internal DataSet RequestData(IOutboundRule rule, DataSet criteria)
{
if (OnDataRequest == null)
{
return(null);
}
return(OnDataRequest(rule, criteria));
}
private DataSet controler_OnDataRequest(IOutboundRule rule, DataSet criteria)
{
if (OnDataRequest != null)
{
return(OnDataRequest(rule, criteria));
}
else
{
return(null);
}
}
private DataSet controler_OnDataRequest(IOutboundRule rule, DataSet criteria)
{
if (OnDataRequest != null)
{
return(OnDataRequest(rule, criteria));
}
else
{
Program.Log.Write(LogType.Warning, "OnDataRequest is not implemented!");
return(null);
}
}
private DataSet outAdapter_OnDataRequest(IOutboundRule rule, DataSet criteria)
{
Program.Log.Write("-- Prepare outbound data begin --");
DataSet result = null;
if (rule == null)
{
Program.Log.Write(LogType.Warning, "Receive a <null> rule.");
goto EndSub;
}
if (criteria == null)
{
Program.Log.Write(LogType.Warning, "Receive a <null> criteria data set.");
}
if (Program.ConfigMgt.Config.DumpData)
{
dataControler.WriteDataToFile(DataAccessControler.GetSPName(rule) + "_QC", criteria);
}
result = dataControler.PrepareOutboundData(rule, criteria);
if (Program.ConfigMgt.Config.DumpData)
{
dataControler.WriteDataToFile(DataAccessControler.GetSPName(rule) + "_QR", result);
}
EndSub:
if (result == null)
{
Program.Log.Write("-- Prepare outbound data end. Return data set: <null> --\r\n");
}
else
{
int rowCount = -1;
if (result.Tables.Count > 0)
{
rowCount = result.Tables[0].Rows.Count;
}
Program.Log.Write("-- Prepare outbound data end. Return data set, number of rows : " + rowCount.ToString() + " --\r\n");
}
return(result);
}
public DataSet PrepareOutboundData(IOutboundRule rule, DataSet criteria)
{
if (rule == null)
{
return(null);
}
bool result = false;
DataSet resultData = null;
//SafeDBConnection cn = SafeDBConnection.Instance;
OleDbConnection cnn = new OleDbConnection(Program.ConfigMgt.Config.DataDBConnection);
try
{
//OleDbCommand cmd = new OleDbCommand(GetSPName(rule), cn.Connection);
OleDbCommand cmd = new OleDbCommand(GetSPName(rule), cnn);
cmd.CommandType = CommandType.StoredProcedure;
if (criteria != null && criteria.Tables.Count > 0)
{
Program.Log.Write("Query criteria (" + criteria.Tables[0].Rows.Count.ToString() + ": ");
MappingItem[] qcList = rule.GetQueryCriteriaItems();
if (qcList == null || qcList.Length < 1)
{
Program.Log.Write(LogType.Warning, "No query criteria mapping item found in outbound rule. ");
}
else
{
foreach (DataRow dr in criteria.Tables[0].Rows)
{
foreach (MappingItem qc in qcList)
{
// following logic is according to
// public static string GetSP<TC, TR>(string interfaceName, OutboundRule<TC, TR> rule)
if (qc.Translating.Type == TranslatingType.FixValue)
{
continue;
}
OleDbParameter param = new OleDbParameter();
param.ParameterName = "@" + qc.SourceField;
param.OleDbType = OleDbType.VarWChar;
param.Direction = ParameterDirection.Input;
param.Value = dr[qc.SourceField].ToString(); //.Replace("'", "''"); // db parameter will handle this
cmd.Parameters.Add(param);
Program.Log.Write(qc.SourceField + " = " + param.Value);
}
}
}
Program.Log.Write("");
}
resultData = new DataSet();
OleDbDataAdapter ad = new OleDbDataAdapter();
ad.SelectCommand = cmd;
//cn.Open();
cnn.Open();
int count = ad.Fill(resultData);
//cn.Close();
cnn.Close();
if (resultData.Tables.Count > 0 &&
(Program.ConfigMgt.Config.Composing.Enable ||
Program.ConfigMgt.Config.Replacement.Enable ||
Program.ConfigMgt.Config.Chinese2Pinyin.Enable) ||
Program.ConfigMgt.Config.L3KanJiReplacement.Enable)
{
DataTable dt = resultData.Tables[0];
MappingItem[] qrList = rule.GetQueryResultItems();
if (qrList == null || qrList.Length < 1)
{
Program.Log.Write(LogType.Warning, "No query result mapping item found in outbound rule. ");
}
else
{
foreach (DataRow dr in dt.Rows)
{
foreach (MappingItem qr in qrList)
{
//string strValue = dr[qr.TargetField].ToString();
#region Composing
if (Program.ConfigMgt.Config.Composing.Enable)
{
ComposingRuleItem comRule = Program.ConfigMgt.Config.Composing.GetComposingRule(qr.GWDataDBField);
if (comRule != null && dt.Columns.Contains(qr.TargetField))
{
string strValue = dr[qr.TargetField].ToString();
List <string> sourceList = new List <string>();
foreach (GWDataDBField sourceField in comRule.FromFields)
{
string sourceValue = "";
foreach (MappingItem sItem in qrList)
{
if (sItem.GWDataDBField.Table == sourceField.Table &&
sItem.GWDataDBField.FieldName == sourceField.FieldName)
{
if (dt.Columns.Contains(sItem.TargetField))
{
sourceValue = dr[sItem.TargetField].ToString();
}
break;
}
}
sourceList.Add(sourceValue);
}
strValue = comRule.Compose(sourceList.ToArray(), Program.Log);
dr[qr.TargetField] = strValue;
}
}
#endregion
#region Regular Replacement
if (Program.ConfigMgt.Config.Replacement.Enable)
{
ReplacementRuleItem item = Program.ConfigMgt.Config.Replacement.GetReplacementRule(qr.GWDataDBField);
if (item != null && dt.Columns.Contains(qr.TargetField))
{
string strValue = dr[qr.TargetField].ToString();
strValue = item.RegularExpression.Replace(strValue, Program.Log);
dr[qr.TargetField] = strValue;
}
}
#endregion
#region Chinese2Pinyin
if (Program.ConfigMgt.Config.Chinese2Pinyin.Enable)
{
Chinese2PinyinRuleItem item = Program.ConfigMgt.Config.Chinese2Pinyin.GetChinese2PinyinRule(qr.GWDataDBField);
if (item != null && dt.Columns.Contains(qr.TargetField))
{
string strValue = dr[qr.TargetField].ToString();
strValue = ChineseCode.Convert(item.ConvertType, strValue, Program.Log);
strValue = PinyinFactory.GetInstance(item.Type).ConvertName(strValue, Program.Log);
dr[qr.TargetField] = strValue;
}
}
#endregion
//dr[qr.TargetField] = strValue;
#region Level 3 KanJi Replacement
if (Program.ConfigMgt.Config.L3KanJiReplacement.Enable)
{
Level3KanJiReplacementRuleItem item = Program.ConfigMgt.Config.L3KanJiReplacement.GetLevel3KanJiReplacementRule(qr.GWDataDBField);
if (item != null && dt.Columns.Contains(qr.TargetField))
{
string strValue = dr[qr.TargetField].ToString();
strValue = item.Replace(strValue, Program.Log);
dr[qr.TargetField] = strValue;
}
}
#endregion
}
}
}
}
Program.Log.Write("Prepare outbound data success. SP Name: " + GetSPName(rule) + ", Number of rows affected: " + count.ToString());
result = true;
}
catch (Exception err)
{
Program.Log.Write(LogType.Warning, "Prepare outbound data failed.");
DumpDataBaseError(err, rule, criteria);
}
finally
{
//if (!result) cn.Close();
if (!result)
{
cnn.Close();
}
}
return(resultData);
}
