public List <ExternalSupplyServiceDomainValueMaptbl> ESSDVMtblsGetAllFiledByDomainTypeAndDomainValue(string domainType, string domainValue, string supplierID) { ExternalSupplyServiceDomainValueMaptbl searchTbl = new ExternalSupplyServiceDomainValueMaptbl(domainType: domainType, domainValue: domainValue, supplierID: supplierID); string query = TBLQueryGet(searchTbl); return(ESSDVMtblsGet(query, this.ConnectionString)); }
/// <summary> /// Query ExternalSupplyServiceDomainValueMap table to get ExternalDomainValue /// </summary> /// <param name="domainType"></param> /// <param name="domainValue"></param> /// <returns></returns> public string ESSDVMtblsGetExternalDomainValue(string domainType, string domainValue, string messageSystemID = null) { ExternalSupplyServiceDomainValueMaptbl searchTbl = new ExternalSupplyServiceDomainValueMaptbl( domainType: domainType, domainValue: domainValue, messageSystemID: messageSystemID); string query = TBLQueryGet(searchTbl); return(ESSDVMtblsGetExternalDomainValue(query)); }
/// <summary> /// Query ExternalSupplyServiceDomainValueMap table to get mapping info /// </summary> public string ESSDVMtblsGetDomainValue(string domainType, string externalDomainValue, string additionDomainValue = null, string messageSystemID = null, string supplierID = null) { ExternalSupplyServiceDomainValueMaptbl searchTbl = new ExternalSupplyServiceDomainValueMaptbl( domainType: domainType, externalDomainValue: externalDomainValue, domainValue: additionDomainValue, messageSystemID: messageSystemID, supplierID: supplierID); return(ESSDVMtblsGetDomainValue(TBLQueryGet(searchTbl))); }
/// <summary> /// in CarWorldspanSCS, column name is DomainTypeID, not DomainType /// </summary> /// <param name="domainTypeID"></param> /// <param name="externalDomainValue"></param> /// <param name="additionDomainValue"></param> /// <returns></returns> public string ESSDVMtblsGetDomainValue(int domainTypeID, string externalDomainValue, string additionDomainValue = null) { ExternalSupplyServiceDomainValueMaptbl searchTbl = new ExternalSupplyServiceDomainValueMaptbl( domainType: domainTypeID.ToString(), externalDomainValue: externalDomainValue, domainValue: additionDomainValue); string[] columns = new string[1] { "DomainType" }; return(ESSDVMtblsGetDomainValue(TBLQueryGet(searchTbl, columns))); }
/// <summary> /// in CarWorldspanSCS, column name is DomainTypeID, not DomainType /// </summary> /// <param name="domainTypeID"></param> /// <param name="domainValue"></param> /// <returns></returns> public string ESSDVMtblsGetExternalDomainValue(int domainTypeID, string domainValue) { ExternalSupplyServiceDomainValueMaptbl searchTbl = new ExternalSupplyServiceDomainValueMaptbl( domainType: domainTypeID.ToString(), domainValue: domainValue); string[] columns = new string[1] { "DomainType" }; string query = TBLQueryGet(searchTbl, columns); return(ESSDVMtblsGetExternalDomainValue(query)); }
/// <summary> /// ExternalSupplyServiceDomainValueMap entity list get by query /// </summary> /// <param name="query"></param> /// <param name="connectionString"></param> /// <returns></returns> public static List <ExternalSupplyServiceDomainValueMaptbl> ESSDVMtblsGet( string query, string connectionString) { List <ExternalSupplyServiceDomainValueMaptbl> tbls = new List <ExternalSupplyServiceDomainValueMaptbl>(); using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmd = conn.CreateCommand(); conn.Open(); cmd.CommandText = query; cmd.CommandTimeout = 0; SqlDataReader reader = cmd.ExecuteReader(); ExternalSupplyServiceDomainValueMaptbl tbl; string domainTypeColname = "DomainType"; if (!CarSCSCommonHelper.ColumnExists(reader, domainTypeColname)) { domainTypeColname = "DomainTypeID"; } while (reader.Read()) { tbl = new ExternalSupplyServiceDomainValueMaptbl(); tbl.SupplierID = reader["SupplierID"].ToString(); tbl.MessageSystemID = reader["MessageSystemID"].ToString(); tbl.DomainType = reader[domainTypeColname].ToString(); tbl.DomainValue = reader["DomainValue"].ToString(); tbl.ExternalDomainValue = reader["ExternalDomainValue"].ToString(); tbl.CreateDate = Convert.ToDateTime(reader["CreateDate"].ToString()); tbl.CreatedBy = reader["CreatedBy"].ToString(); tbl.UpdateDate = Convert.ToDateTime(reader["UpdateDate"].ToString()); tbl.LastUpdatedBy = reader["LastUpdatedBy"].ToString(); tbls.Add(tbl); } conn.Close(); } return(tbls); }
/// <summary> /// ExternalSupplyServiceDomainValueMap table query get /// </summary> /// <param name="searchTbl"></param> /// <returns></returns> public static string TBLQueryGet(ExternalSupplyServiceDomainValueMaptbl searchTbl, string[] columnNames = null) { string domainTypeStr = "and DomainType"; string eDomainValueStr = "and ExternalDomainValue"; string domainValueStr = "and DomainValue"; string supplierIDStr = "and SupplierID"; string messageSystemIDStr = "and MessageSystemID"; if (columnNames != null) { if (columnNames.Length > 0) { domainTypeStr = "and " + columnNames[0]; } if (columnNames.Length > 1) { eDomainValueStr = "and " + columnNames[1]; } if (columnNames.Length > 2) { domainValueStr = "and " + columnNames[2]; } if (columnNames.Length > 3) { supplierIDStr = "and " + columnNames[3]; } if (columnNames.Length > 4) { messageSystemIDStr = "and " + columnNames[4]; } } return(string.Format("select * from ExternalSupplyServiceDomainValueMap where 1=1 {0} {1} {2} {3} {4}" , CarSCSCommonHelper.SubConditionQueryGet <string>(searchTbl.DomainType, domainTypeStr, noReturnIfNoValue: true) , CarSCSCommonHelper.SubConditionQueryGet <string>(searchTbl.ExternalDomainValue, eDomainValueStr, noReturnIfNoValue: true) , CarSCSCommonHelper.SubConditionQueryGet <string>(searchTbl.DomainValue, domainValueStr, noReturnIfNoValue: true) , CarSCSCommonHelper.SubConditionQueryGet <string>(searchTbl.SupplierID, supplierIDStr, noReturnIfNoValue: true) , CarSCSCommonHelper.SubConditionQueryGet <string>(searchTbl.MessageSystemID, messageSystemIDStr, noReturnIfNoValue: true))); }