/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(hm.Model.ad model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ad set ");
strSql.Append("apId=@apId,");
strSql.Append("title=@title,");
strSql.Append("url=@url,");
strSql.Append("pic=@pic,");
strSql.Append("remark=@remark,");
strSql.Append("startDate=@startDate,");
strSql.Append("endDate=@endDate,");
strSql.Append("orders=@orders,");
strSql.Append("addTime=@addTime,");
strSql.Append("status=@status");
strSql.Append(" where id=@id");
OleDbParameter[] parameters =
{
new OleDbParameter("@apId", OleDbType.Integer, 4),
new OleDbParameter("@title", OleDbType.VarChar, 255),
new OleDbParameter("@url", OleDbType.VarChar, 255),
new OleDbParameter("@pic", OleDbType.VarChar, 255),
new OleDbParameter("@remark", OleDbType.VarChar, 0),
new OleDbParameter("@startDate", OleDbType.Date),
new OleDbParameter("@endDate", OleDbType.Date),
new OleDbParameter("@orders", OleDbType.Integer, 4),
new OleDbParameter("@addTime", OleDbType.Date),
new OleDbParameter("@status", OleDbType.Integer, 4),
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters[0].Value = model.apId;
parameters[1].Value = model.title;
parameters[2].Value = model.url;
parameters[3].Value = model.pic;
parameters[4].Value = model.remark;
parameters[5].Value = model.startDate;
parameters[6].Value = model.endDate;
parameters[7].Value = model.orders;
parameters[8].Value = model.addTime;
parameters[9].Value = model.status;
parameters[10].Value = model.id;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo(int siId)
{
hm.BLL.ad bll = new hm.BLL.ad();
hm.Model.ad model = bll.GetModel(siId);
lblId.Text = model.id.ToString();
txtTitle.Text = model.title;
ddlAp.SelectedValue = model.apId.Value.ToString();
txtUrl.Text = model.url;
txtStartDate.Text = model.startDate.Value.ToString("yyyy-MM-dd HH:mm:ss");
txtEndDate.Text = model.endDate.Value.ToString("yyyy-MM-dd HH:mm:ss");
if (!string.IsNullOrEmpty(model.pic))
{
imgPic.ImageUrl = model.pic;
}
txtRemark.Text = model.remark;
txtOrders.Text = model.orders.ToString();
bindPos();
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(hm.Model.ad model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ad(");
strSql.Append("apId,title,url,pic,remark,startDate,endDate,orders,addTime,status)");
strSql.Append(" values (");
strSql.Append("@apId,@title,@url,@pic,@remark,@startDate,@endDate,@orders,@addTime,@status)");
OleDbParameter[] parameters =
{
new OleDbParameter("@apId", OleDbType.Integer, 4),
new OleDbParameter("@title", OleDbType.VarChar, 255),
new OleDbParameter("@url", OleDbType.VarChar, 255),
new OleDbParameter("@pic", OleDbType.VarChar, 255),
new OleDbParameter("@remark", OleDbType.VarChar, 0),
new OleDbParameter("@startDate", OleDbType.Date),
new OleDbParameter("@endDate", OleDbType.Date),
new OleDbParameter("@orders", OleDbType.Integer, 4),
new OleDbParameter("@addTime", OleDbType.Date),
new OleDbParameter("@status", OleDbType.Integer, 4)
};
parameters[0].Value = model.apId;
parameters[1].Value = model.title;
parameters[2].Value = model.url;
parameters[3].Value = model.pic;
parameters[4].Value = model.remark;
parameters[5].Value = model.startDate;
parameters[6].Value = model.endDate;
parameters[7].Value = model.orders;
parameters[8].Value = model.addTime;
parameters[9].Value = model.status;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtTitle.Text.Trim().Length == 0)
{
strErr += "广告名称不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtStartDate.Text))
{
strErr += "时间格式不正确！\\n";
}
if (!PageValidate.IsDateTime(txtEndDate.Text))
{
strErr += "时间格式不正确！\\n";
}
if (!PageValidate.IsNumber(txtOrders.Text))
{
strErr += "排序必须为数字！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string title = txtTitle.Text;
string url = txtUrl.Text;
DateTime startDate = DateTime.Parse(txtStartDate.Text);
DateTime endDate = DateTime.Parse(txtEndDate.Text);
int orders = int.Parse(txtOrders.Text);
string pic = "";
string remark = txtRemark.Text;
if (flPic.HasFile)
{
string result = Common.CommonHelper.Imageupload(flPic, "ad");
if (result.IndexOf('|') > 0)
{
pic = result.Split('|')[2];
}
else
{
MessageBox.Show(this, result);
return;
}
}
hm.Model.ad model = new hm.Model.ad();
model.apId = int.Parse(ddlAp.SelectedValue);
model.title = title;
model.url = txtUrl.Text;
model.pic = pic;
model.startDate = startDate;
model.endDate = endDate;
model.remark = remark;
model.orders = orders;
model.addTime = DateTime.Now;
model.status = 1;
hm.BLL.ad bll = new hm.BLL.ad();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public hm.Model.ad GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,apId,title,url,pic,remark,startDate,endDate,orders,addTime,status from ad ");
strSql.Append(" where id=@id");
OleDbParameter[] parameters =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters[0].Value = id;
hm.Model.ad model = new hm.Model.ad();
DataSet ds = DbHelperOleDb.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]["apId"] != null && ds.Tables[0].Rows[0]["apId"].ToString() != "")
{
model.apId = int.Parse(ds.Tables[0].Rows[0]["apId"].ToString());
}
if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "")
{
model.title = ds.Tables[0].Rows[0]["title"].ToString();
}
if (ds.Tables[0].Rows[0]["url"] != null && ds.Tables[0].Rows[0]["url"].ToString() != "")
{
model.url = ds.Tables[0].Rows[0]["url"].ToString();
}
if (ds.Tables[0].Rows[0]["pic"] != null && ds.Tables[0].Rows[0]["pic"].ToString() != "")
{
model.pic = ds.Tables[0].Rows[0]["pic"].ToString();
}
if (ds.Tables[0].Rows[0]["remark"] != null && ds.Tables[0].Rows[0]["remark"].ToString() != "")
{
model.remark = ds.Tables[0].Rows[0]["remark"].ToString();
}
if (ds.Tables[0].Rows[0]["startDate"] != null && ds.Tables[0].Rows[0]["startDate"].ToString() != "")
{
model.startDate = DateTime.Parse(ds.Tables[0].Rows[0]["startDate"].ToString());
}
if (ds.Tables[0].Rows[0]["endDate"] != null && ds.Tables[0].Rows[0]["endDate"].ToString() != "")
{
model.endDate = DateTime.Parse(ds.Tables[0].Rows[0]["endDate"].ToString());
}
if (ds.Tables[0].Rows[0]["orders"] != null && ds.Tables[0].Rows[0]["orders"].ToString() != "")
{
model.orders = int.Parse(ds.Tables[0].Rows[0]["orders"].ToString());
}
if (ds.Tables[0].Rows[0]["addTime"] != null && ds.Tables[0].Rows[0]["addTime"].ToString() != "")
{
model.addTime = DateTime.Parse(ds.Tables[0].Rows[0]["addTime"].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());
}
return(model);
}
else
{
return(null);
}
}
