/// <summary>
/// 获取数据变更痕迹数据
/// </summary>
/// <param name="info">变更痕迹</param>
/// <returns>变更痕迹</returns>
public DataMark GetInfo(DataMark info, ref DataTable columnDt)
{
StringBuilder sqlBuilder = new StringBuilder();
List <DataParameter> parameters = new List <DataParameter>();
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sqlBuilder.Append("SELECT T1.MARKID,T1.OPERATETIME,T2.USERDES AS OPERATEUSER,T1.OPERATETYPE,T1.DATAKIND,T3.COMMENTS AS DATAKINDDES,T1.OriginalData,T1.ChangedData ");
sqlBuilder.Append("FROM T_BD_DATAMARK T1 ");
sqlBuilder.Append("left JOIN T_QM_USERINFO T2 ON t1.OPERATEUSER=T2.USERID ");
sqlBuilder.Append("left JOIN ALL_TAB_COMMENTS T3 ON T3.OWNER='PLP' AND T1.DATAKIND=T3.TABLE_NAME ");
sqlBuilder.Append("WHERE T1.MARKID=:MARKID");
//获取变更痕迹信息
info = session.Get <DataMark>(sqlBuilder.ToString(), new DataParameter("MARKID", info.MARKID));
//获取字段描述信息
if (columnDt != null)
{
sqlBuilder.Clear();
sqlBuilder.Append("SELECT T1.COLUMN_NAME AS COLUMNNAME, T1.COMMENTS AS COLUMNDES ");
sqlBuilder.Append("FROM USER_COL_COMMENTS T1, ALL_TAB_COMMENTS T2 ");
sqlBuilder.Append("WHERE T1.TABLE_NAME = T2.TABLE_NAME AND T1.TABLE_NAME = :TABLENAME");
parameters.Add(new DataParameter("TABLENAME", info.DATAKIND));
session.FillTable(columnDt, sqlBuilder.ToString(), parameters.ToArray());
}
}
return(info);
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 获取用户和密码是否正确
/// </summary>
/// <param name="user">条件</param>
/// <returns>用户信息</returns>
public LoginInfo IsLogin(LoginInfo login)
{
StringBuilder sqlBuilder = new StringBuilder();
DataTable powerDt = new DataTable();
List <DataParameter> parameters = new List <DataParameter>();
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取用户信息
sqlBuilder.Append(" SELECT * ");
sqlBuilder.Append(" FROM T_USER AS A WHERE LoginUserID = @LoginUserID AND PASSWORD = @PASSWORD ");
if (login.LoginUserID != "admin")
{
sqlBuilder.Append(" AND ISSTOP='0' ");
}
parameters.Add(new DataParameter {
ParameterName = "LoginUserID", DataType = DbType.String, Value = login.LoginUserID
});
parameters.Add(new DataParameter {
ParameterName = "PASSWORD", DataType = DbType.String, Value = login.PassWord
});
login = session.Get <LoginInfo>(sqlBuilder.ToString(), parameters.ToArray());
if (login != null)
{
//获取用户权限
sqlBuilder.Clear();
sqlBuilder.Append(@"
SELECT T1.AUTHORITYID FROM T_ROLEAUTHORITY T1
INNER JOIN T_USERROLE T2 ON T1.ROLEID = T2.ROLEID
WHERE T2.USERID = @USERID
UNION
SELECT AUTHORITYID FROM T_USERAUTHORITY
WHERE USERID = @USERID");
parameters.Clear();
parameters.Add(new DataParameter("USERID", login.UserID));
session.FillTable(powerDt, sqlBuilder.ToString(), parameters.ToArray());
login.Powers = new List <string>();
foreach (DataRow row in powerDt.Rows)
{
login.Powers.Add(row["AUTHORITYID"].ToString());
}
//获取用户所属的组织机构
sqlBuilder.Clear();
sqlBuilder.Append(" SELECT * ");
sqlBuilder.Append(" FROM T_USERORGAIZATION AS A WHERE USERID = @USERID");
parameters.Clear();
parameters.Add(new DataParameter {
ParameterName = "USERID", DataType = DbType.String, Value = login.UserID
});
}
}
return(login);
}
catch (Exception ex)
{
throw;
}
}