Exemplo n.º 1
0
    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'>&nbsp;" + i + "</td><td>&nbsp;</td><td class='label' id='tr_" + i + "_2'>&nbsp;</td><td>&nbsp;a" + i + "</td></tr>";
                }
            }
        }
    }
Exemplo n.º 2
0
    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'>&nbsp;"+i+"</td><td>&nbsp;</td><td class='label' id='tr_" + i + "_2'>&nbsp;</td><td>&nbsp;a"+i+"</td></tr>";
                }
            }
        }
    }
Exemplo n.º 3
0
 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);
     }
 }
Exemplo n.º 4
0
 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);
     }
 }
Exemplo n.º 5
0
    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);
    }
Exemplo n.º 6
0
    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);
    }
Exemplo n.º 7
0
    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());
            }
        }
    }
Exemplo n.º 8
0
    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());
            }
        }
    }
Exemplo n.º 9
0
    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();
    }
Exemplo n.º 10
0
    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();
    }