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 + "\"}}");
}
}
Maticsoft.BLL.Homemadetab hot = new BLL.Homemadetab(); //自制商品
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int id = Convert.ToInt32(Request.QueryString["id"].ToString());
Model.OrderTab or = ot.GetModel(id);
Label1.Text = or.OrderNumber;
if (or.PhotoID1 != 0)
{
Model.phototab ph = pt.GetModel(Convert.ToInt32(or.PhotoID1));
ImageButton1.ImageUrl = ph.Photourl;
}
if (or.PhotoID2 != 0)
{
Model.phototab ph = pt.GetModel(Convert.ToInt32(or.PhotoID2));
ImageButton2.ImageUrl = ph.Photourl;
}
if (or.PhotoID3 != 0)
{
Model.phototab ph = pt.GetModel(Convert.ToInt32(or.PhotoID3));
ImageButton3.ImageUrl = ph.Photourl;
}
if (or.PhotoID4 != 0)
{
Model.phototab ph = pt.GetModel(Convert.ToInt32(or.PhotoID4));
ImageButton4.ImageUrl = ph.Photourl;
}
Label3.Text = or.alllength.ToString();
Label4.Text = or.Imperial.ToString();
Label5.Text = or.QhWidth.ToString();
Label6.Text = or.Beizhuzz;
Label7.Text = or.Zengsong;
Label8.Text = or.MemberName;
Label9.Text = or.MemberPhone;
Label10.Text = or.MemberPhone1;
Label11.Text = or.MemberAdd;
Label12.Text = Convert.ToDateTime(or.validity).ToString("yyyy-MM-dd");
Label13.Text = or.AllMoney.ToString();
Label14.Text = or.Deposit.ToString();
Label15.Text = or.Beizhuwg;
Maticsoft.Model.Homemadetab ho = hot.GetModel(Convert.ToInt32(or.HomemadeID));
ImageButton5.ImageUrl = ho.Photourl;
if (or.Zhuangtai2 == 1)
{
Label23.Text = "未付全款";
}
else if (or.Zhuangtai2 == 2)
{
Label23.Text = "已付全款";
}
else
{
Label23.Text = "状态异常";
}
DataSet ds = ct.GetList(" OrderNumber like '" + Label1.Text + "'");
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Model.ContractTab con = ct.GetModel(Convert.ToInt32(ds.Tables[0].Rows[i]["id"]));
if (con.By1 == 1)
{
Label16.Text = con.CommodityID;
}
else if (con.By1 == 2)
{
Label17.Text = con.CommodityID;
}
else if (con.By1 == 3)
{
Label18.Text = con.CommodityID;
}
else if (con.By1 == 4)
{
Label19.Text = con.CommodityID;
}
else if (con.By1 == 5)
{
Label20.Text = con.CommodityID;
}
else if (con.By1 == 6)
{
Label21.Text = con.CommodityID;
}
else if (con.By1 == 7)
{
Label22.Text = con.CommodityID;
}
else
{
}
if (i == ds.Tables[0].Rows.Count - 1)
{
if (Label16.Text == "")
{
Label16.Text = "无";
}
if (Label17.Text == "")
{
Label17.Text = "无";
}
if (Label18.Text == "")
{
Label18.Text = "无";
}
if (Label19.Text == "")
{
Label19.Text = "无";
}
if (Label20.Text == "")
{
Label20.Text = "无";
}
if (Label21.Text == "")
{
Label21.Text = "无";
}
if (Label22.Text == "")
{
Label22.Text = "无";
}
}
}
}
else
{
Label16.Text = "无";
Label17.Text = "无";
Label18.Text = "无";
Label19.Text = "无";
Label20.Text = "无";
Label21.Text = "无";
Label22.Text = "无";
}
}
}
static int zzspid = 0; //自制商品ID
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
id = Convert.ToInt32(Request.QueryString["id"].ToString());
bind();
bind1();
Model.OrderTab ord = ot.GetModel(id);
Label1.Text = ord.OrderNumber;
if (ord.PhotoID1 != 0)
{
Model.phototab ph = pt.GetModel(Convert.ToInt32(ord.PhotoID1));
ImageButton1.ImageUrl = ph.Photourl;
tp1 = ph.id;
}
if (ord.PhotoID2 != 0)
{
Model.phototab ph = pt.GetModel(Convert.ToInt32(ord.PhotoID2));
ImageButton2.ImageUrl = ph.Photourl;
tp2 = ph.id;
}
if (ord.PhotoID3 != 0)
{
Model.phototab ph = pt.GetModel(Convert.ToInt32(ord.PhotoID3));
ImageButton3.ImageUrl = ph.Photourl;
tp3 = ph.id;
}
if (ord.PhotoID4 != 0)
{
Model.phototab ph = pt.GetModel(Convert.ToInt32(ord.PhotoID4));
ImageButton4.ImageUrl = ph.Photourl;
tp4 = ph.id;
}
TextBox1.Text = ord.alllength.ToString();
TextBox2.Text = ord.Imperial.ToString();
TextBox3.Text = ord.QhWidth.ToString();
TextBox4.Text = ord.Beizhuzz;
TextBox5.Text = ord.Beizhuwg;
TextBox6.Text = ord.Zengsong;
TextBox7.Text = ord.MemberName;
TextBox8.Text = ord.MemberPhone;
TextBox9.Text = ord.MemberPhone1;
TextBox10.Text = ord.MemberAdd;
TextBox11.Text = Convert.ToDateTime(ord.validity).ToString("yyyy-MM-dd");
TextBox12.Text = ord.AllMoney.ToString();
Label4.Text = ord.Deposit.ToString();
Model.Homemadetab hom = ht.GetModel(Convert.ToInt32(ord.HomemadeID));
zzspid = hom.id;
ImageButton5.ImageUrl = hom.Photourl;
DataSet ds = ct.GetList(" OrderNumber like '" + Label1.Text + "'");
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Model.ContractTab con = ct.GetModel(Convert.ToInt32(ds.Tables[0].Rows[i]["id"]));
if (con.By1 == 1)
{
TextBox14.Text = con.CommodityID;
}
else if (con.By1 == 2)
{
TextBox15.Text = con.CommodityID;
}
else if (con.By1 == 3)
{
TextBox16.Text = con.CommodityID;
}
else if (con.By1 == 4)
{
TextBox17.Text = con.CommodityID;
}
else if (con.By1 == 5)
{
TextBox18.Text = con.CommodityID;
}
else if (con.By1 == 6)
{
TextBox19.Text = con.CommodityID;
}
else if (con.By1 == 7)
{
TextBox20.Text = con.CommodityID;
}
else
{
}
}
}
}
}
/// <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
{
Model.OrderTab ort = ot.GetModel(id);
ort.MemberName = TextBox7.Text;
ort.MemberPhone = TextBox8.Text;
ort.MemberPhone1 = TextBox9.Text;
ort.MemberAdd = TextBox10.Text;
ort.OrderNumber = Label1.Text;
ort.PhotoID1 = tp1;
ort.PhotoID2 = tp2;
ort.PhotoID3 = tp3;
ort.PhotoID4 = tp4;
ort.validity = Convert.ToDateTime(TextBox11.Text);
ort.progress = 0;
ort.AllMoney = Convert.ToDecimal(TextBox12.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.HomemadeID = zzspid;
ct.DeleteList(" OrderNumber like '" + Label1.Text + "'");
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);
}
bool a = ot.Update(ort);
if (a == true)
{
Response.Write(string.Format("<script>alert('修改成功！');location='zhiyuandanjulist.aspx'</script>"));
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('修改失败！');</script>");
}
}
}
}
}
}
}
}
}
}
}
}
/// <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>");
}
}
}
}
}
}
}
}
}
}
}
}
}
