public IRAPJsonResult ufn_EWI_GetInfo_ShowPaper( int communityID, int processLeaf, int workUnitLeaf, long sysLogID, out int errCode, out string errText) { string strProcedureName = string.Format( "{0}.{1}", className, MethodBase.GetCurrentMethod().Name); WriteLog.Instance.WriteBeginSplitter(strProcedureName); try { EWIShowPaperInfo data = new EWIShowPaperInfo(); #region 创建数据库调用参数组,并赋值 IList <IDataParameter> paramList = new List <IDataParameter>(); paramList.Add(new IRAPProcParameter("@CommunityID", DbType.Int32, communityID)); paramList.Add(new IRAPProcParameter("@ProcessLeaf", DbType.Int32, processLeaf)); paramList.Add(new IRAPProcParameter("@WorkUnitLeaf", DbType.Int32, workUnitLeaf)); paramList.Add(new IRAPProcParameter("@SysLogID", DbType.Int64, sysLogID)); WriteLog.Instance.Write( string.Format( "调用函数 IRAPFVS..ufn_EWI_GetInfo_ShowPaper," + "参数:CommunityID={0}|ProcessLeaf={1}|WorkUnitLeaf={2}|SysLogID={3}", communityID, processLeaf, workUnitLeaf, sysLogID), strProcedureName); #endregion #region 执行数据库函数或存储过程 try { using (IRAPSQLConnection conn = new IRAPSQLConnection()) { string strSQL = "SELECT * " + "FROM IRAPFVS..ufn_EWI_GetInfo_ShowPaper(" + "@CommunityID, @ProcessLeaf, @WorkUnitLeaf, @SysLogID)"; IList <EWIShowPaperInfo> lstDatas = conn.CallTableFunc <EWIShowPaperInfo>(strSQL, paramList); if (lstDatas.Count > 0) { data = lstDatas[0].Clone(); } errCode = 0; errText = string.Format("调用成功!共获得 {0} 条记录", lstDatas.Count); WriteLog.Instance.Write(errText, strProcedureName); } } catch (Exception error) { errCode = 99000; errText = string.Format("调用 IRAPFVS..ufn_EWI_GetInfo_ShowPaper 函数发生异常:{0}", error.Message); WriteLog.Instance.Write(errText, strProcedureName); WriteLog.Instance.Write(error.StackTrace, strProcedureName); } #endregion return(Json(data)); } finally { WriteLog.Instance.WriteEndSplitter(strProcedureName); } }
private void ShowProductWI(int t120LeafID, int workUnitLeafID) { if (tpProductWI.PageVisible) { string strProcedureName = string.Format( "{0}.{1}", className, MethodBase.GetCurrentMethod().Name); WriteLog.Instance.WriteBeginSplitter(strProcedureName); try { int errCode = 0; string errText = ""; EWIShowPaperInfo data = new EWIShowPaperInfo(); IRAPFVSClient.Instance.ufn_EWI_GetInfo_ShowPaper( IRAPUser.Instance.CommunityID, t120LeafID, workUnitLeafID, IRAPUser.Instance.SysLogID, ref data, out errCode, out errText); WriteLog.Instance.Write( string.Format("({0}){1}", errCode, errText), strProcedureName); if (errCode != 0) { IRAPMessageBox.Instance.Show( errText, tpProductWI.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } else { tpProductWI.Text = string.Format( "{0}_{1}_{2}", data.PartNumber, data.WorkUnit, data.VersionNo); string prdtUrl = string.Format( url, data.PartNumber, data.WorkUnit, data.VersionNo, IRAPUser.Instance.SysLogID); WriteLog.Instance.Write( string.Format("作业指导书显示的地址:[{0}]", prdtUrl), strProcedureName); wbProductWIShow.Navigate(prdtUrl); } } catch (Exception error) { WriteLog.Instance.Write(error.Message, strProcedureName); WriteLog.Instance.Write(error.StackTrace, strProcedureName); IRAPMessageBox.Instance.Show( error.Message, tpProductWI.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { WriteLog.Instance.WriteEndSplitter(strProcedureName); } } }