public List <AscmContainerDelivery> GetCurrentList(string containerSn, string sessionKey) { 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, sessionKey); //IList<AscmContainerDelivery> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmContainerDelivery>(sql, sessionKey); if (ilist != null && ilist.Count > 0) { foreach (AscmContainerDelivery ascmContainerDelivery in ilist) { ascmContainerDelivery.ascmDeliBatSumMain = AscmDeliBatSumMainService.GetInstance().Get(ascmContainerDelivery.batSumMainId, sessionKey); ascmContainerDelivery.ascmDeliveryOrderBatch = AscmDeliveryOrderBatchService.GetInstance().Get(ascmContainerDelivery.deliveryOrderBatchId, sessionKey); } list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmContainerDelivery>(ilist); //AscmDeliBatSumMain ascmDeliBatSumMain = YnDaoHelper.GetInstance().nHibernateHelper.Get<AscmDeliBatSumMain>(ilist[0].batSumMainId, sessionKey); //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, sessionKey); // 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 AscmContainerDelivery GetCurrent(string warehouseId) { AscmContainerDelivery ascmContainerDelivery = null; try { YnPage ynPage = new YnPage(); ynPage.SetPageSize(1); ynPage.SetCurrentPage(1); string sort = " order by modifyTime desc "; string sql = "from AscmContainerDelivery where status='" + AscmContainerDelivery.StatusDefine.inWarehouseDoor + "' and batSumMainId in (select id from AscmDeliBatSumMain where warehouseId='" + warehouseId + "') and modifyTime is not null"; IList <AscmContainerDelivery> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmContainerDelivery>(sql + sort, sql, ynPage); if (ilist != null && ilist.Count > 0) { return(ilist[0]); } } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmContainerDelivery)", ex); throw ex; } return(ascmContainerDelivery); }
public AscmWmsContainerDelivery GetCurrent(string containerSn, string sessionKey) { try { string sort = " order by id desc "; string sql = "from AscmWmsContainerDelivery where containerSn='" + containerSn + "' and (status is null or status='') and createTime>='" + DateTime.Now.AddDays(-2).ToString("yyyy-MM-dd 00:00:00") + "'"; YnPage ynPage = new YnPage(); ynPage.SetPageSize(1); ynPage.SetCurrentPage(1); IList <AscmWmsContainerDelivery> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWmsContainerDelivery>(sql + sort, sql, ynPage, sessionKey); //IList<AscmContainerDelivery> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmContainerDelivery>(sql, sessionKey); if (ilist != null && ilist.Count > 0) { return(ilist[0]); } } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmWmsContainerDelivery)", ex); throw ex; } return(null); }
//车辆入厂 public void InOutPlant(int doorId, string readingHead, int driverId, bool inPlant, string direction, bool onTime, ref string allocateOutDoor) { try { AscmDriver ascmDriver = Get(driverId); if (ascmDriver != null) { int batSumMainId = 0; string batSumDocNumber = string.Empty; string appointmentStartTime = string.Empty; string appointmentEndTime = string.Empty; SetSupplier(new List <AscmDriver> { ascmDriver }); List <AscmDeliBatSumMain> list = AscmDeliBatSumMainService.GetInstance().GetByDriverId(ascmDriver.id); if (list != null) { foreach (AscmDeliBatSumMain ascmDeliBatSumMain in list) { if (inPlant) { ascmDeliBatSumMain.status = AscmDeliBatSumMain.StatusDefine.inPlant; ascmDeliBatSumMain.toPlantTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ascmDeliBatSumMain.allocateOutDoor = "北门"; if (ascmDeliBatSumMain.warehouseId != "W112材料") { #region 取上一次送货合单 YnPage ynPage = new YnPage(); ynPage.SetPageSize(1); ynPage.SetCurrentPage(1); //string sort = " order by toPlantTime desc "; string where = " toPlantTime is not null and status='" + AscmDeliBatSumMain.StatusDefine.inPlant + "'"; List <AscmDeliBatSumMain> listAscmDeliBatSumMainPreviousInPlant = AscmDeliBatSumMainService.GetInstance().GetList(ynPage, "toPlantTime", "desc", where); if (listAscmDeliBatSumMainPreviousInPlant != null && listAscmDeliBatSumMainPreviousInPlant.Count > 0) { AscmDeliBatSumMain ascmDeliBatSumMain_tmp = listAscmDeliBatSumMainPreviousInPlant[0]; if (ascmDeliBatSumMain_tmp.allocateOutDoor == "北门") { ascmDeliBatSumMain.allocateOutDoor = "西门"; } } #endregion } batSumMainId = ascmDeliBatSumMain.id; batSumDocNumber = ascmDeliBatSumMain.docNumber; appointmentStartTime = ascmDeliBatSumMain.appointmentStartTime; appointmentEndTime = ascmDeliBatSumMain.appointmentEndTime; allocateOutDoor = ascmDeliBatSumMain.allocateOutDoor; } else { } DateTime createTime = DateTime.Now; string description = ascmDriver.supplierName + ":" + ascmDriver.name + ":" + ascmDriver.plateNumber; AscmTruckSwipeLog ascmTruckSwipeLog = AscmTruckSwipeLogService.GetInstance().GetAddLog(doorId, readingHead, ascmDriver.rfid, ascmDriver.supplierId, driverId, ascmDriver.supplierName, ascmDriver.name, ascmDriver.plateNumber, true, description, createTime, direction, batSumMainId, batSumDocNumber, onTime, appointmentStartTime, appointmentEndTime); using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction()) { try { if (ascmTruckSwipeLog != null) { YnDaoHelper.GetInstance().nHibernateHelper.Save(ascmTruckSwipeLog); } if (ascmDeliBatSumMain != null) { YnDaoHelper.GetInstance().nHibernateHelper.Update(ascmDeliBatSumMain); } tx.Commit();//正确执行提交 } catch (Exception ex) { tx.Rollback();//回滚 throw ex; } } } } } } catch (Exception ex) { throw ex; } }
public List<AscmContainerDelivery> GetCurrentList(string containerSn, string sessionKey) { 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, sessionKey); //IList<AscmContainerDelivery> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmContainerDelivery>(sql, sessionKey); if (ilist != null && ilist.Count > 0) { foreach (AscmContainerDelivery ascmContainerDelivery in ilist) { ascmContainerDelivery.ascmDeliBatSumMain = AscmDeliBatSumMainService.GetInstance().Get(ascmContainerDelivery.batSumMainId, sessionKey); ascmContainerDelivery.ascmDeliveryOrderBatch = AscmDeliveryOrderBatchService.GetInstance().Get(ascmContainerDelivery.deliveryOrderBatchId, sessionKey); } list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList<AscmContainerDelivery>(ilist); //AscmDeliBatSumMain ascmDeliBatSumMain = YnDaoHelper.GetInstance().nHibernateHelper.Get<AscmDeliBatSumMain>(ilist[0].batSumMainId, sessionKey); //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, sessionKey); // 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 AscmContainerDelivery GetCurrent(string warehouseId) { AscmContainerDelivery ascmContainerDelivery = null; try { YnPage ynPage = new YnPage(); ynPage.SetPageSize(1); ynPage.SetCurrentPage(1); string sort = " order by modifyTime desc "; string sql = "from AscmContainerDelivery where status='" + AscmContainerDelivery.StatusDefine.inWarehouseDoor + "' and batSumMainId in (select id from AscmDeliBatSumMain where warehouseId='" + warehouseId + "') and modifyTime is not null"; IList<AscmContainerDelivery> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmContainerDelivery>(sql + sort, sql, ynPage); if (ilist != null && ilist.Count>0) { return ilist[0]; } } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmContainerDelivery)", ex); throw ex; } return ascmContainerDelivery; }
//车辆入厂 public void InOutPlant(int doorId, string readingHead, int driverId, bool inPlant, string direction, bool onTime,ref string allocateOutDoor) { try { AscmDriver ascmDriver = Get(driverId); if (ascmDriver != null) { int batSumMainId = 0; string batSumDocNumber = string.Empty; string appointmentStartTime = string.Empty; string appointmentEndTime = string.Empty; SetSupplier(new List<AscmDriver> { ascmDriver }); List<AscmDeliBatSumMain> list = AscmDeliBatSumMainService.GetInstance().GetByDriverId(ascmDriver.id); if (list != null) { foreach (AscmDeliBatSumMain ascmDeliBatSumMain in list) { if (inPlant) { ascmDeliBatSumMain.status = AscmDeliBatSumMain.StatusDefine.inPlant; ascmDeliBatSumMain.toPlantTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ascmDeliBatSumMain.allocateOutDoor = "北门"; if (ascmDeliBatSumMain.warehouseId != "W112材料") { #region 取上一次送货合单 YnPage ynPage = new YnPage(); ynPage.SetPageSize(1); ynPage.SetCurrentPage(1); //string sort = " order by toPlantTime desc "; string where = " toPlantTime is not null and status='" + AscmDeliBatSumMain.StatusDefine.inPlant + "'"; List<AscmDeliBatSumMain> listAscmDeliBatSumMainPreviousInPlant = AscmDeliBatSumMainService.GetInstance().GetList(ynPage, "toPlantTime", "desc", where); if (listAscmDeliBatSumMainPreviousInPlant != null && listAscmDeliBatSumMainPreviousInPlant.Count > 0) { AscmDeliBatSumMain ascmDeliBatSumMain_tmp = listAscmDeliBatSumMainPreviousInPlant[0]; if (ascmDeliBatSumMain_tmp.allocateOutDoor == "北门") ascmDeliBatSumMain.allocateOutDoor = "西门"; } #endregion } batSumMainId = ascmDeliBatSumMain.id; batSumDocNumber = ascmDeliBatSumMain.docNumber; appointmentStartTime = ascmDeliBatSumMain.appointmentStartTime; appointmentEndTime = ascmDeliBatSumMain.appointmentEndTime; allocateOutDoor = ascmDeliBatSumMain.allocateOutDoor; } else { } DateTime createTime = DateTime.Now; string description = ascmDriver.supplierName + ":" + ascmDriver.name + ":" + ascmDriver.plateNumber; AscmTruckSwipeLog ascmTruckSwipeLog = AscmTruckSwipeLogService.GetInstance().GetAddLog(doorId, readingHead, ascmDriver.rfid, ascmDriver.supplierId, driverId, ascmDriver.supplierName, ascmDriver.name, ascmDriver.plateNumber, true, description, createTime, direction, batSumMainId, batSumDocNumber, onTime, appointmentStartTime, appointmentEndTime); using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction()) { try { if (ascmTruckSwipeLog != null) YnDaoHelper.GetInstance().nHibernateHelper.Save(ascmTruckSwipeLog); if (ascmDeliBatSumMain != null) YnDaoHelper.GetInstance().nHibernateHelper.Update(ascmDeliBatSumMain); tx.Commit();//正确执行提交 } catch (Exception ex) { tx.Rollback();//回滚 throw ex; } } } } } } catch (Exception ex) { throw ex; } }
public AscmWmsContainerDelivery GetCurrent(string containerSn, string sessionKey) { try { string sort = " order by id desc "; string sql = "from AscmWmsContainerDelivery where containerSn='" + containerSn + "' and (status is null or status='') and createTime>='" + DateTime.Now.AddDays(-2).ToString("yyyy-MM-dd 00:00:00") + "'"; YnPage ynPage = new YnPage(); ynPage.SetPageSize(1); ynPage.SetCurrentPage(1); IList<AscmWmsContainerDelivery> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmWmsContainerDelivery>(sql + sort, sql, ynPage, sessionKey); //IList<AscmContainerDelivery> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmContainerDelivery>(sql, sessionKey); if (ilist != null && ilist.Count > 0) { return ilist[0]; } } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmWmsContainerDelivery)", ex); throw ex; } return null; }