|
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/c87b3efd/cc6243dc/ |
?#pragma checksum "D:\wwwroot\zgyzd233com\wwwroot\App_Code\Comm.cs" "{406ea660-64cf-4c82-b6f0-42d48172a799}" "E3FCB0E10BA5BE834CDDD1A47136E60C"
#line 1 "D:\wwwroot\zgyzd233com\wwwroot\App_Code\Comm.cs"
using System;
using System.Data;
using System.Data.OleDb;
/// <summary>
///Comm的提要注明
/// </summary>
public static class Comm
{
public static string strdel(string biaoming, string ziduan, string zhi)
{
return "delete from " + biaoming + " where " + ziduan + "=" + zhi;
}
public static string gettopnum(int topnum)
{
return (topnum == 0 ? "top 100 percent" : "top " + topnum.ToString());
}
public static bool returnExecuteSql(string strsql)
{
if (SqlHelper.ExecuteSql(strsql) > 0)
return true;
else
return false;
}
public static bool returnExecuteSql(string strsql, OleDbParameter[] parameters)
{
if (SqlHelper.ExecuteSql(strsql, parameters) > 0)
return true;
else
return false;
}
/// <summary>
/// /////////
/// </summary>
/// <param name="strsql"></param>
/// <returns></returns>
public static Double returndoubletop1row(string strsql)
{
DataTable dt = SqlHelper.Query(strsql).Tables[0];
if (dt.Rows.Count > 0)
{
string num = dt.Rows[0][0].ToString();
if (num != "")
return Convert.ToDouble(dt.Rows[0][0].ToString());
else
return 0;
}
else
return 0;
}
public static int returntop1row(string strsql)
{
DataTable dt = SqlHelper.Query(strsql).Tables[0];
if (dt.Rows.Count > 0)
return Convert.ToInt32(dt.Rows[0][0].ToString());
else
return 0;
}
/// <summary>
/// /////////////////
/// </summary>
/// <param name="strsql"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public static int returntop1row(string strsql, OleDbParameter[] parameters)
{
DataTable dt = SqlHelper.Query(strsql, parameters).Tables[0];
if (dt.Rows.Count > 0)
return Convert.ToInt32(dt.Rows[0][0].ToString());
else
return 0;
}
}
#line default
#line hidden