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)));
}
