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);
}
