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>");
}
}
}
}
}
}
}
}
}
}
}
}
}
