/// <summary>
/// 根据Sql获得单个对象
/// </summary>
/// <param name="sql"></param>
/// <param name="param"></param>
/// <returns></returns>
public static T GetSingleObjectBySql(string sql, params MySqlParameter[] param)
{
DataTable dt = MySqlHelper.ExecuteDataTable(sql, param);
IList <T> ts = ModelConvertHelper <T> .ConvertToModel(dt);
return(ts.Count == 0 ? null : ts[0]);
}
/// <summary>
/// 查询二级域名
/// 编写时间: 2010-10-11 17:10
/// 创建者：Mickey
/// </summary>
/// <param name="guid"></param>
/// <returns></returns>
public bool SelectGuId(string guid)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?SubDomain", guid)
};
return(MySqlHelper.ExecuteDataTable(SQL_SELECTGUID, param).Rows.Count > 0);
}
public DataTable GetModuleRightOperateByCode(string moduleCode)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?Module_code", moduleCode)
};
return(MySqlHelper.ExecuteDataTable(SELECTMRANDOPERATEBYMODULECODE, param));
}
public bool CeliName(string Name, string Language)
{
string mysql = "";
if (Language == "cn")
{
mysql = "name_cn";
}
if (Language == "tw")
{
mysql = "name_tw";
}
if (Language == "en")
{
mysql = "name_en";
}
if (Language == "th")
{
mysql = "name_th";
}
if (Language == "vn")
{
mysql = "name_vn";
}
string SQL_SELECTNAEM = "select " + mysql + " from yafa.rate where " + mysql + "='" + Name + "'";
return(MySqlHelper.ExecuteDataTable(SQL_SELECTNAEM, null).Rows.Count > 0);
}
public DataTable GetSysModuleByPid(string moduleParentCode)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?moduleParentCode", moduleParentCode)
};
return(MySqlHelper.ExecuteDataTable(SELECT_BYPID, param));
}
///<summary>
///获得所有数据，返回DataTable
///生成时间：2011-5-5 21:16:16
///</summary>
public DataTable GetMutilDTBetaccount()
{
return(MySqlHelper.ExecuteDataTable(SQL_SELECTALL, null));
}
public bool CeliName(string Name)
{
string SQL_SELECTNAEM = "select ServerName from servers.server where ServerName='" + Name + "'";
return(MySqlHelper.ExecuteDataTable(SQL_SELECTNAEM, null).Rows.Count > 0);
}
/// <summary>
/// 根据Sql获得某对象的集合
/// </summary>
/// <param name="sql">SQL语句</param>
/// <param name="pas">参数数组</param>
/// <returns>对象集合</returns>
public static IList <T> GetObjectsBySql(string sql, params MySqlParameter[] pas)
{
DataTable dt = MySqlHelper.ExecuteDataTable(sql, pas);
return(ModelConvertHelper <T> .ConvertToModel(dt));
}
///<summary>
///获得所有数据，返回DataTable
///生成时间：2010-8-27 22:00:49
///</summary>
public DataTable GetMutilDTSys_module_right()
{
return(MySqlHelper.ExecuteDataTable(SQL_SELECTALL, null));
}
public bool CeliName(string Name)
{
string SQL_SELECTNAEM = "select Otype from yafa.config where Otype='" + Name + "'";
return(MySqlHelper.ExecuteDataTable(SQL_SELECTNAEM, null).Rows.Count > 0);
}
///<summary>
///获得所有数据，返回DataTable
///生成时间：2010-11-2 10:27:01
///</summary>
public DataTable GetMutilDTRoteds1x2hf1()
{
return(MySqlHelper.ExecuteDataTable(SQL_SELECTALL, null));
}
///<summary>
///获得所有数据，返回DataTable
///生成时间：2010-8-27 22:00:49
///</summary>
public DataTable GetMutilDTSystem_module_operate()
{
return(MySqlHelper.ExecuteDataTable(SQL_SELECTALL, null));
}
///<summary>
///获得所有数据，返回DataTable
///生成时间：2011-1-9 20:45:38
///</summary>
public DataTable GetMutilDTUpdatematches()
{
return(MySqlHelper.ExecuteDataTable(SQL_SELECTALL, null));
}
///<summary>
///获得所有数据，返回DataTable
///生成时间：2011-6-1 14:31:11
///</summary>
public DataTable GetMutilDTMatches_copy()
{
return(MySqlHelper.ExecuteDataTable(SQL_SELECTALL, null));
}
///<summary>
///获得所有数据，返回DataTable
///生成时间：2011-4-14 21:35:13
///</summary>
public DataTable GetMutilDTRefusedList()
{
return(MySqlHelper.ExecuteDataTable(SQL_SELECTALL, null));
}
///<summary>
///获得所有数据，返回DataTable
///生成时间：2010-11-2 10:27:01
///</summary>
public DataTable GetMutilDTRotedshdp1()
{
return MySqlHelper.ExecuteDataTable(SQL_SELECTALL, null);
}
public DataTable GetRootModuleTable()
{
return(MySqlHelper.ExecuteDataTable(SELECT_MODULE_TYPE_ALL, null));
}
///<summary>
///获得所有数据，返回DataTable
///生成时间：2011-4-14 16:28:31
///</summary>
public DataTable GetMutilDTBanklistc()
{
return(MySqlHelper.ExecuteDataTable(SQL_SELECTALL, null));
}
///<summary>
///获得所有数据，返回DataTable
///生成时间：2011-3-19 21:56:52
///</summary>
public DataTable GetMutilDTOrderotherhistory()
{
return(MySqlHelper.ExecuteDataTable(SQL_SELECTALL, null));
}
private DataTable GetDataBySql(string sql, params MySqlParameter[] param)
{
return(MySqlHelper.ExecuteDataTable(sql, param));
}
public DataTable GetModuleRightBySql(string sql, params MySqlParameter[] param)
{
return(MySqlHelper.ExecuteDataTable(sql, param));
}
///<summary>
///获得所有数据，返回DataTable
///生成时间：2011-1-6 20:18:20
///</summary>
public DataTable GetMutilDTNotice()
{
return(MySqlHelper.ExecuteDataTable(SQL_SELECTALL, null));
}
///<summary>
///获得所有数据，返回DataTable
///生成时间：2011-1-21 20:24:03
///</summary>
public DataTable GetMutilDTOrderdetailouhfl()
{
return(MySqlHelper.ExecuteDataTable(SQL_SELECTALL, null));
}
///<summary>
///获得所有数据，返回DataTable
///生成时间：2011-1-23 1:00:24
///</summary>
public DataTable GetMutilDTCasinologinservers()
{
return(MySqlHelper.ExecuteDataTable(SQL_SELECTALL, null));
}
