public TOTransaction <TOCfConct> GetInfoCfConct(string ter_coda, int emp_codi) { DAOCfConct daoCfConct = new DAOCfConct(); TOCfConct result = new TOCfConct(); try { result = daoCfConct.GetInfoCfConct(ter_coda, emp_codi); if (result == null) { result = daoCfConct.GetInfoFechSald(ter_coda, emp_codi); result.dim_fech = string.IsNullOrEmpty(result.dim_fech) ? "" : Convert.ToDateTime(result.dim_fech).ToString("dd/MM/yyyy"); } else { result.dim_fech = string.IsNullOrEmpty(result.dim_fech) ? "" : Convert.ToDateTime(result.dim_fech).ToString("dd/MM/yyyy"); } return(new TOTransaction <TOCfConct>() { objTransaction = result, retorno = 0, txtRetorno = "" }); } catch (Exception ex) { return(new TOTransaction <TOCfConct>() { objTransaction = null, retorno = 1, txtRetorno = ex.Message }); } }
public TOTransaction <string> BuildPrintLink(TOCfConct CfConct) { try { CultureInfo.DefaultThreadCurrentCulture = new CultureInfo("es-CO"); string usu_codi = ConfigurationManager.AppSettings["usu_codi"].ToString(); string reportPublic = ConfigurationManager.AppSettings["reportPublic"].ToString(); string dinamicReport = ConfigurationManager.AppSettings["dinamicReport"].ToString(); StringBuilder sf = new StringBuilder(); string url = ""; string urlReporte = ConfigurationManager.AppSettings["UrlReport"]; string reporte = ""; reporte = "SSuConct"; List <string> Params = new List <string>(); Params.Add(CfConct.emp_codi.ToString()); Params.Add(CfConct.emp_nomb); Params.Add(usu_codi); Params.Add("dd/mm/yyyy"); Params.Add(DateTime.Parse(CfConct.dim_feci).ToString("dd/MM/yyyy")); Params.Add(DateTime.Parse(CfConct.dim_fecf).ToString("dd/MM/yyyy")); Params.Add("$ " + String.Format("{0:0,0.0}", CfConct.bon_sald)); if (CfConct.dim_fech != "") { Params.Add(DateTime.Parse(CfConct.dim_fech).ToString("dd/MM/yyyy")); } else { Params.Add(""); // DateTime.Now.ToString("dd/MM/yyyy")); } sf.Append("{Comando.TER_CODA}='" + CfConct.ter_coda + "'"); sf.Append(" AND {Comando.EMP_CODI}=" + CfConct.emp_codi); sf.Append(" AND {Comando.DIM_FECH}>= date(" + DateTime.Parse(CfConct.dim_feci).Year + ", " + DateTime.Parse(CfConct.dim_feci).Month + ", " + DateTime.Parse(CfConct.dim_feci).Day + ")"); sf.Append(" AND {Comando.DIM_FECH}< date(" + DateTime.Parse(CfConct.dim_fecf).Year + ", " + DateTime.Parse(CfConct.dim_fecf).Month + ", " + DateTime.Parse(CfConct.dim_fecf).Day + ")"); sf.Append(" AND {Comando.AST_ESTA}='A'"); sf.Append(" AND {Comando.IMC_ESTA}='A'"); url = GetURLReporte(reporte, Params, sf.ToString(), urlReporte); return(new TOTransaction <string>() { objTransaction = url, retorno = 0, txtRetorno = "" }); } catch (Exception ex) { return(new TOTransaction <string>() { objTransaction = null, retorno = 1, txtRetorno = ex.Message }); } }
public TOTransaction <string> BuildPrintLink(TOCfConct CfConct) { BOCfConct bo = new BOCfConct(); return(bo.BuildPrintLink(CfConct)); }