/// <summary>
/// 增加一条数据
/// </summary>
public void Add(DtCms.Model.Adbanner model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Adbanner(");
strSql.Append("Aid,Title,StartTime,EndTime,AdUrl,LinkUrl,AdRemark,IsLock,AddTime)");
strSql.Append(" values (");
strSql.Append("@Aid,@Title,@StartTime,@EndTime,@AdUrl,@LinkUrl,@AdRemark,@IsLock,@AddTime)");
OleDbParameter[] parameters =
{
new OleDbParameter("@Aid", OleDbType.Integer, 4),
new OleDbParameter("@Title", OleDbType.VarWChar, 100),
new OleDbParameter("@StartTime", OleDbType.Date),
new OleDbParameter("@EndTime", OleDbType.Date),
new OleDbParameter("@AdUrl", OleDbType.VarWChar, 250),
new OleDbParameter("@LinkUrl", OleDbType.VarWChar, 250),
new OleDbParameter("@AdRemark", OleDbType.VarWChar, 0),
new OleDbParameter("@IsLock", OleDbType.Integer, 4),
new OleDbParameter("@AddTime", OleDbType.Date)
};
parameters[0].Value = model.Aid;
parameters[1].Value = model.Title;
parameters[2].Value = model.StartTime;
parameters[3].Value = model.EndTime;
parameters[4].Value = model.AdUrl;
parameters[5].Value = model.LinkUrl;
parameters[6].Value = model.AdRemark;
parameters[7].Value = model.IsLock;
parameters[8].Value = model.AddTime;
DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DtCms.Model.Adbanner GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,Aid,Title,StartTime,EndTime,AdUrl,LinkUrl,AdRemark,SortId,IsLock,AddTime from dt_Adbanner ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
DtCms.Model.Adbanner model = new DtCms.Model.Adbanner();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["Aid"].ToString() != "")
{
model.Aid = int.Parse(ds.Tables[0].Rows[0]["Aid"].ToString());
}
model.Title = ds.Tables[0].Rows[0]["Title"].ToString();
if (ds.Tables[0].Rows[0]["StartTime"].ToString() != "")
{
model.StartTime = DateTime.Parse(ds.Tables[0].Rows[0]["StartTime"].ToString());
}
if (ds.Tables[0].Rows[0]["EndTime"].ToString() != "")
{
model.EndTime = DateTime.Parse(ds.Tables[0].Rows[0]["EndTime"].ToString());
}
model.AdUrl = ds.Tables[0].Rows[0]["AdUrl"].ToString();
model.LinkUrl = ds.Tables[0].Rows[0]["LinkUrl"].ToString();
model.AdRemark = ds.Tables[0].Rows[0]["AdRemark"].ToString();
if (ds.Tables[0].Rows[0]["SortId"].ToString() != "")
{
model.SortId = int.Parse(ds.Tables[0].Rows[0]["SortId"].ToString());
}
if (ds.Tables[0].Rows[0]["IsLock"].ToString() != "")
{
model.IsLock = int.Parse(ds.Tables[0].Rows[0]["IsLock"].ToString());
}
if (ds.Tables[0].Rows[0]["AddTime"].ToString() != "")
{
model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DtCms.Model.Adbanner model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_Adbanner set ");
strSql.Append("Aid=@Aid,");
strSql.Append("Title=@Title,");
strSql.Append("StartTime=@StartTime,");
strSql.Append("EndTime=@EndTime,");
strSql.Append("AdUrl=@AdUrl,");
strSql.Append("LinkUrl=@LinkUrl,");
strSql.Append("AdRemark=@AdRemark,");
strSql.Append("SortId=@SortId,");
strSql.Append("IsLock=@IsLock");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@Aid", SqlDbType.Int, 4),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@AdUrl", SqlDbType.NVarChar, 250),
new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 250),
new SqlParameter("@AdRemark", SqlDbType.NText),
new SqlParameter("@SortId", SqlDbType.Int, 4),
new SqlParameter("@IsLock", SqlDbType.Int, 4)
};
parameters[0].Value = model.id;
parameters[1].Value = model.Aid;
parameters[2].Value = model.Title;
parameters[3].Value = model.StartTime;
parameters[4].Value = model.EndTime;
parameters[5].Value = model.AdUrl;
parameters[6].Value = model.LinkUrl;
parameters[7].Value = model.AdRemark;
parameters[8].Value = model.SortId;
parameters[9].Value = model.IsLock;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DtCms.BLL.Adbanner bll = new DtCms.BLL.Adbanner();
DtCms.Model.Adbanner model = bll.GetModel(this.Id);
model.Title = this.txtTitle.Text.Trim();
model.StartTime = DateTime.Parse(this.txtStartTime.Text.Trim());
model.EndTime = DateTime.Parse(this.txtEndTime.Text.Trim());
model.AdUrl = this.txtImgUrl.Text.Trim();
model.LinkUrl = this.txtLinkUrl.Text.Trim();
model.AdRemark = Utils.ToHtml(this.txtAdRemark.Text);
model.SortId = int.Parse(txtSortId.Text.Trim());
model.IsLock = int.Parse(this.rblIsLock.SelectedValue);
bll.Update(model);
//保存日志
SaveLogs("[首页图片管理]编辑首页图片内容：" + model.Title);
JscriptPrint("首页图片修改成功啦！", "BarList.aspx?Pid=" + model.Aid, "Success");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DtCms.Model.Adbanner model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dt_Adbanner(");
strSql.Append("Aid,Title,StartTime,EndTime,AdUrl,LinkUrl,AdRemark,SortId,IsLock,AddTime)");
strSql.Append(" values (");
strSql.Append("@Aid,@Title,@StartTime,@EndTime,@AdUrl,@LinkUrl,@AdRemark,@SortId,@IsLock,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Aid", SqlDbType.Int, 4),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@AdUrl", SqlDbType.NVarChar, 250),
new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 250),
new SqlParameter("@AdRemark", SqlDbType.NText),
new SqlParameter("@SortId", SqlDbType.Int, 4),
new SqlParameter("@IsLock", SqlDbType.Int, 4),
new SqlParameter("@AddTime", SqlDbType.DateTime)
};
parameters[0].Value = model.Aid;
parameters[1].Value = model.Title;
parameters[2].Value = model.StartTime;
parameters[3].Value = model.EndTime;
parameters[4].Value = model.AdUrl;
parameters[5].Value = model.LinkUrl;
parameters[6].Value = model.AdRemark;
parameters[7].Value = model.SortId;
parameters[8].Value = model.IsLock;
parameters[9].Value = model.AddTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void ShowInfo(int _id)
{
DtCms.BLL.Adbanner bll = new DtCms.BLL.Adbanner();
DtCms.Model.Adbanner model = bll.GetModel(_id);
this.pid = model.Aid;
this.lblAdTitle.Text = model.Aid.ToString();
this.txtTitle.Text = model.Title;
this.txtStartTime.Text = model.StartTime.ToString("yyyy-MM-dd");
this.txtEndTime.Text = model.EndTime.ToString("yyyy-MM-dd");
this.txtImgUrl.Text = model.AdUrl;
this.txtLinkUrl.Text = model.LinkUrl;
this.txtAdRemark.Text = Utils.ToTxt(model.AdRemark);
this.txtSortId.Text = model.SortId.ToString();
this.rblIsLock.SelectedValue = model.IsLock.ToString();
//显示所属首页图片
GetAdType(this.pid);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(DtCms.Model.Adbanner model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Adbanner set ");
strSql.Append("Aid=@Aid,");
strSql.Append("Title=@Title,");
strSql.Append("StartTime=@StartTime,");
strSql.Append("EndTime=@EndTime,");
strSql.Append("AdUrl=@AdUrl,");
strSql.Append("LinkUrl=@LinkUrl,");
strSql.Append("AdRemark=@AdRemark,");
strSql.Append("IsLock=@IsLock,");
strSql.Append("AddTime=@AddTime");
strSql.Append(" where Id=@Id ");
OleDbParameter[] parameters =
{
new OleDbParameter("@Aid", OleDbType.Integer, 4),
new OleDbParameter("@Title", OleDbType.VarWChar, 100),
new OleDbParameter("@StartTime", OleDbType.Date),
new OleDbParameter("@EndTime", OleDbType.Date),
new OleDbParameter("@AdUrl", OleDbType.VarWChar, 250),
new OleDbParameter("@LinkUrl", OleDbType.VarWChar, 250),
new OleDbParameter("@AdRemark", OleDbType.VarWChar, 0),
new OleDbParameter("@IsLock", OleDbType.Integer, 4),
new OleDbParameter("@AddTime", OleDbType.Date),
new OleDbParameter("@Id", OleDbType.Integer, 4)
};
parameters[0].Value = model.Aid;
parameters[1].Value = model.Title;
parameters[2].Value = model.StartTime;
parameters[3].Value = model.EndTime;
parameters[4].Value = model.AdUrl;
parameters[5].Value = model.LinkUrl;
parameters[6].Value = model.AdRemark;
parameters[7].Value = model.IsLock;
parameters[8].Value = model.AddTime;
parameters[9].Value = model.Id;
DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(DtCms.Model.Adbanner model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(DtCms.Model.Adbanner model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DtCms.Model.Adbanner model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DtCms.Model.Adbanner model)
{
return(dal.Add(model));
}
