public void UpdateTransportComment(int id, String comment, String userID)
{
using (SQLDBDataContext context = new SQLDBDataContext())
{
TransportRecords record = context.TransportRecords.FirstOrDefault(x => x.ID == id);
if (record == null)
{
throw new ApplicationException("要修改的记录不存在");
}
record.Comment = comment;
record.TransportRecordsOptionHistory.Add(
new TransportRecordsOptionHistory()
{
Description = string.Format("修改备注信息为: {0} ", comment),
LogDateTime = DateTime.Now,
Operation = "更新",
UserID = userID
});
context.SubmitChanges();
}
}
public void UpdateTransportErrorStatus(int id, bool error, string errorMessage, string userID)
{
using (SQLDBDataContext context = new SQLDBDataContext())
{
TransportRecords record = context.TransportRecords.FirstOrDefault(x => x.ID == id);
if (record == null)
{
throw new ApplicationException("要修改的记录不存在");
}
record.Error = error;
record.ErrorMessage = errorMessage;
record.TransportRecordsOptionHistory.Add(
new TransportRecordsOptionHistory()
{
Description = string.Format("修改异常状态为{0}, 异常信息：{1}", error?"异常":"正常", errorMessage),
LogDateTime = DateTime.Now,
Operation = "修改异常状态",
UserID = userID
});
context.SubmitChanges();
}
}
public void UpdateTransportModel(int id, string trayNo, double volume, int quantity, bool updateClientIndex, string userID)
{
using (SQLDBDataContext context = new SQLDBDataContext())
{
TransportRecords record = context.TransportRecords.FirstOrDefault(x => x.ID == id);
if (record == null)
{
throw new ApplicationException("要修改的记录不存在");
}
record.TrayNo = trayNo;
record.Volume = volume;
record.Quantity = quantity;
record.TransportRecordsOptionHistory.Add(
new TransportRecordsOptionHistory()
{
Description = string.Format("更新单据内容，新内容 托编号:{0} 体积： {1} 数量：{2} ", trayNo, volume, quantity),
LogDateTime = DateTime.Now,
Operation = "更新",
UserID = userID
});
if (updateClientIndex)
{
if (!string.IsNullOrEmpty(trayNo))
{
Client client = context.Client.FirstOrDefault(x => x.ClientName == record.ClientName);
if (client != null)
{
client.Index = GetTrayNoIndex(trayNo);
if (client.IndexMonth != DateTime.Now.Month)
{
client.Index = 0;
client.IndexMonth = DateTime.Now.Month;
}
}
}
}
context.SubmitChanges();
}
}
public void UpdateTransportPrice(int id, double?deliverPrice, double?shortBargeFee, double?accoundPayable, string userID)
{
using (SQLDBDataContext context = new SQLDBDataContext())
{
TransportRecords record = context.TransportRecords.FirstOrDefault(x => x.ID == id);
if (record == null)
{
throw new ApplicationException("要修改的记录不存在");
}
record.DeliverPrice = deliverPrice;
record.ShortBargeFee = shortBargeFee;
record.AccountPayble = accoundPayable;
record.TransportRecordsOptionHistory.Add(
new TransportRecordsOptionHistory()
{
Description = string.Format("修改价格信息， 运费：{0}，短驳费：{1}，应付金额:{2}", deliverPrice, shortBargeFee, accoundPayable),
LogDateTime = DateTime.Now,
Operation = "修改价格信息",
UserID = userID
});
context.SubmitChanges();
}
}
