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("全部", ""));
//}
}
}