/// <summary>
/// 加载总功能信息
/// </summary>
private void LoadPermissionsTatal()
{
PermissionstatalEO ptEO = new PermissionstatalEO();
ptEO = ptManage.GetPermissionsTatalByPK(Request.QueryString["Ptid"]);
if (!string.IsNullOrEmpty(ptEO.PtName))
{
this.txtPtName.Text = ptEO.PtName;
this.hfPtName.Value = ptEO.PtName;
this.ddlPf.SelectedValue = ptEO.PfId;
this.rblState.SelectedValue = ptEO.PtState;
}
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name = "item">要更新的实体对象</param>
/// <param name="tm">事务管理对象</param>
/// <return>受影响的行数</return>
public virtual int UpdatePermissionsTatal(PermissionstatalEO item, TransactionManager tm = null)
{
const string sql = @"UPDATE permissionstatal SET Pt_name=@Pt_name, Pf_id=@Pf_id, Pt_addUser=@Pt_addUser, Pt_addTime=@Pt_addTime, Pt_state=@Pt_state, Pt_del=@Pt_del, Pt_text1=@Pt_text1, Pt_text2=@Pt_text2 WHERE Pt_id=@Pt_id";
return(Database.CreateSqlDao(sql)
.AddInParameter("@Pt_id", item.PtId, DbType.String, 50)
.AddInParameter("@Pt_name", item.PtName, DbType.String, 50)
.AddInParameter("@Pf_id", item.PfId, DbType.String, 50)
.AddInParameter("@Pt_addUser", item.PtAddUser, DbType.String, 50)
.AddInParameter("@Pt_addTime", item.PtAddTime, DbType.DateTime, 8)
.AddInParameter("@Pt_state", item.PtState, DbType.AnsiStringFixedLength, 1)
.AddInParameter("@Pt_del", item.PtDel, DbType.AnsiStringFixedLength, 1)
.AddInParameter("@Pt_text1", item.PtText1 != null ? (object)item.PtText1 : DBNull.Value, DbType.String, 200)
.AddInParameter("@Pt_text2", item.PtText2 != null ? (object)item.PtText2 : DBNull.Value, DbType.String, 200)
.ExecNonQuery(tm));
}
/// <summary>
/// 修改总功能信息
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int EditPermissionsTatal(PermissionstatalEO item)
{
return(ptMO.UpdatePermissionsTatal(item));
}
/// <summary>
/// 创建总功能信息
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int AddPermissionsTatal(PermissionstatalEO item)
{
return(ptMO.Add(item));
}
/// <summary>
/// 维护信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnOK_Click(object sender, EventArgs e)
{
if (this.CheckForms() == false)
{
CloseDivImplementation();
return;
}
PermissionstatalEO ptEO = new PermissionstatalEO(); //总功能
PermissionstatalpEO ptpEO = new PermissionstatalpEO(); //总功能关系
if (Request.QueryString["State"] == "U")
{
ptEO = ptManage.GetPermissionsTatalByPK(Request.QueryString["Ptid"]);
}
//总功能数据
ptEO.PtName = this.txtPtName.Text.Trim();
ptEO.PfId = this.ddlPf.SelectedValue;
ptEO.PtState = this.rblState.SelectedValue;
//创建总功能信息
if (Request.QueryString["State"] == "A")
{
//判断总功能名称是否存在
if (this.ChecPtName() == false)
{
//Jswork.Alert("总功能名称 " + this.txtPtName.Text.Trim() + " 已存在", this.Page);
this.divAlert.Visible = true;
this.lblAlert.Text = this.ddlPf.SelectedItem.Text + Resources.Resource.Name_of_total_function_in + this.txtPtName.Text.Trim() + Resources.Resource.Already_exist;
CloseDivImplementation();
return;
}
//总功能数据
ptEO.PtId = GetBigGuid();
ptEO.PtDel = "0";
ptEO.PtAddUser = GetUserID();
ptEO.PtAddTime = DateTime.Now;
//总功能关系数据
for (int i = 0; i < this.cblPermissions.Items.Count; i++)
{
if (this.cblPermissions.Items[i].Selected)
{
ptpEO.PtId = ptEO.PtId;
ptpEO.PmId = this.cblPermissions.Items[i].Value;
ptpEO.PpUser = GetUserID();
ptpEO.PpAddTime = DateTime.Now;
ptpManage.AddPermissionsTatalP(ptpEO);
}
}
if (ptManage.AddPermissionsTatal(ptEO) > 0)
{
//插入操作日志
InsertLog(Resources.Resource.Create_general_function_information, string.Format("permissionstatalname:{0},id:{1}", ptEO.PtName, ptEO.PtId), 7, GetPlatformIdByValue(1));
CloseDivImplementation();
Jswork.Alert(Resources.Resource.Total_function_information_creation_success, "PermissionsTatalList.aspx");
}
else
{
//Jswork.Alert("总功能信息创建失败", this.Page);
this.divAlert.Visible = true;
this.lblAlert.Text = Resources.Resource.Total_function_information_creation_failed;//"总功能信息创建失败";
}
}
//修改总功能信息
if (Request.QueryString["State"] == "U")
{
//修改时判断总功能名称是否存在
if (this.hfPtName.Value != this.txtPtName.Text.Trim())
{
//判断平台名称是否存在
if (this.ChecPtName() == false)
{
//Jswork.Alert("总功能名称 " + this.txtPtName.Text.Trim() + " 已存在", this.Page);
this.divAlert.Visible = true;
this.lblAlert.Text = this.ddlPf.SelectedItem.Text + Resources.Resource.Name_of_total_function_in + this.txtPtName.Text.Trim() + Resources.Resource.Already_exist;
CloseDivImplementation();
return;
}
}
//总功能关系数据
ptpManage.RemoveByPK(Request.QueryString["Ptid"]); //插入关系表数据前先删除数据
for (int i = 0; i < this.cblPermissions.Items.Count; i++)
{
if (this.cblPermissions.Items[i].Selected)
{
ptpEO.PtId = Request.QueryString["Ptid"];
ptpEO.PmId = this.cblPermissions.Items[i].Value;
ptpEO.PpUser = GetUserID();
ptpEO.PpAddTime = DateTime.Now;
ptpManage.AddPermissionsTatalP(ptpEO);
}
}
if (ptManage.EditPermissionsTatal(ptEO) > 0)
{
//插入操作日志
InsertLog(Resources.Resource.Modify_general_function_information, string.Format("permissionstatalname:{0},id:{1}", ptEO.PtName, ptEO.PtId), 8, GetPlatformIdByValue(1));
CloseDivImplementation();
Jswork.Alert(Resources.Resource.The_success_of_total_functional_information_modification, "PermissionsTatalList.aspx");
}
else
{
//Jswork.Alert("总功能信息修改失败", this.Page);
this.divAlert.Visible = true;
this.lblAlert.Text = Resources.Resource.Failure_of_total_functional_information_modification;
}
}
CloseDivImplementation();
}
