private void Detail() { string id = Request["id"]; CaegoryInfo model = dao.GetModel(int.Parse(id)); string json = Newtonsoft.Json.JsonConvert.SerializeObject(model); Log.WritePage(json); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(CaegoryInfo model) { string sql = "UPDATE [Caegory] SET [CategoryName] = @0,[Categry_describe] = @1 WHERE [ID]=@2"; int rows = DBHelp.ExecuteNonQuery(sql, DBHelp.Databasetype.SQL2005.ToString(), CommandType.Text, model.CategoryName, model.Categry_describe, model.ID); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(CaegoryInfo model) { string sql = "insert into Caegory([CategoryName],[Categry_describe])" + " values (@0,@1) select @@identity"; object obj = DBHelp.ExecuteScalar(sql, DBHelp.Databasetype.SQL2005.ToString(), CommandType.Text, model.CategoryName, model.Categry_describe); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public CaegoryInfo GetModel(int ID) { string sql = "select top 1 * from Caegory where [ID]=@0"; CaegoryInfo model = new CaegoryInfo(); DataSet ds = DBHelp.ExecteDataSet(sql, DBHelp.Databasetype.SQL2005.ToString(), CommandType.Text, ID); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
private void edit() { CaegoryInfo model = new CaegoryInfo(); model.ID = int.Parse(Request.Form["ID"]); model.CategoryName = Request.Form["CategoryName"]; model.Categry_describe = Request.Form["Categry_describe"]; //上传图片处理 //string imgUrl = ImageHelper.UploadImg("fuligoods"); //if (imgUrl != "") model.imgUrl = imgUrl; bool result = dao.Update(model); Log.WritePage(result ? "SUCCESS" : "Error"); }
private void Add() { CaegoryInfo model = new CaegoryInfo(); model.ID = int.Parse(Request.Form["ID"]); model.CategoryName = Request.Form["CategoryName"]; model.Categry_describe = Request.Form["Categry_describe"]; //上传图片处理 //大文本处理 int id = dao.Add(model); Log.WritePage(id > 0 ? "SUCCESS" : "Error"); }
/// <summary> /// 得到一个对象实体 /// </summary> public CaegoryInfo DataRowToModel(DataRow row) { CaegoryInfo model = new CaegoryInfo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["CategoryName"] != null) { model.CategoryName = row["CategoryName"].ToString(); } if (row["Categry_describe"] != null) { model.Categry_describe = row["Categry_describe"].ToString(); } } return(model); }