From dbedc3b6b40a3c8ec3caf5639fd083ba7a3fadce Mon Sep 17 00:00:00 2001
From: yxj <1qaz@123>
Date: 星期三, 16 十一月 2022 20:30:57 +0800
Subject: [PATCH] 条码生成模块增加选源单工序汇报单生成条码，新增生产入库、销售出库扫描源单方法，新增扫描物料条码方法，返回单据列表信息方法
---
WebAPI/Controllers/基础资料/基础资料/Gy_SOPBillController.cs | 493 ++++++++++++++++++++++++++++++++++--------------------
1 files changed, 308 insertions(+), 185 deletions(-)
diff --git "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_SOPBillController.cs" "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_SOPBillController.cs"
index 4f59850..d315210 100644
--- "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_SOPBillController.cs"
+++ "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_SOPBillController.cs"
@@ -1,18 +1,19 @@
-锘縰sing NPOI.HSSF.UserModel;
+锘縰sing Newtonsoft.Json.Linq;
+using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using Pub_Class;
using System;
+using System.Collections.Generic;
using System.Data;
+using System.IO;
using System.Net;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Runtime.InteropServices;
+using System.Web;
using System.Web.Http;
using System.Windows.Forms;
using WebAPI.Models;
-//using Excel = Microsoft.Office.Interop.Excel;
-
-
namespace WebAPI.Controllers.鍩虹璧勬枡.鍩虹璧勬枡
{
public class Gy_SOPBillController : ApiController
@@ -22,223 +23,345 @@
private json objJsonResult = new json();
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
DataSet ds;
- DAL.ClsGy_SOPBill oBill = new DAL.ClsGy_SOPBill();
-
+ public DAL.ClsGy_SOPBill BillNew = new DAL.ClsGy_SOPBill();
+ public DAL.ClsGy_SOPBill BillOld = new DAL.ClsGy_SOPBill();
+ public bool BillChange; //
public DataGridView grdMain = new System.Windows.Forms.DataGridView();
+ ClsGridViewSum oSumGrid = new ClsGridViewSum();
- #region 浣滀笟鎸囧涔﹀垪琛�
- [Route("Gy_SOPBill/list")]
- [HttpGet]
- public object getSOPBillList(string sWhere, string user)
+ //瀹氫箟
+ public const Int16 HTagCol = 0;
+ public const Int16 HSnoCol = 1;
+ public const Int16 HProcNoCol = 2;
+ public const Int16 HProcIDCol = 3;
+ public const Int16 HProcNumberCol = 4;
+ public const Int16 HProcNameCol = 5;
+ public const Int16 HWorkStationIDCol = 6;
+ public const Int16 HWorkStationNumberCol = 7;
+ public const Int16 HWorkStationNameCol = 8;
+ public const Int16 HCenterIDCol = 9;
+ public const Int16 HCenterNumberCol = 10;
+ public const Int16 HCenterNameCol = 11;
+ public const Int16 HRemarkCol = 12;
+ public const Int16 HEntryIDCol = 13;
+
+ DAL.ClsIF_Material_View oMater = new DAL.ClsIF_Material_View();
+ DAL.ClsIF_Unit_View oUnit = new DAL.ClsIF_Unit_View();
+ DAL.ClsIF_Process_View oProc = new DAL.ClsIF_Process_View();
+ DAL.ClsGy_WorkStation_View oStation = new DAL.ClsGy_WorkStation_View();
+ DAL.ClsGy_WorkCenter_View oCenter = new DAL.ClsGy_WorkCenter_View();
+
+ #region 璇诲啓绫�
+ //鏄剧ず鍗曟嵁
+ public void Sub_ShowBill()
+ {
+ DAL.ClsIF_Material_View oMater = new DAL.ClsIF_Material_View();
+ DAL.ClsIF_Unit_View oUnit = new DAL.ClsIF_Unit_View();
+ DAL.ClsIF_Process_View oProc = new DAL.ClsIF_Process_View();
+ DAL.ClsGy_WorkStation_View oStation = new DAL.ClsGy_WorkStation_View();
+ DAL.ClsGy_WorkCenter_View oCenter = new DAL.ClsGy_WorkCenter_View();
+ //ClsGy_SourceHlp oSource = new ClsGy_SourceHlp();
+ //鍒ゆ柇鏄惁瀛樺湪鍗曟嵁
+ if (BillOld.ShowBill(BillOld.omodel.HInterID, ref ClsPub.sExeReturnInfo) == false)
+ {
+ MessageBox.Show(ClsPub.sExeReturnInfo, "鎻愮ず");
+ return;
+ }
+ //grid绂佹鍒锋柊
+
+
+ //鍔犺浇琛ㄤ綋
+ int i = 0;
+ foreach (Model.ClsGy_SOPBillSub oSub in BillOld.DetailColl)
+ {
+ if (i >= grdMain.RowCount - 1)
+ grdMain.Rows.Add();
+ grdMain.Rows[i].Cells[HTagCol].Value = "*";
+
+ grdMain.Rows[i].Cells[HProcIDCol].Value = oSub.HProcID.ToString();
+ if (oProc.GetInfoByID(oSub.HProcID))
+ {
+ grdMain.Rows[i].Cells[HProcNumberCol].Value = oProc.omodel.HNumber;
+ grdMain.Rows[i].Cells[HProcNameCol].Value = oProc.omodel.HName;
+ }
+ else
+ {
+ grdMain.Rows[i].Cells[HProcNumberCol].Value = "";
+ grdMain.Rows[i].Cells[HProcNameCol].Value = "";
+ }
+ //
+ grdMain.Rows[i].Cells[HCenterIDCol].Value = oSub.HCenterID.ToString();
+ if (oCenter.GetInfoByID(oSub.HCenterID))
+ {
+ grdMain.Rows[i].Cells[HCenterNumberCol].Value = oCenter.omodel.HNumber;
+ grdMain.Rows[i].Cells[HCenterNameCol].Value = oCenter.omodel.HName;
+ }
+ else
+ {
+ grdMain.Rows[i].Cells[HCenterNameCol].Value = "";
+ grdMain.Rows[i].Cells[HCenterNumberCol].Value = "";
+ }
+ //
+ grdMain.Rows[i].Cells[HWorkStationIDCol].Value = oSub.HWorkStationID.ToString();
+ if (oStation.GetInfoByID(oSub.HWorkStationID))
+ {
+ grdMain.Rows[i].Cells[HWorkStationNumberCol].Value = oStation.omodel.HNumber;
+ grdMain.Rows[i].Cells[HWorkStationNameCol].Value = oStation.omodel.HName;
+ }
+ else
+ {
+ grdMain.Rows[i].Cells[HWorkStationNumberCol].Value = "";
+ grdMain.Rows[i].Cells[HWorkStationNameCol].Value = "";
+ }
+ //
+ grdMain.Rows[i].Cells[HProcNoCol].Value = oSub.HProcNo.ToString();
+
+ grdMain.Rows[i].Cells[HRemarkCol].Value = oSub.HRemark;
+ grdMain.Rows[i].Cells[HEntryIDCol].Value = oSub.HEntryID;
+ i = i + 1;
+ }
+ //GRID鍏佽鍒锋柊
+ DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
+ //
+ //Sub_OperStatus();
+ }
+ #endregion
+
+
+ #region 淇濆瓨鍗曟嵁
+ [Route("Gy_SOPBill/ModifyByID")]
+ [HttpPost]
+ public object Sub_SaveBill([FromBody] JObject oMain)
{
try
{
- //鏌ョ湅鏉冮檺
- //if (!DBUtility.ClsPub.Security_Log("Gy_SOPBillMain", 1, false, user))
+ var _value = oMain["oMain"].ToString();
+ string msg1 = _value.ToString();
+ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
+ string msg2 = sArray[0].ToString();
+ string msg3 = sArray[1].ToString();//褰撳墠浜�
+
+ //鍙嶅簭鍒楀寲
+ msg2 = "[" + msg2.ToString() + "]";
+
+ List<SOPBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<SOPBill>>(msg2);
+
+ string HBillNo = list[0].HBillNo;
+ DateTime HDate = list[0].HDate;
+ string HName = list[0].HName;
+ int HMaterID = list[0].HMaterID;
+ string HMaterNumber = list[0].HMaterNumber;
+ string HMaterName = list[0].HMaterName;
+ string HMaterModel = list[0].HMaterModel;
+ int HUnitID = list[0].HUnitID;
+ string HUnitNumber = list[0].HUnitNumber;
+ string HUnitName = list[0].HUnitName;
+ string HRemark = list[0].HRemark;
+ bool HStandard = list[0].HStandard;
+ bool HUse = list[0].HUse;
+
+ //鍒ゆ柇鏉冮檺
+ //if (!ClsPub.Security_Log("Gy_Repair_Edit", 1, false, msg3))
//{
// objJsonResult.code = "0";
// objJsonResult.count = 0;
- // objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒";
+ // objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒";
// objJsonResult.data = null;
// return objJsonResult;
//}
- if (sWhere == null || sWhere.Equals(""))
- {
- ds = oCN.RunProcReturn("select * from h_v_Gy_SOPBillList order by hmainid ", "h_v_Gy_SOPBillList");
- }
- else
- {
- string sql1 = "select * from h_v_Gy_SOPBillList where 1 = 1 ";
- string sql = sql1 + sWhere + " order by hmainid ";
- ds = oCN.RunProcReturn(sql, "h_v_Gy_SOPBillList");
- }
+ //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙�
+ oCN.BeginTran();
+ //涓昏〃
+ oCN.RunProc("Insert Into Gy_SOPBillMain " +
+ "(HBillType,HInterID,HBillNo,HDate" +
+ ",HYear,HPeriod,HRemark,HMaker,Hmakedate,HMaterID,HName,HMaterTypeID" +
+ ",HUnitID,HMaterNumber,HUnitNumber,HStandard" +
+ ") " +
+ " values('" + 3305 + "'," + HMaterID + ",'" + HMaterID + "','" + "2022-11-04" + "'" +
+ "," + 2022 + "," + 11 + ",'" + HRemark + "','" + "Test" + "'," + "2022-11-04" + "," + HMaterID.ToString() + ",'" + HName + "'," + 656 +
+ "," + HUnitID.ToString() + ",'" + HMaterNumber + "','" + HUnitNumber + "','" + HStandard.ToString() +
+ "') ");
+ //" values(" + 3305 + "','" + 12333 + "','" + "test" + "','" + HDate + "','" +
+ //2022 + "','" + 11 + "','" + HRemark + "','" + "Test" + "','" + "2022-11-04" + "','" + HMaterID.ToString() + "','" + HName + "','" + "656" +
+ //"','" + HUnitID.ToString() + "','" + HMaterNumber + "','" + HUnitNumber + "','" + HStandard.ToString() +
+ //") ");
+ //淇敼涓婄骇涓洪潪鏈骇浠ｇ爜
+ //oCN.RunProc("Update Gy_MouldType set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
- //if (ds.Tables[0].Rows.Count != 0 || ds != null)
- //{
+ oCN.Commit();
objJsonResult.code = "1";
objJsonResult.count = 1;
- objJsonResult.Message = "Sucess锛�";
- objJsonResult.data = ds.Tables[0];
+ objJsonResult.Message = "鏂板鎴愬姛锛�";
return objJsonResult;
- //}
- //else
- //{
- //objJsonResult.code = "0";
- //objJsonResult.count = 0;
- //objJsonResult.Message = "鏃犳暟鎹�";
- //objJsonResult.data = null;
- //return objJsonResult;
- //}
}
catch (Exception e)
{
+ oCN.RollBack();
objJsonResult.code = "0";
objJsonResult.count = 0;
- objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.Message = "Exception锛�" + e.Message;
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
- #region 寮曞嚭
- [Route("Gy_SOPBill/SetExcel")]
- [HttpGet]
- public HttpResponseMessage Sc_StationInBillSetExcel(string sWhere)
- {
- HSSFWorkbook workbook = new HSSFWorkbook();
- ISheet sheet = workbook.CreateSheet("sheet1");
- IRow row = sheet.CreateRow(0);
-
-
- row.CreateCell(0).SetCellValue("鍗曟嵁鍙�");
- row.CreateCell(1).SetCellValue("鍗曟嵁绫诲瀷");
- row.CreateCell(2).SetCellValue("宸ヨ壓鍚嶇О");
- row.CreateCell(3).SetCellValue("鐗╂枡浠ｇ爜");
- row.CreateCell(4).SetCellValue("鐗╂枡鍚嶇О");
- row.CreateCell(5).SetCellValue("瑙勬牸鍨嬪彿");
- row.CreateCell(6).SetCellValue("璁￠噺鍗曚綅浠ｇ爜");
- row.CreateCell(7).SetCellValue("璁￠噺鍗曚綅");
- row.CreateCell(8).SetCellValue("榛樿鎸囧涔�");
- row.CreateCell(9).SetCellValue("琛ㄥご澶囨敞");
- row.CreateCell(10).SetCellValue("宸ュ簭鍙�");
- row.CreateCell(11).SetCellValue("宸ュ簭浠ｇ爜");
- row.CreateCell(12).SetCellValue("宸ュ簭");
- row.CreateCell(13).SetCellValue("宸ヤ綔涓績浠ｇ爜");
- row.CreateCell(14).SetCellValue("宸ヤ綔涓績鍚嶇О");
- row.CreateCell(15).SetCellValue("宸ヤ綅浠ｇ爜");
- row.CreateCell(16).SetCellValue("宸ヤ綅");
- row.CreateCell(17).SetCellValue("琛ㄤ綋澶囨敞");
- row.CreateCell(18).SetCellValue("浣跨敤鏍囪");
- row.CreateCell(19).SetCellValue("鍚敤浜�");
- row.CreateCell(20).SetCellValue("鍚敤鏃ユ湡");
- row.CreateCell(21).SetCellValue("鍒跺崟浜�");
- row.CreateCell(22).SetCellValue("鍒跺崟鏃ユ湡");
- row.CreateCell(23).SetCellValue("瀹℃牳浜�");
- row.CreateCell(24).SetCellValue("瀹℃牳鏃ユ湡");
- row.CreateCell(25).SetCellValue("淇敼浜�");
- row.CreateCell(26).SetCellValue("淇敼鏃ユ湡");
- row.CreateCell(27).SetCellValue("浣滃簾浜�");
- row.CreateCell(28).SetCellValue("浣滃簾鏃ユ湡");
-
-
- //绮剧‘鎺у埗鍒楀
- sheet.SetColumnWidth(1, 5000);
- sheet.SetColumnWidth(2, 5000);
- sheet.SetColumnWidth(3, 5000);
- sheet.SetColumnWidth(4, 5000);
- sheet.SetColumnWidth(5, 5000);
- sheet.SetColumnWidth(6, 5000);
- sheet.SetColumnWidth(7, 5000);
- sheet.SetColumnWidth(8, 5000);
- sheet.SetColumnWidth(9, 5000);
- sheet.SetColumnWidth(10, 5000);
- sheet.SetColumnWidth(11, 5000);
- sheet.SetColumnWidth(12, 5000);
- sheet.SetColumnWidth(13, 5000);
- sheet.SetColumnWidth(14, 5000);
- sheet.SetColumnWidth(15, 5000);
- sheet.SetColumnWidth(16, 5000);
- sheet.SetColumnWidth(17, 5000);
- sheet.SetColumnWidth(18, 5000);
- sheet.SetColumnWidth(19, 5000);
- sheet.SetColumnWidth(20, 5000);
- sheet.SetColumnWidth(21, 5000);
- sheet.SetColumnWidth(22, 5000);
- sheet.SetColumnWidth(23, 5000);
- sheet.SetColumnWidth(24, 5000);
- sheet.SetColumnWidth(25, 5000);
- sheet.SetColumnWidth(26, 5000);
- sheet.SetColumnWidth(27, 5000);
- sheet.SetColumnWidth(28, 5000);
- sheet.SetColumnWidth(29, 5000);
-
-
- DataSet ds = oCN.RunProcReturn("select * from h_v_Gy_SOPBillList" + sWhere + " order by hmainid desc", "h_v_Gy_SOPBillList");
- for (var i = 0; i < ds.Tables[0].Rows.Count; i++)
- {
- IRow row1 = sheet.CreateRow(i + 1);
- row1.CreateCell(0).SetCellValue(ds.Tables[0].Rows[i]["鍗曟嵁鍙�"].ToString());
- row1.CreateCell(1).SetCellValue(ds.Tables[0].Rows[i]["鍗曟嵁绫诲瀷"].ToString());
- row1.CreateCell(2).SetCellValue(ds.Tables[0].Rows[i]["宸ヨ壓鍚嶇О"].ToString());
- row1.CreateCell(3).SetCellValue(ds.Tables[0].Rows[i]["鐗╂枡浠ｇ爜"].ToString());
- row1.CreateCell(4).SetCellValue(ds.Tables[0].Rows[i]["鐗╂枡鍚嶇О"].ToString());
- row1.CreateCell(5).SetCellValue(ds.Tables[0].Rows[i]["瑙勬牸鍨嬪彿"].ToString());
- row1.CreateCell(6).SetCellValue(ds.Tables[0].Rows[i]["璁￠噺鍗曚綅浠ｇ爜"].ToString());
- row1.CreateCell(7).SetCellValue(ds.Tables[0].Rows[i]["璁￠噺鍗曚綅"].ToString());
- row1.CreateCell(8).SetCellValue(ds.Tables[0].Rows[i]["榛樿鎸囧涔�"].ToString());
- row1.CreateCell(9).SetCellValue(ds.Tables[0].Rows[i]["琛ㄥご澶囨敞"].ToString());
- row1.CreateCell(10).SetCellValue(ds.Tables[0].Rows[i]["宸ュ簭鍙�"].ToString());
- row1.CreateCell(11).SetCellValue(ds.Tables[0].Rows[i]["宸ュ簭浠ｇ爜"].ToString());
- row1.CreateCell(12).SetCellValue(ds.Tables[0].Rows[i]["宸ュ簭"].ToString());
- row1.CreateCell(13).SetCellValue(ds.Tables[0].Rows[i]["宸ヤ綔涓績浠ｇ爜"].ToString());
- row1.CreateCell(14).SetCellValue(ds.Tables[0].Rows[i]["宸ヤ綔涓績鍚嶇О"].ToString());
- row1.CreateCell(15).SetCellValue(ds.Tables[0].Rows[i]["宸ヤ綅浠ｇ爜"].ToString());
- row1.CreateCell(16).SetCellValue(ds.Tables[0].Rows[i]["宸ヤ綅"].ToString());
- row1.CreateCell(17).SetCellValue(ds.Tables[0].Rows[i]["琛ㄤ綋澶囨敞"].ToString());
- row1.CreateCell(18).SetCellValue(ds.Tables[0].Rows[i]["浣跨敤鏍囪"].ToString());
- row1.CreateCell(19).SetCellValue(ds.Tables[0].Rows[i]["鍚敤浜�"].ToString());
- row1.CreateCell(20).SetCellValue(ds.Tables[0].Rows[i]["鍚敤鏃ユ湡"].ToString());
- row1.CreateCell(21).SetCellValue(ds.Tables[0].Rows[i]["鍒跺崟浜�"].ToString());
- row1.CreateCell(22).SetCellValue(ds.Tables[0].Rows[i]["鍒跺崟鏃ユ湡"].ToString());
- row1.CreateCell(23).SetCellValue(ds.Tables[0].Rows[i]["瀹℃牳浜�"].ToString());
- row1.CreateCell(24).SetCellValue(ds.Tables[0].Rows[i]["瀹℃牳鏃ユ湡"].ToString());
- row1.CreateCell(25).SetCellValue(ds.Tables[0].Rows[i]["淇敼浜�"].ToString());
- row1.CreateCell(26).SetCellValue(ds.Tables[0].Rows[i]["淇敼鏃ユ湡"].ToString());
- row1.CreateCell(27).SetCellValue(ds.Tables[0].Rows[i]["浣滃簾浜�"].ToString());
- row1.CreateCell(28).SetCellValue(ds.Tables[0].Rows[i]["浣滃簾鏃ユ湡"].ToString());
-
- }
- System.IO.MemoryStream ms = new System.IO.MemoryStream();
- workbook.Write(ms);
- ms.Position = 0;
-
- var response = new HttpResponseMessage(HttpStatusCode.OK);
- response.Content = new StreamContent(ms);
-
- response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");
- var fileName = "浣滀笟鎸囧涔﹀垪琛�.xls";
-
- response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
- {
- FileName = System.Web.HttpUtility.UrlEncode(fileName)
- };
- return response;
- }
- #endregion
-
-
- //
- private Int32 Fun_GetCol(string sCol)
- {
- return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
- }
- #region 浣跨敤
- [Route("Gy_SOPBill/BatchUse")]
+ [Route("Gy_SOPBill/Use")]
[HttpGet]
public object sy_Click()
{
- long sOldInterID = 0;
- for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++)
+ if (BillOld.omodel.HInterID == 0)
{
- long HInterID = DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("HMainID")].Value);
- if (HInterID == 0 || HInterID == sOldInterID)
+ objJsonResult.Message = "浣跨敤澶辫触!褰撳墠浣滀笟鎸囧涔︿笉鏄祻瑙堢姸鎬�!";
+ return objJsonResult;
+ }
+ if (BillOld.Sub_RoutingCheckAndUsed(BillOld.omodel.HInterID))
+ {
+ objJsonResult.count = 1;
+ objJsonResult.Message = "浣跨敤鎴愬姛!";
+ return objJsonResult;
+ }
+ else
+ {
+ objJsonResult.Message = "浣跨敤澶辫触!";
+ return objJsonResult;
+ }
+ }
+
+ [Route("Gy_SOPBill/Cancel")]
+ [HttpGet]
+ public object fsy_Click()
+ {
+ if (BillOld.omodel.HInterID == 0)
+ {
+ objJsonResult.Message = "鍙嶄娇鐢ㄥけ璐�!褰撳墠浣滀笟鎸囧涔︿笉鏄祻瑙堢姸鎬�!";
+ return objJsonResult;
+ }
+ if (BillOld.Sub_RoutingUsed_Back(BillOld.omodel.HInterID))
+ {
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍙嶄娇鐢ㄦ垚鍔�!";
+ return objJsonResult;
+ }
+ else
+ {
+ objJsonResult.Message = "鍙嶄娇鐢ㄥけ璐�!";
+ return objJsonResult;
+ }
+ }
+
+ [Route("Gy_SOPBill/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/" + 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)
{
- continue;
+ 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 Gy_SOPBillSub2 where HFileName='" + filename + "'", "Gy_SOPBillSub2");
+ if (Directory.Exists(path))
+ {
+ File.Delete(fileurl); //鍒犻櫎鎸囧畾鏂囦欢
+ files.SaveAs(fileurl);
+ string StrPath = "/files/" + HBillNo + "/" + filename;
+ if (File.Exists(fileurl))
+ {
+ //杩欓噷鍙互鎵ц涓�浜涘叾瀹冪殑鎿嶄綔锛屾瘮濡傛洿鏂版暟鎹簱
+ //鍐欏叆鏁版嵁琛�
+ oCN.RunProc("Insert into Gy_SOPBillSub2 (HFileName,HPath,HFileType" +
+ ",HUpMan,HUpTime,HInterID,HEntryID,HSno,HFileID,HFileSize" +
+ ") values('"
+ + filename.ToString() + "','" + filePath.ToString() + "','" + fileExtension.ToString() + "'" +
+ ",'" + HUserName + "',getdate()" + ",'" + 0 + "','" + 0 + "','" + 0 + "','" + 0 + "','" + 0 +
+ "') ");
+ }
+ else
+ {
+ Result_Ob = new { result = 0, returnval = "涓婁紶澶辫触锛佹鏂囦欢涓烘伓鎰忔枃浠�" };
+ }
}
else
{
- sOldInterID = HInterID;
+ Directory.CreateDirectory(fileSavePath); //娣诲姞鏂囦欢澶�
+ files.SaveAs(fileurl);
+ string StrPath = "/files/" + HBillNo + "/" + filename;
+ if (File.Exists(fileurl))
+ {
+ //杩欓噷鍙互鎵ц涓�浜涘叾瀹冪殑鎿嶄綔锛屾瘮濡傛洿鏂版暟鎹簱
+ //鍐欏叆鏁版嵁琛�
+ oCN.RunProc("Insert into Gy_SOPBillSub2 (HFileName,HPath,HFileType" +
+ ",HUpMan,HUpTime,HInterID,HEntryID,HSno,HFileID,HFileSize" +
+ ") values('"
+ + filename.ToString() + "','" + filePath.ToString() + "','" + fileExtension.ToString() + "'" +
+ ",'" + HUserName + "',getdate()" + ",'" + 111 + "','" + 222 + "','" + 333 + "','" + 444 + "','" + 555 +
+ "') ");
+ }
+ else
+ {
+ Result_Ob = new { result = 0, returnval = "涓婁紶澶辫触锛佹鏂囦欢涓烘伓鎰忔枃浠�" };
+ }
}
- if (!oBill.Sub_RoutingCheckAndUsed(HInterID))
- {
- continue;
- }
+
}
- objJsonResult.count = 1;
- objJsonResult.Message = "鎵归噺浣跨敤瀹屾瘯锛�";
- return objJsonResult;
+ catch (Exception e)
+ {
+ Result_Ob = new { result = 0, returnval = e.Message };
+ }
+ return Result_Ob;
}
- #endregion
+
}
}
\ No newline at end of file
--
Gitblit v1.9.1