public async Task UpdateMasterHeaderAsync(MasterRecord header) { Header = header; await Task.Delay(100); dataGrid.RefreshGrid(); }
public async Task OnCommandClicked(CommandClickEventArgs <OrderMasterAdapterModel> args) { OrderMasterAdapterModel item = args.RowData as OrderMasterAdapterModel; if (args.CommandColumn.ButtonOption.IconCss == ButtonIdHelper.ButtonIdEdit) { #region 點選 修改紀錄 按鈕 CurrentRecord = item.Clone(); EditRecordDialogTitle = "修改紀錄"; IsShowEditRecord = true; isNewRecordMode = false; #endregion } else if (args.CommandColumn.ButtonOption.IconCss == ButtonIdHelper.ButtonIdDelete) { #region 點選 刪除紀錄 按鈕 CurrentNeedDeleteRecord = item; #region 檢查關聯資料是否存在 var checkedResult = await CurrentService .BeforeDeleteCheckAsync(CurrentNeedDeleteRecord); await Task.Delay(100); if (checkedResult.Success == false) { MessageBox.Show("400px", "200px", "警告", ErrorMessageMappingHelper.Instance.GetErrorMessage(checkedResult.MessageId)); await Task.Yield(); thisView.NeedRefresh(); return; } #endregion ConfirmMessageBox.Show("400px", "200px", "警告", "確認要刪除這筆紀錄嗎?"); #endregion } else if (args.CommandColumn.ButtonOption.IconCss == ButtonIdHelper.ButtonIdShowDetailOfMaster) { #region 點選 開啟多筆 CRUD 對話窗 按鈕 IsShowMoreDetailsRecord = true; ShowMoreDetailsRecordDialogTitle = MagicHelper.訂單明細管理功能名稱; MasterRecord masterRecord = new MasterRecord() { Id = item.Id }; Header = masterRecord; if (ShowMoreDetailsGrid != null) { await Task.Delay(100); // 使用延遲,讓 Header 的資料綁定可以成功 ShowMoreDetailsGrid.RefreshGrid(); } #endregion } }
public void ReadAllRecords() { using (StreamReader reader = File.OpenText(@"D:\Documents\Projects\Form337Insertion\AR112014\MASTER.txt")) { CsvConfiguration config = new CsvConfiguration(); config.RegisterClassMap <MasterRecordClassMap>(); var csv = new CsvReader(reader, config); List <MasterRecord> records = csv.GetRecords <MasterRecord>().ToList(); MasterRecord chubby = records.Where(rec => rec.n_number == "145WK").FirstOrDefault(); } }
public static void WriteToPdf(MasterRecord record) { using (PdfReader rdr = new PdfReader(@"C:\Users\Admin\Documents\Visual Studio 2013\Projects\Form337Insertion\FAA_Form_337.pdf")) using (PdfStamper stamper = new PdfStamper(rdr, new System.IO.FileStream("FAA_Form_337_Filled.pdf", FileMode.Create))) { stamper.AcroFields.SetField("instructions and disposition of this form This report is required by law 49 USC 44701 Failure to report can result in a civil penalty for each", record.n_number); stamper.AcroFields.SetField("Serial No", record.serial_number); stamper.AcroFields.SetField("Make", record.kit_mfr); stamper.AcroFields.SetField("Model", record.kit_model); stamper.AcroFields.SetField("Name As shown on registration certificate", record.name); stamper.AcroFields.SetField("Address", record.street); stamper.AcroFields.SetField("City", record.city); stamper.AcroFields.SetField("State", record.state); stamper.AcroFields.SetField("Zip", record.zip_code); stamper.AcroFields.SetField("Identify with aircraft nationality and registration mark and date work completed 1", record.n_number); stamper.Close(); rdr.Close(); } }
public void Read(Stream input, OWLib.STUD stud) { using (BinaryReader reader = new BinaryReader(input, System.Text.Encoding.Default, true)) { master = reader.Read <MasterRecord>(); if (master.bundles > 0) { input.Position = master.bundles; STUDArrayInfo array = reader.Read <STUDArrayInfo>(); bundles = new Bundle[array.count]; input.Position = (long)array.offset; for (ulong i = 0; i < array.count; ++i) { bundles[i] = reader.Read <Bundle>(); } } else { bundles = new Bundle[0]; } } }
public async Task OnCommandClicked(CommandClickEventArgs <PolicyHeaderAdapterModel> args) { PolicyHeaderAdapterModel item = args.RowData as PolicyHeaderAdapterModel; if (args.CommandColumn.ButtonOption.IconCss == ButtonIdHelper.ButtonIdEdit) { #region 點選 修改紀錄 按鈕 CurrentRecord = item.Clone(); EditRecordDialogTitle = "修改紀錄"; IsShowEditRecord = true; isNewRecordMode = false; #endregion } else if (args.CommandColumn.ButtonOption.IconCss == ButtonIdHelper.ButtonIdDelete) { #region 點選 刪除紀錄 按鈕 CurrentNeedDeleteRecord = item; #region 檢查關聯資料是否存在 var checkedResult = await CurrentService .BeforeDeleteCheckAsync(CurrentNeedDeleteRecord); await Task.Delay(100); if (checkedResult.Success == false) { MessageBox.Show("400px", "200px", "警告", ErrorMessageMappingHelper.Instance.GetErrorMessage(checkedResult.MessageId), MessageBox.HiddenAsync); await Task.Yield(); thisView.NeedRefresh(); return; } #endregion #region 刪除這筆紀錄 await Task.Yield(); var checkTask = ConfirmMessageBox.ShowAsync("400px", "200px", "警告", "確認要刪除這筆紀錄嗎?", ConfirmMessageBox.HiddenAsync); thisView.NeedRefresh(); var checkAgain = await checkTask; if (checkAgain == true) { var verifyRecordResult = await CurrentService.DeleteAsync(CurrentNeedDeleteRecord.Id); await TranscationResultHelper.CheckDatabaseResult(MessageBox, verifyRecordResult); dataGrid.RefreshGrid(); } #endregion #endregion } else if (args.CommandColumn.ButtonOption.IconCss == ButtonIdHelper.ButtonIdShowDetailOfMaster) { #region 點選 開啟多筆 CRUD 對話窗 按鈕 IsShowMoreDetailsRecord = true; ShowMoreDetailsRecordDialogTitle = MagicHelper.簽核流程政策明細; MasterRecord masterRecord = new MasterRecord() { Id = item.Id }; Header = masterRecord; if (ShowMoreDetailsGrid != null) { await Task.Delay(100); // 使用延遲,讓 Header 的資料綁定可以成功 ShowMoreDetailsGrid.RefreshGrid(); } #endregion } }
bool Equals(MasterRecord other) { return(Type == other.Type && string.Equals(Description, other.Description) && Value == other.Value); }
public DataSet GenerateSQL(Guid DataViewListID, out MetricTrac.Bll.DataViewList.Extend dv, out List <MasterGroup> MasterGroupList) { MasterGroupList = new List <MasterGroup>(); dv = MetricTrac.Bll.DataViewList.Get(DataViewListID); string sql = SqlSelet.Replace("@InstanceId", "'" + dv.InstanceId.ToString() + "'"); List <string> TotalOrderBy = new List <string>(); List <string> TotalSelect = new List <string>(); List <ReferenceEntity.UseField> MasterGroupByFieldList = GetGroupByFieldList(ref sql, TotalOrderBy, TotalSelect, dv.GroupByList); List <ReferenceEntity.UseField> MasterSelectFieldList = GetSelectFieldList(ref sql, TotalOrderBy, TotalSelect, dv.SelectList); List <ReferenceEntity.UseField> SlaveGroupByFieldList = GetGroupByFieldList(ref sql, TotalOrderBy, TotalSelect, dv.GroupBySlaveList); List <ReferenceEntity.UseField> SlaveSelectFieldList = GetSelectFieldList(ref sql, TotalOrderBy, TotalSelect, dv.SelectSlaveList); if (MasterSelectFieldList.Count == 0 && SlaveSelectFieldList.Count == 0) { return(null); } DataSet ds = MetricTrac.Bll.LinqMicajahDataContext.Execute(sql); DataTable dt = ds.Tables[0]; List <string> PrevMasterGroupValue = new List <string>(); List <MasterGroupNode> PrevMasterGroupNode = new List <MasterGroupNode>(); for (int i = 0; i < MasterGroupByFieldList.Count + SlaveGroupByFieldList.Count; i++) { PrevMasterGroupValue.Add(null); PrevMasterGroupNode.Add(null); } MasterGroup mg = null; MasterRecord mr = null; MasterHeader mh = null; foreach (DataRow r in dt.Rows) { string OrgLocationRootColumnName = "en_FullName"; if (dt.Columns.Contains(OrgLocationRootColumnName)) { object o = r[OrgLocationRootColumnName]; if (o is string && ((string)o) == "Organization Location") { r[OrgLocationRootColumnName] = MetricTrac.Bll.LinqMicajahDataContext.OrganizationName; } } //Fill Master Group bool isNewMasterGroup = false; string alias; string GroupValue; List <MasterGroupNode> GroupTree = null; for (int i = 0; i < MasterGroupByFieldList.Count; i++) { alias = GetAlias(MasterGroupByFieldList[i]); GroupValue = r[alias].ToString(); if (PrevMasterGroupValue[i] != GroupValue && !isNewMasterGroup) { GroupTree = new List <MasterGroupNode>(); isNewMasterGroup = true; for (int k = 0; k < i; k++) { PrevMasterGroupNode[k].HeaderCount++; } } PrevMasterGroupValue[i] = GroupValue; string GroupHeader = MasterGroupByFieldList[i].Entity.ReadableName; if (MasterGroupByFieldList[i].ReadableName != "Name") { GroupHeader += " " + MasterGroupByFieldList[i].ReadableName; } if (isNewMasterGroup) { MasterGroupNode n = new MasterGroupNode() { Header = GroupHeader, Value = GroupValue, HeaderCount = 1 }; GroupTree.Add(n); for (int k = 0; k < i; k++) { PrevMasterGroupNode[k].SubGroupCount++; } PrevMasterGroupNode[i] = n; } } if (isNewMasterGroup) { mg = new MasterGroup() { GroupTree = GroupTree, MasterHeaderList = new List <MasterHeader>(), MasterRecordList = new List <MasterRecord>(), SlaveGroupList = new List <SlaveGroup>() }; MasterGroupList.Add(mg); foreach (var s in MasterSelectFieldList) { mh = new MasterHeader() { Header = s.Entity.ReadableName + (s.ReadableName == "Name" ? "" : (" " + s.ReadableName)) }; mg.MasterHeaderList.Add(mh); } } //Fill Master Record bool isNewMasterRecord = isNewMasterGroup; MasterRecord PrevMasterRecord = mg.MasterRecordList.Count == 0 ? null : mg.MasterRecordList[mg.MasterRecordList.Count - 1]; mr = new MasterRecord() { MasterValueList = new List <MasterValue>(), SlaveRecordList = new List <SlaveRecord>() }; for (int i = 0; i < MasterSelectFieldList.Count; i++) { var s = MasterSelectFieldList[i]; MasterValue mv = new MasterValue() { Value = GetValue(s, r)// r[GetAlias(s)].ToString() }; mr.MasterValueList.Add(mv); if (PrevMasterRecord == null || mv.Value != PrevMasterRecord.MasterValueList[i].Value) { isNewMasterRecord = true; } } if (isNewMasterRecord) { mg.MasterRecordList.Add(mr); for (int k = 0; k < MasterGroupByFieldList.Count; k++) { PrevMasterGroupNode[k].RecordCount++; } } else { mr = mg.MasterRecordList[mg.MasterRecordList.Count - 1]; } //Fill Slave Group if (mg.MasterRecordList.Count == 1) { for (int i = 0; i < SlaveGroupByFieldList.Count; i++) { var sg = SlaveGroupByFieldList[i]; SlaveGroup g = new SlaveGroup() { Group = r[GetAlias(sg)].ToString() }; mg.SlaveGroupList.Add(g); } } //Fill Slave Records SlaveRecord sr = new SlaveRecord() { SlaveValueList = new List <SlaveValue>() }; mr.SlaveRecordList.Add(sr); for (int i = 0; i < SlaveSelectFieldList.Count; i++) { var column = SlaveSelectFieldList[i]; //object v = r[GetAlias(column)]; SlaveValue sv = new SlaveValue() { Value = GetValue(column, r)//v == null ? null : v.ToString() }; sr.SlaveValueList.Add(sv); } } /*for (int i = 0; i < MasterGroupList.Count; i++) * { * var MG = MasterGroupList[i]; * * for (int k = i + 1; k < MasterGroupList.Count; k++) * { * if (MG.GroupTree.Count <= ChildMG.GroupTree.Count) break; * } * }*/ return(ds); }
public void UpdateMasterHeader(MasterRecord header) { Header = header; Grid?.Refresh(); }
public async Task OnCommandClicked(CommandClickEventArgs <FlowMasterAdapterModel> args) { FlowMasterAdapterModel item = args.RowData as FlowMasterAdapterModel; if (args.CommandColumn.ButtonOption.IconCss == ButtonIdHelper.ButtonIdEdit) { #region 點選 修改紀錄 按鈕 CurrentRecord = item.Clone(); EditRecordDialogTitle = "修改紀錄"; IsShowEditRecord = true; IsNewRecordMode = false; #endregion } else if (args.CommandColumn.ButtonOption.IconCss == ButtonIdHelper.ButtonIdDelete) { #region 點選 刪除紀錄 按鈕 CurrentNeedDeleteRecord = item; #region 檢查關聯資料是否存在 var checkedResult = await CurrentService .BeforeDeleteCheckAsync(CurrentNeedDeleteRecord); await Task.Delay(100); thisView.NeedRefresh(); if (checkedResult.Success == false) { var checkTask1 = ConfirmMessageBox.ShowAsync("400px", "200px", "警告", $"你確定真的要刪除與這筆紀錄相關紀錄嗎?例如:收件匣、簽呈使用者、簽成歷史紀錄 ({checkedResult.Message})", ConfirmMessageBox.HiddenAsync); thisView.NeedRefresh(); var checkAgain1 = await checkTask1; if (checkAgain1 == true) { var verifyRecordResult = await CurrentService.DeleteAsync(CurrentNeedDeleteRecord.Id); await TranscationResultHelper.CheckDatabaseResult(MessageBox, verifyRecordResult); dataGrid.RefreshGrid(); } await Task.Yield(); thisView.NeedRefresh(); return; } #endregion #region 刪除這筆紀錄 await Task.Yield(); var checkTask = ConfirmMessageBox.ShowAsync("400px", "200px", "警告", "確認要刪除這筆紀錄嗎?", ConfirmMessageBox.HiddenAsync); thisView.NeedRefresh(); var checkAgain = await checkTask; if (checkAgain == true) { var verifyRecordResult = await CurrentService.DeleteAsync(CurrentNeedDeleteRecord.Id); await TranscationResultHelper.CheckDatabaseResult(MessageBox, verifyRecordResult); dataGrid.RefreshGrid(); } #endregion #endregion } else if (args.CommandColumn.ButtonOption.IconCss == ButtonIdHelper.ButtonIdShowFlowUser) { #region 點選 稽核使用者 對話窗 按鈕 IsShowFlowUserRecord = true; ShowMoreDetailsRecordDialogTitle = MagicHelper.簽核使用者明細; MasterRecord masterRecord = new MasterRecord() { Id = item.Id }; Header = masterRecord; if (ShowFlowUserGrid != null) { await Task.Delay(100); // 使用延遲,讓 Header 的資料綁定可以成功 ShowFlowUserGrid.RefreshGrid(); } #endregion } else if (args.CommandColumn.ButtonOption.IconCss == ButtonIdHelper.ButtonIdShowFlowHistory) { #region 點選 開啟多筆 CRUD 對話窗 按鈕 IsShowFlowHistoryRecord = true; ShowMoreDetailsRecordDialogTitle = MagicHelper.簽核歷史紀錄; MasterRecord masterRecord = new MasterRecord() { Id = item.Id }; Header = masterRecord; if (ShowFlowHistoryGrid != null) { await Task.Delay(100); // 使用延遲,讓 Header 的資料綁定可以成功 ShowFlowHistoryGrid.RefreshGrid(); } #endregion } }