/// <summary>
/// 增加一条数据
/// </summary>
public void Add(MobileSoft.Model.Sys.Tb_Sys_User model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@UserCode", SqlDbType.NVarChar, 20),
new SqlParameter("@CommID", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.NVarChar, 50),
new SqlParameter("@DepCode", SqlDbType.NVarChar, 20),
new SqlParameter("@LoginCode", SqlDbType.NVarChar, 20),
new SqlParameter("@PassWord", SqlDbType.NVarChar, 50),
new SqlParameter("@Sex", SqlDbType.NVarChar, 10),
new SqlParameter("@MobileTel", SqlDbType.NVarChar, 50),
new SqlParameter("@WorkedTel", SqlDbType.NVarChar, 50),
new SqlParameter("@PersonalTel", SqlDbType.NVarChar, 50),
new SqlParameter("@IDCardCode", SqlDbType.NVarChar, 25),
new SqlParameter("@LinkmanName", SqlDbType.NVarChar, 20),
new SqlParameter("@LinkmanTel", SqlDbType.NVarChar, 50),
new SqlParameter("@Email", SqlDbType.NVarChar, 50),
new SqlParameter("@IsPublicMail", SqlDbType.SmallInt, 2),
new SqlParameter("@EmployeeCode", SqlDbType.NVarChar, 20),
new SqlParameter("@WorkerSign", SqlDbType.NVarChar, 20),
new SqlParameter("@Duty", SqlDbType.NVarChar, 20),
new SqlParameter("@BankAccounts", SqlDbType.NVarChar, 20),
new SqlParameter("@Qualification", SqlDbType.NVarChar, 20),
new SqlParameter("@NativePlace", SqlDbType.NVarChar, 30),
new SqlParameter("@Speciality", SqlDbType.NVarChar, 30),
new SqlParameter("@MaritalStatus", SqlDbType.NVarChar, 20),
new SqlParameter("@Stature", SqlDbType.NVarChar, 20),
new SqlParameter("@Birthday", SqlDbType.DateTime),
new SqlParameter("@Avoirdupois", SqlDbType.NVarChar, 20),
new SqlParameter("@Nation", SqlDbType.NVarChar, 20),
new SqlParameter("@Politics", SqlDbType.NVarChar, 20),
new SqlParameter("@TechnicTitle", SqlDbType.NVarChar, 80),
new SqlParameter("@Skills", SqlDbType.NVarChar, 80),
new SqlParameter("@GuardCard", SqlDbType.NVarChar, 20),
new SqlParameter("@Computer", SqlDbType.NVarChar, 20),
new SqlParameter("@WorkingTime", SqlDbType.DateTime),
new SqlParameter("@JoinTime", SqlDbType.DateTime),
new SqlParameter("@Residence", SqlDbType.NVarChar, 80),
new SqlParameter("@Address", SqlDbType.NVarChar, 80),
new SqlParameter("@Post", SqlDbType.NVarChar, 6),
new SqlParameter("@ArchivesAddr", SqlDbType.NVarChar, 20),
new SqlParameter("@PreInsuranceCode", SqlDbType.NVarChar, 20),
new SqlParameter("@InsuranceCode", SqlDbType.NVarChar, 20),
new SqlParameter("@ResidenceType", SqlDbType.NVarChar, 20),
new SqlParameter("@IsBuyInsurance", SqlDbType.SmallInt, 2),
new SqlParameter("@IsAgreeBuy", SqlDbType.SmallInt, 2),
new SqlParameter("@PayLevel", SqlDbType.NVarChar, 20),
new SqlParameter("@WorkingDate", SqlDbType.DateTime),
new SqlParameter("@JionDate", SqlDbType.DateTime),
new SqlParameter("@ProbationDate", SqlDbType.DateTime),
new SqlParameter("@FormalDate", SqlDbType.DateTime),
new SqlParameter("@DimissionDate", SqlDbType.DateTime),
new SqlParameter("@InureDate", SqlDbType.DateTime),
new SqlParameter("@PraxisDate", SqlDbType.DateTime),
new SqlParameter("@JoinPartyDate", SqlDbType.DateTime),
new SqlParameter("@HealthState", SqlDbType.NVarChar, 200),
new SqlParameter("@OldName", SqlDbType.NVarChar, 50),
new SqlParameter("@EyeLeft", SqlDbType.NVarChar, 50),
new SqlParameter("@EyeRight", SqlDbType.NVarChar, 50),
new SqlParameter("@FamilyBirth", SqlDbType.NVarChar, 50),
new SqlParameter("@BloodGroup", SqlDbType.NVarChar, 50),
new SqlParameter("@School", SqlDbType.NVarChar, 50),
new SqlParameter("@Approach", SqlDbType.NVarChar, 50),
new SqlParameter("@OldUnit", SqlDbType.NVarChar, 50),
new SqlParameter("@ForRegional", SqlDbType.NVarChar, 20),
new SqlParameter("@ArchiveState", SqlDbType.SmallInt, 2),
new SqlParameter("@Memo", SqlDbType.NVarChar, 1000),
new SqlParameter("@IsShow", SqlDbType.SmallInt, 2),
new SqlParameter("@IsDelete", SqlDbType.SmallInt, 2),
new SqlParameter("@DeleteDate", SqlDbType.DateTime),
new SqlParameter("@WorkAchievement", SqlDbType.NText),
new SqlParameter("@FamilyContext", SqlDbType.NText),
new SqlParameter("@InterestLove", SqlDbType.NText),
new SqlParameter("@StudySuffer", SqlDbType.NText),
new SqlParameter("@JobSuffer", SqlDbType.NText),
new SqlParameter("@ChangeLog", SqlDbType.NText),
new SqlParameter("@IsLogin", SqlDbType.Int, 4),
new SqlParameter("@IsDimission", SqlDbType.Int, 4),
new SqlParameter("@IsHostelSearch", SqlDbType.SmallInt, 2),
new SqlParameter("@OrganizeCode", SqlDbType.NVarChar, 100),
new SqlParameter("@SearchCommID", SqlDbType.Int, 4),
new SqlParameter("@IsMobile", SqlDbType.SmallInt, 2),
new SqlParameter("@MachineCodes", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.UserCode;
parameters[1].Value = model.CommID;
parameters[2].Value = model.UserName;
parameters[3].Value = model.DepCode;
parameters[4].Value = model.LoginCode;
parameters[5].Value = model.PassWord;
parameters[6].Value = model.Sex;
parameters[7].Value = model.MobileTel;
parameters[8].Value = model.WorkedTel;
parameters[9].Value = model.PersonalTel;
parameters[10].Value = model.IDCardCode;
parameters[11].Value = model.LinkmanName;
parameters[12].Value = model.LinkmanTel;
parameters[13].Value = model.Email;
parameters[14].Value = model.IsPublicMail;
parameters[15].Value = model.EmployeeCode;
parameters[16].Value = model.WorkerSign;
parameters[17].Value = model.Duty;
parameters[18].Value = model.BankAccounts;
parameters[19].Value = model.Qualification;
parameters[20].Value = model.NativePlace;
parameters[21].Value = model.Speciality;
parameters[22].Value = model.MaritalStatus;
parameters[23].Value = model.Stature;
parameters[24].Value = model.Birthday;
parameters[25].Value = model.Avoirdupois;
parameters[26].Value = model.Nation;
parameters[27].Value = model.Politics;
parameters[28].Value = model.TechnicTitle;
parameters[29].Value = model.Skills;
parameters[30].Value = model.GuardCard;
parameters[31].Value = model.Computer;
parameters[32].Value = model.WorkingTime;
parameters[33].Value = model.JoinTime;
parameters[34].Value = model.Residence;
parameters[35].Value = model.Address;
parameters[36].Value = model.Post;
parameters[37].Value = model.ArchivesAddr;
parameters[38].Value = model.PreInsuranceCode;
parameters[39].Value = model.InsuranceCode;
parameters[40].Value = model.ResidenceType;
parameters[41].Value = model.IsBuyInsurance;
parameters[42].Value = model.IsAgreeBuy;
parameters[43].Value = model.PayLevel;
parameters[44].Value = model.WorkingDate;
parameters[45].Value = model.JionDate;
parameters[46].Value = model.ProbationDate;
parameters[47].Value = model.FormalDate;
parameters[48].Value = model.DimissionDate;
parameters[49].Value = model.InureDate;
parameters[50].Value = model.PraxisDate;
parameters[51].Value = model.JoinPartyDate;
parameters[52].Value = model.HealthState;
parameters[53].Value = model.OldName;
parameters[54].Value = model.EyeLeft;
parameters[55].Value = model.EyeRight;
parameters[56].Value = model.FamilyBirth;
parameters[57].Value = model.BloodGroup;
parameters[58].Value = model.School;
parameters[59].Value = model.Approach;
parameters[60].Value = model.OldUnit;
parameters[61].Value = model.ForRegional;
parameters[62].Value = model.ArchiveState;
parameters[63].Value = model.Memo;
parameters[64].Value = model.IsShow;
parameters[65].Value = model.IsDelete;
parameters[66].Value = model.DeleteDate;
parameters[67].Value = model.WorkAchievement;
parameters[68].Value = model.FamilyContext;
parameters[69].Value = model.InterestLove;
parameters[70].Value = model.StudySuffer;
parameters[71].Value = model.JobSuffer;
parameters[72].Value = model.ChangeLog;
parameters[73].Value = model.IsLogin;
parameters[74].Value = model.IsDimission;
parameters[75].Value = model.IsHostelSearch;
parameters[76].Value = model.OrganizeCode;
parameters[77].Value = model.SearchCommID;
parameters[78].Value = model.IsMobile;
parameters[79].Value = model.MachineCodes;
DbHelperSQL.RunProcedure("Proc_Tb_Sys_User_ADD", parameters, out rowsAffected);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MobileSoft.Model.Sys.Tb_Sys_User GetModel(string UserCode)
{
SqlParameter[] parameters =
{
new SqlParameter("@UserCode", SqlDbType.NVarChar, 50)
};
parameters[0].Value = UserCode;
MobileSoft.Model.Sys.Tb_Sys_User model = new MobileSoft.Model.Sys.Tb_Sys_User();
DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_Sys_User_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
model.UserCode = ds.Tables[0].Rows[0]["UserCode"].ToString();
if (ds.Tables[0].Rows[0]["CommID"].ToString() != "")
{
model.CommID = int.Parse(ds.Tables[0].Rows[0]["CommID"].ToString());
}
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
model.DepCode = ds.Tables[0].Rows[0]["DepCode"].ToString();
model.LoginCode = ds.Tables[0].Rows[0]["LoginCode"].ToString();
model.PassWord = ds.Tables[0].Rows[0]["PassWord"].ToString();
model.Sex = ds.Tables[0].Rows[0]["Sex"].ToString();
model.MobileTel = ds.Tables[0].Rows[0]["MobileTel"].ToString();
model.WorkedTel = ds.Tables[0].Rows[0]["WorkedTel"].ToString();
model.PersonalTel = ds.Tables[0].Rows[0]["PersonalTel"].ToString();
model.IDCardCode = ds.Tables[0].Rows[0]["IDCardCode"].ToString();
model.LinkmanName = ds.Tables[0].Rows[0]["LinkmanName"].ToString();
model.LinkmanTel = ds.Tables[0].Rows[0]["LinkmanTel"].ToString();
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
if (ds.Tables[0].Rows[0]["IsPublicMail"].ToString() != "")
{
model.IsPublicMail = int.Parse(ds.Tables[0].Rows[0]["IsPublicMail"].ToString());
}
model.EmployeeCode = ds.Tables[0].Rows[0]["EmployeeCode"].ToString();
model.WorkerSign = ds.Tables[0].Rows[0]["WorkerSign"].ToString();
model.Duty = ds.Tables[0].Rows[0]["Duty"].ToString();
model.BankAccounts = ds.Tables[0].Rows[0]["BankAccounts"].ToString();
model.Qualification = ds.Tables[0].Rows[0]["Qualification"].ToString();
model.NativePlace = ds.Tables[0].Rows[0]["NativePlace"].ToString();
model.Speciality = ds.Tables[0].Rows[0]["Speciality"].ToString();
model.MaritalStatus = ds.Tables[0].Rows[0]["MaritalStatus"].ToString();
model.Stature = ds.Tables[0].Rows[0]["Stature"].ToString();
if (ds.Tables[0].Rows[0]["Birthday"].ToString() != "")
{
model.Birthday = DateTime.Parse(ds.Tables[0].Rows[0]["Birthday"].ToString());
}
model.Avoirdupois = ds.Tables[0].Rows[0]["Avoirdupois"].ToString();
model.Nation = ds.Tables[0].Rows[0]["Nation"].ToString();
model.Politics = ds.Tables[0].Rows[0]["Politics"].ToString();
model.TechnicTitle = ds.Tables[0].Rows[0]["TechnicTitle"].ToString();
model.Skills = ds.Tables[0].Rows[0]["Skills"].ToString();
model.GuardCard = ds.Tables[0].Rows[0]["GuardCard"].ToString();
model.Computer = ds.Tables[0].Rows[0]["Computer"].ToString();
if (ds.Tables[0].Rows[0]["WorkingTime"].ToString() != "")
{
model.WorkingTime = DateTime.Parse(ds.Tables[0].Rows[0]["WorkingTime"].ToString());
}
if (ds.Tables[0].Rows[0]["JoinTime"].ToString() != "")
{
model.JoinTime = DateTime.Parse(ds.Tables[0].Rows[0]["JoinTime"].ToString());
}
model.Residence = ds.Tables[0].Rows[0]["Residence"].ToString();
model.Address = ds.Tables[0].Rows[0]["Address"].ToString();
model.Post = ds.Tables[0].Rows[0]["Post"].ToString();
model.ArchivesAddr = ds.Tables[0].Rows[0]["ArchivesAddr"].ToString();
model.PreInsuranceCode = ds.Tables[0].Rows[0]["PreInsuranceCode"].ToString();
model.InsuranceCode = ds.Tables[0].Rows[0]["InsuranceCode"].ToString();
model.ResidenceType = ds.Tables[0].Rows[0]["ResidenceType"].ToString();
if (ds.Tables[0].Rows[0]["IsBuyInsurance"].ToString() != "")
{
model.IsBuyInsurance = int.Parse(ds.Tables[0].Rows[0]["IsBuyInsurance"].ToString());
}
if (ds.Tables[0].Rows[0]["IsAgreeBuy"].ToString() != "")
{
model.IsAgreeBuy = int.Parse(ds.Tables[0].Rows[0]["IsAgreeBuy"].ToString());
}
model.PayLevel = ds.Tables[0].Rows[0]["PayLevel"].ToString();
if (ds.Tables[0].Rows[0]["WorkingDate"].ToString() != "")
{
model.WorkingDate = DateTime.Parse(ds.Tables[0].Rows[0]["WorkingDate"].ToString());
}
if (ds.Tables[0].Rows[0]["JionDate"].ToString() != "")
{
model.JionDate = DateTime.Parse(ds.Tables[0].Rows[0]["JionDate"].ToString());
}
if (ds.Tables[0].Rows[0]["ProbationDate"].ToString() != "")
{
model.ProbationDate = DateTime.Parse(ds.Tables[0].Rows[0]["ProbationDate"].ToString());
}
if (ds.Tables[0].Rows[0]["FormalDate"].ToString() != "")
{
model.FormalDate = DateTime.Parse(ds.Tables[0].Rows[0]["FormalDate"].ToString());
}
if (ds.Tables[0].Rows[0]["DimissionDate"].ToString() != "")
{
model.DimissionDate = DateTime.Parse(ds.Tables[0].Rows[0]["DimissionDate"].ToString());
}
if (ds.Tables[0].Rows[0]["InureDate"].ToString() != "")
{
model.InureDate = DateTime.Parse(ds.Tables[0].Rows[0]["InureDate"].ToString());
}
if (ds.Tables[0].Rows[0]["PraxisDate"].ToString() != "")
{
model.PraxisDate = DateTime.Parse(ds.Tables[0].Rows[0]["PraxisDate"].ToString());
}
if (ds.Tables[0].Rows[0]["JoinPartyDate"].ToString() != "")
{
model.JoinPartyDate = DateTime.Parse(ds.Tables[0].Rows[0]["JoinPartyDate"].ToString());
}
model.HealthState = ds.Tables[0].Rows[0]["HealthState"].ToString();
model.OldName = ds.Tables[0].Rows[0]["OldName"].ToString();
model.EyeLeft = ds.Tables[0].Rows[0]["EyeLeft"].ToString();
model.EyeRight = ds.Tables[0].Rows[0]["EyeRight"].ToString();
model.FamilyBirth = ds.Tables[0].Rows[0]["FamilyBirth"].ToString();
model.BloodGroup = ds.Tables[0].Rows[0]["BloodGroup"].ToString();
model.School = ds.Tables[0].Rows[0]["School"].ToString();
model.Approach = ds.Tables[0].Rows[0]["Approach"].ToString();
model.OldUnit = ds.Tables[0].Rows[0]["OldUnit"].ToString();
model.ForRegional = ds.Tables[0].Rows[0]["ForRegional"].ToString();
if (ds.Tables[0].Rows[0]["ArchiveState"].ToString() != "")
{
model.ArchiveState = int.Parse(ds.Tables[0].Rows[0]["ArchiveState"].ToString());
}
model.Memo = ds.Tables[0].Rows[0]["Memo"].ToString();
if (ds.Tables[0].Rows[0]["IsShow"].ToString() != "")
{
model.IsShow = int.Parse(ds.Tables[0].Rows[0]["IsShow"].ToString());
}
if (ds.Tables[0].Rows[0]["IsDelete"].ToString() != "")
{
model.IsDelete = int.Parse(ds.Tables[0].Rows[0]["IsDelete"].ToString());
}
if (ds.Tables[0].Rows[0]["DeleteDate"].ToString() != "")
{
model.DeleteDate = DateTime.Parse(ds.Tables[0].Rows[0]["DeleteDate"].ToString());
}
model.WorkAchievement = ds.Tables[0].Rows[0]["WorkAchievement"].ToString();
model.FamilyContext = ds.Tables[0].Rows[0]["FamilyContext"].ToString();
model.InterestLove = ds.Tables[0].Rows[0]["InterestLove"].ToString();
model.StudySuffer = ds.Tables[0].Rows[0]["StudySuffer"].ToString();
model.JobSuffer = ds.Tables[0].Rows[0]["JobSuffer"].ToString();
model.ChangeLog = ds.Tables[0].Rows[0]["ChangeLog"].ToString();
if (ds.Tables[0].Rows[0]["IsLogin"].ToString() != "")
{
model.IsLogin = int.Parse(ds.Tables[0].Rows[0]["IsLogin"].ToString());
}
if (ds.Tables[0].Rows[0]["IsDimission"].ToString() != "")
{
model.IsDimission = int.Parse(ds.Tables[0].Rows[0]["IsDimission"].ToString());
}
if (ds.Tables[0].Rows[0]["IsHostelSearch"].ToString() != "")
{
model.IsHostelSearch = int.Parse(ds.Tables[0].Rows[0]["IsHostelSearch"].ToString());
}
model.OrganizeCode = ds.Tables[0].Rows[0]["OrganizeCode"].ToString();
if (ds.Tables[0].Rows[0]["SearchCommID"].ToString() != "")
{
model.SearchCommID = int.Parse(ds.Tables[0].Rows[0]["SearchCommID"].ToString());
}
if (ds.Tables[0].Rows[0]["IsMobile"].ToString() != "")
{
model.IsMobile = int.Parse(ds.Tables[0].Rows[0]["IsMobile"].ToString());
}
model.MachineCodes = ds.Tables[0].Rows[0]["MachineCodes"].ToString();
return(model);
}
else
{
return(null);
}
}
