private static List <Entities.TTableStockDetail> GetDataRecord(
string strSQL,
IList <IDataParameter> paramList)
{
try
{
using (IRAPSQLConnection conn =
new IRAPSQLConnection(SysParams.Instance.DBConnectionString))
{
IList <Entities.TTableStockDetail> lstDatas =
conn.CallTableFunc <Entities.TTableStockDetail>(strSQL, paramList);
return(lstDatas.ToList());
}
}
catch (Exception error)
{
error.Data["ErrCode"] = 999999;
error.Data["ErrText"] =
string.Format(
"在获取四班库存记录时发生错误：[{0}]",
error.Message);
throw error;
}
}
public int GetLogs()
{
IList <IDataParameter> paramList = new List <IDataParameter>();
try
{
using (IRAPSQLConnection conn =
new IRAPSQLConnection(
SysParams.Instance.DBConnectionString))
{
string strSQL =
"SELECT * FROM IRAP..stb_Log_WebServiceShuttling " +
"WHERE ErrCode!=0 AND Retried=0 ORDER BY LinkedLogID";
IList <TEntityCustomLog> lstDatas =
conn.CallTableFunc <TEntityCustomLog>(strSQL, paramList);
ArrangeLogs(lstDatas.ToList(), ref logs);
}
}
catch (Exception error)
{
error.Data["ErrCode"] = 999999;
error.Data["ErrText"] =
string.Format(
"获取 IRAP..stb_Log_WebServiceShuttling 表的记录时发生异常：{0}",
error.Message);
throw error;
}
return(logs.Count);
}
private void GetLocations()
{
TWaitting.Instance.ShowWaitForm("正在获取库位列表");
IList <IDataParameter> paramList = new List <IDataParameter>();
try
{
using (IRAPSQLConnection conn =
new IRAPSQLConnection(
SysParams.Instance.DBConnectionString))
{
string strSQL =
"SELECT * FROM IRAPMDM..stb058 " +
"WHERE PartitioningKey=600100106 " +
"ORDER BY LeafID";
IList <TTableMDM058> lstDatas =
conn.CallTableFunc <TTableMDM058>(strSQL, paramList);
locations = lstDatas.ToList();
}
}
catch (Exception error)
{
locations.Clear();
error.Data["ErrCode"] = 999999;
error.Data["ErrText"] = error.Message;
throw error;
}
finally
{
TWaitting.Instance.CloseWaitForm();
}
}
public void usp_ImportMaterialReq(
int communityID,
long importID,
long sysLogID,
out int errCode,
out string errText)
{
string strProcedureName =
$"{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("@ImportID", DbType.Int64, importID));
paramList.Add(new IRAPProcParameter("@SysLogID", DbType.Int64, sysLogID));
paramList.Add(
new IRAPProcParameter(
"@ErrCode",
DbType.Int32,
ParameterDirection.Output,
4));
paramList.Add(
new IRAPProcParameter(
"@ErrText",
DbType.String,
ParameterDirection.Output,
400));
WriteLog.Instance.Write(
"执行存储过程 IRAPDPA..usp_ImportMaterialReq，参数：" +
$"CommunityID={communityID}|ImportID={importID}|SysLogID={sysLogID}",
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
using (IRAPSQLConnection conn =
new IRAPSQLConnection(
TParams.Instance.DBConnectionStr))
{
IRAPError error = conn.CallProc("IRAPDPA..usp_ImportMaterialReq", ref paramList);
errCode = error.ErrCode;
errText = error.ErrText;
WriteLog.Instance.Write(
string.Format("({0}){1}", errCode, errText),
strProcedureName);
}
#endregion
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("调用 IRAPDPA..usp_ImportMaterialReq 时发生异常：{0}", error.Message);
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
public static List <TTableMaterialStore> GetMaterialStore(string skuID)
{
try
{
using (IRAPSQLConnection conn =
new IRAPSQLConnection(SysParams.Instance.DBConnectionString))
{
IList <IDataParameter> paramList = new List <IDataParameter>();
paramList.Add(new IRAPProcParameter("@SKUID", DbType.String, skuID));
IList <TTableMaterialStore> lstDatas =
conn.CallTableFunc <TTableMaterialStore>(
"SELECT * FROM IRAPRIMCS..utb_MaterialStore " +
"WHERE SKUID=@SKUID",
paramList);
return(lstDatas.ToList());
}
}
catch (Exception error)
{
error.Data["ErrCode"] = 999999;
error.Data["ErrText"] =
string.Format(
"获取 SKUID[{0}] 物料的记录时发生异常：{1}",
skuID,
error.Message);
throw error;
}
}
public IRAPJsonResult msp_InsertIntoDBF_MO(
List <dpa_DBF_MO> datas,
out int errCode,
out string errText)
{
string strProcedureName =
string.Format(
"{0}.{1}",
className,
MethodBase.GetCurrentMethod().Name);
Hashtable rlt = new Hashtable();
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
try
{
int count = conn.BatchInsert(datas);
errCode = 0;
errText =
string.Format(
"在 IRAPDPA..dpa_DBF_MO 表中插入 [{0}] 条记录",
count);
}
catch (Exception error)
{
errCode = 99000;
errText =
string.Format(
"在向 IRAPDPA..dpa_DBF_MO 表中插入记录时发生异常：{0}",
error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
}
return(Json(rlt));
}
catch (Exception error)
{
errCode = 99000;
errText =
string.Format(
"在向 IRAPDPA..dpa_DBF_MO 表中插入记录时发生异常：{0}",
error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
return(Json(rlt));
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
/// <summary>
/// 申请系统登录标识 , 必要时也获取短信验证码
/// </summary>
/// <remarks>
/// UserCode string 用户代码
/// StationID string 站点标识/社区标识
/// 输出
/// SysLogID long 系统登录标识
/// SMSVeriCode string 短信验证码
/// </remarks>
/// <param name="userCode">用户代码</param>
/// <param name="stationID">站点标识/社区标识</param>
public IRAPJsonResult ssp_GetSysLogID(
string userCode,
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("@StationID", DbType.String, stationID));
paramList.Add(new IRAPProcParameter("@SysLogID", DbType.Int64, ParameterDirection.Output, 8));
paramList.Add(new IRAPProcParameter("@SMSVeriCode", DbType.String, ParameterDirection.Output, 10));
paramList.Add(new IRAPProcParameter("@ErrCode", DbType.Int32, ParameterDirection.Output, 4));
paramList.Add(new IRAPProcParameter("@ErrText", DbType.String, ParameterDirection.Output, 400));
#endregion
#region 执行数据库函数或存储过程
try
{
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
IRAPError error = conn.CallProc("IRAP..ssp_GetSysLogID", ref paramList);
errCode = error.ErrCode;
errText = error.ErrText;
Hashtable rlt = new Hashtable();
rlt = DBUtils.DBParamsToHashtable(paramList);
foreach (DictionaryEntry entry in rlt)
{
WriteLog.Instance.Write(
string.Format(
"[{0}]=[{1}]",
entry.Key,
entry.Value),
strProcedureName);
}
return(Json(rlt));
}
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("调用 ssp_GetSysLogID 函数发生异常：{0}", error.Message);
return(Json(new Hashtable()));
}
#endregion
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
public IRAPJsonResult ufn_GetKanban_AndonMaterialCall(
long sysLogID,
out int errCode,
out string errText)
{
string strProcedureName =
string.Format(
"{0}.{1}",
className,
MethodBase.GetCurrentMethod().Name);
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
List <AndonMaterialEvent> datas = new List <AndonMaterialEvent>();
#region 创建数据库调用参数组，并赋值
IList <IDataParameter> paramList = new List <IDataParameter>();
paramList.Add(new IRAPProcParameter("@SysLogID", DbType.Int64, sysLogID));
WriteLog.Instance.Write(
string.Format(
"调用函数 ufn_GetKanban_AndonMaterialCall，" +
"参数：SysLogID={0}",
sysLogID),
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
try
{
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
string strSQL = "SELECT * " +
"FROM ufn_GetKanban_AndonMaterialCall(" +
"@SysLogID) ORDER BY Ordinal";
IList <AndonMaterialEvent> lstDatas = conn.CallTableFunc <AndonMaterialEvent>(strSQL, paramList);
datas = lstDatas.ToList <AndonMaterialEvent>();
errCode = 0;
errText = string.Format("调用成功！共获得 {0} 条记录", datas.Count);
WriteLog.Instance.Write(errText, strProcedureName);
}
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("调用 ufn_GetKanban_AndonMaterialCall 函数发生异常：{0}", error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
#endregion
return(Json(datas));
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
public IRAPJsonResult sfn_AccessibleFilteredLeafSet(int communityID, int treeID, int scenarioIndex,
string dicingFilter, int nodeDepth, string keyword, long sysLogID, out int errCode, out string errText)
{
string strProcedureName = string.Format("{0}.{1}", className, MethodBase.GetCurrentMethod().Name);
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
List <LeafSet> datas = new List <LeafSet>();
#region 创建数据库调用参数组，并赋值
IList <IDataParameter> paramList = new List <IDataParameter>();
paramList.Add(new IRAPProcParameter("@communityID", DbType.Int32, communityID));
paramList.Add(new IRAPProcParameter("@treeID", DbType.Int32, treeID));
paramList.Add(new IRAPProcParameter("@scenarioIndex", DbType.Int32, scenarioIndex));
paramList.Add(new IRAPProcParameter("@dicingFilter", DbType.String, dicingFilter));
paramList.Add(new IRAPProcParameter("@nodeDepth", DbType.Int32, nodeDepth));
paramList.Add(new IRAPProcParameter("@keyword", DbType.String, keyword));
paramList.Add(new IRAPProcParameter("@sysLogID", DbType.Int64, sysLogID));
WriteLog.Instance.Write(
string.Format(
"调用函数 IRAP..sfn_AccessibleFilteredLeafSet，" +
"参数：communityID={0}|treeID={1}|scenarioIndex={2}|dicingFilter={3}|nodeDepth={4}|keyword={5}|sysLogID={6}",
communityID, treeID, scenarioIndex, dicingFilter, nodeDepth, keyword, sysLogID),
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
try
{
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
string strSQL = "SELECT * " +
"FROM IRAP..sfn_AccessibleFilteredLeafSet(" +
"@communityID, @treeID, @scenarioIndex, @dicingFilter, @nodeDepth, @keyword, @sysLogID)";
IList <LeafSet> lstDatas = conn.CallTableFunc <LeafSet>(strSQL, paramList);
datas = lstDatas.ToList <LeafSet>();
errCode = 0;
errText = string.Format("调用成功！共获得 {0} 条记录", datas.Count);
WriteLog.Instance.Write(errText, strProcedureName);
}
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("调用 IRAP..sfn_AccessibleFilteredLeafSet 函数发生异常：{0}", error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
#endregion
return(Json(datas));
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
/// <summary>
/// 获取机构中用户角色清单用于登录时角色选择
/// </summary>
/// <param name="userCode">用户代码</param>
public List <TRoleInfo> sfn_UserRoles(
string userCode,
out int errCode,
out string errText)
{
string strProcedureName =
$"{className}.{MethodBase.GetCurrentMethod().Name}";
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
List <TRoleInfo> datas = new List <TRoleInfo>();
#region 创建数据库调用参数组，并赋值
IList <IDataParameter> paramList = new List <IDataParameter>();
paramList.Add(new IRAPProcParameter("@UserCode", DbType.String, userCode));
WriteLog.Instance.Write(
"调用函数 IRAP..sfn_UserRolesInAgency，" +
$"参数：UserCode={userCode}",
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
try
{
using (IRAPSQLConnection conn =
new IRAPSQLConnection(
TParams.Instance.DBConnectionStr))
{
string strSQL = "SELECT * " +
"FROM IRAP..sfn_UserRoles(" +
"@UserCode)";
WriteLog.Instance.Write(strSQL, strProcedureName);
IList <TRoleInfo> lstDatas =
conn.CallTableFunc <TRoleInfo>(strSQL, paramList);
datas = lstDatas.ToList();
errCode = 0;
errText = string.Format("调用成功！共获得 {0} 条记录", datas.Count);
WriteLog.Instance.Write(errText, strProcedureName);
}
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("调用 IRAP..sfn_UserRolesInAgency 函数发生异常：{0}", error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
#endregion
return(datas);
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
/// <summary>
/// 获取社区级全局字串型参数清单
/// 1、当传入社区标识为 0 时，返回平台全局共享字串型参数清单
/// 2、当传入社区标识非 0 时，返回社区个性以及社区分享的平台字串型参数清单
/// </summary>
/// <param name="communityID">社区标识</param>
/// <param name="languageID">语言标识：0-英文；30-简体中文；28=繁体中文</param>
/// <param name="filterParamIDs">参数标识号</param>
/// <returns></returns>
public IRAPJsonResult sfn_IRAPStrParameters(int communityID, int languageID, string filterParamIDs, out int errCode, out string errText)
{
string strProcedureName = string.Format("{0}.{1}",
className,
MethodBase.GetCurrentMethod().Name);
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
List <StrParamInfo> datas = new List <StrParamInfo>();
try
{
#region 创建数据库调用参数组，并赋值
IList <IDataParameter> paramList = new List <IDataParameter>();
paramList.Add(new IRAPProcParameter("@CommunityID", DbType.Int32, communityID));
paramList.Add(new IRAPProcParameter("@LanguageID", DbType.Int32, languageID));
WriteLog.Instance.Write(string.Format("执行函数 IRAP..sfn_IRAPStrParameters，参数：" +
"CommunityID={0}|LanguageID={1}|ParameterID={2}",
communityID, languageID, filterParamIDs),
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
string strSQL = "SELECT * " +
"FROM IRAP..sfn_IRAPStrParameters(@CommunityID, " +
"@LanguageID)";
if (filterParamIDs != "")
{
strSQL += string.Format(" WHERE ParameterID IN ({0})", filterParamIDs);
}
IList <StrParamInfo> lstDatas = conn.CallTableFunc <StrParamInfo>(strSQL, paramList);
datas = lstDatas.ToList <StrParamInfo>();
errCode = 0;
errText = string.Format("调用成功，共获得 {0} 条记录", datas.Count);
WriteLog.Instance.Write(errText, strProcedureName);
}
#endregion
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("调用 IRAP..sfn_IRAPStrParameters 时发生异常：{0}", error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
return(Json(datas));
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
/// <summary>
/// 获取工艺流程或工作流程清单
/// ⒈ 绑定工位或产线的站点获取产品工艺路线清单；
/// ⒉ 不与任何工位或产线绑定的站点获取工作流清单。
/// </summary>
/// <param name="communityID">社区标识</param>
/// <param name="sysLogID">系统登录标识</param>
/// <returns>List[ProcessInfo]</returns>
public IRAPJsonResult ufn_GetKanban_Processes(
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
{
List <ProcessInfo> datas = new List <ProcessInfo>();
try
{
#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("执行函数 IRAP..ufn_GetKanban_Processes，参数：" +
"CommunityID={0}|SysLogID={1}",
communityID, sysLogID),
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
string strSQL = "SELECT * " +
"FROM IRAP..ufn_GetKanban_Processes(@CommunityID, @SysLogID)";
IList <ProcessInfo> lstDatas = conn.CallTableFunc <ProcessInfo>(strSQL, paramList);
datas = lstDatas.ToList <ProcessInfo>();
errCode = 0;
errText = string.Format("调用成功，共获得 {0} 条记录", datas.Count);
WriteLog.Instance.Write(errText, strProcedureName);
}
#endregion
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("调用 IRAP..ufn_GetKanban_Processes 时发生异常：{0}", error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
return(Json(datas));
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
/// <summary>
/// 获取炉前光谱、浇三角试样、炉水出炉的参数
/// </summary>
/// <param name="communityID">社区标识</param>
/// <param name="opType">检验类型 --LQGP 炉前光谱，SSJSY 烧三角试验，LLCL 炉水出炉</param>
/// <param name="t131LeafID">环别叶标识</param>
/// <param name="t216LeafID">工序代码</param>
/// <param name="batchNumber">熔炼容次号</param>
/// <param name="sysLogID">语言标识</param>
/// <returns></returns>
public IRAPJsonResult ufn_GetList_SmeltMethodItemsByOpType(int communityID, string opType, int t131LeafID, int t216LeafID,
string batchNumber, long sysLogID, out int errCode, out string errText)
{
string strProcedureName = string.Format("{0}.{1}", className, MethodBase.GetCurrentMethod().Name);
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
List <SmeltMethodItemByOpType> datas = new List <SmeltMethodItemByOpType>();
#region 创建数据库调用参数组，并赋值
IList <IDataParameter> paramList = new List <IDataParameter>();
paramList.Add(new IRAPProcParameter("@CommunityID", DbType.Int32, communityID));
paramList.Add(new IRAPProcParameter("@OpType", DbType.String, opType));
paramList.Add(new IRAPProcParameter("@T131LeafID", DbType.Int32, t131LeafID));
paramList.Add(new IRAPProcParameter("@T216LeafID", DbType.Int32, t216LeafID));
paramList.Add(new IRAPProcParameter("@BatchNumber", DbType.String, batchNumber));
paramList.Add(new IRAPProcParameter("@SysLogID", DbType.Int64, sysLogID));
WriteLog.Instance.Write(
string.Format(
"调用函数ufn_GetList_SmeltMethodItemsByOpType," +
"参数：CommunityID={0}|OpType={1}|T131LeafID={2}|T216LeafID={3}|BatchNumber={4}||SysLogID={5}",
communityID, opType, t131LeafID, t216LeafID, batchNumber, sysLogID),
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
try
{
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
string strSQL = "SELECT * " +
"FROM IRAPMES..ufn_GetList_SmeltMethodItemsByOpType(" +
"@CommunityID,@OpType,@T131LeafID,@T216LeafID, @BatchNumber, @SysLogID)";
IList <SmeltMethodItemByOpType> lstDatas = conn.CallTableFunc <SmeltMethodItemByOpType>(strSQL, paramList);
datas = lstDatas.ToList <SmeltMethodItemByOpType>();
errCode = 0;
errText = string.Format("调用成功！共获得 {0} 条记录", datas.Count);
WriteLog.Instance.Write(errText, strProcedureName);
}
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("调用函数ufn_GetList_SmeltMethodItemsByOpType发生异常：{0}", error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
#endregion
return(Json(datas));
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
public IRAPJsonResult sfn_UserRoles(int communityID, string userCode, out int errCode, out string errText)
{
string strProcedureName =
string.Format(
"{0}.{1}",
className,
MethodBase.GetCurrentMethod().Name);
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
List <RoleInfo> datas = new List <RoleInfo>();
#region 创建数据库调用参数组，并赋值
IList <IDataParameter> paramList = new List <IDataParameter>();
paramList.Add(new IRAPProcParameter("@CommunityID", DbType.Int32, communityID));
paramList.Add(new IRAPProcParameter("@UserCode", DbType.String, userCode));
WriteLog.Instance.Write(
string.Format(
"调用函数 IRAP..sfn_UserRoles，" +
"参数：CommunityID={0}|UserCode={1}",
communityID, userCode),
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
try
{
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
string strSQL = "SELECT * " +
"FROM IRAP..sfn_UserRoles(" +
"@CommunityID, @UserCode)";
IList <RoleInfo> lstDatas = conn.CallTableFunc <RoleInfo>(strSQL, paramList);
datas = lstDatas.ToList <RoleInfo>();
errCode = 0;
errText = string.Format("调用成功！共获得 {0} 条记录", datas.Count);
WriteLog.Instance.Write(errText, strProcedureName);
}
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("调用 IRAP..sfn_UserRoles 函数发生异常：{0}", error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
#endregion
return(Json(datas));
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
public List <Tdpa_Log_MaterialReq> mfn_GetList_MaterialReq(
int communityID,
long importID,
long sysLogID,
out int errCode,
out string errText)
{
string strProcedureName =
$"{className}.{MethodBase.GetCurrentMethod().Name}";
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
List <Tdpa_Log_MaterialReq> datas = new List <Tdpa_Log_MaterialReq>();
#region 执行数据库函数或存储过程
try
{
using (IRAPSQLConnection conn =
new IRAPSQLConnection(
TParams.Instance.DBConnectionStr))
{
long partitioningKey = communityID * 10000;
string strSQL =
"SELECT * " +
"FROM IRAPDPA..dpa_Log_MaterialReq " +
$"WHERE PartitioningKey={partitioningKey} AND " +
$"ImportID={importID}";
WriteLog.Instance.Write(strSQL, strProcedureName);
IList <Tdpa_Log_MaterialReq> lstDatas =
conn.List <Tdpa_Log_MaterialReq>(
$"PartitioningKey={partitioningKey} AND " +
$"ImportID={importID}",
"IRAPDPA..dpa_Log_MaterialReq");
datas = lstDatas.ToList();
errCode = 0;
errText = string.Format("调用成功！共获得 {0} 条记录", datas.Count);
WriteLog.Instance.Write(errText, strProcedureName);
}
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("执行 SQL 时发生异常：{0}", error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
#endregion
return(datas);
}
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_GetList_PortalLinks(int portalID, bool logonForMe, string myPlainPWD, long sysLogID, out int errCode, out string errText)
{
string strProcedureName = string.Format("{0}.{1}",
className,
MethodBase.GetCurrentMethod().Name);
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
List <PortalLink> datas = new List <PortalLink>();
try
{
#region 创建数据库调用参数组，并赋值
IList <IDataParameter> paramList = new List <IDataParameter>();
paramList.Add(new IRAPProcParameter("@PortalID", DbType.Int32, portalID));
paramList.Add(new IRAPProcParameter("@LogonForMe", DbType.Boolean, logonForMe));
paramList.Add(new IRAPProcParameter("@MyPlainPassword", DbType.String, myPlainPWD));
paramList.Add(new IRAPProcParameter("@SysLogID", DbType.Int64, sysLogID));
WriteLog.Instance.Write(string.Format("执行函数 IRAP..sfn_GetList_PortalLinks，参数：" +
"PortalID={0}|LogonForMe={1}|MyPlainPassword={2}|SysLogID={4}",
portalID, logonForMe, myPlainPWD, sysLogID),
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
string strSQL = "SELECT * " +
"FROM IRAP..sfn_GetList_PortalLinks(@ProtalID, " +
"@LogonForMe, @MyPlainPassword, @SysLogID)";
IList <PortalLink> lstDatas = conn.CallTableFunc <PortalLink>(strSQL, paramList);
datas = lstDatas.ToList <PortalLink>();
errCode = 0;
errText = string.Format("调用成功，共获得 {0} 条记录", datas.Count);
WriteLog.Instance.Write(errText, strProcedureName);
}
#endregion
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("调用 IRAP..sfn_GetList_PortalLinks 时发生异常：{0}", error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
return(Json(datas));
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
/// <summary>
/// 创建表
/// </summary>
/// <param name="communityID">社区标识</param>
/// <param name="t19LeafID">导入导出叶标识</param>
/// <param name="treeID">导入关联树标识</param>
/// <param name="txLeafID">导出导出关联树叶标识</param>
/// <param name="sysLogID">系统登录标识</param>
/// <param name="blName"></param>
/// <returns></returns>
public IRAPJsonResult sfn_Get_ProcToCreateTBL(int communityID, int t19LeafID, int treeID, int txLeafID,
long sysLogID, string blName, out int errCode, out string errText)
{
string strProcedureName = string.Format("{0}.{1}", className, MethodBase.GetCurrentMethod().Name);
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
List <IRAPError> data = new List <IRAPError>();
try
{
#region 创建数据库调用参数组，并赋值
IList <IDataParameter> paramList = new List <IDataParameter>();
paramList.Add(new IRAPProcParameter("@CommunityID", DbType.Int32, communityID));
paramList.Add(new IRAPProcParameter("@T19LeafID", DbType.Int32, t19LeafID));
paramList.Add(new IRAPProcParameter("@TreeID", DbType.Int32, treeID));
paramList.Add(new IRAPProcParameter("@TxLeafID", DbType.Int32, txLeafID));
paramList.Add(new IRAPProcParameter("@SysLogID", DbType.Int64, sysLogID));
paramList.Add(new IRAPProcParameter("@ErrCode", DbType.Int32, ParameterDirection.Output, 4));
paramList.Add(new IRAPProcParameter("@ErrText", DbType.String, ParameterDirection.Output, 800));
WriteLog.Instance.Write(
string.Format(
"调用存储过程 IRAP..sfn_Get_ProcToCreateTBL，" +
"参数：communityID={0}|t19LeafID={1}|treeID={2}|txLeafID={3}|sysLogID={4}|blName={5}",
communityID, t19LeafID, treeID, txLeafID, sysLogID, blName), strProcedureName);
#endregion
#region 执行数据库函数或存储过程
try
{
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
string strSQL = "IRAPDPA.." + blName;
var err = conn.CallProc(strSQL, ref paramList);
errCode = err.ErrCode;
errText = err.ErrText;
WriteLog.Instance.Write(errText, strProcedureName);
data.Add(err);
}
}
catch (Exception ex)
{
IRAPError errInfo = new IRAPError(9999, ex.Message);
errCode = 9999;
errText = string.Format("创建table：{0}发生异常{1}", blName, ex.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(ex.StackTrace, strProcedureName);
data.Add(errInfo);
}
#endregion
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
return(Json(data));
}
/// <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);
}
}
/// <summary>
/// 生产开始
/// </summary>
/// <param name="communityID">社区标识</param>
/// <param name="t216LeafID">产品叶标识</param>
/// <param name="t107LeafID">工位叶标识</param>
/// <param name="t131LeafID">材质</param>
/// <param name="operatorCode">操作工代码</param>
/// <param name="batchNumber">熔次号</param>
/// <param name="rSFactXML">工艺参数XML</param>
/// <RSFact>
/// <RF25 Ordinal="" T102LeafID="" T216LeafID="" WIPCode="" LotNumber="" Texture="" PWONo="" BatchLot="" Qty="" Scale="" />
/// </RSFact>
/// <param name="sysLogID">系统登录标识</param>
/// <returns></returns>
public IRAPJsonResult usp_SaveFact_SmeltBatchProductionStart(int communityID, int t216LeafID, int t107LeafID, int t131LeafID,
string operatorCode, string batchNumber, string rSFactXML, 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("@T216LeafID", DbType.Int64, t216LeafID));
paramList.Add(new IRAPProcParameter("@T107LeafID", DbType.Int32, t107LeafID));
paramList.Add(new IRAPProcParameter("@T131LeafID", DbType.Int32, t131LeafID));
paramList.Add(new IRAPProcParameter("@OperatorCode", DbType.String, operatorCode));
paramList.Add(new IRAPProcParameter("@BatchNumber", DbType.String, batchNumber));
paramList.Add(new IRAPProcParameter("@RSFactXML", DbType.String, rSFactXML));
paramList.Add(new IRAPProcParameter("@SysLogID", DbType.Int64, sysLogID));
paramList.Add(new IRAPProcParameter("@ErrCode", DbType.Int32, ParameterDirection.Output, 4));
paramList.Add(new IRAPProcParameter("@ErrText", DbType.String, ParameterDirection.Output, 400));
WriteLog.Instance.Write(
string.Format("执行存储过程 " +
"IRAPMES..usp_SaveFact_SmeltBatchProductionStart，参数：" +
"CommunityID={0}|T216LeafID={1}|T107LeafID={2}|T131LeafID={3}|OperatorCode={4}|BatchNumber={5}|RSFactXML={6}" +
"|SysLogID={7}",
communityID, t216LeafID, t107LeafID, t131LeafID, operatorCode, batchNumber, rSFactXML, sysLogID),
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
IRAPError error = conn.CallProc("IRAPMES..usp_SaveFact_SmeltBatchProductionStart", ref paramList);
errCode = error.ErrCode;
errText = error.ErrText;
WriteLog.Instance.Write(string.Format("({0}){1}", errCode, errText), strProcedureName);
return(Json(""));
}
#endregion
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("调用 IRAPMES..usp_SaveFact_SmeltBatchProductionStart 时发生异常：{0}", error.Message);
return(Json(""));
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
/// <summary>
/// 删除 IRAPDPA..dpa_DBF_MO 中指定 importID 的记录
/// </summary>
/// <param name="communityID"></param>
/// <param name="importID"></param>
/// <param name="errCode"></param>
/// <param name="errText"></param>
/// <returns></returns>
public IRAPJsonResult msp_Delete_DPA_DBFMOData(
int communityID,
long importID,
out int errCode,
out string errText)
{
string strProcedureName =
$"{className}.{MethodBase.GetCurrentMethod().DeclaringType.FullName}";
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
List <IRAPError> data = new List <IRAPError>();
try
{
#region 创建数据库调用参数组，并赋值
IList <IDataParameter> paramList = new List <IDataParameter>();
paramList.Add(new IRAPProcParameter("@ImportID", DbType.Int64, importID));
#endregion
#region 执行数据库函数或存储过程
try
{
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
string strSQL =
"DELETE FROM IRAPDPA..dpa_DBF_MO " +
"WHERE ImportID=@ImportID";
WriteLog.Instance.Write(
$"执行 SQL 语句:[{strSQL}]，参数：@ImportID={importID}",
strProcedureName);
var count = conn.CallScalar(strSQL, paramList);
IRAPError errInfo = new IRAPError(0, "成功删除旧数据");
errCode = errInfo.ErrCode;
errText = errInfo.ErrText;
WriteLog.Instance.Write(errInfo.ErrText, strProcedureName);
data.Add(errInfo);
}
}
catch (Exception error)
{
IRAPError errInfo = new IRAPError(9999, error.Message);
errCode = 9999;
errText = $"删除表 IRAPDPA..dpa_DBF_MO 中的数据发生异常：{error.Message}";
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
data.Add(errInfo);
}
#endregion
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
return(Json(data));
}
public void DeleteOldTableData(
string tableName,
int communityID,
long importID,
out int errCode,
out string errText)
{
string strProcedureName =
$"{className}.{MethodBase.GetCurrentMethod().Name}";
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
long partitioningKey = communityID * 10000;
#region 创建数据库调用参数组，并赋值
IList <IDataParameter> paramList = new List <IDataParameter>();
paramList.Add(new IRAPProcParameter("@PartitioningKey", DbType.Int64, partitioningKey));
paramList.Add(new IRAPProcParameter("@ImportLogID", DbType.Int64, importID));
WriteLog.Instance.Write(
$"执行 DELETE FROM IRAPDPA..{tableName} WHERE PartitioningKey={partitioningKey} " +
$"AND ImportID={importID}。",
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
using (IRAPSQLConnection conn =
new IRAPSQLConnection(
TParams.Instance.DBConnectionStr))
{
string strSQL =
$"DELETE FROM IRAPDPA..{tableName} WHERE PartitioningKey={partitioningKey} " +
$"AND ImportID={importID}";
var count = conn.CallScalar(strSQL, paramList);
IRAPError error = new IRAPError(0, "数据删除成功");
errCode = error.ErrCode;
errText = error.ErrText;
WriteLog.Instance.Write(
string.Format("({0}){1}", errCode, errText),
strProcedureName);
}
#endregion
}
catch (Exception error)
{
errCode = 99000;
errText = $"删除(IRAPDPA..{tableName})时发生异常：{error.Message}";
}
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="communityID">社区标识</param>
/// <param name="t19LeafID">导入导出叶标识</param>
/// <param name="sysLogID">系统登录标识</param>
/// <returns></returns>
public IRAPJsonResult sfn_GetInfo_LinkedTreeOfImpExp(int communityID, int t19LeafID, long sysLogID, out int errCode,
out string errText)
{
string strProcedureName = string.Format("{0}.{1}", className, MethodBase.GetCurrentMethod().Name);
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
List <LinkedTreeTip> datas = new List <LinkedTreeTip>();
#region 创建数据库调用参数组，并赋值
IList <IDataParameter> paramList = new List <IDataParameter>();
paramList.Add(new IRAPProcParameter("@CommunityID", DbType.Int32, communityID));
paramList.Add(new IRAPProcParameter("@T19LeafID", DbType.Int32, t19LeafID));
paramList.Add(new IRAPProcParameter("@SysLogID", DbType.Int64, sysLogID));
WriteLog.Instance.Write(
string.Format(
"调用函数 IRAP..sfn_GetInfo_LinkedTreeOfImpExp，" +
"参数：CommunityID={0}|T19LeafID={1}|SysLogID={2}",
communityID, t19LeafID, sysLogID),
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
try
{
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
string strSQL = "SELECT * " +
"FROM IRAP..sfn_GetInfo_LinkedTreeOfImpExp(" +
"@CommunityID, @T19LeafID, @SysLogID)";
IList <LinkedTreeTip> lstDatas = conn.CallTableFunc <LinkedTreeTip>(strSQL, paramList);
datas = lstDatas.ToList <LinkedTreeTip>();
errCode = 0;
errText = string.Format("调用成功！共获得 {0} 条记录", datas.Count);
WriteLog.Instance.Write(errText, strProcedureName);
}
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("调用 IRAP..sfn_GetInfo_LinkedTreeOfImpExp 函数发生异常：{0}", error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
#endregion
return(Json(datas));
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
public IRAPJsonResult ssp_ModiPWD(
int communityID,
string userCode,
string oldPassword,
string newPassword,
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("@UserCode", DbType.String, userCode));
paramList.Add(new IRAPProcParameter("@OldPWD", DbType.String, oldPassword));
paramList.Add(new IRAPProcParameter("@NewPWD", DbType.String, newPassword));
paramList.Add(new IRAPProcParameter("@ErrCode", DbType.Int32, ParameterDirection.Output, 4));
paramList.Add(new IRAPProcParameter("@ErrText", DbType.String, ParameterDirection.Output, 400));
WriteLog.Instance.Write(
string.Format("执行存储过程 IRAP..ssp_ModiPWD，参数：" +
"CommunityID={0}|UserCode={1}|OldPWD={2}|NewPWD={3}",
communityID, userCode, oldPassword, newPassword),
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
IRAPError error = conn.CallProc("IRAP..ssp_ModiPWD", ref paramList);
errCode = error.ErrCode;
errText = error.ErrText;
return(Json(""));
}
#endregion
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("调用 IRAP..ssp_ModiPWD 时发生异常：{0}", error.Message);
return(Json(""));
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
/// <summary>
/// 获取导入信息XML报文
/// </summary>
/// <param name="communityID">社区标识</param>
/// <param name="t19LeafID">导入导出叶标识</param>
/// <param name="txLeafID">导出导出关联树叶标识</param>
/// <param name="sysLogID">系统登录标识</param>
/// <returns></returns>
public IRAPJsonResult sfn_GetXML_ImportInfo(int communityID, int t19LeafID, int txLeafID,
long sysLogID, out int errCode, out string errText)
{
string strProcedureName = string.Format("{0}.{1}", className, MethodBase.GetCurrentMethod().Name);
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
string xml = null;
#region 创建数据库调用参数组，并赋值
IList <IDataParameter> paramList = new List <IDataParameter>();
paramList.Add(new IRAPProcParameter("@communityID", DbType.Int32, communityID));
paramList.Add(new IRAPProcParameter("@t19LeafID", DbType.Int32, t19LeafID));
paramList.Add(new IRAPProcParameter("@txLeafID", DbType.Int32, txLeafID));
paramList.Add(new IRAPProcParameter("@sysLogID", DbType.Int64, sysLogID));
WriteLog.Instance.Write(
string.Format(
"调用函数 IRAP..sfn_GetXML_ImportInfo，" +
"参数：communityID={0}|t19LeafID={1}|txLeafID={2}|sysLogID={3}",
communityID, t19LeafID, txLeafID, sysLogID),
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
try
{
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
string strSQL = "SELECT IRAP.dbo.sfn_GetXML_ImportInfo(@communityID,@t19LeafID,@txLeafID,@sysLogID)";
xml = conn.CallScalar(strSQL, paramList).ToString();
errCode = 0;
errText = string.Format("调用成功！结果长度{0}", xml.Length);
WriteLog.Instance.Write(errText, strProcedureName);
}
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("调用 IRAP..sfn_GetXML_ImportInfo 函数发生异常：{0}", error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
#endregion
return(Json(new List <string>()
{
xml
}));
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
/// <summary>
/// 操作工编号检验
/// </summary>
/// <param name="communityID">社区标识</param>
/// <param name="operatorCode">操作工编号</param>
/// <returns></returns>
public IRAPJsonResult LookForOperatorCode(int communityID, string operatorCode, out int errCode,
out string errText)
{
string strProcedureName = string.Format("{0}.{1}", className, MethodBase.GetCurrentMethod().Name);
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
List <long> datas = new List <long>();
#region 创建数据库调用参数组，并赋值
IList <IDataParameter> paramList = new List <IDataParameter>();
paramList.Add(new IRAPProcParameter("@CommunityID", DbType.Int64, communityID * 10000));
paramList.Add(new IRAPProcParameter("@OperatorCode", DbType.String, operatorCode));
WriteLog.Instance.Write(
string.Format(
"在表IRAP..stb006中查找匹配项，" +
"参数：CommunityID={0}|OperatorCode={1}",
communityID, operatorCode),
strProcedureName);
#endregion
#region 执行数据库函数或存储过程
try
{
using (IRAPSQLConnection conn = new IRAPSQLConnection())
{
string strSQL = "select * from IRAP..stb006 where PartitioningKey = @CommunityID and UserCode = @OperatorCode";
var id = (long)conn.CallScalar(strSQL, paramList);
datas.Add(id);
errCode = 0;
errText = string.Format("调用成功！共获得 {0} 条记录", datas.Count);
WriteLog.Instance.Write(errText, strProcedureName);
}
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("在表IRAP..stb006中查找匹配项发生异常：{0}", error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
#endregion
return(Json(datas));
}
finally
{
WriteLog.Instance.WriteEndSplitter(strProcedureName);
}
}
public void ssp_RunAFunction(
long sysLogID,
int menuItemID,
out int errCode,
out string errText)
{
string strProcedureName =
$"{className}.{MethodBase.GetCurrentMethod().Name}";
WriteLog.Instance.WriteBeginSplitter(strProcedureName);
try
{
#region 执行数据库函数或存储过程
try
{
using (IRAPSQLConnection conn =
new IRAPSQLConnection(
TParams.Instance.DBConnectionStr))
{
string strSQL =
"INSERT INTO IRAP..stb153 " +
$"SELECT {sysLogID}," +
$"'{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")}'," +
$"{menuItemID};\n" +
"UPDATE IRAP..stb009 " +
$"SET DBName='IRAPSCES' " +
$"WHERE SysLogID={sysLogID}";
WriteLog.Instance.Write(strSQL, strProcedureName);
conn.CallScalar(strSQL);
errCode = 0;
errText = "调用成功！";
WriteLog.Instance.Write(errText, strProcedureName);
}
}
catch (Exception error)
{
errCode = 99000;
errText = string.Format("向 IRAP..stb153 中插入记录时发生异常：{0}", error.Message);
WriteLog.Instance.Write(errText, strProcedureName);
WriteLog.Instance.Write(error.StackTrace, strProcedureName);
}
#endregion
}
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));
}
