public bool IsValidBlId(string BlId)
{
string s_User = System.Web.HttpContext.Current.User.Identity.Name;
Classi.ClassiDettaglio.Edificio _Edificio = new
WebCad.Classi.ClassiDettaglio.Edificio(s_User);
S_Controls.Collections.S_ControlsCollection _SColl = new S_ControlsCollection();
S_Controls.Collections.S_Object s_BlId = new S_Object();
s_BlId.ParameterName = "p_Bl_Id";
s_BlId.DbType = CustomDBType.VarChar;
s_BlId.Direction = ParameterDirection.Input;
s_BlId.Size = 8;
s_BlId.Index = 0;
s_BlId.Value = BlId;
S_Controls.Collections.S_Object s_UserName = new S_Object();
s_UserName.ParameterName = "p_UserName";
s_UserName.DbType = CustomDBType.VarChar;
s_UserName.Direction = ParameterDirection.Input;
s_UserName.Size = 50;
s_UserName.Index = 1;
s_UserName.Value = s_User;
S_Controls.Collections.S_Object s_Campus = new S_Object();
s_Campus.ParameterName = "p_Campus";
s_Campus.DbType = CustomDBType.VarChar;
s_Campus.Direction = ParameterDirection.Input;
s_Campus.Index = 2;
s_Campus.Size = 128;
s_Campus.Value = "";
S_Controls.Collections.S_Object s_Cursor = new S_Object();
s_Cursor.ParameterName = "IO_CURSOR";
s_Cursor.DbType = CustomDBType.Cursor;
s_Cursor.Direction = ParameterDirection.Output;
s_Cursor.Index = 3;
_SColl.Add(s_BlId);
_SColl.Add(s_UserName);
_SColl.Add(s_Campus);
_SColl.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_EDIFICI.SP_GETEDIFICI";
if (_OraDl.GetRows(_SColl, s_StrSql).Tables[0].Rows.Count == 1)
{
return(true);
}
else
{
return(false);
}
}
public void Ricarica()
{
int LengthCod = int.Parse(System.Configuration.ConfigurationSettings.AppSettings["edi_cod"]);
//if (txtsCodEdificio.Text.Trim().Length<LengthCod && txtsCodEdificio.Text.Trim().Length>0) return;
if (txtsCodEdificio.Text.Trim().Length == 0)
{
ClearCampi();
// Controllo che sia stata assegnata una funzione.
if (DelegateCodiceEdificio1 != null && txtsCodEdificio.Text != "")
{
DelegateCodiceServizio1();
DelegateCodiceEdificio1(txtsCodEdificio.Text);
}
if (DelegateIDBLEdificio1 != null)
{
DelegateIDBLEdificio1("");
}
return;
}
// Controllo che sia stata assegnata una funzione.
if (DelegateCodiceEdificio1 != null)
{
DelegateCodiceEdificio1(txtsCodEdificio.Text);
}
Classi.ClassiDettaglio.Edificio _MyEdificio = new WebCad.Classi.ClassiDettaglio.Edificio(Context.User.Identity.Name);
S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
///creo i parametri
///
S_Controls.Collections.S_Object s_bl_id = new S_Controls.Collections.S_Object();
s_bl_id.ParameterName = "p_Bl_Id";
s_bl_id.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_bl_id.Direction = ParameterDirection.Input;
s_bl_id.Size = 8;
s_bl_id.Index = 0;
s_bl_id.Value = txtsCodEdificio.Text;
_SCollection.Add(s_bl_id);
S_Controls.Collections.S_Object s_Campus = new S_Controls.Collections.S_Object();
s_Campus.ParameterName = "p_Campus";
s_Campus.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_Campus.Direction = ParameterDirection.Input;
s_Campus.Size = 50;
s_Campus.Index = 2;
s_Campus.Value = "";
_SCollection.Add(s_Campus);
DataSet _MyDs = _MyEdificio.GetData(_SCollection).Copy();
if (_MyDs.Tables[0].Rows.Count == 1)
{
DataRow _Dr = _MyDs.Tables[0].Rows[0];
if (DelegateIDBLEdificio1 != null)
{
DelegateIDBLEdificio1(_Dr["ID"].ToString());
}
this.hiddenidbl.Value = _Dr["ID"].ToString();
this._Edificio.BlId = (string)_Dr["BL_ID"];
this.lblBlId.Text = this._Edificio.BlId;
if (_Dr["DENOMINAZIONE"] != DBNull.Value)
{
this._Edificio.Name = (string)_Dr["DENOMINAZIONE"];
this.lblDenominazione.Text = this._Edificio.Name;
}
if (_Dr["INDIRIZZO"] != DBNull.Value)
{
this._Edificio.Address1 = (string)_Dr["INDIRIZZO"];
this.lblIndirizzo.Text = this._Edificio.Address1;
}
if (_Dr["CAMPUS"] != DBNull.Value)
{
this._Edificio.Campus = (string)_Dr["CAMPUS"];
this.txtRicerca.Text = this._Edificio.Campus;
}
if (_Dr["COMUNE"] != DBNull.Value)
{
this._Edificio.City_Id = (string)_Dr["COMUNE"];
this.lblComune.Text = this._Edificio.City_Id;
}
if (_Dr["REFERENTE"] != DBNull.Value)
{
this._Edificio.Contact_Name = (string)_Dr["REFERENTE"];
this.lblDitta.Text = this._Edificio.Contact_Name;
}
if (_Dr["TELEFONO_REFERENTE"] != DBNull.Value)
{
this._Edificio.Contact_Phone = (string)_Dr["TELEFONO_REFERENTE"];
this.lblTelefono.Text = this._Edificio.Contact_Phone;
}
if (_Dr["CENTRODICOSTO"] != DBNull.Value)
{
this._Edificio.Centro_Costo = (string)_Dr["CENTRODICOSTO"];
this.lblCdC.Text = this._Edificio.Centro_Costo;
}
if (_Dr["EMAIL"] != DBNull.Value)
{
this._Edificio.Option2 = (string)_Dr["EMAIL"];
this.lblEmail.Value = this._Edificio.Option2;
}
}
else
{
ClearCampi();
}
}
