//
protected void btnupdate_Click(object sender, EventArgs e)
{
string id = Request["ID"].ToString();
string name = this.txtUrl.Text; //链接地址
string imagePath = this.Photo.Text;
QPS.NEW.Model.ad a = new QPS.NEW.Model.ad();
a.Id = Convert.ToInt32(id);
a.AdUrl = name;
a.AdImg = imagePath;
QPS.NEW.BLL.Ad Ba = new QPS.NEW.BLL.Ad();
//rm.Add(Mro);
if (Ba.Update(a))
{
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.txtUrl.Text; //链接地址
string imagePath = this.Photo.Text;
QPS.NEW.Model.ad a = new QPS.NEW.Model.ad();
a.Id = Convert.ToInt32(id);
a.AdUrl = name;
a.AdImg = imagePath;
QPS.NEW.BLL.Ad Ba = new QPS.NEW.BLL.Ad();
//rm.Add(Mro);
if (Ba.Update(a))
{
Response.Write("<script>alert('修改成功!!');</script>");
}
else
{
Response.Write("<script>alert('修改失败!!');</script>");
}
}
public bool Update(QPS.NEW.Model.ad 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.Catid != null)
{
filedName[Count] = "catid";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Catid);
Count++;
}
if (model.AdImg != null)
{
filedName[Count] = "adImg";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.AdImg);
Count++;
}
if (model.AdUrl != null)
{
filedName[Count] = "adUrl";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.AdUrl);
Count++;
}
if (model.AdType != null)
{
filedName[Count] = "adType";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.AdType);
Count++;
}
if (model.AdName != null)
{
filedName[Count] = "adName";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.AdName);
Count++;
}
if (model.AdDate != null)
{
filedName[Count] = "adDate";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.AdDate);
Count++;
}
StringBuilder strSql = new StringBuilder();
strSql.Append("update ad 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);
}