public static Msg EnsureInBunch(Tbl_ProductBatch oBunch, Tbl_ProductStorage oStorage)
{
Msg msg = null;
if (oBunch != null)
{
try
{
using (var en = new LingYunEntities())
{
var oPlan = en.Tbl_Plan.Where(a => a.PlanID == oBunch.PlanID).FirstOrDefault();
oPlan.ProductAdmStatus = 128;
en.Tbl_ProductBatch.AddObject(oBunch);
en.SaveChanges();
var obj = en.Tbl_ProductBatch.Where(a => a.MateriesID == oBunch.MateriesID).FirstOrDefault();
oStorage.BuildBatchID = int.Parse(obj.BuildBatchID.ToString());
en.AddToTbl_ProductStorage(oStorage);
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
}
return(msg);
}
public static Msg AddMateries(List <Tbl_Materies> oMatries)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
foreach (Tbl_Materies ma in oMatries)
{
en.AddToTbl_Materies(ma);
}
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
/// <summary>
/// 更新出库批次表
/// </summary>
/// <returns></returns>
public static Msg UpdateOutBunch(int BuildBunchId, int count)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
Tbl_OutCenterStorage oBunch = en.Tbl_OutCenterStorage.Where(a => a.BuildBatchID == BuildBunchId).FirstOrDefault();
if (oBunch != null)
{
oBunch.Count = count;
}
en.SaveChanges();
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
/// <summary>
/// 更新出库批次表批次表
/// </summary>
/// <param name="matriesId"></param>
/// <param name="count"></param>
/// <param name="oStorage">仓储表</param>
/// <returns></returns>
public static Msg UpdateOutBunch(Tbl_OutProductBatch oStorage, Tbl_CenterStorageBatch oCenterBunch)
{
Msg msg = null;
if (oStorage != null)
{
try
{
using (var en = new LingYunEntities())
{
var obj = en.Tbl_OutProductBatch.Where(a => a.BuildBatchID == oStorage.BuildBatchID).FirstOrDefault();
obj.Count = oStorage.Count;
obj.PreAdmStatus = 128;
obj.PreAdmTime = DateTime.Now;
var oProductStorage = en.Tbl_ProductStorage.Where(b => b.BuildBatchID == oStorage.BuildBatchID).FirstOrDefault();
oProductStorage.NowAdmStatus = 128;
oProductStorage.NowAdmTime = DateTime.Now;
en.Tbl_CenterStorageBatch.AddObject(oCenterBunch);//插入入库记录
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
}
return(msg);
}
/// <summary>
/// 新编辑出库批次表
/// </summary>
/// <param name="matriesId"></param>
/// <param name="count"></param>
/// <param name="oStorage">仓储表</param>
/// <returns></returns>
public static Msg NEditOurBunch(List <Tbl_OutProductBatch> list)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
foreach (Tbl_OutProductBatch oPro in list)
{
en.Tbl_OutProductBatch.AddObject(oPro);
en.SaveChanges();
}
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
return(msg);
}
/// <summary>
/// android端确认
/// </summary>
/// <param name="oMatries"></param>
/// <returns></returns>
public static Msg AndroidEnsure(int iPlanid)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
Tbl_Materies obj = en.Tbl_Materies.Where(a => a.MateriesID == iPlanid).FirstOrDefault();
obj.NowAdmStatus = 128;
obj.NowDate = DateTime.Now.ToString();
Tbl_Plan oPlan = en.Tbl_Plan.Where(b => b.PlanID == obj.PlanID).FirstOrDefault();
if (oPlan != null)
{
oPlan.DesignAdmStatus = 128;
}
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
/// <summary>
/// 根据编号查询入库批次表
/// </summary>
/// <returns></returns>
public static Msg EnsureInBunch(int iBuildBunch, Tbl_SiteStorage oStorage)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
Tbl_OutCenterStorage oCenterBunch = en.Tbl_OutCenterStorage.Where(a => a.BuildBatchID == iBuildBunch).FirstOrDefault();
if (oCenterBunch != null)
{
oCenterBunch.NowAdmStatus = 128;
oCenterBunch.NowAdmTime = DateTime.Now;
}
Tbl_SiteStorageBatch oSiteInBunch = en.Tbl_SiteStorageBatch.Where(a => a.BuildBatchID == iBuildBunch).FirstOrDefault();
if (oCenterBunch != null)
{
oSiteInBunch.NowAdmStatus = 128;
oCenterBunch.NowAdmTime = DateTime.Now;
}
en.Tbl_SiteStorage.AddObject(oStorage);
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
//创建人：梁林
//时间：3/29
/// <summary>
///向项目汇总表增加一条项目
/// </summary>
/// <param name="oPlan">项目表对象</param>
/// <returns>消息传输实体</returns>
public static Msg AddPlan(Tbl_Plan oPlan)
{
Msg msg = null;
if (oPlan != null)
{
try
{
using (var en = new LingYunEntities())
{
en.Tbl_Plan.AddObject(oPlan);
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
}
return(msg);
}
/// <summary>
///新插入出库批次表
/// </summary>
/// <returns></returns>
public static Msg NEditOutBunch(List <Tbl_OutCenterStorage> list)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
foreach (Tbl_OutCenterStorage obj in list)
{
en.Tbl_OutCenterStorage.AddObject(obj);
}
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
public static Msg AndroidOutBatch(int iBatchid)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
var obj = en.Tbl_SiteStorage.Where(a => a.BuildBatchID == iBatchid).FirstOrDefault();
obj.NowAdmStatus = 128;
obj.NowAdmTime = DateTime.Now;
var oOut = en.Tbl_OutSiteStorage.Where(a => a.BuildBatchID == iBatchid).FirstOrDefault();
oOut.PreAdmStatus = 128;
oOut.PreAdmTime = DateTime.Now;
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg(false);
}
return(msg);
}
/// <summary>
/// 更新入库批次表
/// </summary>
/// <param name="matriesId"></param>
/// <param name="count"></param>
/// <param name="oStorage">仓储表</param>
/// <returns></returns>
public static Msg UpdateInBunch(int matriesId, int count, Tbl_CenterStorage oStorage)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
Tbl_OutProductBatch oProduct = en.Tbl_OutProductBatch.Where(a => a.BuildBatchID == matriesId).FirstOrDefault();
oProduct.NowAdmStatus = 128;
oProduct.NowAdmTime = DateTime.Now;
////Tbl_CenterStorageBatch oCenter = en.Tbl_CenterStorageBatch.Where(a => a.BuildBatchID == matriesId).FirstOrDefault();
////oCenter.Count = count;
////oCenter.NowAdmStatus = 128;
//oCenter.NowAdmTime = DateTime.Now;
//en.AddToTbl_CenterStorage(oStorage);
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
return(msg);
}
/// <summary>
/// 确认出库批次表
/// </summary>
/// <returns></returns>
public static Msg EnsureOutBunch(int iBuildBunch, int count)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
Tbl_SiteStorage oSiteStorage = en.Tbl_SiteStorage.Where(a => a.BuildBatchID == iBuildBunch).FirstOrDefault();
if (oSiteStorage != null)
{
oSiteStorage.NowAdmStatus = 128;
oSiteStorage.NowAdmTime = DateTime.Now;
}
Tbl_OutSiteStorage oSiteBunch = en.Tbl_OutSiteStorage.Where(a => a.BuildBatchID == iBuildBunch).FirstOrDefault();
if (oSiteStorage != null)
{
oSiteBunch.PreAdmStatus = 128;
oSiteBunch.PreAdmTime = DateTime.Now;
oSiteBunch.Count = count;
}
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
public static Msg UpdateMateries(Tbl_Materies oMatries)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
Tbl_Materies obj = en.Tbl_Materies.Where(a => a.PlanID == oMatries.PlanID).FirstOrDefault();
obj.Date = oMatries.Date;
obj.BuildNum = oMatries.BuildNum;
obj.BuildName = oMatries.BuildName;
obj.NowAdmStatus = oMatries.NowAdmStatus;
obj.TotalNum = oMatries.TotalNum;
obj.MateriesType = oMatries.MateriesType;
obj.ProcessingNum = oMatries.ProcessingNum;
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
public static Msg EnsureMateries(Tbl_Materies oMatries)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
Tbl_Materies obj = en.Tbl_Materies.Where(a => a.PlanID == oMatries.PlanID).FirstOrDefault();
obj.Date = oMatries.Date;
obj.BuildNum = oMatries.BuildNum;
obj.BuildName = oMatries.BuildName;
obj.NowAdmStatus = oMatries.NowAdmStatus;
obj.TotalNum = oMatries.TotalNum;
obj.MateriesType = oMatries.MateriesType;
obj.NowDate = DateTime.Now.ToString();
obj.ProcessingNum = oMatries.ProcessingNum;
Tbl_Plan oPlan = en.Tbl_Plan.Where(b => b.PlanID == oMatries.PlanID).FirstOrDefault();
if (oPlan != null)
{
oPlan.DesignAdmStatus = 128;
}
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
/// <summary>
/// 新确认入库批次表
/// </summary>
/// <param name="matriesId"></param>
/// <param name="count"></param>
/// <param name="oStorage">仓储表</param>
/// <returns></returns>
public static Msg NEnsureInBunch(List <Tbl_ProductStorage> list)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
foreach (Tbl_ProductStorage oPro in list)
{
var oMatries = en.Tbl_Materies.Where(a => a.MateriesID == oPro.MateriesID).FirstOrDefault();
oMatries.NowAdmStatus = 128;
oMatries.NowDate = DateTime.Now.ToString();
var oBatch = en.Tbl_ProductBatch.Where(a => a.BuildBatchID == oPro.BuildBatchID).FirstOrDefault();
oBatch.NowAdmStatus = 128;
oBatch.NowAdmTime = DateTime.Now;
en.Tbl_ProductStorage.AddObject(oPro);
}
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
return(msg);
}
public static Msg EnsureInBunch(Tbl_CenterStorageBatch oBunch, Tbl_CenterStorage oStorage)
{
Msg msg = null;
if (oBunch != null)
{
try
{
using (var en = new LingYunEntities())
{
var obj = en.Tbl_OutProductBatch.Where(a => a.BuildBatchID == oBunch.BuildBatchID).FirstOrDefault();
obj.NowAdmStatus = 128;
en.Tbl_CenterStorageBatch.AddObject(oBunch);
en.SaveChanges();
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
}
return(msg);
}
public static Msg EditOutBunch(Tbl_OutProductBatch oBunch)
{
Msg msg = null;
if (oBunch != null)
{
try
{
using (var en = new LingYunEntities())
{
Tbl_OutProductBatch obj = en.Tbl_OutProductBatch.Where(a => a.PlanID == oBunch.PlanID && oBunch.MateriesID == a.MateriesID).FirstOrDefault();
if (obj == null)
{
en.Tbl_OutProductBatch.AddObject(oBunch);
}
else
{
obj.Count = oBunch.Count;
}
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
}
return(msg);
}
/// <summary>
/// 更新入库批次表
/// </summary>
/// <param name="matriesId"></param>
/// <param name="count"></param>
/// <param name="oStorage">仓储表</param>
/// <returns></returns>
public static Msg UpdateInBunch(int matriesId, int count, Tbl_ProductStorage oStorage)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
var obj = en.Tbl_ProductBatch.Where(a => a.BuildBatchID == oStorage.BuildBatchID).FirstOrDefault();
obj.Count = count;
obj.NowAdmStatus = 128;
obj.NowAdmTime = DateTime.Now;
en.AddToTbl_ProductStorage(oStorage);
en.SaveChanges();
List <Tbl_ProductBatch> list = en.Tbl_ProductBatch.Where(a => a.PlanID == oStorage.PlanID && a.NowAdmStatus == 128).ToList();
int proCount = 0;
foreach (Tbl_ProductBatch oPro in list)
{
proCount += oPro.Count;
}
Tbl_Materies oMa = en.Tbl_Materies.Where(a => a.PlanID == oStorage.PlanID).FirstOrDefault(); //最后如果确认完成对加工主管状态改变
if (oMa.TotalNum == proCount)
{
var oPlan = en.Tbl_Plan.Where(a => a.PlanID == oStorage.PlanID).FirstOrDefault();
oPlan.ProductAdmStatus = 128;
en.SaveChanges();
}
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
return(msg);
}
public static Msg AndroidInEnsure(int iBatchId)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
var last = en.Tbl_OutProductBatch.Where(a => a.BuildBatchID == iBatchId).FirstOrDefault();
last.NowAdmStatus = 128;
last.NowAdmTime = DateTime.Now;
var obj = en.Tbl_CenterStorageBatch.Where(a => a.BuildBatchID == iBatchId).FirstOrDefault();
obj.NowAdmStatus = 128;
obj.NowAdmTime = DateTime.Now;
Tbl_CenterStorage oStorage = new Tbl_CenterStorage();
oStorage.PlanID = obj.PlanID;
oStorage.Time = DateTime.Now;
oStorage.MateriesID = obj.MateriesID;
oStorage.BuildID = obj.BuildID;
oStorage.BuildName = obj.BuildName;
oStorage.MateriesType = obj.MateriesType;
oStorage.PreAdmTime = DateTime.Now;
oStorage.PreAdmStatus = 128;
oStorage.NowAdmStatus = 1;
oStorage.NowAdmTime = DateTime.Now;
oStorage.ProjectName = obj.ProjectName;
oStorage.WorkMapID = obj.WorkMapID;
oStorage.InCount = obj.Count;
en.Tbl_CenterStorage.AddObject(oStorage);
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
return(msg);
}
/// <summary>
/// 安卓端用户首次登录验证
/// </summary>
/// <param name="username"></param>
/// <param name="encodePsd"></param>
/// <returns></returns>
public static Msg Login(string username, string encodePsd, string Imei)
{
Msg loginMsg = new Msg();
Tbl_User userInfo = new Tbl_User();;
try
{
using (var en = new LingYunEntities())
{
Tbl_User Users = en.Tbl_User.Where(b => b.Name == username && b.CheckPwd == encodePsd).FirstOrDefault();
if (Users != null)
{
if (Users.CheckPwd == encodePsd)
{
Users.APP = Imei;
en.SaveChanges();
loginMsg = new Msg(true)
{
UserData = Users
};
}
else
{
loginMsg = new Msg {
Message = "error:用户名或密码不正确"
};
}
}
else
{
loginMsg = new Msg {
Message = "error:用户名不存在"
};
}
}
}
catch (Exception ex)
{
loginMsg = new Msg {
Message = ex.Message
};
}
return(loginMsg);
}
public static Msg AndroidOutBatch(int iBatchid)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
var obj = en.Tbl_CenterStorage.Where(a => a.BuildBatchID == iBatchid).FirstOrDefault();
obj.NowAdmStatus = 128;
obj.NowAdmTime = DateTime.Now;
var oOut = en.Tbl_OutCenterStorage.Where(a => a.BuildBatchID == iBatchid).FirstOrDefault();
oOut.PreAdmStatus = 128;
oOut.PreAdmTime = DateTime.Now;
//出库批次表
Tbl_SiteStorageBatch oCenterBunch = new Tbl_SiteStorageBatch();
oCenterBunch.PlanID = oOut.PlanID;
oCenterBunch.MateriesTasbleID = oOut.MateriesTasbleID;
oCenterBunch.BuildID = oOut.BuildID;
oCenterBunch.BuildBatchID = oOut.BuildBatchID;
oCenterBunch.Time = DateTime.Now;
oCenterBunch.ProjectName = oOut.ProjectName;
oCenterBunch.BuildName = oOut.BuildName;
oCenterBunch.ProjectName = oOut.ProjectName;
oCenterBunch.MateriesID = oOut.MateriesID;
oCenterBunch.MateriesType = oOut.MateriesType;
oCenterBunch.WorkMapID = oOut.WorkMapID;
oCenterBunch.Count = oOut.Count
;
oCenterBunch.NowAdmStatus = 1;
oCenterBunch.PreAdmStatus = 128;
oCenterBunch.PreAdmTime = DateTime.Now;
oCenterBunch.NowAdmTime = DateTime.Now;
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg(false);
}
return(msg);
}
/// <summary>
///向项目汇总表增加一条项目
/// </summary>
/// <param name="oPlan">项目表对象</param>
/// <returns>消息传输实体</returns>
public static Msg EditPlan(Tbl_Plan oPlan)
{
Msg msg = null;
if (oPlan != null)
{
try
{
using (var en = new LingYunEntities())
{
Tbl_Plan obj = en.Tbl_Plan.Where(a => a.PlanID == oPlan.PlanID).FirstOrDefault();
if (obj != null)
{
obj.ProjectName = oPlan.ProjectName;
obj.ProductAdm = oPlan.ProductAdm;
obj.DesignAdm = oPlan.DesignAdm;
obj.CenterStorageAdm = obj.CenterStorageAdm;
obj.SiteStorageAdm = obj.SiteStorageAdm;
obj.PlanDate = DateTime.Now;
en.SaveChanges();
msg = Msg.Default;
}
else
{
msg = new Msg(false)
{
Message = "没有查到要确认的项目"
};
}
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = "没有查到要确认的项目"
};
}
}
return(msg);
}
/// <summary>
/// 新确认出库批次表
/// </summary>
/// <returns></returns>
public static Msg NEnsureOutBunch(List <Tbl_SiteStorageBatch> list)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
foreach (Tbl_SiteStorageBatch oSite in list)
{
Tbl_CenterStorage oStorage = en.Tbl_CenterStorage.Where(a => a.BuildBatchID == oSite.BuildBatchID).FirstOrDefault();
if (oStorage != null)
{
oStorage.NowAdmStatus = 128;
oStorage.NowAdmTime = DateTime.Now;
}
Tbl_OutCenterStorage oSiteBunch = en.Tbl_OutCenterStorage.Where(a => a.BuildBatchID == oSite.BuildBatchID).FirstOrDefault();
if (oSiteBunch != null)
{
oSiteBunch.PreAdmStatus = 128;
oSiteBunch.PreAdmTime = DateTime.Now;
}
en.Tbl_SiteStorageBatch.AddObject(oSite);
}
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
/// 新确认出库批次表批次表
/// </summary>
/// <param name="matriesId"></param>
/// <param name="count"></param>
/// <param name="oStorage">仓储表</param>
/// <returns></returns>
public static Msg NEnsureOutBunch(List <Tbl_CenterStorageBatch> list)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
foreach (Tbl_CenterStorageBatch oPro in list)
{
var obj = en.Tbl_OutProductBatch.Where(a => a.BuildBatchID == oPro.BuildBatchID).FirstOrDefault();
obj.PreAdmStatus = 128;
obj.PreAdmTime = DateTime.Now;
var oProductStorage = en.Tbl_ProductStorage.Where(b => b.BuildBatchID == oPro.BuildBatchID).FirstOrDefault();
oProductStorage.NowAdmStatus = 128;
oProductStorage.NowAdmTime = DateTime.Now;
en.Tbl_CenterStorageBatch.AddObject(oPro);//插入入库记录
}
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
return(msg);
}
/// <summary>
/// 批量确认
/// </summary>
/// <param name="oMatries"></param>
/// <returns></returns>
public static Msg EnsureMateries(List <Tbl_Materies> lMatries)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
foreach (Tbl_Materies oMatries in lMatries)
{
Tbl_Materies obj = en.Tbl_Materies.Where(a => a.MateriesID == oMatries.MateriesID).FirstOrDefault();
obj.Date = oMatries.Date;
obj.BuildNum = oMatries.BuildNum;
obj.BuildName = oMatries.BuildName;
obj.NowAdmStatus = oMatries.NowAdmStatus;
obj.TotalNum = oMatries.TotalNum;
obj.MateriesType = oMatries.MateriesType;
obj.BeforeAdmStatus = 128;
obj.PreDate = DateTime.Now.ToString();
obj.NowAdmStatus = 1;
obj.NowDate = DateTime.Now.ToString();
obj.ProcessingNum = oMatries.ProcessingNum;
}
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
/// <summary>
/// 插入出库批次表
/// </summary>
/// <returns></returns>
public static Msg EditOutBunch(Tbl_OutSiteStorage oBunch)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
en.Tbl_OutSiteStorage.AddObject(oBunch);
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
public static Msg EditInBunch(Tbl_ProductBatch oBunch)
{
//构造调码对象
List <Tbl_BarCodeBatch> lBarcode = new List <Tbl_BarCodeBatch>();
// List<Tbl_BarCodeInfo> lBarCodeInfo = new List<Tbl_BarCodeInfo>();
Msg msg = null;
if (oBunch != null)
{
try
{
using (var en = new LingYunEntities())
{
Tbl_ProductBatch obj = en.Tbl_ProductBatch.Where(a => a.PlanID == oBunch.PlanID && oBunch.MateriesID == a.MateriesID).FirstOrDefault();
//if (obj == null)
{
en.Tbl_ProductBatch.AddObject(oBunch);
en.SaveChanges();
Tbl_ProductBatch oProduct = en.Tbl_ProductBatch.Where(a => a.PlanID == oBunch.PlanID).ToList().LastOrDefault();
//批次
List <string> lCodes = BarCode.BuildBarCode(oProduct.WorkMapID, (int)BarCodeType.批次);
Tbl_BarCodeBatch oBunchBarCode = new Tbl_BarCodeBatch();
oBunchBarCode.BarCodeBatchID = oProduct.BuildBatchID;
oBunchBarCode.BarCodeType = (int)BarCodeType.批次;
oBunchBarCode.BarCodeNo = lCodes[0];
oBunchBarCode.CreateTime = DateTime.Now;
oBunchBarCode.BuildBatchID = oProduct.BuildBatchID;
Tbl_BarCodeInfo oBarCodeInfo = new Tbl_BarCodeInfo();
oBarCodeInfo.BarCodeInfoID = oProduct.BuildBatchID;
oBarCodeInfo.BuildName = oBunch.BuildName;
oBarCodeInfo.CreateTime = DateTime.Now;
oBarCodeInfo.MateriesType = oBunch.MateriesType;
oBarCodeInfo.WorkMapID = oBunch.WorkMapID;
oBarCodeInfo.ProjectName = oBunch.ProjectName;
oBarCodeInfo.BarCodeBatchID = oProduct.BuildBatchID;
en.Tbl_BarCodeBatch.AddObject(oBunchBarCode);
en.Tbl_BarCodeInfo.AddObject(oBarCodeInfo);
//
List <string> lSigleCodes = BarCode.BuildBarCode(oProduct.WorkMapID, (int)BarCodeType.单件, oBunch.Count);
for (int i = 0; i < lSigleCodes.Count; i++)
{
Tbl_BarCodeBatch oSigleBunch = new Tbl_BarCodeBatch();
oSigleBunch.BarCodeBatchID = oProduct.BuildBatchID;
oSigleBunch.BarCodeType = (int)BarCodeType.单件;
oSigleBunch.BarCodeNo = lSigleCodes[i];
oSigleBunch.CreateTime = DateTime.Now;
Tbl_BarCodeInfo oSigleInfo = new Tbl_BarCodeInfo();
oSigleInfo.BarCodeBatchID = oProduct.BuildBatchID;
oSigleInfo.BarCodeInfoID = oProduct.BuildBatchID;
oSigleInfo.BuildName = oBunch.BuildName;
oSigleInfo.CreateTime = DateTime.Now;
oSigleInfo.MateriesType = oBunch.MateriesType;
oSigleInfo.WorkMapID = oBunch.WorkMapID;
oSigleInfo.ProjectName = oBunch.ProjectName;
en.Tbl_BarCodeBatch.AddObject(oSigleBunch);
en.Tbl_BarCodeInfo.AddObject(oSigleInfo);
}
en.SaveChanges();
msg = new Msg(true)
{
UserData = lCodes
};
}
//else
//{
// obj.Count = oBunch.Count;
// List<Tbl_BarCodeBatch> lDelBunch = en.Tbl_BarCodeBatch.Where(a => a.BuildBatchID == obj.BuildBatchID).ToList();
// List<Tbl_BarCodeInfo> lDelInfo = en.Tbl_BarCodeInfo.Where(a => a.BarCodeBatchID == obj.BuildBatchID).ToList();
// for(int j=0;j<lDelBunch.Count;j++)
// {
// en.Tbl_BarCodeBatch.DeleteObject(lDelBunch[j]);
// en.Tbl_BarCodeInfo.DeleteObject(lDelInfo[j]);
// }en.SaveChanges();
// string conStr = ConfigurationManager.AppSettings["ConStr"];
// SqlConnection con = new SqlConnection(conStr);
// con.Open();
// //插入单件
// // SqlTransaction tran = con.BeginTransaction();//开始事务
// List<string> lSigleCodes = BarCode.BuildBarCode(int.Parse(obj.BuildBatchID.ToString()), (int)BarCodeType.单件, oBunch.Count);
// for (int i = 0; i < lSigleCodes.Count; i++)
// {
// Tbl_BarCodeBatch oSigleBunch = new Tbl_BarCodeBatch();
// oSigleBunch.BuildBatchID = obj.BuildBatchID;
// oSigleBunch.BarCodeType = (int)BarCodeType.单件;
// oSigleBunch.BarCodeNo = lSigleCodes[i];
// oSigleBunch.CreateTime = DateTime.Now;
// Tbl_BarCodeInfo oSigleInfo = new Tbl_BarCodeInfo();
// oSigleInfo.BarCodeBatchID = obj.BuildBatchID;
// oSigleInfo.BuildName = oBunch.BuildName;
// oSigleInfo.CreateTime = DateTime.Now;
// oSigleInfo.MateriesType = oBunch.MateriesType;
// oSigleInfo.WorkMapID = oBunch.WorkMapID;
// oSigleInfo.ProjectName = oBunch.ProjectName;
// //en.Tbl_BarCodeBatch.AddObject(oSigleBunch);
// //en.Tbl_BarCodeInfo.AddObject(oSigleInfo);
// SqlCommand com1 = new SqlCommand("insert into Tbl_BarCodeBatch(BuildBatchID,BarCodeNo,CreateTime,BarCodeType) values(" + oSigleBunch.BuildBatchID + ",'" + oSigleBunch.BarCodeNo + "','" + oSigleBunch.CreateTime + "'," + oSigleBunch.BarCodeType + ")", con);
// SqlCommand com2 = new SqlCommand("insert into Tbl_BarCodeInfo(BarCodeBatchID,CreateTime,ProjectName,BuildName,MateriesType,WorkMapID) values(" + oSigleInfo.BarCodeBatchID + ",'" + oSigleInfo.CreateTime + "','" + oSigleInfo.ProjectName + "','" + oSigleInfo.BuildName + "','" + oSigleInfo.MateriesType + "','" + oSigleInfo.WorkMapID + "')", con);
// com1.ExecuteScalar();
// com2.ExecuteScalar();
// }
// //批次
// List<string> lCodes = BarCode.BuildBarCode(int.Parse(obj.BuildBatchID.ToString()), (int)BarCodeType.批次);
// Tbl_BarCodeBatch oBunchBarCode = new Tbl_BarCodeBatch();
// oBunchBarCode.BuildBatchID = obj.BuildBatchID;
// oBunchBarCode.BarCodeType = (int)BarCodeType.批次;
// oBunchBarCode.BarCodeNo = lCodes[0];
// oBunchBarCode.CreateTime = DateTime.Now;
// Tbl_BarCodeInfo oBarCodeInfo = new Tbl_BarCodeInfo();
// oBarCodeInfo.BarCodeBatchID = obj.BuildBatchID;
// oBarCodeInfo.BuildName = oBunch.BuildName;
// oBarCodeInfo.CreateTime = DateTime.Now;
// oBarCodeInfo.MateriesType = oBunch.MateriesType;
// oBarCodeInfo.WorkMapID = oBunch.WorkMapID;
// oBarCodeInfo.ProjectName = oBunch.ProjectName;
// SqlCommand com3 = new SqlCommand("insert into Tbl_BarCodeBatch(BuildBatchID,BarCodeNo,CreateTime,BarCodeType) values(" + oBunchBarCode.BuildBatchID + ",'" + oBunchBarCode.BarCodeNo + "','" + oBunchBarCode.CreateTime + "'," + oBunchBarCode.BarCodeType + ")", con);
// SqlCommand com4 = new SqlCommand("insert into Tbl_BarCodeInfo(BarCodeBatchID,CreateTime,ProjectName,BuildName,MateriesType,WorkMapID) values(" + oBarCodeInfo.BarCodeBatchID + ",'" + oBarCodeInfo.CreateTime + "','" + oBarCodeInfo.ProjectName + "','" + oBarCodeInfo.BuildName + "','" + oBarCodeInfo.MateriesType + "','" + oBarCodeInfo.WorkMapID + "')", con);
// com3.ExecuteScalar();
// com4.ExecuteScalar();
// // tran.Commit();
// con.Close();
// msg = new Msg(true) { UserData = lCodes };
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
}
return(msg);
}
/// <summary>
/// 新编辑如库
/// </summary>
/// <param name="oBunch"></param>
/// <returns></returns>
public static Msg NEditInBunch(List <Tbl_ProductBatch> list)
{
Msg msg = null;
//构造调码对象
List <Tbl_BarCodeBatch> lBarcode = new List <Tbl_BarCodeBatch>();
// List<Tbl_BarCodeInfo> lBarCodeInfo = new List<Tbl_BarCodeInfo>();
try
{
using (var en = new LingYunEntities())
{
List <string> BarCodes = new List <string>();
foreach (Tbl_ProductBatch oPro in list)
{
en.Tbl_ProductBatch.AddObject(oPro);
en.SaveChanges();
Tbl_ProductBatch oProduct = en.Tbl_ProductBatch.Where(a => a.MateriesID == oPro.MateriesID).ToList().LastOrDefault();
//批次
List <string> lCodes = BarCode.BuildBarCode(oProduct.WorkMapID, (int)BarCodeType.批次);
BarCodes.Add(lCodes[0]);
Tbl_BarCodeBatch oBunchBarCode = new Tbl_BarCodeBatch();
oBunchBarCode.BarCodeBatchID = oProduct.BuildBatchID;
oBunchBarCode.BarCodeType = (int)BarCodeType.批次;
oBunchBarCode.BarCodeNo = lCodes[0];
oBunchBarCode.CreateTime = DateTime.Now;
oBunchBarCode.BuildBatchID = oProduct.BuildBatchID;
Tbl_BarCodeInfo oBarCodeInfo = new Tbl_BarCodeInfo();
oBarCodeInfo.BarCodeInfoID = oProduct.BuildBatchID;
oBarCodeInfo.BuildName = oPro.BuildName;
oBarCodeInfo.CreateTime = DateTime.Now;
oBarCodeInfo.MateriesType = oPro.MateriesType;
oBarCodeInfo.WorkMapID = oPro.WorkMapID;
oBarCodeInfo.ProjectName = oPro.ProjectName;
oBarCodeInfo.BarCodeBatchID = oProduct.BuildBatchID;
en.Tbl_BarCodeBatch.AddObject(oBunchBarCode);
en.Tbl_BarCodeInfo.AddObject(oBarCodeInfo);
//
List <string> lSigleCodes = BarCode.BuildBarCode(oProduct.WorkMapID, (int)BarCodeType.单件, oPro.Count);
for (int i = 0; i < lSigleCodes.Count; i++)
{
Tbl_BarCodeBatch oSigleBunch = new Tbl_BarCodeBatch();
oSigleBunch.BarCodeBatchID = oProduct.BuildBatchID;
oSigleBunch.BarCodeType = (int)BarCodeType.单件;
oSigleBunch.BarCodeNo = lSigleCodes[i];
oSigleBunch.CreateTime = DateTime.Now;
Tbl_BarCodeInfo oSigleInfo = new Tbl_BarCodeInfo();
oSigleInfo.BarCodeBatchID = oProduct.BuildBatchID;
oSigleInfo.BarCodeInfoID = oProduct.BuildBatchID;
oSigleInfo.BuildName = oPro.BuildName;
oSigleInfo.CreateTime = DateTime.Now;
oSigleInfo.MateriesType = oPro.MateriesType;
oSigleInfo.WorkMapID = oPro.WorkMapID;
oSigleInfo.ProjectName = oPro.ProjectName;
en.Tbl_BarCodeBatch.AddObject(oSigleBunch);
en.Tbl_BarCodeInfo.AddObject(oSigleInfo);
}
}
en.SaveChanges();
msg = new Msg(true)
{
UserData = BarCodes
};
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
return(msg);
}