/// <summary> /// 获取指定id任务数据 /// </summary> /// <param name="TaskID">任务id</param> /// <returns>任务数据</returns> public static TaskLogUtil GetLogById(string LogID) { return(SQLHelper.Single <TaskLogUtil>( @"SELECT p_Tasklog.*,p_Task.TaskName FROM dbo.p_Tasklog LEFT JOIN dbo.p_Task ON dbo.p_Task.TaskID = p_Tasklog.TaskId WHERE LogID=@LogID", new { LogID = LogID })); }
/// <summary> /// 获取指定id任务数据 /// </summary> /// <param name="TaskID">任务id</param> /// <returns>任务数据</returns> public static TaskUtil GetById(string TaskID) { return(SQLHelper.Single <TaskUtil>("SELECT * FROM p_Task WHERE TaskID=@TaskID", new { TaskID = TaskID })); }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="UserGUID">用户GUID</param> /// <returns>用户信息</returns> public UserAccount GetUserInfo(string UserGUID) { string strSQL = "SELECT * from p_User WHERE UserGUID = @UserGUID limit 1 offset 0"; return(SQLHelper.Single <UserAccount>(strSQL, new { UserGUID = UserGUID })); }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="UserCode">用户Code</param> /// <param name="Password">密码</param> /// <returns>用户信息</returns> public UserAccount GetUserInfo(string UserCode, string Password) { string strSQL = "SELECT * from p_User WHERE UserCode = @UserCode and Password=@Password limit 1 offset 0"; return(SQLHelper.Single <UserAccount>(strSQL, new { UserCode = UserCode, Password = Password })); }
/// <summary> /// 通过消息GUID获取消息数据 /// </summary> /// <param name="MessageGuid">消息GUID</param> /// <returns>消息</returns> public static Message GetMessageById(Guid MessageGuid) { return(SQLHelper.Single <Message>("SELECT * FROM dbo.p_Message WHERE MessageGuid=@MessageGuid", new { MessageGuid = MessageGuid })); }