GoGetOrder.aspx.cs 1.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041
  1. using BizCom;
  2. using Castle.ActiveRecord;
  3. using SQLData;
  4. using System;
  5. using System.Collections.Generic;
  6. using System.Data;
  7. using System.Text;
  8. using System.Web;
  9. using System.Web.UI;
  10. using System.Web.UI.WebControls;
  11. using Utils;
  12. using SiteCore;
  13. using Utils.Serialization;
  14. public partial class EOrder_GoGetOrder : BasePage
  15. {
  16. protected override void OnPreInit(EventArgs e)
  17. {
  18. _selfCheckPermission = true;
  19. }
  20. protected void Page_Load(object sender, EventArgs e)
  21. {
  22. if (!IsPostBack)
  23. {
  24. string ctid = GetString("ctid");
  25. StringBuilder sql = new StringBuilder();
  26. sql.AppendFormat("select * from view_erptradecell where ctid={0};", ctid);
  27. sql.AppendFormat("select * from CE_ErpProduct");
  28. DataSet ds = DbHelper.DbConn.ExecuteDataset(sql.ToString());
  29. AppendScript("tradeData=" + JsonString.DataTable2AjaxJson(ds.Tables[0]) + ";");
  30. AppendScript("productData=" + JsonString.DataTable2AjaxJson(ds.Tables[1]) + ";");
  31. }
  32. }
  33. }