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));
}
