智云SRM-WEBAPI（目前客户通用API）
parent: a2dde21e | 补丁 | 提交 | ignore whitespace
王 垚
2022-10-31 df377dc2934889af29440735123e713a9c569a4b 
get 改 post
6个文件已修改
131 ■■■■■ 已修改文件
WebAPI/Controllers/BarCodeController.cs 24 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/EntrustOrderController.cs 22 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/PODemandPlanController.cs 20 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/POInStockBackController.cs 23 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/POInStockController.cs 18 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/POOrderController.cs 24 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 WebAPI/Controllers/BarCodeController.cs


@@ -605,7 +605,7 @@


                            }


                            //TM = "B" + TM;


                            TM = "SRM" + "B" + TM;


                          




                            if (HSumQty - HMinQty > 0)


                            {


                                WeiShu = "";


@@ -1335,29 +1335,19 @@


        /// <param name="OnePage"></param>


        /// <returns></returns>


        [Route("GetBarCodeShowList")]


        [HttpGet]


        public object GetBarCodeShowList(string HSupNo, string sqlWhere)


        [HttpPost]


        public object GetBarCodeShowList([FromBody] JObject msg)


        {


            string msg = "";


            string HSupNo = msg["HSupNo"].ToString(); string sqlWhere = msg["sqlWhere"].ToString();


            try


            {


                string VsWhere = "";


                string PcWhere = "";


                SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();


                DataSet ds;


                //其他过滤


                if (msg.Trim() == "")


                {


                    msg = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户=''" + HSupNo.Trim() + "'') " + sqlWhere;


                    // msg = " Where   hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)";


                }


                else


                {


                    msg = msg + " and   hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户=''" + HSupNo.Trim() + "'') " + sqlWhere;


                    // msg = msg + " Where   hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)";


                }


                //转换特殊字符


                if (Common.SQLtoChange(msg, ref VsWhere, ref PcWhere) == false)


                string sql = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户=''" + HSupNo.Trim() + "'') " + sqlWhere;




                if (Common.SQLtoChange(sql, ref VsWhere, ref PcWhere) == false)


                {


                    objjson.code = "0";


                    objjson.count = 0;




 WebAPI/Controllers/EntrustOrderController.cs


@@ -28,30 +28,18 @@


        /// <param name="OnePage"></param>


        /// <returns></returns>


        [Route("GetEntrustOrderBill")]


        [HttpGet]


        //采购订单列表


        public object GetEntrustOrderBill(string HSupNo, string sqlWhere)


        [HttpPost]


        public object GetEntrustOrderBill([FromBody] JObject msg)


        {


            string msg = "";


            string HSupNo = msg["HSupNo"].ToString(); string sqlWhere = msg["sqlWhere"].ToString();


            try


            {


                string VsWhere = "";


                string PcWhere = "";


                SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();


                DataSet ds;


                //其他过滤


                if (msg.Trim() == "")


                {


                    msg = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户=^^" + HSupNo.Trim() + "^^) " + sqlWhere;


                    // msg = " Where   hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)";


                }


                else


                {


                    msg = msg + " and   hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户=^^" + HSupNo.Trim() + "^^) " + sqlWhere;


                    // msg = msg + " Where   hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)";


                }


                //转换特殊字符


                if (Common.SQLtoChange(msg, ref VsWhere, ref PcWhere) == false)


                string sql = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户=^^" + HSupNo.Trim() + "^^) " + sqlWhere;


                if (Common.SQLtoChange(sql, ref VsWhere, ref PcWhere) == false)


                {


                    objjson.code = "0";


                    objjson.count = 0;




 WebAPI/Controllers/PODemandPlanController.cs


@@ -27,11 +27,11 @@


        /// <param name="OnePage"></param>


        /// <returns></returns>


        [Route("GetPODemandPlanBill")]


        [HttpGet]


        [HttpPost]


        //采购订单列表


        public object GetPODemandPlanBill(string HSupNo, string sqlWhere)


        public object GetPODemandPlanBill([FromBody] JObject msg)


        {


            string msg = "";


            string HSupNo = msg["HSupNo"].ToString(); string sqlWhere = msg["sqlWhere"].ToString();


            try


            {


                string VsWhere = "";


@@ -39,18 +39,10 @@


                SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();


                DataSet ds;


                //其他过滤


                if (msg.Trim() == "")


                {


                    msg = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户=^^" + HSupNo.Trim() + "^^) " + sqlWhere;


                    // msg = " Where   hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)";


                }


                else


                {


                    msg = msg + " and   hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户=^^" + HSupNo.Trim() + "^^) " + sqlWhere;


                    // msg = msg + " Where   hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)";


                }


               string sql = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户=^^" + HSupNo.Trim() + "^^) " + sqlWhere;


               


                //转换特殊字符


                if (Common.SQLtoChange(msg, ref VsWhere, ref PcWhere) == false)


                if (Common.SQLtoChange(sql, ref VsWhere, ref PcWhere) == false)


                {


                    objjson.code = "0";


                    objjson.count = 0;




 WebAPI/Controllers/POInStockBackController.cs


@@ -27,33 +27,20 @@


        /// <param name="OnePage"></param>


        /// <returns></returns>


        [Route("GetPOInStockBackBillList")]


        [HttpGet]


        public object GetPOInStockBackBillList(string HSupNo, string sqlWhere)


        [HttpPost]


        public object GetPOInStockBackBillList([FromBody] JObject msg)


        {


            string msg = "";


            string HSupNo = msg["HSupNo"].ToString(); string sqlWhere = msg["sqlWhere"].ToString();


            try


            {


                if (msg == null)


                {


                    msg = "";


                }


                string VsWhere = "";


                string PcWhere = "";


                SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();


                DataSet ds;


                //其他过滤


                if (msg.Trim() == "")


                {


                    msg = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户=''" + HSupNo.Trim() + "'') " + sqlWhere;


                    // msg = " Where   hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)";


                }


                else


                {


                    msg = msg + " and   hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户=''" + HSupNo.Trim() + "'') " + sqlWhere;


                    // msg = msg + " Where   hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)";


                }


                string sql = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户=''" + HSupNo.Trim() + "'') " + sqlWhere;


                //转换特殊字符


                if (Common.SQLtoChange(msg, ref VsWhere, ref PcWhere) == false)


                if (Common.SQLtoChange(sql, ref VsWhere, ref PcWhere) == false)


                {


                    return "";


                }




 WebAPI/Controllers/POInStockController.cs


@@ -433,11 +433,11 @@


        /// <param name="OnePage"></param>


        /// <returns></returns>


        [Route("GetPOInStockBill")]


        [HttpGet]


        [HttpPost]


        //送货单列表


        public object GetPOInStockBill(string HSupNo, string sqlWhere)


        public object GetPOInStockBill([FromBody] JObject msg)


        {


            string msg = "";


            string HSupNo = msg["HSupNo"].ToString(); string sqlWhere = msg["sqlWhere"].ToString();


            try


            {


                string VsWhere = "";


@@ -445,16 +445,10 @@


                SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();


                DataSet ds;


                //其他过滤


                if (msg.Trim() == "")


                {


                    msg = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户 =^^" + HSupNo.Trim() + "^^) " + sqlWhere;


                }


                else


                {


                    msg = msg + " and   hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户 =^^" + HSupNo.Trim() + "^^) " + sqlWhere;


                }


                string sql = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户 =^^" + HSupNo.Trim() + "^^) " + sqlWhere;




                //转换特殊字符


                if (Common.SQLtoChange(msg, ref VsWhere, ref PcWhere) == false)


                if (Common.SQLtoChange(sql, ref VsWhere, ref PcWhere) == false)


                {


                    objjson.code = "0";


                    objjson.count = 0;




 WebAPI/Controllers/POOrderController.cs


@@ -28,31 +28,21 @@


        /// <param name="OnePage"></param>


        /// <returns></returns>


        [Route("GetPOOrderBill")]


        [HttpGet]


        [HttpPost]


        //采购订单列表


        public object GetPOOrderBill(string HSupNo, string sqlWhere)


        public object GetPOOrderBill([FromBody] JObject msg)


        {


            string msg = "";


            string HSupNo = msg["HSupNo"].ToString(); string sqlWhere = msg["sqlWhere"].ToString();


            //string msg = "";


            try


            {


                string VsWhere = "";


                string PcWhere = "";


                SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();


                DataSet ds;


                //其他过滤


                if (msg.Trim() == "")


                {


                    msg = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户 = ^^" + HSupNo.Trim() + "^^) " + sqlWhere;


                    // msg = " Where   hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)";


                }


                else


                {


                    msg += " and hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户 =^^" + HSupNo.Trim() + "^^) " + sqlWhere;


                    //msg = msg + " and   hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户=^^" + HSupNo.Trim() + "^^) " + sqlWhere;


                    // msg = msg + " Where   hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)";


                }


                string sql = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 用户 = ^^" + HSupNo.Trim() + "^^) " + sqlWhere;


                //转换特殊字符


                if (Common.SQLtoChange(msg, ref VsWhere, ref PcWhere) == false)


                if (Common.SQLtoChange(sql, ref VsWhere, ref PcWhere) == false)


                {


                    objjson.code = "0";


                    objjson.count = 0;


@@ -63,7 +53,7 @@


                //获取总行数


                //Int64 RowTotal = Common.GetRowTotal("H_v_SRM_POOrderBillList", VsWhere, ref DBUtility.ClsPub.sExeReturnInfo);


                //获取返回数据


                string sql = "exec H_p_SRM_POOrderBillList '" + PcWhere + "'";


                sql = "exec H_p_SRM_POOrderBillList '" + PcWhere + "'";


                //LogService.WriteAsync(sql);




                ds = oCn.RunProcReturn("exec H_p_SRM_POOrderBillList '" + PcWhere + "'", "H_p_SRM_POOrderBillList");