智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2023-02-27 1db1c64dc628d2053617ba2c3cc78fb94b518d2c 
 WebAPI/Controllers/PublicPageMethodController.cs


@@ -1491,9 +1491,10 @@


            try


            {


                


                    string sql1 = "Select * from Kf_StockOutRequestBillMain where 1 = 1 ";


                    string sql = sql1 + sWhere;


                    ds = oCN.RunProcReturn(sql, "Kf_StockOutRequestBillMain");


                    string sql1 = "Select * from AIS20220914133941..T_STK_OUTSTOCKAPPLY where fdocumentstatus = 'C' and FCloseStatus = 'A'";


                   string sql2 = "order by Fdate asc";


                 string sql = sql1 + sWhere + sql2;


                    ds = oCN.RunProcReturn(sql, "T_STK_OUTSTOCKAPPLY");


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


                {


                    objJsonResult.code = "0";


@@ -2069,7 +2070,7 @@


                }


                else


                {


                    string sql1 = "Select HItemID,HParentID,HNumber,HName from h_v_IF_Unit ";


                    string sql1 = "Select HItemID,HParentID,HNumber,HName from h_v_IF_Unit  ";


                    string sql = sql1 + sWhere;


                    ds = oCN.RunProcReturn(sql, "h_v_IF_Unit");


                }


@@ -2187,22 +2188,12 @@


                    string sql = sql1 + sWhere;


                    ds = oCN.RunProcReturn(sql, "Gy_Property");


                }


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "false！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "Sucess！";


                    objJsonResult.data = ds.Tables[0];


                    return objJsonResult;


                }




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


            catch (Exception e)


            {