/// <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); }