| | |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 获取生产资源列表下拉框 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Web/GetSouceList_Select")] |
| | | [HttpGet] |
| | | public object GetSouceList_Select(string HMaterID,Int64 HOrgID) |
| | | { |
| | | sWhere = " and HStopFlag=0 and HUSEORGID =" + HOrgID + ""; |
| | | try |
| | | { |
| | | string sql = "EXEC h_p_Gy_SouceList_PC " + HMaterID + ",'" + sWhere + "'"; |
| | | ds = oCN.RunProcReturn(sql, "h_p_Gy_SouceList_PC"); |
| | | |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | objjson.code = "1"; |
| | | objjson.count = 1; |
| | | objjson.Message = "获取成功!"; |
| | | objjson.data = ds.Tables[0]; |
| | | return objjson; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + ex.ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 获取职员列表 |
| | |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | |
| | | ds = oCN.RunProcReturn("Select * from Xt_BillType where HNumber = '" + HModuleType + "'", "Xt_BillType"); |
| | | ds = oCN.RunProcReturn("Select * from Xt_BillType with(nolock) where HNumber = '" + HModuleType + "'", "Xt_BillType"); |
| | | |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |