From 1a94e0e270668ef1cfbcd5043b72bc6591a50706 Mon Sep 17 00:00:00 2001
From: llj <132905093+newwwwwwtree@users.noreply.github.com>
Date: 星期四, 07 八月 2025 15:18:46 +0800
Subject: [PATCH] 价目表新增审核按钮无效修理bug
---
WebAPI/Controllers/基础资料/基础资料/Gy_SOPBillController.cs | 509 +++++++++++++++++++++++---------------------------------
1 files changed, 212 insertions(+), 297 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 d315210..dc2d10c 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,19 +1,15 @@
-锘縰sing Newtonsoft.Json.Linq;
-using NPOI.HSSF.UserModel;
-using NPOI.SS.UserModel;
+锘縰sing Newtonsoft.Json;
+using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
+using System.Collections;
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.Data.SqlClient;
using System.Web.Http;
-using System.Windows.Forms;
using WebAPI.Models;
+using WebAPI.Service;
+
namespace WebAPI.Controllers.鍩虹璧勬枡.鍩虹璧勬枡
{
public class Gy_SOPBillController : ApiController
@@ -23,344 +19,263 @@
private json objJsonResult = new json();
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
DataSet ds;
- 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();
+ Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
- //瀹氫箟
- 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)
+ /// <summary>
+ /// 杩斿洖鐢熶骇璧勬簮鐢熶骇鐘舵�佸伐鍗曞垪琛�
+ ///鍙傛暟锛歴tring sql銆�
+ ///杩斿洖鍊硷細object銆�
+ /// </summary>
+ [Route("Sc_ICMOBillStatus_Tmp/list")]
+ [HttpGet]
+ public object list(string sWhere, string user)
{
try
{
- 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();//褰撳墠浜�
+ string sql1 = string.Format(@"select * from h_v_Sc_WorkOrderList where 寮�宸ユ爣璁� = 1 and HMainID='" + sWhere + "'");
+
+ ds = oCN.RunProcReturn(sql1, "h_v_Sc_WorkOrderList");
+
- //鍙嶅簭鍒楀寲
- msg2 = "[" + msg2.ToString() + "]";
+ 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;
+ }
+ }
- 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))
+ /// <summary>
+ /// 杩斿洖鏂囦欢娓呭崟鍒楄〃
+ ///鍙傛暟锛歴tring sql銆�
+ ///杩斿洖鍊硷細object銆�
+ /// </summary>
+ [Route("Sc_ICMOBillStatus_Tmp/Filelist")]
+ [HttpGet]
+ public object Filelist(int sWhere)
+ {
+ try
+ {
+ //缂栬緫鏉冮檺
+ //if (!DBUtility.ClsPub.Security_Log_second("Gy_Material", 1, false, user))
//{
// objJsonResult.code = "0";
// objJsonResult.count = 0;
- // objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒";
+ // objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒";
// objJsonResult.data = null;
// return objJsonResult;
//}
+ string sql1 = string.Format(@"select * from h_v_Sc_GetFileList where 鏂囦欢ID = " + sWhere);
- //鑻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);
+ ds = oCN.RunProcReturn(sql1, "h_v_Sc_GetFileList");
- oCN.Commit();
+
objJsonResult.code = "1";
objJsonResult.count = 1;
- objJsonResult.Message = "鏂板鎴愬姛锛�";
+ objJsonResult.Message = "Sucess锛�";
+ objJsonResult.data = ds.Tables[0];
return objJsonResult;
}
catch (Exception e)
{
- oCN.RollBack();
objJsonResult.code = "0";
objJsonResult.count = 0;
- objJsonResult.Message = "Exception锛�" + e.Message;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
- #endregion
- [Route("Gy_SOPBill/Use")]
+
+ /// <summary>
+ /// 杩斿洖褰撳墠鐢熶骇璧勬簮鐢熶骇鐘舵�佷笅鐨勫伐鍗曞垪琛�
+ ///鍙傛暟锛歴tring sql銆�
+ ///杩斿洖鍊硷細object銆�
+ /// </summary>
+ [Route("Sc_ICMOBill/list2")]
[HttpGet]
- public object sy_Click()
+ public object list2(string HSourceID, string user,string HMainID)
{
- if (BillOld.omodel.HInterID == 0)
- {
- 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)
+ var sWhere = "";
+ if (Convert.ToInt32(HMainID) != 0 && HMainID.ToString() != "")
{
- Result_Ob = new { result = 0, returnval = "鏂囦欢涓嶈兘涓虹┖!" };
- return Result_Ob;
+ sWhere += " and HMainID = " + HMainID;
}
- if (filesize >= Maxsize)
+ string sql1 = string.Format(@"select * from h_v_Sc_ICMOBillList_ToSop where 鐘舵�� = '寮�宸�' and HSourceID='" + HSourceID + "'" + sWhere);
+
+ ds = oCN.RunProcReturn(sql1, "h_v_Sc_ICMOBillList_ToSop");
+
+
+ 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>
+ /// 杩斿洖鐢熶骇宸ヤ綅鍒楄〃淇℃伅
+ ///鍙傛暟锛歴tring sql銆�
+ ///杩斿洖鍊硷細object銆�
+ /// </summary>
+ [Route("Gy_SourceWorkStationSet_ToSop/Soplist")]
+ [HttpGet]
+ public object Soplist(string sWhere, string user)
+ {
+ try
+ {
+ List<object> columnNameList = new List<object>();
+
+ string sql1 = string.Format(@"select * from h_v_Gy_SourceWorkStationSetList where 1 = 1");
+ if (sWhere == null || sWhere.Equals(""))
{
- Result_Ob = new { result = 0, returnval = "涓婁紶鏂囦欢瓒呰繃40M锛屼笉鑳戒笂浼狅紒" };
- return Result_Ob;
+ ds = oCN.RunProcReturn(sql1 + sWhere + " order by HItemID ", "h_v_Gy_SourceWorkStationSetList");
+ }
+ else
+ {
+ string sql = sql1 + sWhere + " order by HItemID ";
+ ds = oCN.RunProcReturn(sql, "h_v_Gy_SourceWorkStationSetList");
}
- string fileurl = Path.Combine(fileSavePath, filename);
- if (Directory.Exists(fileurl) == true) //濡傛灉瀛樺湪閲嶅悕鏂囦欢灏辨彁绀�
+ //娣诲姞鍒楀悕
+ foreach (DataColumn col in ds.Tables[0].Columns)
{
- Result_Ob = new { result = 0, returnval = "瀛樺湪鍚屽悕鏂囦欢锛�" };
- return Result_Ob;
+ Type dataType = col.DataType;
+ string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
+ columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞＄殑鍒楀悕
}
- //鍒犻櫎鏁版嵁琛ㄦ暟鎹�
- ds = oCN.RunProcReturn("delete from Gy_SOPBillSub2 where HFileName='" + filename + "'", "Gy_SOPBillSub2");
- if (Directory.Exists(path))
+
+ 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;
+ }
+ }
+
+ /// <summary>
+ /// 鏍规嵁鐗╂枡锛屽伐鍗曟煡鎵句綔涓氭寚瀵间功
+ ///鍙傛暟锛歴tring sql銆�
+ ///杩斿洖鍊硷細object銆�
+ /// </summary>
+ [Route("Gy_SopBill/getListByMaterID")]
+ [HttpGet]
+ public object getListByMaterID(Int64 HMaterID, string HSourceNo)
+ {
+ try
+ {
+ var sWhere = "";
+ if (Convert.ToInt32(HMaterID) != 0 && HMaterID.ToString() != "" && HSourceNo != null && HSourceNo.ToString() != "" )
{
- File.Delete(fileurl); //鍒犻櫎鎸囧畾鏂囦欢
- files.SaveAs(fileurl);
- string StrPath = "/files/" + HBillNo + "/" + filename;
- if (File.Exists(fileurl))
+ sWhere += " and HMaterID = " + HMaterID + " and HSourceNo = '" + HSourceNo + "'";
+ }
+ string sql1 = string.Format(@"select * from h_v_Sc_ICMOBillList_ToSop where 1 = 1 " + sWhere);
+
+ ds = oCN.RunProcReturn(sql1, "h_v_Sc_ICMOBillList_ToSop");
+
+
+ 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>
+ /// 鏍规嵁鐗╂枡+宸ュ簭鏌ユ壘浣滀笟鎸囧涔�
+ ///鍙傛暟锛歴tring sql銆�
+ ///杩斿洖鍊硷細object銆�
+ /// </summary>
+ [Route("Gy_SopBill/getListByMaterProc")]
+ [HttpGet]
+ public object getListByMaterProc(Int64 HMaterID, Int64 HProcID,string HType)
+ {
+ try
+ {
+ var sWhere = "";
+ if (HType != "")
+ {
+ if (Convert.ToInt32(HMaterID) != 0 && HMaterID.ToString() != "" && Convert.ToInt32(HProcID) != 0 && HProcID.ToString() != "")
{
- //杩欓噷鍙互鎵ц涓�浜涘叾瀹冪殑鎿嶄綔锛屾瘮濡傛洿鏂版暟鎹簱
- //鍐欏叆鏁版嵁琛�
- 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 = "涓婁紶澶辫触锛佹鏂囦欢涓烘伓鎰忔枃浠�" };
+ sWhere += " and HMaterID = " + HMaterID + " and HProcID = " + HProcID + " and HProcID2 = " + HProcID + " and 鎸囧涔︾被鍨� = '"+ HType + "'";
}
}
else
{
- Directory.CreateDirectory(fileSavePath); //娣诲姞鏂囦欢澶�
- files.SaveAs(fileurl);
- string StrPath = "/files/" + HBillNo + "/" + filename;
- if (File.Exists(fileurl))
+ if (Convert.ToInt32(HMaterID) != 0 && HMaterID.ToString() != "" && Convert.ToInt32(HProcID) != 0 && HProcID.ToString() != "")
{
- //杩欓噷鍙互鎵ц涓�浜涘叾瀹冪殑鎿嶄綔锛屾瘮濡傛洿鏂版暟鎹簱
- //鍐欏叆鏁版嵁琛�
- 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 = "涓婁紶澶辫触锛佹鏂囦欢涓烘伓鎰忔枃浠�" };
+ sWhere += " and HMaterID = " + HMaterID + " and HProcID = " + HProcID + " and HProcID2 = " + HProcID + " ";
}
}
+ //if (Convert.ToInt32(HMaterID) != 0 && HMaterID.ToString() != "" && Convert.ToInt32(HProcID) != 0 && HProcID.ToString() != "")
+ //{
+ // sWhere += " and HMaterID = " + HMaterID + " and HProcID = " + HProcID + " and HProcID2 = " + HProcID ;
+ //}
+ string sql1 = string.Format(@"select * from h_v_Sc_ICMOBillStatus_Tmp_SOP where 1 = 1 " + sWhere);
+ //鑾峰彇鏄剧ず绯荤粺鍙傛暟
+ string sReturn = "";
+ oSystemParameter.ShowBill(ref sReturn);
+
+ if (oSystemParameter.omodel.WMS_CampanyName == "涔濊彵") //绯荤粺鍙傛暟 瀹㈡埛瀹氬埗鍖栧悕绉� 绌虹櫧涓洪�氱敤
+ {
+ ds = oCN.RunProcReturn("select * from h_v_Sc_ICMOBillStatus_Tmp_SOP where HMaterID = " + HMaterID, "h_v_Sc_ICMOBillStatus_Tmp_SOP");
+ }
+ else
+ {
+ ds = oCN.RunProcReturn(sql1, "h_v_Sc_ICMOBillStatus_Tmp_SOP");
+ }
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "Sucess锛�";
+ objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
}
catch (Exception e)
{
- Result_Ob = new { result = 0, returnval = e.Message };
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
}
- return Result_Ob;
}
}
--
Gitblit v1.9.1