public string orderadd(string json) { try { json = @"{""OrderNumber"":""201812050001"",""MemberName"":""李四先生"",""MemberPhone"":""12356565656"",""MemberPhone1"":"""",""MemberAdd"":""铁西区南十路23号2-3-2"",""HomemadeID"":""2"",""StaffmemberID"":""2"",""UserTabID"":""3"",""PhotoID1"":""3"",""PhotoID2"":"""",""PhotoID3"":"""",""PhotoID4"":""5"",""validity"":""2018-12-06"",""Deposit"":""400.50"",""AllMoney"":""4500.50"",""alllength"":""33.22"",""Imperial"":""22.22"",""QhWidth"":""11.11"",""Beizhuwg"":""外购商品备注!!"",""Beizhuzz"":""自制商品备注!!"",""Zengsong"":""赠品备注"",""Zhuangtai2"":""1"",""table"": [{""CommodityID"": ""桌子卡门"",""by1"": ""1""}, {""CommodityID"": ""椅子卡门"",""by1"": ""2""}]}"; JObject joo = (JObject)JsonConvert.DeserializeObject(json); string OrderNumber = joo["OrderNumber"].ToString(); string MemberName = joo["MemberName"].ToString(); string MemberPhone = joo["MemberPhone"].ToString(); string MemberPhone1 = joo["MemberPhone1"].ToString(); string MemberAdd = joo["MemberAdd"].ToString(); string HomemadeID = joo["HomemadeID"].ToString(); string StaffmemberID = joo["StaffmemberID"].ToString(); string UserTabID = joo["UserTabID"].ToString(); string PhotoID1 = joo["PhotoID1"].ToString(); string PhotoID2 = joo["PhotoID2"].ToString(); string PhotoID3 = joo["PhotoID3"].ToString(); string PhotoID4 = joo["PhotoID4"].ToString(); string validity = joo["validity"].ToString(); string Deposit = joo["Deposit"].ToString(); string AllMoney = joo["AllMoney"].ToString(); string alllength = joo["alllength"].ToString(); string Imperial = joo["Imperial"].ToString(); string QhWidth = joo["QhWidth"].ToString(); string Beizhuwg = joo["Beizhuwg"].ToString(); string Beizhuzz = joo["Beizhuzz"].ToString(); string Zengsong = joo["Zengsong"].ToString(); string Zhuangtai2 = joo["Zhuangtai2"].ToString(); string table = joo["table"].ToString(); DataSet ds = ot.GetList(" validity='" + validity + "'"); if (ds.Tables[0].Rows.Count >= 15) { return(@"{""data"":{""ds"":""2""}}"); } else { JArray je = (JArray)JsonConvert.DeserializeObject(table); DataTable spb = new DataTable(); spb.Columns.Add("CommodityID"); spb.Columns.Add("by1"); foreach (JObject iom in je) { spb.Rows.Add(iom["CommodityID"].ToString(), iom["by1"].ToString()); } string qrEncoding = "BYTE"; string level = "M"; int version = 8; int scale = 3; QRCodeEncoder qrCodeEncoder = new QRCodeEncoder(); string encoding = qrEncoding; switch (encoding) { case "Byte": qrCodeEncoder.QRCodeEncodeMode = QRCodeEncoder.ENCODE_MODE.BYTE; break; case "AlphaNumeric": qrCodeEncoder.QRCodeEncodeMode = QRCodeEncoder.ENCODE_MODE.ALPHA_NUMERIC; break; case "Numeric": qrCodeEncoder.QRCodeEncodeMode = QRCodeEncoder.ENCODE_MODE.NUMERIC; break; default: qrCodeEncoder.QRCodeEncodeMode = QRCodeEncoder.ENCODE_MODE.BYTE; break; } qrCodeEncoder.QRCodeScale = scale; qrCodeEncoder.QRCodeVersion = version; switch (level) { case "L": qrCodeEncoder.QRCodeErrorCorrect = QRCodeEncoder.ERROR_CORRECTION.L; break; case "M": qrCodeEncoder.QRCodeErrorCorrect = QRCodeEncoder.ERROR_CORRECTION.M; break; case "Q": qrCodeEncoder.QRCodeErrorCorrect = QRCodeEncoder.ERROR_CORRECTION.Q; break; default: qrCodeEncoder.QRCodeErrorCorrect = QRCodeEncoder.ERROR_CORRECTION.H; break; } string serial = @"http://192.168.1.150:8585/xianshi.asmx/jiekou?id=" + OrderNumber; System.Drawing.Image image = qrCodeEncoder.Encode(serial); string filename = OrderNumber + ".jpg"; string filepath = Server.MapPath(@"~\qrcode111") + "\\" + filename; //如果文件夹不存在,则创建 //if (!Directory.Exists(filepath)) // Directory.CreateDirectory(filepath); System.IO.FileStream fs = new System.IO.FileStream(filepath, System.IO.FileMode.OpenOrCreate, System.IO.FileAccess.Write); image.Save(fs, System.Drawing.Imaging.ImageFormat.Jpeg); fs.Close(); image.Dispose(); Model.OrderTab ort = new Model.OrderTab(); ort.MemberName = MemberName; ort.MemberPhone = MemberPhone; ort.MemberPhone1 = MemberPhone1; ort.MemberAdd = MemberAdd; ort.Orderdate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")); ort.OrderNumber = OrderNumber; ort.UserTabID = Convert.ToInt32(UserTabID); if (PhotoID1 != "") { ort.PhotoID1 = Convert.ToInt32(PhotoID1); } else { ort.PhotoID1 = 0; } if (PhotoID2 != "") { ort.PhotoID2 = Convert.ToInt32(PhotoID2); } else { ort.PhotoID2 = 0; } if (PhotoID3 != "") { ort.PhotoID3 = Convert.ToInt32(PhotoID3); } else { ort.PhotoID3 = 0; } if (PhotoID4 != "") { ort.PhotoID4 = Convert.ToInt32(PhotoID4); } else { ort.PhotoID4 = 0; } ort.qrcode = "../qrcode111/" + filename; ort.validity = Convert.ToDateTime(validity); ort.progress = 0; ort.AllMoney = Convert.ToDecimal(AllMoney); if (Deposit == "") { ort.Deposit = 0; } else { ort.Deposit = Convert.ToDecimal(Deposit); } ort.alllength = Convert.ToDecimal(alllength); ort.Imperial = Convert.ToDecimal(Imperial); ort.QhWidth = Convert.ToDecimal(QhWidth); ort.Beizhuwg = Beizhuwg; ort.Beizhuzz = Beizhuzz; ort.Zengsong = Zengsong; ort.Zhuangtai1 = 0;//草稿 ort.Zhuangtai2 = Convert.ToInt32(Zhuangtai2); ort.StaffmemberID = Convert.ToInt32(StaffmemberID); ort.HomemadeID = Convert.ToInt32(HomemadeID); if (spb.Rows.Count > 0) { for (int i = 0; i < spb.Rows.Count; i++) { Model.ContractTab con = new Model.ContractTab(); con.OrderNumber = OrderNumber; con.CommodityID = spb.Rows[i]["CommodityID"].ToString(); con.By1 = Convert.ToDecimal(spb.Rows[i]["By1"]); ct.Add(con); } } Model.Currentaccount cu = new Model.Currentaccount(); cu.billnumber = OrderNumber; cu.type = 1; cu.receipt = DateTime.Now; if (Deposit == "") { cu.money = 0; } else { cu.money = Convert.ToDecimal(Deposit); } int b = cur.Add(cu); int a = ot.Add(ort); if (a > 0 && b > 0) { return(@"{""data"":{""ds"":""1""}}"); } else { return(@"{""data"":{""ds"":""0""}}"); } } } catch (Exception ee) { return(@"{""data"":{""ds"":""-1"",""sm"":""数据处理有误:" + ee.Message + "\"}}"); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtMemberID.Text)) { strErr += "MemberID格式错误!\\n"; } if (this.txtMemberName.Text.Trim().Length == 0) { strErr += "MemberName不能为空!\\n"; } if (this.txtMemberPhone.Text.Trim().Length == 0) { strErr += "MemberPhone不能为空!\\n"; } if (this.txtMemberPhone1.Text.Trim().Length == 0) { strErr += "MemberPhone1不能为空!\\n"; } if (this.txtMemberAdd.Text.Trim().Length == 0) { strErr += "MemberAdd不能为空!\\n"; } if (!PageValidate.IsDateTime(txtOrderdate.Text)) { strErr += "Orderdate格式错误!\\n"; } if (this.txtOrderNumber.Text.Trim().Length == 0) { strErr += "OrderNumber不能为空!\\n"; } if (!PageValidate.IsNumber(txtStaffmemberID.Text)) { strErr += "StaffmemberID格式错误!\\n"; } if (this.txtStaffmembername.Text.Trim().Length == 0) { strErr += "Staffmembername不能为空!\\n"; } if (!PageValidate.IsNumber(txtUserTabID.Text)) { strErr += "UserTabID格式错误!\\n"; } if (!PageValidate.IsNumber(txtPhotoID.Text)) { strErr += "PhotoID格式错误!\\n"; } if (!PageValidate.IsDateTime(txtvalidity.Text)) { strErr += "validity格式错误!\\n"; } if (!PageValidate.IsNumber(txtprogress.Text)) { strErr += "progress格式错误!\\n"; } if (!PageValidate.IsDecimal(txtDeposit.Text)) { strErr += "Deposit格式错误!\\n"; } if (!PageValidate.IsDecimal(txtAllMoney.Text)) { strErr += "AllMoney格式错误!\\n"; } if (!PageValidate.IsDecimal(txtalllength.Text)) { strErr += "alllength格式错误!\\n"; } if (!PageValidate.IsDecimal(txtImperial.Text)) { strErr += "Imperial格式错误!\\n"; } if (!PageValidate.IsDecimal(txtQhWidth.Text)) { strErr += "QhWidth格式错误!\\n"; } if (this.txtBeizhuwg.Text.Trim().Length == 0) { strErr += "Beizhuwg不能为空!\\n"; } if (this.txtBeizhuzz.Text.Trim().Length == 0) { strErr += "Beizhuzz不能为空!\\n"; } if (this.txtZengsong.Text.Trim().Length == 0) { strErr += "Zengsong不能为空!\\n"; } if (!PageValidate.IsNumber(txtZhuangtai1.Text)) { strErr += "Zhuangtai1格式错误!\\n"; } if (!PageValidate.IsNumber(txtZhuangtai2.Text)) { strErr += "Zhuangtai2格式错误!\\n"; } if (!PageValidate.IsDecimal(txtBy1.Text)) { strErr += "By1格式错误!\\n"; } if (!PageValidate.IsDecimal(txtBy2.Text)) { strErr += "By2格式错误!\\n"; } if (!PageValidate.IsDecimal(txtBy3.Text)) { strErr += "By3格式错误!\\n"; } if (this.txtBy4.Text.Trim().Length == 0) { strErr += "By4不能为空!\\n"; } if (this.txtBy5.Text.Trim().Length == 0) { strErr += "By5不能为空!\\n"; } if (this.txtBy6.Text.Trim().Length == 0) { strErr += "By6不能为空!\\n"; } if (this.txtBy7.Text.Trim().Length == 0) { strErr += "By7不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int MemberID = int.Parse(this.txtMemberID.Text); string MemberName = this.txtMemberName.Text; string MemberPhone = this.txtMemberPhone.Text; string MemberPhone1 = this.txtMemberPhone1.Text; string MemberAdd = this.txtMemberAdd.Text; DateTime Orderdate = DateTime.Parse(this.txtOrderdate.Text); string OrderNumber = this.txtOrderNumber.Text; int StaffmemberID = int.Parse(this.txtStaffmemberID.Text); string Staffmembername = this.txtStaffmembername.Text; int UserTabID = int.Parse(this.txtUserTabID.Text); int PhotoID = int.Parse(this.txtPhotoID.Text); DateTime validity = DateTime.Parse(this.txtvalidity.Text); int progress = int.Parse(this.txtprogress.Text); decimal Deposit = decimal.Parse(this.txtDeposit.Text); decimal AllMoney = decimal.Parse(this.txtAllMoney.Text); decimal alllength = decimal.Parse(this.txtalllength.Text); decimal Imperial = decimal.Parse(this.txtImperial.Text); decimal QhWidth = decimal.Parse(this.txtQhWidth.Text); string Beizhuwg = this.txtBeizhuwg.Text; string Beizhuzz = this.txtBeizhuzz.Text; string Zengsong = this.txtZengsong.Text; int Zhuangtai1 = int.Parse(this.txtZhuangtai1.Text); int Zhuangtai2 = int.Parse(this.txtZhuangtai2.Text); decimal By1 = decimal.Parse(this.txtBy1.Text); decimal By2 = decimal.Parse(this.txtBy2.Text); decimal By3 = decimal.Parse(this.txtBy3.Text); string By4 = this.txtBy4.Text; string By5 = this.txtBy5.Text; string By6 = this.txtBy6.Text; string By7 = this.txtBy7.Text; Maticsoft.Model.OrderTab model = new Maticsoft.Model.OrderTab(); model.MemberID = MemberID; model.MemberName = MemberName; model.MemberPhone = MemberPhone; model.MemberPhone1 = MemberPhone1; model.MemberAdd = MemberAdd; model.Orderdate = Orderdate; model.OrderNumber = OrderNumber; model.StaffmemberID = StaffmemberID; model.Staffmembername = Staffmembername; model.UserTabID = UserTabID; model.PhotoID = PhotoID; model.validity = validity; model.progress = progress; model.Deposit = Deposit; model.AllMoney = AllMoney; model.alllength = alllength; model.Imperial = Imperial; model.QhWidth = QhWidth; model.Beizhuwg = Beizhuwg; model.Beizhuzz = Beizhuzz; model.Zengsong = Zengsong; model.Zhuangtai1 = Zhuangtai1; model.Zhuangtai2 = Zhuangtai2; model.By1 = By1; model.By2 = By2; model.By3 = By3; model.By4 = By4; model.By5 = By5; model.By6 = By6; model.By7 = By7; Maticsoft.BLL.OrderTab bll = new Maticsoft.BLL.OrderTab(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 生成单据方法 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button1_Click(object sender, EventArgs e) { if (zzspid == 0) { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('请选择自制商品');</script>"); } else { if (TextBox7.Text.Trim() == "") { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('请添客户名称');</script>"); } else { if (TextBox8.Text.Trim() == "" && TextBox9.Text.Trim() == "") { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('至少添加一个电话号');</script>"); } else { if (TextBox10.Text.Trim() == "") { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('请添客户地址');</script>"); } else { if (TextBox1.Text.Trim() == "") { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('请添总长');</script>"); } else { if (TextBox2.Text.Trim() == "") { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('请添妃长');</script>"); } else { if (TextBox3.Text.Trim() == "") { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('请添前后宽');</script>"); } else { if (TextBox11.Text.Trim() == "") { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('请选送货日期');</script>"); } else { if (TextBox12.Text.Trim() == "") { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('请添单据总金额');</script>"); } else { DataSet ds = ot.GetList(" validity='" + TextBox11.Text + "'"); if (ds.Tables[0].Rows.Count >= 15) { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('以达到送货上线');</script>"); } else { if (DropDownList8.Text == "0") { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('请选择付款状况');</script>"); } else { string qrEncoding = "BYTE"; string level = "M"; int version = 8; int scale = 3; QRCodeEncoder qrCodeEncoder = new QRCodeEncoder(); string encoding = qrEncoding; switch (encoding) { case "Byte": qrCodeEncoder.QRCodeEncodeMode = QRCodeEncoder.ENCODE_MODE.BYTE; break; case "AlphaNumeric": qrCodeEncoder.QRCodeEncodeMode = QRCodeEncoder.ENCODE_MODE.ALPHA_NUMERIC; break; case "Numeric": qrCodeEncoder.QRCodeEncodeMode = QRCodeEncoder.ENCODE_MODE.NUMERIC; break; default: qrCodeEncoder.QRCodeEncodeMode = QRCodeEncoder.ENCODE_MODE.BYTE; break; } qrCodeEncoder.QRCodeScale = scale; qrCodeEncoder.QRCodeVersion = version; switch (level) { case "L": qrCodeEncoder.QRCodeErrorCorrect = QRCodeEncoder.ERROR_CORRECTION.L; break; case "M": qrCodeEncoder.QRCodeErrorCorrect = QRCodeEncoder.ERROR_CORRECTION.M; break; case "Q": qrCodeEncoder.QRCodeErrorCorrect = QRCodeEncoder.ERROR_CORRECTION.Q; break; default: qrCodeEncoder.QRCodeErrorCorrect = QRCodeEncoder.ERROR_CORRECTION.H; break; } string serial = @"http://192.168.1.150:8585/xianshi.asmx/jiekou?id=" + Label1.Text; System.Drawing.Image image = qrCodeEncoder.Encode(serial); string filename = Label1.Text + ".jpg"; string filepath = Server.MapPath(@"~\qrcode111") + "\\" + filename; //如果文件夹不存在,则创建 //if (!Directory.Exists(filepath)) // Directory.CreateDirectory(filepath); System.IO.FileStream fs = new System.IO.FileStream(filepath, System.IO.FileMode.OpenOrCreate, System.IO.FileAccess.Write); image.Save(fs, System.Drawing.Imaging.ImageFormat.Jpeg); fs.Close(); image.Dispose(); Model.OrderTab ort = new Model.OrderTab(); ort.MemberName = TextBox7.Text; ort.MemberPhone = TextBox8.Text; ort.MemberPhone1 = TextBox9.Text; ort.MemberAdd = TextBox10.Text; ort.Orderdate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")); ort.OrderNumber = Label1.Text; ort.UserTabID = czy; ort.PhotoID1 = tp1; ort.PhotoID2 = tp2; ort.PhotoID3 = tp3; ort.PhotoID4 = tp4; ort.qrcode = "../qrcode111/" + filename; ort.validity = Convert.ToDateTime(TextBox11.Text); ort.progress = 0; ort.AllMoney = Convert.ToDecimal(TextBox12.Text); if (TextBox13.Text.Trim() == "") { ort.Deposit = 0; } else { ort.Deposit = Convert.ToDecimal(TextBox13.Text); } ort.alllength = Convert.ToDecimal(TextBox1.Text); ort.Imperial = Convert.ToDecimal(TextBox2.Text); ort.QhWidth = Convert.ToDecimal(TextBox3.Text); ort.Beizhuwg = TextBox5.Text; ort.Beizhuzz = TextBox4.Text; ort.Zengsong = TextBox6.Text; ort.Zhuangtai1 = 0;//草稿 ort.Zhuangtai2 = Convert.ToInt32(DropDownList8.Text); ort.StaffmemberID = Convert.ToInt32(DropDownList9.Text); ort.HomemadeID = zzspid; if (TextBox14.Text.Trim() != "") { Model.ContractTab con = new Model.ContractTab(); con.OrderNumber = Label1.Text; con.CommodityID = TextBox14.Text; con.By1 = 1; ct.Add(con); } if (TextBox15.Text.Trim() != "") { Model.ContractTab con = new Model.ContractTab(); con.OrderNumber = Label1.Text; con.CommodityID = TextBox15.Text; con.By1 = 2; ct.Add(con); } if (TextBox16.Text.Trim() != "") { Model.ContractTab con = new Model.ContractTab(); con.OrderNumber = Label1.Text; con.CommodityID = TextBox16.Text; con.By1 = 3; ct.Add(con); } if (TextBox17.Text.Trim() != "") { Model.ContractTab con = new Model.ContractTab(); con.OrderNumber = Label1.Text; con.CommodityID = TextBox17.Text; con.By1 = 4; ct.Add(con); } if (TextBox18.Text.Trim() != "") { Model.ContractTab con = new Model.ContractTab(); con.OrderNumber = Label1.Text; con.CommodityID = TextBox18.Text; con.By1 = 5; ct.Add(con); } if (TextBox19.Text.Trim() != "") { Model.ContractTab con = new Model.ContractTab(); con.OrderNumber = Label1.Text; con.CommodityID = TextBox19.Text; con.By1 = 6; ct.Add(con); } if (TextBox20.Text.Trim() != "") { Model.ContractTab con = new Model.ContractTab(); con.OrderNumber = Label1.Text; con.CommodityID = TextBox20.Text; con.By1 = 7; ct.Add(con); } Model.Currentaccount cu = new Model.Currentaccount(); cu.billnumber = Label1.Text; cu.type = 1; cu.receipt = DateTime.Now; if (TextBox13.Text.Trim() == "") { cu.money = 0; } else { cu.money = Convert.ToDecimal(TextBox13.Text); } int b = cur.Add(cu); int a = ot.Add(ort); if (a > 0 && b > 0) { Response.Write(string.Format("<script>alert('添加成功!');location='danjuluru.aspx'</script>")); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('添加失败!');</script>"); } } } } } } } } } } } } }