/// <summary> /// 添加一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(Config model) { int maxID = DbHelperOleDb.GetMaxID("ID", "Config"); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Config("); strSql.Append("ConName,ConValue,ID,ConType)"); strSql.Append(" values ("); strSql.Append("@ConName,@ConValue,@ID,@ConType)"); OleDbParameter[] parameters = { new OleDbParameter("@ConName", OleDbType.VarChar,255), new OleDbParameter("@ConValue", OleDbType.VarChar,255), new OleDbParameter("@ID", OleDbType.Integer,4), new OleDbParameter("@ConType",OleDbType.VarChar,255)}; parameters[0].Value = model.ConName; parameters[1].Value = model.ConValue; parameters[2].Value = maxID; parameters[3].Value = model.ConType; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Config model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Config set "); strSql.Append("ConName=@ConName,"); strSql.Append("ConValue=@ConValue,"); strSql.Append("ConType=@ConType"); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@ConName", OleDbType.VarChar,255), new OleDbParameter("@ConValue", OleDbType.VarChar,255), new OleDbParameter("@ConType",OleDbType.VarChar,255), new OleDbParameter("@ID", OleDbType.Integer,4)}; parameters[0].Value = model.ConName; parameters[1].Value = model.ConValue; parameters[2].Value = model.ConType; parameters[3].Value = model.ID; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
private Config DataRowToModel(DataRow row) { Config model = new Config(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["ConName"] != null) { model.ConName = row["ConName"].ToString(); } if (row["ConValue"] != null) { model.ConValue = row["ConValue"].ToString(); } if (row["ConType"] != null) { model.ConType = row["ConType"].ToString(); } } return model; }
/// <summary> /// 保存配置信息 /// </summary> private void SaveConfig() { List<Config> list = new List<Config>(); Config config; foreach (Control control in this.ControlList) { if (control.Tag != null) { if (control.Tag is Config) { config = control.Tag as Config; } else { config = new Config(); config.ConName = control.Tag.ToString(); config.ConType = control.GetType().Name; } config.ConValue = GetConValue(control); list.Add(config); } } dal.BatchUpdate(list); }