public async Task <VerifyRecordResult> DeleteAsync(int id)
{
try
{
CleanTrackingHelper.Clean <PhaseCategory>(context);
PhaseCategory item = await context.PhaseCategory
.AsNoTracking()
.FirstOrDefaultAsync(x => x.Id == id);
if (item == null)
{
return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.無法刪除紀錄));
}
else
{
CleanTrackingHelper.Clean <PhaseCategory>(context);
context.Entry(item).State = EntityState.Deleted;
await context.SaveChangesAsync();
CleanTrackingHelper.Clean <PhaseCategory>(context);
return(VerifyRecordResultFactory.Build(true));
}
}
catch (Exception ex)
{
Logger.LogError(ex, "刪除記錄發生例外異常");
return(VerifyRecordResultFactory.Build(false, "刪除記錄發生例外異常", ex));
}
}
public async Task <VerifyRecordResult> UpdateAsync(PhaseCategoryAdapterModel paraObject)
{
try
{
PhaseCategory itemData = Mapper.Map <PhaseCategory>(paraObject);
CleanTrackingHelper.Clean <PhaseCategory>(context);
PhaseCategory item = await context.PhaseCategory
.AsNoTracking()
.FirstOrDefaultAsync(x => x.Id == paraObject.Id);
if (item == null)
{
return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.無法修改紀錄));
}
else
{
CleanTrackingHelper.Clean <PhaseCategory>(context);
context.Entry(itemData).State = EntityState.Modified;
await context.SaveChangesAsync();
CleanTrackingHelper.Clean <PhaseCategory>(context);
return(VerifyRecordResultFactory.Build(true));
}
}
catch (Exception ex)
{
Logger.LogError(ex, "修改記錄發生例外異常");
return(VerifyRecordResultFactory.Build(false, "修改記錄發生例外異常", ex));
}
}
public async Task <PhaseCategoryAdapterModel> GetAsync(int id)
{
PhaseCategory item = await context.PhaseCategory
.AsNoTracking()
.FirstOrDefaultAsync(x => x.Id == id);
PhaseCategoryAdapterModel result = Mapper.Map <PhaseCategoryAdapterModel>(item);
await OhterDependencyData(result);
return(result);
}
public async Task EnableIt(PhaseCategoryAdapterModel paraObject)
{
await Task.Delay(100);
PhaseCategory curritem = await context.PhaseCategory
.AsNoTracking()
.FirstOrDefaultAsync(x => x.Id == paraObject.Id);
CleanTrackingHelper.Clean <PhaseCategory>(context);
curritem.Enable = true;
context.Entry(curritem).State = EntityState.Modified;
await context.SaveChangesAsync();
CleanTrackingHelper.Clean <PhaseCategory>(context);
return;
}
public async Task <VerifyRecordResult> AddAsync(PhaseCategoryAdapterModel paraObject)
{
try
{
PhaseCategory itemParameter = Mapper.Map <PhaseCategory>(paraObject);
CleanTrackingHelper.Clean <PhaseCategory>(context);
await context.PhaseCategory
.AddAsync(itemParameter);
await context.SaveChangesAsync();
CleanTrackingHelper.Clean <PhaseCategory>(context);
return(VerifyRecordResultFactory.Build(true));
}
catch (Exception ex)
{
Logger.LogError(ex, "新增記錄發生例外異常");
return(VerifyRecordResultFactory.Build(false, "新增記錄發生例外異常", ex));
}
}
async Task 建立片語分類與文字Async()
{
List <PhaseMessage> PhaseMessage = new List <PhaseMessage>();
int cc = 10;
#region 簽核表單使用的輸入片語
var phaseCategory = new PhaseCategory()
{
Name = "簽核表單使用的輸入片語",
Enable = true,
OrderNumber = cc++,
PhaseMessage = new List <PhaseMessage>()
};
await context.PhaseCategory.AddAsync(phaseCategory);
await context.SaveChangesAsync();
PhaseMessage = new List <PhaseMessage>()
{
new PhaseMessage()
{
Content = "做得很好，繼續努力",
Enable = true,
Code = cc.ToString("D5"),
OrderNumber = cc++,
PhaseCategoryId = phaseCategory.Id,
},
new PhaseMessage()
{
Content = "用來形容情緒不會表露出來的人",
Enable = true,
Code = cc.ToString("D5"),
OrderNumber = cc++,
PhaseCategoryId = phaseCategory.Id,
},
new PhaseMessage()
{
Content = "像魚一樣的喝，表示喝很多，尤其指喝很多酒",
Enable = true,
Code = cc.ToString("D5"),
OrderNumber = cc++,
PhaseCategoryId = phaseCategory.Id,
},
new PhaseMessage()
{
Content = "意指非常重要、有權力或是具有影響力的人",
Enable = true,
Code = cc.ToString("D5"),
OrderNumber = cc++,
PhaseCategoryId = phaseCategory.Id,
},
};
await context.BulkInsertAsync(PhaseMessage);
#endregion
#region 改善報告的輸入片語
phaseCategory = new PhaseCategory()
{
Name = "改善報告的輸入片語",
Enable = true,
OrderNumber = cc++,
PhaseMessage = new List <PhaseMessage>()
};
await context.PhaseCategory.AddAsync(phaseCategory);
await context.SaveChangesAsync();
PhaseMessage = new List <PhaseMessage>()
{
new PhaseMessage()
{
Content = "加速意見溝通",
Enable = true,
Code = cc.ToString("D5"),
OrderNumber = cc++,
PhaseCategoryId = phaseCategory.Id,
},
new PhaseMessage()
{
Content = "○○○○案，簽會意見綜合說明如下，請鑒核",
Enable = true,
Code = cc.ToString("D5"),
OrderNumber = cc++,
PhaseCategoryId = phaseCategory.Id,
},
new PhaseMessage()
{
Content = "會簽意見一略以，○○○○○○○○○…",
Enable = true,
Code = cc.ToString("D5"),
OrderNumber = cc++,
PhaseCategoryId = phaseCategory.Id,
},
new PhaseMessage()
{
Content = "會簽意見二略以，○○○○○○○○○…",
Enable = true,
Code = cc.ToString("D5"),
OrderNumber = cc++,
PhaseCategoryId = phaseCategory.Id,
},
new PhaseMessage()
{
Content = "「是否允當」?",
Enable = true,
Code = cc.ToString("D5"),
OrderNumber = cc++,
PhaseCategoryId = phaseCategory.Id,
},
new PhaseMessage()
{
Content = "……因故不克擔任…，予以改派…",
Enable = true,
Code = cc.ToString("D5"),
OrderNumber = cc++,
PhaseCategoryId = phaseCategory.Id,
},
};
await context.BulkInsertAsync(PhaseMessage);
#endregion
#region 雜項輸入片語
phaseCategory = new PhaseCategory()
{
Name = "雜項輸入片語",
Enable = true,
OrderNumber = cc++,
PhaseMessage = new List <PhaseMessage>()
};
await context.PhaseCategory.AddAsync(phaseCategory);
await context.SaveChangesAsync();
PhaseMessage = new List <PhaseMessage>()
{
new PhaseMessage()
{
Content = "可以嗎?",
Enable = true,
Code = cc.ToString("D5"),
OrderNumber = cc++,
PhaseCategoryId = phaseCategory.Id,
},
new PhaseMessage()
{
Content = "有關本校進修部學生向 鈞部「部長信箱」反映課程標準一案，本校已查明原委，謹檢陳查核報告乙份（如附件），敬請 鑒核。",
Enable = true,
Code = cc.ToString("D5"),
OrderNumber = cc++,
PhaseCategoryId = phaseCategory.Id,
},
};
await context.BulkInsertAsync(PhaseMessage);
#endregion
}
