public DataTable SelectRegister(Ent_tticol119 MyObj119, ref string strError)
{
DataTable retorno = new DataTable();
try
{
retorno = dal.SelectRegister(ref MyObj119, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
public static string Send(string ITEM, string WARE, string PAID, string CLOT, string DATEI, string DATEF)
{
string strError = string.Empty;
List <Ent_tticol119> lst119 = new List <Ent_tticol119>();
Ent_tticol119 MyObj119 = new Ent_tticol119();
MyObj119.item = ITEM;
MyObj119.cwar = WARE;
MyObj119.paid = PAID;
MyObj119.clot = CLOT;
MyObj119.dati = Convert.ToDateTime(DATEI).ToString("MM/dd/yyyy");
MyObj119.datf = Convert.ToDateTime(DATEF).ToString("MM/dd/yyyy");
DataTable DT119 = ticol119DAL.SelectRegister(MyObj119, ref strError);
if (DT119.Rows.Count > 0)
{
foreach (DataRow row in DT119.Rows)
{
Ent_tticol119 MyObj119lst = new Ent_tticol119();
MyObj119lst.item = row["T$ITEM"].ToString();
MyObj119lst.cwar = row["T$CWAR"].ToString();
MyObj119lst.clot = row["T$CLOT"].ToString();
MyObj119lst.qtyr = Convert.ToInt32(row["T$QTYR"].ToString());
MyObj119lst.cdis = row["T$CDIS"].ToString();
MyObj119lst.obse = row["T$OBSE"].ToString();
MyObj119lst.logr = row["T$LOGR"].ToString();
MyObj119lst.datr = row["T$DATR"].ToString();
MyObj119lst.disp = row["T$DISP"].ToString();
MyObj119lst.stoc = row["T$STOC"].ToString();
MyObj119lst.ritm = row["T$RITM"].ToString();
MyObj119lst.proc = Convert.ToInt32(row["T$PROC"].ToString());
MyObj119lst.mess = row["T$MESS"].ToString();
MyObj119lst.suno = row["T$SUNO"].ToString();
MyObj119lst.paid = row["T$PAID"].ToString();
MyObj119lst.plld = row["T$PLLD"].ToString();
MyObj119lst.refcntd = Convert.ToInt32(row["T$REFCNTD"].ToString());
MyObj119lst.refcntu = Convert.ToInt32(row["T$REFCNTU"].ToString());
lst119.Add(MyObj119lst);
}
}
return(JsonConvert.SerializeObject(lst119));
}
public DataTable SelectRegister(ref Ent_tticol119 Obj119, ref string strError)
{
Dictionary <string, object> paramList = new Dictionary <string, object>();
paramList.Add(":T$PAID", Obj119.paid);
paramList.Add(":T$CWAR", Obj119.cwar);
paramList.Add(":T$ITEM", Obj119.item);
paramList.Add(":T$CLOT", Obj119.clot);
paramList.Add(":DATEI", Obj119.dati);
paramList.Add(":DATEF", Obj119.datf);
string strSentenciaS = recursos.readStatement(method.ReflectedType.Name, "SelectRegister", ref owner, ref env, tabla, paramList);
try
{
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentenciaS, ref parametersOut, null, true);
}
catch (Exception ex)
{
strError = "Error al buscar informacion para imprimir [tticol119]. Try again or contact your administrator \n " + strSentencia;
log.escribirError(strError + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(consulta);
}
