Ejemplo n.º 1
0
        public static ArrayList QueryList(string ptcode)
        {
            ArrayList                r    = new ArrayList();
            Sys_AgentFeeBll          srb  = new Sys_AgentFeeBll();
            List <Sys_AgentFee>      lsf  = new List <Sys_AgentFee>();
            Sys_InventoryCategoryBll sicb = new Sys_InventoryCategoryBll();
            Sys_DepmentBll           sdb  = new Sys_DepmentBll();
            SessionUserValidate      iv   = SysValidateBll.ValidateSession();

            if (iv.f)
            {
                r.Add(iv.badstr);
                lsf = srb.QueryList(" and acode='" + ptcode + "'");
                if (lsf != null)
                {
                    foreach (Sys_AgentFee s in lsf)
                    {
                        ArrayList             al  = new ArrayList();
                        Sys_InventoryCategory sic = sicb.Query(" and iccode='" + s.icode + "'");
                        Sys_Depment           dt  = sdb.Query(" and dcode='" + s.acode + "'");
                        al.Add(s.id);
                        al.Add(dt == null?"":dt.dname);
                        al.Add(sic == null?"":sic.icname);
                        al.Add(s.fmoney);
                        al.Add(s.tfmoney);
                        r.Add(al);
                    }
                }
            }
            else
            {
                r.Add(iv.badstr);
            }
            return(r);
        }