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;
}
}
