コード例 #1
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);
        }
コード例 #2
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);
        }
コード例 #3
0
        public static string AddCompany(string aid, string dabc, string daddress, string dcode, string dname, string dtype, string iadmin, string idep, string iproduction, string manager, string telephone)
        {
            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)
            {
                sd.dname        = dname;
                sd.dcode        = dcode;
                sd.disend       = true;
                sd.disused      = true;
                sd.dattr        = dtype;
                sd.dcdate       = DateTime.Now.ToString();
                sd.dmaker       = iv.u.ename;
                sd.dpcode       = "0001";
                sd.dpname       = "北京联汇软件";
                sd.dcdep        = idep;
                sd.dread        = true;
                sd.dabc         = dabc;
                sdd.dcode       = dcode;
                sdd.daddress    = daddress;
                sdd.dcontact    = telephone;
                sdd.ddetail     = "";
                sdd.dfitment    = DateTime.Now.ToString();
                sdd.dmaker      = iv.u.ename;
                sdd.dmanager    = manager;
                sdd.dno         = "";
                sdd.iadmin      = iadmin == "1" ? true : false;
                sdd.idepment    = idep;
                sdd.logo        = "";
                sdd.iproduction = iproduction == "1" ? true : false;
                sdd.dperson     = 0;
                if (aid == "0")
                {
                    if (sdb.AddDepWithChildDep(sd) > 0)
                    {
                        if (sdd.iadmin)
                        {
                            #region
                            Sys_Employee       se   = new Sys_Employee();
                            Sys_User           su   = new Sys_User();
                            Sys_EmployeeDpt    sed  = new Sys_EmployeeDpt();
                            Sys_EmployeeBll    seb  = new Sys_EmployeeBll();
                            Sys_UserBll        sub  = new Sys_UserBll();
                            Sys_Employee       cse  = new Sys_Employee();
                            Sys_EmployeeDptBll sedb = new Sys_EmployeeDptBll();

                            se.dname  = sd.dname;
                            se.dcode  = sd.dcode;
                            se.eno    = "E" + seb.GetEno().ToString().PadLeft(8, '0');
                            se.ename  = sd.dname + "管理员";
                            se.estate = true;
                            se.dtcode = "";
                            se.elogin = true;
                            se.ecdate = DateTime.Now.ToString();
                            se.emaker = iv.u.ename;
                            se.rcode  = "0001";

                            sed.eaddress     = "";
                            sed.eage         = 0;
                            sed.eeducation   = "";
                            sed.eemail       = "";
                            sed.eheadimage   = "";
                            sed.eidentity    = "";
                            sed.enativeplace = "";
                            sed.eno          = se.eno;
                            sed.esex         = true;
                            sed.etelephone   = "";
                            sed.eworkdate    = DateTime.Now.ToString();

                            su.eno        = se.eno;
                            su.upass      = DES.EncryptDES("123456");
                            su.uname      = sd.dabc + "_admin";
                            su.ulogin     = true;
                            su.uip        = "";
                            su.ulogintime = "";
                            seb.AddList(se, sed, su);
                            #endregion
                        }
                        if (sdd.iproduction)
                        {
                            #region
                            Sys_InventoryCategoryBll sicb = new Sys_InventoryCategoryBll();
                            Sys_InventoryCategory    zcp  = new Sys_InventoryCategory();
                            zcp.iccode  = sd.dcode;
                            zcp.icpcode = "";
                            zcp.icname  = sd.dname + "产品";
                            zcp.icpname = "";
                            zcp.maker   = iv.u.ename;
                            zcp.cdate   = DateTime.Now.ToString();
                            zcp.icsend  = true;
                            zcp.icstate = false;
                            zcp.icms    = "";
                            sicb.Add(zcp);
                            Sys_InventoryCategory ztm = new Sys_InventoryCategory();
                            ztm.iccode  = sd.dcode + "10";
                            ztm.icpcode = sd.dcode;
                            ztm.icname  = "整套门";
                            ztm.icpname = "";
                            ztm.maker   = iv.u.ename;
                            ztm.cdate   = DateTime.Now.ToString();
                            ztm.icsend  = true;
                            ztm.icstate = true;
                            ztm.icms    = "";
                            ztm.isort   = 1;
                            sicb.Add(ztm);
                            Sys_InventoryCategory ms = new Sys_InventoryCategory();
                            ms.iccode  = sd.dcode + "01";
                            ms.icpcode = sd.dcode;
                            ms.icname  = "门扇";
                            ms.icpname = "";
                            ms.maker   = iv.u.ename;
                            ms.cdate   = DateTime.Now.ToString();
                            ms.icsend  = true;
                            ms.icstate = false;
                            ms.icms    = "";
                            ms.isort   = 2;
                            sicb.Add(ms);
                            Sys_InventoryCategory dms = new Sys_InventoryCategory();
                            dms.iccode  = ms.iccode + "01";
                            dms.icpcode = ms.iccode;
                            dms.icname  = "单开门";
                            dms.icpname = "门扇";
                            dms.maker   = iv.u.ename;
                            dms.cdate   = DateTime.Now.ToString();
                            dms.icsend  = true;
                            dms.icstate = true;
                            dms.icms    = "";
                            dms.isort   = 21;
                            sicb.Add(dms);
                            Sys_InventoryCategory sms = new Sys_InventoryCategory();
                            sms.iccode  = ms.iccode + "02";
                            sms.icpcode = ms.iccode;
                            sms.icname  = "对开门";
                            sms.icpname = "门扇";
                            sms.maker   = iv.u.ename;
                            sms.cdate   = DateTime.Now.ToString();
                            sms.icsend  = true;
                            sms.icstate = true;
                            sms.icms    = "";
                            sms.isort   = 22;
                            sicb.Add(sms);
                            Sys_InventoryCategory zms = new Sys_InventoryCategory();
                            zms.iccode  = ms.iccode + "03";
                            zms.icpcode = ms.iccode;
                            zms.icname  = "子母门";
                            zms.icpname = "门扇";
                            zms.maker   = iv.u.ename;
                            zms.cdate   = DateTime.Now.ToString();
                            zms.icsend  = true;
                            zms.icstate = true;
                            zms.icms    = "";
                            zms.isort   = 23;
                            sicb.Add(zms);
                            Sys_InventoryCategory tlm = new Sys_InventoryCategory();
                            tlm.iccode  = ms.iccode + "04";
                            tlm.icpcode = ms.iccode;
                            tlm.icname  = "推拉门";
                            tlm.icpname = "门扇";
                            tlm.maker   = iv.u.ename;
                            tlm.cdate   = DateTime.Now.ToString();
                            tlm.icsend  = true;
                            tlm.icstate = false;
                            tlm.icms    = "";
                            tlm.isort   = 24;
                            sicb.Add(tlm);
                            Sys_InventoryCategory stlm = new Sys_InventoryCategory();
                            stlm.iccode  = tlm.iccode + "01";
                            stlm.icpcode = tlm.iccode;
                            stlm.icname  = "两扇推拉门";
                            stlm.icpname = "推拉门";
                            stlm.maker   = iv.u.ename;
                            stlm.cdate   = DateTime.Now.ToString();
                            stlm.icsend  = true;
                            stlm.icstate = true;
                            stlm.icms    = "";
                            stlm.isort   = 241;
                            sicb.Add(stlm);
                            Sys_InventoryCategory ftlm = new Sys_InventoryCategory();
                            ftlm.iccode  = tlm.iccode + "02";
                            ftlm.icpcode = tlm.iccode;
                            ftlm.icname  = "四扇推拉门";
                            ftlm.icpname = "推拉门";
                            ftlm.maker   = iv.u.ename;
                            ftlm.cdate   = DateTime.Now.ToString();
                            ftlm.icsend  = true;
                            ftlm.icstate = true;
                            ftlm.icms    = "";
                            ftlm.isort   = 242;
                            sicb.Add(ftlm);
                            Sys_InventoryCategory mt = new Sys_InventoryCategory();
                            mt.iccode  = sd.dcode + "02";
                            mt.icpcode = sd.dcode;
                            mt.icname  = "门套";
                            mt.icpname = "";
                            mt.maker   = iv.u.ename;
                            mt.cdate   = DateTime.Now.ToString();
                            mt.icsend  = true;
                            mt.icstate = false;
                            mt.icms    = "";
                            mt.isort   = 3;
                            sicb.Add(mt);
                            Sys_InventoryCategory dmt = new Sys_InventoryCategory();
                            dmt.iccode  = mt.iccode + "01";
                            dmt.icpcode = mt.iccode;
                            dmt.icname  = "单开门套";
                            dmt.icpname = "门套";
                            dmt.maker   = iv.u.ename;
                            dmt.cdate   = DateTime.Now.ToString();
                            dmt.icsend  = true;
                            dmt.icstate = true;
                            dmt.icms    = "";
                            dmt.isort   = 31;
                            sicb.Add(dmt);
                            Sys_InventoryCategory smt = new Sys_InventoryCategory();
                            smt.iccode  = mt.iccode + "02";
                            smt.icpcode = mt.iccode;
                            smt.icname  = "对开门套";
                            smt.icpname = "门套";
                            smt.maker   = iv.u.ename;
                            smt.cdate   = DateTime.Now.ToString();
                            smt.icsend  = true;
                            smt.icstate = true;
                            smt.icms    = "";
                            smt.isort   = 32;
                            sicb.Add(smt);
                            Sys_InventoryCategory zmt = new Sys_InventoryCategory();
                            zmt.iccode  = mt.iccode + "03";
                            zmt.icpcode = mt.iccode;
                            zmt.icname  = "子母门套";
                            zmt.icpname = "门套";
                            zmt.maker   = iv.u.ename;
                            zmt.cdate   = DateTime.Now.ToString();
                            zmt.icsend  = true;
                            zmt.icstate = true;
                            zmt.icms    = "";
                            zmt.isort   = 33;
                            sicb.Add(zmt);
                            Sys_InventoryCategory tmt = new Sys_InventoryCategory();
                            tmt.iccode  = mt.iccode + "04";
                            tmt.icpcode = mt.iccode;
                            tmt.icname  = "推拉门套";
                            tmt.icpname = "门套";
                            tmt.maker   = iv.u.ename;
                            tmt.cdate   = DateTime.Now.ToString();
                            tmt.icsend  = true;
                            tmt.icstate = true;
                            tmt.icms    = "";
                            tmt.isort   = 34;
                            sicb.Add(tmt);
                            Sys_InventoryCategory wj = new Sys_InventoryCategory();
                            wj.iccode  = sd.dcode + "04";
                            wj.icpcode = sd.dcode;
                            wj.icname  = "五金";
                            wj.icpname = "";
                            wj.maker   = iv.u.ename;
                            wj.cdate   = DateTime.Now.ToString();
                            wj.icsend  = true;
                            wj.icstate = true;
                            wj.icms    = "";
                            wj.isort   = 4;
                            sicb.Add(wj);
                            Sys_InventoryCategory bl = new Sys_InventoryCategory();
                            bl.iccode  = sd.dcode + "05";
                            bl.icpcode = sd.dcode;
                            bl.icname  = "玻璃";
                            bl.icpname = "";
                            bl.maker   = iv.u.ename;
                            bl.cdate   = DateTime.Now.ToString();
                            bl.icsend  = true;
                            bl.icstate = true;
                            bl.icms    = "";
                            bl.isort   = 5;
                            sicb.Add(bl);
                            Sys_InventoryCategory ct = new Sys_InventoryCategory();
                            ct.iccode  = sd.dcode + "06";
                            ct.icpcode = sd.dcode;
                            ct.icname  = "窗套";
                            ct.icpname = "";
                            ct.maker   = iv.u.ename;
                            ct.cdate   = DateTime.Now.ToString();
                            ct.icsend  = true;
                            ct.icstate = true;
                            ct.icms    = "";
                            ct.isort   = 6;
                            sicb.Add(ct);
                            Sys_InventoryCategory yk = new Sys_InventoryCategory();
                            yk.iccode  = sd.dcode + "07";
                            yk.icpcode = sd.dcode;
                            yk.icname  = "垭口";
                            yk.icpname = "";
                            yk.maker   = iv.u.ename;
                            yk.cdate   = DateTime.Now.ToString();
                            yk.icsend  = true;
                            yk.icstate = true;
                            yk.icms    = "";
                            yk.isort   = 7;
                            sicb.Add(yk);
                            Sys_InventoryCategory hj = new Sys_InventoryCategory();
                            hj.iccode  = sd.dcode + "08";
                            hj.icpcode = sd.dcode;
                            hj.icname  = "护角";
                            hj.icpname = "";
                            hj.maker   = iv.u.ename;
                            hj.cdate   = DateTime.Now.ToString();
                            hj.icsend  = true;
                            hj.icstate = true;
                            hj.icms    = "";
                            hj.isort   = 8;
                            sicb.Add(hj);
                            Sys_InventoryCategory qt = new Sys_InventoryCategory();
                            qt.iccode  = sd.dcode + "09";
                            qt.icpcode = sd.dcode;
                            qt.icname  = "其他";
                            qt.icpname = "";
                            qt.maker   = iv.u.ename;
                            qt.cdate   = DateTime.Now.ToString();
                            qt.icsend  = true;
                            qt.icstate = true;
                            qt.icms    = "";
                            qt.isort   = 9;
                            sicb.Add(qt);
                            #endregion
                        }
                        sddb.Add(sdd);
                        r = "S";
                    }
                    else
                    {
                        r = "F";
                    }
                }
                else
                {
                    if (sdb.Update(sd))
                    {
                        sddb.Update(sdd);
                        r = "S";
                    }
                    else
                    {
                        r = "F";
                    }
                }
            }
            else
            {
                r = iv.badstr;
            }
            return(r);
        }
コード例 #4
0
        public static string CustSaveDep(string adepattr, string adepcode, string adepmanager, string adepname, string adeptelephone, string aid, string pdepcode, string pdepname)
        {
            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)
            {
                sd.dname     = adepname;
                sd.dcode     = adepcode;
                sd.disend    = true;
                sd.disused   = true;
                sd.dattr     = adepattr;
                sd.dcdate    = DateTime.Now.ToString();
                sd.dmaker    = iv.u.ename;
                sd.dpcode    = pdepcode;
                sd.dpname    = pdepname;
                sd.dcdep     = "";
                sd.dread     = false;
                sdd.dcode    = adepcode;
                sdd.daddress = "";
                sdd.dcontact = adeptelephone;
                sdd.ddetail  = "";
                sdd.dfitment = DateTime.Now.ToString();
                sdd.dmaker   = iv.u.ename;
                sdd.dmanager = adepmanager;
                sdd.dno      = "";
                sdd.dperson  = 0;
                if (aid == "0")
                {
                    if (sdb.Add(sd) > 0)
                    {
                        sddb.Add(sdd);
                        r = "S";
                    }
                    else
                    {
                        r = "F";
                    }
                }
                else
                {
                    if (sdb.Update(sd))
                    {
                        sddb.Update(sdd);
                        r = "S";
                    }
                    else
                    {
                        r = "F";
                    }
                }
            }
            else
            {
                r = iv.badstr;
            }
            return(r);
        }
コード例 #5
0
        public static string SaveDep(string adepattr, string adepcode, string adepmanager, string adepname, string adeptelephone, string admattr, string adsort, string adsquare, string aid, string akhcode, string dabc, string pdepcode, string pdepname)
        {
            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)
            {
                sd.dname   = adepname;
                sd.dcode   = adepcode;
                sd.disend  = true;
                sd.disused = true;
                sd.dattr   = adepattr;
                sd.dcdate  = DateTime.Now.ToString();
                sd.cdate   = DateTime.Now.ToString();
                sd.dmaker  = iv.u.ename;
                sd.dpcode  = pdepcode;
                sd.dpname  = pdepname;
                sd.dcdep   = "";
                sd.dread   = true;
                sd.dabc    = dabc;
                sd.khcode  = akhcode;
                sd.dsquare = adsquare == ""?0: Convert.ToDecimal(adsquare);
                sd.dsort   = Convert.ToInt32(adsort);
                if (adepattr == "dm")
                {
                    sd.dmattr = admattr;
                }
                else
                {
                    sd.dmattr = "";
                }
                sdd.dcode    = adepcode;
                sdd.daddress = "";
                sdd.dcontact = adeptelephone;
                sdd.ddetail  = "";
                sdd.dfitment = DateTime.Now.ToString();
                sdd.dmaker   = iv.u.ename;
                sdd.dmanager = adepmanager;
                sdd.dno      = "";
                sdd.dperson  = 0;
                if (aid == "0")
                {
                    if (sdb.AddDepWithChildDep(sd) > 0)
                    {
                        sddb.Add(sdd);
                        r = "S";
                    }
                    else
                    {
                        r = "F";
                    }
                }
                else
                {
                    if (sdb.Update(sd))
                    {
                        sddb.Update(sdd);
                        r = "S";
                    }
                    else
                    {
                        r = "F";
                    }
                }
            }
            else
            {
                r = iv.badstr;
            }
            return(r);
        }