Ejemplo n.º 1
0
    /// <summary>
    /// 查詢EmpWorkTime資料(新增頁)
    /// </summary>
    /// <param name="model">畫面model</param>
    /// <param name="datas">回傳資料</param>
    /// <param name="msg">回傳訊息</param>
    /// <returns>bool</returns>
    public static bool LoadEmpWorkTimeGridData_Add(EmpWorkTimeModel model, out List <QueryListBean> datas, out string msg)
    {
        bool result = false;

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