public void SetWipEntities(List <AscmMarkTaskLog> list)
{
if (list != null && list.Count > 0)
{
string ids = string.Empty;
foreach (AscmMarkTaskLog ascmMarkTaskLog in list)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += ascmMarkTaskLog.wipEntityId;
}
string where = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "wipentityid");
string sql = "from AscmWipEntities";
if (!string.IsNullOrEmpty(where))
{
sql += " where " + where;
IList <AscmWipEntities> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWipEntities>(sql);
if (ilist != null && ilist.Count > 0)
{
List <AscmWipEntities> listAscmMarkTaskLog = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmWipEntities>(ilist);
foreach (AscmMarkTaskLog ascmMarkTaskLog in list)
{
ascmMarkTaskLog.ascmWipEntities = listAscmMarkTaskLog.Find(e => e.wipEntityId.ToString() == ascmMarkTaskLog.wipEntityId.ToString());
}
}
}
}
}
public void SetWipEntities(List <AscmDiscreteJobs> list)
{
if (list != null && list.Count > 0)
{
string ids = string.Empty;
foreach (AscmDiscreteJobs ascmDiscreteJobs in list)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += "'" + ascmDiscreteJobs.jobId + "'";
}
string sql = "from AscmWipEntities";
string where = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "name");
if (!string.IsNullOrEmpty(where))
{
sql += " where " + where;
}
IList <AscmWipEntities> ilistAscmWipEntities = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWipEntities>(sql);
if (ilistAscmWipEntities != null && ilistAscmWipEntities.Count > 0)
{
List <AscmWipEntities> listAscmWipEntities = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmWipEntities>(ilistAscmWipEntities);
foreach (AscmDiscreteJobs ascmDiscreteJobs in list)
{
ascmDiscreteJobs.ascmWipEntities = listAscmWipEntities.Find(e => e.name == ascmDiscreteJobs.jobId);
}
}
}
}
public void SetDRanker(List <AscmAllocateRule> list)
{
if (list != null && list.Count > 0)
{
string ids = string.Empty;
foreach (AscmAllocateRule ascmAllocateRule in list)
{
if ((!string.IsNullOrEmpty(ids)) && (!string.IsNullOrEmpty(ascmAllocateRule.dRankerName)))
{
ids += ",";
}
if (!string.IsNullOrEmpty(ascmAllocateRule.dRankerName))
{
ids += "'" + ascmAllocateRule.dRankerName + "'";
}
}
string where = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "userId");
if (!string.IsNullOrEmpty(where))
{
string sql = "from AscmUserInfo where " + where;
IList <AscmUserInfo> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmUserInfo>(sql);
if (ilist != null && ilist.Count > 0)
{
List <AscmUserInfo> listAscmUserInfo = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmUserInfo>(ilist);
foreach (AscmAllocateRule ascmAllocateRule in list)
{
if (!string.IsNullOrEmpty(ascmAllocateRule.dRankerName))
{
ascmAllocateRule.ascmUserInfoDRanker = listAscmUserInfo.Find(e => e.userId == ascmAllocateRule.dRankerName);
}
}
}
}
}
}
public void SetGetMaterialTask(List <AscmMarkTaskLog> list)
{
if (list != null && list.Count > 0)
{
string ids = string.Empty;
foreach (AscmMarkTaskLog ascmMarkTaskLog in list)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += ascmMarkTaskLog.taskId;
}
string where = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "id");
string sql = "from AscmGetMaterialTask";
if (!string.IsNullOrEmpty(where))
{
sql += " where " + where;
IList <AscmGetMaterialTask> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmGetMaterialTask>(sql);
if (ilist != null && ilist.Count > 0)
{
List <AscmGetMaterialTask> listAscmGetMaterialTask = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmGetMaterialTask>(ilist);
foreach (AscmMarkTaskLog ascmMarkTaskLog in list)
{
ascmMarkTaskLog.ascmGetMaterialTask = listAscmGetMaterialTask.Find(e => e.id == ascmMarkTaskLog.taskId);
}
}
}
}
}
private void SetMaterialCategory(List <AscmMaterialSubCategory> list)
{
if (list != null && list.Count > 0)
{
string ids = string.Empty;
foreach (AscmMaterialSubCategory ascmMaterialSubCategory in list)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += "" + ascmMaterialSubCategory.categoryId + "";
}
string where = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "id");
if (!string.IsNullOrEmpty(where))
{
string sql = "from AscmMaterialCategory where " + where;
IList <AscmMaterialCategory> ilistAscmMaterialCategory = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmMaterialCategory>(sql);
if (ilistAscmMaterialCategory != null && ilistAscmMaterialCategory.Count > 0)
{
List <AscmMaterialCategory> listAscmMaterialCategory = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmMaterialCategory>(ilistAscmMaterialCategory);
foreach (AscmMaterialSubCategory ascmMaterialSubCategory in list)
{
ascmMaterialSubCategory.ascmMaterialCategory = listAscmMaterialCategory.Find(e => e.id == ascmMaterialSubCategory.categoryId);
}
}
}
}
}
public void SetLogisticsClass(List <AscmAllocateRule> list)
{
if (list != null && list.Count > 0)
{
string ids = string.Empty;
foreach (AscmAllocateRule ascmAllocateRule in list)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += ascmAllocateRule.logisticsClassId;
}
string where = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "id");
string sql = "from AscmLogisticsClassInfo";
if (!string.IsNullOrEmpty(where))
{
sql += " where " + where;
IList <AscmLogisticsClassInfo> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmLogisticsClassInfo>(sql);
if (ilist != null && ilist.Count > 0)
{
List <AscmLogisticsClassInfo> listAscmLogisticsClassInfo = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmLogisticsClassInfo>(ilist);
foreach (AscmAllocateRule ascmAllocateRule in list)
{
if (!string.IsNullOrEmpty(ascmAllocateRule.logisticsClassId.ToString()) && ascmAllocateRule.logisticsClassId != 0)
{
ascmAllocateRule.ascmLogisticsClassInfo = listAscmLogisticsClassInfo.Find(e => e.id == ascmAllocateRule.logisticsClassId);
}
}
}
}
}
}
public void SetRanker(List <AscmDiscreteJobs> list)
{
if (list != null && list.Count > 0)
{
string ids = string.Empty;
foreach (AscmDiscreteJobs ascmDiscreteJobs in list)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += "'" + ascmDiscreteJobs.workerId + "'";
}
string where = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "userId");
if (!string.IsNullOrEmpty(where))
{
string sql = "from YnUser where " + where;
IList <YnUser> ilist = YnFrame.Dal.YnDaoHelper.GetInstance().nHibernateHelper.Find <YnUser>(sql);
if (ilist != null && ilist.Count > 0)
{
List <YnUser> listYnUser = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <YnUser>(ilist);
foreach (AscmDiscreteJobs ascmDiscreteJobs in list)
{
ascmDiscreteJobs.ynUser = listYnUser.Find(e => e.userId == ascmDiscreteJobs.workerId);
}
}
}
}
}
public void SetMonitorLeader(List <AscmLogisticsClassInfo> list)
{
if (list != null && list.Count > 0)
{
string ids = string.Empty;
foreach (AscmLogisticsClassInfo ascmLogisticsClassInfo in list)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
if (!string.IsNullOrEmpty(ascmLogisticsClassInfo.monitorLeader))
{
ids += "'" + ascmLogisticsClassInfo.monitorLeader + "'";
}
}
string where = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "userId");
if (!string.IsNullOrEmpty(where))
{
string sql = "from AscmUserInfo where " + where;
IList <AscmUserInfo> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmUserInfo>(sql);
if (ilist != null && ilist.Count > 0)
{
List <AscmUserInfo> listUser = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmUserInfo>(ilist);
foreach (AscmLogisticsClassInfo ascmLogisticsClassInfo in list)
{
ascmLogisticsClassInfo.monitorUser = listUser.Find(e => e.userId == ascmLogisticsClassInfo.monitorLeader);
}
}
}
}
}
public static AscmCommonHelperService GetInstance()
{
if (service == null)
{
service = new AscmCommonHelperService();
}
return(service);
}
public void SetLogisticsClassName(List <AscmAllocateRule> list)
{
if (list != null && list.Count > 0)
{
foreach (AscmAllocateRule ascmAllocateRule in list)
{
ascmAllocateRule.logisticsClassName = AscmCommonHelperService.GetInstance().DisplayLogisticsClass(ascmAllocateRule.logisticsClass);
}
}
}
public string getTaskId(int number)
{
string autoTask = AscmCommonHelperService.GetInstance().GetConfigTaskWords(0);
int a = number / 1000;
int b = (number - a * 1000) / 100;
int c = (number - a * 1000 - b * 100) / 10;
int d = (number - a * 1000 - b * 100 - c * 10);
return(autoTask + a.ToString() + b.ToString() + c.ToString() + d.ToString());
}
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 static AscmCommonHelperService GetInstance()
{
if (service == null)
service = new AscmCommonHelperService();
return service;
}
//public List<AscmForklift> GetList(YnPage ynPage, string sortName, string sortOrder, string queryWord, string queryOtherWord)
//{
// List<AscmForklift> 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 AscmForklift";
// string where = "", whereQueryWord = "";
// if (!string.IsNullOrEmpty(queryWord))
// {
// whereQueryWord = "forkliftType = '" + queryWord.Trim() + "'";
// where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
// }
// if (!string.IsNullOrEmpty(queryOtherWord))
// {
// string sSql = " from YnUser where userName like '" + queryOtherWord + "%'";
// IList<YnUser> ilistYnUser = YnFrame.Dal.YnDaoHelper.GetInstance().nHibernateHelper.Find<YnUser>(sSql);
// if (ilistYnUser != null && ilistYnUser.Count > 0)
// {
// queryOtherWord = "";
// foreach (YnUser ynUser in ilistYnUser)
// {
// if (!string.IsNullOrEmpty(queryOtherWord))
// queryOtherWord += ",";
// queryOtherWord += "'" + ynUser.userName + "'";
// }
// }
// whereQueryWord = "workerId in (" + queryOtherWord + ")";
// where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
// }
// if (!string.IsNullOrEmpty(where))
// sql += " where " + where;
// IList<AscmForklift> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmForklift>(sql, sql, ynPage);
// if (ilist != null)
// {
// list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList<AscmForklift>(ilist);
// SetWorker(list);
// }
// }
// catch (Exception ex)
// {
// YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmForklift)",ex);
// throw ex;
// }
// return list;
//}
public List <AscmForklift> GetList(YnPage ynPage, string sortName, string sortOrder, string queryWord, string whereOther, bool isSetWorker = true)
{
List <AscmForklift> 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 AscmForklift";
string where = "", whereQueryWord = "";
if (!string.IsNullOrEmpty(queryWord))
{
string whereOtherWord = "";
whereQueryWord = "userName like '" + queryWord + "%'";
List <AscmUserInfo> listAscmUserInfo = AscmUserInfoService.GetInstance().GetList(null, "", "", "", whereQueryWord);
string ids = string.Empty;
if (listAscmUserInfo != null && listAscmUserInfo.Count > 0)
{
foreach (AscmUserInfo ascmUserInfo in listAscmUserInfo)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += ascmUserInfo.userId;
}
whereQueryWord = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "workerId");
whereOtherWord = YnBaseClass2.Helper.StringHelper.SqlWhereOrAdd(whereOtherWord, whereQueryWord);
}
whereQueryWord = "forkliftNumber like '%" + queryWord + "%'";
whereOtherWord = YnBaseClass2.Helper.StringHelper.SqlWhereOrAdd(whereOtherWord, whereQueryWord);
whereQueryWord = "assetsId like '%" + queryWord + "%'";
whereOtherWord = YnBaseClass2.Helper.StringHelper.SqlWhereOrAdd(whereOtherWord, whereQueryWord);
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereOtherWord);
}
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereOther);
if (!string.IsNullOrEmpty(where))
{
sql += " where " + where;
}
if (!string.IsNullOrEmpty(sort))
{
sql += sort;
}
IList <AscmForklift> ilist = null;
if (ynPage != null)
{
ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmForklift>(sql, sql, ynPage);
}
else
{
ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmForklift>(sql);
}
if (ilist != null && ilist.Count > 0)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmForklift>(ilist);
if (isSetWorker)
{
SetWorker(list);
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmForklift)", ex);
throw ex;
}
return(list);
}
public List <AscmDiscreteJobs> GetList(YnPage ynPage, string sortName, string sortOrder, string queryWord, string queryStartTime, string queryEndTime, string queryType, string queryRanker, string userName)
{
List <AscmDiscreteJobs> list = null;
try
{
string sort = "", whereQueryWord = "", where = "", where_Param = "";
string userRole = AscmUserInfoService.GetInstance().GetUserRoleName(userName);
string userLogisticsName = AscmUserInfoService.GetInstance().GetUserLogisticsName(userName, userRole);
string hql = "from AscmDiscreteJobs";
string hql_ParamZ = "select zRankerName from AscmAllocateRule";
string hql_ParamD = "select dRankerName from AscmAllocateRule";
string sql = "select * from ASCM_DISCRETE_JOBS";
if (userRole == "领料员")
{
whereQueryWord = "workerName = '" + userName + "'";
where_Param = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where_Param, whereQueryWord);
}
else if (userRole == "总装排产员" || userRole == "电装排产员")
{
whereQueryWord = "workerId = '" + userName + "'";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
}
else
{
if (!string.IsNullOrEmpty(userLogisticsName))
{
IList <AscmLogisticsClassInfo> ilistAscmLogisticsClassInfo = AscmLogisticsClassInfoService.GetInstance().GetList("from AscmLogisticsClassInfo where logisticsClass in (" + userLogisticsName + ")", false, false);
string ids = string.Empty;
if (ilistAscmLogisticsClassInfo != null && ilistAscmLogisticsClassInfo.Count > 0)
{
foreach (AscmLogisticsClassInfo ascmlogisticsClassInfo in ilistAscmLogisticsClassInfo)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += ascmlogisticsClassInfo.id;
}
}
whereQueryWord = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "logisticsClassId");
where_Param = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where_Param, whereQueryWord);
}
}
if (!string.IsNullOrEmpty(where_Param))
{
string newCondition = string.Empty;
hql_ParamZ += " where " + where_Param;
hql_ParamZ = "workerId in (" + hql_ParamZ + ")";
newCondition = YnBaseClass2.Helper.StringHelper.SqlWhereOrAdd(newCondition, hql_ParamZ);
hql_ParamD += " where " + where_Param;
hql_ParamD = "workerId in (" + hql_ParamD + ")";
newCondition = YnBaseClass2.Helper.StringHelper.SqlWhereOrAdd(newCondition, hql_ParamD);
where += "(" + newCondition + ")";
}
if (!string.IsNullOrEmpty(queryType))
{
whereQueryWord = "identificationId = " + queryType;
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
}
if (!string.IsNullOrEmpty(queryStartTime) && !string.IsNullOrEmpty(queryEndTime))
{
queryStartTime = queryStartTime + " 00:00:00";
queryEndTime = queryEndTime + " 23:59:59";
whereQueryWord = "createTime > '" + queryStartTime + "'";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
whereQueryWord = "createTime <= '" + queryEndTime + "'";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
}
else if (!string.IsNullOrEmpty(queryStartTime) && string.IsNullOrEmpty(queryEndTime))
{
whereQueryWord = "createTime like '" + queryStartTime + "%'";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
}
else if (string.IsNullOrEmpty(queryStartTime) && !string.IsNullOrEmpty(queryEndTime))
{
whereQueryWord = "createTime like '" + queryEndTime + "%'";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
}
if (!string.IsNullOrEmpty(queryRanker))
{
whereQueryWord = "workerId = '" + queryRanker + "'";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
}
if (!string.IsNullOrEmpty(where))
{
hql += " where " + where;
sql += " where " + where;
}
sql = sql.Replace("AscmAllocateRule", "ASCM_ALLOCATE_RULE");
object object1 = YnDaoHelper.GetInstance().nHibernateHelper.GetObjectBySQL("select count(*) from (" + sql + ")");
int count = 0;
int.TryParse(object1.ToString(), out count);
IList <AscmDiscreteJobs> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmDiscreteJobs>(hql, count, ynPage);
if (ilist != null && ilist.Count > 0)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmDiscreteJobs>(ilist);
SetRanker(list);
list = list.OrderBy(e => e.workerId).OrderBy(e => e.productLine).OrderBy(e => e.sequence).OrderBy(e => e.identificationId).OrderBy(e => e.id).ToList();
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmDiscreteJobs)", ex);
throw ex;
}
return(list);
}
//public List<AscmDiscreteJobs> GetList(YnPage ynPage, string sortName, string sortOrder, string queryWord)
//{
// List<AscmDiscreteJobs> list = null;
// try
// {
// string sort = "";
// if (!string.IsNullOrEmpty(sortName))
// {
// sort = "order by " + sortName.Trim() + " " ;
// if (!string.IsNullOrEmpty(sortOrder))
// sort += sortOrder.Trim();
// }
// string sql = "from AscmDiscreteJobs";
// IList<AscmDiscreteJobs> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmDiscreteJobs>(sql + sort, sql, ynPage);
// if (ilist != null)
// {
// list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList<AscmDiscreteJobs>(ilist);
// }
// }
// catch (Exception ex)
// {
// YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmDiscreteJobs)", ex);
// throw ex;
// }
// return list;
//}
public List <AscmDiscreteJobs> GetList(YnPage ynpage, string sortName, string sortOrder, string queryWord, string queryDate, string queryType, string queryRanker, string userLogistisClass, string userRole, string userName)
{
List <AscmDiscreteJobs> list = null;
try
{
string sort = "", whereQueryWord = "", where = "";
string sql = "from AscmDiscreteJobs";
if (!string.IsNullOrEmpty(sortName))
{
sort = "order by " + sortName.Trim() + " ";
if (!string.IsNullOrEmpty(sortOrder))
{
sort += sortOrder.Trim();
}
}
if (!string.IsNullOrEmpty(queryDate))
{
whereQueryWord = "createTime like '%" + queryDate + "%'";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
}
if (!string.IsNullOrEmpty(queryType))
{
whereQueryWord = "identificationId = " + queryType;
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
}
if (!string.IsNullOrEmpty(userLogistisClass))
{
IList <AscmLogisticsClassInfo> ilistAscmLogisticsClassInfo = AscmLogisticsClassInfoService.GetInstance().GetList("from AscmLogisticsClassInfo where logisticsClass in (" + userLogistisClass + ")", false, false);
string ids = string.Empty;
if (ilistAscmLogisticsClassInfo != null && ilistAscmLogisticsClassInfo.Count > 0)
{
foreach (AscmLogisticsClassInfo ascmlogisticsClassInfo in ilistAscmLogisticsClassInfo)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += ascmlogisticsClassInfo.id;
}
}
string newCondition = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "logisticsClassId");
if (!string.IsNullOrEmpty(newCondition))
{
string newsql = "from AscmAllocateRule where " + newCondition;
IList <AscmAllocateRule> ilistAscmAllocateRule = AscmAllocateRuleService.GetInstance().GetList(newsql, false, false, false);
ids = "";
if (ilistAscmAllocateRule != null && ilistAscmAllocateRule.Count > 0)
{
foreach (AscmAllocateRule ascmAllocateRule in ilistAscmAllocateRule)
{
if (!string.IsNullOrEmpty(ids) && (!string.IsNullOrEmpty(ascmAllocateRule.zRankerName) || !string.IsNullOrEmpty(ascmAllocateRule.dRankerName)))
{
ids += ",";
}
if (!string.IsNullOrEmpty(ascmAllocateRule.zRankerName))
{
ids += "'" + ascmAllocateRule.zRankerName + "'";
}
if (!string.IsNullOrEmpty(ids) && !string.IsNullOrEmpty(ascmAllocateRule.dRankerName))
{
ids += ",";
}
if (!string.IsNullOrEmpty(ascmAllocateRule.dRankerName))
{
ids += "'" + ascmAllocateRule.dRankerName + "'";
}
}
}
if (string.IsNullOrEmpty(queryRanker))
{
whereQueryWord = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "workerId");
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
}
else
{
if (ids.IndexOf(queryRanker) > -1)
{
whereQueryWord = "workerId like '%" + queryRanker + "%'";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
}
else
{
whereQueryWord = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "workerId");
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
}
}
}
}
else
{
if (userRole == "总装排产员" || userRole == "电装排产员")
{
whereQueryWord = "workerId = '" + userName + "'";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
}
else if (userRole == "领料员")
{
string newsql = "from AscmAllocateRule where workerName = '" + userName + "'";
string ids = string.Empty;
IList <AscmAllocateRule> ilistAscmAllocateRule = AscmAllocateRuleService.GetInstance().GetList(newsql, false, false, false);
if (ilistAscmAllocateRule != null && ilistAscmAllocateRule.Count > 0)
{
foreach (AscmAllocateRule ascmAllocateRule in ilistAscmAllocateRule)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
if (!string.IsNullOrEmpty(ascmAllocateRule.zRankerName))
{
ids += "'" + ascmAllocateRule.zRankerName + "'";
}
if (!string.IsNullOrEmpty(ascmAllocateRule.dRankerName))
{
ids += "'" + ascmAllocateRule.dRankerName + "'";
}
}
}
whereQueryWord = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "workerId");
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
}
}
if (!string.IsNullOrEmpty(where))
{
sql += " where " + where + " order by workerId,workerId,productLine,sequence,id";
IList <AscmDiscreteJobs> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmDiscreteJobs>(sql, sql, ynpage);
if (ilist != null && ilist.Count > 0)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmDiscreteJobs>(ilist);
SetRanker(list);
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmDiscreteJobs)", ex);
throw ex;
}
return(list);
}
/// <summary>
/// 关联作业@2014-04-22
/// </summary>
/// <param name="ynPage"></param>
/// <param name="sortName"></param>
/// <param name="sortOrder"></param>
/// <param name="queryWord"></param>
/// <param name="queryStartTime"></param>
/// <param name="queryEndTime"></param>
/// <param name="materialId"></param>
/// <returns></returns>
public List <AscmDiscreteJobs> GetRelatedDiscreteJobs(YnPage ynPage, string sortName, string sortOrder, string queryWord, string queryStartTime, string queryEndTime, int materialId)
{
List <AscmDiscreteJobs> list = null;
try
{
//string hql_ParamData = "from AscmWipRequirementOperations where wipentityId in (select t1.wipentityId from AscmWipEntities t1, AscmDiscreteJobs t2 where t1.name = t2.jobId and t2.createTime > '{0}' and t2.createTime <= '{1}') and inventoryItemId = {2}";
string hql_ParamData = "select new AscmWipRequirementOperations(t1.wipEntityId) from AscmWipRequirementOperations t1, AscmWipEntities t2, AscmDiscreteJobs t3 where t2.name = t3.jobId and t1.wipEntityId = t2.wipEntityId and t3.jobDate >= '{0}' and t3.jobDate <= '{1}' and t1.inventoryItemId = {2}";
//string hql_ParamData = "select t1.wipEntityId from AscmWipRequirementOperations t1, AscmWipEntities t2, AscmDiscreteJobs t3 where t2.name = t3.jobId and t1.wipentityId = t2.wipentityId and t3.jobDate > '{0}' and t3.jobDate <= '{1}' and t1.inventoryItemId = {2}";
string hql = "from AscmDiscreteJobs where jobId in ({0})";
string hql_Param = "select name from AscmWipEntities";
hql_ParamData = string.Format(hql_ParamData, queryStartTime, queryEndTime, materialId);
IList <AscmWipRequirementOperations> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWipRequirementOperations>(hql_ParamData);
if (ilist != null && ilist.Count > 0)
{
List <AscmWipRequirementOperations> newlist = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmWipRequirementOperations>(ilist);
var wipEntityIds = newlist.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);
}
string where = "", whereQueryWord = "";
whereQueryWord = AscmCommonHelperService.GetInstance().IsJudgeListCount(ids, "wipentityId");
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
if (!string.IsNullOrEmpty(where))
{
hql_Param += " where " + where;
hql = string.Format(hql, hql_Param);
}
IList <AscmDiscreteJobs> ilistAscmDiscreteJobs = null;
if (ynPage != null)
{
ilistAscmDiscreteJobs = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmDiscreteJobs>(hql, hql, ynPage);
}
else
{
ilistAscmDiscreteJobs = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmDiscreteJobs>(hql);
}
if (ilistAscmDiscreteJobs != null && ilistAscmDiscreteJobs.Count > 0)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmDiscreteJobs>(ilistAscmDiscreteJobs);
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmDiscreteJobs)", ex);
throw ex;
}
return(list);
}
