/// <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);
}
}
