public DataSet GetImpostazioniDefault(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 = 4;
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 = 5;
CollezioneControlli.Add(s_Cursor);
string s_StrSql = "PACK_MAN_PROG.getImpostazioniDeafult";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
/// <summary>
/// Recupera le mail dei destinatari Xls
///</summary>
private ArrayList GetDestinatariXls(int bl_id)
{
S_ControlsCollection _SColl = new S_ControlsCollection();
S_Controls.Collections.S_Object p = new S_Object();
p.ParameterName = "p_bl_id";
p.DbType = CustomDBType.Integer;
p.Direction = ParameterDirection.Input;
p.Index = _SColl.Count;
p.Value = bl_id;
_SColl.Add(p);
p = new S_Object();
p.ParameterName = "IO_CURSOR";
p.DbType = CustomDBType.Cursor;
p.Direction = ParameterDirection.Output;
p.Index = _SColl.Count;
_SColl.Add(p);
string s_StrSql = "PACK_DETINATARIINVIO.SP_GETDESTINATARIXLS";
DataSet _Ds = _OraDl.GetRows(_SColl, s_StrSql);
ArrayList li = new ArrayList();
foreach (DataRow riga in _Ds.Tables[0].Rows)
{
li.Add(riga["mail"].ToString());
}
return(li);
}
public DataSet GetComuni(int anno)
{
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
DataSet _Ds;
S_Controls.Collections.S_Object s_Anno = new S_Object();
s_Anno.ParameterName = "p_Anno";
s_Anno.DbType = CustomDBType.Integer;
s_Anno.Direction = ParameterDirection.Input;
s_Anno.Index = 1;
s_Anno.Size = 50;
s_Anno.Value = anno;
CollezioneControlli.Add(s_Anno);
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 = 2;
CollezioneControlli.Add(s_Cursor);
string s_StrSql = "PACK_SCHEDULA.Crea_WR_GetComuni";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet GetAllReparto(string descrizione)
{
S_ControlsCollection _SColl = new S_ControlsCollection();
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.Size = 225;
s_p_descrizione.Direction = ParameterDirection.Input;
s_p_descrizione.Index = 0;
s_p_descrizione.Value = descrizione;
_SColl.Add(s_p_descrizione);
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);
_OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_RM.SP_GETALLREPARTO";
_Ds = _OraDl.GetRows(_SColl, s_StrSql).Copy();
return(_Ds);
}
public override System.Data.DataSet GetData(S_Controls.Collections.S_ControlsCollection CollezioneControlli)
{
System.Data.DataSet _DSet;
ApplicationDataLayer.OracleDataLayer _OraDl = new ApplicationDataLayer.OracleDataLayer(s_ConnStr);
_DSet = _OraDl.GetRows(CollezioneControlli, _nomeSoredProcedure).Copy();
return(_DSet);
}
private DataTable GetDataDIE()
{
S_ControlsCollection _SColl = new S_ControlsCollection();
S_Controls.Collections.S_Object p = new S_Object();
p.ParameterName = "p_wr_id";
p.DbType = CustomDBType.Integer;
p.Direction = ParameterDirection.Input;
p.Index = _SColl.Count;
p.Value = this.wr_id;
_SColl.Add(p);
p = new S_Object();
p.ParameterName = "IO_CURSOR";
p.DbType = CustomDBType.Cursor;
p.Direction = ParameterDirection.Output;
p.Index = _SColl.Count;
_SColl.Add(p);
string s_StrSql = "PACK_MANCORRETIVA.SP_GETDATIDIE";
DataSet _Ds = _OraDl.GetRows(_SColl, s_StrSql);
return(_Ds.Tables[0]);
}
public DataSet CompletaWO(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
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);
string s_StrSql = "PACK_MAN_PROG.CompletaWO";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public override System.Data.DataSet GetData(S_Controls.Collections.S_ControlsCollection CollezioneControlli)
{
System.Data.DataSet _DSet;
ApplicationDataLayer.OracleDataLayer _OraDl = new ApplicationDataLayer.OracleDataLayer(s_ConnStr);
//_DSet = _OraDl.GetRows(CollezioneControlli, "PACK_ANALISI_STATISTICHE.GET_RDL_MESE_COMPLETATA").Copy();
_DSet = _OraDl.GetRows(CollezioneControlli, _NameProcedure_Db).Copy();
return(_DSet);
}
public DataSet GetComuni(int anno, string MeseDa, string MeseA)
{
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
DataSet _Ds;
S_Controls.Collections.S_Object s_Anno = new S_Object();
s_Anno.ParameterName = "p_Anno";
s_Anno.DbType = CustomDBType.Integer;
s_Anno.Direction = ParameterDirection.Input;
s_Anno.Index = 0;
s_Anno.Value = anno;
CollezioneControlli.Add(s_Anno);
S_Controls.Collections.S_Object s_Mese1 = new S_Object();
s_Mese1.ParameterName = "Mese1";
s_Mese1.DbType = CustomDBType.VarChar;
s_Mese1.Direction = ParameterDirection.Input;
s_Mese1.Index = 1;
s_Mese1.Size = 50;
s_Mese1.Value = MeseDa;
CollezioneControlli.Add(s_Mese1);
S_Controls.Collections.S_Object s_Mese2 = new S_Object();
s_Mese2.ParameterName = "Mese2";
s_Mese2.DbType = CustomDBType.VarChar;
s_Mese2.Direction = ParameterDirection.Input;
s_Mese2.Index = 2;
s_Mese2.Size = 50;
s_Mese2.Value = MeseA;
CollezioneControlli.Add(s_Mese2);
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;
CollezioneControlli.Add(s_Cursor);
string s_StrSql = "PACK_SCHEDULA.Rapportino_GetComuni";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
/// <summary>
/// Ricerca le richieste Accorpante
/// </summary>
/// <param name="CollezioneControlli"></param>
/// <returns></returns>
public DataSet Accorpante(S_ControlsCollection CollezioneControlli)
{
S_Controls.Collections.S_Object s_p_utente = new S_Object();
s_p_utente.ParameterName = "p_utente";
s_p_utente.DbType = CustomDBType.VarChar;
s_p_utente.Direction = ParameterDirection.Input;
s_p_utente.Index = CollezioneControlli.Count + 1;
s_p_utente.Value = this.username;
s_p_utente.Size = 50;
CollezioneControlli.Add(s_p_utente);
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_GetAccorpante";
DataSet _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet GetAllCategoria()
{
S_ControlsCollection _SColl = new S_ControlsCollection();
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);
_OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_RPT_GESTIONE_SPAZI.SP_GETALLCATEGORIE";
_Ds = _OraDl.GetRows(_SColl, s_StrSql).Copy();
return(_Ds);
}
public DataSet GetDatiEdificio(int wr_id)
{
DataSet _Ds;
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
S_Controls.Collections.S_Object s_IdIn = new S_Object();
s_IdIn.ParameterName = "p_Wr_Id";
s_IdIn.DbType = CustomDBType.Integer;
s_IdIn.Direction = ParameterDirection.Input;
s_IdIn.Index = CollezioneControlli.Count + 1;
s_IdIn.Value = wr_id;
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);
string s_StrSql = "PACK_MANCORRETIVA.SP_GETDATIBL";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}