//数据库连接 ZAM 2015-5-22 public bool Connect() { bool ret = false; try { DataConnection.count++; CacheConnectionObject.Open(); /*#region<"CachePool Monitor"> * // CachePool Monitor ZAM 2015-5-22 * int activeCount = CachePoolManager.ActiveConnectionCount; * int idleCount = CachePoolManager.IdleCount(CacheConnectionObject); * int inUseCount = CachePoolManager.InUseCount(CacheConnectionObject); * * HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Service: " + this.serviceID + " DCount: " + DataConnection.count + " CID: " + ConnectID + " State: " + CacheConnectionObject.State.ToString() + " ID: " + CacheConnectionObject.CacheJobID, ""); * HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Active " + activeCount + " idle: " + idleCount + " inUse:" + inUseCount + " ", ""); * #endregion*/ ret = true; } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "", "数据库连接失败! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); throw ex; } return(ret); }
/// <summary> /// Changes the time format. /// </summary> /// <returns></returns> public static string ChgTimeFormat(string TimeString) { string strTime = TimeString; string strTimeDelimiter = ":"; try { if (TimeString.Split(Convert.ToChar(strTimeDelimiter)).Length > 1) { //hh:mm → hhmm strTime = TimeString.Replace(strTimeDelimiter, string.Empty); } else { //hhmm → hh:mm // 20141202 ZAM string tempstr = ("0000" + TimeString); strTime = tempstr.Substring(tempstr.Length - 4, 4); strTime = strTime.Substring(0, 2) + strTimeDelimiter + strTime.Substring(2, 2); } } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "", "ChgTimeFormat! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); throw ex; } return(strTime); }
/// <summary> /// Changes the date format. /// </summary> /// <returns></returns> public static string ChgDateFormat(string DateString) { string strDate = DateString; string strDateDelimiter = "/"; try { switch (DateString.Length) { case 8: //YYYYMMDD → e.g)YYYY/MM/DD strDate = DateString.Substring(0, 4) + strDateDelimiter + DateString.Substring(4, 2) + strDateDelimiter + DateString.Substring(6, 2); break; case 10: //e.g)YYYY/MM/DD → YYYYMMDD strDate = DateString.Replace(strDateDelimiter, string.Empty); break; default: break; } } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "", "ChgDateFormat! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); throw ex; } return(strDate); }
//CaculateWeekDay 判断日期是星期几 syf 2015-10-10 public string CaculateWeekDay(string date) { string week = "星期一"; //待标记颜色 try { string weekDayEn = Convert.ToDateTime(date).DayOfWeek.ToString(); switch (weekDayEn) { case "Monday": week = "星期一"; break; case "Tuesday": week = "星期二"; break; case "Wednesday": week = "星期三"; break; case "Thursday": week = "星期四"; break; case "Friday": week = "星期五"; break; case "Saturday": week = "星期六"; break; case "Sunday": week = "星期日"; break; default: break; } return(week); } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsCompliance.CaculateWeekDay", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return(null); } }
//数据库断开连接 ZAM 2015-5-22 public bool DisConnect() { bool ret = false; try { DataConnection.count--; CacheConnectionObject.Close(); ret = true; } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "", "数据库断开连接失败! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); throw ex; } return(ret); }
//获取服务器日期(解决频繁连接导致的连接未及时关闭) GL 2015-10-13 public int GetServerDate() { string serverDate = string.Empty; int date = 99999999; try { //ZAM 2015-5-7 频繁连接导致的连接未及时关闭 { if (!pclsCache.Connect()) { return(date); } } serverDate = Cm.CommonLibrary.GetServerDateTime(pclsCache.CacheConnectionObject); //2014/08/22 15:33:35 string[] str = serverDate.Split(' '); if (str.Length >= 1) { serverDate = str[0]; serverDate = serverDate.Replace("/", string.Empty); date = Convert.ToInt32(serverDate); } return(date); } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "GetServerDate", "CommonFunction error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return(date); throw (ex); } finally { pclsCache.DisConnect(); } }
/// <summary> /// 时间格式转换 GL 2015-10-10 /// </summary> /// <param name="time"></param> /// <returns></returns> public string TransTime(string time) { int length = time.Length; string result = ""; try { switch (length) { case 1: result = "00:0" + time; break; case 2: result = "00:" + time; break; case 3: result = "0" + time.Substring(0, 1) + ":" + time.Substring(1, 2); break; case 4: result = time.Substring(0, 2) + ":" + time.Substring(2, 2); //Substring(起始, 截取长度) break; default: break; } return(result); } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "CommonMethod.TransTime", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return(null); } }