| | |
|---|
| | | public static ToMessage WorkShopCompreRightBottom() |
|---|
| | | { |
|---|
| | | var sql = ""; |
|---|
| | | Dictionary<object, object> dir = new Dictionary<object, object>(); |
|---|
| | | try |
|---|
| | | { |
|---|
| | | sql = @"select * from h_v_JLKanBan_WorkShopCompreRightBottom"; |
|---|
| | | var data = DapperHelper.selecttable(sql); |
|---|
| | | dir.Add("Y", data.Rows[0]["BaseQuantity"].ToString()); |
|---|
| | | dir.Add("B", data.Rows[1]["BaseQuantity"].ToString()); |
|---|
| | | dir.Add("C", data.Rows[2]["BaseQuantity"].ToString()); |
|---|
| | | mes.code = "200"; |
|---|
| | | mes.message = "查询成功!"; |
|---|
| | | mes.data = dir; |
|---|
| | | mes.data = data; |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
