public employee(string email, string pwd)
{
//test();
//string[] para = new string[] { email, pwd };
sxEmployeeDataTable();
//DataTable dt = Select("select userid,username,englishname,usertypeid,userpowerid,birthday,cardtype,idcardno,sex,employeeno,joindate,"
// + "onjob,email,outdate from T_employeeInfo where email = @para1 and pwd = @para2 and onjob = 1", para);
DataRow[] drc = EmployeeDataTable.Select(string.Format("email = '{0}' and pwd = '{1}' and onjob = 1", email, pwd));
if (drc.Length == 1)
{
DataRow dr = drc[0];
Userid = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("userid")]);
Username = dr.ItemArray[EmployeeDataTable.Columns.IndexOf("username")].ToString();
Englishname = dr.ItemArray[EmployeeDataTable.Columns.IndexOf("englishname")].ToString();
Usertypeid = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("usertypeid")]);
Userpowerid = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("userpowerid")]);
Birthday = Convert.ToDateTime(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("birthday")]);
Cardtype = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("Cardtype")]);
Idcardno = dr.ItemArray[EmployeeDataTable.Columns.IndexOf("idcardno")].ToString();
Sex = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("sex")]);
//Employeeno = Convert.ToInt16(dr.ItemArray[dt.Columns.IndexOf("employeeno")]);
Joindate = Convert.ToDateTime(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("joindate")]);
Outdate = Convert.ToDateTime(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("outdate")]);
Onjob = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("onjob")]) == 1 ?true:false;
Email = email;
Pwd = pwd;
}
else
{
Userid = -1;
}
}
public bool Save()
{
bool f = false;
if (Userid == -1 && Username.Equals(""))
{
return(f);
}
else if (Userid == -1)
{
if (Email != "" && EmployeeDataTable.Select(string.Format("email = '{0}' and onjob = 1", Email)).Length > 0)
{
xuxSeecion.ERRMESSAGE = "Email 重复";
}
else if (EmployeeDataTable.Select(string.Format("idcardno = '{0}' and onjob = 1", Idcardno)).Length > 0)
{
xuxSeecion.ERRMESSAGE = "证件号码重复";
}
else
{
f = insertUser();
}
}
else
{
f = updateUser();
}
return(f);
}
public bool GetByUserId(string userId)
{
bool b = false;
//string[] para = new string[] { userId };
//DataTable dt = Select("select userid,username,englishname,usertypeid,userpowerid,birthday,cardtype,idcardno,sex,employeeno,joindate,"
// + "onjob,email,outdate from T_employeeInfo where userid = @para1", para);
DataRow[] drs = EmployeeDataTable.Select(string.Format("userid = {0}", userId));
if (drs.Length == 1)
{
b = true;
DataRow dr = drs[0];
Userid = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("userid")]);
Username = dr.ItemArray[EmployeeDataTable.Columns.IndexOf("username")].ToString();
Englishname = dr.ItemArray[EmployeeDataTable.Columns.IndexOf("englishname")].ToString();
Usertypeid = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("usertypeid")]);
Userpowerid = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("userpowerid")]);
Birthday = Convert.ToDateTime(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("birthday")]);
Cardtype = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("Cardtype")]);
Idcardno = dr.ItemArray[EmployeeDataTable.Columns.IndexOf("idcardno")].ToString();
Sex = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("sex")]);
//Employeeno = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("employeeno")]);
Joindate = Convert.ToDateTime(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("joindate")]);
Outdate = Convert.ToDateTime(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("outdate")]);
Onjob = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("onjob")]) == 1 ? true : false;
Email = dr.ItemArray[EmployeeDataTable.Columns.IndexOf("email")].ToString();
}
return(b);
}
