/// <summary> /// 得到一个对象实体 /// </summary> public Blogs.Model.Enumeration DataRowToModel(DataRow row) { Blogs.Model.Enumeration model = new Blogs.Model.Enumeration(); if (row != null) { if (row["e_id"] != null && row["e_id"].ToString() != "") { model.e_id = int.Parse(row["e_id"].ToString()); } if (row["e_ename"] != null) { model.e_ename = row["e_ename"].ToString(); } if (row["e_cname"] != null) { model.e_cname = row["e_cname"].ToString(); } if (row["e_type"] != null) { model.e_type = row["e_type"].ToString(); } if (row["e_remark"] != null) { model.e_remark = row["e_remark"].ToString(); } if (row["e_addtime"] != null && row["e_addtime"].ToString() != "") { model.e_addtime = DateTime.Parse(row["e_addtime"].ToString()); } if (row["e_isdel"] != null && row["e_isdel"].ToString() != "") { if ((row["e_isdel"].ToString() == "1") || (row["e_isdel"].ToString().ToLower() == "true")) { model.e_isdel = true; } else { model.e_isdel = false; } } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Blogs.Model.Enumeration model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Enumeration set "); strSql.Append("e_ename=@e_ename,"); strSql.Append("e_cname=@e_cname,"); strSql.Append("e_type=@e_type,"); strSql.Append("e_remark=@e_remark,"); strSql.Append("e_addtime=@e_addtime,"); strSql.Append("e_isdel=@e_isdel"); strSql.Append(" where e_id=@e_id"); SQLiteParameter[] parameters = { new SQLiteParameter("@e_ename", DbType.String), new SQLiteParameter("@e_cname", DbType.String), new SQLiteParameter("@e_type", DbType.String), new SQLiteParameter("@e_remark", DbType.String), new SQLiteParameter("@e_addtime", DbType.DateTime), new SQLiteParameter("@e_isdel", DbType.bit,1), new SQLiteParameter("@e_id", DbType.Int32, 8) }; parameters[0].Value = model.e_ename; parameters[1].Value = model.e_cname; parameters[2].Value = model.e_type; parameters[3].Value = model.e_remark; parameters[4].Value = model.e_addtime; parameters[5].Value = model.e_isdel; parameters[6].Value = model.e_id; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Blogs.Model.Enumeration model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Enumeration("); strSql.Append("e_ename,e_cname,e_type,e_remark,e_addtime,e_isdel)"); strSql.Append(" values ("); strSql.Append("@e_ename,@e_cname,@e_type,@e_remark,@e_addtime,@e_isdel)"); strSql.Append(";select LAST_INSERT_ROWID()"); SQLiteParameter[] parameters = { new SQLiteParameter("@e_ename", DbType.String), new SQLiteParameter("@e_cname", DbType.String), new SQLiteParameter("@e_type", DbType.String), new SQLiteParameter("@e_remark", DbType.String), new SQLiteParameter("@e_addtime", DbType.DateTime), new SQLiteParameter("@e_isdel", DbType.Boolean, 1) }; parameters[0].Value = model.e_ename; parameters[1].Value = model.e_cname; parameters[2].Value = model.e_type; parameters[3].Value = model.e_remark; parameters[4].Value = model.e_addtime; parameters[5].Value = model.e_isdel; object obj = DbHelperSQLite.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Blogs.Model.Enumeration GetModel(int e_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select e_id,e_ename,e_cname,e_type,e_remark,e_addtime,e_isdel from Enumeration "); strSql.Append(" where e_id=@e_id"); SQLiteParameter[] parameters = { new SQLiteParameter("@e_id", DbType.Int32, 4) }; parameters[0].Value = e_id; Blogs.Model.Enumeration model = new Blogs.Model.Enumeration(); DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }