/// <summary> /// 样衣借出 /// </summary> /// <param name="styleId"></param> /// <param name="_user"></param> /// <returns></returns> public static bool DoLend(string styleId, User _user) { using (SunginDataContext sc = new SunginDataContext()) { var style = sc.SampleBaseInfos.SingleOrDefault(p => p.StyleId == styleId); LendRecord lr = sc.LendRecords.SingleOrDefault(p => p.StyleId == styleId && p.DdId == _user.DdId && (p.State != LendRecordStats.已还回)); if (style != null && lr == null) { lr = new LendRecord { StyleId = style.StyleId, DdId = _user.DdId, UserName = _user.UserName, UserDept = _user.DepartName, }; lr.SetCreateUser(_user.UserName); sc.LendRecords.Add(lr); } else { return(false); } sc.SaveChanges(); } return(true); }
public bool LoadSampleById(string styleId) { try { using (SunginDataContext sc = new SunginDataContext()) { BaseInfo = sc.SampleBaseInfos.SingleOrDefault(p => p.StyleId == styleId); ProofingInfo = sc.Proofings.SingleOrDefault(p => p.StyleId == styleId); if (ProofingInfo == null) { ProofingInfo = new Proofing(); } ProductInfo = sc.ProductionRecords.SingleOrDefault(p => p.StyleId == styleId); if (ProductInfo == null) { ProductInfo = new ProductionRecord(); } StockList = sc.GarmentStocks.Where(p => p.StyleId == styleId).ToList(); Files = sc.StyleFiles.Where(p => p.StyleId == BaseInfo.StyleId).ToList(); IsNewSample = false; return(true); } } catch { return(false); } }
public void SyncUsers(List <User> users) { using (SunginDataContext sc = new SunginDataContext()) { var ulist = sc.Users.ToList(); ulist.ForEach(p => p.IsDelete = true); users.ForEach(p => { var u = ulist.SingleOrDefault(t => t.DdId == p.DdId); if (u == null) { p.Pinyin = PinyinHelper.PinyinString(p.UserName); sc.Users.Add(p); } else { u.Pinyin = PinyinHelper.PinyinString(u.UserName); u.UserName = p.UserName; u.IsLeader = p.IsLeader; u.DeptId = p.DeptId; u.DepartName = p.DepartName; u.Avatar = p.Avatar; u.IsDelete = false; }; }); sc.SaveChanges(); } }
public static dynamic GetDdLenOutObj(ILendRecord p) { object obj = null; using (SunginDataContext sc = new SunginDataContext()) { ISampleBaseInfo sb = sc.SampleBaseInfos.SingleOrDefault(item => item.StyleId == p.StyleId); if (sb != null) { var pic = sc.StyleFiles.FirstOrDefault(f => f.StyleId == p.StyleId && f.FileType == FileType.Pic); obj = new { p.Id, sb.StyleId, sb.StyleNo, Pic = pic.FileName, sb.Gauge, sb.Weight, sb.Material, sb.Counts, p.LendOutNo, sb.State, sb.CanLendOut, LendState = p.State, AsLend = sb.State == SampleState.在库, StatsText = sb.State.ToString(), }; } return(obj); } }
public static dynamic GetReturnObj(ISampleBaseInfo baseinfo) { using (SunginDataContext sc = new SunginDataContext()) { IProofing pr = sc.Proofings.SingleOrDefault(p => p.StyleId == baseinfo.StyleId); if (pr == null) { pr = new Proofing(); } IProductionRecord pd = sc.ProductionRecords.SingleOrDefault(p => p.StyleId == baseinfo.StyleId); if (pd == null) { pd = new ProductionRecord(); } var Files = sc.StyleFiles.Where(p => !p.IsDelete && p.StyleId == baseinfo.StyleId).Select(p => new { p.DisplayName, p.FileName, p.FileType }).ToList(); var FirstPic = Files.FirstOrDefault(p => p.FileType == FileType.Pic); var StockData = sc.GarmentStocks.Where(p => !p.IsDelete && p.StyleId == baseinfo.StyleId).Select(p => new { size = p.Size, color = p.Color, num = p.Num }).ToList(); string Pic = FirstPic != null ? FirstPic.FileName : ""; return(new { baseinfo.Id, baseinfo.StyleId, baseinfo.StyleNo, baseinfo.Color, baseinfo.Weight, baseinfo.Gauge, baseinfo.Size, baseinfo.Kinds, baseinfo.CanLendOut, baseinfo.HaveStock, User = baseinfo.CreateUser, baseinfo.State, baseinfo.CostPrice, baseinfo.FactoryPrice, baseinfo.SalePrice, baseinfo.DiscountPrice, baseinfo.Counts, StateText = baseinfo.State.ToString(), StyleTag = JsonHelper.ToObj(baseinfo.StyleTag), Material = JsonHelper.ToObj(baseinfo.Material), CreateDate = baseinfo.CreateDate != null?baseinfo.CreateDate.Value.Date.ToShortDateString() : "", pr.ProofingCompany, pr.ProgamPeople, pr.TechnologyPeople, baseinfo.DeptName, pr.WeaveTime, pr.LinkTime, ProofingDate = pr.ProofingDate != null?pr.ProofingDate.Value.Date.ToShortDateString() : "", pd.ClientName, pd.ProductFactory, pd.ProductNum, pd.Price, ProductDate = pd.ProductDate != null?pd.ProductDate.Value.ToShortDateString() : "", StockData, Pic, Files }); } }
public object GetLendUserList() { using (SunginDataContext sc = new SunginDataContext()) { } return(null); }
public static object GetInputUserList() { using (SunginDataContext sc = new SunginDataContext()) { var re = sc.SampleBaseInfos.Where(p => !p.IsDelete && p.State == SampleState.待入库).Select(p => new { p.DdId, p.CreateUser }).Distinct(); return(re); } }
public static List <ProofTask> GetNextTask(int Id) { SunginDataContext sungindc = new SunginDataContext(); var no = sungindc.ProofTasks.SingleOrDefault(p => p.Id == Id).TaskNo; var tlist = sungindc.ProofTasks.Include(t => t.Process).Where(p => p.UpTaskNo == no).ToList(); return(tlist); }
/// <summary> /// 返回有借用申请的用户清单 /// </summary> /// <returns></returns> public static object GetLendUserList() { using (SunginDataContext sc = new SunginDataContext()) { var re = sc.LendRecords.Where(p => p.State == LendRecordStats.借出审批).Select(p => new { p.DdId, Name = p.UserName }).Distinct().ToList(); return(re); } }
public static object GetTagList() { using (SunginDataContext sc = new SunginDataContext()) { var list = sc.Codes.Where(p => p.Type == CodeType.Tag).OrderByDescending(t => t.UseCount).Select(p => new { name = p.CodeName, color = p.Value1 }).ToList(); return(list); } }
public List <IPermission> GetList() { List <IPermission> list = new List <IPermission>(); var re = new SunginDataContext().Permissions.OrderBy(p => p.Key).ToList(); list.AddRange(re); return(list); }
public static object GetKindsList() { using (SunginDataContext sc = new SunginDataContext()) { var list = sc.Codes.Where(p => p.Type == CodeType.Kinds).OrderByDescending(t => t.UseCount).Select(p => p.CodeName).Distinct().ToList(); return(list); } }
public static object GetMaterialList() { using (SunginDataContext sc = new SunginDataContext()) { //var list = sc.Codes.Where(p => p.Type == CodeType.Material).OrderByDescending(t => t.UseCount).Select(p => p.CodeName).ToList(); var list = sc.Materials.OrderByDescending(p => p.UseCount).Select(p => new { p.CnName, p.EnName, p.UseCount }).ToList(); return(list); } }
public List <string> GetPermissionsKeys(string DdId) { var urList = DataQuery.GetRecords <UserRole>(p => p.DdId == DdId).Select(t => t.RoleId).ToArray(); //var urplist = new SampleContext().UserRolePermissions.Where(p=>p.IsDelete==false).Where(p => urList.Contains(p.RoleId)).Select(r=>r.Key).Distinct().ToList(); SunginDataContext sc = new SunginDataContext(); var re = sc.UserRolePermissions.Join(sc.Permissions, e => e.Key, o => o.Key, (e, o) => new { e.RoleId, e.IsDelete, e.Key, o.Name, o.CnName }).Where(p => !p.IsDelete).Where(p => urList.Contains(p.RoleId)).Select(p => p.Name).Distinct().ToList(); return(re); }
public static void AddUser(User u) { using (SunginDataContext sc = new SunginDataContext()) { u.SetCreateUser("system"); sc.Users.Add(u); sc.SaveChanges(); } }
/// <summary> /// 更新登录信息 /// </summary> public User UpDateLoginInfo(User _user) { using (SunginDataContext sc = new SunginDataContext()) { var user = sc.Users.SingleOrDefault(p => p.DdId == _user.DdId); SetLoginInfo(ref user); sc.SaveChanges(); return(user); } }
public void AddUser(User user) { using (SunginDataContext sc = new SunginDataContext()) { SetLoginInfo(ref user); user.SetCreateUser("system"); user.Pinyin = PinyinHelper.PinyinString(user.UserName); sc.Users.Add(user); sc.SaveChanges(); } }
public static void ClearRoleBeforDate() { using (SunginDataContext sc = new SunginDataContext()) { var list = sc.Users.Where(p => p.Role != UserRoleU.一般用户).ToList(); list.ForEach(p => { p.Role = UserRoleU.一般用户; sc.Entry(p).State = System.Data.Entity.EntityState.Modified; }); sc.SaveChanges(); } }
public static void RebuildFileStyleId() { SunginDataContext sdc = new SunginDataContext(); sdc.StyleFiles.ToList().ForEach(f => { string name = f.FileName; string id = name.Substring(0, 10); f.StyleId = id; }); sdc.SaveChanges(); }
public bool DeleteProofFile(int id) { using (SunginDataContext sdc = new SunginDataContext()) { var re = sdc.ProofFiles.Where(p => p.Id == id && p.CreateUser == user.UserName).SingleOrDefault(); if (re != null) { re.Delete(user.UserName); sdc.SaveChanges(); return(true); } } return(false); }
/// <summary> /// 返回所有借用清单 /// </summary> /// <param name="PageId"></param> /// <param name="pageSize"></param> /// <returns></returns> public static object GetAllLendOutList(int PageId = 1, int PageSize = 20) { using (SunginDataContext sc = new SunginDataContext()) { int count = sc.LendRecords.Count(p => !p.IsDelete && p.State == LendRecordStats.已借出); List <LendRecord> lr = sc.LendRecords.Where(p => !p.IsDelete && p.State == LendRecordStats.已借出).OrderByDescending(p => p.DdId).Skip(PageSize * (PageId - 1)).Take(PageSize).ToList(); List <object> obj = new List <object>();; lr.ForEach(p => { var sb = sc.SampleBaseInfos.SingleOrDefault(t => t.StyleId == p.StyleId); obj.Add(new { p.Id, p.StyleId, p.UserName, p.UserDept, sb.StyleNo, p.CreateDate, baseinfo = SampleHelper.GetReturnObj(sb) }); }); return(new { items = obj, total = count, current = PageId, pageSize = PageSize }); } }
public static string GetKey(string keyName) { string k = ""; using (SunginDataContext sc = new SunginDataContext()) { var key = sc.KMs.Where(p => p.KeyName == keyName).SingleOrDefault(); if (key != null) { key.KeyValue++; k = key.BeginKey + key.KeyValue.ToString(); sc.SaveChanges(); } } return(k); }
/// <summary> /// 删除指定待借样衣 /// </summary> /// <param name="styleId"></param> /// <param name="user"></param> /// <returns></returns> public static bool DoDelete(int LendId, User _user) { using (SunginDataContext sc = new SunginDataContext()) { LendRecord lr = sc.LendRecords.SingleOrDefault(p => p.Id == LendId); if (lr != null) { sc.Entry(lr).State = System.Data.Entity.EntityState.Deleted; } else { return(false); } sc.SaveChanges(); } return(true); }
/// <summary> /// 根据登录Str返回用户 /// </summary> /// <param name="loginStr"></param> /// <returns></returns> public User GetUserByLoginStr(string loginStr) { using (SunginDataContext dc = new SunginDataContext()) { var _user = dc.Users.Where(p => p.LoginStr == loginStr).FirstOrDefault(); if (_user != null) { if (_user.LoginOverTime < DateTime.Now) { _user.LoginOverTime = null; dc.SaveChanges(); _user = null; } } return(_user); }; }
/// <summary> /// 取消借用审批中的样衣借用 /// </summary> /// <param name="StyleId"></param> /// <param name="user">借用者</param> /// <returns></returns> public static bool CancelLend(string StyleId, User _user) { using (SunginDataContext sc = new SunginDataContext()) { var lr = sc.LendRecords.SingleOrDefault(p => p.StyleId == StyleId && p.DdId == _user.DdId && p.State == LendRecordStats.借出审批); if (lr != null) { sc.Entry(lr).State = System.Data.Entity.EntityState.Deleted; sc.SampleBaseInfos.SingleOrDefault(p => p.StyleId == StyleId).State = SampleState.在库; sc.SaveChanges(); return(true); } else { return(false); } } }
public static void AddCode(Code _code) { using (SunginDataContext sc = new SunginDataContext()) { { var code = sc.Codes.Where(p => p.CodeName == _code.CodeName).SingleOrDefault(); if (code == null) { sc.Codes.Add(_code); } else { code.UseCount++; } } sc.SaveChanges(); } }
public static bool SetUserRole(string Ddid, UserRoleU ur) { using (SunginDataContext sc = new SunginDataContext()) { var u = GetUser(Ddid); if (u != null) { u.Role = ur; u.SetEditUser("system"); sc.Entry(u).State = System.Data.Entity.EntityState.Modified; sc.SaveChanges(); return(true); } else { return(false); } } }
public static void AddCode(List <Code> codes) { using (SunginDataContext sc = new SunginDataContext()) { foreach (var m in codes) { var code = sc.Codes.Where(p => p.CodeName == m.CodeName).SingleOrDefault(); if (code == null) { sc.Codes.Add(m); } else { code.UseCount++; } } sc.SaveChanges(); } }
/// <summary> /// 从钉钉同步角色和用户 /// </summary> /// <param name="DdOper"></param> public static void SyncUserRole(IDdOper DdOper) { SunginDataContext sc = new SunginDataContext(); UserProvider uProvider = new UserProvider(DdOper); RoleProvider rProvider = new RoleProvider(DdOper); RoleOper rOper = new RoleOper(); UserOper uOper = new UserOper(); var userList = DataQuery.GetAllRecords <User>(); var roleList = rProvider.GetRoles("管理系统"); rOper.UpdateRoles(roleList); //根据返回的roleList更新数据库 List <IUserRole> urList = new List <IUserRole>(); roleList.ForEach(role => { var ruleUserList = rProvider.GetRoleUserList(role.RoleId); if (ruleUserList != null) { ruleUserList.ForEach(u => { var user = uProvider.GetUserInfo(u.Userid); if (userList.Count(c => c.DdId == u.Userid) == 0) { //没有该用户,添加该用户 uOper.AddUser(user); } urList.Add(new UserRole { RoleId = role.RoleId, DdId = u.Userid, RoleName = role.RoleName, UserName = user.UserName, }); }); } }); new UrOper().UpdateRoles(urList); //同步UserRole表 }
/// <summary> /// 返回当前用户的待借出清单 /// </summary> /// <param name="_user"></param> /// <returns></returns> public static object GetLendList(User _user) { using (SunginDataContext sc = new SunginDataContext()) { //SampleLendout slo = sc.SampleLendouts.SingleOrDefault(p => p.DdId == _user.DdId && p.State == LendStats.草拟); var lendlist = sc.LendRecords.Where(p => p.DdId == _user.DdId && p.State == LendRecordStats.草拟).ToList(); List <object> lo = new List <object>(); lendlist.ForEach(p => { var obj = SampleHelper.GetDdLenOutObj(p); if (obj != null) { lo.Add(obj); } }); return(lo); } }