/// <summary> /// 在EmployeeTable表中获取content页面所需的数据[cat66] /// </summary> /// <param name="empid"></param> /// <returns></returns> public static List <EmployeeTable> geteInfo(int empid) { string sql = "select * from EmployeeTable where e_Id = @empid"; //SqlParameter[] p = new SqlParameter[] { }; DataTable dt = SqlHelper.ExecuteDataTable(sql, new SqlParameter("empid", empid)); List <EmployeeTable> l = new List <EmployeeTable>(); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { try { EmployeeTable e = new EmployeeTable(); //bg.bg_Id = Convert.ToInt32(row["bg_Id"]); //bg.bg_Name = row["bg_Name"].ToString(); //bg.bg_Pwd = row["bg_Pwd"].ToString(); //l.Add(bg); e.e_Address = row["e_Address"].ToString(); l.Add(e); } catch { } } } return(l); }
/// <summary> /// 将兼职表的数据行转换成model /// </summary> /// <param name="dr"></param> /// <param name="model">空</param> public static void SetDr2Model(DataRow dr, PTJob model) { if (dr["pt_Id"].ToString() != "") { model.pt_Id = int.Parse(dr["pt_Id"].ToString()); } model.pt_Kind = dr["pt_Kind"].ToString(); model.pt_Time = dr["pt_Time"].ToString(); model.pt_ReleaseTime = dr["pt_ReleaseTime"].ToString(); if (dr["pt_eId"].ToString() != "") { model.pt_eId = int.Parse(dr["pt_eId"].ToString()); model.Pt_employee = new Employee(); EmployeeTable.SetDr2Model(dr, model.Pt_employee); } if (dr["pt_Money"].ToString() != "") { model.pt_Money = int.Parse(dr["pt_Money"].ToString()); } model.pt_Address = dr["pt_Address"].ToString(); model.pt_Tel = dr["pt_Tel"].ToString(); model.pt_State = dr["pt_State"].ToString(); model.pt_Name = dr["pt_Name"].ToString(); model.pt_Kind = dr["pt_Kind"].ToString(); if (dr["pt_StuId"].ToString() != "") { model.pt_StuId = int.Parse(dr["pt_StuId"].ToString()); model.Pt_student = new Student(); StudentTable.SetDr2Model(dr, model.Pt_student); } if (dr["pt_Need"].ToString() != "") { model.pt_Need = int.Parse(dr["pt_Need"].ToString()); } }
public static bool Exist(string id) { try { using (taxisEntities db = new taxisEntities()) { EmployeeTable es = db.EmployeeTables.Where(e => e.EmployeeCode == id).FirstOrDefault(); return(es != null); } } catch (Exception e) { return(false); } }
public static bool AddNew(EmployeeTable emp) { try { using (taxisEntities db = new taxisEntities()) { db.EmployeeTables.Add(emp); db.SaveChanges(); return(true); } } catch (Exception e) { return(false); } }
public static EmployeeTable Login(string id, string ps) { try { using (taxisEntities db = new taxisEntities()) { EmployeeTable es = db.EmployeeTables.Where(e => e.EmployeeCode == id && e.EmployeePassword == ps).FirstOrDefault(); if (es != null) { return(es); } return(null); } } catch (Exception e) { return(null); } }
public static List <EmployeeTable> getAll(int page, string search) { string sql = "select * from EmployeeTable where e_Id = '" + search + "' or e_Name like '%" + search + "%' or e_RealName like '%" + search + "%' or e_Address like '%" + search + "%' or e_Phone like '%" + search + "%' order by e_Id offset @page rows fetch next 5 rows only"; SqlParameter[] p = new SqlParameter[] { new SqlParameter("@page", (page - 1) * 5) }; DataTable dt = SqlHelper.ExecuteDataTable(sql, p); List <EmployeeTable> l = new List <EmployeeTable>(); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { EmployeeTable com = new EmployeeTable(); com.e_Id = Convert.ToInt32(row["e_Id"]); com.e_Name = row["e_Name"].ToString(); com.e_RealName = row["e_RealName"].ToString(); com.e_Address = row["e_Address"].ToString(); com.e_Phone = row["e_Phone"].ToString(); l.Add(com); } } return(l); }