DataTable 查询时间

最新推荐文章于 2021-01-17 04:03:48 发布

IT菇凉

最新推荐文章于 2021-01-17 04:03:48 发布

阅读量1.7k

点赞数

分类专栏： ASP.NET

本文链接：https://blog.csdn.net/u013214705/article/details/42804495

版权

ASP.NET 专栏收录该内容

27 篇文章 0 订阅

订阅专栏

DataTable dtOrderTime = OrderLogCollection.Create().ChildrensByTable("ReleationId = " + orderId + " and Status in (2,4)", string.Empty, 0, 0, out erMsg);

if (dtOrderTime == null && dtOrderTime.Rows.Count <= 0)
{
_context.Response.Write(AjaxMethod.BuildReturnMsg(0, SitePublicFunction.BuildReturnMsg(20002))); //无效的订单号

return;
}

DataRow[] fr = dtOrderTime.Select("Status=2");
string payedTime = fr.Length > 0 ? fr[0]["DateTime"].ToString() : "";

fr = dtOrderTime.Select("Status=4");
string sendTime = fr.Length > 0 ? fr[0]["DateTime"].ToString() : "";

string orderTime = "{PayedTime:\"" + payedTime + "\",SendTime:\"" + sendTime + "\"}";