protected void MoveSpecs_Btn_Click(object sender, EventArgs e) { string ids = ""; if (string.IsNullOrEmpty(TagetSpecs_List.SelectedValue)) { function.WriteErrMsg("请选择需要迁移的专题!"); } int targetid = DataConverter.CLng(TagetSpecs_List.SelectedValue); M_Spec targetMod = specBll.SelReturnModel(targetid); foreach (ListItem SpecItem in Specs_List.Items) { if (SpecItem.Selected) { if (targetid > 0 && SpecItem.Value.Equals(targetMod.SpecID.ToString())) { continue; } //判断是否选择了相同级别的专题 if (targetid > 0 && CheckExsitParent(DataConverter.CLng(SpecItem.Value), targetMod.Pid)) //判断是否将父专题迁入其子专题 { continue; //M_Spec parentMod = specBll.SelReturnModel(DataConverter.CLng(SpecItem.Value)); //specBll.UpdatePidByIDS(targetMod.SpecID.ToString(), parentMod.Pid);//将目标专题从其父专题中迁移出来 } ids += SpecItem.Value + ","; } } if (!string.IsNullOrEmpty(ids)) { specBll.UpdatePidByIDS(ids.Trim(','), targetid); } function.WriteSuccessMsg("迁移成功!"); }
/// <summary> /// 获取某专题信息所属专题类别和专题组合成的专题名 /// </summary> /// <param name="SpecialID"></param> /// <returns></returns> public string GetSpecName(int SpecialID) { M_Spec info = this.bll.GetSpec(SpecialID); string SpecCate = this.bcate.GetCate(info.SpecCate).SpecCateName; return(SpecCate + ">>" + info.SpecName); }
void ID_Spec.UpdateSpec(M_Spec Spec) { string strSql = "PR_Spec_AddUpdate"; SqlParameter[] cmdParams = GetParameters(Spec); SqlHelper.ExecuteProc(strSql, cmdParams); }
protected void EBtnSubmit_Click(object sender, EventArgs e) { M_AdminInfo admininfo = badmin.GetAdminLogin(); M_Spec info = new M_Spec(); if (Mid > 0) { info = bll.SelReturnModel(Mid); } info.SpecName = TxtSpecName.Text; info.SpecDir = TxtSpecDir.Text; info.SpecPicUrl = Image_T.Text; info.SpecDesc = TxtSpecDesc.Text; info.OpenNew = DataConverter.CBool(RBLOpenType.SelectedValue); info.ListFileExt = DataConverter.CLng(RBLFileExt.SelectedValue); info.ListFileRule = DataConverter.CLng(RBLListFileRule.SelectedValue); info.ListTemplate = TxtListTemplate_hid.Value; info.SpecKeyword = TxtSpeacKeyword.Text; info.SpecTips = TxtSpeacTips.Text; info.SpecDescriptive = TxtSpeacDescriptive.Text; info.CDate = DataConverter.CDate(CDate_T.Text); info.CUser = CUser_T.Text; info.EditDate = DateTime.Now; if (Mid < 1) { info.Pid = Pid; info.OrderID = bll.GetNextOrderID(info.Pid); bll.insert(info); } else { bll.UpdateByID(info); } function.WriteSuccessMsg("操作成功", "SpecialManage.aspx"); }
public void MoveSpec(int id, bool isup) { string[] SpecValues = Request.Form["SpecIDValue"].Split(','); M_Spec specmod = specBll.SelReturnModel(id); for (int i = 0; i < SpecValues.Length; i++) { if (SpecValues[i].Equals(id.ToString())) { if ((isup && i - 1 < 0) || (!isup && i + 1 >= SpecValues.Length)) { break; } //上移下移判断 int index = isup ? i - 1 : i + 1; M_Spec targetmod = specBll.SelReturnModel(DataConverter.CLng(SpecValues[index])); int nodeorder = DataConverter.CLng(Request.Form["OrderField" + SpecValues[index]]); targetmod.OrderID = specmod.OrderID; specmod.OrderID = nodeorder; specBll.UpdateByID(specmod); specBll.UpdateByID(targetmod); break; } } MyBind(); }
protected void EBtnSubmit_Click(object sender, EventArgs e) { if (this.Page.IsValid) { M_Spec info = new M_Spec(); info.SpecID = DataConverter.CLng(this.HdnSpecID.Value); info.SpecName = this.TxtSpecName.Text; info.SpecDir = this.TxtSpecDir.Text; info.SpecDesc = this.TxtSpecDesc.Text; info.SpecCate = DataConverter.CLng(this.HdnCateID.Value); info.OpenNew = DataConverter.CBool(this.RBLOpenType.SelectedValue); info.ListFileExt = DataConverter.CLng(this.RBLFileExt.SelectedValue); info.ListFileRule = DataConverter.CLng(this.RBLListFileRule.SelectedValue); info.ListTemplate = this.TxtListTemplate.Text; if (info.SpecID > 0) { this.bll.AddSpec(info); } else { this.bll.UpdateSpec(info); } Response.Redirect("SpecList.aspx?CateID=" + this.HdnCateID.Value); } }
public void UpdateSpec(M_Spec model) { if (model.SpecID > 0) { UpdateByID(model); } else { insert(model); } }
protected void Page_Load(object sender, EventArgs e) { if (!this.Page.IsPostBack) { B_Admin badmin = new B_Admin(); badmin.CheckMulitLogin(); if (!badmin.ChkPermissions("SpecManage")) { function.WriteErrMsg("没有权限进行此项操作"); } string act = base.Request.QueryString["Action"]; string id = "0"; if (string.IsNullOrEmpty(act)) { function.WriteErrMsg("缺少编辑模式!"); } else { if (act == "Add") { id = base.Request.QueryString["CateID"]; if (string.IsNullOrEmpty(id)) { function.WriteErrMsg("没有指定专题类别ID!"); } this.HdnCateID.Value = id; this.HdnSpecID.Value = "0"; } if (act == "Modify") { id = base.Request.QueryString["SpecID"]; if (string.IsNullOrEmpty(id)) { function.WriteErrMsg("没有指定要修改的专题ID!"); } M_Spec info = this.bll.GetSpec(DataConverter.CLng(id)); if (!info.IsNull) { this.HdnCateID.Value = info.SpecCate.ToString(); this.HdnSpecID.Value = info.SpecID.ToString(); this.TxtSpecName.Text = info.SpecName; this.TxtSpecDir.Text = info.SpecDir; this.TxtSpecDesc.Text = info.SpecDesc; this.RBLOpenType.SelectedValue = DataConverter.CLng(info.OpenNew).ToString(); this.RBLFileExt.SelectedValue = info.ListFileExt.ToString(); this.RBLListFileRule.SelectedValue = info.ListFileRule.ToString(); this.TxtListTemplate.Text = info.ListTemplate; } } M_SpecCate cate = this.bspeccate.GetCate(DataConverter.CLng(id)); this.lblCate.Text = cate.SpecCateName; } } }
public bool CheckExsitParent(int value, int pid) { if (value == pid) { return(true); } M_Spec parentMod = specBll.SelReturnModel(pid); if (parentMod != null && parentMod.Pid > 0) { return(CheckExsitParent(value, parentMod.Pid)); } return(false); }
/// <summary> /// 从DataReader中读取专题信息 /// </summary> /// <param name="rdr">DataReader</param> /// <returns></returns> private static M_Spec GetInfoFromReader(SqlDataReader rdr) { M_Spec info = new M_Spec(); info.SpecID = DataConverter.CLng(rdr["SpecID"]); info.SpecName = rdr["SpecName"].ToString(); info.SpecDir = rdr["SpecDir"].ToString(); info.SpecDesc = rdr["SpecDesc"].ToString(); info.SpecCate = DataConverter.CLng(rdr["SpecCate"]); info.OpenNew = DataConverter.CBool(rdr["OpenType"].ToString()); info.ListFileExt = DataConverter.CLng(rdr["ListFileExt"]); info.ListFileRule = DataConverter.CLng(rdr["ListFileRule"]); info.ListTemplate = rdr["ListTemplate"].ToString(); return(info); }
protected void Save_Btn_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request.Form["SpecIDValue"])) { string[] SpecValues = Request.Form["SpecIDValue"].Split(','); for (int i = 0; i < SpecValues.Length; i++) { string nodeorder = Request.Form["OrderField" + SpecValues[i]]; M_Spec specmod = specBll.SelReturnModel(DataConverter.CLng(SpecValues[i])); specmod.OrderID = DataConverter.CLng(nodeorder); specBll.UpdateByID(specmod); } } MyBind(); function.Script(this, "parent.window.location=parent.location;"); }
//专题id|名称, private string SetSpecial(string specialid) { string sps = ""; B_Spec Bs = new B_Spec(); if (!string.IsNullOrEmpty(specialid)) { string[] arr = specialid.Split(new char[] { ',' }); for (int i = 0; i < arr.Length; i++) { if (!string.IsNullOrEmpty(arr[i])) { M_Spec dd = Bs.GetSpec(DataConverter.CLng(arr[i])); sps += arr[i] + "|" + dd.SpecName + ","; } } } return(sps); }
protected void EBtnBacthSet_Click(object sender, EventArgs e) { for (int i = 0; i < this.LstSpec.Items.Count; i++) { if (this.LstSpec.Items[i].Selected) { int specid = DataConverter.CLng(this.LstSpec.Items[i].Value); M_Spec info = this.bll.GetSpec(specid); if (this.ChkOpenType.Checked) { info.OpenNew = DataConverter.CBool(this.RBLOpenType.SelectedValue); } if (this.ChkTemp.Checked && (!string.IsNullOrEmpty(this.TxtTemplate.Text.Trim()))) { info.ListTemplate = this.TxtTemplate.Text; } this.bll.UpdateSpec(info); } } function.WriteSuccessMsg("批量设置成功", "../Content/SpecialManage.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (ItemID < 1) { ErrToClient("没有指定专题ID,调用方法:/Special_节点ID/Default.aspx"); } M_Spec info = spBll.GetSpec(ItemID); string TemplateDir = ""; TemplateDir = "/" + info.ListTemplate; if (string.IsNullOrEmpty(TemplateDir)) { ErrToClient("该专题列表页未指定模板"); } TemplateDir = SiteConfig.SiteOption.TemplateDir + TemplateDir; TemplateDir = base.Request.PhysicalApplicationPath + "/" + TemplateDir; TemplateDir = TemplateDir.Replace("/", @"\"); string Templatestr = FileSystemObject.ReadFile(TemplateDir); string ContentHtml = this.bll.CreateHtml(Templatestr, Cpage, ItemID, "2"); Response.Write(ContentHtml); }
protected void Page_Load(object sender, EventArgs e) { string sname = ""; B_Admin badmin = new B_Admin(); if (!B_ARoleAuth.Check(ZLEnum.Auth.content, "ContentSpec")) { function.WriteErrMsg("没有权限进行此项操作"); } if (!this.Page.IsPostBack) { specMod = bspec.SelReturnModel(SpecID); if (specMod != null) { sname = specMod.SpecName; } this.ViewState["SpecID"] = this.SpecID.ToString(); this.ViewState["type"] = 1; RepNodeBind(); } Call.SetBreadCrumb(Master, "<li><a href='" + CustomerPageAction.customPath2 + "I/Main.aspx'>工作台</a></li><li><a href='ContentManage.aspx'>内容管理</a></li><li><a href='SpecialManage.aspx'>专题管理</a></li><li class='active'>" + sname + "</li>" + Call.GetHelp(98)); }
protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(base.Request.QueryString["SpecID"])) { int ItemID = DataConverter.CLng(base.Request.QueryString["SpecID"]); B_Spec bll = new B_Spec(); M_Spec info = bll.GetSpec(ItemID); string TemplateDir = ""; TemplateDir = info.ListTemplate; if (string.IsNullOrEmpty(TemplateDir)) { Response.Write("该专题列表页未指定模板"); } else { TemplateDir = SiteConfig.SiteOption.TemplateDir + TemplateDir; int Cpage = 1; if (string.IsNullOrEmpty(base.Request.QueryString["page"])) { Cpage = 1; } else { Cpage = DataConverter.CLng(base.Request.QueryString["page"]); } TemplateDir = base.Request.PhysicalApplicationPath + TemplateDir; TemplateDir = TemplateDir.Replace("/", @"\"); string ContentHtml = this.bll.CreateHtml(FileSystemObject.ReadFile(TemplateDir), Cpage, ItemID); Response.Write(ContentHtml); } } else { Response.Write("没有指定专题ID"); } }
/// <summary> /// 将专题信息的各属性值传递到参数中 /// </summary> /// <param name="administratorInfo"></param> /// <returns></returns> private static SqlParameter[] GetParameters(M_Spec Spec) { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@SpecID", SqlDbType.Int), new SqlParameter("@SpecName", SqlDbType.NVarChar, 50), new SqlParameter("@SpecDir", SqlDbType.NVarChar, 50), new SqlParameter("@SpecDesc", SqlDbType.NVarChar, 255), new SqlParameter("@OpenType", SqlDbType.Bit, 1), new SqlParameter("@SpecCate", SqlDbType.Int), new SqlParameter("@ListFileExt", SqlDbType.Int, 4), new SqlParameter("@ListFileRule", SqlDbType.Int, 4), new SqlParameter("@ListTemplate", SqlDbType.NVarChar, 255) }; parameter[0].Value = Spec.SpecID; parameter[1].Value = Spec.SpecName; parameter[2].Value = Spec.SpecDir; parameter[3].Value = Spec.SpecDesc; parameter[4].Value = Spec.OpenNew; parameter[5].Value = Spec.SpecCate; parameter[6].Value = Spec.ListFileExt; parameter[7].Value = Spec.ListFileRule; parameter[8].Value = Spec.ListTemplate; return(parameter); }
public bool UpdateByID(M_Spec model) { return(Sql.UpdateByIDs(strTableName, PK, model.SpecID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters())); }
public int insert(M_Spec model) { return(DBCenter.Insert(model)); }
public int insert(M_Spec model) { return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model))); }
protected void Page_Load(object sender, EventArgs e) { if (function.isAjax()) { string action = Request.Form["action"]; string result = ""; switch (action) { case "checkspecname": result = CheckSpecName(); break; case "checkspecdir": result = CheckSpecDir(); break; case "checkall": result = CheckSpecName(); if (result.Equals("{\"status\":\"1\"}")) { result = CheckSpecDir(); } break; default: break; } Response.Write(result); Response.Flush(); Response.End(); return; } if (!IsPostBack) { Call.SetBreadCrumb(Master, "<li><a href='" + CustomerPageAction.customPath2 + "Main.aspx'>工作台</a></li><li><a href='../Config/SiteOption.aspx'>系统设置</a></li><li><a href='SpecialManage.aspx'>专题管理</a></li><li class=\"active\">添加专题</li>"); CDate_T.Text = DateTime.Now.ToString(); CUser_T.Text = badmin.GetAdminLogin().AdminName; if (Mid < 1) { lblCate.Text = Pid > 0 ? bll.GetSpec(Pid).SpecName : "无"; } else //修改 { M_Spec info = bll.GetSpec(Mid); if (info.IsNull) { function.WriteErrMsg("要修改的专题不存在"); } TxtSpecName.Text = info.SpecName; TxtSpecDir.Text = info.SpecDir; Image_T.Text = info.SpecPicUrl; EditSpecName_Hid.Value = info.SpecName; EditSpecDir_Hid.Value = info.SpecDir; TxtSpecDesc.Text = info.SpecDesc; RBLOpenType.SelectedValue = DataConverter.CLng(info.OpenNew).ToString(); RBLFileExt.SelectedValue = info.ListFileExt.ToString(); RBLListFileRule.SelectedValue = info.ListFileRule.ToString(); TxtListTemplate_hid.Value = info.ListTemplate; TxtSpeacKeyword.Text = info.SpecKeyword; TxtSpeacTips.Text = info.SpecTips; TxtSpeacDescriptive.Text = info.SpecDescriptive; CUser_T.Text = info.CUser; CDate_T.Text = info.CDate.ToString(); M_Spec pinfo = bll.GetSpec(DataConverter.CLng(info.Pid)); lblCate.Text = (!pinfo.IsNull) ? pinfo.SpecName : "无"; } } }
public bool UpdateByID(M_Spec model) { return(DBCenter.UpdateByID(model, model.SpecID)); }
public void AddSpec(M_Spec Spec) { dal.AddSpec(Spec); }
public void UpdateSpec(M_Spec Spec) { dal.UpdateSpec(Spec); }