public int AddPur(PurChaseInfo m) { SqlParameter[] param = new SqlParameter[] { new SqlParameter { ParameterName = "@CreateTime", SqlDbType = SqlDbType.DateTime, Value = m.CreateTime, Direction = ParameterDirection.Input }, new SqlParameter { ParameterName = "@QID", SqlDbType = SqlDbType.UniqueIdentifier, Value = m.QID, Direction = ParameterDirection.Input }, new SqlParameter { ParameterName = "@GysId", SqlDbType = SqlDbType.UniqueIdentifier, Value = m.GysId, Direction = ParameterDirection.Input }, new SqlParameter { ParameterName = "@IsShui", SqlDbType = SqlDbType.Int, Value = m.IsShui, Direction = ParameterDirection.Input }, new SqlParameter { ParameterName = "@ShuiLv", SqlDbType = SqlDbType.VarChar, Value = m.ShuiLv, Direction = ParameterDirection.Input }, new SqlParameter { ParameterName = "@Address", SqlDbType = SqlDbType.VarChar, Value = m.Address, Direction = ParameterDirection.Input }, new SqlParameter { ParameterName = "@BgName", SqlDbType = SqlDbType.VarChar, Value = m.BgName, Direction = ParameterDirection.Input }, new SqlParameter { ParameterName = "@BgDept", SqlDbType = SqlDbType.VarChar, Value = m.BgDept, Direction = ParameterDirection.Input } }; return(_dBHelper.ExecuteNonQueryProc("AddPur", param)); }
public int AddPur([FromForm] PurChaseInfo m) { m.CreateTime = DateTime.Now; int flag = _IRequBLL.AddPur(m); return(flag); }
public int UpdatePurInfo(PurChaseInfo m) { SqlParameter[] param = new SqlParameter[] { new SqlParameter { ParameterName = "@ID", SqlDbType = SqlDbType.UniqueIdentifier, Value = m.ID, Direction = ParameterDirection.Input }, new SqlParameter { ParameterName = "@IsShui", SqlDbType = SqlDbType.Int, Value = m.IsShui, Direction = ParameterDirection.Input }, new SqlParameter { ParameterName = "@ShuiLv", SqlDbType = SqlDbType.VarChar, Value = m.ShuiLv, Direction = ParameterDirection.Input }, new SqlParameter { ParameterName = "@Address", SqlDbType = SqlDbType.VarChar, Value = m.Address, Direction = ParameterDirection.Input }, new SqlParameter { ParameterName = "@BgName", SqlDbType = SqlDbType.VarChar, Value = m.BgName, Direction = ParameterDirection.Input }, new SqlParameter { ParameterName = "@BgDept", SqlDbType = SqlDbType.VarChar, Value = m.BgDept, Direction = ParameterDirection.Input } }; return(_dBHelper.ExecuteNonQueryProc("UpdatePueInfo", param)); }
//修改采购单信息 public int UpdatePurInfo(PurChaseInfo m) { return(_IRequDal.UpdatePurInfo(m)); }
//添加采购单信息 public int AddPur(PurChaseInfo m) { return(_IRequDal.AddPur(m)); }
public int UpdatePurInfo([FromForm] PurChaseInfo m) { int flag = _IRequBLL.UpdatePurInfo(m); return(flag); }