public ResResultModel SaveMesOrder(MesOrderModel model) { try { if (model == null) { return(ResResult.Response(false, MC.Request_Params_InvalidError, "")); } var bll = new MesOrder(); var effect = 0; var oldModel = bll.GetModel(model.OBarcode, model.PBarcode, model.PdBarcode, model.PtBarcode); if (oldModel != null) { oldModel.Qty += model.Qty; effect = bll.Update(oldModel); } else { var currTime = DateTime.Now; var modelInfo = new MesOrderInfo(Guid.Empty, WebCommon.GetUserId(), model.OBarcode, model.PBarcode, model.PdBarcode, model.PtBarcode, model.Qty, currTime, currTime, 0, "", currTime); effect = bll.Insert(modelInfo); } return(ResResult.Response(true, MC.M_Save_Ok, "")); } catch (Exception ex) { return(ResResult.Response(false, ex.Message, "")); } }
public IList <MesOrderInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select count(*) from MesOrder "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), cmdParms); if (totalRecords == 0) { return(new List <MesOrderInfo>()); } sb.Clear(); int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; sb.Append(@"select * from(select row_number() over(order by Sort) as RowNumber, Id,UserId,OBarcode,PBarcode,PdBarcode,PtBarcode,Qty,StartDate,EndDate,Sort,Remark,LastUpdatedDate from MesOrder " ); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <MesOrderInfo> list = new List <MesOrderInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { MesOrderInfo model = new MesOrderInfo(); model.Id = reader.GetGuid(1); model.UserId = reader.GetGuid(2); model.OBarcode = reader.GetString(3); model.PBarcode = reader.GetString(4); model.PdBarcode = reader.GetString(5); model.PtBarcode = reader.GetString(6); model.Qty = reader.GetDouble(7); model.StartDate = reader.GetDateTime(8); model.EndDate = reader.GetDateTime(9); model.Sort = reader.GetInt32(10); model.Remark = reader.GetString(11); model.LastUpdatedDate = reader.GetDateTime(12); list.Add(model); } } } return(list); }
public MesOrderInfo GetModel(string oBarcode, string pBarcode, string pdBarcode, string ptBarcode) { MesOrderInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 Id,UserId,OBarcode,PBarcode,PdBarcode,PtBarcode,Qty,StartDate,EndDate,Sort,Remark,LastUpdatedDate from MesOrder where OBarcode = @OBarcode and PBarcode = @PBarcode and PdBarcode = @PdBarcode and PtBarcode = @PtBarcode " ); SqlParameter[] parms = { new SqlParameter("@OBarcode", SqlDbType.VarChar, 36), new SqlParameter("@PBarcode", SqlDbType.VarChar, 36), new SqlParameter("@PdBarcode", SqlDbType.VarChar, 36), new SqlParameter("@PtBarcode", SqlDbType.VarChar, 36) }; parms[0].Value = oBarcode; parms[1].Value = pBarcode; parms[2].Value = pdBarcode; parms[3].Value = ptBarcode; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), parms)) { if (reader != null) { if (reader.Read()) { model = new MesOrderInfo(); model.Id = reader.GetGuid(0); model.UserId = reader.GetGuid(1); model.OBarcode = reader.GetString(2); model.PBarcode = reader.GetString(3); model.PdBarcode = reader.GetString(4); model.PtBarcode = reader.GetString(5); model.Qty = reader.GetDouble(6); model.StartDate = reader.GetDateTime(7); model.EndDate = reader.GetDateTime(8); model.Sort = reader.GetInt32(9); model.Remark = reader.GetString(10); model.LastUpdatedDate = reader.GetDateTime(11); } } } return(model); }
public IList <MesOrderInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select Id,UserId,OBarcode,PBarcode,PdBarcode,PtBarcode,Qty,StartDate,EndDate,Sort,Remark,LastUpdatedDate from MesOrder "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.Append("order by Sort "); IList <MesOrderInfo> list = new List <MesOrderInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { MesOrderInfo model = new MesOrderInfo(); model.Id = reader.GetGuid(0); model.UserId = reader.GetGuid(1); model.OBarcode = reader.GetString(2); model.PBarcode = reader.GetString(3); model.PdBarcode = reader.GetString(4); model.PtBarcode = reader.GetString(5); model.Qty = reader.GetDouble(6); model.StartDate = reader.GetDateTime(7); model.EndDate = reader.GetDateTime(8); model.Sort = reader.GetInt32(9); model.Remark = reader.GetString(10); model.LastUpdatedDate = reader.GetDateTime(11); list.Add(model); } } } return(list); }
public MesOrderInfo GetModel(Guid id) { MesOrderInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 Id,UserId,OBarcode,PBarcode,PdBarcode,PtBarcode,Qty,StartDate,EndDate,Sort,Remark,LastUpdatedDate from MesOrder where Id = @Id " ); SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier) }; parms[0].Value = id; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), parms)) { if (reader != null) { if (reader.Read()) { model = new MesOrderInfo(); model.Id = reader.GetGuid(0); model.UserId = reader.GetGuid(1); model.OBarcode = reader.GetString(2); model.PBarcode = reader.GetString(3); model.PdBarcode = reader.GetString(4); model.PtBarcode = reader.GetString(5); model.Qty = reader.GetDouble(6); model.StartDate = reader.GetDateTime(7); model.EndDate = reader.GetDateTime(8); model.Sort = reader.GetInt32(9); model.Remark = reader.GetString(10); model.LastUpdatedDate = reader.GetDateTime(11); } } } return(model); }
public int InsertByOutput(MesOrderInfo model) { StringBuilder sb = new StringBuilder(300); sb.Append(@"insert into MesOrder (Id,UserId,OBarcode,PBarcode,PdBarcode,PtBarcode,Qty,StartDate,EndDate,Sort,Remark,LastUpdatedDate) values (@Id,@UserId,@OBarcode,@PBarcode,@PdBarcode,@PtBarcode,@Qty,@StartDate,@EndDate,@Sort,@Remark,@LastUpdatedDate) " ); SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier), new SqlParameter("@UserId", SqlDbType.UniqueIdentifier), new SqlParameter("@OBarcode", SqlDbType.VarChar, 36), new SqlParameter("@PBarcode", SqlDbType.VarChar, 36), new SqlParameter("@PdBarcode", SqlDbType.VarChar, 36), new SqlParameter("@PtBarcode", SqlDbType.VarChar, 36), new SqlParameter("@Qty", SqlDbType.Float), new SqlParameter("@StartDate", SqlDbType.DateTime), new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@Sort", SqlDbType.Int), new SqlParameter("@Remark", SqlDbType.NVarChar, 100), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; parms[0].Value = model.Id; parms[1].Value = model.UserId; parms[2].Value = model.OBarcode; parms[3].Value = model.PBarcode; parms[4].Value = model.PdBarcode; parms[5].Value = model.PtBarcode; parms[6].Value = model.Qty; parms[7].Value = model.StartDate; parms[8].Value = model.EndDate; parms[9].Value = model.Sort; parms[10].Value = model.Remark; parms[11].Value = model.LastUpdatedDate; return(SqlHelper.ExecuteNonQuery(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), parms)); }
public IList <MesOrderInfo> GetList() { StringBuilder sb = new StringBuilder(300); sb.Append(@"select Id,UserId,OBarcode,PBarcode,PdBarcode,PtBarcode,Qty,StartDate,EndDate,Sort,Remark,LastUpdatedDate from MesOrder order by Sort " ); IList <MesOrderInfo> list = new List <MesOrderInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString())) { if (reader != null && reader.HasRows) { while (reader.Read()) { MesOrderInfo model = new MesOrderInfo(); model.Id = reader.GetGuid(0); model.UserId = reader.GetGuid(1); model.OBarcode = reader.GetString(2); model.PBarcode = reader.GetString(3); model.PdBarcode = reader.GetString(4); model.PtBarcode = reader.GetString(5); model.Qty = reader.GetDouble(6); model.StartDate = reader.GetDateTime(7); model.EndDate = reader.GetDateTime(8); model.Sort = reader.GetInt32(9); model.Remark = reader.GetString(10); model.LastUpdatedDate = reader.GetDateTime(11); list.Add(model); } } } return(list); }
public int Update(MesOrderInfo model) { return(dal.Update(model)); }
public int InsertByOutput(MesOrderInfo model) { return(dal.InsertByOutput(model)); }