Beispiel #1
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj = new SYS_BILL_COL();

        if (txtCOL_NAME.Value != "")
            condObj.Like(SYS_BILL_COL.Attribute.COL_NAME, Convert.ToString(txtCOL_NAME.Value));

        if (txtDATA_TYPE.Value != "")
            condObj.Like(SYS_BILL_COL.Attribute.DATA_TYPE, Convert.ToString(txtDATA_TYPE.Value));

        if (txtBILL_ISHEADER.Value != "")
            condObj.BILL_ISHEADER = txtBILL_ISHEADER.Value;

        if (txtFORM_SHOW.Value != "")
            condObj.FORM_SHOW = txtFORM_SHOW.Value;

        if (txtFORM_NEED.Value != "")
            condObj.FORM_NEED = txtFORM_NEED.Value;

        if (txtFORM_ONEROW.Value != "")
            condObj.FORM_ONEROW = txtFORM_ONEROW.Value;

        if (txtSEARCH_INBILL.Value != "")
            condObj.SEARCH_INBILL = txtSEARCH_INBILL.Value;

        hidCondition.Value = condObj.ToJson(20);

        BindList(condObj);
    }
Beispiel #2
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj = new SYS_BILL_COL();

        if (txtCOL_NAME.Value != "")
        {
            condObj.Like(SYS_BILL_COL.Attribute.COL_NAME, Convert.ToString(txtCOL_NAME.Value));
        }

        if (txtDATA_TYPE.Value != "")
        {
            condObj.Like(SYS_BILL_COL.Attribute.DATA_TYPE, Convert.ToString(txtDATA_TYPE.Value));
        }

        if (txtBILL_ISHEADER.Value != "")
        {
            condObj.BILL_ISHEADER = txtBILL_ISHEADER.Value;
        }

        if (txtFORM_SHOW.Value != "")
        {
            condObj.FORM_SHOW = txtFORM_SHOW.Value;
        }


        if (txtFORM_NEED.Value != "")
        {
            condObj.FORM_NEED = txtFORM_NEED.Value;
        }


        if (txtFORM_ONEROW.Value != "")
        {
            condObj.FORM_ONEROW = txtFORM_ONEROW.Value;
        }

        if (txtSEARCH_INBILL.Value != "")
        {
            condObj.SEARCH_INBILL = txtSEARCH_INBILL.Value;
        }

        hidCondition.Value = condObj.ToJson(20);

        BindList(condObj);
    }
Beispiel #3
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        try
        {
            condObj = new SYS_BILL_COL();

            if(txtCOL_ID.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.COL_ID, Convert.ToInt32(txtCOL_ID.Value));

            if(txtBILL_ID.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.BILL_ID, Convert.ToInt32(txtBILL_ID.Value));

            if(txtTABLE_NAME.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.TABLE_NAME, Convert.ToString(txtTABLE_NAME.Value));

            if(txtCOL_NAME.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.COL_NAME, Convert.ToString(txtCOL_NAME.Value));

            if(txtCOL_NOTE.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.COL_NOTE, Convert.ToString(txtCOL_NOTE.Value));

            if(txtDATA_TYPE.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.DATA_TYPE, Convert.ToString(txtDATA_TYPE.Value));

            if(txtDATA_LEN.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.DATA_LEN, Convert.ToInt32(txtDATA_LEN.Value));

            if(txtDATA_ACC.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.DATA_ACC, Convert.ToInt32(txtDATA_ACC.Value));

            if(txtIS_AUTO.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.IS_AUTO, Convert.ToString(txtIS_AUTO.Value));

            if(txtSORT_NO.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value));

            if(txtCOL_SHOW.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.FK_SHOW, Convert.ToString(txtCOL_SHOW.Value));

            if(txtDISPLAY_NAME.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.DISPLAY_NAME, Convert.ToString(txtDISPLAY_NAME.Value));

            if(txtTITLE.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.TITLE, Convert.ToString(txtTITLE.Value));

            if(txtDVAL.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.DVAL, Convert.ToString(txtDVAL.Value));

            if(txtBILL_ROW_FORMULAR.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.BILL_ROW_FORMULAR, Convert.ToString(txtBILL_ROW_FORMULAR.Value));

            if(txtBILL_COL_FORMULAR.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.BILL_COL_FORMULAR, Convert.ToString(txtBILL_COL_FORMULAR.Value));

            if(txtBILL_ISHEADER.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.BILL_ISHEADER, Convert.ToString(txtBILL_ISHEADER.Value));

            if(txtBILL_HERDERWIDTH.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.BILL_HERDERWIDTH, Convert.ToInt32(txtBILL_HERDERWIDTH.Value));

            if(txtFORM_CHECKTYPE.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.FORM_CHECKTYPE, Convert.ToString(txtFORM_CHECKTYPE.Value));

            if(txtFORM_CTRL_ID.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.FORM_CTRL_ID, Convert.ToInt32(txtFORM_CTRL_ID.Value));

            if(txtFORM_SHOW.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.FORM_SHOW, Convert.ToString(txtFORM_SHOW.Value));

            if(txtFORM_NEED.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.FORM_NEED, Convert.ToString(txtFORM_NEED.Value));

            if(txtFORM_MIN.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.FORM_MIN, Convert.ToString(txtFORM_MIN.Value));

            if(txtFORM_MAX.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.FORM_MAX, Convert.ToString(txtFORM_MAX.Value));

            if(txtFORM_ONEROW.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.FORM_ONEROW, Convert.ToString(txtFORM_ONEROW.Value));

            if(txtFORM_CTRLWIDTH.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.FORM_CTRLWIDTH, Convert.ToInt32(txtFORM_CTRLWIDTH.Value));

            if(txtSEARCH_INBILL.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.SEARCH_INBILL, Convert.ToString(txtSEARCH_INBILL.Value));

            if(txtSEARCH_TYPE.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.SEARCH_TYPE, Convert.ToString(txtSEARCH_TYPE.Value));

            if(txtSEARCH_FORMULAR.Value !="" )
                condObj.Like(SYS_BILL_COL.Attribute.SEARCH_FORMULAR, Convert.ToString(txtSEARCH_FORMULAR.Value));

            listObj = BLLTable<SYS_BILL_COL>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
            repCus.DataSource = listObj;
            repCus.DataBind();
        }
        catch (Exception ex)
        {
            litWarn.Text = ex.Message;
        }
        aspPager.RecordCount = recount;
    }
Beispiel #4
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        try
        {
            condObj = new SYS_BILL_COL();



            if (txtCOL_ID.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.COL_ID, Convert.ToInt32(txtCOL_ID.Value));
            }


            if (txtBILL_ID.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.BILL_ID, Convert.ToInt32(txtBILL_ID.Value));
            }


            if (txtTABLE_NAME.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.TABLE_NAME, Convert.ToString(txtTABLE_NAME.Value));
            }


            if (txtCOL_NAME.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.COL_NAME, Convert.ToString(txtCOL_NAME.Value));
            }


            if (txtCOL_NOTE.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.COL_NOTE, Convert.ToString(txtCOL_NOTE.Value));
            }


            if (txtDATA_TYPE.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.DATA_TYPE, Convert.ToString(txtDATA_TYPE.Value));
            }


            if (txtDATA_LEN.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.DATA_LEN, Convert.ToInt32(txtDATA_LEN.Value));
            }


            if (txtDATA_ACC.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.DATA_ACC, Convert.ToInt32(txtDATA_ACC.Value));
            }


            if (txtIS_AUTO.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.IS_AUTO, Convert.ToString(txtIS_AUTO.Value));
            }


            if (txtSORT_NO.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value));
            }


            if (txtCOL_SHOW.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.FK_SHOW, Convert.ToString(txtCOL_SHOW.Value));
            }


            if (txtDISPLAY_NAME.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.DISPLAY_NAME, Convert.ToString(txtDISPLAY_NAME.Value));
            }


            if (txtTITLE.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.TITLE, Convert.ToString(txtTITLE.Value));
            }


            if (txtDVAL.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.DVAL, Convert.ToString(txtDVAL.Value));
            }


            if (txtBILL_ROW_FORMULAR.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.BILL_ROW_FORMULAR, Convert.ToString(txtBILL_ROW_FORMULAR.Value));
            }


            if (txtBILL_COL_FORMULAR.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.BILL_COL_FORMULAR, Convert.ToString(txtBILL_COL_FORMULAR.Value));
            }


            if (txtBILL_ISHEADER.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.BILL_ISHEADER, Convert.ToString(txtBILL_ISHEADER.Value));
            }


            if (txtBILL_HERDERWIDTH.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.BILL_HERDERWIDTH, Convert.ToInt32(txtBILL_HERDERWIDTH.Value));
            }


            if (txtFORM_CHECKTYPE.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.FORM_CHECKTYPE, Convert.ToString(txtFORM_CHECKTYPE.Value));
            }


            if (txtFORM_CTRL_ID.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.FORM_CTRL_ID, Convert.ToInt32(txtFORM_CTRL_ID.Value));
            }


            if (txtFORM_SHOW.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.FORM_SHOW, Convert.ToString(txtFORM_SHOW.Value));
            }


            if (txtFORM_NEED.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.FORM_NEED, Convert.ToString(txtFORM_NEED.Value));
            }


            if (txtFORM_MIN.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.FORM_MIN, Convert.ToString(txtFORM_MIN.Value));
            }


            if (txtFORM_MAX.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.FORM_MAX, Convert.ToString(txtFORM_MAX.Value));
            }


            if (txtFORM_ONEROW.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.FORM_ONEROW, Convert.ToString(txtFORM_ONEROW.Value));
            }


            if (txtFORM_CTRLWIDTH.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.FORM_CTRLWIDTH, Convert.ToInt32(txtFORM_CTRLWIDTH.Value));
            }


            if (txtSEARCH_INBILL.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.SEARCH_INBILL, Convert.ToString(txtSEARCH_INBILL.Value));
            }


            if (txtSEARCH_TYPE.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.SEARCH_TYPE, Convert.ToString(txtSEARCH_TYPE.Value));
            }


            if (txtSEARCH_FORMULAR.Value != "")
            {
                condObj.Like(SYS_BILL_COL.Attribute.SEARCH_FORMULAR, Convert.ToString(txtSEARCH_FORMULAR.Value));
            }

            listObj = BLLTable <SYS_BILL_COL> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);

            repCus.DataSource = listObj;
            repCus.DataBind();
        }
        catch (Exception ex)
        {
            litWarn.Text = ex.Message;
        }
        aspPager.RecordCount = recount;
    }