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();
}
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
{
}
}
}
}
}
