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

        if (txtTID.Value != "")
            condObj.Like(WEC_REQUEST.Attribute.TID, Convert.ToDecimal(txtTID.Value));

        if (txtAID.Value != "")
            condObj.Like(WEC_REQUEST.Attribute.AID, Convert.ToDecimal(txtAID.Value));

        if (txtKEYWORD.Value != "")
            condObj.Like(WEC_REQUEST.Attribute.KEYWORD, Convert.ToString(txtKEYWORD.Value));

        if (txtMATCH_TYPE.Value != "")
            condObj.MATCH_TYPE = Convert.ToInt32(txtMATCH_TYPE.Value);

        if (txtMEMO.Value != "")
            condObj.Like(WEC_REQUEST.Attribute.MEMO, Convert.ToString(txtMEMO.Value));

        if (txtKIND.Value != "")
            condObj.KIND = Convert.ToInt32(txtKIND.Value);

        if (txtSTATUS.Value != "")
            condObj.STATUS = Convert.ToInt32(txtSTATUS.Value);

        if (txtADDTIME.Value != "")
            condObj.Like(WEC_REQUEST.Attribute.ADDTIME, Convert.ToDateTime(txtADDTIME.Value));

        hidCondition.Value = condObj.ToJson(20);

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

        if (txtTID.Value != "")
        {
            condObj.Like(WEC_REQUEST.Attribute.TID, Convert.ToDecimal(txtTID.Value));
        }


        if (txtAID.Value != "")
        {
            condObj.Like(WEC_REQUEST.Attribute.AID, Convert.ToDecimal(txtAID.Value));
        }


        if (txtKEYWORD.Value != "")
        {
            condObj.Like(WEC_REQUEST.Attribute.KEYWORD, Convert.ToString(txtKEYWORD.Value));
        }


        if (txtMATCH_TYPE.Value != "")
        {
            condObj.MATCH_TYPE = Convert.ToInt32(txtMATCH_TYPE.Value);
        }


        if (txtMEMO.Value != "")
        {
            condObj.Like(WEC_REQUEST.Attribute.MEMO, Convert.ToString(txtMEMO.Value));
        }


        if (txtKIND.Value != "")
        {
            condObj.KIND = Convert.ToInt32(txtKIND.Value);
        }


        if (txtSTATUS.Value != "")
        {
            condObj.STATUS = Convert.ToInt32(txtSTATUS.Value);
        }


        if (txtADDTIME.Value != "")
        {
            condObj.Like(WEC_REQUEST.Attribute.ADDTIME, Convert.ToDateTime(txtADDTIME.Value));
        }

        hidCondition.Value = condObj.ToJson(20);

        BindList(condObj, 1);
    }
コード例 #3
0
    protected string findString()
    {
        condObj   = new WEC_REQUEST();
        finderObj = new WEC_REQUEST();
        foreach (DataBaseField attr in valObj.af_GetAvailableDataBaseField())
        {
            string fieldValue;
            if (TryGetRequest(attr, out fieldValue))
            {
                AttributeItem attr1 = new AttributeItem(attr);
                condObj.Like(attr1, fieldValue);
                finderObj.SetValue(attr1, fieldValue);
            }
        }

        hidVal.Value       = valObj.ToJson(20);
        hidCondition.Value = condObj.ToJson(20);
        hidFind.Value      = finderObj.ToJson(20);

        return(finderObj.ToJson(20));
    }
コード例 #4
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj   = new WEC_REQUEST();
        finderObj = new WEC_REQUEST();
        foreach (DataBaseField attr in valObj.af_GetAvailableDataBaseField())
        {
            string fieldValue;
            if (TryGetRequest(attr, out fieldValue))
            {
                AttributeItem attr1 = new AttributeItem(attr);
                condObj.Like(attr1, fieldValue);
                finderObj.SetValue(attr1, fieldValue);
            }
        }

        hidVal.Value       = valObj.ToJson(20);
        hidCondition.Value = condObj.ToJson(20);
        hidFind.Value      = finderObj.ToJson(20);

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

        if(txtTID.Value !="" )
            condObj.Like_OR(WEC_REQUEST.Attribute.TID, Convert.ToDecimal(txtTID.Value));

        if(txtAID.Value !="" )
            condObj.Like_OR(WEC_REQUEST.Attribute.AID, Convert.ToDecimal(txtAID.Value));

        if(txtKEYWORD.Value !="" )
            condObj.Like_OR(WEC_REQUEST.Attribute.KEYWORD, Convert.ToString(txtKEYWORD.Value));

        if(txtMATCH_TYPE.Value !="" )
            condObj.MATCH_TYPE = Convert.ToInt32(txtMATCH_TYPE.Value);

        if(txtMEMO.Value !="" )
            condObj.Like_OR(WEC_REQUEST.Attribute.MEMO, Convert.ToString(txtMEMO.Value));

        if(txtKIND.Value !="" )
            condObj.KIND = Convert.ToInt32(txtKIND.Value);

        if(txtSTATUS.Value !="" )
            condObj.STATUS = Convert.ToInt32(txtSTATUS.Value);

        if(txtADDTIME.Value !="" )
            condObj.Like_OR(WEC_REQUEST.Attribute.ADDTIME, Convert.ToDateTime(txtADDTIME.Value));

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

            listObj = BLLTable<WEC_REQUEST>.SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
            repList.DataSource = listObj;
            repList.DataBind();
        }
        catch (Exception ex)
        {
             litWarn.Text = ex.Message;
        }
    }
コード例 #6
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj = new WEC_REQUEST();


        if (txtTID.Value != "")
        {
            condObj.Like_OR(WEC_REQUEST.Attribute.TID, Convert.ToDecimal(txtTID.Value));
        }


        if (txtAID.Value != "")
        {
            condObj.Like_OR(WEC_REQUEST.Attribute.AID, Convert.ToDecimal(txtAID.Value));
        }


        if (txtKEYWORD.Value != "")
        {
            condObj.Like_OR(WEC_REQUEST.Attribute.KEYWORD, Convert.ToString(txtKEYWORD.Value));
        }


        if (txtMATCH_TYPE.Value != "")
        {
            condObj.MATCH_TYPE = Convert.ToInt32(txtMATCH_TYPE.Value);
        }


        if (txtMEMO.Value != "")
        {
            condObj.Like_OR(WEC_REQUEST.Attribute.MEMO, Convert.ToString(txtMEMO.Value));
        }


        if (txtKIND.Value != "")
        {
            condObj.KIND = Convert.ToInt32(txtKIND.Value);
        }


        if (txtSTATUS.Value != "")
        {
            condObj.STATUS = Convert.ToInt32(txtSTATUS.Value);
        }


        if (txtADDTIME.Value != "")
        {
            condObj.Like_OR(WEC_REQUEST.Attribute.ADDTIME, Convert.ToDateTime(txtADDTIME.Value));
        }

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

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

            repList.DataSource = listObj;
            repList.DataBind();
        }
        catch (Exception ex)
        {
            litWarn.Text = ex.Message;
        }
    }
コード例 #7
0
    protected string findString()
    {
        condObj = new WEC_REQUEST();
        finderObj = new WEC_REQUEST();
        foreach (DataBaseField attr in valObj.af_GetAvailableDataBaseField())
        {
            string fieldValue;
            if (TryGetRequest(attr, out fieldValue))
            {
                AttributeItem attr1 = new AttributeItem(attr);
                condObj.Like(attr1, fieldValue);
                finderObj.SetValue(attr1, fieldValue);
            }
        }

        hidVal.Value = valObj.ToJson(20);
        hidCondition.Value = condObj.ToJson(20);
        hidFind.Value = finderObj.ToJson(20);

        return finderObj.ToJson(20);
    }
コード例 #8
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj = new WEC_REQUEST();
        finderObj = new WEC_REQUEST();
        foreach (DataBaseField attr in valObj.af_GetAvailableDataBaseField())
        {
            string fieldValue;
            if (TryGetRequest(attr, out fieldValue))
            {
                AttributeItem attr1 = new AttributeItem(attr);
                condObj.Like(attr1, fieldValue);
                finderObj.SetValue(attr1, fieldValue);
            }
        }

        hidVal.Value = valObj.ToJson(20);
        hidCondition.Value = condObj.ToJson(20);
        hidFind.Value = finderObj.ToJson(20);

        BindList(condObj, 1);
    }