/// <summary> /// 取得值勤日期行事曆 /// </summary> /// <param name="model">畫面model</param> /// <param name="datas">回傳資料</param> /// <param name="msg">回傳訊息</param> /// <returns>bool</returns> public static bool LoadGuardCalendar(EmpGuardWorkTimeModel model, out List <DutyListBean> datas, out string msg) { bool result = false; msg = ""; datas = new List <DutyListBean>(); try { using (var conn = new SqlConnection() { ConnectionString = DbHelper.getConnectionStrings(_attendantDBName).ConnectionString }) { try { datas = conn.Query <DutyListBean>(WorkTimeSql.LoadGuardCalendar(model), model).ToList(); } catch (Exception) { throw; } } result = true; } catch (Exception ex) { msg = ex.Message; } return(result); }