Example #1
0
    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;
    }
Example #4
0
    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;
    }