using Admin.NET.Core.EnterWareHouseModule;
|
using iWareCommon.Utils;
|
using iWareModel;
|
using iWareSql.MyDbContext;
|
using iWareTestForm;
|
using iWareTestForm.Model;
|
using Newtonsoft.Json;
|
using NPOI.SS.Formula.PTG;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Windows.Forms;
|
|
namespace XiGang_iWareTestForm.iWareTest.DialogForm
|
{
|
public partial class TestBatchForm : Form
|
{
|
delegate void Delegate_SetPostResult2(string content);
|
public TestBatchForm()
|
{
|
InitializeComponent();
|
}
|
|
private void LoadItemType()
|
{
|
List<ListItem> itemList = new List<ListItem>();
|
itemList.Add(new ListItem()
|
{
|
Text = "发送机",
|
Value = "1"
|
});
|
itemList.Add(new ListItem()
|
{
|
Text = "托盘",
|
Value = "2"
|
});
|
foreach (var item in itemList)
|
{
|
this.cmbItemType.Items.Add(item);
|
}
|
|
cmbItemType.SelectedIndex = 1;
|
}
|
|
/// <summary>
|
/// 显示请求结果
|
/// </summary>
|
/// <param name="content"></param>
|
private void ShowResult(string content)
|
{
|
|
if (this.tb_Log.InvokeRequired)
|
{
|
Delegate_SetPostResult2 delegate_SetPostResult = new Delegate_SetPostResult2(ShowResult);
|
this.Invoke(delegate_SetPostResult, new object[] { content });
|
}
|
else
|
{
|
//content += "\r\n";
|
this.tb_Log.Text = StringHelper.GetLog(content) + this.tb_Log.Text;
|
}
|
}
|
|
private void button2_Click(object sender, EventArgs e)
|
{
|
//ClearPlace();
|
}
|
|
|
|
private void TestBatchForm_Load(object sender, EventArgs e)
|
{
|
LoadItemType();
|
this.tb_SalverCount.Text = "1";
|
}
|
|
private void button3_Click(object sender, EventArgs e)
|
{
|
//测试打印
|
ShowResult($"开始打印");
|
Dictionary<string, object> data = new Dictionary<string, object>();
|
data.Add("bar", "heihei");
|
data.Add("material", "heihei");
|
data.Add("supplier", "heihei");
|
data.Add("unit", "heihei");
|
data.Add("date", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
|
|
//调用打印接口
|
bool isSuccess = false;
|
string errMsg = "";
|
using (iWareTestForm.PrintBaseService.PrintWcfServiceClient client = new iWareTestForm.PrintBaseService.PrintWcfServiceClient())
|
{
|
isSuccess = client.Print3(data, 1, @"D:\打印程序\跟踪码打印模板\跟踪码打印模板_一维码.btw", "ZDesigner ZD888-203dpi ZPL", out errMsg);
|
}
|
if (isSuccess)
|
{
|
ShowResult($"打印成功");
|
}
|
else
|
{
|
ShowResult($"打印失败:" + errMsg);
|
}
|
|
|
}
|
|
/// <summary>
|
/// 生成批次号
|
/// </summary>
|
/// <param name="prefix"></param>
|
/// <returns></returns>
|
public string CreateBatchNo(string prefix)
|
{
|
string BarNo = "WH" + Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")).Ticks.ToString();
|
return BarNo;
|
}
|
|
|
private List<string> GetString()
|
{
|
List<String> list = new List<string>();
|
list.Add("2-01-10-02".Trim());
|
list.Add("1-01-04-01".Trim());
|
|
list.Add("1-01-06-04".Trim());
|
|
return list;
|
}
|
|
private void button1_Click(object sender, EventArgs e)
|
{
|
////零件归还管理增加
|
//List<ware_sorting_details> ware_Sorting_Details = new List<ware_sorting_details>();
|
|
////借用单库存增加
|
//using (MyDbContext dbContext = new MyDbContext())
|
//{
|
|
// //获取所有 借用单的明细
|
// var orders = dbContext.ware_orders.Where(x => x.OrderType == "11" && x.OrderNo == "借用" && (x.IsDeleted == null || x.IsDeleted == false)).ToList();
|
// var ids = orders.Select(y => y.Id).ToList();
|
// var details = dbContext.ware_orders_details.Where(x => ids.Contains(x.OrdersId) && (x.IsDeleted == null || x.IsDeleted == false)).ToList();
|
|
|
|
|
// // 创建分拣订单
|
|
// var sortingOrder = new ware_sorting
|
// {
|
// Id = Yitter.IdGenerator.YitIdHelper.NextId(),
|
// OrderNo = Yitter.IdGenerator.YitIdHelper.NextId().ToString(),
|
// OrderType = "1",//借用取货单
|
// Remarks = "分拣单创建",
|
// OrderStatus = (int)EnumWarehousStatus.Completed,
|
// IsDeleted = false,
|
// Status = 0
|
// };
|
|
// List<string> str = new List<string>();
|
// List<long> str1 = new List<long>();
|
// foreach (var item in details)
|
// {
|
// ware_Sorting_Details.Add(new ware_sorting_details
|
// {
|
// Status = 0,
|
// Id = Yitter.IdGenerator.YitIdHelper.NextId(),
|
// OrdersId = sortingOrder.Id,
|
// WareContainerCode = "",
|
// WareContainerName = "",
|
// WareMaterialCode = item.WareMaterialCode,
|
// WareMaterialName = "",
|
// Unit = "",
|
// CompleteQuantity = item.Quantity,
|
// Quantity = item.Quantity,
|
// OrderStatus = (int)EnumWarehousStatus.Completed,
|
// DeliveryNo = "借用",
|
// IsDeleted = false
|
// });
|
// }
|
|
// dbContext.ware_sorting.Add(sortingOrder);
|
// dbContext.ware_sorting_details.AddRange(ware_Sorting_Details);
|
|
// dbContext.SaveChanges();
|
|
//}
|
|
//ShowResult($"新增{ware_Sorting_Details.Count}条");
|
}
|
|
private void btn_SelectFile_Click(object sender, EventArgs e)
|
{
|
OpenFileDialog fileDialog = new OpenFileDialog();
|
fileDialog.Multiselect = true;
|
fileDialog.Title = "请选择文件";
|
fileDialog.Filter = "所有文件(*xls*)|*.xls*"; //设置要选择的文件的类型
|
if (fileDialog.ShowDialog() == DialogResult.OK)
|
{
|
string file = fileDialog.FileName;//返回文件的完整路径
|
this.tb_FilePath.Text = file;
|
}
|
}
|
|
private void button2_Click_1(object sender, EventArgs e)
|
{
|
// 批量导入 客户寄售区库存
|
// var name = this.tb_KeHuJiShouKuWei.Text;
|
// if (string.IsNullOrEmpty(name))
|
// {
|
// MessageBox.Show("请输入客户寄售区名称!");
|
// return;
|
// }
|
// string filePath = this.tb_FilePath.Text;
|
// if (filePath == string.Empty)
|
// {
|
// MessageBox.Show("请选择Excel!");
|
// return;
|
// }
|
|
// Dictionary<string, string> cellheader = new Dictionary<string, string> {
|
// { "MaterialNo", "零件号" },
|
// { "MaterialName", "名称" },
|
// { "Quntity", "数量" }
|
// };
|
|
// 1.2解析文件，存放到一个List集合里
|
//StringBuilder errorMsg = new StringBuilder(); // 错误信息
|
// string tableDesc = "", tableName = "";
|
// List<MyMaterial> enlist = ExcelHelper.ExcelToEntityListForCreateTable<MyMaterial>(cellheader, filePath, out tableDesc, out tableName, out errorMsg);
|
// if (!string.IsNullOrEmpty(errorMsg.ToString()))
|
// {
|
// MessageBox.Show("错误:" + errorMsg.ToString());
|
// return;
|
// }
|
|
// 汇总数据
|
// List<MyMaterial> inertList = new List<MyMaterial>();
|
// foreach (var item in enlist)
|
// {
|
// if (!string.IsNullOrEmpty(item.MaterialNo))
|
// {
|
// var zz = inertList.Where(x => x.MaterialNo == item.MaterialNo).FirstOrDefault();
|
// if (zz == null)
|
// {
|
// inertList.Add(new MyMaterial()
|
// {
|
// MaterialNo = item.MaterialNo,
|
// MaterialName = item.MaterialName,
|
// Quntity = item.Quntity
|
// });
|
// }
|
// else
|
// {
|
// zz.Quntity += item.Quntity;
|
// }
|
// }
|
// }
|
|
|
// List<ware_container_vs_material> addList = new List<ware_container_vs_material>();
|
// ware_container_vs_material aa = null;
|
// using (MyDbContext dbContext = new MyDbContext())
|
// {
|
// var ddd = dbContext.ware_location_vs_container.Where(x => x.WareContainerCode == name).FirstOrDefault();
|
|
// if (ddd == null)
|
// {
|
// 默认自己写入
|
// ddd = new ware_location_vs_container()
|
// {
|
// Id = Yitter.IdGenerator.YitIdHelper.NextId(),
|
// WareContainerCode = name,
|
// WareContainerName = name,
|
// WareLocationCode = name,
|
// IsEmptyContainer = false,
|
// IsDeleted = false
|
// };
|
// dbContext.ware_location_vs_container.Add(ddd);
|
// }
|
|
// var barno = CreateBatchNo("");
|
// foreach (var item in inertList)
|
// {
|
// aa = new ware_container_vs_material
|
// {
|
// Id = Yitter.IdGenerator.YitIdHelper.NextId(),
|
// locationVsContainerid = ddd.Id,
|
// WareContainerCode = name,
|
// WareMaterialCode = item.MaterialNo,
|
// Quantity = item.Quntity,
|
// PurchaseNo = "",
|
// DeliveryNo = "",
|
// CollectNo = "",
|
// OCCQuantity = 0,
|
// ITEMBATCHNO = "",
|
// OrdersNo = "",//入库单号
|
// Status = 0,
|
// TenantId = null,
|
// CreatedTime = DateTime.Now,
|
// CreatedUserId = CurrentUserInfo.UserId,
|
// CreatedUserName = CurrentUserInfo.Name,
|
// IsLocked = false,
|
// LockRemark = "平库入库,新增物料，初始为false",
|
// DoLockTime = DateTime.Now,
|
|
// IsDeleted = false,
|
// Remarks = "自动插入",
|
// StockStatus = 2,
|
// BarNo = barno,
|
// MaterialType = item.ma,
|
// LocationType = 2,
|
|
// MaterialRegionId = wareRegion.Id,
|
// MaterialRegionCode = wareRegion.Code,
|
// MaterialRegionName = wareRegion.Name
|
// ,
|
// CustomerCode = CustomerCode
|
// ,
|
// MachineToolName = MachineToolName
|
// ,
|
// MachineToolId = MachineToolId,
|
|
// RealWareContainerCode = realWareContainerCode //记录真实的托盘号，用于展示组盘区域中的真实托盘号 [Editby shaocx,2023-01-31]
|
// };
|
// addList.Add(aa);
|
// }
|
|
// dbContext.ware_container_vs_material.AddRange(addList);
|
|
|
// dbContext.SaveChanges();
|
|
// }
|
// ShowResult($"新增{addList.Count}条");
|
}
|
|
private void button4_Click(object sender, EventArgs e)
|
{
|
////采购单明细中没有行号的赋值为有值
|
|
////零件归还管理增加
|
//List<ware_purchase_order_details> orders = new List<ware_purchase_order_details>();
|
|
////借用单库存增加
|
//using (MyDbContext dbContext = new MyDbContext())
|
//{
|
|
// //获取所有 借用单的明细
|
// orders = dbContext.ware_purchase_order_details.Where(x => (x.EBELP == null || x.EBELP == "")).ToList();
|
|
// foreach (var item in orders)
|
// {
|
// item.EBELP = Yitter.IdGenerator.YitIdHelper.NextId().ToString();
|
// }
|
|
// dbContext.SaveChanges();
|
//}
|
|
//ShowResult($"新增{orders.Count}条");
|
}
|
|
private void button5_Click(object sender, EventArgs e)
|
{
|
|
//List<FunRetEntity> errList = new List<FunRetEntity>();
|
//int addCount = 0, updateCount = 0;
|
|
////批量更新容器的栅格数（生产库用）
|
//string filePath = this.tb_FilePath.Text;
|
//if (filePath == string.Empty)
|
//{
|
// MessageBox.Show("请选择Excel!");
|
// return;
|
//}
|
|
//Dictionary<string, string> cellheader = new Dictionary<string, string> {
|
// { "LocationCode", "库位号" },
|
// { "GridNumber", "栅格数" }
|
// };
|
|
//// 1.2解析文件，存放到一个List集合里
|
//StringBuilder errorMsg = new StringBuilder(); // 错误信息
|
//string tableDesc = "", tableName = "";
|
//List<MyLocation> myLocationList = ExcelHelper.ExcelToEntityListForCreateTable<MyLocation>(cellheader, filePath, out tableDesc, out tableName, out errorMsg);
|
//if (!string.IsNullOrEmpty(errorMsg.ToString()))
|
//{
|
// MessageBox.Show("错误:" + errorMsg.ToString());
|
// return;
|
//}
|
|
|
//List<ware_container_vs_material> addList = new List<ware_container_vs_material>();
|
//ware_container_vs_material aa = null;
|
//using (MyDbContext dbContext = new MyDbContext())
|
//{
|
// foreach (var item in myLocationList)
|
// {
|
|
// SimulatorCommonHelper.GetGridNumber(item);
|
|
// var los = dbContext.ware_location.Where(x => x.Code == item.LocationCode && (x.IsDeleted == null || x.IsDeleted == false)).ToList();
|
// if (los == null || los.Count == 0)
|
// {
|
// errList.Add(new FunRetEntity()
|
// {
|
// resData = item.LocationCode,
|
// resMsg = $"{item.LocationCode}库位没有找到"
|
// }); ; ;
|
// }
|
// else if (los.Count > 1)
|
// {
|
// //数据不正确
|
// errList.Add(new FunRetEntity()
|
// {
|
// resData = item.LocationCode,
|
// resMsg = $"{item.LocationCode}库位数超过了1条"
|
// }); ; ;
|
// }
|
|
// var ddds = dbContext.ware_container.Where(x => x.Code == item.LocationCode && (x.IsDeleted == null || x.IsDeleted == false)).ToList();
|
// if (ddds == null || ddds.Count == 0)
|
// {
|
// //新增
|
// var add_container = new ware_container()
|
// {
|
// IsDeleted = false,
|
// IsVirtual = 1,
|
// Id = Yitter.IdGenerator.YitIdHelper.NextId(),
|
// Code = item.LocationCode,
|
// Name = item.LocationCode,
|
// CreatedTime = DateTime.Now,
|
// UpdatedTime = DateTime.Now,
|
// CreatedUserName = "系统初始",
|
// UpdatedUserName = "系统初始",
|
// Status = 0,
|
// GridNumber = Convert.ToInt32(item.GridNumber)
|
// };
|
// //计算已占用栅格数
|
// add_container.UseNumber = ContainerHandler.ReCalcUseNumber(dbContext, item.LocationCode);
|
|
// dbContext.ware_container.Add(add_container);
|
// addCount++;
|
|
// }
|
// else if (ddds.Count > 1)
|
// {
|
// //数据不正确
|
// errList.Add(new FunRetEntity()
|
// {
|
// resData = item.LocationCode,
|
// resMsg = $"{item.LocationCode}容器数超过了1条"
|
// }); ; ;
|
// }
|
// else
|
// {//已存在
|
// var db_container = ddds.FirstOrDefault();
|
// db_container.GridNumber = Convert.ToInt32(item.GridNumber);
|
// //计算已占用栅格数
|
// db_container.UseNumber = ContainerHandler.ReCalcUseNumber(dbContext, item.LocationCode);
|
// updateCount++;
|
// }
|
// }
|
|
|
// dbContext.SaveChanges();
|
|
//}
|
//ShowResult($"新增{addCount}条");
|
//ShowResult($"更新{updateCount}条");
|
//ShowResult($"错误{errList.Count}条," + JsonConvert.SerializeObject(errList));
|
}
|
|
private void button6_Click(object sender, EventArgs e)
|
{
|
this.tb_Yitter.Text = Yitter.IdGenerator.YitIdHelper.NextId().ToString();
|
ShowResult(this.tb_Yitter.Text);
|
}
|
}
|
}
|
