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


@@ -4,8 +4,11 @@


using System;


using System.Collections.Generic;


using System.Data;


using System.IO;


using System.Web;


using System.Web.Http;


using WebAPI.Models;




namespace WebAPI.Controllers


{


    public class Sb_EquipDotCheckBillController : ApiController


@@ -15,7 +18,9 @@


        public DBUtility.ClsPub.Enum_BillStatus BillStatus;//单据状态（新增，修改，浏览，更新单价，变更）


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


        public DAL.ClsSb_EquipDotCheckBill BillNew = new DAL.ClsSb_EquipDotCheckBill();   //对应单据类


        public DAL.ClsSb_EquipDotCheckBill BillOld = new DAL.ClsSb_EquipDotCheckBill();   //对应单据类


        public DAL.ClsSb_EquipDotCheckBill BillOld = new DAL.ClsSb_EquipDotCheckBill();   //对应单据类                                            


        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();   //获取系统参数


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




        #region 设备点检记录表




@@ -38,15 +43,34 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }


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




                string sReturn = "";


                string HViewName = "h_v_Sb_EquipDotCheckBillList";//视图命名


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


                {


                    ds = oCN.RunProcReturn("select * from h_v_Sb_EquipDotCheckBillList " + sWhere + " order by hmainid desc", "h_v_Sb_EquipDotCheckBillList");


                    if (oSystemParameter.omodel.WMS_CampanyName == "九菱")


                    {


                        HViewName = "h_v_Sb_EquipDotCheckBillMainList";


                    }


                }


                else


                {


                    string sql1 = "select * from h_v_Sb_EquipDotCheckBillList where 1 = 1";


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "单据读取失败！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




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


                {


                    ds = oCN.RunProcReturn("select * from " + HViewName + " " + sWhere + " order by hmainid desc", HViewName);


                }


                else


                {


                    string sql1 = "select * from " + HViewName + " " + " where 1 = 1";


                    string sql = sql1 + sWhere + " order by hmainid desc";


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


                    ds = oCN.RunProcReturn(sql, HViewName);


                }


                //添加列名


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


@@ -82,6 +106,59 @@


                return objJsonResult;


            }


        }




        #region 设备点检记录分页查询


        [Route("Sb_EquipDotCheckBill/GetEquipDotCheckBillListPage")]


        [HttpGet]


        public object GetEquipDotCheckBillListPage(string sWhere, string user, int page, int size)


        {


            try


            {


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


                //编辑权限


                if (!DBUtility.ClsPub.Security_Log_second("Sb_EquipDotCheckBillList", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无查看权限！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


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


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


                {


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


                }


                else


                {


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


                }




                //添加列名


                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 = "Sucess！";


                objJsonResult.list = columnNameList;


                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 sql语句




@@ -139,6 +216,7 @@


                    //oItem.HBillNo = "";


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


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


                    oItem.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month);


                    //oItem.HMakeDate = "";


                    //oItem.HYear = "";


                    //oItem.HPeriod = "";


@@ -211,7 +289,6 @@


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


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


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


                    objJsonResult.data = 1;


                    return objJsonResult;


                }


@@ -285,7 +362,29 @@


                    return objJsonResult;


                }




                bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);


                //删除前控制


                DataSet BeforeDs = oCN.RunProcReturn("Exec h_p_Sb_EquipDotCheckBill_BeforeDelCtrl " + HInterID.ToString() + ",'" + user + "'", "h_p_Sb_EquipDotCheckBill_BeforeDelCtrl");


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "删除前判断失败！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


                {


                    if (DBUtility.ClsPub.isLong(BeforeDs.Tables[0].Rows[0]["HBack"]) == 1)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "删除失败！" + DBUtility.ClsPub.isStrNull(BeforeDs.Tables[0].Rows[0]["HRemark"]);


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }




                bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Sb_EquipDotCheckBill_AfterDelCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo);


                if (IsDete)


                {


                    objJsonResult.code = "0";


@@ -322,7 +421,7 @@


            if (string.IsNullOrEmpty(HID))


                return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };


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


            var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sb_EquipDotCheckBillList  where hmainid= " + HID + " ", "h_v_Sb_EquipDotCheckBillList");


            var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sb_EquipDotCheckBill_Edit2  where hmainid= " + HID + " ", "h_v_Sb_EquipDotCheckBill_Edit2");


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


                return new ApiResult<DataSet> { code = -1, msg = "不存在点检记录表" };


            return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };


@@ -340,7 +439,7 @@


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


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


                {


                    ds = oCN.RunProcReturn("select 点检项目ID HDotCheckItemID,点检项目代码 as HDotCheckCode ,点检项目 HDotCheckItem,点检部位 HDotCheckPart ,具体要求 HClaim,表体备注 HRemark,负责人ID HManagerID,负责人编码 HManagerCode,负责人 HManagerName  from h_v_Sb_EquipDotCheckBillList", "h_v_Sb_EquipDotCheckBillList");


                    ds = oCN.RunProcReturn("select * from h_v_Sb_EquipDotCheckBill_Edit", "h_v_Sb_EquipDotCheckBill_Edit");


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


@@ -348,9 +447,9 @@


                }


                else


                {


                    string sql1 = "select 点检项目ID HDotCheckItemID,点检项目代码 as HDotCheckCode ,点检项目 HDotCheckItem,点检部位 HDotCheckPart,具体要求 HClaim,表体备注 HRemark,负责人ID HManagerID,负责人编码 HManagerCode,负责人 HManagerName  from h_v_Sb_EquipDotCheckBillList where 1 = 1 ";


                    string sql1 = "select * from h_v_Sb_EquipDotCheckBill_Edit where 1 = 1 ";


                    string sql = sql1 + sqlWhere;


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


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


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


@@ -369,13 +468,8 @@


        #endregion












        #endregion






        #region 设备点检记录单PDA




        #region 根据设备条码查找设备档案信息PDA


        [Route("Sb_PDA_EquipDotCheckBill/txtHBarCode_KeyDown")]


@@ -394,6 +488,49 @@


                }


                //得到信息


                ds = oCN.RunProcReturn("select top 1 * from Gy_EquipFileBillMain  where HEquipFileNumber= '" + HBarCode + "'", "Gy_EquipFileBillMain");


                //写入信息


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "未查询到设备信息！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                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 根据设备条码查找设备档案信息PDA  查询条码档案列表


        [Route("Sb_PDA_EquipDotCheckBill/txtHBarCode_KeyDown_List")]


        [HttpGet]


        public object txtHBarCode_KeyDown_List(string HBarCode)


        {


            try


            {


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //得到信息


                ds = oCN.RunProcReturn("select top 1 * from h_v_Gy_EquipFileMainList  where 条形码= '" + HBarCode + "'", "h_v_Gy_EquipFileMainList");


                //写入信息


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


                {


@@ -506,8 +643,8 @@


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


                    oItemSub.HCloseType = false;   //关闭类型


                    //oItemSub.HRemark = "";         //备注


                    oItemSub.HSourceInterID = 0;     // 源单主内码


                    oItemSub.HSourceEntryID = 0;   //源单子内码


                    //oItemSub.HSourceInterID = 0;     // 源单主内码


                    //oItemSub.HSourceEntryID = 0;   //源单子内码


                    //oItemSub.HSourceBillNo = "";  //源单单号


                    //oItemSub.HSourceBillType = ""; //源单类型


                    //oItemSub.HRelationQty = 0;     //关联数量


@@ -591,29 +728,71 @@


                //Type 1 审核  2  反审核


                if (Type == 1)


                {


                    if (!BillOld.CheckBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))


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


                    string sql1 = "exec h_p_Sb_EquipDotCheckBill_BeforeCheckCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";


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


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        oCN.RollBack();


                        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;


                        oCN.RollBack();


                        return objJsonResult;


                    }


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




                    if (!BillOld.CheckBill(int.Parse(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipDotCheckBill_AfterCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    }                 


                }


                else


                {


                    if (BillOld.AbandonCheck(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))


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


                    string sql1 = "exec h_p_Sb_EquipDotCheckBill_BeforeUnCheckCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";


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


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


                    {


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


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;




                    }


                    else


                    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.AbandonCheck(int.Parse(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipDotCheckBill_AfterUnCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    }                   


                }




                oCN.Commit();//提交事务


@@ -669,22 +848,86 @@


                //Type 1 关闭  2  反关闭


                if (Type == 1)


                {


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


                    string sql = "";


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


                    sql = "exec h_p_Sb_EquipDotCheckBill_BeforeCloseCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";


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


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "关闭失败!原因:关闭前前判断失败，无返回信息，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;




                    }


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


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




                    //关闭提交


                    if (BillOld.CloseBill(Convert.ToInt32(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipDotCheckBill_AfterCloseCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    {


                        objJsonResult.code = "1";


                        objJsonResult.count = 1;


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


                        objJsonResult.Message = "关闭成功";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    else


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


                else


                {


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


                    string sql = "";


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


                    sql = "exec h_p_Sb_EquipDotCheckBill_BeforeUnCloseCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";


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


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "反关闭失败!原因:反关闭前前判断失败，无返回信息，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;




                    }


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


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




                    //反关闭提交


                    if (BillOld.CancelClose(Convert.ToInt32(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipDotCheckBill_AfterUnCloseCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    {


                        objJsonResult.code = "1";


                        objJsonResult.count = 1;


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


                        objJsonResult.Message = "反关闭成功";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    else


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -710,7 +953,242 @@


        }


        #endregion




        #region 设备点检逾期预警报表




        [Route("Sb_EquipDotCheckWarning/Report")]


        [HttpGet]


        public object Report(string HYear,string HMonth,string HEquipTypeID, string user)


        {


            try


            {


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


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


                //{


                //    objJsonResult.code = "0";


                //    objJsonResult.count = 0;


                //    objJsonResult.Message = "没有查看权限";


                //    objJsonResult.data = null;


                //    return objJsonResult;


                //}


                if (HYear == null || HYear.Equals("") || HMonth == null || HMonth.Equals(""))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "请选择有效年份，月份";


                    objJsonResult.data = "";


                    objJsonResult.list = columnNameList;


                    return objJsonResult;


                }


                else


                {


                    string sql = "exec h_p_Sb_EquipDotCheckWarningReport " + HYear + "," + HMonth + "," + HEquipTypeID;


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


                }




                //添加列名


                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 = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




        #region 设备点检记录拍照上传


        [Route("Sb_EquipDotCheckBill/UploadFile")]


        [HttpPost]


        public object UploadFile()


        {




            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/EquipFolder/" + 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/EquipFolder/" + 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/EquipFolder/" + 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("Sb_EquipDotCheckBill/Filelist")]


        [HttpGet]


        public object Filelist(string HBillNo)


        {


            var url = fileip + "/files/EquipFolder/" + 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("Sb_EquipDotCheckBill/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/EquipFolder/" + HSourceBillNo), HFileName);


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


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "删除成功！";


                objJsonResult.data = null;


                return objJsonResult;


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion       


    }


}