一些公用的方法

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Collections;
using System.Web;
using System.Configuration;
using System.IO;
using System.Reflection;

 

namespace MyCore.control
{
    public class Common
    {
        /// <summary>
        /// 通过将抽取到的值与最后一个值进行对调,让永远抽取不到抽取过的值(因为total每次都会减少1，也就是说每次能取到的随机数一直在减少)
        /// </summary>
        /// <param name="total">数组的长度</param>
        /// <param name="selectnum">取的随机数的个数</param>
        /// <param name="begin">其实取数</param>
        /// <returns></returns>
        public int[] GetRandom(int total,int selectnum,int begin)
        {

            int[] sequence = new int[total];
            int[] output = new int[selectnum];

            for (int i = 0; i < total; i++)
            {
                sequence[i] = i+begin;
            }
            Random random = new Random();
            int end = total - 1;
            for (int i = 0; i < selectnum; i++)
            {
                int num = random.Next(0, end + 1);
                output[i] = sequence[num];
                sequence[num] = sequence[end];
                end--;
            }
            return output;
        }

        public int IsExistZiduanInTable(string ziduan, string param, string table,string id)
        {
            int result = 0;
            string sql = "select count(*) from " + table + " where IsDeleted = 0 and id <> '"+id+"' and " + ziduan + "= @param";
            IDbDataParameter[] parameter = new IDbDataParameter[] { new SqlParameter("@param",param)};
            result = MyCore.common.DBHelper.ExecuteScalar(sql, CommandType.Text, parameter);
            return result;
        }
        /// <summary>
        /// 判断文件夹是否存在，如果不存在则创建文件夹
        /// </summary>
        /// <param name="SavePath"></param>
        private void ToCreateFile(string SavePath)
        {
            if (!Directory.Exists(SavePath))
            {
                Directory.CreateDirectory(SavePath);
            }
        }
        /// <summary>
        /// 判断文件是否不在指定的类型中
        /// </summary>
        /// <param name="fileName"></param>
        /// <returns></returns>
        private bool IsOutOfFileType(string fileName)
        {
            bool flag = false;
            string fileType = ConfigurationManager.AppSettings["FileType"];
            string[] typeList = fileType.Split(';');
            foreach (string oneType in typeList)
            {
                if (oneType == System.IO.Path.GetExtension(fileName))
                    flag = true;
            }
            return flag;
        }

        //上传公告附件
        public string[] fileLoad()
        {
            string []result = new string[3];
            string message = "";
            HttpFileCollection files = HttpContext.Current.Request.Files;
            /// '状态信息
            System.Text.StringBuilder strMsg = new System.Text.StringBuilder();
            for (int iFile = 0; iFile < files.Count; iFile++)
            {
                string maxSize = ConfigurationManager.AppSettings["FileMaxSize"];
                ///'检查文件扩展名字
                bool fileOK = false;
                HttpPostedFile postedFile = files[iFile];
                int fileSize = postedFile.ContentLength;
                string fileType = postedFile.ContentType;
                string fileName, fileExtension;
                fileName = System.IO.Path.GetFileName(postedFile.FileName);
                fileExtension = System.IO.Path.GetExtension(fileName);
                if (postedFile.ContentLength > (Convert.ToDouble(maxSize) * 1024))
                {
                    message += fileName + " 文件大小大于指定大小，上传失败！";
                }
                else
                {
                    if (fileName != "")
                    {
                        fileOK = IsOutOfFileType(fileName);
                    }
                    if (fileOK)
                    {
                        string saveFileName = System.Guid.NewGuid() + fileExtension;
                        string fileSaveDir = System.Web.HttpContext.Current.Request.MapPath("~/Files/") + saveFileName;
                        result[1] = fileSaveDir;
                        result[2] = saveFileName;
                        postedFile.SaveAs(fileSaveDir);
                    }
                    else
                    {
                        message += fileName + " 文件类型错误，上传失败！";
                    }
                }
            }
            result[0]=message;
            return result;
        }

        /// <summary>
        /// 集合装换DataSet
        /// </summary>
        /// <param name="list">集合</param>
        /// <returns></returns>
        /// 2008-08-01 22:08 HPDV2806
        public DataSet ToDataSet(IList p_List)
        {
            DataSet result = new DataSet();
            DataTable _DataTable = new DataTable();
            if (p_List.Count > 0)
            {
                PropertyInfo[] propertys = p_List[0].GetType().GetProperties();
                foreach (PropertyInfo pi in propertys)
                {
                    _DataTable.Columns.Add(pi.Name, pi.PropertyType);
                }

                for (int i = 0; i < p_List.Count; i++)
                {
                    ArrayList tempList = new ArrayList();
                    foreach (PropertyInfo pi in propertys)
                    {
                        object obj = pi.GetValue(p_List[i], null);
                        tempList.Add(obj);
                    }
                    object[] array = tempList.ToArray();
                    _DataTable.LoadDataRow(array, true);
                }
            }
            result.Tables.Add(_DataTable);
            return result;
        }

        public DataSet ExecleDs(string filenameurl, string table)
        {
            DataSet ds = new DataSet();
            string strConn = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + filenameurl + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1;'";
            if (filenameurl.Contains(".xlsx"))//判断文件是否存在 2007版本
            {
                strConn = "Provider = Microsoft.ACE.OLEDB.12.0; Data Source =" + filenameurl + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'";
            }
            OleDbConnection conn = new OleDbConnection(strConn);
            conn.Open();
            string tableName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null).Rows[0][2].ToString().Trim();
            OleDbDataAdapter odda = new OleDbDataAdapter("select * from [" + tableName + "]", conn);
            odda.Fill(ds, table);
            return ds;

        }

        public int InsertQuestionDataSet(DataSet ds)
        {
            int result = 0;
            int rowsnum = ds.Tables[0].Rows.Count;
            int columnum = ds.Tables[0].Columns.Count;
            string sql = "";
            if (rowsnum > 0)
            {
                sql += "update QuestionInfo set IsDeleted = 1;";
            }
            for (int i = 0; i < rowsnum; i++)
            {
                string question = FilteSQLStr(ds.Tables[0].Rows[i]["题目"].ToString().Trim().Replace("'", "''"));
                string a = FilteSQLStr(ds.Tables[0].Rows[i]["A"].ToString().Trim().Replace("'", "''"));
                string b = FilteSQLStr(ds.Tables[0].Rows[i]["B"].ToString().Trim().Replace("'", "''"));
                string c = FilteSQLStr(ds.Tables[0].Rows[i]["C"].ToString().Trim().Replace("'", "''"));
                string d = FilteSQLStr(ds.Tables[0].Rows[i]["D"].ToString().Trim().Replace("'", "''"));
                string answer = FilteSQLStr(ds.Tables[0].Rows[i]["答案"].ToString().Trim().Replace("'", "''"));
                string questionType = ds.Tables[0].Rows[i]["题型"].ToString().Trim().Replace("'", "''");
                string courseID = ds.Tables[0].Rows[i]["课程ID"].ToString().Trim().Replace("'", "''");
                string sqlStr = "insert into QuestionInfo(Question,A,B,C,D,Answer,QuestionType,CourseID,IsDeleted) values('" + question +
                                "','" + a + "','" + b + "','" + c + "','" + d + "','" + answer + "','" + questionType + "','" + courseID + "',0);";
                sql += sqlStr;
            }
            IDbDataParameter[] parameter = new IDbDataParameter[] { };
            result = MyCore.common.DBHelper.ExecuteNonQuery(sql, CommandType.Text, parameter);
            return result;
        }

        public int InsertStudentDataSet(DataSet ds)
        {
            int result = 0;
            int rowsnum = ds.Tables[0].Rows.Count;
            int columnum = ds.Tables[0].Columns.Count;
            string sql = "";
            if (rowsnum > 0)
            {
                sql += "update StuInfo set IsDeleted = 1;";
            }
            for (int i = 0; i < rowsnum; i++)
            {
                string StuClass = ds.Tables[0].Rows[i]["班级"].ToString().Trim();
                string StuNo = ds.Tables[0].Rows[i]["学号"].ToString().Trim();
                string StuName = ds.Tables[0].Rows[i]["姓名"].ToString().Trim();
                string Sex = ds.Tables[0].Rows[i]["性别"].ToString().Trim();
                string pwd = ConfigurationManager.AppSettings["setPwd"];
                string sqlStr = "insert into StuInfo(StuClass,StuNo,StuName,Sex,StuPass,IsDeleted) values('" + StuClass + "','" + StuNo +
                                "','" + StuName + "','" + Sex + "','" + pwd + "',0);";
                sql += sqlStr;
            }
            IDbDataParameter[] parameter = new IDbDataParameter[] { };
            result = MyCore.common.DBHelper.ExecuteNonQuery(sql, CommandType.Text, parameter);
            return result;
        }

        /// <summary>
        /// 过滤不安全的字符串
        /// </summary>
        /// <param name="Str"></param>
        /// <returns></returns>
        public static string FilteSQLStr(string Str)
        {

            Str = Str.Replace("&", "&amp");
            Str = Str.Replace("<", "&lt");
            Str = Str.Replace(">", "&gt");
            return Str;
        }
        /// <summary>
        /// 还原过滤字段
        /// </summary>
        /// <param name="Str"></param>
        /// <returns></returns>
        public static string BackFilteSQLStr(string Str)
        {

            Str = Str.Replace("&amp", "&");
            Str = Str.Replace("&lt", "<");
            Str = Str.Replace("&gt", ">");
            return Str;
        }
    }
}