public int AddOutStorage([FromForm] tb_OutStorage model) { string osNo = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString(); model.OStorageNo = "CK" + osNo; model.DBMan = "李四"; model.OutState = 2; return(_oStorageManage.AddOutStorage(model)); }
public int AddOutStorage(tb_OutStorage model) { string procName = "proc_AddOutStorage"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter { ParameterName = "@OutTime", DbType = DbType.Date, Direction = ParameterDirection.Input, Value = model.OutTime }, new SqlParameter { ParameterName = "@OrderNo", DbType = DbType.String, Direction = ParameterDirection.Input, Value = model.OrderNo }, new SqlParameter { ParameterName = "@OStorageNo", DbType = DbType.String, Direction = ParameterDirection.Input, Value = model.OStorageNo }, new SqlParameter { ParameterName = "@DispatchingId", DbType = DbType.String, Direction = ParameterDirection.Input, Value = model.DispatchingId }, new SqlParameter { ParameterName = "@Consignee", DbType = DbType.String, Direction = ParameterDirection.Input, Value = model.Consignee }, new SqlParameter { ParameterName = "@CPhoneNum", DbType = DbType.String, Direction = ParameterDirection.Input, Value = model.CPhoneNum }, new SqlParameter { ParameterName = "@DispatchingArea", DbType = DbType.String, Direction = ParameterDirection.Input, Value = model.DispatchingArea }, new SqlParameter { ParameterName = "@OutStorageId", DbType = DbType.String, Direction = ParameterDirection.Input, Value = model.OutStorageId }, new SqlParameter { ParameterName = "@DBMan", DbType = DbType.String, Direction = ParameterDirection.Input, Value = model.DBMan }, new SqlParameter { ParameterName = "@OutState", DbType = DbType.Int32, Direction = ParameterDirection.Input, Value = model.OutState }, }; return(_helper.ExecuteNonQueryProc(procName, sqlParameters)); }