Example #1
0
        public static List<Supplier> Getlist(string str, int intFalg, out int total)
        {
            using (BaseContext _db = new BaseContext())
            {
                var query = new List<Supplier>();
                switch (intFalg)
                {
                    case 1:
                        query = _db.a_Supplier.AsNoTracking().
                         Where(l =>
                      l.Name.Contains(str) || string.IsNullOrEmpty(str)).ToList();
                        break;
                    case 2:
                        query = _db.a_Supplier.AsNoTracking().
                          Where(l => l.Director.Contains(str) || string.IsNullOrEmpty(str)).ToList();
                        break;

                    default:
                        query = _db.a_Supplier.AsNoTracking().ToList();
                        break;
                }

                total = query.Count();
                var list = query.ToList();
                return list;
            }
            //供应商名称1//联系人2
        }
Example #2
0
        public static List<Dic> Getlist(string str, int intFalg, out int total)
        {
            using (BaseContext _db = new BaseContext())
            {
                var query = new List<Dic>();
                switch (intFalg)
                {
                    case 1:
                        query = _db.a_Dic.AsNoTracking().
                         Where(l =>
                      l.KeyType == "商品单位").OrderBy(x => x.SortId).ToList();
                        break;
                    case 2:
                        query = _db.a_Dic.AsNoTracking().OrderBy(x => x.SortId).ToList();
                        break;
                    case 3:
                        query = _db.a_Dic.AsNoTracking().Where(l =>
                      l.KeyType == "商品品牌").OrderBy(x => x.SortId).ToList();
                        break;
                    case 4:
                        query = _db.a_Dic.AsNoTracking().Where(l =>
                      l.KeyType == "商品类别").OrderBy(x => x.SortId).ToList();
                        break;

                    default:
                        query = _db.a_Dic.AsNoTracking().Where(l=>l.KeyType == "商品单位").OrderBy(x=>x.SortId).ToList();
                        break;
                }

                total = query.Count();
                var list = query.ToList();
                return list;
            }
            //供应商名称1//联系人2
        }
Example #3
0
        public static bool checkloginName(string name,int id=0)
        {
            using (BaseContext _db = new BaseContext())
            {
                if (id == 0)
                {
                    var query = _db.a_Supplier.AsNoTracking().
                       Where(l =>
                    l.Name.Contains(name)).FirstOrDefault();
                    if (query != null)
                    {
                        return true;
                    }
                }
                else
                {
                    var query = _db.a_Supplier.AsNoTracking().
                       Where(l =>
                    l.Name.Contains(name) && l.SupplierId != id).FirstOrDefault();
                    if (query != null)
                    {
                        return true;
                    }
                }

                return false;
            }
        }
Example #4
0
 /// <summary>
 /// 新增
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public static int add(Employee model)
 {
     var sql = string.Format(@"INSERT INTO [a_Emp]([EmpName],[Sex],[BirthDay],[DepId] ,[Phone],[Email],[Address],[Remark],[Pwd],[Role],[CreateTime],[UpdateTime],[RealName]) VALUES('{0}','{1}','{2}',{3},'{4}','{5}','{6}','{7}','{8}',{9},'{10}','{11}','{12}')", model.EmpName, model.Sex, model.BirthDay, model.DepId, model.Phone, model.Email, model.Address, model.Remark, model.Pwd, model.Role, model.CreateTime, model.UpdateTime, model.RealName);
     using (BaseContext db = new BaseContext())
     {
         var result = db.Database.ExecuteSqlCommand(sql);
         return result;
     }
 }
Example #5
0
        public static List<Dept> getlist()
        {
            using (BaseContext _db = new BaseContext())
            {
                var query = from s in _db.a_Dept.AsNoTracking() select s;

                var list = query.ToList();
                return list;
            }
        }
Example #6
0
 public static List<Sales> Getlist()
 {
     using (BaseContext _db = new BaseContext())
     {
         //获取销售记录
         var query = _db.a_Sales.AsNoTracking().
           Where(l =>l.Num > 0).ToList();
         return query;
     }
 }
Example #7
0
 public static List<Ware> Getlist()
 {
     using (BaseContext _db = new BaseContext())
     {
         var query = _db.a_Ware.AsNoTracking().ToList();
         var list = query.ToList();
         return list;
     }
     //供应商名称1//联系人2
 }
Example #8
0
 /// <summary>
 /// 新增
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public static bool add(Sales model)
 {
     var sql = string.Format("insert into dbo.a_Sales values({0},'{1}',{2},{3},{4})", model.GoodsId, model.AddTime.ToString(), model.EmpId,model.Price, model.Num);
     using (BaseContext db = new BaseContext())
     {
         var querylist = db.Database.ExecuteSqlCommand(sql);
         if (querylist > 0)
         {
             return true;
         }
         else
         {
             return false;
         }
     }
 }
Example #9
0
        public static bool checkloginName(string name)
        {
            using (BaseContext _db = new BaseContext())
            {

                Employee query = _db.a_Emp.AsNoTracking().
                               Where(l =>
                            l.EmpName == name).FirstOrDefault();
                if (query == null)
                {
                    return false;
                }
                else
                {
                    return true;
                }
            }
        }
Example #10
0
        public static bool checkloginName(string name,int goodid)
        {
            using (BaseContext _db = new BaseContext())
            {

                Goods query = _db.a_Goods.AsNoTracking().
                               Where(l =>
                            l.GoodsName == name && (goodid==0 ||l.GoodsId != goodid)).FirstOrDefault();
                if (query == null)
                {
                    return false;
                }
                else
                {
                    return true;
                }
            }
        }
Example #11
0
        /// <summary>
        /// 统计某商品销售数量
        /// </summary>
        /// <param name="goodsId"></param>
        /// <returns></returns>
        public static int getSalesNums(int goodsId)
        {
            using (BaseContext _db = new BaseContext())
            {
                try
                {
                    //获取销售记录
                    var query = _db.a_Sales.AsNoTracking().
                      Where(l =>
                   l.GoodsId == goodsId).Sum(x => x.Num);
                    return query;
                }
                catch (Exception)
                {

                    return 0;
                }

            }
        }
Example #12
0
        public static List<Employee> Getlist(string str, int intFalg,out int total)
        {
            using (BaseContext _db = new BaseContext())
            {
                var query= new List<Employee>();
                switch (intFalg)
                {
                    case 1:
                          query = _db.a_Emp.AsNoTracking().
                           Where(l =>
                        l.RealName.Contains(str)||string.IsNullOrEmpty(str)).ToList();
                        break;
                    case 2:
                         query = _db.a_Emp.AsNoTracking().
                           Where(l => l.Sex.Contains(str) || string.IsNullOrEmpty(str)).ToList();
                        break;
                    case 3:
                          query = _db.a_Emp.AsNoTracking().
                           Where(l =>(l.DepId == 3)).ToList();//销售部
                        break;
                    case 4:
                        query = _db.a_Emp.AsNoTracking().Where(l =>(l.DepId == 2)).ToList();//采购部
                        break;
                    case 5:
                        query = _db.a_Emp.AsNoTracking().Where(l => (l.DepId == 1)).ToList();//管理部
                        break;

                    default:
                          query = _db.a_Emp.Include("Dept").AsNoTracking().ToList();
                        break;
                }

                total = query.Count();
                var list = query.ToList();
                return list;
            }
            //员工姓名1//员工性别2//员工所属部门3//员工职位4
        }
Example #13
0
        public static List<Goods> Getlist(string str, int intFalg, out int total)
        {
            using (BaseContext _db = new BaseContext())
            {
                var query = new List<Goods>();
                try
                {
                    switch (intFalg)
                    {
                        case 1:
                            query = _db.a_Goods.AsNoTracking().
                             Where(l =>
                          l.GoodsName.Contains(str) || string.IsNullOrEmpty(str)).ToList();
                            break;
                        case 2:
                            query = _db.a_Goods.AsNoTracking().
                              Where(l => l.GoodsId.ToString().Contains(str) || string.IsNullOrEmpty(str)).ToList();
                            break;

                        default:
                            query = _db.a_Goods.AsNoTracking().ToList();
                            break;
                    }
                }
                catch (Exception ex)
                {

                    throw ex ;
                }

                total = query.Count();
                var list = query.ToList();
                return list;
            }
            //供应商名称1//联系人2
        }
Example #14
0
 private static List<StcokQueryty> GetDatabySql(string sql)
 {
     using (BaseContext db = new BaseContext())
     {
         var querylist = db.Database.SqlQuery<StcokQueryty>(sql).ToList();
         return querylist;
     }
 }
Example #15
0
 public static List<Stockty> queryForList(string sql)
 {
     List<Stockty> list = null;
     using (BaseContext _db = new BaseContext())
     {
         var result = _db.Database.SqlQuery<Stockty>(sql).ToList();
         if (result != null)
         {
             list = result;
         }
         else
         {
             list = new List<Stockty>();
         }
     }
     return list;
 }
Example #16
0
 public static List<WarnLog> getlist()
 {
     using (BaseContext _db = new BaseContext())
     {
         //获取销售记录
         var query = _db.a_WareLog.AsNoTracking().ToList();
         return query;
     }
 }
Example #17
0
        private static int getStockgoosNum(int goodsId)
        {
            using (BaseContext _db = new BaseContext())
            {
                var query = _db.a_Stock.AsNoTracking().
                          Where(l =>
                       l.GoodsId == goodsId).Sum(x => x.Num);

                return query;
            }
            //供应商名称1//联系人2
        }
Example #18
0
        /// <summary>
        /// 登录
        /// </summary>
        /// <returns></returns>
        public static ReturnRet<Employee> Login(string username, string password)
        {
            ReturnRet<Employee> ret = new ReturnRet<Employee>();
            ret.success = false;
            using (BaseContext _db = new BaseContext())
            {
                var query = from s in _db.a_Emp
                            where s.EmpName == username
                            select s;
                Employee user = query.FirstOrDefault();
                if (user == null)
                {
                    ret.message = "找不到账号";
                    return ret;
                }

                if (user.Pwd != EncryptHelper.MD5Encrypt(password))
                {
                    ret.message = "密码错误";
                    return ret;
                }
                ret.success = true;
                ret.message = "登录成功";
                ret.data = user;
            }
            return ret;
        }