void IProduct.FillTableLayoutPanel(TableLayoutPanel TLP, IRole UVO) { ZhgutVO wp = (ZhgutVO)this; TextBox tb = new TextBox(); DBCategory dbc = new DBCategory("ZHGUTLIST"); tb.Text = dbc.GetName(wp.IDCat); tb.Anchor = AnchorStyles.Left | AnchorStyles.Right; tb.ReadOnly = true; tb.Dock = DockStyle.Fill; UIWorks.AddToTLP(TLP, "Категория", tb); tb = new TextBox(); DBSubCategory dbsc = new DBSubCategory(); tb.Text = dbsc.GetName(wp.IDSubCat); tb.Anchor = AnchorStyles.Left | AnchorStyles.Right; tb.ReadOnly = true; tb.Dock = DockStyle.Fill; UIWorks.AddToTLP(TLP, "Подкатегория", tb); PathField pf = new PathField(); pf.Tag = Roles.Inzhener; pf.Init(wp.ZHGUTPATH, true, false, false, true, Roles.Inzhener, "VIEWONLY", UVO, "ZHGUTPATH", null, this); pf.bDelVisible = false; pf.bPathVisible = false; pf.tbPath.Dock = DockStyle.Fill; pf.Dock = DockStyle.Fill; pf.bRemark.Visible = false; UIWorks.AddToTLP(TLP, "Изготовление жгута", pf); }
public static bool UpdateSubCategoryById(string idSubCategory, string idCategory, string name) { try { string[] subCategory = new string[] { idSubCategory, name }; if (ValidateData.VerifyFields(subCategory)) { SubCategoryModel subCategoryModel = new SubCategoryModel() { IdsubCategory = int.Parse(idSubCategory), IdCategory = int.Parse(idCategory), Name = name }; DBSubCategory.UpdateSubCategory(subCategoryModel); return(true); } else { return(false); } } catch (Exception ex) { //Log4Net return(false); } }
/// <summary> /// /// </summary> /// <param name="name"></param> /// <param name="idCategory"></param> /// <returns></returns> public static bool InsertSubCategory(string name, string idCategory) { try { string[] subCategory = new string[] { name, idCategory }; if (ValidateData.VerifyFields(subCategory)) { SubCategoryModel subCategoryModel = new SubCategoryModel() { IdCategory = int.Parse(idCategory), Name = name, }; DBSubCategory.InsertSubCategory(subCategoryModel); return(true); } else { return(false); } } catch (Exception ex) { return(false); //Log4Net } }
/// <summary> /// /// </summary> /// <returns></returns> public static List <SubCategoryModel> SelectAllSubCategories() { try { return(DBSubCategory.SelectSubCategoryAll()); } catch (Exception ex) { //Log4Net return(null); } }
/// <summary> /// /// </summary> /// <param name="idSubCategory"></param> /// <returns></returns> public static List <SubCategoryModel> SelectCatWithSub(int idCategory) { try { SubCategoryModel subCategoryModel = new SubCategoryModel() { IdCategory = idCategory, }; return(DBSubCategory.SelectCatWithSub(subCategoryModel)); } catch (Exception ex) { //Log4Net return(null); } }
public DataTable GetCategoryZhgutList(int IDCAT, int IDSUBCAT) { if (IDCAT == 15) { return(this.GetAllZhguts()); } string sub = new DBSubCategory().GetNameByID(IDSUBCAT); if (sub.ToUpper() == "ВСЕ") { DA.SelectCommand.CommandText = "select A.ID,A.ZHGUTNAME,B.CATEGORYNAME,isnull(C.SUBCATNAME,'НЕ ПРИСВОЕНО') SUBCATNAME,A.DECNUM,A.ZHGUTPATH,A.NOTE from " + Base.BaseName + "..ZHGUTLIST 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 ZHGUTNAME"; } else if (sub.ToUpper() == "НЕ ПРИСВОЕНО") { DA.SelectCommand.CommandText = "select A.ID,A.ZHGUTNAME,B.CATEGORYNAME,isnull(C.SUBCATNAME,'НЕ ПРИСВОЕНО') SUBCATNAME,A.DECNUM,A.ZHGUTPATH,A.NOTE from " + Base.BaseName + "..ZHGUTLIST 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 ZHGUTNAME"; } else { DA.SelectCommand.CommandText = "select A.ID,A.ZHGUTNAME,B.CATEGORYNAME,isnull(C.SUBCATNAME,'НЕ ПРИСВОЕНО') SUBCATNAME,A.DECNUM,A.ZHGUTPATH,A.NOTE from " + Base.BaseName + "..ZHGUTLIST 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 ZHGUTNAME"; } DS = new DataSet(); int h = DA.Fill(DS, "t"); return(DS.Tables["t"]); }
public static bool DeleteSubCategoryById(string idSubCategory) { try { string[] subCategory = new string[] { idSubCategory }; if (ValidateData.VerifyFields(subCategory)) { SubCategoryModel subCategoryModel = new SubCategoryModel() { IdsubCategory = int.Parse(idSubCategory) }; return(DBSubCategory.DeleteSubCategory(subCategoryModel)); } else { return(false); } } catch (Exception ex) { return(false); //Log4Net } }
public static SubCategoryModel SelectSubCategoryById(string id) { try { string[] subCategory = new string[] { id }; if (ValidateData.VerifyFields(subCategory)) { SubCategoryModel subCategoryModel = new SubCategoryModel() { IdsubCategory = int.Parse(id) }; return(DBSubCategory.SelectSubCategoryById(subCategoryModel)); } else { return(null); } } catch (Exception ex) { //Log4Net return(null); } }
public static List <SubCategoryModel> SelectSubCategoryByNames(string name) { try { string[] subCategory = new string[] { name }; if (ValidateData.VerifyFields(subCategory)) { SubCategoryModel subCategoryModel = new SubCategoryModel() { Name = name }; return(DBSubCategory.SelectSubCategoryNameLike(subCategoryModel)); } else { return(null); } } catch (Exception ex) { //Log4Net return(null); } }
void IProduct.FillTableLayoutPanel(TableLayoutPanel TLP, IRole UVO) { CableVO wp = (CableVO)this; TextBox tb = new TextBox(); DBCategory dbc = new DBCategory("CABLELIST"); tb.Text = dbc.GetName(wp.IDCat); tb.Anchor = AnchorStyles.Left | AnchorStyles.Right; tb.ReadOnly = true; tb.Dock = DockStyle.Fill; UIWorks.AddToTLP(TLP, "Категория", tb); tb = new TextBox(); DBSubCategory dbsc = new DBSubCategory(); tb.Text = dbsc.GetName(wp.IDSubCat); tb.Anchor = AnchorStyles.Left | AnchorStyles.Right; tb.ReadOnly = true; tb.Dock = DockStyle.Fill; UIWorks.AddToTLP(TLP, "Подкатегория", tb); PathField pf = new PathField(); pf.Tag = Roles.Inzhener; pf.Init(wp.DIMENDRAWING, true, false, false, true, Roles.Inzhener, "VIEWONLY", UVO, "DIMENSIONALDRAWING_CABLE", null, wp); pf.bDelVisible = false; pf.bPathVisible = false; pf.tbPath.Width += 150; pf.tbPath.Dock = DockStyle.Fill; pf.Dock = DockStyle.Fill; pf.bRemark.Visible = false; UIWorks.AddToTLP(TLP, "Сборочный чертёж", pf); pf = new PathField(); pf.Tag = Roles.Inzhener; pf.Init(wp.MECHPARTS, true, false, false, true, Roles.Inzhener, "VIEWONLY", UVO, "MECHPARTS_CABLE", null, wp); pf.bDelVisible = false; pf.bPathVisible = false; pf.tbPath.Width += 150; pf.tbPath.Dock = DockStyle.Fill; pf.Dock = DockStyle.Fill; pf.bRemark.Visible = false; UIWorks.AddToTLP(TLP, "Проект мех. деталей", pf); tb = new TextBox(); tb.Text = wp.CONECTORS; tb.Anchor = AnchorStyles.Left | AnchorStyles.Right; tb.ReadOnly = true; tb.Dock = DockStyle.Fill; UIWorks.AddToTLP(TLP, "Соединители", tb); tb = new TextBox(); tb.Text = wp.CLENGTH; tb.Anchor = AnchorStyles.Left | AnchorStyles.Right; tb.ReadOnly = true; tb.Dock = DockStyle.Fill; UIWorks.AddToTLP(TLP, "Длина", tb); }