/* * private static void UpdateGUID(DataTable dt, DataColumn dc, string columnName, GWDataDBField field) * { * if (dc.ColumnName == columnName) * { * Dictionary<string, string> rpIDs = new Dictionary<string, string>(); * foreach (DataRow dr in dt.Rows) * { * object o = dr[dc]; * string rpID = (o == null) ? "" : o.ToString(); * if (rpID.Length < 1) * { * string guid = DicomMappingHelper.GetGUID(dr); * rpID = DHelper.GetDicomGUID(); * rpIDs.Add(guid, rpID); * dr[dc] = rpID; * } * } * if (rpIDs.Count > 0) * { * StringBuilder sb = new StringBuilder(); * foreach (KeyValuePair<string, string> pair in rpIDs) * { * string tableName = GWDataDB.GetTableName(Program.InterfaceName, GWDataDBTable.Order); * string pkName = GWDataDBField.o_DATA_ID.FieldName; * string fieldName = field.FieldName; * sb.Append("UPDATE ").Append(tableName) * .Append(" SET ").Append(fieldName).Append(" = '").Append(pair.Value).Append("'") * .Append(" WHERE ").Append(pkName).Append(" = '").Append(pair.Key).Append("';\r\n"); * } * if (Program.Database.DoQuery(sb.ToString()) == null) * { * Program.Log.Write(LogType.Error, "Update " + columnName + " into database failed."); * } * else * { * Program.Log.Write("Update " + columnName + " into database succeeded."); * } * } * } * }*/ private bool UpdateStudyInstanceUID(string sData_ID, string sStudyInstanceUID, GWDataDBField field) { try { if (field == null) { Program.Log.Write(LogType.Error, "No StudyInstanceUID map!"); return(false); } string sTableName = GWDataDB.GetTableName(Program.InterfaceName, field.Table); string sSql = " update " + sTableName + " set " + field.FieldName + " ='" + sStudyInstanceUID + "'" + " where data_id='" + sData_ID + "'"; if (Program.Database.DoQuery(sSql) == null) { Program.Log.Write(LogType.Error, "Update StudyINstanceUID into" + field.ToString() + " failed."); } else { Program.Log.Write(LogType.Debug, "Update StudyINstanceUID into" + field.ToString() + " succeeded."); } return(true); } catch (Exception ex) { Program.Log.Write(LogType.Error, "Write StudyInstanceUID to GWDataDB Error:" + ex.Message); return(false); } }
//All matched tables public static string GetTablesString(string guid) { string patientTableName = "[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Patient) + "]"; string orderTableName = "[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Order) + "]"; string reportTableName = "[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Report) + "]"; StringBuilder sb = new StringBuilder(); //sb.AppendLine("USE " + GWDataDB.DataBaseName); //sb.AppendLine(""); //sb.AppendLine("SET ANSI_NULLS ON"); //sb.AppendLine("SET QUOTED_IDENTIFIER ON"); //sb.AppendLine(""); //sb.AppendLine("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Patient) + "]') AND type in (N'U'))"); sb.AppendLine("SELECT " + patientTableName + ".* FROM " + patientTableName); sb.AppendLine("WHERE " + GWDBControl.GetFullFieldName(interfaceName, GWDataDBField.p_DATA_ID) + " = " + "\'" + guid + "\'"); sb.AppendLine(""); sb.AppendLine("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Patient) + "]') AND type in (N'U'))"); sb.AppendLine("SELECT " + orderTableName + ".* FROM " + orderTableName); sb.AppendLine("WHERE " + GWDBControl.GetFullFieldName(interfaceName, GWDataDBField.o_DATA_ID) + " = " + "\'" + guid + "\'"); sb.AppendLine(""); sb.AppendLine("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Patient) + "]') AND type in (N'U'))"); sb.AppendLine("SELECT " + reportTableName + ".* FROM " + reportTableName); sb.AppendLine("WHERE " + GWDBControl.GetFullFieldName(interfaceName, GWDataDBField.r_DATA_ID) + " = " + "\'" + guid + "\'"); sb.AppendLine(""); return(sb.ToString()); }
private void SaveChecked() { if (_FormType == FormType.ftPKF) { _PKFields.Clear(); for (int i = 0; i < this.listView1.Items.Count; i++) { ListViewItem lvi = this.listView1.Items[i]; GWDataDBField dbf = (GWDataDBField)lvi.Tag; if (lvi.Checked) { _PKFields.Add(new PKField(GWDataDB.GetTableName(dbf.Table), dbf.FieldName, "AND")); } //_PKFields.Add(new PKField(dbf.Table.ToString(),dbf.FieldName,"AND")); } } if (_FormType == FormType.ftMgF) { _MergeFields.Clear(); for (int i = 0; i < this.listView1.Items.Count; i++) { ListViewItem lvi = this.listView1.Items[i]; GWDataDBField dbf = (GWDataDBField)lvi.Tag; if (lvi.Checked) { _MergeFields.Add(new MergeField(GWDataDB.GetTableName(dbf.Table), dbf.FieldName)); } //_MergeFields.Add(new MergeField(dbf.Table.ToString(), dbf.FieldName)); } } }
public static string GetUpdateString(DataGridViewColumnCollection columns, DataGridViewRow row, GWDataDBTable table) { string tableName = "[dbo].[" + GWDataDB.GetTableName(interfaceName, table) + "]"; StringBuilder sb = new StringBuilder(); //sb.AppendLine("USE " + GWDataDB.DataBaseName); //sb.AppendLine("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[" + GWDataDB.GetTableName(interfaceName, table) + "]') AND type in (N'U'))"); sb.AppendLine("UPDATE " + tableName); sb.AppendLine("SET "); #region Set expression part of update script StringBuilder sbExp = new StringBuilder(); int i = 0; foreach (DataGridViewColumn column in columns) { sbExp.AppendLine("[" + column.HeaderText + "] = " + "N\'" + row.Cells[i].Value.ToString().Replace("'", "''") + "\',"); i++; } sbExp.Remove(sbExp.Length - 3, 3).ToString(); string strExp = sbExp.ToString(); #endregion sb.AppendLine(strExp); sb.AppendLine("WHERE"); sb.AppendLine("[" + columns[0].HeaderText + "] = " + "\'" + row.Cells[0].Value.ToString().Replace("'", "''") + "\'"); return(sb.ToString()); }
public static string GetDeleteString(string guid) { string indexTablename = "[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Index) + "]"; string patientTableName = "[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Patient) + "]"; string orderTableName = "[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Order) + "]"; string reportTableName = "[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Report) + "]"; StringBuilder sb = new StringBuilder(); //sb.AppendLine("USE " + GWDataDB.DataBaseName); //sb.AppendLine("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Report) + "]') AND type in (N'U'))"); sb.AppendLine("DELETE" + " FROM " + reportTableName); sb.AppendLine("WHERE " + GWDBControl.GetFullFieldName(interfaceName, GWDataDBField.r_DATA_ID) + " = " + "\'" + guid + "\'"); sb.AppendLine(""); //sb.AppendLine("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Order) + "]') AND type in (N'U'))"); sb.AppendLine("DELETE" + " FROM " + orderTableName); sb.AppendLine("WHERE " + GWDBControl.GetFullFieldName(interfaceName, GWDataDBField.o_DATA_ID) + " = " + "\'" + guid + "\'"); sb.AppendLine(""); //sb.AppendLine("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Patient) + "]') AND type in (N'U'))"); sb.AppendLine("DELETE" + " FROM " + patientTableName); sb.AppendLine("WHERE " + GWDBControl.GetFullFieldName(interfaceName, GWDataDBField.p_DATA_ID) + " = " + "\'" + guid + "\'"); sb.AppendLine(""); //sb.AppendLine("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Index) + "]') AND type in (N'U'))"); sb.AppendLine("DELETE" + " FROM " + indexTablename); sb.AppendLine("WHERE " + GWDBControl.GetFullFieldName(interfaceName, GWDataDBField.i_IndexGuid) + " = " + "\'" + guid + "\'"); return(sb.ToString()); }
private bool DispatchMessage_Custom(DataRow dataRow, ref string strResponse) { string strFieldName = GWDataDB.GetTableName(GWDataDB.GetTable(_entity.Context.ConfigMgr.Config.MessageDispatchConfig.TableName)) + "_" + _entity.Context.ConfigMgr.Config.MessageDispatchConfig.FieldName; string strConditionValue = dataRow[strFieldName].ToString(); string[] valueSubscribers = _entity.Context.ConfigMgr.Config.MessageDispatchConfig.ValueSubscriber.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries); foreach (string str in valueSubscribers) { if (str.Equals(strConditionValue)) { return(DispatchMessage_Publish(dataRow)); } } string[] valueResponsers = _entity.Context.ConfigMgr.Config.MessageDispatchConfig.ValueResponser.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries); foreach (string str in valueResponsers) { if (str.Equals(strConditionValue)) { return(DispatchMessage_Request(dataRow, ref strResponse)); } } _entity.Context.Log.Write(LogType.Error, "Can not determine how to dispath the following dataset according to current configuration."); _entity.Context.Log.Write(LogType.Error, SerializeDataRowToXml(dataRow)); strResponse = _entity.Context.ConfigMgr.Config.GetBrokerErrorMessageContent(); return(false); }
private void RefreshTableName() { string interfaceName = this.textBoxTP.Text; this.textBoxTName.Text = GWDataDB.GetTableName(interfaceName, GWDataDBTable.Index) + "," + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Patient) + "," + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Order) + "," + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Report); }
private static void UpdateGUID(DataTable dt, DataColumn dc, string columnName, GWDataDBField field) { if (dc.ColumnName == columnName) { Dictionary <string, string> rpIDs = new Dictionary <string, string>(); foreach (DataRow dr in dt.Rows) { object o = dr[dc]; string rpID = (o == null) ? "" : o.ToString(); if (rpID.Length < 1) // need to generate GUID { string guid = DicomMappingHelper.GetGUID(dr); if (rpIDs.ContainsKey(guid)) { // 20100222 // has already generated GUID in this loop, // for example there are two records with same guid and splitted according to multiple procedure codes // 20100227 // as we move the auto generating STDUID before the procedure code spliting in the class Kodak.GCGateway.DicomAdapter.MWLServer.Dicom.WorklistSCP, // this (different records with the same guid/data_id) will not happen any more. rpID = rpIDs[guid]; } else { rpID = DHelper.GetDicomGUID(Program.DeviceMgt.DeviceDirInfor.Header.ID, Program.ConfigMgt.Config.MaxAutoGeneratedLengthOfSTDUID); rpIDs.Add(guid, rpID); } dr[dc] = rpID; } } if (rpIDs.Count > 0) { StringBuilder sb = new StringBuilder(); foreach (KeyValuePair <string, string> pair in rpIDs) { string tableName = GWDataDB.GetTableName(Program.InterfaceName, GWDataDBTable.Order); string pkName = GWDataDBField.o_DATA_ID.FieldName; string fieldName = field.FieldName; sb.Append("UPDATE ").Append(tableName) .Append(" SET ").Append(fieldName).Append(" = '").Append(pair.Value).Append("'") .Append(" WHERE ").Append(pkName).Append(" = '").Append(pair.Key).Append("';\r\n"); } if (Program.Database.DoQuery(sb.ToString()) == null) { Program.Log.Write(LogType.Error, "Update " + columnName + " into database failed."); } else { Program.Log.Write("Update " + columnName + " into database succeeded."); } } } }
public static string GetHeadersQueryString(GWDataDBTable table) { string tableName = "[dbo].[" + GWDataDB.GetTableName(interfaceName, table) + "]"; StringBuilder sb = new StringBuilder(); //sb.AppendLine("USE " + GWDataDB.DataBaseName); //sb.AppendLine("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[" + GWDataDB.GetTableName(interfaceName, table) + "]') AND type in (N'U'))"); sb.AppendLine("SELECT TOP 0" + " * FROM " + tableName); return(sb.ToString()); }
private static void UpdateID(DataTable dt, DataColumn dc, string columnName, GWDataDBField field) { if (dc.ColumnName == columnName) { Dictionary <string, string> rpIDs = new Dictionary <string, string>(); foreach (DataRow dr in dt.Rows) { object o = dr[dc]; string rpID = (o == null) ? "" : o.ToString(); if (rpID.Length < 1) { string guid = DicomMappingHelper.GetGUID(dr); if (rpIDs.ContainsKey(guid)) { // 20100222 // please see the function UpdateGUID() for details rpID = rpIDs[guid]; } else { rpID = GetRandomNumber(Program.ConfigMgt.Config.MaxAutoGeneratedLengthOfRPIDAndSPSID).ToString(); rpIDs.Add(guid, rpID); } dr[dc] = rpID; } } if (rpIDs.Count > 0) { StringBuilder sb = new StringBuilder(); foreach (KeyValuePair <string, string> pair in rpIDs) { string tableName = GWDataDB.GetTableName(Program.InterfaceName, GWDataDBTable.Order); string pkName = GWDataDBField.o_DATA_ID.FieldName; string fieldName = field.FieldName; sb.Append("UPDATE ").Append(tableName) .Append(" SET ").Append(fieldName).Append(" = '").Append(pair.Value).Append("'") .Append(" WHERE ").Append(pkName).Append(" = '").Append(pair.Key).Append("';\r\n"); } //Program.Log.Write(sb.ToString()); if (Program.Database.DoQuery(sb.ToString()) == null) { Program.Log.Write(LogType.Error, "Update " + columnName + " into database failed."); } else { Program.Log.Write("Update " + columnName + " into database succeeded."); } } } }
private void CheckFields(MergeFields mgfs) { for (int i = 0; i < listView1.Items.Count; i++) { GWDataDBField dbf = (GWDataDBField)listView1.Items[i].Tag; //if (mgfs.FindField(dbf.Table.ToString(), dbf.FieldName) != null) if (mgfs.FindField(GWDataDB.GetTableName(dbf.Table), dbf.FieldName) != null) { this.listView1.Items[i].Checked = true; } else { this.listView1.Items[i].Checked = false; } } }
public static string GetAddString(DataGridViewColumnCollection columns, DataGridViewRow row, GWDataDBTable table) { if (table == GWDataDBTable.None) { return(null); } string tablename = "[dbo].[" + GWDataDB.GetTableName(interfaceName, table) + "]"; StringBuilder sb = new StringBuilder(); //sb.AppendLine("USE " + GWDataDB.DataBaseName); //sb.AppendLine("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[" + GWDataDB.GetTableName(interfaceName, table) + "]') AND type in (N'U'))"); sb.AppendLine("INSERT INTO " + tablename); #region Fields StringBuilder sbField = new StringBuilder(); foreach (DataGridViewColumn column in columns) { sbField.Append("[" + column.HeaderText + "]" + ","); } string strField = sbField.ToString(); if (strField.Length > 0) { strField = strField.TrimEnd(','); } sb.AppendLine(" ( "+ strField + " )"); #endregion sb.AppendLine(" VALUES"); #region Values StringBuilder sbValue = new StringBuilder(); foreach (DataGridViewCell cell in row.Cells) { sbValue.Append("N\'" + cell.Value.ToString().Replace("'", "''") + "\'" + ","); } string strValue = sbValue.ToString(); if (strValue.Length > 0) { strValue = strValue.TrimEnd(','); } sb.AppendLine(" ( "+ strValue + " )"); #endregion return(sb.ToString()); }
//Just one table form patient, order or report public static string GetSelectRecordString(string guid, GWDataDBTable table) { string tableName = "[dbo].[" + GWDataDB.GetTableName(interfaceName, table) + "]"; StringBuilder sb = new StringBuilder(); //sb.AppendLine("USE " + GWDataDB.DataBaseName); //sb.AppendLine("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[" + GWDataDB.GetTableName(interfaceName, table) + "]') AND type in (N'U'))"); sb.AppendLine("SELECT " + " * FROM " + tableName); sb.AppendLine("WHERE"); #region Get Field Name string fieldname = ""; switch (table) { case GWDataDBTable.Index: { fieldname = GWDataDBField.i_IndexGuid.FieldName; break; } case GWDataDBTable.Patient: { fieldname = GWDataDBField.p_DATA_ID.FieldName; break; } case GWDataDBTable.Order: { fieldname = GWDataDBField.o_DATA_ID.FieldName; break; } case GWDataDBTable.Report: { fieldname = GWDataDBField.r_DATA_ID.FieldName; break; } } #endregion sb.AppendLine("[" + fieldname + "] = " + "\'" + guid + "\'"); return(sb.ToString()); }
public static string GetFilterString(SimpleQuery queryInfo, XCollection <QueryCriteriaItem> filterItemList) { //Get interface name from configuration file string indexTablename = "[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Index) + "]"; string patientTableName = "[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Patient) + "]"; string orderTableName = "[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Order) + "]"; string reportTableName = "[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Report) + "]"; #region Query Head StringBuilder sb = new StringBuilder(); //sb.AppendLine("USE " + GWDataDB.DataBaseName); //sb.AppendLine(""); //sb.AppendLine("SET ANSI_NULLS ON"); //sb.AppendLine("SET QUOTED_IDENTIFIER ON"); //sb.AppendLine(""); //sb.AppendLine("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[" + GWDataDB.GetTableName(interfaceName, GWDataDBTable.Index) + "]') AND type in (N'U'))"); sb.AppendLine("SELECT"); sb.AppendLine("\t" + indexTablename + ".* FROM " + indexTablename); sb.AppendLine("\tLEFT JOIN " + patientTableName + " ON " + GWDBControl.GetFullFieldName(interfaceName, GWDataDBField.p_DATA_ID) + " = " + GWDBControl.GetFullFieldName(interfaceName, GWDataDBField.i_IndexGuid)); sb.AppendLine("\tLEFT JOIN " + orderTableName + " ON " + GWDBControl.GetFullFieldName(interfaceName, GWDataDBField.o_DATA_ID) + " = " + GWDBControl.GetFullFieldName(interfaceName, GWDataDBField.i_IndexGuid)); sb.AppendLine("\tLEFT JOIN " + reportTableName + " ON " + GWDBControl.GetFullFieldName(interfaceName, GWDataDBField.r_DATA_ID) + " = " + GWDBControl.GetFullFieldName(interfaceName, GWDataDBField.i_IndexGuid)); #endregion #region Query Condition if (queryInfo != null || filterItemList != null) { StringBuilder sbWhere = new StringBuilder(); if (queryInfo != null) { #region Simple Query if (queryInfo.EventType.Enable) { sbWhere.AppendLine("\tAND " + GWDBControl.GetFullFieldName(interfaceName, queryInfo.EventType.Fieldname) + " like " + "\'%" + queryInfo.EventType.FieldValue.Replace("'", "''") + "%\'"); } if (queryInfo.StartTime.Enable) { sbWhere.AppendLine("\tAND " + GWDBControl.GetFullFieldName(interfaceName, queryInfo.StartTime.Fieldname) + " >= " + "\'" + queryInfo.StartTime.FieldValue.Replace("'", "''") + "\'"); } if (queryInfo.EndTime.Enable) { sbWhere.AppendLine("\tAND " + GWDBControl.GetFullFieldName(interfaceName, queryInfo.EndTime.Fieldname) + " <= " + "\'" + queryInfo.EndTime.FieldValue.Replace("'", "''") + "\'"); } if (queryInfo.PatientID.Enable) { sbWhere.AppendLine("\tAND " + GWDBControl.GetFullFieldName(interfaceName, queryInfo.PatientID.Fieldname) + " like " + "\'%" + queryInfo.PatientID.FieldValue.Replace("'", "''") + "%\'"); } if (queryInfo.PatientName.Enable) { sbWhere.AppendLine("\tAND " + GWDBControl.GetFullFieldName(interfaceName, queryInfo.PatientName.Fieldname) + " like " + "\'%" + queryInfo.PatientName.FieldValue.Replace("'", "''") + "%\'"); } if (queryInfo.OrderNo.Enable) { sbWhere.AppendLine("\tAND " + GWDBControl.GetFullFieldName(interfaceName, queryInfo.OrderNo.Fieldname) + " like " + "\'%" + queryInfo.OrderNo.FieldValue.Replace("'", "''") + "%\'"); } if (queryInfo.AccessionNo.Enable) { sbWhere.AppendLine("\tAND " + GWDBControl.GetFullFieldName(interfaceName, queryInfo.AccessionNo.Fieldname) + " like " + "\'%" + queryInfo.AccessionNo.FieldValue.Replace("'", "''") + "%\'"); } if (queryInfo.StudyInstanceUID.Enable) { sbWhere.AppendLine("\tAND " + GWDBControl.GetFullFieldName(interfaceName, queryInfo.StudyInstanceUID.Fieldname) + " like " + "\'%" + queryInfo.StudyInstanceUID.FieldValue.Replace("'", "''") + "%\'"); } #endregion } else { #region Advanced Query foreach (QueryCriteriaItem filterItem in filterItemList) { if (filterItem.Type == QueryCriteriaType.Or) { sbWhere.Append("\t OR "); } else { sbWhere.Append("\tAND "); } string fname = GWDBControl.GetFullFieldName(interfaceName, filterItem.GWDataDBField); switch (filterItem.Operator) { case QueryCriteriaOperator.Like: { sbWhere.AppendLine(fname + " LIKE " + "\'%" + filterItem.Translating.ConstValue + "%\'"); break; } case QueryCriteriaOperator.Equal: { sbWhere.AppendLine(fname + " = " + "\'" + filterItem.Translating.ConstValue + "\'"); break; } case QueryCriteriaOperator.NotEqual: { sbWhere.AppendLine("(" + fname + " <> " + "\'" + filterItem.Translating.ConstValue + "\'" + " OR " + fname + " IS NULL)"); break; } case QueryCriteriaOperator.LargerThan: { sbWhere.AppendLine(fname + " > " + "\'" + filterItem.Translating.ConstValue + "\'"); break; } case QueryCriteriaOperator.SmallerThan: { sbWhere.AppendLine(fname + " < " + "\'" + filterItem.Translating.ConstValue + "\'"); break; } case QueryCriteriaOperator.EqualLargerThan: { sbWhere.AppendLine(fname + " >= " + "\'" + filterItem.Translating.ConstValue + "\'"); break; } case QueryCriteriaOperator.EqualSmallerThan: { sbWhere.AppendLine(fname + " <= " + "\'" + filterItem.Translating.ConstValue + "\'"); break; } } } #endregion } if (sbWhere.Length > 4) { sbWhere.Remove(1, 4); sb.AppendLine("WHERE"); sb.AppendLine(sbWhere.ToString()); } } #endregion sb.AppendLine(" ORDER BY " + GWDataDBField.i_DataDateTime.GetFullFieldName(interfaceName)); return(sb.ToString()); }