/// <summary> /// 获取用户名及密码的验证结果 /// </summary> /// <param name="userCode"></param> /// <param name="plainPWD"></param> /// <param name="veriCode"></param> /// <param name="errCode"></param> /// <param name="errText"></param> /// <returns>false:验证不通过;true:验证通过</returns> public bool sfn_UserPWDVerify( string userCode, string plainPWD, string veriCode, out int errCode, out string errText) { string strProcedureName = string.Format( "{0}.{1}", className, MethodBase.GetCurrentMethod().Name); WriteLog.Instance.WriteBeginSplitter(strProcedureName); try { #region 创建数据库调用参数组,并赋值 IList <IDataParameter> paramList = new List <IDataParameter>(); paramList.Add(new IRAPProcParameter("@UserCode", DbType.String, userCode)); paramList.Add(new IRAPProcParameter("@PlainPWD", DbType.String, plainPWD)); paramList.Add(new IRAPProcParameter("@VeriCode", DbType.String, veriCode)); WriteLog.Instance.Write( $"调用函数 IRAP.dbo.sfn_UserPWDVerify,参数:UserCode={userCode}|" + $"PlainPWD={plainPWD}|VeriCode={veriCode}", strProcedureName); #endregion #region 执行数据库函数或存储过程 try { using (IRAPSQLConnection conn = new IRAPSQLConnection( TParams.Instance.DBConnectionStr)) { bool rlt = (bool)conn.CallScalarFunc("IRAP.dbo.sfn_UserPWDVerify", paramList); errCode = 0; errText = $"调用成功!获得函数结果 ({rlt})"; WriteLog.Instance.Write(errText, strProcedureName); return(rlt); } } catch (Exception error) { errCode = 99000; errText = string.Format("调用 IRAP.dbo.sfn_UserPWDVerify 函数发生异常:{0}", error.Message); WriteLog.Instance.Write(errText, strProcedureName); WriteLog.Instance.Write(error.StackTrace, strProcedureName); return(false); } #endregion } finally { WriteLog.Instance.WriteEndSplitter(strProcedureName); } }
/// <param name="communityID">社区标识</param> /// <param name="sysLogID">系统登录标识</param> public IRAPJsonResult ufn_GetT134ClickStream( int communityID, long sysLogID, out int errCode, out string errText) { string strProcedureName = string.Format( "{0}.{1}", className, MethodBase.GetCurrentMethod().Name); WriteLog.Instance.WriteBeginSplitter(strProcedureName); try { string data = ""; #region 创建数据库调用参数组,并赋值 IList <IDataParameter> paramList = new List <IDataParameter>(); paramList.Add(new IRAPProcParameter("@CommunityID", DbType.Int32, communityID)); paramList.Add(new IRAPProcParameter("@SysLogID", DbType.Int64, sysLogID)); WriteLog.Instance.Write( string.Format( "调用函数 IRAPFVS..ufn_GetT134ClickStream," + "参数:CommunityID={0}|SysLogID={1}", communityID, sysLogID), strProcedureName); #endregion #region 执行数据库函数或存储过程 try { using (IRAPSQLConnection conn = new IRAPSQLConnection()) { data = (string)conn.CallScalarFunc("IRAPFVS.dbo.ufn_GetT134ClickStream", paramList); errCode = 0; errText = string.Format("调用成功!获得返回值:{0}", data); WriteLog.Instance.Write(errText, strProcedureName); } } catch (Exception error) { errCode = 99000; errText = string.Format("调用 IRAPFVS..ufn_GetT134ClickStream 函数发生异常:{0}", error.Message); WriteLog.Instance.Write(errText, strProcedureName); WriteLog.Instance.Write(error.StackTrace, strProcedureName); } #endregion return(Json(data)); } finally { WriteLog.Instance.WriteEndSplitter(strProcedureName); } }
public IRAPJsonResult sfn_DefaultFunctionToRun( int communityID, int systemID, long sysLogID, out int errCode, out string errText) { string strProcedureName = string.Format("{0}.{1}", className, MethodBase.GetCurrentMethod().Name); WriteLog.Instance.WriteBeginSplitter(strProcedureName); try { int rlt = 0; try { #region 创建数据库调用参数组,并赋值 IList <IDataParameter> paramList = new List <IDataParameter>(); paramList.Add(new IRAPProcParameter("@CommunityID", DbType.Int32, communityID)); paramList.Add(new IRAPProcParameter("@SystemID", DbType.Int32, systemID)); paramList.Add(new IRAPProcParameter("@SysLogID", DbType.Int64, sysLogID)); WriteLog.Instance.Write(string.Format("执行函数 IRAP..sfn_DefaultFunctionToRun,参数:" + "CommunityID={0}|SystemID={1}|SysLogID={2}", communityID, systemID, sysLogID), strProcedureName); #endregion #region 执行数据库函数或存储过程 using (IRAPSQLConnection conn = new IRAPSQLConnection()) { rlt = (int)conn.CallScalarFunc("IRAP.dbo.sfn_DefaultFunctionToRun", paramList); errCode = 0; errText = string.Format("调用成功,获得值: [{0}]", rlt); WriteLog.Instance.Write(errText, strProcedureName); } #endregion } catch (Exception error) { errCode = 99000; errText = string.Format("调用 IRAP.dbo.sfn_DefaultFunctionToRun 时发生异常:{0}", error.Message); WriteLog.Instance.Write(errText, strProcedureName); WriteLog.Instance.Write(error.StackTrace, strProcedureName); } return(Json(rlt)); } finally { WriteLog.Instance.WriteEndSplitter(strProcedureName); } }
/// <summary> /// /// </summary> /// <param name="portalCode"></param> /// <param name="errCode"></param> /// <param name="errText"></param> /// <returns>int PortalID</returns> public IRAPJsonResult sfn_GetID_Portal(string portalCode, out int errCode, out string errText) { string strProcedureName = string.Format( "{0}.{1}", className, MethodBase.GetCurrentMethod().Name); WriteLog.Instance.WriteBeginSplitter(strProcedureName); try { int rlt = 0; try { #region 创建数据库调用参数组,并赋值 IList <IDataParameter> paramList = new List <IDataParameter>(); paramList.Add(new IRAPProcParameter("@PortalCode", DbType.String, portalCode)); WriteLog.Instance.Write(string.Format("执行函数 IRAP.dbo.sfn_GetID_Portal,参数:" + "PortalCode={0}", portalCode), strProcedureName); #endregion #region 执行数据库函数或存储过程 using (IRAPSQLConnection conn = new IRAPSQLConnection()) { rlt = (int)conn.CallScalarFunc("IRAP.dbo.sfn_GetID_Portal", paramList); errCode = 0; errText = string.Format("调用成功,获得值: [{0}]", rlt); WriteLog.Instance.Write(errText, strProcedureName); } #endregion } catch (Exception error) { errCode = 99000; errText = string.Format("调用 IRAP.dbo.sfn_GetID_Portal 时发生异常:{0}", error.Message); WriteLog.Instance.Write(errText, strProcedureName); WriteLog.Instance.Write(error.StackTrace, strProcedureName); } return(Json(rlt)); } finally { WriteLog.Instance.WriteEndSplitter(strProcedureName); } }
/// <summary> /// 指定时区地方时转换为Unix时间 /// </summary> /// <returns>Unix时间 </returns> public IRAPJsonResult sfn_LocalToUnixTime(out int errCode, out string errText) { string strProcedureName = string.Format("{0}.{1}", className, MethodBase.GetCurrentMethod().Name); WriteLog.Instance.WriteBeginSplitter(strProcedureName); var localDateTime = DateTime.Now; int timeZone = 8; int result = 0; try { #region 创建数据库调用参数组,并赋值 IList <IDataParameter> paramList = new List <IDataParameter>(); paramList.Add(new IRAPProcParameter("@LocalDateTime", DbType.DateTime, localDateTime)); paramList.Add(new IRAPProcParameter("@TimeZone", DbType.Int16, timeZone)); WriteLog.Instance.Write( string.Format( "调用函数 IRAP..sfn_LocalToUnixTime,参数:LocalDateTime={0}|TimeZone={1}", localDateTime, timeZone), strProcedureName); #endregion #region 执行数据库函数或存储过程 try { using (IRAPSQLConnection conn = new IRAPSQLConnection()) { result = Convert.ToInt32(conn.CallScalarFunc("IRAP.dbo.sfn_LocalToUnixTime", paramList)); errCode = 0; errText = "调用函数 IRAP..sfn_LocalToUnixTime成功"; WriteLog.Instance.Write(errText, strProcedureName); } } catch (Exception ex) { IRAPError errInfo = new IRAPError(9999, ex.Message); errCode = 9999; errText = string.Format("调用函数 IRAP..sfn_LocalToUnixTime异常:{0}", ex.Message); WriteLog.Instance.Write(errText, strProcedureName); WriteLog.Instance.Write(ex.StackTrace, strProcedureName); } #endregion } finally { WriteLog.Instance.WriteEndSplitter(strProcedureName); } return(Json(result)); }
/// <summary> /// 获取包装工位需要打印的标识串 /// </summary> /// <param name="communityID">社区标识</param> /// <param name="correlationID">C64 关联号</param> /// <param name="ordinal">C64 包装行集序号</param> /// <param name="labelType">标签类型(3种)</param> /// <param name="nowTime">当前事件</param> /// <param name="sysLogID">系统登录标识</param> public IRAPJsonResult ufn_GetNextPackageSN( int communityID, int correlationID, int ordinal, string labelType, DateTime nowTime, long sysLogID, out int errCode, out string errText) { string strProcedureName = string.Format( "{0}.{1}", className, MethodBase.GetCurrentMethod().Name); WriteLog.Instance.WriteBeginSplitter(strProcedureName); try { #region 创建数据库调用参数组,并赋值 IList <IDataParameter> paramList = new List <IDataParameter>(); paramList.Add(new IRAPProcParameter("@CommunityID", DbType.Int32, communityID)); paramList.Add(new IRAPProcParameter("@CorrelationID", DbType.Int32, correlationID)); paramList.Add(new IRAPProcParameter("@Ordinal", DbType.Int32, ordinal)); paramList.Add(new IRAPProcParameter("@LabelType", DbType.String, labelType)); paramList.Add(new IRAPProcParameter("@NowTime", DbType.DateTime, nowTime)); paramList.Add(new IRAPProcParameter("@SysLogID", DbType.Int64, sysLogID)); WriteLog.Instance.Write( string.Format( "调用函数 IRAPMES.dbo.ufn_GetNextPackageSN,参数:" + "CommunityID={0}|CorrelationID={1}|Ordinal={2}|" + "LabelType={3}|NowTime={4}|SysLogID={5}", communityID, correlationID, ordinal, labelType, nowTime, sysLogID), strProcedureName); #endregion #region 执行数据库函数或存储过程 try { using (IRAPSQLConnection conn = new IRAPSQLConnection()) { string rlt = (string)conn.CallScalarFunc( "IRAPMES.dbo.ufn_GetNextPackageSN", paramList); errCode = 0; errText = "调用成功!"; WriteLog.Instance.Write(errText, strProcedureName); return(Json(rlt)); } } catch (Exception error) { errCode = 99000; errText = string.Format( "调用 IRAPMES.dbo.ufn_GetNextPackageSN 函数发生异常:{0}", error.Message); WriteLog.Instance.Write(errText, strProcedureName); WriteLog.Instance.Write(error.StackTrace, strProcedureName); return(Json("")); } #endregion } finally { WriteLog.Instance.WriteEndSplitter(strProcedureName); } }
/// <summary> /// 获取用户名及密码验证的结果(0:验证不通过;-1:信息站点未注册;>0:验证通过,返回社区标识号) /// </summary> /// <param name="userCode">用户代码</param> /// <param name="plainPWD">用户密码明码</param> /// <param name="veriCode">验证码,不需时传空串</param> /// <param name="stationID">验证站点或社区标识</param> public IRAPJsonResult sfn_UserPWDVerify( string userCode, string plainPWD, string veriCode, string stationID, out int errCode, out string errText) { string strProcedureName = string.Format( "{0}.{1}", className, MethodBase.GetCurrentMethod().Name); WriteLog.Instance.WriteBeginSplitter(strProcedureName); try { #region 创建数据库调用参数组,并赋值 IList <IDataParameter> paramList = new List <IDataParameter>(); paramList.Add(new IRAPProcParameter("@UserCode", DbType.String, userCode)); paramList.Add(new IRAPProcParameter("@PlainPWD", DbType.String, plainPWD)); paramList.Add(new IRAPProcParameter("@VeriCode", DbType.String, veriCode)); paramList.Add(new IRAPProcParameter("@StationID", DbType.String, stationID)); WriteLog.Instance.Write( string.Format( "调用函数 IRAP.dbo.sfn_UserPWDVerify,参数:UserCode={0}|" + "PlainPWD={1}|VeriCode={2}|StationID={3}", userCode, plainPWD, veriCode, stationID), strProcedureName); #endregion #region 执行数据库函数或存储过程 try { using (IRAPSQLConnection conn = new IRAPSQLConnection()) { int rlt = (int)conn.CallScalarFunc("IRAP.dbo.sfn_UserPWDVerify", paramList); if (rlt == -1) { errCode = -1; errText = string.Format( "站点[{0}]未注册!", stationID); } else { errCode = 0; errText = "调用成功!"; } WriteLog.Instance.Write(errText, strProcedureName); return(Json(rlt)); } } catch (Exception error) { errCode = 99000; errText = string.Format("调用 IRAP.dbo.sfn_UserPWDVerify 函数发生异常:{0}", error.Message); WriteLog.Instance.Write(errText, strProcedureName); WriteLog.Instance.Write(error.StackTrace, strProcedureName); return(Json(0)); } #endregion } finally { WriteLog.Instance.WriteEndSplitter(strProcedureName); } }
/// <summary> /// 根据工位呼叫安灯记录计算工位停产时间(秒) /// [功能假定同一工位异常事件不重叠] /// </summary> /// <param name="communityID">社区标识</param> /// <param name="t107LeafID">工位叶标识</param> /// <param name="periodBegin">期间开始时间</param> /// <param name="periodEnd">期间结束时间</param> /// <param name="sysLogID">系统登录标识</param> /// <returns>long[异常停产时间(s)]</returns> public IRAPJsonResult ufn_GetUnscheduledPDTofAWorkUnit( int communityID, int t107LeafID, DateTime periodBegin, DateTime periodEnd, long sysLogID, out int errCode, out string errText) { string strProcedureName = string.Format( "{0}.{1}", className, MethodBase.GetCurrentMethod().Name); WriteLog.Instance.WriteBeginSplitter(strProcedureName); try { long rlt = 0; #region 创建数据库调用参数组,并赋值 IList <IDataParameter> paramList = new List <IDataParameter>(); paramList.Add(new IRAPProcParameter("@CommunityID", DbType.Int32, communityID)); paramList.Add(new IRAPProcParameter("@T107LeafID", DbType.String, t107LeafID)); paramList.Add(new IRAPProcParameter("@PeriodBegin", DbType.DateTime2, periodBegin)); paramList.Add(new IRAPProcParameter("@PeriodEnd", DbType.DateTime2, periodEnd)); paramList.Add(new IRAPProcParameter("@SysLogID", DbType.Int64, sysLogID)); WriteLog.Instance.Write( string.Format( "调用函数 IRAPMES.dbo.ufn_GetUnscheduledPDTofAWorkUnit," + "参数:CommunityID={0}|T107LeafID={1}|PeridoBegin={2}|" + "PeriodEnd={3}|SysLogID={4}", communityID, t107LeafID, periodBegin, periodEnd, sysLogID), strProcedureName); #endregion #region 执行数据库函数或存储过程 try { using (IRAPSQLConnection conn = new IRAPSQLConnection()) { rlt = (long)conn.CallScalarFunc( "IRAPMES.dbo.ufn_GetUnscheduledPDTofAWorkUnit", paramList); if (rlt > -2147483648) { errCode = 0; errText = string.Format( "调用成功!获得 UnscheduledPDTofAWorkUnit={0}", rlt); WriteLog.Instance.Write(errText, strProcedureName); } else { errCode = 99999; errText = "未得到 UnscheduledPDTofAWorkUnit 的值"; } } } catch (Exception error) { errCode = 99000; errText = string.Format( "调用 IRAPMES.dbo.ufn_GetUnscheduledPDTofAWorkUnit 函数发生异常:{0}", error.Message); WriteLog.Instance.Write(errText, strProcedureName); } #endregion return(Json(rlt)); } finally { WriteLog.Instance.WriteEndSplitter(strProcedureName); WriteLog.Instance.Write(""); } }
/// <summary> /// 获取指定在制品经过指定工位的次数 /// </summary> /// <param name="communityID">社区标识</param> /// <param name="t102LeafID">产品叶标识</param> /// <param name="t107LeafID">工位叶标识</param> /// <param name="wipCode">在制品主标识代码</param> public IRAPJsonResult ufn_GetWIPPassByTimes( int communityID, int t102LeafID, int t107LeafID, string wipCode, out int errCode, out string errText) { string strProcedureName = string.Format( "{0}.{1}", className, MethodBase.GetCurrentMethod().Name); WriteLog.Instance.WriteBeginSplitter(strProcedureName); try { int rlt = 0; #region 创建数据库调用参数组,并赋值 IList <IDataParameter> paramList = new List <IDataParameter>(); paramList.Add(new IRAPProcParameter("@CommunityID", DbType.Int32, communityID)); paramList.Add(new IRAPProcParameter("@T102LeafID", DbType.Int32, t102LeafID)); paramList.Add(new IRAPProcParameter("@T107LeafID", DbType.Int32, t107LeafID)); paramList.Add(new IRAPProcParameter("@WIPCode", DbType.String, wipCode)); WriteLog.Instance.Write( string.Format( "调用函数 IRAPMES.dbo.ufn_GetWIPPassByTimes,参数:" + "CommunityID={0}|T102LeafID={1}|T107LeafID={2}|WIPCode={3}", communityID, t102LeafID, t107LeafID, wipCode), strProcedureName); #endregion #region 执行数据库函数或存储过程 try { using (IRAPSQLConnection conn = new IRAPSQLConnection()) { rlt = (int)conn.CallScalarFunc( "IRAPMES.dbo.ufn_GetWIPPassByTimes", paramList); if (rlt > -2147483648) { errCode = 0; errText = string.Format("调用成功!获得 PassByTimes={0}", rlt); WriteLog.Instance.Write(errText, strProcedureName); } else { errCode = 99999; errText = "未得到 PassByTimes 的值"; } } } catch (Exception error) { errCode = 99000; errText = string.Format( "调用 IRAPMES.dbo.ufn_GetWIPPassByTimes 函数发生异常:{0}", error.Message); WriteLog.Instance.Write(errText, strProcedureName); } #endregion return(Json(rlt)); } finally { WriteLog.Instance.WriteEndSplitter(strProcedureName); WriteLog.Instance.Write(""); } }