public IList<Core.Business.SubsidiesApplication> GetSubsidiesApplicationBySqlwhere(string sqlwhere) { IList<Core.Business.SubsidiesApplication> subsidiesApplicationlist = new List<Core.Business.SubsidiesApplication>(); SqlServerUtility sql = new SqlServerUtility(); string sqlSelAll = "SELECT SubsidiesApplication.[Id],SubsidiesApplication.[SubsidiesID],SubsidiesApplication.[ApplicaiotnUser],SubsidiesApplication.[Type],SubsidiesApplication.[Status],SubsidiesApplication.[ApplicationTime],SubsidiesApplication.[Des],SubsidiesApplication.[AuditDes] FROM [dbo].[SubsidiesApplication]"; sqlSelAll += sqlwhere; SqlDataReader reader = sql.ExecuteSqlReader(sqlSelAll); if (reader != null) { while (reader.Read()) { Core.Business.SubsidiesApplication subsidiesApplication = new Core.Business.SubsidiesApplication(); if (!reader.IsDBNull(0)) subsidiesApplication.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) subsidiesApplication.SubsidiesID = reader.GetGuid(1); if (!reader.IsDBNull(2)) subsidiesApplication.ApplicaiotnUser = reader.GetGuid(2); if (!reader.IsDBNull(3)) subsidiesApplication.Type = reader.GetInt32(3); if (!reader.IsDBNull(4)) subsidiesApplication.Status = reader.GetInt32(4); if (!reader.IsDBNull(5)) subsidiesApplication.ApplicationTime = reader.GetDateTime(5); if (!reader.IsDBNull(6)) subsidiesApplication.Des = reader.GetString(6); if (!reader.IsDBNull(7)) subsidiesApplication.AuditDes = reader.GetString(7); subsidiesApplication.MarkOld(); subsidiesApplicationlist.Add(subsidiesApplication); } reader.Close(); } return subsidiesApplicationlist; }
public IList<Core.Business.SubsidiesApplication> GetAllSubsidiesApplication() { IList<Core.Business.SubsidiesApplication> subsidiesApplicationlist = new List<Core.Business.SubsidiesApplication>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectSubsidiesApplicationsAll"); if (reader != null) { while (reader.Read()) { Core.Business.SubsidiesApplication subsidiesApplication = new Core.Business.SubsidiesApplication(); if (!reader.IsDBNull(0)) subsidiesApplication.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) subsidiesApplication.SubsidiesID = reader.GetGuid(1); if (!reader.IsDBNull(2)) subsidiesApplication.ApplicaiotnUser = reader.GetGuid(2); if (!reader.IsDBNull(3)) subsidiesApplication.Type = reader.GetInt32(3); if (!reader.IsDBNull(4)) subsidiesApplication.Status = reader.GetInt32(4); if (!reader.IsDBNull(5)) subsidiesApplication.ApplicationTime = reader.GetDateTime(5); if (!reader.IsDBNull(6)) subsidiesApplication.Des = reader.GetString(6); if (!reader.IsDBNull(7)) subsidiesApplication.AuditDes = reader.GetString(7); subsidiesApplication.MarkOld(); subsidiesApplicationlist.Add(subsidiesApplication); } reader.Close(); } return subsidiesApplicationlist; }
public Core.Business.SubsidiesApplication SelectBySubIdAndUserId(string SubId, string UserId) { try { Guid sId = new Guid(SubId); Guid uId = new Guid(UserId); SqlServerUtility sql = new SqlServerUtility(); string sqlSel = "SELECT [Id],[SubsidiesID],[ApplicaiotnUser],[Type],[Status],[ApplicationTime],[Des],[AuditDes] FROM [dbo].[SubsidiesApplication] WHERE SubsidiesID='" + sId + "' AND ApplicaiotnUser='******'"; SqlDataReader reader = sql.ExecuteSqlReader(sqlSel); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.SubsidiesApplication subsidiesApplication = new Core.Business.SubsidiesApplication(); if (!reader.IsDBNull(0)) subsidiesApplication.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) subsidiesApplication.SubsidiesID = reader.GetGuid(1); if (!reader.IsDBNull(2)) subsidiesApplication.ApplicaiotnUser = reader.GetGuid(2); if (!reader.IsDBNull(3)) subsidiesApplication.Type = reader.GetInt32(3); if (!reader.IsDBNull(4)) subsidiesApplication.Status = reader.GetInt32(4); if (!reader.IsDBNull(5)) subsidiesApplication.ApplicationTime = reader.GetDateTime(5); if (!reader.IsDBNull(6)) subsidiesApplication.Des = reader.GetString(6); if (!reader.IsDBNull(7)) subsidiesApplication.AuditDes = reader.GetString(7); reader.Close(); return subsidiesApplication; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } } catch (Exception ex) { return null; } }
public IEnumerable<SubsidiesApplication> SelectSubsidiesApplication(Guid subcidies, int status) { IList<Core.Business.SubsidiesApplication> subsidiesApplicationlist = new List<Core.Business.SubsidiesApplication>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@subcidies", SqlDbType.UniqueIdentifier, subcidies); sql.AddParameter("@status", SqlDbType.Int, status); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectSubsidiesApplicationsByStatus"); if (reader != null) { while (reader.Read()) { Core.Business.SubsidiesApplication subsidiesApplication = new Core.Business.SubsidiesApplication(); if (!reader.IsDBNull(0)) subsidiesApplication.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) subsidiesApplication.SubsidiesID = reader.GetGuid(1); if (!reader.IsDBNull(2)) subsidiesApplication.ApplicaiotnUser = reader.GetGuid(2); if (!reader.IsDBNull(3)) subsidiesApplication.Type = reader.GetInt32(3); if (!reader.IsDBNull(4)) subsidiesApplication.Status = reader.GetInt32(4); if (!reader.IsDBNull(5)) subsidiesApplication.ApplicationTime = reader.GetDateTime(5); if (!reader.IsDBNull(6)) subsidiesApplication.Des = reader.GetString(6); if (!reader.IsDBNull(7)) subsidiesApplication.AuditDes = reader.GetString(7); subsidiesApplication.MarkOld(); subsidiesApplicationlist.Add(subsidiesApplication); } reader.Close(); } return subsidiesApplicationlist; }
public Core.Business.SubsidiesApplication Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectSubsidiesApplication"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.SubsidiesApplication subsidiesApplication = new Core.Business.SubsidiesApplication(); if (!reader.IsDBNull(0)) subsidiesApplication.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) subsidiesApplication.SubsidiesID = reader.GetGuid(1); if (!reader.IsDBNull(2)) subsidiesApplication.ApplicaiotnUser = reader.GetGuid(2); if (!reader.IsDBNull(3)) subsidiesApplication.Type = reader.GetInt32(3); if (!reader.IsDBNull(4)) subsidiesApplication.Status = reader.GetInt32(4); if (!reader.IsDBNull(5)) subsidiesApplication.ApplicationTime = reader.GetDateTime(5); if (!reader.IsDBNull(6)) subsidiesApplication.Des = reader.GetString(6); if (!reader.IsDBNull(7)) subsidiesApplication.AuditDes = reader.GetString(7); reader.Close(); return subsidiesApplication; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }