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