protected override void OnLoad(EventArgs e) { base.OnLoad(e); if (this.EditState == DefineConstantValue.EditStateEnum.OE_Insert) { this.TabText = "新增" + this.Text; if (base.BaseParam != null) { AheadOfOffDuty_aod_Info info = base.BaseParam as AheadOfOffDuty_aod_Info; info.aod_RecordID = Guid.NewGuid(); info.aod_TargetID = info.aod_TargetID; this._CurrentAfwInfo = info; } } else if (this.EditState == DefineConstantValue.EditStateEnum.OE_Update) { this.TabText = "查看" + this.Text; if (base.BaseParam != null) { AheadOfOffDuty_aod_Info info = base.BaseParam as AheadOfOffDuty_aod_Info; this._CurrentAfwInfo = info; } else { this.ShowWarningMessage("没有可用的记录。"); } } InitSysBar(); InitppgAfwInfos(); }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { bool isSuccess = false; AheadOfOffDuty_aod_Info info = new AheadOfOffDuty_aod_Info(); info = KeyObject as AheadOfOffDuty_aod_Info; try { using (MainDBDataContext db = new MainDBDataContext()) { //AheadOfOffDuty_aod delTab = db.AheadOfOffDuty_aod.SingleOrDefault(t => t.aod_iRecordID == info.aod_iRecordID && t.aod_lIsDeleted == false); AheadOfOffDuty_aod delTab = db.AheadOfOffDuty_aod.SingleOrDefault(t => t.aod_RecordID == info.aod_RecordID && t.aod_lIsAtive == true); if (delTab != null) { //delTab.aod_lIsDeleted = true; db.AheadOfOffDuty_aod.DeleteOnSubmit(delTab); delTab.aod_lIsAtive = false; db.SubmitChanges(); isSuccess = true; } } } catch (Exception Ex) { throw Ex; } return isSuccess; }
/// <summary> /// 綁定ListView,當TargetID為-1時搜索全部記錄 /// </summary> /// <param name="TargetID">區域或啤機的ID</param> private void BingGv(Guid TargetID) { AheadOfOffDuty_aod_Info query = new AheadOfOffDuty_aod_Info(); query.aod_TargetID = TargetID; var info = _IAheadOfOffDutyBL.SearchRecords(query); this.lvInfo.BeginUpdate(); lvInfo.Items.Clear(); foreach (AheadOfOffDuty_aod_Info item in info) { ListViewItem Item = new ListViewItem(); Item.SubItems.Clear(); for (int i = 0; i < lvInfo.Columns.Count; i++) { TextBox t = new TextBox(); Item.SubItems.Add(""); } Item.SubItems[0].Text = item.aod_RecordID.ToString(); Item.SubItems[1].Text = item.aod_cName; Item.SubItems[2].Text = item.aod_dOffDutyTime.ToString(); //Item.SubItems[3].Text = item.aod_iShiftTypeID == 1 ? "日班" : "夜班"; Item.SubItems[3].Text = _ShiftType.SingleOrDefault(t => t.Key == item.aod_iShiftTypeID).Value; Item.SubItems[4].Text = item.aod_lIsAtive == true ? "是" : "否"; this.lvInfo.Items.Add(Item);//显示 } this.lvInfo.EndUpdate(); }
public AdvanceOffWorkAppSetting() { InitializeComponent(); _AheadOfOffDutyBL = MasterBLLFactory.GetBLL<IAheadOfOffDutyBL>(MasterBLLFactory.AheadOfOffDutyMaster); _CurrentAfwInfo = null; _isChanged = false; //todo: 需初始化用戶信息 if (base.UserInformation == null) { base.UserInformation = new Model.SysMaster.Sys_UserMaster_usm_Info(); base.UserInformation.usm_cUserLoginID = "sys"; } }
public bool InsertRecord(AheadOfOffDuty_aod_Info infoObject) { bool isSuccess = false; try { using (MainDBDataContext db = new MainDBDataContext()) { AheadOfOffDuty_aod newTab = Common.General.CopyObjectValue<AheadOfOffDuty_aod_Info, AheadOfOffDuty_aod>(infoObject); db.AheadOfOffDuty_aod.InsertOnSubmit(newTab); db.SubmitChanges(); isSuccess = true; } } catch (Exception Ex) { throw Ex; } return isSuccess; }
public AheadOfOffDuty_aod_Info DisplayRecord(Model.IModel.IModelObject KeyObject) { AheadOfOffDuty_aod_Info info = new AheadOfOffDuty_aod_Info(); info = KeyObject as AheadOfOffDuty_aod_Info; try { using (MainDBDataContext db = new MainDBDataContext()) { //AheadOfOffDuty_aod disTab = db.AheadOfOffDuty_aod.SingleOrDefault(t => t.aod_iRecordID == info.aod_iRecordID && t.aod_lIsDeleted == false); AheadOfOffDuty_aod disTab = db.AheadOfOffDuty_aod.SingleOrDefault(t => t.aod_RecordID == info.aod_RecordID); if (disTab != null) { info = Common.General.CopyObjectValue<AheadOfOffDuty_aod, AheadOfOffDuty_aod_Info>(disTab); } } } catch (Exception Ex) { throw Ex; } return info; }
public Model.General.ReturnValueInfo Save(Model.IModel.IModelObject itemEntity, Common.DefineConstantValue.EditStateEnum EditMode) { Model.General.ReturnValueInfo returnValue = new Model.General.ReturnValueInfo(); AheadOfOffDuty_aod_Info info = new AheadOfOffDuty_aod_Info(); returnValue.messageText = ""; info = itemEntity as AheadOfOffDuty_aod_Info; try { switch (EditMode) { case Common.DefineConstantValue.EditStateEnum.OE_Insert: bool isExist = false; isExist = _AheadOfOffDutyDA.IsExistRecord(info); if (!isExist) { returnValue.boolValue = _AheadOfOffDutyDA.InsertRecord(info); } else { returnValue.boolValue = false; returnValue.messageText = "數據重複!"; } break; case Common.DefineConstantValue.EditStateEnum.OE_Update: returnValue.boolValue = _AheadOfOffDutyDA.UpdateRecord(info); break; case Common.DefineConstantValue.EditStateEnum.OE_Delete: returnValue.boolValue = _AheadOfOffDutyDA.DeleteRecord(info); break; } } catch (Exception Ex) { throw Ex; } return returnValue; }
public bool IsExistRecord(object KeyObject) { bool isExist = false; AheadOfOffDuty_aod_Info info = new AheadOfOffDuty_aod_Info(); info = KeyObject as AheadOfOffDuty_aod_Info; try { using (MainDBDataContext db = new MainDBDataContext()) { //AheadOfOffDuty_aod query = db.AheadOfOffDuty_aod.SingleOrDefault(t => t.aod_iRecordID == info.aod_iRecordID && t.aod_lIsDeleted == false); AheadOfOffDuty_aod query = db.AheadOfOffDuty_aod.SingleOrDefault(t => t.aod_RecordID == info.aod_RecordID && t.aod_lIsAtive == true); if (query != null) { isExist = true; } } } catch (Exception Ex) { throw Ex; } return isExist; }
public bool UpdateRecord(AheadOfOffDuty_aod_Info infoObject) { bool isSuccess = false; try { using (MainDBDataContext db = new MainDBDataContext()) { AheadOfOffDuty_aod query = db.AheadOfOffDuty_aod.SingleOrDefault(t => t.aod_RecordID == infoObject.aod_RecordID); if (query != null) { query.aod_cName = infoObject.aod_cName; query.aod_dOffDutyTime = infoObject.aod_dOffDutyTime; query.aod_iShiftTypeID = infoObject.aod_iShiftTypeID; query.aod_lIsAtive = infoObject.aod_lIsAtive; query.aod_cLast = infoObject.aod_cLast; query.aod_dLastDate = infoObject.aod_dLastDate; //Common.General.SetDataToLingQEntity<AheadOfOffDuty_aod>(query, infoObject); db.SubmitChanges(); isSuccess = true; } } } catch (Exception Ex) { throw Ex; } return isSuccess; }
public List<AheadOfOffDuty_aod_Info> SearchRecords(Model.IModel.IModelObject searchCondition) { List<AheadOfOffDuty_aod_Info> list = new List<AheadOfOffDuty_aod_Info>(); AheadOfOffDuty_aod_Info info = new AheadOfOffDuty_aod_Info(); info = searchCondition as AheadOfOffDuty_aod_Info; string strSQL = ""; strSQL += " SELECT aod_RecordID,aod_cName,aod_dOffDutyTime,aod_iShiftTypeID,aod_lIsAtive " + Environment.NewLine; strSQL += " FROM AheadOfOffDuty_aod " + Environment.NewLine; //strSQL += " WHERE aod_lIsDeleted =0 " + Environment.NewLine; strSQL += " WHERE 1 =1 " + Environment.NewLine; if (info.aod_TargetID != Guid.Empty) //小於零時搜索全部 { strSQL += " AND aod_TargetID = '" + info.aod_TargetID + "' " + Environment.NewLine; } IEnumerable<AheadOfOffDuty_aod_Info> infos = null; try { using (MainDBDataContext db = new MainDBDataContext()) { infos = db.ExecuteQuery<AheadOfOffDuty_aod_Info>(strSQL, new object[] { }); if (infos != null) { list = infos.ToList<AheadOfOffDuty_aod_Info>(); } } } catch (Exception Ex) { throw Ex; } return list; }
private void ShowModifyForm(object sender, EventArgs evArgs) { MenuItem itemMenu = new MenuItem(); itemMenu.Tag = "WindowUI.HBManagerTerminal.Management.RunningManagement.AdvanceOffWorkAppSetting"; if (lvInfo.SelectedItems.Count > 0) { AheadOfOffDuty_aod_Info aodParam = new AheadOfOffDuty_aod_Info(); aodParam.aod_RecordID = new Guid(lvInfo.SelectedItems[0].SubItems[0].Text.Trim()); aodParam.aod_cName = lvInfo.SelectedItems[0].SubItems[1].Text.Trim(); aodParam.aod_dOffDutyTime = lvInfo.SelectedItems[0].SubItems[2].Text.Trim(); //aodParam.aod_iShiftTypeID = lvInfo.SelectedItems[0].SubItems[3].Text.Trim() == "日班" ? 1 :2; aodParam.aod_iShiftTypeID = _ShiftType.SingleOrDefault(t => t.Value == lvInfo.SelectedItems[0].SubItems[3].Text.Trim()).Key; this.ShowSubForm(itemMenu, this.BaseDockPanel, "修改提前下班主檔", DockState.Document, aodParam, DefineConstantValue.EditStateEnum.OE_Update); } else { this.ShowInformationMessage("先選擇一條記錄!"); } }
private void ShowAddForm(object sender, EventArgs evArgs) { MenuItem itemMenu = new MenuItem(); AheadOfOffDuty_aod_Info aodParam = new AheadOfOffDuty_aod_Info(); itemMenu.Tag = "WindowUI.HBManagerTerminal.Management.RunningManagement.AdvanceOffWorkAppSetting"; //this.ShowSubForm(itemMenu, this.BaseDockPanel); if (_TargetID != Guid.Empty) { aodParam.aod_TargetID = _TargetID; } else { this.ShowInformationMessage("先選擇一個區域!"); return; } this.ShowSubForm(itemMenu, this.BaseDockPanel, "新增提前下班主檔", DockState.Document, aodParam, DefineConstantValue.EditStateEnum.OE_Insert); }
private void DeleteAfw(object sender, EventArgs evArgs) { this.Cursor = Cursors.WaitCursor; if (this.lvInfo.SelectedItems.Count > 0) { if (this.ShowQuestionMessage("是否確定刪除提前下班記錄:" + this.lvInfo.SelectedItems[0].SubItems[1].Text + ",提前下班時間:" + this.lvInfo.SelectedItems[0].SubItems[2].Text)) { AheadOfOffDuty_aod_Info delTab = new AheadOfOffDuty_aod_Info(); ReturnValueInfo rvInfo = null; delTab.aod_RecordID = new Guid(this.lvInfo.SelectedItems[0].SubItems[0].Text.Trim()); rvInfo = _IAheadOfOffDutyBL.Save(delTab, DefineConstantValue.EditStateEnum.OE_Delete); if (!rvInfo.isError && rvInfo.boolValue) { this.ShowInformationMessage("刪除成功。"); RefreshAllState(); } else { this.ShowWarningMessage("刪除失敗,失敗信息:" + rvInfo.messageText); } this.Cursor = Cursors.Default; } else { this.Cursor = Cursors.Default; return; } } else { this.Cursor = Cursors.Default; this.ShowInformationMessage("先選擇記錄!"); } }
public bool UpdateRecord(AheadOfOffDuty_aod_Info infoObject) { throw new NotImplementedException(); }
/// <summary> /// 獲得提前下班設置信息 /// </summary> /// <returns></returns> private List<ComboboxDataInfo> GetAheadOfOffDutyInfos() { List<ComboboxDataInfo> infoList = new List<ComboboxDataInfo>(); try { IAheadOfOffDutyDA da = SQLiteDAFacotry.GetDAL<IAheadOfOffDutyDA>(SQLiteDAFacotry.AheadOfOffDutyMaster); AheadOfOffDuty_aod_Info aodInfo = new AheadOfOffDuty_aod_Info(); Dictionary<string, object> dicParam = new Dictionary<string, object>(); List<AheadOfOffDuty_aod_Info> listSource = da.GetEntities<AheadOfOffDuty_aod_Info>(dicParam).ToList(); if (listSource != null && listSource.Count > 0) { foreach (AheadOfOffDuty_aod_Info item in listSource) { ComboboxDataInfo info = new ComboboxDataInfo(); info.DisplayMember = item.aod_cName; info.ValueMember = item.aod_RecordID.ToString(); infoList.Add(info); } } } catch (Exception Ex) { throw Ex; } return infoList; }
private void btnSave_Click(object sender, EventArgs e) { this.Cursor = Cursors.WaitCursor; AheadOfOffDuty_aod_Info saveInfo = new AheadOfOffDuty_aod_Info(); AdvanceOffWorkInfo afwInfoPartial = ppgAfwInfos.SelectedObject as AdvanceOffWorkInfo; ReturnValueInfo rvInfo = null; if (afwInfoPartial ==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.aod_RecordID = afwInfoPartial.aod_iRecordID; saveInfo.aod_cName = afwInfoPartial.aod_cName.Trim(); saveInfo.aod_dOffDutyTime = afwInfoPartial.aod_dOffDutyTime.Trim(); saveInfo.aod_iShiftTypeID =int.Parse( afwInfoPartial.aod_iShiftTypeID); //saveInfo.aod_lIsDeleted = false; saveInfo.aod_lIsAtive = afwInfoPartial.aod_lIsAtive; saveInfo.aod_TargetID = _CurrentAfwInfo.aod_TargetID; saveInfo.aod_cType = ""; saveInfo.aod_cAdd = base.UserInformation.usm_cUserLoginID; saveInfo.aod_dAddDate = DateTime.Now; saveInfo.aod_cLast = base.UserInformation.usm_cUserLoginID; saveInfo.aod_dLastDate = DateTime.Now; rvInfo = _AheadOfOffDutyBL.Save(saveInfo, DefineConstantValue.EditStateEnum.OE_Insert); } else if(this.EditState == DefineConstantValue.EditStateEnum.OE_Update) { saveInfo.aod_RecordID = afwInfoPartial.aod_iRecordID; saveInfo.aod_cName = afwInfoPartial.aod_cName.Trim(); saveInfo.aod_dOffDutyTime = afwInfoPartial.aod_dOffDutyTime.Trim(); saveInfo.aod_iShiftTypeID =int.Parse( afwInfoPartial.aod_iShiftTypeID); //saveInfo.aod_lIsDeleted = false; saveInfo.aod_lIsAtive = afwInfoPartial.aod_lIsAtive; saveInfo.aod_cLast = base.UserInformation.usm_cUserLoginID; saveInfo.aod_dLastDate = DateTime.Now; rvInfo = _AheadOfOffDutyBL.Save(saveInfo, DefineConstantValue.EditStateEnum.OE_Update); } if (rvInfo.boolValue && !rvInfo.isError) { this.ShowInformationMessage("保存成功。"); } else { this.ShowWarningMessage("保存失敗,異常信息:" + rvInfo.messageText); } this.Cursor = Cursors.Default; }