/// <summary>
/// 添加登录日志
/// </summary>
/// <param name="Account">账户</param>
/// <param name="Status">登录状态</param>
/// <param name="IPAddress">IP地址</param>
/// <param name="IPAddressName">IP所在城市地址</param>
public void AddSysLoginLog(string Account, string Status, string IPAddress, string IPAddressName)
{
Hashtable ht = new Hashtable();
ht["SysLoginLogId"] = CommonHelper.GetGuid;
ht["Account"] = Account;
ht["Status"] = Status;
ht["IPAddress"] = IPAddress;
ht["IPAddressName"] = IPAddressName;
DataFactory.DbUtils().Insert("BPMS_SysLoginLog", ht);
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public int Insert(BPMS_AppendProperty entity)
{
int IsOk = DataFactory.DbUtils().Insert(entity);
#region 写日操作日志
if (IsOk > 0)
{
BPMS_SysLogDAL.Instance.AddTaskLog <BPMS_AppendProperty>(entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName);
}
#endregion
return(IsOk);
}
/// <summary>
/// 新建的项目数据，默认把数据权限设置了，，这样就别必要要去数据权限管理里面去打钩
/// </summary>
/// <param name="RoleId">角色</param>
/// <param name="ResourceId">对象</param>
/// <param name="key">数据ID</param>
/// <param name="UserId">当前用户</param>
/// <param name="key"></param>
public void AddItemDefault(string RoleId, string ResourceId, string key, string UserId)
{
Hashtable ht_Where = new Hashtable();
ht_Where["RoleId"] = RoleId;
ht_Where["ResourceId"] = ResourceId;
BPMS_DataPermission entity = DataFactory.DbUtils().GetModelById <BPMS_DataPermission>(ht_Where);
entity.ObjectId = entity.ObjectId + ",'" + key + "'";
int IsOk = DataFactory.DbUtils().Update(entity, "DataPermissionId");
CacheHelper.RemoveAllCache("Data" + UserId);
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public int Insert(BPMS_TableColumns entity)
{
entity.SortCode = CommonHelper.GetInt(this.GetMaxCode());
int IsOk = DataFactory.DbUtils().Insert(entity);
#region 写日操作日志
if (IsOk > 0)
{
BPMS_SysLogDAL.Instance.AddTaskLog <BPMS_TableColumns>(entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName);
}
#endregion
return(IsOk);
}
/// <summary>
/// 删除一条数据
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public int Delete(string KeyValue)
{
#region 获取旧值
var oldEntity = this.GetEntity(KeyValue);
#endregion
int IsOk = DataFactory.DbUtils().Delete("BPMS_TableColumns", "TableColumnsId", KeyValue);
#region 写日操作日志
if (IsOk > 0)
{
BPMS_SysLogDAL.Instance.DeleteTaskLog <BPMS_TableColumns>(oldEntity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName);
}
#endregion
return(IsOk);
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public int Update(BPMS_TableColumns entity)
{
#region 获取旧值
var oldEntity = this.GetEntity(BPMS_SysLogDAL.Instance.GetKeyFieldValue <BPMS_TableColumns>(entity).ToString());
#endregion
int IsOk = DataFactory.DbUtils().Update(entity, "TableColumnsId");
#region 写日操作日志
if (IsOk > 0)
{
BPMS_SysLogDAL.Instance.UpdateTaskLog <BPMS_TableColumns>(oldEntity, entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName);
}
#endregion
return(IsOk);
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public int Insert(BASE_File entity)
{
return(DataFactory.DbUtils().Insert(entity));
}
/// <summary>
/// 获取记录总数（带条件）
/// </summary>
/// <param name="where">条件</param>
/// <param name="param">参数化</param>
/// <returns></returns>
public int GetRecordCount(StringBuilder where, SqlParam[] param)
{
return(DataFactory.DbUtils().RecordCount("BASE_File", where, param));
}
/// <summary>
/// 获取最大编号
/// </summary>
/// <returns></returns>
public object GetMaxCode()
{
return(DataFactory.DbUtils().GetMax("BPMS_IPBlacklist", "SortCode"));
}
/// <summary>
/// 获取最大编号
/// </summary>
/// <param name="KeyValue">主键值</param>
/// <returns></returns>
public object GetMaxCode()
{
return(DataFactory.DbUtils().GetMax("BPMS_TableColumns", "SortCode"));
}
/// <summary>
/// 获取记录总数（带条件）
/// </summary>
/// <param name="where">条件</param>
/// <param name="param">参数化</param>
/// <returns></returns>
public int GetRecordCount(StringBuilder where, SqlParam[] param)
{
return(DataFactory.DbUtils().RecordCount("BPMS_TableColumns", where, param));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public BPMS_InterfaceAccess GetEntity(string KeyValue)
{
return(DataFactory.DbUtils().GetModelById <BPMS_InterfaceAccess>("IAccessId", KeyValue));
}
/// <summary>
/// 批量删除数据
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public int BatchDelete(string[] KeyValue)
{
return(DataFactory.DbUtils().BatchDelete("BPMS_TableColumns", "TableColumnsId", KeyValue));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="Code">接口编号</param>
/// <returns></returns>
public BASE_InterfaceManage GetEntityByCode(string Code)
{
return(DataFactory.DbUtils().GetModelById <BASE_InterfaceManage>("Code", Code));
}
/// <summary>
/// 批量删除数据
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public int BatchDelete(string[] KeyValue)
{
return(DataFactory.DbUtils().BatchDelete("BPMS_InterfaceAccess", "IAccessId", KeyValue));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public BASE_InterfaceManage GetEntity(string KeyValue)
{
return(DataFactory.DbUtils().GetModelById <BASE_InterfaceManage>("InterfaceId", KeyValue));
}
/// <summary>
/// 删除一条数据
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public int Delete(string KeyValue)
{
return(DataFactory.DbUtils().Delete("BASE_InterfaceManage", "InterfaceId", KeyValue));
}
/// <summary>
/// 批量删除数据
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public int BatchDelete(string[] KeyValue)
{
return(DataFactory.DbUtils().BatchDelete("BPMS_IPBlacklist", "IPBlacklistId", KeyValue));
}
/// <summary>
/// 批量删除数据
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public int BatchDelete(string[] KeyValue)
{
return(DataFactory.DbUtils().BatchDelete("BASE_File", "FileId", KeyValue));
}
/// <summary>
/// 获取最大编号
/// </summary>
/// <returns></returns>
public object GetMaxCode()
{
return(DataFactory.DbUtils().GetMax("BPMS_AppendProperty", "SortCode"));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public BASE_File GetEntity(string KeyValue)
{
return(DataFactory.DbUtils().GetModelById <BASE_File>("FileId", KeyValue));
}
/// <summary>
/// 获取记录总数
/// </summary>
/// <param name="KeyValue">主键值</param>
/// <returns></returns>
public int GetRecordCount(string KeyValue)
{
return(DataFactory.DbUtils().RecordCount("BPMS_Employee", "EmployeeId", KeyValue));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public BPMS_TableColumns GetEntity(string KeyValue)
{
return(DataFactory.DbUtils().GetModelById <BPMS_TableColumns>("TableColumnsId", KeyValue));
}
/// <summary>
/// 获取最大编号
/// </summary>
/// <returns></returns>
public object GetMaxCode()
{
return(DataFactory.DbUtils().GetMax("BPMS_Employee", "EmployeeId"));
}
/// <summary>
/// 获取记录总数
/// </summary>
/// <param name="KeyValue">主键值</param>
/// <returns></returns>
public int GetRecordCount(string KeyValue)
{
return(DataFactory.DbUtils().RecordCount("BPMS_TableColumns", "TableColumnsId", KeyValue));
}
/// <summary>
/// 获取最大编号
/// </summary>
/// <returns></returns>
public object GetMaxCode()
{
return(DataFactory.DbUtils().GetMax("BASE_File", "FileId"));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public BPMS_Employee GetEntity(string KeyValue)
{
return(DataFactory.DbUtils().GetModelById <BPMS_Employee>("EmployeeId", KeyValue));
}
/// <summary>
/// 获取记录总数
/// </summary>
/// <param name="KeyValue">主键值</param>
/// <returns></returns>
public int GetRecordCount(string KeyValue)
{
return(DataFactory.DbUtils().RecordCount("BASE_File", "FileId", KeyValue));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public BPMS_AppendProperty GetEntity(string KeyValue)
{
return(DataFactory.DbUtils().GetModelById <BPMS_AppendProperty>("PropertyId", KeyValue));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public BPMS_IPBlacklist GetEntity(string KeyValue)
{
return(DataFactory.DbUtils().GetModelById <BPMS_IPBlacklist>("IPBlacklistId", KeyValue));
}