private string Delete(HttpContext context)
{
try
{
int Id = 0;
try { Id = int.Parse(context.Request.QueryString["Id"]); }
catch { }
T_Links file = GetById(context);
try
{
string fp = HttpContext.Current.Server.MapPath("~/linkImg/" + file.LinkImgurl);
File.Delete(fp);
}
catch { }
if (dal.Delete(Id))
{
return("删除操作成功！");
}
else
{
return("删除操作失败，错误代码：500 ");
}
}
catch { return("Error 500"); }
}
private T_Links GetModel(HttpContext context)
{
T_Links model = new T_Links();
try { model.Id = int.Parse(context.Request.Form["Id"].ToString()); }
catch { }
model.LinkName = context.Request.Form["LinkName"].ToString();
model.LinkUrl = context.Request.Form["LinkUrl"].ToString();
model.LinkImgurl = new UpLoad().UpLoadFile("~/linkImg/");
model.Editor = admin.AdminLogName;
return(model);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
public bool Create(T_Links model)
{
try
{
object[] obj = { model.LinkName, model.LinkUrl, model.LinkImgurl, model.Editor, model.CreateDate.ToString("yyyy-MM-dd HH:mm:ss") };
string strSql = string.Format(" insert into [T_Links]([LinkName],[LinkUrl],[LinkImgurl],[Editor],[CreateDate])values('{0}','{1}','{2}','{3}','{4}')", obj);
if (DbHelper.Factory().ExecuteNonQuery(strSql) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch { return(false); }
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
public bool Update(T_Links model)
{
try
{
object[] obj = { model.LinkName, model.LinkUrl, model.LinkImgurl, model.Editor, model.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"), model.Id };
string strSql = string.Format(" update [T_Links] set [LinkName] = '{0}',[LinkUrl] = '{1}',[LinkImgurl] = '{2}',[Editor] = '{3}',[CreateDate] = '{4}' where Id ={5} ", obj);
if (DbHelper.Factory().ExecuteNonQuery(strSql) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch { return(false); }
}
//
public T_Links GetById(int id)
{
T_Links model = null;
string strSql = string.Format("select [Id],[LinkName],[LinkUrl],[LinkImgurl],[Editor],[CreateDate] from [T_Links] where Id= {0}", id);
using (dynamic read = DbHelper.Factory().ExecuteReader(strSql))
{
model = new T_Links();
if (read.Read())
{
try { model.Id = int.Parse(read["Id"].ToString()); }
catch { }
model.LinkName = read["LinkName"].ToString();
model.LinkUrl = read["LinkUrl"].ToString();
model.LinkImgurl = read["LinkImgurl"].ToString();
model.Editor = read["Editor"].ToString();
try { model.CreateDate = DateTime.Parse(read["CreateDate"].ToString()); }
catch { }
}
read.Dispose();
}
return(model);
}
