//保存
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
string upload1 = "";
if (ViewState["urlname1"] != null)
{
upload1 = ViewState["urlname1"].ToString();
}
if (upload1 == "")
{
MessageBox.Show(this, "请上传图片");
return;
}
upload1 = upload1.Substring(upload1.LastIndexOf("/") + 1, upload1.Length - upload1.LastIndexOf("/") - 1);
int i = 0;
if (!int.TryParse(txtSort.Text, out i) && int.Parse(txtSort.Text) < 0)
{
strErr += "排序号必需是大于或等于0的整数！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string LinkImage = upload1;
string LinkName = this.txtLinkName.Text;
string LinkUrl = this.txtLinkUrl.Text;
string sort = txtSort.Text.Trim();
lgk.BLL.tb_Link bll = new lgk.BLL.tb_Link();
lgk.Model.tb_Link model = new lgk.Model.tb_Link();
if (id != 0)
{
model = bll.GetModel(id);
}
model.LinkImage = LinkImage; //链接图片
model.LinkName = LinkName; //链接名称
model.LinkUrl = LinkUrl; //链接地址
model.Status = int.Parse(sort); //排序号
model.Link001 = type;
model.Link002 = "";
if (id == 0)
{
bll.Add(model);
}
else
{
bll.Update(model);
}
// MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
MyRedirect(type);
}
//绑定数据
private void ShowInfo(int ID)
{
lgk.BLL.tb_Link bll = new lgk.BLL.tb_Link();
lgk.Model.tb_Link model = bll.GetModel(ID);
this.Image1.ImageUrl = "../../Upload/Banner/" + model.LinkImage;
this.txtLinkName.Text = model.LinkName;
this.txtLinkUrl.Text = model.LinkUrl;
this.txtSort.Text = model.Status.ToString();
ViewState["urlname1"] = model.LinkImage;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_Link GetModel(long ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,LinkImage,LinkName,LinkUrl,Status,Link001,Link002 from tb_Link ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
lgk.Model.tb_Link model = new lgk.Model.tb_Link();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["LinkImage"] != null && ds.Tables[0].Rows[0]["LinkImage"].ToString() != "")
{
model.LinkImage = ds.Tables[0].Rows[0]["LinkImage"].ToString();
}
if (ds.Tables[0].Rows[0]["LinkName"] != null && ds.Tables[0].Rows[0]["LinkName"].ToString() != "")
{
model.LinkName = ds.Tables[0].Rows[0]["LinkName"].ToString();
}
if (ds.Tables[0].Rows[0]["LinkUrl"] != null && ds.Tables[0].Rows[0]["LinkUrl"].ToString() != "")
{
model.LinkUrl = ds.Tables[0].Rows[0]["LinkUrl"].ToString();
}
if (ds.Tables[0].Rows[0]["Status"] != null && ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
if (ds.Tables[0].Rows[0]["Link001"] != null && ds.Tables[0].Rows[0]["Link001"].ToString() != "")
{
model.Link001 = ds.Tables[0].Rows[0]["Link001"].ToString();
}
if (ds.Tables[0].Rows[0]["Link002"] != null && ds.Tables[0].Rows[0]["Link002"].ToString() != "")
{
model.Link002 = ds.Tables[0].Rows[0]["Link002"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_Link model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Link set ");
strSql.Append("LinkImage=@LinkImage,");
strSql.Append("LinkName=@LinkName,");
strSql.Append("LinkUrl=@LinkUrl,");
strSql.Append("Status=@Status,");
strSql.Append("Link001=@Link001,");
strSql.Append("Link002=@Link002");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@LinkImage", SqlDbType.VarChar, 100),
new SqlParameter("@LinkName", SqlDbType.VarChar, 50),
new SqlParameter("@LinkUrl", SqlDbType.VarChar, 100),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@Link001", SqlDbType.VarChar, 50),
new SqlParameter("@Link002", SqlDbType.VarChar, 50),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.LinkImage;
parameters[1].Value = model.LinkName;
parameters[2].Value = model.LinkUrl;
parameters[3].Value = model.Status;
parameters[4].Value = model.Link001;
parameters[5].Value = model.Link002;
parameters[6].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lgk.Model.tb_Link model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_Link(");
strSql.Append("LinkImage,LinkName,LinkUrl,Status,Link001,Link002)");
strSql.Append(" values (");
strSql.Append("@LinkImage,@LinkName,@LinkUrl,@Status,@Link001,@Link002)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@LinkImage", SqlDbType.VarChar, 100),
new SqlParameter("@LinkName", SqlDbType.VarChar, 50),
new SqlParameter("@LinkUrl", SqlDbType.VarChar, 100),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@Link001", SqlDbType.VarChar, 50),
new SqlParameter("@Link002", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.LinkImage;
parameters[1].Value = model.LinkName;
parameters[2].Value = model.LinkUrl;
parameters[3].Value = model.Status;
parameters[4].Value = model.Link001;
parameters[5].Value = model.Link002;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
