public void Update(AscmWarelocation ascmWarelocation)
{
try
{
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction())
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Update <AscmWarelocation>(ascmWarelocation);
tx.Commit();//正确执行提交
}
catch (Exception ex)
{
tx.Rollback();//回滚
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmWarelocation)", ex);
throw ex;
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Save AscmWarelocation)", ex);
throw ex;
}
}
public void Delete(AscmWarelocation ascmWarelocation)
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Delete <AscmWarelocation>(ascmWarelocation);
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("删除失败(Delete AscmWarelocation)", ex);
throw ex;
}
}
public void Delete(int id)
{
try
{
AscmWarelocation ascmWarelocation = Get(id);
Delete(ascmWarelocation);
}
catch (Exception ex)
{
throw ex;
}
}
public AscmWarelocation Get(int id)
{
AscmWarelocation ascmWarelocation = null;
try
{
ascmWarelocation = YnDaoHelper.GetInstance().nHibernateHelper.Get <AscmWarelocation>(id);
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmWarelocation)", ex);
throw ex;
}
return(ascmWarelocation);
}
public void SetWarelocationDocNumber(List <AscmWmsPreparationDetail> list)
{
if (list == null || list.Count == 0)
{
return;
}
var warelocationIds = list.Select(P => P.warelocationId).Distinct();
var count = warelocationIds.Count();
string ids = string.Empty;
for (int i = 0; i < count; i++)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += warelocationIds.ElementAt(i);
if ((i + 1) % 500 == 0 || (i + 1) == count)
{
if (!string.IsNullOrEmpty(ids))
{
string sql = "from AscmWarelocation where id in (" + ids + ")";
IList <AscmWarelocation> ilistAscmWarelocation = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWarelocation>(sql);
if (ilistAscmWarelocation != null && ilistAscmWarelocation.Count > 0)
{
List <AscmWarelocation> listAscmWarelocation = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmWarelocation>(ilistAscmWarelocation);
foreach (AscmWmsPreparationDetail ascmWmsPreparationDetail in list)
{
AscmWarelocation ascmWarelocation = listAscmWarelocation.Find(P => P.id == ascmWmsPreparationDetail.warelocationId);
if (ascmWarelocation != null)
{
ascmWmsPreparationDetail.locationDocNumber = ascmWarelocation.docNumber;
}
}
}
}
ids = string.Empty;
}
}
}
public AscmWarelocation GetWarelocationByRfid(string rfid)
{
AscmWarelocation ascmWarelocation = null;
try
{
if (!string.IsNullOrEmpty(rfid))
{
IList <AscmWarelocation> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWarelocation>("from AscmWarelocation where rfid='" + rfid.Trim() + "'");
if (ilist != null && ilist.Count > 0)
{
ascmWarelocation = ilist.First();
ascmWarelocation.listAscmLocationMaterialLink = AscmLocationMaterialLinkService.GetInstance().GetList(ascmWarelocation.id, true);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(ascmWarelocation);
}
private void SetWarelocation(List <AscmLocationMaterialLink> list)
{
if (list != null && list.Count > 0)
{
var warelocationIds = list.Select(P => P.pk.warelocationId).Distinct();
var count = warelocationIds.Count();
string ids = string.Empty;
for (int i = 0; i < count; i++)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += warelocationIds.ElementAt(i);
if ((i + 1) % 500 == 0 || (i + 1) == count)
{
if (!string.IsNullOrEmpty(ids))
{
string sql = "from AscmWarelocation where id in (" + ids + ")";
IList <AscmWarelocation> ilistWarelocation = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWarelocation>(sql);
if (ilistWarelocation != null && ilistWarelocation.Count > 0)
{
List <AscmWarelocation> listWarelocation = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmWarelocation>(ilistWarelocation);
foreach (AscmLocationMaterialLink locationMaterialLink in list)
{
AscmWarelocation warelocation = listWarelocation.Find(P => P.id == locationMaterialLink.pk.warelocationId);
if (warelocation != null)
{
locationMaterialLink.locationDocNumber = warelocation.docNumber;
locationMaterialLink.warehouseId = warelocation.warehouseId;
}
}
}
}
ids = string.Empty;
}
}
}
}
