protected void Page_Load(object sender, EventArgs e)
{
try
{
Aim.Portal.Web.WebPortalService.CheckLogon();
}
catch
{
Response.Write("<script> window.location.href = '/Login.aspx';</script>");
Response.End();
}
string sql = "";
string where = "";
DataTable dt;
string action = Request["action"];
string id = Request["id"];
switch (action)
{
case "load":
string Number = Request["Number"];
if (!string.IsNullOrEmpty(Number))
{
where += " and number like '%" + Number + "%'";
}
if (!string.IsNullOrEmpty(Request["ProductCode"]))
{
where += " and Id in (select distinct OId from SHHG_AimExamine..OrdersPart where PCode like '%" + Request["ProductCode"] + "%')";
}
sql = @"select * from SHHG_AimExamine..SaleOrders where
CId in ('b1b1e57e-1e6e-4d75-a631-089370041d5b','c241fa9e-813d-47cc-9267-2f26330fa957','db2b0081-53dc-41f3-81e7-893c0c6333d8')" + where;
dt = DataHelper.QueryDataTable(GetPageSql(sql));
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + ",total:" + totalProperty + "}");
Response.End();
break;
case "loaddetail":
sql = @"select a.* from SHHG_AimExamine..OrdersPart a
left join SHHG_AimExamine..SaleOrders b on b.Id=a.OId where a.OId= '" + id + "'";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{innerrows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
case "delete":
IList <OrderDetail_FenGongSi> odEnts = OrderDetail_FenGongSi.FindAllByProperty(OrderDetail_FenGongSi.Prop_Order_FenGongSi_Id, id);
foreach (OrderDetail_FenGongSi odEnt in odEnts)
{
sql = "select isnull(sum(Quantity),0) from SHHG_AimExamine..OrderDetail_FenGongSi where OrderPart_Id='" + odEnt.OrderPart_Id + "'";
OrdersPart opEnt = OrdersPart.Find(odEnt.OrderPart_Id);
opEnt.SaleQuan = DataHelper.QueryValue <Int32>(sql);
opEnt.DoUpdate();
odEnt.Delete();
}
Order_FenGongSi oEnt = Order_FenGongSi.Find(id);
oEnt.DoDelete();
Response.Write("{success:true}");
Response.End();
break;
case "loadsecond":
sql = @"select a.*,b.CustomerName,b.CreateTime from SHHG_AimExamine..OrderDetail_FenGongSi a
left join SHHG_AimExamine..Order_FenGongSi b on b.Id=a.Order_FenGongSi_Id where a.OrderPart_Id= '" + Request["orderpartid"] + "' order by b.CreateTime asc";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{innerrows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Aim.Portal.Web.WebPortalService.CheckLogon();
}
catch
{
Response.Write("<script> window.location.href = '/Login.aspx';</script>");
Response.End();
}
string sql = "";
string where = "";
DataTable dt;
string action = Request["action"];
string id = Request["id"];
switch (action)
{
case "load":
string Number = Request["Number"];
if (!string.IsNullOrEmpty(Number))
{
where += " and number like '%" + Number + "%'";
}
if (!string.IsNullOrEmpty(Request["ProductCode"]))
{
where += " and Id in (select distinct Order_FenGongSi_Id from SHHG_AimExamine..OrderDetail_FenGongSi where Code like '%" + Request["ProductCode"] + "%')";
}
SysUser suEnt = SysUser.Find(Aim.Portal.Web.WebPortalService.CurrentUserInfo.UserID);
if (!string.IsNullOrEmpty(suEnt.LastLogIP))
{
where += " and FenGongSiId='" + suEnt.LastLogIP + "' ";
}
sql = @"select * from SHHG_AimExamine..Order_FenGongSi where 1=1 " + where;
dt = DataHelper.QueryDataTable(GetPageSql(sql));
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + ",total:" + totalProperty + "}");
Response.End();
break;
case "loaddetail":
sql = @"select a.*,c.Number as PurchaseNo from SHHG_AimExamine..OrderDetail_FenGongSi a
left join SHHG_AimExamine..OrdersPart b on a.OrderPart_Id=b.Id
left join SHHG_AimExamine..SaleOrders c on c.Id=b.OId where a.Order_FenGongSi_Id= '" + id + "'";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{innerrows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
case "delete":
IList <OrderDetail_FenGongSi> odEnts = OrderDetail_FenGongSi.FindAllByProperty(OrderDetail_FenGongSi.Prop_Order_FenGongSi_Id, id);
foreach (OrderDetail_FenGongSi odEnt in odEnts)
{
sql = "select isnull(sum(Quantity),0) from SHHG_AimExamine..OrderDetail_FenGongSi where OrderPart_Id='" + odEnt.OrderPart_Id + "'";
OrdersPart opEnt = OrdersPart.Find(odEnt.OrderPart_Id);
opEnt.SaleQuan = DataHelper.QueryValue <Int32>(sql);
opEnt.DoUpdate();
odEnt.Delete();
}
Order_FenGongSi oEnt = Order_FenGongSi.Find(id);
oEnt.DoDelete();
Response.Write("{success:true}");
Response.End();
break;
}
}
