public IRAPJsonResult ufn_EWI_GetInfo_PSShowPaper(
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
{
EWIPSShowPaperInfo data = new EWIPSShowPaperInfo();
#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_PSShowPaper，" +
"参数：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_PSShowPaper(" +
"@CommunityID, @ProcessLeaf, @WorkUnitLeaf, @SysLogID)";
IList <EWIPSShowPaperInfo> lstDatas =
conn.CallTableFunc <EWIPSShowPaperInfo>(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_PSShowPaper 函数发生异常：{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 ShowGeneralWI(int t120LeafID, int workUnitLeafID)
{
if (tpGeneralWI.PageVisible)
{
string strProcedureName =
string.Format(
"{0}.{1}",
className,
MethodBase.GetCurrentMethod().Name);
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
int errCode = 0;
string errText = "";
EWIPSShowPaperInfo data = new EWIPSShowPaperInfo();
IRAPFVSClient.Instance.ufn_EWI_GetInfo_PSShowPaper(
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,
tpGeneralWI.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else
{
tpGeneralWI.Text =
string.Format(
"{0}_{1}_{2}",
data.ProductSeries,
data.WorkUnit,
data.VersionNo);
string prdtUrl =
string.Format(
url,
data.ProductSeries,
data.WorkUnit,
data.VersionNo,
IRAPUser.Instance.SysLogID);
WriteLog.Instance.Write(
string.Format("作业指导书显示的地址：[{0}]", prdtUrl),
strProcedureName);
wbGeneralWIShow.Navigate(prdtUrl);
}
}
catch (Exception error)
{
WriteLog.Instance.Write(error.Message, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
IRAPMessageBox.Instance.Show(
error.Message,
tpGeneralWI.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
}
