public void Delete(AscmAppointmentDistribution ascmAppointmentDistribution) { try { YnDaoHelper.GetInstance().nHibernateHelper.Delete<AscmAppointmentDistribution>(ascmAppointmentDistribution); } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("删除失败(Delete AscmAppointmentDistribution)", ex); throw ex; } }
public void Update(AscmAppointmentDistribution ascmAppointmentDistribution) { try { using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction()) { try { YnDaoHelper.GetInstance().nHibernateHelper.Update<AscmAppointmentDistribution>(ascmAppointmentDistribution); tx.Commit();//正确执行提交 } catch (Exception ex) { tx.Rollback();//回滚 YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmAppointmentDistribution)", ex); throw ex; } } } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Save AscmAppointmentDistribution)", ex); throw ex; } }
public void GetAppointmentDistribution(double _supplierPassDuration, List<AscmDeliBatSumMain> listAscmDeliBatSumMain, ref List<AscmAppointmentDistribution> listAscmAppointmentDistribution) { try { if (listAscmDeliBatSumMain == null || listAscmDeliBatSumMain.Count == 0) return; DateTime dtAppointmentStartTime, dtAppointmentEndTime; if (listAscmDeliBatSumMain[0].appointmentStartTime == null || !DateTime.TryParse(listAscmDeliBatSumMain[0].appointmentStartTime, out dtAppointmentStartTime) || listAscmDeliBatSumMain[0].appointmentEndTime == null || !DateTime.TryParse(listAscmDeliBatSumMain[0].appointmentEndTime, out dtAppointmentEndTime)) return; foreach (AscmDeliBatSumMain ascmDeliBatSumMain in listAscmDeliBatSumMain) { //2013.11.28改为司机合单确认(多个合单) //取交集 DateTime _dtAppointmentStartTime, _dtAppointmentEndTime; if (ascmDeliBatSumMain.appointmentStartTime == null || !DateTime.TryParse(ascmDeliBatSumMain.appointmentStartTime, out _dtAppointmentStartTime) || ascmDeliBatSumMain.appointmentEndTime == null || !DateTime.TryParse(ascmDeliBatSumMain.appointmentEndTime, out _dtAppointmentEndTime)) return; if (dtAppointmentStartTime < _dtAppointmentStartTime) dtAppointmentStartTime = _dtAppointmentStartTime; //5)最晚到货时间早于当前时间的批单,该批单总是可以勾选入合单,但不参加合单生成预约到货时间计算 if (_dtAppointmentEndTime > DateTime.Now.AddMinutes(30)&&dtAppointmentEndTime > _dtAppointmentEndTime) dtAppointmentEndTime = _dtAppointmentEndTime; } if (listAscmDeliBatSumMain.Count > 1) { if (dtAppointmentEndTime > DateTime.Now.AddMinutes(30) && dtAppointmentEndTime < dtAppointmentStartTime) throw new Exception("司机绑定多张合单预约时间不一致,不能合并送货"); } double supplierPassDuration = (double)0.5; double.TryParse(YnParameterService.GetInstance().GetValue(MyParameter.supplierPassDuration), out supplierPassDuration); if (supplierPassDuration < 0.5) supplierPassDuration = 0.5; if (_supplierPassDuration > 0) { supplierPassDuration = _supplierPassDuration; } //如到货时间早于当前时间,时间为当前时间向后取半点(最晚最早一样处理) DateTime now = DateTime.Now; if (now.Minute > 30) now = now.AddMinutes(30); if (dtAppointmentStartTime < now) dtAppointmentStartTime = now; if (dtAppointmentEndTime < now) { dtAppointmentStartTime = now; dtAppointmentEndTime = dtAppointmentStartTime.AddMinutes((int)supplierPassDuration * 60);//-30 TimeSpan ts = dtAppointmentEndTime - dtAppointmentStartTime; if (dtAppointmentStartTime.Hour < 8) { dtAppointmentStartTime = Convert.ToDateTime(dtAppointmentStartTime.ToString("yyyy-MM-dd 08:00")); dtAppointmentEndTime = dtAppointmentStartTime.AddMinutes(ts.TotalMinutes); } if (dtAppointmentStartTime.Hour > 17) { dtAppointmentStartTime = Convert.ToDateTime(dtAppointmentStartTime.ToString("yyyy-MM-dd 08:00")).AddDays(1); dtAppointmentEndTime = dtAppointmentStartTime.AddMinutes(ts.TotalMinutes); } if (dtAppointmentEndTime.Hour > 17) { dtAppointmentEndTime = Convert.ToDateTime(dtAppointmentEndTime.ToString("yyyy-MM-dd 17:00")); dtAppointmentStartTime = dtAppointmentEndTime.AddMinutes(-ts.TotalMinutes); } } //按30分钟取整 //6)仓库收料时间为8:00 – 11:20,13:00 - 17:00,合单生成的预约到货时间为8:00 -17:00。 string appointmentStartTime = dtAppointmentStartTime.ToString("yyyy-MM-dd HH:") + (dtAppointmentStartTime.Minute >= 30 ? "30" : "00"); string appointmentEndTime = dtAppointmentEndTime.ToString("yyyy-MM-dd HH:") + (dtAppointmentEndTime.Minute >= 30 ? "30" : "00"); DateTime.TryParse(appointmentStartTime, out dtAppointmentStartTime); DateTime.TryParse(appointmentEndTime, out dtAppointmentEndTime); if (dtAppointmentStartTime.ToString("yyyy-MM-dd") != dtAppointmentEndTime.ToString("yyyy-MM-dd")) { dtAppointmentEndTime = dtAppointmentStartTime.AddMinutes(supplierPassDuration*60); if (dtAppointmentStartTime.ToString("yyyy-MM-dd") != dtAppointmentEndTime.ToString("yyyy-MM-dd")) { dtAppointmentEndTime = Convert.ToDateTime(dtAppointmentEndTime.ToString("yyyy-MM-dd 23:30:00")); } } //1.将一天8:00 – 18:00每半小时分为一段,此半小时为固定值 listAscmAppointmentDistribution = GetList("from AscmAppointmentDistribution where distributionDate='" + dtAppointmentEndTime .ToString("yyyy-MM-dd")+ "'"); DateTime dtStart = Convert.ToDateTime("2000-01-01 08:00"); int timeMinuteStep = 30;//此半小时为固定值 for (int iTimePoint = 0; iTimePoint < 20; iTimePoint++) { AscmAppointmentDistribution ascmAppointmentDistribution = listAscmAppointmentDistribution.Find(p=>p.timeId==iTimePoint); if (ascmAppointmentDistribution == null) { ascmAppointmentDistribution = new AscmAppointmentDistribution(); ascmAppointmentDistribution.id = 0; ascmAppointmentDistribution.distributionDate = dtAppointmentEndTime.ToString("yyyy-MM-dd"); ascmAppointmentDistribution.timeId = iTimePoint; ascmAppointmentDistribution.startTime = dtStart.AddMinutes((iTimePoint) * timeMinuteStep).ToString("HH:mm"); ascmAppointmentDistribution.endTime = dtStart.AddMinutes((iTimePoint + 1) * timeMinuteStep).ToString("HH:mm"); ascmAppointmentDistribution.count = 0; listAscmAppointmentDistribution.Add(ascmAppointmentDistribution); } } //2.对于合单生成可选时间,计算合单在T0~T19上每个区间的值 List<AscmAppointmentDistribution> listAscmAppointmentDistribution_Tmp = new List<AscmAppointmentDistribution>(); for (int iTime = 0; iTime < 20; iTime++) { AscmAppointmentDistribution ascmAppointmentDistribution = listAscmAppointmentDistribution_Tmp.Find(p => p.timeId == iTime); if (ascmAppointmentDistribution == null) { ascmAppointmentDistribution = new AscmAppointmentDistribution(); ascmAppointmentDistribution.id = 0; ascmAppointmentDistribution.distributionDate = dtAppointmentEndTime.ToString("yyyy-MM-dd"); ascmAppointmentDistribution.timeId = iTime; ascmAppointmentDistribution.startTime = dtStart.AddMinutes((iTime) * timeMinuteStep).ToString("HH:mm"); ascmAppointmentDistribution.endTime = dtStart.AddMinutes((iTime + 1) * timeMinuteStep).ToString("HH:mm"); ascmAppointmentDistribution.count = 0; listAscmAppointmentDistribution_Tmp.Add(ascmAppointmentDistribution); } if (GetMinutes(dtAppointmentStartTime.ToString("HH:mm")) <= GetMinutes(ascmAppointmentDistribution.startTime) && GetMinutes(dtAppointmentEndTime.ToString("HH:mm")) > GetMinutes(ascmAppointmentDistribution.endTime)) { ascmAppointmentDistribution.count += 1; } } ////取均值 此功能在此暂时意义不大,但不要删除 //int sum1 = (int)listAscmAppointmentDistribution_Tmp.Sum(p => p.count); //foreach (AscmAppointmentDistribution ascmAppointmentDistribution in listAscmAppointmentDistribution_Tmp) //{ // ascmAppointmentDistribution.count = ascmAppointmentDistribution.count / sum1; //} //3.比较合单可选时间段不同方案的最优选择,得出合单最早到货时间和最晚到货时间 //供应商到厂放行时长 List<AppointmentSection> listAppointmentSection = new List<AppointmentSection>(); for (int itime = GetMinutes(dtAppointmentStartTime.ToString("HH:mm")); itime < GetMinutes(dtAppointmentEndTime.ToString("HH:mm")); itime += (int)(supplierPassDuration * 60)) { int item_start=itime; int item_end=itime+ (int)(supplierPassDuration * 60); AppointmentSection appointmentSection = new AppointmentSection(); appointmentSection.startTime = GetMinutes(itime); appointmentSection.endTime = GetMinutes(item_end); appointmentSection.value = 0; for (int iTime = 0; iTime < 20; iTime++) { AscmAppointmentDistribution ascmAppointmentDistribution = listAscmAppointmentDistribution.Find(p=>p.timeId==iTime); AscmAppointmentDistribution ascmAppointmentDistribution_tmp = listAscmAppointmentDistribution_Tmp.Find(p=>p.timeId==iTime); if (item_start <= GetMinutes(ascmAppointmentDistribution.startTime) && item_end >= GetMinutes(ascmAppointmentDistribution.endTime)) { appointmentSection.value += ascmAppointmentDistribution.count + ascmAppointmentDistribution_tmp.count; } } listAppointmentSection.Add(appointmentSection); } //2014.3.5根据补充规则,多个合单时间不能超出交集范围 2014.3.9一张合单也这样处理 //if (listAscmDeliBatSumMain.Count > 1) //{ if (listAppointmentSection.Count == 1) { if (GetMinutes(listAppointmentSection[0].endTime) > GetMinutes(dtAppointmentEndTime.ToString("HH:mm"))) { listAppointmentSection[0].endTime = dtAppointmentEndTime.ToString("HH:mm"); } } //} //4.取最小值 AppointmentSection appointmentSection_min=null; foreach (AppointmentSection _appointmentSection in listAppointmentSection) { if (appointmentSection_min == null) appointmentSection_min = _appointmentSection; if(appointmentSection_min.value>_appointmentSection.value) appointmentSection_min = _appointmentSection; } // if (appointmentSection_min != null) { //appointmentSection_min为供应商计算得出的最小落点时间 int appointmentSection_min_timePoint_start = GetTime(dtStart, appointmentSection_min.startTime, timeMinuteStep); int appointmentSection_min_timePoint_end = GetTime(dtStart, appointmentSection_min.endTime, timeMinuteStep); if (appointmentSection_min_timePoint_start != appointmentSection_min_timePoint_end && appointmentSection_min_timePoint_start < appointmentSection_min_timePoint_end) { decimal f1 = (decimal)1 / (appointmentSection_min_timePoint_end - appointmentSection_min_timePoint_start); for (int appointmentSection_min_time = appointmentSection_min_timePoint_start; appointmentSection_min_time < appointmentSection_min_timePoint_end; appointmentSection_min_time++) { AscmAppointmentDistribution ascmAppointmentDistribution = listAscmAppointmentDistribution.Find(p => p.timeId == appointmentSection_min_time); if (ascmAppointmentDistribution != null) { ascmAppointmentDistribution.count += f1; } } } //ascmDeliBatSumMain.appointmentStartTime = dtAppointmentStartTime.ToString("yyyy-MM-dd") + " " + appointmentSection_min.startTime; //ascmDeliBatSumMain.appointmentEndTime = dtAppointmentStartTime.ToString("yyyy-MM-dd") + " " + appointmentSection_min.endTime; //2013.11.28改为司机合单确认(多个合单) //2014.3.24改为不替换时间 //foreach (AscmDeliBatSumMain ascmDeliBatSumMain in listAscmDeliBatSumMain) //{ // ascmDeliBatSumMain.appointmentStartTime = dtAppointmentStartTime.ToString("yyyy-MM-dd") + " " + appointmentSection_min.startTime; // ascmDeliBatSumMain.appointmentEndTime = dtAppointmentStartTime.ToString("yyyy-MM-dd") + " " + appointmentSection_min.endTime; //} } } catch (Exception ex) { throw ex; } }