public IList<Core.Business.SubsidiesApplicationContent> GetAllSubsidiesApplicationContent()
{
IList<Core.Business.SubsidiesApplicationContent> subsidiesApplicationContentlist = new List<Core.Business.SubsidiesApplicationContent>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectSubsidiesApplicationContentsAll");
if (reader != null)
{
while (reader.Read())
{
Core.Business.SubsidiesApplicationContent subsidiesApplicationContent = new Core.Business.SubsidiesApplicationContent();
if (!reader.IsDBNull(0)) subsidiesApplicationContent.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) subsidiesApplicationContent.ApplicationID = reader.GetGuid(1);
if (!reader.IsDBNull(2)) subsidiesApplicationContent.TestContent = reader.GetString(2);
if (!reader.IsDBNull(3)) subsidiesApplicationContent.InstrumentName = reader.GetString(3);
if (!reader.IsDBNull(4)) subsidiesApplicationContent.InstrumentCode = reader.GetString(4);
if (!reader.IsDBNull(5)) subsidiesApplicationContent.InstrumentUint = reader.GetString(5);
if (!reader.IsDBNull(6)) subsidiesApplicationContent.UserDate = reader.GetDateTime(6);
if (!reader.IsDBNull(7)) subsidiesApplicationContent.TestNub = reader.GetInt32(7);
if (!reader.IsDBNull(8)) subsidiesApplicationContent.MachineTime = reader.GetString(8);
if (!reader.IsDBNull(9)) subsidiesApplicationContent.MissionType = reader.GetGuid(9);
if (!reader.IsDBNull(10)) subsidiesApplicationContent.CommissionedPerson = reader.GetString(10);
if (!reader.IsDBNull(11)) subsidiesApplicationContent.TesterAndPhone = reader.GetString(11);
if (!reader.IsDBNull(12)) subsidiesApplicationContent.TotalCharge = reader.GetDouble(12);
if (!reader.IsDBNull(13)) subsidiesApplicationContent.InvoiceNub = reader.GetString(13);
if (!reader.IsDBNull(14)) subsidiesApplicationContent.Proportion = reader.GetInt32(14);
if (!reader.IsDBNull(15)) subsidiesApplicationContent.SubsidiesAmount = reader.GetDouble(15);
if (!reader.IsDBNull(16)) subsidiesApplicationContent.Status = reader.GetInt32(16);
if (!reader.IsDBNull(17)) subsidiesApplicationContent.Annex = reader.GetInt32(17);
subsidiesApplicationContent.MarkOld();
subsidiesApplicationContentlist.Add(subsidiesApplicationContent);
}
reader.Close();
}
return subsidiesApplicationContentlist;
}
public IList<Core.Business.SubsidiesApplicationContent> GetSubByAppIdAndStatus(string sqlwhere)
{
IList<Core.Business.SubsidiesApplicationContent> subsidiesApplicationContentlist = new List<Core.Business.SubsidiesApplicationContent>();
SqlServerUtility sql = new SqlServerUtility();
string sqlstr = "SELECT [Id],[ApplicationID],[TestContent],[InstrumentName],[InstrumentCode],[InstrumentUint],[UserDate],[TestNub],[MachineTime],[MissionType],[CommissionedPerson],[TesterAndPhone],[TotalCharge],[InvoiceNub],[Proportion],[SubsidiesAmount],[Status],[Annex] FROM [dbo].[SubsidiesApplicationContent]";
sqlstr += sqlwhere;
SqlDataReader reader = sql.ExecuteSqlReader(sqlstr);
if (reader != null)
{
while (reader.Read())
{
Core.Business.SubsidiesApplicationContent subsidiesApplicationContent = new Core.Business.SubsidiesApplicationContent();
if (!reader.IsDBNull(0)) subsidiesApplicationContent.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) subsidiesApplicationContent.ApplicationID = reader.GetGuid(1);
if (!reader.IsDBNull(2)) subsidiesApplicationContent.TestContent = reader.GetString(2);
if (!reader.IsDBNull(3)) subsidiesApplicationContent.InstrumentName = reader.GetString(3);
if (!reader.IsDBNull(4)) subsidiesApplicationContent.InstrumentCode = reader.GetString(4);
if (!reader.IsDBNull(5)) subsidiesApplicationContent.InstrumentUint = reader.GetString(5);
if (!reader.IsDBNull(6)) subsidiesApplicationContent.UserDate = reader.GetDateTime(6);
if (!reader.IsDBNull(7)) subsidiesApplicationContent.TestNub = reader.GetInt32(7);
if (!reader.IsDBNull(8)) subsidiesApplicationContent.MachineTime = reader.GetString(8);
if (!reader.IsDBNull(9)) subsidiesApplicationContent.MissionType = reader.GetGuid(9);
if (!reader.IsDBNull(10)) subsidiesApplicationContent.CommissionedPerson = reader.GetString(10);
if (!reader.IsDBNull(11)) subsidiesApplicationContent.TesterAndPhone = reader.GetString(11);
if (!reader.IsDBNull(12)) subsidiesApplicationContent.TotalCharge = reader.GetDouble(12);
if (!reader.IsDBNull(13)) subsidiesApplicationContent.InvoiceNub = reader.GetString(13);
if (!reader.IsDBNull(14)) subsidiesApplicationContent.Proportion = reader.GetInt32(14);
if (!reader.IsDBNull(15)) subsidiesApplicationContent.SubsidiesAmount = reader.GetDouble(15);
if (!reader.IsDBNull(16)) subsidiesApplicationContent.Status = reader.GetInt32(16);
if (!reader.IsDBNull(17)) subsidiesApplicationContent.Annex = reader.GetInt32(17);
subsidiesApplicationContent.MarkOld();
subsidiesApplicationContentlist.Add(subsidiesApplicationContent);
}
reader.Close();
}
return subsidiesApplicationContentlist;
}
public Core.Business.SubsidiesApplicationContent Select(Guid id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id);
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectSubsidiesApplicationContent");
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.SubsidiesApplicationContent subsidiesApplicationContent = new Core.Business.SubsidiesApplicationContent();
if (!reader.IsDBNull(0)) subsidiesApplicationContent.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) subsidiesApplicationContent.ApplicationID = reader.GetGuid(1);
if (!reader.IsDBNull(2)) subsidiesApplicationContent.TestContent = reader.GetString(2);
if (!reader.IsDBNull(3)) subsidiesApplicationContent.InstrumentName = reader.GetString(3);
if (!reader.IsDBNull(4)) subsidiesApplicationContent.InstrumentCode = reader.GetString(4);
if (!reader.IsDBNull(5)) subsidiesApplicationContent.InstrumentUint = reader.GetString(5);
if (!reader.IsDBNull(6)) subsidiesApplicationContent.UserDate = reader.GetDateTime(6);
if (!reader.IsDBNull(7)) subsidiesApplicationContent.TestNub = reader.GetInt32(7);
if (!reader.IsDBNull(8)) subsidiesApplicationContent.MachineTime = reader.GetString(8);
if (!reader.IsDBNull(9)) subsidiesApplicationContent.MissionType = reader.GetGuid(9);
if (!reader.IsDBNull(10)) subsidiesApplicationContent.CommissionedPerson = reader.GetString(10);
if (!reader.IsDBNull(11)) subsidiesApplicationContent.TesterAndPhone = reader.GetString(11);
if (!reader.IsDBNull(12)) subsidiesApplicationContent.TotalCharge = reader.GetDouble(12);
if (!reader.IsDBNull(13)) subsidiesApplicationContent.InvoiceNub = reader.GetString(13);
if (!reader.IsDBNull(14)) subsidiesApplicationContent.Proportion = reader.GetInt32(14);
if (!reader.IsDBNull(15)) subsidiesApplicationContent.SubsidiesAmount = reader.GetDouble(15);
if (!reader.IsDBNull(16)) subsidiesApplicationContent.Status = reader.GetInt32(16);
if (!reader.IsDBNull(17)) subsidiesApplicationContent.Annex = reader.GetInt32(17);
reader.Close();
return subsidiesApplicationContent;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
