/// <summary>
/// 获取未关闭工单下的自制件
/// </summary>
/// <param name="Top"></param>
/// <returns></returns>
public List <Part> GetUnClosedPart(int Top = 0)
{
List <Part> lists = new List <Part>();
using (ERP.ERPDbContext ERPDB = new ERP.ERPDbContext(Connection))
{
lists = (from a in ERPDB.Part
join b in ERPDB.JobAsmbl.Where(o => !o.JobComplete) on a.PartNum equals b.PartNum
where a.TypeCode == "M"
select a).ToList();
if (Top > 0)
{
lists = lists.Take(Top).ToList();
}
}
return(lists);
}
public List <PartMtl> GetPartMtl(string PartNum = "")
{
List <PartMtl> lists = new List <PartMtl>();
using (ERP.ERPDbContext ERPDB = new ERP.ERPDbContext(Connection))
{
if (!string.IsNullOrEmpty(PartNum))
{
lists = ERPDB.PartMtl.Where(o => o.PartNum == PartNum).ToList();
}
else
{
lists = ERPDB.PartMtl.ToList();
}
}
return(lists);
}
public List <PartOpr> GetPartOpr(string PartNum = "")
{
List <PartOpr> lists = new List <PartOpr>();
using (ERP.ERPDbContext ERPDB = new ERP.ERPDbContext(Connection))
{
if (!string.IsNullOrEmpty(PartNum))
{
lists = ERPDB.PartOpr.Where(o => o.PartNum == PartNum).ToList();
}
else
{
lists = ERPDB.PartOpr.ToList();
}
}
lists = lists.OrderBy(o => o.OprSeq).ToList();
return(lists);
}
public DTO_COMPANY GetCompany()
{
DTO_COMPANY model = new DTO_COMPANY();
using (ERP.ERPDbContext ERPDB = new ERP.ERPDbContext(Connection))
{
var Company = ERPDB.Company.FirstOrDefault();
if (Company != null)
{
var Company_UD = ERPDB.Company_UD.Where(o => o.ForeignSysRowID == Company.SysRowID).FirstOrDefault();
if (Company_UD != null)
{
model.Company = Company.Company1;
model.Name = Company.Name;
model.LastGetPLMTime = Company_UD.LastGetPLMTime_c;
}
}
}
return(model);
}
public List <Part> GetPart(string TypeCode = "", string PartNum = "")
{
List <Part> lists = new List <Part>();
using (ERP.ERPDbContext ERPDB = new ERP.ERPDbContext(Connection))
{
if (!string.IsNullOrEmpty(TypeCode))
{
lists = ERPDB.Part.Where(o => o.TypeCode == TypeCode).ToList();
}
else if (!string.IsNullOrEmpty(PartNum))
{
lists = ERPDB.Part.Where(o => o.PartNum == PartNum).ToList();
}
else
{
lists = ERPDB.Part.ToList();
}
}
return(lists);
}
public int GetRevId(string PartNum, string UserID)
{
int result = 0;
try
{
using (ERP.ERPDbContext ERPDB = new ERP.ERPDbContext(Connection))
{
SyncHistory model = new SyncHistory();
model.Company = "001";
model.PartNum = PartNum;
model.SyncTime = DateTime.Now;
model.UserID = UserID;
model.RevName = "R";
ERPDB.SyncHistory.Add(model);
ERPDB.SaveChanges();
result = model.ID;
}
}
catch (Exception e) { }
return(result);
}
public bool DelRev(string PartNum, string UserID, int RevNum)
{
bool result = false;
try
{
using (ERP.ERPDbContext ERPDB = new ERP.ERPDbContext(Connection))
{
var model = ERPDB.SyncHistory.Where(o => o.PartNum == PartNum && o.UserID == UserID && o.RevNum == RevNum).FirstOrDefault();
if (model != null)
{
ERPDB.Entry(model).State = EntityState.Deleted;
ERPDB.SaveChanges();
result = true;
}
}
}
catch
{
result = false;
}
return(result);
}
public ERPRepository(string ConnStr)
{
ConstDB = new ERP.ERPDbContext(ConnStr);
Connection = ConnStr;
}
