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