public DeliveryListNumResponse HandleDeliveryListNumRequest(DeliveryListNumRequest request)
{
SqlCommand com = new SqlCommand
($"select DeliveryId from Delivery where DeliverymanId={request.DelivererId} and DeliveryState={(int)request.State}"
, Connect.Connection);
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds, "DeliveryListNum");
int n = ds.Tables[0].Rows.Count;
ds.Dispose();
return(new DeliveryListNumResponse()
{
Num = n
});
}
public static DeliveryListNumResponse HandleDeliveryListNumRequest(DeliveryListNumRequest request)
{
//TODO:数据库
return(new DeliveryListNumResponse());
}
