private void search()
{
List <InBound.OutBound> list = AtsCellInfoDetailService.GetDetail(tbCode.Text, tbName.Text);
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = list;
}
public void searchQuery()
{
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = AtsCellInfoDetailService.GetCheckIng(tbName.Text.Trim(), tbCode.Text.Trim());
}
public void sendTask()
{
//List<T_WMS_INBOUND_LINE> list = InBoundLineService.GetItem(inboundid);
//if (list != null && list.Count > 0)
//{
// using (TransactionScope ts = new TransactionScope())
// {
// foreach (var item in list)
// {
// INF_JOBDOWNLOAD job = new INF_JOBDOWNLOAD();
// CBAddress.BeginInvoke(new getIndex(getCBSelectIndex));
// job.SOURCE = address[selectIndex];
// job.PLANQTY = item.BOXQTY;
// job.JOBTYPE = 1;//入库任务
// job.PRIORITY = 50;
// job.CREATEDATE = DateTime.Now;
// job.BRANDID = decimal.Parse(item.CIGARETTECODE);
// job.TUTYPE = 1;
// InfJobDownLoadService.InsertEntity(job);
// InBoundLineService.Update(item.INBOUNDDETAILID, 0, item.BOXQTY??0);
// }
// InBoundService.Update(inboundid, "20");
// ts.Complete();
// }
//}
T_WMS_INBOUND_LINE entity = InBoundLineService.GetItemByID(int.Parse(((List <String>)tbChooseName.Tag)[0].ToString()));
decimal? num = 0;
num = decimal.Parse(tbNum.Text);
// if (num > (entity.BOXQTY - entity.LOCKQTY))
//{
// MessageBox.Show("任务数量超出入库单数量,请修正.");
// return;
//}
INF_JOBDOWNLOAD job = new INF_JOBDOWNLOAD();
// CBAddress.BeginInvoke(new getIndex(getCBSelectIndex));
T_WMS_ITEM item = ItemService.GetItemByBarCode(((List <String>)tbChooseName.Tag)[0].ToString());
job.SOURCE = "1217";// address[selectIndex];
job.FULLCOUNT = item.FULLCOUNT;
job.PILETYPE = decimal.Parse(item.DXTYPE);
job.TARGET = AtsCellInService.getCellNo(((List <String>)tbChooseName.Tag)[0].ToString());//储位地址
if (job.TARGET == "")
{
MessageBox.Show("获取储位信息失败");
return;
}
job.PLANQTY = num;
job.JOBTYPE = 20;//入库任务
job.PRIORITY = 50;
job.CREATEDATE = DateTime.Now;
job.BRANDID = ((List <String>)tbChooseName.Tag)[0].ToString();
job.TUTYPE = 4;
job.INPUTTYPE = 10;
job.INBOUNDNO = int.Parse(((List <String>)tbChooseName.Tag)[1].ToString());
String palletNo = RefRFIDPalletService.GetPallet(tbRfid.Text);
if (palletNo == "E")
{
MessageBox.Show("该托盘已在使用,请确认Rfid是否输入正确");
return;
}
job.BARCODE = palletNo;
if (cbcDuo.Checked)
{
job.CDTYPE = 10;
}
else
{
job.CDTYPE = 0;
}
InfJobDownLoadService.InsertEntity(job); //插入任务
InBoundLineService.Update(job.INBOUNDNO ?? 0, 0, job.PLANQTY ?? 0);
T_WMS_ATSCELLINFO info = new T_WMS_ATSCELLINFO();
info.PALLETNO = job.BARCODE;
// info.DISMANTLE = 1;
info.CELLNO = job.TARGET;
info.STATUS = 10;//上架
info.CREATETIME = DateTime.Now;
info.INBOUNDID = job.INBOUNDNO;
info.DISMANTLE = 10;
AtsCellInfoService.InsertAtsCellInfo(info);
T_WMS_ATSCELLINFO_DETAIL detail = new T_WMS_ATSCELLINFO_DETAIL();
detail.CIGARETTECODE = ItemService.GetItemByBarCode(job.BRANDID).ITEMNO;
detail.CIGARETTENAME = ItemService.GetItemByBarCode(job.BRANDID).ITEMNAME;
detail.BARCODE = job.BRANDID;
detail.QTY = job.PLANQTY;
detail.CELLNO = info.CELLNO;
AtsCellInfoDetailService.InsertAtsCellInfo(detail);
MessageBox.Show("任务已下达");
WriteLog.GetLog().Write(job.JOBID + "号任务已下达;入口地址:" + job.SOURCE);
searchTask();
initText();
}
public void search()
{
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = AtsCellInfoDetailService.GetCheckIng();
}
private void button1_Click(object sender, EventArgs e)
{
if (cbAdress.SelectedIndex == -1)
{
MessageBox.Show("请选择出库口");
return;
}
if (tbChooseName.Tag == null)
{
MessageBox.Show("请选择出库品牌");
return;
}
if (cbAdress.SelectedIndex == 2)
{
if (((List <String>)tbChooseName.Tag)[0].ToString() != "1111111")
{
MessageBox.Show("托盘出库中只能出库托盘");
return;
}
else
{
if (InfJobDownLoadService.GetPalletUnFinishTask() > 0)
{
DialogResult MsgBoxResult = MessageBox.Show("已有在出库的托盘任务,确定要空托盘出库?", //对话框的显示内容
"操作提示", //对话框的标题
MessageBoxButtons.YesNo, //定义对话框的按钮，这里定义了YSE和NO两个按钮
MessageBoxIcon.Question, //定义对话框内的图表式样，这里是一个黄色三角型内加一个感叹号
MessageBoxDefaultButton.Button2); //定义对话框的按钮式样
//Console.WriteLine(MsgBoxResult);
if (MsgBoxResult == DialogResult.Yes)
{
}
else
{
return;
}
}
}
}
if (cbType.SelectedIndex == -1)
{
MessageBox.Show("请选择出库类型");
return;
}
if (tbPlanQty.Text == "")
{
MessageBox.Show("请输入计划数量");
return;
}
int planQty = int.Parse(tbPlanQty.Text);
// String barCode = ((List<String>)tbChooseName.Tag)[2].ToString();
String cigaretteName = ((List <String>)tbChooseName.Tag)[1].ToString();
String cigaretteCode = ((List <String>)tbChooseName.Tag)[0].ToString();
int totalQty = int.Parse(((List <String>)tbChooseName.Tag)[3].ToString());
T_WMS_ITEM itemDetail = ItemService.GetItemByCode(cigaretteCode);
if (planQty > totalQty)
{
MessageBox.Show("计划出库数量大于库存,请修改出库数量");
return;
}
//10 调拨出库 20 抽检出库 30 补货出库 40 盘点出库 100 其他
if (cbType.SelectedIndex != 0)//非调拨出库
{
if (planQty > itemDetail.FULLCOUNT)
{
MessageBox.Show("计划数量不能大于满盘数量");
return;
}
else
{
INF_JOBDOWNLOAD job = new INF_JOBDOWNLOAD();
decimal id = BaseService.GetSeq("select S_ATSCELL_OUT.nextval from dual");
job.TARGET = address[cbAdress.SelectedIndex];
if (cbType.SelectedIndex == 4)
{
job.SOURCE = ((List <String>)tbChooseName.Tag)[2].ToString();
AtsCellOutService.UpdateCellOutStatus(job.SOURCE, planQty);
}
else
{
if (cbType.SelectedIndex == 1)
{
job.SOURCE = AtsCellOutService.getCellNoBig(cigaretteCode, planQty);//先进先出
}
else
{
job.SOURCE = AtsCellOutService.getCellNoMath(cigaretteCode, planQty);//先进先出
}
}
if (job.SOURCE == "")
{
MessageBox.Show("下载任务失败,请修改任务");
return;
}
else
{
// AtsCellOutService.UpdateCellOutStatus(job.SOURCE,planQty);
}
job.BARCODE = AtsCellInfoService.GetCellInfo(job.SOURCE).PALLETNO; //托盘号
job.PLANQTY = planQty;
job.JOBTYPE = 52; //
job.PRIORITY = 50;
job.CREATEDATE = DateTime.Now;
job.BRANDID = itemDetail.BIGBOX_BAR;
if (cbAdress.SelectedIndex == 1)
{
job.TUTYPE = 3;//二楼人工口
}
else
{
job.TUTYPE = 4;
}
job.INPUTTYPE = 10;
job.TASKNO = id;
job.TARGET = address[cbAdress.SelectedIndex];
using (TransactionScope ts = new TransactionScope())
{
InfJobDownLoadService.InsertEntity(job);
T_WMS_ATSCELL_OUT outcell = new T_WMS_ATSCELL_OUT();
outcell.REQUESTQTY = job.PLANQTY;
outcell.OUTTARGET = job.TARGET;
//10 调拨出库 20 抽检出库 30 补货出库 40 盘点出库 100 其他
if (cbType.SelectedIndex == 5)
{
outcell.OUTTYPE = 100;
}
else
{
outcell.OUTTYPE = (cbType.SelectedIndex + 1) * 10;
}
outcell.CREATETIME = DateTime.Now;
outcell.BARCODE = job.BRANDID;
outcell.CIGARETTECODE = cigaretteCode;
outcell.STATUS = 20;
outcell.CIGARETTENAME = cigaretteName;
outcell.ID = id;
outcell.RETURNQTY = 0;
outcell.LOCKRETURNQTY = 0;
outcell.ACTQTY = 0;
outcell.ACTRETURNQTY = 0;
AtsCellOutService.InsertObject(outcell);
ts.Complete();
}
}
}
else
{
using (TransactionScope ts = new TransactionScope())
{
decimal id = BaseService.GetSeq("select S_ATSCELL_OUT.nextval from dual");
T_WMS_ATSCELL_OUT outcell = new T_WMS_ATSCELL_OUT();
outcell.REQUESTQTY = planQty;
outcell.OUTTARGET = address[cbAdress.SelectedIndex];
outcell.OUTTYPE = 10;
outcell.STATUS = 20;
outcell.CREATETIME = DateTime.Now;
outcell.BARCODE = itemDetail.BIGBOX_BAR;
outcell.CIGARETTECODE = cigaretteCode;
outcell.CIGARETTENAME = cigaretteName;
outcell.RETURNQTY = 0;
outcell.LOCKRETURNQTY = 0;
outcell.ACTQTY = 0;
outcell.ACTRETURNQTY = 0;
outcell.ID = id;
AtsCellOutService.InsertObject(outcell);
while (planQty > 0)
{
int tempQty = 0;
INF_JOBDOWNLOAD job = new INF_JOBDOWNLOAD();
job.TARGET = address[cbAdress.SelectedIndex];
job.SOURCE = AtsCellOutService.getCellNoByTime(cigaretteCode);
if (job.SOURCE == "")
{
MessageBox.Show("任务下载失败,请修改任务");
break;
}
else
{
T_WMS_ATSCELLINFO_DETAIL detail = AtsCellInfoDetailService.GetDetail(job.SOURCE);
if (detail.QTY >= planQty)
{
AtsCellOutService.UpdateCellOutStatus(job.SOURCE, planQty);
tempQty = planQty;
planQty = 0;
}
else
{
AtsCellOutService.UpdateCellOutStatus(job.SOURCE, int.Parse(detail.QTY.ToString()));
planQty -= int.Parse(detail.QTY.ToString());
tempQty = int.Parse(detail.QTY.ToString());
}
}
job.BARCODE = AtsCellInfoService.GetCellInfo(job.SOURCE).PALLETNO; //托盘号
job.PLANQTY = tempQty;
job.JOBTYPE = 52; //一楼出库
job.PRIORITY = 50;
job.CREATEDATE = DateTime.Now;
job.BRANDID = itemDetail.BIGBOX_BAR;
job.TUTYPE = 4;
job.INPUTTYPE = 10;
job.TASKNO = id;
InfJobDownLoadService.InsertEntity(job);
}
ts.Complete();
}
}
tbChooseName.Tag = null;
tbChooseName.Text = "";
search();
MessageBox.Show("出库任务已下达");
}
private void button2_Click(object sender, EventArgs e)
{
if (jobid != null && jobid != "0")
{
//InBound.INF_JOBFEEDBACK request = new InBound.INF_JOBFEEDBACK();
////request.ID = Guid.NewGuid().ToString("N");
//request.JOBID = jobid;
//request.FEEDBACKSTATUS = 99;
//request.ERRORCODE = "OK";
//request.ENTERDATE = DateTime.Now;
//// request.STATUS = 0;
//InfFeedBackService.InsertEntity(request);
//T_WMS_ATSCELLINFO cellInfo = AtsCellInfoService.CheckPalletExist(temptask.BARCODE);//检查托盘号是否存在
//T_WMS_ATSCELLINFO_DETAIL detail = AtsCellInfoDetailService.GetDetail(cellInfo.CELLNO);
//if (detail.REQUESTQTY == detail.QTY) //&& (cellInfo.DISMANTLE==0)
//{
// INF_JOBDOWNLOAD task1 = new INF_JOBDOWNLOAD();
// task1.JOBID = dataEntity.ExecuteStoreQuery<decimal>("select s_inf_jobdownload.nextval from dual").First() + "";
// task1.ID = task1.JOBID;
// task1.BRANDID = temptask.BRANDID;
// task1.BARCODE = cellInfo.PALLETNO;
// task1.SOURCE = temptask.EQUIPMENTID;
// task1.PLANQTY = 1;
// task1.INPUTTYPE = 10;
// task1.JOBTYPE = 100;//空托盘回收任务
// task1.TARGET = "1422";//空托盘指定地址
// task1.TUTYPE = 2;
// task1.CREATEDATE = DateTime.Now;
// task1.PRIORITY = 50;
// dataEntity.INF_JOBDOWNLOAD.AddObject(task1);
//}
// INF_EQUIPMENTREQUEST request = InfEquipmentRequestService.GetEquipMentRequest(jobid);
INF_JOBDOWNLOAD download = InfJobDownLoadService.GetDetail(jobid);
T_WMS_ATSCELLINFO cellInfo = AtsCellInfoService.GetCellInfoByBarCode(download.BARCODE);
T_WMS_ATSCELLINFO_DETAIL detail = AtsCellInfoDetailService.GetDetail(cellInfo.CELLNO);
using (TransactionScope ts = new TransactionScope())
{
if (detail.REQUESTQTY != detail.QTY)
{
INF_JOBDOWNLOAD task1 = new INF_JOBDOWNLOAD();
// task1.JOBID = dataEntity.ExecuteStoreQuery<decimal>("select s_inf_jobdownload.nextval from dual").First() + "";
// task1.ID = task.JOBID;
task1.BRANDID = detail.BARCODE;
task1.BARCODE = cellInfo.PALLETNO;
task1.SOURCE = "1415";
task1.PLANQTY = detail.QTY - detail.REQUESTQTY;
task1.INPUTTYPE = 10;
task1.JOBTYPE = 40;//返库任务
task1.TARGET = AtsCellInService.getCellNoCode(download.BRANDID + "");
task1.TUTYPE = 4;
task1.PRIORITY = 50;
task1.STATUS = 0;
task1.CREATEDATE = DateTime.Now;
InfJobDownLoadService.InsertEntity(task1);
T_WMS_ATSCELLINFO info = new T_WMS_ATSCELLINFO();
info.PALLETNO = cellInfo.PALLETNO;
// info.DISMANTLE = 1;
info.CELLNO = task1.TARGET;
info.STATUS = 10;//组盘
info.CREATETIME = cellInfo.CREATETIME;
info.INBOUNDID = cellInfo.INBOUNDID;
//task.TUTYPE = 4;
info.DISMANTLE = 0;
AtsCellInfoService.InsertAtsCellInfo(info);
T_WMS_ATSCELLINFO_DETAIL details = new T_WMS_ATSCELLINFO_DETAIL();
details.BARCODE = detail.BARCODE;
T_WMS_ITEM item = ItemService.GetItemByBarCode(details.BARCODE);
details.CIGARETTECODE = item.ITEMNO;
details.CIGARETTENAME = item.ITEMNAME;
details.QTY = task1.PLANQTY;
details.CELLNO = info.CELLNO;
AtsCellInfoDetailService.InsertAtsCellInfo(details);
}
AtsCellService.UpdateAtsCell(detail.CELLNO, 10);
AtsCellInfoService.delete(detail.CELLNO);
AtsCellInfoDetailService.delete(detail.CELLNO);
InfJobDownLoadService.UpdateJopDownLoad(jobid, 3);
// InfEquipmentRequestService.UpdateEquipMentRequest(jobid, 1);
ts.Complete();
}
search();
}
else
{
MessageBox.Show("请选择记录");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (cbAddress.SelectedIndex == -1)
{
MessageBox.Show("请选择入口地址");
return;
}
if (tbChooseName.Tag == null)
{
MessageBox.Show("请选择品牌");
return;
}
if (tbRfid.Text == "")
{
MessageBox.Show("请输入Rfid");
return;
}
INF_JOBDOWNLOAD job = new INF_JOBDOWNLOAD();
job.SOURCE = address[cbAddress.SelectedIndex];
job.TARGET = AtsCellInService.getCellNoCode(tbChooseName.Tag.ToString());//储位地址
if (job.TARGET == "")
{
MessageBox.Show("获取储位信息失败");
return;
}
job.PLANQTY = int.Parse(tbNum.Text);
job.JOBTYPE = 30;//成品入库
job.PRIORITY = 50;
job.CREATEDATE = DateTime.Now;
job.BRANDID = tbChooseName.Tag.ToString();
job.TUTYPE = 4;
job.INPUTTYPE = 10;
String palletNo = RefRFIDPalletService.GetSeq() + "";// RefRFIDPalletService.GetPallet(tbRfid.Text);
job.BARCODE = palletNo;
if (palletNo == "E")
{
MessageBox.Show("该托盘已在使用,请确认Rfid是否输入正确");
return;
}
if (cbcDuo.Checked)
{
job.CDTYPE = 10;
}
else
{
job.CDTYPE = 0;
}
// InfJobDownLoadService.InsertEntity(job);
using (TransactionScope ts = new TransactionScope())
{
InfJobDownLoadService.InsertEntity(job);
//InBoundLineService.Update(entity.INBOUNDDETAILID, 0, num ?? 0);
AtsCellService.UpdateAtsCell(job.TARGET, 30);//更新cellno状态
T_WMS_ATSCELLINFO info = new T_WMS_ATSCELLINFO();
info.PALLETNO = palletNo;
info.DISMANTLE = 1;
info.CELLNO = job.TARGET;
info.STATUS = 10;//组盘
info.CREATETIME = DateTime.Now;
//info.INBOUNDID = inboundid;
if (cbcDuo.Checked)
{
info.DISMANTLE = 10;
}
else
{
info.DISMANTLE = 0;
}
AtsCellInfoService.InsertAtsCellInfo(info);
T_WMS_ATSCELLINFO_DETAIL detail = new T_WMS_ATSCELLINFO_DETAIL();
detail.BARCODE = tbChooseName.Tag.ToString();
detail.CIGARETTECODE = ItemService.GetItemByBarCode(detail.BARCODE).ITEMNO;
detail.CIGARETTENAME = tbChooseName.Text;
detail.QTY = decimal.Parse(tbNum.Text);
detail.CELLNO = info.CELLNO;
AtsCellInfoDetailService.InsertAtsCellInfo(detail);
ts.Complete();
WriteLog.GetLog().Write("储位明细信息状态:10 储位号:" + job.TARGET);
}
//MessageBox.Show("入库完成");
//InfJobDownLoadService.InsertEntity(job);
//using (TransactionScope ts = new TransactionScope())
//{
// InfJobDownLoadService.InsertEntity(job);
// //InBoundLineService.Update(entity.INBOUNDDETAILID, 0, num ?? 0);
// AtsCellService.UpdateAtsCell(job.TARGET,30);//更新cellno状态
// T_WMS_ATSCELLINFO info = new T_WMS_ATSCELLINFO();
// info.PALLETNO = palletNo;
// info.DISMANTLE = 1;
// info.CELLNO = job.TARGET;
// info.STATUS = 10;//组盘
// info.CREATETIME = DateTime.Now;
// //info.INBOUNDID = inboundid;
// if (cbcDuo.Checked)
// {
// info.DISMANTLE = 10;
// }
// else
// {
// info.DISMANTLE = 0;
// }
// AtsCellInfoService.InsertAtsCellInfo(info);
// T_WMS_ATSCELLINFO_DETAIL detail = new T_WMS_ATSCELLINFO_DETAIL();
// detail.CIGARETTECODE = tbChooseName.Tag.ToString();
// detail.CIGARETTENAME = tbChooseName.Text;
// detail.QTY = decimal.Parse(tbNum.Text);
// detail.PALLETNO = info.PALLETNO;
// AtsCellInfoDetailService.InsertAtsCellInfo(detail);
// ts.Complete();
//}
MessageBox.Show("任务已下达");
updateListBox(job.JOBID + "号任务已下达;入口地址:" + job.SOURCE);
WriteLog.GetLog().Write(job.JOBID + "号任务已下达;入口地址:" + job.SOURCE);
tbChooseName.Text = "";
tbChooseName.Tag = null;
}
private void button1_Click(object sender, EventArgs e)
{
if (cbAddress.SelectedIndex == -1)
{
MessageBox.Show("请选择入口地址");
return;
}
if (tbChooseName.Tag == null)
{
MessageBox.Show("请选择品牌");
return;
}
if (tbRfid.Text == "")
{
MessageBox.Show("请输入Rfid");
return;
}
decimal fullCount = ItemService.GetItemByCode(cigaretteCode).FULLCOUNT ?? 0;
if (decimal.Parse(tbNum.Text) > fullCount)
{
MessageBox.Show("入库数量不能大于满托盘数量");
return;
}
using (TransactionScope ts = new TransactionScope())
{
INF_JOBDOWNLOAD job = new INF_JOBDOWNLOAD();
job.SOURCE = address[cbAddress.SelectedIndex];
job.TARGET = AtsCellInService.getCellNoCode(cigaretteCode);//储位地址
if (job.TARGET == "")
{
MessageBox.Show("获取储位信息失败,请联系管理员");
return;
}
job.PLANQTY = int.Parse(tbNum.Text);
job.JOBTYPE = 42;//返库
job.PRIORITY = 50;
job.CREATEDATE = DateTime.Now;
job.BRANDID = tbChooseName.Tag.ToString();
job.TUTYPE = 4;
job.INPUTTYPE = 10;
job.TASKNO = taskNo;
//job.EXTATTR1 = dataGridView1.SelectedRows[0].Cells[4].Value.ToString();
String palletNo = RefRFIDPalletService.GetPallet(tbRfid.Text);
if (palletNo == "E")
{
MessageBox.Show("该托盘已在使用,请确认Rfid是否输入正确");
return;
}
job.BARCODE = palletNo;
if (cbcDuo.Checked)
{
job.CDTYPE = 10;
}
else
{
job.CDTYPE = 0;
}
InfJobDownLoadService.InsertEntity(job);
AtsCellService.UpdateAtsCell(job.TARGET, 30);
T_WMS_ATSCELLINFO info = new T_WMS_ATSCELLINFO();
info.PALLETNO = job.BARCODE;
info.CELLNO = job.TARGET;
info.STATUS = 10;//组盘
info.CREATETIME = DateTime.Now;
info.DISMANTLE = job.CDTYPE;
AtsCellInfoService.InsertAtsCellInfo(info);
AtsCellOutService.UpdateObjectThd(taskNo, job.PLANQTY ?? 0);
T_WMS_ATSCELLINFO_DETAIL detail = new T_WMS_ATSCELLINFO_DETAIL();
detail.BARCODE = job.BRANDID;
T_WMS_ITEM item = ItemService.GetItemByBarCode(detail.BARCODE);
detail.CIGARETTECODE = item.ITEMNO;
detail.CIGARETTENAME = item.ITEMNAME;
detail.QTY = job.PLANQTY;
detail.CELLNO = info.CELLNO;
AtsCellInfoDetailService.InsertAtsCellInfo(detail);
ts.Complete();
MessageBox.Show("入库任务下达完成");
}
search();
tbChooseName.Text = "";
tbChooseName.Tag = null;
}
