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