/// <summary>
/// 插入任务表
/// </summary>
/// <param name="fromPlace"></param>
/// <param name="toPlace"></param>
private bool GreateTask(string fromPlace, string toPlace)
{
//string nowTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
string nowTime = srv.CommonMethod_GetServerTime().ToUniversalTime().AddHours(8).ToString("yyyy-MM-dd HH:mm:ss");
OD_Task taskSRM = new OD_Task();
taskSRM.TASKID = Guid.NewGuid().ToString();
taskSRM.TASKNAME = "堆垛机入库" + DateTime.Now.ToString("yyyyMMddHHmmssfff");
taskSRM.TASKTYPE = "SRM_Store_In"; //任务类型
taskSRM.TASKTYPEDESCRIPTION = "堆垛机入库";
taskSRM.TASKSTATUS = "In_Intention"; //想要入库
taskSRM.TASKLEVEL = "Normal";
taskSRM.TASKCONTENTSTRING = itemDetails;
taskSRM.DODEVICEID = "SRM_1"; //设备号
taskSRM.DODEVICENODEID = "000011"; //设备节点号
taskSRM.DODEVICETYPE = "SRM"; //设备类型
taskSRM.SOURCEPLACE = fromPlace;
taskSRM.TOPLACE = toPlace; //入库口和目标库位
taskSRM.SENDTIMES = 1;
taskSRM.RELEASESTATUS = "N";
taskSRM.HADFINISH = "N";
taskSRM.ORDERHEADID = "";
taskSRM.ORDERDETAILSID = "";
taskSRM.VOID = 0;
taskSRM.UPDATEUSER = "";
taskSRM.UPDATETIME = nowTime;
taskSRM.ISCURRENTTASK = "N";
taskSRM.ISLASTTASK = "N";
taskSRM.CONTAINERNO = tBContainer.Text.Trim();
taskSRM.INPUTLOCATIONLEVEL = 1;
taskSRM.WAREHOUSENO = "端拾器立体库";
if (srv.Od_Task_InsertOne(taskSRM))
{
itemDetails = string.Empty;
return(true);
}
else
{
return(false);
}
}
}
/// <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 bool isSkuRight()
{
string sku = tBSku.Text.Trim();
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
if (tBContainer.Enabled == true)
{
MessageBox.Show("请先对托盘号绑定再进行扫码工作");
return(false);
}
if (string.IsNullOrEmpty(tBContainer.Text.Trim()))
{
return(true); //无条码则退出
}
if (sku == "")
{
return(true);
}
try
{
var item = srv.IM_Item_GetOneBySku(sku);
if (item == null || string.IsNullOrEmpty(item.SKU))
{
MessageBox.Show("无此物料！");
tBSku.Text = "";
return(false);
}
if (AlreadyScan.Text.IndexOf(tBSku.Text) != -1)
{
MessageBox.Show("物料条码不能重复扫描！");
tBSku.Text = "";
return(false);
}
if (tBSku.Text != "0000" && label4.Visible == false)
{
label4.Visible = true;
AlreadyScan.Visible = true;
}
if (AlreadyScan.Text == "")
{
AlreadyScan.Text = tBSku.Text;
}
else
{
AlreadyScan.Text += ";\r\n" + tBSku.Text;
}
// MessageBox.Show(AlreadyScan.Height.ToString());
AlreadyScan.Height = 32 * (AlreadyScan.Text.ToString().Split(';').Length);
var cvi = new IV_container_vs_item();
cvi.ID = Guid.NewGuid().ToString();
cvi.ITEMDESC = item.SKUDESC;
cvi.ITEMQTY = 1;
cvi.ITEMSKU = sku;
cvi.UPDATETIME = srv.CommonMethod_GetServerTime().ToString("yyyy-MM-dd HH:mm:ss");
cvi.UPDATEUSER = "";
cvi.VOID = 0;
cvi.CONTAINERID = tBContainer.Text.Trim();
srv.Container_Vs_Items_InsertOne(cvi);
itemDetails += "" + cvi.ITEMDESC + ":" + cvi.ITEMQTY + "套 " + ";";
tBSku.Text = "";
tBSku.Focus();
return(true);
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
return(false);
MessageBox.Show("连接数据库失败!");
}
}
}
public FrmLoading()
{
InitializeComponent();
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{ srv.CommonMethod_GetServerTime(); }
}
