public bool AddEmpTab(Model.EmpTab emptab, out string msg) { msg = ""; try { return(iEmpiricalDAL.Add(emptab)); } catch (Exception exp) { msg = exp.Message; return(false); } }
private void ParseEmpTab() { Model.EmpTab empTab = new Model.EmpTab(); empTab.Em_name = this.text_name.Text; empTab.Effect = this.text_method.Text; empTab.Fangjie = this.text_function.Text; empTab.From_where = this.text_from.Text; empTab.Cure = this.text_cure.Text; empTab.Em_ab = this.text_code.Text; empTab.Minus_and_add = "无"; empTab.Apply = "无"; if (empTabBLL.UpdateEmpTab(empTab)) { MessageBox.Show("更新成功!"); } Fill(); }
private void bt_alter_Click(object sender, EventArgs e) { Clear(); Model.EmpTab empTab = new Model.EmpTab(); empTab.Em_name = this.text_name.Text; empTab.Effect = this.text_method.Text; empTab.Fangjie = this.text_function.Text; empTab.From_where = this.text_from.Text; empTab.Cure = this.text_cure.Text; empTab.Em_ab = this.text_code.Text; empTab.Minus_and_add = "无"; empTab.Apply = "无"; if (empTabBLL.UpdateEmpTab(empTab)) { MessageBoxBuilder.buildbox("更新成功!", "ok"); } Fill(); }
public bool Update(Model.EmpTab empTab) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [empirical] set "); strSql.Append("em_name=@em_name,em_ab=@em_ab,from_where=@from_where," + "effect=@effect,cure=@cure,minus_and_add=@minus_and_add,fangjie=@fangjie,apply=@apply where em_name=@em_name"); int row = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, ParsePara(empTab)); if (row > 0) { return(true); } else { return(false); } }
public bool Add(Model.EmpTab empTab) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [empirical](em_name,em_ab,from_where,effect," + "cure,minus_and_add,fangjie,apply) values"); strSql.Append("(@em_name,@em_ab,@from_where,@effect,@cure,@minus_and_add,@fangjie,@apply)"); int row = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, ParsePara(empTab)); if (row > 0) { return(true); } else { return(false); } }
private void ParseEmpTab() { Model.EmpTab empTab = new Model.EmpTab(); empTab.Em_name = this.text_name.Text; empTab.Effect = this.text_method.Text; empTab.Fangjie = this.text_function.Text; empTab.From_where = this.text_from.Text; empTab.Cure = this.text_cure.Text; empTab.Em_ab = this.text_code.Text; empTab.Minus_and_add = "无"; empTab.Apply = "无"; string msg = ""; if (empTabBLL.AddEmpTab(empTab, out msg)) { MessageBoxBuilder.buildbox("更新成功!", "ok"); } this.bt_confirm.Text = "增加"; Fill(); }
public SqlParameter[] ParsePara(Model.EmpTab emptab) { SqlParameter[] parameters = { new SqlParameter("@em_name", SqlDbType.VarChar, 16), new SqlParameter("@em_ab", SqlDbType.VarChar, 6), new SqlParameter("@from_where", SqlDbType.VarChar, 256), new SqlParameter("@effect", SqlDbType.VarChar, 256), new SqlParameter("@cure", SqlDbType.VarChar, 256), new SqlParameter("@minus_and_add", SqlDbType.VarChar, 64), new SqlParameter("@fangjie", SqlDbType.VarChar, 128), new SqlParameter("@apply", SqlDbType.VarChar, 512), }; parameters[0].Value = emptab.Em_name; parameters[1].Value = emptab.Em_ab; parameters[2].Value = emptab.From_where; parameters[3].Value = emptab.Effect; parameters[4].Value = emptab.Cure; parameters[5].Value = emptab.Minus_and_add; parameters[6].Value = emptab.Fangjie; parameters[7].Value = emptab.Apply; return(parameters); }
public bool UpdateEmpTab(Model.EmpTab emptab) { return(iEmpiricalDAL.Update(emptab)); }