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);
}
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);
}
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;
}
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;
}
