using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using CY.BLL; using CY.Model; using CY.Infrastructure.Query; using CY.Infrastructure.Common; using CY.BLL.Sys; using CY.BLL.OA; using CY.BLL.EC; using System.Transactions; using CY.Model.Inquiry; namespace CY.WebForm.Pages.financial { public partial class PlanOrderAdd : BasePage { CoreCmsPlanOrderBLL _PlanOrderBLL = new CoreCmsPlanOrderBLL(); CoreCmsPlanOrderItemBLL _coreCmsPlanOrderItemBLL = new CoreCmsPlanOrderItemBLL(); Sys_CitySiteBLL bll_Sys_CitySiteBLL = new Sys_CitySiteBLL(); EC_OrderPrintParameterBLL _OrderPrintParameterBLL = new EC_OrderPrintParameterBLL(); EC_OrderBasicBLL _eC_OrderBasicBLL = new EC_OrderBasicBLL(); OA_CorporateClientsBLL bll_OA_CorporateClientsBLL = new OA_CorporateClientsBLL() ; public PlanOrderAdd() { } protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { InitialData(); if (Request["Keyid"].ToInt32() > 0) // 加载要修改的的数据 { //HideKeyid.Value = Request["Keyid"].ToString2(); } } } /// /// 初始化科目类别 /// public void InitialData() { //BindProvince(); InitialModifyData(); } /// /// 初始化要修改的数据 /// public void InitialModifyData() { //var coreCmsPlanOrder = _PlanOrderBLL.GetModelByKeyid(Request["Keyid"].ToInt32().Value); //spnsheng.InnerText = coreCmsPlanOrder.sheng; //spnshi.InnerText = coreCmsPlanOrder.shi; //spnquxian.InnerText = coreCmsPlanOrder.quxian; //spnpianqu.Value = coreCmsPlanOrder.pianqu; //spnshipAddress.Value = coreCmsPlanOrder.shipAddress; //spnshipName.Value = coreCmsPlanOrder.shipName; //spnshipMobile.Value = coreCmsPlanOrder.shipMobile; //spnshouhuoAddress.Value = coreCmsPlanOrder.shouhuoAddress; //OrderAmount.Value = coreCmsPlanOrder.orderAmount.ToString2(); var coreCmsPlanOrders = new List(); if (Request["orderkeyid"].ToInt32() > 0) { HideKeyid.Value = Request["orderkeyid"].ToString2(); var eC_OrderPrintParameter = _OrderPrintParameterBLL.GetModel(Request["orderkeyid"].ToInt32().Value); ; InquiryCommonModel model = SerializationHelper.DeSerialize(typeof(InquiryCommonModel), eC_OrderPrintParameter.PrintParameter) as InquiryCommonModel; foreach(var workBookModel in model.InquiryWorkBookList) { var coreCmsPlanOrder = new CoreCmsPlanOrderItem(); coreCmsPlanOrder.name = workBookModel.WorkBookNameTxt; coreCmsPlanOrder.specification = workBookModel.WorkBookSizeTxt; coreCmsPlanOrder.price = workBookModel.WorkBookPrice.ToDecimal2().Value; coreCmsPlanOrder.nums = 0; coreCmsPlanOrder.amount = 0; coreCmsPlanOrder.fengmian = string.IsNullOrEmpty(workBookModel.fengmian)?"": workBookModel.fengmian; coreCmsPlanOrder.neiye = string.IsNullOrEmpty(workBookModel.neiye) ? "" : workBookModel.neiye; coreCmsPlanOrders.Add(coreCmsPlanOrder); } this.RepSubjeSetctList.DataSource = coreCmsPlanOrders; this.RepSubjeSetctList.DataBind(); var eC_OrderBasic = _eC_OrderBasicBLL.SelectModelById(Request["orderkeyid"].ToInt32().Value); if (eC_OrderBasic != null) { var customerCommunications = bll_OA_CorporateClientsBLL.GetModel_CustomerCommunications(eC_OrderBasic.BuyerId); spnsheng.InnerText = customerCommunications.Province; spnshi.InnerText = customerCommunications.City; spnquxian.InnerText = customerCommunications.County; } } } /// /// 添加或修改科目 /// /// /// protected void btn_Submit_Config(object sender, EventArgs e) { //if(selectProvince.SelectedValue == "") //{ // JavaScript.MessageBox("请选择省", this); // return; //} //if (selectCity.SelectedValue == "") //{ // JavaScript.MessageBox("请选择市", this); // return; //} //if (selectCounty.SelectedValue == "") //{ // JavaScript.MessageBox("请选择区县", this); // return; //} // string id = HideKeyid.Value; var orderAmount = this.OrderAmount.Value; var pianqu = this.spnpianqu.Value.Trim(); var shipAddress = this.spnshipAddress.Value.Trim(); var shipName = this.spnshipName.Value.Trim(); var shipMobile = this.spnshipMobile.Value.Trim(); var shouhuoAddress = this.spnshouhuoAddress.Value.Trim(); //string[] ids = Request["id"].ToString2().Split(','); string[] name = Request["name"].ToString2().Split(','); string[] specification = Request["specification"].ToString2().Split(','); string[] price = Request["price"].ToString2().Split(','); string[] itemNumarray = Request["itemNumarray"].ToString2().Split(','); string[] amount = Request["amount"].ToString2().Split(','); string[] fengmian = Request["fengmian"].ToString2().Split(','); string[] neiye = Request["neiye"].ToString2().Split(','); var sss = false; EC_OrderBasicBLL _eC_OrderBasicBLL = new EC_OrderBasicBLL(); int orderkeyid = 0; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted, Timeout = TransactionManager.MaximumTimeout } )) { var coreCmsPlanOrder = new CoreCmsPlanOrder(); orderkeyid = HideKeyid.Value.ToInt32().Value; //coreCmsPlanOrder.sheng = selectProvince.SelectedItem.Text; //coreCmsPlanOrder.shengId = selectProvince.SelectedValue.ToInt32().Value; //coreCmsPlanOrder.shi = selectCity.SelectedItem.Text; //coreCmsPlanOrder.shiId = selectCity.SelectedValue.ToInt32().Value; //coreCmsPlanOrder.quxian = selectCounty.SelectedItem.Text; //coreCmsPlanOrder.quxianId = selectCounty.SelectedValue.ToInt32().Value; coreCmsPlanOrder.sheng = spnsheng.InnerText; coreCmsPlanOrder.shi = spnshi.InnerText; coreCmsPlanOrder.quxian = spnquxian.InnerText; var sys_CitySite = bll_Sys_CitySiteBLL.GetModelByName(coreCmsPlanOrder.sheng); if (sys_CitySite != null) { coreCmsPlanOrder.shengId = sys_CitySite.Keyid; var sys_CitySite1 = bll_Sys_CitySiteBLL.SelectAllNextModel(sys_CitySite.Keyid, 0, 2).FirstOrDefault(x=>x.Name == coreCmsPlanOrder.shi); if (sys_CitySite1 != null) { coreCmsPlanOrder.shiId = sys_CitySite1.Keyid; var sys_CitySite2 = bll_Sys_CitySiteBLL.SelectAllNextModel(sys_CitySite.Keyid, sys_CitySite1.Keyid, 3).FirstOrDefault(x => x.Name == coreCmsPlanOrder.quxian); if (sys_CitySite2 != null) { coreCmsPlanOrder.quxianId = sys_CitySite2.Keyid; } } } coreCmsPlanOrder.orderkeyid = orderkeyid; coreCmsPlanOrder.orderAmount = orderAmount.ToDecimal2().Value; coreCmsPlanOrder.pianqu = pianqu; coreCmsPlanOrder.shipAddress = shipAddress; coreCmsPlanOrder.shipName = shipName; coreCmsPlanOrder.shipMobile = shipMobile; coreCmsPlanOrder.userMobile = shipMobile; coreCmsPlanOrder.shouhuoAddress = shouhuoAddress; coreCmsPlanOrder.upDataTime = DateTime.Now; coreCmsPlanOrder.upDataBy = CurrentUser.ShortName; coreCmsPlanOrder.createTime = DateTime.Now; coreCmsPlanOrder.createBy = CurrentUser.ShortName; coreCmsPlanOrder.FirmId = CurrentUser.MemberId; int orderid = _PlanOrderBLL.InsertModelIden(coreCmsPlanOrder); for (int i = 0; i < name.Length; i++) { var cmsPlanOrderItem = new CoreCmsPlanOrderItem(); cmsPlanOrderItem.orderId = orderid; cmsPlanOrderItem.name = name[i]; cmsPlanOrderItem.specification = specification[i]; cmsPlanOrderItem.price = price[i].ToDecimal2().Value; cmsPlanOrderItem.nums = itemNumarray[i].ToInt32().Value; cmsPlanOrderItem.amount = amount[i].ToDecimal2().Value; cmsPlanOrderItem.upDataTime = DateTime.Now; cmsPlanOrderItem.upDataBy = CurrentUser.ShortName; cmsPlanOrderItem.createTime = DateTime.Now; cmsPlanOrderItem.createBy = CurrentUser.ShortName; cmsPlanOrderItem.isOld = true; cmsPlanOrderItem.fengmian = string.IsNullOrEmpty(fengmian[i])?"": fengmian[i]; cmsPlanOrderItem.neiye = string.IsNullOrEmpty(neiye[i]) ? "" : neiye[i]; sss = _PlanOrderBLL.insertModelOrderItem(cmsPlanOrderItem); } //更新整个订单的总价格 scope.Complete(); } sss = _eC_OrderBasicBLL.UpdateorderJine(orderkeyid); if (sss) { JavaScript.MessageBoxCloseAndRefreshFirsts("新增成功", this); } else { JavaScript.MessageBox("新增成功", this); } } ////绑定省 //protected void BindProvince() //{ // this.selectProvince.Items.Clear(); // var sys_CitySites = bll_Sys_CitySiteBLL.SelectAllNextModel(0, 0, 1); // this.selectProvince.DataSource = sys_CitySites; // var sys_CitySite = sys_CitySites.FirstOrDefault(x => x.Name == "四川省"); // this.selectProvince.DataTextField = "Name"; // this.selectProvince.DataValueField = "Keyid"; // this.selectProvince.DataBind(); // this.selectProvince.Items.Insert(0, new ListItem("全部", "")); // this.selectCity.Items.Insert(0, new ListItem("全部", "")); // this.selectCounty.Items.Insert(0, new ListItem("全部", "")); // if (sys_CitySite != null) // { // this.selectProvince.SelectedValue = sys_CitySite.Keyid.ToString(); // this.selectCity.Items.Clear(); // this.selectCounty.Items.Clear(); // Sys_CitySite m_Sys_CitySite = bll_Sys_CitySiteBLL.GetModelByKeyid(this.selectProvince.SelectedValue.ToInt32() ?? 0); // if (m_Sys_CitySite != null) // { // this.selectCity.DataSource = bll_Sys_CitySiteBLL.SelectAllNextModel(m_Sys_CitySite.Keyid, 0, 2); // this.selectCity.DataTextField = "Name"; // this.selectCity.DataValueField = "Keyid"; // this.selectCity.DataBind(); // } // this.selectCity.Items.Insert(0, new ListItem("全部", "")); // this.selectCounty.Items.Insert(0, new ListItem("全部", "")); // } //} ////改变省绑定市 //protected void ChangeProvince(object sender, EventArgs e) //{ // this.selectCity.Items.Clear(); // this.selectCounty.Items.Clear(); // Sys_CitySite m_Sys_CitySite = bll_Sys_CitySiteBLL.GetModelByKeyid(this.selectProvince.SelectedValue.ToInt32() ?? 0); // if (m_Sys_CitySite != null) // { // this.selectCity.DataSource = bll_Sys_CitySiteBLL.SelectAllNextModel(m_Sys_CitySite.Keyid, 0, 2); // this.selectCity.DataTextField = "Name"; // this.selectCity.DataValueField = "Keyid"; // this.selectCity.DataBind(); // } // this.selectCity.Items.Insert(0, new ListItem("全部", "")); // this.selectCounty.Items.Insert(0, new ListItem("全部", "")); //} ////改变市绑定区 //protected void ChangeCity(object sender, EventArgs e) //{ // this.selectCounty.Items.Clear(); // Sys_CitySite m_Sys_CitySite = bll_Sys_CitySiteBLL.GetModelByKeyid(this.selectCity.SelectedValue.ToInt32() ?? 0); // if (m_Sys_CitySite != null) // { // this.selectCounty.DataSource = bll_Sys_CitySiteBLL.SelectProxyNextModel(m_Sys_CitySite.ProvinceId, m_Sys_CitySite.Keyid, 3); // this.selectCounty.DataTextField = "Name"; // this.selectCounty.DataValueField = "Keyid"; // this.selectCounty.DataBind(); // } // this.selectCounty.Items.Insert(0, new ListItem("全部", "")); //} } }