public override void Init()
{
//逻辑对象赋值
bll = PagePowerSignPublicBll.GetInstence();
//表格对象赋值
grid = Grid1;
}
protected void Grid3_OnRowClick(object sender, FineUI.GridRowClickEventArgs e)
{
Grid4.Rows.Clear();
GridRow gr = Grid3.Rows[e.RowIndex];
menuInfoId_ = int.Parse(gr.Values[0].ToString());
// PositionBll.GetInstence().BandPagePowerSignPublicList(this, Grid4);
// PositionBll.GetInstence().BandPagePowerSignList(this, Grid5, menuInfoId);
//var list = PagePowerSignBll.GetInstence().GetList(false);
// bll.BindGrid(Grid4, InquiryCondition(), sortList);
// conditionList = new List<ConditionFun.SqlqueryCondition>();
// conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "1", Comparison.Equals, "1", false, false));
//bll.BindGrid(Grid1, 0, sortList);
// bll.BindGrid(Grid4, 0, 0, conditionList, sortList);
PagePowerSignPublicBll.GetInstence().BandPagePowerSignPublicList(this, Grid4);
}
//#region 页面控件绑定
///// <summary>下拉列表改变事件
///// </summary>
///// <param name="sender"></param>
///// <param name="e"></param>
//protected void ddlParentId_SelectedIndexChanged(object sender, EventArgs e)
//{
// //初始化路径值
// txtUrl.Text = string.Empty;
// //获取当前节点的父节点Id
// txtParent.Text = ddlParentId.SelectedValue;
// if (!ddlParentId.SelectedValue.Equals("0"))
// {
// try
// {
// //获取当前节点的父节点url
// txtUrl.Text = MenuInfoBll.GetInstence().GetFieldValue(ConvertHelper.Cint0(ddlParentId.SelectedValue), MenuInfoTable.Url) + "";
// }
// catch
// {
// }
// }
//}
//#endregion
#region 保存
/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
int id = ConvertHelper.Cint0(hidId.Text);
try
{
#region 数据验证
if (string.IsNullOrEmpty(txtCname.Text.Trim()))
{
return(txtCname.Label + "不能为空！");
}
if (string.IsNullOrEmpty(txtEname.Text.Trim()))
{
return(txtEname.Label + "不能为空！");
}
#endregion
#region 赋值
//读取指定部门资料
var model = new PagePowerSignPublic(x => x.Id == id);
//设置名称
model.Cname = txtCname.Text;;
//连接地址
model.Ename = txtEname.Text;;
#endregion
//----------------------------------------------------------
//存储到数据库
PagePowerSignPublicBll.GetInstence().Save(this, model);
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
private void BindGrid()
{
var index = ConvertHelper.Cint0(hidId.Text);
if (index == 0)
{
return;
}
//设置查询条件
var wheres = new List <ConditionHelper.SqlqueryCondition>();
wheres.Add(new ConditionHelper.SqlqueryCondition(ConstraintType.And, PagePowerSignTable.MenuInfo_Id, Comparison.Equals, index));
//设置排序
var _order = new List <string>();
_order.Add(PagePowerSignTable.Id);
//获取DataTable
var dt = PagePowerSignBll.GetInstence().GetDataTable(false, 0, null, 0, 0, wheres, _order);
if (dt == null || dt.Rows.Count == 0)
{
Grid2.DataSource = null;
Grid2.DataBind();
PagePowerSignPublicBll.GetInstence().BindGrid(Grid1, 0, 0, null, _order);
}
else
{
//绑定到表格——已绑定控件列表
//PagePowerSignBll.GetInstence().BindGrid(Grid2, 0, 0, list, _order);
Grid2.DataSource = dt;
Grid2.DataBind();
var id = DataTableHelper.GetArrayInt(dt, PagePowerSignTable.PagePowerSignPublic_Id);
wheres = new List <ConditionHelper.SqlqueryCondition>();
wheres.Add(new ConditionHelper.SqlqueryCondition(ConstraintType.And, PagePowerSignPublicTable.Id, Comparison.NotIn, id));
PagePowerSignPublicBll.GetInstence().BindGrid(Grid1, 0, 0, wheres, _order);
}
}
/// <summary>读取数据</summary>
public override void LoadData()
{
int id = ConvertHelper.Cint0(hidId.Text);
if (id != 0)
{
//获取指定ID的菜单内容，如果不存在，则创建一个菜单实体
var model = PagePowerSignPublicBll.GetInstence().GetModelForCache(x => x.Id == id);
if (model == null)
{
return;
}
//控件名称
txtCName.Text = model.CName;
//英文名称
txtEName.Text = model.EName;
}
}
/// <summary>读取数据</summary>
public override void LoadData()
{
//关闭窗口
ButtonCancel.OnClientClick = ActiveWindow.GetHideReference();
int id = ConvertHelper.Cint0(hidId.Text);
if (id != 0)
{
//获取指定ID的菜单内容，如果不存在，则创建一个菜单实体
var model = PagePowerSignPublicBll.GetInstence().GetModelForCache(x => x.Id == id);
if (model == null)
{
return;
}
//对页面窗体进行赋值
// txtId.Text = model.Id.ToString();
txtCname.Text = model.Cname;
txtEname.Text = model.Ename;
}
}
/// <summary>
/// 页面绑定控件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonEmpower_Click(object sender, EventArgs e)
{
//获取当前选择的菜单项
var index = ConvertHelper.Cint0(hidId.Text);
//获取当前用户选择的全部记录Id
var id = GridViewHelper.GetSelectedKeyIntArray(Grid1);
//如果没有选择项，则直接退出
if (index == 0 || id == null || id.Length == 0)
{
return;
}
//添加到绑定表中
foreach (var i in id)
{
//检查当前控件是否已添加
//添加前判断一下本权限标签是否已添加过了，没有则进行添加
if (!PagePowerSignBll.GetInstence().Exist(x => x.MenuInfo_Id == index && x.PagePowerSignPublic_Id == i))
{
var ppsp = PagePowerSignPublicBll.GetInstence().GetModelForCache(i);
if (ppsp == null)
{
continue;
}
var model = new PagePowerSign();
model.MenuInfo_Id = index;
model.PagePowerSignPublic_Id = i;
model.CName = ppsp.CName;
model.EName = ppsp.EName;
PagePowerSignBll.GetInstence().Save(this, model);
}
}
BindGrid();
}
/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
int id = ConvertHelper.Cint0(hidId.Text);
try
{
#region 数据验证
if (string.IsNullOrEmpty(txtCName.Text.Trim()))
{
return(txtCName.Label + "不能为空！");
}
var sName = StringHelper.Left(txtCName.Text, 20);
if (PagePowerSignPublicBll.GetInstence().Exist(x => x.CName == sName && x.Id != id))
{
return(txtCName.Label + "已存在！请重新输入！");
}
if (string.IsNullOrEmpty(txtEName.Text.Trim()))
{
return(txtEName.Label + "不能为空！");
}
var sEname = StringHelper.Left(txtEName.Text, 50);
if (PagePowerSignPublicBll.GetInstence().Exist(x => x.EName == sEname && x.Id != id))
{
return(txtEName.Label + "已存在！请重新输入！");
}
#endregion
#region 赋值
//定义是否更新标识——即当前记录的名称是否改变了
bool isUpdate = false;
//获取实体
var model = new PagePowerSignPublic(x => x.Id == id);
//判断是否有改变名称
if (id > 0 && (sName != model.CName || sEname != model.EName))
{
isUpdate = true;
}
//设置名称
model.CName = sName;
//设置英文名称
model.EName = sEname;
#endregion
//----------------------------------------------------------
//存储到数据库
PagePowerSignPublicBll.GetInstence().Save(this, model);
//判断是否需要同步更新关联表字段
if (isUpdate)
{
//调用更新函数，同步更新对应的所有记录
PagePowerSignBll.GetInstence().UpdateValue_For_PagePowerSignPublic_Id(this, model.Id, PagePowerSignTable.CName, model.CName, PagePowerSignTable.EName, model.EName);
}
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
