private void bind()
{
Maticsoft.BLL.JobZiJianInfo zijianbll = new Maticsoft.BLL.JobZiJianInfo();
int index = int.Parse(Request.QueryString["JobInfoID"].ToString());
Maticsoft.Model.JobZiJianInfo zijianmodel = zijianbll.GetModel(index);
lblguanji.Text = zijianmodel.Jiguan;
try
{
lblbrierth.Text = Convert.ToDateTime(zijianmodel.Britday.ToString()).ToString("yyyy-MM-dd");
}
catch (Exception e1)
{ }
lblmonery.Text = zijianmodel.Monery;
lblname.Text = zijianmodel.Usersname;
if (zijianmodel.Sex.ToString() == "1")
{
lblsex.Text = "先生";
}
else if (zijianmodel.Sex.ToString() == "0")
{
lblsex.Text = "女士";
}
else
{
}
lblxueli.Text = zijianmodel.Xueli;
lblzhiwei.Text = zijianmodel.Jobtitle;
lblzhuanye.Text = zijianmodel.Zhuanye;
txtjiaoyue.Text = zijianmodel.Jiaoyu;
txtjingyan.Text = zijianmodel.Jingyan;
txtpingjia.Text = zijianmodel.Pingjia;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.JobZiJianInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update JobZiJianInfo set ");
strSql.Append("Usersname=@Usersname,");
strSql.Append("Sex=@Sex,");
strSql.Append("Xueli=@Xueli,");
strSql.Append("datatime=@datatime,");
strSql.Append("Monery=@Monery,");
strSql.Append("Jiguan=@Jiguan,");
strSql.Append("Britday=@Britday,");
strSql.Append("Zhuanye=@Zhuanye,");
strSql.Append("Jiaoyu=@Jiaoyu,");
strSql.Append("Jingyan=@Jingyan,");
strSql.Append("Pingjia=@Pingjia,");
strSql.Append("Jobtitle=@Jobtitle");
strSql.Append(" where JobInfoID=@JobInfoID");
SqlParameter[] parameters =
{
new SqlParameter("@JobInfoID", SqlDbType.Int, 4),
new SqlParameter("@Usersname", SqlDbType.VarChar, 200),
new SqlParameter("@Sex", SqlDbType.Int, 4),
new SqlParameter("@Xueli", SqlDbType.VarChar, 200),
new SqlParameter("@datatime", SqlDbType.DateTime),
new SqlParameter("@Monery", SqlDbType.VarChar, 200),
new SqlParameter("@Jiguan", SqlDbType.VarChar, 200),
new SqlParameter("@Britday", SqlDbType.DateTime),
new SqlParameter("@Zhuanye", SqlDbType.VarChar, 200),
new SqlParameter("@Jiaoyu", SqlDbType.Text),
new SqlParameter("@Jingyan", SqlDbType.Text),
new SqlParameter("@Pingjia", SqlDbType.Text),
new SqlParameter("@Jobtitle", SqlDbType.Text)
};
parameters[0].Value = model.JobInfoID;
parameters[1].Value = model.Usersname;
parameters[2].Value = model.Sex;
parameters[3].Value = model.Xueli;
parameters[4].Value = model.datatime;
parameters[5].Value = model.Monery;
parameters[6].Value = model.Jiguan;
parameters[7].Value = model.Britday;
parameters[8].Value = model.Zhuanye;
parameters[9].Value = model.Jiaoyu;
parameters[10].Value = model.Jingyan;
parameters[11].Value = model.Pingjia;
parameters[12].Value = model.Jobtitle;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.JobZiJianInfo GetModel(int JobInfoID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 JobInfoID,Usersname,Sex,Xueli,datatime,Monery,Jiguan,Britday,Zhuanye,Jiaoyu,Jingyan,Pingjia,Jobtitle from JobZiJianInfo ");
strSql.Append(" where JobInfoID=@JobInfoID");
SqlParameter[] parameters =
{
new SqlParameter("@JobInfoID", SqlDbType.Int, 4)
};
parameters[0].Value = JobInfoID;
Maticsoft.Model.JobZiJianInfo model = new Maticsoft.Model.JobZiJianInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["JobInfoID"].ToString() != "")
{
model.JobInfoID = int.Parse(ds.Tables[0].Rows[0]["JobInfoID"].ToString());
}
model.Usersname = ds.Tables[0].Rows[0]["Usersname"].ToString();
if (ds.Tables[0].Rows[0]["Sex"].ToString() != "")
{
model.Sex = int.Parse(ds.Tables[0].Rows[0]["Sex"].ToString());
}
model.Xueli = ds.Tables[0].Rows[0]["Xueli"].ToString();
if (ds.Tables[0].Rows[0]["datatime"].ToString() != "")
{
model.datatime = DateTime.Parse(ds.Tables[0].Rows[0]["datatime"].ToString());
}
model.Monery = ds.Tables[0].Rows[0]["Monery"].ToString();
model.Jiguan = ds.Tables[0].Rows[0]["Jiguan"].ToString();
if (ds.Tables[0].Rows[0]["Britday"].ToString() != "")
{
model.Britday = DateTime.Parse(ds.Tables[0].Rows[0]["Britday"].ToString());
}
model.Zhuanye = ds.Tables[0].Rows[0]["Zhuanye"].ToString();
model.Jiaoyu = ds.Tables[0].Rows[0]["Jiaoyu"].ToString();
model.Jingyan = ds.Tables[0].Rows[0]["Jingyan"].ToString();
model.Pingjia = ds.Tables[0].Rows[0]["Pingjia"].ToString();
model.Jobtitle = ds.Tables[0].Rows[0]["Jobtitle"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.JobZiJianInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into JobZiJianInfo(");
strSql.Append("Usersname,Sex,Xueli,datatime,Monery,Jiguan,Britday,Zhuanye,Jiaoyu,Jingyan,Pingjia,Jobtitle)");
strSql.Append(" values (");
strSql.Append("@Usersname,@Sex,@Xueli,@datatime,@Monery,@Jiguan,@Britday,@Zhuanye,@Jiaoyu,@Jingyan,@Pingjia,@Jobtitle)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Usersname", SqlDbType.VarChar, 200),
new SqlParameter("@Sex", SqlDbType.Int, 4),
new SqlParameter("@Xueli", SqlDbType.VarChar, 200),
new SqlParameter("@datatime", SqlDbType.DateTime),
new SqlParameter("@Monery", SqlDbType.VarChar, 200),
new SqlParameter("@Jiguan", SqlDbType.VarChar, 200),
new SqlParameter("@Britday", SqlDbType.DateTime),
new SqlParameter("@Zhuanye", SqlDbType.VarChar, 200),
new SqlParameter("@Jiaoyu", SqlDbType.Text),
new SqlParameter("@Jingyan", SqlDbType.Text),
new SqlParameter("@Pingjia", SqlDbType.Text),
new SqlParameter("@Jobtitle", SqlDbType.Text)
};
parameters[0].Value = model.Usersname;
parameters[1].Value = model.Sex;
parameters[2].Value = model.Xueli;
parameters[3].Value = model.datatime;
parameters[4].Value = model.Monery;
parameters[5].Value = model.Jiguan;
parameters[6].Value = model.Britday;
parameters[7].Value = model.Zhuanye;
parameters[8].Value = model.Jiaoyu;
parameters[9].Value = model.Jingyan;
parameters[10].Value = model.Pingjia;
parameters[11].Value = model.Jobtitle;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void ShowInfo(int JobInfoID)
{
Maticsoft.BLL.JobZiJianInfo bll = new Maticsoft.BLL.JobZiJianInfo();
Maticsoft.Model.JobZiJianInfo model = bll.GetModel(JobInfoID);
this.lblJobInfoID.Text = model.JobInfoID.ToString();
this.txtUsersname.Text = model.Usersname;
this.txtJobID.Text = model.JobID.ToString();
this.chkSex.Checked = model.Sex;
this.txtXueli.Text = model.Xueli;
this.txtJiguan.Text = model.Jiguan;
this.txtBritday.Text = model.Britday.ToString();
this.txtZhuanye.Text = model.Zhuanye;
this.txtJiaoyu.Text = model.Jiaoyu;
this.txtJingyan.Text = model.Jingyan;
this.txtPingjia.Text = model.Pingjia;
}
private void ShowInfo(int JobInfoID)
{
Maticsoft.BLL.JobZiJianInfo bll = new Maticsoft.BLL.JobZiJianInfo();
Maticsoft.Model.JobZiJianInfo model = bll.GetModel(JobInfoID);
this.lblJobInfoID.Text = model.JobInfoID.ToString();
this.lblUsersname.Text = model.Usersname;
this.lblJobID.Text = model.JobID.ToString();
this.lblSex.Text = model.Sex?"ÊÇ":"·ñ";
this.lblXueli.Text = model.Xueli;
this.lblJiguan.Text = model.Jiguan;
this.lblBritday.Text = model.Britday.ToString();
this.lblZhuanye.Text = model.Zhuanye;
this.lblJiaoyu.Text = model.Jiaoyu;
this.lblJingyan.Text = model.Jingyan;
this.lblPingjia.Text = model.Pingjia;
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtUsersname.Text.Trim().Length == 0)
{
strErr += "Usersname不能为空！\\n";
}
if (!PageValidate.IsNumber(txtJobID.Text))
{
strErr += "JobID格式错误！\\n";
}
if (this.txtXueli.Text.Trim().Length == 0)
{
strErr += "Xueli不能为空！\\n";
}
if (this.txtJiguan.Text.Trim().Length == 0)
{
strErr += "Jiguan不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtBritday.Text))
{
strErr += "Britday格式错误！\\n";
}
if (this.txtZhuanye.Text.Trim().Length == 0)
{
strErr += "Zhuanye不能为空！\\n";
}
if (this.txtJiaoyu.Text.Trim().Length == 0)
{
strErr += "Jiaoyu不能为空！\\n";
}
if (this.txtJingyan.Text.Trim().Length == 0)
{
strErr += "Jingyan不能为空！\\n";
}
if (this.txtPingjia.Text.Trim().Length == 0)
{
strErr += "Pingjia不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int JobInfoID = int.Parse(this.lblJobInfoID.Text);
string Usersname = this.txtUsersname.Text;
int JobID = int.Parse(this.txtJobID.Text);
bool Sex = this.chkSex.Checked;
string Xueli = this.txtXueli.Text;
string Jiguan = this.txtJiguan.Text;
DateTime Britday = DateTime.Parse(this.txtBritday.Text);
string Zhuanye = this.txtZhuanye.Text;
string Jiaoyu = this.txtJiaoyu.Text;
string Jingyan = this.txtJingyan.Text;
string Pingjia = this.txtPingjia.Text;
Maticsoft.Model.JobZiJianInfo model = new Maticsoft.Model.JobZiJianInfo();
model.JobInfoID = JobInfoID;
model.Usersname = Usersname;
model.JobID = JobID;
model.Sex = Sex;
model.Xueli = Xueli;
model.Jiguan = Jiguan;
model.Britday = Britday;
model.Zhuanye = Zhuanye;
model.Jiaoyu = Jiaoyu;
model.Jingyan = Jingyan;
model.Pingjia = Pingjia;
Maticsoft.BLL.JobZiJianInfo bll = new Maticsoft.BLL.JobZiJianInfo();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
protected void btnok_Click(object sender, EventArgs e)
{
Maticsoft.BLL.JobZiJianInfo jobbll = new Maticsoft.BLL.JobZiJianInfo();
Maticsoft.Model.JobZiJianInfo jobmodel = new Maticsoft.Model.JobZiJianInfo();
if (txtUsersname.Text.Trim() == "")
{
lblusername.Text = "请填写您的姓名..";
return;
}
jobmodel.Usersname = txtUsersname.Text.Trim();
lblusername.Text = "";
if (txtJobTitleName.Text.Trim() == "")
{
lnljobtitle.Text = "请填写您应聘的职位..";
return;
}
jobmodel.Jobtitle = txtJobTitleName.Text.Trim();
lnljobtitle.Text = "";
if (drpSex.SelectedValue != "1" && drpSex.SelectedValue != "0")
{
lblsex.Text = "请选择您的性别..";
return;
}
else
{
jobmodel.Sex = int.Parse(drpSex.SelectedValue.ToString());
lblsex.Text = "";
}
if (txtXueli.Text.Trim() == "")
{
lblxueli.Text = "请天谢谢您的学历";
return;
}
lblxueli.Text = "";
jobmodel.Xueli = txtXueli.Text.Trim();
if (txtJiguan.Text.Trim() == "")
{
lbljiguan.Text = "请填写您的籍贯";
return;
}
jobmodel.Jiguan = txtJiguan.Text.Trim();
lbljiguan.Text = "";
if (txtBritday.Text.Trim() == "")
{
lblbriendy.Text = "请填写您的出生年月..";
return;
}
lblbriendy.Text = "";
jobmodel.datatime = Convert.ToDateTime(DateTime.Now.ToString());
jobmodel.Britday = Convert.ToDateTime(txtBritday.Text.Trim());
if (txtZhuanye.Text.Trim() == "")
{
lnlzhuangye.Text = "请填写您的专业...";
return;
}
lnlzhuangye.Text = "";
jobmodel.Zhuanye = txtZhuanye.Text.Trim();
jobmodel.Jiaoyu = txtJiaoyu.Text.Trim();
jobmodel.Jingyan = txtJingyan.Text.Trim();
jobmodel.Pingjia = txtPingjia.Text.Trim();
jobbll.Add(jobmodel);
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('信息添加成功..')</script>");
txtBritday.Text = string.Empty;
txtJiaoyu.Text = string.Empty;
txtJiguan.Text = string.Empty;
txtJingyan.Text = string.Empty;
txtJobTitleName.Text = string.Empty;
txtPingjia.Text = string.Empty;
txtUsersname.Text = string.Empty;
txtXueli.Text = string.Empty;
txtZhuanye.Text = string.Empty;
}
