using Newtonsoft.Json.Linq;
|
using Pub_Class;
|
using System;
|
using System.Collections;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Data.SqlClient;
|
using System.Web.Http;
|
using WebAPI.Models;
|
|
namespace WebAPI.Controllers
|
{
|
//生产任务单Controller
|
//数据库主表Sc_ICMOBillMain
|
//数据库子表Sc_ICMOBillSub
|
public class Sc_ICMOBillController : ApiController
|
{
|
public DBUtility.ClsPub.Enum_BillStatus BillStatus;
|
private json objJsonResult = new json();
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
DataSet ds;
|
|
#region 生产任务单删除功能
|
[Route("Sc_ICMOBill/DeltetSc_ICMOReportBill")]
|
[HttpGet]
|
public object DeltetSc_ICMOReportBill(string HInterID,string user)
|
{
|
try
|
{
|
//判断是否有删除权限
|
if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Drop", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无权限删除!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
if (string.IsNullOrWhiteSpace(HInterID))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "HInterID为空！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
oCN.BeginTran();//开始事务
|
ds = oCN.RunProcReturn("select * from Sc_ICMOBillMain where HInterID=" + HInterID, "Sc_ICMOBillMain");
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有数据，无法删除！";
|
objJsonResult.data = null;
|
return objJsonResult; ;
|
}
|
oCN.RunProc("delete from Sc_ICMOBillMain where HInterID=" + HInterID);
|
oCN.Commit();//提交事务
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "* 数据删除成功！";
|
objJsonResult.data = null;
|
return objJsonResult; ;
|
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
|
#region 墙咔装箱单回车事件
|
[Route("Sc_ICMOBill/QK_PackingBillByXSBill")]
|
[HttpGet]
|
public object QK_PackingBillByXSBill(string HBillNo)
|
{
|
try
|
{
|
string sql = string.Format(@"select b.HMaterID,m.HNumber HMaterCode,m.HName HMaterName,b.HUnitID,u.HName HUnitName,
|
b.HQty HQty,a.HAddress HAddress,b.HDate HDate,b.HOutStockQty HOutStockQty,b.HInvoiceQty HInvoiceQty,
|
b.HTaxPrice HTaxPrice,b.HPrice HPrice,b.HMoney HMoney,a.HCusID HCusID,c.HName HCusName,a.HEmpID,e.HName HEmpName,
|
i.HInterID,i.HBillNo
|
from Xs_SeOrderBillMain a
|
left join Xs_SeOrderBillSub b on a.HInterID=b.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join Gy_Unit u on b.HUnitID=u.HItemID
|
left join Gy_Customer c on a.HCusID=c.HItemID
|
left join Gy_Employee e on a.HEmpID=e.HItemID
|
left join Sc_ICMOBillMain i on i.HSeOrderInterID=a.HInterID
|
where a.HInterID=(select HSeOrderInterID from Sc_ICMOBillMain where HBillNo='" + HBillNo + "')");
|
|
ds = oCN.RunProcReturn(sql, "Xs_SeOrderBillMain");
|
if (ds.Tables[0].Rows.Count != 0 || ds != null)
|
{
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "获取成功！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "暂无对应的销售明细！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "获取失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 墙咔装箱单整箱生成
|
[Route("Sc_ICMOBill/QK_PackingBillSavePack")]
|
[HttpPost]
|
public object QK_PackingBillSavePack([FromBody] JObject msg)
|
{
|
var _value = msg["msg"].ToString();
|
string msg1 = _value.ToString();
|
string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
string msg2 = sArray[0].ToString();
|
string msg3 = sArray[1].ToString();
|
string msg4 = sArray[2].ToString();
|
|
ListModels oListModels = new ListModels();
|
try
|
{
|
if (msg4=="ZZ")
|
{
|
//表体数据
|
//按 },{来拆分数组 //去掉【和】
|
|
msg2 = msg2.Replace("\\", "");
|
msg2 = msg2.Replace("\n", ""); //\n
|
//msg2 = msg2.Replace("'", "’");
|
List<Models.ClsQK_PackingBill> ls = new List<Models.ClsQK_PackingBill>();
|
ls = oListModels.getObjectByJson_QK_PackingBill(msg2);
|
oCN.BeginTran();
|
foreach (Models.ClsQK_PackingBill oItemSub in ls)
|
{
|
var HInterID = DBUtility.ClsPub.CreateBillID("3783", ref DBUtility.ClsPub.sExeReturnInfo);
|
var HBillNo = DBUtility.ClsPub.CreateBillCode("3783", ref DBUtility.ClsPub.sExeReturnInfo, true);
|
string sql = string.Format(@"Insert Sc_PackUnionBillMain(HYear,HPeriod,HBillType,HInterID,HDate,HBillNo,HBillStatus,HCheckItemNowID,HCheckItemNextID,
|
HRemark,HBacker,HChecker,HMaker,HMakeDate,HUpDater,HCloseMan,HCloseType,HDeleteMan,
|
HICMOInterID,HICMOBillNo,HBarCode_Pack,HMaterID,HUnitID,HWeight,HMWeight,HPWeight,
|
HProdOrgID,HDeptID,HEmpID,HSNum,HPackNum,HBarCode_Cus,HBatchNo,HBillSubType)
|
values('2022',1,'3783'," + HInterID + ",getdate(),'" + HBillNo + "',1,0,0," +
|
"'自动绑定','','', " + msg3 + ",getdate(),'','',0,''," +
|
oItemSub.HInterID + ",'" + oItemSub.HBillNo + "','" + HBillNo + "'," + oItemSub.HMaterID + "," + oItemSub.HUnitID + "," + oItemSub.HWeight + "," + oItemSub.HMWeight + "," + oItemSub.HPWeight + "," +
|
"0,0," + oItemSub.HEmpID + ",0,0,'','','')");
|
oCN.RunProc(sql);
|
}
|
oCN.Commit();
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "整装生成成功！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
else
|
{
|
msg2 = msg2.Replace("\\", "");
|
msg2 = msg2.Replace("\n", ""); //\n
|
//msg2 = msg2.Replace("'", "’");
|
List<Models.ClsQK_PackingBill> ls = new List<Models.ClsQK_PackingBill>();
|
ls = oListModels.getObjectByJson_QK_PackingBill(msg2);
|
|
var HInterID = DBUtility.ClsPub.CreateBillID("3783", ref DBUtility.ClsPub.sExeReturnInfo);
|
var HBillNo = DBUtility.ClsPub.CreateBillCode("3783", ref DBUtility.ClsPub.sExeReturnInfo, true);
|
oCN.BeginTran();
|
foreach (Models.ClsQK_PackingBill oItemSub in ls)
|
{
|
string sql = string.Format(@"insert into Sc_PackUnionBillSub(HInterID,HEntryID,HCloseMan,HCloseType,HRemark,
|
HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,
|
HRelationQty,HRelationMoney,HMaterID,HUnitID,HQty,HSourceID,HEquipID,HGroupID,HWorkerID,
|
HScanDate,HBarCode,HBarCode_Pack)
|
values("+HInterID+",'','',0,'自动绑定',"+oItemSub.HInterID+",'',"+oItemSub.HBillNo+",'3710',"+
|
"0,0,"+ oItemSub.HMaterID+","+ oItemSub.HUnitID+","+ oItemSub.HQty+", 0,0,0,0,"+
|
"getdate(),'',"+HBillNo+")");
|
oCN.RunProc(sql);
|
}
|
string sql2 = string.Format(@"Insert Sc_PackUnionBillMain(HYear,HPeriod,HBillType,HInterID,HDate,HBillNo,HBillStatus,HCheckItemNowID,HCheckItemNextID,
|
HRemark,HBacker,HChecker,HMaker,HMakeDate,HUpDater,HCloseMan,HCloseType,HDeleteMan,HICMOInterID,HICMOBillNo,
|
HBarCode_Pack,HMaterID,HUnitID,HWeight,HMWeight,HPWeight,
|
HProdOrgID,HDeptID,HEmpID,HSNum,HPackNum,HBarCode_Cus,HBatchNo,HBillSubType)
|
values('2022',1,'3783'," + HInterID + ",getdate(),'" + HBillNo + "',1,0,0," +
|
"'自动绑定','','', " + msg3 + ",getdate(),'','',0,'',0,0,'" +
|
HBillNo + "',0,0,0,0,0" +
|
"0,0,0,0,0,'','','')");
|
oCN.RunProc(sql2);
|
oCN.Commit();
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "拼装生成成功";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "获取失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
}
|
}
|
