//删除功能页按钮点击事件 protected void btnDel_Click(object sender, EventArgs e) { FineUI.CheckBoxField chkFild = (FineUI.CheckBoxField)GridFunctionPages.FindColumn("CheckBoxField1"); SeatManage.ClassModel.SysFuncDicInfo modelSysFuncDicInfo = new SeatManage.ClassModel.SysFuncDicInfo(); SeatManage.Bll.SysFuncDic bllSysFuncDic = new SeatManage.Bll.SysFuncDic(); int selectCount = GridFunctionPages.SelectedRowIndexArray.Length; if (selectCount > 0) { for (int i = 0; i < selectCount; i++) { int rowIndex = GridFunctionPages.SelectedRowIndexArray[i]; FineUI.GridRow row = GridFunctionPages.Rows[rowIndex] as FineUI.GridRow; modelSysFuncDicInfo.No = row.DataKeys[0].ToString(); if (bllSysFuncDic.DeleteFuncPage(modelSysFuncDicInfo)) { FineUI.Alert.ShowInTop("删除成功!"); } else { FineUI.Alert.ShowInTop("删除失败!"); } } BindFunctionPagesGrid(); } }
/// <summary> /// 添加功能页面 /// </summary> /// <param name="model">添加的实体类</param> /// <returns>返回空值,说明成功,其他返回错误信息</returns> public string AddNewFuncPage(SeatManage.ClassModel.SysFuncDicInfo model) { IWCFService.ISeatManageService seatService = SeatManage.WcfAccessProxy.ServiceProxy.CreateChannelSeatManageService(); bool error = false; try { return(seatService.AddNewFuncPage(model)); } catch (Exception ex) { error = true; WriteLog.Write("添加功能页面失败:" + ex.Message); return(ex.Message); } finally { ICommunicationObject ICommObjectService = seatService as ICommunicationObject; try { if (ICommObjectService.State == CommunicationState.Faulted) { ICommObjectService.Abort(); } else { ICommObjectService.Close(); } } catch { ICommObjectService.Abort(); } } }
/// <summary> /// 更新数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(SeatManage.ClassModel.SysFuncDicInfo model) { StringBuilder sqlstr = new StringBuilder(); sqlstr.Append("update SysFuncDic set MCaption=@MCaption,MenuLink=@MenuLink,OrderSeq=@OrderSeq"); sqlstr.Append(" where ModSeq=@ModSeq"); SqlParameter[] parameters = { new SqlParameter("@ModSeq", SqlDbType.NVarChar, 50), new SqlParameter("@MCaption", SqlDbType.NVarChar, 60), new SqlParameter("@MenuLink", SqlDbType.NVarChar, 255), new SqlParameter("@OrderSeq", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.No; parameters[1].Value = model.Name; parameters[2].Value = model.PageUrl; parameters[3].Value = model.Order; try { int rows = DbHelperSQL.ExecuteSql(sqlstr.ToString(), parameters); if (rows == 0) { return(false); } else { return(true); } } catch { throw; } }
/// <summary> /// 删除数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Delete(SeatManage.ClassModel.SysFuncDicInfo model) { StringBuilder sqlstr = new StringBuilder(); sqlstr.Append("delete SysFuncDic"); sqlstr.Append(" where ModSeq=@ModSeq"); SqlParameter[] parameters = { new SqlParameter("@ModSeq", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.No; try { int rows = DbHelperSQL.ExecuteSql(sqlstr.ToString(), parameters); if (rows == 0) { return(false); } else { return(true); } } catch { throw; } }
public ActionResult AddOrEditingFunc(string Op, string ModSeq) { if (Op == "Edit") { SeatManage.Bll.SysFuncDic bllSysFuncDic = new SeatManage.Bll.SysFuncDic(); SeatManage.ClassModel.SysFuncDicInfo modelSysFuncDicInfo = bllSysFuncDic.GetFuncPage(null, ModSeq)[0]; ViewBag.Model = modelSysFuncDicInfo; ViewBag.Op = "Edit"; } return(View()); }
/// <summary> /// 删除功能页面,连表删除,会把菜单以及菜单相关联的权限删除 /// </summary> /// <param name="model">需要删除的实体类</param> /// <returns>返回Ture说明成功,False失败</returns> public bool DeleteFuncPage(SeatManage.ClassModel.SysFuncDicInfo model) { IWCFService.ISeatManageService seatService = new WcfServiceForSeatManage.SeatManageDateService(); bool error = false; try { return(seatService.DeleteFuncPage(model)); } catch (Exception ex) { error = true; WriteLog.Write("删除功能页面失败:" + ex.Message); return(false); } }
protected void GridFunctionPages_RowCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "ActionDelete") { SeatManage.ClassModel.SysFuncDicInfo modelSysFuncDicInfo = new SeatManage.ClassModel.SysFuncDicInfo(); SeatManage.Bll.SysFuncDic bllSysFuncDic = new SeatManage.Bll.SysFuncDic(); modelSysFuncDicInfo.No = GridFunctionPages.Rows[e.RowIndex].DataKeys[0].ToString(); if (!bllSysFuncDic.DeleteFuncPage(modelSysFuncDicInfo)) { FineUI.Alert.ShowInTop("删除失败!"); } else { FineUI.Alert.ShowInTop("删除成功!"); BindFunctionPagesGrid(); } } }
protected void btnSubmit_OnClick(object sender, EventArgs e) { string flag = Request.QueryString["flag"]; SeatManage.ClassModel.SysFuncDicInfo modelSysFuncDic = new SeatManage.ClassModel.SysFuncDicInfo(); SeatManage.Bll.SysFuncDic bllSysFuncDic = new SeatManage.Bll.SysFuncDic(); modelSysFuncDic.Name = txtMCaption.Text; modelSysFuncDic.PageUrl = txtMenuLink.Text; modelSysFuncDic.Order = txtOrderSeq.Text; switch (flag) { //新增功能页 case "add": modelSysFuncDic.No = txtModSeq.Text; if (string.IsNullOrEmpty(bllSysFuncDic.AddNewFuncPage(modelSysFuncDic))) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("添加成功!"); } else { FineUI.Alert.ShowInTop("添加失败!"); } break; //修改功能页 case "edit": modelSysFuncDic.No = txtModSeq.Text; if (bllSysFuncDic.UpdateFuncPage(modelSysFuncDic)) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("修改成功!"); } else { FineUI.Alert.ShowInTop("修改失败!"); } break; default: FineUI.Alert.ShowInTop("未执行任何操作"); break; } }
/// <summary> /// 删除 /// </summary> /// <param name="ModSeq"></param> /// <returns></returns> public JsonResult RemoveItem(string ModSeq) { JsonResult result = null; SeatManage.ClassModel.SysFuncDicInfo modelSysFuncDicInfo = new SeatManage.ClassModel.SysFuncDicInfo(); SeatManage.Bll.SysFuncDic bllSysFuncDic = new SeatManage.Bll.SysFuncDic(); modelSysFuncDicInfo.No = ModSeq; bool isTrue = bllSysFuncDic.DeleteFuncPage(modelSysFuncDicInfo); if (isTrue) { result = Json(new { status = "yes", message = "删除成功" }, JsonRequestBehavior.AllowGet); } else { result = Json(new { status = "no", message = "删除失败" }, JsonRequestBehavior.AllowGet); } return(result); }