智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
1
wtt
4 天以前 797e02f68d79c931233f25af1d39bc136ce6185d 
 WebAPI/Controllers/CJGL/Cj_StationInBillController.cs


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


using System.Collections.Generic;


using System.Data;


using System.Data.SqlClient;


using System.IO;


using System.Web;


using System.Web.Http;


using System.Windows.Forms;


using WebAPI.Models;


@@ -23,6 +25,7 @@


        private json objJsonResult = new json();


        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


        public DAL.ClsSc_ICMOBill BillOld = new DAL.ClsSc_ICMOBill();


        string fileip = System.Configuration.ConfigurationManager.AppSettings["FileIP"];


        DataSet ds;


        DataSet ds1;




@@ -49,7 +52,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "开工单无编辑权限!";


                        objJsonResult.Message = "[3790-2-003]开工单无编辑权限!";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -60,7 +63,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "进站单无编辑权限!";


                        objJsonResult.Message = "[3790-2-003]进站单无编辑权限!";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -78,7 +81,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "错误的流转卡内码！";


                    objJsonResult.Message = "[3790-2-004]错误的流转卡内码！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -87,7 +90,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "流水号没有选择！请输入流水号后回车！";


                    objJsonResult.Message = "[3790-2-002]流水号没有选择！请输入流水号后回车！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -96,7 +99,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "流水号没有选择！";


                    objJsonResult.Message = "[3790-2-005]流水号没有选择！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -105,7 +108,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "流转卡号没有选择！";


                    objJsonResult.Message = "[3790-2-006]流转卡号没有选择！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -115,10 +118,11 @@


                string HBillNo = list[0].HBillNo;//递入type得到的单据号


                int HBillStatus = 0;


                string HMaker = user;//制单人


                int HYear = 2021;


                double HPeriod = 1;


                int HYear = DateTime.Now.Year;


                double HPeriod = DateTime.Now.Month;


                string HRemark = list[0].HRemark;//备注


                long HICMOInterID = list[0].HICMOInterID;//任务单ID


                long HICMOEntryID = list[0].HICMOEntryID;//任务单子ID


                string HICMOBillNo = list[0].HICMOBillNo;//任务单


                long HProcPlanInterID = 0;


                long HProcPlanEntryID = 0;


@@ -144,26 +148,28 @@


                string HOrderProcNO = list[0].HOrderProcNO;//订单跟踪号


                long HPRDOrgID = list[0].HPRDOrgID;//组织ID


                double HmaterOutqty = list[0].HmaterOutqty;//白坯发布


                long HMaterToSourceInterID = list[0].HMaterToSourceInterID;//上料防错单ID


                string HMaterToSourceBillNo = list[0].HMaterToSourceBillNo;//上料防错单单据号


                //单据完整性判断


                if (HMaterID <= 0)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "产品没有选择！";


                    objJsonResult.Message = "[0000-2-007]产品没有选择！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                string sReturn = "";


                if (oSystemParameter.ShowBill(ref sReturn) == true)


                {


                    if (oSystemParameter.omodel.WMS_CampanyName == "乔一") //系统参数  判断客户


                    if (oSystemParameter.omodel.WMS_CampanyName == "乔一" || oSystemParameter.omodel.WMS_CampanyName == "杭州斯莫尔") //系统参数  判断客户


                    {


                        //判断生产资源


                        if (HSourceID <= 0)


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "生产资源没有选择！";


                            objJsonResult.Message = "[0000-2-006]生产资源没有选择！";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


@@ -174,7 +180,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "工作中心没有选择！";


                    objJsonResult.Message = "[0000-2-010]工作中心没有选择！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -182,7 +188,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "当前工序没有选择！";


                    objJsonResult.Message = "[0000-2-011]当前工序没有选择！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -190,7 +196,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "接收个数不能为0！";


                    objJsonResult.Message = "[3790-2-007]接收个数不能为0！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -200,7 +206,7 @@




                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "判断首道工序失败，不允许保存！";


                    objJsonResult.Message = "[3790-2-008]判断首道工序失败，不允许保存！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -212,7 +218,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "保存前判断失败！";


                    objJsonResult.Message = "[0000-2-012]保存前判断失败！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -220,7 +226,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);


                    objJsonResult.Message = "[0000-1-051]保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -236,7 +242,7 @@


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "单据号重复！";


                        objJsonResult.Message = "[0000-2-013]单据号重复！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -260,6 +266,29 @@


                    ",'" + HProcNo + "','" + HOrderProcNO + "','" + HMainInterID + "'," + HPRDOrgID +


                    ","+ HmaterOutqty + ") ");




                    if(HMaterToSourceInterID!=0)


                    {


                        //生成上料防错单


                        //插入子表


                        oCN.RunProc("EXEC h_p_Sc_MaterToSourceBillSub_Insert " + HMaterToSourceInterID.ToString() + ",'" + HMaterToSourceBillNo + "'");


                        //插入主表


                        oCN.RunProc("Insert Into Sc_MaterToSourceBillMain   " +


                        "(HBillType,HBillSubType,HInterID,HBillNo,HDate" +


                        ",HYear,HPeriod,HRemark,HMaker,HMakeDate,HChecker,HCheckDate" +


                        ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType" +


                        ",HProcExchInterID,HProcExchEntryID,HProcExchBillNo,HICMOInterID,HICMOEntryID,HICMOBillNo" +


                        ",HSourceID,HProcID,HMaterID,HSourceBarCode,HEquipID,HWorkerID,HWorkerBarCode" +


                        ",HGroupID,HProcNo,HStockOrgID" +


                        ") " +


                        " values('3786','3790'," + HMaterToSourceInterID.ToString() + ",'" + HMaterToSourceBillNo + "',convert(varchar(10),getdate(),120)" +


                        ",year(getdate()),month(getdate()),'工序进站绑定生成','" + HMaker + "',getdate(),'" + HMaker + "',getdate()" +


                        "," + HInterID.ToString() + ",0,'" + HBillNo + "','3790'" +


                        "," + HProcExchInterID.ToString() + "," + HProcExchEntryID.ToString() + ",'" + HProcExchBillNo + "'," + HICMOInterID.ToString() + "," + HICMOEntryID.ToString() + ",'" + HICMOBillNo + "'" +


                        "," + HSourceID.ToString() + "," + HProcID.ToString() + "," + HMaterID.ToString() + ",'',0,0,''" +


                        "," + HGroupID.ToString() + "," + HProcNo.ToString() + "," + HPRDOrgID.ToString() +


                        ") ");


                    }


                    //写入日志


                    LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",新增工序进站单据:" + HBillNo);


                    oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "新增工序进站单据：" + HBillNo + "','LMES-工序进站模块','" + DBUtility.ClsPub.IPAddress + "','新增单据'", ref DBUtility.ClsPub.sExeReturnInfo);


                }


@@ -313,39 +342,39 @@


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "操作类型无效！";


                    objJsonResult.Message = "[操作类型无效]操作类型无效！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                


                //ds = oCN.RunProcReturn("exec h_p_MES_StationInBill_QtyCtrl " + HInterID + "", "h_p_MES_StationInBill_QtyCtrl");


                //if (ds == null)


                //{


                //    oCN.RollBack();


                //    objJsonResult.code = "0";


                //    objJsonResult.count = 0;


                //    objJsonResult.Message = "判断数量失败！";


                //    objJsonResult.data = null;


                //    return objJsonResult;


                //}


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


                //{


                //    oCN.RollBack();


                //    objJsonResult.code = "0";


                //    objJsonResult.count = 0;


                //    objJsonResult.Message = "判断数量失败！";


                //    objJsonResult.data = null;


                //    return objJsonResult;


                //}


                //if (ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "2")


                //{


                //    oCN.RollBack();


                //    objJsonResult.code = "0";


                //    objJsonResult.count = 0;


                //    objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);


                //    objJsonResult.data = null;


                //    return objJsonResult;


                //}




                ds = oCN.RunProcReturn("exec h_p_MES_StationInBill_QtyCtrl " + HInterID + "", "h_p_MES_StationInBill_QtyCtrl");


                if (ds == null)


                {


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "[0000-2-015]判断数量失败！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


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


                {


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "[0000-2-015]判断数量失败！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                if (ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "2")


                {


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "[0000-2-015]" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_In " + HInterID + ",1");


                //判断是否是 首道工序


                ds1 = oCN.RunProcReturn(" select HLastProc,HFstProc from Sc_ProcessExchangeBillMain a  " +


@@ -360,14 +389,14 @@




                }




                //=========================保存后控制  


                //=========================保存后控制  ============================


                DataSet ds2 = oCN.RunProcReturn("Exec h_p_Sc_StationInBill_AfterSaveCtrl " + HInterID.ToString() + ", '" + HBillNo + "',1 ", "h_p_Sc_StationInBill_AfterSaveCtrl");


                if (ds2 == null)


                {


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "保存后控制判断失败！";


                    objJsonResult.Message = "[0000-2-016]保存后控制判断失败！";


                    objJsonResult.data = null;


                    return objJsonResult;


                   


@@ -377,11 +406,11 @@


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "保存失败2！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);


                    objJsonResult.Message = "[0000-1-051]保存失败2！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);


                    objJsonResult.data = null;


                    return objJsonResult;


                }


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


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




                oCN.Commit();


               


@@ -396,9 +425,29 @@


                        objJsonResult.Verify = "N";


                    }


                }




                //测试语句===========================================================================================================


                string msg_str = "";


                string sql_str = "select a.HQty HQty_Main,b.HQty HQty_Sub " +


                            "from Sc_ProcessExchangeBillMain as a " +


                            "inner join Sc_ProcessExchangeBillSub as b on a.HInterID = b.HInterID " +


                            "where a.HInterID = " + HProcExchInterID;


                DataSet ds_str = oCN.RunProcReturn(sql_str, "Sc_ProcessExchangeBillMain");


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


                {


                    msg_str = "HQty_Main:" + ds_str.Tables[0].Rows[0]["HQty_Main"].ToString() + ";HQty_Sub:";


                    for (int j = 0; j < ds_str.Tables[0].Rows.Count; j++)


                    {


                        msg_str += ds_str.Tables[0].Rows[j]["HQty_Sub"].ToString() + ",";


                    }


                }




                oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "修改工序进站单据：" + HBillNo + "[工序流转卡号：" + HProcExchBillNo + "]" + msg_str + "','LMES-工序出站模块','" + DBUtility.ClsPub.IPAddress + "','新增或修改单据'", ref DBUtility.ClsPub.sExeReturnInfo);


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




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "新增单据成功！";


                objJsonResult.Message = "[0000-1-050]新增单据成功！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


@@ -407,7 +456,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.Message = "[0000-1-051]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -423,6 +472,67 @@


        }


        #endregion




        #region 工序进站接收单流水号回车获取工序信息，并根据系统参数判断进站单是否绑定配件清单 20240621


        [Route("Cj_StationInBill/HProcNo_KeyDown")]


        [HttpGet]


        public object HProcNo_KeyDown(string HBillNo, string HProcExchBillNo, Int64 HProcNo, string HMaker)


        {


            try


            {


                if (HProcExchBillNo.Equals(""))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "流转卡没有扫描，或者没有按回车键，请扫描流转卡或在流转卡文本框中按回车键！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                //获取系统参数


                string sErrMsg = "";


                if (oSystemParameter.ShowBill(ref sErrMsg) == true)


                {


                    string MES_StationInBill_LineBindCtl = "N"; //进站接收时是否绑定该工序的配件清单（Y是需要绑定，N不需要绑定）


                    string MES_StationInBill_DefQty = "4";      //工序进站时默认带入数量（1.流转卡数，2.上道合格数量，3.物料最小包装数量，4.不带入）


                    MES_StationInBill_LineBindCtl = oSystemParameter.omodel.MES_StationInBill_LineBindCtl;


                    MES_StationInBill_DefQty = oSystemParameter.omodel.MES_StationInBill_DefQty;




                    ds = oCN.RunProcReturn("exec h_p_MES_StationInBill_HProcNo_KeyDown '" + HBillNo + "','" + HProcExchBillNo + "'," + HProcNo.ToString() + ",'" + MES_StationInBill_LineBindCtl + "','" + MES_StationInBill_DefQty + "','" + HMaker + "'", "h_p_MES_StationInBill_HProcNo_KeyDown");




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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "工序号错误或者当前工序号不允许进站，请重新输入！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "成功！";


                    objJsonResult.data = ds.Tables[0];


                    return objJsonResult;


                }


                else


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "获取系统参数失败！ " + sErrMsg;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "工序进站接收单流水号获取信息失败！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




        #region 工序进站接收单流水号回车获取工序信息


        [Route("Cj_StationInBill/txtHProcNo_KeyDown")]


        [HttpGet]


@@ -434,7 +544,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "条形码不能为空！";


                    objJsonResult.Message = "[0000-2-019]条形码不能为空！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -447,13 +557,13 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "工序号错误或者当前工序号不允许进站，请重新输入！";


                    objJsonResult.Message = "[3790-2-013]工序号错误或者当前工序号不允许进站，请重新输入！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.Message = "[0000-1-037]Sucess！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


@@ -461,7 +571,7 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -483,30 +593,30 @@


                    oCN.RunProc("exec h_p_MES_StationInBillSubBindSource_Insert " + HProcExchInterID.ToString() + " , " + HProcExchEntryID.ToString() + "," + HInterID.ToString() + " ");




                    ds = oCN.RunProcReturn($@"select * from


(


 select 


a.HICMOInterID,a.HICMOEntryID,b.HProcID  


from Sc_ProcessExchangeBillMain a with(nolock) 


inner join Sc_ProcessExchangeBillSub b with(nolock)  on a.HInterID=b.HinterID


Where a.HInterID={HProcExchInterID} and b.HEntryID={HProcExchEntryID}


) a


inner join (


select a.HICMOInterID,a.HICMOEntryID, b.HProcID 


from Sc_PPBomBillMain a with(nolock) 


inner join Sc_PPBomBillSub b with(nolock)  on a.HInterID=b.HInterID


Where b.HKeyMaterID_Line<>0


)b on a.HICMOInterID=b.HICMOInterID and a.HICMOEntryID=b.HICMOEntryID and a.HProcID=b.HProcID", "Sc_ProcessExchangeBillMain");


                                            (


                                             select 


                                            a.HICMOInterID,a.HICMOEntryID,b.HProcID  


                                            from Sc_ProcessExchangeBillMain a with(nolock) 


                                            inner join Sc_ProcessExchangeBillSub b with(nolock)  on a.HInterID=b.HinterID


                                            Where a.HInterID={HProcExchInterID} and b.HEntryID={HProcExchEntryID}


                                            ) a


                                            inner join (


                                            select a.HICMOInterID,a.HICMOEntryID,isnull(c.HItemID,0) HProcID 


                                            from Sc_PPBomBillMain a with(nolock) 


                                            inner join Sc_PPBomBillSub b with(nolock)  on a.HInterID=b.HInterID


                                            left join Gy_Process c on b.HProcName = c.HName


                                            )b on a.HICMOInterID=b.HICMOInterID and a.HICMOEntryID=b.HICMOEntryID and a.HProcID=b.HProcID", "Sc_ProcessExchangeBillMain");




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


                        objJsonResult.Message = "需要绑定配件！";


                        objJsonResult.Message = "[0000-2-026]需要绑定配件！";


                    }


                    else


                    {


                        objJsonResult.Message = "不需要绑定配件！";


                        objJsonResult.Message = "[0000-2-027]不需要绑定配件！";


                    }


                }


                else {


                    objJsonResult.Message = "不需要绑定配件！";


                    objJsonResult.Message = "[0000-2-027]不需要绑定配件！";


                }




                objJsonResult.code = "1";


@@ -518,13 +628,12 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion






        #region 工序进站接收单流水号回车获取工序信息


        [Route("Cj_StationInBill/txtHProcNo_KeyDown_qiaoyi")]


@@ -571,8 +680,6 @@


        }


        #endregion








        #region 工序进站接收单根据职员代码模糊回车查询


        [Route("Cj_StationInBill/GetMessageByEmpNumber")]


        [HttpGet]


@@ -587,13 +694,13 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "未查询到职员信息！";


                    objJsonResult.Message = "[0000-2-028]未查询到职员信息！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                objJsonResult.code = "0";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.Message = "[0000-1-037]Sucess！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


@@ -601,14 +708,12 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion








        #region 工序进站接收单根据物料代码模糊回车查询


        [Route("Cj_StationInBill/GetMessageByMaterNumber")]


@@ -645,9 +750,6 @@


        }


        #endregion










        #region 返回工序进站接收单列表


        [Route("Cj_StationInBill/get_Display")]


        [HttpGet]


@@ -675,7 +777,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "进站单无查询权限!";


                        objJsonResult.Message = "进站单无查询权限!";    


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -730,6 +832,77 @@


        }


        #endregion




        #region 返回工序进站接收单列表-分页


        [Route("Cj_StationInBill/get_Display_ByPage")]


        [HttpGet]


        public object get_Display_ByPage(string sWhere, string user, string Organization, int page, int size, string HBillSubType)


        {


            try


            {


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




                if (HBillSubType == "SUB")


                {


                    //判断是否有查询权限


                    if (!DBUtility.ClsPub.Security_Log("Cj_StationInBill_Sub_Query", 1, false, user))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "[3790-1-004]开工单无查询权限!";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


                else


                {


                    //判断是否有查询权限


                    if (!DBUtility.ClsPub.Security_Log("Cj_StationInBill_Query", 1, false, user))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "[3790-1-004]进站单无查询权限!";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }




                sWhere = sWhere.Replace("'", "''");




                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("exec h_p_MES_StationInBillList " + page + "," + size + ",'" + Organization + "'," + "''", "h_p_MES_StationInBillList");


                }


                else


                {


                    ds = oCN.RunProcReturn("exec h_p_MES_StationInBillList " + page + "," + size + ",'" + Organization + "','" + sWhere + "'", "h_p_MES_StationInBillList");


                }




                //添加列名


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


                {


                    Type dataType = col.DataType;


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


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


                }




                objJsonResult.code = "1";


                objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString());


                objJsonResult.Message = "[0000-1-037]Sucess！";


                objJsonResult.list = columnNameList;


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "[0000-1-010]查询数据异常，请与管理员联系！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




        #region 编辑前判断


        [Route("Cj_StationInBill/set_ShowBillJudge")]


        [HttpGet]


@@ -742,7 +915,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "判断关联失败！";


                    objJsonResult.Message = "[0000-2-018]判断关联失败！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -758,7 +931,7 @@


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "Sucess！";


                    objJsonResult.Message = "[0000-1-037]Sucess！";


                    objJsonResult.data = ds.Tables[0];


                    return objJsonResult;


                }


@@ -767,7 +940,7 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -817,8 +990,6 @@


        {


            try


            {


                string ModRightNameCheck = "";




                if (HBillSubType == "SUB")


                {


                    //审核权限


@@ -826,7 +997,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "开工单审核失败！无权限！";


                        objJsonResult.Message = "[3790-1-006]开工单审核失败！无权限！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -837,7 +1008,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "进站单审核失败！无权限！";


                        objJsonResult.Message = "[3790-1-006]进站单审核失败！无权限！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -847,7 +1018,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "单据ID为0，不能审核！";


                    objJsonResult.Message = "[0000-1-009]单据ID为0，不能审核！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -859,7 +1030,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "单据已审核!不能再次审核";


                        objJsonResult.Message = "[0000-1-023]单据已审核!不能再次审核";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -868,12 +1039,12 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.Message = "[0000-1-045]单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                //审核前控制


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


                string HBillNo = oBill.omodel.HBillNo;


                string sql = "exec h_p_Sc_StationInBill_BeforeCheckCtrl " + HInterID + ",'" + HBillNo + "','" + CurUserName + "'";


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


@@ -881,7 +1052,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


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


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


                    objJsonResult.data = null;


                    return objJsonResult;




@@ -890,17 +1061,17 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


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


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }




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


                //审核


                if (Cj_StationInBillCheckBill(HInterID, HBillNo, CurUserName, ref DBUtility.ClsPub.sExeReturnInfo))


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


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


                    objJsonResult.Message = "[0000-1-029]审核成功!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -908,7 +1079,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.Message = "[0000-1-025]审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -918,7 +1089,7 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.Message = "[0000-1-025]审核失败！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -954,7 +1125,7 @@


                {


                }




                //审核后控制


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


                string sql = "exec h_p_Sc_StationInBill_AfterCheckCtrl " + lngBillKey + ",'" + HBillNo + "','" + CurUserName + "'";


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


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


@@ -969,7 +1140,7 @@


                    oCN.RollBack();


                    return false;


                }




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


                sReturn = sReturn + " 审核功能！";


                oCN.Commit();


                return true;


@@ -997,7 +1168,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "开工单反审核失败！无权限！";


                        objJsonResult.Message = "[3790-1-007]开工单反审核失败！无权限！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -1009,7 +1180,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "进站单反审核失败！无权限！";


                        objJsonResult.Message = "[3790-1-007]进站单反审核失败！无权限！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -1021,7 +1192,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "单据ID为0，不能反审核！";


                    objJsonResult.Message = "[0000-1-009]单据ID为0，不能反审核！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1033,7 +1204,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "单据未审核!不需要反审核!";


                        objJsonResult.Message = "[0000-1-018]单据未审核!不需要反审核!";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -1042,12 +1213,12 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.Message = "[0000-1-005]单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                //反审核前控制


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


                string HBillNo = oBill.omodel.HBillNo;


                string sql = "exec h_p_Sc_StationInBill_BeforeUnCheckCtrl " + HInterID + ",'" + HBillNo + "','" + CurUserName + "'";


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


@@ -1055,7 +1226,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


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


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


                    objJsonResult.data = null;


                    return objJsonResult;




@@ -1064,17 +1235,17 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


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


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }




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


                //反审核


                if (Cj_StationInBillAbandonCheckBill(HInterID, HBillNo, CurUserName, ref DBUtility.ClsPub.sExeReturnInfo))


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


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


                    objJsonResult.Message = "[0000-1-019]反审核成功!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1082,7 +1253,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.Message = "[0000-1-028]反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1091,7 +1262,7 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.Message = "[0000-1-028]反审核失败！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1132,7 +1303,7 @@


                {


                }




                //反审核后控制


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


                string sql = "exec h_p_Sc_StationInBill_AfterUnCheckCtrl " + lngBillKey + ",'" + HBillNo + "','" + CurUserName + "'";


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


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


@@ -1147,7 +1318,7 @@


                    oCN.RollBack();


                    return false;


                }




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


                sReturn = sReturn + "反审核功能！";


                oCN.Commit();


                return true;


@@ -1198,7 +1369,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "开工单无权限关闭!";


                        objJsonResult.Message = "[3790-1-008]开工单无权限关闭!";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -1209,7 +1380,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "进站单无权限关闭!";


                        objJsonResult.Message = "[3790-1-008]进站单无权限关闭!";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -1220,7 +1391,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "HInterID为空！";


                    objJsonResult.Message = "[0000-1-009]HInterID为空！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1242,17 +1413,41 @@


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "单据已关闭!不需要再关闭!";


                            objJsonResult.Message = "[0000-1-033]单据已关闭!不需要再关闭!";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                    }


                    //关闭单据


                    if (!BillOld.CloseBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    var HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString();




                    //关闭前控制=========================================      


                    string sql1 = "exec h_p_Sc_ShiftsBeginInfoBill_BeforeCloseCtrl " + HInterID + ",'" +HBillNo + "','" + user + "'";


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


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "关闭失败!原因:" + ClsPub.sExeReturnInfo;


                        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;


                    }


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




                    //关闭单据


                    if (!BillOld.CloseBill(Int64.Parse(HInterID), HBillNo, "h_p_Sc_ShiftsBeginInfoBill_AfterCloseCtrl", user,ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "[0000-1-034]关闭失败!原因:" + ClsPub.sExeReturnInfo;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -1269,17 +1464,41 @@


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "单据已反关闭!不需要再反关闭!";


                            objJsonResult.Message = "[0000-1-035]单据已反关闭!不需要再反关闭!";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                    }


                    //反关闭单据


                    if (!BillOld.CancelClose(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    var HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString();


                    //反关闭前控制=========================================      


                    string sql1 = "exec h_p_Sc_StationInBill_BeforeUnCloseCtrl " + HInterID + ",'" + HBillNo + "','" + user + "'";


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


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "反关闭失败!原因:" + ClsPub.sExeReturnInfo;


                        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;


                    }


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






                    //反关闭单据


                    if (!BillOld.CancelClose(Int64.Parse(HInterID), HBillNo, "h_p_Sc_StationInBill_AfterUnCloseCtrl", user, ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "[0000-1-036]反关闭失败!原因:" + ClsPub.sExeReturnInfo;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -1289,7 +1508,7 @@




                objJsonResult.code = "0";


                objJsonResult.count = 1;


                objJsonResult.Message = "执行成功！";


                objJsonResult.Message = "[0000-1-037]执行成功！";


                objJsonResult.data = null;


                return objJsonResult; ;




@@ -1298,7 +1517,7 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "执行失败！" + e.ToString();


                objJsonResult.Message = "[0000-1-037]执行失败！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1366,7 +1585,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "开工单无权限！";


                        objJsonResult.Message = "[3790-1-005]开工单无权限！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -1377,7 +1596,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "进站接收单无权限！";


                        objJsonResult.Message = "[3790-1-005]进站接收单无权限！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -1395,7 +1614,7 @@


                            {


                                objJsonResult.code = "0";


                                objJsonResult.count = 0;


                                objJsonResult.Message = "只能删除本人的单据！";


                                objJsonResult.Message = "[0000-1-011]只能删除本人的单据！";


                                objJsonResult.data = null;


                                return objJsonResult;


                            }


@@ -1600,5 +1819,188 @@


            }


        }


        #endregion




        #region  工序进站汇报单文件上传处理




        [Route("Cj_StationInBill/UploadFile1")]


        [HttpPost]


        public object UploadFile1()


        {




            string HBillNo = HttpContext.Current.Request.Params["HBillNo"];  //单据号


            string HRemark = HttpContext.Current.Request.Params["HRemark"];  //备注


            string HUserName = HttpContext.Current.Request.Params["HUserName"];  //创建人


            HttpPostedFile files = HttpContext.Current.Request.Files["file"];


            string path = HttpContext.Current.Server.MapPath("~/../Files/Cj_StationInBill/" + HBillNo);


            //string path = @"D:\\Files\\"+ HBillNo;


            dynamic dyResult = UpLoadFile(files, path, HBillNo, HRemark, HUserName);


            if (dyResult != null && dyResult.result == 1)


            {


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "上传成功！";


                objJsonResult.data = null;


                return objJsonResult;


            }


            else


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = dyResult.returnval;


                objJsonResult.data = null;


                return objJsonResult;


            }




        }




        public dynamic UpLoadFile(HttpPostedFile files, string path, string HBillNo, string HRemark, string HUserName)


        {


            dynamic Result_Ob = new { result = 1, returnval = "上传成功！" };


            string filePath = Path.GetFullPath(files.FileName);//文件上传路径


            string fileExtension = Path.GetExtension(files.FileName);// 文件扩展名


            string filename = files.FileName;//文件名


            string fileSavePath = path;// 上传保存路径


            int filesize = files.ContentLength;//获取上传文件的大小单位为字节byte


            int Maxsize = 40000 * 1024;//定义上传文件的最大空间大小为40M


            try


            {


                if (files == null || files.ContentLength <= 0)


                {


                    Result_Ob = new { result = 0, returnval = "文件不能为空!" };


                    return Result_Ob;


                }


                if (filesize >= Maxsize)


                {


                    Result_Ob = new { result = 0, returnval = "上传文件超过40M，不能上传！" };


                    return Result_Ob;


                }




                string fileurl = Path.Combine(fileSavePath, filename);


                if (Directory.Exists(fileurl) == true)  //如果存在重名文件就提示  


                {


                    Result_Ob = new { result = 0, returnval = "存在同名文件！" };


                    return Result_Ob;


                }


                //删除数据表数据


                ds = oCN.RunProcReturn("delete from MES_AccessoriesList where HSourceBillNo ='" + HBillNo + "' and HFileName='" + filename + "'", "MES_AccessoriesList");


                if (Directory.Exists(path))


                {


                    File.Delete(fileurl);      //删除指定文件


                    files.SaveAs(fileurl);


                    string StrPath = "/files/Cj_StationInBill/" + HBillNo + "/" + filename;


                    if (File.Exists(fileurl))


                    {


                        //这里可以执行一些其它的操作，比如更新数据库


                        //写入数据表


                        oCN.RunProc("Insert into MES_AccessoriesList (HFileName,HFilePath,HFilePath_Cus,HFileType" +


                                    ",HLoadMan,HLoadDate,HRemark,HVerNum,HFileSize" +


                                    ",HFileClsID,HSourceBillNo" +


                                   ") values('"


                                    + filename.ToString() + "','" + StrPath.ToString() + "','" + filePath.ToString() + "','" + fileExtension.ToString() + "'" +


                                    ",'" + HUserName + "',getdate(),'" + HRemark + "','V1','" + filesize +


                                    "','" + 0 + "','" + HBillNo +


                                   "') ");


                    }


                    else


                    {


                        Result_Ob = new { result = 0, returnval = "上传失败！此文件为恶意文件" };


                    }


                }


                else


                {


                    Directory.CreateDirectory(fileSavePath); //添加文件夹


                    files.SaveAs(fileurl);


                    string StrPath = "/files/Cj_StationInBill/" + HBillNo + "/" + filename;


                    if (File.Exists(fileurl))


                    {


                        //这里可以执行一些其它的操作，比如更新数据库


                        //写入数据表


                        oCN.RunProc("Insert into MES_AccessoriesList (HFileName,HFilePath,HFilePath_Cus,HFileType" +


                                    ",HLoadMan,HLoadDate,HRemark,HVerNum,HFileSize" +


                                    ",HFileClsID,HSourceBillNo" +


                                   ") values('"


                                    + filename.ToString() + "','" + StrPath.ToString() + "','" + filePath.ToString() + "','" + fileExtension.ToString() + "'" +


                                    ",'" + HUserName + "',getdate(),'" + HRemark + "','V1','" + filesize +


                                    "','" + 0 + "','" + HBillNo +


                                   "') ");


                    }


                    else


                    {


                        Result_Ob = new { result = 0, returnval = "上传失败！此文件为恶意文件" };


                    }


                }




            }


            catch (Exception e)


            {


                Result_Ob = new { result = 0, returnval = e.Message };


            }


            return Result_Ob;


        }  






        /// <summary>


        /// 根据单据号查找上传文件列表


        /// </summary>


        /// <param name="sWhere"></param>


        /// <returns></returns>


        [Route("Cj_StationInBill/Filelist")]


        [HttpGet]


        public object Filelist(string HBillNo)


        {


            var url = fileip + "/files/Cj_StationInBill/" + HBillNo + "/";


            //@"C:\\files\\"


            try


            {


                ds = oCN.RunProcReturn("select *,'" + url + "'+CAST(HFileName as varchar(200))as url  from MES_AccessoriesList where HSourceBillNo='" + HBillNo + "'", "MES_AccessoriesList");


                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;


            }


        }




        /// <summary>


        /// 根据ID,单据号,文件名 删除文件


        /// </summary>


        /// <param name="sWhere"></param>


        /// <returns></returns>


        [Route("Cj_StationInBill/DeleteFilelist")]


        [HttpGet]


        public object DeleteFilelist(string HItemID, string HSourceBillNo, string HFileName)


        {


            try


            {




                oCN.RunProc("delete from MES_AccessoriesList where HItemID =" + HItemID);


                string fileurl = Path.Combine(HttpContext.Current.Server.MapPath("~/../Files/Cj_StationInBill/" + HSourceBillNo), HFileName);


                File.Delete(fileurl);      //删除指定文件


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "[0000-1-008]删除成功！";


                objJsonResult.data = null;


                return objJsonResult;


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "[0000-1-007]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }




        #endregion


    }


}