public DataSet GetAllPMP(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
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.Index = CollezioneControlli.Count;
s_UserName.Value = System.Web.HttpContext.Current.User.Identity.Name;
s_UserName.Size = 50;
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 = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_UserName);
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_PMP.SP_GetPMPSteps";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet GetIstruzioni()
{
S_ControlsCollection _SCollection = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_sql = new S_Controls.Collections.S_Object();
s_p_sql.ParameterName = "p_sql";
s_p_sql.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_sql.Direction = ParameterDirection.Input;
s_p_sql.Size = 2000;
s_p_sql.Index = 0;
s_p_sql.Value = "select pmps.pmps_id || ' ' || pmps.instructions as ISTRUZIONI, pmps.id_pmp as ID from pmps order by pmps.id_pmp, pmps.pmps_id";
_SCollection.Add(s_p_sql);
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 = 1;
_SCollection.Add(s_Cursor);
DataSet _Ds;
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_COMMON.SP_DYNAMIC_SELECT";
_Ds = _OraDl.GetRows(_SCollection, s_StrSql).Copy();
_Ds.Tables[0].TableName = "ISTRUZIONI";
return(_Ds);
}
protected DataTable GetData()
{
ApplicationDataLayer.OracleDataLayer _OraDl;
_OraDl = new OracleDataLayer(s_ConnStr);
DataSet _Ds = new DataSet();
//Recupero i dati dal DataBase
try
{
_Ds = _OraDl.GetRows(paramFederico, CurrentProcedure).Copy();
//this.Id = itemId;
return(_Ds.Tables[0]);
}
catch (Exception ex)
{
if (LabelMessage != null)
{
LabelMessage.Text = ex.Message;
}
else
{
throw ex;
}
return(new DataTable());
}
}
public DataSet GetStanze(int idBl, int idPiani)
{
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_id_bl = new S_Object();
s_p_id_bl.ParameterName = "p_id_bl";
s_p_id_bl.DbType = CustomDBType.Integer;
s_p_id_bl.Direction = ParameterDirection.Input;
s_p_id_bl.Index = CollezioneControlli.Count + 1;
s_p_id_bl.Value = idBl;
CollezioneControlli.Add(s_p_id_bl);
S_Controls.Collections.S_Object s_p_id_piani = new S_Object();
s_p_id_piani.ParameterName = "p_id_piani";
s_p_id_piani.DbType = CustomDBType.Integer;
s_p_id_piani.Direction = ParameterDirection.Input;
s_p_id_piani.Index = CollezioneControlli.Count + 1;
s_p_id_piani.Value = idPiani;
CollezioneControlli.Add(s_p_id_piani);
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 = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_DATITECNICIAPP.SP_GETSTANZE";
// string s_StrSql = "PACK_DATITECNICI_M.SP_GETSTANZE";
DataSet _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public int GetDataCount(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
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.Index = CollezioneControlli.Count + 1;
s_UserName.Value = this.UserName;
s_UserName.Size = 50;
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 = CollezioneControlli.Count + 2;
CollezioneControlli.Add(s_UserName);
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_MAN_PROG.getPAnnualeCount";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(int.Parse(_Ds.Tables[0].Rows[0][0].ToString()));
}
public DataSet GetRDLApprovate(string bl_id)
{
DataSet _Ds;
S_Controls.Collections.S_ControlsCollection _SColl = new S_ControlsCollection();
S_Controls.Collections.S_Object s_bl_id = new S_Object();
s_bl_id.ParameterName = "p_Bl_id";
s_bl_id.DbType = CustomDBType.VarChar;
s_bl_id.Direction = ParameterDirection.Input;
s_bl_id.Index = 0;
s_bl_id.Value = bl_id;
_SColl.Add(s_bl_id);
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 = 0;
_SColl.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_MANCORRETIVA.SP_GetRDLApprovate";
_Ds = _OraDl.GetRows(_SColl, s_StrSql).Copy();
return(_Ds);
}
public override DataSet GetSingleData(int itemId)
{
DataSet _Ds;
S_ControlsCollection _SColl = new S_ControlsCollection();
S_Controls.Collections.S_Object s_Id = new S_Object();
s_Id.ParameterName = "p_id";
s_Id.DbType = CustomDBType.Integer;
s_Id.Direction = ParameterDirection.Input;
s_Id.Index = 0;
s_Id.Value = itemId;
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 = 1;
_SColl.Add(s_Id);
_SColl.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_RICHIEDENTI.SP_GETSINGLERICHIEDENTI";
_Ds = _OraDl.GetRows(_SColl, s_StrSql).Copy();
this.Id = itemId;
return(_Ds);
}
/// <summary>
/// usa il campo bl_id, di fatto chiave primaria della tabella bl
/// </summary>
/// <param name="itemId"></param>
/// <returns></returns>
public DataSet GetSingleData(string itemId)
{
DataSet _Ds;
S_ControlsCollection _SColl = new S_ControlsCollection();
S_Controls.Collections.S_Object s_Id = new S_Object();
s_Id.ParameterName = "p_BL_ID";
s_Id.DbType = CustomDBType.VarChar;
s_Id.Direction = ParameterDirection.Input;
s_Id.Index = 0;
s_Id.Value = itemId;
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 = 1;
_SColl.Add(s_Id);
_SColl.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_BUILDINGS.SP_GETSINGLEBL_FROM_BL_ID";
_Ds = _OraDl.GetRows(_SColl, s_StrSql).Copy();
//this.Id = itemId;
return(_Ds);
}
public DataSet GetAllPianiNonAssociati(int blId)
{
DataSet _Ds;
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
S_Controls.Collections.S_Object s_BlId = new S_Object();
s_BlId.ParameterName = "p_ID_BL";
s_BlId.DbType = CustomDBType.Integer;
s_BlId.Value = blId;
s_BlId.Direction = ParameterDirection.Input;
s_BlId.Index = 0;
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 = 1;
CollezioneControlli.Add(s_BlId);
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_BUILDINGS.SP_GETPIANIBUILDING_NASS";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public int GetNumeroStanzeBuilding(int idedificio)
{
DataSet _Ds;
S_ControlsCollection _SColl = new S_ControlsCollection();
S_Controls.Collections.S_Object s_IdEdificio = new S_Object();
s_IdEdificio.ParameterName = "p_Bl_Id";
s_IdEdificio.DbType = CustomDBType.Integer;
s_IdEdificio.Direction = ParameterDirection.Input;
s_IdEdificio.Index = 0;
s_IdEdificio.Value = idedificio;
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 = 1;
_SColl.Add(s_Cursor);
_SColl.Add(s_IdEdificio);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_BUILDINGS.SP_STANZE_EDIFICIO";
_Ds = _OraDl.GetRows(_SColl, s_StrSql).Copy();
return(_Ds.Tables[0].Rows.Count);
}
public DataSet GetServiziBuilding(int idditta)
{
DataSet _Ds;
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
S_Controls.Collections.S_Object s_id = new S_Object();
s_id.ParameterName = "p_ID_BL";
s_id.DbType = CustomDBType.Integer;
s_id.Direction = ParameterDirection.Input;
s_id.Index = 0;
s_id.Value = idditta;
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 = 1;
CollezioneControlli.Add(s_id);
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_BUILDINGS.SP_GETSERVIZI_BUILDING";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet GetPianiBuilding(string id_bl)
{
DataSet _Ds;
S_ControlsCollection _SColl = new S_ControlsCollection();
S_Controls.Collections.S_Object s_id = new S_Object();
s_id.ParameterName = "p_ID_BL";
s_id.DbType = CustomDBType.VarChar;
s_id.Direction = ParameterDirection.Input;
s_id.Index = 0;
s_id.Value = id_bl;
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 = 1;
_SColl.Add(s_id);
_SColl.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_CAD.SP_GETPIANIBUILDING";
_Ds = _OraDl.GetRows(_SColl, s_StrSql).Copy();
return(_Ds);
}
public override DataSet GetSingleData(int itemId)
{
S_Controls.Collections.S_Object s_Id = new S_Object();
s_Id.ParameterName = "p_id";
s_Id.DbType = CustomDBType.Integer;
s_Id.Direction = ParameterDirection.Input;
s_Id.Index = 0;
s_Id.Value = itemId;
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 = 1;
CollezioneControlli.Add(s_Id);
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_RPT_GESTIONE_SPAZI.SP_GETSINGLECATEGORIA";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
this.Id = itemId;
return(_Ds);
}
public DataSet GetFrequenze()
{
S_ControlsCollection _SCollection = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_sql = new S_Controls.Collections.S_Object();
s_p_sql.ParameterName = "p_sql";
s_p_sql.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_sql.Direction = ParameterDirection.Input;
s_p_sql.Size = 2000;
s_p_sql.Index = 0;
s_p_sql.Value = "Select frequenza as freq, frequenza_des as des from pmpfrequenza";
_SCollection.Add(s_p_sql);
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 = 1;
_SCollection.Add(s_Cursor);
DataSet _Ds;
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_COMMON.SP_DYNAMIC_SELECT";
_Ds = _OraDl.GetRows(_SCollection, s_StrSql).Copy();
return(_Ds);
}
public override DataSet GetData(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
// 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.Index = CollezioneControlli.Count + 1;
// s_UserName.Value = this.s_username;
// s_UserName.Size = 50;
// CollezioneControlli.Add(s_UserName);
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 = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_SCHEDAAPPARECCHIATURE.SP_GETSCHEDAAPPARECCHIATURE";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet GetVenditore(int idvenditore)
{
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_id = new S_Object();
s_p_id.ParameterName = "p_id";
s_p_id.DbType = CustomDBType.Integer;
s_p_id.Direction = ParameterDirection.Input;
s_p_id.Index = CollezioneControlli.Count + 1;
s_p_id.Value = idvenditore;
CollezioneControlli.Add(s_p_id);
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 = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_DATITECNICIAPP.SP_GETVENDITORE";
// string s_StrSql = "PACK_DATITECNICI_M.SP_GETVENDITORE";
DataSet _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
/// <summary>
/// Ricerca le Richieste della Manutenzione Correttiva
/// Usata nella Pagina Completamento Manutenzione Correttiva
/// </summary>
/// <param name="CollezioneControlli"></param>
/// <returns></returns>
public DataSet GetDataCompletamento(S_Controls.Collections.S_ControlsCollection CollezioneControlli)
{
S_Controls.Collections.S_Object s_p_username = new S_Object();
s_p_username.ParameterName = "p_username";
s_p_username.DbType = CustomDBType.VarChar;
s_p_username.Direction = ParameterDirection.Input;
s_p_username.Index = CollezioneControlli.Count + 1;
s_p_username.Value = this.username;
s_p_username.Size = 50;
CollezioneControlli.Add(s_p_username);
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 = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_MANCORRETIVA.SP_GETCOMPLETAMENTO";
DataSet _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet GetAnalisiRDL(S_ControlsCollection CollezioneControlli, string utente)
{
DataSet _Ds;
S_Controls.Collections.S_Object s_IdIn = new S_Object();
s_IdIn.ParameterName = "p_CurrentUser";
s_IdIn.DbType = CustomDBType.VarChar;
s_IdIn.Direction = ParameterDirection.Input;
s_IdIn.Index = CollezioneControlli.Count + 1;
s_IdIn.Value = utente;
CollezioneControlli.Add(s_IdIn);
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 = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_MAN_ORD.SP_GETANALISIRDL";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
/// <summary>
///
/// </summary>
/// <param name="CollezioneControlli"></param>
/// <returns></returns>
public override DataSet GetData(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
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.Index = 8;
s_UserName.Size = 50;
s_UserName.Value = System.Web.HttpContext.Current.User.Identity.Name;
CollezioneControlli.Add(s_UserName);
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 = 9;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_MAN_PROG.GetCompletamento";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet GetIstruzionePmp(string pmpId)
{
DataSet _Ds;
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
S_Controls.Collections.S_Object s_Id = new S_Object();
s_Id.ParameterName = "p_pmp_id";
s_Id.DbType = CustomDBType.VarChar;
s_Id.Direction = ParameterDirection.Input;
s_Id.Index = 0;
s_Id.Value = pmpId;
CollezioneControlli.Add(s_Id);
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 = CollezioneControlli.Count;
CollezioneControlli.Add(S_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDL = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_PMP.SP_GETISTRUZIONI_PMPS";
_Ds = _OraDL.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet GetDatabyEQ(int itemEQId)
{
DataSet _Ds;
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
S_Controls.Collections.S_Object s_Id = new S_Object();
s_Id.ParameterName = "p_eq_id";
s_Id.DbType = CustomDBType.Integer;
s_Id.Direction = ParameterDirection.Input;
s_Id.Index = 0;
s_Id.Value = itemEQId;
CollezioneControlli.Add(s_Id);
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 = CollezioneControlli.Count;
CollezioneControlli.Add(S_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDL = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_PMP.SP_GETPMPBYEQ";
_Ds = _OraDL.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public string GetCodicepmp(S_ControlsCollection _SColl)
{
DataSet _Ds;
string s_out;
//S_ControlsCollection _SColl = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_OUT = new S_Object();
s_p_OUT.ParameterName = "IO_CURSOR";
s_p_OUT.DbType = CustomDBType.Cursor;
s_p_OUT.Direction = ParameterDirection.Output;
s_p_OUT.Index = _SColl.Count;
_SColl.Add(s_p_OUT);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_PMP.SP_CREAPMP";
_Ds = _OraDl.GetRows(_SColl, s_StrSql).Copy();
s_out = _Ds.Tables[0].Rows[0][0].ToString();
return(s_out);
}
public DataSet docNormativiList(S_ControlsCollection CollezioneControlli)
{
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_CPERIODICI_SFOGLIA.DOC_NORMATIVI_LIST";
DataSet _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet GetAddetti(string NomeCompleto, string BL_ID, int ditta_id)
{
S_ControlsCollection _SCollection = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_NomeCompleto = new S_Controls.Collections.S_Object();
s_p_NomeCompleto.ParameterName = "p_NomeCompleto";
s_p_NomeCompleto.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_NomeCompleto.Direction = ParameterDirection.Input;
s_p_NomeCompleto.Size = 50;
s_p_NomeCompleto.Index = 0;
s_p_NomeCompleto.Value = NomeCompleto;
_SCollection.Add(s_p_NomeCompleto);
S_Controls.Collections.S_Object s_p_BL_ID = new S_Controls.Collections.S_Object();
s_p_BL_ID.ParameterName = "p_bl_id";
s_p_BL_ID.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_BL_ID.Direction = ParameterDirection.Input;
s_p_BL_ID.Size = 50;
s_p_BL_ID.Index = 1;
s_p_BL_ID.Value = BL_ID;
_SCollection.Add(s_p_BL_ID);
S_Controls.Collections.S_Object s_p_DITTA_ID = new S_Controls.Collections.S_Object();
s_p_DITTA_ID.ParameterName = "p_ditta_id";
s_p_DITTA_ID.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DITTA_ID.Direction = ParameterDirection.Input;
s_p_DITTA_ID.Size = 50;
s_p_DITTA_ID.Index = 2;
s_p_DITTA_ID.Value = ditta_id;
_SCollection.Add(s_p_DITTA_ID);
S_Controls.Collections.S_Object s_p_UserName = new S_Controls.Collections.S_Object();
s_p_UserName.ParameterName = "p_UserName";
s_p_UserName.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_UserName.Direction = ParameterDirection.Input;
s_p_UserName.Size = 50;
s_p_UserName.Index = 3;
s_p_UserName.Value = System.Web.HttpContext.Current.User.Identity.Name;
_SCollection.Add(s_p_UserName);
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 = 4;
_SCollection.Add(s_Cursor);
DataSet _Ds;
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
//string s_StrSql = "PACK_MAN_ORD.SP_GetAddetti";
string s_StrSql = "PACK_ADDETTI.SP_GETADDETTORUOLO";
_Ds = _OraDl.GetRows(_SCollection, s_StrSql).Copy();
return(_Ds);
}
public bool IsValidBlId(string BlId)
{
string s_User = System.Web.HttpContext.Current.User.Identity.Name;
Classi.ClassiDettaglio.Edificio _Edificio = new
TheSite.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 DataSet GetRichiedenti(string NomeCompleto, string CognomeCompleto, string Progetto, string Gruppo)
{
S_ControlsCollection _SCollection = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_NomeCompleto = new S_Controls.Collections.S_Object();
s_p_NomeCompleto.ParameterName = "p_NomeCompleto";
s_p_NomeCompleto.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_NomeCompleto.Direction = ParameterDirection.Input;
s_p_NomeCompleto.Size = 50;
s_p_NomeCompleto.Index = _SCollection.Count;
s_p_NomeCompleto.Value = NomeCompleto;
_SCollection.Add(s_p_NomeCompleto);
S_Controls.Collections.S_Object s_p_CognomeCompleto = new S_Controls.Collections.S_Object();
s_p_CognomeCompleto.ParameterName = "p_CognomeCompleto";
s_p_CognomeCompleto.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_CognomeCompleto.Direction = ParameterDirection.Input;
s_p_CognomeCompleto.Size = 50;
s_p_CognomeCompleto.Index = _SCollection.Count;
s_p_CognomeCompleto.Value = CognomeCompleto;
_SCollection.Add(s_p_CognomeCompleto);
S_Controls.Collections.S_Object s_p_progetto = new S_Controls.Collections.S_Object();
s_p_progetto.ParameterName = "p_progetto";
s_p_progetto.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_progetto.Direction = ParameterDirection.Input;
s_p_progetto.Index = _SCollection.Count;
s_p_progetto.Value = (Progetto == "" || Progetto == "0")?0:int.Parse(Progetto);
_SCollection.Add(s_p_progetto);
S_Controls.Collections.S_Object s_p_gruppo = new S_Controls.Collections.S_Object();
s_p_gruppo.ParameterName = "p_gruppo";
s_p_gruppo.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_gruppo.Direction = ParameterDirection.Input;
s_p_gruppo.Index = _SCollection.Count;
s_p_gruppo.Value = (Gruppo == "" || Gruppo == "0")?0:int.Parse(Gruppo);
_SCollection.Add(s_p_gruppo);
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 = _SCollection.Count;
_SCollection.Add(s_Cursor);
DataSet _Ds;
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_RICHIEDENTI.SP_GetRichiedenti2";
_Ds = _OraDl.GetRows(_SCollection, s_StrSql).Copy();
return(_Ds);
}
public int GetDataCount(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_MAN_PROG.getProcStepsCount";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(int.Parse(_Ds.Tables[0].Rows[0][0].ToString()));
}
public DataSet ControllaDuplicato(string tabella, string campo_input, string valore, string campo_output)
{
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
S_Controls.Collections.S_Object s_Tabella = new S_Object();
s_Tabella.ParameterName = "p_tabella";
s_Tabella.DbType = CustomDBType.VarChar;
s_Tabella.Direction = ParameterDirection.Input;
s_Tabella.Index = 0;
s_Tabella.Value = tabella;
s_Tabella.Size = 50;
S_Controls.Collections.S_Object s_campo = new S_Object();
s_campo.ParameterName = "p_campo_input";
s_campo.DbType = CustomDBType.VarChar;
s_campo.Direction = ParameterDirection.Input;
s_campo.Index = 1;
s_campo.Value = campo_input;
s_campo.Size = 50;
S_Controls.Collections.S_Object s_valore = new S_Object();
s_valore.ParameterName = "p_valore";
s_valore.DbType = CustomDBType.VarChar;
s_valore.Direction = ParameterDirection.Input;
s_valore.Index = 2;
s_valore.Value = valore;
s_valore.Size = 50;
S_Controls.Collections.S_Object s_campo_output = new S_Object();
s_campo_output.ParameterName = "p_campo_output";
s_campo_output.DbType = CustomDBType.VarChar;
s_campo_output.Direction = ParameterDirection.Input;
s_campo_output.Index = 3;
s_campo_output.Value = campo_output;
s_campo_output.Size = 50;
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 = 4;
CollezioneControlli.Add(s_Tabella);
CollezioneControlli.Add(s_campo);
CollezioneControlli.Add(s_valore);
CollezioneControlli.Add(s_campo_output);
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_COMMON.SP_SEARCHDUPLICATO";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet GetSfoglia(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_TRACCIA_DOC.SP_GETLOG";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public override DataSet GetData(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_ENTI.GETENTI";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}