/// <summary>
/// 保存暂支申请信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
if (this.AdvanceId > 0)
{
string ddTheAdvanceType = this.ddTheAdvanceType.SelectedValue.Trim();
//查询暂支单预计归还日期
var setting = base.SettingManager.GetSettingByName("AdvanceApplication.ForecastReturnTime");
if (setting != null)
{
//刷单暂支
if (ddTheAdvanceType == "343")
{
#region 根据店铺Id查询 所对应的项目,并查询出该项目所对应的所有店铺
int ProjectId = 0;
var NickId = Convert.ToInt32(this.hfNickId.Value);
var XMNick = base.XMNickService.GetXMNickByID(NickId);
if (XMNick != null)
{
if (XMNick.ProjectId != null)
{
ProjectId = XMNick.ProjectId.Value;
}
}
XMProject xMProject = new XMProject();
List <int> ProjectIdList = new List <int>(); //项目Id
List <int> NickIdList = new List <int>(); //项目下所有的 店铺Id
if (ProjectId > 0)
{
ProjectIdList.Add(ProjectId);
//所有店铺
var XMNickProjectIdList = base.XMNickService.GetXMNickListByProjectId(ProjectIdList);
//所有店铺Id
NickIdList = XMNickProjectIdList.Select(p => p.nick_id).ToList();
xMProject = base.XMProjectService.GetXMProjectById(ProjectId);
}
#endregion
List <AdvanceApplication> AdvanceApplicationList = new List <AdvanceApplication>();
if (NickIdList.Count > 0)
{
var AdvanceApplicationListByNickId = base.AdvanceApplicationService.GetAdvanceApplicationListByNickId(NickIdList);
if (AdvanceApplicationListByNickId.Count > 0)
{
AdvanceApplicationList = AdvanceApplicationListByNickId.Where(p => p.ForecastReturnTime < DateTime.Now.AddDays(1) && p.AdvanceState == (int)AdvanceStateEnum.TheAdvanceUse).ToList();
}
}
if (AdvanceApplicationList.Count > 0)
{
string ProjectName = "";
if (xMProject != null)
{
ProjectName = xMProject.ProjectName;
}
base.ShowMessage(ProjectName + "项目有其它店铺未在归还日期内还款,请先还款!");
return;
}
else
{
#region 修改
string ddApplicationDepartment = this.ddApplicationDepartment.SelectedValue.Trim();
string txtApplicationPayee = this.txtApplicationPayee.Text;
string txtTheAdvanceSubject = this.txtTheAdvanceSubject.Text;
string txtTheAdvanceMoney = this.txtTheAdvanceMoney.Text;
//string lblForecastReturnTime = this.lblForecastReturnTime.Text.Trim();
string txtSubject = this.txtSubject.Text;
int txtApplicants = this.txtApplicants.SelectSingleCustomer.CustomerID;// this.txtApplicants.Text;
//判断刷单单号否有效
this.lblMag.Visible = false;
int scalpingId = 0;
int.TryParse(this.hfScalpingId.Value, out scalpingId);
if (ddTheAdvanceType == "343")
{
var scalping = base.XMScalpingApplicationService.GetXMScalpingApplicationByScalpingId(scalpingId);
if (scalping == null)
{
this.lblMag.Visible = true;
this.lblMag.Text = "刷单单号有误";
this.hfScalpingId.Value = "";
this.txtScalpingCode.Value = "";
this.hfNickId.Value = "";
this.txtNickName.Text = "";
this.hfPlatformTypeId.Value = "";
this.txtPlatformType.Text = "";
ScriptManager.RegisterStartupScript(this.txtScalpingCode, this.Page.GetType(), "advanceApplicationDetailManage", "autoCompleteBindScalpingCodeManag()", true);
return;
}
}
//暂支申请主表信息
AdvanceApplication advanceApplication = base.AdvanceApplicationService.GetAdvanceApplicationById(this.AdvanceId);
if (advanceApplication != null)
{
//判断是否重复
var AdvanceApplicationListByScalpingId = base.AdvanceApplicationService.GetAdvanceApplicationByScalpingId(scalpingId);
if (AdvanceApplicationListByScalpingId.Count > 0)
{
if (AdvanceApplicationListByScalpingId[0].ScalpingId != advanceApplication.ScalpingId)
{
this.lblMag.Visible = true;
this.lblMag.Text = "刷单单号已存在";
this.hfScalpingId.Value = "";
this.txtScalpingCode.Value = "";
this.hfNickId.Value = "";
this.txtNickName.Text = "";
this.hfPlatformTypeId.Value = "";
this.txtPlatformType.Text = "";
ScriptManager.RegisterStartupScript(this.txtScalpingCode, this.Page.GetType(), "advanceApplicationDetailManage", "autoCompleteBindScalpingCodeManag()", true);
return;
}
}
if (ddTheAdvanceType == "343")
{
advanceApplication.PlatformTypeId = Convert.ToInt32(this.hfPlatformTypeId.Value);
advanceApplication.NickId = Convert.ToInt32(this.hfNickId.Value);
advanceApplication.ScalpingId = Convert.ToInt32(scalpingId);
}
advanceApplication.TheAdvanceType = Convert.ToInt32(ddTheAdvanceType);
advanceApplication.ApplicationDepartment = Convert.ToInt32(ddApplicationDepartment);
advanceApplication.ApplicationPayee = txtApplicationPayee;
advanceApplication.TheAdvanceSubject = txtTheAdvanceSubject;
advanceApplication.TheAdvanceMoney = Convert.ToDecimal(txtTheAdvanceMoney);
//if (lblForecastReturnTime != "")
//{
// advanceApplication.ForecastReturnTime = Convert.ToDateTime(lblForecastReturnTime);
//}
advanceApplication.Subject = txtSubject;
advanceApplication.Applicants = txtApplicants;
advanceApplication.UpdatorID = HozestERPContext.Current.User.CustomerID;
advanceApplication.UpdateTime = DateTime.Now;
base.AdvanceApplicationService.UpdateAdvanceApplication(advanceApplication);
base.ShowMessage("保存成功");
loadDate();
ScriptManager.RegisterStartupScript(this.txtScalpingCode, this.Page.GetType(), "advanceApplicationDetailManage", "autoCompleteBindScalpingCodeManag()", true);
}
#endregion
}
}
else
{
#region 修改
string ddApplicationDepartment = this.ddApplicationDepartment.SelectedValue.Trim();
string txtApplicationPayee = this.txtApplicationPayee.Text;
string txtTheAdvanceSubject = this.txtTheAdvanceSubject.Text;
string txtTheAdvanceMoney = this.txtTheAdvanceMoney.Text;
//string lblForecastReturnTime = this.lblForecastReturnTime.Text.Trim();
string txtSubject = this.txtSubject.Text;
int txtApplicants = this.txtApplicants.SelectSingleCustomer.CustomerID;// this.txtApplicants.Text;
//暂支申请主表信息
AdvanceApplication advanceApplication = base.AdvanceApplicationService.GetAdvanceApplicationById(this.AdvanceId);
if (advanceApplication != null)
{
advanceApplication.PlatformTypeId = null;
advanceApplication.NickId = null;
advanceApplication.ScalpingId = null;
advanceApplication.TheAdvanceType = Convert.ToInt32(ddTheAdvanceType);
advanceApplication.ApplicationDepartment = Convert.ToInt32(ddApplicationDepartment);
advanceApplication.ApplicationPayee = txtApplicationPayee;
advanceApplication.TheAdvanceSubject = txtTheAdvanceSubject;
advanceApplication.TheAdvanceMoney = Convert.ToDecimal(txtTheAdvanceMoney);
//if (lblForecastReturnTime != "")
//{
// advanceApplication.ForecastReturnTime = Convert.ToDateTime(lblForecastReturnTime);
//}
advanceApplication.Subject = txtSubject;
advanceApplication.Applicants = txtApplicants;
advanceApplication.UpdatorID = HozestERPContext.Current.User.CustomerID;
advanceApplication.UpdateTime = DateTime.Now;
base.AdvanceApplicationService.UpdateAdvanceApplication(advanceApplication);
base.ShowMessage("保存成功");
loadDate();
ScriptManager.RegisterStartupScript(this.txtScalpingCode, this.Page.GetType(), "advanceApplicationDetailManage", "autoCompleteBindScalpingCodeManag()", true);
}
#endregion
}
}
else
{
base.ShowMessage("请联系管理员设置暂支预计归还天数!");
return;
}
}
}
catch (Exception err)
{
this.ProcessException(err);
}
}
}
/// <summary>
/// 记录行 操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gvXMProjectList_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int Id = 0;
if (int.TryParse(this.gvXMProjectList.DataKeys[e.RowIndex].Value.ToString(), out Id))
{
var row = this.gvXMProjectList.Rows[e.RowIndex];
#region 字符验证
//产品名称
var txtProjectName = row.FindControl("txtProjectName") as TextBox;
var lblMsgProjectNameVaule = row.FindControl("lblMsgProjectNameVaule") as Label;
var lblProjectName = row.FindControl("lblProjectName") as Label;
var lblMsgShipmentProportionVaule = row.FindControl("lblMsgShipmentProportionVaule") as Label;
var ccProjectTypeId = row.FindControl("ccProjectTypeId") as CodeControl;
var chkIsEnable = row.FindControl("chkIsEnable") as CheckBox;
var ddlDepartment = row.FindControl("ddlDepartment") as DropDownList;
var ShipmentProportion = row.FindControl("txtShipmentProportion") as TextBox;
decimal paramparse2 = 0;
lblMsgProjectNameVaule.Text = "";
if (txtProjectName.Text.Trim() == "")
{
lblMsgProjectNameVaule.Text = "不允许为空";
}
//负责人
SelectSingleCustomerControl txtcustomerId = (SelectSingleCustomerControl)row.FindControl("txtcustomerId");
//客户
SelectSingleCustomerControl txtClientId = (SelectSingleCustomerControl)row.FindControl("txtClientId");
//备注
var txtRemark = row.FindControl("txtRemark") as TextBox;
if (lblMsgProjectNameVaule.Text != "")
{
return;
}
#endregion
var xMProject = base.XMProjectService.GetXMProjectById(Id);
var xMProjectList = base.XMProjectService.GetXMProjectList(txtProjectName.Text.Trim(), -1, -1);
if (xMProject != null)
{
if ((!txtProjectName.Text.Trim().Equals(lblProjectName.Text.Trim())) && xMProjectList.Count > 0)
{
base.ShowMessage("该项目名称已存在");
return;
}
xMProject.ProjectName = txtProjectName.Text.Trim();
xMProject.ProjectTypeId = ccProjectTypeId.SelectedValue;
xMProject.customerId = txtcustomerId.SelectSingleCustomer.CustomerID;
if (decimal.TryParse(ShipmentProportion.Text.Trim(), out paramparse2))
{
xMProject.ShipmentProportion = decimal.Parse(ShipmentProportion.Text.Trim());
}
else
{
xMProject.ShipmentProportion = 0;
}
if (txtClientId != null)
{
if (txtClientId.SelectSingleCustomer != null)
{
xMProject.ClientId = txtClientId.SelectSingleCustomer.CustomerID;
}
}
if (txtRemark.Text.Trim() != "")
{
xMProject.Remark = txtRemark.Text.Trim();
}
else
{
xMProject.Remark = "";
}
xMProject.DepartmentID = int.Parse(ddlDepartment.SelectedValue.Trim());
if (!chkIsEnable.Checked && (bool)xMProject.IsEnable)
{
var NickList = base.XMNickService.GetXMNickListByProjectId(xMProject.Id);
if (NickList != null && NickList.Count > 0)
{
foreach (XMNick info in NickList)
{
info.isEnable = false;
info.updatePerson = HozestERPContext.Current.User.CustomerID.ToString();
info.updateTime = DateTime.Now;
base.XMNickService.UpdateXMNick(info);
}
}
}
xMProject.IsEnable = chkIsEnable.Checked;//是否在运营
xMProject.UpdateID = HozestERPContext.Current.User.CustomerID;
xMProject.UpdateDate = DateTime.Now;
base.XMProjectService.UpdateXMProject(xMProject);
}
else
{
if (xMProjectList.Count > 0)
{
base.ShowMessage("该项目名称已存在");
return;
}
xMProject = new XMProject();
xMProject.ProjectName = txtProjectName.Text.Trim();
xMProject.ProjectTypeId = ccProjectTypeId.SelectedValue;
xMProject.customerId = txtcustomerId.SelectSingleCustomer.CustomerID;
if (txtClientId != null)
{
if (txtClientId.SelectSingleCustomer != null)
{
xMProject.ClientId = txtClientId.SelectSingleCustomer.CustomerID;
}
}
if (txtRemark.Text.Trim() != "")
{
xMProject.Remark = txtRemark.Text.Trim();
}
else
{
xMProject.Remark = "";
}
xMProject.DepartmentID = int.Parse(ddlDepartment.SelectedValue.Trim());
xMProject.IsEnable = chkIsEnable.Checked;//是否在运营
xMProject.CreateID = HozestERPContext.Current.User.CustomerID;
xMProject.CreateDate = DateTime.Now;
xMProject.UpdateID = HozestERPContext.Current.User.CustomerID;
xMProject.UpdateDate = DateTime.Now;
base.XMProjectService.InsertXMProject(xMProject);
}
// SelectSingleCustomer //this.SelectSingleCustomer = null;
Session["OperationCustomerCustomerStatus"] = null;
Session["OperationClientCustomerStatus"] = null;
this.RowEditIndex = -1;
this.BindGrid(this.Master.PageIndex, this.Master.PageSize);
}
}
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;
}
}