/// <summary>
/// 获取往来单位权限
/// </summary>
/// <param name="EmployeeId"></param>
/// <param name="TypeID"></param>
/// <returns></returns>
public string GetBusIDsByUserID(string EmployeeId, int TypeID)
{
string bussIDs = "";
try
{
if (string.IsNullOrEmpty(EmployeeId))
{
return("( -1 )");
}
if (EmployeeId == "1")
{
return("");
}
List <DbParameter> parameters = new List <DbParameter>();
parameters.Add(QueryService.AddInParameter("@UserID", SqlDbType.Int, 0, EmployeeId));
parameters.Add(QueryService.AddInParameter("@BusinessProperty", SqlDbType.Int, 0, TypeID));
parameters.Add(QueryService.AddInParameter("@ReturnType", SqlDbType.Int, 0, 0));//集合 //字符串
//执行存储过程
DataTable table = QueryService.ExecuteDataTable("[dbo].[proc_Authority_UserBusiness]", parameters);
if (table != null && table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
bussIDs += row["ID"] + ",";
}
return("( " + bussIDs.Substring(0, bussIDs.Length - 1) + " )");
}
else
{
return("( -1 )");
}
}
catch (Exception ex)
{
WriteExceptionLog(ex);
return("( -1 )");
}
}
/// <summary>
/// 获取往来单位权限
/// </summary>
/// <param name="EmployeeId"></param>
/// <param name="TypeID"></param>
/// <returns></returns>
public string GetBusAllIDsByUserID(string EmployeeId)
{
string bussIDs = "";
try
{
if (string.IsNullOrEmpty(EmployeeId))
{
return("( -1 )");
}
if (EmployeeId == "1")
{
return("");
}
List <DbParameter> parameters = new List <DbParameter>();
parameters.Add(QueryService.AddInParameter("@UserID", SqlDbType.Int, 0, EmployeeId));
parameters.Add(QueryService.AddInParameter("@BusinessProperty", SqlDbType.Int, 0, 1));
parameters.Add(QueryService.AddInParameter("@ReturnType", SqlDbType.Int, 0, 0));//集合 //字符串
DataTable tableSupplier = QueryService.ExecuteDataTable("[dbo].[proc_Authority_UserBusiness]", parameters);
parameters = new List <DbParameter>();
parameters.Add(QueryService.AddInParameter("@UserID", SqlDbType.Int, 0, EmployeeId));
parameters.Add(QueryService.AddInParameter("@BusinessProperty", SqlDbType.Int, 0, 2));
parameters.Add(QueryService.AddInParameter("@ReturnType", SqlDbType.Int, 0, 0));//集合 //字符串
DataTable tableClient = QueryService.ExecuteDataTable("[dbo].[proc_Authority_UserBusiness]", parameters);
string strSql = @" SELECT * FROM CO_Business WHERE BusinessProperty = 3 ";
DataTable tableLogistics = QueryService.ExecuteDataTable(strSql);
//供应商
if (tableSupplier != null && tableSupplier.Rows.Count > 0)
{
foreach (DataRow row in tableSupplier.Rows)
{
bussIDs += row["ID"] + ",";
}
}
//客户
if (tableClient != null && tableClient.Rows.Count > 0)
{
foreach (DataRow row in tableClient.Rows)
{
bussIDs += row["ID"] + ",";
}
}
//物流
if (tableLogistics != null && tableLogistics.Rows.Count > 0)
{
foreach (DataRow row in tableLogistics.Rows)
{
bussIDs += row["ID"] + ",";
}
}
if (string.IsNullOrEmpty(bussIDs))
{
return(" ( -1 ) ");
}
return("( " + bussIDs.Substring(0, bussIDs.Length - 1) + " )");
}
catch (Exception ex)
{
WriteExceptionLog(ex);
return("( -1 )");
}
}