/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Staffmember DataRowToModel(DataRow row) { Maticsoft.Model.Staffmember model = new Maticsoft.Model.Staffmember(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["Staffname"] != null) { model.Staffname = row["Staffname"].ToString(); } if (row["information"] != null) { model.information = row["information"].ToString(); } if (row["departmentID"] != null && row["departmentID"].ToString() != "") { model.departmentID = int.Parse(row["departmentID"].ToString()); } if (row["Positionid"] != null && row["Positionid"].ToString() != "") { model.Positionid = int.Parse(row["Positionid"].ToString()); } if (row["Beizhu"] != null) { model.Beizhu = row["Beizhu"].ToString(); } if (row["BY1"] != null && row["BY1"].ToString() != "") { model.BY1 = decimal.Parse(row["BY1"].ToString()); } if (row["BY2"] != null && row["BY2"].ToString() != "") { model.BY2 = decimal.Parse(row["BY2"].ToString()); } if (row["BY3"] != null && row["BY3"].ToString() != "") { model.BY3 = decimal.Parse(row["BY3"].ToString()); } if (row["BY4"] != null) { model.BY4 = row["BY4"].ToString(); } if (row["BY5"] != null) { model.BY5 = row["BY5"].ToString(); } if (row["BY6"] != null) { model.BY6 = row["BY6"].ToString(); } if (row["BY7"] != null) { model.BY7 = row["BY7"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Staffmember model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Staffmember set "); strSql.Append("Staffname=@Staffname,"); strSql.Append("information=@information,"); strSql.Append("departmentID=@departmentID,"); strSql.Append("Positionid=@Positionid,"); strSql.Append("Beizhu=@Beizhu,"); strSql.Append("BY1=@BY1,"); strSql.Append("BY2=@BY2,"); strSql.Append("BY3=@BY3,"); strSql.Append("BY4=@BY4,"); strSql.Append("BY5=@BY5,"); strSql.Append("BY6=@BY6,"); strSql.Append("BY7=@BY7"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@Staffname", SqlDbType.VarChar, 100), new SqlParameter("@information", SqlDbType.VarChar, 100), new SqlParameter("@departmentID", SqlDbType.Int, 4), new SqlParameter("@Positionid", SqlDbType.Int, 4), new SqlParameter("@Beizhu", SqlDbType.VarChar, 4000), new SqlParameter("@BY1", SqlDbType.Decimal, 9), new SqlParameter("@BY2", SqlDbType.Decimal, 9), new SqlParameter("@BY3", SqlDbType.Decimal, 9), new SqlParameter("@BY4", SqlDbType.VarChar, 4000), new SqlParameter("@BY5", SqlDbType.VarChar, 4000), new SqlParameter("@BY6", SqlDbType.VarChar, 4000), new SqlParameter("@BY7", SqlDbType.VarChar, 4000), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.Staffname; parameters[1].Value = model.information; parameters[2].Value = model.departmentID; parameters[3].Value = model.Positionid; parameters[4].Value = model.Beizhu; parameters[5].Value = model.BY1; parameters[6].Value = model.BY2; parameters[7].Value = model.BY3; parameters[8].Value = model.BY4; parameters[9].Value = model.BY5; parameters[10].Value = model.BY6; parameters[11].Value = model.BY7; parameters[12].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 修改部门(确定按钮) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ImageButton2_Click(object sender, EventArgs e) { try { if (TextBox4.Text.Trim() != "") { if (DropDownList3.Text != "0") { if (DropDownList4.Text != "0") { Maticsoft.Model.Staffmember zhiyuan = st.GetModel(Convert.ToInt32(Label1.Text)); zhiyuan.Staffname = TextBox4.Text; zhiyuan.information = TextBox5.Text; zhiyuan.departmentID = Convert.ToInt32(DropDownList3.Text); zhiyuan.Positionid = Convert.ToInt32(DropDownList4.Text); zhiyuan.Beizhu = TextBox7.Text; bool a = st.Update(zhiyuan); if (a == true) { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('修改成功!');</script>"); bind(sql); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('修改失败!');</script>"); bind(sql); } } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('没选择职务!');</script>"); ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>javascript:showDiv2();</script>"); } } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('没选择部门!');</script>"); ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>javascript:showDiv2();</script>"); } } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('职员名称不能为空!');</script>"); ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>javascript:showDiv2();</script>"); } } catch (Exception ee) { //Response.Write("<script>alert('确定异常 " + ee.Message + "')</script>"); ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('确定异常 " + ee.Message + "');</script>"); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.Staffmember model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Staffmember("); strSql.Append("Staffname,information,departmentID,Positionid,Beizhu,BY1,BY2,BY3,BY4,BY5,BY6,BY7)"); strSql.Append(" values ("); strSql.Append("@Staffname,@information,@departmentID,@Positionid,@Beizhu,@BY1,@BY2,@BY3,@BY4,@BY5,@BY6,@BY7)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Staffname", SqlDbType.VarChar, 100), new SqlParameter("@information", SqlDbType.VarChar, 100), new SqlParameter("@departmentID", SqlDbType.Int, 4), new SqlParameter("@Positionid", SqlDbType.Int, 4), new SqlParameter("@Beizhu", SqlDbType.VarChar, 4000), new SqlParameter("@BY1", SqlDbType.Decimal, 9), new SqlParameter("@BY2", SqlDbType.Decimal, 9), new SqlParameter("@BY3", SqlDbType.Decimal, 9), new SqlParameter("@BY4", SqlDbType.VarChar, 4000), new SqlParameter("@BY5", SqlDbType.VarChar, 4000), new SqlParameter("@BY6", SqlDbType.VarChar, 4000), new SqlParameter("@BY7", SqlDbType.VarChar, 4000) }; parameters[0].Value = model.Staffname; parameters[1].Value = model.information; parameters[2].Value = model.departmentID; parameters[3].Value = model.Positionid; parameters[4].Value = model.Beizhu; parameters[5].Value = model.BY1; parameters[6].Value = model.BY2; parameters[7].Value = model.BY3; parameters[8].Value = model.BY4; parameters[9].Value = model.BY5; parameters[10].Value = model.BY6; parameters[11].Value = model.BY7; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
private void ShowInfo(int id) { Maticsoft.BLL.Staffmember bll = new Maticsoft.BLL.Staffmember(); Maticsoft.Model.Staffmember model = bll.GetModel(id); this.lblid.Text = model.id.ToString(); this.lblStaffname.Text = model.Staffname; this.lblinformation.Text = model.information; this.lbldepartmentID.Text = model.departmentID.ToString(); this.lblPositionid.Text = model.Positionid.ToString(); this.lblBeizhu.Text = model.Beizhu; this.lblBY1.Text = model.BY1.ToString(); this.lblBY2.Text = model.BY2.ToString(); this.lblBY3.Text = model.BY3.ToString(); this.lblBY4.Text = model.BY4; this.lblBY5.Text = model.BY5; this.lblBY6.Text = model.BY6; this.lblBY7.Text = model.BY7; }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Staffmember GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,Staffname,information,departmentID,Positionid,Beizhu,BY1,BY2,BY3,BY4,BY5,BY6,BY7 from Staffmember "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Maticsoft.Model.Staffmember model = new Maticsoft.Model.Staffmember(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtStaffname.Text.Trim().Length == 0) { strErr += "Staffname不能为空!\\n"; } if (this.txtinformation.Text.Trim().Length == 0) { strErr += "information不能为空!\\n"; } if (!PageValidate.IsNumber(txtdepartmentID.Text)) { strErr += "departmentID格式错误!\\n"; } if (!PageValidate.IsNumber(txtPositionid.Text)) { strErr += "Positionid格式错误!\\n"; } if (this.txtBeizhu.Text.Trim().Length == 0) { strErr += "Beizhu不能为空!\\n"; } if (!PageValidate.IsDecimal(txtBY1.Text)) { strErr += "BY1格式错误!\\n"; } if (!PageValidate.IsDecimal(txtBY2.Text)) { strErr += "BY2格式错误!\\n"; } if (!PageValidate.IsDecimal(txtBY3.Text)) { strErr += "BY3格式错误!\\n"; } if (this.txtBY4.Text.Trim().Length == 0) { strErr += "BY4不能为空!\\n"; } if (this.txtBY5.Text.Trim().Length == 0) { strErr += "BY5不能为空!\\n"; } if (this.txtBY6.Text.Trim().Length == 0) { strErr += "BY6不能为空!\\n"; } if (this.txtBY7.Text.Trim().Length == 0) { strErr += "BY7不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string Staffname = this.txtStaffname.Text; string information = this.txtinformation.Text; int departmentID = int.Parse(this.txtdepartmentID.Text); int Positionid = int.Parse(this.txtPositionid.Text); string Beizhu = this.txtBeizhu.Text; decimal BY1 = decimal.Parse(this.txtBY1.Text); decimal BY2 = decimal.Parse(this.txtBY2.Text); decimal BY3 = decimal.Parse(this.txtBY3.Text); string BY4 = this.txtBY4.Text; string BY5 = this.txtBY5.Text; string BY6 = this.txtBY6.Text; string BY7 = this.txtBY7.Text; Maticsoft.Model.Staffmember model = new Maticsoft.Model.Staffmember(); model.Staffname = Staffname; model.information = information; model.departmentID = departmentID; model.Positionid = Positionid; model.Beizhu = Beizhu; model.BY1 = BY1; model.BY2 = BY2; model.BY3 = BY3; model.BY4 = BY4; model.BY5 = BY5; model.BY6 = BY6; model.BY7 = BY7; Maticsoft.BLL.Staffmember bll = new Maticsoft.BLL.Staffmember(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }