/// <summary> /// 更新一条数据 /// </summary> public bool Update(ProductImgM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update productImage set "); strSql.Append("productid=@productid,"); strSql.Append("imgName=@imgName,"); strSql.Append("imgexplain=@imgexplain"); strSql.Append(" where Imgid=@Imgid"); SqlParameter[] parameters = { new SqlParameter("@Imgid", SqlDbType.Int, 4), new SqlParameter("@productid", SqlDbType.Int, 4), new SqlParameter("@imgName", SqlDbType.VarChar, 120), new SqlParameter("@imgexplain", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.Imgid; parameters[1].Value = model.productid; parameters[2].Value = model.imgName; parameters[3].Value = model.imgexplain; int rows = DBHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ProductImgM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into productImage("); strSql.Append("productid,imgName,imgexplain)"); strSql.Append(" values ("); strSql.Append("@productid,@imgName,@imgexplain)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@productid", SqlDbType.Int, 4), new SqlParameter("@imgName", SqlDbType.VarChar, 120), new SqlParameter("@imgexplain", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.productid; parameters[1].Value = model.imgName; parameters[2].Value = model.imgexplain; object obj = DBHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ProductImgM GetModel(int Imgid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Imgid,productid,imgName,imgexplain from productImage "); strSql.Append(" where Imgid=@Imgid"); SqlParameter[] parameters = { new SqlParameter("@Imgid", SqlDbType.Int, 4) }; parameters[0].Value = Imgid; ProductImgM model = new ProductImgM(); DataSet ds = DBHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Imgid"].ToString() != "") { model.Imgid = int.Parse(ds.Tables[0].Rows[0]["Imgid"].ToString()); } if (ds.Tables[0].Rows[0]["productid"].ToString() != "") { model.productid = int.Parse(ds.Tables[0].Rows[0]["productid"].ToString()); } model.imgName = ds.Tables[0].Rows[0]["imgName"].ToString(); model.imgexplain = ds.Tables[0].Rows[0]["imgexplain"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 获得数据列表 /// </summary> public List <ProductImgM> DataTableToList(DataTable dt) { List <ProductImgM> modelList = new List <ProductImgM>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { ProductImgM model; for (int n = 0; n < rowsCount; n++) { model = new ProductImgM(); if (dt.Rows[n]["Imgid"].ToString() != "") { model.Imgid = int.Parse(dt.Rows[n]["Imgid"].ToString()); } if (dt.Rows[n]["productid"].ToString() != "") { model.productid = int.Parse(dt.Rows[n]["productid"].ToString()); } model.imgName = dt.Rows[n]["imgName"].ToString(); model.imgexplain = dt.Rows[n]["imgexplain"].ToString(); modelList.Add(model); } } return(modelList); }
private void BindShow(string str) { if (str != "") { List <ProductImgM> list = new List <ProductImgM>(); string[] num = str.Split('%'); for (int i = 0; i < num.Length; i++) { if (num[i].Trim() != "") { ProductImgM imagemodel = new ProductImgM(); imagemodel.imgName = num[i].ToString().Trim();//图片URL list.Add(imagemodel); } } photo.Attributes.Add("style", "display:''"); this.DataList1.DataSource = list; this.DataList1.DataBind(); } else { photo.Attributes.Add("style", "display:none"); this.DataList1.DataSource = null; this.DataList1.DataBind(); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ProductImgM model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ProductImgM model) { return(dal.Add(model)); }
private string content(string id, string loginName) { StringBuilder str = new StringBuilder(); string[] strId = id.Split(','); for (int j = 0; j < strId.Length - 1; j++) { doM = doBll.GetModel(int.Parse(strId[j])); if (doM != null) { str.Append("<div id=\"cy_con_" + strId[j] + "\">"); str.Append("<div class=\"industry-con1\">"); str.Append(doM.Chineseintroduced.ToString() + "</div>"); str.Append("<div class=\"industry-con2\">"); str.Append(doM.Englishintroduction.ToString() + "</div>"); ProductImgBLL imbll = new ProductImgBLL(); ProductImgM imM = new ProductImgM(); if (doM.productid > 0) { DataSet ds = imbll.GetList(" productid=" + doM.productid); if ((ds != null) && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; if (i == 0) { str.Append("<div class=\"industry-img-left\">");//大图width=\"651\" height=\"399\" str.Append("<img src=\"http://dp.topfo.com/img/" + loginName + "/" + dr["imgName"].ToString() + "\" id=\"placeholder" + doM.productid + "\" />"); str.Append("</div>"); } else { str.Append("<div style='display:none;' class=\"industry-img-left\">");//大图width=\"651\" height=\"399\" str.Append("<img src=\"http://dp.topfo.com/img/" + loginName + "/" + dr["imgName"].ToString() + "\" style=\"display:none\" id=\"placeholder" + doM.productid + "\" />"); str.Append("</div>"); } } } if ((ds != null) && ds.Tables[0].Rows.Count > 0) { str.Append("<div class=\"industry-img-right\" id=\"ISL_Cont_1\"> <ul>"); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; str.Append("<li>"); str.Append("<a href=\"http://dp.topfo.com/img/" + loginName + "/" + dr["imgName"].ToString() + "\" onmouseover=\"showPic(this," + doM.productid + ");return false;\" alt='点击查看大图' target=\"_blank\">"); str.Append("<img alt='点击查看大图' src=\"http://dp.topfo.com/img/" + loginName + "/" + dr["imgName"].ToString() + "\" />"); str.Append("</a></li>"); } str.Append("</ul></div>"); } } str.Append("</div>"); } else { str.Append("<div id=\"cy_con_" + strId[j] + "\">"); str.Append("暂无数据"); str.Append("</div>"); } } return(str.ToString()); }