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