Ejemplo n.º 1
0
        public Hashtable GetTransations(Hashtable htLCOPreUDefineParams, string username, string catid, string operator_id)
        {
            string whereString = "";
            string lcocd       = htLCOPreUDefineParams["lcocd"].ToString();
            string lconm       = htLCOPreUDefineParams["lconm"].ToString();

            //string searchParamStr = "";

            if (lcocd != null && lcocd != "")
            {
                whereString += "  upper(lcocode)  like upper('" + lcocd + "%') ";
                //searchParamStr += " <b>Transaction From : </b> " + from;
            }
            else if (lconm != null && lconm != "")
            {
                whereString += "  upper(lconame) like upper('" + lconm + "%') ";
                //searchParamStr += " <b>Transaction To : </b> " + to;
            }
            if (catid == "2")
            {
                whereString += "  and PARENTID= '" + operator_id + "' ";
            }
            else if (catid == "5")
            {
                whereString += "  and DISTID= '" + operator_id + "' ";
            }
            else if (catid == "3")
            {
                whereString += "  and OPERID= '" + operator_id + "' ";
            }

            Cls_Data_MstLCOPreUDefine objDataLCOPreUDefine = new Cls_Data_MstLCOPreUDefine();
            Hashtable htResponse = new Hashtable();

            htResponse.Add("htResponse", objDataLCOPreUDefine.getLCOData(whereString, username));
            //htResponse.Add("ParamStr", searchParamStr);
            return(htResponse);
        }
Ejemplo n.º 2
0
        public DataTable getUserDataBll(string whereClauseStr, string username)
        {
            Cls_Data_MstLCOPreUDefine obj = new Cls_Data_MstLCOPreUDefine();

            return(obj.getLCOData(whereClauseStr, username));
        }