/// <summary> /// 更新报文状态(联邦--更新数据表) /// </summary> /// <param name="resultStatus"></param> /// <returns></returns> public string updateUploadStatus2(model.orderCustomsResult resultStatus) { string s = string.Empty; model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext(); var p = (from c in context.orderCustomsResult where c.SJOrgOrderChildId == resultStatus.SJOrgOrderChildId select c).SingleOrDefault(); if (p == null) { return("更新联邦失败,无订单(" + resultStatus.SJOrgOrderChildId + ")信息记录"); } //BBCReturnData,BBCask,BBCmessage,BBCorderCode,BBCerrorMessage,BBCstatus p.BBCReturnData = resultStatus.BBCReturnData; p.BBCask = resultStatus.BBCask; p.BBCmessage = resultStatus.BBCmessage; p.BBCorderCode = resultStatus.BBCorderCode; p.BBCerrorMessage = resultStatus.BBCerrorMessage; p.BBCstatus = resultStatus.BBCstatus; try { context.SubmitChanges(); s = "更新联邦成功"; } catch { s = "更新联邦失败"; } return(s); }
/// <summary> /// 上传报文状态(插入数据表) /// </summary> /// <param name="resultStatus"></param> /// <returns></returns> public string addUploadStatus(model.orderCustomsResult resultStatus) { string s = string.Empty; model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext(); try { context.orderCustomsResult.InsertOnSubmit(resultStatus); context.SubmitChanges(); s = "添加成功"; } catch { s = "添加失败"; } return(s); }
/// <summary> /// 更新报文状态(商检--更新数据表) /// </summary> /// <param name="resultStatus"></param> /// <returns></returns> public string updateUploadStatus(model.orderCustomsResult resultStatus) { string s = string.Empty; model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext(); var p = (from c in context.orderCustomsResult where c.SJOrgOrderChildId == resultStatus.SJOrgOrderChildId select c).SingleOrDefault(); //SJOrgReturnTime,SJOrgStatus,SJOrgNotes,SJstatus p.SJOrgReturnTime = resultStatus.SJOrgReturnTime; p.SJOrgStatus = resultStatus.SJOrgStatus; p.SJOrgNotes = resultStatus.SJOrgNotes; p.SJstatus = resultStatus.SJstatus; try { context.SubmitChanges(); s = "更新商检成功"; } catch { s = "更新商检失败"; } return(s); }
/// <summary> /// 更新报文状态(海关--更新数据表) /// </summary> /// <param name="resultStatus"></param> /// <returns></returns> public string updateUploadStatus1(model.orderCustomsResult resultStatus) { string s = string.Empty; model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext(); var p = (from c in context.orderCustomsResult where c.SJOrgOrderChildId == resultStatus.SJOrgOrderChildId select c).SingleOrDefault(); //HGReturnDate,HGReturnCode,HGReturnInfo,HGAttachedFlag,HGstatus p.HGReturnDate = resultStatus.HGReturnDate; p.HGReturnCode = resultStatus.HGReturnCode; p.HGReturnInfo = resultStatus.HGReturnInfo; p.HGAttachedFlag = resultStatus.HGAttachedFlag; p.HGstatus = resultStatus.HGstatus; try { context.SubmitChanges(); s = "更新海关成功"; } catch { s = "更新海关失败"; } return(s); }
/// <summary> /// 上传报文状态(插入数据表) /// </summary> /// <param name="resultStatus"></param> /// <returns></returns> public string addUploadStatus(model.orderCustomsResult resultStatus) { return(dal.addUploadStatus(resultStatus)); }
/// <summary> /// 更新报文状态(联邦--更新数据表) /// </summary> /// <param name="resultStatus"></param> /// <returns></returns> public string updateUploadStatus2(model.orderCustomsResult resultStatus) { return(dal.updateUploadStatus2(resultStatus)); }