private object ExecuteScalar(string tranType, KingTop.Modules.SelectParams paramsModel)
{
SqlParameter[] prams = new SqlParameter[] {
new SqlParameter("tranType", tranType),
new SqlParameter("I1", paramsModel.I1),
new SqlParameter("I2", paramsModel.I2),
new SqlParameter("S1", paramsModel.S1),
new SqlParameter("S2", paramsModel.S2)
};
return(SQLHelper.ExecuteScalar(SQLHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "proc_K_MemberSel", prams));
}
/// <summary>
/// 根据传入的参数查询K_Member,返回查询结果
/// </summary>
/// <param Name="tranType">操作类型</param>
/// <param Name="paramsModel">条件</param>
/// <returns>返回DataTable</returns>
public DataTable GetList(string tranType, KingTop.Modules.SelectParams paramsModel)
{
SqlParameter[] prams = new SqlParameter[] {
new SqlParameter("tranType", tranType),
new SqlParameter("I1", paramsModel.I1),
new SqlParameter("I2", paramsModel.I2),
new SqlParameter("S1", paramsModel.S1),
new SqlParameter("S2", paramsModel.S2)
};
return(SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "proc_K_MemberSel", prams).Tables[0]);
}
/// <summary>
/// 根据传入的参数查询K_Member,返回查询结果
/// </summary>
/// <param name="tranType">操作类型</param>
/// <param name="paramsModel">条件</param>
/// <returns>返回DataTable</returns>
public DataTable GetList(string tranType, KingTop.Modules.SelectParams paramsModel)
{
return(dal.GetList(tranType, paramsModel));
}
