コード例 #1
0
    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;
    }
コード例 #2
0
    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);
    }
コード例 #3
0
    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);
    }
コード例 #4
0
    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;
    }