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