public string GetUserLoginNameByMac()
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
Eva.Library.Net.NetTool nt = new Eva.Library.Net.NetTool();
string ipAddressString = nt.GetBrowerIP();
string macAddressString = nt.GetRemoteMacByIP(ipAddressString);
if (macAddressString == "00-00-00-00-00-00" || macAddressString == "")
{
resultDic["result"] = "false";
resultDic["message"] = "";
}
else
{
Eva.Library.ServiceAdapter.IAdapter.IAuth _ia = Eva.Library.ServiceAdapter.AdapterFactory.AuthFactory.CreateService(Eva.Library.Configuration.ConfigurationManager.AppSettings["AppCode"]);
string sqlString = "select * from t_user where upper(f_value1) like '%" + macAddressString.ToUpper() + "%'";
DataSet ds = null;
if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll")
{
ds = sara.platform.service.auth.Service.QuerySql(sqlString);
}
else
{
ds = _ia.QuerySql(sqlString);
}
if (ds.Tables[0].Rows.Count == 1)
{
resultDic["result"] = "true";
resultDic["message"] = ds.Tables[0].Rows[0]["U_Code"].ToString();
}
else
{
resultDic["result"] = "false";
resultDic["message"] = "";
}
}
}
catch (Exception ex)
{
resultDic["result"] = "error";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string GetUserInf(string userIdString, string uuid)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
if (checkUserInf(userIdString, uuid))
{
Session["userid"] = userIdString;
Session.Timeout = 1440;
Eva.Library.ServiceAdapter.IAdapter.IAuth _ia = Eva.Library.ServiceAdapter.AdapterFactory.AuthFactory.CreateService(Eva.Library.Configuration.ConfigurationManager.AppSettings["AppCode"]);
#region 装载用户信息
DataSet dsInf = null;
DataSet dsOrg = null;
DataSet dsRole = null;
DataSet dsPosition = null;
//DataSet dsField = null;
if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll")
{
dsInf = sara.platform.service.auth.Service.GetUserInfByUserid(userIdString);
dsOrg = sara.platform.service.auth.Service.GetUserOrganByUserid(userIdString);
dsRole = sara.platform.service.auth.Service.GetUserRoleByUserid(userIdString);
dsPosition = sara.platform.service.auth.Service.GetUserPositionByUserid(userIdString);
// dsField = sara.platform.service.auth.Service.GetUserFieldByUserid(userIdString);
}
else
{
dsInf = _ia.GetUserInfByUserid(userIdString);
dsOrg = _ia.GetUserOrganByUserid(userIdString);
dsRole = _ia.GetUserRoleByUserid(userIdString);
dsPosition = _ia.GetUserPositionByUserid(userIdString);
//dsField = _ia.GetUserFieldByUserid(userIdString);
}
string userInfJson = "{";
#region user
userInfJson += "\"sys_userid\":\"" + userIdString + "\",";
userInfJson += "\"sys_username\":\"" + dsInf.Tables[0].Rows[0]["U_Name"].ToString() + "\",";
userInfJson += "\"sys_userloginname\":\"" + dsInf.Tables[0].Rows[0]["U_Code"].ToString() + "\",";
userInfJson += "\"sys_photourl\":\"" + dsInf.Tables[0].Rows[0]["U_PHOTOTURL"].ToString() + "\",";
userInfJson += "\"sys_value1\":\"" + dsInf.Tables[0].Rows[0]["F_VALUE1"].ToString() + "\",";
userInfJson += "\"sys_value2\":\"" + dsInf.Tables[0].Rows[0]["F_VALUE2"].ToString() + "\",";
userInfJson += "\"sys_value3\":\"" + dsInf.Tables[0].Rows[0]["F_VALUE3"].ToString() + "\",";
userInfJson += "\"sys_value4\":\"" + dsInf.Tables[0].Rows[0]["F_VALUE4"].ToString() + "\",";
userInfJson += "\"sys_value5\":\"" + dsInf.Tables[0].Rows[0]["F_VALUE5"].ToString() + "\",";
userInfJson += "\"sys_value6\":\"" + dsInf.Tables[0].Rows[0]["F_VALUE6"].ToString() + "\",";
userInfJson += "\"sys_value7\":\"" + dsInf.Tables[0].Rows[0]["F_VALUE7"].ToString() + "\",";
userInfJson += "\"sys_value8\":\"" + dsInf.Tables[0].Rows[0]["F_VALUE8"].ToString() + "\",";
userInfJson += "\"sys_value9\":\"" + dsInf.Tables[0].Rows[0]["F_VALUE9"].ToString() + "\",";
userInfJson += "\"sys_value10\":\"" + dsInf.Tables[0].Rows[0]["F_VALUE10"].ToString() + "\",";
#endregion
#region organ
if (dsOrg.Tables[0].Rows.Count > 0)
{
userInfJson += "\"sys_organid\":\"" + dsOrg.Tables[0].Rows[0]["O_ID"].ToString() + "\",";
userInfJson += "\"sys_organcode\":\"" + dsOrg.Tables[0].Rows[0]["O_CODE"].ToString() + "\",";//用于组装流程编号
userInfJson += "\"sys_organname\":\"" + dsOrg.Tables[0].Rows[0]["O_FullName"].ToString() + "\",";
}
else
{
userInfJson += "\"sys_organid\":\"" + "" + "\",";
userInfJson += "\"sys_organcode\":\"" + "" + "\",";
userInfJson += "\"sys_organname\":\"" + "" + "\",";
}
string sqlString = "select o_id,o_fullname from t_organ where o_id in ('" + dsInf.Tables[0].Rows[0]["U_REMARK"].ToString() + "') ";
DataSet ds_TopOrgan = null;
if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll")
{
ds_TopOrgan = sara.platform.service.auth.Service.QuerySql(sqlString);
}
else
{
ds_TopOrgan = _ia.QuerySql(sqlString);
}
userInfJson += "\"sys_toporgan\":\"" + dsInf.Tables[0].Rows[0]["U_REMARK"].ToString() + "\",";
if (ds_TopOrgan.Tables[0].Rows.Count > 0)
{
userInfJson += "\"sys_toporganname\":\"" + ds_TopOrgan.Tables[0].Rows[0]["o_fullname"].ToString() + "\",";
}
else
{
userInfJson += "\"sys_toporganname\":\"\",";
}
#endregion
#region roles
if (dsRole.Tables[0].Rows.Count > 0)
{
string roles = "";
string rolenames = "";
string sys_rolenameremarks = "";
for (int i = 0; i < dsRole.Tables[0].Rows.Count; i++)
{
if (dsRole.Tables[0].Rows[i]["r_sys_appcode"].ToString() == "" || ("," + dsRole.Tables[0].Rows[i]["r_sys_appcode"].ToString() + ",").IndexOf("," + Eva.Library.Configuration.ConfigurationManager.AppSettings["APPCODE"] + ",") > -1)
{
roles += "" + dsRole.Tables[0].Rows[i]["R_ID"].ToString() + "^";
rolenames += "" + dsRole.Tables[0].Rows[i]["R_NAME"].ToString() + "^";
sys_rolenameremarks += "" + dsRole.Tables[0].Rows[i]["R_REMARK"].ToString().Replace(",", "|").Replace("，", "|") + "^";
}
}
userInfJson += "\"sys_roles\":\"" + roles.TrimEnd('^') + "\",";
userInfJson += "\"sys_rolenames\":\"" + rolenames.TrimEnd('^') + "\",";
userInfJson += "\"sys_rolenameremarks\":\"" + sys_rolenameremarks.TrimEnd('^') + "\",";
}
else
{
userInfJson += "\"sys_roles\":\"" + "" + "\",";
userInfJson += "\"sys_rolenames\":\"" + "\",";
userInfJson += "\"sys_rolenameremarks\":\"" + "\",";
}
#endregion
#region position
if (dsPosition.Tables[0].Rows.Count > 0)
{
string positionids = "";
string positionnames = "";
for (int i = 0; i < dsPosition.Tables[0].Rows.Count; i++)
{
if (("," + dsPosition.Tables[0].Rows[i]["p_sys_appcode"].ToString() + ",").IndexOf("," + Eva.Library.Configuration.ConfigurationManager.AppSettings["APPCODE"] + ",") > -1)
{
positionids += "" + dsPosition.Tables[0].Rows[i]["p_id"].ToString() + "^";
positionnames += "" + dsPosition.Tables[0].Rows[i]["p_fullname"].ToString() + "^";
}
}
userInfJson += "\"sys_positionids\":\"" + positionids.TrimEnd('^') + "\",";
userInfJson += "\"sys_positionnames\":\"" + positionnames.TrimEnd('^') + "\",";
}
else
{
userInfJson += "\"sys_positionids\":\"" + "" + "\",";
userInfJson += "\"sys_positionnames\":\"" + "\",";
}
#endregion
#region field
//if (dsField.Tables.Count > 0 && dsField.Tables[0].Rows.Count > 0)
//{
// string tablename = "";
// for (int i = 0; i < dsField.Tables[0].Rows.Count; i++)
// {
// tablename += "" + dsField.Tables[0].Rows[i]["f_name"].ToString() + "^";
// }
// userInfJson += "\"sys_fieldnames\":\"" + tablename.TrimEnd('^') + "\"";
//}
//else
//{
// userInfJson += "\"sys_fieldnames\":\"" + "\"";
//}
#endregion
userInfJson += "}";
#endregion
resultDic["result"] = "true";
resultDic["message"] = userInfJson;
}
else
{
resultDic["result"] = "false";
resultDic["message"] = "timeout";
}
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
public string UserLogin(string userLoginNameString, string userPasswordString, string userPatternString)
{
Dictionary <string, string> resultDic = new Dictionary <string, string>();
resultDic["result"] = "";
resultDic["message"] = "";
try
{
Eva.Library.ServiceAdapter.IAdapter.IAuth _ia = Eva.Library.ServiceAdapter.AdapterFactory.AuthFactory.CreateService(Eva.Library.Configuration.ConfigurationManager.AppSettings["AppCode"]);
string userid = "";
//登录方式：0普通登录，1超级登录
string logintype = "0";
//如果传入的password是--的话自动调用超级密码登录
if (userPasswordString == "--")
{
userPasswordString = Eva.Library.Configuration.ConfigurationManager.AppSettings["UpassWord"].ToString();
}
if (userPasswordString == Eva.Library.Configuration.ConfigurationManager.AppSettings["UpassWord"].ToString())
{
if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll")
{
userid = sara.platform.service.auth.Service.UserLoginByLoginName1(userLoginNameString);
logintype = "1";
}
else
{
userid = _ia.UserLoginByLoginName1(userLoginNameString);
logintype = "1";
}
}
else
{
if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll")
{
userid = sara.platform.service.auth.Service.UserLogin1(userLoginNameString, userPasswordString);
logintype = "0";
}
else
{
userid = _ia.UserLogin1(userLoginNameString, userPasswordString);
logintype = "0";
}
}
//通过图形码和userid校验用户是否正确
if (userPatternString != "--")
{
string sqlString = "select count(*) from t_user where u_id = '" + userid + "' and f_value2 = '" + userPatternString + "' and u_state = '1'";
string ss = "";
if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll")
{
ss = sara.platform.service.auth.Service.QuerySql(sqlString).Tables[0].Rows[0][0].ToString();
}
else
{
ss = _ia.QuerySql(sqlString).Tables[0].Rows[0][0].ToString();
}
if (ss != "1")
{
userid = "0";
}
}
if (userid == "0")
{
resultDic["result"] = "false";
resultDic["message"] = "登录失败，用户名和密码不符。";
}
else
{
Session["userid"] = userid;
Session.Timeout = 1440;
resultDic["result"] = "true";
resultDic["message"] = userid + "^" + logintype;
try
{
Eva.Library.Net.NetTool nt = new Eva.Library.Net.NetTool();
string ipAddressString = nt.GetBrowerIP();
string macAddressString = nt.GetRemoteMacByIP(ipAddressString);
string sqlString = "";
sqlString += " insert into t_login_log ";
sqlString += " (sys_id, f_userid, f_userloginname, f_username, f_date, f_ip, f_mac, f_clienttype, f_loginpattern) ";
sqlString += " values ";
//sqlString += " ((select nvl(max(sys_id), 0) + 1 as sys_id from t_login_log), ";
sqlString += " ('1', ";
sqlString += " '" + userid + "', ";
sqlString += " '" + userLoginNameString + "', ";
sqlString += " '" + userLoginNameString + "',";
sqlString += " to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "', 'yyyy-MM-dd hh24:mi:ss'),";
sqlString += " '" + ipAddressString + "',";
sqlString += " '" + macAddressString + "',";
sqlString += " 'pc',";
sqlString += " 'pc') ";
Eva.Library.Data.AccessData.IAccessData _iAccessData = commonclass.commonclass.CreateIAccessData();
_iAccessData.ExecuteSql(sqlString);
}
catch
{
}
}
}
catch (Exception ex)
{
resultDic["result"] = "false";
resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace);
}
return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic));
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="sys_user_id"></param>
/// <returns></returns>
public static sara.dd.ldsw.model.userinfo GetUserInfoModel(string userIdString, string userInfoJsonString)
{
if (userInfoJsonString != "")
{
sara.dd.ldsw.model.userinfo userInfoModel = new sara.dd.ldsw.model.userinfo();
IDictionary <string, string> userInfoDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(userInfoJsonString);
userInfoModel.sys_userid = userInfoDic["sys_userid"].ToString();
userInfoModel.sys_username = userInfoDic["sys_username"].ToString();
userInfoModel.sys_userloginname = userInfoDic["sys_userloginname"].ToString();
userInfoModel.sys_organid = userInfoDic["sys_organid"].ToString();
userInfoModel.sys_organcode = userInfoDic["sys_organcode"].ToString();
userInfoModel.sys_organname = userInfoDic["sys_organname"].ToString();
userInfoModel.sys_toporgan = userInfoDic["sys_toporgan"].ToString();
userInfoModel.sys_toporganname = userInfoDic["sys_toporganname"].ToString();
userInfoModel.sys_roles = userInfoDic["sys_roles"].ToString();
userInfoModel.sys_rolenames = userInfoDic["sys_rolenames"].ToString();
userInfoModel.sys_rolenameremarks = userInfoDic["sys_rolenameremarks"].ToString();
userInfoModel.sys_positionids = userInfoDic["sys_positionids"].ToString();
userInfoModel.sys_positionnames = userInfoDic["sys_positionnames"].ToString();
userInfoModel.sys_fieldnames = userInfoDic["sys_fieldnames"].ToString();
return(userInfoModel);
}
else
{
sara.dd.ldsw.model.userinfo userInfoModel = new sara.dd.ldsw.model.userinfo();
DataSet dsInf = null;
DataSet dsOrg = null;
DataSet dsRole = null;
DataSet dsPosition = null;
DataSet dsField = null;
if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll")
{
dsInf = sara.platform.service.auth.Service.GetUserInfByUserid(userIdString);
dsOrg = sara.platform.service.auth.Service.GetUserOrganByUserid(userIdString);
dsRole = sara.platform.service.auth.Service.GetUserRoleByUserid(userIdString);
dsPosition = sara.platform.service.auth.Service.GetUserPositionByUserid(userIdString);
dsField = sara.platform.service.auth.Service.GetUserFieldByUserid(userIdString);
}
else
{
dsInf = _ia.GetUserInfByUserid(userIdString);
dsOrg = _ia.GetUserOrganByUserid(userIdString);
dsRole = _ia.GetUserRoleByUserid(userIdString);
dsPosition = _ia.GetUserPositionByUserid(userIdString);
dsField = _ia.GetUserFieldByUserid(userIdString);
}
string sqlString = "select o_id,o_fullname from t_organ where o_id in ('" + dsInf.Tables[0].Rows[0]["U_REMARK"].ToString() + "') ";
DataSet ds_TopOrgan = null;
if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll")
{
ds_TopOrgan = sara.platform.service.auth.Service.QuerySql(sqlString);
}
else
{
ds_TopOrgan = _ia.QuerySql(sqlString);
}
userInfoModel.sys_userid = userIdString;
userInfoModel.sys_username = dsInf.Tables[0].Rows[0]["U_Name"].ToString();
userInfoModel.sys_userloginname = dsInf.Tables[0].Rows[0]["U_Code"].ToString();
userInfoModel.sys_organid = dsOrg.Tables[0].Rows[0]["O_ID"].ToString();
userInfoModel.sys_organcode = dsOrg.Tables[0].Rows[0]["O_CODE"].ToString();
userInfoModel.sys_organname = dsOrg.Tables[0].Rows[0]["O_FullName"].ToString();
userInfoModel.sys_toporgan = dsInf.Tables[0].Rows[0]["U_REMARK"].ToString();
userInfoModel.sys_toporganname = ds_TopOrgan.Tables[0].Rows[0]["o_fullname"].ToString();
userInfoModel.sys_roles = "";
userInfoModel.sys_rolenames = "";
userInfoModel.sys_rolenameremarks = "";
for (int i = 0; i < dsRole.Tables[0].Rows.Count; i++)
{
if ((dsRole.Tables[0].Rows[i]["r_sys_appcode"].ToString() == "") || ("," + dsRole.Tables[0].Rows[i]["r_sys_appcode"].ToString() + ",").IndexOf("," + Eva.Library.Configuration.ConfigurationManager.AppSettings["APPCODE"] + ",") > -1)
{
userInfoModel.sys_roles += "" + dsRole.Tables[0].Rows[i]["R_ID"].ToString() + "^";
userInfoModel.sys_rolenames += "" + dsRole.Tables[0].Rows[i]["R_NAME"].ToString() + "^";
userInfoModel.sys_rolenameremarks += "" + dsRole.Tables[0].Rows[i]["R_REMARK"].ToString().Replace(",", "|").Replace("，", "|") + "^";
}
}
userInfoModel.sys_roles = userInfoModel.sys_roles.TrimEnd('^');
userInfoModel.sys_rolenames = userInfoModel.sys_rolenames.TrimEnd('^');
userInfoModel.sys_rolenameremarks = userInfoModel.sys_rolenameremarks.TrimEnd('^');
userInfoModel.sys_positionids = "";
userInfoModel.sys_positionnames = "";
for (int i = 0; i < dsPosition.Tables[0].Rows.Count; i++)
{
if (dsRole.Tables[0].Rows[i]["r_sys_appcode"].ToString() == "" || ("," + dsPosition.Tables[0].Rows[i]["p_sys_appcode"].ToString() + ",").IndexOf("," + Eva.Library.Configuration.ConfigurationManager.AppSettings["APPCODE"] + ",") > -1)
{
userInfoModel.sys_positionids += "" + dsPosition.Tables[0].Rows[i]["p_id"].ToString() + "^";
userInfoModel.sys_positionnames += "" + dsPosition.Tables[0].Rows[i]["p_fullname"].ToString() + "^";
}
}
userInfoModel.sys_positionids = userInfoModel.sys_positionids.TrimEnd('^');
userInfoModel.sys_positionnames = userInfoModel.sys_positionnames.TrimEnd('^');
userInfoModel.sys_fieldnames = "";
for (int i = 0; i < dsField.Tables[0].Rows.Count; i++)
{
userInfoModel.sys_fieldnames = "" + dsField.Tables[0].Rows[i]["tablename"].ToString() + "^";
}
userInfoModel.sys_fieldnames = userInfoModel.sys_fieldnames.TrimEnd('^');
return(userInfoModel);
}
}