/// <summary>
/// 获取表数据
/// </summary>
/// <param name="SQLType">1-获取表数据,0-获取表结构,</param>
/// <param name="id">主键的值</param>
/// <returns></returns>
public DataTable GetTable(int SQLType, string id)
{
DataTable table = null;
string sql = "";
string where = "";
if (!string.IsNullOrEmpty(id))
{
where = " id=" + id;
}
if (SQLType == 0)
{
where = " 1!=1";
}
sql = SQLGeneration.MySQLGeneration(tablename, where, SQLType);
table = DBHelper.GetTable(sql, DBHelper.connStr);
if (table != null)
{
table.TableName = tablename;
return(table);
}
else
{
return(null);
}
}
/// <summary>
/// 获取表数据
/// </summary>
/// /// <param name="SQLType">1-获取表数据,0-获取表结构,</param>
/// <returns></returns>
public DataTable GetTable(int SQLType)
{
DataTable table;
ow_articletypeControl ow_articletypeControl = new DataBaseControl.ow_articletypeControl();
table = ow_articletypeControl.GetTable(1, " TypeName ='关于我们'");
string sql = "";
if (table != null && table.Rows.Count > 0)
{
sql = SQLGeneration.MySQLGeneration(tablename, " ArticleType=" + table.Rows[0]["ID"].ToString(), SQLType);
}
else
{
return(null);
}
table = DBHelper.GetTable(sql, DBHelper.connStr);
if (table != null)
{
table.TableName = "ow_article";
return(table);
}
else
{
return(null);
}
}
/// <summary>
/// 基本的增删改
/// </summary>
/// <param name="id">主键</param>
/// <param name="table">要更新的表数据</param>
/// <param name="SQLType">0-增加,1-修改,2-删除,</param>
/// <returns></returns>
public int Update(string PrimaryKey, DataTable table, int SQLType)
{
List <MySqlParameter> parameter = new List <MySqlParameter>();
parameter = SQLGeneration.MySQLGetParameter(table, parameter);
string sql = SQLGeneration.MySQLGeneration(table, PrimaryKey, SQLType);
return(DBHelper.Update(sql, DBHelper.connStr, parameter));
}
/// <summary>
/// 登陆
/// </summary>
/// <param name="username"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public bool Login(string username, string pwd)
{
bool tag = false;
DataTable table = null;
string sql = SQLGeneration.MySQLGeneration(tablename, "AccountNumber='" + username + "' and Pwd='" + pwd + "'", 1);
table = DBHelper.GetTable(sql, DBHelper.connStr);
if (table != null && table.Rows.Count > 0)
{
tag = true;
}
else
{
tag = false;
}
return(tag);
}
/// <summary>
/// 获取表数据
/// </summary>
/// /// <param name="SQLType">3-获取表数据,4-获取表结构,</param>
/// <returns></returns>
public DataTable GetTable(DataTable table, int SQLType, List <string> keys)
{
string sql = SQLGeneration.MySQLGeneration(table, "", SQLType, tablename, keys);
return(DBHelper.GetTable(sql, DBHelper.connStr));
}
/// <summary>
/// 基本的增删改
/// </summary>
/// <param name="id">主键</param>
/// <param name="table">要更新的表数据</param>
/// <param name="SQLType">0-增加,1-修改,2-删除,</param>
/// <returns></returns>
public int Update(string PrimaryKey, DataTable table, int SQLType, List <string> keys)
{
string sql = SQLGeneration.MySQLGeneration(table, PrimaryKey, SQLType, tablename, keys);
return(DBHelper.Update(sql, DBHelper.connStr));
}
/// <summary>
/// 获取表数据
/// </summary>
/// /// <param name="SQLType">3-获取表数据,4-获取表结构,</param>
/// <returns></returns>
public DataTable GetTable(int SQLType)
{
string sql = SQLGeneration.MySQLGeneration(null, "", SQLType, tablename, null);
return(DBHelper.GetTable(sql, DBHelper.connStr));
}
/// <summary>
/// 获取表数据
/// </summary>
/// <param name="SQLType">1-获取表数据,0-获取表结构,</param>
/// <returns></returns>
public DataTable GetTable(int SQLType, string where)
{
string sql = SQLGeneration.MySQLGeneration(tablename, where, SQLType);
return(DBHelper.GetTable(sql, DBHelper.connStr));
}
