コード例 #1
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj = new IM_PURORDER();

        if(txtPORD_ID.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.PORD_ID, Convert.ToDecimal(txtPORD_ID.Value));

        if(txtPORD_NO.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.PORD_NO, Convert.ToString(txtPORD_NO.Value));

        if(txtC_DATE.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.C_DATE, Convert.ToDateTime(txtC_DATE.Value));

        if(txtORG_ID.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.ORG_ID, Convert.ToString(txtORG_ID.Value));

        if(txtDEPT_ID.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.DEPT_ID, Convert.ToString(txtDEPT_ID.Value));

        if(txtSUP_ID.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.SUP_ID, Convert.ToDecimal(txtSUP_ID.Value));

        if(txtPERSON_HID.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.PERSON_HID, Convert.ToDecimal(txtPERSON_HID.Value));

        if(txtTS_NO.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.TS_NO, Convert.ToString(txtTS_NO.Value));

        if(txtGOODES_NUM.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.GOODES_NUM, Convert.ToDecimal(txtGOODES_NUM.Value));

        if(txtARRIVAL_DATE.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.ARRIVAL_DATE, Convert.ToDateTime(txtARRIVAL_DATE.Value));

        if(txtPACKAGE_TYPE.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.PACKAGE_TYPE, Convert.ToString(txtPACKAGE_TYPE.Value));

        if(txtTS_DEPT.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.TS_DEPT, Convert.ToString(txtTS_DEPT.Value));

        if(txtPHONE.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.PHONE, Convert.ToString(txtPHONE.Value));

        if(txtCOST_PEICE_FLAG.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.COST_PEICE_FLAG, Convert.ToString(txtCOST_PEICE_FLAG.Value));

        if(txtSTOR_ID.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.STOR_ID, Convert.ToDecimal(txtSTOR_ID.Value));

        if(txtDEDUCTION_RATE.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.DEDUCTION_RATE, Convert.ToDecimal(txtDEDUCTION_RATE.Value));

        if(txtTAX_RATE.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.TAX_RATE, Convert.ToDecimal(txtTAX_RATE.Value));

        if(txtCREATER.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.CREATER, Convert.ToString(txtCREATER.Value));

        if(txtCHECKER.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.CHECKER, Convert.ToString(txtCHECKER.Value));

        if(txtNOTE.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.NOTE, Convert.ToString(txtNOTE.Value));

        if(txtREMARK.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.REMARK, Convert.ToString(txtREMARK.Value));

        if(txtEXP1.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.EXP1, Convert.ToString(txtEXP1.Value));

        if(txtEXP2.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.EXP2, Convert.ToString(txtEXP2.Value));

        if(txtEXP3.Value !="" )
            condObj.Like(IM_PURORDER.Attribute.EXP3, Convert.ToString(txtEXP3.Value));

        hidCondition.Value = condObj.ToJson(20);

        BindList(condObj, 1);
    }
コード例 #2
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        try
        {
            condObj = new IM_PURORDER();



            if (txtPORD_ID.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.PORD_ID, Convert.ToDecimal(txtPORD_ID.Value));
            }


            if (txtPORD_NO.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.PORD_NO, Convert.ToString(txtPORD_NO.Value));
            }


            if (txtC_DATE.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.C_DATE, Convert.ToDateTime(txtC_DATE.Value));
            }


            if (txtORG_ID.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.ORG_ID, Convert.ToString(txtORG_ID.Value));
            }


            if (txtDEPT_ID.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.DEPT_ID, Convert.ToString(txtDEPT_ID.Value));
            }


            if (txtSUP_ID.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.SUP_ID, Convert.ToDecimal(txtSUP_ID.Value));
            }


            if (txtPERSON_HID.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.PERSON_HID, Convert.ToDecimal(txtPERSON_HID.Value));
            }


            if (txtTS_NO.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.TS_NO, Convert.ToString(txtTS_NO.Value));
            }


            if (txtGOODES_NUM.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.GOODES_NUM, Convert.ToDecimal(txtGOODES_NUM.Value));
            }


            if (txtARRIVAL_DATE.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.ARRIVAL_DATE, Convert.ToDateTime(txtARRIVAL_DATE.Value));
            }


            if (txtPACKAGE_TYPE.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.PACKAGE_TYPE, Convert.ToString(txtPACKAGE_TYPE.Value));
            }


            if (txtTS_DEPT.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.TS_DEPT, Convert.ToString(txtTS_DEPT.Value));
            }


            if (txtPHONE.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.PHONE, Convert.ToString(txtPHONE.Value));
            }


            if (txtCOST_PEICE_FLAG.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.COST_PEICE_FLAG, Convert.ToString(txtCOST_PEICE_FLAG.Value));
            }


            if (txtSTOR_ID.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.STOR_ID, Convert.ToDecimal(txtSTOR_ID.Value));
            }


            if (txtDEDUCTION_RATE.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.DEDUCTION_RATE, Convert.ToDecimal(txtDEDUCTION_RATE.Value));
            }


            if (txtTAX_RATE.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.TAX_RATE, Convert.ToDecimal(txtTAX_RATE.Value));
            }


            if (txtCREATER.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.CREATER, Convert.ToString(txtCREATER.Value));
            }


            if (txtCHECKER.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.CHECKER, Convert.ToString(txtCHECKER.Value));
            }


            if (txtNOTE.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.NOTE, Convert.ToString(txtNOTE.Value));
            }


            if (txtREMARK.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.REMARK, Convert.ToString(txtREMARK.Value));
            }


            if (txtEXP1.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.EXP1, Convert.ToString(txtEXP1.Value));
            }


            if (txtEXP2.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.EXP2, Convert.ToString(txtEXP2.Value));
            }


            if (txtEXP3.Value != "")
            {
                condObj.Like(IM_PURORDER.Attribute.EXP3, Convert.ToString(txtEXP3.Value));
            }

            listObj = BLLTable <IM_PURORDER> .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;
    }
コード例 #3
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj = new IM_PURORDER();



        if (txtPORD_ID.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.PORD_ID, Convert.ToDecimal(txtPORD_ID.Value));
        }


        if (txtPORD_NO.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.PORD_NO, Convert.ToString(txtPORD_NO.Value));
        }


        if (txtC_DATE.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.C_DATE, Convert.ToDateTime(txtC_DATE.Value));
        }


        if (txtORG_ID.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.ORG_ID, Convert.ToString(txtORG_ID.Value));
        }


        if (txtDEPT_ID.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.DEPT_ID, Convert.ToString(txtDEPT_ID.Value));
        }


        if (txtSUP_ID.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.SUP_ID, Convert.ToDecimal(txtSUP_ID.Value));
        }


        if (txtPERSON_HID.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.PERSON_HID, Convert.ToDecimal(txtPERSON_HID.Value));
        }


        if (txtTS_NO.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.TS_NO, Convert.ToString(txtTS_NO.Value));
        }


        if (txtGOODES_NUM.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.GOODES_NUM, Convert.ToDecimal(txtGOODES_NUM.Value));
        }


        if (txtARRIVAL_DATE.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.ARRIVAL_DATE, Convert.ToDateTime(txtARRIVAL_DATE.Value));
        }


        if (txtPACKAGE_TYPE.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.PACKAGE_TYPE, Convert.ToString(txtPACKAGE_TYPE.Value));
        }


        if (txtTS_DEPT.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.TS_DEPT, Convert.ToString(txtTS_DEPT.Value));
        }


        if (txtPHONE.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.PHONE, Convert.ToString(txtPHONE.Value));
        }


        if (txtCOST_PEICE_FLAG.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.COST_PEICE_FLAG, Convert.ToString(txtCOST_PEICE_FLAG.Value));
        }


        if (txtSTOR_ID.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.STOR_ID, Convert.ToDecimal(txtSTOR_ID.Value));
        }


        if (txtDEDUCTION_RATE.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.DEDUCTION_RATE, Convert.ToDecimal(txtDEDUCTION_RATE.Value));
        }


        if (txtTAX_RATE.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.TAX_RATE, Convert.ToDecimal(txtTAX_RATE.Value));
        }


        if (txtCREATER.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.CREATER, Convert.ToString(txtCREATER.Value));
        }


        if (txtCHECKER.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.CHECKER, Convert.ToString(txtCHECKER.Value));
        }


        if (txtNOTE.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.NOTE, Convert.ToString(txtNOTE.Value));
        }


        if (txtREMARK.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.REMARK, Convert.ToString(txtREMARK.Value));
        }


        if (txtEXP1.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.EXP1, Convert.ToString(txtEXP1.Value));
        }


        if (txtEXP2.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.EXP2, Convert.ToString(txtEXP2.Value));
        }


        if (txtEXP3.Value != "")
        {
            condObj.Like(IM_PURORDER.Attribute.EXP3, Convert.ToString(txtEXP3.Value));
        }

        hidCondition.Value = condObj.ToJson(20);

        BindList(condObj, 1);
    }
コード例 #4
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        try
        {
            condObj = new IM_PURORDER();

            if(txtPORD_ID.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.PORD_ID, Convert.ToDecimal(txtPORD_ID.Value));

            if(txtPORD_NO.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.PORD_NO, Convert.ToString(txtPORD_NO.Value));

            if(txtC_DATE.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.C_DATE, Convert.ToDateTime(txtC_DATE.Value));

            if(txtORG_ID.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.ORG_ID, Convert.ToString(txtORG_ID.Value));

            if(txtDEPT_ID.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.DEPT_ID, Convert.ToString(txtDEPT_ID.Value));

            if(txtSUP_ID.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.SUP_ID, Convert.ToDecimal(txtSUP_ID.Value));

            if(txtPERSON_HID.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.PERSON_HID, Convert.ToDecimal(txtPERSON_HID.Value));

            if(txtTS_NO.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.TS_NO, Convert.ToString(txtTS_NO.Value));

            if(txtGOODES_NUM.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.GOODES_NUM, Convert.ToDecimal(txtGOODES_NUM.Value));

            if(txtARRIVAL_DATE.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.ARRIVAL_DATE, Convert.ToDateTime(txtARRIVAL_DATE.Value));

            if(txtPACKAGE_TYPE.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.PACKAGE_TYPE, Convert.ToString(txtPACKAGE_TYPE.Value));

            if(txtTS_DEPT.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.TS_DEPT, Convert.ToString(txtTS_DEPT.Value));

            if(txtPHONE.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.PHONE, Convert.ToString(txtPHONE.Value));

            if(txtCOST_PEICE_FLAG.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.COST_PEICE_FLAG, Convert.ToString(txtCOST_PEICE_FLAG.Value));

            if(txtSTOR_ID.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.STOR_ID, Convert.ToDecimal(txtSTOR_ID.Value));

            if(txtDEDUCTION_RATE.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.DEDUCTION_RATE, Convert.ToDecimal(txtDEDUCTION_RATE.Value));

            if(txtTAX_RATE.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.TAX_RATE, Convert.ToDecimal(txtTAX_RATE.Value));

            if(txtCREATER.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.CREATER, Convert.ToString(txtCREATER.Value));

            if(txtCHECKER.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.CHECKER, Convert.ToString(txtCHECKER.Value));

            if(txtNOTE.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.NOTE, Convert.ToString(txtNOTE.Value));

            if(txtREMARK.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.REMARK, Convert.ToString(txtREMARK.Value));

            if(txtEXP1.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.EXP1, Convert.ToString(txtEXP1.Value));

            if(txtEXP2.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.EXP2, Convert.ToString(txtEXP2.Value));

            if(txtEXP3.Value !="" )
                condObj.Like(IM_PURORDER.Attribute.EXP3, Convert.ToString(txtEXP3.Value));

            listObj = BLLTable<IM_PURORDER>.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;
    }