/// <summary>
/// 获取未完成包装信息
/// </summary>
/// <param name="communityID">社区标识</param>
/// <param name="productLeaf">产品叶标识</param>
/// <param name="workUnitLeaf">工位叶标识</param>
/// <param name="packagingSpecNo">包装规格序号</param>
/// <param name="sysLogID">系统登录标识</param>
/// <returns></returns>
public IRAPJsonResult ufn_GetInfo_UncompletedPackage(
int communityID,
int productLeaf,
int workUnitLeaf,
int packagingSpecNo,
long sysLogID,
out int errCode,
out string errText)
{
string strProcedureName =
string.Format(
"{0}.{1}",
className,
MethodBase.GetCurrentMethod().Name);
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
UncompletedPackage data = new UncompletedPackage();
#region 创建数据库调用参数组，并赋值
IList <IDataParameter> paramList = new List <IDataParameter>();
paramList.Add(new IRAPProcParameter("@CommunityID", DbType.Int32, communityID));
paramList.Add(new IRAPProcParameter("@ProductLeaf", DbType.Int32, productLeaf));
paramList.Add(new IRAPProcParameter("@WorkUnitLeaf", DbType.Int32, workUnitLeaf));
paramList.Add(new IRAPProcParameter("@PackagingSpecNo", DbType.Int32, packagingSpecNo));
paramList.Add(new IRAPProcParameter("@SysLogID", DbType.Int64, sysLogID));
WriteLog.Instance.Write(
string.Format(
"调用函数 IRAPMES..ufn_GetInfo_UncompletedPackage，参数：CommunityID={0}|" +
"ProductLeaf={1}|WorkUnitLeaf={2}|PackagingSpecNo={3}|" +
"SysLogID={4}",
communityID, productLeaf, workUnitLeaf, packagingSpecNo,
sysLogID),
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
try
{
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
string strSQL = "SELECT * " +
"FROM IRAPMES..ufn_GetInfo_UncompletedPackage(" +
"@CommunityID, @ProductLeaf, @WorkUnitLeaf, " +
"@PackagingSpecNo, @SysLogID)";
WriteLog.Instance.Write(strSQL, strProcedureName);
IList <UncompletedPackage> lstDatas =
conn.CallTableFunc <UncompletedPackage>(strSQL, paramList);
if (lstDatas.Count > 0)
{
data = lstDatas[0].Clone();
errCode = 0;
errText = "调用成功！";
}
else
{
errCode = 99001;
errText = string.Format("在包装规格序号[{0}]在系统中不存在", packagingSpecNo);
}
WriteLog.Instance.Write(errText, strProcedureName);
}
}
catch (Exception error)
{
errCode = 99000;
errText =
string.Format(
"调用 IRAPMES..ufn_GetInfo_UncompletedPackage 函数发生异常：{0}",
error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
#endregion
return(Json(data));
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
/// <summary>
/// 获取未完成包装信息
/// </summary>
/// <param name="communityID">社区标识</param>
/// <param name="productLeaf">产品叶标识</param>
/// <param name="workUnitLeaf">工位叶标识</param>
/// <param name="packagingSpecNo">包装规格序号</param>
/// <param name="sysLogID">系统登录标识</param>
public void ufn_GetInfo_UncompletedPackage(
int communityID,
int productLeaf,
int workUnitLeaf,
int packagingSpecNo,
long sysLogID,
ref UncompletedPackage data,
out int errCode,
out string errText)
{
string strProcedureName =
string.Format(
"{0}.{1}",
className,
MethodBase.GetCurrentMethod().Name);
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
#region 将函数调用参数加入 HashTable 中
Hashtable hashParams = new Hashtable();
hashParams.Add("communityID", communityID);
hashParams.Add("productLeaf", productLeaf);
hashParams.Add("workUnitLeaf", workUnitLeaf);
hashParams.Add("packagingSpecNo", packagingSpecNo);
hashParams.Add("sysLogID", sysLogID);
WriteLog.Instance.Write(
string.Format(
"调用 ufn_GetInfo_UncompletedPackage，输入参数：" +
"CommunityID={0}|ProductLeaf={1}|WorkUnitLeaf={2}|" +
"PackagingSpecNo={3}|SysLogID={4}",
communityID,
productLeaf,
workUnitLeaf,
packagingSpecNo,
sysLogID),
strProcedureName);
#endregion
#region 执行存储过程或者函数
using (WCFClient client = new WCFClient())
{
object rlt = client.WCFRESTFul(
"IRAP.BL.MES.dll",
"IRAP.BL.MES.ProductPackage",
"ufn_GetInfo_UncompletedPackage",
hashParams,
out errCode,
out errText);
WriteLog.Instance.Write(
string.Format("({0}){1}",
errCode,
errText),
strProcedureName);
if (errCode == 0)
{
data = rlt as UncompletedPackage;
}
else
{
data = null;
}
}
#endregion
}
catch (Exception error)
{
errCode = -1001;
errText = error.Message;
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
