Example #1
0
        /// <summary>
        /// 花名下拉列表 text为花名,value 为花名
        /// </summary>
        public static List <SelectListItem> UserList()
        {
            EBMSEntities          db         = new EBMSEntities();
            IEnumerable           list       = db.T_User.AsEnumerable();
            SelectList            selectList = new SelectList(list, "NickName", "NickName");
            List <SelectListItem> ListUser   = new List <SelectListItem>();

            ListUser.AddRange(selectList);
            return(ListUser);
        }
Example #2
0
        /// <summary>
        /// 绑定仓库无默认值 code-name
        /// </summary>
        /// <returns></returns>
        public static List <SelectListItem> Warehousesz()
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_Warehouses.AsQueryable();
            var                   selectList = new SelectList(list, "code", "name");
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.AddRange(selectList);
            return(selecli);
        }
Example #3
0
        /// <summary>
        /// 绑定快递公司有默认值
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public static List <SelectListItem> ExpressName(object obj)
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_Express.AsQueryable();
            var                   selectList = new SelectList(list, "Code", "Name", obj);
            List <SelectListItem> selecli    = new List <SelectListItem>();

            //selecli.Add(new SelectListItem { Text = "==请选择==", Value = "" });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #4
0
        /// <summary>
        /// 根据店铺代码获得店铺名称
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static string GetShopName(string code)
        {
            EBMSEntities db       = new EBMSEntities();
            string       ShopName = "";
            T_ShopFromGY shop     = db.T_ShopFromGY.SingleOrDefault(a => a.code == code);

            if (shop != null)
            {
                ShopName = shop.name;
            }
            return(ShopName);
        }
Example #5
0
        /// <summary>
        /// 根据仓库代码获得仓库名称
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static string GetWarehouseName(string code)
        {
            EBMSEntities db            = new EBMSEntities();
            string       WarehouseName = "";
            T_Warehouses Warehouse     = db.T_Warehouses.SingleOrDefault(a => a.code == code);

            if (Warehouse != null)
            {
                WarehouseName = Warehouse.name;
            }
            return(WarehouseName);
        }
Example #6
0
        /// <summary>
        /// 根据部门ID获取部门名称
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static string GetDepartmentName(int ID)
        {
            EBMSEntities db             = new EBMSEntities();
            string       DepartmentName = "";
            T_Department Department     = db.T_Department.Find(ID);

            if (Department != null)
            {
                DepartmentName = Department.Name;
            }
            return(DepartmentName);
        }
Example #7
0
        /// <summary>
        /// 根据用户ID获得花名
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static string GetNickName(int id)
        {
            EBMSEntities db       = new EBMSEntities();
            string       Nickname = "";
            T_User       user     = db.T_User.Find(id);

            if (user != null)
            {
                Nickname = user.Nickname;
            }
            return(Nickname);
        }
Example #8
0
        /// <summary>
        /// 根据快递代码获得快递名称
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static string GetExpressName(string code)
        {
            EBMSEntities db          = new EBMSEntities();
            string       ExpressName = "";
            T_Express    express     = db.T_Express.SingleOrDefault(a => a.Code == code);

            if (express != null)
            {
                ExpressName = express.Name;
            }
            return(ExpressName);
        }
Example #9
0
        /// <summary>
        /// 绑定支付帐号无默认值
        /// </summary>
        /// <returns></returns>
        public static List <SelectListItem> BackFrom()
        {
            EBMSEntities        db        = new EBMSEntities();
            List <CashBackFrom> list      = db.Database.SqlQuery <CashBackFrom>("select Name from T_CashBackFrom group by Name").ToList();
            var selectList                = new SelectList(list, "Name", "Name");
            List <SelectListItem> selecli = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #10
0
        /// <summary>
        /// 拦截原因有默认值
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public static List <SelectListItem> InterceptReson(object obj)
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_InterceptReson.AsQueryable();
            var                   selectList = new SelectList(list, "Reson", "Reson", obj);
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #11
0
        /// <summary>
        /// 绑定WDT快递公司
        /// </summary>
        /// <returns></returns>
        public static List <SelectListItem> WDTExpressName()
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_WDTExpress.Where(a => a.Isdelete == "0").AsQueryable();
            var                   selectList = new SelectList(list, "Code", "Name");
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #12
0
        /// <summary>
        /// 线下绑定报销支出帐号
        /// </summary>
        /// <returns></returns>
        public static List <SelectListItem> LineExpenseAcount()
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_LineExpenseAcount.AsQueryable();
            var                   selectList = new SelectList(list, "ComPany", "Number");
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #13
0
        /// <summary>
        /// 资金调拨收款账号
        /// </summary>
        /// <returns></returns>
        public static List <SelectListItem> AcountNumber()
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_FundAcount.Where(s => s.Number != null).AsQueryable();
            var                   selectList = new SelectList(list, "ID", "Number");
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #14
0
        /// <summary>
        /// 支付方式无默认
        /// </summary>
        /// <returns></returns>
        public static List <SelectListItem> BlendingType()
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_ReturnToStorageBlendingType.AsQueryable();
            var                   selectList = new SelectList(list, "TypeCode", "TypeName");
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #15
0
        /// <summary>
        /// 绑定部门有默认值
        /// </summary>
        /// <returns></returns>
        public static List <SelectListItem> DepartMent(object obj)
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_Department.Where(s => s.parentId != -1).AsQueryable();
            var                   selectList = new SelectList(list, "ID", "Name", obj);
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #16
0
        /// <summary>
        /// 绑定店铺无默认值
        /// </summary>
        /// <returns></returns>
        public static List <SelectListItem> Shop()
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_ShopFromGY.AsQueryable();
            var                   selectList = new SelectList(list, "name", "name");
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #17
0
        /// <summary>
        /// 凭证部门
        /// </summary>
        /// <returns></returns>
        public static List <SelectListItem> depart()
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_PZ_DePartMent.AsQueryable();
            var                   selectList = new SelectList(list, "Name", "Name");
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #18
0
        /// <summary>
        /// 凭证科目
        /// </summary>
        /// <returns></returns>
        public static List <SelectListItem> subject()
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_AccountantProject.Where(s => s.ID != 1).AsQueryable();
            var                   selectList = new SelectList(list, "Name", "Name");
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #19
0
        /// <summary>
        /// 资金调拨付款账号
        /// </summary>
        /// <returns></returns>
        public static List <SelectListItem> PayNumber()
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_FundOutAllot.AsQueryable();
            var                   selectList = new SelectList(list, "ID", "Number");
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #20
0
        //退款
        public static List <SelectListItem> RetreatBackFrom()
        {
            EBMSEntities       db         = new EBMSEntities();
            List <RetreatFrom> list       = db.Database.SqlQuery <RetreatFrom>("select PaymentAccounts from  T_RetreatPayment  group by PaymentAccounts").ToList();
            var selectList                = new SelectList(list, "PaymentAccounts", "PaymentAccounts");
            List <SelectListItem> selecli = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #21
0
        /// <summary>
        /// 绑定仓库有默认值
        /// </summary>
        /// <returns></returns>
        public static List <SelectListItem> Warehouses(object obj)
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_Warehouses.AsQueryable();
            var                   selectList = new SelectList(list, "code", "name", obj);
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #22
0
        /// <summary>
        /// 绑定店铺无默认值
        /// </summary>
        /// <returns></returns>
        public List <SelectListItem> ExpenseAcount()
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_ExpenseAcount.Where(a => a.ComPany != null).AsQueryable();
            var                   selectList = new SelectList(list, "ComPany", "ComPany");
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
        // GET: /ManualExpress/
        public static List <SelectListItem> ManualExpressType(int type)
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_ManualExpressType.Where(a => a.type == type).AsQueryable();
            var                   selectList = new SelectList(list, "Name", "Name");
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #24
0
        /// <summary>
        /// 支付方式无默认值
        /// </summary>
        /// <returns></returns>
        public static List <SelectListItem> PaymentType()
        {
            EBMSEntities          db         = new EBMSEntities();
            var                   list       = db.T_PaymentType.AsQueryable();
            var                   selectList = new SelectList(list, "Code", "Code");
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #25
0
        public static List <SelectListItem> DirectoryList(string KeyType)
        {
            EBMSEntities          db         = new EBMSEntities();
            IEnumerable           list       = db.T_Directory.Where(a => a.KeyType == KeyType).AsEnumerable();
            SelectList            selectList = new SelectList(list, "KeyValue", "KeyName");
            List <SelectListItem> ListItem   = new List <SelectListItem>();

            ListItem.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            ListItem.AddRange(selectList);
            return(ListItem);
        }
Example #26
0
 public static void ModularRejectCount(string PendingAuditName, string ModularName, int Qty = 0)
 {
     try {
         EBMSEntities        db    = new EBMSEntities();
         T_ModularNotaudited model = db.T_ModularNotaudited.FirstOrDefault(a => a.ModularName == ModularName && a.PendingAuditName == PendingAuditName);
         model.ToupdateDate = DateTime.Now;
         model.RejectNumber = model.RejectNumber + Qty;
         db.Entry <T_ModularNotaudited>(model).State = System.Data.Entity.EntityState.Modified;
         db.SaveChanges();
     }
     catch (Exception e)
     {
     }
 }
        //获取部门数据作为下拉列表
        public List <SelectListItem> DepartMentList()
        {
            EBMSEntities          db         = new EBMSEntities();
            string                name       = Server.UrlDecode(Request.Cookies["NickName"].Value);
            string                deptID     = db.T_User.First(a => a.Nickname == name).DepartmentId;
            int                   dID        = Convert.ToInt32(deptID);
            string                deptName   = db.T_Department.Find(dID).Name;
            var                   list       = db.T_Department.Where(a => a.parentId > 0);
            var                   selectList = new SelectList(list, "Name", "Name", deptName);
            List <SelectListItem> selecli    = new List <SelectListItem>();

            selecli.Add(new SelectListItem {
                Text = "==请选择==", Value = ""
            });
            selecli.AddRange(selectList);
            return(selecli);
        }
Example #28
0
        /// <summary>
        /// 获得补发货名字
        /// </summary>
        /// <returns></returns>
        public static string GetReissueName(string code, string reson)
        {
            EBMSEntities db = new EBMSEntities();

            if (reson.Equals("呼吸机专用"))
            {
                return("阿奎");
            }
            else
            {
                T_ShopFromGY shop = db.T_ShopFromGY.SingleOrDefault(s => s.code.Equals(code));

                if (shop.type_name.Equals("天猫"))
                {
                    return("紫荆");
                }
                //else if (shop.type_name.Equals("淘宝"))
                //    return "欧阳";
                else if (shop.type_name.Equals("京东"))
                {
                    return("丹丹");
                }
                else if (shop.type_name.Equals("Ebay"))
                {
                    return("叮当");
                }
                else if (shop.type_name.Equals("贝贝网"))
                {
                    return("辉驮");
                }
                else
                {
                    return("成风");
                }
            }
        }