protected void btnFind_Click(object sender, EventArgs e) { try { condObj = new KM_SUB_STRU(); if(txtSUB_ID.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_ID, Convert.ToString(txtSUB_ID.Value)); if(txtSUB_NAME.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_NAME, Convert.ToString(txtSUB_NAME.Value)); if(txtK_SUB_ID.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.K_SUB_ID, Convert.ToString(txtK_SUB_ID.Value)); if(txtSUB_CONTENT.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_CONTENT, Convert.ToString(txtSUB_CONTENT.Value)); if(txtSUB_CLASS_ID.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_CLASS_ID, Convert.ToString(txtSUB_CLASS_ID.Value)); if(txtSUB_EA_SIGN.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_EA_SIGN, Convert.ToString(txtSUB_EA_SIGN.Value)); if(txtSUB_AUTHOR.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_AUTHOR, Convert.ToString(txtSUB_AUTHOR.Value)); if(txtSUB_IS_READ.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_IS_READ, Convert.ToString(txtSUB_IS_READ.Value)); if(txtSORT_NO.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SORT_NO, Convert.ToDecimal(txtSORT_NO.Value)); if(txtIDPATH.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.IDPATH, Convert.ToString(txtIDPATH.Value)); if(txtKNAME.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.KNAME, Convert.ToString(txtKNAME.Value)); if(txtSNAME.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SNAME, Convert.ToString(txtSNAME.Value)); if(txtRNAME.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.RNAME, Convert.ToString(txtRNAME.Value)); if(txtSUB_NUM.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_NUM, Convert.ToDecimal(txtSUB_NUM.Value)); if(txtSUBOBJECT_NUM.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUBOBJECT_NUM, Convert.ToDecimal(txtSUBOBJECT_NUM.Value)); if(txtUSE_FLAG.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.USE_FLAG, Convert.ToString(txtUSE_FLAG.Value)); if(txtEXP1.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.EXP1, Convert.ToString(txtEXP1.Value)); if(txtEXP2.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.EXP2, Convert.ToString(txtEXP2.Value)); if(txtEXP3.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.EXP3, Convert.ToString(txtEXP3.Value)); if(txtEXP4.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.EXP4, Convert.ToString(txtEXP4.Value)); listObj = BLLTable<KM_SUB_STRU>.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) { condObj = new KM_SUB_STRU(); if (txtSUB_ID.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_ID, Convert.ToString(txtSUB_ID.Value)); } if (txtSUB_NAME.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_NAME, Convert.ToString(txtSUB_NAME.Value)); } if (txtK_SUB_ID.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.K_SUB_ID, Convert.ToString(txtK_SUB_ID.Value)); } if (txtSUB_CONTENT.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_CONTENT, Convert.ToString(txtSUB_CONTENT.Value)); } if (txtSUB_CLASS_ID.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_CLASS_ID, Convert.ToString(txtSUB_CLASS_ID.Value)); } if (txtSUB_EA_SIGN.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_EA_SIGN, Convert.ToString(txtSUB_EA_SIGN.Value)); } if (txtSUB_AUTHOR.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_AUTHOR, Convert.ToString(txtSUB_AUTHOR.Value)); } if (txtSUB_IS_READ.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_IS_READ, Convert.ToString(txtSUB_IS_READ.Value)); } if (txtSORT_NO.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SORT_NO, Convert.ToDecimal(txtSORT_NO.Value)); } if (txtIDPATH.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.IDPATH, Convert.ToString(txtIDPATH.Value)); } if (txtKNAME.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.KNAME, Convert.ToString(txtKNAME.Value)); } if (txtSNAME.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SNAME, Convert.ToString(txtSNAME.Value)); } if (txtRNAME.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.RNAME, Convert.ToString(txtRNAME.Value)); } if (txtSUB_NUM.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_NUM, Convert.ToDecimal(txtSUB_NUM.Value)); } if (txtSUBOBJECT_NUM.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUBOBJECT_NUM, Convert.ToDecimal(txtSUBOBJECT_NUM.Value)); } if (txtUSE_FLAG.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.USE_FLAG, Convert.ToString(txtUSE_FLAG.Value)); } if (txtEXP1.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.EXP1, Convert.ToString(txtEXP1.Value)); } if (txtEXP2.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.EXP2, Convert.ToString(txtEXP2.Value)); } if (txtEXP3.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.EXP3, Convert.ToString(txtEXP3.Value)); } if (txtEXP4.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.EXP4, Convert.ToString(txtEXP4.Value)); } hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new KM_SUB_STRU(); if(txtSUB_ID.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_ID, Convert.ToString(txtSUB_ID.Value)); if(txtSUB_NAME.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_NAME, Convert.ToString(txtSUB_NAME.Value)); if(txtK_SUB_ID.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.K_SUB_ID, Convert.ToString(txtK_SUB_ID.Value)); if(txtSUB_CONTENT.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_CONTENT, Convert.ToString(txtSUB_CONTENT.Value)); if(txtSUB_CLASS_ID.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_CLASS_ID, Convert.ToString(txtSUB_CLASS_ID.Value)); if(txtSUB_EA_SIGN.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_EA_SIGN, Convert.ToString(txtSUB_EA_SIGN.Value)); if(txtSUB_AUTHOR.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_AUTHOR, Convert.ToString(txtSUB_AUTHOR.Value)); if(txtSUB_IS_READ.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_IS_READ, Convert.ToString(txtSUB_IS_READ.Value)); if(txtSORT_NO.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SORT_NO, Convert.ToDecimal(txtSORT_NO.Value)); if(txtIDPATH.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.IDPATH, Convert.ToString(txtIDPATH.Value)); if(txtKNAME.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.KNAME, Convert.ToString(txtKNAME.Value)); if(txtSNAME.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SNAME, Convert.ToString(txtSNAME.Value)); if(txtRNAME.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.RNAME, Convert.ToString(txtRNAME.Value)); if(txtSUB_NUM.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUB_NUM, Convert.ToDecimal(txtSUB_NUM.Value)); if(txtSUBOBJECT_NUM.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.SUBOBJECT_NUM, Convert.ToDecimal(txtSUBOBJECT_NUM.Value)); if(txtUSE_FLAG.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.USE_FLAG, Convert.ToString(txtUSE_FLAG.Value)); if(txtEXP1.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.EXP1, Convert.ToString(txtEXP1.Value)); if(txtEXP2.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.EXP2, Convert.ToString(txtEXP2.Value)); if(txtEXP3.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.EXP3, Convert.ToString(txtEXP3.Value)); if(txtEXP4.Value !="" ) condObj.Like(KM_SUB_STRU.Attribute.EXP4, Convert.ToString(txtEXP4.Value)); hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void btnFind_Click(object sender, EventArgs e) { try { condObj = new KM_SUB_STRU(); if (txtSUB_ID.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_ID, Convert.ToString(txtSUB_ID.Value)); } if (txtSUB_NAME.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_NAME, Convert.ToString(txtSUB_NAME.Value)); } if (txtK_SUB_ID.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.K_SUB_ID, Convert.ToString(txtK_SUB_ID.Value)); } if (txtSUB_CONTENT.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_CONTENT, Convert.ToString(txtSUB_CONTENT.Value)); } if (txtSUB_CLASS_ID.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_CLASS_ID, Convert.ToString(txtSUB_CLASS_ID.Value)); } if (txtSUB_EA_SIGN.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_EA_SIGN, Convert.ToString(txtSUB_EA_SIGN.Value)); } if (txtSUB_AUTHOR.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_AUTHOR, Convert.ToString(txtSUB_AUTHOR.Value)); } if (txtSUB_IS_READ.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_IS_READ, Convert.ToString(txtSUB_IS_READ.Value)); } if (txtSORT_NO.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SORT_NO, Convert.ToDecimal(txtSORT_NO.Value)); } if (txtIDPATH.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.IDPATH, Convert.ToString(txtIDPATH.Value)); } if (txtKNAME.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.KNAME, Convert.ToString(txtKNAME.Value)); } if (txtSNAME.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SNAME, Convert.ToString(txtSNAME.Value)); } if (txtRNAME.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.RNAME, Convert.ToString(txtRNAME.Value)); } if (txtSUB_NUM.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUB_NUM, Convert.ToDecimal(txtSUB_NUM.Value)); } if (txtSUBOBJECT_NUM.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.SUBOBJECT_NUM, Convert.ToDecimal(txtSUBOBJECT_NUM.Value)); } if (txtUSE_FLAG.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.USE_FLAG, Convert.ToString(txtUSE_FLAG.Value)); } if (txtEXP1.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.EXP1, Convert.ToString(txtEXP1.Value)); } if (txtEXP2.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.EXP2, Convert.ToString(txtEXP2.Value)); } if (txtEXP3.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.EXP3, Convert.ToString(txtEXP3.Value)); } if (txtEXP4.Value != "") { condObj.Like(KM_SUB_STRU.Attribute.EXP4, Convert.ToString(txtEXP4.Value)); } listObj = BLLTable <KM_SUB_STRU> .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; }