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();
}
