public cConsignmentEx()
{
CNote = new cConsignmentItem();
list_BacterialInsiminateClass = new List <cListItem>();
list_Contractor = new List <cListItem>();
list_PurityGroup = new List <cListItem>();
list_Sort = new List <cListItem>();
list_Status = new List <cListItem>();
//setMode('D');
}
//---- INSERT накладная
public void srv_work_Consignment(cConsignmentItem item,cFilter filter)
{
try
{
DataManager.ins_upd_ConsignmentNote(item);
client.notifyWorkConsignmentItem(1);
client.receiveConsignmentList(DataManager.sel_ConsignmentNote(filter));
}
catch
{
client.notifyWorkConsignmentItem(0);
}
}
//------ INSERT UPDATE накладной
public static int ins_upd_ConsignmentNote(cConsignmentItem C)
{
int ret = 0;
using (SqlConnection conn = new SqlConnection(CommManager.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_ins_upd_ConsignmentNote");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ConsignmentNoteID", objectOrNull(C.ID));
cmd.Parameters.AddWithValue("@DT_In", objectOrNull(C.DT_In));
cmd.Parameters.AddWithValue("@DT_Out", objectOrNull(C.DT_Out));
cmd.Parameters.AddWithValue("@ConsignmentNote_N", C.ConsigmentNote_N);
cmd.Parameters.AddWithValue("@Contractor_ID", objectOrNull(C.item_Contractor.ID));
cmd.Parameters.AddWithValue("@Sort_ID", objectOrNull(C.item_Sort.ID));
cmd.Parameters.AddWithValue("@PurityGroup_ID", objectOrNull(C.item_PurityGroup.ID));
cmd.Parameters.AddWithValue("@BacterialInsiminateClass_ID", objectOrNull(C.item_BacterialInsiminateClass.ID));
cmd.Parameters.AddWithValue("@Status_ID", objectOrNull(C.item_Status.ID));
cmd.Parameters.AddWithValue("@RichnessVal", objectOrNull(C.RichnessVal));
cmd.Parameters.AddWithValue("@MassBaseRichnessVal", objectOrNull(C.MassBaseRichnessVal));
cmd.Parameters.AddWithValue("@AcidityVal", objectOrNull(C.AcidityVal));
cmd.Parameters.AddWithValue("@TemperatureVal", objectOrNull(C.TemperatureVal));
cmd.Parameters.AddWithValue("@DensityVal", objectOrNull(C.DensityVal));
cmd.Parameters.AddWithValue("@ProteinVal", objectOrNull(C.ProteinVal));
cmd.Parameters.AddWithValue("@Comments", objectOrNull(C.Comments));
cmd.Parameters.AddWithValue("@VolumeVal", objectOrNull(C.VolumeVal));
cmd.Parameters.AddWithValue("@MassNetFactVal", objectOrNull(C.MassNetVal));
//cmd.Parameters.Add("@rowcount_out", SqlDbType.Int);
//cmd.Parameters["@rowcount_out"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
ret = 1;
//ret = (int)cmd.Parameters["@rowcount_out"].Value;
conn.Close();
}
return(ret);
}
public void srv_work_Consignment(cConsignmentItem item)
{
string t="";
try
{
DataManager.ins_upd_ConsignmentNote(item);
t = "Произведены изменения в таблице Consignments";
foreach (MDSClient c in Clients.Values.ToArray())
{
c.SendTableUpdated("Consignments");
}
}
catch (Exception err)
{
foreach (MDSClient c in Clients.Values.ToArray())
{
t = "Попытка вставки накладной не удалась, текст ошибки: " + err.Message;
c.SendMessage(t);
}
}
createNewMessage(t);
}
//----- 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);
}
public cConsignmentEx()
{
CNote = new cConsignmentItem();
list_BacterialInsiminateClass = new List<cListItem>();
list_Contractor = new List<cListItem>();
list_PurityGroup = new List<cListItem>();
list_Sort = new List<cListItem>();
list_Status = new List<cListItem>();
//setMode('D');
}
//------ INSERT UPDATE накладной
public static int ins_upd_ConsignmentNote(cConsignmentItem C)
{
int ret = 0;
using (SqlConnection conn = new SqlConnection(CommManager.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_ins_upd_ConsignmentNote");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ConsignmentNoteID", objectOrNull(C.ID));
cmd.Parameters.AddWithValue("@DT_In", objectOrNull(C.DT_In));
cmd.Parameters.AddWithValue("@DT_Out", objectOrNull(C.DT_Out));
cmd.Parameters.AddWithValue("@ConsignmentNote_N", C.ConsigmentNote_N);
cmd.Parameters.AddWithValue("@Contractor_ID", objectOrNull(C.item_Contractor.ID));
cmd.Parameters.AddWithValue("@Sort_ID", objectOrNull(C.item_Sort.ID));
cmd.Parameters.AddWithValue("@PurityGroup_ID", objectOrNull(C.item_PurityGroup.ID));
cmd.Parameters.AddWithValue("@BacterialInsiminateClass_ID", objectOrNull(C.item_BacterialInsiminateClass.ID));
cmd.Parameters.AddWithValue("@Status_ID", objectOrNull(C.item_Status.ID));
cmd.Parameters.AddWithValue("@RichnessVal", objectOrNull(C.RichnessVal));
cmd.Parameters.AddWithValue("@MassBaseRichnessVal", objectOrNull(C.MassBaseRichnessVal));
cmd.Parameters.AddWithValue("@AcidityVal", objectOrNull(C.AcidityVal));
cmd.Parameters.AddWithValue("@TemperatureVal", objectOrNull(C.TemperatureVal));
cmd.Parameters.AddWithValue("@DensityVal", objectOrNull(C.DensityVal));
cmd.Parameters.AddWithValue("@ProteinVal", objectOrNull(C.ProteinVal));
cmd.Parameters.AddWithValue("@Comments", objectOrNull(C.Comments));
cmd.Parameters.AddWithValue("@VolumeVal", objectOrNull(C.VolumeVal));
cmd.Parameters.AddWithValue("@MassNetFactVal", objectOrNull(C.MassNetVal));
//cmd.Parameters.Add("@rowcount_out", SqlDbType.Int);
//cmd.Parameters["@rowcount_out"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
ret = 1;
//ret = (int)cmd.Parameters["@rowcount_out"].Value;
conn.Close();
}
return ret;
}
//----- 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;
}