/// <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>
/// 新增EmpGuardWorkTime資料
/// </summary>
/// <param name="model">畫面model</param>
/// <param name="msg">回傳訊息</param>
/// <returns>bool</returns>
public static bool AddEmpGuardWorkTime(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
{
var count = conn.Query <EmpGuardWorkTimeBean>(WorkTimeSql.SelectEmpGuardWorkTime(), dataBean, trans).Count(); //執行查詢，結果回傳至TestBean物件
if (count == 0)
{
conn.Execute(WorkTimeSql.AddEmpGuardWorkTime(), dataBean, trans); //執行修改，並做Transaction機制
}
else
{
throw new Exception("資料已存在，請勿重複新增!!");
}
trans.Commit(); //成功Transaction直接Commit
}
catch (Exception)
{
trans.Rollback(); //失敗Transaction Rollback
result = false;
throw;
}
}
}
result = true;
}
catch (Exception ex)
{
msg = ex.Message;
}
return(result);
}
/// <summary>
/// 查詢值班人數
/// </summary>
/// <param name="model"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static int SelectDutyCnt(EmpGuardWorkTimeModel model, out string msg)
{
var result = 0;
msg = "";
var viewData = new EmpGuardWorkTimeBean()
{
DutyDate = model.DutyDate,
DutyCompID = model.CompID,
DutyDeptID = model.DeptID,
DutyOrganID = model.OrganID,
BranchFlag = model.BranchFlag,
WTCompID = model.CompID,
WTID = model.WTID
};
WorkTime.SelectDutyCnt(viewData, out result, out msg);
return(result);
}
/// <summary>
/// 修改EmpGuardWorkTime資料
/// </summary>
/// <param name="model">畫面model</param>
/// <param name="msg">回傳訊息</param>
/// <returns>bool</returns>
public static bool UpdateEmpGuardWorkTime(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.UpdateEmpGuardWorkTime(), 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);
}
