/// <summary> /// 订订审批通过,添加订单到打样系统,并修改状态 /// </summary> /// <param name="DdApprovalCode"></param> public void AgreeApprove(string DdApprovalCode) { var order = GetProofByDdApprovalCode(DdApprovalCode); YdOper yo = new YdOper(); string dio = yo.AddYd(order); if (dio != "") { order.Dydbh = dio; order.ProofStatus = ProofStatus.排单; sdc.SaveChanges(); } }
public ProofTask UpDateTask(Task t) { ProofTask re = sdc.ProofTasks.Include(tp => tp.Order).SingleOrDefault(p => p.Id == t.Id); if (re != null) { re.UserName = t.WorkerName; re.Worker = sdc.Workers.FirstOrDefault(p => p.UserName == t.WorkerName); re.Process = sdc.Processlist.FirstOrDefault(p => p.Id == t.ProcessId); re.NeedFinshDate = t.NeedFinshDate; re.BeginDate = t.BeginDate; re.UpTaskNo = t.UpTaskNo; } sdc.SaveChanges(); return(re); }
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(); } }
/// <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 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 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); }
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> /// 根据登录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 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); }
void SyncWorkerForRole(string roleName) { var role = sdc.Roles.FirstOrDefault(p => p.RoleName == roleName); var ur = sdc.UserRoles.Where(p => p.RoleId == role.RoleId).ToList(); var workerRole = sdc.FactryRolesWorker.Include(t => t.Job).Include(t => t.Worker).Where(p => p.Role.RoleId == role.RoleId).ToList(); var workers = sdc.Workers.Include(t => t.Job).Include(t => t.User).ToList(); workerRole.ForEach(t => t.IsDelete = true); ur.ForEach(p => { var job = sdc.jobs.SingleOrDefault(j => j.JobName == roleName); var user = sdc.Users.SingleOrDefault(u => u.DdId == p.DdId); var wr = workerRole.SingleOrDefault(w => w.WorkName == p.UserName); var worker = workers.SingleOrDefault(w => w.UserName == p.UserName); if (worker == null) { worker = new Worker() { UserName = p.UserName, User = sdc.Users.SingleOrDefault(u => u.DdId == p.DdId), DeptName = "样品部", Point = 3 }; sdc.Workers.Add(worker); } if (wr == null) { FactryRoleWorker wk = new FactryRoleWorker { JobName = job.JobName, WorkName = worker.UserName, Worker = worker, Role = role, Job = job, }; sdc.FactryRolesWorker.Add(wk); } else { wr.IsDelete = false; } }); sdc.SaveChanges(); }
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(); } }
/// <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(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(); } }
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); } } }
/// <summary> /// 执行借出申请 /// </summary> /// <param name="_lendOutNo"></param> /// <returns></returns> public static bool ApplyLendOut(int LendId, User _user) { using (SunginDataContext sc = new SunginDataContext()) { var lr = sc.LendRecords.SingleOrDefault(p => p.Id == LendId); SampleBaseInfo sb = sc.SampleBaseInfos.SingleOrDefault(s => s.StyleId == lr.StyleId); if (sb != null && sb.State == SampleState.在库) { lr.State = LendRecordStats.借出审批; sb.State = SampleState.待借出; lr.LendOutNo = ""; sc.Entry(lr).State = System.Data.Entity.EntityState.Modified; sc.Entry(sb).State = System.Data.Entity.EntityState.Modified; //ishavelend = true; } //else sc.Entry(lr).State = System.Data.Entity.EntityState.Deleted; //不在库中从借出审批中删除 sc.SaveChanges(); } return(true); }
/// <summary> /// 执行退回申请 /// </summary> /// <param name="styleId"></param> /// <param name="user"></param> public static bool DoBackLend(int LenId, string user) { using (SunginDataContext sc = new SunginDataContext()) { var sl = sc.LendRecords.SingleOrDefault(p => !p.IsDelete && p.Id == LenId); if (sl != null) { sl.State = LendRecordStats.草拟; sl.OperRemark = sl.OperRemark + " 退回借出申请:" + user; var sb = sc.SampleBaseInfos.SingleOrDefault(p => !p.IsDelete && p.StyleId == sl.StyleId); sb.State = SampleState.在库; sc.SaveChanges(); return(true); } else { return(false); } } }
/// <summary> /// 执行通过借出申请 /// </summary> /// <param name="styleId"></param> public static bool DoInstroage(int LendId, string user) { using (SunginDataContext sc = new SunginDataContext()) { var sl = sc.LendRecords.SingleOrDefault(p => !p.IsDelete && p.Id == LendId); if (sl != null) { sl.State = LendRecordStats.已借出; sl.LendOutDate = DateTime.Now; sl.OperRemark = sl.OperRemark + " 借出审批人:" + user; var sb = sc.SampleBaseInfos.SingleOrDefault(p => !p.IsDelete && p.StyleId == sl.StyleId); sb.State = SampleState.借出; sc.SaveChanges(); return(true); } else { return(false); } } }
/// <summary> /// 更新usrRole表 /// </summary> /// <param name="urList"></param> public void UpdateRoles(List <IUserRole> urList) { using (SunginDataContext sc = new SunginDataContext()) { var re = sc.UserRoles.Where(p => p.RoleId > 0).ToList(); re.ForEach(p => p.IsDelete = true); urList.ForEach(u => { var ur = re.SingleOrDefault(p => p.DdId == u.DdId && p.RoleId == u.RoleId); if (ur == null) { sc.UserRoles.Add((UserRole)u); } else { ur.IsDelete = false; ur.UserName = u.UserName; ur.RoleName = u.RoleName; } }); sc.SaveChanges(); } }
public void AddDefalutUR(User user) { using (SunginDataContext sc = new SunginDataContext()) { var userobj = sc.UserRoles.SingleOrDefault(p => p.RoleId == 0 && p.DdId == user.DdId); if (userobj == null) { UserRole ur = new UserRole { DdId = user.DdId, UserName = user.UserName, RoleId = 0, RoleName = "默认用户", }; sc.UserRoles.Add(ur); } else { userobj.IsDelete = false; } sc.SaveChanges(); } }
public void UrpUpData(long roleId, List <string> KeyList) { using (SunginDataContext sc = new SunginDataContext()) { var urpList = sc.UserRolePermissions.Where(p => p.RoleId == roleId).ToList(); urpList.ForEach(p => p.IsDelete = true); KeyList.ForEach(p => { var urp = urpList.SingleOrDefault(u => u.RoleId == roleId && u.Key == p); if (urp != null) { urp.IsDelete = false; } else { sc.UserRolePermissions.Add(new UserRolePermission { RoleId = roleId, Key = p }); } }); sc.SaveChanges(); } }
/// <summary> /// 同步数据库角色 /// </summary> /// <param name="roleList"></param> public void UpdateRoles(List <IRole> roleList) { using (SunginDataContext sc = new SunginDataContext()) { var re = sc.Roles.Where(p => p.RoleId > 0).ToList(); re.ForEach(p => p.IsDelete = true); roleList.ForEach(p => { var reobj = re.Where(t => t.RoleId == p.RoleId).SingleOrDefault(); if (reobj == null) { sc.Roles.Add(new Role { RoleId = p.RoleId, RoleName = p.RoleName }); } else { reobj.IsDelete = false; reobj.RoleName = p.RoleName; } }); sc.SaveChanges(); }; }
public void SyncDepts(List <Dept> depts) { using (SunginDataContext sc = new SunginDataContext()) { var deptList = sc.Depts.ToList(); deptList.ForEach(p => p.IsDelete = true); depts.ForEach(p => { var d = deptList.SingleOrDefault(t => t.DeptID == p.DeptID); if (d == null) { sc.Depts.Add(p); } else { d.DeptName = p.DeptName; d.ParentDeptId = p.ParentDeptId; d.DeptAdminDdId = p.DeptAdminDdId; d.IsDelete = false; } }); sc.SaveChanges(); }; }
public void AgreeFinsh(string pid) { ApproveOper ao = new ApproveOper(_oper); var re = ao.GetApprove(pid); var po = sdc.ProofOrders.SingleOrDefault(p => p.DdFinshApprovalCode == pid); if (po != null) { re.FormComponentValues.ForEach(p => { if (p.Name == "评分") { int Rating = 3; if (p.Value != null) { if (p.Value.IndexOf('1') > 0) { Rating = 1; } else if (p.Value.IndexOf('2') > 0) { Rating = 2; } else if (p.Value.IndexOf('3') > 0) { Rating = 3; } else if (p.Value.IndexOf('4') > 0) { Rating = 4; } else if (p.Value.IndexOf('5') > 0) { Rating = 5; } } ; po.Rating = Rating; po.ProofTasks.ForEach(pt => pt.Rating = Rating); } if (p.Name == "样衣图片") { var picList = JsonHelper.JsonToList <string>(p.Value); picList.ForEach(f => { var fdata = HttpHelper.DownloadData(f); string name = f.Substring(f.LastIndexOf('/') + 1); string fullname = po.ProofStyle.ProofStyleId + "_" + name; File.WriteAllBytes(SysPath + PicPath + fullname, fdata); ProofFile pf = new ProofFile { FullName = fullname, DisplayName = name, Url = PicPath + fullname, FileType = SG.Interface.Sys.FileType.Pic, ProofStyleId = po.ProofStyle.ProofStyleId, }; pf.SetCreateUser("钉钉审批"); po.ProofStyle.ProofFiles.Add(pf); }); } }); po.ProofStatus = ProofStatus.完成; sdc.SaveChanges(); } }
public bool SaveSample(SampleFullInfoModel sample) { using (SunginDataContext sc = new SunginDataContext()) { //基本信息 //BaseInfo.StyleId = (string)sample.styleId; BaseInfo.StyleNo = sample.StyleNo; BaseInfo.DeptName = sample.DeptName; BaseInfo.Color = sample.Color; BaseInfo.Size = sample.Size; BaseInfo.Gauge = sample.Gauge; BaseInfo.Weight = sample.Weight; BaseInfo.CanLendOut = sample.CanLendOut; BaseInfo.Kinds = sample.Kinds; BaseInfo.Counts = sample.Counts; BaseInfo.Material = JsonHelper.ToJson(sample.MaterialItems); BaseInfo.StyleTag = JsonHelper.ToJson(sample.StyleTagItems); if (IsNewSample) { BaseInfo.DdId = currentUser.DdId; } BaseInfo.HaveStock = sample.HaveStock; BaseInfo.CostPrice = sample.CostPrice; BaseInfo.FactoryPrice = sample.FactoryPrice; BaseInfo.SalePrice = sample.SalePrice; BaseInfo.DiscountPrice = sample.DiscountPrice; //大货信息 ProductInfo.StyleId = BaseInfo.StyleId; ProductInfo.ClientName = sample.ClientName; ProductInfo.ProductFactory = sample.ProductFactory; ProductInfo.ProductNum = sample.ProductNum; ProductInfo.Price = sample.Price; if (sample.ProductDate != "") { ProductInfo.ProductDate = DateTime.Parse(sample.ProductDate); } //打样信息 ProofingInfo.StyleId = BaseInfo.StyleId; ProofingInfo.ProofingCompany = (string)sample.ProofingCompany; ProofingInfo.TechnologyPeople = (string)sample.TechnologyPeople; ProofingInfo.ProgamPeople = (string)sample.ProgamPeople; ProofingInfo.WeaveTime = sample.WeaveTime; ProofingInfo.LinkTime = sample.LinkTime; if (sample.ProofingDate != "") { ProofingInfo.ProofingDate = DateTime.Parse(sample.ProofingDate); } //开始保存 //库存信息 if (BaseInfo.HaveStock && sample.StockDataItems.Count > 0) { //如已有数据,则更新,如无则删除 StockList.ForEach(p => { var re = sample.StockDataItems.SingleOrDefault(w => w.Size == p.Size && w.Color == p.Color); if (re != null) { p.Num = re.Num; } else { p.IsDelete = true; } sc.Entry(p).State = System.Data.Entity.EntityState.Modified; sample.StockDataItems.Remove(re); }); //新增数据 sample.StockDataItems.ForEach(p => { sc.GarmentStocks.Add(new GarmentStock { Color = p.Color, Size = p.Size, Num = p.Num, StyleId = BaseInfo.StyleId, StockId = KeyMange.GetKey("Stock") }); }); } if (IsNewSample) { Files.ForEach(p => { if (p.IsDelete) { File.Delete(p.FileUrl); } }); Files.RemoveAll(p => p.IsDelete); BaseInfo.SetCreateUser(currentUser.UserName); sc.SampleBaseInfos.Add(BaseInfo); //写入打样信息 ProofingInfo.SetCreateUser(currentUser.UserName); sc.Proofings.Add(ProofingInfo); //写入文件信息 sc.StyleFiles.AddRange(Files); //写入大货信息 ProductInfo.SetCreateUser(currentUser.UserName); sc.ProductionRecords.Add(ProductInfo); } else { Files.ForEach(p => { if (p.Id == 0) { sc.StyleFiles.Add(p); } else if (p.IsDelete == true) { sc.Entry(p).State = System.Data.Entity.EntityState.Modified; } }); BaseInfo.SetEditUser(currentUser.UserName); ProofingInfo.SetEditUser(currentUser.UserName); ProductInfo.SetEditUser(currentUser.UserName); sc.Entry(BaseInfo).State = System.Data.Entity.EntityState.Modified; if (ProofingInfo.Id > 0) { sc.Entry(ProofingInfo).State = System.Data.Entity.EntityState.Modified; } else { sc.Entry(ProofingInfo).State = System.Data.Entity.EntityState.Added; } if (ProductInfo.Id > 0) { sc.Entry(ProductInfo).State = System.Data.Entity.EntityState.Modified; } else { sc.Entry(ProductInfo).State = System.Data.Entity.EntityState.Added; } }; SetSeachStr(); sc.SaveChanges(); } return(true); }
public bool SaveProofOrder() { sdc.SaveChanges(); return(true); }