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