public List<SOHeaderEntity> GetVhicleHeadersInfoByBillID(int vehicleID, string loadingNo)
{
List<SOHeaderEntity> list = new List<SOHeaderEntity>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("vehicleID=").Append(vehicleID).Append("&");
loStr.Append("vehicleTrainNo=").Append(loadingNo);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_GetVhicleHeadersInfoByBillID);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return list;
}
#endregion
#region 正常错误处理
JsonQueryBills bill = JsonConvert.DeserializeObject<JsonQueryBills>(jsonQuery);
if (bill == null)
{
//MsgBox.Warn(WebWork.JSON_DATA_NULL);
return list;
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return list;
}
#endregion
#region 赋值数据
foreach (JsonQueryBillsResult jbr in bill.result)
{
SOHeaderEntity asnEntity = new SOHeaderEntity();
#region 0-10
asnEntity.Address = jbr.address;
asnEntity.BillID = Convert.ToInt32(jbr.billId);
asnEntity.BillNO = jbr.billNo;
asnEntity.BillType = jbr.billType;
asnEntity.BillTypeName = jbr.billTypeName;
asnEntity.ContractNO = jbr.contractNo;
asnEntity.Consignee = jbr.contact;
asnEntity.CustomerName = jbr.cName;
asnEntity.CustomerCode = jbr.cCode;
asnEntity.DelayMark = Convert.ToInt32(jbr.delayMark);
#endregion
#region 11-20
asnEntity.CancelFlag = Convert.ToInt32(jbr.cancelFlag);
asnEntity.ConfirmFlag = Convert.ToInt32(jbr.confirmFlag);
asnEntity.CrnAmount = Convert.ToDecimal(jbr.crmAmount);
asnEntity.CustomerCode = jbr.cCode;
asnEntity.CustomerName = jbr.cName;
asnEntity.DeliverymanMobile = jbr.mobilePhone;
asnEntity.FromWarehouse = jbr.fromWhCode;
asnEntity.FromWarehouseName = jbr.fromWhName;
asnEntity.OtherAmount = Convert.ToDecimal(jbr.otherAmount);
asnEntity.OutstoreType = jbr.outStoreType;
#endregion
#region 21---30
asnEntity.OutstoreTypeName = jbr.outStoreTypeName;
asnEntity.PayedAmount = Convert.ToDecimal(jbr.payedAmount);
asnEntity.PayMethod = Convert.ToInt32(jbr.payMethod);
asnEntity.PickZnType = jbr.pickZnType;
asnEntity.PickZnTypeName = jbr.pickZnTypeName;
asnEntity.RealAmount = Convert.ToDecimal(jbr.realAmount);
asnEntity.ReceiveAmount = Convert.ToDecimal(jbr.receiveAmount);
asnEntity.Remark = jbr.remark;
asnEntity.RowForeColor = Convert.ToInt32(jbr.rowColor);
asnEntity.SalesMan = jbr.salesMan;
#endregion
#region 31-40
asnEntity.ShipNO = jbr.shipNo;
asnEntity.ShTel = jbr.phone;
asnEntity.Status = jbr.billState;
asnEntity.StatusName = jbr.statusName;
asnEntity.Warehouse = jbr.whCode;
asnEntity.WarehouseName = jbr.whName;
asnEntity.WmsRemark = jbr.wmsRemark;
asnEntity.OriginalBillNo = jbr.originalBillNo;
#endregion
#region
try
{
if (!string.IsNullOrEmpty(jbr.closeDate))
asnEntity.CloseDate = Convert.ToDateTime(jbr.closeDate);
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
#endregion
#region
try
{
if (!string.IsNullOrEmpty(jbr.createDate))
asnEntity.CreateDate = Convert.ToDateTime(jbr.createDate);
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
#endregion
#region
try
{
if (!string.IsNullOrEmpty(jbr.confirmDate))
asnEntity.ConfirmDate = Convert.ToDateTime(jbr.confirmDate);
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
#endregion
list.Add(asnEntity);
}
return list;
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return list;
}
/// <summary>
/// 出库单管理，，自定义查询
/// </summary>
/// <param name="billNO"></param>
/// <param name="customer"></param>
/// <param name="saleMan"></param>
/// <param name="billType"></param>
/// <param name="billStatus"></param>
/// <param name="outboundType"></param>
/// <param name="shipNO"></param>
/// <param name="dateFrom"></param>
/// <param name="dateTo"></param>
/// <returns></returns>
public List <SOHeaderEntity> QueryBills(string billNO, string customer, string saleMan, string billType,
string billStatus, string outboundType, string shipNO, DateTime dateFrom, DateTime dateTo)
{
List <SOHeaderEntity> list = new List <SOHeaderEntity>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("billNO=").Append(billNO).Append("&");
loStr.Append("customer=").Append(customer).Append("&");
loStr.Append("saleMan=").Append(saleMan).Append("&");
loStr.Append("billType=").Append(billType).Append("&");
loStr.Append("billStatus=").Append(billStatus).Append("&");
loStr.Append("outboundType=").Append(outboundType).Append("&");
loStr.Append("shipNO=").Append(shipNO).Append("&");
loStr.Append("dateFrom=").Append(dateFrom).Append("&");
loStr.Append("beginRow=").Append("&");
loStr.Append("rows=").Append("&");
loStr.Append("dateTo=").Append(dateTo);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_selectBillBody, 30000);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonQueryBills bill = JsonConvert.DeserializeObject <JsonQueryBills>(jsonQuery);
if (bill == null)
{
//MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(list);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(list);
}
#endregion
#region 赋值数据
foreach (JsonQueryBillsResult jbr in bill.result)
{
SOHeaderEntity asnEntity = new SOHeaderEntity();
#region 0-10
asnEntity.Address = jbr.address;
asnEntity.BillID = Convert.ToInt32(jbr.billId);
asnEntity.BillNO = jbr.billNo;
asnEntity.BillType = jbr.billType;
asnEntity.BillTypeName = jbr.billTypeName;
asnEntity.ContractNO = jbr.contractNo;
asnEntity.Consignee = jbr.contact;
asnEntity.CustomerName = jbr.cName;
asnEntity.CustomerCode = jbr.cCode;
asnEntity.DelayMark = Convert.ToInt32(jbr.delayMark);
#endregion
#region 11-20
asnEntity.CancelFlag = Convert.ToInt32(jbr.cancelFlag);
asnEntity.ConfirmFlag = Convert.ToInt32(jbr.confirmFlag);
asnEntity.CrnAmount = Convert.ToDecimal(jbr.crmAmount);
asnEntity.CustomerCode = jbr.cCode;
asnEntity.CustomerName = jbr.cName;
asnEntity.DeliverymanMobile = jbr.mobilePhone;
asnEntity.FromWarehouse = jbr.fromWhCode;
asnEntity.FromWarehouseName = jbr.fromWhName;
asnEntity.OtherAmount = Convert.ToDecimal(jbr.otherAmount);
asnEntity.OutstoreType = jbr.outStoreType;
#endregion
#region 21---30
asnEntity.OutstoreTypeName = jbr.outStoreTypeName;
asnEntity.PayedAmount = Convert.ToDecimal(jbr.payedAmount);
asnEntity.PayMethod = Convert.ToInt32(jbr.payMethod);
asnEntity.PickZnType = jbr.pickZnType;
asnEntity.PickZnTypeName = jbr.pickZnTypeName;
asnEntity.RealAmount = Convert.ToDecimal(jbr.realAmount);
asnEntity.ReceiveAmount = Convert.ToDecimal(jbr.receiveAmount);
asnEntity.Remark = jbr.remark;
asnEntity.RowForeColor = Convert.ToInt32(jbr.rowColor);
asnEntity.SalesMan = jbr.salesMan;
#endregion
#region 31-40
asnEntity.ShipNO = jbr.shipNo;
asnEntity.ShTel = jbr.phone;
asnEntity.Status = jbr.billState;
asnEntity.StatusName = jbr.statusName;
asnEntity.Warehouse = jbr.whCode;
asnEntity.WarehouseName = jbr.whName;
asnEntity.WmsRemark = jbr.wmsRemark;
asnEntity.Printed = Convert.ToInt32(jbr.printed);
#endregion
#region
try
{
if (!string.IsNullOrEmpty(jbr.closeDate))
{
asnEntity.CloseDate = Convert.ToDateTime(jbr.closeDate);
}
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("PSoManage+QueryBills", msg);
}
#endregion
#region
try
{
if (!string.IsNullOrEmpty(jbr.createDate))
{
asnEntity.CreateDate = Convert.ToDateTime(jbr.createDate);
}
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("PSoManage+QueryBills", msg);
}
#endregion
#region
try
{
if (!string.IsNullOrEmpty(jbr.confirmDate))
{
asnEntity.ConfirmDate = Convert.ToDateTime(jbr.confirmDate);
}
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("PSoManage+QueryBills", msg);
}
#endregion
list.Add(asnEntity);
}
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
