/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.UserInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UserInfo set ");
strSql.Append("UserName=@UserName,");
strSql.Append("UserPass=@UserPass,");
strSql.Append("RegTime=@RegTime,");
strSql.Append("Email=@Email");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 32),
new SqlParameter("@UserPass", SqlDbType.NVarChar, 32),
new SqlParameter("@RegTime", SqlDbType.DateTime),
new SqlParameter("@Email", SqlDbType.NVarChar, 32),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.UserPass;
parameters[2].Value = model.RegTime;
parameters[3].Value = model.Email;
parameters[4].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//
//窗体载入事件
//
private void Window_Loaded(object sender, RoutedEventArgs e)
{
cmb_Workstation.ItemsSource = MCP_CS._M_Workstation.GetStringList("");
cmb_Job_Title.ItemsSource = MCP_CS._M_Equipment_TypeList.GetStringList("Type = '职位'");
cmb_IsJob.ItemsSource = MCP_CS._M_Equipment_TypeList.GetStringList("Type = '是否在职'");
cmb_IsWedding.ItemsSource = MCP_CS._M_Equipment_TypeList.GetStringList("Type = '是否已婚'");
cmb_Politics.ItemsSource = MCP_CS._M_Equipment_TypeList.GetStringList("Type = '政治面貌'");
cmb_Sex.ItemsSource = MCP_CS._M_Equipment_TypeList.GetStringList("Type = '性别'");
dpk_Entry_Date.SelectedDate = DateTime.Now;
dpk_Termination_Date.SelectedDate = DateTime.Now;
if (IsAddNew) //添加模式
{
Maticsoft.Model.UserInfo use = new Maticsoft.Model.UserInfo();
grd_UserInfo.DataContext = use;
btn_Edit.IsEnabled = false;
}
else //更新模式
{
if (Employee != null)
{
grd_UserInfo.DataContext = Employee;
SetControl(false, false);
btn_Add.IsEnabled = false;
btn_Save.IsEnabled = false;
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.UserInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into UserInfo(");
strSql.Append("UserName,UserPass,RegTime,Email)");
strSql.Append(" values (");
strSql.Append("@UserName,@UserPass,@RegTime,@Email)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 32),
new SqlParameter("@UserPass", SqlDbType.NVarChar, 32),
new SqlParameter("@RegTime", SqlDbType.DateTime),
new SqlParameter("@Email", SqlDbType.NVarChar, 32)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.UserPass;
parameters[2].Value = model.RegTime;
parameters[3].Value = model.Email;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.UserInfo DataRowToModel(DataRow row)
{
Maticsoft.Model.UserInfo model = new Maticsoft.Model.UserInfo();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
if (row["UserPass"] != null)
{
model.UserPass = row["UserPass"].ToString();
}
if (row["RegTime"] != null && row["RegTime"].ToString() != "")
{
model.RegTime = DateTime.Parse(row["RegTime"].ToString());
}
if (row["Email"] != null)
{
model.Email = row["Email"].ToString();
}
}
return(model);
}
//
//保存
//
private void btn_Save_Click(object sender, RoutedEventArgs e)
{
bool IsOk = true;
CheckTextBoxNotNull(ref IsOk, txb_JobNum, txb_Name, txb_Age);
if (!IsOk)
{
return;
}
else
{
try
{
if (IsAddNew) //添加模式
{
Maticsoft.Model.UserInfo use = (Maticsoft.Model.UserInfo)grd_UserInfo.DataContext;
MCP_CS.UserInfo.Add(use);
}
else //更新模式
{
Maticsoft.Model.UserInfo use = (Maticsoft.Model.UserInfo)grd_UserInfo.DataContext;
MCP_CS.UserInfo.Update(use);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
btn_Save.IsEnabled = false;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.UserInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into UserInfo(");
strSql.Append("ParentID,UserName,Password,PrivilegeID,TrueName,RoleID,Time,status,UnionID,UserFrom,DepartmentID,UrGuid,HeadImage)");
strSql.Append(" values (");
strSql.Append("@ParentID,@UserName,@Password,@PrivilegeID,@TrueName,@RoleID,@Time,@status,@UnionID,@UserFrom,@DepartmentID,@UrGuid,@HeadImage)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.NVarChar, 50),
new SqlParameter("@Password", SqlDbType.NVarChar, 100),
new SqlParameter("@PrivilegeID", SqlDbType.NVarChar, 200),
new SqlParameter("@TrueName", SqlDbType.NVarChar, 50),
new SqlParameter("@RoleID", SqlDbType.Int, 4),
new SqlParameter("@Time", SqlDbType.DateTime),
new SqlParameter("@status", SqlDbType.Int, 4),
new SqlParameter("@UnionID", SqlDbType.NVarChar, 50),
new SqlParameter("@UserFrom", SqlDbType.NVarChar, 50),
new SqlParameter("@DepartmentID", SqlDbType.Int, 4),
new SqlParameter("@UrGuid", SqlDbType.NVarChar, 100),
new SqlParameter("@HeadImage", SqlDbType.NVarChar, 500)
};
parameters[0].Value = model.ParentID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.Password;
parameters[3].Value = model.PrivilegeID;
parameters[4].Value = model.TrueName;
parameters[5].Value = model.RoleID;
parameters[6].Value = model.Time;
parameters[7].Value = model.status;
parameters[8].Value = model.UnionID;
parameters[9].Value = model.UserFrom;
parameters[10].Value = model.DepartmentID;
parameters[11].Value = model.UrGuid;
parameters[12].Value = model.HeadImage;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.UserInfo GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,ParentID,UserName,Password,PrivilegeID,TrueName,RoleID,Time,status,UnionID,UserFrom,DepartmentID,UrGuid,HeadImage from UserInfo ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Maticsoft.Model.UserInfo model = new Maticsoft.Model.UserInfo();
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 DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "UserInfo";
* parameters[1].Value = "ID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
#endregion ExtensionMethod
/// <summary>
/// 登录查询
/// </summary>
/// <param name="admin">管理员名字</param>
/// <param name="pwd">密码</param>
public Model.UserInfo GetModel(string admin, string pwd)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,UserName,UserPass,RegTime,Email from UserInfo ");
strSql.Append(" where UserName=@username and UserPass=@pwd");
SqlParameter[] parameters =
{
new SqlParameter("@username", admin),
new SqlParameter("@pwd", pwd)
};
Maticsoft.Model.UserInfo model = new Maticsoft.Model.UserInfo();
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 Maticsoft.Model.UserInfo GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,UserName,UserPass,RegTime,Email from UserInfo ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Maticsoft.Model.UserInfo model = new Maticsoft.Model.UserInfo();
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 Maticsoft.Model.UserInfo DataRowToModel(DataRow row)
{
Maticsoft.Model.UserInfo model = new Maticsoft.Model.UserInfo();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["ParentID"] != null && row["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(row["ParentID"].ToString());
}
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
if (row["Password"] != null)
{
model.Password = row["Password"].ToString();
}
if (row["PrivilegeID"] != null)
{
model.PrivilegeID = row["PrivilegeID"].ToString();
}
if (row["TrueName"] != null)
{
model.TrueName = row["TrueName"].ToString();
}
if (row["RoleID"] != null && row["RoleID"].ToString() != "")
{
model.RoleID = int.Parse(row["RoleID"].ToString());
}
if (row["Time"] != null && row["Time"].ToString() != "")
{
model.Time = DateTime.Parse(row["Time"].ToString());
}
if (row["status"] != null && row["status"].ToString() != "")
{
model.status = int.Parse(row["status"].ToString());
}
if (row["UnionID"] != null)
{
model.UnionID = row["UnionID"].ToString();
}
if (row["UserFrom"] != null)
{
model.UserFrom = row["UserFrom"].ToString();
}
if (row["DepartmentID"] != null && row["DepartmentID"].ToString() != "")
{
model.DepartmentID = int.Parse(row["DepartmentID"].ToString());
}
if (row["UrGuid"] != null)
{
model.UrGuid = row["UrGuid"].ToString();
}
if (row["HeadImage"] != null)
{
model.HeadImage = row["HeadImage"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.UserInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UserInfo set ");
strSql.Append("ParentID=@ParentID,");
strSql.Append("UserName=@UserName,");
strSql.Append("Password=@Password,");
strSql.Append("PrivilegeID=@PrivilegeID,");
strSql.Append("TrueName=@TrueName,");
strSql.Append("RoleID=@RoleID,");
strSql.Append("Time=@Time,");
strSql.Append("status=@status,");
strSql.Append("UnionID=@UnionID,");
strSql.Append("UserFrom=@UserFrom,");
strSql.Append("DepartmentID=@DepartmentID,");
strSql.Append("UrGuid=@UrGuid,");
strSql.Append("HeadImage=@HeadImage");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.NVarChar, 50),
new SqlParameter("@Password", SqlDbType.NVarChar, 100),
new SqlParameter("@PrivilegeID", SqlDbType.NVarChar, 200),
new SqlParameter("@TrueName", SqlDbType.NVarChar, 50),
new SqlParameter("@RoleID", SqlDbType.Int, 4),
new SqlParameter("@Time", SqlDbType.DateTime),
new SqlParameter("@status", SqlDbType.Int, 4),
new SqlParameter("@UnionID", SqlDbType.NVarChar, 50),
new SqlParameter("@UserFrom", SqlDbType.NVarChar, 50),
new SqlParameter("@DepartmentID", SqlDbType.Int, 4),
new SqlParameter("@UrGuid", SqlDbType.NVarChar, 100),
new SqlParameter("@HeadImage", SqlDbType.NVarChar, 500),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.ParentID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.Password;
parameters[3].Value = model.PrivilegeID;
parameters[4].Value = model.TrueName;
parameters[5].Value = model.RoleID;
parameters[6].Value = model.Time;
parameters[7].Value = model.status;
parameters[8].Value = model.UnionID;
parameters[9].Value = model.UserFrom;
parameters[10].Value = model.DepartmentID;
parameters[11].Value = model.UrGuid;
parameters[12].Value = model.HeadImage;
parameters[13].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.UserInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_UserInfo(");
strSql.Append("Workstation,Job_Title,Is_Job,Job_Num,Name,Age,Sex,IsWedding,Politics,ID_Card,Nation,Native_Place,Degree,Major,School,Date_Of_Birth,Entry_Date,Termination_Date,QQ,Email_Address,Phone,Present_Assress,Emergency_Contact,Resume,Remark)");
strSql.Append(" values (");
strSql.Append("@Workstation,@Job_Title,@Is_Job,@Job_Num,@Name,@Age,@Sex,@IsWedding,@Politics,@ID_Card,@Nation,@Native_Place,@Degree,@Major,@School,@Date_Of_Birth,@Entry_Date,@Termination_Date,@QQ,@Email_Address,@Phone,@Present_Assress,@Emergency_Contact,@Resume,@Remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Workstation", SqlDbType.VarChar, 50),
new SqlParameter("@Job_Title", SqlDbType.VarChar, 50),
new SqlParameter("@Is_Job", SqlDbType.VarChar, 10),
new SqlParameter("@Job_Num", SqlDbType.VarChar, 30),
new SqlParameter("@Name", SqlDbType.VarChar, 30),
new SqlParameter("@Age", SqlDbType.VarChar, 10),
new SqlParameter("@Sex", SqlDbType.VarChar, 10),
new SqlParameter("@IsWedding", SqlDbType.VarChar, 10),
new SqlParameter("@Politics", SqlDbType.VarChar, 20),
new SqlParameter("@ID_Card", SqlDbType.VarChar, 50),
new SqlParameter("@Nation", SqlDbType.VarChar, 20),
new SqlParameter("@Native_Place", SqlDbType.VarChar, 255),
new SqlParameter("@Degree", SqlDbType.VarChar, 20),
new SqlParameter("@Major", SqlDbType.VarChar, 50),
new SqlParameter("@School", SqlDbType.VarChar, 50),
new SqlParameter("@Date_Of_Birth", SqlDbType.DateTime),
new SqlParameter("@Entry_Date", SqlDbType.DateTime),
new SqlParameter("@Termination_Date", SqlDbType.DateTime),
new SqlParameter("@QQ", SqlDbType.VarChar, 20),
new SqlParameter("@Email_Address", SqlDbType.VarChar, 30),
new SqlParameter("@Phone", SqlDbType.VarChar, 30),
new SqlParameter("@Present_Assress", SqlDbType.VarChar, 255),
new SqlParameter("@Emergency_Contact", SqlDbType.Text),
new SqlParameter("@Resume", SqlDbType.Text),
new SqlParameter("@Remark", SqlDbType.Text)
};
parameters[0].Value = model.Workstation;
parameters[1].Value = model.Job_Title;
parameters[2].Value = model.Is_Job;
parameters[3].Value = model.Job_Num;
parameters[4].Value = model.Name;
parameters[5].Value = model.Age;
parameters[6].Value = model.Sex;
parameters[7].Value = model.IsWedding;
parameters[8].Value = model.Politics;
parameters[9].Value = model.ID_Card;
parameters[10].Value = model.Nation;
parameters[11].Value = model.Native_Place;
parameters[12].Value = model.Degree;
parameters[13].Value = model.Major;
parameters[14].Value = model.School;
parameters[15].Value = model.Date_Of_Birth;
parameters[16].Value = model.Entry_Date;
parameters[17].Value = model.Termination_Date;
parameters[18].Value = model.QQ;
parameters[19].Value = model.Email_Address;
parameters[20].Value = model.Phone;
parameters[21].Value = model.Present_Assress;
parameters[22].Value = model.Emergency_Contact;
parameters[23].Value = model.Resume;
parameters[24].Value = model.Remark;
object obj = dbs.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.UserInfo GetModel(string jobNum)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 USI_ID,Workstation,Job_Title,Is_Job,Job_Num,Name,Age,Sex,IsWedding,Politics,ID_Card,Nation,Native_Place,Degree,Major,School,Date_Of_Birth,Entry_Date,Termination_Date,QQ,Email_Address,Phone,Present_Assress,Emergency_Contact,Resume,Remark from tb_UserInfo ");
strSql.Append(" where Job_Num=@Job_Num");
SqlParameter[] parameters =
{
new SqlParameter("@Job_Num", SqlDbType.VarChar, 30)
};
parameters[0].Value = jobNum;
Maticsoft.Model.UserInfo model = new Maticsoft.Model.UserInfo();
DataSet ds = dbs.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["USI_ID"] != null && ds.Tables[0].Rows[0]["USI_ID"].ToString() != "")
{
model.USI_ID = decimal.Parse(ds.Tables[0].Rows[0]["USI_ID"].ToString());
}
if (ds.Tables[0].Rows[0]["Workstation"] != null && ds.Tables[0].Rows[0]["Workstation"].ToString() != "")
{
model.Workstation = ds.Tables[0].Rows[0]["Workstation"].ToString();
}
if (ds.Tables[0].Rows[0]["Job_Title"] != null && ds.Tables[0].Rows[0]["Job_Title"].ToString() != "")
{
model.Job_Title = ds.Tables[0].Rows[0]["Job_Title"].ToString();
}
if (ds.Tables[0].Rows[0]["Is_Job"] != null && ds.Tables[0].Rows[0]["Is_Job"].ToString() != "")
{
model.Is_Job = ds.Tables[0].Rows[0]["Is_Job"].ToString();
}
if (ds.Tables[0].Rows[0]["Job_Num"] != null && ds.Tables[0].Rows[0]["Job_Num"].ToString() != "")
{
model.Job_Num = ds.Tables[0].Rows[0]["Job_Num"].ToString();
}
if (ds.Tables[0].Rows[0]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "")
{
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
}
if (ds.Tables[0].Rows[0]["Age"] != null && ds.Tables[0].Rows[0]["Age"].ToString() != "")
{
model.Age = ds.Tables[0].Rows[0]["Age"].ToString();
}
if (ds.Tables[0].Rows[0]["Sex"] != null && ds.Tables[0].Rows[0]["Sex"].ToString() != "")
{
model.Sex = ds.Tables[0].Rows[0]["Sex"].ToString();
}
if (ds.Tables[0].Rows[0]["IsWedding"] != null && ds.Tables[0].Rows[0]["IsWedding"].ToString() != "")
{
model.IsWedding = ds.Tables[0].Rows[0]["IsWedding"].ToString();
}
if (ds.Tables[0].Rows[0]["Politics"] != null && ds.Tables[0].Rows[0]["Politics"].ToString() != "")
{
model.Politics = ds.Tables[0].Rows[0]["Politics"].ToString();
}
if (ds.Tables[0].Rows[0]["ID_Card"] != null && ds.Tables[0].Rows[0]["ID_Card"].ToString() != "")
{
model.ID_Card = ds.Tables[0].Rows[0]["ID_Card"].ToString();
}
if (ds.Tables[0].Rows[0]["Nation"] != null && ds.Tables[0].Rows[0]["Nation"].ToString() != "")
{
model.Nation = ds.Tables[0].Rows[0]["Nation"].ToString();
}
if (ds.Tables[0].Rows[0]["Native_Place"] != null && ds.Tables[0].Rows[0]["Native_Place"].ToString() != "")
{
model.Native_Place = ds.Tables[0].Rows[0]["Native_Place"].ToString();
}
if (ds.Tables[0].Rows[0]["Degree"] != null && ds.Tables[0].Rows[0]["Degree"].ToString() != "")
{
model.Degree = ds.Tables[0].Rows[0]["Degree"].ToString();
}
if (ds.Tables[0].Rows[0]["Major"] != null && ds.Tables[0].Rows[0]["Major"].ToString() != "")
{
model.Major = ds.Tables[0].Rows[0]["Major"].ToString();
}
if (ds.Tables[0].Rows[0]["School"] != null && ds.Tables[0].Rows[0]["School"].ToString() != "")
{
model.School = ds.Tables[0].Rows[0]["School"].ToString();
}
if (ds.Tables[0].Rows[0]["Date_Of_Birth"] != null && ds.Tables[0].Rows[0]["Date_Of_Birth"].ToString() != "")
{
model.Date_Of_Birth = DateTime.Parse(ds.Tables[0].Rows[0]["Date_Of_Birth"].ToString());
}
if (ds.Tables[0].Rows[0]["Entry_Date"] != null && ds.Tables[0].Rows[0]["Entry_Date"].ToString() != "")
{
model.Entry_Date = DateTime.Parse(ds.Tables[0].Rows[0]["Entry_Date"].ToString());
}
if (ds.Tables[0].Rows[0]["Termination_Date"] != null && ds.Tables[0].Rows[0]["Termination_Date"].ToString() != "")
{
model.Termination_Date = DateTime.Parse(ds.Tables[0].Rows[0]["Termination_Date"].ToString());
}
if (ds.Tables[0].Rows[0]["QQ"] != null && ds.Tables[0].Rows[0]["QQ"].ToString() != "")
{
model.QQ = ds.Tables[0].Rows[0]["QQ"].ToString();
}
if (ds.Tables[0].Rows[0]["Email_Address"] != null && ds.Tables[0].Rows[0]["Email_Address"].ToString() != "")
{
model.Email_Address = ds.Tables[0].Rows[0]["Email_Address"].ToString();
}
if (ds.Tables[0].Rows[0]["Phone"] != null && ds.Tables[0].Rows[0]["Phone"].ToString() != "")
{
model.Phone = ds.Tables[0].Rows[0]["Phone"].ToString();
}
if (ds.Tables[0].Rows[0]["Present_Assress"] != null && ds.Tables[0].Rows[0]["Present_Assress"].ToString() != "")
{
model.Present_Assress = ds.Tables[0].Rows[0]["Present_Assress"].ToString();
}
if (ds.Tables[0].Rows[0]["Emergency_Contact"] != null && ds.Tables[0].Rows[0]["Emergency_Contact"].ToString() != "")
{
model.Emergency_Contact = ds.Tables[0].Rows[0]["Emergency_Contact"].ToString();
}
if (ds.Tables[0].Rows[0]["Resume"] != null && ds.Tables[0].Rows[0]["Resume"].ToString() != "")
{
model.Resume = ds.Tables[0].Rows[0]["Resume"].ToString();
}
if (ds.Tables[0].Rows[0]["Remark"] != null && ds.Tables[0].Rows[0]["Remark"].ToString() != "")
{
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.UserInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_UserInfo set ");
strSql.Append("Workstation=@Workstation,");
strSql.Append("Job_Title=@Job_Title,");
strSql.Append("Is_Job=@Is_Job,");
strSql.Append("Job_Num=@Job_Num,");
strSql.Append("Name=@Name,");
strSql.Append("Age=@Age,");
strSql.Append("Sex=@Sex,");
strSql.Append("IsWedding=@IsWedding,");
strSql.Append("Politics=@Politics,");
strSql.Append("ID_Card=@ID_Card,");
strSql.Append("Nation=@Nation,");
strSql.Append("Native_Place=@Native_Place,");
strSql.Append("Degree=@Degree,");
strSql.Append("Major=@Major,");
strSql.Append("School=@School,");
strSql.Append("Date_Of_Birth=@Date_Of_Birth,");
strSql.Append("Entry_Date=@Entry_Date,");
strSql.Append("Termination_Date=@Termination_Date,");
strSql.Append("QQ=@QQ,");
strSql.Append("Email_Address=@Email_Address,");
strSql.Append("Phone=@Phone,");
strSql.Append("Present_Assress=@Present_Assress,");
strSql.Append("Emergency_Contact=@Emergency_Contact,");
strSql.Append("Resume=@Resume,");
strSql.Append("Remark=@Remark");
strSql.Append(" where USI_ID=@USI_ID");
SqlParameter[] parameters =
{
new SqlParameter("@Workstation", SqlDbType.VarChar, 50),
new SqlParameter("@Job_Title", SqlDbType.VarChar, 50),
new SqlParameter("@Is_Job", SqlDbType.VarChar, 10),
new SqlParameter("@Job_Num", SqlDbType.VarChar, 30),
new SqlParameter("@Name", SqlDbType.VarChar, 30),
new SqlParameter("@Age", SqlDbType.VarChar, 10),
new SqlParameter("@Sex", SqlDbType.VarChar, 10),
new SqlParameter("@IsWedding", SqlDbType.VarChar, 10),
new SqlParameter("@Politics", SqlDbType.VarChar, 20),
new SqlParameter("@ID_Card", SqlDbType.VarChar, 50),
new SqlParameter("@Nation", SqlDbType.VarChar, 20),
new SqlParameter("@Native_Place", SqlDbType.VarChar, 255),
new SqlParameter("@Degree", SqlDbType.VarChar, 20),
new SqlParameter("@Major", SqlDbType.VarChar, 50),
new SqlParameter("@School", SqlDbType.VarChar, 50),
new SqlParameter("@Date_Of_Birth", SqlDbType.DateTime),
new SqlParameter("@Entry_Date", SqlDbType.DateTime),
new SqlParameter("@Termination_Date", SqlDbType.DateTime),
new SqlParameter("@QQ", SqlDbType.VarChar, 20),
new SqlParameter("@Email_Address", SqlDbType.VarChar, 30),
new SqlParameter("@Phone", SqlDbType.VarChar, 30),
new SqlParameter("@Present_Assress", SqlDbType.VarChar, 255),
new SqlParameter("@Emergency_Contact", SqlDbType.Text),
new SqlParameter("@Resume", SqlDbType.Text),
new SqlParameter("@Remark", SqlDbType.Text),
new SqlParameter("@USI_ID", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.Workstation;
parameters[1].Value = model.Job_Title;
parameters[2].Value = model.Is_Job;
parameters[3].Value = model.Job_Num;
parameters[4].Value = model.Name;
parameters[5].Value = model.Age;
parameters[6].Value = model.Sex;
parameters[7].Value = model.IsWedding;
parameters[8].Value = model.Politics;
parameters[9].Value = model.ID_Card;
parameters[10].Value = model.Nation;
parameters[11].Value = model.Native_Place;
parameters[12].Value = model.Degree;
parameters[13].Value = model.Major;
parameters[14].Value = model.School;
parameters[15].Value = model.Date_Of_Birth;
parameters[16].Value = model.Entry_Date;
parameters[17].Value = model.Termination_Date;
parameters[18].Value = model.QQ;
parameters[19].Value = model.Email_Address;
parameters[20].Value = model.Phone;
parameters[21].Value = model.Present_Assress;
parameters[22].Value = model.Emergency_Contact;
parameters[23].Value = model.Resume;
parameters[24].Value = model.Remark;
parameters[25].Value = model.USI_ID;
int rows = dbs.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
