/// <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>
public bool Update(Maticsoft.Model.tsuhan_gt_cpbm model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.tsuhan_gt_cpbm model)
{
return(dal.Add(model));
}