//修改
protected void btnupdate_Click(object sender, EventArgs e)
{
string id = Request["ID"].ToString();
string name = this.txName.Text; //链接地址
string imagePath = this.Photo.Text;
QPS.NEW.Model.Poster mpt = new QPS.NEW.Model.Poster();
mpt.Id = Convert.ToInt32(id);
mpt.URL = name;
mpt.URL = imagePath;
QPS.NEW.BLL.Poster pt =new QPS.NEW.BLL.Poster ();
//rm.Add(Mro);
if (pt.Update(mpt))
{
Response.Write("<script>alert('修改成功!!');</script>");
}
else
{
Response.Write("<script>alert('修改失败!!');</script>");
}
}
//修改
protected void btnupdate_Click(object sender, EventArgs e)
{
string id = Request["ID"].ToString();
string name = this.txName.Text; //链接地址
string imagePath = this.Photo.Text;
QPS.NEW.Model.Poster mpt = new QPS.NEW.Model.Poster();
mpt.Id = Convert.ToInt32(id);
mpt.URL = name;
mpt.URL = imagePath;
QPS.NEW.BLL.Poster pt = new QPS.NEW.BLL.Poster();
//rm.Add(Mro);
if (pt.Update(mpt))
{
Response.Write("<script>alert('修改成功!!');</script>");
}
else
{
Response.Write("<script>alert('修改失败!!');</script>");
}
}
public bool Update(QPS.NEW.Model.Poster model)
{
bool res = false;
string[] filedName = new string[50];
string[] paramName = new string[50];
SqlParameter[] sqlParams = new SqlParameter[50];
int Count = 0;
if (model.Id == -999)
{
return(false);
}
if (model.Id != -999)
{
filedName[Count] = "ID";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Id);
Count++;
}
if (model.PhotoUrl != null)
{
filedName[Count] = "PhotoUrl";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.PhotoUrl);
Count++;
}
if (model.URL != null)
{
filedName[Count] = "URL";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.URL);
Count++;
}
StringBuilder strSql = new StringBuilder();
strSql.Append("update Poster set ");
for (int i = 1; i < Count; i++) // i begin with 0 !!!
{
strSql.Append(filedName[i]);
strSql.Append("=");
strSql.Append(paramName[i]);
if (i != Count - 1)
{
strSql.Append(",");
}
}
strSql.Append(" where ");
strSql.Append(filedName[0] + "=" + paramName[0]);
int num = Convert.ToInt32(sqlHelper_.ExecuteCommand(
strSql.ToString(),
CommandType.Text,
sqlParams
));
if (num != 1)
{
res = false;
}
else
{
res = true;
}
return(res);
}
