using DBUtility;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Net;
|
using System.Net.Http;
|
using System.Web.Http;
|
using System.Web.Script.Serialization;
|
using WebAPI.Models;
|
|
namespace WebAPI.Controllers.博日自动扫码线
|
{
|
public class ScanlineAPIController : ApiController
|
{
|
private jsonScanline objJsonResult = new jsonScanline();
|
public DataSet ds = new DataSet();
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
#region 生成箱码接口
|
[Route("packagebarcode/create")]
|
[HttpGet]
|
public object create(int num)
|
{
|
try
|
{
|
objJsonResult.data = new List<barcode>();
|
for (int i = 0; i < num; i++)
|
{
|
barcode jsn = new barcode();
|
//string prefix = "ZM";
|
//string date = DateTime.Now.ToString("yyMMddhh");
|
//string custom = "12";
|
//int nm = i;
|
//string result = prefix + date + custom + nm.ToString().PadLeft(4, '0');
|
|
//条码前缀 = 箱码前缀 + 年 + 月 + 日
|
string sDate = DateTime.Now.ToString("yyyy-MM-dd");
|
string sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2);
|
string sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString();
|
sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2);
|
string sDay = "0" + ClsPub.isDate(sDate).Day.ToString();
|
sDay = sDay.Substring(sDay.Length - 2, 2);
|
string sTMNumber ="ZX"+ sYear + sPeriod + sDay;
|
ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //获取最大流水号
|
int LSH = ClsPub.isInt(ds.Tables[0].Rows[0][0])+1; //流水号加1
|
string TM = sTMNumber + LSH;
|
jsn.packagebarcode = TM;
|
oCN.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'");
|
objJsonResult.data.Add(jsn);
|
}
|
objJsonResult.status = 0;
|
objJsonResult.msg = "查询数据成功！";
|
objJsonResult.data =objJsonResult.data;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.status =-1;
|
objJsonResult.msg = "生成箱条码失败！";
|
objJsonResult.data =null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
|
#region 报工平台开工单保存/编辑
|
/// <summary>
|
/// 开工单
|
/// </summary>
|
/// <param name="msg"></param>
|
/// <returns></returns>
|
[Route("packagebarcode/pack")]
|
[HttpPost]
|
public object pack([FromBody] JObject msg)
|
{
|
try
|
{
|
JavaScriptSerializer js = new JavaScriptSerializer(); //实例化一个能够序列化数据的类
|
ScanLineCode list = js.Deserialize<ScanLineCode>(msg.ToString()); //将json数据转化为对象类型并赋值给list
|
|
objJsonResult.status = 0;
|
objJsonResult.msg = "success";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.status =-1;
|
objJsonResult.msg = "success";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
}
|
}
|
