//删除功能页按钮点击事件
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);
}
