private void BindGrid() { var data = XMProductService.getProductByMinPriceUnSet(brandTypeId); StoreWorker.DataSource = data; StoreWorker.DataBind(); }
protected void btnExportProduct_Click(object sender, EventArgs e) { try { string fileName = string.Format("Exports_{0}_{1}.xls", DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss"), CommonHelper.GenerateRandomDigitCode(4)); string filePath = string.Format("{0}Upload\\Product\\{1}", HttpContext.Current.Request.PhysicalApplicationPath, fileName); //产品名称 string ProductName = this.txtProductName.Text.Trim(); //厂家编码 string FactoryCode = this.txtFactoryCode.Text.Trim(); //商品编码 string ProductCode = this.txtProductCode.Text.Trim(); int BrandTypeId = this.CCBrandTypeList.SelectedValue; List <XMProduct> list = XMProductService.GetXMProducts(BrandTypeId, ProductName, FactoryCode, ProductCode); ExportManager.ExportProductExcel(filePath, list); CommonHelper.WriteResponseXls(filePath, fileName); } catch (Exception exc) { ProcessException(exc); } }
private void BindGrid(int saleReturnID) { //绑定收款方式 var codeList = base.CodeService.GetCodeListInfoByCodeTypeID(228, false); this.ddlPayment.DataSource = codeList; this.ddlPayment.DataTextField = "CodeName"; this.ddlPayment.DataValueField = "CodeID"; this.ddlPayment.DataBind(); StringBuilder str = new StringBuilder(); str.Append("<table class='table' id='MyPurchaseProductList' style=\"width:100%\">"); str.Append("<tr >"); str.Append("<th>厂家编码</th><th>商品名称</th><th>尺寸规格</th><th>可退货数量</th><th>退货数量</th><th>单位</th><th>退货单价</th><th>退货金额</th><th>操作</th></tr>"); //绑定退货入库单主表和产品明细表 var saleReturn = base.XMSaleReturnService.GetXMSaleReturnById(saleReturnID); if (saleReturn != null) { lblRef.Text = saleReturn.Ref; var saleReturnDetails = base.XMSaleReturnProductDetailsService.GetXMSaleReturnProductDetailsListBySaleReturnID(saleReturnID); if (!string.IsNullOrEmpty(saleReturn.ProjectId.ToString())) { ddXMProject.Value = saleReturn.ProjectId.ToString(); } ddlPayment.SelectedValue = saleReturn.PaymentType.ToString(); this.BindddXMProject();//项目 if (saleReturn.ProjectId == -1) { ddXMProject.SelectedIndex = 0; } else { ddXMProject.Value = saleReturn.ProjectId.ToString(); } this.ddXMProject_SelectedIndexChanged(null, null);//店铺 ddlwareHouses.Value = saleReturn.WarehouseId.ToString(); txtNote.Text = saleReturn.Remarks; txtStorageDate.Value = saleReturn.BizDt.ToString() == "" ? DateTime.Now.ToShortDateString() : saleReturn.BizDt.ToString(); if (saleReturnDetails != null && saleReturnDetails.Count > 0) { foreach (XMSaleReturnProductDetails info in saleReturnDetails) { string PlatformMerchantCode = ""; int kSaleReturnCount = 0; if (info.DeliveryProductsDetailID != null && info.DeliveryProductsDetailID.ToString() != "") { //var deliveryp = base.XMSaleDeliveryProductDetailsService.GetXMSaleDeliveryProductDetailsById(info.DeliveryProductsDetailID.Value); //var applicationExchange = XMApplicationExchangeService.GetXMApplicationExchangeByID((int)info.DeliveryProductsDetailID); var product = XMProductService.GetXMProductById((int)info.ProductId); if (product != null) { PlatformMerchantCode = product.ManufacturersCode; //kSaleReturnCount = GetKReturnCount(deliveryp.SaleCount.Value, deliveryp.Id); } } str.Append("<tr id=\"mytr\">"); str.Append("<td id=\"PlatformMerchantCode\">" + PlatformMerchantCode + "</td><td id=\"ProductName\">" + info.ProductName + "</td><td>" + info.Specifications + "</td><td id=\"counts\"><input runat=\"server\" id=\"txtKCount\" class=\"TextBox\" style=\"text-align: left;width: 90%\" type=\"text\" value='" + kSaleReturnCount.ToString() + "' readonly=\"readonly\"/></td><td id=\"count\"><input runat=\"server\" id=\"txtProductCount\" class=\"TextBox\" style=\"text-align: left;width: 90%\" type=\"text\" value='" + info.RejectionProdcutsCount.ToString() + "' /></td><td>" + info.ProductUnit + "</td><td id=\"Price\">" + info.RejectionProductsPrice.ToString() + "</td><td id=\"ProductMoney\">" + info.RejectionsaleMoney.ToString() + "</td>"); str.Append("<td id=\"PID\"><input id=\"hiddPID\" type=\"hidden\" value='" + info.Id + "' /><input type=\"image\" name=\"setBarCode\" id=\"setBarCodes\" title=\"查看条形码\" src=\"../App_Themes/Blue/Image/ButtonImages/meeting.gif\" onclick=\"return ShowWindowDetail('查看商品条形码','" + CommonHelper.GetStoreLocation() + "ManageInventory/ProductBarCodeList.aspx?Status=SaleReturn&&ID=" + info.Id + "',400,600, this);\"/></td>"); str.Append("</tr>"); } } str.Append("</table>"); TableStr = str.ToString(); } }
protected void btnCalculate_Click(object sender, DirectEventArgs e) { string OrderID = CommonHelper.QueryString("ID"); XMOrderInfo entity_Order = XMOrderInfoService.GetXMOrderInfoByID(int.Parse(OrderID)); if (entity_Order == null) { ExtNet.Msg.Alert("提示", "订单信息不存在").Show(); return; } XMProject entity_Project = XMProjectService.GetXMProjectById(entity_Order.ProjectId); if (entity_Project == null) { ExtNet.Msg.Alert("提示", "项目信息不存在").Show(); return; } if (entity_Project.ProjectName == "曲美") { //干线费用 decimal mainMoney = 0; //支线费用 decimal branchMoney = 0; string province = entity_Order.Province; string city = entity_Order.City; string region = entity_Order.County; string[] mes = entity_Order.CustomerServiceRemark.Split(new string[] { "///" }, StringSplitOptions.RemoveEmptyEntries); if (mes.Count() <= 0) { ExtNet.Msg.Alert("提示", "解析错误").Show(); return; } string[] mes1 = mes[0].Split(new string[] { "+" }, StringSplitOptions.RemoveEmptyEntries); if (mes1.Count() <= 0) { ExtNet.Msg.Alert("提示", "解析错误").Show(); return; } //查询干线物流公司信息 List <CodeList> codeList = CodeService.GetCodeListInfoByCodeTypeIDAndCodeName(243, mes1[0]); if (codeList.Count <= 0) { ExtNet.Msg.Alert("提示", "找不到干线物流公司信息").Show(); return; } int logisticsMainID = codeList[0].CodeID; //查询干线物流单价费率 BusinessLogic.ManageProject.XMLogisticsFeeMain entityMain = XMLogisticsFeeMainService. getSingle(a => a.ProjectID == entity_Project.Id && a.WareHouseID == 758 && province.StartsWith(a.Province) && city.StartsWith(a.City) && region.StartsWith(a.Area) && a.LogisticsID == logisticsMainID); if (entityMain == null) { ExtNet.Msg.Alert("提示", "找不到对应干线单价费率").Show(); return; } //只计算干线费用 if (mes1.Count() == 1) { //对应干线单价费率 decimal main = (decimal)entityMain.Fee; List <XMOrderInfoProductDetails> list_OrderProductDetails = XMOrderInfoProductDetailsService.GetXMOrderInfoProductDetailsList(entity_Order.ID); foreach (var item in list_OrderProductDetails) { string ProductVolume = string.IsNullOrEmpty(item.ProductVolume) ? "0" : item.ProductVolume; mainMoney = mainMoney + main * decimal.Parse(ProductVolume) * (int)item.ProductNum; } } //计算干线和支线费用 else if (mes1.Count() == 2) { //对应干线单价费率 decimal main = (decimal)entityMain.Fee; //查询支线物流公司信息 List <CodeList> codeList1 = CodeService.GetCodeListInfoByCodeTypeIDAndCodeName(244, mes1[1]); if (codeList.Count <= 0) { ExtNet.Msg.Alert("提示", "找不到支线物流公司信息").Show(); return; } List <XMOrderInfoProductDetails> list_OrderProductDetails = XMOrderInfoProductDetailsService.GetXMOrderInfoProductDetailsList(entity_Order.ID); foreach (var item in list_OrderProductDetails) { //对应支线单价费率 decimal Branch = 0; XMProduct entityProduct = XMProductService.getXMProductByManufacturersCode(item.TManufacturersCode); XMProductDetails entityProductDetails = XMProductDetailsService.GetXMProductDetailsListByProductId(entityProduct.Id)[0]; //查询支线物流单价费率 int logisticsBranchID = codeList1[0].CodeID; BusinessLogic.ManageProject.XMLogisticsFeeBranch entityBranch = XMLogisticsFeeBranchService. getSingle(a => a.ProjectID == entity_Project.Id && a.LogisticsID == logisticsBranchID && a.ProductCategoryID == entityProductDetails.ProductTypeId); if (entityBranch == null) { ExtNet.Msg.Alert("提示", "找不到对应支线单价费率").Show(); return; } Branch = (decimal)entityBranch.Fee; //商品体积 string ProductVolume = string.IsNullOrEmpty(entityProduct.ProductVolume) ? "0" : entityProduct.ProductVolume; mainMoney = mainMoney + main * decimal.Parse(ProductVolume) * (int)item.ProductNum; branchMoney = branchMoney + Branch * (int)item.ProductNum; } } //事务 using (TransactionScope scope = new TransactionScope()) { List <BusinessLogic.ManageProject.XMLogisticsFeeDetail> list = XMLogisticsFeeDetailService.getList(a => a.Type != 3); foreach (var item in list) { XMLogisticsFeeDetailService.delete(item); } if (mainMoney >= 0) { XMLogisticsFeeDetailService.InsertXMLogisticsFeeDetail(new BusinessLogic.ManageProject.XMLogisticsFeeDetail() { OrderID = entity_Order.ID, Type = 1, Fee = mainMoney, CreateID = HozestERPContext.Current.User.CustomerID, CreateDate = DateTime.Now, }); } if (branchMoney >= 0) { XMLogisticsFeeDetailService.InsertXMLogisticsFeeDetail(new BusinessLogic.ManageProject.XMLogisticsFeeDetail() { OrderID = entity_Order.ID, Type = 2, Fee = branchMoney, CreateID = HozestERPContext.Current.User.CustomerID, CreateDate = DateTime.Now, }); } scope.Complete(); } } else { ExtNet.Msg.Alert("提示", "不在计算范围内").Show(); return; } }