예제 #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)
    {
        condObj = new HR_CK_USERINFO();

        if(txtUSERID.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.USERID, Convert.ToInt32(txtUSERID.Value));

        if(txtSTAFF_ID.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.STAFF_ID, Convert.ToDecimal(txtSTAFF_ID.Value));

        if(txtBADGENUMBER.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.BADGENUMBER, Convert.ToString(txtBADGENUMBER.Value));

        if(txtSSN.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.SSN, Convert.ToString(txtSSN.Value));

        if(txtNAME.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.NAME, Convert.ToString(txtNAME.Value));

        if(txtGENDER.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.GENDER, Convert.ToString(txtGENDER.Value));

        if(txtTITLE.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.TITLE, Convert.ToString(txtTITLE.Value));

        if(txtPAGER.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.PAGER, Convert.ToString(txtPAGER.Value));

        if(txtBIRTHDAY.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.BIRTHDAY, Convert.ToDateTime(txtBIRTHDAY.Value));

        if(txtHIREDDAY.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.HIREDDAY, Convert.ToDateTime(txtHIREDDAY.Value));

        if(txtSTREET.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.STREET, Convert.ToString(txtSTREET.Value));

        if(txtCITY.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.CITY, Convert.ToString(txtCITY.Value));

        if(txtSTATE.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.STATE, Convert.ToString(txtSTATE.Value));

        if(txtZIP.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.ZIP, Convert.ToString(txtZIP.Value));

        if(txtOPHONE.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.OPHONE, Convert.ToString(txtOPHONE.Value));

        if(txtFPHONE.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.FPHONE, Convert.ToString(txtFPHONE.Value));

        if(txtVERIFICATIONMETHOD.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.VERIFICATIONMETHOD, Convert.ToInt16(txtVERIFICATIONMETHOD.Value));

        if(txtDEFAULTDEPTID.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.DEFAULTDEPTID, Convert.ToInt16(txtDEFAULTDEPTID.Value));

        if(txtSECURITYFLAGS.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.SECURITYFLAGS, Convert.ToInt16(txtSECURITYFLAGS.Value));

        if(txtATT.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.ATT, Convert.ToInt16(txtATT.Value));

        if(txtINLATE.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.INLATE, Convert.ToInt16(txtINLATE.Value));

        if(txtOUTEARLY.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.OUTEARLY, Convert.ToInt16(txtOUTEARLY.Value));

        if(txtOVERTIME.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.OVERTIME, Convert.ToInt16(txtOVERTIME.Value));

        if(txtSEP.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.SEP, Convert.ToInt16(txtSEP.Value));

        if(txtHOLIDAY.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.HOLIDAY, Convert.ToInt16(txtHOLIDAY.Value));

        if(txtMINZU.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.MINZU, Convert.ToString(txtMINZU.Value));

        if(txtPASSWORD.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.PASSWORD, Convert.ToString(txtPASSWORD.Value));

        if(txtLUNCHDURATION.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.LUNCHDURATION, Convert.ToInt16(txtLUNCHDURATION.Value));

        if(txtMVerifyPass.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.MVerifyPass, Convert.ToString(txtMVerifyPass.Value));

        try
        {
            hidCondition.Value = condObj.ToJson(20);

            listObj = BLLTable<HR_CK_USERINFO>.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 HR_CK_USERINFO();


        if (txtUSERID.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.USERID, Convert.ToInt32(txtUSERID.Value));
        }


        if (txtSTAFF_ID.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.STAFF_ID, Convert.ToDecimal(txtSTAFF_ID.Value));
        }


        if (txtBADGENUMBER.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.BADGENUMBER, Convert.ToString(txtBADGENUMBER.Value));
        }


        if (txtSSN.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.SSN, Convert.ToString(txtSSN.Value));
        }


        if (txtNAME.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.NAME, Convert.ToString(txtNAME.Value));
        }


        if (txtGENDER.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.GENDER, Convert.ToString(txtGENDER.Value));
        }


        if (txtTITLE.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.TITLE, Convert.ToString(txtTITLE.Value));
        }


        if (txtPAGER.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.PAGER, Convert.ToString(txtPAGER.Value));
        }


        if (txtBIRTHDAY.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.BIRTHDAY, Convert.ToDateTime(txtBIRTHDAY.Value));
        }


        if (txtHIREDDAY.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.HIREDDAY, Convert.ToDateTime(txtHIREDDAY.Value));
        }


        if (txtSTREET.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.STREET, Convert.ToString(txtSTREET.Value));
        }


        if (txtCITY.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.CITY, Convert.ToString(txtCITY.Value));
        }


        if (txtSTATE.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.STATE, Convert.ToString(txtSTATE.Value));
        }


        if (txtZIP.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.ZIP, Convert.ToString(txtZIP.Value));
        }


        if (txtOPHONE.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.OPHONE, Convert.ToString(txtOPHONE.Value));
        }


        if (txtFPHONE.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.FPHONE, Convert.ToString(txtFPHONE.Value));
        }


        if (txtVERIFICATIONMETHOD.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.VERIFICATIONMETHOD, Convert.ToInt16(txtVERIFICATIONMETHOD.Value));
        }


        if (txtDEFAULTDEPTID.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.DEFAULTDEPTID, Convert.ToInt16(txtDEFAULTDEPTID.Value));
        }


        if (txtSECURITYFLAGS.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.SECURITYFLAGS, Convert.ToInt16(txtSECURITYFLAGS.Value));
        }


        if (txtATT.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.ATT, Convert.ToInt16(txtATT.Value));
        }


        if (txtINLATE.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.INLATE, Convert.ToInt16(txtINLATE.Value));
        }


        if (txtOUTEARLY.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.OUTEARLY, Convert.ToInt16(txtOUTEARLY.Value));
        }


        if (txtOVERTIME.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.OVERTIME, Convert.ToInt16(txtOVERTIME.Value));
        }


        if (txtSEP.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.SEP, Convert.ToInt16(txtSEP.Value));
        }


        if (txtHOLIDAY.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.HOLIDAY, Convert.ToInt16(txtHOLIDAY.Value));
        }


        if (txtMINZU.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.MINZU, Convert.ToString(txtMINZU.Value));
        }


        if (txtPASSWORD.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.PASSWORD, Convert.ToString(txtPASSWORD.Value));
        }


        if (txtLUNCHDURATION.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.LUNCHDURATION, Convert.ToInt16(txtLUNCHDURATION.Value));
        }


        if (txtMVerifyPass.Value != "")
        {
            condObj.Like_OR(HR_CK_USERINFO.Attribute.MVerifyPass, Convert.ToString(txtMVerifyPass.Value));
        }


        try
        {
            hidCondition.Value = condObj.ToJson(20);

            listObj = BLLTable <HR_CK_USERINFO> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);

            repList.DataSource = listObj;
            repList.DataBind();
        }
        catch (Exception ex)
        {
            litWarn.Text = ex.Message;
        }
    }