Пример #1
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj = new TF_TABLE();


        if (txtTB_ID.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));
        }


        if (txtTB_NAME.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.TB_NAME, Convert.ToString(txtTB_NAME.Value));
        }


        if (txtCH_NAME.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.CH_NAME, Convert.ToString(txtCH_NAME.Value));
        }


        if (txtM_TB_ID.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.M_TB_ID, Convert.ToInt32(txtM_TB_ID.Value));
        }


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


        if (txtTB_TYPE.Value != "")
        {
            condObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
        }


        if (txtNOTE.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.NOTE, Convert.ToString(txtNOTE.Value));
        }

        try
        {
            hidCondition.Value = condObj.ToJson(20);

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

            repList.DataSource = listObj;
            repList.DataBind();
        }
        catch (Exception ex)
        {
            litWarn.Text = ex.Message;
        }
    }
Пример #2
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj = new TF_TABLE();

        if(txtTB_ID.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));

        if(txtTB_NAME.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.TB_NAME, Convert.ToString(txtTB_NAME.Value));

        if(txtCH_NAME.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.CH_NAME, Convert.ToString(txtCH_NAME.Value));

        if(txtM_TB_ID.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.M_TB_ID, Convert.ToInt32(txtM_TB_ID.Value));

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

        if(txtTB_TYPE.Value !="" )
            condObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);

        if(txtNOTE.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.NOTE, Convert.ToString(txtNOTE.Value));

        try
        {
            hidCondition.Value = condObj.ToJson(20);

            listObj = BLLTable<TF_TABLE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
            repList.DataSource = listObj;
            repList.DataBind();
        }
        catch (Exception ex)
        {
             litWarn.Text = ex.Message;
        }
    }
Пример #3
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj = new TF_TABLE();

        if(txtTB_ID.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));

        if(txtTB_NAME.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.TB_NAME, Convert.ToString(txtTB_NAME.Value));

        if(txtWF_TB_NAME.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.WF_TB_NAME, Convert.ToString(txtWF_TB_NAME.Value));

        if(txtCH_NAME.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.CH_NAME, Convert.ToString(txtCH_NAME.Value));

        if(txtM_TB_ID.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.M_TB_ID, Convert.ToInt32(txtM_TB_ID.Value));

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

        if(txtTB_TYPE.Value !="" )
            condObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);

        if(txtNOTE.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.NOTE, Convert.ToString(txtNOTE.Value));

        if(txtCREATED.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.CREATED, Convert.ToInt32(txtCREATED.Value));

        if(txtDB_SRC.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.DB_SRC, Convert.ToString(txtDB_SRC.Value));

        if(txtMENU_NAME.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.MENU_NAME, Convert.ToString(txtMENU_NAME.Value));

        if(txtKEY_NAME.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.KEY_NAME, Convert.ToString(txtKEY_NAME.Value));

        if(txtKEY_TYPE.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.KEY_TYPE, Convert.ToString(txtKEY_TYPE.Value));

        if(txtAPI_NAME.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.API_NAME, Convert.ToString(txtAPI_NAME.Value));

        if(txtALLOW_REPORT.Value !="" )
            condObj.ALLOW_REPORT = Convert.ToBoolean(txtALLOW_REPORT.Checked);

        if(txtALLOW_ACTIVITY.Value !="" )
            condObj.ALLOW_ACTIVITY = Convert.ToBoolean(txtALLOW_ACTIVITY.Checked);

        if(txtMODIFY_HIS.Value !="" )
            condObj.MODIFY_HIS = Convert.ToBoolean(txtMODIFY_HIS.Checked);

        if(txtALLOW_USER_AREA.Value !="" )
            condObj.ALLOW_USER_AREA = Convert.ToBoolean(txtALLOW_USER_AREA.Checked);

        if(txtALLOW_PUBLIC.Value !="" )
            condObj.ALLOW_PUBLIC = Convert.ToBoolean(txtALLOW_PUBLIC.Checked);

        if(txtTB_NAMESPACE.Value !="" )
            condObj.Like_OR(TF_TABLE.Attribute.TB_NAMESPACE, Convert.ToString(txtTB_NAMESPACE.Value));

        if(txtINSTALL_STAT.Value !="" )
            condObj.INSTALL_STAT = Convert.ToBoolean(txtINSTALL_STAT.Checked);

        if(txtADD_NOTE_FILE.Value !="" )
            condObj.ADD_NOTE_FILE = Convert.ToBoolean(txtADD_NOTE_FILE.Checked);

        if(txtHAS_WF.Value !="" )
            condObj.HAS_WF = Convert.ToBoolean(txtHAS_WF.Checked);

        try
        {
            hidCondition.Value = condObj.ToJson(20);

            listObj = BLLTable<TF_TABLE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
            repList.DataSource = listObj;
            repList.DataBind();
        }
        catch (Exception ex)
        {
             litWarn.Text = ex.Message;
        }
    }
Пример #4
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj = new TF_TABLE();


        if (txtTB_ID.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));
        }


        if (txtTB_NAME.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.TB_NAME, Convert.ToString(txtTB_NAME.Value));
        }


        if (txtWF_TB_NAME.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.WF_TB_NAME, Convert.ToString(txtWF_TB_NAME.Value));
        }


        if (txtCH_NAME.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.CH_NAME, Convert.ToString(txtCH_NAME.Value));
        }


        if (txtM_TB_ID.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.M_TB_ID, Convert.ToInt32(txtM_TB_ID.Value));
        }


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


        if (txtTB_TYPE.Value != "")
        {
            condObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
        }


        if (txtNOTE.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.NOTE, Convert.ToString(txtNOTE.Value));
        }


        if (txtCREATED.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.CREATED, Convert.ToInt32(txtCREATED.Value));
        }


        if (txtDB_SRC.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.DB_SRC, Convert.ToString(txtDB_SRC.Value));
        }


        if (txtMENU_NAME.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.MENU_NAME, Convert.ToString(txtMENU_NAME.Value));
        }


        if (txtKEY_NAME.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.KEY_NAME, Convert.ToString(txtKEY_NAME.Value));
        }


        if (txtKEY_TYPE.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.KEY_TYPE, Convert.ToString(txtKEY_TYPE.Value));
        }


        if (txtAPI_NAME.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.API_NAME, Convert.ToString(txtAPI_NAME.Value));
        }


        if (txtALLOW_REPORT.Value != "")
        {
            condObj.ALLOW_REPORT = Convert.ToBoolean(txtALLOW_REPORT.Checked);
        }


        if (txtALLOW_ACTIVITY.Value != "")
        {
            condObj.ALLOW_ACTIVITY = Convert.ToBoolean(txtALLOW_ACTIVITY.Checked);
        }


        if (txtMODIFY_HIS.Value != "")
        {
            condObj.MODIFY_HIS = Convert.ToBoolean(txtMODIFY_HIS.Checked);
        }


        if (txtALLOW_USER_AREA.Value != "")
        {
            condObj.ALLOW_USER_AREA = Convert.ToBoolean(txtALLOW_USER_AREA.Checked);
        }


        if (txtALLOW_PUBLIC.Value != "")
        {
            condObj.ALLOW_PUBLIC = Convert.ToBoolean(txtALLOW_PUBLIC.Checked);
        }


        if (txtTB_NAMESPACE.Value != "")
        {
            condObj.Like_OR(TF_TABLE.Attribute.TB_NAMESPACE, Convert.ToString(txtTB_NAMESPACE.Value));
        }


        if (txtINSTALL_STAT.Value != "")
        {
            condObj.INSTALL_STAT = Convert.ToBoolean(txtINSTALL_STAT.Checked);
        }


        if (txtADD_NOTE_FILE.Value != "")
        {
            condObj.ADD_NOTE_FILE = Convert.ToBoolean(txtADD_NOTE_FILE.Checked);
        }


        if (txtHAS_WF.Value != "")
        {
            condObj.HAS_WF = Convert.ToBoolean(txtHAS_WF.Checked);
        }

        try
        {
            hidCondition.Value = condObj.ToJson(20);

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

            repList.DataSource = listObj;
            repList.DataBind();
        }
        catch (Exception ex)
        {
            litWarn.Text = ex.Message;
        }
    }