public int AddRequInfo([FromForm] RequisitionInfo m)
{
m.CreateDate = DateTime.Now;
int flag = _IRequBLL.AddRequ(m);
return(flag);
}
public int AddRequ(RequisitionInfo m)
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter {
ParameterName = "@CreateDate", SqlDbType = SqlDbType.DateTime, Value = m.CreateDate, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@DhAddress", SqlDbType = SqlDbType.VarChar, Value = m.DhAddress, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@QgName", SqlDbType = SqlDbType.VarChar, Value = m.QgName, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@DeptName", SqlDbType = SqlDbType.VarChar, Value = m.DeptName, Direction = ParameterDirection.Input
},
};
return(_dBHelper.ExecuteNonQueryProc("AddRequ", param));
}
public int UpdateRequ(RequisitionInfo m)
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter {
ParameterName = "@DhAddress", SqlDbType = SqlDbType.VarChar, Value = m.DhAddress, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@QgName", SqlDbType = SqlDbType.VarChar, Value = m.QgName, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@DeptName", SqlDbType = SqlDbType.VarChar, Value = m.DeptName, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@QId", SqlDbType = SqlDbType.UniqueIdentifier, Value = m.QId, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@QGId", SqlDbType = SqlDbType.UniqueIdentifier, Value = m.QgId, Direction = ParameterDirection.Input
}
};
return(_dBHelper.ExecuteNonQueryProc("UpdRequInfo", param));
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
RequisitionInfo rinfo = new RequisitionInfo();
foreach (var item in (List <Items>)itemList.ToList())
{
rinfo.RequisitionNo = requisitionNo;
rinfo.ItemName = item.ItemName;
rinfo.Quantity = item.Quantity;
rinfo.Description = item.Description;
rinfo.UnitPrice = item.UnitPrice;
rinfo.TotalPrice = item.TotalPrice;
rinfo.Date = Convert.ToDateTime(item.Date);
rinfo.UserId = item.UserId;
rinfo.TotalRequisition = Convert.ToDecimal(lblSubtotal.Text);
db.RequisitionInfoes.Add(rinfo);
db.SaveChanges();
ScriptManager.RegisterStartupScript(this, GetType(), "",
"alert('Requisition Confirmed');location.href='MakeRequisition.aspx'", true);
itemList.Clear();
}
}
//修改请购单信息
public int UpdateRequ(RequisitionInfo m)
{
return(_IRequDal.UpdateRequ(m));
}
//添加请购单信息
public int AddRequ(RequisitionInfo m)
{
return(_IRequDal.AddRequ(m));
}
public int UpdateRequ([FromForm] RequisitionInfo m)
{
int flag = _IRequBLL.UpdateRequ(m);
return(flag);
}
