|
Server : Microsoft-IIS/10.0 System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586 User : jxgj ( 0) PHP Version : 7.0.33 Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server Directory : D:/tmp_aspnet/root/87401a0c/944f02a0/ |
?#pragma checksum "D:\wwwroot\cnhbclw\wwwroot\App_Code\Email\EmailSQLDAL.cs" "{406ea660-64cf-4c82-b6f0-42d48172a799}" "D24E567F8DA41E75964BBC5A96E795BA"
#line 1 "D:\wwwroot\cnhbclw\wwwroot\App_Code\Email\EmailSQLDAL.cs"
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace nspEmail.Lables
{
/// <summary>
/// EmailSQLDAL 的提要注明
/// </summary>
public class EmailSQLDAL
{
public EmailSQLDAL()
{
//
// TODO: 在此处增长机关函数逻辑
//
}
/// <summary>
/// 挪用查问资讯列表
/// </summary>
/// <param name="strSelect">SQL语句</param>
/// <returns></returns>
public static DataTable GetDataTable(string strSql)
{
return SqlOperate.SqlHelper.ExecuteTable(strSql);
}
/// <summary>
/// 挪用查问资讯列表
/// </summary>
/// <param name="strSelect">查问的内容</param>
/// <param name="strWhere">查问前提</param>
/// <param name="strTableName">查问的表、视图、存储过程</param>
/// <returns></returns>
public static DataTable GetDataTable(string strSelect, string strWhere, string strTableName, string strOrder)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@StrSelect",strSelect),
new SqlParameter("@strWhere",strWhere),
new SqlParameter("@strTableName", strTableName),
new SqlParameter("@strOrder", strOrder)
};
return SqlOperate.SqlHelper.ExecuteTable(CommandType.StoredProcedure, "SP_SelectByWhere", param);
}
}
}
#line default
#line hidden