/// <summary> /// 修改权限 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void RG_Power_UpdateCommand(object sender, GridCommandEventArgs e) { var editedItem = e.Item as GridEditableItem; var info = new CompanyInvoicePowerInfo(); if (editedItem != null) { info.PowerID = new Guid(editedItem.GetDataKeyValue("PowerID").ToString()); info.FilialeID = new Guid(((DropDownList)editedItem.FindControl("DDL_Filiale")).SelectedValue); info.BranchID = new Guid(((DropDownList)editedItem.FindControl("DDL_Branch")).SelectedValue); info.PositionID = new Guid(((DropDownList)editedItem.FindControl("DDL_Position")).SelectedValue); info.AuditorID = new Guid(((DropDownList)editedItem.FindControl("DDL_Personnel")).SelectedValue); info.InvoicesType = int.Parse(((DropDownList)editedItem.FindControl("DDL_InvoiceType")).SelectedValue); } info.BindingType = (int)CompanyFundReceiptPowerBindType.DirectBind; info.CompanyID = CompanyID; info.ParentPowerID = Guid.Empty; try { _companyInvoicePower.UpdateCompanyInvoicePower(info, 0); IList <CompanyInvoicePowerInfo> companyList = _companyInvoicePower.GetCompanyInvoicePowerByPowerID(info.PowerID); if (companyList.Count > 0) { info.BindingType = (int)CompanyFundReceiptPowerBindType.ExpandBind; info.ParentPowerID = info.PowerID; _companyInvoicePower.UpdateCompanyInvoicePower(info, 1); } RG_Power.Rebind(); } catch (Exception ex) { RAM.Alert("权限修改失败!" + ex); } }
/// <summary> /// 根据所属权限ID获取所绑定的权限 /// </summary> /// <param name="powerId">权限ID</param> /// <returns></returns> public IList <CompanyInvoicePowerInfo> GetCompanyInvoicePowerByPowerID(Guid powerId) { var parm = new SqlParameter(PARM_POWER_ID, SqlDbType.UniqueIdentifier) { Value = powerId }; var sql = new StringBuilder(SQL_SELECT_COMPANY_INVOICE_POWER); sql.Append(" AND ParentPowerID=@PowerID "); IList <CompanyInvoicePowerInfo> list = new List <CompanyInvoicePowerInfo>(); try { using (var dr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, sql.ToString(), parm)) { while (dr.Read()) { var info = new CompanyInvoicePowerInfo(dr.GetGuid(0), dr.GetInt32(1), dr.GetGuid(2), dr.GetGuid(3), dr.GetGuid(4), dr.GetGuid(5), dr.GetGuid(6), dr.GetInt32(7), dr.GetGuid(8)); list.Add(info); } } return(list); } catch (Exception ex) { throw new ApplicationException(ex.Message); } }
/// <summary> /// 修改往来单位收付款发票权限 /// </summary> /// <param name="info">权限模型</param> /// <param name="updateType">修改模式:0按权限ID修改,1按所属权限ID修改</param> public void UpdateCompanyInvoicePower(CompanyInvoicePowerInfo info, int updateType) { SqlParameter[] parms = GetCompanyParameters(); parms[0].Value = info.PowerID; parms[1].Value = info.InvoicesType; parms[2].Value = info.CompanyID; parms[3].Value = info.FilialeID; parms[4].Value = info.BranchID; parms[5].Value = info.PositionID; parms[6].Value = info.AuditorID; parms[7].Value = info.BindingType; parms[8].Value = info.ParentPowerID; var sql = new StringBuilder(SQL_UPDATE_COMPANY_INVOICE_POWER); sql.Append(updateType == 0 ? " AND PowerID=@PowerID " : " AND ParentPowerID=@ParentPowerID "); try { SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, sql.ToString(), parms); } catch (Exception ex) { throw new ApplicationException(ex.Message); } }
/// <summary> /// 添加往来单位收付款发票权限 /// </summary> /// <param name="info">权限模型</param> public void InsertCompanyInvoicePower(CompanyInvoicePowerInfo info) { SqlParameter[] parms = GetCompanyParameters(); parms[0].Value = info.PowerID; parms[1].Value = info.InvoicesType; parms[2].Value = info.CompanyID; parms[3].Value = info.FilialeID; parms[4].Value = info.BranchID; parms[5].Value = info.PositionID; parms[6].Value = info.AuditorID; parms[7].Value = info.BindingType; parms[8].Value = info.ParentPowerID; try { SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL_INSERT_COMPANY_INVOICE_POWER, parms); } catch (Exception ex) { throw new ApplicationException(ex.Message); } }
/// <summary> /// 获取所有往来单位绑定的权限 /// </summary> /// <returns></returns> public IList <CompanyInvoicePowerInfo> GetALLCompanyInvoicePower() { IList <CompanyInvoicePowerInfo> list = new List <CompanyInvoicePowerInfo>(); try { using (var dr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, SQL_SELECT_COMPANY_INVOICE_POWER, null)) { while (dr.Read()) { var info = new CompanyInvoicePowerInfo(dr.GetGuid(0), dr.GetInt32(1), dr.GetGuid(2), dr.GetGuid(3), dr.GetGuid(4), dr.GetGuid(5), dr.GetGuid(6), dr.GetInt32(7), dr.GetGuid(8)); list.Add(info); } } return(list); } 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) { var editedItem = e.Item as GridEditableItem; var info = new CompanyInvoicePowerInfo(); Guid parentPowerID = Guid.NewGuid(); info.PowerID = parentPowerID; if (editedItem != null) { info.FilialeID = new Guid(((DropDownList)editedItem.FindControl("DDL_Filiale")).SelectedValue); info.BranchID = new Guid(((DropDownList)editedItem.FindControl("DDL_Branch")).SelectedValue); info.PositionID = new Guid(((DropDownList)editedItem.FindControl("DDL_Position")).SelectedValue); info.AuditorID = new Guid(((DropDownList)editedItem.FindControl("DDL_Personnel")).SelectedValue); info.InvoicesType = int.Parse(((DropDownList)editedItem.FindControl("DDL_InvoiceType")).SelectedValue); } info.BindingType = (int)CompanyFundReceiptPowerBindType.DirectBind; info.CompanyID = CompanyID; info.ParentPowerID = Guid.Empty; try { _companyInvoicePower.InsertCompanyInvoicePower(info); CompanyClassInfo companyClassInfo = _companyClass.GetCompanyClass(CompanyID); if (companyClassInfo.CompanyClassId != Guid.Empty) { IList <CompanyClassInfo> classList = _companyClass.GetChildCompanyClassList(CompanyID).ToList(); if (classList.Count > 0) { foreach (CompanyClassInfo cInfo in classList) { info.PowerID = Guid.NewGuid(); info.BindingType = (int)CompanyFundReceiptPowerBindType.ExpandBind; info.CompanyID = cInfo.CompanyClassId; info.ParentPowerID = parentPowerID; _companyInvoicePower.InsertCompanyInvoicePower(info); IList <CompanyCussentInfo> cussentList = _companyCussent.GetCompanyCussentList(cInfo.CompanyClassId).ToList(); if (cussentList.Count > 0) { foreach (CompanyCussentInfo cussentInfo in cussentList) { info.PowerID = Guid.NewGuid(); info.BindingType = (int)CompanyFundReceiptPowerBindType.ExpandBind; info.CompanyID = cussentInfo.CompanyId; info.ParentPowerID = parentPowerID; _companyInvoicePower.InsertCompanyInvoicePower(info); } } } } else { IList <CompanyCussentInfo> cussentList = _companyCussent.GetCompanyCussentList(CompanyID).ToList(); if (cussentList.Count > 0) { foreach (CompanyCussentInfo cussentInfo in cussentList) { info.PowerID = Guid.NewGuid(); info.BindingType = (int)CompanyFundReceiptPowerBindType.ExpandBind; info.CompanyID = cussentInfo.CompanyId; info.ParentPowerID = parentPowerID; _companyInvoicePower.InsertCompanyInvoicePower(info); } } } } RG_Power.Rebind(); } catch (Exception ex) { RAM.Alert("权限添加失败!" + ex); } }