扫码记录缓存报表

zzr99

2022-07-08 17378c3946c1aac0dbe3b6cd05911421a17d3b34

扫码记录缓存报表

 Pub_Class/CustomerCls/ClsPub.cs

@@ -709,8 +709,6 @@
            }
        }



        //得到最大HINTERID å­˜å‚¨è¿‡ç¨‹
        public static Int64 CreateBillID_Prod(string BillCode, ref string sReturn)
        {

 WebAPI/Controllers/WebAPIController.cs

@@ -80,6 +80,67 @@
            }
        }

        [Route("Web/GetMAXNumPDA")]
        [HttpGet]
        public object GetMAXNumPDA(string HBillType)
        {
            try
            {
                string HBillNo = "";
                string sErrMsg = "";
                Int64 HInterID = 0;//显示的字段
                HInterID = DBUtility.ClsPub.CreateBillID_Prod(HBillType, ref sErrMsg);
                HBillNo = DBUtility.ClsPub.CreateBillCode_Prod(HBillType, ref sErrMsg, true);

                DataSet ds;
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                ds = oCN.RunProcReturn("exec h_p_IF_CheckBillIDExists_WMS  " + HInterID + ",'" + HBillNo + "'", "h_p_IF_CheckBillIDExists_WMS");
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    sErrMsg = "存在重复单据内码或单据号的单据，不允许新增，请退出后重新登录！";
                    objjson.code = "0";
                    objjson.count = 0;
                    objjson.Message = sErrMsg;
                    objjson.data = null;
                    return objjson;
                }
                else if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0][0]) == "1")
                {
                    sErrMsg = "存在重复单据内码或单据号的单据，不允许新增，请退出后重新登录！";
                    objjson.code = "0";
                    objjson.count = 0;
                    objjson.Message = sErrMsg;
                    objjson.data = null;
                    return objjson;
                }
                else
                {
                    //----------创建虚表------------------------
                    DataTable dt_Main = new DataTable("Json");
                    dt_Main.Columns.Add("HBillNo", typeof(string));
                    dt_Main.Columns.Add("HInterID", typeof(int));
                    //---------创建新行------------------------
                    DataRow dr_main = dt_Main.NewRow();//创建新行 
                    dt_Main.Rows.Add(dr_main);//将新行加入到表中
                    dr_main["HBillNo"] = DBUtility.ClsPub.isStrNull(HBillNo);
                    dr_main["HInterID"] = DBUtility.ClsPub.isLong(HInterID);
                    //返回数据
                    objjson.code = "0";
                    objjson.count = 1;
                    objjson.Message = "获取成功";
                    objjson.data = dt_Main;
                    return objjson;
                }
            }
            catch (Exception e)
            {
                objjson.code = "0";
                objjson.count = 0;
                objjson.Message = "获取失败" + e.ToString();
                objjson.data = null;
                return objjson;
            }
        }


        //[Route("Web/Get_MaxBillNoAndID")]
@@ -3452,17 +3513,17 @@
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有返回任何记录！";
                    objJsonResult.data = ds.Tables[0];
                    objJsonResult.list = columnNameList;
                    objJsonResult.data = 0;
                    return objJsonResult;
                    //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "获取信息成功！";
                    objJsonResult.data = ds.Tables[0];
                    objJsonResult.list = columnNameList;
                    return objJsonResult;
                }
            }

 WebAPI/Controllers/²Ö´æ¹ÜÀí/ÌõÂë³öÈë¿â¼Ç¼/Kf_ICStockInOutBillController.cs

@@ -202,5 +202,52 @@
        #endregion
        #endregion

        #region æ‰«ç è®°å½•ç¼“存列表
         [Route("Kf_ICStockInOutBill/GetKF_PonderationBillMain_Temp")]
        [HttpGet]
        public object GetKF_PonderationBillMain_Temp(string sWhere)
        {
            try
            {
                DataSet ds = new DataSet();
                string sql1 = string.Format(@"select * from h_v_KF_PonderationBillList_Query where 1=1 ");
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn(sql1 + "order by åˆ¶å•æ—¥æœŸ desc", "h_v_KF_PonderationBillList_Query");
                }
                else
                {
                    ds = oCN.RunProcReturn(sql1 + sWhere + "order by åˆ¶å•æ—¥æœŸ desc", "h_v_KF_PonderationBillList_Query");
                }
                if (ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "查询数据异常，请与管理员联系！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "返回记录成功！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }

            }
            catch (Exception e)
            {

                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = e.Message.ToString();
                objJsonResult.data = null;
            }
            return objJsonResult;
        }
        #endregion

    }
}

 WebAPI/Sc_MouldProdInBill/Log/637929035024768802.log

New file
@@ -0,0 +1,3 @@
------------------------2022/7/8 18:58:22------------------------------
成功！


 WebAPI/Sc_MouldProdInBill/Log/637929035026089000.log

New file
@@ -0,0 +1,3 @@
------------------------2022/7/8 18:58:22------------------------------
有权限


 WebAPI/Sc_MouldProdInBill/Log/637929035026128911.log

New file
@@ -0,0 +1,3 @@
------------------------2022/7/8 18:58:22------------------------------
select * from h_v_Sc_MouldProdInHouseBillList where åº“存组织='蓝海实业集团' and CONVERT(varchar(100),日期, 23) >= '2022-06-08' and CONVERT(varchar(100),日期, 23) <= '2022-07-08'order by hmainid desc


 WebAPI/Sc_MouldProdInBill/Log/637929058526173134.log

New file
@@ -0,0 +1,3 @@
------------------------2022/7/8 19:37:32------------------------------
成功！


 WebAPI/Sc_MouldProdInBill/Log/637929058526583161.log

New file
@@ -0,0 +1,3 @@
------------------------2022/7/8 19:37:32------------------------------
有权限


 WebAPI/Sc_MouldProdInBill/Log/637929058526613165.log

New file
@@ -0,0 +1,3 @@
------------------------2022/7/8 19:37:32------------------------------
select * from h_v_Sc_MouldProdInHouseBillList where åº“存组织='手机事业部' and CONVERT(varchar(100),日期, 23) >= '2022-06-08' and CONVERT(varchar(100),日期, 23) <= '2022-07-08'order by hmainid desc


 WebAPI/Sc_MouldProdOutBill/Log/637929058581481456.log

New file
@@ -0,0 +1,3 @@
------------------------2022/7/8 19:37:38------------------------------
select * from h_v_Sc_MouldProdOutHouseBillList where åº“存组织='手机事业部'


 WebAPI/Vlog/webapi20220708.txt

New file
@@ -0,0 +1,3 @@
2022/7/8 18:58:22  and CONVERT(varchar(100),日期, 23) >= '2022-06-08' and CONVERT(varchar(100),日期, 23) <= '2022-07-08';蓝海实业集团

2022/7/8 19:37:32  and CONVERT(varchar(100),日期, 23) >= '2022-06-08' and CONVERT(varchar(100),日期, 23) <= '2022-07-08';手机事业部