using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Net; using System.Net.Http; using System.Web.Http; using WebAPI; using WebAPI.Models; namespace WebAPI.Controllers { public class Sc_AssemblyBillController : ApiController { public Int64 HInterID; //本单ID public string HBillNo; //本单单号 public string HBillType = "3727"; //单据类型 public WebServer webserver =new WebServer(); public DataSet ds =new DataSet(); string sBillNo = ""; Int64 sInterID = 0; string sICMOBillNo = ""; string sCPBarCode = ""; Int64 sCPMaterID = 0; string sCPMaterName = ""; private json objjson = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //扫描成品条码 [Route("Assembly/Get_Assembly_CPBarCode_Json")] [HttpGet] public object Get_Assembly_CPBarCode_Json(string sBarCode,string sBillType) { try { DataTable dt_Main = new DataTable("Json"); dt_Main.Columns.Add("sICMOBillNo", typeof(string)); dt_Main.Columns.Add("sCPBarCode", typeof(string)); dt_Main.Columns.Add("sCPMaterID", typeof(Int64)); dt_Main.Columns.Add("sCPMaterName", typeof(string)); dt_Main.Columns.Add("sInterID", typeof(Int64)); dt_Main.Columns.Add("sBillNo", typeof(string)); if (webserver.Get_Assembly_CPBarCode(sBarCode, sBillType, ref sICMOBillNo, ref sCPBarCode, ref sCPMaterID, ref sCPMaterName, ref sBillNo, ref sInterID, ref DBUtility.ClsPub.sErrInfo)) { //---------创建新行------------------------ DataRow dr_main = dt_Main.NewRow();//创建新行 dt_Main.Rows.Add(dr_main);//将新行加入到表中 dr_main["sICMOBillNo"] = DBUtility.ClsPub.isStrNull(sICMOBillNo); dr_main["sCPBarCode"] = DBUtility.ClsPub.isStrNull(sCPBarCode); dr_main["sCPMaterID"] = DBUtility.ClsPub.isLong(sCPMaterID); dr_main["sCPMaterName"] = DBUtility.ClsPub.isStrNull(sCPMaterName); dr_main["sInterID"] = DBUtility.ClsPub.isLong(sInterID); dr_main["sBillNo"] = DBUtility.ClsPub.isStrNull(sBillNo); objjson.code = "0"; objjson.count = 1; objjson.Message = "获取成功"; objjson.data = dt_Main; return objjson; } else { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; } } catch (Exception e) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + e.ToString(); objjson.data = null; return objjson; } } //扫描配件条码 [Route("Assembly/Get_Assembly_PJBarCode_Json")] [HttpGet] public object Get_Assembly_PJBarCode_Json(string sPJCode, string sCPCode, long sInterID, string sBillNo, string sMaker, long HWorkerID, string HSNNumber) { try { DataTable dt_Main = new DataTable("Json"); dt_Main.Columns.Add("sPJCode", typeof(string)); dt_Main.Columns.Add("sCPCode", typeof(string)); dt_Main.Columns.Add("sInterID", typeof(Int64)); dt_Main.Columns.Add("sBillNo", typeof(string)); dt_Main.Columns.Add("sMaker", typeof(string)); dt_Main.Columns.Add("HWorkerID", typeof(Int64)); dt_Main.Columns.Add("HSNNumber", typeof(string)); if (webserver.Get_Assembly_PJBarCode(sPJCode, sCPCode, sInterID, sBillNo, sMaker, HWorkerID, HSNNumber, ref DBUtility.ClsPub.sErrInfo)) { //---------创建新行------------------------ DataRow dr_main = dt_Main.NewRow();//创建新行 dt_Main.Rows.Add(dr_main);//将新行加入到表中 dr_main["sPJCode"] = DBUtility.ClsPub.isStrNull(sPJCode); dr_main["sCPCode"] = DBUtility.ClsPub.isStrNull(sCPCode); dr_main["sInterID"] = DBUtility.ClsPub.isLong(sInterID); dr_main["sBillNo"] = DBUtility.ClsPub.isStrNull(sBillNo); dr_main["sMaker"] = DBUtility.ClsPub.isStrNull(sMaker); dr_main["HWorkerID"] = DBUtility.ClsPub.isLong(HWorkerID); dr_main["HSNNumber"] = DBUtility.ClsPub.isStrNull(HSNNumber); objjson.code = "0"; objjson.count = 1; objjson.Message = "获取成功"; objjson.data = dt_Main; return objjson; } else { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; } } catch (Exception e) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + e.ToString(); objjson.data = null; return objjson; } } [Route("Assembly/DisBillEntryList_Mate_Webs_Json")] [HttpGet] public object DisBillEntryList_Mate_Webs_Json(long HInterID, string sBillType, string sWhere) { try { ds = webserver.GetSc_AssemblyBill(HInterID, sBillType, sWhere); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "没有返回任何记录！"; objjson.data = null; return objjson; //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning); } else { objjson.code = "0"; objjson.count = 1; objjson.Message = "获取信息成功！"; objjson.data = ds.Tables[0]; return objjson; } } catch (Exception e) { objjson.code = "0"; objjson.count = 0; objjson.Message = "没有返回任何记录！" + e.ToString(); objjson.data = null; return objjson; } } #region 产线组装追溯单 [Route("Sc_AssemblyBill/HBardCodeList")] [HttpGet] public object HBardCodeList(string HBarCode, string user,string HICMOBillNo) { try { //查看权限 if (!DBUtility.ClsPub.Security_Log("Sc_AssemblyBill_Edit", 1, false, user)) { objjson.code = "0"; objjson.count = 0; objjson.Message = "无保存权限！"; objjson.data = null; return objjson; } if (HICMOBillNo == "" || HICMOBillNo == null) { ds = oCN.RunProcReturn(@"select b.FMUSTQTY,a.FMOBILLNO,FERPCLSID,t5.FNAME HMaterName_z,t5.FSPECIFICATION HMaterModel_z ,m.HItemID,b.FMATERIALID,m.HName HMaterName,m.HNumber HMaterNumber,m.HModel HMaterModel,m1.HItemID HMaterID from AIS20210811135644..T_PRD_PPBOM a join AIS20210811135644..T_PRD_PPBOMENTRY b on a.FID = b.FID join AIS20210811135644..T_BD_MATERIAL t3 on a.FMATERIALID = t3.FMATERIALID join AIS20210811135644..T_BD_MATERIAL t31 on b.FMATERIALID = t31.FMATERIALID join AIS20210811135644..T_BD_MATERIAL_L t5 on b.FMATERIALID = t5.FMATERIALID and FLOCALEID=2052 join AIS20210811135644..t_BD_MaterialBase t4 on t5.FMATERIALID = t4.FMATERIALID join Gy_BarCodeBill bard on a.FMOBILLNO=bard.HSourceBillNo join Gy_Material m on bard.HMaterID=m.HItemID and t3.FNUMBER=m.HNumber join Gy_Material m1 on t31.FNUMBER=m1.HNumber and t31.FUSEORGID=m1.HUSEORGID where bard.HBarCode='" + HBarCode + "' AND t4.FERPCLSID in ('1', '3')", "Gy_BarCodeBill"); if (ds.Tables[0].Rows.Count == 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "无源单！"; objjson.data = null; return objjson; } else { objjson.code = "1"; objjson.count = 1; objjson.Message = ""; objjson.data = ds.Tables[0]; } } else { ds = oCN.RunProcReturn(@"select a.FMOBILLNO,FERPCLSID ,t4.FMATERIALID, a.FMATERIALID from AIS20210811135644..T_PRD_PPBOM a join AIS20210811135644..T_PRD_PPBOMENTRY b on a.FID=b.FID JOIN AIS20210811135644..T_BD_MATERIAL T6 ON b.FMATERIALID = T6.FMATERIALID join AIS20210811135644..t_BD_MaterialBase t4 on b.FMATERIALID = t4.FMATERIALID left join Gy_Material m on t6.FNUMBER=m.HNumber and m.HUSEORGID=a.FPRDORGID where a.FMOBILLNO ='" + HICMOBillNo + "' and m.HItemID=(select HMaterID from Gy_BarCodeBill where HBarCode = '" + HBarCode + "' )", "ds2"); if (ds.Tables[0].Rows.Count == 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "配件不属于该生产订单！"; objjson.data = null; return objjson; } ds = oCN.RunProcReturn(@"select HQty,HSourceBillNo,m.HName HMaterName,m.HItemID HMaterID from Gy_BarCodeBill bard join Gy_Material m on bard.HMaterID=m.HItemID where HBarCode='" + HBarCode + "'", "ds3"); objjson.code = "1"; objjson.count = 1; objjson.Message = ""; objjson.data = ds.Tables[0]; } return objjson; } catch (Exception e) { objjson.code = "0"; objjson.count = 0; objjson.Message = "没有返回任何记录！" + e.ToString(); objjson.data = null; return objjson; } } #endregion [Route("Assembly/Delete_Json")] [HttpGet] public object Delete_Json(long sInterID,string sBarCode) { string sErrMsg=string.Empty; try { if (webserver.set_DelSc_AssemblyBill(sInterID, sBarCode,ref sErrMsg)) { objjson.code = "0"; objjson.count = 1; objjson.Message = "删除成功！"; objjson.data = null; return objjson; } else { objjson.code = "0"; objjson.count = 0; objjson.Message = "删除失败！"; objjson.data = null; return objjson; } } catch (Exception) { objjson.code = "0"; objjson.count = 0; objjson.Message = "删除失败！"; objjson.data = null; return objjson; } } } }