private void btnSave_Click(object sender, EventArgs e)
{
int res = 0;
foreach (DataGridViewRow dr in dgvUseList.Rows)
{
ConsumablesUseModel cu = new ConsumablesUseModel();
cu.MzjldId = MzjldId;
cu.PatId = PatId;
cu.Id = UserFunction.ToInt32(dr.Cells["Id"].Value);
cu.Name = Convert.ToString(dr.Cells["Name"].Value);
cu.Dosage = UserFunction.ToInt32(dr.Cells["Dosage"].Value);
cu.Price = UserFunction.ToDouble(dr.Cells["Price"].Value);
cu.Unit = Convert.ToString(dr.Cells["Unit"].Value);
cu.IsCost = UserFunction.ToInt32(dr.Cells["IsCost"].Value);
res = dal.Update(cu);
res += 1;
}
if (res == 0)
{
MessageBox.Show("保存失败！");
}
else
{
MessageBox.Show("保存成功！");
BindGridView();
}
}
/// <summary>
/// 插入
/// </summary>
/// <param name="mod"></param>
/// <returns></returns>
public int Insert(ConsumablesUseModel mod)
{
string Insert = string.Format("Insert into Mzjld_ConsumablesUse(MzjldId,PatId,Name,Dosage,Unit,IsCost,Price,UseTime) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}') "
, mod.MzjldId, mod.PatId, mod.Name, mod.Dosage, mod.Unit, mod.IsCost, mod.Price, mod.UseTime);
return(dBConn.ExecuteNonQuery(Insert));
}
private void BindGridView()
{
DataTable dt = dal.GetByMzjldId(MzjldId);
if (dt.Rows.Count == 0)
{
DataTable dtCon = dal.GetConsumablesAll();
foreach (DataRow dr in dtCon.Rows)
{
ConsumablesUseModel cu = new ConsumablesUseModel();
cu.MzjldId = MzjldId;
cu.PatId = PatId;
cu.Name = Convert.ToString(dr["Name"]);
cu.Dosage = 0;
cu.Price = UserFunction.ToDouble(dr["Price"]);
cu.Unit = Convert.ToString(dr["Unit"]);
cu.IsCost = 1;
dal.Insert(cu);
}
dt = dal.GetByMzjldId(MzjldId);
this.dgvUseList.DataSource = dt;
}
else
{
this.dgvUseList.DataSource = dt;
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="QXName"></param>
/// <param name="XGName"></param>
/// <returns></returns>
public int Update(ConsumablesUseModel mod)
{
string update = @"update Mzjld_ConsumablesUse set "
+ " Name='" + mod.Name + "',Dosage='" + mod.Dosage + "',"
+ " Unit='" + mod.Unit + "',Price='" + mod.Price + "',IsCost='" + mod.IsCost + "'"
+ " where Id='" + mod.Id + "'";
return(dBConn.ExecuteNonQuery(string.Format(update)));
}
