private void search()
{
List <InBound.OutBound> list = AtsCellInfoDetailService.GetDetail(tbCode.Text, tbName.Text);
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = list;
}
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("请选择记录");
}
}
