/// <summary> /// 增加一条数据 /// </summary> public bool AddCopy(XHD.Model.ecs_goods_gallery model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into scm_goods_gallery("); strSql.Append("goods_id,img_url,img_desc,thumb_url,img_original,file_ip)"); strSql.Append(" values ("); strSql.Append("@goods_id,@img_url,@img_desc,@thumb_url,@img_original,@file_ip)"); MySqlParameter[] parameters = { new MySqlParameter("@goods_id", MySqlDbType.Int16, 8), new MySqlParameter("@img_url", MySqlDbType.VarChar, 255), new MySqlParameter("@img_desc", MySqlDbType.VarChar, 255), new MySqlParameter("@thumb_url", MySqlDbType.VarChar, 255), new MySqlParameter("@img_original", MySqlDbType.VarChar, 255), new MySqlParameter("@file_ip", MySqlDbType.VarChar, 200) }; parameters[0].Value = model.goods_id; parameters[1].Value = model.img_url; parameters[2].Value = model.img_desc; parameters[3].Value = model.thumb_url; parameters[4].Value = model.img_original; parameters[5].Value = model.file_ip; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XHD.Model.ecs_goods_gallery DataRowToModel(DataRow row) { XHD.Model.ecs_goods_gallery model = new XHD.Model.ecs_goods_gallery(); if (row != null) { //model.img_id=row["img_id"].ToString(); //model.goods_id=row["goods_id"].ToString(); if (row["img_url"] != null) { model.img_url = row["img_url"].ToString(); } if (row["img_desc"] != null) { model.img_desc = row["img_desc"].ToString(); } if (row["thumb_url"] != null) { model.thumb_url = row["thumb_url"].ToString(); } if (row["img_original"] != null) { model.img_original = row["img_original"].ToString(); } if (row["file_ip"] != null) { model.file_ip = row["file_ip"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XHD.Model.ecs_goods_gallery model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ecs_goods_gallery set "); strSql.Append("goods_id=@goods_id,"); strSql.Append("img_url=@img_url,"); strSql.Append("img_desc=@img_desc,"); strSql.Append("thumb_url=@thumb_url,"); strSql.Append("img_original=@img_original,"); strSql.Append("file_ip=@file_ip"); strSql.Append(" where img_id=@img_id"); MySqlParameter[] parameters = { new MySqlParameter("@goods_id", MySqlDbType.Int16, 8), new MySqlParameter("@img_url", MySqlDbType.VarChar, 255), new MySqlParameter("@img_desc", MySqlDbType.VarChar, 255), new MySqlParameter("@thumb_url", MySqlDbType.VarChar, 255), new MySqlParameter("@img_original", MySqlDbType.VarChar, 255), new MySqlParameter("@file_ip", MySqlDbType.VarChar, 200), new MySqlParameter("@img_id", MySqlDbType.Int16, 8) }; parameters[0].Value = model.goods_id; parameters[1].Value = model.img_url; parameters[2].Value = model.img_desc; parameters[3].Value = model.thumb_url; parameters[4].Value = model.img_original; parameters[5].Value = model.file_ip; parameters[6].Value = model.img_id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XHD.Model.ecs_goods_gallery GetModel(int img_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select img_id,goods_id,img_url,img_desc,thumb_url,img_original from ecs_goods_gallery,file_ip "); strSql.Append(" where img_id=@img_id"); MySqlParameter[] parameters = { new MySqlParameter("@img_id", MySqlDbType.Int16) }; parameters[0].Value = img_id; XHD.Model.ecs_goods_gallery model = new XHD.Model.ecs_goods_gallery(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }