/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(tsuhan_gt_cpbm model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tsuhan_gt_cpbm(");
strSql.Append("成品编码,录入员,时间)");
strSql.Append(" values (");
strSql.Append("@成品编码,@录入员,@时间)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@成品编码", SqlDbType.NVarChar, 30),
new SqlParameter("@录入员", SqlDbType.NVarChar, 10),
new SqlParameter("@时间", SqlDbType.DateTime)
};
parameters[0].Value = model.成品编码;
parameters[1].Value = model.录入员;
parameters[2].Value = model.时间;
int rows = dbhelper1.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("确定要添加吗？？？", "提示", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
var gt = yhbll.GetModel(gh);
tsuhan_gt_cpbm cpbm = new tsuhan_gt_cpbm();
cpbm.成品编码 = this.txtCPBM.Text;
cpbm.时间 = Convert.ToDateTime(this.dtpTime.Text);
cpbm.录入员 = Convert.ToString(gt.工号);
bool result = cpbll.Add(cpbm);
if (result == true)
{
MessageBox.Show("添加成功", "提示");
this.dataGridView1.AutoGenerateColumns = false;
DataSet ds = cpbll.GetChanPTable();
this.dataGridView1.DataSource = ds.Tables[0];
}
else
{
MessageBox.Show("添加失败", "提示");
}
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="cpbm"></param>
/// <returns></returns>
public bool Add(tsuhan_gt_cpbm cpbm)
{
return(dal.Add(cpbm));
}
