DKIBOSSPRDLogic.cs 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571
  1. /*******************************************************************************
  2. * Copyright(c) 2014 DongkeSoft All rights reserved. / Confidential
  3. * 类的信息:
  4. * 1.程序名称:DKIBOSSPRDLogic.cs
  5. * 2.功能描述:系统登录相关处理。
  6. * 编辑履历:
  7. * 作者 日期 版本 修改内容
  8. * 张国印 2014/09/16 1.00 新建
  9. *******************************************************************************/
  10. using System;
  11. using System.Data;
  12. using System.IO;
  13. using Dongke.IBOSS.PRD.Basics.BaseResources;
  14. using Dongke.IBOSS.PRD.Basics.DataAccess;
  15. using Dongke.IBOSS.PRD.Basics.Library;
  16. using Dongke.IBOSS.PRD.Service.DataModels;
  17. using Dongke.IBOSS.PRD.WCF.DataModels;
  18. using Oracle.ManagedDataAccess.Client;
  19. namespace Dongke.IBOSS.PRD.Service.DKIBOSSPRDLogic
  20. {
  21. /// <summary>
  22. /// 系统登录相关处理
  23. /// </summary>
  24. public static class DKIBOSSPRDLogic
  25. {
  26. /// <summary>
  27. /// 升级文件读取时,用的统一锁。
  28. /// </summary>
  29. private static object _downloadUpgradeFile = new object();
  30. #region 用户登录相关
  31. /// <summary>
  32. /// 用户登录-刷新菜单
  33. /// </summary>
  34. /// <param name="requestEntity"></param>
  35. /// <param name="actionType">0:PC端;2:移动端</param>
  36. /// <returns>LoginResultEntity对象</returns>
  37. public static LoginResultEntity DoLoginRefresh(LoginRequestEntity requestEntity, string actionType)
  38. {
  39. LoginResultEntity resultEntity = new LoginResultEntity();
  40. IDBConnection oracleConn = ClsDbFactory.CreateDBConnection(DataBaseType.ORACLE, DataManager.ConnectionString);
  41. try
  42. {
  43. // 读取License文件数据
  44. if (DataManager.LicDataSet != null)
  45. {
  46. resultEntity.LicenseInfo = new DataSet("LIC");
  47. resultEntity.LicenseInfo.Merge(DataManager.LicDataSet.Tables["Info"]);
  48. }
  49. #region 形成需要执行的SQL语句
  50. string strSql = "PRO_SYS_DoLogin";
  51. OracleParameter[] paras = new OracleParameter[]
  52. {
  53. new OracleParameter("in_AccountCode",requestEntity.AccountCode),
  54. new OracleParameter("in_UserCode",requestEntity.UserCode),
  55. new OracleParameter("in_UserPassword",requestEntity.Password),
  56. new OracleParameter("in_MAC",requestEntity.MACAddress),
  57. new OracleParameter("in_SessionKey",requestEntity.SessionKey),
  58. new OracleParameter("in_ComputerName",requestEntity.ComputerName),
  59. new OracleParameter("in_IP",requestEntity.IPAddress),
  60. new OracleParameter("in_LoginType",actionType),
  61. new OracleParameter("out_LoginStatus",OracleDbType.Int16, ParameterDirection.Output),
  62. new OracleParameter("out_UserOrganization",OracleDbType.RefCursor, ParameterDirection.Output),
  63. new OracleParameter("out_Navigation",OracleDbType.RefCursor, ParameterDirection.Output), //用户导航菜单
  64. new OracleParameter("out_UserRightData",OracleDbType.RefCursor, ParameterDirection.Output), //用户功能权限
  65. new OracleParameter("out_UserRangeRightData",OracleDbType.RefCursor, ParameterDirection.Output), //用户范围权限
  66. new OracleParameter("out_Function",OracleDbType.RefCursor, ParameterDirection.Output) //系统功能菜单
  67. };
  68. #endregion
  69. oracleConn.Open();
  70. int loginStatus = 0;
  71. DataSet returnDataSet = oracleConn.ExecStoredProcedure(strSql, paras);
  72. foreach (Constant.SysCacheTable itemEnum in Enum.GetValues(typeof(Constant.SysCacheTable)))
  73. {
  74. string strSysConfig = "Select * From " + itemEnum.ToString();
  75. DataTable dtTemp = oracleConn.GetSqlResultToDt(strSysConfig);
  76. dtTemp.TableName = itemEnum.ToString();
  77. if (resultEntity.SysParameter == null)
  78. resultEntity.SysParameter = new DataSet();
  79. resultEntity.SysParameter.Tables.Add(dtTemp);
  80. }
  81. oracleConn.Close();
  82. if (returnDataSet != null && 5 <= returnDataSet.Tables.Count)
  83. {
  84. DataRow dataRow = returnDataSet.Tables[0].Rows[0];
  85. #region 给用户实体赋值
  86. resultEntity.CurrentUserEntity.UserID = Convert.ToInt16(dataRow["UserID"].ToString().Trim());
  87. resultEntity.CurrentUserEntity.UserCode = dataRow["UserCode"].ToString().Trim();
  88. resultEntity.CurrentUserEntity.UserName = dataRow["UserName"].ToString().Trim();
  89. resultEntity.CurrentUserEntity.AccountID = Convert.ToInt16(dataRow["AccountID"].ToString().Trim());
  90. resultEntity.CurrentUserEntity.AccountCode = dataRow["AccountCode"].ToString().Trim();
  91. resultEntity.CurrentUserEntity.AccountName = dataRow["AccountName"].ToString().Trim();
  92. resultEntity.CurrentUserEntity.Password = dataRow["Password"].ToString().Trim();
  93. resultEntity.CurrentUserEntity.OrganizationID = Convert.ToInt16(dataRow["OrganizationID"].ToString().Trim());
  94. resultEntity.CurrentUserEntity.OrganizationCode = dataRow["OrganizationCode"].ToString().Trim();
  95. resultEntity.CurrentUserEntity.SessionKey = dataRow["SessionKey"].ToString().Trim();
  96. resultEntity.CurrentUserEntity.ValueFlag = Convert.ToInt16(dataRow["ValueFlag"].ToString().Trim());
  97. resultEntity.CurrentUserEntity.LimitMAC = dataRow["LimitMAC"].ToString().Trim();
  98. resultEntity.CurrentUserEntity.CanSmartLogin = Convert.ToInt16(dataRow["CanSmartLogin"].ToString().Trim());
  99. resultEntity.CurrentUserEntity.Remarks = dataRow["Remarks"].ToString().Trim();
  100. resultEntity.CurrentUserEntity.UserNavigationData = returnDataSet.Tables[1]; // 用户的主导航菜单数据
  101. resultEntity.CurrentUserEntity.UserRightData = returnDataSet.Tables[2];// 用户的功能权限限制数据
  102. resultEntity.CurrentUserEntity.UserRangeRightData = returnDataSet.Tables[3]; // 用户的范围权限限制数据
  103. resultEntity.CurrentUserEntity.FunctionData = returnDataSet.Tables[4]; //系统功能菜单
  104. #endregion
  105. }
  106. else if (paras[8] != null)
  107. {
  108. loginStatus = Convert.ToInt32(paras[8].Value.ToString());
  109. }
  110. else
  111. {
  112. loginStatus = -1;
  113. }
  114. resultEntity.LoginStatus = loginStatus;
  115. return resultEntity;
  116. }
  117. finally
  118. {
  119. if (oracleConn.ConnState == ConnectionState.Open)
  120. {
  121. oracleConn.Close();
  122. }
  123. }
  124. }
  125. /// <summary>
  126. /// 用户登录
  127. /// </summary>
  128. /// <param name="requestEntity">请求用户实例</param>
  129. /// <param name="actionType">0:PC端;2:移动端</param>
  130. /// <returns>LoginResultEntity对象</returns>
  131. public static LoginResultEntity DoLogin(LoginRequestEntity requestEntity, string actionType)
  132. {
  133. LoginResultEntity resultEntity = new LoginResultEntity();
  134. IDBConnection oracleConn = ClsDbFactory.CreateDBConnection(DataBaseType.ORACLE, DataManager.ConnectionString);
  135. try
  136. {
  137. #region 对License文件结果处理 返回异常信息
  138. bool checkLic = false;
  139. if (checkLic)
  140. {
  141. lock (DataManager.LicLock)
  142. {
  143. string sql = "select a.ListCode from tp_mst_account a order by a.accountid";
  144. string listCode = oracleConn.GetSqlResultToStr(sql);
  145. // 读取License文件数据
  146. DataSet customer = null;
  147. string licString = null;
  148. int readLock = LockLicenseHandle.ReadLisenceFile(listCode, ref customer, out licString);
  149. if (readLock == -1)
  150. {
  151. resultEntity.LoginStatus = Constant.LOGIN_NOT_LICENSE;
  152. return resultEntity;
  153. }
  154. else if (readLock == -2)
  155. {
  156. resultEntity.LoginStatus = Constant.LOGIN_LICENSE_CONTENT_ERROR;
  157. return resultEntity;
  158. }
  159. else if (readLock == -3)
  160. {
  161. resultEntity.LoginStatus = Constant.LOGIN_LICENSE_BE_OVERDUE;
  162. return resultEntity;
  163. }
  164. // license文件数据不正确
  165. if (customer == null || customer.Tables[0].Rows.Count < 1)
  166. {
  167. resultEntity.LoginStatus = Constant.LOGIN_LICENSE_CONTENT_ERROR;
  168. return resultEntity;
  169. }
  170. if (DataManager.LicString == null || DataManager.LicString != licString)
  171. {
  172. DataManager.LicString = licString;
  173. DataManager.LicDataSet = customer;
  174. }
  175. resultEntity.LicenseInfo = new DataSet("LIC");
  176. resultEntity.LicenseInfo.Merge(DataManager.LicDataSet.Tables["Info"]);
  177. }
  178. }
  179. #endregion
  180. #region 形成需要执行的SQL语句
  181. requestEntity.SessionKey = Guid.NewGuid().ToString();
  182. string strSql = "PRO_SYS_DoLogin";
  183. OracleParameter[] paras = new OracleParameter[]
  184. {
  185. new OracleParameter("in_AccountCode",requestEntity.AccountCode),
  186. new OracleParameter("in_UserCode",requestEntity.UserCode),
  187. new OracleParameter("in_UserPassword",requestEntity.Password),
  188. new OracleParameter("in_MAC",requestEntity.MACAddress==null ? " ":requestEntity.MACAddress),//wangx 2015/08/11 pda出现问题所修改
  189. new OracleParameter("in_SessionKey",requestEntity.SessionKey),
  190. new OracleParameter("in_ComputerName",requestEntity.ComputerName),
  191. new OracleParameter("in_IP",requestEntity.IPAddress),
  192. new OracleParameter("in_IMEI",requestEntity.IMEI),
  193. new OracleParameter("in_LoginType",actionType),
  194. new OracleParameter("out_LoginStatus",OracleDbType.Int16, ParameterDirection.Output),
  195. new OracleParameter("out_UserOrganization",OracleDbType.RefCursor, ParameterDirection.Output),
  196. new OracleParameter("out_Navigation",OracleDbType.RefCursor, ParameterDirection.Output), //用户导航菜单
  197. new OracleParameter("out_UserRightData",OracleDbType.RefCursor, ParameterDirection.Output), //用户功能权限
  198. new OracleParameter("out_UserRangeRightData",OracleDbType.RefCursor, ParameterDirection.Output), //用户范围权限
  199. new OracleParameter("out_Function",OracleDbType.RefCursor, ParameterDirection.Output) //系统功能菜单
  200. };
  201. #endregion
  202. oracleConn.Open();
  203. int loginStatus = 0;
  204. DataSet returnDataSet = oracleConn.ExecStoredProcedure(strSql, paras);
  205. foreach (Constant.SysCacheTable itemEnum in Enum.GetValues(typeof(Constant.SysCacheTable)))
  206. {
  207. string strSysConfig = "Select * From " + itemEnum.ToString();
  208. DataTable dtTemp = oracleConn.GetSqlResultToDt(strSysConfig);
  209. dtTemp.TableName = itemEnum.ToString();
  210. if (resultEntity.SysParameter == null)
  211. resultEntity.SysParameter = new DataSet();
  212. resultEntity.SysParameter.Tables.Add(dtTemp);
  213. }
  214. oracleConn.Close();
  215. if (returnDataSet != null && 5 <= returnDataSet.Tables.Count)
  216. {
  217. DataRow dataRow = returnDataSet.Tables[0].Rows[0];
  218. #region 给用户实体赋值
  219. resultEntity.CurrentUserEntity.UserID = Convert.ToInt16(dataRow["UserID"].ToString().Trim());
  220. resultEntity.CurrentUserEntity.UserCode = dataRow["UserCode"].ToString().Trim();
  221. resultEntity.CurrentUserEntity.UserName = dataRow["UserName"].ToString().Trim();
  222. resultEntity.CurrentUserEntity.AccountID = Convert.ToInt16(dataRow["AccountID"].ToString().Trim());
  223. resultEntity.CurrentUserEntity.AccountCode = dataRow["AccountCode"].ToString().Trim();
  224. resultEntity.CurrentUserEntity.AccountName = dataRow["AccountName"].ToString().Trim();
  225. resultEntity.CurrentUserEntity.Password = dataRow["Password"].ToString().Trim();
  226. resultEntity.CurrentUserEntity.OrganizationID = Convert.ToInt16(dataRow["OrganizationID"].ToString().Trim());
  227. resultEntity.CurrentUserEntity.OrganizationCode = dataRow["OrganizationCode"].ToString().Trim();
  228. resultEntity.CurrentUserEntity.SessionKey = dataRow["SessionKey"].ToString().Trim();
  229. resultEntity.CurrentUserEntity.ValueFlag = Convert.ToInt16(dataRow["ValueFlag"].ToString().Trim());
  230. resultEntity.CurrentUserEntity.LimitMAC = dataRow["LimitMAC"].ToString().Trim();
  231. resultEntity.CurrentUserEntity.CanSmartLogin = Convert.ToInt16(dataRow["CanSmartLogin"].ToString().Trim());
  232. resultEntity.CurrentUserEntity.Remarks = dataRow["Remarks"].ToString().Trim();
  233. resultEntity.CurrentUserEntity.IsGroutingWorker = Convert.ToInt16(dataRow["IsGroutingWorker"].ToString());
  234. resultEntity.CurrentUserEntity.UserNavigationData = returnDataSet.Tables[1]; // 用户的主导航菜单数据
  235. resultEntity.CurrentUserEntity.UserRightData = returnDataSet.Tables[2];// 用户的功能权限限制数据
  236. resultEntity.CurrentUserEntity.UserRangeRightData = returnDataSet.Tables[3]; // 用户的范围权限限制数据
  237. resultEntity.CurrentUserEntity.FunctionData = returnDataSet.Tables[4]; //系统功能菜单
  238. #endregion
  239. }
  240. else if (paras[8] != null)
  241. {
  242. loginStatus = Convert.ToInt32(paras[8].Value.ToString());
  243. }
  244. else
  245. {
  246. loginStatus = -1;
  247. }
  248. resultEntity.LoginStatus = loginStatus;
  249. return resultEntity;
  250. }
  251. catch (Exception ex)
  252. {
  253. throw ex;
  254. }
  255. finally
  256. {
  257. if (oracleConn.ConnState == ConnectionState.Open)
  258. {
  259. oracleConn.Close();
  260. }
  261. }
  262. }
  263. /// <summary>
  264. /// 退出登录
  265. /// </summary>
  266. /// <param name="userID">用户ID</param>
  267. /// <param name="actionType">1:PC端;3:移动端</param>
  268. /// <param name="userInfo">用户基本信息</param>
  269. /// <returns>bool</returns>
  270. public static bool Logout(int userID, string actionType, SUserInfo userInfo)
  271. {
  272. IDBTransaction oracleTrConn = ClsDbFactory.CreateDBTransaction(DataBaseType.ORACLE, DataManager.ConnectionString);
  273. try
  274. {
  275. oracleTrConn.Connect();
  276. #region SQL语句形成
  277. string sqlString1 = "UPDATE TP_MST_UserLogin SET "
  278. + " IsLogin = '0',"
  279. + " SessionKey = NULL,"
  280. + " LastLogoutTime = sysdate"
  281. + " WHERE IsLogin = '1'"
  282. + " AND SessionKey = :SessionKey"
  283. + " AND UserID = :userID";
  284. OracleParameter[] parmeters1 = new OracleParameter[]
  285. {
  286. new OracleParameter(":SessionKey",userInfo.SessionKey),
  287. new OracleParameter(":userID",userID),
  288. };
  289. #endregion
  290. int i = oracleTrConn.ExecuteNonQuery(sqlString1, parmeters1);
  291. #region SQL语句形成
  292. string sqlString2 = "INSERT INTO TP_MST_UserLoginLog "
  293. + " (UserID"
  294. + " ,ActionTime"
  295. + " ,ActionType"
  296. + " ,MAC"
  297. + " ,ComputerName"
  298. + " ,IP) "
  299. + " VALUES "
  300. + " (:userID "
  301. + " ,systimestamp "
  302. + " ,:in_actionType"
  303. + " ,:in_MAC "
  304. + " ,:in_ComputerName "
  305. + " ,:in_IP) ";
  306. OracleParameter[] parmeters2 = new OracleParameter[]
  307. {
  308. new OracleParameter(":userID",userID)
  309. ,new OracleParameter(":in_actionType",actionType)
  310. ,new OracleParameter(":in_MAC",userInfo.MACAddress)
  311. ,new OracleParameter(":in_ComputerName",userInfo.ComputerName)
  312. ,new OracleParameter(":in_IP",userInfo.IPAddress)
  313. };
  314. #endregion
  315. oracleTrConn.ExecuteNonQuery(sqlString2, parmeters2);
  316. oracleTrConn.Commit();
  317. oracleTrConn.Disconnect();
  318. return true;
  319. }
  320. catch (Exception ex)
  321. {
  322. if (oracleTrConn.ConnState == ConnectionState.Open)
  323. {
  324. oracleTrConn.Rollback();
  325. }
  326. throw ex;
  327. }
  328. finally
  329. {
  330. if (oracleTrConn.ConnState == ConnectionState.Open)
  331. {
  332. oracleTrConn.Disconnect();
  333. }
  334. }
  335. }
  336. /// <summary>
  337. /// 服务访问验证
  338. /// </summary>
  339. /// <param name="requestEntity">验证实体</param>
  340. /// <param name="userInfo">用户基本信息</param>
  341. /// <returns>string</returns>
  342. public static string AuthenticateRepeatLogin(LoginRequestEntity requestEntity, out SUserInfo userInfo)
  343. {
  344. userInfo = null;
  345. if (DataManager.LicDataSet != null)
  346. {
  347. DateTime vBegin = Convert.ToDateTime(DataManager.LicDataSet.Tables["Info"].Rows[0]["ValidityBegin"]);
  348. DateTime vEnd = Convert.ToDateTime(DataManager.LicDataSet.Tables["Info"].Rows[0]["ValidityEnd"]);
  349. DateTime n = DateTime.Now.Date;
  350. if (n < vBegin || n > vEnd)
  351. {
  352. return "3";
  353. }
  354. }
  355. IDBConnection oracleConn = ClsDbFactory.CreateDBConnection(DataBaseType.ORACLE, DataManager.ConnectionString);
  356. try
  357. {
  358. oracleConn.Open();
  359. int loginStatus = 0;
  360. OracleParameter[] paras = new OracleParameter[]{
  361. new OracleParameter("in_accountCode", OracleDbType.Varchar2, requestEntity.AccountCode,ParameterDirection.Input),
  362. new OracleParameter("in_userCode", OracleDbType.Varchar2, requestEntity.UserCode,ParameterDirection.Input),
  363. new OracleParameter("in_userPassword", OracleDbType.Varchar2, requestEntity.Password,ParameterDirection.Input),
  364. new OracleParameter("in_sessionKey", OracleDbType.Varchar2, requestEntity.SessionKey,ParameterDirection.Input),
  365. new OracleParameter("out_loginStatus", OracleDbType.Int32, ParameterDirection.Output),
  366. new OracleParameter("out_userInfo", OracleDbType.RefCursor, ParameterDirection.Output)
  367. };
  368. DataSet dsUserInfo = oracleConn.ExecStoredProcedure("PRO_SYS_Authentication", paras);
  369. loginStatus = Convert.ToInt32(paras[4].Value.ToString());
  370. if (loginStatus == 0)
  371. {
  372. if (dsUserInfo != null && dsUserInfo.Tables[0].Rows.Count > 0)
  373. {
  374. userInfo = new SUserInfo();
  375. userInfo.UserID = System.Convert.ToInt32(dsUserInfo.Tables[0].Rows[0]["UserID"]);
  376. userInfo.UserCode = System.Convert.ToString(dsUserInfo.Tables[0].Rows[0]["UserCode"]);
  377. userInfo.UserName = System.Convert.ToString(dsUserInfo.Tables[0].Rows[0]["UserName"]);
  378. userInfo.OrganizationID = System.Convert.ToInt32(dsUserInfo.Tables[0].Rows[0]["OrganizationID"]);
  379. userInfo.OrganizationCode = System.Convert.ToString(dsUserInfo.Tables[0].Rows[0]["OrganizationCode"]);
  380. userInfo.AccountID = System.Convert.ToInt32(dsUserInfo.Tables[0].Rows[0]["AccountID"]);
  381. userInfo.AccountCode = System.Convert.ToString(dsUserInfo.Tables[0].Rows[0]["AccountCode"]);
  382. userInfo.MACAddress = System.Convert.ToString(dsUserInfo.Tables[0].Rows[0]["MAC"]);
  383. userInfo.ComputerName = System.Convert.ToString(dsUserInfo.Tables[0].Rows[0]["Computername"]);
  384. userInfo.IPAddress = System.Convert.ToString(dsUserInfo.Tables[0].Rows[0]["IP"]);
  385. userInfo.SessionKey = requestEntity.SessionKey;
  386. }
  387. else
  388. {
  389. return "1"; // wangxin 20150416 else后添加的
  390. }
  391. }
  392. return loginStatus.ToString();
  393. }
  394. finally
  395. {
  396. if (oracleConn.ConnState == ConnectionState.Open)
  397. {
  398. oracleConn.Close();
  399. }
  400. }
  401. }
  402. #endregion
  403. #region 客户端升级
  404. /// <summary>
  405. /// 客户端升级判断
  406. /// </summary>
  407. /// <param name="version">客户端版本号</param>
  408. /// <returns>NeedUpgradeResultEntity客户端是否需要更新信息</returns>
  409. public static NeedUpgradeResultEntity IsNeedUpgrade(string version, string dllVersion)
  410. {
  411. string serverVersion = INIUtility.Instance(INIUtility.IniFile.Config).ReadIniData("VersionSetting", "ClientVersion");//ConfigurationManager.AppSettings["ServerVersion"];
  412. NeedUpgradeResultEntity result = new NeedUpgradeResultEntity();
  413. result.ServerVersion = serverVersion;
  414. result.UpgradeState = false;
  415. result.GradeInfo = "";
  416. string[] versions = version.Split('.');
  417. string[] serverVersions = serverVersion.Split('.');
  418. if (versions == null || serverVersions == null || versions.Length != 4 || serverVersions.Length != 4)
  419. {
  420. result.UpgradeState = false;
  421. result.GradeInfo = "服务端版本信息获取异常,请联系系统管理员。";
  422. return result;
  423. }
  424. //string dbVersion = null;
  425. //try
  426. //{
  427. // IDBConnection oracleConn = ClsDbFactory.CreateDBConnection(DataBaseType.ORACLE, DataManager.ConnectionString);
  428. // oracleConn.Open();
  429. // dbVersion = oracleConn.GetSqlResultToStr("select Version from T_SYS_UpgradeRecord where releaseid=0");
  430. //}
  431. //catch
  432. //{
  433. // result.UpgradeState = false;
  434. // result.GradeInfo = "数据库版本信息获取异常,请联系系统管理员。";
  435. // return result;
  436. //}
  437. //if (dbVersion == null)
  438. //{
  439. // result.UpgradeState = false;
  440. // result.GradeInfo = "数据库版本信息获取异常,请联系系统管理员。";
  441. // return result;
  442. //}
  443. //if (dbVersion != serverVersion || dbVersion != dllVersion)
  444. //{
  445. // result.UpgradeState = false;
  446. // result.GradeInfo = string.Format("服务端版本信息不一致,请联系系统管理员。{3}服务INI版本【{0}】{3}服务DLL版本【{1}】{3}数据DBR版本【{2}】",
  447. // serverVersion, dllVersion, dbVersion, System.Environment.NewLine);
  448. // return result;
  449. //}
  450. if (versions[1] != "0" && versions[1] != serverVersions[1])
  451. {
  452. result.UpgradeState = false;
  453. result.GradeInfo = string.Format("客户端[{0}]与服务端[{1}]的客户号(版本号第二位)不一致,此客户端不能连接服务器。", version, serverVersion);
  454. }
  455. for (int j = 0; j < versions.Length; j++)
  456. {
  457. int sv = Convert.ToInt32(serverVersions[j]);
  458. int cv = Convert.ToInt32(versions[j]);
  459. if (sv > cv)
  460. {
  461. result.UpgradeState = true;
  462. result.GradeInfo = LoadUpgradeInfo(version, serverVersion);
  463. break;
  464. }
  465. else if (sv < cv)
  466. {
  467. result.UpgradeState = false;
  468. result.GradeInfo = string.Format("客户端版本[{0}]比服务器版本[{1}]高,此客户端不能连接服务器。", version, serverVersion);
  469. }
  470. }
  471. return result;
  472. }
  473. /// <summary>
  474. /// 获取更新履历信息
  475. /// </summary>
  476. /// <param name="version">客户端版本号</param>
  477. /// <param name="serverVersion">最新版本号</param>
  478. /// <returns>string升级信息</returns>
  479. private static string LoadUpgradeInfo(string version, string serverVersion)
  480. {
  481. #region 查询字符串
  482. //string sqlString = "SELECT UpgradeInfoID"
  483. // + ",VersionNo"
  484. // + ",UpgradeType"
  485. // + ",Content"
  486. // + ",CreateTime"
  487. // + " FROM T_SYS_UpgradeInfo"
  488. // + " WHERE UpgradeType = 0";
  489. //if (!string.IsNullOrEmpty(serverVersion) && !string.IsNullOrEmpty(version))
  490. //{
  491. // sqlString = string.Format("{0} AND VersionNo > '{1}' AND VersionNo <= '{2}'", sqlString, version, serverVersion);
  492. // DataSet returnData = DataManager.ExecuteDataset(sqlString);
  493. //}
  494. #endregion
  495. return null;
  496. }
  497. /// <summary>
  498. /// 下载更新程序
  499. /// </summary>
  500. /// <returns>byte[]更新程序</returns>
  501. public static byte[] DownloadUpgradeFile(string flag = null)
  502. {
  503. string filePath = null;
  504. string fup = null;
  505. if (flag == "Public")
  506. {
  507. filePath = "UpgradePublicDownLoadPath";
  508. fup = @"-UpgradePublic.up";
  509. }
  510. else
  511. {
  512. filePath = "UpgradeDownLoadPath";
  513. fup = @"-Upgrade.up";
  514. }
  515. filePath = INIUtility.Instance(INIUtility.IniFile.Config).ReadIniData("PathSetting", filePath);
  516. //ConfigurationManager.AppSettings["UpgradeDownLoadPath"];
  517. // 取得WEB服务器上的文件全路径
  518. string fileFullPath = System.AppDomain.CurrentDomain.BaseDirectory + filePath;
  519. lock (_downloadUpgradeFile)
  520. {
  521. if (!Directory.Exists(fileFullPath))
  522. {
  523. Directory.CreateDirectory(fileFullPath);
  524. }
  525. // zip 压缩
  526. string zipPath = fileFullPath + fup;
  527. if (!File.Exists(zipPath))
  528. {
  529. ZipFileClass.DirectoryToZip(fileFullPath, zipPath);
  530. }
  531. // 文件存在,则将文件读入文件流中返回
  532. if (File.Exists(zipPath))
  533. {
  534. using (FileStream fileStream = new FileStream(zipPath, FileMode.Open, FileAccess.Read))
  535. {
  536. BinaryReader binaryReader = new BinaryReader(fileStream);
  537. return binaryReader.ReadBytes((int)fileStream.Length);
  538. }
  539. }
  540. }
  541. return null;
  542. }
  543. #endregion
  544. }
  545. }