/// <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);
}