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