private void btnBelt_Click(object sender, EventArgs e) //皮带单击事件
{
Button name = ((Button)sender); //获取当前单击按钮的所有实例
updateListBox("查看" + Text.Substring(4) + "的皮带");
ListViewBind(FolloTaskService.GetMachineBeltInfo(Convert.ToDecimal(Text.Substring(5, 1))));
}
decimal SortNum; //排序号
private void W_FenJTask_Load(object sender, EventArgs e)
{
// asc.controllInitializeSize(this);
dgvTask.DataSource = FolloTaskService.getFJDataAll(1, 1);
BindSelectCmb();
DgvBind();
}
private void btnOk_Click(object sender, EventArgs e)
{
switch (cmbSelectC.SelectedItem.ToString())
{
case "所有分拣任务":
if (!string.IsNullOrWhiteSpace(txtInfo.Text) && !string.IsNullOrWhiteSpace(txtinfo2.Text))
{
groupNo1 = Convert.ToDecimal(txtInfo.Text.Replace(" ", ""));
groupNo2 = Convert.ToDecimal(txtinfo2.Text.Replace(" ", ""));
dgvTask.DataSource = FolloTaskService.getFJDataAll(groupNo1, groupNo2).Select(a => new
{
CIGARETTDECODE = a.CIGARETTDECODE,
CIGARETTDENAME = a.CIGARETTDENAME,
Machineseq = a.Machineseq,
SortNum = a.SortNum,
tNum = a.tNum,
Billcode = a.Billcode,
SortState = a.SortState
}).ToList();
DgvBind();
}
else
{
MessageBox.Show("请输入组号");
return;
}
break;
case "任务号":
if (!string.IsNullOrWhiteSpace(txtInfo.Text) && !string.IsNullOrWhiteSpace(txtinfo2.Text) && !string.IsNullOrWhiteSpace(txtinfo3.Text))
{
groupNo1 = Convert.ToDecimal(txtInfo.Text.Replace(" ", ""));
groupNo2 = Convert.ToDecimal(txtinfo2.Text.Replace(" ", ""));
SortNum = Convert.ToDecimal(txtinfo3.Text.Replace(" ", ""));
dgvTask.DataSource = FolloTaskService.getFJData(SortNum, groupNo1, groupNo2).Select(a => new
{
CIGARETTDECODE = a.CIGARETTDECODE,
CIGARETTDENAME = a.CIGARETTDENAME,
Machineseq = a.Machineseq,
SortNum = a.SortNum,
tNum = a.tNum,
Billcode = a.Billcode,
SortState = a.SortState
}).ToList();;
DgvBind();
}
else
{
MessageBox.Show("请输入完整");
return;
}
break;
}
}
/*******************************************************************/
/// <summary>
/// 合流机械手
/// </summary>
/// <param name="MachineNo"></param>
/// <returns></returns>
public string GetUnionMachine(int MachineNo)
{
try
{
OpcServer.Connect();
}
catch (Exception ex)
{
return("与电控连接失败,请检查网络");
}
decimal[] sortnumAndXYnum = new decimal[4];
sortnumAndXYnum[0] = OpcServer.listUnionTaskGroup[5].ReadD(((MachineNo * 2) - 2)).CastTo <int>(-1); //当前任务号
sortnumAndXYnum[1] = OpcServer.listUnionTaskGroup[4].ReadD(((MachineNo * 2) - 1)).CastTo <int>(-1); //累计总数数量
sortnumAndXYnum[2] = OpcServer.listUnionTaskGroup[5].ReadD(((MachineNo * 2) - 1)).CastTo <int>(-1); //当前吸烟数量
sortnumAndXYnum[3] = OpcServer.listUnionTaskGroup[6].ReadD(MachineNo + 31).CastTo <int>(-1); //当前机械手累计放烟数量
writeLog.Write("\r查询合流：" + MachineNo + "号机械手\r当前任务号：" + sortnumAndXYnum[0] + "\r累计抓烟数量:" + sortnumAndXYnum[1] + "\r当前吸烟数量：" + sortnumAndXYnum[2] + "\r当前累计放烟数量：" + sortnumAndXYnum[3]);
if (sortnumAndXYnum.Sum() >= 0)
{
if (sortnumAndXYnum[3] == sortnumAndXYnum[1])
{
return("当前机械手无抓烟数据");
}
else
{
//List<FollowTaskDeail> list = FolloTaskService.GetUnionMachineInfo(123903, 3, 5, 10);
List <FollowTaskDeail> list = FolloTaskService.GetUnionMachineInfo(sortnumAndXYnum[0], GetMainBeltNo(MachineNo), GetGroupNo(MachineNo), sortnumAndXYnum[1], sortnumAndXYnum[2]);
if (list != null && list.Count > 0)
{
DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(List <FollowTaskDeail>));
using (MemoryStream ms = new MemoryStream())
{
ser.WriteObject(ms, list.Take(10));
string s = Encoding.UTF8.GetString(ms.ToArray());
s = s.Replace("\\", "");
writeLog.Write("\r查询合流：" + MachineNo + "号机械手\r");
return(s);
}
}
else
{
writeLog.Write("GetUnionMachine(" + MachineNo + ")查询结果集为空");
return("当前机械手无抓烟数据,请重新查询!");
}
}
}
else
{
writeLog.Write("GetUnionMachine(" + MachineNo + ")读取DB块数据异常");
return("从电控获取数据失败，请重新查询!");
}
}
private void Fm_SortDetails_Load(object sender, EventArgs e)
{
try
{
listViewYaobaiDetails.Items.Clear();
list1 = FolloTaskService.GetSortingBeltTask(MainBelt, groupNo);
ListViewBind(list1);
}
catch (Exception ex)
{
MessageBox.Show("异常信息:" + "\r\n" + ex.Message);
}
}
decimal SortNum; //排序号
private void w_FollowTask_Load(object sender, EventArgs e)
{
try
{
asc.controllInitializeSize(this);
BindSelectCmb();
// list = FolloTaskService.getAllTask();
//new Thread(() => { ReadDBInfo(listuinongroup[0]); }).Start();
list = FolloTaskService.getAllTask();
dgvTask.DataSource = list;
}
catch (Exception ex)
{
MessageBox.Show("数据库连接失败，请检查连接状况！");
}
}
private void textBox_jym_TextChanged(object sender, EventArgs e)
{
RestockingData rt = FolloTaskService.RestockingByDx(textBox_jym.Text);
if (rt != null)
{
textBox_jym.Text = rt.bigbox_bar;
textBox_jybm.Text = rt.cid;
textBox_jymc.Text = rt.cname;
textBox_dx.Text = rt.dxtype;
}
else
{
textBox_jybm.Text = "";
textBox_jymc.Text = "";
textBox_dx.Text = "";
}
}
public void bindtext(TroughNumList list)
{
RestockingData rt = FolloTaskService.RestockingOrDefult(list.Cid);
if (rt != null)
{
textBox_jym.Text = rt.bigbox_bar;
textBox_jybm.Text = rt.cid;
textBox_jymc.Text = rt.cname;
textBox_dx.Text = rt.dxtype;
}
else
{
textBox_jym.Text = "";
textBox_jybm.Text = "";
textBox_jymc.Text = "";
textBox_dx.Text = "";
}
}
private void Restocking_Load(object sender, EventArgs e)
{
writeLog.Write("手动补货数据录入界面打开！");
comboBox1_zlhj.SelectedIndex = -1;
cmb1 = FolloTaskService.GetHJTroughNum();
comboBox1_zlhj.DataSource = cmb1;
comboBox1_zlhj.DisplayMember = "troughnun";
comboBox1_zlhj.ValueMember = "troughnun";
comboBox1_zlhj.SelectedIndex = 0;
comboBox2_yg.SelectedIndex = -1;
cmb2 = FolloTaskService.GetYGTroughNum();
comboBox2_yg.DataSource = cmb2;
comboBox2_yg.DisplayMember = "troughnun";
comboBox2_yg.ValueMember = "troughnun";
comboBox2_yg.SelectedIndex = 0;
falg = true;
}
void GetDate()
{
try
{
ReadDbInFo(MainBelt, MachineNo);
dgvUnionCache.DataSource = null;
list.Clear();
if (sortnumAndXYnum.Count() != 0)
{
//ReadDBInfo(listUnionMachine[5], MainBelt);
txtSortnum.Text = sortnumAndXYnum[0] + "";
txtPokenum.Text = sortnumAndXYnum[1] + "";
//list = FolloTaskService.getUnionCache(8, 1, 137595, 18);//获取数据
list = FolloTaskService.getUnionCache(groupno, MainBelt, sortnumAndXYnum[0], sortnumAndXYnum[1]);//获取数据
ListViewBind(list);
}
}
catch (Exception ex)
{
MessageBox.Show("错误异常" + ex);
}
}
private void btnOk_Click(object sender, EventArgs e)
{
try
{
switch (cmbSelectC.SelectedItem.ToString())
{
case "所有任务":
if (!string.IsNullOrWhiteSpace(txtInfo.Text))
{
TsakNum = Convert.ToDecimal(txtInfo.Text.Replace(" ", ""));
dgvTask.DataSource = FolloTaskService.getAllTask(TsakNum);
}
else
{
dgvTask.DataSource = list;
}
break;
case "设备号":
if (!string.IsNullOrWhiteSpace(txtInfo.Text))
{
Machineseq = Convert.ToDecimal(txtInfo.Text.Replace(" ", ""));
dgvTask.DataSource = FolloTaskService.getAllMachineTask(Machineseq).Select(a => new
{
CIGARETTECODE = a.CIGARETTDECODE,
CIGARETTNAME = a.CIGARETTDENAME,
MACHINESEQ = a.Machineseq,
UNIONTASKNUM = a.UnionTasknum,
MERAGENUM = a.MERAGENUM,
BILLCODE = a.Billcode,
MACHINESTATE = a.MachineState
}).ToList();
DgvBind();
}
break;
case "合流任务号":
if (!string.IsNullOrWhiteSpace(txtInfo.Text) && !string.IsNullOrWhiteSpace(txtinfo2.Text))
{
Machineseq = Convert.ToDecimal(txtInfo.Text.Replace(" ", ""));
UnionTsakNum = Convert.ToDecimal(txtinfo2.Text.Replace(" ", ""));
dgvTask.DataSource = FolloTaskService.getMachineTask(Machineseq, UnionTsakNum).Select(a => new
{
CIGARETTECODE = a.CIGARETTDECODE,
CIGARETTNAME = a.CIGARETTDENAME,
MACHINESEQ = a.Machineseq,
UNIONTASKNUM = a.UnionTasknum,
MERAGENUM = a.MERAGENUM,
BILLCODE = a.Billcode,
MACHINESTATE = a.MachineState
}).ToList();
DgvBind();
}
break;
case "品牌":
break;
case "数量":
break;
case "组号":
break;
case "机械手":
break;
}
}
catch (Exception ex)
{
MessageBox.Show("错误：" + ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
dataGridView1.DataSource = FolloTaskService.Restocking(textBox1.Text);
}
private void button2_Click(object sender, EventArgs e)
{
try
{
if (Convert.ToInt32(textBox_num.Text) <= 0)
{
MessageBox.Show("数量不能小于0!");
return;
}
}
catch (Exception)
{
MessageBox.Show("数量格式有误！");
return;
}
if (!check1())
{
MessageBox.Show("重力式货架或烟柜编号输入有误！");
return;
}
if (!check2())
{
DialogResult res = MessageBox.Show("重力式货架与烟柜品牌不符合，是否继续？", "警告", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (res == DialogResult.Cancel)
{
return;
}
}
DialogResult re = MessageBox.Show("确认下达补货任务？\r\n \r\n" + comboBox1_zlhj.SelectedValue + " " + labelcmb1_jymc.Text + " 到 " + comboBox2_yg.SelectedValue + " " + labelcmb2_jymc.Text + "\r\n烟件数为：" + textBox_num.Text + "\r\n垛形为：" + textBox_dx.Text + "\r\n件烟码为：" + textBox_jym.Text + "\r\n实物品牌为：" + textBox_jymc.Text, "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (re == DialogResult.OK)
{
string str = "";
try
{
bool falg = FolloTaskService.InsertRestocking(comboBox1_zlhj.SelectedValue.ToString(), comboBox2_yg.SelectedValue.ToString(), textBox_jym.Text, textBox_jybm.Text, Convert.ToInt32(textBox_num.Text), Convert.ToDecimal(textBox_dx.Text));
//bool troughfalg = FolloTaskService.TroughMantissaChange(comboBox1.Text, Convert.ToDecimal(textBox_num.Text));
if (falg)
{
MessageBox.Show("任务下达成功！");
str = "下达成功";
}
else
{
MessageBox.Show("任务下达失败！");
str = "下达成功";
}
}
catch (Exception)
{
MessageBox.Show("输入数据有误！");
str = "数据有误,下达失败！";
}
finally
{
writeLog.Write("下达补货任务：" + comboBox1_zlhj.SelectedValue + " " + labelcmb1_jymc.Text + " 到 " + comboBox2_yg.SelectedValue + " " + labelcmb2_jymc.Text + " ,烟件数为：" + textBox_num.Text + " ,垛形为：" + textBox_dx.Text + " ,件烟码为：" + textBox_jym.Text + " ,实物品牌为：" + textBox_jymc.Text);
}
}
}
public string GetSortMachine(int machineNo)
{
string conncetionGroupStr = "S7:[FJConnectionGroup1]";//默认为第一组
decimal groupno = 0;
decimal MachineNo = 0;
if (machineNo.ToString().Substring(0, 1) == "1")
{
conncetionGroupStr = "S7:[FJConnectionGroup1]";
groupno = GetSortingMachineGroup(machineNo, 1000);
MachineNo = machineNo - 1000;
}
else if (machineNo.ToString().Substring(0, 1) == "2")
{
conncetionGroupStr = "S7:[FJConnectionGroup2]";
groupno = GetSortingMachineGroup(machineNo, 2000);
MachineNo = machineNo - 2000;
}
else if (machineNo.ToString().Substring(0, 1) == "3")
{
conncetionGroupStr = "S7:[FJConnectionGroup3]";
groupno = GetSortingMachineGroup(machineNo, 3000);
MachineNo = machineNo - 3000;
}
else if (machineNo.ToString().Substring(0, 1) == "4")
{
conncetionGroupStr = "S7:[FJConnectionGroup4]";
groupno = GetSortingMachineGroup(machineNo, 4000);
MachineNo = machineNo - 4000;
}
else
{
return("请勿输入错的设备号！");
}
try
{
OpcServer.Connect(2, conncetionGroupStr);
}
catch (Exception ex)
{
return("远程连接失败,请检查网络");
}
decimal sortnum = 0;
decimal xynum = 0;
if (groupno == 1)
{
sortnum = OpcServer.listUnionTaskGroup[9].ReadD((((int)MachineNo * 2) - 2)).CastTo <decimal>(-1); //A 任务号
xynum = OpcServer.listUnionTaskGroup[9].ReadD((((int)MachineNo * 2) - 1)).CastTo <decimal>(-1); //A 数量
}
else
{
sortnum = OpcServer.listUnionTaskGroup[10].ReadD((((int)MachineNo * 2) - 2)).CastTo <decimal>(-1); //B 任务号
xynum = OpcServer.listUnionTaskGroup[10].ReadD((((int)MachineNo * 2) - 1)).CastTo <decimal>(-1); //B 数量
}
var machineinfo = FolloTaskService.GetSrotingMachineInfo(MachineNo).FirstOrDefault();
if (machineinfo != null)
{
List <string> list = new List <string>();
string str = "数量:" + xynum + "，卷烟名称:" + machineinfo.CIGARETTDENAME;
list.Add(str);
DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(List <MainBeltInfo>));
using (MemoryStream ms = new MemoryStream())
{
ser.WriteObject(ms, list);
string s = Encoding.UTF8.GetString(ms.ToArray());
s = s.Replace("\\", "");
writeLog.Write("\r查询预分拣：第" + MachineNo + "号机械手\r");
return(s);
}
}
else
{
return("未读取到数据！");
}
}
/// <summary>
/// 合流S缓存
/// </summary>
/// <param name="MachineNo"></param>
/// <returns></returns>
public string GetUnionCaChe(int MachineNo)
{
try
{
OpcServer.Connect();
}
catch (Exception ex)
{
return("远程连接失败,请检查网络");
}
string conncetionGroupStr = "S7:[FJConnectionGroup1]";//默认为第一组
int GroupNo = GetGroupNo(MachineNo);
int mainbelt = GetMainBeltNo(MachineNo);
if (GroupNo == 1 || GroupNo == 2)
{
conncetionGroupStr = "S7:[FJConnectionGroup1]";
}
else if (GroupNo == 3 || GroupNo == 4)
{
conncetionGroupStr = "S7:[FJConnectionGroup2]";
}
else if (GroupNo == 5 || GroupNo == 6)
{
conncetionGroupStr = "S7:[FJConnectionGroup3]";
}
else if (GroupNo == 7 || GroupNo == 8)
{
conncetionGroupStr = "S7:[FJConnectionGroup4]";
}
try
{
OpcServer.Connect1(1, conncetionGroupStr);
}
catch (Exception ex)
{
return("远程连接失败,请检查网络");
}
decimal[] sortnumAndXYnum = new decimal[2];
sortnumAndXYnum[0] = OpcServer.listUnionTaskGroup[4].ReadD(((MachineNo * 2) - 2)).CastTo <int>(-1); //当前任务号
sortnumAndXYnum[1] = OpcServer.listUnionTaskGroup[4].ReadD(((MachineNo * 2) - 1)).CastTo <int>(-1); //当前吸烟数量
writeLog.Write("\r查询合流缓存，任务号：" + sortnumAndXYnum[0] + "\r当前抓烟数量：" + sortnumAndXYnum[1]);
int taskIndex = 0;
decimal gpceil = Math.Floor((decimal)(GroupNo % 2));
if (gpceil == 1)
{
taskIndex = mainbelt - 1;
}
else
{
taskIndex = 4 + mainbelt - 1;
}
decimal yfjTaskNum = OpcServer.YFJGroup.ReadD(taskIndex).CastTo <int>(-1);//预分拣最后一个完成任务号
if (sortnumAndXYnum.Sum() >= 0)
{
List <FollowTaskDeail> date = FolloTaskService.getUnionCache(GroupNo, mainbelt, sortnumAndXYnum[0], sortnumAndXYnum[1], yfjTaskNum);
if (date != null && date.Count > 0)
{
DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(List <FollowTaskDeail>));
using (MemoryStream ms = new MemoryStream())
{
ser.WriteObject(ms, date);
string s = Encoding.UTF8.GetString(ms.ToArray());
s = s.Replace("\\", "");
writeLog.Write("\r查询合流：" + MachineNo + "号S缓存\r");
return(s);
}
}
else
{
writeLog.Write("GetUnionCaChe(" + MachineNo + ")查询结果集为空");
return("当前S缓存无数据,请重新查询!");
}
}
else
{
writeLog.Write("GetUnionCaChe(" + MachineNo + ")读取DB块数据异常");
return("从电控获取数据失败，请重新查询!");
}
}
private void timer1_Tick(object sender, EventArgs e)
{
listViewMchineBelt.Items.Clear();
ListViewBind(FolloTaskService.GetMachineBeltInfo(Convert.ToDecimal(Text.Substring(5, 1))));
timer1.Interval = (times * 1000);
}
