예제 #1
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj = new V_DEVICELIST();

        if(txtV_DEVICELIST_ID.Value !="" )
            condObj.Like(V_DEVICELIST.Attribute.ID, Convert.ToDecimal(txtV_DEVICELIST_ID.Value));

        if(txtV_DEVICELIST_USER_ID.Value !="" )
            condObj.Like(V_DEVICELIST.Attribute.USER_ID, Convert.ToDecimal(txtV_DEVICELIST_USER_ID.Value));

        if(txtV_DEVICELIST_DEVICE_ID.Value !="" )
            condObj.Like(V_DEVICELIST.Attribute.DEVICE_ID, Convert.ToString(txtV_DEVICELIST_DEVICE_ID.Value));

        if(txtV_DEVICELIST_KIND.Value !="" )
            condObj.Like(V_DEVICELIST.Attribute.KIND, Convert.ToInt32(txtV_DEVICELIST_KIND.Value));

        if(txtV_DEVICELIST_DEBUG.Value !="" )
            condObj.Like(V_DEVICELIST.Attribute.DEBUG, Convert.ToInt32(txtV_DEVICELIST_DEBUG.Value));

        if(txtV_DEVICELIST_STATUS.Value !="" )
            condObj.Like(V_DEVICELIST.Attribute.STATUS, Convert.ToInt32(txtV_DEVICELIST_STATUS.Value));

        if(txtV_DEVICELIST_AF_ADDTIEM.Value !="" )
            condObj.Like(V_DEVICELIST.Attribute.AF_ADDTIEM, Convert.ToDateTime(txtV_DEVICELIST_AF_ADDTIEM.Value));

        if(txtV_DEVICELIST_AF_EDITTIME.Value !="" )
            condObj.Like(V_DEVICELIST.Attribute.AF_EDITTIME, Convert.ToDateTime(txtV_DEVICELIST_AF_EDITTIME.Value));

        if(txtV_DEVICELIST_TOKEN_ID.Value !="" )
            condObj.Like(V_DEVICELIST.Attribute.TOKEN_ID, Convert.ToString(txtV_DEVICELIST_TOKEN_ID.Value));

        if(txtV_DEVICELIST_STAFF_NAME.Value !="" )
            condObj.Like(V_DEVICELIST.Attribute.STAFF_NAME, Convert.ToString(txtV_DEVICELIST_STAFF_NAME.Value));

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

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

        if(txtV_DEVICELIST_ID.Value != "" )
            condObj.Like(V_DEVICELIST.Attribute.ID, Convert.ToDecimal(txtV_DEVICELIST_ID.Value));

        if(txtV_DEVICELIST_USER_ID.Value != "" )
            condObj.Like(V_DEVICELIST.Attribute.USER_ID, Convert.ToDecimal(txtV_DEVICELIST_USER_ID.Value));

        if(txtV_DEVICELIST_DEVICE_ID.Value != "" )
            condObj.Like(V_DEVICELIST.Attribute.DEVICE_ID, Convert.ToString(txtV_DEVICELIST_DEVICE_ID.Value));

        if(txtV_DEVICELIST_KIND.Value != "" )
            condObj.Like(V_DEVICELIST.Attribute.KIND, Convert.ToInt32(txtV_DEVICELIST_KIND.Value));

        if(txtV_DEVICELIST_DEBUG.Value != "" )
            condObj.Like(V_DEVICELIST.Attribute.DEBUG, Convert.ToInt32(txtV_DEVICELIST_DEBUG.Value));

        if(txtV_DEVICELIST_STATUS.Value != "" )
            condObj.Like(V_DEVICELIST.Attribute.STATUS, Convert.ToInt32(txtV_DEVICELIST_STATUS.Value));

        if(txtV_DEVICELIST_AF_ADDTIEM.Value != "" )
            condObj.Like(V_DEVICELIST.Attribute.AF_ADDTIEM, Convert.ToDateTime(txtV_DEVICELIST_AF_ADDTIEM.Value));

        if(txtV_DEVICELIST_AF_EDITTIME.Value != "" )
            condObj.Like(V_DEVICELIST.Attribute.AF_EDITTIME, Convert.ToDateTime(txtV_DEVICELIST_AF_EDITTIME.Value));

        if(txtV_DEVICELIST_TOKEN_ID.Value != "" )
            condObj.Like(V_DEVICELIST.Attribute.TOKEN_ID, Convert.ToString(txtV_DEVICELIST_TOKEN_ID.Value));

        if(txtV_DEVICELIST_STAFF_NAME.Value != "" )
            condObj.Like(V_DEVICELIST.Attribute.STAFF_NAME, Convert.ToString(txtV_DEVICELIST_STAFF_NAME.Value));

        hidCondition.Value = condObj.ToJson(20);

        BindList(condObj, 1);
    }
예제 #3
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj = new V_DEVICELIST();


        if (txtV_DEVICELIST_ID.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.ID, Convert.ToDecimal(txtV_DEVICELIST_ID.Value));
        }


        if (txtV_DEVICELIST_USER_ID.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.USER_ID, Convert.ToDecimal(txtV_DEVICELIST_USER_ID.Value));
        }


        if (txtV_DEVICELIST_DEVICE_ID.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.DEVICE_ID, Convert.ToString(txtV_DEVICELIST_DEVICE_ID.Value));
        }


        if (txtV_DEVICELIST_KIND.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.KIND, Convert.ToInt32(txtV_DEVICELIST_KIND.Value));
        }


        if (txtV_DEVICELIST_DEBUG.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.DEBUG, Convert.ToInt32(txtV_DEVICELIST_DEBUG.Value));
        }


        if (txtV_DEVICELIST_STATUS.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.STATUS, Convert.ToInt32(txtV_DEVICELIST_STATUS.Value));
        }


        if (txtV_DEVICELIST_AF_ADDTIEM.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.AF_ADDTIEM, Convert.ToDateTime(txtV_DEVICELIST_AF_ADDTIEM.Value));
        }


        if (txtV_DEVICELIST_AF_EDITTIME.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.AF_EDITTIME, Convert.ToDateTime(txtV_DEVICELIST_AF_EDITTIME.Value));
        }


        if (txtV_DEVICELIST_TOKEN_ID.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.TOKEN_ID, Convert.ToString(txtV_DEVICELIST_TOKEN_ID.Value));
        }


        if (txtV_DEVICELIST_STAFF_NAME.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.STAFF_NAME, Convert.ToString(txtV_DEVICELIST_STAFF_NAME.Value));
        }

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

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



        if (txtV_DEVICELIST_ID.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.ID, Convert.ToDecimal(txtV_DEVICELIST_ID.Value));
        }


        if (txtV_DEVICELIST_USER_ID.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.USER_ID, Convert.ToDecimal(txtV_DEVICELIST_USER_ID.Value));
        }


        if (txtV_DEVICELIST_DEVICE_ID.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.DEVICE_ID, Convert.ToString(txtV_DEVICELIST_DEVICE_ID.Value));
        }


        if (txtV_DEVICELIST_KIND.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.KIND, Convert.ToInt32(txtV_DEVICELIST_KIND.Value));
        }


        if (txtV_DEVICELIST_DEBUG.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.DEBUG, Convert.ToInt32(txtV_DEVICELIST_DEBUG.Value));
        }


        if (txtV_DEVICELIST_STATUS.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.STATUS, Convert.ToInt32(txtV_DEVICELIST_STATUS.Value));
        }


        if (txtV_DEVICELIST_AF_ADDTIEM.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.AF_ADDTIEM, Convert.ToDateTime(txtV_DEVICELIST_AF_ADDTIEM.Value));
        }


        if (txtV_DEVICELIST_AF_EDITTIME.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.AF_EDITTIME, Convert.ToDateTime(txtV_DEVICELIST_AF_EDITTIME.Value));
        }


        if (txtV_DEVICELIST_TOKEN_ID.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.TOKEN_ID, Convert.ToString(txtV_DEVICELIST_TOKEN_ID.Value));
        }


        if (txtV_DEVICELIST_STAFF_NAME.Value != "")
        {
            condObj.Like(V_DEVICELIST.Attribute.STAFF_NAME, Convert.ToString(txtV_DEVICELIST_STAFF_NAME.Value));
        }

        hidCondition.Value = condObj.ToJson(20);

        BindList(condObj, 1);
    }