private void BindGrid()
{
var data = XMOrderInfoProductDetailsService.GetWarningOrderList();
StoreWorker.DataSource = data;
StoreWorker.DataBind();
}
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;
}
}
