工序出站汇报单，图片上传

YL

2021-06-15 bfbc267f3c7d337820fb1bb3156ce31d6141fd78

 WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs

@@ -5,12 +5,14 @@
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Web;
using System.Web.Http;
using WebAPI.Models;

namespace WebAPI.Controllers
{
    //工序出站发出单Controller
    //工序出站汇报单Controller
    public class Cj_StationOutBillController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;
@@ -19,7 +21,6 @@
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;
        DataSet ds1;



        /// <summary>
@@ -38,63 +39,283 @@
                //反序列化
                msg1 = "[" + msg1.ToString() + "]";
                List<StationBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<StationBill>>(msg1);
                string BillType = "3790";
                string eventType = list[0].eventType;
                string BillType = "3791";
                string HBillSubType = "3791";
                long HInterID = list[0].HInterID;//递入type得到的单据ID
                string HBillNo = list[0].HBillNo;//递入type得到的单据号
                int HBillStatus = 0;
                string HMaker = list[0].HMaker;//制单人
                string HMouldNum = list[0].HMouldNum;//模穴号
                int HYear = 2021;
                double HPeriod = 1;
                string HRemark = list[0].HRemark;//备注
                string HSourceName = list[0].HSourceName;//生产资源名称
                double HPieceQty = list[0].HPieceQty;//进站PCS数
                double HWasterQty = list[0].HWasterQty;//报废数量
                double HPlanPieceQty = list[0].HPlanPieceQty;//进站PNL数
                double HBadPNL = list[0].HBadPNL;//报废PNL数
                long HICMOInterID = list[0].HICMOInterID;//任务单ID
                string HICMOBillNo = list[0].HICMOBillNo;//任务单
                int HProcPlanInterID = 0;
                int HProcPlanEntryID = 0;
                string HProcPlanBillNo = "";
                int HProcExchInterID = 0;
                int HProcExchEntryID = 0;
                long HProcExchInterID = list[0].lngBillKey;
                long HProcExchEntryID = list[0].lngBillSubKey;
                string HProcExchBillNo = list[0].HProcExchBillNo;//流转卡
                long HMaterID = list[0].HMaterID;//产品ID
                long HProcID = list[0].HProcID;//当前工序
                long HProcID = list[0].HProcID;//当前工序ID
                double HICMOQty = list[0].HICMOQty;//任务单数量
                double HPlanQty = list[0].HPlanQty;//流转卡数量
                double HPlanQty = list[0].HPlanQty;//移交PNL数
                DateTime HStationOutTime = list[0].HStationOutTime;//汇报时间
                long HSourceID = list[0].HSourceID;//生产资源ID
                long HPayProcID = list[0].HPayProcID;//核算工序ID
                long HGroupID = list[0].HGroupID;//班组ID
                long HDeptID = 0;
                long HEmpID = list[0].HEmpID;//接收人ID
                long HEmpID = list[0].HEmpID;//操作员ID
                string HBarCode = list[0].HBarCode;//条形码
                string HAddr = "";
                string HBarCodeMaker = "";
                long HSourceID2 = list[0].HSourceID2;//生产资源2ID
                long HSourceID3 = list[0].HSourceID3;//生产资源3ID
                long HSourceID4 = list[0].HSourceID4;//生产资源4ID
                long HSourceID5 = list[0].HSourceID5;//生产资源5ID
                long HSupID = 0;
                double HQty = list[0].HQty;//接收数量
                double HQty = list[0].HQty;//合格数量
                double HPrice = 0;
                double HMoney = 0;
                double HPieceQty = list[0].HPieceQty;//接收件数
                string HSourceName = list[0].HSourceName;//生产资源名称
                double HBadCount = list[0].HBadCount;//不良数量
                long HCenterID = list[0].HCenterID;//工作中心ID
                string HProcNo = list[0].HProcNo;//流水号
                long HProcNo = list[0].HProcNo;//流水号
                string HOrderProcNO = list[0].HOrderProcNO;//订单跟踪号
                string HSourceNameList = list[0].HSourceNameList;//设备清单
                long HMainSourceInterID = list[0].HInterID;//递入type得到的单据ID
                string HMainSourceBillNo = list[0].HBillNo;//递入type得到的单据号
                string HMainSourceBillType = "3790";
                bool HLastSubProc = list[0].HLastSubProc;//转下工序
                long HEmpID2 = list[0].HEmpID2;//操作员2ID
                long HEmpID3 = list[0].HEmpID3;//操作员3ID
                long HEmpID4 = list[0].HEmpID4;//操作员4ID
                long HEmpID5 = list[0].HEmpID5;//操作员5ID
                double HDSQty = list[0].HDSQty;//折弯刀数
                double HChongQty = list[0].HChongQty;//NCT冲次数
                double HPriceRate = list[0].HPriceRate;//系数
                double HWorkTimes = list[0].HWorkTimes;//工时
                long HQCCheckID = list[0].HQCCheckID;//检验员ID
                //单据完整性判断
                if (HProcExchInterID <= 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "流转卡没有选择！请扫描条形码或输入条形码后回车";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (HProcExchEntryID <= 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "流水号没有选择！请输入流水号后回车";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (HProcNo <= 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "流水号没有选择！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (HProcExchBillNo == "")
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "流转卡号没有选择！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (HMaterID == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "产品没有选择！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (HGroupID == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "生产班组没有选择！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                if (HProcID == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "当前工序没有选择！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (HEmpID == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "操作员没有选择！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (HQCCheckID == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "检验员没有选择！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (HSourceID == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "生产资源没有选择！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (HCenterID == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "工作中心没有选择！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (HQty + HWasterQty <= 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "合格数量加报废数量不能为0！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (HWorkTimes <= 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "工时必须大于0！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //if (HEmpID2 == 0 )
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "操作员2没有选择！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}
                //if (HEmpID3 == 0 )
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "操作员3没有选择！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}
                //if (HEmpID4 == 0 )
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "操作员4没有选择！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}
                //if (HEmpID5 == 0 )
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "操作员5没有选择！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}
                //若MAINDI重复则重新获取
                oCN.BeginTran();
                if ("Add".Equals(eventType))
                {
                    if (!AllowbillNo(HBillNo))
                    {
                        oCN.RollBack();
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "单据号重复！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    oCN.RunProc("Insert Into Sc_StationOutBillMain " +
                    "(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate,HMouldNum" +
                    ",HYear,HPeriod,HRemark,HSourceName,HPieceQty,HWasterQty,HPlanPieceQty,HBadPNL" +
                    ",HICMOInterID,HICMOBillNo,HProcPlanInterID,HProcPlanEntryID,HProcPlanBillNo,HProcExchInterID,HProcExchEntryID" +
                    ",HProcExchBillNo,HMaterID,HProcID,HICMOQty,HPlanQty,HStationOutTime,HSourceID,HPayProcID" +
                    ",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate,HSourceID2,HSourceID3,HSourceID4,HSourceID5" +
                    ",HSupID,HQty,HPrice,HMoney,HBadCount,HCenterID,HProcNo,HOrderProcNO,HSourceNameList" +
                    ",HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HLastSubProc" +
                    ",HEmpID2,HEmpID3,HEmpID4,HEmpID5,HDSQty,HChongQty,HPriceRate,HWorkTimes,HQCCheckID" +
                    ") " +
                    " values('" + BillType + "','" + HBillSubType + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate(),'" + HMouldNum + "'" +
                    "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HSourceName + "'," + HPieceQty + "," + HWasterQty + "," + HPlanPieceQty + "," + HBadPNL +
                    "," + HICMOInterID + ",'" + HICMOBillNo + "'," + HProcPlanInterID + "," + HProcPlanEntryID + ",'" + HProcPlanBillNo + "'," + HProcExchInterID + "," + HProcExchEntryID +
                    ",'" + HProcExchBillNo + "'," + HMaterID + "," + HProcID + "," + HICMOQty + "," + HPlanQty + ",'" + HStationOutTime + "'," + HSourceID + "," + HPayProcID +
                    "," + HGroupID + "," + HDeptID + "," + HEmpID + ",'" + HBarCode + "','" + HAddr + "','" + HBarCodeMaker + "',getdate()" + "," + HSourceID2 + "," + HSourceID3 + "," + HSourceID4 + "," + HSourceID5 +
                    "," + HSupID + "," + HQty + "," + HPrice + "," + HMoney + "," + HBadCount + "," + HCenterID + "," + HProcNo + ",'" + HOrderProcNO + "'" + ",'" + HSourceNameList + "'" +
                    "," + HMainSourceInterID + ",'" + HMainSourceBillNo + "','" + HMainSourceBillType + "'," + Convert.ToString(HLastSubProc ? 1 : 0) +
                    "," + HEmpID2 + "," + HEmpID3 + "," + HEmpID4 + "," + HEmpID5 + "," + HDSQty + "," + HChongQty + "," + HPriceRate + "," + HWorkTimes + "," + HQCCheckID +
                    ") ");
                }
                else if ("Modify".Equals(eventType))
                {
                    oCN.RunProc("UpDate Sc_StationOutBillMain set  " +
                    "HUpDater='" + HMaker + "'" +
                    ",HUpDateDate=getdate()" +
                    ",HSourceName='" + HSourceName + "'" +
                    ",HRemark='" + HRemark + "'" +
                    ",HQCCheckID=" + HQCCheckID +
                    ",HEmpID=" + HEmpID +
                    ",HEmpID2=" + HEmpID2 +
                    ",HEmpID3=" + HEmpID3 +
                    ",HEmpID4=" + HEmpID4 +
                    ",HEmpID5=" + HEmpID5 +
                    ",HSourceID=" + HSourceID +
                    ",HSourceID2=" + HSourceID2 +
                    ",HSourceID3=" + HSourceID3 +
                    ",HSourceID4=" + HSourceID4 +
                    ",HSourceID5=" + HSourceID5 +
                    ",HPayProcID=" + HPayProcID +
                    ",HWorkTimes=" + HWorkTimes +
                    ",HSaveBillFlag=0 " +
                    ",HPieceQty=" + HPieceQty +
                    ",HQty=" + HQty +
                    ",HDSQty=" + HDSQty +
                    ",HChongQty=" + HChongQty +
                    ",HMouldNum='" + HMouldNum + "'" +
                    ",HSourceNameList='" + HSourceNameList + "'" +
                    ",HWasterQty=" + HWasterQty +
                    ",HLastSubProc=" + Convert.ToString(HLastSubProc ? 1 : 0) +
                    " where HInterID=" + HInterID);
                }
                else
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "操作类型无效！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //主表
                oCN.RunProc("Insert Into Sc_StationInBillMain " +
                "(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" +
                ",HYear,HPeriod,HRemark" +
                ",HICMOInterID,HICMOBillNo,HProcPlanInterID,HProcPlanEntryID,HProcPlanBillNo,HProcExchInterID,HProcExchEntryID" +
                ",HProcExchBillNo,HMaterID,HProcID,HICMOQty,HPlanQty,HStationInTime,HSourceID" +
                ",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate" +
                ",HSupID,HQty,HPrice,HMoney,HPieceQty,HSourceName,HCenterID" +
                ",HProcNo,HOrderProcNO" +
                ") " +
                " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate()" +
                "," + HYear + "," + HPeriod + ",'" + HRemark + "'" +
                "," + HICMOInterID + ",'" + HICMOBillNo + "'," + HProcPlanInterID + "," + HProcPlanEntryID + ",'" + HProcPlanBillNo + "'," + HProcExchInterID + "," + HProcExchEntryID +
                ",'" + HProcExchBillNo + "'," + HMaterID + "," + HProcID + "," + HICMOQty + "," + HPlanQty + ",getdate()," + HSourceID +
                "," + HGroupID + "," + HDeptID + "," + HEmpID + ",'" + HBarCode + "','" + HAddr + "','" + HBarCodeMaker + "',getdate()" +
                "," + HSupID + "," + HQty + "," + HPrice + "," + HMoney + "," + HPieceQty + ",'" + HSourceName + "'," + HCenterID +
                ",'" + HProcNo + "','" + HOrderProcNO + "'" +
              ") ");
                ds = oCN.RunProcReturn("exec h_p_MES_StationInBill_QtyCtrl " + HInterID + "", "h_p_MES_StationInBill_QtyCtrl");

                ds = oCN.RunProcReturn("exec h_p_MES_StationOutBill_QtyCtrl " + HInterID + "", "h_p_MES_StationOutBill_QtyCtrl");
                if (ds == null)
                {
                    oCN.RollBack();
@@ -118,21 +339,23 @@
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
                    objJsonResult.Message = "数量控制," + ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_In " + HInterID + ",1");
                //判断是否是 首道工序
                oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_Out " + HInterID + ",1");
                oCN.RunProc("exec h_p_Mes_ProcessExchangeChangeStatus  " + HInterID + " ");
                oCN.RunProc("exec h_p_Mes_StationOutBillBackBarCode  " + HInterID + " ");
                //判断是否是 末道工序 
                ds1 = oCN.RunProcReturn(" select HLastProc,HFstProc from Sc_ProcessExchangeBillMain a  " +
                                    " inner join Sc_ProcessExchangeBillSub b on a.HInterID=b.HInterID  " +
                                    " Where a.HInterID=" + HProcExchInterID + " and b.HEntryID=" + HProcExchEntryID + " ", "Sc_ProcessExchangeBillMain");
                if (ds1 == null || ds1.Tables[0].Rows.Count == 0)
                if (ds1 == null || ds1.Tables[0].Rows.Count == 0 || HLastSubProc == false)
                {
                    

                }
                else if (ClsPub.isStrNull(ds1.Tables[0].Rows[0]["HFstProc"]) == "是")
                { 
                else if (ClsPub.isStrNull(ds1.Tables[0].Rows[0]["HLastProc"]) == "是")
                {

                }
                oCN.Commit();
@@ -144,7 +367,6 @@
            }
            catch (Exception e)
            {
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
@@ -153,9 +375,18 @@
            }
        }

        private bool AllowbillNo(string HBillNo)
        {
            ds = oCN.RunProcReturn("select HBillNo from Sc_StationOutBillMain where  HBillNo = '" + HBillNo + "'", "Sc_StationOutBillMain");
            if (ds == null || ds.Tables[0].Rows.Count == 0)
            {
                return true;
            }
            return false;
        }

        /// <summary>
        /// 返回工序出站发出单列表
        /// 返回工序出站汇报单列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
@@ -202,7 +433,177 @@
            }
        }

        /// <summary>
        /// 编辑页面根据id获取工序出站汇报单信息
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Cj_StationOutBill/GetStationOutBill")]
        [HttpGet]
        public object GetStationOutBill(int HInterID)
        {
            try
            {
                ds = oCN.RunProcReturn("select * from h_v_GetStationOutBill where HInterID = " + HInterID, "h_v_GetStationOutBill");
                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;
            }
        }


        //


        [Route("Cj_StationOutBill/UploadFile")]
        [HttpPost]
        public object UploadFile()
        {
            try
            {
                int num = 0;
                string HBillNo = HttpContext.Current.Request.Params["HBillNo"];  //单据号
                string HRemark = HttpContext.Current.Request.Params["HRemark"];  //备注
                string HUserName = HttpContext.Current.Request.Params["HUserName"];  //单据号
                string uploadPath = HttpContext.Current.Server.MapPath("~/App_Data/");
                HttpRequest request = System.Web.HttpContext.Current.Request;
                HttpFileCollection files = request.Files;
              
                string savePath = "";
                if (files == null || files.Count <= 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "文件不能为空！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    for (int i = 0; i < files.Count; i++)
                    {
                   
                        // 获取文件
                        HttpPostedFile httpPostedFile = files[i];

                        string filePath = Path.GetFullPath(httpPostedFile.FileName);//文件上传路径
                        string fileExtension = Path.GetExtension(httpPostedFile.FileName);// 文件扩展名
                        string filename = httpPostedFile.FileName;
                        string fileSavePath = uploadPath;// 上传保存路径
                        int filesize = files[i].ContentLength;//获取上传文件的大小单位为字节byte
                        int Maxsize = 40000 * 1024;//定义上传文件的最大空间大小为40M
                        if (filesize >= Maxsize)
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "上传文件超过40M，不能上传！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        if (Directory.Exists(fileSavePath) == false)//如果不存在就创建file文件夹
                        {
                            Directory.CreateDirectory(fileSavePath); //添加文件夹
                        }
                        savePath = Path.Combine(fileSavePath, filename);
                        //查询文件关联表,是否已存在上传数据
                        ds = oCN.RunProcReturn("select * from MES_AccessoriesList where HSourceBillNo = " + HBillNo, "MES_AccessoriesList");
                        if (ds == null || ds.Tables[0].Rows.Count == 0)
                        {
                            //写入服务器文件
                            httpPostedFile.SaveAs(savePath);
                            //写入数据表
                            oCN.RunProc("Insert into MES_AccessoriesList (HFileName,HFilePath,HFilePath_Cus,HFileType" +
                                        ",HLoadMan,HLoadDate,HRemark,HVerNum,HFileSize" +
                                        ",HFileClsID,HSourceBillNo" +
                                       ") values('"
                                        + filename.ToString() + "','" + savePath.ToString() + "','" + filePath.ToString() + "','" + fileExtension.ToString()+ "'" +
                                        ",'" + HUserName + "',getdate(),'" + HRemark + "','V1','" + filesize +
                                        "','" + 0 + "','" + HBillNo +
                                       "') ");
                        }
                        else 
                        {
                            //删除服务器文件
                            FileInfo file = new FileInfo(HttpContext.Current.Server.MapPath(savePath));
                            file.Delete();
                            //删除数据表数据
                            ds = oCN.RunProcReturn("delete from MES_AccessoriesList where HSourceBillNo =  " + HBillNo, "MES_AccessoriesList");

                            //写入服务器文件
                            httpPostedFile.SaveAs(savePath);
                            //写入数据表
                            //写入数据表
                            oCN.RunProc("Insert into MES_AccessoriesList (HFileName,HFilePath,HFilePath_Cus,HFileType" +
                                       ",HLoadMan,HLoadDate,HRemark,HVerNum,HFileSize" +
                                       ",HFileClsID,HSourceBillNo" +
                                      ") values('"
                                       + filename.ToString() + "','" + savePath.ToString() + "','" + filePath.ToString() + "','" + fileExtension.ToString() + "'" +
                                       ",'" + HUserName + "',getdate(),'" + HRemark + "','V1','" + filesize +
                                       "','" + 0 + "','" + HBillNo +
                                      "') ");
                        }
                        //if (Directory.Exists(savePath) == true)  //如果存在重名文件就提示  
                        //{
                        //    objJsonResult.code = "0";
                        //    objJsonResult.count = 0;
                        //    objJsonResult.Message = "存在同名文件！";
                        //    objJsonResult.data = null;
                        //    return objJsonResult;
                        //}
                        httpPostedFile.SaveAs(savePath);
                        string StrPath = "/File/" + filename;
                        //写入数据表

                        num = num + 1;
                    }
                    if (num == files.Count)
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "上传成功！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    else
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "上传失败！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = e.Message;
                objJsonResult.data = null;
                return objJsonResult;
            }
           
        }
    }
}