/// <summary>增加一条数据 /// /// </summary> public int Add(Model.Set model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Tb_Set("); strSql.Append("SetKey, SetText, SetValue, State, Remark )"); strSql.Append(" values ("); strSql.Append("@SetKey, @SetText, @SetValue, @State, @Remark )"); SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); h.CreateCommand(strSql.ToString()); if (model.SetKey == null) { h.AddParameter("@SetKey", DBNull.Value); } else { h.AddParameter("@SetKey", model.SetKey); } if (model.SetText == null) { h.AddParameter("@SetText", DBNull.Value); } else { h.AddParameter("@SetText", model.SetText); } if (model.SetValue == null) { h.AddParameter("@SetValue", DBNull.Value); } else { h.AddParameter("@SetValue", model.SetValue); } h.AddParameter("@State", model.State); if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } h.ExecuteNonQuery(); const string strSql2 = "select max(id) from Tb_Set"; h.CreateCommand(strSql2); int result; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out result)) { return(0); } return(result); }
/// <summary>更新一条数据 /// /// </summary> public bool Update(Model.Set model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Tb_Set set "); strSql.Append("SetKey=@SetKey, SetText=@SetText, SetValue=@SetValue, State=@State, Remark=@Remark "); strSql.Append(" where id=@id "); SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); h.CreateCommand(strSql.ToString()); if (model.SetKey == null) { h.AddParameter("@SetKey", DBNull.Value); } else { h.AddParameter("@SetKey", model.SetKey); } if (model.SetText == null) { h.AddParameter("@SetText", DBNull.Value); } else { h.AddParameter("@SetText", model.SetText); } if (model.SetValue == null) { h.AddParameter("@SetValue", DBNull.Value); } else { h.AddParameter("@SetValue", model.SetValue); } h.AddParameter("@State", model.State); if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } h.AddParameter("@id", model.Id); return(h.ExecuteNonQuery()); }
/// <summary>对象实体绑定数据 /// /// </summary> public Model.Set ReaderBind(IDataReader dataReader) { Model.Set model = new Model.Set(); var ojb = dataReader["id"]; if (ojb != null && ojb != DBNull.Value) { model.Id = int.Parse(ojb.ToString()); } model.SetKey = dataReader["SetKey"].ToString(); model.SetText = dataReader["SetText"].ToString(); model.SetValue = dataReader["SetValue"].ToString(); ojb = dataReader["State"]; if (ojb != null && ojb != DBNull.Value) { model.State = int.Parse(ojb.ToString()); } model.Remark = dataReader["Remark"].ToString(); return(model); }
/// <summary>得到一个对象实体 /// /// </summary> public Model.Set GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from Tb_Set "); strSql.Append(" where id=@id "); SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); h.CreateCommand(strSql.ToString()); h.AddParameter("@id", id); Model.Set model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } h.CloseConn(); return(model); }
/// <summary>根据条件得到一个对象实体 /// /// </summary> public Model.Set GetModelByCond(string cond) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from Tb_Set "); if (!string.IsNullOrEmpty(cond)) { strSql.Append(" where " + cond); } strSql.Append(" limit 1"); SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); h.CreateCommand(strSql.ToString()); Model.Set model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }