string ENTITY;//сущность, которой принадлежат категории public EditWPSubCategory(int IDCat, string Entity_) { this.ENTITY = Entity_; InitializeComponent(); this.IDCat = IDCat; DBSubCategory dbc = new DBSubCategory(); dgWP.DataSource = dbc.GetAll(IDCat); dgWP.Columns["ID"].Visible = false; dgWP.Columns["IDCATEGORY"].Visible = false; dgWP.Columns["SUBCATNAME"].HeaderText = "Наименование подкатегории"; dgWP.Columns["SUBCATNAME"].Width = 200; dgWP.Columns["srt"].Visible = false; this.Text = "Подкатегории категории \"" + new DBCategory(this.ENTITY).GetName(IDCat) + "\""; switch (this.ENTITY) { case "WPNAMELIST": this.Text = "Подкатегории изделия"; break; case "CABLELIST": this.Text = "Подкатегории кабелей"; break; case "ZHGUTLIST": this.Text = "Подкатегории жгутов"; break; case "RUNCARDLIST": this.Text = "Подкатегории технологических карт"; break; } }
private void cbCAT_SelectedIndexChanged(object sender, EventArgs e) { if ((cbCAT.Text.ToUpper() == "ВСЕ") || (cbCAT.Text.ToUpper() == "НЕ ПРИСВОЕНО")) { cbSubCat.Text = ""; cbSubCat.Enabled = false; } else { cbSubCat.Enabled = true; DBSubCategory dbs = new DBSubCategory(); cbSubCat.ValueMember = "ID"; cbSubCat.DisplayMember = "SUBCATNAME"; cbSubCat.DataSource = dbs.GetAll(Convert.ToInt32(cbCAT.SelectedValue)); //cbSubCat.SelectedItem = cbCAT.Items[0]; cbSubCat.SelectedIndex = 1; } switch (WPT) { case WPTYPE.ZHGUTLIST: //zhgut FillDGV_ZHGUTLIST(); break; case WPTYPE.CABLELIST: //cable FillDGV_CABLELIST(); break; } }
public DataTable GetCategoryWPNames(int IDCAT, int IDSUBCAT) { if (IDCAT == 2) { return(this.GetAllWPNames()); } string sub = new DBSubCategory().GetNameByID(IDSUBCAT); if (sub.ToUpper() == "ВСЕ") { DA.SelectCommand.CommandText = "select A.ID,A.WPNAME,B.CATEGORYNAME,isnull(C.SUBCATNAME,'НЕ ПРИСВОЕНО') SUBCATNAME,A.DECNUM,A.TECHREQ,A.COMPOSITION,A.NOTE from " + Base.BaseName + "..WPNAMELIST A left join " + Base.BaseName + "..CATEGORYLIST B on B.ID = IDCATEGORY " + " left join " + Base.BaseName + "..SUBCATEGORYLIST C on C.ID = A.IDSUBCAT " + " where A.IDCATEGORY = " + IDCAT + " order by WPNAME"; } else if (sub.ToUpper() == "НЕ ПРИСВОЕНО") { DA.SelectCommand.CommandText = "select A.ID,A.WPNAME,B.CATEGORYNAME,isnull(C.SUBCATNAME,'НЕ ПРИСВОЕНО') SUBCATNAME,A.DECNUM,A.TECHREQ,A.COMPOSITION,A.NOTE from " + Base.BaseName + "..WPNAMELIST A left join " + Base.BaseName + "..CATEGORYLIST B on B.ID = IDCATEGORY " + " left join " + Base.BaseName + "..SUBCATEGORYLIST C on C.ID = A.IDSUBCAT " + " where A.IDCATEGORY = " + IDCAT + " and ((A.IDSUBCAT is null) or (C.SUBCATNAME = 'НЕ ПРИСВОЕНО')) order by WPNAME"; } else { DA.SelectCommand.CommandText = "select A.ID,A.WPNAME,B.CATEGORYNAME,isnull(C.SUBCATNAME,'НЕ ПРИСВОЕНО') SUBCATNAME,A.DECNUM,A.TECHREQ,A.COMPOSITION,A.NOTE from " + Base.BaseName + "..WPNAMELIST A left join " + Base.BaseName + "..CATEGORYLIST B on B.ID = IDCATEGORY " + " left join " + Base.BaseName + "..SUBCATEGORYLIST C on C.ID = A.IDSUBCAT " + " where A.IDCATEGORY = " + IDCAT + " and (A.IDSUBCAT = " + IDSUBCAT + ") order by WPNAME"; } DS = new DataSet(); int h = DA.Fill(DS, "t"); return(DS.Tables["t"]); }
private void LoadSubs(int idCat) { DBSubCategory dbs = new DBSubCategory(); cbSubCategory.ValueMember = "ID"; cbSubCategory.DisplayMember = "SUBCATNAME"; cbSubCategory.DataSource = dbs.GetAllExceptAll(idCat); }
private void LoadSubs(int idCat) { if ((idCat == 1) || (idCat == 2)) { cbSubCategory.Text = ""; cbSubCategory.Enabled = false; } if (!viewonly) { cbSubCategory.Enabled = true; } DBSubCategory dbs = new DBSubCategory(); cbSubCategory.ValueMember = "ID"; cbSubCategory.DisplayMember = "SUBCATNAME"; cbSubCategory.DataSource = dbs.GetAllExceptAll(idCat); DBWPName dbwp = new DBWPName(); WPNameVO wp = WPNameVO.WPNameVOByID(this.IDW); cbSubCategory.SelectedValue = wp.IDSubCat; }
private void button2_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("Введите наименование!"); return; } if (edit) { DBSubCategory dbwp = new DBSubCategory(); dbwp.Edit(textBox1.Text, editID.ToString()); MessageBox.Show("Подкатегория успешно изменена!"); } else { DBSubCategory dbwp = new DBSubCategory(); dbwp.AddNew(textBox1.Text, IDCat); MessageBox.Show("Подкатегория успешно добавлена!"); } Close(); }