/// <summary> /// 得到一个对象实体 /// </summary> public TopicsCategoryModel GetModel(int TopicsCategoryId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from T_TopicsCategory "); strSql.Append(" where TopicsCategoryId=@TopicsCategoryId "); SqlParameter[] parameters = { new SqlParameter("@TopicsCategoryId", SqlDbType.Int, 4) }; parameters[0].Value = TopicsCategoryId; TopicsCategoryModel model = new TopicsCategoryModel(); DataSet ds = adoHelper.ExecuteSqlDataset(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["TopicsCategoryId"].ToString() != "") { model.TopicsCategoryId = int.Parse(ds.Tables[0].Rows[0]["TopicsCategoryId"].ToString()); } model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); if (ds.Tables[0].Rows[0]["Sort"].ToString() != "") { model.Sort = int.Parse(ds.Tables[0].Rows[0]["Sort"].ToString()); } if (ds.Tables[0].Rows[0]["ParentCategoryId"].ToString() != "") { model.ParentCategoryId = int.Parse(ds.Tables[0].Rows[0]["ParentCategoryId"].ToString()); } if (ds.Tables[0].Rows[0]["AddedUserId"].ToString() != "") { model.AddedUserId = int.Parse(ds.Tables[0].Rows[0]["AddedUserId"].ToString()); } if (ds.Tables[0].Rows[0]["AddedDate"].ToString() != "") { model.AddedDate = DateTime.Parse(ds.Tables[0].Rows[0]["AddedDate"].ToString()); } if (ds.Tables[0].Rows[0]["EndDate"].ToString() != "") { model.EndDate = DateTime.Parse(ds.Tables[0].Rows[0]["EndDate"].ToString()); } if (ds.Tables[0].Rows[0]["TypeId"].ToString() != "") { model.TypeId = int.Parse(ds.Tables[0].Rows[0]["TypeId"].ToString()); } model.ImgURL = ds.Tables[0].Rows[0]["ImgURL"].ToString(); model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TopicsCategoryModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_TopicsCategory("); strSql.Append("Title,Sort,ParentCategoryId,AddedUserId,AddedDate,ImgURL,Remark,TypeId,EndDate)"); strSql.Append(" values ("); strSql.Append("@Title,@Sort,@ParentCategoryId,@AddedUserId,@AddedDate,@ImgURL,@Remark,@TypeId,@EndDate)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Title", SqlDbType.VarChar, 100), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@ParentCategoryId", SqlDbType.Int, 4), new SqlParameter("@AddedUserId", SqlDbType.Int, 4), new SqlParameter("@AddedDate", SqlDbType.DateTime), new SqlParameter("@ImgURL", SqlDbType.VarChar, 200), new SqlParameter("@Remark", SqlDbType.Text), new SqlParameter("@TypeId", SqlDbType.Int, 4), new SqlParameter("@EndDate", SqlDbType.DateTime) }; parameters[0].Value = model.Title; parameters[1].Value = model.Sort; parameters[2].Value = model.ParentCategoryId; parameters[3].Value = model.AddedUserId; parameters[4].Value = model.AddedDate; parameters[5].Value = model.ImgURL; parameters[6].Value = model.Remark; parameters[7].Value = model.TypeId; parameters[8].Value = model.EndDate; object obj = adoHelper.ExecuteSqlScalar(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(TopicsCategoryModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_TopicsCategory set "); strSql.Append("Title=@Title,"); strSql.Append("Sort=@Sort,"); strSql.Append("ParentCategoryId=@ParentCategoryId,"); strSql.Append("AddedUserId=@AddedUserId,"); strSql.Append("AddedDate=@AddedDate,"); strSql.Append("ImgURL=@ImgURL,"); strSql.Append("Remark=@Remark,"); strSql.Append("EndDate=@EndDate"); strSql.Append(" where TopicsCategoryId=@TopicsCategoryId "); SqlParameter[] parameters = { new SqlParameter("@TopicsCategoryId", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.VarChar, 100), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@ParentCategoryId", SqlDbType.Int, 4), new SqlParameter("@AddedUserId", SqlDbType.Int, 4), new SqlParameter("@AddedDate", SqlDbType.DateTime), new SqlParameter("@ImgURL", SqlDbType.VarChar, 200), new SqlParameter("@Remark", SqlDbType.Text), new SqlParameter("@EndDate", SqlDbType.DateTime) }; parameters[0].Value = model.TopicsCategoryId; parameters[1].Value = model.Title; parameters[2].Value = model.Sort; parameters[3].Value = model.ParentCategoryId; parameters[4].Value = model.AddedUserId; parameters[5].Value = model.AddedDate; parameters[6].Value = model.ImgURL; parameters[7].Value = model.Remark; parameters[8].Value = model.EndDate; adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(TopicsCategoryModel model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TopicsCategoryModel model) { return(dal.Add(model)); }