private void data_Bind()
{
//项目数据
var projectList = XMProjectService.GetXMProjectList();
Store2.DataSource = projectList;
Store2.DataBind();
//发货点数据(发货仓)
var codeList = CodeService.GetCodeListInfoByCodeTypeID(227);
Store3.DataSource = codeList;
Store3.DataBind();
//省份数据
var provinceList = AreaCodeService.GetAreaCodeByRank(2);
Store4.DataSource = provinceList;
Store4.DataBind();
//物流公司数据
var logisticsList = CodeService.GetCodeListInfoByCodeTypeID(243);
Store7.DataSource = logisticsList;
Store7.DataBind();
}
private void DataLoad()
{
var list = XMProjectService.GetXMProjectList();
StoreProject.DataSource = list;
StoreProject.DataBind();
}
private void dataBind()
{
//项目数据
var projectList = XMProjectService.GetXMProjectList();
Store2.DataSource = projectList;
Store2.DataBind();
//物流公司数据
var logisticsList = CodeService.GetCodeListInfoByCodeTypeID(244);
Store3.DataSource = logisticsList;
Store3.DataBind();
//发货点数据(发货仓)
var codeList = CodeService.GetCodeListInfoByCodeTypeID(188);
Store4.DataSource = codeList;
Store4.DataBind();
}
/// <summary>
/// 项目名称
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ddlBelongingDep_SelectedIndexChanged(object sender, EventArgs e)
{
string depID = this.ddlBelongingDep.SelectedValue;
List <XMProject> ProjectList = new List <XMProject>();
//List<Department> DepartmentList = new List<Department>();
//if (DepartmentType == "-1")
//{
// DepartmentList = base.EnterpriseService.GetDepartmentAll();
//}
//else
//{
// DepartmentList = base.EnterpriseService.GetDepartmentListByDepType(int.Parse(DepartmentType));
//}
//if (DepartmentList.Count > 0)
//{
// foreach (Department info in DepartmentList)
// {
// var list = base.XMProjectService.GetXMProjectListByDepID(info.DepartmentID);
// if (list.Count > 0)
// {
// ProjectList.AddRange(list);
// }
// }
//}
if (!string.IsNullOrEmpty(depID))
{
ProjectList = XMProjectService.GetXMProjectListByDepID(int.Parse(depID));
if (ProjectList.Count > 0)
{
this.ddlBelongingProject.Items.Clear();
this.ddlBelongingProject.DataSource = ProjectList;
this.ddlBelongingProject.DataTextField = "ProjectName";
this.ddlBelongingProject.DataValueField = "Id";
this.ddlBelongingProject.DataBind();
this.ddlBelongingProject.Items.Insert(0, new ListItem("", "-1"));
}
else
{
var DepartmentList = base.EnterpriseService.GetDepartmentListByDepType(int.Parse(depID));
foreach (Department info in DepartmentList)
{
var list = base.XMProjectService.GetXMProjectListByDepID(info.DepartmentID);
if (list.Count > 0)
{
ProjectList.AddRange(list);
}
}
this.ddlBelongingProject.Items.Clear();
this.ddlBelongingProject.DataSource = ProjectList;
this.ddlBelongingProject.DataTextField = "ProjectName";
this.ddlBelongingProject.DataValueField = "Id";
this.ddlBelongingProject.DataBind();
this.ddlBelongingProject.Items.Insert(0, new ListItem("", "-1"));
}
ReceivablesValue = Request.Form["txtComboReceivables"];
BudgetValue = Request.Form["txtComboBudget"];
FinancialValue = Request.Form["ddlFinancialType"];
ScriptManager.RegisterStartupScript(this.ddlBelongingDep, this.Page.GetType(), "ddlBelongingDep", "Load()", true);//ajax
}
}
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;
}
}
