/// <summary> /// 修改权限 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void RG_Power_UpdateCommand(object sender, GridCommandEventArgs e) { Ccb_CheckedChanged(e); var editedItem = e.Item as GridEditableItem; var info = new CostReportAuditingInfo(); if (editedItem != null) { info.PowerId = new Guid(editedItem.GetDataKeyValue("PowerId").ToString()); info.AuditingFilialeId = new Guid(((DropDownList)editedItem.FindControl("DDL_Filiale")).SelectedValue); info.AuditingBranchId = new Guid(((DropDownList)editedItem.FindControl("DDL_Branch")).SelectedValue); info.AuditingPositionId = new Guid(((DropDownList)editedItem.FindControl("DDL_Position")).SelectedValue); } info.MinAmount = -1; info.MaxAmount = -1; info.ReportBranchId = BranchID; if (editedItem != null) { info.Description = ((TextBox)editedItem.FindControl("TB_Description")).Text; } info.Kind = (int)CostReportAuditingType.Invoice; try { _costReportAuditingPower.UpdatePower(info); RG_Power.Rebind(); CheckChanged = false; } catch (Exception ex) { RAM.Alert("权限修改失败!" + ex.Message); } }
/// <summary> /// 修改权限 /// </summary> /// <param name="info">权限模型</param> public void UpdatePower(CostReportAuditingInfo info) { SqlParameter[] parms = GetParameter(); parms[0].Value = info.PowerId; parms[1].Value = info.AuditingFilialeId; parms[2].Value = info.AuditingBranchId; parms[3].Value = info.AuditingPositionId; parms[4].Value = info.MinAmount; parms[4].Precision = 18; parms[4].Scale = 4; parms[5].Value = info.MaxAmount; parms[5].Precision = 18; parms[5].Scale = 4; parms[6].Value = info.ReportBranchId; parms[7].Value = info.Description; parms[8].Value = info.Kind; try { SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL_UPDATE_POWER, parms); } catch (Exception ex) { throw new ApplicationException(ex.Message); } }
/// <summary> /// 获取权限 /// </summary> /// <returns></returns> public IList <CostReportAuditingInfo> GetPowerList() { IList <CostReportAuditingInfo> list = new List <CostReportAuditingInfo>(); using (var dr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, SQL_GET_POWER, null)) { while (dr.Read()) { var info = new CostReportAuditingInfo(dr.GetGuid(0), dr.GetGuid(1), dr.GetGuid(2), dr.GetGuid(3), dr.GetDecimal(4), dr.GetDecimal(5), dr.GetString(6), dr[7] == DBNull.Value ? "" : dr.GetString(7), dr[8] == DBNull.Value ? 0 : dr.GetInt32(8)); list.Add(info); } } return(list); }
/// <summary> /// 添加权限 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void RgPowerInsertCommand(object sender, GridCommandEventArgs e) { var editedItem = e.Item as GridEditableItem; var info = new CostReportAuditingInfo { PowerId = Guid.NewGuid() }; if (editedItem != null) { info.AuditingFilialeId = new Guid(((DropDownList)editedItem.FindControl("DDL_Filiale")).SelectedValue); info.AuditingBranchId = new Guid(((DropDownList)editedItem.FindControl("DDL_Branch")).SelectedValue); info.AuditingPositionId = new Guid(((DropDownList)editedItem.FindControl("DDL_Position")).SelectedValue); info.MinAmount = decimal.Parse(((TextBox)editedItem.FindControl("TB_MinAmount")).Text); info.MaxAmount = decimal.Parse(((TextBox)editedItem.FindControl("TB_MaxAmount")).Text); string strReportBranchIds = string.Empty; var rpReportFiliale = (Repeater)editedItem.FindControl("RP_ReportFiliale"); strReportBranchIds = (from RepeaterItem item in rpReportFiliale.Items select(CheckBoxList) item.FindControl("cblReportBranch")) .Aggregate(strReportBranchIds, (current1, cblReportBranch) => cblReportBranch.Items.Cast <ListItem>().Where(listItem => listItem.Selected).Aggregate(current1, (current, listItem) => current + (listItem.Value + ","))); info.ReportBranchId = strReportBranchIds; } if (editedItem != null) { info.Description = ((TextBox)editedItem.FindControl("TB_Description")).Text; } info.Kind = (int)CostReportAuditingType.Auditing; try { CostReportAuditingInfo auditingInfo = _costReportAuditingPowerDao.GetPowerList().FirstOrDefault(p => p.AuditingFilialeId == info.AuditingFilialeId && p.AuditingBranchId == info.AuditingBranchId && p.AuditingPositionId == info.AuditingPositionId && p.ReportBranchId == info.ReportBranchId); using (var ts = new TransactionScope(TransactionScopeOption.Required)) { if (auditingInfo != null) { _costReportAuditingPowerDao.DeletePower(auditingInfo.PowerId); } _costReportAuditingPowerDao.InsertPower(info); ts.Complete(); } RG_Power.Rebind(); } catch (Exception ex) { RAM.Alert("权限添加失败!" + ex.Message); } }
/// <summary> /// 申报部门权限 /// </summary> /// <param name="info">权限模型</param> public void UpdateReportPower(CostReportAuditingInfo info) { var parms = new[] { new SqlParameter(PARM_POWER_ID, SqlDbType.UniqueIdentifier), new SqlParameter(PARM_REPORT_BRANCH_ID, SqlDbType.VarChar, 256) }; parms[0].Value = info.PowerId; parms[1].Value = info.ReportBranchId; try { SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL_UPDATE_REPORT_POWER, parms); } catch (Exception ex) { throw new ApplicationException(ex.Message); } }
/// <summary> /// 添加权限 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void RG_Power_InsertCommand(object sender, GridCommandEventArgs e) { Ccb_CheckedChanged(e); var editedItem = e.Item as GridEditableItem; var info = new CostReportAuditingInfo { PowerId = Guid.NewGuid() }; if (editedItem != null) { info.AuditingFilialeId = new Guid(((DropDownList)editedItem.FindControl("DDL_Filiale")).SelectedValue); info.AuditingBranchId = new Guid(((DropDownList)editedItem.FindControl("DDL_Branch")).SelectedValue); info.AuditingPositionId = new Guid(((DropDownList)editedItem.FindControl("DDL_Position")).SelectedValue); } info.MinAmount = -1; info.MaxAmount = -1; info.ReportBranchId = BranchID; if (editedItem != null) { info.Description = ((TextBox)editedItem.FindControl("TB_Description")).Text; } info.Kind = (int)CostReportAuditingType.Invoice; try { CostReportAuditingInfo auditingInfo = _costReportAuditingPower.GetPowerList().FirstOrDefault(p => p.AuditingFilialeId == info.AuditingFilialeId && p.AuditingBranchId == info.AuditingBranchId && p.AuditingPositionId == info.AuditingPositionId && p.ReportBranchId == info.ReportBranchId); using (var ts = new TransactionScope(TransactionScopeOption.Required)) { if (auditingInfo != null) { _costReportAuditingPower.DeletePower(auditingInfo.PowerId); } _costReportAuditingPower.InsertPower(info); ts.Complete(); } RG_Power.Rebind(); CheckChanged = false; } catch (Exception ex) { RAM.Alert("权限添加失败!" + ex.Message); } }
/// <summary> /// 修改权限 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void RgPowerUpdateCommand(object sender, GridCommandEventArgs e) { var editedItem = e.Item as GridEditableItem; var info = new CostReportAuditingInfo(); if (editedItem != null) { info.PowerId = new Guid(editedItem.GetDataKeyValue("PowerId").ToString()); info.AuditingFilialeId = new Guid(((DropDownList)editedItem.FindControl("DDL_Filiale")).SelectedValue); info.AuditingBranchId = new Guid(((DropDownList)editedItem.FindControl("DDL_Branch")).SelectedValue); info.AuditingPositionId = new Guid(((DropDownList)editedItem.FindControl("DDL_Position")).SelectedValue); info.MinAmount = decimal.Parse(((TextBox)editedItem.FindControl("TB_MinAmount")).Text); info.MaxAmount = decimal.Parse(((TextBox)editedItem.FindControl("TB_MaxAmount")).Text); string strReportBranchIds = string.Empty; var rpReportFiliale = (Repeater)editedItem.FindControl("RP_ReportFiliale"); strReportBranchIds = (from RepeaterItem item in rpReportFiliale.Items select(CheckBoxList) item.FindControl("cblReportBranch")) .Aggregate(strReportBranchIds, (current1, cblReportBranch) => cblReportBranch.Items.Cast <ListItem>() .Where(listItem => listItem.Selected).Aggregate(current1, (current, listItem) => current + (listItem.Value + ","))); info.ReportBranchId = strReportBranchIds; } if (editedItem != null) { info.Description = ((TextBox)editedItem.FindControl("TB_Description")).Text; } info.Kind = (int)CostReportAuditingType.Auditing; try { _costReportAuditingPowerDao.UpdatePower(info); RG_Power.Rebind(); } catch (Exception ex) { RAM.Alert("权限修改失败!" + ex.Message); } }