/// <summary>
/// 取得會員資料
/// </summary>
/// <param name="IDNo">身分證字號</param>
/// <returns></returns>
public static Models.Entity.MemberInfo GetMemberInfoByIDNo(string IDNo)
{
Log log = new Log();
try
{
using (var db = new HealthPaltformContext())
{
if (string.IsNullOrEmpty(IDNo))
{
log.Info($"會員資料不存在");
return(new Models.Entity.MemberInfo());
}
else
{
log.Info($"會員資料存在");
return(db.MemberInfo.Where(x => x.IDNo == IDNo).FirstOrDefault());
}
}
}
catch (DbEntityValidationException ex)
{
new Log().Error($"產生與資料庫相關的錯誤\n" +
$"Data：{ex.ToString()}");
return(new Models.Entity.MemberInfo());
}
}
/// <summary>
/// 查詢是否已建立資料，回傳ID，若不存在新增一筆
/// </summary>
/// <param name="IDNo">身分證字號</param>
/// <returns></returns>
public static string QueryMemberInfoByIDNo(string IDNo)
{
Log log = new Log();
try
{
using (var db = new HealthPaltformContext())
{
if (db.MemberInfo.Any(x => x.IDNo == IDNo))
{
log.Info($"會員資料存在，回傳資料");
return(db.MemberInfo.Where(x => x.IDNo == IDNo).FirstOrDefault().ID);
}
else
{
log.Info($"會員資料不存在，回傳空值");
return(string.Empty);
}
}
}
catch (DbEntityValidationException ex)
{
new Log().Error($"產生與資料庫相關的錯誤\n" +
$"Data：{ex.ToString()}");
return(string.Empty);
}
}
/// <summary>
/// 建立評語的資料
/// </summary>
/// <param name="measure"></param>
/// <returns></returns>
public static bool InitialResultRemark()
{
var result = false;
try
{
using (var db = new HealthPaltformContext())
{
if (!db.ResultRemark.Any())
{
var tmpData = ToolLibs.GetResultRemarkData();
var obj = ToolLibs.ResultRemarkConvert(tmpData);
if (obj.Result.Any())
{
foreach (var unit in obj.Result)
{
//建立新物件
var tmpResult = new Models.Entity.ResultRemark();
//型態
tmpResult.Type = ToolLibs.GetEnum <ResultRemarkType>(unit.Type);
//低標
tmpResult.LowRange = Convert.ToDouble(unit.LowRange);
//頂標
tmpResult.HightRange = Convert.ToDouble(unit.HightRange);
//等級
tmpResult.Level = unit.Level;
//評語
tmpResult.Message = unit.Message;
//建立日期
tmpResult.CreateDate = DateTime.Now;
//新增資料
db.ResultRemark.Add(tmpResult);
}
//儲存新增
if (db.SaveChanges() > 0)
{
result = true;
}
}
}
}
return(result);
}
catch (DbEntityValidationException ex)
{
new Log().Error($"產生與資料庫相關的錯誤\n" +
$"Data：{ex.ToString()}");
return(result);
}
}
public DataTable SqlQuery(string esqlQuery)
{
using (var context = new HealthPaltformContext())
{
// Create a query that takes two parameters.
esqlQuery =
@"SELECT TOP (1000) [UID]
,[MemberIDNo]
,[MIData]
,[MIDate]
FROM [HealthPlatform].[dbo].[MeasureInfo]";
context.Database.ExecuteSqlCommand(esqlQuery);
}
}
/// <summary>
/// 新增資料
/// </summary>
/// <param name="measure"></param>
/// <returns></returns>
public static long InsertMeasureInfo(Models.Entity.MeasureInfo measure)
{
try
{
using (var db = new HealthPaltformContext())
{
db.MeasureInfo.Add(measure);
db.SaveChanges();
return(measure.UID);
}
}
catch (DbEntityValidationException ex)
{
new Log().Error($"產生與資料庫相關的錯誤\n" +
$"Data：{ex.ToString()}");
return(-999);
}
}
/// <summary>
/// 新增會員資料
/// </summary>
/// <param name="memberInfo"></param>
/// <returns></returns>
public static int InsertMemberInfo(Models.Entity.MemberInfo memberInfo)
{
Log log = new Log();
try
{
using (var db = new HealthPaltformContext())
{
db.MemberInfo.Add(memberInfo);
//log
return(db.SaveChanges());
}
}
catch (DbEntityValidationException ex)
{
log.Error($"產生與資料庫相關的錯誤\n" +
$"Data：{ex.ToString()}");
return(-999);
}
}
public static Models.Entity.ResultRemark GetRemarkByType(ResultRemarkType type, double value)
{
var result = new Models.Entity.ResultRemark();
try
{
using (var db = new HealthPaltformContext())
{
if (value > 0)
{
result = db.ResultRemark.Where(x => x.Type == type && value > x.LowRange && value < x.HightRange).FirstOrDefault();
}
}
return(result);
}
catch (DbEntityValidationException ex)
{
new Log().Error($"產生與資料庫相關的錯誤\n" +
$"Data：{ex.ToString()}");
return(result);
}
}
public static Models.Entity.MeasureInfo GetMeasureInfoByUID(long uid)
{
try
{
using (var db = new HealthPaltformContext())
{
if (uid > 0)
{
return(db.MeasureInfo.Where(x => x.UID == uid).FirstOrDefault());
}
else
{
return(new Models.Entity.MeasureInfo());
}
}
}
catch (DbEntityValidationException ex)
{
new Log().Error($"產生與資料庫相關的錯誤\n" +
$"Data：{ex.ToString()}");
return(new Models.Entity.MeasureInfo());
}
}
