static private Dictionary <string, decimal> Init_List_AccantonamentiRigheORV(string libreria)
{
Dictionary <string, decimal> ret = new Dictionary <string, decimal>(1500);
string __libreriaAs400 = libreria;
string _tabORR = __libreriaAs400 + ".ORR00PF";
string _tabORV = __libreriaAs400 + ".ORV00PF";
//recupero totali accantonamenti per ogni articolo presente in ORR
string query = "SELECT "
+ _tabORR + ".ORRCART, Sum( " + _tabORR + ".ORRQACA) AS QTAALLOC "
+ " FROM " + _tabORR
+ " WHERE " + _tabORR + ".ORRSTAT ='RI' "
//+ " and " + _tabORR + ".ORRTORD<>'ORC' "
+ " and " + _tabORR + ".ORRCART not like 'WU%' \n"
+ " GROUP BY ORRCART "
+ " HAVING Sum(" + _tabORR + ".ORRQACA)<>0 "
+ " order by ORRCART ";
DBHelper2 db = DBHelper2.getAs400DBHelper(libreria);
DbDataReader dtr = db.GetReaderSelectCommand(query);
object[] row = new object[dtr.FieldCount];
while (dtr.Read())
{
dtr.GetValues(row);
ret.Add(Item.GetDBV <string>(row[0], "ORRCART"), Item.GetDBV <decimal>(row[1], "Sum(ORRQACA)"));
}
return(ret);
}
static public void GetFileImport_YMFG_Sage()
{
string libreriaAs400 = "MBM41LIB_M";
DBHelper2 sage = DBHelper2.getAs400DBHelper(libreriaAs400);
_logger.Debug(System.Reflection.MethodBase.GetCurrentMethod().Name + " start...");
string qry = GetSelectQuery_opr_CON_ODV(libreriaAs400);
DbDataReader dtr = sage.GetReaderSelectCommand(qry);
object[] row = new object[dtr.FieldCount];
OrdiniAcq_OPR_As400_FIRSTIMPORT opr = null;
string pathfile = @"\\srvx3app1\S$\Sage\SAGEX3\folders\SAURO\YSAURO\IMPEXP\Import_Iniziale_OPR_Da_As400_CON_ODV.txt";
pathfile = @"Import_Iniziale_OPR_Da_As400_CON_ODV.txt";
using (System.IO.StreamWriter fs = new System.IO.StreamWriter(pathfile, false))
{
while (dtr.Read())
{
opr = new OrdiniAcq_OPR_As400_FIRSTIMPORT();
dtr.GetValues(row);
opr.Init(row);
fs.Write(opr.getSageImportString());
}
}
dtr.Close();
qry = GetSelectQuery_opr_SENZA_ODV(libreriaAs400);
dtr = sage.GetReaderSelectCommand(qry);
row = new object[dtr.FieldCount];
opr = null;
pathfile = @"\\srvx3app1\S$\Sage\SAGEX3\folders\SAURO\YSAURO\IMPEXP\Import_Iniziale_OPR_Da_As400_SENZA_ODV.txt";
pathfile = @"Import_Iniziale_OPR_Da_As400_SENZA_ODV.txt";
using (System.IO.StreamWriter fs = new System.IO.StreamWriter(pathfile, false))
{
while (dtr.Read())
{
opr = new OrdiniAcq_OPR_As400_FIRSTIMPORT();
dtr.GetValues(row);
opr.Init(row);
fs.Write(opr.getSageImportString());
}
}
dtr.Close();
_logger.Debug(System.Reflection.MethodBase.GetCurrentMethod().Name + " end");
return;
}