/// <summary>
/// 获得不允许登录IP范围列表
/// </summary>
/// <param name="where">条件</param>
/// <returns></returns>
public IList GetIPBlacklist()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM BPMS_IPBlacklist WHERE 1=1");
strSql.Append(" AND Enabled =1 ");
strSql.Append(" AND Failuretime >= @Failuretime ");
SqlParam[] param =
{
new SqlParam("@Failuretime", DbType.DateTime, DateTime.Now)
};
return(DataFactory.SqlHelper().GetDataListBySQL <BPMS_IPBlacklist>(strSql, param));
}
/// <summary>
/// 接口参数列表
/// </summary>
/// <param name="InterfaceId">接口主键</param>
/// <returns></returns>
public IList GetListDetails(string InterfaceId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM BASE_InterfaceManageDetails WHERE 1=1");
strSql.Append(" AND InterfaceId = @InterfaceId");
strSql.Append(" ORDER BY SortCode");
SqlParam[] param =
{
new SqlParam("@InterfaceId", InterfaceId)
};
return(DataFactory.SqlHelper().GetDataListBySQL <BASE_InterfaceManageDetails>(strSql, param));
}
/// <summary>
/// 写入更新操作日志
/// </summary>
/// <param name="oldObj">旧实体对象</param>
/// <param name="newObj">新实体对象</param>
/// <param name="CreateUserId">创建用户主键</param>
/// <param name="CreateUserName">创建用户</param>
/// <param name="busingessName">业务名称</param>
/// <param name="Result">操作业务把结果记录起来</param>
/// <returns></returns>
public void UpdateTaskLog <T>(T oldObj, T newObj, string CreateUserId, string CreateUserName, string busingessName = "", string Result = "")
{
try
{
List <StringBuilder> ListSql = new List <StringBuilder>();
List <object> ListParam = new List <object>();
Type objTye = typeof(T);
BPMS_SysLogs SysLog = new BPMS_SysLogs();
SysLog.SyslogsId = CommonHelper.GetGuid;
SysLog.TableName = newObj.ToString();
if (busingessName == "")
{
busingessName = GetBusingessName <T>();
}
SysLog.BusinessName = busingessName;
SysLog.OperationIp = RequestHelper.GetIPAddress();
SysLog.CreateUserId = CreateUserId;
SysLog.CreateUserName = CreateUserName;
SysLog.Result = Result;
SysLog.OperationType = (int)OperationType.Update;
PropertyInfo property = objTye.GetProperty(GetKeyField(objTye).ToString());
SysLog.Object_ID = property.GetValue(newObj, null).ToString();
ListSql.Add(DbCommon.InsertSql(SysLog));
ListParam.Add(DbCommon.GetParameter(SysLog));
//添加日志详细信息
foreach (PropertyInfo pi in objTye.GetProperties())
{
object oldVal = pi.GetValue(oldObj, null);
object newVal = pi.GetValue(newObj, null);
if (!Equals(oldVal, newVal))
{
if (oldVal != null && newVal != null)
{
BPMS_SysLogDetails SysLogDetails = new BPMS_SysLogDetails();
SysLogDetails.SysLogDetailsId = CommonHelper.GetGuid;
SysLogDetails.SyslogsId = SysLog.SyslogsId;
SysLogDetails.FieldName = GetFieldText(pi);
SysLogDetails.FieldText = pi.Name;
SysLogDetails.NewValue = "" + newVal + "";
SysLogDetails.OldValue = "" + oldVal + "";
ListSql.Add(DbCommon.InsertSql(SysLogDetails));
ListParam.Add(DbCommon.GetParameter(SysLogDetails));
}
}
}
DataFactory.SqlHelper().BatchExecuteBySql(ListSql.ToArray(), ListParam.ToArray());
}
finally
{
}
}
/// <summary>
/// 恢复数据库
/// </summary>
/// <param name="dbName">数据库名</param>
/// <param name="dbFileName">路经包括盘符和文件名以及扩展名称一般为“_dat”</param>
public int RestoreDatabase(string dbName, string dbFileName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("USE master ");
strSql.Append(" GO ");
strSql.Append("restore database @dbName from disk='@dbFileName' WITH REPLACE,RECOVERY");
SqlParam[] param =
{
new SqlParam("@dbName", dbName),
new SqlParam("@dbFileName", dbFileName)
};
return(DataFactory.SqlHelper().ExecuteBySqlNotTran(strSql, param));
}
/// <summary>
/// 验证是否有效用户可以访问接口
/// </summary>
/// <param name="AuthorizationUserId"></param>
/// <returns></returns>
public int IsEnabled(string AuthorizationUserId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT COUNT(1)
FROM BPMS_InterfaceAccess
WHERE AuthorizationUserId = @AuthorizationUserId
AND GETDATE() BETWEEN StartDate AND EndDate AND Enabled=1");
SqlParam[] param =
{
new SqlParam("@AuthorizationUserId", AuthorizationUserId)
};
return(CommonHelper.GetInt(DataFactory.SqlHelper().GetObjectValue(strSql, param)));
}
/// <summary>
/// 获得数据列表(带条件)
/// </summary>
/// <param name="where">条件</param>
/// <param name="param">参数化</param>
/// <returns></returns>
public DataTable GetListWhere(StringBuilder where, SqlParam[] param)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT
B.ButtonId ,
B.FullName ,
B.Img ,
B.Category,
B.Description,
ISNULL(S.CreateDate,GETDATE()+1) AS IsExist
FROM BPMS_Button B
LEFT JOIN BPMS_SysMenuButton S ON B.ButtonId = S.ButtonId AND 1=1");
strSql.Append(where);
strSql.Append(" ORDER BY IsExist,S.SortCode ,B.SortCode");
return(DataFactory.SqlHelper().GetDataTableBySQL(strSql, param));
}
/// <summary>
/// 获取 所有 模块菜单权限
/// </summary>
/// <param name="UserId">用户主键</param>
/// <returns></returns>
public IList GetModulePermission()
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT MenuId ,
ParentId ,
FullName ,
Description ,
Img ,
NavigateUrl ,
FormName ,
Target ,
IsUnfold
FROM BPMS_SysMenu
ORDER BY SortCode");
return(DataFactory.SqlHelper().GetDataListBySQL <BPMS_ModulePermission>(strSql));
}
/// <summary>
/// 得到一个对象IList
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public IList GetIListById(string KeyValue)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT *
FROM ( SELECT U.UserId ,
U.Code ,
U.Account ,
U.RealName ,
U.Gender ,
U.Email ,
U.Mobile ,
U.OICQ ,
U.Birthday,
U.Telephone,
I.ItemName AS DutyId ,
IA.ItemName AS TitleId ,
U.Enabled ,
U.SortCode ,
ORG_C.FullName AS CompanyId,
ORG_D.FullName AS DepartmentId ,
ORG_W.FullName AS WorkgroupId ,
U.Spell ,
U.LogOnCount ,
U.LastVisit ,
U.Description,
R.FullName AS RoleId
FROM BPMS_User U
LEFT JOIN BPMS_ItemDetails I ON U.DutyId = I.ItemCode
AND I.ItemsId = '137a2d97-d1d9-4752-9c5e-239097e2ed68'
LEFT JOIN BPMS_ItemDetails IA ON U.TitleId = IA.ItemCode
AND IA.ItemsId = '2acba9e8-5fa7-4b6f-8ebd-56e753dd059a'
LEFT JOIN BPMS_Roles R ON R.RoleId = U.RoleId
LEFT JOIN BPMS_Organization ORG_C ON ORG_C.OrganizationId = U.CompanyId
LEFT JOIN BPMS_Organization ORG_D ON ORG_D.OrganizationId = U.DepartmentId
LEFT JOIN BPMS_Organization ORG_W ON ORG_W.OrganizationId = U.WorkgroupId
) A
WHERE 1 = 1");
strSql.Append(" AND UserId = @UserId");
SqlParam[] param =
{
new SqlParam("@UserId", KeyValue)
};
return(DataFactory.SqlHelper().GetDataListBySQL <BPMS_User>(strSql, param));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public BPMS_DataPermission GetEntity(StringBuilder where, SqlParam[] param)
{
BPMS_DataPermission entity = new BPMS_DataPermission();
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM BPMS_DataPermission WHERE 1=1");
strSql.Append(where);
DataTable dt = DataFactory.SqlHelper().GetDataTableBySQL(strSql, param);
if (dt.Rows.Count > 0)
{
return(DbReader.ReaderToModel <BPMS_DataPermission>(dt.Rows[0]));
}
else
{
return(entity);
}
}
/// <summary>
/// 获取 所有 按钮权限
/// </summary>
/// <returns></returns>
public IList GetButtonPermission()
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT MB.MenuId ,
B.ButtonId ,
B.FullName ,
B.Img ,
B.Event ,
B.Control_ID ,
B.Category ,
B.Split ,
B.Description
FROM BPMS_SysMenuButton MB
LEFT JOIN BPMS_Button B ON B.ButtonId = MB.ButtonId
ORDER BY MB.CreateDate");
return(DataFactory.SqlHelper().GetDataListBySQL <BPMS_ButtonPermission>(strSql));
}
/// <summary>
/// 删除角色成员
/// </summary>
/// <param name="RoleId">角色主键</param>
/// <param name="KeyValue">要删除值</param>
/// <returns></returns>
public int BatchDeleteMember(string RoleId, string[] KeyValue)
{
StringBuilder[] sqls = new StringBuilder[KeyValue.Length];
object[] objs = new object[KeyValue.Length];
int index = 0;
foreach (string item in KeyValue)
{
if (item.Length > 0)
{
Hashtable ht = new Hashtable();
ht["RoleId"] = RoleId;
ht["UserId"] = item;
sqls[index] = DbCommon.DeleteSql("BPMS_UserRole", ht);
objs[index] = DbCommon.GetParameter(ht);
index++;
}
}
return(DataFactory.SqlHelper().BatchExecuteBySql(sqls, objs));
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <param name="UserId">用户主键</param>
/// <returns></returns>
public IList GetList(string UserId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT M.MenuId ,
M.Code ,
M.FullName ,
M.Description ,
M.Img ,
M.NavigateUrl
FROM BPMS_Shortcut S
LEFT JOIN BPMS_SysMenu M ON S.MenuId = M.MenuId
WHERE 1=1 AND UserId = @UserId");
strSql.Append(" ORDER BY S.CreateDate");
SqlParam[] param =
{
new SqlParam("@UserId", UserId)
};
return(DataFactory.SqlHelper().GetDataListBySQL <BPMS_ModulePermission>(strSql, param));
}
/// <summary>
/// 用户分配角色列表，
/// </summary>
/// <param name="UserId">用户主键</param>
/// <returns></returns>
public DataTable GetUserRoleList(string UserId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT
R.RoleId ,
R.FullName ,
R.Description,
R.OrganizationId,
UR.RoleId AS IsExist
FROM BPMS_Roles R
LEFT JOIN BPMS_UserRole UR ON R.RoleId = UR.RoleId AND 1=1");
strSql.Append(" AND UserId =@UserId");
strSql.Append(" ORDER BY R.SortCode");
SqlParam[] param =
{
new SqlParam("@UserId", UserId)
};
return(DataFactory.SqlHelper().GetDataTableBySQL(strSql, param));
}
/// <summary>
/// 获得数据列表(带条件)
/// </summary>
/// <param name="where">条件</param>
/// <param name="param">参数化</param>
/// <returns></returns>
public IList GetListWhere(StringBuilder where, SqlParam[] param)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT * FROM
( SELECT R.RoleId ,
R.Code ,
R.OrganizationId,
R.FullName ,
I.ItemName AS Category ,
R.Description ,
R.AllowEdit ,
R.AllowDelete ,
R.Enabled
FROM BPMS_Roles R
LEFT JOIN BPMS_ItemDetails I ON R.Category = I.ItemCode
WHERE I.ItemsId = '5fed1313-7355-4cc4-a7ec-73211a361fa6'
)A WHERE 1=1");
strSql.Append(where);
return(DataFactory.SqlHelper().GetDataListBySQL <BPMS_Roles>(strSql, param));
}
/// <summary>
/// 根据用户查询 拥有角色列表
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public IList GetUserRoleListByUserId(string UserId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT R.RoleId ,
R.Code ,
R.FullName ,
I.ItemName AS Category ,
R.Description
FROM BPMS_UserRole UR
LEFT JOIN BPMS_Roles R ON R.RoleId = UR.RoleId
LEFT JOIN BPMS_ItemDetails I ON R.Category = I.ItemCode
AND I.ItemsId = '5fed1313-7355-4cc4-a7ec-73211a361fa6'
WHERE 1 = 1");
strSql.Append(" AND UserId = @UserId");
SqlParam[] param =
{
new SqlParam("@UserId", UserId)
};
return(DataFactory.SqlHelper().GetDataListBySQL <BPMS_Roles>(strSql, param));
}
/// <summary>
/// 加载所有数据表
/// </summary>
/// <param name="DB">库名</param>
/// <returns></returns>
public DataTable InitDBName(string DB)
{
StringBuilder strSql = new StringBuilder(@"SELECT ID = D.ID ,
Field = CASE WHEN A.COLORDER = 1 THEN D.NAME
ELSE ''
END ,
Remark = CASE WHEN A.COLORDER = 1 THEN ISNULL(F.VALUE, '')
ELSE ''
END ,
ParentID = 0 ,
colorder = 0
FROM SYSCOLUMNS A
LEFT JOIN SYSTYPES B ON A.XUSERTYPE = B.XUSERTYPE
INNER JOIN SYSOBJECTS D ON A.ID = D.ID
AND D.XTYPE = 'U'
AND D.NAME <> 'DTPROPERTIES'
LEFT JOIN sys.extended_properties F ON D.ID = F.major_id
WHERE a.COLORDER = 1
AND F.minor_id = 0");
return(DataFactory.SqlHelper().GetDataTableBySQL(strSql));
}
/// <summary>
/// 获取 角色，用户 模块菜单权限
/// </summary>
/// <param name="UserId">用户主键</param>
/// <returns></returns>
public IList GetModulePermission(string UserId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT UM.UserId ,
UM.MenuId ,
SM.ParentId ,
SM.FullName ,
SM.Description ,
SM.Img ,
SM.NavigateUrl ,
SM.FormName ,
SM.Target ,
SM.IsUnfold
FROM BPMS_SysMenu SM
INNER JOIN ( SELECT UR.UserId AS UserId ,
RM.MenuId AS MenuId
FROM BPMS_RoleMenu RM
INNER JOIN BPMS_UserRole UR ON RM.RoleId = UR.RoleId
UNION
SELECT UserId ,
MenuId
FROM BPMS_UserMenu
UNION
SELECT U.UserId ,
RM.MenuId
FROM BPMS_User U
LEFT JOIN BPMS_RoleMenu RM ON U.RoleId = RM.RoleId
WHERE U.UserId = @UserId
) UM ON SM.MenuId = UM.MenuId
WHERE UM.UserId = @UserId AND SM.Enabled = 1
ORDER BY SM.SortCode");
SqlParam[] param =
{
new SqlParam("@UserId", UserId)
};
return(DataFactory.SqlHelper().GetDataListBySQL <BPMS_ModulePermission>(strSql, param));
}
/// <summary>
/// 获得数据列表(带条件)
/// </summary>
/// <param name="where">条件</param>
/// <param name="param">参数化</param>
/// <returns></returns>
public IList GetListWhere(StringBuilder where, SqlParam[] param)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT M.MenuId ,
M.ParentId ,
M.Code ,
M.FullName ,
M.Description ,
M.Img ,
M.NavigateUrl ,
M.FormName ,
M.Target ,
M.IsUnfold ,
M.Enabled ,
M.SortCode ,
MA.FullName AS Category
FROM BPMS_SysMenu M
LEFT JOIN BPMS_SysMenu MA ON MA.MenuId = M.ParentId WHERE 1=1");
strSql.Append(where);
strSql.Append(" Order BY SortCode");
return(DataFactory.SqlHelper().GetDataListBySQL <BPMS_SysMenu>(strSql, param));
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <param name="RoleId">角色主键</param>
/// <returns></returns>
public DataTable GetList(string RoleId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT B.ButtonId ,
B.FullName ,
B.Img ,
B.Description ,
MB.MenuId ,
B.Category ,
RMB.RoleMenuButtonId AS IsExist
FROM BPMS_SysMenuButton MB
LEFT JOIN BPMS_Button B ON B.ButtonId = MB.ButtonId
LEFT JOIN BPMS_RoleMenuButton RMB ON RMB.ButtonId = B.ButtonId
AND RMB.MenuId = MB.MenuId AND 1=1
AND RMB.RoleId = @RoleId " );
strSql.Append(" ORDER BY MB.SortCode");
SqlParam[] param =
{
new SqlParam("@RoleId", RoleId)
};
return(DataFactory.SqlHelper().GetDataTableBySQL(strSql, param));
}
/// <summary>
/// 批量添加角色成员
/// </summary>
/// <param name="KeyValue">主键值</param>
/// <param name="RoleId">角色主键</param>
/// <param name="CreateUserId">操作用户主键</param>
/// <param name="CreateUserName">操作用户</param>
/// <returns></returns>
public int BatchAddMember(string[] KeyValue, string RoleId, string CreateUserId, string CreateUserName)
{
StringBuilder[] sqls = new StringBuilder[KeyValue.Length];
object[] objs = new object[KeyValue.Length];
int index = 0;
foreach (string item in KeyValue)
{
if (item.Length > 0)
{
BPMS_UserRole entity = new BPMS_UserRole();
entity.UserRoleId = CommonHelper.GetGuid;
entity.RoleId = RoleId;
entity.UserId = item;
entity.CreateUserId = CreateUserId;
entity.CreateUserName = CreateUserName;
sqls[index] = DbCommon.InsertSql(entity);
objs[index] = DbCommon.GetParameter(entity);
index++;
}
}
return(DataFactory.SqlHelper().BatchExecuteBySql(sqls, objs));
}
/// <summary>
/// 删除一条数据
/// </summary>
/// <param name="KeyValue">主键</param>
/// <param name="UserId">用户主键</param>
/// <returns></returns>
public int Delete(string KeyValue, string UserId)
{
#region 获取旧值
var oldEntity = this.GetEntity(KeyValue);
#endregion
StringBuilder strSql = new StringBuilder();
strSql.Append(@"DELETE FROM BPMS_Shortcut WHERE 1=1");
strSql.Append(" AND MenuId = @MenuId");
strSql.Append(" AND UserId = @UserId");
SqlParam[] param =
{
new SqlParam("@MenuId", KeyValue),
new SqlParam("@UserId", UserId)
};
int IsOk = DataFactory.SqlHelper().ExecuteBySql(strSql, param);
#region 写日操作日志
if (IsOk > 0)
{
BPMS_SysLogDAL.Instance.DeleteTaskLog <BPMS_Shortcut>(oldEntity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName);
}
#endregion
return(IsOk);
}
/// <summary>
/// 获得数据列表(带条件)
/// </summary>
/// <param name="RoleId">角色主键</param>
/// <returns></returns>
public DataTable GetList(string RoleId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT
M.MenuId,
M.Code ,
M.FullName ,
M.Img ,
M.Category,
M.Description,
M.SortCode,
M.ParentId,
R.MenuId AS IsExist
FROM BPMS_SysMenu M
LEFT JOIN BPMS_RoleMenu R ON M.MenuId = R.MenuId AND 1=1");
strSql.Append(" AND RoleId = @RoleId");
strSql.Append(" ORDER BY M.SortCode");
SqlParam[] param =
{
new SqlParam("@RoleId", RoleId)
};
return(DataFactory.SqlHelper().GetDataTableBySQL(strSql, param));
}
/// <summary>
/// 清除所有操作日志
/// </summary>
public int RemoveAllLog()
{
StringBuilder strSql = new StringBuilder("DELETE FROM BPMS_SysLogs");
return(DataFactory.SqlHelper().ExecuteBySql(strSql));
}
/// <summary>
/// 获取 角色，用户 按钮权限
/// </summary>
/// <param name="UserId">用户主键</param>
/// <returns></returns>
public IList GetButtonPermission(string UserId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT BID.UserId ,
BID.MenuId ,
BID.ButtonId ,
B.FullName ,
B.Img ,
B.Event ,
B.Control_ID ,
B.Category ,
B.Split ,
B.Description,
MB.SortCode
FROM BPMS_Button B
INNER JOIN ( SELECT UR.UserId AS UserId ,
RMB.MenuId AS MenuId ,
RMB.ButtonId AS ButtonId
FROM BPMS_UserRole UR
INNER JOIN BPMS_RoleMenuButton RMB ON UR.RoleId = RMB.RoleId
GROUP BY RMB.MenuId ,
RMB.ButtonId ,
UR.UserId
UNION
SELECT UM.UserId AS UserId ,
UM.MenuId AS MenuId ,
UMB.ButtonId AS ButtonId
FROM BPMS_UserMenu UM
INNER JOIN BPMS_UserMenuButton UMB ON UM.MenuId = UMB.MenuId
GROUP BY UM.UserId ,
UM.MenuId ,
UMB.ButtonId
UNION
SELECT U.UserId ,
RMB.MenuId ,
RMB.ButtonId
FROM BPMS_User u
INNER JOIN BPMS_RoleMenuButton RMB ON u.RoleId = RMB.RoleId
WHERE U.UserId = @UserId
) BID ON B.ButtonId = BID.ButtonId
INNER JOIN BPMS_SysMenuButton MB ON BID.MenuId = MB.MenuId
AND BID.ButtonId = MB.ButtonId
WHERE BID.UserId = @UserId AND B.Enabled = 1
GROUP BY BID.UserId ,
BID.MenuId ,
BID.ButtonId ,
B.FullName ,
B.Img ,
B.Event ,
B.Control_ID ,
B.Category ,
B.Split ,
B.Description ,
MB.SortCode
ORDER BY MB.SortCode");
SqlParam[] param =
{
new SqlParam("@UserId", UserId)
};
return(DataFactory.SqlHelper().GetDataListBySQL <BPMS_ButtonPermission>(strSql, param));
}
/// <summary>
/// 获取表空间使用情况
/// </summary>
/// <returns></returns>
public DataTable GetSpaceCase()
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"DECLARE @TableInfo TABLE
(
name VARCHAR(50) ,
[rows] CHAR(11) ,
reserved VARCHAR(50) ,
data VARCHAR(50) ,
index_size VARCHAR(50) ,
unused VARCHAR(50)
)
DECLARE @TableName TABLE ( name VARCHAR(50) )
DECLARE @name VARCHAR(50)
INSERT INTO @TableName
( name
)
SELECT o.name
FROM sysobjects o ,
sysindexes i
WHERE o.id = i.id
AND o.Xtype = 'U'
AND i.indid < 2
ORDER BY i.rows DESC ,
o.name
WHILE EXISTS ( SELECT 1
FROM @TableName )
BEGIN
SELECT TOP 1
@name = name
FROM @TableName
DELETE @TableName WHERE name=@name
INSERT INTO @TableInfo
( name ,
[rows] ,
reserved ,
data ,
index_size ,
unused
)
EXEC sys.sp_spaceused @name
END
SELECT F.*,p.tdescription FROM @TableInfo F LEFT JOIN (
SELECT name = CASE WHEN A.COLORDER = 1 THEN D.NAME
ELSE ''
END ,
tdescription = CASE WHEN A.COLORDER = 1 THEN ISNULL(F.VALUE, '')
ELSE ''
END
FROM SYSCOLUMNS A
LEFT JOIN SYSTYPES B ON A.XUSERTYPE = B.XUSERTYPE
INNER JOIN SYSOBJECTS D ON A.ID = D.ID
AND D.XTYPE = 'U'
AND D.NAME <> 'DTPROPERTIES'
LEFT JOIN sys.extended_properties F ON D.ID = F.major_id
WHERE a.COLORDER = 1
AND F.minor_id = 0
)P ON F.name=p.name");
return(DataFactory.SqlHelper().GetDataTableBySQL(strSql));
}
/// <summary>
/// 批量新增 接口，接口参数
/// </summary>
/// <param name="InterfaceFrom">接口配置</param>
/// <param name="InterfaceDetailsFrom">接口参数明细</param>
/// <param name="key">主键</param>
/// <returns></returns>
public int AddInterfaceManage(object[] InterfaceFrom, object[] InterfaceDetailsFrom, string key)
{
try
{
StringBuilder[] sqls = new StringBuilder[InterfaceDetailsFrom.Length + 2];
object[] objs = new object[InterfaceDetailsFrom.Length + 2];
Hashtable ht_Interface = new Hashtable();
foreach (string item in InterfaceFrom)
{
if (item.Length > 0)
{
string[] str_item = item.Split('☻');
ht_Interface[str_item[0]] = str_item[1];
}
}
if (!string.IsNullOrEmpty(key))
{
ht_Interface["InterfaceId"] = key;
ht_Interface["ModifyDate"] = DateTime.Now;
ht_Interface["ModifyUserId"] = RequestSession.GetSessionUser().UserId;
ht_Interface["ModifyUserName"] = RequestSession.GetSessionUser().UserName;
}
else
{
ht_Interface["InterfaceId"] = CommonHelper.GetGuid;
ht_Interface["CreateUserId"] = RequestSession.GetSessionUser().UserId;
ht_Interface["CreateUserName"] = RequestSession.GetSessionUser().UserName;
}
sqls[0] = !string.IsNullOrEmpty(key) ? DbCommon.UpdateSql("BASE_InterfaceManage", "InterfaceId", ht_Interface) : DbCommon.InsertSql("BASE_InterfaceManage", ht_Interface);
objs[0] = DbCommon.GetParameter(ht_Interface);
sqls[1] = DbCommon.DeleteSql("BASE_InterfaceManageDetails", "InterfaceId");
objs[1] = new SqlParam[] { new SqlParam("@InterfaceId", key) };
int index = 2;
foreach (string item in InterfaceDetailsFrom)
{
if (item.Length > 0)
{
Hashtable ht_InterfaceDetails = new Hashtable();
foreach (string itemwithin in item.Split('☺'))
{
if (itemwithin.Length > 0)
{
string[] str_item = itemwithin.Split('☻');
ht_InterfaceDetails[str_item[0]] = str_item[1];
if (str_item[0].ToString() == "FieldMinLength")
{
ht_InterfaceDetails[str_item[0]] = str_item[1] == "true" ? 0 : 1;
}
if (str_item[0].ToString() == "Enabled")
{
ht_InterfaceDetails[str_item[0]] = str_item[1] == "true" ? 0 : 1;
}
}
}
ht_InterfaceDetails["InterfaceDetailsId"] = CommonHelper.GetGuid;
ht_InterfaceDetails["InterfaceId"] = ht_Interface["InterfaceId"];
sqls[index] = DbCommon.InsertSql("BASE_InterfaceManageDetails", ht_InterfaceDetails);;
objs[index] = DbCommon.GetParameter(ht_InterfaceDetails);
index++;
}
}
return(DataFactory.SqlHelper().BatchExecuteBySql(sqls, objs));
}
catch
{
return(-1);
}
}