public static string Sincro2000()
{
string[] Fecha = DateTime.Now.ToString("yyyy-MM-dd").Split('-');
SincroController control_sincro = new SincroController();
if (control_sincro.SincronizadorACR(Fecha[0], Fecha[1], Fecha[2]) == "OK")
{
}
return("");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CargarSuscripcion();
cargarLeidos();
CargarAsignadas();
SincroController control_sincro = new SincroController();
//if (control_sincro.GenerarCorreoInformeFacturacion("", "", "0"))
//{
//}
}
HtmlAnchor MyLnk = (HtmlAnchor)this.Master.FindControl("menuProduccion");
MyLnk.Attributes.Add("class", "b-hover");
}
public static string SincroAutoOTS(string Usuario, string Horas, string Minutos)
{
SincroController controlSin = new SincroController();
string fec = DateTime.Now.ToString("yyyy/MM/dd");
int ins = controlSin.SincronizarOTAutomatica(Usuario, Convert.ToDateTime(fec + " " + Horas + ":00:" + "00"), 1);
if (ins != 0)
{
try
{
List <SincronizarOT> lista = controlSin.listaOTSincroOT();
List <SincronizarOT> listaSincro = controlSin.listaOTSincroMetrics();
string query = "";
int contador = 0;
foreach (SincronizarOT sinOT in listaSincro)
{
int count = lista.Where(o => o.QG_RMS_JOB_NBR.Trim() == sinOT.QG_RMS_JOB_NBR.Trim()).Count();
if (count == 0)
{
DateTime fecha = Convert.ToDateTime(sinOT.CTD_TMSTMP);
query = query + "INSERT INTO Data_P2B.dbo.QGPressJob (QG_RMS_JOB_NBR ,NM ,CTD_TMSTMP ,DUE_DT ,JOB_STS ,CUST_RUT ,CUST_NM, QG_RMS_TITLE_CD ," +
" PRN_ORD_QTY,IMPZ_PROD_HGT,IMPZ_PROD_WDT,OPN_WDTH,OPN_HGT,AccountAddress1,AccountAddress2,AccountNeighborhood," +
" AccountRegion,AccountCountry,AccountCity ,FullIssueName,FECHA_LIQUIDACION) VALUES" +
"('" + sinOT.QG_RMS_JOB_NBR.Trim() + "','" + sinOT.NM + "','" + fecha.ToString("yyyy-dd-MM HH:mm:ss") + "',NULL," + sinOT.JOB_STS + ",'" + sinOT.CUST_RUT + "','" +
sinOT.CUST_NM + "','" + sinOT.QG_RMS_TITLE_CD + "'," + sinOT.PRN_ORD_QTY + ",NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);";
}
else
{
query = query + "UPDATE Data_P2B.dbo.QGPressJob SET NM = '" + sinOT.NM + "',CUST_RUT = '" + sinOT.CUST_RUT + "'" +
",CUST_NM = '" + sinOT.CUST_NM + "',PRN_ORD_QTY = " + sinOT.PRN_ORD_QTY + ", JOB_STS= " + sinOT.JOB_STS + " WHERE QG_RMS_JOB_NBR = '" + sinOT.QG_RMS_JOB_NBR.Trim() + "';";
}
contador++;
}
}
catch (Exception e)
{
bool r = controlSin.generarCorreoErrorSuscripcion(e.ToString());
}
}
return("");
}
