public string GetTopFunctionList()
{
string sql = "SELECT * FROM dbo.FunctionList WHERE parentId IS NULL ORDER BY orderFlag";
IList <Function> TopFunctionList = new List <Function>();
using (DataTable table = SqlHelper.ExecuteDataset(CommonInfo.ConQJVRMS, CommandType.Text, sql).Tables[0])
{
foreach (DataRow row in table.Rows)
{
Function f = new Function();
f.Description = row["Description"].ToString();
f.FunctionName = row["FunctionName"].ToString();
f.UrlPath = row["UrlPath"].ToString();
f.FunctionID = new Guid(row["FunctionId"].ToString());
f.OrderFlag = int.Parse(row["orderFlag"].ToString());
if (row["parentid"] == DBNull.Value)
{
f.ParentFunctionId = null;
}
else
{
f.ParentFunctionId = new Guid(row["parentId"].ToString());
}
TopFunctionList.Add(f);
}
}
SerializeObjectFactory sof = new SerializeObjectFactory();
return(sof.SerializeToBase64(TopFunctionList));
}
public string AuthUserByAD(string domain, string loginfullName, string loginId, string password)
{
IADsUser adUser = null;
try
{
adUser = ADHelper.AuthenticateUser(domain, loginfullName, loginId, password);
User user = new User();
user.UserId = new Guid(adUser.GUID);
user.GroupId = Guid.NewGuid();
user.UserName = adUser.FullName;
user.GroupName = string.Empty;
user.IsDownLoad = string.Empty;
// returnObj = user;
SerializeObjectFactory sof = new SerializeObjectFactory();
return(sof.SerializeToBase64(user));
}
catch (Exception ex)
{
LogWriter.WriteExceptionLog(ex);
return(string.Empty);
}
}
public string GetFunctionList()
{
List <Function> FunctionListAll = new List <Function>();
using (DataTable table = SqlHelper.ExecuteDataset(CommonInfo.ConQJVRMS, CommandType.StoredProcedure, "Function_GetFunction").Tables[0])
{
foreach (DataRow row in table.Rows)
{
Function f = new Function();
f.Description = row["Description"].ToString();
f.FunctionName = row["FunctionName"].ToString();
f.UrlPath = row["UrlPath"].ToString();
f.FunctionID = new Guid(row["FunctionId"].ToString());
f.OrderFlag = int.Parse(row["orderFlag"].ToString());
if (row["parentid"] == DBNull.Value)
{
f.ParentFunctionId = null;
}
else
{
f.ParentFunctionId = new Guid(row["parentId"].ToString());
}
FunctionListAll.Add(f);
}
}
SerializeObjectFactory sof = new SerializeObjectFactory();
return(sof.SerializeToBase64(FunctionListAll));
}
public string AuthUserByForm(string loginName, string password, string IPAddress)
{
string encryptPassword = Encryption.Encrypt(password);
SqlParameter[] Parameters = new SqlParameter[4];
Parameters[0] = new SqlParameter("@loginName", SqlDbType.NVarChar);
Parameters[1] = new SqlParameter("@password", SqlDbType.VarChar, 50);
Parameters[2] = new SqlParameter("@IPAddress", SqlDbType.NVarChar, 15);
Parameters[3] = new SqlParameter("@IsValidated", SqlDbType.Bit);
Parameters[0].Value = loginName;
Parameters[1].Value = encryptPassword;
Parameters[2].Value = IPAddress;
Parameters[3].Direction = ParameterDirection.Output;
try
{
using (DataTable resTable = SqlHelper.ExecuteDataset(CommonInfo.ConQJVRMS, CommandType.StoredProcedure, "dbo.Users_ValidateUserAndGetUser", Parameters).Tables[0])
{
if (resTable.Rows.Count != 0)
{
if (!bool.Parse(Parameters[3].Value.ToString()))
{
return(null);
}
DataRow reader = resTable.Rows[0];
User user = new User();
user.UserId = new Guid(reader["UserId"].ToString());
user.GroupId = new Guid(reader["Groupid"].ToString());
user.UserName = reader["UserName"].ToString();
user.GroupName = reader["GroupName"].ToString();
user.IsDownLoad = reader["IsDownLoad"].ToString();
// returnObj = user;
SerializeObjectFactory sof = new SerializeObjectFactory();
return(sof.SerializeToBase64(user));
// return true;
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
LogWriter.WriteExceptionLog(ex);
return(null);
}
}
public string AuthClientUser(string loginName, string password)
{
string encryptPassword = Encryption.Encrypt(password);
string sql = "select UserId,UserName from Users"
+ " where loginName=@loginName and password = @password and IsLocked=0";
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = new SqlParameter("@loginName", SqlDbType.NVarChar);
Parameters[1] = new SqlParameter("@password", SqlDbType.VarChar, 50);
Parameters[0].Value = loginName;
Parameters[1].Value = encryptPassword;
try
{
using (DataTable resTable = SqlHelper.ExecuteDataset(CommonInfo.ConQJVRMS, CommandType.Text, sql, Parameters).Tables[0])
{
if (resTable.Rows.Count != 0)
{
DataRow reader = resTable.Rows[0];
User user = new User();
user.UserId = new Guid(reader["UserId"].ToString());
user.UserName = reader["UserName"].ToString();
SerializeObjectFactory sof = new SerializeObjectFactory();
Quanjing.Security.FTPInfo ftp = new Quanjing.Security.FTPInfo(CommonInfo.FtpAddress, CommonInfo.FtpUser, CommonInfo.FtpPwd, "");
ftp.SetUserId(user.UserId);
return(sof.SerializeToBase64(ftp));
// return true;
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
LogWriter.WriteExceptionLog(ex);
return(null);
}
}
public string CheckUsers(string domainName, string OU, string adminId, string adminPwd, string listUserStr)
{
List <User> userList = new List <User>();
SerializeObjectFactory sof = new SerializeObjectFactory();
try
{
List <string> userIdList = (List <string>)sof.DesializeFromBase64(listUserStr);
ADHelper.SearchUser(domainName, OU, adminId, adminPwd, userIdList, userList);
return(sof.SerializeToBase64(userList));
}
catch (Exception ex)
{
LogWriter.WriteExceptionLog(ex);
return(string.Empty);
}
}
public string CheckRules(string rulesStr)
{
SerializeObjectFactory sof = new SerializeObjectFactory();
StringBuilder sqlQuery = new StringBuilder();
List <ObjectRule> rules = null;
try
{
rules = (List <ObjectRule>)sof.DesializeFromBase64(rulesStr);
string sql = "CREATE TABLE #RuleList(ruleId uniqueidentifier);";
sqlQuery.Append(sql);
foreach (IRule rule in rules)
{
sqlQuery.Append(rule.GetSqlQuery());
}
sql = "select * from #RuleList";
sqlQuery.Append(sql);
using (DataTable dt = SqlHelper.ExecuteDataset(CommonInfo.ConQJVRMS, CommandType.Text, sqlQuery.ToString()).Tables[0])
{
foreach (IRule rule in rules)
{
DataRow[] rows = dt.Select("ruleId='" + rule.RuleId.ToString() + "'");
if (rows.Length > 0)
{
rule.IsValidate = true;
}
}
}
}
catch (Exception ex)
{
QJVRMS.Common.LogWriter.WriteExceptionLog(ex);
return(null);
}
return(sof.SerializeToBase64(rules));
}
public string GetUserById(Guid userId)
{
//string sql = "select * from Users where loginName=@loginName and IsLocked=0";
SqlParameter[] Parameters = new SqlParameter[1];
Parameters[0] = new SqlParameter("@userId", SqlDbType.UniqueIdentifier);
Parameters[0].Value = userId;
QJVRMS.Business.User user = null;
Guid groupId;
bool isLocked;
bool isIPValidate;
string loginName, UserName, Email, Telphone, isdownload, groupName;
DateTime createDate;
using (IDataReader reader = SqlHelper.ExecuteReader(CommonInfo.ConQJVRMS, CommandType.StoredProcedure, "dbo.Users_GetUserByUserId", Parameters))
{
if (!reader.Read())
{
throw new Exception("用户ID不存在!");
}
groupId = new Guid(reader["groupId"].ToString());
isLocked = bool.Parse(reader["IsLocked"].ToString());
isIPValidate = bool.Parse(reader["IsIPValidate"].ToString());
isdownload = reader["IsDownLoad"].ToString();
loginName = reader["logInName"].ToString();
UserName = reader["Username"].ToString();
groupName = reader["groupName"].ToString();
Email = reader["email"].ToString();
Telphone = reader["Tel"].ToString();
createDate = DateTime.Parse(reader["CreateDate"].ToString());
}
user = new User(loginName, UserName, userId, groupId, isLocked, Email, Telphone, createDate, isdownload, isIPValidate);
user.GroupName = groupName;
SerializeObjectFactory sof = new SerializeObjectFactory();
return(sof.SerializeToBase64(user));
}
public string GetUserByLoginName(string loginName)
{
string sql = " select u.*,g.GroupName from Users u,[Group] g where u.loginName=@loginName and u.groupId=g.groupId";
SqlParameter[] Parameters = new SqlParameter[1];
Parameters[0] = new SqlParameter("@loginName", SqlDbType.NVarChar);
Parameters[0].Value = loginName;
QJVRMS.Business.User user = null;
Guid groupId, UserId;
bool isLocked, isIPValidate;
string UserName, Email, Telphone, isdownload, groupName;
DateTime createDate;
using (IDataReader reader = SqlHelper.ExecuteReader(CommonInfo.ConQJVRMS, CommandType.Text, sql, Parameters))
{
if (!reader.Read())
{
throw new Exception("用户登录ID不存在!");
}
groupId = new Guid(reader["groupId"].ToString());
isLocked = bool.Parse(reader["IsLocked"].ToString());
isIPValidate = bool.Parse(reader["IsIPValidate"].ToString());
isdownload = reader["IsDownLoad"].ToString();
UserId = new Guid(reader["UserId"].ToString());
UserName = reader["Username"].ToString();
groupName = reader["groupName"].ToString();
Email = reader["email"].ToString();
Telphone = reader["Tel"].ToString();
createDate = DateTime.Parse(reader["CreateDate"].ToString());
}
user = new User(loginName, UserName, UserId, groupId, isLocked, Email, Telphone, createDate, isdownload, isIPValidate);
user.GroupName = groupName;
SerializeObjectFactory sof = new SerializeObjectFactory();
return(sof.SerializeToBase64(user));
}
public static List <User> CheckUsers(string domainName, string OU, string adminId, string adminPwd, List <string> userIdList)
{
List <User> userList = new List <User>();
// ADHelper.SearchUser(domainName, OU, adminId, adminPwd, userIdList, userList);
QJVRMS.Business.MemWS.MemberShipService mss = new QJVRMS.Business.MemWS.MemberShipService();
SerializeObjectFactory sof = new SerializeObjectFactory();
//System.Collections.ArrayList al = new System.Collections.ArrayList(userIdList.Count);
//foreach (string var in userIdList)
//{
// al.Add(var);
//}
string idString = sof.SerializeToBase64(userIdList);
string returnUserList = mss.CheckUsers(domainName, OU, adminId, adminPwd, idString);
object o = sof.DesializeFromBase64(returnUserList);
List <User> users = (List <User>)o;
//foreach (IADsUser adUser in adList)
//{
// User user = new User();
// user.Email = adUser.EmailAddress;
// user.UserLoginName = adUser.Name;
// user.UserId = new Guid(adUser.GUID);
// user.Telphone = adUser.TelephoneNumber.ToString();
// userList.Add(user);
//}
return(users);
}