public SQLInQueryCriteriaItem(ThrPartyDBParamter param, GWDataDBField sourceField) { TargetField = param.FieldName; SourceField = sourceField.GetFullFieldName(); GWDataDBField = sourceField; _paramter = param; }
public RdetOutQueryCriterialItem(GWDataDBField targetfield, ThrPartyDBParamter param) { TargetField = targetfield.GetFullFieldName(); SourceField = param.FieldName; GWDataDBField = targetfield; _paramter = param; }
public SocketInQueryResultItem(ThrPartyDBParamter param, GWDataDBField sourceField) { TargetField = param.FieldName; SourceField = sourceField.GetFullFieldName(); GWDataDBField = sourceField; _paramter = param; }
public SocketInQueryResultItem(GWDataDBField targetfield, ThrPartyDBParamter param) { TargetField = targetfield.GetFullFieldName(); SourceField = param.FieldName; GWDataDBField = targetfield; _paramter = param; }
public RdetOutQueryResultItem(ThrPartyDBParamter param, GWDataDBField sourceField, bool redundancyFlag) { RedundancyFlag = redundancyFlag; TargetField = param.FieldName; SourceField = sourceField.GetFullFieldName(); GWDataDBField = sourceField; _paramter = param; }
public SocketInQueryCriteriaItem(ThrPartyDBParamter param, GWDataDBField sourceField, bool redundancyFlag) { RedundancyFlag = redundancyFlag; TargetField = param.FieldName; SourceField = sourceField.GetFullFieldName(); GWDataDBField = sourceField; _paramter = param; }
private void CheckFields(XCollection <GWDataDBField> fields) { for (int i = 0; i < listView1.Items.Count; i++) { this.listView1.Items[i].Checked = false; GWDataDBField dbf = (GWDataDBField)listView1.Items[i].Tag; foreach (GWDataDBField f in fields) { if (f.GetFullFieldName() == dbf.GetFullFieldName()) { this.listView1.Items[i].Checked = true; } } } }
/// <summary> /// support [%ChannelName%] token, let channecl.name as the part of filename /// </summary> /// <param name="ch"></param> /// <returns></returns> public static string BuildOutFileName(FileOutChannel ch, DataRow dr) { if (_FileOutAdapterConfig == null) { throw new Exception("System cannot initialized!"); } string sFilePath = _FileOutAdapterConfig.OutGeneralParams.FilePath; string sFilePrefix = _FileOutAdapterConfig.OutGeneralParams.FilePrefix; string sFileSuffix = _FileOutAdapterConfig.OutGeneralParams.FileSuffix; string sDatetime = ""; if (_FileOutAdapterConfig.OutGeneralParams.FileDtFormat.Trim() != "") { sDatetime = DateTime.Now.ToString(_FileOutAdapterConfig.OutGeneralParams.FileDtFormat); } if (sFilePath.Trim() == "") { sFilePath = Application.StartupPath + "\\data\\"; } if (!Directory.Exists(sFilePath)) { Directory.CreateDirectory(sFilePath); } sFilePath = sFilePath.Trim(); if (sFilePath.Substring(sFilePath.Length - 1, 1) != "\\") { sFilePath = sFilePath + "\\"; } #region Replace [%Table_Field%] with pValue //if (sFilePrefix.Trim().ToUpper() == ("[%ChannelName%]").ToUpper()) // sFilePrefix = ch.ChannelName; string pValue; //replace value foreach (GWDataDBField prefield in FileOutAdapterConfig.OutGeneralParams.PreGWDataDBFields) { pValue = ""; foreach (FileOutQueryResultItem resultItem in ch.Rule.QueryResult.MappingList) { GWDataDBField resultField = resultItem.GWDataDBField; if (resultField.GetFullFieldName().Trim().ToUpper() == prefield.GetFullFieldName().Trim().ToUpper()) { object o = dr[resultItem.TargetField]; if (Convert.IsDBNull(o)) { pValue = ""; } else { pValue = Convert.ToString(o); } break; } } //Replace [%Table_Field%] with pValue sFilePrefix = sFilePrefix.Replace("[%" + prefield.GetFullFieldName().Replace(".", "_") + "%]", pValue); } //Gurant no error file name sFilePrefix = sFilePrefix.Replace("[%", ""); sFilePrefix = sFilePrefix.Replace("%]", ""); #endregion if (sFileSuffix.IndexOf(".") < 0) { sFileSuffix = "." + sFileSuffix; } string sFileName; for (int i = 0; i < Int32.MaxValue; i++) { if (i == 0) { sFileName = sFilePath + sFilePrefix + sDatetime + sFileSuffix; } else { sFileName = sFilePath + sFilePrefix + sDatetime + i.ToString() + sFileSuffix; } if (!File.Exists(sFileName)) { return(sFileName); } } throw new Exception("Cannot build outfilename, extract out int32.maxvalue!"); }