public static DinnerRecord_dnr_Info CreateDinnerRecord(DinnerRecord_dnr_Info dnr)
{
try
{
using (NHibernateTransaction.DBContext db = new NHibernateTransaction.DBContext())
{
DateTime dt = DateTime.Now;
dnr.dnr_RecordID = Guid.NewGuid();
dnr.dnr_cAdd = "SYS";
dnr.dnr_cLast = "SYS";
dnr.dnr_dAddDate = dt;
dnr.dnr_dLastDate = dt;
dnr.dnr_dDate = dt.Date;
dnr.dnr_lIsAuto = true;
dnr.dsm_cProjectStatus = string.Empty;
db.CurrentSession.Save(dnr);
}
}
catch (Exception e)
{
Common.General.BLLoger.Error(e);
}
return dnr;
}
public Model.General.ReturnValueInfo Save(DinnerRecord_dnr_Info objInfo, DefineConstantValue.EditStateEnum cState)
{
ReturnValueInfo objRturn = null;
switch (cState)
{
case Common.DefineConstantValue.EditStateEnum.OE_Update:
objRturn = this.dinnerScheduleDA_SQLite.Update(objInfo);
break;
case Common.DefineConstantValue.EditStateEnum.OE_Insert:
objRturn = this.dinnerScheduleDA_SQLite.Insert(objInfo);
break;
}
return objRturn;
}
/// <summary>
/// 開始用餐
/// </summary>
/// <returns></returns>
public static bool AddDinnerRecord(DinnerRecord_dnr_Info dnr)
{
bool result = false;
try
{
using (NHibernateTransaction.DBContext db = new NHibernateTransaction.DBContext())
{
dnr.dnr_dAddDate = DateTime.Now;
dnr.dnr_dLastDate = DateTime.Now;
db.CurrentSession.Save(dnr);
}
}
catch (Exception e)
{
Common.General.BLLoger.Error(e);
//throw;
}
return result;
}
/// <summary>
/// 開始用餐
/// </summary>
/// <returns></returns>
public static ReturnValueInfo StartDinner(DinnerRecord_dnr_Info dnr)
{
ReturnValueInfo result = new ReturnValueInfo();
try
{
//dnr.dnr_cMachineID = swl.swl_cMachineNO;
//dnr.dsm_cProjectStatus = swl.swl_cProjStatus;
//dnr.dsm_swlID = swl.swl_RecordID;
using (NHibernateTransaction.DBContext db = new NHibernateTransaction.DBContext())
{
dnr.dnr_dLastDate = DateTime.Now;
dnr.dnr_dBeginTime = DateTime.Now;
db.CurrentSession.SaveOrUpdate(dnr);
result.boolValue = true;
}
}
catch (Exception e)
{
result.messageText = "開始就餐出錯：" + e.Message;
Common.General.BLLoger.Error(e);
//throw;
}
return result;
}
/// <summary>
/// 創建默認就餐記錄
/// </summary>
/// <param name="machineID"></param>
/// <param name="date"></param>
/// <returns></returns>
//public static List<DinnerRecord_dnr_Info> CreateDefaultDinnerRecord(string machineID, Guid areaID, DateTime date)
//{
// List<DinnerRecord_dnr_Info> dinnerRecords = new List<DinnerRecord_dnr_Info>();
// try
// {
// List<DinnerScheduleMaster_dsm_Info> dinnerScheduleMaster = DinnerBL.GetDinnerSchedule(areaID);
// using (DBContext db = DBContext.Begin())
// {
// try
// {
// foreach (var item in dinnerScheduleMaster)
// {
// var dnrs = db.CurrentSession.QueryOver<DinnerRecord_dnr_Info>().Where(d => d.dnr_dDate == date.Date && d.dnr_DSMID == item.dsm_RecordID).List();
// if (dnrs.Count != 0)
// {
// dinnerRecords.Add(dnrs[0]);
// continue;
// }
// else
// {
// DinnerRecord_dnr_Info dnr = new DinnerRecord_dnr_Info();
// dnr.dnr_RecordID = Guid.NewGuid();
// dnr.dnr_cAdd = "SYS";
// dnr.dnr_cLast = "SYS";
// dnr.dnr_dAddDate = DateTime.Now;
// dnr.dnr_dLastDate = DateTime.Now;
// dnr.dnr_dDate = date.Date;
// dnr.dnr_cMachineID = machineID;
// dnr.dnr_DSMID = item.dsm_RecordID;
// dnr.dnr_dBeginTime = DateUtil.Convert(date.Date, item.dsm_cBeginTime);
// dnr.dnr_dEndTime = DateUtil.Convert(date.Date, item.dsm_cEndTime);
// dnr.dnr_lIsAuto = true;
// dnr.dsm_cProjectStatus = string.Empty;
// db.CurrentSession.Save(dnr);
// dinnerRecords.Add(dnr);
// }
// }
// }
// catch (Exception)
// {
// db.CanCommit = false;
// throw;
// }
// }
// return dinnerRecords;
// }
// catch (Exception e)
// {
// Common.General.BLLoger.Error(e);
// }
// return null;
//}
/// <summary>
/// 結束用餐
/// </summary>
/// <returns></returns>
public static ReturnValueInfo FinishDinner(DinnerRecord_dnr_Info dnr)
{
ReturnValueInfo result = new ReturnValueInfo();
try
{
using (NHibernateTransaction.DBContext db = NHibernateTransaction.DBContext.Begin())
{
try
{
dnr.dnr_dLastDate = DateTime.Now;
dnr.dnr_dEndTime = DateTime.Now;
db.CurrentSession.SaveOrUpdate(dnr);
result.boolValue = true;
}
catch (Exception)
{
db.CanCommit = false;
throw;
}
}
}
catch (Exception e)
{
result.messageText = "結束就餐出錯：" + e.Message;
Common.General.BLLoger.Error(e);
//throw;
}
return result;
}
