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
}
}
