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(); }