///
/// 重新生成排序码
///
#region public int BatchSetSortCode(string[] ids) 重置排序码
/// <summary>
/// 重置排序码
/// </summary>
/// <param name="ids">主键数组</param>
/// <returns>影响行数</returns>
public int BatchSetSortCode(string[] ids)
{
int returnValue = 0;
BaseSequenceManager sequenceManager = new BaseSequenceManager(dbHelper);
string[] sortCodes = sequenceManager.GetBatchSequence(this.CurrentTableName, ids.Length);
for (int i = 0; i < ids.Length; i++)
{
returnValue += this.SetProperty(ids[i], new KeyValuePair <string, object>(BaseBusinessLogic.FieldSortCode, sortCodes[i]));
}
return(returnValue);
}
/// <summary>
/// 重新设置表的排序码
/// </summary>
/// <returns>影响行数</returns>
public virtual int ResetSortCode()
{
int returnValue = 0;
DataTable dataTable = this.GetDataTable(BaseBusinessLogic.FieldSortCode);
BaseSequenceManager sequenceManager = new BaseSequenceManager(dbHelper);
string[] sortCode = sequenceManager.GetBatchSequence(this.CurrentTableName, dataTable.Rows.Count);
int i = 0;
foreach (DataRow dataRow in dataTable.Rows)
{
returnValue += this.SetProperty(dataRow[BaseBusinessLogic.FieldId].ToString(), new KeyValuePair <string, object>(BaseBusinessLogic.FieldSortCode, sortCode[i]));
i++;
}
return(returnValue);
}
public int Grant(string[] userIds, string[] permissionItemIds)
{
int returnValue = 0;
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper);
string[] sequenceIds = sequenceManager.GetBatchSequence(BasePermissionEntity.TableName, userIds.Length * permissionItemIds.Length);
BasePermissionManager permissionManager = new BasePermissionManager(DbHelper, UserInfo, this.CurrentTableName);
for (int i = 0; i < userIds.Length; i++)
{
for (int j = 0; j < permissionItemIds.Length; j++)
{
this.Grant(permissionManager, sequenceIds[i * permissionItemIds.Length + j], userIds[i], permissionItemIds[j]);
returnValue++;
}
}
return returnValue;
}
/// <summary>
/// 获取序列号
/// </summary>
/// <param name="dbHelper">数据库连接</param>
/// <param name="userInfo">用户</param>
/// <param name="fullName">序列名称</param>
/// <param name="count">个数</param>
/// <returns>序列号</returns>
public string[] GetBatchSequence(IDbHelper dbHelper, BaseUserInfo userInfo, string fullName, int count)
{
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
BaseSequenceManager sequenceManager = new BaseSequenceManager(dbHelper);
return sequenceManager.GetBatchSequence(fullName, count);
}
/// <summary>
/// 重新设置表的排序码
/// </summary>
/// <returns>影响行数</returns>
public virtual int ResetSortCode()
{
int returnValue = 0;
DataTable dataTable = this.GetDataTable(BaseBusinessLogic.FieldSortCode);
BaseSequenceManager sequenceManager = new BaseSequenceManager(dbHelper);
string[] sortCode = sequenceManager.GetBatchSequence(this.CurrentTableName, dataTable.Rows.Count);
int i = 0;
foreach (DataRow dataRow in dataTable.Rows)
{
returnValue += this.SetProperty(dataRow[BaseBusinessLogic.FieldId].ToString(), new KeyValuePair<string, object>(BaseBusinessLogic.FieldSortCode, sortCode[i]));
i++;
}
return returnValue;
}
/// <summary>
/// 重置排序码
/// </summary>
/// <param name="ids">主键数组</param>
/// <returns>影响行数</returns>
public int BatchSetSortCode(string[] ids)
{
int returnValue = 0;
BaseSequenceManager sequenceManager = new BaseSequenceManager(dbHelper);
string[] sortCodes = sequenceManager.GetBatchSequence(this.CurrentTableName, ids.Length);
for (int i = 0; i < ids.Length; i++)
{
returnValue += this.SetProperty(ids[i], new KeyValuePair<string, object>(BaseBusinessLogic.FieldSortCode, sortCodes[i]));
}
return returnValue;
}
/// <summary>
/// 重置排序码
/// </summary>
/// <param name="parentId">父节点主键</param>
public int ResetSortCode(string parentId)
{
int returnValue = 0;
DataTable dataTable = this.GetDataTableByParent(parentId);
string id = string.Empty;
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper);
string[] sortCode = sequenceManager.GetBatchSequence(BaseModuleEntity.TableName, dataTable.Rows.Count);
int i = 0;
foreach (DataRow dataRow in dataTable.Rows)
{
id = dataRow[BaseModuleEntity.FieldId].ToString();
returnValue += this.SetProperty(id, new KeyValuePair<string, object>(BaseModuleEntity.FieldSortCode, sortCode[i]));
i++;
}
return returnValue;
}
