/// <summary>
/// 调节货叉位置
/// </summary>
private void SetFork(int Zero)
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
int maxForkDistance = Zero * 100;
if (maxForkDistance > 0)
{
for (int l = 0; l < maxForkDistance; l += 2)
{
srv.OPC_WritePoint(LOCALSERVER + StackerWrite + "INT18", l);//模拟伸叉位置 1排为正,二排为负
}
wait(1000);
for (int l = maxForkDistance; l >= 0; l -= 2)
{
srv.OPC_WritePoint(LOCALSERVER + StackerWrite + "INT18", l);//模拟收叉位置 1排为正,二排为负
}
}
if (maxForkDistance < 0)
{
for (int l = 0; l > maxForkDistance; l -= 2)
{
srv.OPC_WritePoint(LOCALSERVER + StackerWrite + "INT18", l);//模拟伸叉位置 1排为正,二排为负
}
wait(300);
for (int l = maxForkDistance; l <= 0; l += 2)
{
srv.OPC_WritePoint(LOCALSERVER + StackerWrite + "INT18", l);//模拟收叉位置 1排为正,二排为负
}
}
}
}
private void btn_r_RemoveGroup_Click(object sender, EventArgs e)
{
if (lsV_r_Group.Items.Count == 0 || lsV_r_Group.SelectedItems.Count == 0)
{
return;
}
string groupname = lsV_r_Group.SelectedItems[0].Text;
if (groupLst.Count > 0)
{
if (groupname == "管理员")
{
MessageBox.Show("不允许删除管理员角色!");
return;
}
using (ASRS_Volvo.ServiceForVolvo.ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
srv.PW_Group_DeleteOne(oneGroup.ID);
var moduls = srv.MODULE_VS_GROUP_GetAllByGroupName(oneGroup.GROUPNAME);
foreach (var p in moduls)
{
srv.MODULE_VS_GROUP_DeleteOne(p.ID);
}
}
initalLsV_Group();
tb_r_GroupName.Clear();
rTB_r_GroupDesc.Clear();
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
PW_User one = new PW_User();
var row = dGVPeopleInfo.SelectedRows[0];
List <PW_User> lst = dGVPeopleInfo.DataSource as List <PW_User>;
one.ID = row.Cells["ID"].Value.ToString();
PW_User findOne = lst.Find(delegate(PW_User user)
{
return(user.ID == one.ID);
});//用Find方法按工号找到此人的密码
if (findOne.USERNAME == "001")
{
MessageBox.Show("不允许修改001管理员账号!");
return;
}
one.PASSWORD = findOne.PASSWORD;
one.USERNAME = row.Cells[1].Value.ToString();
one.USERGROUP = row.Cells["UserGroup"].Value == null ? "" : row.Cells["UserGroup"].Value.ToString();
FormEditPeopleInfo f = new FormEditPeopleInfo(one);
f.ShowDialog();
}
FormEmpSetting_Load(null, e);
}
private void bindingDgv(DateTime startDate, DateTime endDate)
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
dGVInOutStock.DataSource = null;
lst = srv.V_INOUTSTOCK_SelectByDate(startDate, endDate).ToList();
var itemsLst = from items in lst orderby items.UPDATETIME select items;
lst = itemsLst.ToList();
if (lst != null && lst.Count > 0)
{
foreach (var p in lst)
{
if (p.TASKTYPE == "SRM_Retrieve_Out")
{
p.TASKTYPE = "出库";
}
if (p.TASKTYPE == "SRM_Store_In")
{
p.TASKTYPE = "入库";
}
}
}
dGVInOutStock.DataSource = lst;
}
}
private void btn_r_PW_Add_Click(object sender, EventArgs e)
{
if (oneGroup.ID == null)
{
return;
}
var oneFunc = cmB_PW.SelectedItem as MODULE;
MODULE_VS_GROUP oneGROUPVSFUNCTION = new MODULE_VS_GROUP();
oneGROUPVSFUNCTION.ID = Guid.NewGuid().ToString();
oneGROUPVSFUNCTION.MODULE_ID = oneFunc.ID;
oneGROUPVSFUNCTION.MODULE_NAME = oneFunc.MODULE_NAME;
oneGROUPVSFUNCTION.GROUP_DESC = oneGroup.GROUPDESCRIBE;
oneGROUPVSFUNCTION.GROUP_NAME = oneGroup.GROUPNAME;
List <MODULE_VS_GROUP> tmpList = new List <MODULE_VS_GROUP>();
tmpList = lsB_r_PW.DataSource as List <MODULE_VS_GROUP>;
if (tmpList == null)
{
tmpList = new List <MODULE_VS_GROUP>();
}
var tmp = tmpList.Find(x => x.MODULE_ID == oneGROUPVSFUNCTION.MODULE_ID);
if (tmp != null)
{
MessageBox.Show(this, "已有该功能!");
return;
}
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
srv.MODULE_VS_GROUP_InsertOne(oneGROUPVSFUNCTION);
inialGroupVsFunction();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (tBSku.Text.Trim() == string.Empty)
{
return;
}
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
if (item == null || item.SKU == "")
{
item = new IM_Item();
}
else
{
srv.IM_Item_DeleteOne(item.SKU);
}
item.ABCCLASS = "A区";
item.COMPATIBLECODE = tbCMCode.Text.Trim();
item.SKU = tBSku.Text.Trim();
item.SKUDESC = tBDesc.Text.Trim();
item.ITEMCLASS = ddlItemClass.SelectedItem.ToString();
item.UPDATETIME = DateTime.Now.ToString("yyyy-MM-dd");
item.UPDATEUSER = FormLogin.user.USERNAME;
bool val = srv.IM_Item_InsertOne(item);
if (val)
{
Close();
}
else
{
item = null;
MessageBox.Show(this, "保存失败!");
}
}
}
private void btn_Delete_Click(object sender, EventArgs e)
{
DialogResult rst = MessageBox.Show(this, "是否确定要删除?!", "警告!", MessageBoxButtons.YesNo);
if (rst == DialogResult.No)
{
return;
}
using (ASRS_Volvo.ServiceForVolvo.ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
if (dGVItemInfo.SelectedRows.Count > 0)
{
var i = dGVItemInfo.SelectedRows[0].Cells[0].Value.ToString().Trim();
if (lst != null && lst.Count > 0)
{
var oneItem = lst.Find(x => x.SKU == i);
srv.IM_Item_DeleteOne(oneItem.SKU);
lst.Remove(oneItem);
dGVItemInfo.DataSource = null;
dGVItemInfo.DataSource = lst;
}
}
}
}
/// <summary>
/// 密码校验
/// </summary>
/// <param name="EmpNo"></param>
/// <param name="password"></param>
/// <returns></returns>
private bool CheckLoginSuss(string EmpNo, string password)
{
user = new PW_User();
using (ASRS_Volvo.ServiceForVolvo.ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
string cesarPassword = srv.CommonMethod_StringEncoding(password);
var _user = srv.PW_User_GetUserInfoByEmpno(EmpNo);
if (_user.PASSWORD == cesarPassword)
{
user = _user;
}
else
{
user = new PW_User();
return(false);
}
if (ckBForce.Checked)
{
_user.ISLOGININ = "N";
srv.PW_User_UpdateUserInfo(user);
wait(1000);
}
return(true);
}
}
private void tBContainer_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Enter)
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
var container = srv.IM_Container_GetOneByContainerId(tBContainer.Text.Trim());
if (container == null || string.IsNullOrEmpty(container.CONTAINERID))
{
MessageBox.Show("无此托盘信息!");
return;
}
else
{
tBContainer.Enabled = false;
tBGate.Focus();
}
if (isStoredContainer(container.CONTAINERID) != 0)
{
MessageBox.Show("托盘已经扫描过或已经在货架上");
tBContainer.Enabled = true;
tBContainer.SelectAll();
tBContainer.Focus();
return;
}
}
//changeImg(1);
}
}
private void bgWorkLoadAll_DoWork(object sender, DoWorkEventArgs e)
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
lst = srv.IM_Item_GetAll().ToList();
}
}
private void button3_Click(object sender, EventArgs e)
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
if (btn_Alert.Text == "报警")
{
{
srv.OPC_WritePoint(LOCALSERVER + StackerRead + "W90", alertSec++);//发送报警信号
switch (comboBox1.SelectedIndex)
{
case 0:
srv.OPC_WritePoint(LOCALSERVER + StackerRead + "W6", 111);
break;
case 1:
srv.OPC_WritePoint(LOCALSERVER + StackerRead + "W6", 105);
break;
case 2:
srv.OPC_WritePoint(LOCALSERVER + StackerRead + "W6", 23);
break;
case 3:
srv.OPC_WritePoint(LOCALSERVER + StackerRead + "W6", 11);
break;
}
btn_Alert.Text = "解除";
}
}
else
{
srv.OPC_WritePoint(LOCALSERVER + StackerRead + "W90", 0);//发送报警解除
btn_Alert.Text = "报警";
}
}
private void bindingDgv(DateTime startDate, DateTime endDate)
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
dGVAlertQuery.DataSource = null;
lst = srv.Device_Alert_GetAllByDate(startDate, endDate, "SRM_1").ToList();
dGVAlertQuery.DataSource = lst;
}
}
private void btnUp_MouseUp(object sender, MouseEventArgs e)
{
bSt1 = false;
FormMain.wait(200);
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
srv.OPC_WritePoint(Items[0], 0);
}
}
private void btnDown_KeyUp(object sender, KeyEventArgs e)
{
bSt2 = false;
FormMain.wait(200);
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
srv.OPC_WritePoint(Items[1], 0);
}
}
private void getGroupToControl()
{
using (ASRS_Volvo.ServiceForVolvo.ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
var allGroup = srv.PW_Group_GetAll().ToList();
cmB_Group.DisplayMember = "GROUPNAME";
cmB_Group.ValueMember = "GROUPNAME";
cmB_Group.DataSource = allGroup;
}
}
private void btn_r_SaveDesc_Click(object sender, EventArgs e)
{
oneGroup.GROUPNAME = tb_r_GroupName.Text;
oneGroup.GROUPDESCRIBE = rTB_r_GroupDesc.Text;
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
srv.PW_Group_UpadteOne(oneGroup);
}
initalLsV_Group();
}
private void button2_Click(object sender, EventArgs e)
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
string write_TaskFinish = LOCALSERVER + StackerRead + "X1.2";
srv.OPC_WritePoint(write_TaskFinish, true);
string write_NewTask = LOCALSERVER + StackerRead + "W52";
srv.OPC_WritePoint(write_NewTask, 0);
}
}
private void initalcmB_PW()
{
cmB_PW.DataSource = null;
using (ASRS_Volvo.ServiceForVolvo.ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
cmB_PW.DataSource = srv.MODULE_GetAll().ToList();
}
cmB_PW.DisplayMember = "MODULE_NAME";
}
private void DeleteTask(OD_Task tsk)
{
if (tsk.HADFINISH == "N" && tsk.RELEASESTATUS == "Y")
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
string containerID = tsk.CONTAINERNO;
if (srv.Od_Task_deleteOne(tsk.TASKID)) //删除当前任务
{
srv.Place_Vs_Container_DeleteOne(containerID);
srv.Container_Vs_Items_DeleteOneByContainerID(containerID);
bool bl = srv.OPC_WritePoint("S7:[300]DB540,B1", 2); //删除堆垛机任务
if (bl)
{
MessageBox.Show("删除成功！");
}
}
}
}
if (tsk.HADFINISH == "N" && tsk.RELEASESTATUS == "N")
{
if (tsk.TASKTYPEDESCRIPTION.Contains("出库")) //如果出库的话
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
string placeId = tsk.SOURCEPLACE;
string containerID = tsk.CONTAINERNO;
if (srv.Od_Task_deleteOne(tsk.TASKID))
{
List <IV_place_vs_container> lstPVC = srv.Place_Vs_Container_GetRelationshipByContainer(containerID).ToList();
IV_place_vs_container pvc = new IV_place_vs_container();
if (lstPVC.Count > 0)
{
pvc = lstPVC[0];
pvc.PLACEID = placeId;
srv.Place_Vs_Container_UpdateOne(pvc);
}
}
}
}
else if (tsk.TASKTYPEDESCRIPTION.Contains("入库")) //否则入库
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
string containerID = tsk.CONTAINERNO;
if (srv.Od_Task_deleteOne(tsk.TASKID))
{
srv.Place_Vs_Container_DeleteOne(containerID);
srv.Container_Vs_Items_DeleteOneByContainerID(containerID);
}
}
}
}
}
public void Query_Stored_GetAll()
{
while (true)
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
Stored_cache = srv.Query_Stored_GetAll().ToList();
}
Thread.Sleep(2000);
}
}
private void ctrlST2(object obj)
{
if (bSt2)
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
srv.OPC_WritePoint(Items[1], 1);
FormMain.wait(50);
}
}
}
private void getTASKCONTENTSTRING(string CONTAINERID)
{
itemDetails = null;
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
var cvis = srv.Container_Vs_Items_GetItemsByContainerID(CONTAINERID);
foreach (var one in cvis)
{
itemDetails += one.ITEMDESC + ":" + one.ITEMQTY.ToString("0.##") + "套; ";
}
}
}
private void btn_r_Pw_Remove_Click(object sender, EventArgs e)
{
if (lsB_r_PW.SelectedItem == null)
{
return;
}
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
MODULE_VS_GROUP oneGVF = lsB_r_PW.SelectedItem as MODULE_VS_GROUP;
srv.MODULE_VS_GROUP_DeleteOne(oneGVF.ID);
inialGroupVsFunction();
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
string empno, password;
empno = tbLoginName.Text.Trim();
if (string.Empty == empno)
{
MessageBox.Show("请输入用户名！", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.tbLoginName.Focus();
this.tbLoginName.SelectAll();
return;
}
password = tbLoginPassword.Text.Trim();
bool blogin = CheckLoginSuss(empno, password); //调用数据库，校验逻辑
if (!blogin)
{
MessageBox.Show(this, "用户名或密码错误！", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.tbLoginName.Focus();
this.tbLoginName.SelectAll();
return;
}
if (user.ISLOGININ == "Y")
{
MessageBox.Show(this, "该用户已在别处登录！", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.tbLoginName.Focus();
this.tbLoginName.SelectAll();
return;
}
user.ISLOGININ = "Y";
using (ASRS_Volvo.ServiceForVolvo.ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
if (!srv.PW_User_UpdateUserInfo(user))
{
MessageBox.Show(this, "登录失败！", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.tbLoginName.Focus();
this.tbLoginName.SelectAll();
return;
}
else
{
FormMain fmain = new FormMain();
fmain.Show();
}
}
this.Hide();
}
private void btnClear_Click(object sender, EventArgs e)
{
AlreadyScan.Text = "";
label4.Visible = false;
AlreadyScan.Visible = false;
AlreadyScan.Height = 32;
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
if (MessageBox.Show("此操作会导致该小车的库存数据被清除,是否继续操作?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
var container = srv.IM_Container_GetOneByContainerId(tBContainer.Text.Trim());
if (container == null || string.IsNullOrEmpty(container.CONTAINERID))
{
MessageBox.Show("无此托盘信息!");
return;
}
if (isStoredContainer(container.CONTAINERID) == 2)
{
MessageBox.Show("托盘已经在货架上，若要解除绑定，请进行出库作业！");
tBContainer.Enabled = true;
tBContainer.SelectAll();
tBContainer.Focus();
return;
}
if (tBContainer.Enabled == true)
{
MessageBox.Show("托盘号尚未绑定可直接修改单元格，无需清除数据");
return;
}
try
{
srv.Place_Vs_Container_DeleteOne(tBContainer.Text.Trim());
var itemsIncontainer = srv.Container_Vs_Items_GetItemsByContainerID(tBContainer.Text.Trim()).ToList();
foreach (var p in itemsIncontainer)
{
srv.Container_Vs_Items_DeleteOneByContainerID(p.CONTAINERID);
}
tBContainer.Text = "";
tBSku.Text = "";
tBContainer.Enabled = true;
changeImg(1);
tBContainer.Focus();
}
catch (Exception)
{
}
}
}
}
private void btn_Refresh_Click(object sender, EventArgs e)
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
var nofinods = srv.Od_Task_GetNotFinishedTask_by_deviceID("SRM_1").ToList();
var rlsod = srv.Od_Task_GetCurrentTaskByDeviceID("SRM_1");
List <OD_Task> rlsods = new List <OD_Task>();
rlsods.Add(rlsod);
dgvNoFinOd.DataSource = null;
dGVReleaseOd.DataSource = null;
dgvNoFinOd.DataSource = nofinods;
dGVReleaseOd.DataSource = rlsods;
}
}
/// <summary>
/// 刷新包含用户列表
/// </summary>
private void inial_lsB_r_User()
{
lsB_r_User.DataSource = null;
if (oneGroup == null)
{
return;
}
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
var lst = srv.PW_User_GetAllByUserGroup(oneGroup.GROUPNAME);
lsB_r_User.DataSource = lst;
lsB_r_User.DisplayMember = "USERNAME";
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (!FormMain.srmStatus.Contains("正常"))
{
MessageBox.Show(this, "堆垛机状态异常，不允许下发指令!");
return;
}
if (dGVItemQuery.SelectedRows.Count == 0)
{
return;
}
lsBGate.SelectedIndex = 0;
if (lsBGate.SelectedItem == null)
{
MessageBox.Show(this, "请选择出库口!");
return;
}
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
//var st1 = srv.DU_Device_GetOneByDeviceId("ST1");
//if (!st1.WORKINGSTATUS.Contains("正常"))
//{
// MessageBox.Show(this, "升降机有异常!,禁止发货！");
// return;
//}
}
if (dGVItemQuery.SelectedRows[0].Cells[1].Value.ToString().Contains("TEMP"))
{
return;
}
//if (dGVUnLoadItems.Rows.Count >= 1)
// return;
DataGridViewRow oneContainer = CommonMethod.CloneWithValues(dGVItemQuery.SelectedRows[0]);
if (dGVUnLoadItems.Rows.Count > 0)
{
foreach (DataGridViewRow row in dGVUnLoadItems.Rows)
{
if (row.Cells[1].Value.ToString() == oneContainer.Cells[1].Value.ToString())
{
return;
}
}
}
oneContainer.Cells[6].Value = lsBGate.SelectedItem.ToString();
dGVUnLoadItems.Rows.Add(oneContainer);
dGVUnLoadItems.Refresh();
}
private void filtLocationByRowColumnLayer(string row, string col, string layer)
{
try
{
using (ASRS_Volvo.ServiceForVolvo.ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
List <PL_Place> lisPlaces = srv.PL_PLACE_FiltLocationByRowColumnLayer(row, col, layer).ToList();
dGVPlaceInfo.DataSource = null;
dGVPlaceInfo.DataSource = lisPlaces;
}
}
catch
{
}
}
/// <summary>
/// 登录者信号握手
/// </summary>
private void LoginHandShake()
{
int tryCount = 0;
string oldHandShake = string.Empty;
while (true)
{
Thread.Sleep(2000);
try
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
var user = srv.PW_User_GetOneByUserID(FormLogin.user.ID);
if (user.ISLOGININ == "N")//如果不在线
{
MessageBox.Show("系统已离线！");
Environment.Exit(0);
}
if (oldHandShake != user.HANDSHAKE)
{
oldHandShake = user.HANDSHAKE;
tryCount = 0;
tSLabelDataBase.Text = "数据库连接:正常";
tSLabelDataBase.ForeColor = Color.Blue;
tSLableEmployeeNo.Text = user.ID;
tSLabelName.Text = user.USERNAME;
SRM_Communicate();
}
else
{
tryCount++;
tSLabelDataBase.Text = "数据库连接:中断";
tSLabelDataBase.ForeColor = Color.Red;
if (tryCount > 5)//如果连续五次握手失败则表明断线
{
user.ISLOGININ = "N";
}
}
user.HANDSHAKE = Guid.NewGuid().ToString();
srv.PW_User_UpdateUserInfo(user);
}
}
catch (Exception ex)
{
}
}
}
