//--- Конструктор -----------------------------------------------------
public uc_TTN_list(string name)
{
InitializeComponent();
Loaded += new RoutedEventHandler(uc_TTNList_Loaded);
Unloaded += new RoutedEventHandler(uc_TTN_list_Unloaded);
thisName = name + ":" + thisName;
ucFilter = new cFilterList();
ucFilter.refreshFilterDatePeriod(null, null);
panel_control.DataContext = ucFilter;
dg_Root.ItemsSource = new List<cConsignmentItem>();
}
static void Main(string[] args)
{
string OpStatus;
int id = 152;
cConsignmentEx C_Ex = new cConsignmentEx();
try
{
C_Ex.list_BacterialInsiminateClass = DataManager.sel_DatFromLists("BacterialInsiminateClassList");
C_Ex.list_Contractor = DataManager.sel_DatFromLists("ContractorList");
C_Ex.list_PurityGroup = DataManager.sel_DatFromLists("PurityGroupList");
C_Ex.list_Sort = DataManager.sel_DatFromLists("SortList");
C_Ex.list_Status = DataManager.sel_DatFromLists("StatusList");
if (id != null)
{
cFilterList filter = new cFilterList();
filter.ConsignmentNoteID = id;
C_Ex.CNote = DataManager.sel_ConsignmentNote(filter).ToList()[0];
C_Ex.setCurrentItemsIndexes();
}
else
{
C_Ex.CNote = new cConsignmentItem();
C_Ex.CNote.item_BacterialInsiminateClass = C_Ex.list_BacterialInsiminateClass[0];
C_Ex.CNote.item_Contractor = C_Ex.list_Contractor[0];
C_Ex.CNote.item_PurityGroup = C_Ex.list_PurityGroup[0];
C_Ex.CNote.item_Sort = C_Ex.list_Sort[0];
C_Ex.CNote.item_Status = C_Ex.list_Status[0];
}
OpStatus = "Операция выполнена успешно";
}
catch (Exception err)
{
OpStatus = err.ToString();
}
}
//--- Конфигурация ------------------------------------------------------
public void configure(cFilterList filter, int DataGridHeight = 400)
{
}
public List<cConsignmentItem> srv_select_ConsignmentList(cFilterList filter, out string statusString)
{
try
{
statusString = filter.StatusIDString;
return DataManager.sel_ConsignmentNote(filter);
}
catch
{
statusString = filter.StatusIDString;
return null;
}
}
//----- SELECT списка накладных или одной накладной ------------------------------
public static List <cConsignmentItem> sel_ConsignmentNote(cFilterList filter)
{
List <cConsignmentItem> list = new List <cConsignmentItem>();
using (SqlConnection conn = new SqlConnection(CommManager.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_sel_ConsignmentNote");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
// @ConsignmentNoteID int = null
// @BeginDT smalldatetime = null
// @EndDT smalldatetime = null
// @StatusID int = null
cmd.Parameters.AddWithValue("@ConsignmentNoteID", objectOrNull(filter.ConsignmentNoteID));
cmd.Parameters.AddWithValue("@BeginDT", objectOrNull(filter.BeginDT));
cmd.Parameters.AddWithValue("@EndDT", objectOrNull(filter.EndDT));
cmd.Parameters.AddWithValue("@StatusID", objectOrNull(filter.StatusIDString));
SqlDataReader Reader = cmd.ExecuteReader();
while (Reader.Read())
{
cConsignmentItem item = new cConsignmentItem();
if (!Reader.IsDBNull(Reader.GetOrdinal("ID")))
{
item.ID = (int)Reader["ID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("DT_In")))
{
item.DT_In = (DateTime)Reader["DT_In"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("DT_Out")))
{
item.DT_Out = (DateTime)Reader["DT_Out"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("ConsignmentNote_N")))
{
item.ConsigmentNote_N = (string)Reader["ConsignmentNote_N"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Contractor_ID")))
{
item.item_Contractor.ID = (int)Reader["Contractor_ID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("ContractorName")))
{
item.item_Contractor.Name = (string)Reader["ContractorName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("ContractorShortName")))
{
item.item_Contractor.Short = (string)Reader["ContractorShortName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Sort_ID")))
{
item.item_Sort.ID = (int)Reader["Sort_ID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("SortName")))
{
item.item_Sort.Name = (string)Reader["SortName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("SortShortName")))
{
item.item_Sort.Short = (string)Reader["SortShortName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("PurityGroup_ID")))
{
item.item_PurityGroup.ID = (int)Reader["PurityGroup_ID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("PurityGroupName")))
{
item.item_PurityGroup.Name = (string)Reader["PurityGroupName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("PurityGroupShortName")))
{
item.item_PurityGroup.Short = (string)Reader["PurityGroupShortName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("BacterialInsiminateClass_ID")))
{
item.item_BacterialInsiminateClass.ID = (int)Reader["BacterialInsiminateClass_ID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("BacterialInsiminateClassName")))
{
item.item_BacterialInsiminateClass.Name = (string)Reader["BacterialInsiminateClassName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("BacterialInsiminateClassShortName")))
{
item.item_BacterialInsiminateClass.Short = (string)Reader["BacterialInsiminateClassShortName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Status_ID")))
{
item.item_Status.ID = (int)Reader["Status_ID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("StatusName")))
{
item.item_Status.Name = (string)Reader["StatusName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("StatusShortName")))
{
item.item_Status.Short = (string)Reader["StatusShortName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("RichnessVal")))
{
item.RichnessVal = (double)Reader["RichnessVal"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("MassBaseRichnessVal")))
{
item.MassBaseRichnessVal = (double)Reader["MassBaseRichnessVal"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("AcidityVal")))
{
item.AcidityVal = (double)Reader["AcidityVal"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("TemperatureVal")))
{
item.TemperatureVal = (double)Reader["TemperatureVal"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("DensityVal")))
{
item.DensityVal = (double)Reader["DensityVal"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("MassNetVal")))
{
item.MassNetVal = (double)Reader["MassNetVal"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("VolumeVal")))
{
item.VolumeVal = (double)Reader["VolumeVal"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("MassNetFactVal")))
{
item.MassNetFactVal = (double)Reader["MassNetFactVal"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Comments")))
{
item.Comments = (string)Reader["Comments"];
}
list.Add(item);
}
Reader.Close();
conn.Close();
}
return(list);
}
//----- SELECT списка накладных или одной накладной ------------------------------
public static List<cConsignmentItem> sel_ConsignmentNote(cFilterList filter)
{
List<cConsignmentItem> list = new List<cConsignmentItem>();
using (SqlConnection conn = new SqlConnection(CommManager.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_sel_ConsignmentNote");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
// @ConsignmentNoteID int = null
// @BeginDT smalldatetime = null
// @EndDT smalldatetime = null
// @StatusID int = null
cmd.Parameters.AddWithValue("@ConsignmentNoteID", objectOrNull(filter.ConsignmentNoteID));
cmd.Parameters.AddWithValue("@BeginDT", objectOrNull(filter.BeginDT));
cmd.Parameters.AddWithValue("@EndDT", objectOrNull(filter.EndDT));
cmd.Parameters.AddWithValue("@StatusID", objectOrNull(filter.StatusIDString));
SqlDataReader Reader = cmd.ExecuteReader();
while (Reader.Read())
{
cConsignmentItem item = new cConsignmentItem();
if (!Reader.IsDBNull(Reader.GetOrdinal("ID")))
item.ID = (int)Reader["ID"];
if (!Reader.IsDBNull(Reader.GetOrdinal("DT_In")))
item.DT_In = (DateTime)Reader["DT_In"];
if (!Reader.IsDBNull(Reader.GetOrdinal("DT_Out")))
item.DT_Out = (DateTime)Reader["DT_Out"];
if (!Reader.IsDBNull(Reader.GetOrdinal("ConsignmentNote_N")))
item.ConsigmentNote_N = (string)Reader["ConsignmentNote_N"];
if (!Reader.IsDBNull(Reader.GetOrdinal("Contractor_ID")))
item.item_Contractor.ID = (int)Reader["Contractor_ID"];
if (!Reader.IsDBNull(Reader.GetOrdinal("ContractorName")))
item.item_Contractor.Name = (string)Reader["ContractorName"];
if (!Reader.IsDBNull(Reader.GetOrdinal("ContractorShortName")))
item.item_Contractor.Short = (string)Reader["ContractorShortName"];
if (!Reader.IsDBNull(Reader.GetOrdinal("Sort_ID")))
item.item_Sort.ID = (int)Reader["Sort_ID"];
if (!Reader.IsDBNull(Reader.GetOrdinal("SortName")))
item.item_Sort.Name = (string)Reader["SortName"];
if (!Reader.IsDBNull(Reader.GetOrdinal("SortShortName")))
item.item_Sort.Short = (string)Reader["SortShortName"];
if (!Reader.IsDBNull(Reader.GetOrdinal("PurityGroup_ID")))
item.item_PurityGroup.ID = (int)Reader["PurityGroup_ID"];
if (!Reader.IsDBNull(Reader.GetOrdinal("PurityGroupName")))
item.item_PurityGroup.Name = (string)Reader["PurityGroupName"];
if (!Reader.IsDBNull(Reader.GetOrdinal("PurityGroupShortName")))
item.item_PurityGroup.Short = (string)Reader["PurityGroupShortName"];
if (!Reader.IsDBNull(Reader.GetOrdinal("BacterialInsiminateClass_ID")))
item.item_BacterialInsiminateClass.ID = (int)Reader["BacterialInsiminateClass_ID"];
if (!Reader.IsDBNull(Reader.GetOrdinal("BacterialInsiminateClassName")))
item.item_BacterialInsiminateClass.Name = (string)Reader["BacterialInsiminateClassName"];
if (!Reader.IsDBNull(Reader.GetOrdinal("BacterialInsiminateClassShortName")))
item.item_BacterialInsiminateClass.Short = (string)Reader["BacterialInsiminateClassShortName"];
if (!Reader.IsDBNull(Reader.GetOrdinal("Status_ID")))
item.item_Status.ID = (int)Reader["Status_ID"];
if (!Reader.IsDBNull(Reader.GetOrdinal("StatusName")))
item.item_Status.Name = (string)Reader["StatusName"];
if (!Reader.IsDBNull(Reader.GetOrdinal("StatusShortName")))
item.item_Status.Short = (string)Reader["StatusShortName"];
if (!Reader.IsDBNull(Reader.GetOrdinal("RichnessVal")))
item.RichnessVal = (double)Reader["RichnessVal"];
if (!Reader.IsDBNull(Reader.GetOrdinal("MassBaseRichnessVal")))
item.MassBaseRichnessVal = (double)Reader["MassBaseRichnessVal"];
if (!Reader.IsDBNull(Reader.GetOrdinal("AcidityVal")))
item.AcidityVal = (double)Reader["AcidityVal"];
if (!Reader.IsDBNull(Reader.GetOrdinal("TemperatureVal")))
item.TemperatureVal = (double)Reader["TemperatureVal"];
if (!Reader.IsDBNull(Reader.GetOrdinal("DensityVal")))
item.DensityVal = (double)Reader["DensityVal"];
if (!Reader.IsDBNull(Reader.GetOrdinal("MassNetVal")))
item.MassNetVal = (double)Reader["MassNetVal"];
if (!Reader.IsDBNull(Reader.GetOrdinal("VolumeVal")))
item.VolumeVal = (double)Reader["VolumeVal"];
if (!Reader.IsDBNull(Reader.GetOrdinal("MassNetFactVal")))
item.MassNetFactVal = (double)Reader["MassNetFactVal"];
if (!Reader.IsDBNull(Reader.GetOrdinal("Comments")))
item.Comments = (string)Reader["Comments"];
list.Add(item);
}
Reader.Close();
conn.Close();
}
return list;
}
