/// <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);
}
}
