/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">Links对象</param>
/// <returns>影响行数</returns>
public int Update(ClassLibrary.Model.Links model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("UPDATE {0} SET ", table));
strSql.Append("Title=@Title,");
strSql.Append("Img=@Img,");
strSql.Append("LinkURL=@LinkURL,");
strSql.Append("CreatedTime=@CreatedTime,");
strSql.Append("LinkClass=@LinkClass");
strSql.Append(" WHERE ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@Img", SqlDbType.NVarChar, 60),
new SqlParameter("@LinkURL", SqlDbType.NVarChar, 500),
new SqlParameter("@CreatedTime", SqlDbType.DateTime, 8),
new SqlParameter("@LinkClass", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.Title;
parameters[2].Value = model.Img;
parameters[3].Value = model.LinkURL;
parameters[4].Value = model.CreatedTime;
parameters[5].Value = model.LinkClass;
return(SQLHelper.Execute(strSql.ToString(), parameters));
}
private void EditLink()
{
ClassLibrary.Model.Links linksModel = new ClassLibrary.Model.Links();
linksModel.ID = newsId;
if (string.IsNullOrEmpty(Request.Form["Title"]))
{
Response.Write("<script>alert('请输入标题！');history.back(-1);</script>");
return;
}
else
{
linksModel.Title = Request.Form["Title"];
}
linksModel.LinkURL = Request.Form["LinkURL"];
linksModel.LinkClass = Convert.ToInt32(Request.Form["LinkClass"]);
HttpPostedFile file = Request.Files["Img"];
if (file.ContentLength > 0)
{
string ext = Path.GetExtension(file.FileName);
string fileName = Function.GetRandomTime() + ext;
string fileFullPath = Server.MapPath(SysConfig.UploadFilePathLinksImg);
Function.CreatedDirectory(fileFullPath);
file.SaveAs(fileFullPath + fileName);
linksModel.Img = fileName;
}
else
{
linksModel.Img = Request.Form["Img_Hidden"];
}
if (linksBLL.Update(linksModel) > 0)
{
Function.goMessagePage("修改友情链接", "操作成功", "Links/LinksList.aspx");
}
else
{
Function.goMessagePage("修改友情链接", "操作失败，请稍后再试", "Links/LinksList.aspx");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="ID">主键ID</param>
/// <returns>Links对象</returns>
public ClassLibrary.Model.Links GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT ID,Title,Img,LinkURL,CreatedTime,LinkClass");
strSql.Append(" FROM ");
strSql.Append(table);
strSql.Append(string.Format(" WHERE {0}=@{0}", pk));
SqlParameter[] parameters =
{
new SqlParameter("@" + pk, SqlDbType.Int, 4)
};
parameters[0].Value = ID;
ClassLibrary.Model.Links model = new ClassLibrary.Model.Links();
DataTable dt = SQLHelper.Query(strSql.ToString(), parameters);
model.ID = ID;
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["Title"] != DBNull.Value)
{
model.Title = Convert.ToString(dt.Rows[0]["Title"]);
}
if (dt.Rows[0]["Img"] != DBNull.Value)
{
model.Img = Convert.ToString(dt.Rows[0]["Img"]);
}
if (dt.Rows[0]["LinkURL"] != DBNull.Value)
{
model.LinkURL = Convert.ToString(dt.Rows[0]["LinkURL"]);
}
if (dt.Rows[0]["CreatedTime"] != DBNull.Value)
{
model.CreatedTime = Convert.ToDateTime(dt.Rows[0]["CreatedTime"]);
}
if (dt.Rows[0]["LinkClass"] != DBNull.Value)
{
model.LinkClass = Convert.ToInt32(dt.Rows[0]["LinkClass"]);
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">Links对象</param>
public int Add(ClassLibrary.Model.Links model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("INSERT INTO {0}(", table));
strSql.Append("Title,Img,LinkURL,CreatedTime,LinkClass");
strSql.Append(") VALUES (");
strSql.Append("@Title,@Img,@LinkURL,@CreatedTime,@LinkClass)");
SqlParameter[] parameters =
{
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@Img", SqlDbType.NVarChar, 60),
new SqlParameter("@LinkURL", SqlDbType.NVarChar, 500),
new SqlParameter("@CreatedTime", SqlDbType.DateTime, 8),
new SqlParameter("@LinkClass", SqlDbType.Int, 4)
};
parameters[0].Value = model.Title;
parameters[1].Value = model.Img;
parameters[2].Value = model.LinkURL;
parameters[3].Value = model.CreatedTime;
parameters[4].Value = model.LinkClass;
return(SQLHelper.Execute(strSql.ToString(), parameters));
}
private void AddLinks()
{
if (Request.Files.Count == 0)
{
Response.Write("<script>alert('请选择链接文件...');history.back(-1);</script>");
return;
}
HttpPostedFile file = Request.Files[0];
int fileLen = file.ContentLength;
if (fileLen <= 0)
{
Response.Write("<script>alert('链接文件为空，请重新上传！');history.back(-1);</script>");
return;
}
string ext = Path.GetExtension(file.FileName);
if (ext != ".txt")
{
Response.Write("<script>alert('仅支持txt链接文件，请重新上传！');history.back(-1);</script>");
return;
}
byte[] input = new byte[fileLen];
Stream str = file.InputStream;
str.Read(input, 0, fileLen);
str.Position = 0;
System.IO.StreamReader sr = new System.IO.StreamReader(str, System.Text.Encoding.Default);
string link = sr.ReadLine();
int i = 1;
ClassLibrary.Model.Links model = new ClassLibrary.Model.Links();
ClassLibrary.BLL.Links bll = new ClassLibrary.BLL.Links();
ClassLibrary.BLL.RouteClass rcBll = new ClassLibrary.BLL.RouteClass();
List <ClassLibrary.Model.RouteClass> rcList = rcBll.GetModelList(string.Empty);
while (link != null && link.Trim() != "")
{
string[] lks = link.Split('^');
if (lks.Length != 3)
{
Response.Write("<script>alert('第" + i + "行数据有问题，请检查后重新上传后面部分数据！');history.back(-1);</script>");
return;
}
model.Title = lks[0].Trim();
model.LinkURL = lks[1].Trim();
if (model.LinkURL.IndexOf("http://") != 0)
{
model.LinkURL = "http://" + lks[1];
}
if (Function.IsNumberStr(lks[2]))
{
ClassLibrary.Model.RouteClass rc = rcList.Find(delegate(ClassLibrary.Model.RouteClass trc) { return(trc.ID == Convert.ToInt32(lks[2])); });
if (rc == null)
{
Response.Write("<script>alert('第" + i + "行数据目的地ID无效，请检查后重新上传后面部分数据！');history.back(-1);</script>");
return;
}
model.LinkClass = Convert.ToInt32(lks[2]);
}
else
{
Response.Write("<script>alert('第" + i + "行数据目的地ID出错，请检查后重新上传后面部分数据！');history.back(-1);</script>");
return;
}
if (bll.Add(model) > 0)
{
link = sr.ReadLine();
i++;
}
else
{
Response.Write("<script>alert('第" + i + "行数据添加出错，请检查后重新上传后面部分数据！');history.back(-1);</script>");
return;
}
}
str.Close();
sr.Close();
Function.goMessagePage("批量导入友情链接", "成功导入" + (i - 1) + "个链接", "Links/LinksList.aspx");
}
