protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new TF_TABLE();
if(txtTB_ID.Value !="" )
condObj.Like(TF_TABLE.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));
if(txtTB_NAME.Value !="" )
condObj.Like(TF_TABLE.Attribute.TB_NAME, Convert.ToString(txtTB_NAME.Value));
if(txtCH_NAME.Value !="" )
condObj.Like(TF_TABLE.Attribute.CH_NAME, Convert.ToString(txtCH_NAME.Value));
if(txtM_TB_ID.Value !="" )
condObj.Like(TF_TABLE.Attribute.M_TB_ID, Convert.ToInt32(txtM_TB_ID.Value));
if(txtSORT_NO.Value !="" )
condObj.Like(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(TF_TABLE.Attribute.NOTE, Convert.ToString(txtNOTE.Value));
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
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;
}
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new TF_TABLE();
if (txtTB_ID.Value != "")
{
condObj.Like(TF_TABLE.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));
}
if (txtTB_NAME.Value != "")
{
condObj.Like(TF_TABLE.Attribute.TB_NAME, Convert.ToString(txtTB_NAME.Value));
}
if (txtCH_NAME.Value != "")
{
condObj.Like(TF_TABLE.Attribute.CH_NAME, Convert.ToString(txtCH_NAME.Value));
}
if (txtM_TB_ID.Value != "")
{
condObj.Like(TF_TABLE.Attribute.M_TB_ID, Convert.ToInt32(txtM_TB_ID.Value));
}
if (txtSORT_NO.Value != "")
{
condObj.Like(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(TF_TABLE.Attribute.NOTE, Convert.ToString(txtNOTE.Value));
}
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
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;
}
}
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;
}
}
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;
}
}