示例#1
0
        /// <summary>
        /// 处理教师信息表,把密码进行MD5加密而已
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static DataTable SplitTeacher4DT(DataTable dt)
        {
            string    strSQL = "select * from TabTeachers where user_id='1'";
            DataTable NewDT  = ConnHelper.GetDataTable(strSQL);
            DataRow   dr     = NewDT.NewRow();

            //进行拆分处理
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                for (int y = 0; y < 6; y++)
                {
                    if (y == 2)
                    {
                        dr[y] = md5(dt.Rows[i][y].ToString());
                    }
                    else
                    {
                        dr[y] = dt.Rows[i][y];
                    }
                }
                NewDT.Rows.Add(dr);
                dr = NewDT.NewRow();
            }

            return(NewDT);
        }
        public static bool IsHas(string UserID, string identity)//判断原表有没有该老师,有的话就是True,没有是False
        {
            DataTable dt = ConnHelper.GetDataTable("select UserID from " + identity + "");

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (UserID == dt.Rows[i]["UserID"].ToString())
                {
                    return(true);
                }
            }
            return(false);
        }