/// <summary> /// 处理入库任务 /// </summary> /// <param name="currentTask"></param> /// <returns></returns> private bool DealFor_Srm_Store_In(OD_Task currentTask) { List <IV_place_vs_container> placeContnr = new List <IV_place_vs_container>(); placeContnr = srv.Place_Vs_Container_GetRelationshipByContainer(currentTask.CONTAINERNO).ToList(); if (placeContnr.Count > 0) { placeContnr[0].PLACEID = currentTask.TOPLACE; srv.Place_Vs_Container_UpdateOne(placeContnr[0]); } else { //插入新库位容器记录 IV_place_vs_container ivp = new IV_place_vs_container(); ivp.CONTAINERID = currentTask.CONTAINERNO; ivp.PC_ID = Guid.NewGuid().ToString(); ivp.PLACEID = currentTask.TOPLACE; ivp.VOID = 0; ivp.WAREHOUSENO = currentTask.WAREHOUSENO; ivp.INSERTUSER = currentTask.CREATEUSER; ivp.UPDATEUSER = currentTask.UPDATEUSER; ivp.ISEMPTYCONTAINER = currentTask.ISEMPTYCONTAINER == "Y" ? 1 : 0; ivp.UPDATETIME = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ivp.INSERTTIME = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); srv.Place_Vs_Container_InsertOne(ivp); } bool a = srv.PL_PLACE_UpdateHadTaskDoing(currentTask.TOPLACE, 0); currentTask.TASKSTATUS = "In_Finished"; srv.Od_Task_SetLastTaskVoidByDeviceID(currentTask.DODEVICEID); // 废除上一次任务的有效性,当完成一个任务时,会先将以前的上一次任务(LastTask)作废,将刚刚完成的任务设置为最新上一次任务 bool b = srv.Od_Task_UpdateOne(currentTask); return(a && b); }
private void btn_TaskCancel_Click(object sender, EventArgs e) { OD_Task currentTask = srv.Od_Task_GetCurrentTaskByDeviceID("SRM_1"); if (currentTask.SOURCEPLACE == "10301" || currentTask.SOURCEPLACE == "11901") { //入库任务无需撤回 return; } string placeid = currentTask.SOURCEPLACE; string isEmptyContainer = currentTask.ISEMPTYCONTAINER; IV_place_vs_container pvc = new IV_place_vs_container(); pvc.CONTAINERID = currentTask.CONTAINERNO; pvc.INSERTTIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); pvc.INSERTUSER = ""; pvc.ISEMPTYCONTAINER = isEmptyContainer == "Y"?1:0; pvc.ISEMPTYPLACE = 0; pvc.PC_ID = Guid.NewGuid().ToString(); pvc.PLACEID = placeid; pvc.VOID = 0; pvc.UPDATETIME = pvc.INSERTTIME; pvc.UPDATEUSER = ""; pvc.WAREHOUSENO = "吉利沃尔沃立体库"; if (!srv.Place_Vs_Container_InsertOne(pvc)) { MessageBox.Show(this, "撤回失败!"); return; } btnCancle_Click(null, null);//删除堆垛机指令 }
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); } } } } }
/// <summary> /// 处理出库任务 /// </summary> /// <param name="currentTask"></param> /// <returns></returns> private bool DealFor_Srm_Retrieve_Out(OD_Task currentTask) { IV_place_vs_container placeContnr = new IV_place_vs_container(); placeContnr = srv.Place_Vs_Container_GetRelationshipByContainer(currentTask.CONTAINERNO)[0]; srv.Place_Vs_Container_DeleteOne(placeContnr.CONTAINERID); //清除库存 currentTask.TASKSTATUS = "Out_Finished"; srv.Od_Task_SetLastTaskVoidByDeviceID(currentTask.DODEVICEID); // 废除上一次任务的有效性,当完成一个任务时,会先将以前的上一次任务(LastTask)作废,将刚刚完成的任务设置为最新上一次任务 bool b = srv.Od_Task_UpdateOne(currentTask); return(b); }
/// <summary> /// 插入库位和容器关联表 /// </summary> /// <returns></returns> private bool insertToPlace_Vs_Container() { using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient()) { IV_place_vs_container plct = new IV_place_vs_container(); plct.CONTAINERID = currentContainer; plct.ID = Guid.NewGuid().ToString(); plct.PLACEID = "TEMP_RCV"; plct.UPDATEUSER = ""; plct.UPDATETIME = srv.CommonMethod_GetServerTime().ToString("yyyy-MM-dd HH:mm:ss"); plct.WAREHOUSENO = "端拾器立体库"; if (srv.Place_Vs_Container_InsertOne(plct)) //插入到库位容器库存表,库位是TEMP_RCV { return(true); } else { return(false); } } }
private static List <IV_place_vs_container> DoQuery(string sql_str) { List <IV_place_vs_container> rtn = new List <IV_place_vs_container>(); try { DBHelper DBHelper_SqlServer = new DBLink(); using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str)) { while (dr.Read()) { var p = new IV_place_vs_container(); #region 逐个赋值 p.ID = DBHelper_SqlServer.GetDataValue <string>(dr, "ID"); p.WAREHOUSENO = DBHelper_SqlServer.GetDataValue <string>(dr, "WAREHOUSENO"); p.PLACEID = DBHelper_SqlServer.GetDataValue <string>(dr, "PLACEID"); p.CONTAINERID = DBHelper_SqlServer.GetDataValue <string>(dr, "CONTAINERID"); p.UPDATETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATETIME"); p.UPDATEUSER = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATEUSER"); p.VOID = DBHelper_SqlServer.GetDataValue <int>(dr, "VOID"); p.ISEMPTYCONTAINER = DBHelper_SqlServer.GetDataValue <string>(dr, "ISEMPTYCONTAINER"); p.ISEMPTYPLACE = DBHelper_SqlServer.GetDataValue <string>(dr, "ISEMPTYPLACE"); p.PVC_BACKUP1 = DBHelper_SqlServer.GetDataValue <string>(dr, "PVC_BACKUP1"); p.PVC_BACKUP2 = DBHelper_SqlServer.GetDataValue <string>(dr, "PVC_BACKUP2"); p.PVC_BACKUP3 = DBHelper_SqlServer.GetDataValue <string>(dr, "PVC_BACKUP3"); #endregion rtn.Add(p); } } } catch { } return(rtn); }
private void btnUnLoad_Click(object sender, EventArgs e) { List <Query_Stored> unLoadLst = new List <Query_Stored>(); string isEmptyContainer = "N"; string toPlace = ""; if (dGVUnLoadItems.Rows.Count == 0) { return; } using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient()) { int count = 0; foreach (DataGridViewRow p in dGVUnLoadItems.Rows) { Query_Stored one = new Query_Stored(); one.WAREHOUSENO = p.Cells[0].Value == null ? "" : p.Cells[0].Value.ToString(); one.PLACEID = p.Cells[1].Value.ToString(); one.CONTAINERID = p.Cells[2].Value.ToString(); one.ITEMDESC = p.Cells[4].Value == null ? "" : p.Cells[4].Value.ToString(); one.ITEMQTY = decimal.Parse(p.Cells[5].Value == null ? "0" : p.Cells[5].Value.ToString()); one.ITEMSKU = p.Cells[3].Value == null ? "" : p.Cells[3].Value.ToString(); toPlace = p.Cells[6].Value.ToString(); switch (toPlace) { case "出入口10001": toPlace = "10001"; break; default: toPlace = "10001"; break; } unLoadLst.Add(one); if (unLoadLst.Count < 1) { return; } else { //foreach (var unLoadOne in unLoadLst) //{ OD_Task taskSRM = new OD_Task(); //MessageBox.Show(unLoadLst[count].PLACEID); #region newTask taskSRM.TASKID = Guid.NewGuid().ToString(); taskSRM.TASKNAME = "堆垛机出库" + DateTime.Now.ToString("yyyyMMddHHmmssfff"); taskSRM.TASKTYPE = "SRM_Retrieve_Out"; //任务类型 taskSRM.TASKTYPEDESCRIPTION = "堆垛机出库"; taskSRM.TASKSTATUS = "Out_Intention"; //想要入库 taskSRM.TASKLEVEL = "Normal"; getTASKCONTENTSTRING(unLoadLst[count].CONTAINERID); taskSRM.TASKCONTENTSTRING = itemDetails; taskSRM.DODEVICEID = "SRM_1"; //设备号 taskSRM.DODEVICENODEID = "000011"; //设备节点号 taskSRM.DODEVICETYPE = "SRM"; //设备类型 taskSRM.SOURCEPLACE = unLoadLst[count].PLACEID; taskSRM.TOPLACE = toPlace; //出库口 taskSRM.SENDTIMES = 1; taskSRM.RELEASESTATUS = "N"; taskSRM.HADFINISH = "N"; taskSRM.ORDERHEADID = ""; taskSRM.ORDERDETAILSID = ""; taskSRM.VOID = 0; taskSRM.UPDATEUSER = FormLogin.user.USERNAME; taskSRM.UPDATETIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); taskSRM.ISCURRENTTASK = "N"; taskSRM.ISLASTTASK = "N"; taskSRM.CONTAINERNO = unLoadLst[count].CONTAINERID; taskSRM.INPUTLOCATIONLEVEL = 1; taskSRM.ISEMPTYCONTAINER = isEmptyContainer; taskSRM.WAREHOUSENO = "端拾器立体库"; IV_place_vs_container pvc = new IV_place_vs_container(); try { pvc = srv.Place_Vs_Container_GetRelationshipByContainer(taskSRM.CONTAINERNO)[0]; if (pvc.PLACEID.ToUpper().Contains("TEMP")) { MessageBox.Show("托盘:" + taskSRM.CONTAINERNO + "正在出库!"); return; } } catch (Exception) { MessageBox.Show("托盘:" + taskSRM.CONTAINERNO + "已出库!"); return; } var undoTask = srv.Od_Task_GetNotFinishedTask_by_deviceID("SRM_1").ToList(); undoTask = undoTask.FindAll(x => (x.TOPLACE == "10001" || x.TOPLACE == "11601" || x.TOPLACE == "20001")); var curtsk = srv.Od_Task_GetCurrentTaskByDeviceID("SRM_1"); if (curtsk.TOPLACE == "10001") { undoTask.Add(curtsk); } //foreach (var o in undoTask)//如果任务序列中的任务目标位和未完成任务目标位子冲突,不允许下发 //{ // if (taskSRM.TOPLACE == o.TOPLACE) // { // MessageBox.Show(taskSRM.CONTAINERNO + "的出库口尚有出库任务执行中,请稍后再执行!"); // return; // } //} #endregion if (srv.Od_Task_InsertOne(taskSRM)) { ///将库位号改为TEMP_OUT pvc.PLACEID = "TEMP_OUT"; pvc.UPDATETIME = DateTime.Now.ToString(); pvc.UPDATEUSER = FormLogin.user.USERNAME; srv.Place_Vs_Container_UpdateOne(pvc); } //} } count++; } count = 0; dGVUnLoadItems.Rows.Clear(); dGVUnLoadItems.Refresh(); lsBGate.SelectedIndex = -1; dGVItemQuery.DataSource = null; wait(1500); btnFind_Click(null, null);//出库后执行页面刷新 } }
public bool Place_Vs_Container_InsertOne(IV_place_vs_container one) { return(SQL_Da_IV_place_vs_container.InsertNew(one)); }
public bool Place_Vs_Container_UpdateOne(IV_place_vs_container one) { return(SQL_Da_IV_place_vs_container.UpdateOne(one)); }
/// <summary> /// 更新某条数据 /// </summary> /// <param name="t_new"></param> /// <returns></returns> public static bool UpdateOne(IV_place_vs_container t_new) { try { var tt = t_new; StringBuilder sb = new StringBuilder(); sb.Append(" update IV_place_vs_container set "); sb.Append("WAREHOUSENO=@WAREHOUSENO, "); sb.Append("PLACEID=@PLACEID, "); sb.Append("CONTAINERID=@CONTAINERID, "); sb.Append("UPDATETIME=@UPDATETIME, "); sb.Append("UPDATEUSER=@UPDATEUSER, "); sb.Append("VOID=@VOID, "); sb.Append("ISEMPTYCONTAINER=@ISEMPTYCONTAINER, "); sb.Append("ISEMPTYPLACE=@ISEMPTYPLACE, "); sb.Append("PVC_BACKUP1=@PVC_BACKUP1, "); sb.Append("PVC_BACKUP2=@PVC_BACKUP2, "); sb.Append("PVC_BACKUP3=@PVC_BACKUP3 "); sb.Append(" where ID=@ID "); DbCommand cmd = new SqlCommand(); cmd.CommandText = sb.ToString(); cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@WAREHOUSENO", DbType.String) { Value = tt.WAREHOUSENO }); cmd.Parameters.Add(new SqlParameter("@PLACEID", DbType.String) { Value = tt.PLACEID }); cmd.Parameters.Add(new SqlParameter("@CONTAINERID", DbType.String) { Value = tt.CONTAINERID }); cmd.Parameters.Add(new SqlParameter("@UPDATETIME", DbType.String) { Value = tt.UPDATETIME }); cmd.Parameters.Add(new SqlParameter("@UPDATEUSER", DbType.String) { Value = tt.UPDATEUSER }); cmd.Parameters.Add(new SqlParameter("@VOID", DbType.Int32) { Value = tt.VOID }); cmd.Parameters.Add(new SqlParameter("@ISEMPTYCONTAINER", DbType.String) { Value = tt.ISEMPTYCONTAINER }); cmd.Parameters.Add(new SqlParameter("@ISEMPTYPLACE", DbType.String) { Value = tt.ISEMPTYPLACE }); cmd.Parameters.Add(new SqlParameter("@PVC_BACKUP1", DbType.String) { Value = tt.PVC_BACKUP1 }); cmd.Parameters.Add(new SqlParameter("@PVC_BACKUP2", DbType.String) { Value = tt.PVC_BACKUP2 }); cmd.Parameters.Add(new SqlParameter("@PVC_BACKUP3", DbType.String) { Value = tt.PVC_BACKUP3 }); cmd.Parameters.Add(new SqlParameter("@ID", DbType.String) { Value = tt.ID }); foreach (SqlParameter p in cmd.Parameters) { p.IsNullable = true; if (p.Value == null) { p.Value = DBNull.Value; } } DBHelper DBHelper_SqlServer = new DBLink(); int val = DBHelper_SqlServer.ExecuteNonQuery(cmd); if (val > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } }