private void SaveExpressData()
{
string str = this.context.Request["param"];
if (string.IsNullOrEmpty(str))
{
this.context.Response.Write("{\"result\":\"false\",\"returnCode\":\"500\",\"message\":\"服务器错误\"}");
}
else
{
try
{
JObject obj2 = JObject.Parse(str);
ExpressDataInfo model = new ExpressDataInfo {
ExpressNumber = obj2["lastResult"]["nu"].ToString(),
CompanyCode = obj2["lastResult"]["com"].ToString(),
DataContent = str
};
if (new ExpressDataHelper().AddExpressData(model))
{
this.context.Response.Write("{\"result\":\"true\",\"returnCode\":\"200\",\"message\":\"成功\"}");
}
else
{
this.context.Response.Write("{\"result\":\"false\",\"returnCode\":\"500\",\"message\":\"服务器错误\"}");
}
}
catch (Exception)
{
this.context.Response.Write("{\"result\":\"false\",\"returnCode\":\"500\",\"message\":\"服务器错误\"}");
}
}
}
private void SaveExpressData()
{
string text = this.context.Request["param"];
if (string.IsNullOrEmpty(text))
{
this.context.Response.Write("{\"result\":\"false\",\"returnCode\":\"500\",\"message\":\"服务器错误\"}");
return;
}
try
{
JObject jObject = JObject.Parse(text);
ExpressDataInfo expressDataInfo = new ExpressDataInfo();
expressDataInfo.ExpressNumber = jObject["lastResult"]["nu"].ToString();
expressDataInfo.CompanyCode = jObject["lastResult"]["com"].ToString();
expressDataInfo.DataContent = text;
if (new ExpressDataHelper().AddExpressData(expressDataInfo))
{
this.context.Response.Write("{\"result\":\"true\",\"returnCode\":\"200\",\"message\":\"成功\"}");
}
else
{
this.context.Response.Write("{\"result\":\"false\",\"returnCode\":\"500\",\"message\":\"服务器错误\"}");
}
}
catch (System.Exception)
{
this.context.Response.Write("{\"result\":\"false\",\"returnCode\":\"500\",\"message\":\"服务器错误\"}");
}
}
public bool AddExpressData(ExpressDataInfo edata)
{
DbCommand sqlStringCommand = base.database.GetSqlStringCommand("IF NOT EXISTS (SELECT * FROM Hishop_OrderExpressData WHERE CompanyCode=@CompanyCode AND ExpressNumber=@ExpressNumber) INSERT INTO Hishop_OrderExpressData (CompanyCode,ExpressNumber, DataContent) VALUES(@CompanyCode,@ExpressNumber, @DataContent) ELSE UPDATE Hishop_OrderExpressData SET DataContent=@DataContent WHERE CompanyCode=@CompanyCode AND ExpressNumber=@ExpressNumber");
base.database.AddInParameter(sqlStringCommand, "CompanyCode", DbType.String, edata.CompanyCode);
base.database.AddInParameter(sqlStringCommand, "ExpressNumber", DbType.String, edata.ExpressNumber);
base.database.AddInParameter(sqlStringCommand, "DataContent", DbType.String, edata.DataContent);
return(base.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public bool AddExpressData(ExpressDataInfo model)
{
string query;
if (!string.IsNullOrEmpty(this.GetExpressDataList(model.CompanyCode, model.ExpressNumber)))
{
query = "update Hishop_OrderExpressData set DataContent=@DataContent where CompanyCode=@CompanyCode and ExpressNumber=@ExpressNumber";
}
else
{
query = "insert into Hishop_OrderExpressData(CompanyCode,ExpressNumber,DataContent) values(@CompanyCode,@ExpressNumber,@DataContent)";
}
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);
this.database.AddInParameter(sqlStringCommand, "CompanyCode", System.Data.DbType.String, model.CompanyCode);
this.database.AddInParameter(sqlStringCommand, "ExpressNumber", System.Data.DbType.String, model.ExpressNumber);
this.database.AddInParameter(sqlStringCommand, "DataContent", System.Data.DbType.String, model.DataContent);
return(this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public bool AddExpressData(ExpressDataInfo model)
{
return(new ExpressDataDao().AddExpressData(model));
}
