private void ShowInfo(int _id)
{
BLL.article_spec bll = new BLL.article_spec();
Model.article_spec model = bll.GetModel(_id);
txtTitle.Text = model.title;
txtRemark.Text = model.remark;
txtSortId.Text = model.sort_id.ToString();
//绑定规格选项
rptList.DataSource = model.values;
rptList.DataBind();
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
txtKeywords.Text = this.keywords;
BLL.article_spec bll = new BLL.article_spec();
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("spec_list.aspx", "channel_id={0}&keywords={1}&page={2}", this.channel_id.ToString(), this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
//嵌套绑定
protected void rptList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
BLL.article_spec bll = new BLL.article_spec();
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
Repeater rptSpecItem = (Repeater)e.Item.FindControl("rptSpecItem");
//找到关联的数据项
DataRowView drv = (DataRowView)e.Item.DataItem;
//提取父ID
int parentId = Convert.ToInt32(drv["id"]);
//根据父ID查询并绑定
rptSpecItem.DataSource = bll.GetList(0, "parent_id=" + parentId, "sort_id asc,id desc");
rptSpecItem.DataBind();
}
}
//嵌套绑定
protected void rptList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
BLL.article_spec bll = new BLL.article_spec();
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
Repeater rptSpecItem = (Repeater)e.Item.FindControl("rptSpecItem");
//找到关联的数据项
DataRowView drv = (DataRowView)e.Item.DataItem;
//提取父ID
int parentId = Convert.ToInt32(drv["id"]);
//根据父ID查询并绑定
rptSpecItem.DataSource = bll.GetList(0, "parent_id=" + parentId, "sort_id asc,id desc");
rptSpecItem.DataBind();
}
}
//批量删除
protected void btnDelete_Click(object sender, EventArgs e)
{
ChkAdminLevel("sys_goods_spec", DTEnums.ActionEnum.Delete.ToString()); //检查权限
BLL.article_spec bll = new BLL.article_spec();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
bll.Delete(id);
}
}
AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除商品规格"); //记录日志
JscriptMsg("删除规格成功！", Utils.CombUrlTxt("spec_list.aspx", "keywords={0}", this.keywords));
}
//批量删除
protected void btnDelete_Click(object sender, EventArgs e)
{
ChkAdminLevel("sys_goods_spec", DTEnums.ActionEnum.Delete.ToString()); //检查权限
BLL.article_spec bll = new BLL.article_spec();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
bll.Delete(id);
}
}
AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除商品规格"); //记录日志
JscriptMsg("删除规格成功！", Utils.CombUrlTxt("spec_list.aspx", "keywords={0}", this.keywords));
}
//保存排序
protected void btnSave_Click(object sender, EventArgs e)
{
ChkAdminLevel("sys_goods_spec", DTEnums.ActionEnum.Edit.ToString()); //检查权限
BLL.article_spec bll = new BLL.article_spec();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
int sortId;
if (!int.TryParse(((TextBox)rptList.Items[i].FindControl("txtSortId")).Text.Trim(), out sortId))
{
sortId = 99;
}
bll.UpdateField(id, "sort_id=" + sortId.ToString());
}
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "保存商品规格排序"); //记录日志
JscriptMsg("保存排序成功！", Utils.CombUrlTxt("spec_list.aspx", "keywords={0}", this.keywords));
}
//保存排序
protected void btnSave_Click(object sender, EventArgs e)
{
ChkAdminLevel("sys_goods_spec", DTEnums.ActionEnum.Edit.ToString()); //检查权限
BLL.article_spec bll = new BLL.article_spec();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
int sortId;
if (!int.TryParse(((TextBox)rptList.Items[i].FindControl("txtSortId")).Text.Trim(), out sortId))
{
sortId = 99;
}
bll.UpdateField(id, "sort_id=" + sortId.ToString());
}
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "保存商品规格排序"); //记录日志
JscriptMsg("保存排序成功！", Utils.CombUrlTxt("spec_list.aspx", "keywords={0}", this.keywords));
}
private bool DoEdit(int _id)
{
bool result = false;
BLL.article_spec bll = new BLL.article_spec();
Model.article_spec model = bll.GetModel(_id);
model.channel_id = this.channel_id;
model.title = txtTitle.Text.Trim();
model.remark = txtRemark.Text.Trim();
model.sort_id = Utils.StrToInt(txtSortId.Text.Trim(), 99);
#region 保存规格选项
string[] itemIdArr = Request.Form.GetValues("item_id");
string[] itemTitleArr = Request.Form.GetValues("item_title");
string[] itemImgUrlArr = Request.Form.GetValues("item_imgurl");
string[] itemSortIdArr = Request.Form.GetValues("item_sortid");
if (itemIdArr != null && itemTitleArr != null && itemImgUrlArr != null && itemSortIdArr != null)
{
if ((itemIdArr.Length == itemTitleArr.Length) && (itemTitleArr.Length == itemImgUrlArr.Length) && (itemImgUrlArr.Length == itemSortIdArr.Length))
{
List <Model.article_spec_value> ls = new List <Model.article_spec_value>();
for (int i = 0; i < itemIdArr.Length; i++)
{
Model.article_spec_value modelt = new Model.article_spec_value();
modelt.id = Utils.StrToInt(itemIdArr[i].Trim(), 0);
modelt.parent_id = model.id;
modelt.title = itemTitleArr[i].Trim();
modelt.img_url = itemImgUrlArr[i].Trim();
modelt.sort_id = Utils.StrToInt(itemSortIdArr[i].Trim(), 99);
ls.Add(modelt);
}
model.values = ls;
}
}
#endregion
if (bll.Update(model))
{
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改商品规格:" + model.title); //记录日志
result = true;
}
return(result);
}
private bool DoAdd()
{
bool result = false;
Model.article_spec model = new Model.article_spec();
BLL.article_spec bll = new BLL.article_spec();
model.title = txtTitle.Text.Trim();
model.remark = txtRemark.Text.Trim();
model.sort_id = Utils.StrToInt(txtSortId.Text.Trim(), 99);
#region 保存规格选项
string[] itemIdArr = Request.Form.GetValues("item_id");
string[] itemTitleArr = Request.Form.GetValues("item_title");
string[] itemImgUrlArr = Request.Form.GetValues("item_imgurl");
string[] itemSortIdArr = Request.Form.GetValues("item_sortid");
if (itemIdArr != null && itemTitleArr != null && itemImgUrlArr != null && itemSortIdArr != null)
{
if ((itemIdArr.Length == itemTitleArr.Length) && (itemTitleArr.Length == itemImgUrlArr.Length) && (itemImgUrlArr.Length == itemSortIdArr.Length))
{
List<Model.article_spec_value> ls = new List<Model.article_spec_value>();
for (int i = 0; i < itemIdArr.Length; i++)
{
Model.article_spec_value modelt = new Model.article_spec_value();
modelt.id = Utils.StrToInt(itemIdArr[i].Trim(), 0);
modelt.title = itemTitleArr[i].Trim();
modelt.img_url = itemImgUrlArr[i].Trim();
modelt.sort_id = Utils.StrToInt(itemSortIdArr[i].Trim(), 99);
ls.Add(modelt);
}
model.values = ls;
}
}
#endregion
if (bll.Add(model) > 0)
{
AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加商品规格:" + model.title); //记录日志
result = true;
}
return result;
}
private void RptBind(string _strWhere, string _orderby)
{
BLL.article_spec bll = new BLL.article_spec();
this.rptList.DataSource = bll.GetList(0, _strWhere, _orderby);
this.rptList.DataBind();
}
private void RptBind(string _strWhere, string _orderby)
{
BLL.article_spec bll = new BLL.article_spec();
this.rptList.DataSource = bll.GetList(0, _strWhere, _orderby);
this.rptList.DataBind();
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
txtKeywords.Text = this.keywords;
BLL.article_spec bll = new BLL.article_spec();
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("spec_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
