//---- Работа с однотипными таблицами 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; } } } }
private void OKButton_Click(object sender, RoutedEventArgs e) { item = dataForm.CurrentItem as cListItem; }