Beispiel #1
0
        public static string InitOrderType(string tcode)
        {
            string              r   = "";
            Sys_OrderTypeBll    svb = new Sys_OrderTypeBll();
            Sys_OrderType       st  = new Sys_OrderType();
            SessionUserValidate iv  = SysValidateBll.ValidateSession();

            if (iv.f)
            {
                if (tcode == "")
                {
                    st.tcode = svb.CreateCode().ToString().PadLeft(4, '0');
                    st.tname = "";
                    st.id    = 0;
                }
                else
                {
                    st = svb.Query(" and tcode='" + tcode + "'");
                }
                r = js.Serialize(st);
            }
            else
            {
                r = iv.badstr;
            }
            return(r);
        }
Beispiel #2
0
        public static ArrayList QueryListByEmenu(string emcode)
        {
            ArrayList           r   = new ArrayList();
            Sys_OrderTypeBll    svb = new Sys_OrderTypeBll();
            Sys_EventMenuBll    srb = new Sys_EventMenuBll();
            SessionUserValidate iv  = SysValidateBll.ValidateSession();

            if (iv.f)
            {
                r.Add(iv.badstr);
                List <Sys_OrderType> ls = svb.QueryList(" and emcode='" + emcode + "'");
                if (ls != null)
                {
                    foreach (Sys_OrderType s in ls)
                    {
                        ArrayList al = new ArrayList();
                        al.Add(s.tcode);
                        al.Add(s.tname);
                        r.Add(al);
                    }
                }
            }
            else
            {
                r.Add(iv.badstr);
            }
            return(r);
        }
Beispiel #3
0
        public static string SaveOrderType(string dsource, string emcode, string ofcode, string ofname, string ofid)
        {
            string              r   = "";
            Sys_OrderTypeBll    svb = new Sys_OrderTypeBll();
            Sys_OrderType       sv  = new Sys_OrderType();
            SessionUserValidate iv  = SysValidateBll.ValidateSession();

            if (iv.f)
            {
                sv.emname  = "";
                sv.emcode  = emcode;
                sv.tcode   = ofcode;
                sv.tname   = ofname;
                sv.tread   = true;
                sv.ttype   = "a";
                sv.dcode   = iv.u.dcode.Substring(0, 8);
                sv.cdate   = DateTime.Now.ToString();
                sv.maker   = iv.u.ename;
                sv.tsource = dsource;
                if (ofid == "0")
                {
                    if (svb.Add(sv) > 0)
                    {
                        r = "S";
                    }
                    else
                    {
                        r = "F";
                    }
                }
                else
                {
                    if (svb.Update(sv))
                    {
                        r = "S";
                    }
                    else
                    {
                        r = "F";
                    }
                }
            }
            else
            {
                r = iv.badstr;
            }
            return(r);
        }
Beispiel #4
0
        public static ArrayList QueryList()
        {
            ArrayList           r   = new ArrayList();
            Sys_OrderTypeBll    svb = new Sys_OrderTypeBll();
            Sys_EventMenuBll    srb = new Sys_EventMenuBll();
            SessionUserValidate iv  = SysValidateBll.ValidateSession();

            if (iv.f)
            {
                r.Add(iv.badstr);
                string where = "";
                if (iv.u.rcode != "xtgl")
                {
                    where = " and  dcode='" + iv.u.dcode.Substring(0, 8) + "'";
                }
                List <Sys_OrderType> ls = svb.QueryList(where);
                if (ls != null)
                {
                    foreach (Sys_OrderType s in ls)
                    {
                        Sys_EventMenu sem = srb.Query(" and emcode='" + s.emcode + "'");
                        ArrayList     al  = new ArrayList();
                        al.Add(s.tcode);
                        al.Add(s.tname);
                        if (sem != null)
                        {
                            al.Add(sem.emname);
                        }
                        else
                        {
                            al.Add("");
                        }
                        r.Add(al);
                    }
                }
            }
            else
            {
                r.Add(iv.badstr);
            }
            return(r);
        }
Beispiel #5
0
        public static string CustDelOrderType(string tcode)
        {
            string              r   = "";
            Sys_OrderTypeBll    sdb = new Sys_OrderTypeBll();
            SessionUserValidate iv  = SysValidateBll.ValidateSession();

            if (iv.f)
            {
                Sys_OrderType sot = sdb.Query(" and tcode='" + tcode + "'");
                if (sot != null)
                {
                    if (sot.tread)
                    {
                        r = "R";
                    }
                    else
                    {
                        if (sdb.Delete(" and tcode='" + tcode + "'"))
                        {
                            r = "S";
                        }
                        else
                        {
                            r = "F";
                        }
                    }
                }
                else
                {
                    r = "F";
                }
            }
            else
            {
                r = iv.badstr;
            }
            return(r);
        }
Beispiel #6
0
        public static string DelOrderType(string tcode)
        {
            string              r   = "";
            Sys_OrderTypeBll    sdb = new Sys_OrderTypeBll();
            SessionUserValidate iv  = SysValidateBll.ValidateSession();

            if (iv.f)
            {
                if (sdb.Delete(" and tcode='" + tcode + "'"))
                {
                    r = "S";
                }
                else
                {
                    r = "F";
                }
            }
            else
            {
                r = iv.badstr;
            }
            return(r);
        }
Beispiel #7
0
        public static ArrayList CustQueryListByEmenu(string emcode)
        {
            ArrayList           r   = new ArrayList();
            Sys_OrderTypeBll    svb = new Sys_OrderTypeBll();
            Sys_EventMenuBll    srb = new Sys_EventMenuBll();
            SessionUserValidate iv  = SysValidateBll.ValidateSession();

            if (iv.f)
            {
                r.Add(iv.badstr);
                string where = "";
                if (iv.u.rcode == "xtgl")
                {
                }
                else
                {
                    where = " and (ttype='a' or dcode='" + iv.u.dcode.Substring(0, 8) + "')";
                }
                List <Sys_OrderType> ls = svb.QueryList(" and emcode='" + emcode + "'" + where);
                if (ls != null)
                {
                    foreach (Sys_OrderType s in ls)
                    {
                        ArrayList al = new ArrayList();
                        al.Add(s.tcode);
                        al.Add(s.tname);
                        r.Add(al);
                    }
                }
            }
            else
            {
                r.Add(iv.badstr);
            }
            return(r);
        }