public string zyselect(string orderid) { DataSet dw = ot.GetList(" id like '" + orderid + "'"); if (dw.Tables[0].Rows.Count > 0) { string qq = JsonHelper.DataSetToJson(dw.Tables[0]); qq = qq.Substring(1, qq.Length - 2); DataSet dww = ct.GetList(" OrderNumber like '" + dw.Tables[0].Rows[0]["OrderNumber"] + "'"); if (dww.Tables[0].Rows.Count > 0) { string qqs = JsonHelper.shenhezhuanhuan(dww.Tables[0], 2); qqs = qqs.Substring(1, qqs.Length - 2); return(@"{""data"":{""ds"":""1""," + qq + "," + qqs + "}}"); } else { return(@"{""data"":{""ds"":""1""," + qq + "}}"); } } else { return(@"{""data"":{""ds"":""0""}}"); } }
public void BindData() { #region //if (!Context.User.Identity.IsAuthenticated) //{ // return; //} //AccountsPrincipal user = new AccountsPrincipal(Context.User.Identity.Name); //if (user.HasPermissionID(PermId_Modify)) //{ // gridView.Columns[6].Visible = true; //} //if (user.HasPermissionID(PermId_Delete)) //{ // gridView.Columns[7].Visible = true; //} #endregion DataSet ds = new DataSet(); StringBuilder strWhere = new StringBuilder(); if (txtKeyword.Text.Trim() != "") { #warning 代码生成警告:请修改 keywordField 为需要匹配查询的真实字段名称 //strWhere.AppendFormat("keywordField like '%{0}%'", txtKeyword.Text.Trim()); } ds = bll.GetList(strWhere.ToString()); gridView.DataSource = ds; gridView.DataBind(); }
/// <summary> /// 删除(该操作员有生成单据停用否则删除) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void LinkButton2_Click(object sender, EventArgs e) { try { //获取button 控件 LinkButton lb = (LinkButton)sender; //获取传过来的commwntid int id = Convert.ToInt32(lb.CommandArgument); DataSet dwq = ot.GetList(" StaffmemberID like '" + id + "' or UserTabID like '" + id + "'"); if (dwq.Tables[0].Rows.Count > 0) { Model.Operator czy = op.GetModel(id); czy.BranchID = 0; bool a = op.Update(czy); if (a == true) { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('停用成功!');</script>"); bind(sql); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('停用失败!');</script>"); bind(sql); } } else { bool a = op.Delete(id); if (a == true) { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('删除成功!');</script>"); bind(sql); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('删除失败!');</script>"); bind(sql); } } } catch (Exception ee) { //Response.Write("<script>alert('确定异常 " + ee.Message + "')</script>"); ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('删除异常 " + ee.Message + "');</script>"); } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void LinkButton2_Click(object sender, EventArgs e) { try { //获取button 控件 LinkButton lb = (LinkButton)sender; //获取传过来的commwntid int id = Convert.ToInt32(lb.CommandArgument); DataSet de = or.GetList(" (PhotoID1 like '" + id + "' or PhotoID2 like '" + id + "' or PhotoID3 like '" + id + "' or PhotoID4 like '" + id + "' )"); if (de.Tables[0].Rows.Count > 0) { Model.phototab dd = pt.GetModel(id); dd.beizhu = "0"; bool a = pt.Update(dd); if (a == true) { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('停用成功!');</script>"); bind(); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('停用失败!');</script>"); bind(); } } else { bool aa = pt.Delete(id); if (aa == true) { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('删除成功!');</script>"); bind(); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('删除失败!');</script>"); bind(); } } } catch (Exception ee) { //Response.Write("<script>alert('确定异常 " + ee.Message + "')</script>"); ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('删除异常 " + ee.Message + "');</script>"); } }
public string jiekou(string id) { DataSet ds = or.GetList("OrderNumber like '" + id + "'"); if (ds.Tables[0].Rows.Count > 0) { int a = Convert.ToInt32(ds.Tables[0].Rows[0]["progress"]); if (a == 0) { return("单据生成草稿"); } else if (a == 1) { return("工厂确认,下单成功"); } else if (a == 2) { return("开始排产,进材料"); } else if (a == 3) { return("正在生产中"); } else if (a == 4) { return("以入库"); } else if (a == 5) { return("以付全款,准备送货"); } else { return("完成"); } } else { return("没有该单据"); } }
/// <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>"); } } } } } } } } } } } } }