public static DataTable getSpecifiedProductConfigInfo(string type) { DataSet ds = null; try { ds = DbOperate.ExecuteDataSet(sqlSelect_SpecifiedConfig, new object[1] { type }); //ds = SQLiteHelper.ExecuteDataSet( // SQLiteHelper.connectString, // sqlSelect_SpecifiedConfig, new object[1] { type }); if (ds != null) { if (ds.Tables.Count > 0) { return(ds.Tables[0]); } } } catch (System.Exception ex) { MessageBox.Show("查询数据库时出现错误:" + ex.Message); } return(null); }
public static bool deleteConfig(string type) { string sql = sqlDelete_deleteConfig; try { //int result = int.Parse(SQLiteHelper.ExecuteNonQuery(SQLiteHelper.connectString, // sql // , new object[1] // { // type // }).ToString()); int result = int.Parse(DbOperate.ExecuteNonQuery( sql , new object[1] { type }).ToString()); if (result > 0) { return(true); } } catch (System.Exception ex) { MessageBox.Show("删除数据时出现错误:" + ex.Message); } return(false); }
public static bool updateConfig(string type, string picName, int width, int height, int minCount, string productName, int red, int green, int blue) { string sql = sqlUpdate_updateConfig; try { //int result = int.Parse(SQLiteHelper.ExecuteNonQuery(SQLiteHelper.connectString, // sql // , new object[9] // { // picName // ,width // ,height // ,minCount // ,productName // ,red // ,green // ,blue // ,type // }).ToString()); int result = int.Parse(DbOperate.ExecuteNonQuery( sql , new object[9] { picName , width , height , minCount , productName , red , green , blue , type }).ToString()); if (result > 0) { return(true); } } catch (System.Exception ex) { MessageBox.Show("更新数据时出现错误:" + ex.Message); } return(false); }