private static void logInner(K3DataParaInfo docInfo, string logMsg)
{
try
{
//if (string.IsNullOrEmpty(docInfo.Data))
//{
docInfo.Data = logMsg;
using (SqlConnection sqlconn = new SqlConnection(@"context connection=true"))
{
sqlconn.Open();
using (SqlCommand sqlcommCache = new SqlCommand("zz_pr_X9ToK3Log_Save", sqlconn))
{
sqlcommCache.CommandType = CommandType.StoredProcedure;
string strDocInfo = XmlSerialize <K3DataParaInfo>(docInfo, Encoding.Unicode);
SqlParameter sqlparamDocInfo = new SqlParameter("@DocInfo", SqlDbType.Xml);
sqlparamDocInfo.Value = strDocInfo;
SqlParameter sqlparamType = new SqlParameter("@Type", SqlDbType.NVarChar);
sqlparamType.Value = System.Enum.GetName(typeof(LOG_TYPE), ConfigLogType);
sqlcommCache.Parameters.Add(sqlparamDocInfo);
sqlcommCache.Parameters.Add(sqlparamType);
sqlcommCache.ExecuteNonQuery();
}
}
//}
}
catch (Exception ex)
{
//throw new RankException(string.Format("暂存DocInfo存储异常：{0}", string.Empty), ex);
//MessageBox.Show(string.Format("{0}\t暂存DocInfo存储异常：{1}", Environment.NewLine, ex.Message));
throw new Exception(string.Format("{0}\t日志存储异常：{1}", Environment.NewLine, ex.Message), ex);
}
}
private static void cacheDocInfo(K3DataParaInfo docInfo, K3InterceptConfig busiConfig)
{
try
{
using (SqlConnection sqlconn = new SqlConnection(@"context connection=true"))
{
sqlconn.Open();
using (SqlCommand sqlcommCache = new SqlCommand("zz_pr_X9WebSrvBackup_Save", sqlconn))
{
sqlcommCache.CommandType = CommandType.StoredProcedure;
string strDocInfo = XmlSerialize <K3DataParaInfo>(docInfo, Encoding.Unicode);
SqlParameter sqlparamDocInfo = new SqlParameter("@DocInfo", SqlDbType.Xml);
sqlparamDocInfo.Value = strDocInfo;
SqlParameter sqlparamUrl = new SqlParameter("@Url", SqlDbType.NVarChar);
sqlparamUrl.Value = string.Format("http://{0}", busiConfig.ServiceAddress);
sqlcommCache.Parameters.Add(sqlparamDocInfo);
sqlcommCache.Parameters.Add(sqlparamUrl);
sqlcommCache.ExecuteNonQuery();
}
}
infoLogger(docInfo, string.Format("X9系统服务调用异常，事件{0}数据被缓存。", docInfo.EventName));
}
catch (Exception ex)
{
//throw new RankException(string.Format("暂存DocInfo存储异常：{0}", string.Empty), ex);
//MessageBox.Show(string.Format("{0}\t暂存DocInfo存储异常：{1}", Environment.NewLine, ex.Message));
infoLogger(docInfo, string.Format("暂存DocInfo存储异常：{0}", ex.Message));
throw new Exception(string.Format("{0}\t暂存DocInfo存储异常：{1}", Environment.NewLine, ex.Message), ex);
}
}
//做Info日志收录时，不管日志级别是Debug还是Info，都保存记录。
private static void infoLogger(K3DataParaInfo docInfo, string logMsg)
{
if (ConfigLogType == LOG_TYPE.LOG_INFO || ConfigLogType == LOG_TYPE.LOG_DEBUG)
{
logInner(docInfo, logMsg);
}
}
public static K3InterceptConfig validateBusinessEnable(K3DataParaInfo docInfo)
{
SqlPipe pipe = SqlContext.Pipe;
K3InterceptConfig busiConfig = null;
string strViewXml = string.Empty;
using (SqlConnection sqlconn = new SqlConnection(@"context connection=true"))
{
sqlconn.Open();
using (SqlCommand sqlcommPOView = new SqlCommand("zz_pr_BusiConfigSingle_View", sqlconn))
{
sqlcommPOView.CommandType = CommandType.StoredProcedure;
SqlParameter sqlparaResult = new SqlParameter("@Infos", SqlDbType.Xml, 5000);
sqlparaResult.Direction = ParameterDirection.Output;
SqlParameter sqlparaDocInfo = new SqlParameter("@DocInfo", SqlDbType.Xml);
sqlparaDocInfo.Direction = ParameterDirection.Input;
sqlparaDocInfo.Value = XmlSerialize <K3DataParaInfo>(docInfo, Encoding.Unicode);
sqlcommPOView.Parameters.Add(sqlparaDocInfo);
sqlcommPOView.Parameters.Add(sqlparaResult);
sqlcommPOView.ExecuteNonQuery();
strViewXml = sqlparaResult.Value.ToString();
busiConfig = XmlDeserialize <K3InterceptConfig>(strViewXml, Encoding.UTF8);
}
}
return(busiConfig);;
}
/// <summary>
/// 所单据表头增加了“是否进X9”字段，并在zz_t_K3InterceptConfig配置表设置好对应字段则会进行过滤调用。
/// </summary>
/// <param name="itemConfig"></param>
/// <param name="docInfo"></param>
/// <returns></returns>
internal static bool isCalledFilter(K3InterceptConfig itemConfig, K3DataParaInfo docInfo)
{
bool bRlt = true;
if (itemConfig == null || string.IsNullOrEmpty(itemConfig.ConditionTable) || string.IsNullOrEmpty(itemConfig.ConditionField) || string.IsNullOrEmpty(itemConfig.KeyField))
{
return(bRlt);
}
using (SqlConnection sqlconn = new SqlConnection(@"context connection=true"))
{
sqlconn.Open();
using (SqlCommand sqlcommExists = new SqlCommand(string.Format("select 1 from sys.columns where [object_id] = object_id('{0}') and name = '{1}'", itemConfig.ConditionTable, itemConfig.ConditionField), sqlconn))
{
Object objIsExists = sqlcommExists.ExecuteScalar();
if (objIsExists == null || Convert.ToInt32(objIsExists.ToString()) != 1)
{
return(bRlt);
}
}
using (SqlCommand sqlcommKeyExists = new SqlCommand(string.Format("select 1 from sys.columns where [object_id] = object_id('{0}') and name = '{1}'", itemConfig.ConditionTable, itemConfig.KeyField), sqlconn))
{
Object objIsExists = sqlcommKeyExists.ExecuteScalar();
if (objIsExists == null || Convert.ToInt32(objIsExists.ToString()) != 1)
{
return(bRlt);
}
}
string strExcludedValue = "N";
if (!string.IsNullOrEmpty(itemConfig.ExcludedValue))
{
strExcludedValue = itemConfig.ExcludedValue;
}
using (SqlCommand sqlcommCondition = new SqlCommand(string.Format("select isnull({1},'1') from {0} where {2} = {3}", itemConfig.ConditionTable, itemConfig.ConditionField, itemConfig.KeyField, docInfo.InterID.ToString()), sqlconn))
{
Object objValue = sqlcommCondition.ExecuteScalar();
if (objValue == null)
{
return(bRlt);
}
else
{
if (string.Equals(strExcludedValue, objValue.ToString(), StringComparison.OrdinalIgnoreCase))
{
bRlt = false;
}
}
}
}
return(bRlt);
}
/// <summary>
/// 日志级别高于等于LOG_DEBUG，进行日志记录
/// </summary>
public static void debugLog(string interceptEvent, K3DataParaInfo docInfo, string msg)
{
if (SimpleConfig.ConfigLogType >= LOG_TYPE.LOG_DEBUG)
{
string strPreLog = String.Format("-----------日志消息：{0}---------------" + Environment.NewLine
+ "\tK3传递数据内容：业务类型【{1}】；红蓝字【{2}】；触发事件【{3}】；单据内码【{4}】；单据编码【{5}】；额外数据【{6}】；操作人【{7}】",
msg, docInfo.TransType.ToString(), docInfo.ROB.ToString(), interceptEvent, docInfo.InterID.ToString(), docInfo.BillCode, docInfo.Data, docInfo.CurrentUser);
Log(strPreLog, SimpleConfig.ConfigLogType);
}
}
//基础缺省处理事件方法。
private static bool basicHandle(K3DataParaInfo docInfo)
{
SqlPipe pipe = SqlContext.Pipe;
bool bRlt = true;
try
{
//WriteInfoToLogFile(string.Format("进入基类{0}事件响应", docInfo.EventName), LOG_TYPE.LOG_DEBUG);
debugLogger(docInfo, string.Format("进入基类{0}事件响应", docInfo.EventName));
K3InterceptConfig itemConfig = validateBusinessEnable(docInfo);
//K3InterceptConfig itemConfig = new K3InterceptConfig()
//{
// ServiceAddress = "192.168.1.100/WebService/WebService.asmx",
// X9BusinessType = 5,
// InterceptEvent = "ClosedBefore",
// IsEnable = 1,
//};
if (itemConfig != null)
{
if (!isCalledFilter(itemConfig, docInfo))
{
infoLogger(docInfo, string.Format("X9系统业务校验事件{0}服务，单据【{1}]表头标记为“不进入X9系统”。", docInfo.EventName, docInfo.InterID.ToString()));
return(true);//直接返回，不再调用X9服务。
}
ResultInfo rltInfo = defaultServiceHandle(docInfo, itemConfig);
if (rltInfo != null)
{
if (docInfo.EventName.IndexOf("After", 0, StringComparison.OrdinalIgnoreCase) > 0)
{
bRlt = true;
}
else
{
bRlt = rltInfo.IsSuccess;//(2019-8-17取消)2019-8-13 改为：不管X9服务认定是否通过，都不再中断K3动作。
}
infoLogger(docInfo, string.Format("X9系统业务校验事件{0}服务，返回结果为{1}。", docInfo.EventName, bRlt.ToString()));
}
}
else
{
infoLogger(docInfo, string.Format("未启用X9系统对K3事件{0}的拦截", docInfo.EventName));
}
}
catch (Exception ex)
{
pipe.Send(ex.Message);
infoLogger(docInfo, string.Format("执行基类缺省拦截处理：{0}事件。异常：{1}", docInfo.EventName, ex.Message));
bRlt = false;
}
return(bRlt);
}
public static K3InterceptConfig validateBusinessEnable(K3DataParaInfo docInfo)
{
SqlPipe pipe = SqlContext.Pipe;
List <K3InterceptConfig> BusiConfigs = null;
string strViewXml = string.Empty;
using (SqlConnection sqlconn = new SqlConnection(@"context connection=true"))
{
sqlconn.Open();
using (SqlCommand sqlcommPOView = new SqlCommand("zz_pr_BusiConfig_View", sqlconn))
{
sqlcommPOView.CommandType = CommandType.StoredProcedure;
SqlParameter sqlparaResult = new SqlParameter("@Infos", SqlDbType.Xml, 5000);
sqlparaResult.Direction = ParameterDirection.Output;
sqlcommPOView.Parameters.Add(sqlparaResult);
sqlcommPOView.ExecuteNonQuery();
strViewXml = sqlparaResult.Value.ToString();
BusiConfigs = SimpleConfig.XmlDeserialize <List <K3InterceptConfig> >(strViewXml, Encoding.UTF8);
}
}
List <K3InterceptConfig> lstConfig = (from s in BusiConfigs
where s.InterceptEvent == docInfo.EventName && s.X9BusinessType == docInfo.X9BillType && s.IsEnable == 1
orderby s.Id descending
select s).ToList <K3InterceptConfig>();
pipe.Send(lstConfig.Count.ToString());
foreach (var item in lstConfig)
{
if (DateTime.Now.Date >= item.EnableDate && DateTime.Now.Date <= item.DisableDate)
{
return(item);
}
}
return(null);;
}
private static ResultInfo defaultServiceHandle(K3DataParaInfo docInfo, K3InterceptConfig busiConfig)
{
SqlPipe pipe = SqlContext.Pipe;
try
{
string strRlt = string.Empty;
debugLogger(docInfo, string.Format("进入X9系统业务校验事件{0}服务中", docInfo.EventName));
//WindowsIdentity windowsIdentity = null;
//WindowsImpersonationContext userImpersonated = null;
//windowsIdentity = SqlContext.WindowsIdentity;
//// Switch the context to local service account user (a domain user)
//// by getting its identity in order to call the web service
//userImpersonated = windowsIdentity.Impersonate();
//if (userImpersonated != null)
//{
// // Create the instance of a web service to be called. // Remember this is not actual // CAAT search web service but a similar fake web service just for testing.
// pipe.Send("create service");
// X9WebService.WebService svValidateBM = new X9WebService.WebService();
// pipe.Send("end service");
// svValidateBM.Url = string.Format("http://{0}", busiConfig.ServiceAddress);
// string strDocInfo = SimpleConfig.XmlSerialize<K3DataParaInfo>(docInfo, Encoding.Unicode);
// pipe.Send(strDocInfo);
// // Execute the web service and get the IEnumerable type results
// strRlt = svValidateBM.SynchBillFromK3ToX9(strDocInfo);
// // Switch the context back to the SQL Server
// userImpersonated.Undo();
//}
//else
//{
// pipe.Send("userImpersonated is null");
//}
X9WebService.WebService svValidateBM = new X9WebService.WebService();
svValidateBM.Url = string.Format("http://{0}", busiConfig.ServiceAddress);
string strDocInfo = XmlSerialize <K3DataParaInfo>(docInfo, Encoding.Unicode);
pipe.Send(strDocInfo);
//string strHttpEncoding = HttpUtility.HtmlEncode(strDocInfo);
strRlt = svValidateBM.SynchBillFromK3ToX9(strDocInfo);
if (!string.IsNullOrEmpty(strRlt))
{
pipe.Send(strRlt);
//strRlt = strRlt.Replace(" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"", "");
//string strHttpDecoding = HttpUtility.HtmlDecode(strRlt);
ResultInfo rltInfo = XmlDeserialize <ResultInfo>(strRlt, Encoding.Unicode);
//(2019-8-17取消)
//if (!rltInfo.IsSuccess)
//{
// StringBuilder strbError = new StringBuilder();
// foreach (var item in rltInfo.Errors)
// {
// if (!String.IsNullOrEmpty(item.ErrorText))
// {
// strbError.AppendLine(item.ErrorText);
// }
// }
// docInfo.Data = strbError.ToString();
// cacheDocInfo(docInfo, busiConfig);
//}
return(rltInfo);
}
else
{
docInfo.Data = "X9服务未开启或执行返回为空字符";
cacheDocInfo(docInfo, busiConfig);
}
return(null);
}
catch (Exception ex)
{
//LogInfoHelp.infoLog(eventName, docInfo, string.Format("调用X9系统服务时，异常：{0}", ex.Message));
infoLogger(docInfo, string.Format("调用X9系统服务时，异常：{0}", ex.Message));
docInfo.Data = ex.Message;
cacheDocInfo(docInfo, busiConfig);
return(null);
}
}
public static void trICStockX9FirstCheck()
{
string billCode = string.Empty;
long interID = 0L;
int iROB = 1;
long lTransType = 0L;
int insFFirstChecker, delFFirstChecker;
bool bCheckTriggerCol = false;
string strX9No = string.Empty;
SqlTriggerContext triggContext = SqlContext.TriggerContext;
SqlPipe pipe = SqlContext.Pipe;
SqlDataReader reader;
initialConfig();
//pipe.Send(System.Enum.GetName(typeof(LOG_TYPE), ConfigLogType));
#region 只有出入库单一级审核人变化时才触发
using (SqlConnection connection = new SqlConnection(@"context connection=true"))
{
connection.Open();
SqlCommand command = new SqlCommand(@"SELECT * FROM INSERTED;", connection);
reader = command.ExecuteReader();
reader.Read();
//虽reader不为null，但HasRows为false时，调用reader方法或属性会出现NullReferenceException异常。
if (reader == null || reader.HasRows == false)
{
return;
}
for (int columnNumber = 0; columnNumber < triggContext.ColumnCount; columnNumber++)
{
try
{
if (triggContext.IsUpdatedColumn(columnNumber) && reader.GetName(columnNumber).Equals("FMultiCheckLevel1", StringComparison.InvariantCultureIgnoreCase))
{
bCheckTriggerCol = true;
}
}
catch (NullReferenceException ex)
{
continue;
}
//pipe.Send("Updated column "
// + reader.GetName(columnNumber) + "? "
// + triggContext.IsUpdatedColumn(columnNumber).ToString());
}
pipe.Send(bCheckTriggerCol.ToString());
if (!bCheckTriggerCol)
{
return;
}
billCode = (string)reader["FBillNo"].ToString();
interID = Convert.ToInt64(reader["FInterID"].ToString());
iROB = Convert.ToInt32(reader["FROB"].ToString());
lTransType = Convert.ToInt64(reader["FTranType"].ToString());
strX9No = (string)reader["X9NO"].ToString();
insFFirstChecker = Convert.ToInt32(reader["FMultiCheckLevel1"] == null ||
string.IsNullOrEmpty(reader["FMultiCheckLevel1"].ToString()) ? "0" : reader["FMultiCheckLevel1"].ToString());
reader.Close();
}
#endregion
using (SqlConnection connection = new SqlConnection(@"context connection=true"))
{
connection.Open();
SqlCommand command = new SqlCommand(@"SELECT * FROM DELETED;", connection);
reader = command.ExecuteReader();
reader.Read();
if (reader == null || reader.HasRows == false)
{
return;
}
delFFirstChecker = Convert.ToInt32(reader["FMultiCheckLevel1"] == null ||
string.IsNullOrEmpty(reader["FMultiCheckLevel1"].ToString()) ? "0" : reader["FMultiCheckLevel1"].ToString());
reader.Close();
}
#region 一级审核时
if (delFFirstChecker == 0 && insFFirstChecker > 0)
{
K3DataParaInfo docInfo = new K3DataParaInfo()
{
BillCode = billCode,
InterID = interID,
EntryID = 0,
TransType = lTransType,
ROB = iROB,
CurrentUser = "******",
X9BillType = ContrastK3TransType(lTransType, iROB),
EventName = "FirstApprovedAfter",
Data = strX9No,
};
if (!basicHandle(docInfo))
{
try
{
// Get the current transaction and roll it back.
Transaction trans = Transaction.Current;
trans.Rollback();
}
catch (SqlException ex)
{
//throw new Exception("X9系统异常");
return;
}
}
}
#endregion
#region 一级反审核时
if (delFFirstChecker > 0 && insFFirstChecker == 0)
{
K3DataParaInfo docInfo = new K3DataParaInfo()
{
BillCode = billCode,
InterID = interID,
EntryID = 0,
TransType = lTransType,
ROB = iROB,
CurrentUser = "******",
X9BillType = ContrastK3TransType(lTransType, iROB),
EventName = "UnFirstApprovedAfter",
Data = strX9No,
};
if (!basicHandle(docInfo))
{
try
{
// Get the current transaction and roll it back.
Transaction trans = Transaction.Current;
trans.Rollback();
}
catch (SqlException ex)
{
return;
}
}
}
#endregion
}
public static void trOMOrderEntryClosed()
{
string billCode = string.Empty;
long interID = 0L;
int entryID = 0;
int insFClosed, delFClosed;
bool bCheckTriggerCol = false;
SqlTriggerContext triggContext = SqlContext.TriggerContext;
SqlPipe pipe = SqlContext.Pipe;
SqlDataReader reader;
initialConfig();
#region 只有委外订单行关闭时触发
using (SqlConnection connection = new SqlConnection(@"context connection=true"))
{
connection.Open();
SqlCommand command = new SqlCommand(@"SELECT * FROM INSERTED;", connection);
reader = command.ExecuteReader();
reader.Read();
if (reader == null || reader.HasRows == false)
{
return;
}
for (int columnNumber = 0; columnNumber < triggContext.ColumnCount; columnNumber++)
{
if (reader.GetName(columnNumber).Equals("FMrpClosed", StringComparison.InvariantCultureIgnoreCase) && triggContext.IsUpdatedColumn(columnNumber))
{
bCheckTriggerCol = true;
}
//pipe.Send("Updated column "
// + reader.GetName(columnNumber) + "? "
// + triggContext.IsUpdatedColumn(columnNumber).ToString());
}
pipe.Send(bCheckTriggerCol.ToString());
if (!bCheckTriggerCol)
{
return;
}
billCode = string.Empty;
interID = Convert.ToInt64(reader["FInterID"].ToString());
entryID = Convert.ToInt32(reader["FEntryID"].ToString());
insFClosed = Convert.ToInt32(reader["FMrpClosed"].ToString());
reader.Close();
}
#endregion
using (SqlConnection connection = new SqlConnection(@"context connection=true"))
{
connection.Open();
SqlCommand command = new SqlCommand(@"SELECT * FROM DELETED;", connection);
reader = command.ExecuteReader();
reader.Read();
if (reader == null || reader.HasRows == false)
{
return;
}
delFClosed = Convert.ToInt32(reader["FMrpClosed"].ToString());
reader.Close();
}
//行关闭时
if (insFClosed == 1 && delFClosed == 0)
{
K3DataParaInfo docInfo = new K3DataParaInfo()
{
BillCode = billCode,
InterID = interID,
EntryID = entryID,
TransType = 1007105,
ROB = 0,
CurrentUser = "******",
X9BillType = 3,
EventName = "EntryClosedAfter",
Data = "",
};
if (!basicHandle(docInfo))
{
try
{
// Get the current transaction and roll it back.
Transaction trans = Transaction.Current;
trans.Rollback();
}
catch (SqlException ex)
{
return;
}
}
}
//反关闭时
if (delFClosed == 1 && insFClosed == 0)
{
K3DataParaInfo docInfo = new K3DataParaInfo()
{
BillCode = billCode,
InterID = interID,
EntryID = entryID,
TransType = 1007105,
ROB = 0,
CurrentUser = "******",
X9BillType = 3,
EventName = "UnEntryClosedAfter",
Data = "",
};
if (!basicHandle(docInfo))
{
try
{
// Get the current transaction and roll it back.
Transaction trans = Transaction.Current;
trans.Rollback();
}
catch (SqlException ex)
{
return;
}
}
}
}
public static void trPPBOMX9Validate()
{
string billCode = string.Empty;
long interID = 0L;
int insFStatus, delFStatus;
int typeID = 0;
bool bCheckTriggerCol = false;
SqlTriggerContext triggContext = SqlContext.TriggerContext;
SqlPipe pipe = SqlContext.Pipe;
SqlDataReader reader;
initialConfig();
#region 只有生产投料单状态变化时才触发
using (SqlConnection connection = new SqlConnection(@"context connection=true"))
{
connection.Open();
SqlCommand command = new SqlCommand(@"SELECT * FROM INSERTED;", connection);
reader = command.ExecuteReader();
reader.Read();
if (reader == null || reader.HasRows == false)
{
return;
}
for (int columnNumber = 0; columnNumber < triggContext.ColumnCount; columnNumber++)
{
if (reader.GetName(columnNumber).Equals("FStatus", StringComparison.InvariantCultureIgnoreCase) && triggContext.IsUpdatedColumn(columnNumber))
{
bCheckTriggerCol = true;
}
//pipe.Send("Updated column "
// + reader.GetName(columnNumber) + "? "
// + triggContext.IsUpdatedColumn(columnNumber).ToString());
}
pipe.Send(bCheckTriggerCol.ToString());
if (!bCheckTriggerCol)
{
return;
}
billCode = (string)reader["FBillNo"].ToString();
interID = Convert.ToInt64(reader["FInterID"].ToString());
insFStatus = Convert.ToInt32(reader["FStatus"].ToString());
typeID = Convert.ToInt32(reader["FType"].ToString());
reader.Close();
}
#endregion
using (SqlConnection connection = new SqlConnection(@"context connection=true"))
{
connection.Open();
SqlCommand command = new SqlCommand(@"SELECT * FROM DELETED;", connection);
reader = command.ExecuteReader();
reader.Read();
if (reader == null || reader.HasRows == false)
{
return;
}
delFStatus = Convert.ToInt32(reader["FStatus"].ToString());
reader.Close();
}
//审核时
if (insFStatus == 1 && delFStatus == 0)
{
K3DataParaInfo docInfo = new K3DataParaInfo()
{
BillCode = billCode,
InterID = interID,
EntryID = 0,
TransType = 88,
ROB = 1,
CurrentUser = "******",
X9BillType = typeID == 1067 ? 23 : 7,//根据typeID区分是工单投料，还是委外投料。
EventName = "ApprovedAfter",
Data = "",
};
if (!basicHandle(docInfo))
{
try
{
// Get the current transaction and roll it back.
Transaction trans = Transaction.Current;
trans.Rollback();
}
catch (SqlException ex)
{
return;
}
}
}
//弃审时
if (delFStatus == 1 && insFStatus == 0)
{
K3DataParaInfo docInfo = new K3DataParaInfo()
{
BillCode = billCode,
InterID = interID,
EntryID = 0,
TransType = 88,
ROB = 1,
CurrentUser = "******",
X9BillType = typeID == 1067 ? 23 : 7,//根据typeID区分是工单投料，还是委外投料。
EventName = "UnApprovedAfter",
Data = "",
};
if (!basicHandle(docInfo))
{
try
{
// Get the current transaction and roll it back.
Transaction trans = Transaction.Current;
trans.Rollback();
}
catch (SqlException ex)
{
return;
}
}
}
}
public static void trICMOX9Validate()
{
string billCode = string.Empty;
long interID = 0L;
int insFStatus, delFStatus;
string strInsCommitDate = string.Empty, strDelCommitDate = string.Empty;
bool bCheckTriggerCol = false;
SqlTriggerContext triggContext = SqlContext.TriggerContext;
SqlPipe pipe = SqlContext.Pipe;
SqlDataReader reader;
initialConfig();
//pipe.Send(System.Enum.GetName(typeof(LOG_TYPE), ConfigLogType));
#region 只有生产任务单状态变化时才触发
using (SqlConnection connection = new SqlConnection(@"context connection=true"))
{
connection.Open();
SqlCommand command = new SqlCommand(@"SELECT * FROM INSERTED;", connection);
reader = command.ExecuteReader();
reader.Read();
//虽reader不为null，但HasRows为false时，调用reader方法或属性会出现NullReferenceException异常。
if (reader == null || reader.HasRows == false)
{
return;
}
for (int columnNumber = 0; columnNumber < triggContext.ColumnCount; columnNumber++)
{
try
{
if (triggContext.IsUpdatedColumn(columnNumber) && reader.GetName(columnNumber).Equals("FStatus", StringComparison.InvariantCultureIgnoreCase))
{
bCheckTriggerCol = true;
}
}
catch (NullReferenceException ex) {
continue;
}
//pipe.Send("Updated column "
// + reader.GetName(columnNumber) + "? "
// + triggContext.IsUpdatedColumn(columnNumber).ToString());
}
pipe.Send(bCheckTriggerCol.ToString());
if (!bCheckTriggerCol)
{
return;
}
billCode = (string)reader["FBillNo"].ToString();
interID = Convert.ToInt64(reader["FInterID"].ToString());
insFStatus = Convert.ToInt32(reader["FStatus"].ToString());
strInsCommitDate = reader["FCommitDate"].ToString();//下达日期
reader.Close();
}
#endregion
using (SqlConnection connection = new SqlConnection(@"context connection=true"))
{
connection.Open();
SqlCommand command = new SqlCommand(@"SELECT * FROM DELETED;", connection);
reader = command.ExecuteReader();
reader.Read();
if (reader == null || reader.HasRows == false)
{
return;
}
delFStatus = Convert.ToInt32(reader["FStatus"].ToString());
strDelCommitDate = reader["FCommitDate"].ToString();//下达日期
reader.Close();
}
#region 达时
//不再用insFStatus == 1 && delFStatus != 1判断是否下达，因为结案会出现更新ICShop_SubcOut表的FStatus,却触发IcMo触发器的bug。
/*
*
*
* */
if (string.IsNullOrEmpty(strDelCommitDate) && !string.IsNullOrEmpty(strInsCommitDate))
{
K3DataParaInfo docInfo = new K3DataParaInfo()
{
BillCode = billCode,
InterID = interID,
EntryID = 0,
TransType = 85,
ROB = 1,
CurrentUser = "******",
X9BillType = 5,
EventName = "ApprovedAfter",
Data = "",
};
if (!basicHandle(docInfo))
{
try
{
// Get the current transaction and roll it back.
Transaction trans = Transaction.Current;
trans.Rollback();
}
catch (SqlException ex)
{
//throw new Exception("X9系统异常");
return;
}
}
}
#endregion
#region 反下达时
if (string.IsNullOrEmpty(strInsCommitDate) && !string.IsNullOrEmpty(strDelCommitDate))
{
K3DataParaInfo docInfo = new K3DataParaInfo()
{
BillCode = billCode,
InterID = interID,
EntryID = 0,
TransType = 85,
ROB = 1,
CurrentUser = "******",
X9BillType = 5,
EventName = "UnApprovedAfter",
Data = "",
};
if (!basicHandle(docInfo))
{
try
{
// Get the current transaction and roll it back.
Transaction trans = Transaction.Current;
trans.Rollback();
}
catch (SqlException ex)
{
return;
}
}
}
#endregion
#region 结案时
if (insFStatus == 3 && delFStatus != 3)
{
K3DataParaInfo docInfo = new K3DataParaInfo()
{
BillCode = billCode,
InterID = interID,
EntryID = 0,
TransType = 85,
ROB = 1,
CurrentUser = "******",
X9BillType = 5,
EventName = "ClosedAfter",
Data = "",
};
if (!basicHandle(docInfo))
{
try
{
// Get the current transaction and roll it back.
Transaction trans = Transaction.Current;
trans.Rollback();
}
catch (SqlException ex)
{
return;
}
}
}
#endregion
//反结案时
if (delFStatus == 3 && insFStatus != 3)
{
K3DataParaInfo docInfo = new K3DataParaInfo()
{
BillCode = billCode,
InterID = interID,
EntryID = 0,
TransType = 85,
ROB = 1,
CurrentUser = "******",
X9BillType = 5,
EventName = "UnClosedAfter",
Data = "",
};
if (!basicHandle(docInfo))
{
try
{
// Get the current transaction and roll it back.
Transaction trans = Transaction.Current;
trans.Rollback();
}
catch (SqlException ex)
{
return;
}
}
}
}
