智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yusijie
2023-11-15 c022f537f5b80dbe5294c0ea40e2d7933d4f4ce4 
 WebAPI/Controllers/WebAPIController.cs


@@ -4209,6 +4209,12 @@


                    case "WX":


                        HView = "h_v_Sb_EquipRepairCheckBillList";


                        break;


                    case "GZ":


                        HView = "h_v_Sb_EquipConkBookBillList";


                        break;


                    case "YS":


                        HView = "h_v_Sb_EquipRepairCheckBillList";


                        break;


                    default:


                        objjson.code = "0";


                        objjson.count = 0;


@@ -4218,7 +4224,7 @@


                }




                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                string sql = string.Format(@"select * from " + HView + " where 1 = 1 ");


                string sql = string.Format(@"select * from " + HView + " where 1 = 1 " + sWhere);


                ds = oCN.RunProcReturn(sql, HView);


                //添加列名


                foreach (DataColumn col in ds.Tables[0].Columns)


@@ -4229,9 +4235,9 @@


                }


                if (ds == null || ds.Tables[0].Rows.Count <= 0)


                {


                    objjson.code = "0";


                    objjson.count = 0;


                    objjson.Message = "获取失败,查无数据" + DBUtility.ClsPub.sErrInfo;


                    objjson.code = "1";


                    objjson.count = 1;


                    objjson.Message = "获取失败,查无数据";


                    objjson.data = null;


                    objjson.list = columnNameList;


                    return objjson;