/// <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)); }