/// <summary>
/// 根据所属权限ID获取所绑定的权限
/// </summary>
/// <param name="powerId">权限ID</param>
/// <returns></returns>
public IList <CompanyAuditingPowerInfo> GetCompanyAuditingPowerByPowerID(Guid powerId)
{
var parm = new SqlParameter(PARM_POWER_ID, SqlDbType.UniqueIdentifier)
{
Value = powerId
};
var sql = new StringBuilder(SQL_SELECT_COMPANY_AUDITING_POWER);
sql.Append(" AND ParentPowerID=@PowerID ");
IList <CompanyAuditingPowerInfo> list = new List <CompanyAuditingPowerInfo>();
try
{
using (var dr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, sql.ToString(), parm))
{
while (dr.Read())
{
var info = new CompanyAuditingPowerInfo(dr.GetGuid(0), dr.GetDecimal(1), dr.GetDecimal(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 UpdateCompanyAuditingPower(CompanyAuditingPowerInfo info, int updateType)
{
SqlParameter[] parms = GetCompanyParameters();
parms[0].Value = info.PowerID;
parms[1].Value = info.UpperMoney;
parms[2].Value = info.LowerMoney;
parms[3].Value = info.CompanyID;
parms[4].Value = info.FilialeId;
parms[5].Value = info.BranchID;
parms[6].Value = info.PositionID;
parms[7].Value = info.BindingType;
parms[8].Value = info.ParentPowerID;
var sql = new StringBuilder(SQL_UPDATE_COMPANY_AUDITING_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="filialeId">公司</param>
/// <param name="branchId">部门</param>
/// <param name="positionId">职务</param>
/// <returns></returns>
/// zal 2016-04-27
public IList <CompanyAuditingPowerInfo> GetCompanyAuditingPower(Guid filialeId, Guid branchId, Guid positionId)
{
var sql = new StringBuilder(SQL_SELECT_COMPANY_AUDITING_POWER);
sql.Append(" AND FilialeId=@FilialeId ");
sql.Append(" AND BranchID=@BranchID ");
sql.Append(" AND PositionID=@PositionID ");
var parms = new[]
{
new SqlParameter("@FilialeId", filialeId),
new SqlParameter("@BranchID", branchId),
new SqlParameter("@PositionID", positionId)
};
IList <CompanyAuditingPowerInfo> list = new List <CompanyAuditingPowerInfo>();
try
{
using (var dr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, sql.ToString(), parms))
{
while (dr.Read())
{
var info = new CompanyAuditingPowerInfo(dr.GetGuid(0), dr.GetDecimal(1), dr.GetDecimal(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>
public void InsertCompanyAuditingPower(CompanyAuditingPowerInfo info)
{
SqlParameter[] parms = GetCompanyParameters();
parms[0].Value = info.PowerID;
parms[1].Value = info.UpperMoney;
parms[2].Value = info.LowerMoney;
parms[3].Value = info.CompanyID;
parms[4].Value = info.FilialeId;
parms[5].Value = info.BranchID;
parms[6].Value = info.PositionID;
parms[7].Value = info.BindingType;
parms[8].Value = info.ParentPowerID;
try
{
SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL_INSERT_COMPANY_AUDITING_POWER, parms);
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message);
}
}
/// <summary>
/// 获取所有往来单位绑定的权限
/// </summary>
/// <returns></returns>
public IList <CompanyAuditingPowerInfo> GetALLCompanyAuditingPower()
{
IList <CompanyAuditingPowerInfo> list = new List <CompanyAuditingPowerInfo>();
try
{
using (var dr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, SQL_SELECT_COMPANY_AUDITING_POWER, null))
{
while (dr.Read())
{
var info = new CompanyAuditingPowerInfo(dr.GetGuid(0), dr.GetDecimal(1), dr.GetDecimal(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_UpdateCommand(object sender, GridCommandEventArgs e)
{
var editedItem = e.Item as GridEditableItem;
var info = new CompanyAuditingPowerInfo();
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.LowerMoney = decimal.Parse(((TextBox)editedItem.FindControl("TB_MinAmount")).Text);
info.UpperMoney = decimal.Parse(((TextBox)editedItem.FindControl("TB_MaxAmount")).Text);
}
info.BindingType = (int)CompanyFundReceiptPowerBindType.DirectBind;
info.CompanyID = CompanyID;
info.ParentPowerID = Guid.Empty;
try
{
_powerWrite.UpdateCompanyAuditingPower(info, 0);
CacheHelper.Remove(Key.AllCompanyAuditingPower);
IList <CompanyAuditingPowerInfo> companyList = _powerWrite.GetCompanyAuditingPowerByPowerID(info.PowerID);
if (companyList.Count > 0)
{
info.BindingType = (int)CompanyFundReceiptPowerBindType.ExpandBind;
info.ParentPowerID = info.PowerID;
_powerWrite.UpdateCompanyAuditingPower(info, 1);
CacheHelper.Remove(Key.AllCompanyAuditingPower);
}
RG_Power.Rebind();
}
catch (Exception ex)
{
RAM.Alert("权限修改失败！" + ex);
}
}
/// <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 CompanyAuditingPowerInfo();
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.LowerMoney = decimal.Parse(((TextBox)editedItem.FindControl("TB_MinAmount")).Text);
info.UpperMoney = decimal.Parse(((TextBox)editedItem.FindControl("TB_MaxAmount")).Text);
}
info.BindingType = (int)CompanyFundReceiptPowerBindType.DirectBind;
info.CompanyID = CompanyID;
info.ParentPowerID = Guid.Empty;
try
{
_powerWrite.InsertCompanyAuditingPower(info);
CacheHelper.Remove(Key.AllCompanyAuditingPower);
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;
_powerWrite.InsertCompanyAuditingPower(info);
CacheHelper.Remove(Key.AllCompanyAuditingPower);
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;
_powerWrite.InsertCompanyAuditingPower(info);
CacheHelper.Remove(Key.AllCompanyAuditingPower);
}
}
}
}
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;
_powerWrite.InsertCompanyAuditingPower(info);
CacheHelper.Remove(Key.AllCompanyAuditingPower);
}
}
}
}
RG_Power.Rebind();
}
catch (Exception ex)
{
RAM.Alert("权限添加失败！" + ex);
}
}
