public Type650ServiceReject[] ListServiceRejects(int serviceKey)
{
using (var connection = new SqlConnection(connectionString))
using (var command = connection.CreateCommand("esp_650ServiceRejectList"))
{
command.AddWithValue("@Service_Key", serviceKey);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
var collection = new List <Type650ServiceReject>();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var item = new Type650ServiceReject
{
ServiceKey = serviceKey,
ServiceRejectKey = reader.GetInt32("ServiceReject_Key"),
};
reader.TryGetString("RejectCode", x => item.RejectCode = x);
reader.TryGetString("RejectReason", x => item.RejectReason = x);
reader.TryGetString("UnexCode", x => item.UnexCode = x);
reader.TryGetString("UnexReason", x => item.UnexReason = x);
collection.Add(item);
}
return(collection.ToArray());
}
}
}
public void ParseServiceReject(Prism650Context context, string[] marketFields)
{
var current = context.Current;
if (current == null || current.ModelType != Type650Types.Service)
{
throw new InvalidOperationException();
}
var service = current as Type650Service;
if (service == null)
{
throw new InvalidOperationException();
}
var model = new Type650ServiceReject
{
RejectCode = marketFields.AtIndex(2),
RejectReason = marketFields.AtIndex(3),
UnexCode = marketFields.AtIndex(4),
UnexReason = marketFields.AtIndex(5),
};
service.AddReject(model);
}
public int InsertServiceReject(Type650ServiceReject model)
{
using (var connection = new SqlConnection(connectionString))
using (var command = connection.CreateCommand("csp650ServiceRejectInsert"))
{
SqlParameter keyParameter;
command.AddWithValue("@Service_Key", model.ServiceKey)
.AddIfNotEmptyOrDbNull("@RejectCode", model.RejectCode)
.AddIfNotEmptyOrDbNull("@RejectReason", model.RejectReason)
.AddIfNotEmptyOrDbNull("@UnexCode", model.UnexCode)
.AddIfNotEmptyOrDbNull("@UnexReason", model.UnexReason)
.AddOutParameter("@ServiceReject_Key", SqlDbType.Int, out keyParameter);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.ExecuteNonQuery();
if (keyParameter.Value == null)
{
throw new Exception();
}
var rejectKey = (int)keyParameter.Value;
model.ServiceRejectKey = rejectKey;
return(rejectKey);
}
}
public Type650ServiceReject ParseServiceReject(XElement element, IDictionary <string, XNamespace> namespaces)
{
XNamespace empty;
if (!namespaces.TryGetValue(string.Empty, out empty))
{
empty = XNamespace.None;
}
var model = new Type650ServiceReject
{
RejectCode = element.GetChildText(empty + "RejectCode"),
RejectReason = element.GetChildText(empty + "RejectReason"),
UnexCode = element.GetChildText(empty + "UnexCode"),
UnexReason = element.GetChildText(empty + "UnexReason"),
};
return(model);
}
