public GetApplicationListResponse HandleGetApplicationListRequest(GetApplicationListRequest request)
{
// 指定SQL语句
SqlCommand com = new SqlCommand(
$"select Tranc.TransactionId, Materials.MaterialName, Tranc.MaterialQuantity, Tranc.TransactionState, Tranc.StartTime " +
$"from Tranc left join Materials " +
$"on Tranc.MaterialId=Materials.MaterialID " +
$"where Tranc.UserId={UserId} and Tranc.TransactionType={(int)TransactionType.APPLICATION}"
, Connect.Connection);
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds, "Tranc");
List <GetApplicationListResponse.Item> items = new List <GetApplicationListResponse.Item>();
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
items.Add(new GetApplicationListResponse.Item()
{
ID = (int)ds.Tables[0].Rows[j]["TransactionId"],
Name = ds.Tables[0].Rows[j]["MaterialName"].ToString(),
Quantity = (int)ds.Tables[0].Rows[j]["MaterialQuantity"],
State = (ApplicationState)ds.Tables[0].Rows[j]["TransactionState"],
StartTime = (DateTime)ds.Tables[0].Rows[j]["StartTime"]
});
}
return(new GetApplicationListResponse()
{
Items = items
});
}
public static GetApplicationListResponse HandleGetApplicationListRequest(GetApplicationListRequest request)
{
//TODO: 数据库
return(new GetApplicationListResponse());
}
