Esempio n. 1
0
    /// <summary>
    /// 取得單位工作地點
    /// </summary>
    /// <param name="model">畫面model</param>
    /// <param name="datas">回傳資料</param>
    /// <param name="msg">回傳訊息</param>
    /// <returns>bool</returns>
    public static bool LoadOrgWorkSite(EmpGuardWorkTimeModel model, out List <WorkSiteMobel> datas, out string msg)
    {
        bool result = false;

        msg   = "";
        datas = new List <WorkSiteMobel>();
        try
        {
            using (var conn = new SqlConnection()
            {
                ConnectionString = DbHelper.getConnectionStrings(_eHRMSDB_ITRD).ConnectionString
            })
            {
                try
                {
                    datas = conn.Query <WorkSiteMobel>(WorkTimeSql.LoadOrgWorkSite(), model).ToList();
                }
                catch (Exception)
                {
                    throw;
                }
            }
            result = true;
        }
        catch (Exception ex)
        {
            msg = ex.Message;
        }
        return(result);
    }