/// <summary> /// 增加一条数据 /// </summary> public int Add(Tunnel.Model.Tunnel_PageMessage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Tunnel_PageMessage("); strSql.Append("pic_AspxName,pic_TitleName,pic_TopicName,pic_TopImgURL,pic_BgColor)"); strSql.Append(" values ("); strSql.Append("@pic_AspxName,@pic_TitleName,@pic_TopicName,@pic_TopImgURL,@pic_BgColor)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@pic_AspxName", SqlDbType.NVarChar, 100), new SqlParameter("@pic_TitleName", SqlDbType.NVarChar, 100), new SqlParameter("@pic_TopicName", SqlDbType.NVarChar, 100), new SqlParameter("@pic_TopImgURL", SqlDbType.NVarChar, 100), new SqlParameter("@pic_BgColor", SqlDbType.NVarChar, 100) }; parameters[0].Value = model.pic_AspxName; parameters[1].Value = model.pic_TitleName; parameters[2].Value = model.pic_TopicName; parameters[3].Value = model.pic_TopImgURL; parameters[4].Value = model.pic_BgColor; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Tunnel.Model.Tunnel_PageMessage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Tunnel_PageMessage set "); strSql.Append("pic_AspxName=@pic_AspxName,"); strSql.Append("pic_TitleName=@pic_TitleName,"); strSql.Append("pic_TopicName=@pic_TopicName,"); strSql.Append("pic_TopImgURL=@pic_TopImgURL,"); strSql.Append("pic_BgColor=@pic_BgColor"); strSql.Append(" where pic_ID=@pic_ID "); SqlParameter[] parameters = { new SqlParameter("@pic_ID", SqlDbType.Int, 4), new SqlParameter("@pic_AspxName", SqlDbType.NVarChar, 100), new SqlParameter("@pic_TitleName", SqlDbType.NVarChar, 100), new SqlParameter("@pic_TopicName", SqlDbType.NVarChar, 100), new SqlParameter("@pic_TopImgURL", SqlDbType.NVarChar, 100), new SqlParameter("@pic_BgColor", SqlDbType.NVarChar, 100) }; parameters[0].Value = model.pic_ID; parameters[1].Value = model.pic_AspxName; parameters[2].Value = model.pic_TitleName; parameters[3].Value = model.pic_TopicName; parameters[4].Value = model.pic_TopImgURL; parameters[5].Value = model.pic_BgColor; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public Tunnel.Model.Tunnel_PageMessage GetModel(int pic_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 pic_ID,pic_AspxName,pic_TitleName,pic_TopicName,pic_TopImgURL,pic_BgColor from Tunnel_PageMessage "); strSql.Append(" where pic_ID=@pic_ID "); SqlParameter[] parameters = { new SqlParameter("@pic_ID", SqlDbType.Int, 4) }; parameters[0].Value = pic_ID; Tunnel.Model.Tunnel_PageMessage model = new Tunnel.Model.Tunnel_PageMessage(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["pic_ID"].ToString() != "") { model.pic_ID = int.Parse(ds.Tables[0].Rows[0]["pic_ID"].ToString()); } model.pic_AspxName = ds.Tables[0].Rows[0]["pic_AspxName"].ToString(); model.pic_TitleName = ds.Tables[0].Rows[0]["pic_TitleName"].ToString(); model.pic_TopicName = ds.Tables[0].Rows[0]["pic_TopicName"].ToString(); model.pic_TopImgURL = ds.Tables[0].Rows[0]["pic_TopImgURL"].ToString(); model.pic_BgColor = ds.Tables[0].Rows[0]["pic_BgColor"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 获得数据列表 /// </summary> public List <Tunnel.Model.Tunnel_PageMessage> DataTableToList(DataTable dt) { List <Tunnel.Model.Tunnel_PageMessage> modelList = new List <Tunnel.Model.Tunnel_PageMessage>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Tunnel.Model.Tunnel_PageMessage model; for (int n = 0; n < rowsCount; n++) { model = new Tunnel.Model.Tunnel_PageMessage(); if (dt.Rows[n]["pic_ID"].ToString() != "") { model.pic_ID = int.Parse(dt.Rows[n]["pic_ID"].ToString()); } model.pic_AspxName = dt.Rows[n]["pic_AspxName"].ToString(); model.pic_TitleName = dt.Rows[n]["pic_TitleName"].ToString(); model.pic_TopicName = dt.Rows[n]["pic_TopicName"].ToString(); model.pic_TopImgURL = dt.Rows[n]["pic_TopImgURL"].ToString(); model.pic_BgColor = dt.Rows[n]["pic_BgColor"].ToString(); modelList.Add(model); } } return(modelList); }
protected void btnok_click(object sender, EventArgs e) { int TitleLength = this.uptitilepic.PostedFile.ContentLength; if (TitleLength != 0) { //获得图片名称. FileInfo fi = new FileInfo(uptitilepic.FileName); if (fi.Extension.Equals(".jpg") || fi.Extension.Equals(".JPG") || fi.Extension.Equals(".jpge") || fi.Extension.Equals(".JPEG") || fi.Extension.Equals(".gif") || fi.Extension.Equals(".GIF") || fi.Extension.Equals(".PNG") || fi.Extension.Equals(".png")) { string type = Path.GetExtension(uptitilepic.FileName); filedName = DateTime.Now.ToFileTime().ToString() + type; string strpath = Server.MapPath("~/N_PicVote/Pic/"); string temp = strpath + filedName; string _temp = strpath + "_" + filedName; this.uptitilepic.SaveAs(temp); } else { Tunnel.Common.Message.Show("只能上传图片类型的文件!"); } } else { filedName = ImgURL; } Tunnel.Model.Tunnel_PageMessage pageMessageModel = new Tunnel.Model.Tunnel_PageMessage(); pageMessageModel.pic_AspxName = "Vote_ShowAllPic.aspx"; pageMessageModel.pic_TitleName = this.txttitle.Text.Trim().ToString(); pageMessageModel.pic_TopicName = this.txttopic.Text.Trim().ToString(); pageMessageModel.pic_TopImgURL = filedName; pageMessageModel.pic_BgColor = this.txtcolor.Text.Trim(); Tunnel.BLL.Tunnel_PageMessage pageMessBLL = new Tunnel.BLL.Tunnel_PageMessage(); pageMessBLL.Add(pageMessageModel); Tunnel.Common.Message.Show("上传成功!"); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Tunnel.Model.Tunnel_PageMessage model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Tunnel.Model.Tunnel_PageMessage model) { return(dal.Add(model)); }