internal void EditWP_Constructor(WPNameVO p) { DA.UpdateCommand.Parameters.Clear(); DA.UpdateCommand.Parameters.AddWithValue("WPNAME", 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("DIMENSIONALDRAWING", ((object)p.DIMENDRAWING) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("DIMENSIONALDRAWINGREQ", p.DIMENSIONALDRAWINGREQ); DA.UpdateCommand.Parameters.AddWithValue("SBORKA3D", ((object)p.SBORKA3D) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("SBORKA3DREQ", p.SBORKA3DREQ); DA.UpdateCommand.Parameters.AddWithValue("MECHPARTS", ((object)p.MECHPARTS) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("MECHPARTSREQ", p.MECHPARTSREQ); DA.UpdateCommand.Parameters.AddWithValue("SHILDS", ((object)p.SHILDS) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("SHILDSREQ", p.SHILDSREQ); //DA.UpdateCommand.Parameters.AddWithValue("PLANKA", ((object)p.PLANKA) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("PACKAGING", ((object)p.PACKAGING) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("PACKAGINGREQ", p.PACKAGINGREQ); DA.UpdateCommand.Parameters.AddWithValue("NOTE", p.Note); DA.UpdateCommand.Parameters.AddWithValue("ZHGUTLISTREQ", p.ZHGUTLISTREQ); DA.UpdateCommand.Parameters.AddWithValue("CABLELISTREQ", p.CABLELISTREQ); DA.UpdateCommand.Parameters.AddWithValue("ID", p.ID); DA.UpdateCommand.CommandText = "update " + Base.BaseName + "..WPNAMELIST set WPNAME = @WPNAME,IDCATEGORY = @IDCATEGORY,IDSUBCAT = @IDSUBCAT,DECNUM = @DECNUM, " + " DIMENSIONALDRAWING=@DIMENSIONALDRAWING,SBORKA3D=@SBORKA3D,MECHPARTS=@MECHPARTS,SHILDS=@SHILDS,PACKAGING=@PACKAGING,NOTE=@NOTE, " + " SHILDSREQ=@SHILDSREQ, PACKAGINGREQ=@PACKAGINGREQ,DIMENSIONALDRAWINGREQ=@DIMENSIONALDRAWINGREQ,SBORKA3DREQ=@SBORKA3DREQ,MECHPARTSREQ=@MECHPARTSREQ " + " ,ZHGUTLISTREQ=@ZHGUTLISTREQ,CABLELISTREQ=@CABLELISTREQ " + " where ID = @ID"; DA.UpdateCommand.Connection.Open(); DA.UpdateCommand.ExecuteNonQuery(); DA.UpdateCommand.Connection.Close(); }
private void bEdit_Click(object sender, EventArgs e)//редактировать { PreviousState ps = new PreviousState(dgWP); if (cbPRODUCTTYPE.SelectedIndex == 0) { NewWPN ew = new NewWPN(WPNameVO.WPNameVOByID(Convert.ToInt32(dgWP.SelectedRows[0].Cells["ID"].Value)), "EDIT", UVO); ew.ShowDialog(); } if (cbPRODUCTTYPE.SelectedIndex == 1) { NewZHGUT ew = new NewZHGUT(ZhgutVO.GetZhgutVOByID(Convert.ToInt32(dgWP.SelectedRows[0].Cells["ID"].Value)), "EDIT", UVO); ew.ShowDialog(); } if (cbPRODUCTTYPE.SelectedIndex == 2) { NewCABLE ew = new NewCABLE(CableVO.GetCableVOByID(Convert.ToInt32(dgWP.SelectedRows[0].Cells["ID"].Value)), "EDIT", UVO); ew.ShowDialog(); } int idsub = (cbSubCat.SelectedValue != null) ? (int)cbSubCat.SelectedValue : 0; cbCAT_SelectedIndexChanged(sender, e); cbSubCat.SelectedValue = idsub; ps.Restore(); }
internal void EditWP_Inzhener(WPNameVO p) { DA.UpdateCommand.Parameters.Clear(); DA.UpdateCommand.Parameters.AddWithValue("WPNAME", 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("WIRINGDIAGRAM", ((object)p.WIRINGDIAGRAM) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("TECHREQ", ((object)p.TECHREQ) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("COMPOSITION", ((object)p.COMPOSITION) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("CONFIGURATION", ((object)p.CONFIGURATION) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("DIMENSIONALDRAWING", ((object)p.DIMENDRAWING) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("SBORKA3D", ((object)p.SBORKA3D) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("MECHPARTS", ((object)p.MECHPARTS) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("SHILDS", ((object)p.SHILDS) ?? DBNull.Value); //DA.UpdateCommand.Parameters.AddWithValue("PLANKA", ((object)p.PLANKA) ?? DBNull.Value); //DA.UpdateCommand.Parameters.AddWithValue("SERIAL", ((object)p.SERIAL) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("PACKAGING", ((object)p.PACKAGING) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("PASSPORT", ((object)p.PASSPORT) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("MANUAL", ((object)p.MANUAL) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("PACKINGLIST", ((object)p.PACKINGLIST) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("POWERSUPPLY", p.PowerSupply); DA.UpdateCommand.Parameters.AddWithValue("NOTE", p.Note); DA.UpdateCommand.Parameters.AddWithValue("COMPOSITIONREQ", p.COMPOSITIONREQ); DA.UpdateCommand.Parameters.AddWithValue("DIMENSIONALDRAWINGREQ", p.DIMENSIONALDRAWINGREQ); DA.UpdateCommand.Parameters.AddWithValue("CONFIGURATIONREQ", p.CONFIGURATIONREQ); DA.UpdateCommand.Parameters.AddWithValue("WIRINGDIAGRAMREQ", p.WIRINGDIAGRAMREQ); DA.UpdateCommand.Parameters.AddWithValue("TECHREQREQ", p.TECHREQREQ); DA.UpdateCommand.Parameters.AddWithValue("SBORKA3DREQ", p.SBORKA3DREQ); DA.UpdateCommand.Parameters.AddWithValue("MECHPARTSREQ", p.MECHPARTSREQ); DA.UpdateCommand.Parameters.AddWithValue("SHILDSREQ", p.SHILDSREQ); //DA.UpdateCommand.Parameters.AddWithValue("PLANKAREQ", p.PLANKAREQ); //DA.UpdateCommand.Parameters.AddWithValue("SERIALREQ", p.SERIALREQ); DA.UpdateCommand.Parameters.AddWithValue("PACKAGINGREQ", p.PACKAGINGREQ); DA.UpdateCommand.Parameters.AddWithValue("PASSPORTREQ", p.PASSPORTREQ); DA.UpdateCommand.Parameters.AddWithValue("MANUALREQ", p.MANUALREQ); DA.UpdateCommand.Parameters.AddWithValue("PACKINGLISTREQ", p.PACKINGLISTREQ); DA.UpdateCommand.Parameters.AddWithValue("SOFTWAREREQ", p.SOFTWAREREQ); DA.UpdateCommand.Parameters.AddWithValue("CABLELISTREQ", p.CABLELISTREQ); DA.UpdateCommand.Parameters.AddWithValue("ZHGUTLISTREQ", p.ZHGUTLISTREQ); DA.UpdateCommand.Parameters.AddWithValue("RUNCARDLISTREQ", p.RUNCARDLISTREQ); DA.UpdateCommand.Parameters.AddWithValue("CIRCUITBOARDLISTREQ", p.CIRCUITBOARDLISTREQ); DA.UpdateCommand.Parameters.AddWithValue("ID", p.ID); DA.UpdateCommand.CommandText = "update " + Base.BaseName + "..WPNAMELIST set WPNAME = @WPNAME,IDCATEGORY = @IDCATEGORY,IDSUBCAT = @IDSUBCAT,DECNUM = @DECNUM, " + " WIRINGDIAGRAM = @WIRINGDIAGRAM, TECHREQ=@TECHREQ,COMPOSITION = @COMPOSITION,CONFIGURATION=@CONFIGURATION, " + " DIMENSIONALDRAWING=@DIMENSIONALDRAWING,SBORKA3D=@SBORKA3D,MECHPARTS=@MECHPARTS,SHILDS=@SHILDS, " + " PACKAGING=@PACKAGING, PASSPORT=@PASSPORT, MANUAL=@MANUAL, PACKINGLIST=@PACKINGLIST,POWERSUPPLY=@POWERSUPPLY," + " NOTE = @NOTE, COMPOSITIONREQ=@COMPOSITIONREQ, DIMENSIONALDRAWINGREQ=@DIMENSIONALDRAWINGREQ, CONFIGURATIONREQ=@CONFIGURATIONREQ, " + " WIRINGDIAGRAMREQ=@WIRINGDIAGRAMREQ, TECHREQREQ=@TECHREQREQ, SBORKA3DREQ=@SBORKA3DREQ, MECHPARTSREQ=@MECHPARTSREQ, " + " SHILDSREQ=@SHILDSREQ, PACKAGINGREQ=@PACKAGINGREQ," + " PASSPORTREQ=@PASSPORTREQ, MANUALREQ=@MANUALREQ, PACKINGLISTREQ=@PACKINGLISTREQ, SOFTWAREREQ=@SOFTWAREREQ, " + " CABLELISTREQ=@CABLELISTREQ,ZHGUTLISTREQ=@ZHGUTLISTREQ, RUNCARDLISTREQ=@RUNCARDLISTREQ,CIRCUITBOARDLISTREQ=@CIRCUITBOARDLISTREQ " + " where ID = @ID"; DA.UpdateCommand.Connection.Open(); DA.UpdateCommand.ExecuteNonQuery(); DA.UpdateCommand.Connection.Close(); }
public EditWPN(int idw, bool viewOnly) { InitializeComponent(); if (viewOnly) { this.viewonly = viewOnly; button2.Visible = false; this.Text = "Просмотр сведений об изделии"; tbName.ReadOnly = true; tbNote.ReadOnly = true; tbPowerSupply.ReadOnly = true; tbDecNum.ReadOnly = true; tbConfiguration.ReadOnly = true; cbCategory.Enabled = false; cbSubCategory.Enabled = false; } this.IDW = idw; DBWPName dbwp = new DBWPName(); WPNameVO wp = WPNameVO.WPNameVOByID(this.IDW); tbName.Text = wp.WPName; cbCategory.SelectedValue = wp.IDCat; cbSubCategory.SelectedValue = wp.IDSubCat; tbDecNum.Text = wp.DecNum; tbPowerSupply.Text = wp.PowerSupply; tbConfiguration.Text = wp.CONFIGURATION; tbNote.Text = wp.Note; }
private void button2_Click(object sender, EventArgs e) { if (tbName.Text == "") { MessageBox.Show("Введите наименование!"); return; } DBWPName dbwp = new DBWPName(); WPNameVO wp = new WPNameVO(); wp.WPName = tbName.Text; wp.IDCat = Convert.ToInt32(cbCategory.SelectedValue); wp.IDSubCat = Convert.ToInt32(cbSubCategory.SelectedValue); wp.DecNum = tbDecNum.Text; wp.COMPOSITION = pfComposition.FullPath; //.bOpen.Tag.ToString(); wp.DIMENDRAWING = pfDimDrawing.FullPath; //.bOpen.Tag.ToString(); wp.PowerSupply = tbPowerSupply.Text; wp.CONFIGURATION = tbConfiguration.Text; wp.Note = tbNote.Text; wp.ID = this.IDW; dbwp.EditWP(wp); MessageBox.Show("Наименование успешно изменено!"); Close(); }
public NewWPN(WPNameVO wp, string accessmode_, IRole uvo) { InitializeComponent(); this.AccessMode = accessmode_; this.UVO = uvo; RequireVisible = true;//((UVO.Role == Roles.Inzhener) || (UVO.Role == Roles.Admin)) ? true : false; RequireEnabled = false; if (AccessMode == "NEW") { InitNEW(); this.Text = "Создание нового изделия"; } if (AccessMode == "NEWCLONE") { InitNEWCLONE(wp); this.Text = "Создание нового изделия на основе существующего"; } if (AccessMode == "EDIT") { InitEDIT(wp); this.Text = "Редактирование изделия"; } if (AccessMode == "VIEWONLY") { InitVIEWONLY(wp); this.Text = "Просмотр сведений об изделии"; button2.Visible = false; } }
internal void EditWP_Tehnolog(WPNameVO p) { DA.UpdateCommand.Parameters.Clear(); DA.UpdateCommand.Parameters.AddWithValue("NOTE", p.Note); DA.UpdateCommand.Parameters.AddWithValue("ID", p.ID); DA.UpdateCommand.CommandText = "update " + Base.BaseName + "..WPNAMELIST set NOTE=@NOTE" + " where ID = @ID"; DA.UpdateCommand.Connection.Open(); DA.UpdateCommand.ExecuteNonQuery(); DA.UpdateCommand.Connection.Close(); }
private void bGoToWP_Click(object sender, EventArgs e) { if (dgWP.SelectedRows.Count != 1) { MessageBox.Show("Не выбрано ни одной строки!"); return; } IProduct pr = WPNameVO.WPNameVOByID(Convert.ToInt32(dgWP.SelectedRows[0].Cells["IDWP"].Value)); pr.ViewOnly(UVO); Remarks_Load(sender, e); }
private void InitNEWCLONE(WPNameVO clone) { if (clone.WPName != "") { this.Clone = clone; //wp.WPType = WPTYPE.WPNAMELIST; //wp.ID = (int)r["ID"]; tbName.Text = Clone.WPName; cbCategory.SelectedValue = Clone.IDCat; cbSubCategory.SelectedValue = Clone.IDSubCat; tbDecNum.Text = Clone.DecNum; cbCategory.SelectedValue = Clone.IDCat; //CHECK!!!!!!!! cbSubCategory.SelectedValue = Clone.IDSubCat; //CHECK!!!!!!!!! tbName.Enabled = false; cbCategory.Enabled = false; cbSubCategory.Enabled = false; tbDecNum.Enabled = false; tbPowerSupply.Enabled = false; tbNote.Enabled = false; pfWIRINGDIAGRAM.Init(Clone.WIRINGDIAGRAM, Clone.WIRINGDIAGRAMREQ, false, RequireVisible, RequireEnabled, Roles.Shemotehnik, "NEWCLONE", UVO, "WIRINGDIAGRAM", null, Clone); pfTECHREQ.Init(Clone.TECHREQ, Clone.TECHREQREQ, false, RequireVisible, RequireEnabled, Roles.Inzhener, "NEWCLONE", UVO, "TECHREQ", null, Clone); pfComposition.Init(Clone.COMPOSITION, Clone.COMPOSITIONREQ, false, RequireVisible, RequireEnabled, Roles.Inzhener, "NEWCLONE", UVO, "COMPOSITION", null, Clone); pfCONFIGURATION.Init(Clone.CONFIGURATION, Clone.CONFIGURATIONREQ, false, RequireVisible, RequireEnabled, Roles.Inzhener, "NEWCLONE", UVO, "CONFIGURATION", null, Clone); pfDimDrawing.Init(Clone.DIMENDRAWING, Clone.DIMENSIONALDRAWINGREQ, false, RequireVisible, RequireEnabled, Roles.Constructor, "NEWCLONE", UVO, "DIMENSIONALDRAWING", null, Clone); pf3DSBORKA.Init(Clone.SBORKA3D, Clone.SBORKA3DREQ, false, RequireVisible, RequireEnabled, Roles.Constructor, "NEWCLONE", UVO, "SBORKA3D", null, Clone); pfMECHPARTS.Init(Clone.MECHPARTS, Clone.MECHPARTSREQ, false, RequireVisible, RequireEnabled, Roles.Constructor, "NEWCLONE", UVO, "MECHPARTS", null, Clone); packZHGUT.Init(WPTYPE.ZHGUTLIST, Clone.ID, Clone.ZHGUTLISTREQ, false, RequireVisible, RequireEnabled, Roles.Constructor, UVO.Role, UVO); packCABLE.Init(WPTYPE.CABLELIST, Clone.ID, Clone.CABLELISTREQ, false, RequireVisible, RequireEnabled, Roles.Constructor, UVO.Role, UVO); pfSHILDS.Init(Clone.SHILDS, Clone.SHILDSREQ, false, RequireVisible, RequireEnabled, Roles.Constructor, "NEWCLONE", UVO, "SHILDS", null, Clone); //pfPLANKA.Init(Clone.PLANKA, Clone.PLANKAREQ, false, RequireVisible, RequireEnabled, Roles.Constructor, UVO.Role); //pfSERIAL.Init(Clone.SERIAL, Clone.SERIALREQ, false, RequireVisible, RequireEnabled, Roles.OTK, UVO.Role); pfPACKAGING.Init(Clone.PACKAGING, Clone.PACKAGINGREQ, false, RequireVisible, RequireEnabled, Roles.Constructor, "NEWCLONE", UVO, "PACKAGING", null, Clone); pfPASSPORT.Init(Clone.PASSPORT, Clone.PASSPORTREQ, false, RequireVisible, RequireEnabled, Roles.OTD, "NEWCLONE", UVO, "PASSPORT", null, Clone); pfMANUAL.Init(Clone.MANUAL, Clone.MANUALREQ, false, RequireVisible, RequireEnabled, Roles.OTD, "NEWCLONE", UVO, "MANUAL", null, Clone); pfPACKINGLIST.Init(Clone.PACKINGLIST, Clone.PACKINGLISTREQ, false, RequireVisible, RequireEnabled, Roles.OTD, "NEWCLONE", UVO, "PACKINGLIST", null, Clone); tbPowerSupply.Text = Clone.PowerSupply; tbNote.Text = Clone.Note; tbLENGTH.Text = Clone.LENGTH; tbWIDTH.Text = Clone.WIDTH; tbHEIGHT.Text = Clone.HEIGHT; tbWEIGHT.Text = Clone.WEIGHT; AllocateRoles(); } }
internal void EditWP_Shemotehnik(WPNameVO p) { DA.UpdateCommand.Parameters.Clear(); DA.UpdateCommand.Parameters.AddWithValue("WIRINGDIAGRAM", ((object)p.WIRINGDIAGRAM) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("WIRINGDIAGRAMREQ", p.WIRINGDIAGRAMREQ); DA.UpdateCommand.Parameters.AddWithValue("NOTE", p.Note); DA.UpdateCommand.Parameters.AddWithValue("ID", p.ID); DA.UpdateCommand.CommandText = "update " + Base.BaseName + "..WPNAMELIST set WIRINGDIAGRAM = @WIRINGDIAGRAM,WIRINGDIAGRAMREQ=@WIRINGDIAGRAMREQ, NOTE=@NOTE" + " where ID = @ID"; DA.UpdateCommand.Connection.Open(); DA.UpdateCommand.ExecuteNonQuery(); DA.UpdateCommand.Connection.Close(); }
private void EditWPN_Load(object sender, EventArgs e) { DBCategory dbc = new DBCategory("WPNAMELIST"); cbCategory.ValueMember = "ID"; cbCategory.DisplayMember = "CATEGORYNAME"; cbCategory.DataSource = dbc.GetAllExceptAll(); DBWPName dbwp = new DBWPName(); WPNameVO wp = WPNameVO.WPNameVOByID(this.IDW); cbCategory.SelectedValue = wp.IDCat; LoadSubs((int)cbCategory.SelectedValue); }
private void InitVIEWONLY(WPNameVO wp) { ViewWP = wp; RequireVisible = true; tbName.Text = wp.WPName; tbName.Enabled = false; cbCategory.SelectedValue = wp.IDCat; cbCategory.Enabled = false; cbSubCategory.SelectedValue = wp.IDSubCat; cbSubCategory.Enabled = false; tbDecNum.Text = wp.DecNum; tbDecNum.Enabled = false; tbPowerSupply.Text = wp.PowerSupply; tbPowerSupply.Enabled = false; tbNote.Text = wp.Note; tbNote.Enabled = false; pfWIRINGDIAGRAM.Init(wp.WIRINGDIAGRAM, wp.WIRINGDIAGRAMREQ, false, RequireVisible, RequireEnabled, Roles.Shemotehnik, "VIEWONLY", UVO, "WIRINGDIAGRAM", null, wp); pfTECHREQ.Init(wp.TECHREQ, wp.TECHREQREQ, false, RequireVisible, RequireEnabled, Roles.Inzhener, "VIEWONLY", UVO, "TECHREQ", null, wp); pfComposition.Init(wp.COMPOSITION, wp.COMPOSITIONREQ, false, RequireVisible, RequireEnabled, Roles.Inzhener, "VIEWONLY", UVO, "COMPOSITION", null, wp); pfCONFIGURATION.Init(wp.CONFIGURATION, wp.CONFIGURATIONREQ, false, RequireVisible, RequireEnabled, Roles.Inzhener, "VIEWONLY", UVO, "CONFIGURATION", null, wp); pfDimDrawing.Init(wp.DIMENDRAWING, wp.DIMENSIONALDRAWINGREQ, false, RequireVisible, RequireEnabled, Roles.Constructor, "VIEWONLY", UVO, "DIMENSIONALDRAWING", null, wp); pf3DSBORKA.Init(wp.SBORKA3D, wp.SBORKA3DREQ, false, RequireVisible, RequireEnabled, Roles.Constructor, "VIEWONLY", UVO, "SBORKA3D", null, wp); pfMECHPARTS.Init(wp.MECHPARTS, wp.MECHPARTSREQ, false, RequireVisible, RequireEnabled, Roles.Constructor, "VIEWONLY", UVO, "MECHPARTS", null, wp); packZHGUT.Init(WPTYPE.ZHGUTLIST, wp.ID, wp.ZHGUTLISTREQ, false, RequireVisible, RequireEnabled, Roles.Constructor, UVO.Role, UVO); packCABLE.Init(WPTYPE.CABLELIST, wp.ID, wp.CABLELISTREQ, false, RequireVisible, RequireEnabled, Roles.Constructor, UVO.Role, UVO); pfSHILDS.Init(wp.SHILDS, wp.SHILDSREQ, false, RequireVisible, RequireEnabled, Roles.Constructor, "VIEWONLY", UVO, "SHILDS", null, wp); //pfPLANKA.Init(wp.PLANKA, wp.PLANKAREQ, false, RequireVisible, RequireEnabled,Roles.Constructor, UVO.Role); //pfSERIAL.Init(wp.SERIAL, wp.SERIALREQ, false, RequireVisible, RequireEnabled, Roles.OTK, UVO.Role); pfPACKAGING.Init(wp.PACKAGING, wp.PACKAGINGREQ, false, RequireVisible, RequireEnabled, Roles.Constructor, "VIEWONLY", UVO, "PACKAGING", null, wp); pfPASSPORT.Init(wp.PASSPORT, wp.PASSPORTREQ, false, RequireVisible, RequireEnabled, Roles.OTD, "VIEWONLY", UVO, "PASSPORT", null, wp); pfMANUAL.Init(wp.MANUAL, wp.MANUALREQ, false, RequireVisible, RequireEnabled, Roles.OTD, "VIEWONLY", UVO, "MANUAL", null, wp); pfPACKINGLIST.Init(wp.PACKINGLIST, wp.PACKINGLISTREQ, false, RequireVisible, RequireEnabled, Roles.OTD, "VIEWONLY", UVO, "PACKINGLIST", null, wp); packZHGUT.Enabled = false; packCABLE.Enabled = false; tbLENGTH.Text = wp.LENGTH; tbLENGTH.Enabled = false; tbWIDTH.Text = wp.WIDTH; tbWIDTH.Enabled = false; tbHEIGHT.Text = wp.HEIGHT; tbHEIGHT.Enabled = false; tbWEIGHT.Text = wp.WEIGHT; tbWEIGHT.Enabled = false; }
internal void EditWP_OTK(WPNameVO p) { DA.UpdateCommand.Parameters.Clear(); DA.UpdateCommand.Parameters.AddWithValue("LENGTH", p.LENGTH); DA.UpdateCommand.Parameters.AddWithValue("WIDTH", p.WIDTH); DA.UpdateCommand.Parameters.AddWithValue("HEIGHT", p.HEIGHT); DA.UpdateCommand.Parameters.AddWithValue("WEIGHT", p.WEIGHT); DA.UpdateCommand.Parameters.AddWithValue("NOTE", p.Note); DA.UpdateCommand.Parameters.AddWithValue("ID", p.ID); DA.UpdateCommand.CommandText = "update " + Base.BaseName + "..WPNAMELIST set LENGTH=@LENGTH,WIDTH=@WIDTH,HEIGHT=@HEIGHT,WEIGHT=@WEIGHT, NOTE=@NOTE" + " where ID = @ID"; DA.UpdateCommand.Connection.Open(); DA.UpdateCommand.ExecuteNonQuery(); DA.UpdateCommand.Connection.Close(); }
internal void EditWP_OTD(WPNameVO p) { DA.UpdateCommand.Parameters.Clear(); DA.UpdateCommand.Parameters.AddWithValue("PASSPORT", ((object)p.PASSPORT) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("MANUAL", ((object)p.MANUAL) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("PACKINGLIST", ((object)p.PACKINGLIST) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("PASSPORTREQ", p.PASSPORTREQ); DA.UpdateCommand.Parameters.AddWithValue("MANUALREQ", p.MANUALREQ); DA.UpdateCommand.Parameters.AddWithValue("PACKINGLISTREQ", p.PACKINGLISTREQ); DA.UpdateCommand.Parameters.AddWithValue("NOTE", p.Note); DA.UpdateCommand.Parameters.AddWithValue("ID", p.ID); DA.UpdateCommand.CommandText = "update " + Base.BaseName + "..WPNAMELIST set PASSPORT = @PASSPORT,MANUAL=@MANUAL,PACKINGLIST=@PACKINGLIST, NOTE=@NOTE" + ", PASSPORTREQ=@PASSPORTREQ,MANUALREQ=@MANUALREQ,PACKINGLISTREQ=@PACKINGLISTREQ " + " where ID = @ID"; DA.UpdateCommand.Connection.Open(); DA.UpdateCommand.ExecuteNonQuery(); DA.UpdateCommand.Connection.Close(); }
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 bView_Click(object sender, EventArgs e)//просмотр { if (dgWP.SelectedRows.Count == 0) { return; } if (cbPRODUCTTYPE.SelectedIndex == 0) { NewWPN ew = new NewWPN(WPNameVO.WPNameVOByID(Convert.ToInt32(dgWP.SelectedRows[0].Cells["ID"].Value)), "VIEWONLY", UVO); ew.ShowDialog(); } if (cbPRODUCTTYPE.SelectedIndex == 1) { NewZHGUT ew = new NewZHGUT(ZhgutVO.GetZhgutVOByID(Convert.ToInt32(dgWP.SelectedRows[0].Cells["ID"].Value)), "VIEWONLY", UVO); ew.ShowDialog(); } if (cbPRODUCTTYPE.SelectedIndex == 2) { NewCABLE ew = new NewCABLE(CableVO.GetCableVOByID(Convert.ToInt32(dgWP.SelectedRows[0].Cells["ID"].Value)), "VIEWONLY", UVO); ew.ShowDialog(); } }
private void button2_Click(object sender, EventArgs e)//save { WPNameVO wp = new WPNameVO(); if (tbName.Text == "") { MessageBox.Show("Введите наименование!"); return; } wp.WPType = WPTYPE.WPNAMELIST; //wp.ID = (int)r["ID"]; wp.WPName = tbName.Text; wp.IDCat = Convert.ToInt32(cbCategory.SelectedValue); wp.IDSubCat = (cbSubCategory.SelectedValue == null) ? new DBSubCategory().GetIDNotAwardedByIDCat(wp.IDCat) : (int)cbSubCategory.SelectedValue; wp.DecNum = tbDecNum.Text; wp.WIRINGDIAGRAM = (pfWIRINGDIAGRAM.FullPath == "<нет>") ? null : pfWIRINGDIAGRAM.FullPath; wp.TECHREQ = (pfTECHREQ.FullPath == "<нет>") ? null : pfTECHREQ.FullPath; wp.COMPOSITION = (pfComposition.FullPath == "<нет>") ? null : pfComposition.FullPath; wp.CONFIGURATION = (pfCONFIGURATION.FullPath == "<нет>") ? null : pfCONFIGURATION.FullPath; wp.DIMENDRAWING = (pfDimDrawing.FullPath == "<нет>") ? null : pfDimDrawing.FullPath;; wp.SBORKA3D = (pf3DSBORKA.FullPath == "<нет>") ? null : pf3DSBORKA.FullPath; wp.MECHPARTS = (pfMECHPARTS.FullPath == "<нет>") ? null : pfMECHPARTS.FullPath; wp.ZHGUTS = new DBZhgutList().GetPackageForVO(wp.ID); wp.CABLES = new DBCableList().GetPackageForVO(wp.ID); wp.SHILDS = (pfSHILDS.FullPath == "<нет>") ? null : pfSHILDS.FullPath; //wp.PLANKA = (pfPLANKA.FullPath == "<нет>") ? null : pfPLANKA.FullPath; //wp.SERIAL = (pfSERIAL.FullPath == "<нет>") ? null : pfSERIAL.FullPath; wp.PACKAGING = (pfPACKAGING.FullPath == "<нет>") ? null : pfPACKAGING.FullPath; wp.PASSPORT = (pfPASSPORT.FullPath == "<нет>") ? null : pfPASSPORT.FullPath; wp.MANUAL = (pfMANUAL.FullPath == "<нет>") ? null : pfMANUAL.FullPath; wp.PACKINGLIST = (pfPACKINGLIST.FullPath == "<нет>") ? null : pfPACKINGLIST.FullPath; wp.PowerSupply = tbPowerSupply.Text; wp.Note = tbNote.Text; wp.COMPOSITIONREQ = pfComposition.Required; wp.DIMENSIONALDRAWINGREQ = pfDimDrawing.Required; //wp.POWERSUPPLYREQ = pfpowe; wp.CONFIGURATIONREQ = pfCONFIGURATION.Required; wp.WIRINGDIAGRAMREQ = pfWIRINGDIAGRAM.Required; wp.TECHREQREQ = pfTECHREQ.Required; wp.SBORKA3DREQ = pf3DSBORKA.Required; wp.MECHPARTSREQ = pfMECHPARTS.Required; wp.SHILDSREQ = pfSHILDS.Required; //wp.PLANKAREQ = pfPLANKA.Required; //wp.SERIALREQ = pfSERIAL.Required; wp.PACKAGINGREQ = pfPACKAGING.Required; wp.PASSPORTREQ = pfPASSPORT.Required; wp.MANUALREQ = pfMANUAL.Required; wp.PACKINGLISTREQ = pfPACKINGLIST.Required; //wp.SOFTWAREREQ ; wp.CABLELISTREQ = packCABLE.Required; wp.ZHGUTLISTREQ = packZHGUT.Required; //wp.RUNCARDLISTREQ ; //wp.CIRCUITBOARDLISTREQ; wp.LENGTH = tbLENGTH.Text; wp.WIDTH = tbWIDTH.Text; wp.HEIGHT = tbHEIGHT.Text; wp.WEIGHT = tbWEIGHT.Text; DBWPName dbwp = new DBWPName(); if (AccessMode == "EDIT") { wp.ID = EditWP.ID; if (UVO.Role == Roles.Admin) { dbwp.EditWP(wp); } if (UVO.Role == Roles.Constructor) { dbwp.EditWP_Constructor(wp); } if ((UVO.Role == Roles.Inzhener) || (UVO.Role == Roles.SimpleInzhener)) { dbwp.EditWP_Inzhener(wp); } if (UVO.Role == Roles.Tehnolog) { dbwp.EditWP_Tehnolog(wp); } if (UVO.Role == Roles.Shemotehnik) { dbwp.EditWP_Shemotehnik(wp); } if (UVO.Role == Roles.OTD) { dbwp.EditWP_OTD(wp); } if (UVO.Role == Roles.OTK) { dbwp.EditWP_OTK(wp); } if (UVO.Role == Roles.OTK) { dbwp.EditWP_OTK(wp); } MessageBox.Show("Изделие успешно сохранено!"); } if ((AccessMode == "NEW") || (AccessMode == "NEWCLONE")) { wp.COMPOSITIONREQ = true; wp.DIMENSIONALDRAWINGREQ = true; wp.CONFIGURATIONREQ = true; wp.WIRINGDIAGRAMREQ = true; wp.TECHREQREQ = true; wp.SBORKA3DREQ = true; wp.MECHPARTSREQ = true; wp.SHILDSREQ = true; wp.PACKAGINGREQ = true; wp.PASSPORTREQ = true; wp.MANUALREQ = true; wp.PACKINGLISTREQ = true; wp.CABLELISTREQ = true; wp.ZHGUTLISTREQ = true; dbwp.AddNewWP(wp); MessageBox.Show("Изделие успешно добавлено!"); } Close(); }
internal WPNameVO GetWPNameByID(int id) { WPNameVO wp = new WPNameVO(); DA.SelectCommand.Parameters.AddWithValue("ID", id); DA.SelectCommand.CommandText = " select * from " + Base.BaseName + "..WPNAMELIST A where ID = @ID"; DA.Fill(DS, "t"); DataRow r = DS.Tables["t"].Rows[0]; wp.WPType = WPTYPE.WPNAMELIST; wp.ID = (int)r["ID"]; wp.WPName = r["WPNAME"].ToString(); wp.IDCat = (int)r["IDCATEGORY"]; wp.IDSubCat = (r["IDSUBCAT"] == DBNull.Value) ? new DBSubCategory().GetIDNotAwardedByIDCat(wp.IDCat) : (int)r["IDSUBCAT"]; wp.DecNum = r["DECNUM"].ToString(); wp.WIRINGDIAGRAM = r["WIRINGDIAGRAM"].ToString(); wp.TECHREQ = r["TECHREQ"].ToString(); wp.COMPOSITION = r["COMPOSITION"].ToString(); wp.CONFIGURATION = r["CONFIGURATION"].ToString(); wp.DIMENDRAWING = r["DIMENSIONALDRAWING"].ToString(); wp.SBORKA3D = r["SBORKA3D"].ToString(); wp.MECHPARTS = r["MECHPARTS"].ToString(); wp.ZHGUTS = new DBZhgutList().GetPackageForVO(wp.ID); wp.CABLES = new DBCableList().GetPackageForVO(wp.ID); wp.SHILDS = r["SHILDS"].ToString(); //wp.PLANKA = r["PLANKA"].ToString(); //wp.SERIAL = r["SERIAL"].ToString(); wp.PACKAGING = r["PACKAGING"].ToString(); wp.PASSPORT = r["PASSPORT"].ToString(); wp.MANUAL = r["MANUAL"].ToString(); wp.PACKINGLIST = r["PACKINGLIST"].ToString(); wp.PowerSupply = r["POWERSUPPLY"].ToString(); wp.Note = r["NOTE"].ToString(); wp.COMPOSITIONREQ = (bool)r["COMPOSITIONREQ"]; wp.DIMENSIONALDRAWINGREQ = (bool)r["DIMENSIONALDRAWINGREQ"]; //wp.POWERSUPPLYREQ = (bool)r["POWERSUPPLYREQ"]; wp.CONFIGURATIONREQ = (bool)r["CONFIGURATIONREQ"]; wp.WIRINGDIAGRAMREQ = (bool)r["WIRINGDIAGRAMREQ"]; wp.TECHREQREQ = (bool)r["TECHREQREQ"]; wp.SBORKA3DREQ = (bool)r["SBORKA3DREQ"]; wp.MECHPARTSREQ = (bool)r["MECHPARTSREQ"]; wp.SHILDSREQ = (bool)r["SHILDSREQ"]; //wp.PLANKAREQ = (bool)r["PLANKAREQ"]; //wp.SERIALREQ = (bool)r["SERIALREQ"]; wp.PACKAGINGREQ = (bool)r["PACKAGINGREQ"]; wp.PASSPORTREQ = (bool)r["PASSPORTREQ"]; wp.MANUALREQ = (bool)r["MANUALREQ"]; wp.PACKINGLISTREQ = (bool)r["PACKINGLISTREQ"]; wp.SOFTWAREREQ = (bool)r["SOFTWAREREQ"]; wp.CABLELISTREQ = (bool)r["CABLELISTREQ"]; wp.ZHGUTLISTREQ = (bool)r["ZHGUTLISTREQ"]; wp.RUNCARDLISTREQ = (bool)r["RUNCARDLISTREQ"]; wp.CIRCUITBOARDLISTREQ = (bool)r["CIRCUITBOARDLISTREQ"]; wp.LENGTH = r["LENGTH"].ToString(); wp.WIDTH = r["WIDTH"].ToString(); wp.HEIGHT = r["HEIGHT"].ToString(); wp.WEIGHT = r["WEIGHT"].ToString(); return(wp); }
internal void AddNewWP(WPNameVO p) { int ID = new DBProduct().AddNewProduct(p); DA.InsertCommand.Parameters.Clear(); DA.InsertCommand.Parameters.AddWithValue("ID", ID); DA.InsertCommand.Parameters.AddWithValue("WPNAME", p.WPName); DA.InsertCommand.Parameters.AddWithValue("IDCATEGORY", p.IDCat); DA.InsertCommand.Parameters.AddWithValue("IDSUBCAT", (p.IDSubCat == 0) ? new DBSubCategory().GetIDNotAwardedByIDCat(p.IDCat) : p.IDSubCat); DA.InsertCommand.Parameters.AddWithValue("DECNUM", p.DecNum); DA.InsertCommand.Parameters.AddWithValue("WIRINGDIAGRAM", ((object)p.WIRINGDIAGRAM) ?? DBNull.Value); DA.InsertCommand.Parameters.AddWithValue("TECHREQ", ((object)p.TECHREQ) ?? DBNull.Value); DA.InsertCommand.Parameters.AddWithValue("COMPOSITION", ((object)p.COMPOSITION) ?? DBNull.Value); DA.InsertCommand.Parameters.AddWithValue("CONFIGURATION", ((object)p.CONFIGURATION) ?? DBNull.Value); DA.InsertCommand.Parameters.AddWithValue("DIMENSIONALDRAWING", ((object)p.DIMENDRAWING) ?? DBNull.Value); DA.InsertCommand.Parameters.AddWithValue("SBORKA3D", ((object)p.SBORKA3D) ?? DBNull.Value); DA.InsertCommand.Parameters.AddWithValue("MECHPARTS", ((object)p.MECHPARTS) ?? DBNull.Value); DA.InsertCommand.Parameters.AddWithValue("SHILDS", ((object)p.SHILDS) ?? DBNull.Value); //DA.InsertCommand.Parameters.AddWithValue("PLANKA", ((object)p.PLANKA) ?? DBNull.Value); //DA.InsertCommand.Parameters.AddWithValue("SERIAL", ((object)p.SERIAL) ?? DBNull.Value); DA.InsertCommand.Parameters.AddWithValue("PACKAGING", ((object)p.PACKAGING) ?? DBNull.Value); DA.InsertCommand.Parameters.AddWithValue("MANUAL", ((object)p.MANUAL) ?? DBNull.Value); DA.InsertCommand.Parameters.AddWithValue("PASSPORT", ((object)p.PASSPORT) ?? DBNull.Value); DA.InsertCommand.Parameters.AddWithValue("PACKINGLIST", ((object)p.PACKINGLIST) ?? DBNull.Value); DA.InsertCommand.Parameters.AddWithValue("POWERSUPPLY", p.PowerSupply); DA.InsertCommand.Parameters.AddWithValue("NOTE", p.Note); DA.InsertCommand.Parameters.AddWithValue("CREATED", DateTime.Now); DA.InsertCommand.Parameters.AddWithValue("COMPOSITIONREQ", p.COMPOSITIONREQ); DA.InsertCommand.Parameters.AddWithValue("DIMENSIONALDRAWINGREQ", p.DIMENSIONALDRAWINGREQ); DA.InsertCommand.Parameters.AddWithValue("CONFIGURATIONREQ", p.CONFIGURATIONREQ); DA.InsertCommand.Parameters.AddWithValue("WIRINGDIAGRAMREQ", p.WIRINGDIAGRAMREQ); DA.InsertCommand.Parameters.AddWithValue("TECHREQREQ", p.TECHREQREQ); DA.InsertCommand.Parameters.AddWithValue("SBORKA3DREQ", p.SBORKA3DREQ); DA.InsertCommand.Parameters.AddWithValue("MECHPARTSREQ", p.MECHPARTSREQ); DA.InsertCommand.Parameters.AddWithValue("SHILDSREQ", p.SHILDSREQ); //DA.InsertCommand.Parameters.AddWithValue("PLANKAREQ", p.PLANKAREQ); //DA.InsertCommand.Parameters.AddWithValue("SERIALREQ", p.SERIALREQ); DA.InsertCommand.Parameters.AddWithValue("PACKAGINGREQ", p.PACKAGINGREQ); DA.InsertCommand.Parameters.AddWithValue("PASSPORTREQ", p.PASSPORTREQ); DA.InsertCommand.Parameters.AddWithValue("MANUALREQ", p.MANUALREQ); DA.InsertCommand.Parameters.AddWithValue("PACKINGLISTREQ", p.PACKINGLISTREQ); DA.InsertCommand.Parameters.AddWithValue("SOFTWAREREQ", p.SOFTWAREREQ); DA.InsertCommand.Parameters.AddWithValue("CABLELISTREQ", p.CABLELISTREQ); DA.InsertCommand.Parameters.AddWithValue("ZHGUTLISTREQ", p.ZHGUTLISTREQ); DA.InsertCommand.Parameters.AddWithValue("RUNCARDLISTREQ", p.RUNCARDLISTREQ); DA.InsertCommand.Parameters.AddWithValue("CIRCUITBOARDLISTREQ", p.CIRCUITBOARDLISTREQ); DA.InsertCommand.Parameters.AddWithValue("LENGTH", p.LENGTH); DA.InsertCommand.Parameters.AddWithValue("WIDTH", p.WIDTH); DA.InsertCommand.Parameters.AddWithValue("HEIGHT", p.HEIGHT); DA.InsertCommand.Parameters.AddWithValue("WEIGHT", p.WEIGHT); //wp.ZHGUTS = new DBZhgutList().GetPackageForVO(wp.ID); ///////////////////////////////////////////////////////////////////////////////// ЗАПРЕЩЕНО НАПОЛНЯТЬ ЖГУТЫ КОГДА СОЗДАЁШЬ ИЗДЕЛИЕ!!!!!!!!!!!!!!!!! //wp.CABLES = new DBCableList().GetPackageForVO(wp.ID); DA.InsertCommand.CommandText = "insert into " + Base.BaseName + "..WPNAMELIST " + " (ID,WPNAME,IDCATEGORY,IDSUBCAT,DECNUM,WIRINGDIAGRAM,TECHREQ,COMPOSITION,CONFIGURATION,DIMENSIONALDRAWING,SBORKA3D, " + " MECHPARTS,SHILDS,PACKAGING,MANUAL,PASSPORT,PACKINGLIST,POWERSUPPLY,NOTE,CREATED, " + " COMPOSITIONREQ,DIMENSIONALDRAWINGREQ,CONFIGURATIONREQ,WIRINGDIAGRAMREQ," + " TECHREQREQ,SBORKA3DREQ,MECHPARTSREQ,SHILDSREQ,PACKAGINGREQ,PASSPORTREQ, " + " MANUALREQ,PACKINGLISTREQ,SOFTWAREREQ,CABLELISTREQ,ZHGUTLISTREQ,RUNCARDLISTREQ,CIRCUITBOARDLISTREQ " + " ,LENGTH,WIDTH,HEIGHT,WEIGHT) " + " values (@ID,@WPNAME,@IDCATEGORY,@IDSUBCAT,@DECNUM,@WIRINGDIAGRAM,@TECHREQ,@COMPOSITION,@CONFIGURATION,@DIMENSIONALDRAWING,@SBORKA3D, " + " @MECHPARTS,@SHILDS,@PACKAGING,@MANUAL, @PASSPORT,@PACKINGLIST,@POWERSUPPLY,@NOTE,@CREATED, " + " @COMPOSITIONREQ,@DIMENSIONALDRAWINGREQ,@CONFIGURATIONREQ,@WIRINGDIAGRAMREQ," + " @TECHREQREQ,@SBORKA3DREQ,@MECHPARTSREQ,@SHILDSREQ,@PACKAGINGREQ,@PASSPORTREQ, " + " @MANUALREQ,@PACKINGLISTREQ,@SOFTWAREREQ,@CABLELISTREQ,@ZHGUTLISTREQ,@RUNCARDLISTREQ,@CIRCUITBOARDLISTREQ " + " ,@LENGTH,@WIDTH,@HEIGHT,@WEIGHT)"; DA.InsertCommand.Connection.Open(); DA.InsertCommand.ExecuteNonQuery(); DA.InsertCommand.Connection.Close(); }