/// <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);
}
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();
}
}
/// <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>
/// 取消借用审批中的样衣借用
/// </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 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 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);
}