| | |
|---|
| | | |
|---|
| | | [Route("Sc_MESTransFerWorkBill/GetSc_MESTransFerWorkBillQuery")] |
|---|
| | | [HttpGet] |
|---|
| | | public object GetSc_MESTransFerWorkBillQuery(string user) |
|---|
| | | public object GetSc_MESTransFerWorkBillQuery(string sWhere, string user) |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | | Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere); |
|---|
| | | |
|---|
| | | |
|---|
| | | string HStatus = dic["HStatus"].ToString();//时间状态 |
|---|
| | | string HBeginDate = dic["HBeginDate"].ToString();//开始日期 |
|---|
| | | string HEndDate = dic["HEndDate"].ToString();//结束日期 |
|---|
| | | string HSourceID = dic["HSourceID"].ToString();//生产资源 |
|---|
| | | |
|---|
| | | List<object> columnNameList = new List<object>(); |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn("exec h_p_OA_ErrMsgBackSelfQuery " + user, "h_p_OA_ErrMsgBackSelfQuery"); |
|---|
| | | ds = oCN.RunProcReturn("exec h_p_OA_ErrMsgBackSelfQuery '" + HStatus + "','" + HBeginDate + "','" + HEndDate + "','" + HSourceID + "','" + user + "'", "h_p_QC_ErrManagerLedgerReport_Source"); |
|---|
| | | |
|---|
| | | if (ds.Tables[0].Rows.Count != 0 || ds != null) |
|---|
| | | { |
|---|
