protected void btnFind_Click(object sender, EventArgs e) { int uid = -1; condObj = new HR_CK_USERINFO(); if (txtUSERID.Value != "" && int.TryParse(txtUSERID.Value, out uid)) { condObj.USERID = Convert.ToInt32(txtUSERID.Value); } if (txtSTAFF_ID.Value != "" && int.TryParse(txtSTAFF_ID.Value, out uid)) { condObj.STAFF_ID = Convert.ToInt32(txtSTAFF_ID.Value); } if (txtBADGENUMBER.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.BADGENUMBER, txtBADGENUMBER.Value); } if (txtSSN.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.SSN, txtSSN.Value); } if (txtNAME.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.NAME, txtNAME.Value); } hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void btnFind_Click(object sender, EventArgs e) { int uid = -1; condObj = new HR_CK_USERINFO(); if (txtUSERID.Value != "" && int.TryParse(txtUSERID.Value, out uid)) condObj.USERID = Convert.ToInt32(txtUSERID.Value); if (txtSTAFF_ID.Value != "" && int.TryParse(txtSTAFF_ID.Value, out uid)) condObj.STAFF_ID = Convert.ToInt32(txtSTAFF_ID.Value); if (txtBADGENUMBER.Value != "") condObj.Like(HR_CK_USERINFO.Attribute.BADGENUMBER, txtBADGENUMBER.Value); if (txtSSN.Value != "") condObj.Like(HR_CK_USERINFO.Attribute.SSN, txtSSN.Value); if (txtNAME.Value != "") condObj.Like(HR_CK_USERINFO.Attribute.NAME, txtNAME.Value); hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void btnFind_Click(object sender, EventArgs e) { try { condObj = new HR_CK_USERINFO(); if(txtUSERID.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.USERID, Convert.ToInt32(txtUSERID.Value)); if(txtSTAFF_ID.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.STAFF_ID, Convert.ToDecimal(txtSTAFF_ID.Value)); if(txtBADGENUMBER.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.BADGENUMBER, Convert.ToString(txtBADGENUMBER.Value)); if(txtSSN.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.SSN, Convert.ToString(txtSSN.Value)); if(txtNAME.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.NAME, Convert.ToString(txtNAME.Value)); if(txtGENDER.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.GENDER, Convert.ToString(txtGENDER.Value)); if(txtTITLE.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.TITLE, Convert.ToString(txtTITLE.Value)); if(txtPAGER.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.PAGER, Convert.ToString(txtPAGER.Value)); if(txtBIRTHDAY.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.BIRTHDAY, Convert.ToDateTime(txtBIRTHDAY.Value)); if(txtHIREDDAY.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.HIREDDAY, Convert.ToDateTime(txtHIREDDAY.Value)); if(txtSTREET.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.STREET, Convert.ToString(txtSTREET.Value)); if(txtCITY.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.CITY, Convert.ToString(txtCITY.Value)); if(txtSTATE.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.STATE, Convert.ToString(txtSTATE.Value)); if(txtZIP.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.ZIP, Convert.ToString(txtZIP.Value)); if(txtOPHONE.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.OPHONE, Convert.ToString(txtOPHONE.Value)); if(txtFPHONE.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.FPHONE, Convert.ToString(txtFPHONE.Value)); if(txtVERIFICATIONMETHOD.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.VERIFICATIONMETHOD, Convert.ToInt16(txtVERIFICATIONMETHOD.Value)); if(txtDEFAULTDEPTID.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.DEFAULTDEPTID, Convert.ToInt16(txtDEFAULTDEPTID.Value)); if(txtSECURITYFLAGS.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.SECURITYFLAGS, Convert.ToInt16(txtSECURITYFLAGS.Value)); if(txtATT.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.ATT, Convert.ToInt16(txtATT.Value)); if(txtINLATE.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.INLATE, Convert.ToInt16(txtINLATE.Value)); if(txtOUTEARLY.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.OUTEARLY, Convert.ToInt16(txtOUTEARLY.Value)); if(txtOVERTIME.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.OVERTIME, Convert.ToInt16(txtOVERTIME.Value)); if(txtSEP.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.SEP, Convert.ToInt16(txtSEP.Value)); if(txtHOLIDAY.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.HOLIDAY, Convert.ToInt16(txtHOLIDAY.Value)); if(txtMINZU.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.MINZU, Convert.ToString(txtMINZU.Value)); if(txtPASSWORD.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.PASSWORD, Convert.ToString(txtPASSWORD.Value)); if(txtLUNCHDURATION.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.LUNCHDURATION, Convert.ToInt16(txtLUNCHDURATION.Value)); if(txtMVerifyPass.Value !="" ) condObj.Like(HR_CK_USERINFO.Attribute.MVerifyPass, Convert.ToString(txtMVerifyPass.Value)); listObj = BLLTable<HR_CK_USERINFO>.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 HR_CK_USERINFO(); if (txtUSERID.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.USERID, Convert.ToInt32(txtUSERID.Value)); } if (txtSTAFF_ID.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.STAFF_ID, Convert.ToDecimal(txtSTAFF_ID.Value)); } if (txtBADGENUMBER.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.BADGENUMBER, Convert.ToString(txtBADGENUMBER.Value)); } if (txtSSN.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.SSN, Convert.ToString(txtSSN.Value)); } if (txtNAME.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.NAME, Convert.ToString(txtNAME.Value)); } if (txtGENDER.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.GENDER, Convert.ToString(txtGENDER.Value)); } if (txtTITLE.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.TITLE, Convert.ToString(txtTITLE.Value)); } if (txtPAGER.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.PAGER, Convert.ToString(txtPAGER.Value)); } if (txtBIRTHDAY.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.BIRTHDAY, Convert.ToDateTime(txtBIRTHDAY.Value)); } if (txtHIREDDAY.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.HIREDDAY, Convert.ToDateTime(txtHIREDDAY.Value)); } if (txtSTREET.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.STREET, Convert.ToString(txtSTREET.Value)); } if (txtCITY.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.CITY, Convert.ToString(txtCITY.Value)); } if (txtSTATE.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.STATE, Convert.ToString(txtSTATE.Value)); } if (txtZIP.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.ZIP, Convert.ToString(txtZIP.Value)); } if (txtOPHONE.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.OPHONE, Convert.ToString(txtOPHONE.Value)); } if (txtFPHONE.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.FPHONE, Convert.ToString(txtFPHONE.Value)); } if (txtVERIFICATIONMETHOD.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.VERIFICATIONMETHOD, Convert.ToInt16(txtVERIFICATIONMETHOD.Value)); } if (txtDEFAULTDEPTID.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.DEFAULTDEPTID, Convert.ToInt16(txtDEFAULTDEPTID.Value)); } if (txtSECURITYFLAGS.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.SECURITYFLAGS, Convert.ToInt16(txtSECURITYFLAGS.Value)); } if (txtATT.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.ATT, Convert.ToInt16(txtATT.Value)); } if (txtINLATE.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.INLATE, Convert.ToInt16(txtINLATE.Value)); } if (txtOUTEARLY.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.OUTEARLY, Convert.ToInt16(txtOUTEARLY.Value)); } if (txtOVERTIME.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.OVERTIME, Convert.ToInt16(txtOVERTIME.Value)); } if (txtSEP.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.SEP, Convert.ToInt16(txtSEP.Value)); } if (txtHOLIDAY.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.HOLIDAY, Convert.ToInt16(txtHOLIDAY.Value)); } if (txtMINZU.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.MINZU, Convert.ToString(txtMINZU.Value)); } if (txtPASSWORD.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.PASSWORD, Convert.ToString(txtPASSWORD.Value)); } if (txtLUNCHDURATION.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.LUNCHDURATION, Convert.ToInt16(txtLUNCHDURATION.Value)); } if (txtMVerifyPass.Value != "") { condObj.Like(HR_CK_USERINFO.Attribute.MVerifyPass, Convert.ToString(txtMVerifyPass.Value)); } listObj = BLLTable <HR_CK_USERINFO> .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; }