Пример #1
0
        private void BindSpecStd(int id_serv)
        {
            //cambio il valore della combo delle specializzazioni in base al servizio passato
            this.cmbstr_id.Items.Clear();

            S_ControlsCollection _SColl = new S_ControlsCollection();

            S_Controls.Collections.S_Object s_Id = new S_Object();
            s_Id.ParameterName = "p_servizio_id";
            s_Id.DbType        = CustomDBType.Integer;
            s_Id.Direction     = ParameterDirection.Input;
            s_Id.Index         = 0;
            s_Id.Value         = id_serv;
            _SColl.Add(s_Id);

            Classi.ClassiAnagrafiche.Pmp _Pmp = new TheSite.Classi.ClassiAnagrafiche.Pmp();

            DataSet _MyDs = _Pmp.GetSpecData(_SColl).Copy();

            if (_MyDs.Tables[0].Rows.Count > 0)
            {
                this.cmbstr_id.DataSource = Classi.GestoreDropDownList.ItemBlankDataSource(
                    _MyDs.Tables[0], "descrizione", "id", "- Selezionare una Specializzazione -", "0");
                this.cmbstr_id.DataTextField  = "descrizione";
                this.cmbstr_id.DataValueField = "id";
                this.cmbstr_id.DataBind();
            }
            else
            {
                string s_Messagggio = "- Nessuna Specializzazione  -";
                this.cmbstr_id.Items.Add(Classi.GestoreDropDownList.ItemMessaggio(s_Messagggio, "-1"));
            }
        }
Пример #2
0
        private string generacodice(int id_eqstd, int id_freq)
        {
            S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();

            S_Controls.Collections.S_Object s_p_id_eqstd = new S_Object();
            s_p_id_eqstd.ParameterName = "p_id_eqstd";
            s_p_id_eqstd.DbType        = CustomDBType.Integer;
            s_p_id_eqstd.Direction     = ParameterDirection.Input;
            s_p_id_eqstd.Value         = id_eqstd;
            s_p_id_eqstd.Size          = 10;
            s_p_id_eqstd.Index         = 0;
            _SCollection.Add(s_p_id_eqstd);


            S_Controls.Collections.S_Object s_p_id_freq = new S_Object();
            s_p_id_freq.ParameterName = "p_id_freq";
            s_p_id_freq.DbType        = CustomDBType.Integer;
            s_p_id_freq.Direction     = ParameterDirection.Input;
            s_p_id_freq.Value         = id_freq;
            s_p_id_freq.Size          = 10;
            s_p_id_freq.Index         = 1;
            _SCollection.Add(s_p_id_freq);

            Classi.ClassiAnagrafiche.Pmp _Pmp = new TheSite.Classi.ClassiAnagrafiche.Pmp();
            return(_Pmp.GetCodicepmp(_SCollection));
        }
Пример #3
0
        private void Page_Load(object sender, System.EventArgs e)
        {
            lblMessaggi.Text = "";
            FunId            = Int32.Parse(Request["FunId"]);

            if (Request["ItemId"] != null)
            {
                itemId = Int32.Parse(Request["ItemId"]);
            }
            if (!Page.IsPostBack)
            {
                //leggo le info del pmp e le metto nel datagrid del dettaglio
                //string id_pmp ="";
                Classi.ClassiAnagrafiche.Pmp _Pmp = new TheSite.Classi.ClassiAnagrafiche.Pmp();
                DataSet _MyDsPmp = _Pmp.GetSingleData(itemId).Copy();
                //id_pmp = _MyDsPmp.Tables[0].Rows[0]["pmp_id"].ToString();
                this.DataGridDettaglio.DataSource = _MyDsPmp.Tables[0];
                this.DataGridDettaglio.DataBind();

                //leggo i passi
                Classi.PmpS _PmpS = new TheSite.Classi.PmpS();
                //this.lblFirstAndLast.Text = _PmpS.GetFirstAndLastUser(_Dr);

                DataSet _MyDsPmpS = _PmpS.GetSingleData(itemId).Copy();

                DataView _dv = new DataView(_MyDsPmpS.Tables[0]);
                _dv.Sort = "PASSO ASC";

                this.DataGridEsegui.DataSource = _dv;                //_MyDsPmpS.Tables[0];
                this.DataGridEsegui.DataBind();

                Session.Add("PmpS", _MyDsPmpS.Tables[0]);

                this.lblRecord.Text = _MyDsPmpS.Tables[0].Rows.Count.ToString();
                this.DataGridEsegui.Columns[1].Visible = true;
                this.DataGridEsegui.Columns[2].Visible = false;
                this.DataGridEsegui.Columns[3].Visible = false;

                this.lblOperazione.Text = "";

                this.PageTitle1.Title = "Passi per Procedura di Manutenzione Programmata ";                // + id_pmp;
                //this.lblFirstAndLast.Visible = true;

                ViewState["UrlReferrer"] = Request.UrlReferrer.ToString();
                if (Context.Handler is TheSite.Gestione.Pmp)
                {
                    _fp = (TheSite.Gestione.Pmp)Context.Handler;
                    this.ViewState.Add("mioContenitore", _fp._Contenitore);
                }
            }
        }
Пример #4
0
        private void cmbseq_std_SelectedIndexChanged(object sender, System.EventArgs e)
        {
            //			if (cmbseq_std.SelectedIndex>0)
            //			{
            if (cmbsServizio.SelectedIndex == 0)
            {
                DataSet _MyDs;
                Classi.ClassiAnagrafiche.Pmp _Pmp = new TheSite.Classi.ClassiAnagrafiche.Pmp();

                int id_std = int.Parse(cmbseq_std.SelectedValue);
                _MyDs = _Pmp.GetStdData(id_std);
                DataRow _Dr = _MyDs.Tables[0].Rows[0];

                int id_serv = int.Parse(_Dr["id"].ToString());

                BindSpecStd(id_serv);
            }
            //			}
        }
Пример #5
0
        private void BindSpecStd()
        {
            //cambio il valore della combo delle specializzazioni
            this.cmbstr_id.Items.Clear();

            Classi.ClassiAnagrafiche.Pmp _Pmp = new TheSite.Classi.ClassiAnagrafiche.Pmp();

            DataSet _MyDs = _Pmp.GetAllTr().Copy();

            if (_MyDs.Tables[0].Rows.Count > 0)
            {
                this.cmbstr_id.DataSource = Classi.GestoreDropDownList.ItemBlankDataSource(
                    _MyDs.Tables[0], "descrizione", "id", "- Selezionare una Specializzazione -", "0");
                this.cmbstr_id.DataTextField  = "descrizione";
                this.cmbstr_id.DataValueField = "id";
                this.cmbstr_id.DataBind();
            }
            else
            {
                string s_Messagggio = "- Nessuna Specializzazione  -";
                this.cmbstr_id.Items.Add(Classi.GestoreDropDownList.ItemMessaggio(s_Messagggio, "-1"));
            }
        }
Пример #6
0
        private void cmbseq_std_SelectedIndexChanged(object sender, System.EventArgs e)
        {
            if (cmbsServ.SelectedIndex == 0)
            {
                DataSet _MyDs;
                Classi.ClassiAnagrafiche.Pmp _Pmp = new TheSite.Classi.ClassiAnagrafiche.Pmp();

                int id_std = int.Parse(cmbseq_std.SelectedValue);
                _MyDs = _Pmp.GetStdData(id_std);
                DataRow _Dr = _MyDs.Tables[0].Rows[0];

                int id_serv = int.Parse(_Dr["id"].ToString());

                BindSpecStd(id_serv);
            }

            if (cmbseq_std.SelectedValue != "0")
            {
                txtspmp_id.Text = generacodice(Int32.Parse(cmbseq_std.SelectedValue), Int32.Parse(cmbspmp.SelectedValue));
            }
            //			s_Pmp_id = cmbseq_std.SelectedItem.Text.Substring(0,8) + "_" + cmbspmp.SelectedItem.Text.Split(Convert.ToChar("-"))[0];
            //			txtspmp_id.Text=s_Pmp_id;
        }
Пример #7
0
        private void Page_Load(object sender, System.EventArgs e)
        {
            check_caselle_testo();

            FunId = Int32.Parse(Request["FunId"]);

            if (Request["ItemId"] != null)
            {
                itemId = Int32.Parse(Request["ItemId"]);
            }

            //Disabilito le combo prima del postback
            System.Text.StringBuilder sbValid = new System.Text.StringBuilder();
            sbValid.Append("document.getElementById('" + this.cmbspmp.ClientID + "').disabled = true;");
            sbValid.Append("document.getElementById('" + this.cmbseq_std.ClientID + "').disabled = true;");
            this.cmbsServ.Attributes.Add("onchange", sbValid.ToString());

            sbValid = new System.Text.StringBuilder();
            sbValid.Append("document.getElementById('" + this.cmbspmp.ClientID + "').disabled = true;");
            sbValid.Append("document.getElementById('" + this.cmbsServ.ClientID + "').disabled = true;");
            this.cmbseq_std.Attributes.Add("onchange", sbValid.ToString());

            sbValid = new System.Text.StringBuilder();
            sbValid.Append("document.getElementById('" + this.cmbsServ.ClientID + "').disabled = true;");
            sbValid.Append("document.getElementById('" + this.cmbseq_std.ClientID + "').disabled = true;");
            this.cmbspmp.Attributes.Add("onchange", sbValid.ToString());


            if (!Page.IsPostBack)
            {
                BindServizio();
                //BindSpecStd();//BindTr();
                BindPmPFrequenza();
                if (itemId != 0)
                {
                    DataSet _MyDs = new DataSet();
                    Classi.ClassiAnagrafiche.Pmp _Pmp = new TheSite.Classi.ClassiAnagrafiche.Pmp();
                    _MyDs = _Pmp.GetSingleData(itemId);

                    if (_MyDs.Tables[0].Rows.Count == 1)
                    {
                        DataRow _Dr = _MyDs.Tables[0].Rows[0];
                        this.txtsdescrizione.Text = _Dr["DES"].ToString();

                        if (_Dr["UH"] != DBNull.Value)
                        {
                            this.txtsunitshour.Text = _Dr["UH"].ToString();
                        }

                        if (_Dr["servizi_id"] != DBNull.Value)
                        {
                            this.cmbsServ.SelectedValue = _Dr["servizi_id"].ToString();
                        }
                        BindEqstd(int.Parse(this.cmbsServ.SelectedValue));

                        if (_Dr["eq_std"] != DBNull.Value)
                        {
                            this.cmbseq_std.SelectedValue = _Dr["eq_std"].ToString();
                        }
                        BindSpecStd(int.Parse(this.cmbsServ.SelectedValue));
                        if (_Dr["freq"] != DBNull.Value)
                        {
                            this.cmbspmp.SelectedValue = _Dr["freq"].ToString();
                        }

                        if (_Dr["tr"] != DBNull.Value)
                        {
                            BindSpecStd();
                            this.cmbstr.SelectedValue = _Dr["tr"].ToString();
                        }
                        if (_Dr["pmp_id"] != DBNull.Value)
                        {
                            this.txtspmp_id.Text = _Dr["pmp_id"].ToString();
                        }
                        if (_Dr["ac_id"] != DBNull.Value)
                        {
                            this.ChekDismesso.Checked = true;
                        }

                        this.lblOperazione.Text      = "Modifica Procedura di Manutenzione: " + _Dr["pmp_id"].ToString();
                        this.lblFirstAndLast.Visible = true;
                        this.btnsElimina.Attributes.Add("onclick", "return confirm('Si vuole effettuare la cancellazione?')");
                        lblFirstAndLast.Text = _Pmp.GetFirstAndLastUser(_Dr);
                    }
                }
                else
                {
                    this.lblOperazione.Text = "Inserimento Procedura di Manutenzione";
                    BindEqstd(0);
                    BindSpecStd();
                    this.lblFirstAndLast.Visible = false;
                    this.btnsElimina.Visible     = false;
                }

                if (Request["TipoOper"] == "read")
                {
                    AbilitaControlli(false);
                    this.lblOperazione.Text = "Visualizzazione Procedura di Manutenzione: " + this.txtspmp_id.Text;
                }
                ViewState["UrlReferrer"] = Request.UrlReferrer.ToString();
                if (Context.Handler is TheSite.Gestione.Pmp)
                {
                    _fp = (TheSite.Gestione.Pmp)Context.Handler;
                    this.ViewState.Add("mioContenitore", _fp._Contenitore);
                }
            }
        }
Пример #8
0
        private void btnsSalva_Click(object sender, System.EventArgs e)
        {
            //			this.txtsdescrizione.DBDefaultValue = DBNull.Value;
            //			this.txtsunitshour.DBDefaultValue = "0";
            //			this.txtspmp_id.DBDefaultValue = DBNull.Value;
            //			this.cmbseq_std.DBDefaultValue = "-1";
            //			this.cmbspmp.DBDefaultValue = "-1";
            //			this.cmbstr .DBDefaultValue = "-1";
            //			this.ChekDismesso.DBDefaultValue=false;
            //			this.txtsdescrizione.Text=this.txtsdescrizione.Text.Trim();
            //			this.txtsunitshour.Text= this.txtsunitshour.Text.Trim();


            S_Controls.Collections.S_Object s_p_descrizione = new S_Object();
            s_p_descrizione.ParameterName = "p_descrizione";
            s_p_descrizione.DbType        = CustomDBType.VarChar;
            s_p_descrizione.Direction     = ParameterDirection.Input;
            s_p_descrizione.Index         = 0;
            s_p_descrizione.Value         = txtsdescrizione.Text;
            s_p_descrizione.Size          = 255;

            S_Controls.Collections.S_Object s_p_unitshour = new S_Object();
            s_p_unitshour.ParameterName = "p_unitshour";
            s_p_unitshour.DbType        = CustomDBType.Integer;
            s_p_unitshour.Direction     = ParameterDirection.Input;
            s_p_unitshour.Index         = 1;
            s_p_unitshour.Value         = txtsunitshour.Text;

            S_Controls.Collections.S_Object s_p_eq_std_id = new S_Object();
            s_p_eq_std_id.ParameterName = "p_eq_std_id";
            s_p_eq_std_id.DbType        = CustomDBType.Integer;
            s_p_eq_std_id.Direction     = ParameterDirection.Input;
            s_p_eq_std_id.Index         = 2;
            s_p_eq_std_id.Value         = cmbseq_std.SelectedValue;

            S_Controls.Collections.S_Object s_p_pmp = new S_Object();
            s_p_pmp.ParameterName = "p_pmp";
            s_p_pmp.DbType        = CustomDBType.Integer;
            s_p_pmp.Direction     = ParameterDirection.Input;
            s_p_pmp.Index         = 3;
            s_p_pmp.Value         = cmbspmp.SelectedValue;

            S_Controls.Collections.S_Object s_p_id_tr = new S_Object();
            s_p_id_tr.ParameterName = "p_id_tr";
            s_p_id_tr.DbType        = CustomDBType.Integer;
            s_p_id_tr.Direction     = ParameterDirection.Input;
            s_p_id_tr.Index         = 4;
            s_p_id_tr.Value         = cmbstr.SelectedValue;

            S_Controls.Collections.S_Object s_p_pmp_id = new S_Object();
            s_p_pmp_id.ParameterName = "p_pmp_id";
            s_p_pmp_id.DbType        = CustomDBType.VarChar;
            s_p_pmp_id.Direction     = ParameterDirection.Input;
            s_p_pmp_id.Index         = 5;
            s_p_pmp_id.Value         = txtspmp_id.Text;
            s_p_pmp_id.Size          = 16;

            S_Controls.Collections.S_Object s_p_ac_id = new S_Object();
            s_p_ac_id.ParameterName = "p_ac_id";
            s_p_ac_id.DbType        = CustomDBType.VarChar;
            s_p_ac_id.Direction     = ParameterDirection.Input;
            s_p_ac_id.Index         = 6;
            s_p_ac_id.Value         = (ChekDismesso.Checked == true)?"1":"0";

            int i_RowsAffected = 0;

            S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
            _SCollection.Add(s_p_descrizione);
            _SCollection.Add(s_p_unitshour);
            _SCollection.Add(s_p_eq_std_id);
            _SCollection.Add(s_p_pmp);
            _SCollection.Add(s_p_id_tr);
            _SCollection.Add(s_p_pmp_id);
            _SCollection.Add(s_p_ac_id);

            //_SCollection.AddItems(this.PanelEdit.Controls);

            try
            {
                if (itemId == 0)
                {
                    Classi.ClassiAnagrafiche.Pmp _Pmp = new TheSite.Classi.ClassiAnagrafiche.Pmp();
                    i_RowsAffected = _Pmp.Add(_SCollection);
                }
                else
                {
                    Classi.ClassiAnagrafiche.Pmp _Pmp = new TheSite.Classi.ClassiAnagrafiche.Pmp();
                    i_RowsAffected = _Pmp.Update(_SCollection, itemId);
                }

                if (i_RowsAffected == -11)
                {
                    Classi.SiteJavaScript.msgBox(this.Page, "Attenzione il Piano di Manutenzione Programmata creato è già presente.");
                }
                else
                {
                    Server.Transfer("Pmp.aspx");
                }
            }
            catch (Exception ex)
            {
                string s_Err = ex.Message.ToString().ToUpper();
                PanelMess.ShowError(s_Err, true);
            }
        }
Пример #9
0
        private void btnsElimina_Click(object sender, System.EventArgs e)
        {
            try
            {
                Classi.ClassiAnagrafiche.Pmp _Pmp = new TheSite.Classi.ClassiAnagrafiche.Pmp();

//				this.txtsdescrizione.DBDefaultValue = DBNull.Value;
//				this.txtsunitshour.DBDefaultValue = "0";
//				this.txtspmp_id.DBDefaultValue = DBNull.Value;
//				this.cmbseq_std.DBDefaultValue = "-1";
//				this.cmbspmp.DBDefaultValue = -1;
//				this.cmbstr .DBDefaultValue = "-1";

                S_Controls.Collections.S_Object s_p_descrizione = new S_Object();
                s_p_descrizione.ParameterName = "p_descrizione";
                s_p_descrizione.DbType        = CustomDBType.VarChar;
                s_p_descrizione.Direction     = ParameterDirection.Input;
                s_p_descrizione.Index         = 0;
                s_p_descrizione.Value         = txtsdescrizione.Text;
                s_p_descrizione.Size          = 255;

                S_Controls.Collections.S_Object s_p_unitshour = new S_Object();
                s_p_unitshour.ParameterName = "p_unitshour";
                s_p_unitshour.DbType        = CustomDBType.Integer;
                s_p_unitshour.Direction     = ParameterDirection.Input;
                s_p_unitshour.Index         = 1;
                s_p_unitshour.Value         = txtsunitshour.Text;

                S_Controls.Collections.S_Object s_p_eq_std_id = new S_Object();
                s_p_eq_std_id.ParameterName = "p_eq_std_id";
                s_p_eq_std_id.DbType        = CustomDBType.Integer;
                s_p_eq_std_id.Direction     = ParameterDirection.Input;
                s_p_eq_std_id.Index         = 2;
                s_p_eq_std_id.Value         = cmbseq_std.SelectedValue;

                S_Controls.Collections.S_Object s_p_pmp = new S_Object();
                s_p_pmp.ParameterName = "p_pmp";
                s_p_pmp.DbType        = CustomDBType.Integer;
                s_p_pmp.Direction     = ParameterDirection.Input;
                s_p_pmp.Index         = 3;
                s_p_pmp.Value         = cmbspmp.SelectedValue;

                S_Controls.Collections.S_Object s_p_id_tr = new S_Object();
                s_p_id_tr.ParameterName = "p_id_tr";
                s_p_id_tr.DbType        = CustomDBType.Integer;
                s_p_id_tr.Direction     = ParameterDirection.Input;
                s_p_id_tr.Index         = 4;
                s_p_id_tr.Value         = cmbstr.SelectedValue;

                S_Controls.Collections.S_Object s_p_pmp_id = new S_Object();
                s_p_pmp_id.ParameterName = "p_pmp_id";
                s_p_pmp_id.DbType        = CustomDBType.VarChar;
                s_p_pmp_id.Direction     = ParameterDirection.Input;
                s_p_pmp_id.Index         = 5;
                s_p_pmp_id.Value         = txtspmp_id.Text;
                s_p_pmp_id.Size          = 16;

                S_Controls.Collections.S_Object s_p_ac_id = new S_Object();
                s_p_ac_id.ParameterName = "p_ac_id";
                s_p_ac_id.DbType        = CustomDBType.VarChar;
                s_p_ac_id.Direction     = ParameterDirection.Input;
                s_p_ac_id.Index         = 6;
                s_p_ac_id.Value         = (ChekDismesso.Checked == true)?"1":"0";

                int i_RowsAffected = 0;
                S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
                _SCollection.Add(s_p_descrizione);
                _SCollection.Add(s_p_unitshour);
                _SCollection.Add(s_p_eq_std_id);
                _SCollection.Add(s_p_pmp);
                _SCollection.Add(s_p_id_tr);
                _SCollection.Add(s_p_pmp_id);
                _SCollection.Add(s_p_ac_id);



//				int i_RowsAffected = 0;
//
//				S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
//
//				_SCollection.AddItems(this.PanelEdit.Controls);

                i_RowsAffected = _Pmp.Delete(_SCollection, itemId);

                if (i_RowsAffected == -1)
                {
                    Server.Transfer("Pmp.aspx");
                }
            }
            catch (Exception ex)
            {
                string s_Err = ex.Message.ToString().ToUpper();
                PanelMess.ShowError(s_Err, true);
            }
        }