public string RequestPayUrl(string machineId, string waresId)
{
if (string.IsNullOrEmpty(machineId))
{
return("");
}
KeyJsonModel jsonModel = new KeyJsonModel();
jsonModel.m = machineId;
jsonModel.t = new List <KeyTunnelModel>();
jsonModel.t.Add(new KeyTunnelModel()
{
tid = waresId, n = "1"
});
string json = JsonHandler.GetJsonStrFromObject(jsonModel);
//byte[] byteSend = System.Text.Encoding.Default.GetBytes(json);
//string hex = ByteHelper.byteToHexStr(byteSend);
Dictionary <string, string> dicRet = new Dictionary <string, string>();
dicRet["url"] = PathConfig.DomainConfig + "/m.html#/paybyproduct?k=" + json;
dicRet["waresId"] = waresId;
string retJson = JsonHandler.GetJsonStrFromObject(dicRet);
return(HttpUtility.UrlDecode(retJson));
}
//支付宝支付结果插入数据库
public int PostPayResultA(KeyJsonModel keyJsonModel, string outTradeNo, string tradeNo, string sellerId, string buyerId, string payDate)
{
try
{
if (string.IsNullOrEmpty(outTradeNo))
{
return(0);
}
int isExist = GetCountByTradeNo(outTradeNo);
if (isExist > 0)
{
return(0);
}
GenerateDal.BeginTransaction();
foreach (KeyTunnelModel keyTunnelInfo in keyJsonModel.t)
{
SaleModel saleInfo = new SaleModel();
saleInfo.SalesIcId = Guid.NewGuid().ToString();
saleInfo.MachineId = keyJsonModel.m;
saleInfo.SalesDate = DateTime.Now;
saleInfo.SalesNumber = string.IsNullOrEmpty(keyTunnelInfo.n) ? 1 : Convert.ToInt32(keyTunnelInfo.n);
saleInfo.PayDate = TransStrToDateTime(payDate, "a");
saleInfo.PayInterface = "支付宝";
saleInfo.PayType = "支付宝";
saleInfo.TradeNo = outTradeNo;
saleInfo.ComId = tradeNo;
saleInfo.GoodsId = keyTunnelInfo.tid;
saleInfo.TradeStatus = 1;
saleInfo.MerchantId = sellerId;
saleInfo.BuyerId = buyerId;
saleInfo.TradeAmount = Convert.ToDouble(keyTunnelInfo.p);
saleInfo.ServiceCharge = Math.Round(Convert.ToDouble(keyTunnelInfo.p) * ConfigHandler.ZhifubaoRate, 2, MidpointRounding.AwayFromZero);
saleInfo.WaresId = keyTunnelInfo.wid;
saleInfo.WaresName = GetProductNameByWaresId(keyTunnelInfo.wid);
GenerateDal.Create(saleInfo);
//更新存存
UpdateCurrStock(keyJsonModel.m, keyTunnelInfo.tid, saleInfo.SalesNumber);
}
GenerateDal.CommitTransaction();
return(1);
}
catch (Exception e)
{
GenerateDal.RollBack();
return(0);
}
}
public void TestZhiFu()
{
IMachine imachine = new MachineService();
KeyJsonModel jsonModel = new KeyJsonModel();
jsonModel.m = "ABC000000001";
jsonModel.t = new List <KeyTunnelModel>();
jsonModel.t.Add(new KeyTunnelModel()
{
tid = "A0101",
wid = "f2408a65-3355-49dc-b0ad-0f98861943fa",
tn = "20180123456789"
});
// imachine.PostPayResultA(jsonModel, "20180123456789", "20180123456789");
}
public KeyJsonModel AnalizeKey(string key)
{
KeyJsonModel keyJsonInfo = null;
try
{
keyJsonInfo = JsonHandler.GetObjectFromJson <KeyJsonModel>(key);
}
catch (Exception e)
{
keyJsonInfo = JsonHandler.GetObjectFromJson <KeyJsonModel>(System.Text.Encoding.Default.GetString(ByteHelper.strToToHexByte(key)));
}
return(keyJsonInfo);
}
//上报出货结果 更新销售表状态
public int PutPayResult(KeyJsonModel keyJsonInfo)
{
try
{
GenerateDal.BeginTransaction();
foreach (KeyTunnelModel keyTunnelInfo in keyJsonInfo.t)
{
List <SaleModel> lstSaleModel = GetSalesByNo(keyJsonInfo.m, keyTunnelInfo.tid, keyTunnelInfo.tn);
if (lstSaleModel.Count > 0 && lstSaleModel[0].TradeStatus == 1)
{
SaleModel saleInfo = new SaleModel();
saleInfo.SalesDate = DateTime.Now;
saleInfo.GoodsId = keyTunnelInfo.tid;
saleInfo.MachineId = keyJsonInfo.m;
saleInfo.TradeNo = keyTunnelInfo.tn;
saleInfo.RealitySaleNumber = Convert.ToInt32(keyTunnelInfo.n);
saleInfo.TradeStatus = Convert.ToInt32(keyTunnelInfo.s);
//出货失败后库存回滚
if (saleInfo.TradeStatus == 5)
{
saleInfo.RealitySaleNumber = 0;
UpdateAddCurrStock(saleInfo.MachineId, saleInfo.GoodsId, lstSaleModel[0].SalesNumber);
}
if (saleInfo.TradeStatus == 3)
{
saleInfo.RealitySaleNumber = 0;
UpdateAddCurrStock(saleInfo.MachineId, saleInfo.GoodsId, lstSaleModel[0].SalesNumber - saleInfo.RealitySaleNumber);
}
GenerateDal.Update(CommonSqlKey.UpdatePayResult, saleInfo);
}
}
GenerateDal.CommitTransaction();
}
catch (Exception e)
{
GenerateDal.RollBack();
return(0);
}
return(1);
}
//支付宝支付结果
/*
* public ResultObj<int> PostPayResultA(List<ProductModel> listProductInfo)
* {
*
* IMachine _imachine = new MachineService();
* _imachine.PostPayResultA(listProductInfo);
* return Content(1);
* }
*/
public string PostPayResultA()
{
try
{
string outTradeNo = Fycn.Utility.HttpContext.Current.Request.Form["out_trade_no"].ToString().Trim();
//RedisHelper helper = new RedisHelper(0);
//log.Info(outTradeNo);
//log.Info(helper.KeyExists(outTradeNo));
/*
* if (!helper.KeyExists(outTradeNo))
* {
* return "success";
* }
*/
/*
* IMachine _imachine = new MachineService();
* if (_imachine.GetCountByTradeNo(outTradeNo) > 0)
* {
* return Content(1);
* }
*/
string tradeStatus = Fycn.Utility.HttpContext.Current.Request.Form["trade_status"].ToString().ToUpper();
if (tradeStatus == "TRADE_SUCCESS")
{
/*******************************放到微信支付通知参数里，因参数只支付最大128个字符长度，所以注释修改*****************************/
//string jsonProduct = Fycn.Utility.HttpContext.Current.Request.Form["body"];
//KeyJsonModel keyJsonModel = JsonHandler.GetObjectFromJson<KeyJsonModel>(jsonProduct);
string tradeNo = Fycn.Utility.HttpContext.Current.Request.Form["trade_no"];
string sellerId = Fycn.Utility.HttpContext.Current.Request.Form["seller_id"]; //买家合作者id
string buyerId = Fycn.Utility.HttpContext.Current.Request.Form["buyer_logon_id"]; //买家账号
//log.Info(Fycn.Utility.HttpContext.Current.Request.Form["passback_params"]);
//string jsonProduct = helper.StringGet(outTradeNo);
string jsonProduct = Fycn.Utility.HttpContext.Current.Request.Form["passback_params"];
//log.Info("test");
string gmtPayment = Fycn.Utility.HttpContext.Current.Request.Form["gmt_payment"]; //付款时间
//string jsonProduct = FileHandler.ReadFile("data/" + outTradeNo + ".wa");
//log.Info(gmtPayment);
KeyJsonModel keyJsonModel = JsonHandler.GetObjectFromJson <KeyJsonModel>(jsonProduct);
IMachine _imachine = new MachineService();
int result = _imachine.PostPayResultA(keyJsonModel, outTradeNo, tradeNo, sellerId, buyerId, gmtPayment);
if (result == 1)
{
//Fycn.Utility.HttpContext.Current.Response.Write("success");
//Response.WriteAsync("success");
List <CommandModel> lstCommand = new List <CommandModel>();
lstCommand.Add(new CommandModel()
{
Content = keyJsonModel.m,
Size = 12
});
lstCommand.Add(new CommandModel()
{
Content = outTradeNo,
Size = 22
});
lstCommand.Add(new CommandModel()
{
Content = keyJsonModel.t[0].tid,
Size = 5
});
lstCommand.Add(new CommandModel()
{
Content = "4",
Size = 1
});
SocketHelper.GenerateCommand(10, 41, 66, lstCommand);
//删除文件
//helper.KeyDelete(outTradeNo);
//FileHandler.DeleteFile("data/" + outTradeNo + ".wa");
if (sellerId == PathConfig.RootAliMchId)
{
IDistrubuteMoney imoney = new DistrubuteMoneyService();
imoney.PostMoney(outTradeNo);
}
return("success");
}
}
return("success");
}
catch (Exception ex)
{
return("success");
}
}
// 微信支付结果
public string PostPayResultW()
{
try
{
var request = Fycn.Utility.HttpContext.Current.Request;
int len = (int)request.ContentLength;
byte[] b = new byte[len];
Fycn.Utility.HttpContext.Current.Request.Body.Read(b, 0, len);
string postStr = Encoding.UTF8.GetString(b);
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(postStr);
// 商户交易号
XmlNode tradeNoNode = xmlDoc.SelectSingleNode("xml/out_trade_no");
/*
* RedisHelper helper = new RedisHelper(0);
*
* if (!helper.KeyExists(tradeNoNode.InnerText))
* {
* return Content(1);
* }
*/
/*
* IMachine _imachine = new MachineService();
* if (_imachine.GetCountByTradeNo(tradeNoNode.InnerText) > 0)
* {
* return Content(1);
* }
*/
//支付结果
XmlNode payResultNode = xmlDoc.SelectSingleNode("xml/result_code");
if (payResultNode.InnerText.ToUpper() == "SUCCESS")
{
/*******************************放到微信支付通知参数里，因参数只支付最大128个字符长度，所以注释修改*****************************/
//XmlNode tunnelNode = xmlDoc.SelectSingleNode("xml/attach");
//KeyJsonModel keyJsonModel = JsonHandler.GetObjectFromJson<KeyJsonModel>(tunnelNode.InnerText);
XmlNode attachNode = xmlDoc.SelectSingleNode("xml/attach");
string jsonProduct = attachNode.InnerText; //helper.StringGet(tradeNoNode.InnerText);
XmlNode mchIdNode = xmlDoc.SelectSingleNode("xml/mch_id"); // 商户号
XmlNode openidNode = xmlDoc.SelectSingleNode("xml/openid"); //买家唯一标识
XmlNode isSubNode = xmlDoc.SelectSingleNode("xml/is_subscribe"); // 是否为公众号关注者
XmlNode timeEndNode = xmlDoc.SelectSingleNode("xml/time_end"); // 是否为公众号关注者
//string jsonProduct = FileHandler.ReadFile("data/" + tradeNoNode.InnerText + ".wa");
KeyJsonModel keyJsonModel = JsonHandler.GetObjectFromJson <KeyJsonModel>(jsonProduct);
IMachine _imachine = new MachineService();
int result = _imachine.PostPayResultW(keyJsonModel, tradeNoNode.InnerText, mchIdNode.InnerText, openidNode.InnerText, isSubNode.InnerText, timeEndNode.InnerText);
if (result == 1)
{
List <CommandModel> lstCommand = new List <CommandModel>();
lstCommand.Add(new CommandModel()
{
Content = keyJsonModel.m,
Size = 12
});
lstCommand.Add(new CommandModel()
{
Content = tradeNoNode.InnerText,
Size = 22
});
lstCommand.Add(new CommandModel()
{
Content = keyJsonModel.t[0].tid,
Size = 5
});
lstCommand.Add(new CommandModel()
{
Content = "3",
Size = 1
});
//var log = LogManager.GetLogger("FycnApi", "weixin");
//log.Info("test");
//log.Info(tradeNoNode.InnerText);
SocketHelper.GenerateCommand(10, 41, 66, lstCommand);
//删除文件
//helper.KeyDelete(tradeNoNode.InnerText);
//FileHandler.DeleteFile("data/" + tradeNoNode.InnerText + ".wa");
if (mchIdNode.InnerText == PathConfig.RootWeixinMchId)
{
IDistrubuteMoney imoney = new DistrubuteMoneyService();
imoney.PostMoney(tradeNoNode.InnerText);
}
}
}
return("<xml><return_code><![CDATA[SUCCESS]]></return_code></xml>");
}
catch (Exception ex)
{
return("<xml><return_code><![CDATA[FAIL]]></return_code></xml>");
}
//File.WriteAllText(@"c:\text.txt", postStr);
}
//对k进行解码 k格式：{"m":"123128937","t":[{"tid":"1-2","n":3},{"tid":"1-3","n":2}]}
private KeyJsonModel AnalizeKey(string key)
{
KeyJsonModel keyJsonInfo = JsonHandler.GetObjectFromJson <KeyJsonModel>(key);
return(keyJsonInfo);
}
public byte[] PushLogic(string commandStr, byte[] byteInfo, byte[] data, AsyncSocketUserToken m_asyncSocketUserToken)
{
IMachine imachine = new MachineService();
//验证通过
switch (commandStr)
{
case "40": //心跳
int size40 = 2;
byte[] returnByte40 = new byte[7];
returnByte40[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(size40).CopyTo(returnByte40, 1); //size
returnByte40[4] = data[0];
string machineNum40 = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
int signal40 = data[13];
int temp40 = (sbyte)data[14];
int door40 = data[15];
MachineHelper.Signature(machineNum40, m_asyncSocketUserToken.ConnectSocket.RemoteEndPoint.ToString());
returnByte40[5] = 0;
returnByte40[6] = 238; //
//验证码生成
byte result40Chunk = new byte();
byte[] finalResult40 = returnByte40.Skip(4).Take(size40).ToArray();
for (int i = 0; i < finalResult40.Length; i++)
{
result40Chunk ^= finalResult40[i];
}
returnByte40[3] = result40Chunk;
ByteHelper.Encryption(size40, finalResult40.ToArray()).CopyTo(returnByte40, 4); //加密
try
{
imachine.UpdateMachineInlineTimeAndIpv4(machineNum40, signal40, temp40, door40, m_asyncSocketUserToken.ConnectSocket.RemoteEndPoint.ToString());
}
catch (Exception e)
{
return(returnByte40);
}
return(returnByte40);
case "30": //申请签到随机码
int size30 = 19;
//机器编号
int infoSize30 = int.Parse(ByteHelper.GenerateRealityData(byteInfo.Skip(1).Take(2).ToArray(), "intval"));
string machineNum30 = string.Empty;
if (infoSize30 < 15)
{
machineNum30 = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
}
else
{
string deviceId = ByteHelper.GenerateRealityData(data.Skip(1).Take(15).ToArray(), "stringval");
machineNum30 = imachine.GetMachineIdByDeviceId(deviceId);
}
byte[] returnByte30 = new byte[24];
returnByte30[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(size30).CopyTo(returnByte30, 1); //size
returnByte30[4] = data[0];
ByteHelper.StrToByte(machineNum30).CopyTo(returnByte30, 5); //机器编号
ByteHelper.StrToByte(MachineHelper.GenerateCode(machineNum30, "code")).CopyTo(returnByte30, 17);
returnByte30[23] = 238; //
//验证码生成
byte result30Chunk = new byte();
byte[] finalResult30 = returnByte30.Skip(4).Take(size30).ToArray();
for (int i = 0; i < finalResult30.Length; i++)
{
result30Chunk ^= finalResult30[i];
}
returnByte30[3] = result30Chunk;
//SendMsg(finalResultA1, myClientSocket);
ByteHelper.Encryption(size30, finalResult30.ToArray()).CopyTo(returnByte30, 4); //加密
return(returnByte30);
case "41": //签到
int size41 = 16;
//机器编号
string machineNum41 = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
string signCode = ByteHelper.GenerateRealityData(data.Skip(13).Take(6).ToArray(), "stringval");
//resultA1 = imachine.UpdateMachineInlineTimeAndIpv4(machineNum41, m_asyncSocketUserToken.ConnectSocket.RemoteEndPoint.ToString() + "-" + m_asyncSocketUserToken.ConnectSocket.LocalEndPoint.ToString());
m_asyncSocketUserToken.MachineId = machineNum41;
SocketDictionary.Add(machineNum41, m_asyncSocketUserToken);
byte[] returnByte41 = new byte[21];
returnByte41[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(size41).CopyTo(returnByte41, 1); //size
returnByte41[4] = data[0];
ByteHelper.StrToByte(DateTime.Now.ToString("yyyyMMddHHmmss")).CopyTo(returnByte41, 5); //机器编号
if (MachineHelper.IsLegal(machineNum41, signCode, "code"))
{
try
{
ICommon common41 = new CommonService();
int machineCount = common41.CheckMachineId(machineNum41, "");
if (machineCount > 0)
{
MachineHelper.ClearCode(machineNum41, "code");
MachineHelper.Signature(machineNum41, m_asyncSocketUserToken.ConnectSocket.RemoteEndPoint.ToString());
returnByte41[19] = 48;
}
else
{
returnByte41[19] = 49;
}
}
catch (Exception e)
{
returnByte41[19] = 50;
}
}
else
{
returnByte41[19] = 50;
}
returnByte41[20] = 238; //
//验证码生成
byte resultA1Chunk = new byte();
byte[] finalResult41 = returnByte41.Skip(4).Take(size41).ToArray();
for (int i = 0; i < finalResult41.Length; i++)
{
resultA1Chunk ^= finalResult41[i];
}
returnByte41[3] = resultA1Chunk;
//SendMsg(finalResultA1, myClientSocket);
ByteHelper.Encryption(size41, finalResult41.ToArray()).CopyTo(returnByte41, 4); //加密
return(returnByte41);
case "43": //上报出货结果
int size43 = 2;
// string machineNum = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
string serialNum = ByteHelper.GenerateRealityData(data.Skip(13).Take(22).ToArray(), "stringval");
//清除缓存
MachineHelper.ClearCacheOrder(serialNum);
byte[] returnByte43 = new byte[7];
returnByte43[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(size43).CopyTo(returnByte43, 1); //size
returnByte43[4] = data[0];
string result43 = data[35].ToString();
int putResult = 0;
if (result43 == "48")
{
putResult = imachine.PutPayResultByOrderNo(serialNum, true);
}
else
{
putResult = imachine.PutPayResultByOrderNo(serialNum, false);
}
if (putResult == 1)
{
returnByte43[5] = 48;
}
else if (putResult == 0)
{
returnByte43[5] = 49;
}
else
{
returnByte43[5] = 53;
}
returnByte43[6] = 238; //结尾
//验证码生成
byte result43Chunk = new byte();
byte[] finalResult43 = returnByte43.Skip(4).Take(size43).ToArray();
for (int i = 0; i < finalResult43.Length; i++)
{
result43Chunk ^= finalResult43[i];
}
returnByte43[3] = result43Chunk;
//SendMsg(finalResultA1, myClientSocket);
ByteHelper.Encryption(size43, finalResult43.ToArray()).CopyTo(returnByte43, 4); //加密
return(returnByte43);
case "4A": //验证订单是否合法
int size4A = 14;
string orerNum4A = ByteHelper.GenerateRealityData(data.Skip(13).Take(22).ToArray(), "stringval");
byte[] returnByte4A = new byte[19];
returnByte4A[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(size4A).CopyTo(returnByte4A, 1); //size
returnByte4A[4] = data[0];
data.Skip(1).Take(12).ToArray().CopyTo(returnByte4A, 5);
if (MachineHelper.IsLegalOrder(orerNum4A)) //判断是否为合法订单
{
returnByte4A[17] = 48;
}
else
{
returnByte4A[17] = 49;
}
returnByte4A[18] = 238; //结尾
//验证码生成
byte result4AChunk = new byte();
byte[] finalResult4A = returnByte4A.Skip(4).Take(size4A).ToArray();
for (int i = 0; i < finalResult4A.Length; i++)
{
result4AChunk ^= finalResult4A[i];
}
returnByte4A[3] = result4AChunk;
//SendMsg(finalResultA1, myClientSocket);
ByteHelper.Encryption(size4A, finalResult4A.ToArray()).CopyTo(returnByte4A, 4); //加密
return(returnByte4A);
case "54": //上报一键补货结果 (一键补货)
string machineNum65 = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
//string serialNum45 = ByteHelper.GenerateRealityData(data.Skip(13).Take(12).ToArray(), "stringval
MachineHelper.ClearCachePush(machineNum65, "54");
return(new byte[0]);
case "53": //上报按货道补货结果
string machineNum53 = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
//string serialNum45 = ByteHelper.GenerateRealityData(data.Skip(13).Take(12).ToArray(), "stringval
MachineHelper.ClearCachePush(machineNum53, "53");
//SendMsg(returnByteA6, myClientSocket);
return(new byte[0]);
case "52": //上报现金设置结果
string machineNum52 = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
//string serialNum45 = ByteHelper.GenerateRealityData(data.Skip(13).Take(12).ToArray(), "stringval
MachineHelper.ClearCachePush(machineNum52, "52");
//SendMsg(returnByteA6, myClientSocket);
return(new byte[0]);
case "57": //上报广告资源拉取结果
string machineNum57 = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
//string serialNum45 = ByteHelper.GenerateRealityData(data.Skip(13).Take(12).ToArray(), "stringval
MachineHelper.ClearCachePush(machineNum57, "57");
//SendMsg(returnByteA6, myClientSocket);
return(new byte[0]);
case "65": // 终端->服务器 一键补货
int size65 = 14;
string machineId65 = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
byte[] returnByte65 = new byte[19];
returnByte65[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(size65).CopyTo(returnByte65, 1); //size
returnByte65[4] = data[0];
data.Skip(1).Take(12).ToArray().CopyTo(returnByte65, 5);
int result = imachine.GetFullfilGood(machineId65);
try
{
if (result > 0)
{
returnByte65[17] = 48;
}
else
{
returnByte65[17] = 49;
}
}
catch (Exception e)
{
returnByte65[17] = 49;
}
returnByte65[18] = 238; //结尾
//验证码生成
byte result65Chunk = new byte();
byte[] finalResult65 = returnByte65.Skip(4).Take(size65).ToArray();
for (int i = 0; i < finalResult65.Length; i++)
{
result65Chunk ^= finalResult65[i];
}
returnByte65[3] = result65Chunk;
//SendMsg(finalResultA1, myClientSocket);
ByteHelper.Encryption(size65, finalResult65.ToArray()).CopyTo(returnByte65, 4); //加密
return(returnByte65);
case "66": // 终端->服务器 详细补货
int size66 = 14;
string machineNum66 = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
byte[] returnByte66 = new byte[19];
returnByte66[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(size66).CopyTo(returnByte66, 1); //size
returnByte66[4] = data[0];
data.Skip(1).Take(12).ToArray().CopyTo(returnByte66, 5); //机器编号
byte[] tunnels66 = data.Skip(13).Take(data.Length - 13).ToArray();
int loopTimes66 = (tunnels66.Length / 7);
KeyJsonModel jsonModel66 = new KeyJsonModel();
jsonModel66.m = machineNum66;
jsonModel66.t = new List <KeyTunnelModel>();
for (int i = 0; i < loopTimes66; i++)
{
jsonModel66.t.Add(new KeyTunnelModel()
{
tid = ByteHelper.GenerateRealityData(data.Skip(13 + i * 7).Take(5).ToArray(), "stringval"),
n = ByteHelper.GenerateRealityData(data.Skip(18 + i * 7).Take(2).ToArray(), "stringval")
});
}
try
{
int result66 = imachine.GetFullfilGoodByTunnel(jsonModel66);
if (result66 > 0)
{
returnByte66[17] = 48;
}
else
{
returnByte66[17] = 49;
}
}
catch (Exception e)
{
returnByte66[17] = 49;
}
returnByte66[18] = 238;
byte resultChunk66 = new byte();
byte[] finalResult66 = returnByte66.Skip(4).Take(size66).ToArray();
for (int i = 0; i < finalResult66.Length; i++)
{
resultChunk66 ^= finalResult66[i];
}
returnByte66[3] = resultChunk66;
//SendMsg(returnByteA5, myClientSocket);
ByteHelper.Encryption(size66, finalResult66.ToArray()).CopyTo(returnByte66, 4); //加密
return(returnByte66);
case "67": // 终端->服务器 补现金价格
int size67 = 14;
string machineNum67 = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
//string serialNum48 = ByteHelper.GenerateRealityData(data.Skip(13).Take(12).ToArray(), "stringval");
//string tunnelNumA5 = ByteHelper.GenerateRealityData(data.Skip(9).Take(5).ToArray(), "stringval");
byte[] returnByte67 = new byte[19];
returnByte67[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(size67).CopyTo(returnByte67, 1); //size
returnByte67[4] = data[0];
data.Skip(1).Take(12).ToArray().CopyTo(returnByte67, 5); //机器编号
byte[] tunnels67 = data.Skip(13).Take(data.Length - 13).ToArray();
int loopTimes67 = (tunnels67.Length / 10);
List <PriceAndMaxStockModel> lstPrice67 = new List <PriceAndMaxStockModel>();
for (int i = 0; i < loopTimes67; i++)
{
lstPrice67.Add(new PriceAndMaxStockModel()
{
tid = ByteHelper.GenerateRealityData(data.Skip(13 + i * 10).Take(5).ToArray(), "stringval"),
p1 = (decimal)int.Parse(ByteHelper.GenerateRealityData(data.Skip(18 + i * 10).Take(5).ToArray(), "stringval")) / 100
});
}
try
{
int result67 = imachine.PostCashPrice(lstPrice67, machineNum67);
if (result67 == 1)
{
returnByte67[17] = 48;
}
else
{
returnByte67[17] = 49;
}
}
catch (Exception e)
{
returnByte67[17] = 49;
}
returnByte67[18] = 238;
byte resultChunk67 = new byte();
byte[] finalResult67 = returnByte67.Skip(4).Take(size67).ToArray();
for (int i = 0; i < finalResult67.Length; i++)
{
resultChunk67 ^= finalResult67[i];
}
returnByte67[3] = resultChunk67;
//SendMsg(returnByteA5, myClientSocket);
ByteHelper.Encryption(size67, finalResult67.ToArray()).CopyTo(returnByte67, 4); //加密
return(returnByte67);
case "68": // 终端->服务器 补最大库存
int size68 = 14;
string machineNum68 = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
byte[] returnByte68 = new byte[19];
returnByte68[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(size68).CopyTo(returnByte68, 1); //size
returnByte68[4] = data[0];
data.Skip(1).Take(12).ToArray().CopyTo(returnByte68, 5); //机器编号
byte[] tunnels68 = data.Skip(13).Take(data.Length - 13).ToArray();
int loopTimes68 = (tunnels68.Length / 7);
List <PriceAndMaxStockModel> lstPrice68 = new List <PriceAndMaxStockModel>();
for (int i = 0; i < loopTimes68; i++)
{
lstPrice68.Add(new PriceAndMaxStockModel()
{
tid = ByteHelper.GenerateRealityData(data.Skip(13 + i * 7).Take(5).ToArray(), "stringval"),
ms = int.Parse(ByteHelper.GenerateRealityData(data.Skip(18 + i * 7).Take(2).ToArray(), "stringval"))
});
}
try
{
int result68 = imachine.PostMaxPuts(lstPrice68, machineNum68);
if (result68 == 1)
{
returnByte68[17] = 48;
}
else
{
returnByte68[17] = 49;
}
}
catch (Exception e)
{
returnByte68[17] = 49;
}
returnByte68[18] = 238;
byte resultChunk68 = new byte();
byte[] finalResult68 = returnByte68.Skip(4).Take(size68).ToArray();
for (int i = 0; i < finalResult68.Length; i++)
{
resultChunk68 ^= finalResult68[i];
}
returnByte68[3] = resultChunk68;
//SendMsg(returnByteA5, myClientSocket);
ByteHelper.Encryption(size68, finalResult68.ToArray()).CopyTo(returnByte68, 4); //加密
return(returnByte68);
case "6B": // 终端->服务器 上报现金出货
int size6B = 14; //加密的长度
string machineNum6B = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
//string serialNum48 = ByteHelper.GenerateRealityData(data.Skip(13).Take(12).ToArray(), "stringval");
//string tunnelNumA5 = ByteHelper.GenerateRealityData(data.Skip(9).Take(5).ToArray(), "stringval");
byte[] returnByte6B = new byte[19]; //返回的长度
returnByte6B[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(size6B).CopyTo(returnByte6B, 1); //size
returnByte6B[4] = data[0];
data.Skip(1).Take(12).ToArray().CopyTo(returnByte6B, 5); //机器编号
string tunnelId = ByteHelper.GenerateRealityData(data.Skip(13).Take(5).ToArray(), "stringval");
string price = ByteHelper.GenerateRealityData(data.Skip(18).Take(5).ToArray(), "stringval");
try
{
CashSaleModel cashInfo = new CashSaleModel();
cashInfo.SalesType = "1";
cashInfo.MachineId = machineNum6B;
cashInfo.GoodsId = tunnelId;
cashInfo.SalesPrices = (Convert.ToDouble(price) / 100).ToString("0.00");
int result6B = new CashSaleService().PostData(cashInfo);
if (result6B == 1)
{
returnByte6B[17] = 48;
}
else
{
returnByte6B[17] = 49;
}
}
catch (Exception e)
{
returnByte6B[17] = 49;
}
returnByte6B[18] = 238;
byte resultChunk6B = new byte();
byte[] finalResult6B = returnByte6B.Skip(4).Take(size6B).ToArray();
for (int i = 0; i < finalResult6B.Length; i++)
{
resultChunk6B ^= finalResult6B[i];
}
returnByte6B[3] = resultChunk6B;
//SendMsg(returnByteA5, myClientSocket);
ByteHelper.Encryption(size6B, finalResult6B.ToArray()).CopyTo(returnByte6B, 4); //加密
return(returnByte6B);
case "6C": // 终端->服务器 纸币器状态
int size6C = 14; //加密的长度
string machineNum6C = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
//string serialNum48 = ByteHelper.GenerateRealityData(data.Skip(13).Take(12).ToArray(), "stringval");
//string tunnelNumA5 = ByteHelper.GenerateRealityData(data.Skip(9).Take(5).ToArray(), "stringval");
byte[] returnByte6C = new byte[19]; //返回的长度
returnByte6C[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(size6C).CopyTo(returnByte6C, 1); //size
returnByte6C[4] = data[0];
data.Skip(1).Take(12).ToArray().CopyTo(returnByte6C, 5); //机器编号
string statusCode = ByteHelper.GenerateRealityData(data.Skip(13).Take(2).ToArray(), "stringval");
//string price = ByteHelper.GenerateRealityData(data.Skip(18).Take(5).ToArray(), "stringval");
try
{
CashEquipmentModel cashEquipment = new CashEquipmentModel();
cashEquipment.MachineId = machineNum6C;
cashEquipment.CashStatus = statusCode;
cashEquipment.UpdateType = "cash_status";
int result6C = new CashEquipmentService().UpdateData(cashEquipment);
if (result6C == 1)
{
returnByte6C[17] = 48;
}
else
{
returnByte6C[17] = 49;
}
}
catch (Exception e)
{
returnByte6C[17] = 49;
}
returnByte6C[18] = 238;
byte resultChunk6C = new byte();
byte[] finalResult6C = returnByte6C.Skip(4).Take(size6C).ToArray();
for (int i = 0; i < finalResult6C.Length; i++)
{
resultChunk6C ^= finalResult6C[i];
}
returnByte6C[3] = resultChunk6C;
//SendMsg(returnByteA5, myClientSocket);
ByteHelper.Encryption(size6C, finalResult6C.ToArray()).CopyTo(returnByte6C, 4); //加密
return(returnByte6C);
case "6D": // 终端->服务器 纸币器当前存量
int size6D = 14; //加密的长度
string machineNum6D = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
//string serialNum48 = ByteHelper.GenerateRealityData(data.Skip(13).Take(12).ToArray(), "stringval");
//string tunnelNumA5 = ByteHelper.GenerateRealityData(data.Skip(9).Take(5).ToArray(), "stringval");
byte[] returnByte6D = new byte[19]; //返回的长度
returnByte6D[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(size6D).CopyTo(returnByte6D, 1); //size
returnByte6D[4] = data[0];
data.Skip(1).Take(12).ToArray().CopyTo(returnByte6D, 5); //机器编号
string priceD = ByteHelper.GenerateRealityData(data.Skip(13).Take(10).ToArray(), "stringval");
//string price = ByteHelper.GenerateRealityData(data.Skip(18).Take(5).ToArray(), "stringval");
try
{
CashEquipmentModel cashEquipmentD = new CashEquipmentModel();
cashEquipmentD.MachineId = machineNum6D;
cashEquipmentD.CashStock = (Convert.ToInt32(priceD) / 100).ToString();
cashEquipmentD.UpdateType = "cash_stock";
int result6D = new CashEquipmentService().UpdateData(cashEquipmentD);
if (result6D == 1)
{
returnByte6D[17] = 48;
}
else
{
returnByte6D[17] = 49;
}
}
catch (Exception e)
{
returnByte6D[17] = 49;
}
returnByte6D[18] = 238;
byte resultChunk6D = new byte();
byte[] finalResult6D = returnByte6D.Skip(4).Take(size6D).ToArray();
for (int i = 0; i < finalResult6D.Length; i++)
{
resultChunk6D ^= finalResult6D[i];
}
returnByte6D[3] = resultChunk6D;
//SendMsg(returnByteA5, myClientSocket);
ByteHelper.Encryption(size6D, finalResult6D.ToArray()).CopyTo(returnByte6D, 4); //加密
return(returnByte6D);
case "6E": // 终端->服务器 硬币器状态
int size6E = 14; //加密的长度
string machineNum6E = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
//string serialNum48 = ByteHelper.GenerateRealityData(data.Skip(13).Take(12).ToArray(), "stringval");
//string tunnelNumA5 = ByteHelper.GenerateRealityData(data.Skip(9).Take(5).ToArray(), "stringval");
byte[] returnByte6E = new byte[19]; //返回的长度
returnByte6E[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(size6E).CopyTo(returnByte6E, 1); //size
returnByte6E[4] = data[0];
data.Skip(1).Take(12).ToArray().CopyTo(returnByte6E, 5); //机器编号
string coinStatusE = ByteHelper.GenerateRealityData(data.Skip(13).Take(2).ToArray(), "stringval");
//string price = ByteHelper.GenerateRealityData(data.Skip(18).Take(5).ToArray(), "stringval");
try
{
CashEquipmentModel cashEquipmentE = new CashEquipmentModel();
cashEquipmentE.MachineId = machineNum6E;
cashEquipmentE.CoinStatus = coinStatusE;
cashEquipmentE.UpdateType = "coin_status";
int result6E = new CashEquipmentService().UpdateData(cashEquipmentE);
if (result6E == 1)
{
returnByte6E[17] = 48;
}
else
{
returnByte6E[17] = 49;
}
}
catch (Exception e)
{
returnByte6E[17] = 49;
}
returnByte6E[18] = 238;
byte resultChunk6E = new byte();
byte[] finalResult6E = returnByte6E.Skip(4).Take(size6E).ToArray();
for (int i = 0; i < finalResult6E.Length; i++)
{
resultChunk6E ^= finalResult6E[i];
}
returnByte6E[3] = resultChunk6E;
//SendMsg(returnByteA5, myClientSocket);
ByteHelper.Encryption(size6E, finalResult6E.ToArray()).CopyTo(returnByte6E, 4); //加密
return(returnByte6E);
case "6F": // 终端->服务器 硬币器当前存量
int size6F = 14; //加密的长度
string machineNum6F = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
//string serialNum48 = ByteHelper.GenerateRealityData(data.Skip(13).Take(12).ToArray(), "stringval");
//string tunnelNumA5 = ByteHelper.GenerateRealityData(data.Skip(9).Take(5).ToArray(), "stringval");
byte[] returnByte6F = new byte[19]; //返回的长度
returnByte6F[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(size6F).CopyTo(returnByte6F, 1); //size
returnByte6F[4] = data[0];
data.Skip(1).Take(12).ToArray().CopyTo(returnByte6F, 5); //机器编号
byte[] datasF = data.Skip(13).Take(data.Length - 13).ToArray();
int loopTimesF = (datasF.Length / 10);
List <CoinStockModel> lstCoin = new List <CoinStockModel>();
for (int i = 0; i < loopTimesF; i++)
{
CoinStockModel coinStock = new CoinStockModel();
coinStock.Money = ByteHelper.GenerateRealityData(data.Skip(13 + i * 10).Take(5).ToArray(), "stringval");
coinStock.Number = ByteHelper.GenerateRealityData(data.Skip(18 + i * 10).Take(5).ToArray(), "stringval");
}
try
{
CashEquipmentModel cashEquipmentF = new CashEquipmentModel();
cashEquipmentF.MachineId = machineNum6F;
cashEquipmentF.CoinStock = JsonHandler.GetJsonStrFromObject(lstCoin, false);
cashEquipmentF.UpdateType = "coin_stock";
int result6F = new CashEquipmentService().UpdateData(cashEquipmentF);
if (result6F == 1)
{
returnByte6F[17] = 48;
}
else
{
returnByte6F[17] = 49;
}
}
catch (Exception e)
{
returnByte6F[17] = 49;
}
returnByte6F[18] = 238;
byte resultChunk6F = new byte();
byte[] finalResult6F = returnByte6F.Skip(4).Take(size6F).ToArray();
for (int i = 0; i < finalResult6F.Length; i++)
{
resultChunk6F ^= finalResult6F[i];
}
returnByte6F[3] = resultChunk6F;
//SendMsg(returnByteA5, myClientSocket);
ByteHelper.Encryption(size6F, finalResult6F.ToArray()).CopyTo(returnByte6F, 4); //加密
return(returnByte6F);
case "90": // 终端->服务器 上报现金出货
int size90 = 14; //加密的长度
string machineNum90 = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
//string serialNum48 = ByteHelper.GenerateRealityData(data.Skip(13).Take(12).ToArray(), "stringval");
//string tunnelNumA5 = ByteHelper.GenerateRealityData(data.Skip(9).Take(5).ToArray(), "stringval");
byte[] returnByte90 = new byte[19]; //返回的长度
returnByte90[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(size90).CopyTo(returnByte90, 1); //size
returnByte90[4] = data[0];
data.Skip(1).Take(12).ToArray().CopyTo(returnByte90, 5); //机器编号
string tunnelId90 = ByteHelper.GenerateRealityData(data.Skip(13).Take(5).ToArray(), "stringval");
string price90 = ByteHelper.GenerateRealityData(data.Skip(18).Take(5).ToArray(), "stringval");
try
{
CashSaleModel cashInfo90 = new CashSaleModel();
cashInfo90.SalesType = "2";
cashInfo90.MachineId = machineNum90;
cashInfo90.GoodsId = tunnelId90;
cashInfo90.SalesPrices = (Convert.ToDouble(price90) / 100).ToString("0.00");
int result6B = new CashSaleService().PostData(cashInfo90);
if (result6B == 1)
{
returnByte90[17] = 48;
}
else
{
returnByte90[17] = 49;
}
}
catch (Exception e)
{
returnByte90[17] = 49;
}
returnByte90[18] = 238;
byte resultChunk90 = new byte();
byte[] finalResult90 = returnByte90.Skip(4).Take(size90).ToArray();
for (int i = 0; i < finalResult90.Length; i++)
{
resultChunk90 ^= finalResult90[i];
}
returnByte90[3] = resultChunk90;
//SendMsg(returnByteA5, myClientSocket);
ByteHelper.Encryption(size90, finalResult90.ToArray()).CopyTo(returnByte90, 4); //加密
return(returnByte90);
case "A0": // 终端->服务器 取货码验证
int sizeA0 = 20; //加密的长度
string machineNumA0 = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
//string serialNum48 = ByteHelper.GenerateRealityData(data.Skip(13).Take(12).ToArray(), "stringval");
//string tunnelNumA5 = ByteHelper.GenerateRealityData(data.Skip(9).Take(5).ToArray(), "stringval");
byte[] returnByteA0 = new byte[25]; //返回的长度
returnByteA0[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(sizeA0).CopyTo(returnByteA0, 1); //size
returnByteA0[4] = data[0];
data.Skip(1).Take(12).ToArray().CopyTo(returnByteA0, 5); //机器编号
//string tunnelId90 = ByteHelper.GenerateRealityData(data.Skip(13).Take(5).ToArray(), "stringval");
//string price90 = ByteHelper.GenerateRealityData(data.Skip(18).Take(5).ToArray(), "stringval");
string pickupCodeA0 = ByteHelper.GenerateRealityData(data.Skip(13).Take(8).ToArray(), "stringval");
try
{
ClientSalesRelationModel clientSalesInfoA0 = new ClientSalesRelationModel();
clientSalesInfoA0.MachineId = machineNumA0;
clientSalesInfoA0.PickupNo = pickupCodeA0;
List <ClientSalesRelationModel> lstClientSales = new WechatService().VerifyPickupCode(clientSalesInfoA0);
if (lstClientSales.Count == 0)
{
returnByteA0[23] = 49; //非法取货
}
else if (lstClientSales.Count > 1)
{
returnByteA0[23] = 52; //其它
}
else
{
ClientSalesRelationModel retInfo = lstClientSales[0];
if (retInfo.CurrentStatus != 1)
{
returnByteA0[23] = 51; //商品售空
}
else if (retInfo.CurrentStock == 0)
{
returnByteA0[23] = 51; //商品售空
}
else
{
returnByteA0[23] = 48;
ByteHelper.StrToByte(retInfo.TunnelId).CopyTo(returnByteA0, 17);
if (retInfo.TotalNum == 0)
{
ByteHelper.strToAscii("1").CopyTo(returnByteA0, 22);
}
else
{
ByteHelper.strToAscii(retInfo.TotalNum.ToString()).CopyTo(returnByteA0, 22);
}
}
}
}
catch (Exception e)
{
returnByteA0[23] = 53;
}
returnByteA0[24] = 238;
byte resultChunkA0 = new byte();
byte[] finalResultA0 = returnByteA0.Skip(4).Take(sizeA0).ToArray();
for (int i = 0; i < finalResultA0.Length; i++)
{
resultChunkA0 ^= finalResultA0[i];
}
returnByteA0[3] = resultChunkA0;
//SendMsg(returnByteA5, myClientSocket);
ByteHelper.Encryption(sizeA0, finalResultA0.ToArray()).CopyTo(returnByteA0, 4); //加密
return(returnByteA0);
case "A1": // 终端->服务器 上报取货码结果
int sizeA1 = 2; //加密的长度
string machineNumA1 = ByteHelper.GenerateRealityData(data.Skip(1).Take(12).ToArray(), "stringval");
string pickupCodeA1 = ByteHelper.GenerateRealityData(data.Skip(13).Take(8).ToArray(), "stringval");
string tunnelNumA1 = ByteHelper.GenerateRealityData(data.Skip(21).Take(5).ToArray(), "stringval");
string totalNumA1 = ByteHelper.GenerateRealityData(data.Skip(26).Take(1).ToArray(), "stringval");
byte[] returnByteA1 = new byte[7]; //返回的长度
returnByteA1[0] = byteInfo[0]; //包头;
ByteHelper.IntToTwoByte(sizeA1).CopyTo(returnByteA1, 1); //size
returnByteA1[4] = data[0];
try
{
ClientSalesRelationModel clientSalesInfoA1 = new ClientSalesRelationModel();
clientSalesInfoA1.MachineId = machineNumA1;
clientSalesInfoA1.PickupNo = pickupCodeA1;
clientSalesInfoA1.TunnelId = tunnelNumA1;
clientSalesInfoA1.TotalNum = int.Parse(totalNumA1);
if (data[27] == 48)
{
clientSalesInfoA1.Remark = "成功";
}
else if (data[27] == 49)
{
clientSalesInfoA1.Remark = "失败";
}
else if (data[27] == 50)
{
clientSalesInfoA1.Remark = "货道故障";
}
else
{
clientSalesInfoA1.Remark = "其它故障";
}
int resultA1 = new WechatService().PutPayResultByPickupCode(clientSalesInfoA1);
if (resultA1 == 0)
{
returnByteA1[5] = 49;
}
else
{
returnByteA1[5] = 48;
}
}
catch (Exception e)
{
returnByteA1[5] = 49;
}
returnByteA1[6] = 238;
byte resultChunkA1 = new byte();
byte[] finalResultA1 = returnByteA1.Skip(4).Take(sizeA1).ToArray();
for (int i = 0; i < finalResultA1.Length; i++)
{
resultChunkA1 ^= finalResultA1[i];
}
returnByteA1[3] = resultChunkA1;
//SendMsg(returnByteA5, myClientSocket);
ByteHelper.Encryption(sizeA1, finalResultA1.ToArray()).CopyTo(returnByteA1, 4); //加密
return(returnByteA1);
}
return(new byte[0]);
}
//按货道更新
public int GetFullfilGoodByTunnel(KeyJsonModel keyJsonModel)
{
try
{
GenerateDal.BeginTransaction();
foreach (KeyTunnelModel keyTunnelInfo in keyJsonModel.t)
{
TunnelInfoModel tunnelInfo = new TunnelInfoModel();
tunnelInfo.MachineId = keyJsonModel.m;
tunnelInfo.GoodsStuId = keyTunnelInfo.tid;
if (!string.IsNullOrEmpty(keyTunnelInfo.n))
{
tunnelInfo.CurrStock = Convert.ToInt32(keyTunnelInfo.n);
}
if (string.IsNullOrEmpty(keyTunnelInfo.s))
{
tunnelInfo.CurrStatus = "1";
}
else
{
tunnelInfo.CurrStatus = keyTunnelInfo.s;
}
tunnelInfo.UpdateDate = DateTime.Now;
tunnelInfo.CabinetId = GetCabinetIdByMachine(keyJsonModel.m);
/*
* var conditions = new List<Condition>();
*
* conditions.Add(new Condition
* {
* LeftBrace = " AND ",
* ParamName = "MachineId",
* DbColumnName = "machine_id",
* ParamValue = tunnelInfo.MachineId,
* Operation = ConditionOperate.Equal,
* RightBrace = "",
* Logic = ""
* });
*
* conditions.Add(new Condition
* {
* LeftBrace = " AND ",
* ParamName = "GoodsStuId",
* DbColumnName = "goods_stu_id",
* ParamValue = tunnelInfo.GoodsStuId,
* Operation = ConditionOperate.Equal,
* RightBrace = "",
* Logic = ""
* });
*
* conditions.Add(new Condition
* {
* LeftBrace = " AND ",
* ParamName = "CabinetId",
* DbColumnName = "cabinet_id",
* ParamValue = tunnelInfo.CabinetId,
* Operation = ConditionOperate.Equal,
* RightBrace = "",
* Logic = ""
* });
*
* int resultStatusCount = GenerateDal.CountByConditions(CommonSqlKey.IsExistTunnelInfo, conditions);
* if (resultStatusCount > 0)
* {
*
* }
* else
* {
* GenerateDal.Create<TunnelInfoModel>(tunnelInfo);
* }
*/
GenerateDal.Delete <TunnelInfoModel>(CommonSqlKey.DeleteTunnelStatusByMachineAndTunnel, tunnelInfo);
GenerateDal.Create <TunnelInfoModel>(tunnelInfo);
}
//往机器下行表里插入库存改变的数据
PostToMachine(keyJsonModel.m, "st");
//操作日志
operationService.PostData(new OperationLogModel()
{
MachineId = keyJsonModel.m, OptContent = "按货道补货"
});
GenerateDal.CommitTransaction();
}
catch (Exception e)
{
GenerateDal.RollBack();
return(0);
}
return(1);
}