/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.SysParamInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SysParamInfo set ");
strSql.Append("ItemName=@ItemName,");
strSql.Append("ItemValue1=@ItemValue1,");
strSql.Append("ItemValue2=@ItemValue2");
strSql.Append(" where RecordID=@RecordID");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ItemName", DbType.String),
new SQLiteParameter("@ItemValue1", DbType.String),
new SQLiteParameter("@ItemValue2", DbType.String),
new SQLiteParameter("@RecordID", DbType.Int32, 8)
};
parameters[0].Value = model.ItemName;
parameters[1].Value = model.ItemValue1;
parameters[2].Value = model.ItemValue2;
parameters[3].Value = model.RecordID;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.SysParamInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SysParamInfo(");
strSql.Append("ItemName,ItemValue1,ItemValue2)");
strSql.Append(" values (");
strSql.Append("@ItemName,@ItemValue1,@ItemValue2)");
strSql.Append(";select LAST_INSERT_ROWID()");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ItemName", DbType.String),
new SQLiteParameter("@ItemValue1", DbType.String),
new SQLiteParameter("@ItemValue2", DbType.String)
};
parameters[0].Value = model.ItemName;
parameters[1].Value = model.ItemValue1;
parameters[2].Value = model.ItemValue2;
object obj = DbHelperSQLite.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 设置选项卡初始化
/// </summary>
private void initPage_Set()
{
foreach (Control c in page_Set.Controls)
{
if (c.GetType() == typeof(ComboBox))
{
if (c.Tag.ToString() == "shift")
{
((ComboBox)c).DataSource = System.Enum.GetNames(typeof(EnumClass.KeyModifiers));
}
else if (c.Tag.ToString() == "main")
{
((ComboBox)c).DataSource = System.Enum.GetNames(typeof(EnumClass.KeyMain));
}
}
}
Model.SysParamInfo model = sysBll.GetModelList(" ItemName='ActivateHotKey'")[0];
cmb_Activate_Shift.SelectedItem = model.ItemValue1;
cmb_Activate_Main.SelectedItem = model.ItemValue2;
model = sysBll.GetModelList(" ItemName='StopHotKey'")[0];
cmb_Stop_Shift.SelectedItem = model.ItemValue1;
cmb_Stop_Main.SelectedItem = model.ItemValue2;
model = sysBll.GetModelList(" ItemName='RecordHotKey'")[0];
cmb_Start_Shift.SelectedItem = model.ItemValue1;
cmb_Start_Main.SelectedItem = model.ItemValue2;
model = sysBll.GetModelList(" ItemName='ShowHideHotKey'")[0];
cmb_Resize_Shift.SelectedItem = model.ItemValue1;
cmb_Resize_Main.SelectedItem = model.ItemValue2;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.SysParamInfo DataRowToModel(DataRow row)
{
Model.SysParamInfo model = new Model.SysParamInfo();
if (row != null)
{
if (row["RecordID"] != null && row["RecordID"].ToString() != "")
{
model.RecordID = int.Parse(row["RecordID"].ToString());
}
if (row["ItemName"] != null)
{
model.ItemName = row["ItemName"].ToString();
}
if (row["ItemValue1"] != null)
{
model.ItemValue1 = row["ItemValue1"].ToString();
}
if (row["ItemValue2"] != null)
{
model.ItemValue2 = row["ItemValue2"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.SysParamInfo GetModel(int RecordID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select RecordID,ItemName,ItemValue1,ItemValue2 from SysParamInfo ");
strSql.Append(" where RecordID=@RecordID");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@RecordID", DbType.Int32, 4)
};
parameters[0].Value = RecordID;
Model.SysParamInfo model = new Model.SysParamInfo();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
