public IActionResult SearchFuncAdd_Submit(M_Search model) { M_Search shMod = new M_Search(); if (Mid > 0) { shMod = shBll.GetSearchById(Mid); } shMod.Name = model.Name; shMod.FlieUrl = model.FlieUrl; shMod.Ico = GetParam("ItemIcon_T"); shMod.Mobile = model.Mobile; shMod.Size = model.Size; shMod.OpenType = model.OpenType; shMod.BKColor = model.BKColor; if (Mid > 0) { shBll.UpdateByID(shMod); } else { shMod.AdminID = adminMod.AdminId; shMod.LinkState = 2; shMod.OrderID = shBll.SelMaxOrder() + 1; shBll.insert(shMod); } string pageUrl = shMod.Type == 1 ? "SearchFunc?EliteLevel=" + shMod.EliteLevel : "SearchFunc"; return(WriteOK("操作成功", pageUrl)); }
public List <M_Search> selectByName(string name) { SqlParameter[] sp = new SqlParameter[] { new SqlParameter("name", "%" + name + "%") }; DataSet ds = SqlHelper.ExecuteDataSet(CommandType.Text, "select * from ZL_Search where name like @name", sp); if (ds != null && ds.Tables.Count > 0) { List <M_Search> search = new List <M_Search>(); foreach (DataRow dr in ds.Tables[0].Rows) { M_Search sea = new M_Search(); sea.Id = DataConverter.CLng(dr["id"]); sea.Name = dr["Name"].ToString(); sea.FlieUrl = dr["fileUrl"].ToString(); sea.Ico = dr["ico"].ToString(); sea.Type = DataConverter.CLng(dr["type"]); sea.State = DataConverter.CLng(dr["state"]); sea.LinkState = DataConverter.CLng(dr["linkState"]); sea.OpenType = DataConverter.CLng(dr["OpenType"]); sea.Time = DataConverter.CDate(dr["time"]); sea.Mobile = Convert.ToInt32(dr["Mobile"]); sea.Size = Convert.ToInt32(dr["Size"]); search.Add(sea); } return(search); } else { return(null); } }
//文件邦定事件 protected void gvCard_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { int id = DataConverter.CLng((e.Row.FindControl("hfId") as HiddenField).Value); e.Row.Attributes.Add("ondblclick", "location.href='AddSearch.aspx?menu=edit&id=" + id + "'"); M_Search sea = b_search.GetSearchById(id); if (sea != null) { Image imgLinkType = e.Row.FindControl("imgLinkType") as Image; Label linkType = e.Row.FindControl("linkType") as Label; Label lblState = e.Row.FindControl("lblState") as Label; switch (sea.Type) { case 0: //站内链接 if (sea.LinkState == 1 && sea.State == 1) //存在该文件并且启用 { lblState.Text = "启用"; } if (sea.LinkState == 2 || sea.State == 2) //不存在该文件 { lblState.Text = "停用"; } linkType.Text = "<i class='fa fa-folder-open' title='站内应用' style='color:#FF7A00;'></i>"; break; case 1: //用户中心 linkType.Text = "<i class='fa fa-list-alt' title='用户中心' style='color:#FF7A00;'></i>"; break; case 2: //站外链接 linkType.Text = "<i class='fa fa-folder-open' title='站内应用' style='color:#FF7A00;'></i>"; break; default: break; } if (sea.State == 2) //文件未启用 { lblState.Text = "停用"; } if (sea.State == 1) //文件启用 { lblState.Text = "启用"; } sea.FlieUrl = sea.FlieUrl.ToLower(); if (sea.FlieUrl.StartsWith("http:") || sea.FlieUrl.StartsWith("https:")) { linkType.Text = "<i class='fa fa-chain' title='站外链接' style='color:#FF7A00;'></i>"; } } } }
protected void EBtnSubmit_Click(object sender, EventArgs e) { b_search = new B_Search(); M_Search search = new M_Search(); search.Name = txtName.Text; //search.Type = DataConverter.CLng(rdoType.SelectedValue); search.FlieUrl = txtFileUrl.Text.Trim(); string pic = ItemIcon_T.Text; if (pic != "") { search.Ico = pic; } search.Mobile = Convert.ToInt32(SupportMobile.SelectedValue); search.Size = Convert.ToInt32(MotroSize.SelectedValue); search.OpenType = DataConverter.CLng(rdoOpenType.SelectedValue); search.AdminID = badmin.GetAdminLogin().AdminId; search.Type = 2; search.UserGroup = ""; if (!string.IsNullOrEmpty(Request.Form["selGroup"])) { search.UserGroup = Request.Form["selGroup"];//用户组权限 } ///search.LinkType =DataConverter.CLng(rdoLinkType.SelectedValue); search.State = 1; search.LinkState = 2; search.EliteLevel = IsEliteLevel.Checked == true ? 1 : 0; if (Mid > 0) { search.Id = Mid; search.OrderID = Convert.ToInt32(txtOrderID.Value); bool res = b_search.UpdateByID(search); if (res) { function.WriteSuccessMsg("修改成功!", "UserFunc.aspx?EliteLevel=2"); } else { function.WriteErrMsg("修改失败!"); } } else { search.OrderID = b_search.SelMaxOrder() + 1; int res = b_search.insert(search); function.WriteSuccessMsg("添加成功!", "UserFunc.aspx?EliteLevel=2"); } }
public IActionResult SearchFuncAdd() { M_Search shMod = new M_Search(); if (Mid > 0) { shMod = shBll.GetSearchById(Mid); } else { shMod.BKColor = colorArr[new Random().Next(colorArr.Length - 1)]; } return(View(shMod)); }
//获取用户组选中状态 public string GetChecked() { string groupid = Eval("GroupID").ToString(); if (Mid > 0) { searchMod = b_search.GetSearchById(Mid); } if (searchMod != null && searchMod.UserGroup.Split(',').Contains(groupid)) { return("checked"); } else { return(""); } }
protected void Page_Load(object sender, EventArgs e) { if (function.isAjax()) { string action = Request.Form["action"]; string result = ""; switch (action) { case "checkname": result = CheckSearchName(); break; default: break; } Response.Write(result); Response.Flush(); Response.End(); return; } if (!IsPostBack) { if (Mid > 0) { searchMod = b_search.GetSearchById(Mid); txtName.Text = searchMod.Name; //rdoType.SelectedValue = search.Type.ToString(); txtFileUrl.Text = searchMod.FlieUrl; Edit_Btn.InnerText = "保存设置"; hideid.Value = ID.ToString(); ItemIcon_T.Text = searchMod.Ico; EditSearchName_Hid.Value = searchMod.Name; rdoOpenType.SelectedValue = searchMod.OpenType.ToString(); SupportMobile.SelectedValue = searchMod.Mobile.ToString(); MotroSize.SelectedValue = searchMod.Size.ToString(); txtOrderID.Value = searchMod.OrderID.ToString(); IsEliteLevel.Checked = searchMod.EliteLevel == 1 ? true : false; function.Script(this, "CheckUserType();"); } DataTable dt = groupBll.Select_All(); selGroup_Rpt.DataSource = dt; selGroup_Rpt.DataBind(); Call.SetBreadCrumb(Master, "<li><a href='" + customPath2 + "I/Main.aspx'>工作台</a></li><li><a href=\"UserFunc.aspx?LinkType=3\">会员导航</a></li><li class='active'>添加会员导航</li>"); } }
protected void Page_Load(object sender, EventArgs e) { if (function.isAjax()) { string action = Request.Form["action"]; string result = ""; switch (action) { case "checkname": result = CheckSearchName(); break; default: break; } Response.Write(result); Response.Flush(); Response.End(); return; } if (!IsPostBack) { if (Mid > 0) { searchMod = b_search.GetSearchById(Mid); txtName.Text = searchMod.Name; //rdoType.SelectedValue = search.Type.ToString(); txtFileUrl.Text = searchMod.FlieUrl; Edit_Btn.InnerText = "保存设置"; EditSearchName_Hid.Value = searchMod.Name; hideid.Value = ID.ToString(); ItemIcon_T.Text = searchMod.Ico; rdoOpenType.SelectedValue = searchMod.OpenType.ToString(); SupportMobile.SelectedValue = searchMod.Mobile.ToString(); MotroSize.SelectedValue = searchMod.Size.ToString(); txtOrderID.Value = searchMod.OrderID.ToString(); } Call.SetBreadCrumb(Master, "<li><a href='" + customPath2 + "I/Main.aspx'>工作台</a></li><li><a href=\"SearchFunc.aspx\">管理导航</a></li><li class=\"active\">管理导航管理</li>"); } }
public int insert(M_Search model) { return(Sql.insertID(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model))); }
public bool UpdateByID(M_Search model) { return(Sql.UpdateByIDs(strTableName, PK, model.Id.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters())); }
public bool GetAdd(M_Search model) { return(insert(model) > 0); }
public int insert(M_Search model) { return(DBCenter.Insert(model)); }
public bool UpdateByID(M_Search model) { return(DBCenter.UpdateByID(model, model.Id)); }
//添加搜索信息 protected void EBtnSubmit_Click(object sender, EventArgs e) { b_search = new B_Search(); M_Search search = new M_Search(); search.Name = txtName.Text; //search.Type = DataConverter.CLng(rdoType.SelectedValue); search.FlieUrl = txtFileUrl.Text.Trim(); string pic = ItemIcon_T.Text; if (pic != "") { search.Ico = pic; } search.Mobile = Convert.ToInt32(SupportMobile.SelectedValue); search.Size = Convert.ToInt32(MotroSize.SelectedValue); search.OpenType = DataConverter.CLng(rdoOpenType.SelectedValue); search.AdminID = badmin.GetAdminLogin().AdminId; Regex regexObj = new Regex(@"\b(?:(?:https?|ftp|file)://|www\.|ftp\.)[-A-Z0-9+&@#/%=~_|$?!:,.]*[A-Z0-9+&@#/%=~_|$]", RegexOptions.IgnoreCase); //try //{ // if (regexObj.IsMatch(txtFileUrl.Text.Trim())) // { // // Successful match// 链接类型:1为站内链接,2为站外链接 // search.LinkType = 2; // } // else // { // // Match attempt failed // search.LinkType = 1; // } //} //catch //{ // search.LinkType = 1; // // Syntax error in the regular expression //} ///search.LinkType =DataConverter.CLng(rdoLinkType.SelectedValue); //if (search.LinkType == 1) //如果为站内链接就判断是否存在文件 //{ // if (File.Exists(txtFileUrl.Text.Trim().Substring(1))) // { // search.Time = File.GetLastWriteTime(txtFileUrl.Text.Trim()); // search.LinkState = 1; // search.State = 1; // } // else // { // search.Time = DateTime.Now; // search.State = 1; // search.LinkState = 2; // } //} //else //{ // search.State = 1; // search.LinkState = 2; // //search.Time = DataConverter.CDate("1755-1-1"); //} search.State = 1; search.LinkState = 2; search.EliteLevel = 0; search.Type = 1; string pageUrl = search.Type == 1 ? "SearchFunc.aspx?EliteLevel=" + search.EliteLevel : "SearchFunc.aspx"; if (Mid > 0) { search.Id = Mid; search.OrderID = Convert.ToInt32(txtOrderID.Value); bool res = b_search.UpdateByID(search); if (res) { function.WriteSuccessMsg("修改成功!", pageUrl); } else { function.WriteErrMsg("修改失败!"); } } else { search.OrderID = b_search.SelMaxOrder() + 1; int res = b_search.insert(search); function.WriteSuccessMsg("添加成功!", pageUrl); } }