/// <summary>
/// 返回第一行第一列,有参数
/// </summary>
/// <param name="sql"></param>
/// <param name="values"></param>
/// <returns></returns>
public static int GetScalar(string sql, params SqlParameter[] values)
{
try
{
SqlCommand comm = new SqlCommand(sql, ConnectionString);
comm.Parameters.AddRange(values);
return(Convert.ToInt32(comm.ExecuteScalar()));
}
catch (Exception ex)
{
SClient = new Service1();
SClient.CreateFile(ex.Message, DateTime.Now.ToLongDateString());
return(0);
}
finally {
ConnectionString.Close();
}
}
/// <summary>
/// 返回第一行第一列(String类型),无参数
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static string ReturnStringScalar(string sql)
{
try
{
SqlCommand comm = new SqlCommand(sql, ConnectionString);
return(comm.ExecuteScalar().ToString());
}
catch (Exception ex)
{
SClient = new Service1();
SClient.CreateFile(ex.Message, DateTime.Now.ToLongDateString());
return(null);
}
finally {
ConnectionString.Close();
}
}
/// <summary>
/// 返回SqlDataReader,有参数
/// </summary>
/// <param name="sql"></param>
/// <param name="values"></param>
/// <returns></returns>
public static SqlDataReader GetReader(string sql, params SqlParameter[] values)
{
try
{
SqlCommand comm = new SqlCommand(sql, ConnectionString);
comm.Parameters.AddRange(values);
SqlDataReader reader = comm.ExecuteReader();
return(reader);
reader.Close();
}
catch (Exception ex)
{
SClient = new Service1();
SClient.CreateFile(ex.Message, DateTime.Now.ToLongDateString());
return(null);
}
finally {
ConnectionString.Close();
}
}
/// <summary>
/// 返回DataTable,无参数
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static DataTable GetDateSet(string sql)
{
try
{
DataSet Ds = new DataSet();
SqlCommand comm = new SqlCommand(sql, ConnectionString);
SqlDataAdapter Adapter = new SqlDataAdapter(comm);
Adapter.Fill(Ds);
return(Ds.Tables[0]);
}
catch (Exception ex) {
SClient = new Service1();
SClient.CreateFile(ex.Message, DateTime.Now.ToLongDateString());
return(null);
}
finally { ConnectionString.Close(); }
}
/// <summary>
/// 返回结果集分页
/// </summary>
/// <param name="cmdText">SQL语句</param>
/// <param name="start">起始条数(从0开始) start+1 -- start+max</param>
/// <param name="max">分页条数</param>
public static DataTable GetDataTable_Page(string cmdText, int start, int max)
{
//创建一个新的数据适配器
SqlDataAdapter custDA = new SqlDataAdapter();
//创建一个新的 SqlCommand 对象
SqlCommand cmd = new SqlCommand();
cmd.Connection = ConnectionString;
cmd.CommandText = cmdText;
custDA.SelectCommand = cmd;
DataSet ds = new DataSet();
try
{
custDA.Fill(ds, start, max, "data");
}
catch (Exception ex)
{
SClient = new Service1();
SClient.CreateFile(ex.Message, DateTime.Now.ToLongDateString());
return(null);
}
return(ds.Tables["data"]);
}