//导出数据 protected void Button1_Click(object sender, EventArgs e) { string PacTime1 = PacTime.Value; string Fpactate1 = Fpactate.Value; string Pacpersonnel1 = Pacpersonnel.Value; if (PacTime1 == "") { PacTime1 = "0"; } if (Pacpersonnel1 == "") { Pacpersonnel1 = "0"; } PackingModel rm = new PackingModel(); // DataBaseLayer db = new DataBaseLayer(); // string str = "select * from lossiInfor where type ='" + type + "'"; DataTable dt = rm.findPackingInfoDao(Fpactate1, Pacpersonnel1, PacTime1); System.DateTime currentTime = new System.DateTime(); currentTime = System.DateTime.Now; string now = currentTime.ToString("yyyyMMdd"); CreateExcel(dt, "application/ms-excel", "包装管理" + now); }
public async Task <int> UpdateAsync(int id, PackingModel model) { using (var transaction = dbContext.Database.BeginTransaction()) { try { await packingLogic.UpdateModelAsync(id, model); var row = await dbContext.SaveChangesAsync(); //if (row > 0) //{ // await CreateProduct(model); //} transaction.Commit(); return(row); } catch (Exception ex) { transaction.Rollback(); throw ex; } } }
public List <PackingModel> GetPackings() { try { List <PackingModel> md = new List <PackingModel>(); var data = _tRSEntities.PackingMasters.ToList(); foreach (var item in data) { PackingModel pd = new PackingModel { id = item.id, article = item.article, item = item.item, actualWeight1 = item.actualWeight, packingType = item.packingType }; md.Add(pd); } return(md); } catch (Exception e) { throw e; } }
public async Task <IActionResult> PostPacking([FromBody] PackingModel packings) { try { service.Username = User.Claims.Single(p => p.Type.Equals("username")).Value; bool success = await service.CreateProduct(packings); if (success) { Dictionary <string, object> Result = new ResultFormatter(ApiVersion, General.CREATED_STATUS_CODE, General.OK_MESSAGE) .Ok(); return(NoContent()); } else { Dictionary <string, object> Result = new ResultFormatter(ApiVersion, General.INTERNAL_ERROR_STATUS_CODE, "Failed to create product!") .Fail(); return(StatusCode(General.INTERNAL_ERROR_STATUS_CODE, Result)); } } catch (Exception e) { Dictionary <string, object> Result = new ResultFormatter(ApiVersion, General.INTERNAL_ERROR_STATUS_CODE, e.Message) .Fail(); return(StatusCode(General.INTERNAL_ERROR_STATUS_CODE, Result)); } }
public async Task <int> CreateAsync(PackingModel model) { using (var transaction = dbContext.Database.BeginTransaction()) { try { do { model.Code = CodeGenerator.Generate(); }while (dbSet.Any(d => d.Code.Equals(model.Code))); packingLogic.CreateModel(model); var row = await dbContext.SaveChangesAsync(); if (row > 0) { await CreateProduct(model); } transaction.Commit(); return(row); } catch (Exception ex) { transaction.Rollback(); throw ex; } } }
public async Task CreateProduct(PackingModel model) { var client = (IHttpClientService)ServiceProvider.GetService(typeof(IHttpClientService)); var uri = string.Format("{0}{1}", Utilities.APIEndpoint.Core, "master/products/packing/create"); var myContentJson = JsonConvert.SerializeObject(model); var myContent = new StringContent(myContentJson, Encoding.UTF8, "application/json"); var response = await client.PostAsync(uri, myContent); response.EnsureSuccessStatusCode(); }
private PackingReceiptModel GetPackingReceipt(PackingModel packingModel) { return(new PackingReceiptModel() { PackingId = packingModel.Id, Items = new List <PackingReceiptItem>() { new PackingReceiptItem() } }); }
public async Task <int> CreateAsync(PackingModel model) { do { model.Code = CodeGenerator.Generate(); }while (dbSet.Any(d => d.Code.Equals(model.Code))); packingLogic.CreateModel(model); var row = await dbContext.SaveChangesAsync(); if (row > 0) { await packingLogic.CreateProduct(model); } return(row); }
public bool SavePacking(PackingModel model) { try { PackingMaster ms = new PackingMaster(); ms.article = model.article; ms.item = model.item; ms.actualWeight = model.actualWeight1; ms.packingType = model.packingType; _tRSEntities.SaveChanges(); return(true); } catch (Exception e) { throw e; } }
public static bool deletePackingById(string strRowIds) { int a = 0; bool result; string[] strRows1Id = strRowIds.Split(','); for (int i = 0; i < strRows1Id.Length; i++) { PackingModel rm = new PackingModel(); a = rm.deletePackingInfo(Convert.ToInt16(strRows1Id[i])); } if (a == 0) { result = false; } else { result = true; } return(result); }
public async Task <int> UpdateAsync(int id, PackingModel model) { packingLogic.UpdateModelAsync(id, model); return(await dbContext.SaveChangesAsync()); }
public BookingModel GetBooking(int id) { try { List <PackingModel> packingModels = new List <PackingModel>(); var check = _tRSEntities.BookingMasters.Where(x => x.id == id && x.isActive == true).FirstOrDefault(); if (check != null) { BookingModel model = new BookingModel(); model.cn = check.cn; model.expectedDelivery = check.expectedDelivery; model.from = check.from; var from = _tRSEntities.BranchMasters.Where(x => x.id == model.from).FirstOrDefault(); if (from != null) { model.fromName = from.branchCode; } model.to = check.to; var to = _tRSEntities.BranchMasters.Where(x => x.id == model.to).FirstOrDefault(); if (to != null) { model.toName = to.branchCode; } model.godownNo = check.godownNo; var godownName = _tRSEntities.GodownMasters.Where(x => x.id == check.godownNo).FirstOrDefault(); if (godownName != null) { model.godownName = godownName.godownName; } model.paymentType = check.paymentType; model.actualWeight = check.actualWeight; model.consignee = check.consignee; var consigneeName = _tRSEntities.RegularClientMasters.Where(x => x.id == check.consignee).FirstOrDefault(); if (consigneeName != null) { model.consigneeName = consigneeName.clientCode; } //third day model.cnNo = check.cnNo; model.deliveryBranch = check.deliveryBranch; var deliveryBranchName = _tRSEntities.BranchMasters.Where(x => x.id == check.deliveryBranch).FirstOrDefault(); if (deliveryBranchName != null) { model.deliveryBranchName = deliveryBranchName.deliveryAgainstAs; } model.virtualGoddownNo = check.virtualGoddownNo; var virtualGoddownName = _tRSEntities.VirtualGodownMasters.Where(x => x.id == check.virtualGoddownNo).FirstOrDefault(); if (virtualGoddownName != null) { model.virtualGoddownName = virtualGoddownName.virtualGodownCode; } model.consignorDetails = check.consignorDetails; model.consignor = check.consignor; var consignorName = _tRSEntities.RegularClientMasters.Where(x => x.id == check.consignor).FirstOrDefault(); if (consignorName != null) { model.consignorName = consignorName.gstIN; } model.agentName = check.agentName; var clientName = _tRSEntities.RegularClientMasters.Where(x => x.id == check.agentName).FirstOrDefault(); if (clientName != null) { model.clientName = clientName.clientName; } model.agentDetails = check.agentDetails; model.bookingType = check.bookingType; model.deliveryType = check.deliveryType; model.modeOfTransport = check.modeOfTransport; model.invoiceNo = check.invoiceNo; model.invoiceValue = check.invoiceValue; model.consignorInvoice = check.consignorInvoice; model.freightBasis = check.freightBasis; model.ftl = check.ftl; model.isCcAttached = check.isCcAttached; model.isCod = check.isCod; model.chargeWeight = check.chargeWeight; model.freightRate = check.freightRate; model.privateMark = check.privateMark; model.insuredBy = check.insuredBy; model.freight = check.freight; model.surcharge = check.surcharge; model.hamaliCharge = check.hamaliCharge; model.localCartages = check.localCartages; model.doorDeliveryCharge = check.doorDeliveryCharge; model.statisticalCharges = check.statisticalCharges; model.miscellaneousCharges = check.miscellaneousCharges; model.godownCharges = check.godownCharges; model.cod = check.cod; model.riskCharge = check.riskCharge; model.branch = check.branch; model.reserveReason = check.reserveReason; model.cnFrom = check.cnFrom; model.cnTo = check.cnTo; model.srtoNo = check.srtoNo; model.lotNo = check.lotNo; model.rollNo = check.rollNo; model.meter = check.meter; model.weightInKg = check.weightInKg; var findPacketBooking = _tRSEntities.PackingMasters.Where(x => x.bookingId == id && x.isActive == true).ToList(); foreach (var item in findPacketBooking) { PackingModel pm = new PackingModel(); pm.id = item.id; pm.article = item.article; pm.actualWeight1 = item.actualWeight; pm.packingType = item.packingType; packingModels.Add(pm); } model.singleCn = packingModels; return(model); } else { return(null); } } catch (Exception e) { throw e; } }
public IHttpActionResult SavePacking(PackingModel model) { var data = packing.SavePacking(model); return(Ok(data)); }
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid1DataHandler(dotNetFlexGrid.DataHandlerParams p) { dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult(); result.page = p.page; //设定当前返回的页号 result.total = 100; //总计的数据条数,此处用100进行模拟,查询和筛选时需要根据实际 PackingModel rm = new PackingModel(); string Fpactate = "0"; if (p.extParam.ContainsKey("Fpactate")) { Fpactate = p.extParam["Fpactate"]; } string Pacpersonnel = "0"; if (p.extParam.ContainsKey("Pacpersonnel")) { Pacpersonnel = p.extParam["Pacpersonnel"]; } string PacTime = "0"; if (p.extParam.ContainsKey("PacTime")) { PacTime = p.extParam["PacTime"]; } string StartTime = "0"; if (p.extParam.ContainsKey("StartTime")) { StartTime = p.extParam["StartTime"]; } if (PacTime == "") { PacTime = "0"; } if (Pacpersonnel == "") { Pacpersonnel = "0"; } if (StartTime == "") { StartTime = "0"; } dotNetFlexGrid.FieldFormatorHandle proc1 = delegate(DataRow dr) { if (dr["warningstatus"].ToString() == "1") { return("<span style='color:red'>黄色预警</span>"); } else { return("<span style='color:black'>暂无预警</span>"); } }; result.FieldFormator.Register("warningstatus", proc1); result.table = rm.findPackingInfo(Fpactate, Pacpersonnel, PacTime, StartTime); dotNetFlexGrid.FieldFormatorHandle proc2 = delegate(DataRow dr) { int bstatus = Convert.ToInt32(dr["Fpactate"].ToString()); if (bstatus == 1) { return("包装完成"); } else { return("开始包装"); } }; result.FieldFormator.Register("Fpactate", proc2); return(result); }
public async Task <bool> CreateProduct(PackingModel packings) { var productNames = (from packingDetail in packings.PackingDetails select string.Format("{0}/{1}/{2}/{3}/{4}/{5}", packings.ProductionOrderNo, packings.ColorName, packings.Construction, packingDetail.Lot, packingDetail.Grade, packingDetail.Length) + (string.IsNullOrWhiteSpace(packingDetail.Remark) ? "" : string.Format("/{0}", packingDetail.Remark))) .Except((from product in DbSet where product._IsDeleted == false select product.Name)); if (productNames.Count() > 0) { var uomId = (from uom in DbContext.UnitOfMeasurements where uom.Unit == packings.PackingUom && uom._IsDeleted == false select uom.Id).FirstOrDefault(); if (uomId == 0) { Uom uom = new Uom { Active = true, Unit = packings.PackingUom, _IsDeleted = false, _CreatedBy = this.Username, _CreatedUtc = DateTimeOffset.Now.DateTime, _CreatedAgent = UserAgent }; await DbContext.UnitOfMeasurements.AddAsync(uom); await DbContext.SaveChangesAsync(); uomId = uom.Id; } var tags = string.Format("sales contract #{0}", packings.SalesContractNo); CodeGenerator codeGenerator = new CodeGenerator(); IEnumerable <Product> products = from packingDetail in packings.PackingDetails where productNames.Contains(string.Format("{0}/{1}/{2}/{3}/{4}/{5}", packings.ProductionOrderNo, packings.ColorName, packings.Construction, packingDetail.Lot, packingDetail.Grade, packingDetail.Length) + (string.IsNullOrWhiteSpace(packingDetail.Remark) ? "" : string.Format("/{0}", packingDetail.Remark))) select new Product { Active = true, Code = codeGenerator.GenerateCode(), Name = string.Format("{0}/{1}/{2}/{3}/{4}/{5}", packings.ProductionOrderNo, packings.ColorName, packings.Construction, packingDetail.Lot, packingDetail.Grade, packingDetail.Length) + (string.IsNullOrWhiteSpace(packingDetail.Remark) ? "" : string.Format("/{0}", packingDetail.Remark)), UomId = uomId, UomUnit = packings.PackingUom, Tags = tags, SPPProperties = new ProductSPPProperty() { ProductionOrderId = packings.ProductionOrderId, ProductionOrderNo = packings.ProductionOrderNo, DesignCode = packings.DesignCode, DesignNumber = packings.DesignNumber, OrderTypeId = packings.OrderTypeId, OrderTypeCode = packings.OrderTypeCode, OrderTypeName = packings.OrderTypeName, BuyerId = packings.BuyerId, BuyerName = packings.BuyerName, BuyerAddress = packings.BuyerAddress, ColorName = packings.ColorName, Construction = packings.Construction, Lot = packingDetail.Lot, Grade = packingDetail.Grade, Weight = packingDetail.Weight, Length = packingDetail.Length }, _IsDeleted = false, _CreatedBy = this.Username, _CreatedUtc = DateTimeOffset.Now.DateTime, _CreatedAgent = UserAgent }; await DbContext.AddRangeAsync(products); var rowAffected = await DbContext.SaveChangesAsync(); if (rowAffected > 0) { return(true); } } else { return(true); } return(false); }
public PackingPdfTemplate(PackingModel model, int timeoffset) { #region Data Preparation var OrderType = ((model.OrderTypeName ?? string.Empty) == PRINTING) ? PRINTING : FINISHING; #region Header IEnumerable <string> headerLefts = new List <string> { HEADER_LEFT_1, string.Format("{0} {1}", HEADER_LEFT_2, OrderType) }; List <string> headerRights1 = new List <string> { HEADER_RIGHT_1, HEADER_RIGHT_2 }; List <string> headerRights2 = new List <string> { string.Format("{0} {1}", SPLITTER, model.Code), string.Format("{0} {1}", SPLITTER, model.ProductionOrderNo) }; #endregion #region Body IEnumerable <string> bodyColumn = new List <string> { "Barang", string.Format("Jumlah ({0})", model.PackingUom), "Panjang (Meter)", "Panjang Total (Meter)", "Berat Total (Kg)", "Keterangan" }; List <List <string> > bodyData = new List <List <string> > { model.PackingDetails.Select(m => string.Format("{0} {1} {2} {3}", model.ColorName, m.Lot, m.Grade, (m.Grade.ToLower() == "a" ? "BQ" : "BS"))).ToList(), model.PackingDetails.Select(m => m.Quantity.ToString("#,#", CultureInfo.InvariantCulture)).ToList(), model.PackingDetails.Select(m => m.Length.ToString("#,#", CultureInfo.InvariantCulture)).ToList(), model.PackingDetails.Select(m => (m.Quantity * m.Length).ToString("#,#", CultureInfo.InvariantCulture)).ToList(), model.PackingDetails.Select(m => (m.Quantity * m.Weight).ToString("#,#", CultureInfo.InvariantCulture)).ToList(), model.PackingDetails.Select(m => m.Remark).ToList() }; IEnumerable <string> totalData = new List <string> { model.PackingDetails.Select(m => m.Quantity).Sum().ToString("#,#", CultureInfo.InvariantCulture), model.PackingDetails.Select(m => m.Length).Sum().ToString("#,#", CultureInfo.InvariantCulture), model.PackingDetails.Select(m => (m.Quantity * m.Length)).Sum().ToString("#,#", CultureInfo.InvariantCulture), model.PackingDetails.Select(m => (m.Quantity * m.Weight)).Sum().ToString("#,#", CultureInfo.InvariantCulture) }; #endregion #region Body Footer List <string> footerHeaders = new List <string>(); List <string> footerValues = new List <string>(); if (model.OrderTypeName.ToLowerInvariant() == SOLID.ToLower()) { footerHeaders = new List <string> { BUYER, ORDER_TYPE, COLOUR_TYPE, CONSTRUCTION, DESTINATION }; footerValues = new List <string> { model.BuyerName, OrderType, model.ColorType, model.Construction, model.BuyerAddress }; } else if (model.OrderTypeName.ToLowerInvariant() == PRINTING.ToLower()) { footerHeaders = new List <string> { BUYER, ORDER_TYPE, CONSTRUCTION, DESIGN_PATTERN, DESTINATION }; footerValues = new List <string> { model.BuyerName, OrderType, model.Construction, string.IsNullOrWhiteSpace(model.DesignNumber) && string.IsNullOrWhiteSpace(model.DesignCode) ? string.Format("{0} - {1}", model.DesignNumber, model.DesignCode) : string.Empty, model.BuyerAddress }; } else { footerHeaders = new List <string> { BUYER, ORDER_TYPE, CONSTRUCTION, DESTINATION }; footerValues = new List <string> { model.BuyerName, OrderType, model.Construction, model.BuyerAddress }; } #endregion #endregion this.Title = this.GetTitle(); this.Header = this.GetHeader(headerLefts, headerRights1, headerRights2); this.Body = this.GetBody(bodyColumn, bodyData, totalData); this.BodyFooter = this.GetBodyFooter(footerHeaders, footerValues); this.Footer = this.GetFooter(model.Date.AddHours(timeoffset), model.CreatedBy); }
public async Task <bool> CreateProduct(PackingModel packings) { //DbContext.Database.SetCommandTimeout(1000 * 60 * 10); var packingProducts = packings.PackingDetails.Select(packingDetail => string.Format("{0}/{1}/{2}/{3}/{4}/{5}", packings.ProductionOrderNo, packings.ColorName, packings.Construction, packingDetail.Lot, packingDetail.Grade, packingDetail.Length) + (string.IsNullOrWhiteSpace(packingDetail.Remark) ? "" : string.Format("/{0}", packingDetail.Remark))).ToList(); //var productNames = (from packingDetail in packings.PackingDetails // select ) // .Except((from product in DbSet where product._IsDeleted == false select product.Name)); var uom = DbContext.UnitOfMeasurements.FirstOrDefault(f => f.Unit.Equals(packings.PackingUom)); if (uom == null) { uom = new Uom { Active = true, Unit = packings.PackingUom, _IsDeleted = false, _CreatedBy = this.Username, _CreatedUtc = DateTimeOffset.Now.DateTime, _CreatedAgent = UserAgent }; DbContext.UnitOfMeasurements.Add(uom); await DbContext.SaveChangesAsync(); //uomId = uom.Id; } var tags = string.Format("sales contract #{0}", packings.SalesContractNo); CodeGenerator codeGenerator = new CodeGenerator(); var listProductToCreate = new List <Product>(); foreach (var packingDetail in packings.PackingDetails) { var packingProduct = string.Format("{0}/{1}/{2}/{3}/{4}/{5}", packings.ProductionOrderNo, packings.ColorName, packings.Construction, packingDetail.Lot, packingDetail.Grade, packingDetail.Length) + (string.IsNullOrWhiteSpace(packingDetail.Remark) ? "" : string.Format("/{0}", packingDetail.Remark)); var existingProduct = DbContext.Products.FirstOrDefault(f => f.Name.Equals(packingProduct)); if (existingProduct == null) { var productToCreate = new Product() { Active = true, Code = codeGenerator.GenerateCode(), Name = packingProduct, UomId = uom.Id, UomUnit = packings.PackingUom, Tags = tags, SPPProperties = new ProductSPPProperty() { ProductionOrderId = packings.ProductionOrderId, ProductionOrderNo = packings.ProductionOrderNo, DesignCode = packings.DesignCode, DesignNumber = packings.DesignNumber, OrderTypeId = packings.OrderTypeId, OrderTypeCode = packings.OrderTypeCode, OrderTypeName = packings.OrderTypeName, BuyerId = packings.BuyerId, BuyerName = packings.BuyerName, BuyerAddress = packings.BuyerAddress, ColorName = packings.ColorName, Construction = packings.Construction, Lot = packingDetail.Lot, Grade = packingDetail.Grade, Weight = packingDetail.Weight, Length = packingDetail.Length }, _IsDeleted = false, _CreatedBy = this.Username, _CreatedUtc = DateTimeOffset.Now.DateTime, _CreatedAgent = UserAgent }; listProductToCreate.Add(productToCreate); } } if (listProductToCreate.Count > 0) { await DbContext.AddRangeAsync(listProductToCreate); } var rowAffected = await DbContext.SaveChangesAsync(); if (rowAffected > 0) { return(true); } else { return(true); } }
protected void Page_Load(object sender, EventArgs e) { String type = Request.QueryString["type"].ToString(); if ("save".Equals(type)) { try { string imgbase64 = Request.Form["imgbase64"]; //图片 string tisaneNum = Request.Form["tisaneNum"]; //煎药单号 string userNum = Request.Form["userNum"]; //员工号 string barcode = Request.Form["barcode"]; //条形码 string userName = Request.Form["userName"]; //员工姓名 string imgname = null; string nowDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); if (imgbase64 != null && imgbase64.Trim().Length > 0) { imgbase64 = imgbase64.Replace(' ', '+'); Byte[] bimg = Convert.FromBase64String(imgbase64); //D:\\项目\\煎药厂\\src\\web\\upload\\ String path = System.AppDomain.CurrentDomain.BaseDirectory.ToString() + "upload\\"; imgname = DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".png"; FileBinaryConvertHelper.Bytes2File(bimg, path + imgname); } PackingModel rm = new PackingModel(); DataTable dt = rm.findPackingBybarcode(tisaneNum); int result = 0; if (dt.Rows.Count > 0) { if ("1".Equals(dt.Rows[0]["Fpactate"].ToString())) { result = 0; } else { result = rm.updatePackinginfo(Convert.ToInt32(dt.Rows[0]["id"].ToString()), 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), tisaneNum); } } else { RecipeModel rem = new RecipeModel(); DataTable dtable = rem.findTisaneFinish(Convert.ToInt32(tisaneNum)); if (dtable.Rows.Count > 0) { result = rm.addPacking(Convert.ToInt32(userNum), nowDate, barcode, tisaneNum, imgname, userName); } } if (result > 0) { Response.Write("{\"code\":\"0\",\"msg\":\"操作成功\"}"); } else { Response.Write("{\"code\":\"1\",\"msg\":\"操作失败\"}"); } } catch (Exception e1) { Response.Write("{\"code\":\"1\",\"msg\":\"操作失败\"}"); } } else if ("get".Equals(type)) { String id = Request.QueryString["id"].ToString(); RecipeModel rm2 = new RecipeModel(); string warningid = rm2.getRetentionWarning(5); PackingModel rm = new PackingModel(); DataTable dataTable = rm.findPackingInfo(Convert.ToInt32(id), DateTime.Now.ToString("yyyy-MM-dd")); Response.Write("{\"code\":\"0\",\"msg\":\"操作成功\",\"data\":" + DataTableToJson.ToJson(dataTable) + ",\"warning\":\"" + warningid + "\"}"); } }