Esempio n. 1
0
        public static string LoadSaleOrder(string sid)
        {
            string r = "";
            SessionUserValidate iv = SysValidateBll.ValidateSession();

            if (iv.f)
            {
                B_YqSaleOrder bco = bsob.Query(" and sid='" + sid + "'");
                if (bco != null)
                {
                    B_CustormOrder bdj = bcob.Query(" and csid='" + bco.csid + "'");
                    r = js.Serialize(bco);
                }
                else
                {
                    Sys_Depment sd  = sdb.Query(" and dcode='" + iv.u.dcode + "'");
                    B_SaleOrder kco = new B_SaleOrder();
                    if (sd != null)
                    {
                        if (sd.dattr == "cs")
                        {
                            Sys_DepmentDpt sdd = sddb.Query(" and dcode='" + sd.dcode + "'");
                            kco.city       = sd.dpname;
                            kco.citycode   = sd.dpcode;
                            kco.dname      = sd.dname;
                            kco.dcode      = sd.dcode;
                            kco.stelephone = sdd != null ? sdd.dcontact : "";
                        }
                        else if (sd.dattr == "dm")
                        {
                            Sys_DepmentDpt sdd = sddb.Query(" and dcode='" + sd.dcode.Substring(0, sd.dcode.Length - 4) + "'");
                            kco.city       = sd.dpname;
                            kco.citycode   = sd.dpcode;
                            kco.dname      = sd.dname;
                            kco.dcode      = sd.dcode;
                            kco.stelephone = sdd != null ? sdd.dcontact : "";
                        }
                        else
                        {
                            kco.city     = "";
                            kco.citycode = "";
                            kco.dname    = "";
                            kco.dcode    = "";
                        }
                    }
                    kco.maker = iv.u.ename;
                    r         = js.Serialize(kco);
                }
            }
            else
            {
                r = iv.badstr;
            }
            return(r);
        }
Esempio n. 2
0
        public static string CustQueryDepmentByDepCode(string dcode)
        {
            string              r    = "";
            VDepment            vsd  = new VDepment();
            Sys_Depment         sd   = new Sys_Depment();
            Sys_DepmentBll      sdb  = new Sys_DepmentBll();
            Sys_DepmentDpt      sdd  = new Sys_DepmentDpt();
            Sys_DepmentDptBll   sddb = new Sys_DepmentDptBll();
            SessionUserValidate iv   = SysValidateBll.ValidateSession();

            if (iv.f)
            {
                sd  = sdb.Query(" and dcode='" + dcode + "'");
                sdd = sddb.Query(" and dcode='" + dcode + "'");
                if (sd != null)
                {
                    vsd.dcode  = sd.dcode;
                    vsd.dname  = sd.dname;
                    vsd.dpname = sd.dpname;
                    vsd.dpcode = sd.dpcode;
                    vsd.id     = sd.id;
                    vsd.khcode = sd.khcode;
                    vsd.dattr  = sd.dattr;
                    if (sdd != null)
                    {
                        vsd.dmanager = sdd.dmanager;
                        vsd.dcontact = sdd.dcontact;
                    }
                    if (sd.dread)
                    {
                        r = "R";
                    }
                    else
                    {
                        r = js.Serialize(vsd);
                    }
                }
                else
                {
                    r = iv.badstr;
                }
            }
            else
            {
                r = iv.badstr;
            }
            return(r);
        }
Esempio n. 3
0
        public static string QueryCompany(string dcode)
        {
            string              r    = "";
            Sys_Depment         sd   = new Sys_Depment();
            Sys_DepmentDpt      sdd  = new Sys_DepmentDpt();
            Sys_DepmentBll      sdb  = new Sys_DepmentBll();
            Sys_DepmentDptBll   sddb = new Sys_DepmentDptBll();
            SessionUserValidate iv   = SysValidateBll.ValidateSession();

            if (iv.f)
            {
                VDepment vd = new VDepment();
                if (dcode == "")
                {
                    vd.dcode = "0001" + sdb.CreateCode("0001").ToString().PadLeft(4, '0');
                    vd.id    = 0;
                }
                else
                {
                    sd             = sdb.Query(" and dcode='" + dcode + "'");
                    sdd            = sddb.Query(" and dcode='" + dcode + "'");
                    vd.id          = sd.id;
                    vd.dcode       = sd.dcode;
                    vd.dname       = sd.dname;
                    vd.dabc        = sd.dabc;
                    vd.dattr       = sd.dattr;
                    vd.daddress    = sdd.daddress;
                    vd.dcontact    = sdd.dcontact;
                    vd.dmanager    = sdd.dmanager;
                    vd.disused     = sd.disused;
                    vd.iadmin      = sdd.iadmin == true ? "1" : "0";
                    vd.idepment    = sdd.idepment;
                    vd.logo        = sdd.logo;
                    vd.iproduction = sdd.iproduction == true ? "1" : "0";
                }
                r = js.Serialize(vd);
            }
            else
            {
                r = iv.badstr;
            }
            return(r);
        }
Esempio n. 4
0
        public static string InitOrder(string sid, string zsid)
        {
            string r = "";
            SessionUserValidate iv = SysValidateBll.ValidateSession();

            if (iv.f)
            {
                B_SaleOrder bco = new B_SaleOrder();
                if (sid != "")
                {
                    bco = bsob.Query(" and sid='" + sid + "'");
                    r   = js.Serialize(bco);
                }
                else
                {
                    if (zsid != "")
                    {
                        B_Orders       bo  = bob.Query(" and sid='" + zsid + "'");
                        Sys_DepmentDpt sdd = sddb.Query(" and dcode='" + bo.dcode + "'");
                        bco.city       = bo.city;
                        bco.citycode   = bo.citycode;
                        bco.dname      = bo.dname;
                        bco.dcode      = bo.dcode;
                        bco.zsid       = bo.sid;
                        bco.customer   = bo.customer;
                        bco.telephone  = bo.telephone;
                        bco.address    = bo.address;
                        bco.community  = bo.community;
                        bco.zcode      = bo.zcode;
                        bco.stelephone = sdd != null ? sdd.dcontact : "";
                        bco.maker      = iv.u.ename;
                    }
                    r = js.Serialize(bco);
                }
            }
            else
            {
                r = iv.badstr;
            }
            return(r);
        }