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