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