/// <summary> /// 取得班別下拉選單 /// </summary> /// <param name="model">畫面model</param> /// <param name="datas">回傳資料</param> /// <param name="msg">回傳訊息</param> /// <returns>bool</returns> public static bool LoadWTID(EmpWorkTimeModel 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.LoadWTID(), model).ToList(); } catch (Exception) { throw; } } result = true; } catch (Exception ex) { msg = ex.Message; } return(result); }