protected void Page_Load(object sender, EventArgs e) { //SYS_BILL_EXD bill = new SYS_BILL_EXD(int.Parse(Request["BillID"])); //litView.Text = bill.HtmlEditForm(); //litList.Text = bill.HtmlList(); int billid = 0; if (Request["BillID"] != null) { billid = int.Parse(Request["BillID"]); List <SYS_BILL_COL> list = BLLTable <SYS_BILL_COL> .Factory(conn).Select(SYS_BILL_COL.Attribute.BILL_ID, billid); repBillCol.DataSource = list; repBillCol.DataBind(); if (list.Count > 0) { SYS_BILL_BLL bill = new SYS_BILL_BLL(billid); litList.Text = bill.HtmlList(null); //litView.Text = bill.HtmlEditForm(); for (int i = 0; i < 8; i++) { litView.Text += "<tr id='tr_" + i + "'><td class='label' id='tr_" + i + "_1'> " + i + "</td><td> </td><td class='label' id='tr_" + i + "_2'> </td><td> a" + i + "</td></tr>"; } } } }
protected void Page_Load(object sender, EventArgs e) { //SYS_BILL_EXD bill = new SYS_BILL_EXD(int.Parse(Request["BillID"])); //litView.Text = bill.HtmlEditForm(); //litList.Text = bill.HtmlList(); int billid = 0; if (Request["BillID"] != null) { billid = int.Parse(Request["BillID"]); List<SYS_BILL_COL> list = BLLTable<SYS_BILL_COL>.Factory(conn).Select(SYS_BILL_COL.Attribute.BILL_ID, billid); repBillCol.DataSource = list; repBillCol.DataBind(); if (list.Count > 0) { SYS_BILL_BLL bill = new SYS_BILL_BLL(billid); litList.Text = bill.HtmlList(null); //litView.Text = bill.HtmlEditForm(); for (int i = 0; i < 8; i++) { litView.Text += "<tr id='tr_" + i + "'><td class='label' id='tr_" + i + "_1'> "+i+"</td><td> </td><td class='label' id='tr_" + i + "_2'> </td><td> a"+i+"</td></tr>"; } } } }
protected void btnFind_Click(object sender, EventArgs e) { if (BillID > 0) { SYS_BILL_BLL billExd = new SYS_BILL_BLL(BillID); SYS_BILL_OBJ condBill = billExd.GetBillObjByFindForm(); //Response.Write(billExd.GetFindColsObjectString()); litFind.Text = billExd.HtmlFindForm(condBill); litList.Text = billExd.HtmlList(condBill); } }
protected void Page_Load(object sender, EventArgs e) { SYS_BILL_EXD bill = new SYS_BILL_EXD(int.Parse(Request["BillID"])); SYS_BILL_BLL billExd = new SYS_BILL_BLL(int.Parse(Request["BillID"])); litView.Text = billExd.HtmlEditForm(); hidAppPath.Value = WebHelper.GetAppPath(); List <SYS_BILL_COL> cols = bill.GetColList(); Dictionary <string, int> tbkeynum = new Dictionary <string, int>(); if (cols != null) { for (int i = 0; i < cols.Count; i++) { if (!tbkeynum.ContainsKey(cols[i].TABLE_NAME)) { tbkeynum.Add(cols[i].TABLE_NAME, 0); } if (cols[i].ISPK == "1") { tbkeynum[cols[i].TABLE_NAME] += 1; } } } //foreach (KeyValuePair<string, int> key in tbkeynum) { // //Response.Write(key.Key); // if (key.Value == 0) // { // if (key.Key != bill.Base.TABLE_NAME) // { // litWarn.Text += "主表单里未配置外部关联表" + key.Key + "的主键,无法与外部表信息同步。"; // } // else { // litWarn.Text += key.Key + "未配置主键。"; // } // } // else if (key.Value > 1) // { // if (key.Key != bill.Base.TABLE_NAME) // { // litWarn.Text += "主表单里配置了多个外部关联表"+key.Key + "的主键,可能导致信息同步异常。"; // } // } //} litList.Text = billExd.HtmlList(null); }
protected void Page_Load(object sender, EventArgs e) { SYS_BILL_EXD bill = new SYS_BILL_EXD(int.Parse(Request["BillID"])); SYS_BILL_BLL billExd = new SYS_BILL_BLL(int.Parse(Request["BillID"])); litView.Text = billExd.HtmlEditForm(); hidAppPath.Value = WebHelper.GetAppPath(); List<SYS_BILL_COL> cols = bill.GetColList(); Dictionary<string, int> tbkeynum = new Dictionary<string, int>(); if (cols != null) { for (int i = 0; i < cols.Count; i++) { if (!tbkeynum.ContainsKey(cols[i].TABLE_NAME)) { tbkeynum.Add(cols[i].TABLE_NAME, 0); } if (cols[i].ISPK == "1") { tbkeynum[cols[i].TABLE_NAME] += 1; } } } //foreach (KeyValuePair<string, int> key in tbkeynum) { // //Response.Write(key.Key); // if (key.Value == 0) // { // if (key.Key != bill.Base.TABLE_NAME) // { // litWarn.Text += "主表单里未配置外部关联表" + key.Key + "的主键,无法与外部表信息同步。"; // } // else { // litWarn.Text += key.Key + "未配置主键。"; // } // } // else if (key.Value > 1) // { // if (key.Key != bill.Base.TABLE_NAME) // { // litWarn.Text += "主表单里配置了多个外部关联表"+key.Key + "的主键,可能导致信息同步异常。"; // } // } //} litList.Text = billExd.HtmlList(null); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { hidAppPath.Value = WebHelper.GetAppPath(); if (BillID > 0) { SYS_BILL_BLL billExd = new SYS_BILL_BLL(BillID); //此查询区可缓存 litFind.Text = billExd.HtmlFindForm(new SYS_BILL_OBJ()); //表体只可部分缓存 litList.Text = billExd.HtmlList(new SYS_BILL_OBJ()); } } }
protected void Page_Load(object sender, EventArgs e) { #region//导入字段 if (Request["showInHead"] != null) { string colid = Request["id"]; string billid = Request["pid"]; SYS_BILL_COL ccc = new SYS_BILL_COL(); ccc.COL_ID = int.Parse(colid); ccc.BILL_ID = int.Parse(billid); SYS_BILL_COL vvv = new SYS_BILL_COL(); vvv.BILL_ISHEADER = "1"; int re = BLLTable <SYS_BILL_COL> .Factory(conn).Update(vvv, ccc); if (re > 0) { Response.Write("{re:1,msg:'设置成功!'}"); } else { Response.Write("{re:0,msg:'设置失败!'}"); } } #endregion #region//导入字段 if (Request["getBillHtml"] != null) { SYS_BILL_BLL bill = new SYS_BILL_BLL(int.Parse(Request["billid"])); Response.Write(bill.HtmlList(null) + "`" + bill.HtmlEditForm()); } #endregion Response.End(); }
protected void Page_Load(object sender, EventArgs e) { #region//导入字段 if (Request["showInHead"] != null) { string colid = Request["id"]; string billid = Request["pid"]; SYS_BILL_COL ccc = new SYS_BILL_COL(); ccc.COL_ID = int.Parse(colid); ccc.BILL_ID = int.Parse(billid); SYS_BILL_COL vvv = new SYS_BILL_COL(); vvv.BILL_ISHEADER = "1"; int re = BLLTable<SYS_BILL_COL>.Factory(conn).Update(vvv, ccc); if (re > 0) { Response.Write("{re:1,msg:'设置成功!'}"); } else { Response.Write("{re:0,msg:'设置失败!'}"); } } #endregion #region//导入字段 if (Request["getBillHtml"] != null) { SYS_BILL_BLL bill = new SYS_BILL_BLL(int.Parse(Request["billid"])); Response.Write(bill.HtmlList(null) + "`"+bill.HtmlEditForm()); } #endregion Response.End(); }