private string Planilla(string plani)
{
string result = "";
int output;
if (int.TryParse(plani, out output))
{
mRECC = dRECC.GetPlani(plani);
if (mRECC != null)
{
result = "OK";
}
else
{
mRDCC = dRDCC.GetInfo(plani);
if (mRDCC != null)
{
ActualizaRECC(mRDCC.DCONSO);
mRECC = dRECC.GetPlani(plani);
if (mRECC != null)
{
result = "OK";
}
}
}
}
return(result);
}
public List <RECC> GetData2(RECC recc)
{
StringBuilder query = new StringBuilder();
query.Append(" SELECT EID");
query.Append(" FROM RECC");
query.Append(" WHERE ECONSO = '" + recc.ECONSO + "'");
query.Append(" AND EPEDID = " + recc.EPEDID);
query.Append(" AND EIDIVI = '" + recc.EIDIVI + "'");
query.Append(" AND ECUST = " + recc.ECUST);
query.Append(" AND ESHIP = " + recc.ESHIP);
query.Append(" AND EPLANI = 0");
return(db.Query <RECC>(query.ToString()).ToList());
}
