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