/// <summary>
/// 取得假單檔
/// </summary>
/// <param name="model">畫面model</param>
/// <param name="datas">回傳資料</param>
/// <param name="msg">回傳訊息</param>
/// <returns>bool</returns>
public static bool GetVacInfo(WorkTimeViewModel model, out int cnt, out string msg)
{
bool result = false;
msg = "";
cnt = 0;
try
{
using (var conn = new SqlConnection()
{
ConnectionString = DbHelper.getConnectionStrings(_attendantDBName).ConnectionString
})
{
try
{
cnt = Convert.ToInt32(conn.ExecuteScalar(WorkTimeSql.GetVacInfo(), model));
}
catch (Exception)
{
throw;
}
}
result = true;
}
catch (Exception ex)
{
msg = ex.Message;
}
return(result);
}
/// <summary>
/// 查詢EmpGuardWorkTime資料(修改頁)
/// </summary>
/// <param name="model">畫面model</param>
/// <param name="datas">回傳資料</param>
/// <param name="msg">回傳訊息</param>
/// <returns>bool</returns>
public static bool GetEmpGuardWorkTime(EmpGuardWorkTimeModel model, out List <EmpGuardWorkTimeBean> datas, out string msg)
{
bool result = false;
msg = "";
datas = new List <EmpGuardWorkTimeBean>();
try
{
using (var conn = new SqlConnection()
{
ConnectionString = DbHelper.getConnectionStrings(_attendantDBName).ConnectionString
})
{
try
{
datas = conn.Query <EmpGuardWorkTimeBean>(WorkTimeSql.GetEmpGuardWorkTime(), model).ToList();
}
catch (Exception)
{
throw;
}
}
result = true;
}
catch (Exception ex)
{
msg = ex.Message;
}
return(result);
}
/// <summary>
/// 取得CompID下拉選單
/// </summary>
/// <param name="model">畫面model</param>
/// <param name="datas">回傳資料</param>
/// <param name="msg">回傳訊息</param>
/// <returns>bool</returns>
public static bool LoadComp(WorkTimeViewModel model, out List <DropDownListMobel> datas, out string msg)
{
bool result = false;
msg = "";
datas = new List <DropDownListMobel>();
try
{
using (var conn = new SqlConnection()
{
ConnectionString = DbHelper.getConnectionStrings(_eHRMSDB_ITRD).ConnectionString
})
{
try
{
datas = conn.Query <DropDownListMobel>(WorkTimeSql.LoadComp(), model).ToList();
}
catch (Exception)
{
throw;
}
}
result = true;
}
catch (Exception ex)
{
msg = ex.Message;
}
return(result);
}
/// <summary>
/// 查詢值班人數
/// </summary>
/// <param name="model">畫面model</param>
/// <param name="msg">回傳訊息</param>
/// <returns>bool</returns>
public static bool SelectDutyCnt(EmpGuardWorkTimeBean dataBean, out int cnt, out string msg)
{
bool result = false;
msg = "";
cnt = 0;
try
{
using (var conn = new SqlConnection()
{
ConnectionString = DbHelper.getConnectionStrings(_attendantDBName).ConnectionString
})
{
conn.Open();
try
{
cnt = Convert.ToInt32(conn.ExecuteScalar(WorkTimeSql.SelectDutyCnt(), dataBean));
}
catch (Exception)
{
throw;
}
}
result = true;
}
catch (Exception ex)
{
msg = ex.Message;
}
return(result);
}
/// <summary>
/// 新增EmpWorkTime資料
/// </summary>
/// <param name="model">畫面model</param>
/// <param name="msg">回傳訊息</param>
/// <returns>bool</returns>
public static bool AddEmpWorkTime(List <EmpWorkTimeBean> dataBean, out string msg)
{
bool result = false;
msg = "";
try
{
using (var conn = new SqlConnection()
{
ConnectionString = DbHelper.getConnectionStrings(_attendantDBName).ConnectionString
})
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
foreach (var item in dataBean)
{
var count = conn.Query <EmpWorkTimeBean>(WorkTimeSql.SelectEmpWorkTime(), item, trans).Count(); //執行查詢，結果回傳至TestBean物件
if (count == 0)
{
conn.Execute(WorkTimeSql.AddEmpWorkTime(), item, trans); //執行新增，並做Transaction機制
}
else
{
conn.Execute(WorkTimeSql.UpdateEmpWorkTime(), item, trans); //執行修改，並做Transaction機制
}
}
trans.Commit(); //成功Transaction直接Commit
}
catch (Exception)
{
trans.Rollback(); //失敗Transaction Rollback
result = false;
throw;
}
}
}
result = true;
}
catch (Exception ex)
{
msg = ex.Message;
}
return(result);
}
/// <summary>
/// 刪除EmpGuardWorkTime資料
/// </summary>
/// <param name="model">畫面model</param>
/// <param name="msg">回傳訊息</param>
/// <returns>bool</returns>
public static bool DeleteEmpGuardWorkTime(List <EmpGuardWorkTimeBean> dataBean, out string msg)
{
bool result = false;
msg = "";
try
{
using (var conn = new SqlConnection()
{
ConnectionString = DbHelper.getConnectionStrings(_attendantDBName).ConnectionString
})
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
conn.Execute(WorkTimeSql.DeleteEmpGuardWorkTime(), dataBean, trans); //執行修改，並做Transaction機制
trans.Commit(); //成功Transaction直接Commit
}
catch (Exception)
{
trans.Rollback(); //失敗Transaction Rollback
result = false;
throw;
}
}
}
result = true;
}
catch (Exception ex)
{
msg = ex.Message;
}
return(result);
}
/// <summary>
/// 取得Calendar假日資料
/// </summary>
/// <param name="model">畫面model</param>
/// <param name="datas">回傳資料</param>
/// <param name="msg">回傳訊息</param>
/// <returns>bool</returns>
public static bool LoadHoliday(WorkTimeViewModel model, out List <CalendarListMobel> datas, out string msg)
{
bool result = false;
msg = "";
datas = new List <CalendarListMobel>();
try
{
using (var conn = new SqlConnection()
{
ConnectionString = DbHelper.getConnectionStrings(_attendantDBName).ConnectionString
})
{
try
{
if (model.WorkSite != "台灣")
{
datas = conn.Query <CalendarListMobel>(WorkTimeSql.LoadOverSeaHoliday(), model).ToList();
}
else
{
datas = conn.Query <CalendarListMobel>(WorkTimeSql.LoadHoliday(), model).ToList();
}
}
catch (Exception)
{
throw;
}
}
result = true;
}
catch (Exception ex)
{
msg = ex.Message;
}
return(result);
}
/// <summary>
/// 取得分行註記
/// </summary>
/// <param name="model">畫面model</param>
/// <param name="strField">回傳資料</param>
/// <param name="msg">回傳訊息</param>
/// <returns>bool</returns>
public static bool LoadOrgBranchMark(WorkTimeViewModel model, out string strField, out string msg)
{
bool result = false;
msg = "";
strField = "";
try
{
using (var conn = new SqlConnection()
{
ConnectionString = DbHelper.getConnectionStrings(_attendantDBName).ConnectionString
})
{
try
{
var objField = conn.ExecuteScalar(WorkTimeSql.LoadOrgBranchMark(), model);
if (objField != null)
{
strField = objField.ToString().Trim();
}
}
catch (Exception)
{
throw;
}
}
result = true;
}
catch (Exception ex)
{
msg = ex.Message;
}
return(result);
}
