//--- Конструктор ----------------------------------------------------- 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; }