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()); }