//---вызов ХП заполнение реестра
public static List <cRD> lp_sel_RegistryData(int?ID, DateTime BeginDT, DateTime EndDT)
{
List <cRD> list = new List <cRD>();
using (SqlConnection conn = new SqlConnection(CommManager.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_sel_RegistryData");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Contractor_ID", objectOrNull(ID));
cmd.Parameters.AddWithValue("@BeginDT", BeginDT);
cmd.Parameters.AddWithValue("@EndDT", EndDT);
SqlDataReader Reader = cmd.ExecuteReader();
while (Reader.Read())
{
cRD item = new cRD();
if (!Reader.IsDBNull(Reader.GetOrdinal("Contractor")))
{
item.Contractor_Name = (string)Reader["Contractor"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("MassType")))
{
item.MassType = (string)Reader["MassType"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Sort")))
{
item.Sort_Name = (string)Reader["Sort"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("MassValue")))
{
item.Val = (double)Reader["MassValue"];
}
list.Add(item);
}
Reader.Close();
conn.Close();
}
return(list);
}
//---вызов ХП заполнение реестра
public static List<cRD> lp_sel_RegistryData(int? ID, DateTime BeginDT, DateTime EndDT)
{
List<cRD> list = new List<cRD>();
using (SqlConnection conn = new SqlConnection(CommManager.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_sel_RegistryData");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Contractor_ID", objectOrNull(ID));
cmd.Parameters.AddWithValue("@BeginDT", BeginDT);
cmd.Parameters.AddWithValue("@EndDT", EndDT);
SqlDataReader Reader = cmd.ExecuteReader();
while (Reader.Read())
{
cRD item = new cRD();
if (!Reader.IsDBNull(Reader.GetOrdinal("Contractor")))
item.Contractor_Name = (string)Reader["Contractor"];
if (!Reader.IsDBNull(Reader.GetOrdinal("MassType")))
item.MassType = (string)Reader["MassType"];
if (!Reader.IsDBNull(Reader.GetOrdinal("Sort")))
item.Sort_Name = (string)Reader["Sort"];
if (!Reader.IsDBNull(Reader.GetOrdinal("MassValue")))
item.Val = (double)Reader["MassValue"];
list.Add(item);
}
Reader.Close();
conn.Close();
}
return list;
}