public IEnumerable <KeyValuePair <Guid, BAF> > Query()
{
string sql = "SELECT [ID],[AIRLINE],[MILEAGE],[ADULT],[CHILD],[EFFECTIVEDATE],[EXPIREDDATE] FROM [T_BAF]";
var result = new List <KeyValuePair <Guid, BAF> >();
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
using (var reader = dbOperator.ExecuteReader(sql)) {
while (reader.Read())
{
BAF item = new BAF(reader.GetGuid(0));
item.AirlineCode = reader.IsDBNull(1) ? string.Empty : reader.GetString(1);
item.Mileage = reader.GetDecimal(2);
item.Adult = reader.GetDecimal(3);
item.Child = reader.GetDecimal(4);
item.EffectiveDate = reader.GetDateTime(5);
if (!reader.IsDBNull(6))
{
item.ExpiredDate = reader.GetDateTime(6);
}
result.Add(new KeyValuePair <Guid, BAF>(item.Id, item));
}
}
}
return(result);
}
public int Update(BAF value)
{
string sql = "UPDATE [T_BAF] SET [AIRLINE]=@AIRLINE,[MILEAGE]=@MILEAGE,[ADULT]=@ADULT,[CHILD]=@CHILD,[EFFECTIVEDATE]=@EFFECTIVEDATE,[EXPIREDDATE]=@EXPIREDDATE WHERE ID=@ID";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
if (value.AirlineCode.IsNullOrEmpty())
{
dbOperator.AddParameter("AIRLINE", DBNull.Value);
}
else
{
dbOperator.AddParameter("AIRLINE", value.AirlineCode.Value);
}
dbOperator.AddParameter("MILEAGE", value.Mileage);
dbOperator.AddParameter("ADULT", value.Adult);
dbOperator.AddParameter("CHILD", value.Child);
dbOperator.AddParameter("EFFECTIVEDATE", value.EffectiveDate);
dbOperator.AddParameter("ID", value.Id);
if (value.ExpiredDate.HasValue)
{
dbOperator.AddParameter("EXPIREDDATE", value.ExpiredDate.Value);
}
else
{
dbOperator.AddParameter("EXPIREDDATE", DBNull.Value);
}
return(dbOperator.ExecuteNonQuery(sql));
}
}
public int Insert(BAF value)
{
string sql = "INSERT INTO [T_BAF]([ID],[AIRLINE],[MILEAGE],[ADULT],[CHILD],[EFFECTIVEDATE],[EXPIREDDATE]) VALUES(@ID,@AIRLINE,@MILEAGE,@ADULT,@CHILD,@EFFECTIVEDATE,@EXPIREDDATE)";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("ID", value.Id);
if (value.AirlineCode.IsNullOrEmpty())
{
dbOperator.AddParameter("AIRLINE", DBNull.Value);
}
else
{
dbOperator.AddParameter("AIRLINE", value.AirlineCode.Value);
}
dbOperator.AddParameter("MILEAGE", value.Mileage);
dbOperator.AddParameter("ADULT", value.Adult);
dbOperator.AddParameter("CHILD", value.Child);
dbOperator.AddParameter("EFFECTIVEDATE", value.EffectiveDate);
if (value.ExpiredDate.HasValue)
{
dbOperator.AddParameter("EXPIREDDATE", value.ExpiredDate.Value);
}
else
{
dbOperator.AddParameter("EXPIREDDATE", DBNull.Value);
}
return(dbOperator.ExecuteNonQuery(sql));
}
}
public static void AddBAF(BAFView bafView, string account)
{
var baf = BAF.GetBAF(bafView);
BAFCollection.Instance.Add(baf.Id, baf);
saveAddLog("燃油附加税", baf.ToString(), baf.Id.ToString(), account);
}
public int Delete(BAF value)
{
string sql = "DELETE FROM [T_BAF] WHERE [ID]=@ID";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("ID", value.Id);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public static void UpdateBAF(Guid id, BAFView bafView, string account)
{
var baf = BAF.GetBAF(id, bafView);
var originalBAF = QueryBAF(id);
if (null == originalBAF)
{
throw new ChinaPay.Core.CustomException("原燃油附加税不存在");
}
var originalContent = originalBAF.ToString();
BAFCollection.Instance.Update(baf.Id, baf);
saveUpdateLog("燃油附加税", originalContent, baf.ToString(), baf.Id.ToString(), account);
}
public override void CustomerDefinedSettledPod()
{
//double specialDivisor = 11.4;
//double commonDivisor = 11;
//decimal point100 = 100;
//decimal point80 = 80;
//decimal point_from_suzhou = 100;
//decimal point_from_shanghai = 200;
foreach (var gPod in base.SettledPodResponse.GroupedPods)
{
decimal BAFPrice = 0;
double weight = 0;
var innerPodIDS = gPod.PodIDs.Split('|').Select(i => i.ObjectToInt64());
var tempOriginalPods = this.podCollection.Where(p => innerPodIDS.Contains(p.ID));
tempOriginalPods.Each((i, p) =>
{
int tempInt = 0;
double tempCube = 0;
if (string.Equals(p.PODTypeName, "出货运单", StringComparison.OrdinalIgnoreCase))
{
if (p.CustomerOrderNumber.Substring(0, 2) == "SP" || int.TryParse(p.CustomerOrderNumber.Substring(0, 1), out tempInt))
{
tempCube = p.BoxNumber.Value / 11.4;
}
else
{
tempCube = p.BoxNumber.Value / (double)11;
}
}
{
tempCube = p.BoxNumber.Value / (double)11;
}
weight += tempCube;
this.podCollection.First(c => c.ID == p.ID).Str40 = tempCube.ToString();
});
var price = quotedPriceCollection.FirstOrDefault(q => q.ProjectID == 1 && q.Target == 0 && q.TargetID == gPod.TargetID && q.StartCityName.Trim() == gPod.StartCityName.Trim() && q.EndCityName.Trim() == gPod.EndCityName.Trim() &&
q.PodTypeName.Trim() == gPod.PODTypeName.Trim() && q.ShipperTypeName.Trim() == gPod.ShipperTypeName.Trim() && q.TplOrTtlName.Trim() == gPod.TtlOrTplName.Trim() &&
q.StartVal < weight && q.EndVal >= weight && q.EffectiveStartTime <= gPod.ActualDeliveryDate.ObjectToDateTime() && (q.EffectiveEndTime >= gPod.ActualDeliveryDate.ObjectToDateTime() || q.EffectiveEndTime == null));
var BAFPrices = BAF.FirstOrDefault(q => q.ProjectID == 1 && q.BAFStartTime <= gPod.ActualDeliveryDate.ObjectToDateTime() && q.BAFEndTime > gPod.ActualDeliveryDate.ObjectToDateTime());
if (BAFPrices == null)
{
BAFPrice = 0;
}
else
{
BAFPrice = BAFPrices.BAFPrice;
}
if (price == null)
{
this.GenErrorMessage_ByGroupedPod(gPod, "");
continue;
}
//运费
decimal shipAmt = price.Price * (decimal)weight;
this.settledPodCollection.Each((i, settledPod) =>
{
});
}
}
