/// <summary> /// 更新一条数据 /// </summary> public void Update(TFXK.Model.Category model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Category set "); strSql.Append("title=@title,"); strSql.Append("codeNo=@codeNo,"); strSql.Append("parentID=@parentID,"); strSql.Append("description=@description,"); strSql.Append("orderId=@orderId"); strSql.Append(" where id=@id "); OleDbParameter[] parameters = { new OleDbParameter("@title", OleDbType.VarChar, 50), new OleDbParameter("@codeNo", OleDbType.VarChar, 50), new OleDbParameter("@parentID", OleDbType.Integer, 4), new OleDbParameter("@description", OleDbType.VarChar, 0), new OleDbParameter("@orderId", OleDbType.Integer, 4), new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = model.title; parameters[1].Value = model.codeNo; parameters[2].Value = model.parentID; parameters[3].Value = model.description; parameters[4].Value = model.orderId; parameters[5].Value = model.id; DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TFXK.Model.Category model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Category("); strSql.Append("title,codeNo,parentID,description,orderId)"); strSql.Append(" values ("); strSql.Append("@title,@codeNo,@parentID,@description,@orderId)"); OleDbParameter[] parameters = { new OleDbParameter("@title", OleDbType.VarChar, 50), new OleDbParameter("@codeNo", OleDbType.VarChar, 50), new OleDbParameter("@parentID", OleDbType.Integer, 4), new OleDbParameter("@description", OleDbType.VarChar), new OleDbParameter("@orderId", OleDbType.Integer, 4) }; parameters[0].Value = model.title; parameters[1].Value = model.codeNo; parameters[2].Value = model.parentID; parameters[3].Value = model.description; parameters[4].Value = model.orderId; DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); string sql = "select max(id) from [tb_Category]"; try { return(int.Parse(DbHelperOleDb.GetSingle(sql).ToString())); } catch { return(0); } }
/// <summary> /// 更具编号获取父分类的编号 /// </summary> /// <param name="id">编号</param> /// <returns>dataset pid</returns> public DataSet GetParentIdsByID(int id) { Model.Category model = new TFXK.Model.Category(); model.parentID = id; DataTable dt = new DataTable(); dt.Columns.Add("pid"); while (model != null && model.parentID != 0) { model = GetParentID(model.parentID); DataRow dr = dt.NewRow(); dr["pid"] = model.parentID; dt.Rows.Add(dr); } DataSet ds = new DataSet(); ds.Tables.Add(dt); return(ds); }
/// <summary> /// 得到一个对象实体 /// </summary> public TFXK.Model.Category GetModel(string code) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,title,codeNo,parentID,description,orderId from tb_Category "); strSql.Append(" where codeNo=@code "); OleDbParameter[] parameters = { new OleDbParameter("@code", OleDbType.VarChar, 10) }; parameters[0].Value = code; TFXK.Model.Category model = new TFXK.Model.Category(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } model.title = ds.Tables[0].Rows[0]["title"].ToString(); model.codeNo = ds.Tables[0].Rows[0]["codeNo"].ToString(); if (ds.Tables[0].Rows[0]["parentID"].ToString() != "") { model.parentID = int.Parse(ds.Tables[0].Rows[0]["parentID"].ToString()); } model.description = ds.Tables[0].Rows[0]["description"].ToString(); if (ds.Tables[0].Rows[0]["orderId"].ToString() != "") { model.orderId = int.Parse(ds.Tables[0].Rows[0]["orderId"].ToString()); } return(model); } else { return(null); } }