public bool DeleteRecord(Model.IModel.IModelObject KeyObject)
{
bool isSuccess = false;
DinnerScheduleMaster_dsm_Info info = new DinnerScheduleMaster_dsm_Info();
info = KeyObject as DinnerScheduleMaster_dsm_Info;
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
DinnerScheduleMaster_dsm delTab = db.DinnerScheduleMaster_dsm.SingleOrDefault(t => t.dsm_RecordID == info.dsm_RecordID);
if (delTab != null)
{
db.DinnerScheduleMaster_dsm.DeleteOnSubmit(delTab);
db.SubmitChanges();
isSuccess = true;
}
}
}
catch (Exception ex)
{
mLoger.Error("run DinnerScheduleMasterDA.DeleteRecord", ex);
throw ex;
}
return isSuccess;
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
if (this.EditState == DefineConstantValue.EditStateEnum.OE_Insert)
{
this.TabText = "新增" + this.Text;
if (base.BaseParam != null)
{
DinnerScheduleMaster_dsm_Info info = base.BaseParam as DinnerScheduleMaster_dsm_Info;
info = _DinnerScheduleMasterBL.DisplayRecord(info);
this._CurrentAfwInfo = info;
}
}
else if (this.EditState == DefineConstantValue.EditStateEnum.OE_Update)
{
this.TabText = "查看" + this.Text;
if (base.BaseParam != null)
{
DinnerScheduleMaster_dsm_Info info = base.BaseParam as DinnerScheduleMaster_dsm_Info;
info = _DinnerScheduleMasterBL.DisplayRecord(info);
this._CurrentAfwInfo = info;
}
else
{
this.ShowWarningMessage("没有可用的记录。");
}
}
InitSysBar();
InitppgDsmInfos();
}
bool ISync.Download(string machineID)
{
try
{
ShowMessage("同步就餐計劃主檔...");
List<DinnerScheduleMaster_dsm_Info> sourceList;
DinnerBL dinnerBL = new DinnerBL();
DinnerScheduleMaster_dsm_Info cond = new DinnerScheduleMaster_dsm_Info();
cond.dsm_lIsAtive = true;
sourceList = dinnerBL.SearchRecords(cond);
using (DBContext uow = DBContext.Begin(NHConfigFactory.DBConfig.PPC))
{
uow.CurrentSession.CreateQuery("delete from DinnerScheduleMaster_dsm_Info").ExecuteUpdate();
foreach (var item in sourceList)
{
uow.CurrentSession.Save(item);
}
}
return true;
}
catch (Exception ex)
{
Common.General.BLLoger.Error(ex);
return false;
//throw ex;
}
}
public DinnerScheduleAppSetting()
{
InitializeComponent();
_DinnerScheduleMasterBL = new DinnerBL();
_CurrentAfwInfo = null;
_isChanged = false;
//todo: 需初始化用戶信息
if (base.UserInformation == null)
{
base.UserInformation = new Model.SysMaster.Sys_UserMaster_usm_Info();
base.UserInformation.usm_cUserLoginID = "sys";
}
}
public DinnerScheduleMaster_dsm_Info DisplayRecord(DinnerScheduleMaster_dsm_Info KeyObject)
{
DinnerScheduleMaster_dsm_Info info = new DinnerScheduleMaster_dsm_Info();
info = KeyObject as DinnerScheduleMaster_dsm_Info;
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
DinnerScheduleMaster_dsm disTab = db.DinnerScheduleMaster_dsm.SingleOrDefault(t => t.dsm_RecordID == info.dsm_RecordID);
if (disTab != null)
{
info = Common.General.CopyObjectValue<DinnerScheduleMaster_dsm, DinnerScheduleMaster_dsm_Info>(disTab);
}
}
}
catch (Exception ex)
{
mLoger.Error("run DinnerScheduleMasterDA.DisplayRecord", ex);
throw ex;
}
return info;
}
public bool InsertRecord(DinnerScheduleMaster_dsm_Info infoObject)
{
bool isSuccess = false;
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
DinnerScheduleMaster_dsm newTab = Common.General.CopyObjectValue<DinnerScheduleMaster_dsm_Info, DinnerScheduleMaster_dsm>(infoObject);
db.DinnerScheduleMaster_dsm.InsertOnSubmit(newTab);
db.SubmitChanges();
isSuccess = true;
}
}
catch (Exception ex)
{
mLoger.Error("run DinnerScheduleMasterDA.InsertRecord", ex);
throw ex;
}
return isSuccess;
}
public bool UpdateRecord(DinnerScheduleMaster_dsm_Info updateObject)
{
bool isSuccess = false;
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
DinnerScheduleMaster_dsm dbObject = db.DinnerScheduleMaster_dsm.SingleOrDefault(t => t.dsm_RecordID == updateObject.dsm_RecordID);
if (dbObject != null)
{
dbObject.dsm_cScheduleName = updateObject.dsm_cScheduleName;
dbObject.dsm_AreaID = updateObject.dsm_AreaID;
dbObject.dsm_cBeginTime = updateObject.dsm_cBeginTime;
dbObject.dsm_cEndTime = updateObject.dsm_cEndTime;
dbObject.dsm_lIsAtive = updateObject.dsm_lIsAtive;
dbObject.dsm_cLast = updateObject.dsm_cLast;
dbObject.dsm_dLastDate = updateObject.dsm_dLastDate;
db.SubmitChanges();
isSuccess = true;
}
}
}
catch (Exception ex)
{
mLoger.Error("run DinnerScheduleMasterDA.UpdateRecord", ex);
throw ex;
}
return isSuccess;
}
public List<DinnerScheduleMaster_dsm_Info> SearchRecords(DinnerScheduleMaster_dsm_Info searchCondition)
{
List<DinnerScheduleMaster_dsm_Info> list = null;
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
var datas = from a in db.DinnerScheduleMaster_dsm
join b in db.AreaMaster_amr on a.dsm_AreaID equals b.amr_cRecordID into ds
from d in ds
select new DinnerScheduleMaster_dsm_Info
{
dsm_RecordID = a.dsm_RecordID,
dsm_lIsAtive = a.dsm_lIsAtive,
dsm_dLastDate = a.dsm_dLastDate,
dsm_dAddDate = a.dsm_dAddDate,
dsm_cScheduleName = a.dsm_cScheduleName,
dsm_cLast = a.dsm_cLast,
dsm_cEndTime = a.dsm_cEndTime,
dsm_cBeginTime = a.dsm_cBeginTime,
dsm_cAdd = a.dsm_cAdd,
dsm_AreaID = a.dsm_AreaID,
AreaName = d.amr_cAreaName
};
if (searchCondition != null)
{
if (!string.IsNullOrEmpty(searchCondition.dsm_cScheduleName))
{
datas = datas.Where(d => d.dsm_cScheduleName.Contains(searchCondition.dsm_cScheduleName));
}
if (searchCondition.dsm_AreaID != Guid.Empty)
{
datas = datas.Where(d => d.dsm_AreaID == searchCondition.dsm_AreaID);
}
}
list = datas.ToList();
}
}
catch (Exception Ex)
{
throw Ex;
}
return list;
}
public bool IsExistRecord(object KeyObject)
{
bool isExist = false;
DinnerScheduleMaster_dsm_Info info = new DinnerScheduleMaster_dsm_Info();
info = KeyObject as DinnerScheduleMaster_dsm_Info;
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
DinnerScheduleMaster_dsm query = db.DinnerScheduleMaster_dsm.SingleOrDefault(t => t.dsm_RecordID == info.dsm_RecordID);
if (query != null)
{
isExist = true;
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return isExist;
}
private void btnSave_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
DinnerScheduleMaster_dsm_Info saveInfo = new DinnerScheduleMaster_dsm_Info();
DinnerScheduleMasterInfo dsmInfoPartial = ppgDsmInfos.SelectedObject as DinnerScheduleMasterInfo;
ReturnValueInfo rvInfo = null;
if (dsmInfoPartial == null)
{
this.ShowWarningMessage("保存失敗，獲取鍵入資料有誤。");
this.Cursor = Cursors.Default;
return;
}
if (CheckCanSave() == false)
{
this.ShowWarningMessage("保存失敗，獲取鍵入資料有誤。");
this.Cursor = Cursors.Default;
return;
}
if (this.EditState == DefineConstantValue.EditStateEnum.OE_Insert)
{
saveInfo.dsm_RecordID = dsmInfoPartial.dsm_iRecordID;
//saveInfo.dsm_cName = dsmInfoPartial.dsm_cName;
saveInfo.dsm_cScheduleName = dsmInfoPartial.dsm_cScheduleName;
saveInfo.dsm_cBeginTime = dsmInfoPartial.dsm_BeginTime;
saveInfo.dsm_cEndTime = dsmInfoPartial.dsm_EndTime;
saveInfo.dsm_lIsAtive = dsmInfoPartial.dsm_IIsActive == CustEnum.ChineseYesNo.是;
saveInfo.dsm_AreaID = new Guid(dsmInfoPartial.dsm_AreadID);
saveInfo.dsm_cAdd = base.UserInformation.usm_cUserLoginID;
saveInfo.dsm_dAddDate = DateTime.Now;
saveInfo.dsm_cLast = base.UserInformation.usm_cUserLoginID;
saveInfo.dsm_dLastDate = DateTime.Now;
rvInfo = _DinnerScheduleMasterBL.Save(saveInfo, DefineConstantValue.EditStateEnum.OE_Insert);
}
else if (this.EditState == DefineConstantValue.EditStateEnum.OE_Update)
{
saveInfo.dsm_RecordID = dsmInfoPartial.dsm_iRecordID;
saveInfo.dsm_AreaID = new Guid(dsmInfoPartial.dsm_AreadID);
saveInfo.dsm_cScheduleName = dsmInfoPartial.dsm_cScheduleName;
saveInfo.dsm_cBeginTime = dsmInfoPartial.dsm_BeginTime;
saveInfo.dsm_cEndTime = dsmInfoPartial.dsm_EndTime;
saveInfo.dsm_lIsAtive = dsmInfoPartial.dsm_IIsActive == CustEnum.ChineseYesNo.是;
saveInfo.dsm_cLast = base.UserInformation.usm_cUserLoginID;
saveInfo.dsm_dLastDate = DateTime.Now;
rvInfo = _DinnerScheduleMasterBL.Save(saveInfo, DefineConstantValue.EditStateEnum.OE_Update);
}
if (rvInfo.boolValue && !rvInfo.isError)
{
this.ShowInformationMessage("保存成功。");
}
else
{
this.ShowWarningMessage("保存失敗，異常信息：" + rvInfo.messageText);
}
this.Cursor = Cursors.Default;
}
private void SysToolBar_OnItemDelete_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
ReturnValueInfo rvInfo = null;
if (lvInfo.SelectedItems.Count > 0)
{
if (this.ShowQuestionMessage("是否確定刪除就餐計劃記錄：" + this.lvInfo.SelectedItems[0].SubItems[1].Text + "，區域：" + this.lvInfo.SelectedItems[0].SubItems[2].Text))
{
DinnerScheduleMaster_dsm_Info delTab = new DinnerScheduleMaster_dsm_Info();
delTab.dsm_RecordID = new Guid(lvInfo.SelectedItems[0].SubItems[0].Text.Trim());
rvInfo = mDinnerScheduleMasterBL.Save(delTab, DefineConstantValue.EditStateEnum.OE_Delete);
if (rvInfo.boolValue && !rvInfo.isError)
{
this.ShowInformationMessage(rvInfo.messageText);
RefreshAllState();
}
else
{
this.ShowWarningMessage("刪除失敗，異常信息：" + rvInfo.messageText);
}
this.Cursor = Cursors.Default;
}
else
{
this.Cursor = Cursors.Default;
return;
}
}
else
{
this.ShowInformationMessage("請選擇要刪除的記錄。");
this.Cursor = Cursors.Default;
return;
}
}
private void ShowModifyForm(object sender, EventArgs evArgs)
{
try
{
MenuItem itemMenu = new MenuItem();
itemMenu.Tag = typeof(DinnerScheduleAppSetting).FullName;
if (lvInfo.SelectedItems.Count > 0)
{
DinnerScheduleMaster_dsm_Info dsmParam = new DinnerScheduleMaster_dsm_Info();
dsmParam.dsm_RecordID = new Guid(lvInfo.SelectedItems[0].SubItems[0].Text.Trim());
BaseForm detailForm = this.ShowSubForm(itemMenu, this.BaseDockPanel, "修改就餐計劃主檔", DockState.Document, dsmParam, DefineConstantValue.EditStateEnum.OE_Update);
detailForm.FromCloseCallBack += RefreshAllState;
}
else
{
this.ShowInformationMessage("先選擇一條記錄!");
}
}
catch (Exception ex)
{
mLog.Error("DinnerSchedule.ShowModifyForm", ex);
ShowErrorMessage(ex);
}
}
private void ShowAddForm(object sender, EventArgs evArgs)
{
try
{
MenuItem itemMenu = new MenuItem();
DinnerScheduleMaster_dsm_Info dsmParam = new DinnerScheduleMaster_dsm_Info();
itemMenu.Tag = typeof(DinnerScheduleAppSetting).FullName;
if (mAreaID != Guid.Empty)
{
dsmParam.dsm_AreaID = mAreaID;
}
else
{
this.ShowInformationMessage("先選擇一個區域!");
return;
}
BaseForm detailForm = this.ShowSubForm(itemMenu, this.BaseDockPanel, "新增就餐計劃主檔", DockState.Document, dsmParam, DefineConstantValue.EditStateEnum.OE_Insert);
detailForm.FromCloseCallBack += RefreshAllState;
}
catch (Exception ex)
{
mLog.Error("DinnerSchedule.ShowAddForm", ex);
ShowErrorMessage(ex);
}
}
/// <summary>
/// 就餐主檔
/// </summary>
/// <param name="areaID">區域ID</param>
/// <param name="machineID">機台ID</param>
/// <returns></returns>
public List<DinnerScheduleMaster_dsm_Info> GetDinnerMaster(string areaID,string machineID)
{
try
{
List<DinnerScheduleMaster_dsm_Info> list = new List<DinnerScheduleMaster_dsm_Info>();
StringBuilder strSql = new StringBuilder();
strSql.AppendLine("select ");
strSql.AppendLine("dsm_RecordID,dsm_cScheduleName,dsm_AreaID,dsm_cBeginTime,dsm_cEndTime,dsm_lIsAtive,dsm_cAdd,dsm_dAddDate,dsm_cLast,dsm_dLastDate ");
strSql.AppendLine("from DinnerScheduleMaster_dsm ");
strSql.AppendLine(" WHERE dsm_lIsAtive=1 ");
strSql.AppendLine(" AND dsm_AreaID='" + areaID.Trim() + "'");
using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (sdr.Read())
{
DinnerScheduleMaster_dsm_Info model = new DinnerScheduleMaster_dsm_Info();
if (sdr["dsm_RecordID"] != null && sdr["dsm_RecordID"].ToString() != "")
{
model.dsm_RecordID = new Guid(sdr["dsm_RecordID"].ToString());
}
if (sdr["dsm_cScheduleName"] != null && sdr["dsm_cScheduleName"].ToString() != "")
{
model.dsm_cScheduleName = sdr["dsm_cScheduleName"].ToString();
}
if (sdr["dsm_AreaID"] != null && sdr["dsm_AreaID"].ToString() != "")
{
model.dsm_AreaID = new Guid(sdr["dsm_AreaID"].ToString());
}
if (sdr["dsm_cBeginTime"] != null && sdr["dsm_cBeginTime"].ToString() != "")
{
model.dsm_cBeginTime = sdr["dsm_cBeginTime"].ToString();
}
if (sdr["dsm_cEndTime"] != null && sdr["dsm_cEndTime"].ToString() != "")
{
model.dsm_cEndTime = sdr["dsm_cEndTime"].ToString();
}
if (sdr["dsm_lIsAtive"] != null && sdr["dsm_lIsAtive"].ToString() != "")
{
if ((sdr["dsm_lIsAtive"].ToString() == "1") || (sdr["dsm_lIsAtive"].ToString().ToLower() == "true"))
{
model.dsm_lIsAtive = true;
}
else
{
model.dsm_lIsAtive = false;
}
}
if (sdr["dsm_cAdd"] != null && sdr["dsm_cAdd"].ToString() != "")
{
model.dsm_cAdd = sdr["dsm_cAdd"].ToString();
}
if (sdr["dsm_dAddDate"] != null && sdr["dsm_dAddDate"].ToString() != "")
{
model.dsm_dAddDate = DateTime.Parse(sdr["dsm_dAddDate"].ToString());
}
if (sdr["dsm_cLast"] != null && sdr["dsm_cLast"].ToString() != "")
{
model.dsm_cLast = sdr["dsm_cLast"].ToString();
}
if (sdr["dsm_dLastDate"] != null && sdr["dsm_dLastDate"].ToString() != "")
{
model.dsm_dLastDate = DateTime.Parse(sdr["dsm_dLastDate"].ToString());
}
list.Add(model);
}
}
return list;
}
catch
{
throw;
}
}
private string GetDinnerMasterSQL(DinnerScheduleMaster_dsm_Info model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.dsm_RecordID != null)
{
strSql1.Append("dsm_RecordID,");
strSql2.Append("'" + model.dsm_RecordID + "',");
}
if (model.dsm_cScheduleName != null)
{
strSql1.Append("dsm_cScheduleName,");
strSql2.Append("'" + model.dsm_cScheduleName + "',");
}
if (model.dsm_AreaID != null)
{
strSql1.Append("dsm_AreaID,");
strSql2.Append("'" + model.dsm_AreaID + "',");
}
if (model.dsm_cBeginTime != null)
{
strSql1.Append("dsm_cBeginTime,");
strSql2.Append("'" + model.dsm_cBeginTime + "',");
}
if (model.dsm_cEndTime != null)
{
strSql1.Append("dsm_cEndTime,");
strSql2.Append("'" + model.dsm_cEndTime + "',");
}
if (model.dsm_lIsAtive != null)
{
strSql1.Append("dsm_lIsAtive,");
strSql2.Append("" + (model.dsm_lIsAtive ? 1 : 0) + ",");
}
if (model.dsm_cAdd != null)
{
strSql1.Append("dsm_cAdd,");
strSql2.Append("'" + model.dsm_cAdd + "',");
}
if (model.dsm_dAddDate != null)
{
strSql1.Append("dsm_dAddDate,");
strSql2.Append("'" + model.dsm_dAddDate.Value.ToString(this._sqlLiteDatetimeFormat) + "',");
}
if (model.dsm_cLast != null)
{
strSql1.Append("dsm_cLast,");
strSql2.Append("'" + model.dsm_cLast + "',");
}
if (model.dsm_dLastDate != null)
{
strSql1.Append("dsm_dLastDate,");
strSql2.Append("'" + model.dsm_dLastDate.Value.ToString(this._sqlLiteDatetimeFormat) + "',");
}
strSql.Append("insert into DinnerScheduleMaster_dsm(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
return strSql.ToString();
}
/// <summary>
/// 獲取本地所有就餐記錄
/// </summary>
/// <returns></returns>
//public List<DinnerRecord_dnr_Info> FindAllSchedule()
//{
// DinnerScheduleDA dinnerScheduleDA_SQLite = new DinnerScheduleDA();
// List<DinnerRecord_dnr_Info> objReturn = new List<DinnerRecord_dnr_Info>();
// Dictionary<string, object> param = new Dictionary<string, object>();
// IList<DinnerRecord_dnr_Info> objAll = dinnerScheduleDA_SQLite.GetEntities<DinnerRecord_dnr_Info>(param);
// foreach (DinnerRecord_dnr_Info objItem in objAll)
// {
// objReturn.Add(objItem);
// }
// return objReturn;
//}
//public ReturnValueInfo Save(DinnerRecord_dnr_Info objInfo, DefineConstantValue.EditStateEnum cState)
//{
// //DinnerScheduleDA dinnerScheduleDA_SQLite = new DinnerScheduleDA();
// ReturnValueInfo objRturn = null;
// switch (cState)
// {
// case Common.DefineConstantValue.EditStateEnum.OE_Update:
// objRturn = dinnerScheduleDA_SQLite.Update(objInfo);
// break;
// case Common.DefineConstantValue.EditStateEnum.OE_Insert:
// objRturn = dinnerScheduleDA_SQLite.Insert(objInfo);
// break;
// }
// return objRturn;
//}
public DinnerScheduleMaster_dsm_Info DisplayRecord(DinnerScheduleMaster_dsm_Info itemEntity)
{
return _DinnerScheduleMasterDA.DisplayRecord(itemEntity);
}
/// <summary>
/// 查詢後台就餐計劃
/// </summary>
/// <param name="itemEntity"></param>
/// <returns></returns>
public List<DinnerScheduleMaster_dsm_Info> SearchRecords(DinnerScheduleMaster_dsm_Info itemEntity)
{
List<DinnerScheduleMaster_dsm_Info> returnList = new List<DinnerScheduleMaster_dsm_Info>();
try
{
returnList = _DinnerScheduleMasterDA.SearchRecords(itemEntity);
return returnList;
}
catch (Exception ex)
{
mLog.Error("run DinnerBL.SearchRecords", ex);
}
return returnList;
}
/// <summary>
/// 綁定ListView，當TargetID為-1時搜索全部記錄
/// </summary>
/// <param name="TargetID">區域或啤機的ID</param>
private void BingGv()
{
DinnerScheduleMaster_dsm_Info query = new DinnerScheduleMaster_dsm_Info();
query.dsm_AreaID = mAreaID;
var info = mDinnerScheduleMasterBL.SearchRecords(query);
this.lvInfo.BeginUpdate();
lvInfo.Items.Clear();
foreach (DinnerScheduleMaster_dsm_Info item in info)
{
ListViewItem Item = new ListViewItem();
for (int i = 0; i < lvInfo.Columns.Count; i++)
{
TextBox t = new TextBox();
Item.SubItems.Add("");
}
Item.SubItems[0].Text = item.dsm_RecordID.ToString();
Item.SubItems[1].Text = item.dsm_cScheduleName;
Item.SubItems[2].Text = item.AreaName;
Item.SubItems[3].Text = item.dsm_cBeginTime;
Item.SubItems[4].Text = item.dsm_cEndTime;
Item.SubItems[5].Text = item.dsm_lIsAtive == true ? "是" : "否";
this.lvInfo.Items.Add(Item);//显示
}
this.lvInfo.Columns[0].Width = 0;
this.lvInfo.EndUpdate();
}
