/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.common_adR DataRowToModel(DataRow row)
{
Model.common_adR model = new Model.common_adR();
if (row != null)
{
if (row["id"] != null) //&& row["id"].ToString() != ""
{
model.id = Convert.ToInt32(row["id"]);
}
if (row["ad_group_id"] != null) //&& row["ad_group_id"].ToString() != ""
{
model.ad_group_id = Convert.ToInt32(row["ad_group_id"]);
}
if (row["ad_group_name"] != null) //&& row["ad_group_name"].ToString() != ""
{
model.ad_group_name = Convert.ToString(row["ad_group_name"]);
}
if (row["ad_type_id"] != null) //&& row["ad_type_id"].ToString() != ""
{
model.ad_type_id = Convert.ToInt32(row["ad_type_id"]);
}
if (row["ad_type_name"] != null) //&& row["ad_type_name"].ToString() != ""
{
model.ad_type_name = Convert.ToString(row["ad_type_name"]);
}
if (row["ad_data_id"] != null) //&& row["ad_data_id"].ToString() != ""
{
model.ad_data_id = Convert.ToInt32(row["ad_data_id"]);
}
if (row["ad_data_title"] != null) //&& row["ad_data_title"].ToString() != ""
{
model.ad_data_title = Convert.ToString(row["ad_data_title"]);
}
if (row["ad_data_subtitle"] != null) //&& row["ad_data_subtitle"].ToString() != ""
{
model.ad_data_subtitle = Convert.ToString(row["ad_data_subtitle"]);
}
if (row["ad_data_img"] != null) //&& row["ad_data_img"].ToString() != ""
{
model.ad_data_img = Convert.ToString(row["ad_data_img"]);
}
if (row["ad_data_url"] != null) //&& row["ad_data_url"].ToString() != ""
{
model.ad_data_url = Convert.ToString(row["ad_data_url"]);
}
if (row["ad_sort_id"] != null) //&& row["ad_sort_id"].ToString() != ""
{
model.ad_sort_id = Convert.ToInt32(row["ad_sort_id"]);
}
if (row["add_time"] != null && row["add_time"].ToString() != "")
{
model.add_time = Convert.ToDateTime(row["add_time"]);
}
return(model);
}
else
{
return(null);
}
}
private void SetRecommend(HttpContext context)
{
int id = RequestHelper.GetFormInt("id");
BLL.common_adR bll = new BLL.common_adR();
Model.common_adR model = bll.GetModel("ad_data_id=" + id + " and ad_group_id=" + (int)EnumCollection.adR_group.精品微课推荐课程);
if (model != null)
{
new BLL.common_adR().Delete(model.id);
}
else
{
model = new Model.common_adR();
model.ad_group_id = (int)EnumCollection.adR_group.精品微课推荐课程;
model.ad_group_name = EnumCollection.adR_group.精品微课推荐课程.ToString();
model.ad_type_id = 0;
model.ad_type_name = "";
model.ad_data_title = "";
model.ad_data_subtitle = "";
model.ad_data_img = "";
model.ad_data_url = "";
model.ad_data_id = id;
model.ad_sort_id = 0;
model.add_time = System.DateTime.Now;
bll.Add(model);
}
context.Response.Write("1");
context.Response.End();
}
/// <summary>
/// 获得Model
/// </summary>
/// <param name="whereStr"></param>
/// <returns></returns>
public Model.common_adR GetModel(string whereStr)
{
DataTable dt = dal.GetList(whereStr).Tables[0];
Model.common_adR model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null;
return(model);
}
/// <summary>
/// 获得Model
/// </summary>
/// <param name="Top">大于0取前几行数据，否则取全部</param>
/// <param name="whereStr">where条件</param>
/// <param name="filedOrder">排序字段Order By + filedOrder (不可为空)</param>
/// <returns></returns>
public Model.common_adR GetModel(int Top, string whereStr, string filedOrder)
{
DataTable dt = dal.GetList(Top, whereStr, filedOrder).Tables[0];
Model.common_adR model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null;
return(model);
}
private bool DoAdd()
{
BLL.common_adR bll = new BLL.common_adR();
Model.common_adR model = new Model.common_adR();
model.ad_group_id = (int)EnumCollection.adR_group.梧桐花轮播图;
model.ad_group_name = Enum.GetName(typeof(EnumCollection.adR_group), model.ad_group_id);
model.ad_type_id = 0;
model.ad_type_name = "";
model.ad_data_id = Convert.ToInt32(this.txtad_data_id.Text);
model.ad_data_title = this.txtad_data_title.Text;
model.ad_data_subtitle = "";
model.ad_data_url = "";
model.ad_data_img = this.txtad_data_img.Text;
model.ad_sort_id = Convert.ToInt32(this.txtad_sort_id.Text);
model.add_time = System.DateTime.Now;
int id = bll.Add(model);
if (id > 0)
{
AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加轮播图信息，主键:" + id); //记录日志
return(true);
}
else
{
return(false);
}
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
ChkAdminLevel("_ybd_common_adR", EnumCollection.ActionEnum.Modify.ToString()); //检查权限
BLL.common_adR bll = new BLL.common_adR();
Model.common_adR model = bll.GetModel(this.id);
model.ad_group_id = Convert.ToInt32(txtad_group_id.Text);
model.ad_group_name = Convert.ToString(txtad_group_name.Text);
model.ad_type_id = Convert.ToInt32(txtad_type_id.Text);
model.ad_type_name = Convert.ToString(txtad_type_name.Text);
model.ad_data_id = Convert.ToInt32(txtad_data_id.Text);
model.ad_data_title = Convert.ToString(txtad_data_title.Text);
model.ad_data_subtitle = Convert.ToString(txtad_data_subtitle.Text);
model.ad_data_img = Convert.ToString(txtad_data_img.Text);
model.ad_data_url = Convert.ToString(txtad_data_url.Text);
model.ad_sort_id = Convert.ToInt32(txtad_sort_id.Text);
model.add_time = Convert.ToDateTime(txtadd_time.Text);
if (bll.Update(model))
{
AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改广告位与数据对应信息，主键:" + id); //记录日志
JscriptMsg("修改广告位与数据对应信息成功！", "Manage.aspx");
}
else
{
JscriptMsg("保存过程中发生错误！", "");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.common_adR model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"UPDATE ybd_common_adR SET
ad_group_id = @ad_group_id
,ad_group_name = @ad_group_name
,ad_type_id = @ad_type_id
,ad_type_name = @ad_type_name
,ad_data_id = @ad_data_id
,ad_data_title = @ad_data_title
,ad_data_subtitle = @ad_data_subtitle
,ad_data_img = @ad_data_img
,ad_data_url = @ad_data_url
,ad_sort_id = @ad_sort_id
,add_time = @add_time
WHERE id = @id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
, new SqlParameter("@ad_group_id", SqlDbType.Int, 4)
, new SqlParameter("@ad_group_name", SqlDbType.NVarChar, 50)
, new SqlParameter("@ad_type_id", SqlDbType.Int, 4)
, new SqlParameter("@ad_type_name", SqlDbType.NVarChar, 50)
, new SqlParameter("@ad_data_id", SqlDbType.Int, 4)
, new SqlParameter("@ad_data_title", SqlDbType.NVarChar, 50)
, new SqlParameter("@ad_data_subtitle", SqlDbType.NVarChar, 500)
, new SqlParameter("@ad_data_img", SqlDbType.NVarChar, 500)
, new SqlParameter("@ad_data_url", SqlDbType.NVarChar, 500)
, new SqlParameter("@ad_sort_id", SqlDbType.Int, 4)
, new SqlParameter("@add_time", SqlDbType.DateTime, 8)
};
parameters[0].Value = model.id;
parameters[1].Value = model.ad_group_id;
parameters[2].Value = model.ad_group_name;
parameters[3].Value = model.ad_type_id;
parameters[4].Value = model.ad_type_name;
parameters[5].Value = model.ad_data_id;
parameters[6].Value = model.ad_data_title;
parameters[7].Value = model.ad_data_subtitle;
parameters[8].Value = model.ad_data_img;
parameters[9].Value = model.ad_data_url;
parameters[10].Value = model.ad_sort_id;
parameters[11].Value = model.add_time;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo(int _id)
{
BLL.common_adR bll = new BLL.common_adR();
Model.common_adR model = bll.GetModel(this.id);
if (model == null)
{
JscriptMsg("信息不存在或已被删除！", "back");
return;
}
this.txtad_data_title.Text = model.ad_data_title;
this.txtad_data_id.Text = model.ad_data_id + "";
this.txtad_data_img.Text = model.ad_data_img;
this.txtad_sort_id.Text = model.ad_sort_id + "";
}
private bool DoEdit(int id)
{
BLL.common_adR bll = new BLL.common_adR();
Model.common_adR model = bll.GetModel(id);
model.ad_data_id = Convert.ToInt32(this.txtad_data_id.Text);
model.ad_data_title = this.txtad_data_title.Text;
model.ad_data_subtitle = "";
model.ad_data_img = this.txtad_data_img.Text;
model.ad_sort_id = Convert.ToInt32(this.txtad_sort_id.Text);
if (bll.Update(model))
{
AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改轮播图信息，主键:" + id); //记录日志
return(true);
}
else
{
return(false);
}
}
private void BindInfo()
{
BLL.common_adR bll = new BLL.common_adR();
Model.common_adR model = bll.GetModel(this.id);
if (model == null)
{
JscriptMsg("信息不存在或已被删除！", "back");
return;
}
txtad_group_id.Text = model.ad_group_id + "";
txtad_group_name.Text = model.ad_group_name + "";
txtad_type_id.Text = model.ad_type_id + "";
txtad_type_name.Text = model.ad_type_name + "";
txtad_data_id.Text = model.ad_data_id + "";
txtad_data_title.Text = model.ad_data_title + "";
txtad_data_subtitle.Text = model.ad_data_subtitle + "";
txtad_data_img.Text = model.ad_data_img + "";
txtad_data_url.Text = model.ad_data_url + "";
txtad_sort_id.Text = model.ad_sort_id + "";
txtadd_time.Text = model.add_time + "";
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
ChkAdminLevel("_ybd_common_adR", EnumCollection.ActionEnum.Add.ToString()); //检查权限
#region
string strError = string.Empty;
if (txtad_group_id.Text.Trim() == "" || txtad_group_id.Text.Trim().Length > 4)
{
strError += "广告分组id为空或超出长度![br]";
}
if (txtad_group_name.Text.Trim() == "" || txtad_group_name.Text.Trim().Length > 50)
{
strError += "广告分组名称为空或超出长度![br]";
}
if (txtad_type_id.Text.Trim() == "" || txtad_type_id.Text.Trim().Length > 4)
{
strError += "广告类型id为空或超出长度![br]";
}
if (txtad_type_name.Text.Trim() == "" || txtad_type_name.Text.Trim().Length > 50)
{
strError += "广告类型name为空或超出长度![br]";
}
if (txtad_data_id.Text.Trim() == "" || txtad_data_id.Text.Trim().Length > 4)
{
strError += "广告数据id为空或超出长度![br]";
}
if (txtad_data_title.Text.Trim() == "" || txtad_data_title.Text.Trim().Length > 50)
{
strError += "广告数据标题为空或超出长度![br]";
}
if (txtad_data_subtitle.Text.Trim() == "" || txtad_data_subtitle.Text.Trim().Length > 500)
{
strError += "广告数据副标题为空或超出长度![br]";
}
if (txtad_data_img.Text.Trim() == "" || txtad_data_img.Text.Trim().Length > 500)
{
strError += "广告数据图片为空或超出长度![br]";
}
if (txtad_data_url.Text.Trim() == "" || txtad_data_url.Text.Trim().Length > 500)
{
strError += "广告位链接为空或超出长度![br]";
}
if (txtad_sort_id.Text.Trim() == "" || txtad_sort_id.Text.Trim().Length > 4)
{
strError += "排序为空或超出长度![br]";
}
if (txtadd_time.Text.Trim() == "" || txtadd_time.Text.Trim().Length > 8)
{
strError += "添加时间为空或超出长度![br]";
}
if (strError != string.Empty)
{
JscriptMsg(strError, "", "Error");
return;
}
#endregion
Model.common_adR model = new Model.common_adR();
BLL.common_adR bll = new BLL.common_adR();
model.ad_group_id = Convert.ToInt32(txtad_group_id.Text);
model.ad_group_name = Convert.ToString(txtad_group_name.Text);
model.ad_type_id = Convert.ToInt32(txtad_type_id.Text);
model.ad_type_name = Convert.ToString(txtad_type_name.Text);
model.ad_data_id = Convert.ToInt32(txtad_data_id.Text);
model.ad_data_title = Convert.ToString(txtad_data_title.Text);
model.ad_data_subtitle = Convert.ToString(txtad_data_subtitle.Text);
model.ad_data_img = Convert.ToString(txtad_data_img.Text);
model.ad_data_url = Convert.ToString(txtad_data_url.Text);
model.ad_sort_id = Convert.ToInt32(txtad_sort_id.Text);
model.add_time = Convert.ToDateTime(txtadd_time.Text);
int id = bll.Add(model);
if (id > 0)
{
AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加广告位与数据对应信息，主键:" + id); //记录日志
JscriptMsg("添加广告位与数据对应信息成功！", "Manage.aspx", "");
}
else
{
JscriptMsg("保存过程中发生错误！", "");
}
}
private void SetGoodsIndex()
{
int id = RequestHelper.GetFormInt("id");
Model.goods_goods goods = new BLL.goods_goods().GetModel(id);
if (goods != null)
{
BLL.common_adR bll = new BLL.common_adR();
if (goods.group_id == (int)EnumCollection.goods_group.教育商城)
{
Model.common_adR model = bll.GetModel("ad_data_id=" + id + " and ad_group_id=" + (int)EnumCollection.adR_group.教育商城推荐商品);
if (model != null)
{
new BLL.common_adR().Delete(model.id);
}
else
{
model = new Model.common_adR();
model.ad_group_id = (int)EnumCollection.adR_group.教育商城推荐商品;
model.ad_group_name = EnumCollection.adR_group.教育商城推荐商品.ToString();
model.ad_type_id = 0;
model.ad_type_name = "";
model.ad_data_title = "";
model.ad_data_subtitle = "";
model.ad_data_img = "";
model.ad_data_url = "";
model.ad_data_id = id;
model.ad_sort_id = 0;
model.add_time = System.DateTime.Now;
bll.Add(model);
}
HttpContext.Current.Response.Write("1");
HttpContext.Current.Response.End();
return;
}
if (goods.group_id == (int)EnumCollection.goods_group.积分专区)
{
Model.common_adR model = bll.GetModel("ad_data_id=" + id + " and ad_group_id=" + (int)EnumCollection.adR_group.积分商城推荐商品);
if (model != null)
{
new BLL.common_adR().Delete(model.id);
}
else
{
model = new Model.common_adR();
model.ad_group_id = (int)EnumCollection.adR_group.积分商城推荐商品;
model.ad_group_name = EnumCollection.adR_group.积分商城推荐商品.ToString();
model.ad_type_id = 0;
model.ad_type_name = "";
model.ad_data_title = "";
model.ad_data_subtitle = "";
model.ad_data_img = "";
model.ad_data_url = "";
model.ad_data_id = id;
model.ad_sort_id = 0;
model.add_time = System.DateTime.Now;
bll.Add(model);
}
HttpContext.Current.Response.Write("1");
HttpContext.Current.Response.End();
return;
}
HttpContext.Current.Response.Write("0");
HttpContext.Current.Response.End();
return;
}
else
{
HttpContext.Current.Response.Write("0");
HttpContext.Current.Response.End();
return;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.common_adR model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.common_adR model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.common_adR model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"Insert Into ybd_common_adR(
ad_group_id
,ad_group_name
,ad_type_id
,ad_type_name
,ad_data_id
,ad_data_title
,ad_data_subtitle
,ad_data_img
,ad_data_url
,ad_sort_id
,add_time
) Values (
@ad_group_id
,@ad_group_name
,@ad_type_id
,@ad_type_name
,@ad_data_id
,@ad_data_title
,@ad_data_subtitle
,@ad_data_img
,@ad_data_url
,@ad_sort_id
,@add_time
);
SELECT @@IDENTITY;");
SqlParameter[] parameters =
{
new SqlParameter("@ad_group_id", SqlDbType.Int, 4)
, new SqlParameter("@ad_group_name", SqlDbType.NVarChar, 50)
, new SqlParameter("@ad_type_id", SqlDbType.Int, 4)
, new SqlParameter("@ad_type_name", SqlDbType.NVarChar, 50)
, new SqlParameter("@ad_data_id", SqlDbType.Int, 4)
, new SqlParameter("@ad_data_title", SqlDbType.NVarChar, 50)
, new SqlParameter("@ad_data_subtitle", SqlDbType.NVarChar, 500)
, new SqlParameter("@ad_data_img", SqlDbType.NVarChar, 500)
, new SqlParameter("@ad_data_url", SqlDbType.NVarChar, 500)
, new SqlParameter("@ad_sort_id", SqlDbType.Int, 4)
, new SqlParameter("@add_time", SqlDbType.DateTime, 8)
};
parameters[0].Value = model.ad_group_id;
parameters[1].Value = model.ad_group_name;
parameters[2].Value = model.ad_type_id;
parameters[3].Value = model.ad_type_name;
parameters[4].Value = model.ad_data_id;
parameters[5].Value = model.ad_data_title;
parameters[6].Value = model.ad_data_subtitle;
parameters[7].Value = model.ad_data_img;
parameters[8].Value = model.ad_data_url;
parameters[9].Value = model.ad_sort_id;
parameters[10].Value = model.add_time;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
