智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
1
wtt
2024-05-17 cb98f3abf09cb75bf1328c42745f3be8cd9d9374 
 WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs


@@ -8,6 +8,7 @@


using System.Data.SqlClient;


using System.Web.Http;


using WebAPI.Models;


using System.Windows.Forms;




namespace WebAPI.Controllers


{


@@ -276,7 +277,6 @@


            string user = sArray[2].ToString();


            string OperationType = sArray[3].ToString();




            string UserName = "";


            ListModels oListModels = new ListModels();


            try


            {


@@ -296,19 +296,9 @@


                lsmain = oListModels.getSellOutBillMainByJson(msg2);


                foreach (Model.ClsKf_SellOutBillMain oItem in lsmain)


                {


                    //oItem.HMaker = "";


                    UserName = oItem.HMaker;


                    oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));


                    oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);


                    oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));


                    oItem.HBillType = "1205";


                    oItem.HBillSubType = "1205";


                    oItem.HBillStatus = 0;


                    oItem.HPeriod = 0;


                    oItem.HMaker = user;


                    oItem.HMainSourceInterID = oItem.HInterID;


                    oItem.HUpDater = user;




                    //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);


                    if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")


                    {


                        objJsonResult.code = "0";


@@ -324,50 +314,84 @@


                msg3 = msg3.Substring(1, msg3.Length - 2);


                msg3 = msg3.Replace("\\", "");


                msg3 = msg3.Replace("\n", "");  //\n


                //msg2 = msg2.Replace("'", "’");


                List<Model.ClsKf_SellOutBillSub> ls = new List<Model.ClsKf_SellOutBillSub>();


                ls = oListModels.getSellOutBillSubByJson(msg3);


                int i = 0;


                foreach (Model.ClsKf_SellOutBillSub oItemSub in ls)


                {


                    i++;




                    oItemSub.HEntryID = i;


                    //oItemSub.HSourceEntryID = 0;


                    //oItemSub.HSourceInterID = 0;


                    //oItemSub.HSourceBillNo = "";


                    //oItemSub.HSourceBillType = "";


                    oItemSub.HRelationQty = 0;


                    oItemSub.HRelationMoney = 0;




                    


                    // DBUtility.ClsPub.isDate(DateTime.Now);


                    oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);


                    oItemSub.HCloseType = false;


                    oItemSub.HCloseMan = "";


                    //oItemSub.HRemark = "";


                    oBill.DetailColl.Add(oItemSub);


                }




                //进行 会计期间 结账 的判断和控制


                string s = "";


                int sYear = 0;


                int sPeriod = 0;


                DateTime HDate = DateTime.Now;


                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)


                {


                    objJsonResult.Message = s;


                    return objJsonResult;


                }




                //保存


                //保存完毕后处理


                bool bResult;


                if (Convert.ToInt32(OperationType) == 1)


                if (Convert.ToInt32(OperationType) == 1)                                //新增保存


                {


                    // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);


                    bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);


                } else if(Convert.ToInt32(OperationType) == 4)                          //下推保存


                {


                    bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);


                }


                else


                else                                                                    //编辑保存


                {


                    if (BillOld.ShowBill(lsmain[0].HInterID, ref s) == false)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "此单据有误！";


                        objJsonResult.data = 1;


                        return objJsonResult;


                    }


                    //判断是否可编辑


                    if (BillOld.omodel.HChecker != "" && BillOld.omodel.HChecker != null)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "此单据已经被审核，不允许修改！";


                        objJsonResult.data = 1;


                        return objJsonResult;


                    }


                    if (BillOld.omodel.HBillStatus > 1)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "此单据处于不可编辑状态，不允许修改！";


                        objJsonResult.data = 1;


                        return objJsonResult;


                    }


                    if (!DBUtility.Xt_BaseBillFun.Fun_AllowEditBill(BillOld, ref s))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = s + "，不允许修改";


                        objJsonResult.data = 1;


                        return objJsonResult;


                    }




                    bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);


                }




                if (bResult)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "保存成功！";


                    //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");


                    objJsonResult.data = 1;


                    return objJsonResult;


                }


@@ -398,7 +422,8 @@


        {


            try


            {


                ds = oCN.RunProcReturn("select * from h_v_IF_SellOutBillList where hmainid=" + HInterID, "h_v_IF_SellOutBillList");


                //ds = oCN.RunProcReturn("select * from h_v_IF_SellOutBillList where hmainid=" + HInterID, "h_v_IF_SellOutBillList");


                ds = oCN.RunProcReturn("select * from h_v_IF_SellOutBillList_EditInit where hmainid=" + HInterID, "h_v_IF_SellOutBillList_EditInit");


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


                {


                    objJsonResult.code = "0";


@@ -516,7 +541,16 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                //进行 会计期间 结账 的判断和控制


                string s = "";


                int sYear = 0;


                int sPeriod = 0;


                DateTime HDate = DateTime.Now;


                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)


                {


                    objJsonResult.Message = s;


                    return objJsonResult;


                }




                //进行需要进行的审核/反审核操作


                if (IsAudit == 0) //审核提交


@@ -531,29 +565,118 @@


                        return objJsonResult;


                    }




                    //审核提交


                    if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    {


                        objJsonResult.code = "1";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "审核成功";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    else


                    //审核前控制=========================================      


                    string sql1 = "exec h_p_Kf_SellOutBill_BeforeCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'";


                    ds = oCN.RunProcReturn(sql1, "h_p_Kf_SellOutBill_BeforeCheckCtrl");


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;


                        objJsonResult.count = 1;


                        objJsonResult.Message = "审核失败!原因:审核前判断失败，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




                    if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //==================================================================================      




                    //审核提交


                    oCN.BeginTran();


                    //增加关联


                    oCN.RunProc("exec h_p_Kf_SellOutBill_Check " + HInterID + ",'" + oBill.BillType + "','" + CurUserName + "'");


                    //写入日志


                    string WorkList = "审核单据，单据号：" + oBill.omodel.HBillNo;


                    string SystemName = "LMES-销售出库单模块";


                    oCN.RunProc("Insert into  System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " +


                        "(getdate(),'" + CurUserName + "','" + SystemInformation.ComputerName + "','" + WorkList + "','" + SystemName + "','','审核')"


                        );






                    //审核后控制=========================================      


                    string sql = "exec h_p_Kf_SellOutBill_AfterCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'";


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


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


                    {


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "审核失败!原因:审核过程中出错，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                    {


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString();


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //=========================================      




                    oCN.Commit();


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "审核成功";


                    objJsonResult.data = null;


                    return objJsonResult;




                    //if (oBill.CheckBill(oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Kf_SellOutBill_AfterCheckCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    //{


                    //    objJsonResult.code = "1";


                    //    objJsonResult.count = 1;


                    //    objJsonResult.Message = "审核成功";


                    //    objJsonResult.data = null;


                    //    return objJsonResult;


                    //}


                    //else


                    //{


                    //    objJsonResult.code = "0";


                    //    objJsonResult.count = 0;


                    //    objJsonResult.Message = "审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;


                    //    objJsonResult.data = null;


                    //    return objJsonResult;


                    //}


                }


                if (IsAudit == 1) //反审核提交


                {


                    //反审核提交AbandonCheck


                    if (oBill.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    //反审核前控制=========================================        


                    string sql1 = "exec h_p_Kf_SellOutBill_BeforeUnCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'";


                    ds = oCN.RunProcReturn(sql1, "h_p_Kf_SellOutBill_BeforeUnCheckCtrl");


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "反审核失败!原因:反审核前判断失败，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;




                    }


                    if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "反审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //===========================================================         




                    //反审核提交AbandonCheck


                    //删除关联


                    oCN.BeginTran();


                    oCN.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToSellOut_UnCheck " + HInterID + ",'" + CurUserName + "'");


                    if (oBill.AbandonCheck(oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Kf_SellOutBill_AfterUnCheckCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    {


                        oCN.Commit();


                        objJsonResult.code = "1";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "反审核成功";


@@ -562,6 +685,7 @@


                    }


                    else


                    {


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;


@@ -573,6 +697,7 @@


            }


            catch (Exception e)


            {


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "审核失败或者反审核失败！" + e.ToString();


@@ -863,5 +988,203 @@


            }


        }


        #endregion




        #region 销售出库 条码明细


        /// <summary>


        /// </summary>


        /// <param name="HInterID">单据ID</param>


        /// <returns></returns>


        [Route("Kf_SellOutBill/BarCodeNote")]


        [HttpGet]


        public object SellOutBill_BarCodeNote(int HInterID)


        {


            try


            {


                List<object> columnNameListSum = new List<object>();


                List<object> columnNameList0 = new List<object>();


                List<object> columnNameList1 = new List<object>();


                List<object> columnNameList2 = new List<object>();




                string sql = "exec h_p_Kf_SellOutBillBarCodeNote " + HInterID;


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




                //添加 基本信息 列名


                foreach (DataColumn col in ds.Tables[1].Columns)


                {


                    Type dataType = col.DataType;


                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";


                    columnNameList0.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名


                }




                //添加 码单信息 列名


                foreach (DataColumn col in ds.Tables[2].Columns)


                {


                    Type dataType = col.DataType;


                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";


                    columnNameList1.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名


                }




                //添加 条码明细 列名


                foreach (DataColumn col in ds.Tables[3].Columns)


                {


                    Type dataType = col.DataType;


                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";


                    columnNameList2.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名


                }




                columnNameListSum.Add(columnNameList0);


                columnNameListSum.Add(columnNameList1);


                columnNameListSum.Add(columnNameList2);




                List<DataTable> tableList = new List<DataTable>();


                tableList.Add(ds.Tables[1]);


                tableList.Add(ds.Tables[2]);


                tableList.Add(ds.Tables[3]);




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = tableList;


                objJsonResult.list = columnNameListSum;


                return objJsonResult;


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




        #region 销售出库单 根据主内码与子内码获取销售出库单数据


        [Route("Kf_SellOutBill/loadKf_SellOutBill_Push")]


        [HttpGet]


        public object loadKf_SellOutBill_Push(long HInterID, long HSubID)


        {


            try


            {




                ds = oCN.RunProcReturn("select * from h_v_IF_SellOutBillList_EditInit where hmainid =" + HInterID + " and hsubid = " + HSubID, "h_v_IF_SellOutBillList_EditInit");


                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




        #region 销售出库单 根据主内码与子内码获取发货通知单数据


        [Route("Kf_SellOutBill/loadXs_SeOutStockBill_Push")]


        [HttpGet]


        public object loadXs_SeOrderBill_Push(long HInterID, long HSubID)


        {


            try


            {




                ds = oCN.RunProcReturn("select * from h_v_IF_SeOutStockBillList where hmainid =" + HInterID + " and hsubid = " + HSubID, "h_v_IF_SeOutStockBillList");


                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




        #region 销售出库单 检查单据是否存在


        /// <summary>


        /// </summary>


        /// <param name="HInterID">单据ID</param>


        /// <returns></returns>


        [Route("Kf_SellOutBill/CheckSellOutBill_IsExist")]


        [HttpGet]


        public object CheckSellOutBill_IsExist(int HInterID)


        {


            try


            {


                //HInterID数据判断


                if (HInterID <= 0)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "HInterID小于0！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                Int64 lngBillKey = 0;


                lngBillKey = DBUtility.ClsPub.isLong(HInterID);                                         //对HInterID进行类型的转换


                DAL.ClsKf_SellOutBill oBill = new DAL.ClsKf_SellOutBill();                              //实例化单据操作类，用于进行相关操作




                //针对需要进行的操作，检验当前单据的状态是否支持需要进行的操作


                if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))                    //根据HInterID获取该单据的数据


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "单据存在";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "程序错误！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion


    }


}