public string GetConnectString(string svrName, string account)
{
string result;
DBConnectionStringBuilder dbbuilder = new DBConnectionStringBuilder();
string pubConn = string.Empty;
string userConn = string.Empty;
if (string.IsNullOrWhiteSpace(svrName))
{
pubConn = dbbuilder.GetMainConnStringElement(0, out result, false);//取第一个（默认）服务器
}
else
{
pubConn = dbbuilder.GetMainConnStringElement(svrName, out result);
}
//数据库名不完整，缺少NG
if (account.Length > 0 && account.ToLower().IndexOf("ng") != 0)
{
account = "NG" + account;
}
userConn = dbbuilder.GetAccConnstringElement(svrName, account, pubConn, out result);
NG3.Data.Service.ConnectionInfoService.SetSessionConnectString(userConn);//初始化2.0的dbhelper
return(userConn);
}
/// <summary>
/// 构造函数
/// </summary>
public WorkFlowApiController()
{
//获取AppInfo值 头部信息记录
#region 设置当前线程数据库
var base64EncodedBytes = Convert.FromBase64String(HttpContext.Current.Request.Headers.GetValues("AppInfo").First());
var jsonText = Encoding.UTF8.GetString(base64EncodedBytes);
var AppInfo = JsonConvert.DeserializeObject <ApiControllerBase.Models.AppInfoBase>(jsonText);
if (AppInfo != null)
{
DBConnectionStringBuilder dbbuilder = new DBConnectionStringBuilder();
string result, userConn;
var pubConn = dbbuilder.GetMainConnStringElement(0, out result, false);
string defaultConn = dbbuilder.GetDefaultConnString();
if (AppInfo.DbName.ToLower() == "ngsoft")
{
userConn = pubConn;
}
else
{
userConn = string.IsNullOrWhiteSpace(AppInfo.DbName)
? defaultConn
: dbbuilder.GetAccConnstringElement(0, AppInfo.DbName, pubConn,
out result);
}
//设置当前数据库连接信息
ConnectionInfoService.SetCallContextConnectString(userConn);
MultiDelegatingDbProvider.CurrentDbProviderName = AppInfo.DbName;
}
#endregion
service = new WorkFlowServiceProxy();
}
public string GetAccList(string svrName)
{
DBConnectionStringBuilder dbbuilder = new DBConnectionStringBuilder();
string result;
string pubConnStr = dbbuilder.GetMainConnStringElement(svrName, out result);
//string sql = "select ucode,uname from ngusers order by ucode ";
string sql = "select dbname,uname from ngusers order by ucode ";
DataTable dt = NG3.Data.Service.DbHelper.GetDataTable(pubConnStr, sql);
foreach (DataRow dr in dt.Rows)
{
//dr["uname"] = dr["ucode"].ToString() + "-" + dr["uname"].ToString();
dr["uname"] = dr["dbname"].ToString() + "-" + dr["uname"].ToString();
}
//Ajax.WriteRaw(dt.ToJSON("ucode", "uname"));
string str = DataConverterHelper.ToJson(dt, dt.Rows.Count);
return(str);
//return this.Json(str, JsonRequestBehavior.AllowGet);
}
//初始化数据库
private void InitDb()
{
//数据库连接方式取值方法一：固定链接串
//string connectionString=@"ConnectType=SqlClient;Server=10.0.16.168\upty;Database=NG0054;User ID=sa;Password=123456";
//string connectionString = "ConnectType=SqlClient;Server=10.0.18.21;Database=NG0008;User ID=sa;Password="******"ConnectType=SqlClient;Server=10.0.17.118;Database=NG0004;User ID=sa;Password=psoft";
//二：从web.config取值
//string connectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
//三：从config目录下文件DataBases.xml中取值
DBConnectionStringBuilder dbbuilder = new DBConnectionStringBuilder();
//var userConn = dbbuilder.GetDefaultConnString(); //主帐套连接串
var result = string.Empty;
var dbname = dbbuilder.DefaultDB;
var pubConn = dbbuilder.GetMainConnStringElement(0, out result, false); //获取主数据库连接串 NGSoft
var userConn = dbbuilder.GetAccConnstringElement(0, dbname, pubConn, out result); //获取默认数据库连接串 NG0001
ConnectionInfoService.SetSessionConnectString(userConn);
I6WebAppInfo appInfo = new I6WebAppInfo();
appInfo.PubConnectString = pubConn;
appInfo.UserConnectString = userConn;
appInfo.LoginID = "xyp";
appInfo.UserName = "******";
appInfo.OCode = "001";
appInfo.UCode = dbname.Substring(2);
appInfo.DbName = dbname;
//appInfo.UserID = 2;
//appInfo.OrgID = 1;
string uid = DbHelper.GetString(userConn, string.Format("select phid from fg3_user where userno='{0}'", appInfo.LoginID));
string oid = DbHelper.GetString(userConn, string.Format("select phid from fg_orglist where ocode='{0}'", appInfo.OCode));
if (!string.IsNullOrWhiteSpace(uid))
{
appInfo.UserID = Convert.ToInt64(uid);
}
else
{
appInfo.UserID = 1;
}
if (!string.IsNullOrWhiteSpace(oid))
{
appInfo.OrgID = Convert.ToInt64(oid);
}
else
{
appInfo.OrgID = 1;
}
System.Web.HttpContext.Current.Session["NGWebAppInfo"] = appInfo;
}
private static void TestOracle()
{
string result;
DBConnectionStringBuilder dbbuilder = new DBConnectionStringBuilder();
string pubConn = string.Empty;
string userConn = string.Empty;
pubConn = dbbuilder.GetMainConnStringElement(0, out result, false); //取第一个（默认）服务器
userConn = dbbuilder.GetDefaultConnString(); //取默认连接串
userConn = dbbuilder.GetAccConnstringElement("10.0.16.168:1521/orclup.rd.ngsoft.com", "NG0001", pubConn, out result);
userConn = dbbuilder.GetAccConnstringElement(0, "NG0001", pubConn, out result);
DataTable tb = dbbuilder.GetDBserverList();
DataTable dt = dbbuilder.GetAccountList("10.0.0.233:1521/orcl.rd.ngsoft.com");
}
public string GetServerList()
{
DataSet ds = new DBConnectionStringBuilder().DBConfig;
try
{
//Ajax.WriteRaw(ds.Tables["Connect"].ToJSON("byname", "servername"));
string str = DataConverterHelper.ToJson(ds.Tables["Connect"], ds.Tables["Connect"].Rows.Count);
return(str);
//return this.Json(str, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}
public string GetUserConnectString(string ucode)
{
DBConnectionStringBuilder dBConnectionStringBuilder = new DBConnectionStringBuilder();
string theResult = string.Empty;
DataTable dtacc = DbHelper.GetDataTable(NG3.AppInfoBase.PubConnectString, "select ucode,uname,dbname,product from ngusers order by ucode ");
if (dtacc != null && dtacc.Rows.Count > 0)
{
foreach (DataRow dr in dtacc.Rows)
{
if (dr["ucode"].ToString() == ucode)
{
return(dBConnectionStringBuilder.GetAccConnstringElement(0, dr["dbname"].ToString(), NG3.AppInfoBase.PubConnectString, out theResult));
}
}
}
return(string.Empty);
}
public override void OnActionExecuting(HttpActionContext actionContext)
{
//获取AppInfo值 头部信息记录
var base64EncodedBytes = Convert.FromBase64String(HttpContext.Current.Request.Headers.GetValues("AppInfo").First());
var jsonText = Encoding.UTF8.GetString(base64EncodedBytes);
var AppInfo = JsonConvert.DeserializeObject <AppInfoBase>(jsonText);
if (AppInfo != null)
{
string curConnect = DbHelper.ConnectString;
if (curConnect.IndexOf(AppInfo.DbName, StringComparison.CurrentCultureIgnoreCase) > 0)
{
//连接串包含了当前数据库
}
else
{
DBConnectionStringBuilder dbbuilder = new DBConnectionStringBuilder();
string result, userConn;
var pubConn = dbbuilder.GetMainConnStringElement(0, out result, false);
string defaultConn = dbbuilder.GetDefaultConnString();
if (AppInfo.DbName.ToLower() == "ngsoft")
{
userConn = pubConn;
}
else
{
userConn = string.IsNullOrWhiteSpace(AppInfo.DbName)
? defaultConn
: dbbuilder.GetAccConnstringElement(0, AppInfo.DbName, pubConn,
out result);
}
//设置当前数据库连接信息
ConnectionInfoService.SetCallContextConnectString(userConn);
MultiDelegatingDbProvider.CurrentDbProviderName = AppInfo.DbName;
}
}
base.OnActionExecuting(actionContext);
}
public string GetConnectType(string svrName, string account)
{
try
{
string connectType = "0";
var dbbuilder = new DBConnectionStringBuilder();
string pubConn = string.Empty;
string result;
if (string.IsNullOrWhiteSpace(svrName))
{
pubConn = dbbuilder.GetMainConnStringElement(0, out result, false);//取第一个（默认）服务器
}
else
{
pubConn = dbbuilder.GetMainConnStringElement(svrName, out result);
}
DataTable dt = new DataTable();
byte[] obj = null;
DbHelper.Open(pubConn);
string sql = "select file_value from fg_systemconfigfile where file_key='NG_NetWorkIPMapping_Data'";
obj = (byte[])DbHelper.ExecuteScalar(pubConn, sql);
if (obj != null)
{
dt = NG3.Runtime.Serialization.SerializerBase.DeSerialize(obj) as DataTable;
if (dt != null && dt.Rows.Count > 0 && dt.Columns.IndexOf("connectType") != -1)
{
connectType = dt.Rows[0]["connectType"].ToString();
}
}
return(connectType);
}
catch (Exception ex)
{
return("0");
throw new Exception(ex.Message);
}
}
public static DBConnectionStringBuilder GetAcountDBConnectString(string svrName, string database, out string pubConn, out string userConn)
{
var dbbuilder = new DBConnectionStringBuilder();
string result;
if (string.IsNullOrWhiteSpace(svrName))
{
pubConn = dbbuilder.GetMainConnStringElement(0, out result, false);//取第一个（默认）服务器
}
else
{
pubConn = dbbuilder.GetMainConnStringElement(svrName, out result);
}
if (string.IsNullOrWhiteSpace(database))
{
userConn = dbbuilder.GetDefaultConnString();//取默认连接串
}
else
{
userConn = dbbuilder.GetAccConnstringElement(svrName, "NG" + database.Replace("NG", ""), pubConn, out result);
}
return(dbbuilder);
}
public string getUserInfo()
{
//string mobileno = System.Web.HttpContext.Current.Request.Params["mobileno"]; //人员手机号码
string mobileno = CasAuthentication.CurrentPrincipal.Identity.Name;
//根据手机号码获取人员信息
DBConnectionStringBuilder dbbuilder = new DBConnectionStringBuilder();
string theResult;
string pubConn = dbbuilder.GetMainConnStringElement(0, out theResult, false); //取第一个（默认）服务器
string userConn = dbbuilder.GetDefaultConnString(); //取默认连接串
DataTable dt = null;
object userData = null;
if (string.IsNullOrEmpty(mobileno))
{
return(DataConverterHelper.SerializeObject(new
{
Status = ResponseStatus.Error,
Msg = "没有获取到云平台的cas的手机号码."
}));
}
try
{
string sqlType = "";
string connectString = "";
//ConnectType=ORACLEClient;Data Source=10.0.14.34:1521/DQW;User ID=NG0001;Password=NG0001;Self Tuning=false;Statement Cache Size=0;Metadata Pooling=false
//ConnectType=SqlClient;Server=10.0.13.168;Database=NG0012;User ID=sa;Password=123456;
if (userConn.IndexOf("ConnectType=SqlClient", StringComparison.OrdinalIgnoreCase) >= 0)
{
sqlType = "sqlclient";
string server = NG.NGKeyValueUtility.GetValue(userConn, "Server");
string dataBase = NG.NGKeyValueUtility.GetValue(userConn, "Database", "Initial Catalog");
string userid = NG.NGKeyValueUtility.GetValue(userConn, "User ID");
string password = NG.NGKeyValueUtility.GetValue(userConn, "Password");
connectString = string.Format("Server={0};Database={1};User ID={2};Password={3}", server, dataBase, userid, password);
}
if (userConn.IndexOf("ConnectType=OracleClient", StringComparison.OrdinalIgnoreCase) >= 0)
{
sqlType = "oracle";
string source = NG.NGKeyValueUtility.GetValue(userConn, "Data Source");
string[] arrySource = source.Split(new char[] { ':', '/' }, StringSplitOptions.RemoveEmptyEntries);
string host = arrySource[0];
string port = arrySource[1];
string Server_name = arrySource[2];
string userid = NG.NGKeyValueUtility.GetValue(userConn, "User ID");
string password = NG.NGKeyValueUtility.GetValue(userConn, "Password");
connectString = string.Format("Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST={0})(PORT={1}))(CONNECT_DATA=(SERVICE_NAME={2})));Persist Security Info=True;User ID={3};Password={4};", host, port, Server_name, userid, password);
}
//"oracle":"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.6.139)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)));Persist Security Info=True;User ID=PUBDATA;Password=pubdata;";
//"sqlclient":"Server=218.108.53.111,1433;Database=DMPBase;User ID=sa;Password=newgrand@123";
string SQLString = string.Format("select userno,pwd from fg3_user where mobileno='{0}'", mobileno);
if (sqlType == "sqlclient")
{
using (SqlConnection connection = new SqlConnection(connectString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
SqlDataAdapter command = new SqlDataAdapter(SQLString, connection);
command.Fill(ds, "ds");
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
}
else if (sqlType == "oracle")
{
using (OracleConnection connection = new OracleConnection(connectString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
OracleDataAdapter command = new OracleDataAdapter(SQLString, connection);
command.Fill(ds, "ds");
}
catch (OracleException ex)
{
throw ex;
}
finally
{
connection.Close();
}
dt = ds.Tables[0];
}
}
}
catch (Exception e)
{
//throw e;
return(DataConverterHelper.SerializeObject(new
{
Status = ResponseStatus.Error,
Msg = e.ToString()
}));
}
if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows.Count > 1)
{
return(DataConverterHelper.SerializeObject(new
{
Status = ResponseStatus.Error,
Msg = "当前的人员的手机号：" + mobileno + "，含有多个数据"
}));
}
string dbpwd = "";
if (!string.IsNullOrEmpty(dt.Rows[0]["pwd"].ToString()))
{
dbpwd = NG3.NGEncode.DecodePassword(dt.Rows[0]["pwd"].ToString(), 128);
}
userData = new
{
logid = dt.Rows[0]["userno"].ToString(),
pwd = string.IsNullOrEmpty(dt.Rows[0]["pwd"].ToString()) ? "" : dt.Rows[0]["pwd"].ToString()
};
}
else
{
return(DataConverterHelper.SerializeObject(new
{
Status = ResponseStatus.Error,
Msg = "当前的人员的手机号：" + mobileno + "，没有对应的账号"
}));
}
var data = new
{
Status = ResponseStatus.Success,
Msg = "",
Data = userData
};
return(DataConverterHelper.SerializeObject(data));
}
/// <summary>
/// 初始化
/// </summary>
/// <param name="requestContext">请求上下文</param>
protected override void Initialize(System.Web.Routing.RequestContext requestContext)
{
var isSso = System.Web.HttpContext.Current.Request.Params["issso"] == null ? "" : System.Web.HttpContext.Current.Request.Params["issso"].ToString();
if (isSso == "1")
{
var logId = System.Web.HttpContext.Current.Request.Params["logno"] == null ? "" : System.Web.HttpContext.Current.Request.Params["logno"].ToString();
var logName = System.Web.HttpContext.Current.Request.Params["logname"] == null ? "" : System.Web.HttpContext.Current.Request.Params["logname"].ToString();
var oCode = System.Web.HttpContext.Current.Request.Params["ocode"] == null ? "" : System.Web.HttpContext.Current.Request.Params["ocode"].ToString();
var uCode = System.Web.HttpContext.Current.Request.Params["ucode"] == null ? "" : System.Web.HttpContext.Current.Request.Params["ucode"].ToString();
//comment by ljy 2018.01.17 特变要求预览能跟正式发布单据一样操作
//ViewBag.IsSso = "true";
ViewBag.IsSso = "false";
try
{
//设置NG3的i6WebInfoBase对象
var dbbuilder = new DBConnectionStringBuilder();
var dbName = string.Empty;
//没有传帐套号过来
if (string.IsNullOrWhiteSpace(uCode))
{
dbName = dbbuilder.DefaultDB; //如NG0001
uCode = dbName.Substring(2); //如0001
}
else
{
dbName = "NG" + uCode;
}
var result = string.Empty;
var pubConn = dbbuilder.GetMainConnStringElement(0, out result, false); //获取主数据库连接串 NGSoft
var userConn = dbbuilder.GetAccConnstringElement(0, dbName, pubConn, out result); //获取默认数据库连接串 NG0001
var i6AppInfo = new I6WebAppInfo()
{
UserType = UserType.OrgUser,
PubConnectString = pubConn,
UserConnectString = userConn,
LoginID = logId,
UserName = logName,
OCode = oCode,
UCode = uCode,
DbName = dbName,
UserID = Convert.ToInt64(DbHelper.GetString(userConn, string.Format("select phid from fg3_user where userno='{0}'", logId))),
OrgID = Convert.ToInt64(DbHelper.GetString(userConn, string.Format("select phid from fg_orglist where ocode='{0}'", oCode)))
};
System.Web.HttpContext.Current.Session["NGWebAppInfo"] = i6AppInfo;
ConnectionInfoService.SetSessionConnectString(i6AppInfo.UserConnectString);
}
catch (Exception e)
{
throw new Exception(e.Message); //应该加入日志，设置i6WebAppInfo异常。
}
}
base.Initialize(requestContext);
//调老丰AFCommonController的InitialAF()，里面含WorkFlowHandling()
string dbnameStr = NG3.AppInfoBase.DbName;
if (string.IsNullOrWhiteSpace(dbnameStr))
{
dbnameStr = base.NGPreCompileHandling();
}
base.InitialAF(dbnameStr);
}
/// <summary>
/// 登录
/// </summary>
/// <param name="svrName">数据库服务器名</param>
/// <param name="account">帐套</param>
/// <param name="logid">登录id</param>
/// <param name="pwd">密码</param>
/// <param name="msg">消息</param>
/// <returns></returns>
public bool Login(string svrName, string account, string logid, string pwd, ref string msg)
{
string result;
DBConnectionStringBuilder dbbuilder = new DBConnectionStringBuilder();
string pubConn = string.Empty;
string userConn = string.Empty;
if (string.IsNullOrWhiteSpace(svrName))
{
pubConn = dbbuilder.GetMainConnStringElement(0, out result, false);//取第一个（默认）服务器
}
else
{
pubConn = dbbuilder.GetMainConnStringElement(svrName, out result);
}
if (string.IsNullOrWhiteSpace(account))
{
userConn = dbbuilder.GetDefaultConnString();//取默认连接串
}
else
{
userConn = dbbuilder.GetAccConnstringElement(svrName, account, pubConn, out result);
}
I6WebAppInfo appInfo = new I6WebAppInfo();
appInfo.UserType = UserType.OrgUser;
#region 校验用户是否存在
object obj = DbHelper.ExecuteScalar(userConn, string.Format("select count(logid) from secuser where logid='{0}'", logid));
if (obj == null || obj == DBNull.Value || obj.ToString() == "0")
{
//检测系统管理员
obj = DbHelper.ExecuteScalar(pubConn, string.Format("select count(cname) from ngrights where cname='{0}'", logid));
if (obj == null || obj == DBNull.Value || obj.ToString() == "0")
{
//this.SetErrMsg(ps, "不存在该用户!");
//return false;
msg = "不存在该用户!";
return(false);
}
else
{
appInfo.UserType = SUP.Common.Base.UserType.System;
}
}
#endregion
#region 用户状态
string sql = "select status from secuser where logid='" + logid + "'";
string ret = DbHelper.GetString(userConn, sql);
if (ret == "1")
{
msg = "用户已锁定，请联系系统管理员!";
return(false);
}
#endregion
#region 校验密码
if (UserType.OrgUser == appInfo.UserType)
{
obj = DbHelper.ExecuteScalar(userConn, string.Format("select pwd from secuser where logid='{0}'", logid));
}
else
{
obj = DbHelper.ExecuteScalar(pubConn, string.Format("select cpwd from ngrights where cname='{0}'", logid));
}
if (string.IsNullOrEmpty(pwd))
{
if (obj != null && obj != DBNull.Value)
{
if (obj.ToString().Length > 0)
{
msg = "密码不正确";
return(false);
}
}
}
else
{
if (obj == null || obj == DBNull.Value)
{
msg = "密码不正确";
return(false);
}
else
{
string dbpwd = NG3.NGEncode.DecodePassword(obj.ToString(), 128);
if (dbpwd.Equals(pwd) == false)
{
msg = "密码不正确";
return(false);
}
}
}
#endregion
return(true);
}
public void Check(ref string msg, ref bool loginflag, string svrName, string account, string logid, string pwd)
{
string result;
DBConnectionStringBuilder dbbuilder = new DBConnectionStringBuilder();
string pubConn = string.Empty;
string userConn = string.Empty;
if (string.IsNullOrWhiteSpace(svrName))
{
pubConn = dbbuilder.GetMainConnStringElement(0, out result, false);//取第一个（默认）服务器
}
else
{
pubConn = dbbuilder.GetMainConnStringElement(svrName, out result);
}
if (string.IsNullOrWhiteSpace(account))
{
userConn = dbbuilder.GetDefaultConnString();//取默认连接串
}
else
{
userConn = dbbuilder.GetAccConnstringElement(svrName, account, pubConn, out result);
}
I6WebAppInfo appInfo = new I6WebAppInfo();
appInfo.UserType = UserType.OrgUser;
#region 用户状态
string sql = "select status from secuser where logid='" + logid + "'";
string ret = DbHelper.GetString(userConn, sql);
if (ret == "1")
{
msg = "用户[" + logid + "]已锁定，请联系系统管理员!";
loginflag = false;
return;
}
int sysErrortimes = this.dac.GetSysErrTimes(userConn);//系统定义出错次数
int currentErrorTimes = this.dac.GetErrTimes(logid, userConn);
if (currentErrorTimes == sysErrortimes)
{
this.dac.SetUserStateOff(logid, userConn);//锁定用户
msg = "用户[" + logid + "]已锁定，请联系系统管理员!";
loginflag = false;
return;
}
#endregion
string username = string.Empty;
//校验用户
object obj = DbHelper.ExecuteScalar(userConn, string.Format("select count(logid) from secuser where logid='{0}'", logid));
if (obj == null || obj == DBNull.Value || obj.ToString() == "0")
{
//检测系统管理员
obj = DbHelper.ExecuteScalar(pubConn, string.Format("select count(cname) from ngrights where cname='{0}'", logid));
if (obj == null || obj == DBNull.Value || obj.ToString() == "0")
{
//this.SetErrMsg(ps, "不存在该用户!");
//return false;
msg = "用户名或密码错误！";//"不存在该用户!";
loginflag = false;
this.dac.AddErrTimes(logid, userConn);
return;
}
else
{
appInfo.UserType = SUP.Common.Base.UserType.System;
}
username = logid;
}
else
{
string usernameSql = string.Format("select u_name from secuser where logid='{0}'", logid);
username = DbHelper.GetString(userConn, usernameSql);
}
#region 校验密码
if (UserType.OrgUser == appInfo.UserType)
{
obj = DbHelper.ExecuteScalar(userConn, string.Format("select pwd from secuser where logid='{0}'", logid));
}
else
{
obj = DbHelper.ExecuteScalar(pubConn, string.Format("select cpwd from ngrights where cname='{0}'", logid));
}
if (string.IsNullOrEmpty(pwd))
{
if (obj != null && obj != DBNull.Value)
{
if (obj.ToString().Length > 0)
{
msg = "用户名或密码错误！";//"密码不正确";
loginflag = false;
this.dac.AddErrTimes(logid, userConn);
return;
}
}
}
else
{
if (obj == null || obj == DBNull.Value)
{
msg = "用户名或密码错误！"; //"密码不正确";
loginflag = false;
this.dac.AddErrTimes(logid, userConn);
return;
}
else
{
string dbpwd = NG3.NGEncode.DecodePassword(obj.ToString(), 128);
if (dbpwd.Equals(pwd) == false)
{
msg = "用户名或密码错误！";//"密码不正确";
loginflag = false;
this.dac.AddErrTimes(logid, userConn);
return;
}
}
}
#endregion
//错误次数清零
this.dac.ClearErr(logid, userConn);
//普通用户，获取组织
string ocode = string.Empty;
if (UserType.System != appInfo.UserType)
{
ocode = DbHelper.ExecuteScalar(userConn, string.Format("select lastloginorg from secuser where logid='{0}'", logid)).ToString();
if (string.IsNullOrWhiteSpace(ocode))
{
sql = "select ocode from fg_orglist";
DataTable dt = DbHelper.GetDataTable(userConn, sql);
if (dt.Rows.Count > 0)
{
ocode = dt.Rows[0]["ocode"].ToString();//取第一个组织作为默认组织
}
}
}
#region 在线用户
//string message = this.CheckUserOnline(logid, account, string.Empty);
string message = this.CheckTheSameSessionUser(logid);
if (!string.IsNullOrEmpty(message))
{
msg = message;
loginflag = false;
return;
}
#endregion
appInfo.PubConnectString = pubConn;
appInfo.UserConnectString = userConn;
appInfo.LoginID = logid;
appInfo.UserName = username;
appInfo.OCode = ocode;
appInfo.UCode = account;
appInfo.UserID = Convert.ToInt64(DbHelper.GetString(userConn, string.Format("select phid from fg3_user where userno='{0}'", logid)));
appInfo.OrgID = Convert.ToInt64(DbHelper.GetString(userConn, string.Format("select phid from fg_orglist where ocode='{0}'", ocode)));
System.Web.HttpContext.Current.Session[UPAppInfoNameInSession] = appInfo;
NG3.Data.Service.ConnectionInfoService.SetSessionConnectString(appInfo.UserConnectString);//初始化2.0的dbhelper
}