protected void Page_Load(object sender, EventArgs e) { Session["songhuodan"] = "1"; if (!IsPostBack) { if (Session["SendList"] != null) { List<PrevProductMOD> list = (List<PrevProductMOD>)Session["SendList"]; List<PrevProductMOD> newList = new List<PrevProductMOD>(); foreach (var m in list) { if (m.ProNum != "" && m.ProNum != "0") { newList.Add(m); } } Repeater1.DataSource = newList; Repeater1.DataBind(); rptPro.DataSource = newList; rptPro.DataBind(); } if (Request.QueryString["orderNum"] != null && Request.QueryString["orderNum"].ToString() != "") { orderNum = Request.QueryString["orderNum"].ToString(); lblOrderNum.Text = orderNum; } if (Request.QueryString["sendTime"] != null && Request.QueryString["sendTime"].ToString() != "") { lblPrintTime.Value = Request.QueryString["sendTime"].ToString(); } if (Request.QueryString["customerNo"] != null && Request.QueryString["customerNo"].ToString() != "") { string customNum = Request.QueryString["customerNo"].ToString(); CustomerManageMod mod = CustomerManageBLL.GetcustomerByid(customNum); if (mod != null) { using (var db = new Web.Model.OrderPrintEntities()) { var dtl = db.SendDetail.OrderByDescending(r => r.sendId).FirstOrDefault(r => r.orderNum == orderNum); if (dtl != null && !string.IsNullOrEmpty(dtl.PrintCompanyName)) { txtCompanyName.Text = dtl.PrintCompanyName; } else { txtCompanyName.Text = mod.CompanyName; } } if (mod.IsShowPrice == 0) //显示 { div1.Visible = false; div2.Visible = true; } else //不显示 { div1.Visible = true; div2.Visible = false; } } else { div1.Visible = true; div2.Visible = false; } } //产品型号 if (Request.QueryString["proType"] != null && Request.QueryString["proType"].ToString() != "") { proType = Request.QueryString["proType"].ToString(); } //打印时间 // lblPrintTime.Value = DateTime.Now.ToShortDateString(); } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Save_Click(object sender, EventArgs e) { try { bool real = true; //修改订单基本信息 if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != "") { string orderNum = Request.QueryString["id"].ToString(); int id; var db = new Web.Model.OrderPrintEntities(); if (Int32.TryParse(Request.QueryString["id"], out id)) { orderNum = db.proOrders.Where(r => r.orderId == id).FirstOrDefault().orderNum; } //加载订单基本信息 orderMod = ProOrdersBLL.GetModel(orderNum); orderMod.customManager = txtcustomManager.Text.Trim(); orderMod.customOrderNum = txtcustomOrderNum.Text.Trim(); orderMod.customWLBH = "";// txtcustomWLBH.Text.Trim(); orderMod.heTongNum = txtheTongNum.Text.Trim(); orderMod.remark = txtremark.Text.Trim(); orderMod.UpdateTime = DateTime.Now; orderMod.FaPiaoDanhao = ""; orderMod.ChengShuiHao = ""; orderMod.Remark1 = ""; orderMod.EditUser = UserInfo.UserId; orderMod.IsTiXing = 0; orderMod.ShuRuXianchang = "";// txtshuRuXianchang.Text.Trim(); orderMod.ShuChuXianchang = "";// txtshuChuXianchang.Text.Trim(); var intorderDetailId = id; var gt_order = db.proOrders.FirstOrDefault(r => r.orderId == orderMod.orderId); gt_order.发货状态 = rbl发货状态.SelectedValue; db.SaveChanges(); //if (txtYijiekuanMoney.Text.Trim() != "") //{ // orderMod.YijiekuanMoney = Convert.ToDecimal(txtYijiekuanMoney.Text.Trim()); //} //else //{ // orderMod.YijiekuanMoney = 0; //} //if (txtYikaipiaoMoney.Text.Trim() != "") //{ // orderMod.YikaipiaoMoney = Convert.ToDecimal(txtYikaipiaoMoney.Text.Trim()); //} //else //{ // orderMod.YikaipiaoMoney = 0; //} ProOrdersBLL.Update(orderMod); } //修改订单详情 string[] xinghao = Request.Params.GetValues("proType"); string[] shuliang = Request.Params.GetValues("proNum"); string[] danjia = Request.Params.GetValues("ProPrice"); string[] wuliaobian = Request.Params.GetValues("wuliaobian"); string xianyouyongpin = ""; string errmsg = ""; //原有产品的增加和修改 for (int i = 0; i < rptYongpin.Items.Count; i++) { Label lblProType = this.rptYongpin.Items[i].FindControl("lblProType") as Label; TextBox txtProNum = this.rptYongpin.Items[i].FindControl("txtProNum") as TextBox; Label lblProPrice = this.rptYongpin.Items[i].FindControl("lblProPrice") as Label; Label lblWuliaobian = this.rptYongpin.Items[i].FindControl("lblWuliaobian") as Label; HiddenField hdborderDetailId = this.rptYongpin.Items[i].FindControl("hdborderDetailId") as HiddenField; xianyouyongpin += lblProType.Text.Trim() + ","; if (txtProNum != null && txtProNum.Text.Trim() != "" && int.Parse(txtProNum.Text.Trim()) != 0) { //修改产品数量 int Updcount = ProOrdersDetailBLL.Update(Convert.ToInt32(hdborderDetailId.Value), Convert.ToInt32(txtProNum.Text)); if (!(Updcount > 0)) { real = false; } } else { //删除产品型号 ProOrdersDetailBLL.Delete(Convert.ToInt32(hdborderDetailId.Value)); } } //新增产品 if (xinghao != null && xinghao.Length > 0) { for (int i = 0; i < xinghao.Length; i++) { if (shuliang[i].ToString().Trim() != "" && int.Parse(shuliang[i].ToString().Trim()) != 0) { ProductParamMOD paramMod = ProductParamBLL.GetmodByid(txtcustomNum.Text.Trim(), xinghao[i].Trim()); if (paramMod != null) { string xinYongpin = xinghao[i].ToString().Trim(); int num = 0; int osid = 0; if (xianyouyongpin.Contains(xinYongpin)) //如果新增产品已经存在于原有的产品中,则数量合并 { DataSet ds = ProOrdersDetailBLL.GetList(" and proType='" + xinghao[i].Trim() + "' and orderNum='" + txtorderNum.Text.Trim() + "'"); if (ds != null && ds.Tables[0].Rows.Count > 0) { num = Convert.ToInt32(ds.Tables[0].Rows[0]["proNum"].ToString()); osid = Convert.ToInt32(ds.Tables[0].Rows[0]["orderDetailId"].ToString()); int newNUM = num + Convert.ToInt32(shuliang[i].Trim()); //修改产品数量 int Updcount = ProOrdersDetailBLL.Update(osid, newNUM); if (!(Updcount > 0)) { real = false; } } else { orderDetail = new ProOrdersDetailMOD(); orderDetail.orderNum = txtorderNum.Text.Trim(); orderDetail.proNum = Convert.ToInt32(shuliang[i].Trim()); orderDetail.ProPrice = Convert.ToDecimal(danjia[i].Trim()); orderDetail.proType = xinghao[i].Trim(); int Addcounts = ProOrdersDetailBLL.Add(orderDetail); if (!(Addcounts > 0)) { real = false; } } } else //直接添加 { orderDetail = new ProOrdersDetailMOD(); orderDetail.orderNum = txtorderNum.Text.Trim(); orderDetail.proNum = Convert.ToInt32(shuliang[i].Trim()); orderDetail.ProPrice = Convert.ToDecimal(danjia[i].Trim()); orderDetail.proType = xinghao[i].Trim(); //orderDetail.Wuliaobian = wuliaobian[i].Trim(); int Addcounts = ProOrdersDetailBLL.Add(orderDetail); if (!(Addcounts > 0)) { real = false; } } } else { errmsg += xinghao[i] + ","; } } } } if (real) { if (errmsg == "") { ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');", true); // ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');print();DetailsPageControl.CloseBox();", true); Response.Redirect("Contract.aspx?customerNo=" + txtcustomNum.Text.Trim() + "&orderNum=" + txtorderNum.Text.Trim()); } else { // ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert(" + errmsg + "'没有维护单价提交失败,其余提交成功');", true); ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('" + errmsg + "没有维护产品参数提交失败,其余提交成功');DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');", true); Response.Redirect("Contract.aspx?customerNo=" + txtcustomNum.Text.Trim() + "&orderNum=" + txtorderNum.Text.Trim()); } // ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "DetailsPageControl.CloseBox();alert('提交成功!');DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');", true); } else { ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "alert('提交失败!')", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "alert('提交失败,您输入的信息有误!')", true); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != "") { string orderNum = Request.QueryString["id"].ToString(); int id; if (Int32.TryParse(Request.QueryString["id"], out id)) { var db=new Web.Model.OrderPrintEntities(); orderNum = db.proOrders.Where(r => r.orderId == id).FirstOrDefault().orderNum; } //加载订单基本信息 orderMod = ProOrdersBLL.GetModel(orderNum); if (orderMod != null) { txtcustomManager.Text = orderMod.customManager; txtcustomNum.Text = orderMod.customNum; txtcustomOrderNum.Text = orderMod.customOrderNum; // txtcustomWLBH.Text = orderMod.customWLBH; txtheTongNum.Text = orderMod.heTongNum; txtorderNum.Text = orderMod.orderNum; txtremark.Text = orderMod.remark; //txtshuChuXianchang.Text = orderMod.ShuChuXianchang; //txtshuRuXianchang.Text = orderMod.ShuRuXianchang; //txtYijiekuanMoney.Text = orderMod.YijiekuanMoney.ToString(); //txtYikaipiaoMoney.Text = orderMod.YikaipiaoMoney.ToString(); var db = new Web.Model.OrderPrintEntities(); var intorderDetailId = id; var gt_order = db.proOrders.FirstOrDefault(r => r.orderId == orderMod.orderId); if (!string.IsNullOrEmpty(gt_order.发货状态)) { rbl发货状态.SelectedValue = gt_order.发货状态; } } //加载订单产品 string strWhere = " and orderNum='" + orderNum + "'"; DataSet ds = ProOrdersDetailBLL.GetList(strWhere); if (ds != null && ds.Tables[0].Rows.Count > 0) { rptYongpin.DataSource = ds; rptYongpin.DataBind(); txtTRLastIndex.Value = ds.Tables[0].Rows.Count.ToString(); } else { txtTRLastIndex.Value = "0"; } //查看客户是否客户提供合同范本,如客户提供,打印合同按钮隐藏 customer = CustomerManageBLL.GetcustomerByid(orderMod.customNum); if (customer != null) { if (customer.IsFanben == 0) { tishi.InnerText = "本客户自己提供合同模板,请使用签订客户合同"; IBtn_Print.Visible = false; } else { IBtn_Print.Visible = true; } } else { IBtn_Print.Visible = true; } //订单号、客户编号不允许修改 txtorderNum.Enabled = false; txtcustomNum.Enabled = false; } } }
/// <summary> /// 添加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Save_Click(object sender, ImageClickEventArgs e) { int num = 0; if (Request.QueryString["id"] != "" && Request.QueryString["id"] != null) { int id = Convert.ToInt32(Request.QueryString["id"]); customer = CustomerManageBLL.GetcustomerByid(id); customer.BackMethod = txtbackMethod.Text.Trim(); customer.CompanyAddress = txtcompanyAddress.Text.Trim(); customer.CompanyName = txtcompanyName.Text.Trim(); customer.Contacts = txtcontacts.Text.Trim(); customer.Description = txtdescription.Text.Trim(); customer.Discount = txtdiscount.Text.Trim(); customer.InvoiceMethod = txtInvoiceMethod.Text.Trim(); customer.IsFanben = rdoIsFanbenYes.Checked ? 0 : 1; customer.IsShowPrice = rdoIsShowPriceYes.Checked ? 0 : 1; customer.ModifyPriceRecord = txtmodifyPriceRecord.Text.Trim(); customer.OtherDangAn = txtotherDangAn.Text.Trim(); customer.Phone = txtphone.Text.Trim(); customer.Position = txtposition.Text.Trim(); customer.Tax = txttax.Text.Trim(); customer.TelPhone = txttelPhone.Text.Trim(); customer.ShuiHao = txtShuiHao.Text.Trim(); customer.ZhangHao = txtZhangHao.Text.Trim(); if (rdoIsAdd.Checked == true) { customer.IsAddInfo = 1; } else { customer.IsAddInfo = 0; } num = CustomerManageBLL.Updatecustomer(customer); } else { customer = new CustomerManageMod(); customer.CustomerNo = txtcustomerNo.Text.Trim(); customer.BackMethod = txtbackMethod.Text.Trim(); customer.CompanyAddress = txtcompanyAddress.Text.Trim(); customer.CompanyName = txtcompanyName.Text.Trim(); customer.Contacts = txtcontacts.Text.Trim(); customer.Description = txtdescription.Text.Trim(); customer.Discount = txtdiscount.Text.Trim(); customer.InvoiceMethod = txtInvoiceMethod.Text.Trim(); customer.IsFanben = rdoIsFanbenYes.Checked ? 0 : 1; customer.IsShowPrice = rdoIsShowPriceYes.Checked ? 0 : 1; customer.ModifyPriceRecord = txtmodifyPriceRecord.Text.Trim(); customer.OtherDangAn = txtotherDangAn.Text.Trim(); customer.Phone = txtphone.Text.Trim(); customer.Position = txtposition.Text.Trim(); customer.Tax = txttax.Text.Trim(); customer.TelPhone = txttelPhone.Text.Trim(); customer.ShuiHao = txtShuiHao.Text.Trim(); customer.ZhangHao = txtZhangHao.Text.Trim(); if (rdoIsAdd.Checked == true) { customer.IsAddInfo = 1; } else { customer.IsAddInfo = 0; } using (var db = new OrderPrintEntities()) { if (db.customer.Count(r => r.companyName == customer.CompanyName) > 0) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('提交失败,一个公司名只能对应一个客户编号!');", true); return; } } num = CustomerManageBLL.Insertcustomer(customer); } if (num > 0) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.CloseBox();alert('提交成功');DetailsPageControl.ReflushList('CustomerManage/CustomerManage.aspx');", true); } else { ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('提交失败');", true); } }