internal void AddNewZhgut(ZhgutVO p)
{
int ID = new DBProduct().AddNewProduct(p);
DA.InsertCommand.Parameters.Clear();
DA.InsertCommand.Parameters.AddWithValue("ID", ID);
DA.InsertCommand.Parameters.AddWithValue("ZHGUTNAME", p.WPName);
DA.InsertCommand.Parameters.AddWithValue("IDCATEGORY", p.IDCat);
DA.InsertCommand.Parameters.AddWithValue("IDSUBCAT", p.IDSubCat);
DA.InsertCommand.Parameters.AddWithValue("DECNUM", p.DecNum);
DA.InsertCommand.Parameters.AddWithValue("ZHGUTPATH", ((object)p.ZHGUTPATH) ?? DBNull.Value);
DA.InsertCommand.Parameters.AddWithValue("NOTE", p.NOTE);
DA.InsertCommand.Parameters.AddWithValue("CREATED", DateTime.Now);
//wp.ZHGUTS = new DBZhgutList().GetPackageForVO(wp.ID);
///////////////////////////////////////////////////////////////////////////////// ЗАПРЕЩЕНО НАПОЛНЯТЬ ЖГУТЫ КОГДА СОЗДАЁШЬ ИЗДЕЛИЕ!!!!!!!!!!!!!!!!!
//wp.CABLES = new DBCableList().GetPackageForVO(wp.ID);
DA.InsertCommand.CommandText = "insert into " + Base.BaseName + "..ZHGUTLIST " +
" (ID,ZHGUTNAME,IDCATEGORY,IDSUBCAT,DECNUM,ZHGUTPATH, " +
" NOTE,CREATED) " +
" values (@ID,@ZHGUTNAME,@IDCATEGORY,@IDSUBCAT,@DECNUM,@ZHGUTPATH, " +
" @NOTE,@CREATED) ";
DA.InsertCommand.Connection.Open();
DA.InsertCommand.ExecuteNonQuery();
DA.InsertCommand.Connection.Close();
}
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);
}
internal List <ZhgutVO> GetPackageForVO(int IDWP)
{
DA.SelectCommand.Parameters.AddWithValue("IDWP", IDWP);
DA.SelectCommand.CommandText = " select A.IDZHGUT id,A.ID nn,B.ZHGUTNAME name,A.CNT " +
" from " + Base.BaseName + "..ZHGUTS A" +
" left join " + Base.BaseName + "..ZHGUTLIST B ON B.ID = A.IDZHGUT " +
" where IDWP = @IDWP ";
DA.Fill(DS, "t");
List <ZhgutVO> ret = new List <ZhgutVO>();
foreach (DataRow r in DS.Tables["t"].Rows)
{
ret.Add(ZhgutVO.GetZhgutVOByID((int)r["id"]));
}
return(ret);
}
internal ZhgutVO GetZhgutVOByID(int ID)
{
DA.SelectCommand.Parameters.AddWithValue("ID", ID);
DA.SelectCommand.CommandText = " select * from " + Base.BaseName + "..ZHGUTLIST where ID = @ID ";
DA.Fill(DS, "t");
DataRow r = DS.Tables["t"].Rows[0];
ZhgutVO ZVO = new ZhgutVO();
ZVO.ID = (int)r["ID"];
ZVO.WPName = r["ZHGUTNAME"].ToString();
ZVO.IDCat = (int)r["IDCATEGORY"];
ZVO.IDSubCat = (r["IDSUBCAT"] == DBNull.Value) ? 0 : (int)r["IDSUBCAT"];
ZVO.DecNum = r["DECNUM"].ToString();
ZVO.ZHGUTPATH = r["ZHGUTPATH"].ToString();
ZVO.NOTE = r["NOTE"].ToString();
ZVO.WPType = WPTYPE.ZHGUTLIST;
return(ZVO);
}
internal void EditZhgut(ZhgutVO p)
{
DA.UpdateCommand.Parameters.Clear();
DA.UpdateCommand.Parameters.AddWithValue("ZHGUTNAME", p.WPName);
DA.UpdateCommand.Parameters.AddWithValue("IDCATEGORY", p.IDCat);
DA.UpdateCommand.Parameters.AddWithValue("IDSUBCAT", p.IDSubCat);
DA.UpdateCommand.Parameters.AddWithValue("DECNUM", p.DecNum);
DA.UpdateCommand.Parameters.AddWithValue("ZHGUTPATH", ((object)p.ZHGUTPATH) ?? DBNull.Value);
DA.UpdateCommand.Parameters.AddWithValue("NOTE", p.NOTE);
DA.UpdateCommand.Parameters.AddWithValue("ID", p.ID);
DA.UpdateCommand.CommandText = "update " + Base.BaseName + "..ZHGUTLIST set ZHGUTNAME = @ZHGUTNAME,IDCATEGORY = @IDCATEGORY,IDSUBCAT = @IDSUBCAT,DECNUM = @DECNUM, " +
" ZHGUTPATH=@ZHGUTPATH, " +
" NOTE = @NOTE " +
" where ID = @ID";
DA.UpdateCommand.Connection.Open();
DA.UpdateCommand.ExecuteNonQuery();
DA.UpdateCommand.Connection.Close();
}
public static IProduct Create(int ID, string WPTYPE)
{
switch (WPTYPE)
{
case "WPNAMELIST":
return(WPNameVO.WPNameVOByID(ID));
case "ZHGUTLIST":
return(ZhgutVO.GetZhgutVOByID(ID));
case "CABLELIST":
return(CableVO.GetCableVOByID(ID));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("Неизвестный тип продукта : \"{0}\"!", WPTYPE);
throw new Exception(sb.ToString());
}
