智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yxj
8 天以前 bdda209f00d8f03ab50acf7e219f71d7f68a375f 
 WebAPI/Controllers/BLL/Xt_UserController.cs


@@ -383,8 +383,6 @@


        }


        #endregion








        #region  根据用户编码查找已分配供应商列表


        [Route("Xt_User/SupperPlaylist")]


        [HttpGet]


@@ -843,6 +841,7 @@


            }


        }


        #endregion




        #region 用户关联组织维护 删除


        /// <summary>


        ///参数：string HInterID。


@@ -877,7 +876,7 @@




                oCN.BeginTran();




                string sql = "delete from Gy_UserORGRelation where HItemID = " + HInterID;


                string sql = "delete from Gy_UserByOrgRelation where HItemID = " + HInterID;


                oCN.RunProc(sql);




                oCN.Commit();


@@ -898,6 +897,7 @@


            }


        }


        #endregion




        #region 用户关联组织维护 编辑初始化


        /// <summary>


        ///参数：string sql。


@@ -940,6 +940,7 @@


            }


        }


        #endregion




        #region 用户关联组织维护 保存


        [Route("Xt_User/UserRelationOrganizationList_Save")]


        [HttpPost]


@@ -991,11 +992,11 @@


                        string HOrgName = item["HOrgName"].ToString();      //组织名称






                        sql = "select * from Gy_UserORGRelation where HUserID = '" + HUserID + "' and HOrgID = " + HOrgID;


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


                        sql = "select * from Gy_UserByOrgRelation where HUserID = '" + HUserID + "' and HOrgID = " + HOrgID;


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


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


                        {


                            sql = "insert into Gy_UserORGRelation(HUserID,HOrgID)" +


                            sql = "insert into Gy_UserByOrgRelation(HUserID,HOrgID)" +


                                "values(" +


                                "'" + HUserID + "'" +


                                "," + HOrgID + "" +


@@ -1034,15 +1035,15 @@


                        string HOrgNumber = item["HOrgNumber"].ToString();  //组织代码


                        string HOrgName = item["HOrgName"].ToString();      //组织名称




                        sql = "select * from Gy_UserORGRelation where HItemID = " + HItemID;


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


                        sql = "select * from Gy_UserByOrgRelation where HItemID = " + HItemID;


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


                        if (ds.Tables[0].Rows.Count > 0)


                        {


                            sql = "select * from Gy_UserORGRelation where HUserID = '" + HUserID + "' and HOrgID = " + HOrgID + " and HItemID <> " + HItemID;


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


                            sql = "select * from Gy_UserByOrgRelation where HUserID = '" + HUserID + "' and HOrgID = " + HOrgID + " and HItemID <> " + HItemID;


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


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


                            {


                                sql = "update Gy_UserORGRelation set " +


                                sql = "update Gy_UserByOrgRelation set " +


                                      "HUserID = '" + HUserID + "' " +


                                      ",HOrgID = " + HOrgID + " " +


                                      "where HItemID = " + HItemID;


@@ -2468,6 +2469,7 @@


            }


        }


        #endregion




        #region 用户关联职员维护 删除


        /// <summary>


        ///参数：string HInterID。


@@ -2523,6 +2525,7 @@


            }


        }


        #endregion




        #region 用户关联职员维护 编辑初始化


        /// <summary>


        ///参数：string sql。


@@ -2565,6 +2568,7 @@


            }


        }


        #endregion




        #region 用户关联职员维护 保存


        [Route("Xt_User/UserRelationEmployeelist_Save")]


        [HttpPost]


@@ -3029,6 +3033,7 @@


            }


        }


        #endregion




        #region  查询指定用户所关联客户中的客户


        [Route("Xt_User/CustomerPlaylistFromUserCustomerList")]


        [HttpGet]


@@ -3082,6 +3087,7 @@


            }


        }


        #endregion




        #region 用户关联客户保存


        [Route("Xt_User/SaveUserCustomer")]


        [HttpPost]


@@ -3138,6 +3144,7 @@


            }


        }


        #endregion






        #region 用户关联客户 文件上传


        [Route("Xt_User/Gy_UserCustomer_ImportByExcel")]


@@ -3299,6 +3306,7 @@


            }


        }


        #endregion




        #region 用户关联客户 导入(数据验证)


        [Route("Xt_User/Gy_UserCustomer_ImportByExcel_Confirm")]


        [HttpPost]


@@ -3479,6 +3487,7 @@


            }


        }


        #endregion




        #region 用户关联客户 导入(保存)


        [Route("Xt_User/Gy_UserCustomer_ImportByExcel_Save")]


        [HttpPost]


@@ -3769,6 +3778,7 @@


            }


        }


        #endregion




        #region 用户关联客户维护 编辑初始化


        /// <summary>


        ///参数：string sql。


@@ -3811,6 +3821,7 @@


            }


        }


        #endregion




        #region 用户关联客户维护 保存


        [Route("Xt_User/UserRelationCustomerlist_Save")]


        [HttpPost]


@@ -3969,6 +3980,7 @@


            }


        }


        #endregion






        #region  根据用户编码查找已分配工序列表


        [Route("Xt_User/ProcessPlaylist")]


@@ -4512,5 +4524,33 @@


            }


        }


        #endregion




        #region 根据用户关联组织 过滤条件


        [Route("Xt_User/getOrgIDListByUser")]


        [HttpGet]


        public object getOrgIDListByUser(string UserID, string UserName,string HOrgID)


        {            


            try


            {


              


                //根据用户ID 查询用户关联组织表


                ds = oCN.RunProcReturn("exec h_p_GetHorgIDByUser_Query '"+ UserID + "','"+ UserName + "','"+ HOrgID + "'", "h_p_GetHorgIDByUser_Query");




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


            catch (Exception e)


            {               


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion


    }


}