/// <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); }