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