/// <summary>
/// 得到一个对象实体
/// </summary>
public Eday.Model.hr_info GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,userID,userPwd,roleNames,roleIDs,userName,IDcard,gender,nation,bloodType,birthdate,nativePlace,maritalStatus,Political,mobilephone,phoneCall,workPhone,Email,firstEducation,Topeducation,Worktime,entryTime,status,ContractTime,dept,deptID,address,AccountLocation,FileLocation,addDate,remark,photo,director,costCenterArea,position,postTitle,flag,bak1,bak2,bak3,bak4,bak5 from hr_info ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = ID;
Eday.Model.hr_info model = new Eday.Model.hr_info();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Eday.Model.hr_info model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into hr_info(");
strSql.Append("ID,userID,userPwd,roleNames,roleIDs,userName,IDcard,gender,nation,bloodType,birthdate,nativePlace,maritalStatus,Political,mobilephone,phoneCall,workPhone,Email,firstEducation,Topeducation,Worktime,entryTime,status,ContractTime,dept,deptID,address,AccountLocation,FileLocation,addDate,remark,photo,director,costCenterArea,position,postTitle,flag,bak1,bak2,bak3,bak4,bak5)");
strSql.Append(" values (");
strSql.Append("@ID,@userID,@userPwd,@roleNames,@roleIDs,@userName,@IDcard,@gender,@nation,@bloodType,@birthdate,@nativePlace,@maritalStatus,@Political,@mobilephone,@phoneCall,@workPhone,@Email,@firstEducation,@Topeducation,@Worktime,@entryTime,@status,@ContractTime,@dept,@deptID,@address,@AccountLocation,@FileLocation,@addDate,@remark,@photo,@director,@costCenterArea,@position,@postTitle,@flag,@bak1,@bak2,@bak3,@bak4,@bak5)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 50),
new SqlParameter("@userID", SqlDbType.NVarChar, -1),
new SqlParameter("@userPwd", SqlDbType.NVarChar, -1),
new SqlParameter("@roleNames", SqlDbType.NVarChar, -1),
new SqlParameter("@roleIDs", SqlDbType.NVarChar, -1),
new SqlParameter("@userName", SqlDbType.NVarChar, -1),
new SqlParameter("@IDcard", SqlDbType.NVarChar, -1),
new SqlParameter("@gender", SqlDbType.NVarChar, -1),
new SqlParameter("@nation", SqlDbType.NVarChar, -1),
new SqlParameter("@bloodType", SqlDbType.NVarChar, -1),
new SqlParameter("@birthdate", SqlDbType.NVarChar, -1),
new SqlParameter("@nativePlace", SqlDbType.NVarChar, -1),
new SqlParameter("@maritalStatus", SqlDbType.NVarChar, -1),
new SqlParameter("@Political", SqlDbType.NVarChar, -1),
new SqlParameter("@mobilephone", SqlDbType.NVarChar, -1),
new SqlParameter("@phoneCall", SqlDbType.NVarChar, -1),
new SqlParameter("@workPhone", SqlDbType.NVarChar, -1),
new SqlParameter("@Email", SqlDbType.NVarChar, -1),
new SqlParameter("@firstEducation", SqlDbType.NVarChar, -1),
new SqlParameter("@Topeducation", SqlDbType.NVarChar, -1),
new SqlParameter("@Worktime", SqlDbType.NVarChar, -1),
new SqlParameter("@entryTime", SqlDbType.NVarChar, -1),
new SqlParameter("@status", SqlDbType.NVarChar, -1),
new SqlParameter("@ContractTime", SqlDbType.NVarChar, -1),
new SqlParameter("@dept", SqlDbType.NVarChar, -1),
new SqlParameter("@deptID", SqlDbType.NVarChar, -1),
new SqlParameter("@address", SqlDbType.NVarChar, -1),
new SqlParameter("@AccountLocation", SqlDbType.NVarChar, -1),
new SqlParameter("@FileLocation", SqlDbType.NVarChar, -1),
new SqlParameter("@addDate", SqlDbType.DateTime),
new SqlParameter("@remark", SqlDbType.NVarChar, -1),
new SqlParameter("@photo", SqlDbType.NVarChar, -1),
new SqlParameter("@director", SqlDbType.NVarChar, 50),
new SqlParameter("@costCenterArea", SqlDbType.NVarChar, 50),
new SqlParameter("@position", SqlDbType.NVarChar, 50),
new SqlParameter("@postTitle", SqlDbType.NVarChar, 50),
new SqlParameter("@flag", SqlDbType.VarChar, 50),
new SqlParameter("@bak1", SqlDbType.NVarChar, 50),
new SqlParameter("@bak2", SqlDbType.NVarChar, 50),
new SqlParameter("@bak3", SqlDbType.NVarChar, 50),
new SqlParameter("@bak4", SqlDbType.NVarChar, 50),
new SqlParameter("@bak5", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.userID;
parameters[2].Value = model.userPwd;
parameters[3].Value = model.roleNames;
parameters[4].Value = model.roleIDs;
parameters[5].Value = model.userName;
parameters[6].Value = model.IDcard;
parameters[7].Value = model.gender;
parameters[8].Value = model.nation;
parameters[9].Value = model.bloodType;
parameters[10].Value = model.birthdate;
parameters[11].Value = model.nativePlace;
parameters[12].Value = model.maritalStatus;
parameters[13].Value = model.Political;
parameters[14].Value = model.mobilephone;
parameters[15].Value = model.phoneCall;
parameters[16].Value = model.workPhone;
parameters[17].Value = model.Email;
parameters[18].Value = model.firstEducation;
parameters[19].Value = model.Topeducation;
parameters[20].Value = model.Worktime;
parameters[21].Value = model.entryTime;
parameters[22].Value = model.status;
parameters[23].Value = model.ContractTime;
parameters[24].Value = model.dept;
parameters[25].Value = model.deptID;
parameters[26].Value = model.address;
parameters[27].Value = model.AccountLocation;
parameters[28].Value = model.FileLocation;
parameters[29].Value = model.addDate;
parameters[30].Value = model.remark;
parameters[31].Value = model.photo;
parameters[32].Value = model.director;
parameters[33].Value = model.costCenterArea;
parameters[34].Value = model.position;
parameters[35].Value = model.postTitle;
parameters[36].Value = model.flag;
parameters[37].Value = model.bak1;
parameters[38].Value = model.bak2;
parameters[39].Value = model.bak3;
parameters[40].Value = model.bak4;
parameters[41].Value = model.bak5;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Eday.Model.hr_info DataRowToModel(DataRow row)
{
Eday.Model.hr_info model = new Eday.Model.hr_info();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["userID"] != null)
{
model.userID = row["userID"].ToString();
}
if (row["userPwd"] != null)
{
model.userPwd = row["userPwd"].ToString();
}
if (row["roleNames"] != null)
{
model.roleNames = row["roleNames"].ToString();
}
if (row["roleIDs"] != null)
{
model.roleIDs = row["roleIDs"].ToString();
}
if (row["userName"] != null)
{
model.userName = row["userName"].ToString();
}
if (row["IDcard"] != null)
{
model.IDcard = row["IDcard"].ToString();
}
if (row["gender"] != null)
{
model.gender = row["gender"].ToString();
}
if (row["nation"] != null)
{
model.nation = row["nation"].ToString();
}
if (row["bloodType"] != null)
{
model.bloodType = row["bloodType"].ToString();
}
if (row["birthdate"] != null)
{
model.birthdate = row["birthdate"].ToString();
}
if (row["nativePlace"] != null)
{
model.nativePlace = row["nativePlace"].ToString();
}
if (row["maritalStatus"] != null)
{
model.maritalStatus = row["maritalStatus"].ToString();
}
if (row["Political"] != null)
{
model.Political = row["Political"].ToString();
}
if (row["mobilephone"] != null)
{
model.mobilephone = row["mobilephone"].ToString();
}
if (row["phoneCall"] != null)
{
model.phoneCall = row["phoneCall"].ToString();
}
if (row["workPhone"] != null)
{
model.workPhone = row["workPhone"].ToString();
}
if (row["Email"] != null)
{
model.Email = row["Email"].ToString();
}
if (row["firstEducation"] != null)
{
model.firstEducation = row["firstEducation"].ToString();
}
if (row["Topeducation"] != null)
{
model.Topeducation = row["Topeducation"].ToString();
}
if (row["Worktime"] != null)
{
model.Worktime = row["Worktime"].ToString();
}
if (row["entryTime"] != null)
{
model.entryTime = row["entryTime"].ToString();
}
if (row["status"] != null)
{
model.status = row["status"].ToString();
}
if (row["ContractTime"] != null)
{
model.ContractTime = row["ContractTime"].ToString();
}
if (row["dept"] != null)
{
model.dept = row["dept"].ToString();
}
if (row["deptID"] != null)
{
model.deptID = row["deptID"].ToString();
}
if (row["address"] != null)
{
model.address = row["address"].ToString();
}
if (row["AccountLocation"] != null)
{
model.AccountLocation = row["AccountLocation"].ToString();
}
if (row["FileLocation"] != null)
{
model.FileLocation = row["FileLocation"].ToString();
}
if (row["addDate"] != null && row["addDate"].ToString() != "")
{
model.addDate = DateTime.Parse(row["addDate"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["photo"] != null)
{
model.photo = row["photo"].ToString();
}
if (row["director"] != null)
{
model.director = row["director"].ToString();
}
if (row["costCenterArea"] != null)
{
model.costCenterArea = row["costCenterArea"].ToString();
}
if (row["position"] != null)
{
model.position = row["position"].ToString();
}
if (row["postTitle"] != null)
{
model.postTitle = row["postTitle"].ToString();
}
if (row["flag"] != null)
{
model.flag = row["flag"].ToString();
}
if (row["bak1"] != null)
{
model.bak1 = row["bak1"].ToString();
}
if (row["bak2"] != null)
{
model.bak2 = row["bak2"].ToString();
}
if (row["bak3"] != null)
{
model.bak3 = row["bak3"].ToString();
}
if (row["bak4"] != null)
{
model.bak4 = row["bak4"].ToString();
}
if (row["bak5"] != null)
{
model.bak5 = row["bak5"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Eday.Model.hr_info model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update hr_info set ");
strSql.Append("userID=@userID,");
strSql.Append("userPwd=@userPwd,");
strSql.Append("roleNames=@roleNames,");
strSql.Append("roleIDs=@roleIDs,");
strSql.Append("userName=@userName,");
strSql.Append("IDcard=@IDcard,");
strSql.Append("gender=@gender,");
strSql.Append("nation=@nation,");
strSql.Append("bloodType=@bloodType,");
strSql.Append("birthdate=@birthdate,");
strSql.Append("nativePlace=@nativePlace,");
strSql.Append("maritalStatus=@maritalStatus,");
strSql.Append("Political=@Political,");
strSql.Append("mobilephone=@mobilephone,");
strSql.Append("phoneCall=@phoneCall,");
strSql.Append("workPhone=@workPhone,");
strSql.Append("Email=@Email,");
strSql.Append("firstEducation=@firstEducation,");
strSql.Append("Topeducation=@Topeducation,");
strSql.Append("Worktime=@Worktime,");
strSql.Append("entryTime=@entryTime,");
strSql.Append("status=@status,");
strSql.Append("ContractTime=@ContractTime,");
strSql.Append("dept=@dept,");
strSql.Append("deptID=@deptID,");
strSql.Append("address=@address,");
strSql.Append("AccountLocation=@AccountLocation,");
strSql.Append("FileLocation=@FileLocation,");
strSql.Append("addDate=@addDate,");
strSql.Append("remark=@remark,");
strSql.Append("photo=@photo,");
strSql.Append("director=@director,");
strSql.Append("costCenterArea=@costCenterArea,");
strSql.Append("position=@position,");
strSql.Append("postTitle=@postTitle,");
strSql.Append("flag=@flag,");
strSql.Append("bak1=@bak1,");
strSql.Append("bak2=@bak2,");
strSql.Append("bak3=@bak3,");
strSql.Append("bak4=@bak4,");
strSql.Append("bak5=@bak5");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@userID", SqlDbType.NVarChar, -1),
new SqlParameter("@userPwd", SqlDbType.NVarChar, -1),
new SqlParameter("@roleNames", SqlDbType.NVarChar, -1),
new SqlParameter("@roleIDs", SqlDbType.NVarChar, -1),
new SqlParameter("@userName", SqlDbType.NVarChar, -1),
new SqlParameter("@IDcard", SqlDbType.NVarChar, -1),
new SqlParameter("@gender", SqlDbType.NVarChar, -1),
new SqlParameter("@nation", SqlDbType.NVarChar, -1),
new SqlParameter("@bloodType", SqlDbType.NVarChar, -1),
new SqlParameter("@birthdate", SqlDbType.NVarChar, -1),
new SqlParameter("@nativePlace", SqlDbType.NVarChar, -1),
new SqlParameter("@maritalStatus", SqlDbType.NVarChar, -1),
new SqlParameter("@Political", SqlDbType.NVarChar, -1),
new SqlParameter("@mobilephone", SqlDbType.NVarChar, -1),
new SqlParameter("@phoneCall", SqlDbType.NVarChar, -1),
new SqlParameter("@workPhone", SqlDbType.NVarChar, -1),
new SqlParameter("@Email", SqlDbType.NVarChar, -1),
new SqlParameter("@firstEducation", SqlDbType.NVarChar, -1),
new SqlParameter("@Topeducation", SqlDbType.NVarChar, -1),
new SqlParameter("@Worktime", SqlDbType.NVarChar, -1),
new SqlParameter("@entryTime", SqlDbType.NVarChar, -1),
new SqlParameter("@status", SqlDbType.NVarChar, -1),
new SqlParameter("@ContractTime", SqlDbType.NVarChar, -1),
new SqlParameter("@dept", SqlDbType.NVarChar, -1),
new SqlParameter("@deptID", SqlDbType.NVarChar, -1),
new SqlParameter("@address", SqlDbType.NVarChar, -1),
new SqlParameter("@AccountLocation", SqlDbType.NVarChar, -1),
new SqlParameter("@FileLocation", SqlDbType.NVarChar, -1),
new SqlParameter("@addDate", SqlDbType.DateTime),
new SqlParameter("@remark", SqlDbType.NVarChar, -1),
new SqlParameter("@photo", SqlDbType.NVarChar, -1),
new SqlParameter("@director", SqlDbType.NVarChar, 50),
new SqlParameter("@costCenterArea", SqlDbType.NVarChar, 50),
new SqlParameter("@position", SqlDbType.NVarChar, 50),
new SqlParameter("@postTitle", SqlDbType.NVarChar, 50),
new SqlParameter("@flag", SqlDbType.VarChar, 50),
new SqlParameter("@bak1", SqlDbType.NVarChar, 50),
new SqlParameter("@bak2", SqlDbType.NVarChar, 50),
new SqlParameter("@bak3", SqlDbType.NVarChar, 50),
new SqlParameter("@bak4", SqlDbType.NVarChar, 50),
new SqlParameter("@bak5", SqlDbType.NVarChar, 50),
new SqlParameter("@ID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.userID;
parameters[1].Value = model.userPwd;
parameters[2].Value = model.roleNames;
parameters[3].Value = model.roleIDs;
parameters[4].Value = model.userName;
parameters[5].Value = model.IDcard;
parameters[6].Value = model.gender;
parameters[7].Value = model.nation;
parameters[8].Value = model.bloodType;
parameters[9].Value = model.birthdate;
parameters[10].Value = model.nativePlace;
parameters[11].Value = model.maritalStatus;
parameters[12].Value = model.Political;
parameters[13].Value = model.mobilephone;
parameters[14].Value = model.phoneCall;
parameters[15].Value = model.workPhone;
parameters[16].Value = model.Email;
parameters[17].Value = model.firstEducation;
parameters[18].Value = model.Topeducation;
parameters[19].Value = model.Worktime;
parameters[20].Value = model.entryTime;
parameters[21].Value = model.status;
parameters[22].Value = model.ContractTime;
parameters[23].Value = model.dept;
parameters[24].Value = model.deptID;
parameters[25].Value = model.address;
parameters[26].Value = model.AccountLocation;
parameters[27].Value = model.FileLocation;
parameters[28].Value = model.addDate;
parameters[29].Value = model.remark;
parameters[30].Value = model.photo;
parameters[31].Value = model.director;
parameters[32].Value = model.costCenterArea;
parameters[33].Value = model.position;
parameters[34].Value = model.postTitle;
parameters[35].Value = model.flag;
parameters[36].Value = model.bak1;
parameters[37].Value = model.bak2;
parameters[38].Value = model.bak3;
parameters[39].Value = model.bak4;
parameters[40].Value = model.bak5;
parameters[41].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
