采购管理模块的修改

陈雯静

2024-03-21 5e0cbf16956e0d976de65b9e273e15eac8f0fa05

 WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs

@@ -1922,25 +1922,25 @@
                }
                if (IsAudit == 1) //行反关闭提交
                {
                    //oBill.oCn.BeginTran();
                    oBill.oCn.BeginTran();
                    //行反关闭提交
                    if (oBill.CancelRow(lngBillKey, HEntryID, oBill.omodel.HBillNo, CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)
                    {
                        //ds = oCN.RunProcReturn("exec h_p_Kf_CheckSeOrderBill_CrediControl " + oBill.omodel.HInterID, "h_p_Kf_CheckSeOrderBill_CrediControl");
                        //if (ds.Tables[0].Rows[0]["HBack"].ToString() == "1")
                        //{
                        //    objJsonResult.code = "0";
                        //    objJsonResult.count = 0;
                        //    objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString();
                        //    objJsonResult.data = null;
                        //    oBill.oCn.RollBack();
                        //    return objJsonResult;
                        //}
                        ds = oCN.RunProcReturn("exec h_p_Kf_CheckSeOrderBill_CrediControl " + oBill.omodel.HInterID, "h_p_Kf_CheckSeOrderBill_CrediControl");
                        if (ds.Tables[0].Rows[0]["HBack"].ToString() == "1")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString();
                            objJsonResult.data = null;
                            oBill.oCn.RollBack();
                            return objJsonResult;
                        }
                        objJsonResult.code = "1";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "反关闭成功";
                        objJsonResult.data = null;
                        //oBill.oCn.Commit();
                        oBill.oCn.Commit();
                        return objJsonResult;
                    }
                    else
@@ -1949,7 +1949,7 @@
                        objJsonResult.count = 0;
                        objJsonResult.Message = "反关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
                        objJsonResult.data = null;
                        //oBill.oCn.RollBack();
                        oBill.oCn.RollBack();
                        return objJsonResult;
                    }
                }
@@ -2460,5 +2460,48 @@
            }
        }
        #endregion

        #region 销售订单 根据职员获取部门、主管
        [Route("Xs_SeOrderBill/getEmpInfoByHEmpID")]
        [HttpGet]
        public object getEmpInfoByHEmpID(long HEmpID)
        {
            try
            {
                string sql = "select a.HItemID HEmpID,a.HName HEmpName,ISNULL(a.HDeptID,0) HDeptID,b.HName HDeptName,ISNULL(b.HEmpID,0) HManagerID,c.HName HManagerName " +
                    " from Gy_Employee as a " +
                    " left join Gy_Department as b on a.HDeptID = b.HItemID " +
                    " left join Gy_Employee as c on b.HEmpID = c.HItemID " +
                    " where a.HItemID = " + HEmpID;
                ds = oCN.RunProcReturn(sql, "Gy_Employee");


                if (ds == null || 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 = "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
    }
}