//---- Работа с однотипными таблицами
public static int work_DataFromLists(string tblName, string actionType, cListItem insItem)
{
int ret = 0;
using (SqlConnection conn = new SqlConnection(CommManager.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_work_DataFromLists");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
// @TableName
//,@ActType
//,@ID
//,@ID_1C
//,@Name
//,@Short
cmd.Parameters.AddWithValue("@TableName", tblName);
cmd.Parameters.AddWithValue("@ActType", actionType);
cmd.Parameters.AddWithValue("@ID", objectOrNull(insItem.ID));
cmd.Parameters.AddWithValue("@Name", objectOrNull(insItem.Name));
cmd.Parameters.AddWithValue("@Short", objectOrNull(insItem.Short));
cmd.Parameters.Add("@rowcount_out", SqlDbType.Int);
cmd.Parameters["@rowcount_out"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
ret = (int)cmd.Parameters["@rowcount_out"].Value;
conn.Close();
}
return ret;
}
void cwnd_ListItemDF_Loaded(object sender, RoutedEventArgs e)
{
item = new cListItem();
List<cListItem> list = new List<cListItem>();
list.Add(item);
this.DataContext = list;
}
public cConsignmentItem()
{
item_BacterialInsiminateClass = new cListItem();
item_Contractor = new cListItem();
item_PurityGroup = new cListItem();
item_Sort = new cListItem();
item_Status = new cListItem();
DT_In = DateTime.Now;
}
//---- Работа с однотипными таблицами
public void srv_work_DataFromLists(string tbl, string action, cListItem item)
{
client = OperationContext.Current.GetCallbackChannel<IDuplexClient>();
try
{
DataManager.work_DataFromLists(tbl, action, item);
client.notifyWorkDataFromList(1);
}
catch
{
client.notifyWorkDataFromList(0);
}
}
private void setItem(cListItem item, List <cListItem> list)
{
if ((list != null) & (item != null))
{
foreach (var i in list)
{
if (i.ID == item.ID)
{
item.orderN = i.orderN;
break;
}
}
}
}
//---- SELECT данных из однотипных таблиц
public static List <cListItem> sel_DatFromLists(string tblName)
{
List <cListItem> list = new List <cListItem>();
using (SqlConnection conn = new SqlConnection(CommManager.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_work_DataFromLists");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TableName", tblName);
cmd.Parameters.AddWithValue("@ActType", "sel");
cmd.Parameters.Add("@rowcount_out", SqlDbType.Int);
cmd.Parameters["@rowcount_out"].Direction = ParameterDirection.Output;
SqlDataReader Reader = cmd.ExecuteReader();
int i = 0;
while (Reader.Read())
{
cListItem item = new cListItem();
if (!Reader.IsDBNull(Reader.GetOrdinal("ID")))
{
item.ID = (int)Reader["ID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Name")))
{
item.Name = (string)Reader["Name"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Short")))
{
item.Short = (string)Reader["Short"];
}
item.orderN = i;
i++;
list.Add(item);
}
Reader.Close();
conn.Close();
}
return(list);
}
//---- SELECT данных из однотипных таблиц
public static List<cListItem> sel_DatFromLists(string tblName)
{
List<cListItem> list = new List<cListItem>();
using (SqlConnection conn = new SqlConnection(CommManager.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_work_DataFromLists");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TableName", tblName);
cmd.Parameters.AddWithValue("@ActType", "sel");
cmd.Parameters.Add("@rowcount_out", SqlDbType.Int);
cmd.Parameters["@rowcount_out"].Direction = ParameterDirection.Output;
SqlDataReader Reader = cmd.ExecuteReader();
int i = 0;
while (Reader.Read())
{
cListItem item = new cListItem();
if (!Reader.IsDBNull(Reader.GetOrdinal("ID")))
item.ID = (int)Reader["ID"];
if (!Reader.IsDBNull(Reader.GetOrdinal("Name")))
item.Name = (string)Reader["Name"];
if (!Reader.IsDBNull(Reader.GetOrdinal("Short")))
item.Short = (string)Reader["Short"];
item.orderN = i;
i++;
list.Add(item);
}
Reader.Close();
conn.Close();
}
return list;
}
//---- Работа с однотипными таблицами
public static int work_DataFromLists(string tblName, string actionType, cListItem insItem)
{
int ret = 0;
using (SqlConnection conn = new SqlConnection(CommManager.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_work_DataFromLists");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
// @TableName
//,@ActType
//,@ID
//,@ID_1C
//,@Name
//,@Short
cmd.Parameters.AddWithValue("@TableName", tblName);
cmd.Parameters.AddWithValue("@ActType", actionType);
cmd.Parameters.AddWithValue("@ID", objectOrNull(insItem.ID));
cmd.Parameters.AddWithValue("@Name", objectOrNull(insItem.Name));
cmd.Parameters.AddWithValue("@Short", objectOrNull(insItem.Short));
cmd.Parameters.Add("@rowcount_out", SqlDbType.Int);
cmd.Parameters["@rowcount_out"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
ret = (int)cmd.Parameters["@rowcount_out"].Value;
conn.Close();
}
return(ret);
}
private void setItem(cListItem item, List<cListItem> list)
{
if ((list != null) & (item != null))
{
foreach (var i in list)
{
if (i.ID == item.ID)
{
item.orderN = i.orderN;
break;
}
}
}
}
public cConsignmentItem()
{
item_BacterialInsiminateClass = new cListItem();
item_Contractor = new cListItem();
item_PurityGroup = new cListItem();
item_Sort = new cListItem();
item_Status = new cListItem();
DT_In = DateTime.Now;
}
private void OKButton_Click(object sender, RoutedEventArgs e)
{
item = dataForm.CurrentItem as cListItem;
}
