public void SetWorker(List <AscmForklift> list, bool isSetLogisticsClassName = true)
{
if (list != null && list.Count > 0)
{
string ids = string.Empty;
foreach (AscmForklift ascmForklift in list)
{
if (!string.IsNullOrEmpty(ids) && !string.IsNullOrEmpty(ascmForklift.workerId))
{
ids += ",";
}
if (!string.IsNullOrEmpty(ascmForklift.workerId))
{
ids += "'" + ascmForklift.workerId + "'";
}
}
string where = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "userId");
if (!string.IsNullOrEmpty(where))
{
string sql = "from AscmUserInfo where " + where;
IList <AscmUserInfo> ilistAscmUserInfo = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmUserInfo>(sql);
if (ilistAscmUserInfo != null && ilistAscmUserInfo.Count > 0)
{
List <AscmUserInfo> listAscmUserInfo = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmUserInfo>(ilistAscmUserInfo);
if (isSetLogisticsClassName)
{
AscmUserInfoService.GetInstance().SetUserLogisticsClass(listAscmUserInfo);
}
foreach (AscmForklift ascmForklift in list)
{
if (!string.IsNullOrEmpty(ascmForklift.workerId))
{
ascmForklift.ascmUserInfo = listAscmUserInfo.Find(e => e.userId == ascmForklift.workerId);
}
if (isSetLogisticsClassName && ascmForklift.ascmUserInfo != null)
{
ascmForklift.logisticsClassName = ascmForklift.ascmUserInfo.logisticsClassName;
}
}
}
}
}
}
public string SuplierSiteCode()
{
string hql = "from AscmSupplier where id in (select DISTINCT supplierId from AscmContainer)";
IList <MideaAscm.Dal.Base.Entities.AscmSupplier> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <MideaAscm.Dal.Base.Entities.AscmSupplier>(hql);
List <MideaAscm.Dal.Base.Entities.AscmSupplier> list = null;
if (ilist != null && ilist.Count > 0)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <MideaAscm.Dal.Base.Entities.AscmSupplier>(ilist);
System.Text.StringBuilder sbSn = new System.Text.StringBuilder();
sbSn.Clear();
var q = list.Select(e => e.id).Distinct();
foreach (int supplierId in q)
{
if (sbSn.Length != 0)
{
sbSn.Append(",");
}
sbSn.AppendFormat("{0}", supplierId);
}
if (string.IsNullOrEmpty(sbSn.ToString()))
{
return("");
}
IList <MideaAscm.Dal.Base.Entities.AscmSupplierAddress> ilistII = YnDaoHelper.GetInstance().nHibernateHelper.Find <MideaAscm.Dal.Base.Entities.AscmSupplierAddress>("from AscmSupplierAddress where vendorId in (" + sbSn.ToString() + ")");
List <MideaAscm.Dal.Base.Entities.AscmSupplierAddress> listAscmReadingHead = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList(ilistII);
if (ilist.Count > 0)
{
foreach (Dal.Base.Entities.AscmSupplier ascmTagLog in list)
{
if (ascmTagLog.id == 6128)
{
ascmTagLog.name = "美的";
}
else
{
ascmTagLog.name = listAscmReadingHead.Find(e => e.vendorId == ascmTagLog.id).vendorSiteCode;
}
}
}
}
return(YnBaseClass2.Helper.ObjectHelper.Serialize(list));
}
public AscmEmployee GetByRfid(string rfid)
{
AscmEmployee ascmEmployee = null;
try
{
IList <AscmEmployee> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmEmployee>("from AscmEmployee where id in (select bindId from AscmRfid where id='" + rfid + "')");// and status='" + AscmRfid.StatusDefine.inUse + "'
if (ilist != null && ilist.Count > 0)
{
return(ilist[0]);
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmEmployee)", ex);
throw ex;
}
return(ascmEmployee);
}
/// <summary>
/// 超期预警数据查询Excel导出
/// 覃小华于2013/10/22修改
/// </summary>
/// <param name="ynPage"></param>
/// <param name="sortName"></param>
/// <param name="sortOrder"></param>
/// <param name="queryWord"></param>
/// <param name="whereOther"></param>
/// <param name="extendedTime"></param>
/// <returns></returns>
public List <Dal.SupplierPreparation.Entities.AscmContainer> GetlistForExcellExport(string whereOther, string DateRequired)
{
List <Dal.SupplierPreparation.Entities.AscmContainer> list = null;
try
{
string strHql = @"select new AscmContainer(container,(suppli.name),(to_char(to_date(container.storeInTime,'yyyy-MM-dd HH24:mi:ss')+suppli.warnHours/24,'yyyy-MM-dd HH24:mi:ss')),(ceil(((to_date('" + System.DateTime.Now.ToString() + "','yyyy-MM-dd HH24:mi:ss')-suppli.warnHours/24)-to_date(container.storeInTime, 'yyyy-MM-dd HH24:mi:ss'))*24))) from AscmContainer container, AscmSupplier suppli where container.storeInTime is not null and container.supplierId=suppli.id and (suppli.warnHours is not null and suppli.warnHours!=0) and ceil(((to_date('" + System.DateTime.Now.ToString() + "','yyyy-MM-dd HH24:mi:ss')-suppli.warnHours/24)-to_date(container.storeInTime, 'yyyy-MM-dd HH24:mi:ss'))*24)>-25 and (container.place not in (select to_char(id) from AscmReadingHead where ip='0.0.0.0') or container.place is null)";
//string strHql1 = "from AscmContainer container, AscmSupplier suppli where container.storeInTime is not null and container.supplierId=suppli.id and (suppli.warnHours is not null or suppli.warnHours!=0) and ceil(((to_date('" + System.DateTime.Now.ToString() + "','yyyy-MM-dd HH24:mi:ss')-suppli.warnHours/24)-to_date(container.storeInTime, 'yyyy-MM-dd HH24:mi:ss'))*24)>-25 and (container.place not in (select to_char(id) from AscmReadingHead where address= '容器监管中心' and ip='0.0.0.0') or container.place is null)";
if (!string.IsNullOrEmpty(DateRequired))
{
DateTime DatereadTime = new DateTime();
if (!string.IsNullOrEmpty(DateRequired) && DateTime.TryParse(DateRequired, out DatereadTime))
{
strHql = @"select new AscmContainer(container,(suppli.name),to_char(to_date(container.storeInTime,'yyyy-MM-dd HH24:mi:ss')+suppli.warnHours/24,'yyyy-MM-dd HH24:mi:ss'),(ceil(((to_date('" + DatereadTime.ToString() + "','yyyy-MM-dd HH24:mi:ss')-suppli.warnHours/24)-to_date(container.storeInTime, 'yyyy-MM-dd HH24:mi:ss'))*24))) from AscmContainer container, AscmSupplier suppli where container.storeInTime is not null and container.supplierId=suppli.id and (suppli.warnHours is not null and suppli.warnHours!=0) and ceil(((to_date('" + DatereadTime.ToString() + "','yyyy-MM-dd HH24:mi:ss')-suppli.warnHours/24)-to_date(container.storeInTime, 'yyyy-MM-dd HH24:mi:ss'))*24)>-25 and (container.place not in (select to_char(id) from AscmReadingHead where ip='0.0.0.0') or container.place is null)";
// strHql1 = "from AscmContainer container, AscmSupplier suppli where container.storeInTime is not null and container.supplierId=suppli.id and (suppli.warnHours is not null and suppli.warnHours!=0) and ceil(((to_date('" + DatereadTime.ToString() + "','yyyy-MM-dd HH24:mi:ss')-suppli.warnHours/24)-to_date(container.storeInTime, 'yyyy-MM-dd HH24:mi:ss'))*24)>-25 and (container.place not in (select to_char(id) from AscmReadingHead where ip='0.0.0.0') or container.place is null)";
}
}
//string sort = " order by store.id ";
string where = "";
//in (select id from AscmSupplier where warnHours is not null or warnHours!=0) and sn not in (SELECT containerId FROM AscmStoreInOut a WHERE readTime=(SELECT max(readTime) FROM AscmStoreInOut WHERE containerId=a.containerId) and direction='STOREOUT')";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereOther);
if (!string.IsNullOrEmpty(where))
{
strHql += " and" + where;
// strHql1 += " and" + where;
}
IList <Dal.SupplierPreparation.Entities.AscmContainer> ilist =
//YnDaoHelper.GetInstance().nHibernateHelper.Find<Dal.SupplierPreparation.Entities.AscmContainer>(strHql1);
YnDaoHelper.GetInstance().nHibernateHelper.Find <Dal.SupplierPreparation.Entities.AscmContainer>(strHql
);
if (ilist != null)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <Dal.SupplierPreparation.Entities.AscmContainer>(ilist);
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmWipEntities)", ex);
throw ex;
}
return(list);
}
///<summary>获取卡信息列表</summary>
///<returns>返回卡信息列表</returns>
public List <AscmReadingHead> GetList(string sql)
{
List <AscmReadingHead> list = null;
try
{
IList <AscmReadingHead> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmReadingHead>(sql);
if (ilist != null)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmReadingHead>(ilist);
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmReadingHead)", ex);
throw ex;
}
return(list);
}
public AscmPalletDelivery Add(string palletSn, int batSumMainId, int deliveryOrderBatchId, int materialId, decimal quantity)
{
try
{
AscmPalletDelivery ascmPalletDelivery = new AscmPalletDelivery();
ascmPalletDelivery.organizationId = 0;
ascmPalletDelivery.createUser = "";
ascmPalletDelivery.createTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
ascmPalletDelivery.modifyUser = "";
ascmPalletDelivery.modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
ascmPalletDelivery.palletSn = palletSn;
ascmPalletDelivery.batSumMainId = batSumMainId;
ascmPalletDelivery.deliveryOrderBatchId = deliveryOrderBatchId;
ascmPalletDelivery.deliveryOrderId = 0;
ascmPalletDelivery.materialId = materialId;
ascmPalletDelivery.quantity = quantity;
//ascmPalletDelivery.status = "";
ascmPalletDelivery.memo = "";
int maxId = YnDaoHelper.GetInstance().nHibernateHelper.GetMaxId("select max(id) from AscmPalletDelivery");
maxId++;
ascmPalletDelivery.id = maxId;
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction())
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Save(ascmPalletDelivery);
tx.Commit();//正确执行提交
}
catch (Exception ex)
{
tx.Rollback();//回滚
throw ex;
}
}
return(ascmPalletDelivery);
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("保存失败(Save AscmPalletDelivery)", ex);
throw ex;
}
}
public List<AscmDoor> GetList()
{
List<AscmDoor> list = null;
try
{
string sql = "from AscmDoor ";
IList<AscmDoor> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmDoor>(sql);
if (ilist != null)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList<AscmDoor>(ilist);
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmDoor)", ex);
throw ex;
}
return list;
}
public List <AscmWarelocation> GetList(string sortName, string sortOrder, string queryWord, string whereOther)
{
List <AscmWarelocation> list = null;
try
{
string sort = " order by docNumber ";
if (!string.IsNullOrEmpty(sortName))
{
sort = " order by " + sortName.Trim() + " ";
if (!string.IsNullOrEmpty(sortOrder))
{
sort += sortOrder.Trim();
}
}
string sql = "from AscmWarelocation ";
string where = "", whereQueryWord = "";
if (!string.IsNullOrEmpty(queryWord))
{
whereQueryWord = " docNumber like '%" + queryWord.Trim() + "%'";
}
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereOther);
if (!string.IsNullOrEmpty(where))
{
sql += " where " + where;
}
IList <AscmWarelocation> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWarelocation>(sql + sort);
if (ilist != null)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmWarelocation>(ilist);
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmWarelocation)", ex);
throw ex;
}
return(list);
}
public void SetPreparationDocNumbers(List <AscmWmsMtlRequisitionMain> list)
{
if (list != null && list.Count > 0)
{
var ieIds = list.Select(P => P.id).Distinct();
var count = ieIds.Count();
string ids = string.Empty;
for (int i = 0; i < count; i++)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += ieIds.ElementAt(i);
}
if (!string.IsNullOrEmpty(ids))
{
string hql = "from AscmWmsMtlReqMainLink where reqMainLinkPK.reqMainId in(" + ids + ")";
IList <AscmWmsMtlReqMainLink> ilistReqMainLink = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWmsMtlReqMainLink>(hql);
if (ilistReqMainLink != null && ilistReqMainLink.Count > 0)
{
List <AscmWmsMtlReqMainLink> listReqMainLink = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmWmsMtlReqMainLink>(ilistReqMainLink);
hql = "from AscmWmsPreparationMain where id in(" + " select reqMainLinkPK.preMainId from AscmWmsMtlReqMainLink where reqMainLinkPK.reqMainId in(" + ids + ") )";
IList <AscmWmsPreparationMain> ilistPreparationMain = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWmsPreparationMain>(hql);
if (ilistPreparationMain != null && ilistPreparationMain.Count > 0)
{
List <AscmWmsPreparationMain> listPreparationMain = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmWmsPreparationMain>(ilistPreparationMain);
foreach (AscmWmsMtlRequisitionMain requisitionMain in list)
{
requisitionMain.preparationDocNumbers
= string.Join(",", listPreparationMain.Where(P =>
listReqMainLink.Where(T => T.reqMainLinkPK.reqMainId == requisitionMain.id).
Select(T => T.reqMainLinkPK.preMainId).Contains(P.id)).OrderBy(p => p.docNumber).
Select(P => P.docNumber));
}
}
}
}
}
}
public List <AscmDeliveryOrderDetail> GetList(int mainId)
{
List <AscmDeliveryOrderDetail> list = null;
try
{
string sort = " order by id ";
//if (!string.IsNullOrEmpty(sortName))
//{
// sort = " order by " + sortName.Trim() + " ";
// if (!string.IsNullOrEmpty(sortOrder))
// sort += sortOrder.Trim();
//}
string sql = "from AscmDeliveryOrderDetail where mainId=" + mainId;
string where = "", whereQueryWord = "";
//if (!string.IsNullOrEmpty(queryWord))
// whereQueryWord = " (name like '%" + queryWord.Trim() + "%' or description like '%" + queryWord.Trim() + "%')";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
//where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereOther);
if (!string.IsNullOrEmpty(where))
{
sql += " and " + where;
}
//IList<AscmDeliveryOrderDetail> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmDeliveryOrderDetail>(sql + sort);
IList <AscmDeliveryOrderDetail> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmDeliveryOrderDetail>(sql + sort);
if (ilist != null)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmDeliveryOrderDetail>(ilist);
SetMain(list);
SetMaterial(list);
SetNotifyDetail(list);
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmDeliveryOrderDetail)", ex);
throw ex;
}
return(list);
}
public List <AscmContainerDelivery> GetCurrentList(string containerSn)
{
List <AscmContainerDelivery> list = null;
try
{
string sort = " order by id desc ";
string sql = "from AscmContainerDelivery where containerSn='" + containerSn + "'";
//IList<AscmContainerDelivery> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmContainerDelivery>(sql);
YnPage ynPage = new YnPage();
ynPage.SetPageSize(1);
ynPage.SetCurrentPage(1);
IList <AscmContainerDelivery> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmContainerDelivery>(sql + sort, sql, ynPage);
if (ilist != null && ilist.Count > 0)
{
foreach (AscmContainerDelivery ascmContainerDelivery in ilist)
{
ascmContainerDelivery.ascmDeliBatSumMain = AscmDeliBatSumMainService.GetInstance().Get(ascmContainerDelivery.batSumMainId);
ascmContainerDelivery.ascmDeliveryOrderBatch = AscmDeliveryOrderBatchService.GetInstance().Get(ascmContainerDelivery.deliveryOrderBatchId);
}
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmContainerDelivery>(ilist);
//AscmDeliBatSumMain ascmDeliBatSumMain = AscmDeliBatSumMainService.GetInstance().Get(ilist[0].batSumMainId);
//if (ascmDeliBatSumMain != null &&( ascmDeliBatSumMain.status == AscmDeliBatSumMain.StatusDefine.outPlant||ascmDeliBatSumMain.status == AscmDeliBatSumMain.StatusDefine.confirm))
//{
// sql = "from AscmContainerDelivery where batSumMainId =" + ilist[0].batSumMainId + " and containerSn='" + containerSn + "'";
// ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmContainerDelivery>(sql);
// if (ilist != null)
// {
// list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList<AscmContainerDelivery>(ilist);
// }
//}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmContainerDelivery)", ex);
throw ex;
}
return(list);
}
public List <AscmCuxWipReleaseLines> GetList(string whereOther, bool isSetMaterial = false,
bool isSetWipRequirementOperations = false, bool isSetWipReleaseHeader = false)
{
List <AscmCuxWipReleaseLines> list = null;
try
{
string sort = " order by inventoryItemId ";
string sql = "from AscmCuxWipReleaseLines";
string where = "";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereOther);
if (!string.IsNullOrEmpty(where))
{
sql += " where " + where;
}
IList <AscmCuxWipReleaseLines> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmCuxWipReleaseLines>(sql + sort);
if (ilist != null)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmCuxWipReleaseLines>(ilist);
if (isSetWipReleaseHeader)
{
SetWipReleaseHeader(list);
}
if (isSetMaterial)
{
SetMaterial(list);
}
if (isSetWipRequirementOperations)
{
SetWipRequirementOperations(list);
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmCuxWipReleaseLines)", ex);
throw ex;
}
return(list);
}
public void Update(AscmContainerDelivery ascmContainerDelivery, int readingHeadId, string sessionKey)
{
try
{
AscmContainer ascmContainer = null;
if (!string.IsNullOrEmpty(ascmContainerDelivery.containerSn))
{
ascmContainer = YnDaoHelper.GetInstance().nHibernateHelper.Get <AscmContainer>(ascmContainerDelivery.containerSn, sessionKey);
if (ascmContainer != null)
{
ascmContainer.place = readingHeadId.ToString();
ascmContainer.storeInTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
}
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession(sessionKey).BeginTransaction())
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Update <AscmContainerDelivery>(ascmContainerDelivery, sessionKey);
if (ascmContainer != null)
{
YnDaoHelper.GetInstance().nHibernateHelper.Update <AscmContainer>(ascmContainer, sessionKey);
}
tx.Commit();//正确执行提交
}
catch (Exception ex)
{
tx.Rollback();//回滚
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmContainerDelivery)", ex);
throw ex;
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Save AscmContainerDelivery)", ex);
throw ex;
}
}
public string GetUserLogisticsName(string userName, string userRole)
{
string logisticsName = string.Empty;
try
{
if (userRole != "领料员" && !string.IsNullOrEmpty(userRole))
{
string sql = "from AscmLogisticsClassInfo";
string where = "", whereQueryWord = "";
whereQueryWord = "groupLeader ='" + userName + "'";
where = YnBaseClass2.Helper.StringHelper.SqlWhereOrAdd(where, whereQueryWord);
whereQueryWord = "monitorLeader = '" + userName + "'";
where = YnBaseClass2.Helper.StringHelper.SqlWhereOrAdd(where, whereQueryWord);
if (!string.IsNullOrEmpty(where))
{
sql += " where " + where;
IList <AscmLogisticsClassInfo> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmLogisticsClassInfo>(sql);
if (ilist != null && ilist.Count > 0)
{
List <AscmLogisticsClassInfo> list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmLogisticsClassInfo>(ilist);
foreach (AscmLogisticsClassInfo ascmLogisticsClassInfo in list)
{
if (!string.IsNullOrEmpty(logisticsName))
{
logisticsName += ",";
}
logisticsName += "'" + ascmLogisticsClassInfo.logisticsClass + "'";
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(logisticsName);
}
public List <AscmGenerateTaskRule> GetList(string sql)
{
List <AscmGenerateTaskRule> list = null;
try
{
IList <AscmGenerateTaskRule> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmGenerateTaskRule>(sql);
if (ilist != null && ilist.Count > 0)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmGenerateTaskRule>(ilist);
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmGenerateTaskRule)", ex);
throw ex;
}
return(list);
}
public List <AscmContainerUnitQuantity> GetList(int supplierId, string materialDocNumber)
{
List <AscmContainerUnitQuantity> list = null;
try
{
string sql = "from AscmContainerUnitQuantity where materialDocNumber='" + materialDocNumber + "' and supplierId =" + supplierId;
IList <AscmContainerUnitQuantity> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmContainerUnitQuantity>(sql);
if (ilist != null)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmContainerUnitQuantity>(ilist);
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmContainerUnitQuantity)", ex);
throw ex;
}
return(list);
}
public void SetScheduleGroups(List <AscmCuxWipReleaseHeaders> list)
{
if (list != null && list.Count > 0)
{
string sql = "from AscmWipScheduleGroups where scheduleGroupId in (" + string.Join(",", list.Select(P => P.scheduleGroupId).Distinct()) + ")";
IList <AscmWipScheduleGroups> ilistAscmWipScheduleGroups = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWipScheduleGroups>(sql);
if (ilistAscmWipScheduleGroups != null && ilistAscmWipScheduleGroups.Count > 0)
{
List <AscmWipScheduleGroups> listAscmWipScheduleGroups = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmWipScheduleGroups>(ilistAscmWipScheduleGroups);
foreach (AscmCuxWipReleaseHeaders cuxWipReleaseHeaders in list)
{
AscmWipScheduleGroups wipScheduleGroups = listAscmWipScheduleGroups.Find(e => e.scheduleGroupId == cuxWipReleaseHeaders.scheduleGroupId);
if (wipScheduleGroups != null)
{
cuxWipReleaseHeaders.scheduleGroupName = wipScheduleGroups.scheduleGroupName;
}
}
}
}
}
public AscmBuildingWarehouseLink Get(int buildingId, string warehouseId)
{
AscmBuildingWarehouseLink ascmBuildingWarehouseLink = null;
try
{
string sql = "from AscmBuildingWarehouseLink where buildingId=" + buildingId + " and warehouseId='" + warehouseId + "'";
IList <AscmBuildingWarehouseLink> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmBuildingWarehouseLink>(sql);
if (ilist != null && ilist.Count > 0)
{
ascmBuildingWarehouseLink = ilist[0];
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmBuildingWarehouseLink)", ex);
throw ex;
}
return(ascmBuildingWarehouseLink);
}
public AscmContainer GetAllInfo(string sn)
{
AscmContainer ascmContainer = null;
try
{
ascmContainer = YnDaoHelper.GetInstance().nHibernateHelper.Get <AscmContainer>(sn);
if (ascmContainer != null)
{
ascmContainer.SpecName = MideaAscm.Services.SupplierPreparation.AscmContainerSpecService.GetInstance().Get(ascmContainer.specId).spec;
ascmContainer.supplier = MideaAscm.Services.Base.AscmSupplierService.GetInstance().Get(ascmContainer.supplierId);
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmContainer)", ex);
throw ex;
}
return(ascmContainer);
}
/// <summary>
///
/// </summary>
/// <param name="docNumber"></param>
/// <param name="direction"></param>
/// <returns></returns>
public List <AscmStoreInOut> GetReportList(string docNumber, string direction)
{
string strHql = "select b.specId, b.supplierId, count(b.specId), a.direction from AscmStoreInOut as a,AscmContainer as b where a.containerId=b.sn and a.docNumber='" + docNumber + "' GROUP BY b.supplierId, b.specId, a.direction";
List <AscmStoreInOut> st = new List <AscmStoreInOut>();
System.Collections.IList ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find(strHql);
if (ilist.Count != 0)
{
foreach (object[] obj in ilist)
{
foreach (object[] obj2 in YnDaoHelper.GetInstance().nHibernateHelper.Find("select name, docNumber from AscmSupplier where id=" + obj[1].ToString() + ""))
{
st.Add(new AscmStoreInOut {
docNumber = obj[5].ToString(), direction = obj[4].ToString(), createUser = obj[3].ToString(), supplierName = obj2[0].ToString(), specCount = Convert.ToInt32(obj[2].ToString()), specName = YnDaoHelper.GetInstance().nHibernateHelper.GetObject("select spec from AscmContainerSpec where id=" + obj[0].ToString() + "").ToString(), supplierDoc = obj2[1].ToString()
});
}
}
}
return(st);
}
/// <summary>手持登录</summary>
public AscmUserInfo TryGet2(string userId)
{
AscmUserInfo ascmUserInfo = null;
try
{
string sql = "from AscmUserInfo where extExpandId='" + userId + "'";
IList <AscmUserInfo> ilist = YnDaoHelper.GetInstance().nHibernateHelper.FindTop <AscmUserInfo>(sql, 1);
if (ilist != null && ilist.Count > 0)
{
ascmUserInfo = ilist[0];
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmUserInfo)", ex);
throw ex;
}
return(ascmUserInfo);
}
public AscmReadingHeadLog GetAddLog(int readingHeadId, string rfid, string sn, DateTime createTime, bool processed, string sessionKey = null)
{
try
{
DateTime dtServerTime = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentDate("AscmReadingHead", sessionKey);
AscmReadingHeadLog ascmReadingHeadLog = new AscmReadingHeadLog();
ascmReadingHeadLog.readingHeadId = readingHeadId;
ascmReadingHeadLog.rfid = rfid;
ascmReadingHeadLog.sn = sn;
ascmReadingHeadLog.createTime = createTime.ToString("yyyy-MM-dd HH:mm:ss");
ascmReadingHeadLog.modifyTime = dtServerTime.ToString("yyyy-MM-dd HH:mm:ss");
ascmReadingHeadLog.processed = processed;
return(ascmReadingHeadLog);
}
catch (Exception ex)
{
throw ex;
}
}
public void Save(AscmWmsLogisticsMainLog wmsLogisticsMainLog, List <WmsAndLogistics> listWmsAndLogistics)
{
try
{
int maxId_Detail = YnDaoHelper.GetInstance().nHibernateHelper.GetMaxId("select max(id) from AscmWmsLogisticsDetailLog");
List <AscmWmsLogisticsDetailLog> listWmsLogisticsDetailLog = new List <AscmWmsLogisticsDetailLog>();
foreach (WmsAndLogistics wmsAndLogistics in listWmsAndLogistics)
{
AscmWmsLogisticsDetailLog wmsLogisticsDetailLog = new AscmWmsLogisticsDetailLog();
wmsLogisticsDetailLog.id = ++maxId_Detail;
wmsLogisticsDetailLog.mainId = wmsLogisticsMainLog.id;
wmsLogisticsDetailLog.wipEntityId = wmsAndLogistics.wipEntityId;
wmsLogisticsDetailLog.materialId = wmsAndLogistics.materialId;
wmsLogisticsDetailLog.quantity = wmsAndLogistics.quantity;
wmsLogisticsDetailLog.preparationString = wmsAndLogistics.preparationString;
wmsLogisticsDetailLog.workerId = wmsAndLogistics.workerId;
listWmsLogisticsDetailLog.Add(wmsLogisticsDetailLog);
}
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction())
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Save(wmsLogisticsMainLog);
YnDaoHelper.GetInstance().nHibernateHelper.SaveList(listWmsLogisticsDetailLog);
tx.Commit();//正确执行提交
}
catch (Exception ex)
{
tx.Rollback();//回滚
throw ex;
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("保存失败(Save AscmWmsLogisticsMainLog)", ex);
throw ex;
}
}
public List <AscmDeliveryOrderDetail> GetListByBatch(List <AscmDeliveryOrderBatch> ListAscmDeliveryOrderBatch)
{
List <AscmDeliveryOrderDetail> list = null;
try
{
string whereIds = "";
foreach (AscmDeliveryOrderBatch ascmDeliveryOrderBatch in ListAscmDeliveryOrderBatch)
{
if (!string.IsNullOrEmpty(whereIds))
{
whereIds += ",";
}
whereIds += ascmDeliveryOrderBatch.id;
}
string sql = "from AscmDeliveryOrderDetail where mainId in (select id from AscmDeliveryOrderMain where batchId in (" + whereIds + "))";
string where = "", whereQueryWord = "";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
if (!string.IsNullOrEmpty(where))
{
sql += " and " + where;
}
IList <AscmDeliveryOrderDetail> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmDeliveryOrderDetail>(sql);
if (ilist != null)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmDeliveryOrderDetail>(ilist);
SetNotifyDetail(list);
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmDeliveryOrderDetail)", ex);
throw ex;
}
return(list);
}
public void SetWipEntities(List <AscmWmsPreparationDetail> list)
{
if (list == null || list.Count == 0)
{
return;
}
var wipEntityIds = list.Select(P => P.wipEntityId).Distinct();
var count = wipEntityIds.Count();
string ids = string.Empty;
for (int i = 0; i < count; i++)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += wipEntityIds.ElementAt(i);
if ((i + 1) % 500 == 0 || (i + 1) == count)
{
if (!string.IsNullOrEmpty(ids))
{
string sql = "from AscmWipEntities where wipEntityId in (" + ids + ")";
IList <AscmWipEntities> ilistAscmWipEntities = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWipEntities>(sql);
if (ilistAscmWipEntities != null && ilistAscmWipEntities.Count > 0)
{
List <AscmWipEntities> listAscmWipEntities = ilistAscmWipEntities.ToList();
foreach (AscmWmsPreparationDetail ascmWmsPreparationDetail in list)
{
AscmWipEntities ascmWipEntities = listAscmWipEntities.Find(P => P.wipEntityId == ascmWmsPreparationDetail.wipEntityId);
if (ascmWipEntities != null)
{
ascmWmsPreparationDetail.wipEntityName = ascmWipEntities.name;
}
}
}
}
ids = string.Empty;
}
}
}
public void SetMaterial(List <AscmDeliveryOrderBatch> list)
{
if (list == null || list.Count == 0)
{
return;
}
var materialIds = list.Select(P => P.materialIdTmp).Distinct();
var count = materialIds.Count();
string ids = string.Empty;
for (int i = 0; i < count; i++)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += materialIds.ElementAt(i);
if ((i + 1) % 500 == 0 || (i + 1) == count)
{
if (!string.IsNullOrEmpty(ids))
{
string hql = "from AscmMaterialItem where id in (" + ids + ")";
IList <AscmMaterialItem> ilistMaterialItem = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmMaterialItem>(hql);
if (ilistMaterialItem != null && ilistMaterialItem.Count > 0)
{
List <AscmMaterialItem> listMaterialItem = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmMaterialItem>(ilistMaterialItem);
foreach (AscmDeliveryOrderBatch deliveryOrderBatch in list)
{
AscmMaterialItem materialItem = listMaterialItem.Find(P => P.id == deliveryOrderBatch.materialIdTmp);
if (materialItem != null)
{
deliveryOrderBatch.ascmMaterialItem = materialItem;
}
}
}
}
ids = string.Empty;
}
}
}
/// <summary>设置作业备料单已领数量</summary>
public void SetReceivedQuantity(int wipEntityId, List <AscmWmsPreparationDetail> list)
{
if (list == null && list.Count == 0)
{
return;
}
var materialIds = list.Select(P => P.materialId).Distinct();
var count = materialIds.Count();
string ids = string.Empty;
for (int i = 0; i < count; i++)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += materialIds.ElementAt(i);
if ((i + 1) % 500 == 0 || (i + 1) == count)
{
if (!string.IsNullOrEmpty(ids))
{
string hql = "select new AscmWmsLogisticsDetailLog(" + wipEntityId + ",materialId,sum(quantity)) from AscmWmsLogisticsDetailLog where wipEntityId=" + wipEntityId + " and materialId in (" + ids + ") group by materialId";
IList <AscmWmsLogisticsDetailLog> ilistLogisticsDetailLog = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWmsLogisticsDetailLog>(hql);
if (ilistLogisticsDetailLog != null && ilistLogisticsDetailLog.Count > 0)
{
List <AscmWmsLogisticsDetailLog> listLogisticsDetailLog = ilistLogisticsDetailLog.ToList();
foreach (AscmWmsPreparationDetail preparationDetail in list)
{
AscmWmsLogisticsDetailLog logisticsDetailLog = listLogisticsDetailLog.Find(P => P.materialId == preparationDetail.materialId);
if (logisticsDetailLog != null)
{
preparationDetail.receivedQuantity = logisticsDetailLog.quantity;
}
}
}
}
ids = string.Empty;
}
}
}
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 List <AscmContainerDelivery> GetList(int?batSumMainId)
{
List <AscmContainerDelivery> list = null;
try
{
string sql = "from AscmContainerDelivery where batSumMainId=" + batSumMainId;
IList <AscmContainerDelivery> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmContainerDelivery>(sql);
if (ilist != null)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmContainerDelivery>(ilist);
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmContainerDelivery)", ex);
throw ex;
}
return(list);
}
public List <AscmGetMaterialTask> TaskDetailStatisticsList(string strWorkId)
{
List <AscmGetMaterialTask> list = null;
try
{
string sort = " order by id ";
string strHql = "from AscmGetMaterialTask where workerId='" + strWorkId + "'";
IList <AscmGetMaterialTask> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmGetMaterialTask>(strHql + sort);
if (ilist != null)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmGetMaterialTask>(ilist);
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmDeliveryOrderDetail)", ex);
throw ex;
}
return(list);
}
