public bool UpdatePickUpLog(PickUpLog obj)
{
LoggingData data = new LoggingData(ip, username, password, database);
bool result = data.UpdatePickUpLog(obj.Id, obj.Sn, obj.CourierCode, obj.ReceiverTelNum, obj.BoxCode, obj.DeletedTime, obj.ReceiverIdentity, Convert.ToByte(obj.ServerSaved), obj.Remark);
return(result);
}
public List <PickUpLog> GetPickUpLogNoUpload()
{
DataTable table = null;
LoggingData data = new LoggingData(ip, username, password, database);
table = data.GetPickUpLogNoUpload();
if (table == null)
{
CLog4net.LogError("取件日志表初始化错误");
return(null);
}
List <PickUpLog> a = new List <PickUpLog>();
foreach (System.Data.DataRow d in table.Rows)
{
PickUpLog pl = new PickUpLog();
pl.Sn = Convert.ToString(d[TbPickuplog.packageCode]);
pl.CourierCode = Convert.ToString(d[TbPickuplog.courierCode]);
pl.ReceiverTelNum = Convert.ToString(d[TbPickuplog.receiverTelNum]);
pl.BoxCode = Convert.ToInt32(d[TbPickuplog.boxCode]);
pl.DeletedTime = Convert.ToDateTime(d[TbPickuplog.deletedTime]);
pl.ReceiverIdentity = Convert.ToByte(d[TbPickuplog.receiverIdentity]);
pl.ServerSaved = Convert.ToBoolean(d[TbPickuplog.serverSaved]);
pl.Remark = Convert.ToString(d[TbPickuplog.remark]);
a.Add(pl);
}
return(a);
}
/// <summary>
/// 包裹被取出后操作
/// </summary>
/// <param name="p"></param>
void packageManager_PackageTakedEvent(Package p)
{
bool updateBox = false;
bool deletePackage = false;
bool savePickUpLog = false;
//本条语句在xp上测试有时有问题
//this.databaseService.UpdatePackage(p);
//updateBox = this.databaseService.UpdateBox(p.Place);
PickUpLog pLog = new PickUpLog();
pLog.BoxCode = p.Place.Code;
pLog.CourierCode = p.Courier.Code;
pLog.DeletedTime = p.DeletedTime;
pLog.ReceiverTelNum = p.ReceiverTelNum;
pLog.Remark = p.RemarkInfo;
pLog.Sn = p.SN;
pLog.ReceiverIdentity = p.ReceiverIdentity;
deletePackage = this.databaseService.DeletePackage(p);
savePickUpLog = this.databaseService.SavePickUpLog(pLog);
CLog4net.LogInfo("包裹取出数据库更新：updateBox " + updateBox + " deletePackage " + deletePackage + " savePickUpLog " + savePickUpLog);
}
