/// <summary> /// 获取所有货币信息 /// </summary> /// <returns></returns> public static List <t_currencyEntity> GetCurrencyList() { using (var con = ConnectionFactory.CreateConnection()) { if (con.State == System.Data.ConnectionState.Closed) { con.Open(); } string sql = SqlFactory.GetSelectListSql(new t_currencyEntity()); return(con.Query <t_currencyEntity>(sql).ToList()); } }
/// <summary> /// 获取所有货币信息 /// </summary> /// <returns></returns> public static List <yw_wldwEntity> GetWldwListByHddz(yw_hddzEntity model) { using (var con = ConnectionFactory.CreateConnection()) { if (con.State == System.Data.ConnectionState.Closed) { con.Open(); } string sql = SqlFactory.GetSelectListSql(new yw_wldwEntity()); sql += " where yw_khbm in(@khbm,@gwgysbm,@jydwbm,@cyrbm)"; return(con.Query <yw_wldwEntity>(sql, model).ToList()); } }
/// <summary> /// 根据主键和表查询数据 /// </summary> /// <param name="tablename"></param> /// <param name="mainid"></param> /// <param name="parameters"></param> /// <param name="cscs"></param> /// <returns></returns> public List <s_log_errEntity> GetLogerrListByTableName(string tablename, string mainid, string[] parameters, int cscs) { using (var con = ConnectionFactory.CreateConnection()) { if (con.State == System.Data.ConnectionState.Closed) { con.Open(); } string strWhere = " where mainid=@mainid and tablename=@tablename and cscs<@cscs and sfcg=0 "; string sql = SqlFactory.GetSelectListSql(new s_log_errEntity()) + strWhere; string p = null; if (parameters != null) { p = string.Join(",", parameters); } if (!string.IsNullOrEmpty(p)) { strWhere += "and parameters=@parameters"; } return(con.Query <s_log_errEntity>(sql, new { cscs = cscs, mainid = mainid, tablename = tablename, parameters = p }).ToList()); } }