private void btnRefresh_Click(object sender, EventArgs e)
{
ChannelDal channelDal = new ChannelDal();
DataTable table = channelDal.GetAllChannel();
bsMain.DataSource = table;
}
public void Refresh()
{
StateManagerDal dal = new StateManagerDal();
ChannelDal channelDal = new ChannelDal();
string rowIndex = dal.FindScannerIndexNoByStateCode("01")["ROW_INDEX"].ToString();
gridControl.DataSource = channelDal.FindScokChannel(rowIndex);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
////保存修改到数据库
ChannelDal channelDal = new ChannelDal();
channelDal.Save(txtChannelCode.ToolTip, txtCigaretteCode.Text, txtCigaretteName.Text, ddlStatus.SelectedValue);
JScript.Instance.ShowMessage(UpdatePanel1, "保存数据成功。");
}
public ActionResult Insert(string id = "")
{
var cate = new ChannelModel();
if (!string.IsNullOrEmpty(id))
{
cate = ChannelDal.Get(id, EnumChannelQueryKey.Id);
}
ViewBag.cate = cate;
return(View());
}
private void BindData()
{
pager.PageSize = PagingSize;
ChannelDal channelDal = new ChannelDal();
string filter = null;
if (ViewState["Filter"] != null)
{
filter = ViewState["Filter"].ToString();
}
pager.RecordCount = channelDal.GetCount(filter);
DataTable table = channelDal.GetAll(pageIndex, PagingSize, filter);
BindTable2GridView(gvMain, table);
}
public ActionResult Insert(string id, ChannelModel channel)
{
channel.UpdateTime = DateTime.Now;
if (!string.IsNullOrEmpty(id))
{
channel.Id = ObjectId.Parse(id);
ChannelDal.UpdateChannel(channel);
}
else
{
channel.CreateTime = DateTime.Now;
channel.Status = EnumChannelStatus.Normal;
ChannelDal.AddChannel(channel);
}
return(RedirectToRoute(Insert()));
}
protected override void StateChanged(StateItem stateItem, IProcessDispatcher dispatcher)
{
/* 处理事项：
* 二层小车进入缓存站台
*/
object obj = ObjectUtil.GetObject(stateItem.State);
if (obj == null || obj.ToString() == "0")
{
return;
}
string WriteItem = "";
string ChannelNo = "";
object objChannel;
string strReadItem = "";
try
{
switch (stateItem.ItemName)
{
case "02_1_378_1":
WriteItem = "02_2_378";
ChannelNo = "415";
strReadItem = "02_1_378_2";
break;
case "02_1_381_1":
WriteItem = "02_2_381";
ChannelNo = "431";
strReadItem = "02_1_381_2";
break;
case "02_1_383_1":
WriteItem = "02_2_383";
ChannelNo = "438";
strReadItem = "02_1_383_2";
break;
case "02_1_385_1":
WriteItem = "02_2_385";
ChannelNo = "461";
strReadItem = "02_1_385_2";
break;
case "02_1_387_1":
WriteItem = "02_2_387";
ChannelNo = "465";
strReadItem = "02_1_387_2";
break;
case "02_1_389_1":
WriteItem = "02_2_389";
ChannelNo = "471";
strReadItem = "02_1_389_2";
break;
}
string TaskNo = obj.ToString().PadLeft(4, '0');
objChannel = ObjectUtil.GetObject(WriteToService("StockPLC_02", strReadItem));
TaskDal dal = new TaskDal();
string[] strValue = dal.GetTaskInfo(TaskNo);
if (!string.IsNullOrEmpty(strValue[0]))
{
ChannelDal Cdal = new ChannelDal();
ChannelNo = Cdal.GetChannelFromTask(TaskNo, strValue[1]);
dal.UpdateTaskDetailState(string.Format("TASK_ID='{0}' AND ITEM_NO=5", strValue[0]), "2"); //更新
if (objChannel.ToString() == ChannelNo) //返回正确的缓存道。
{
int value = Cdal.UpdateInChannelTime(strValue[0], strValue[1], ChannelNo);
WriteToService("StockPLC_02", WriteItem + "_1", value);
WriteToService("StockPLC_02", WriteItem + "_2", 1);
}
else
{
int value = Cdal.UpdateInChannelAndTime(strValue[0], strValue[1], objChannel.ToString());
WriteToService("StockPLC_02", WriteItem + "_1", value);
WriteToService("StockPLC_02", WriteItem + "_2", 2);
}
}
}
catch (Exception e)
{
Logger.Error("THOK.XC.Process.Process_02.StockOutInCacheProcess，原因：" + e.Message);
}
}
private void DownloadData()
{
try
{
using (TransactionScopeManager TM = new TransactionScopeManager())
{
OrderDal orderDal = new OrderDal();
orderDal.TransactionScopeManager = TM;
if (orderDal.FindUnsortCount() == true)
{
if (DialogResult.Cancel == MessageBox.Show("还有未分拣的数据，您确定要重新下载数据吗？", "询问", MessageBoxButtons.OKCancel, MessageBoxIcon.Question))
{
return;
}
}
ChannelDal channelDal = new ChannelDal();
ServerDal serverDal = new ServerDal();
DataTable table = serverDal.FindBatch();
if (table.Rows.Count != 0)
{
string batchsortid = table.Rows[0]["batch_no"].ToString();
orderDal.DeleteExportData();//删除贴标机数据(未实现删除哪些表)
//AutomationContext.Write(plcServiceName, O_StockIn_Task_Info, data);
//下载烟道表
table = serverDal.FindChannel(batchsortid);
channelDal.InsertChannel(table);
System.Threading.Thread.Sleep(100);
//下载订单主表
table = serverDal.FindOrderMaster(batchsortid);
orderDal.InsertMaster(table);
System.Threading.Thread.Sleep(100);
//下载订单明细表
table = serverDal.FindOrderDetail(batchsortid);
orderDal.InsertOrderDetail(table);
//下载手工补货订单明细表
table = serverDal.FindHandleSupply(batchsortid);
orderDal.InsertHandleSupply(table);
//更新批次状态（下载完成）
serverDal.UpdateBatchStatus(batchsortid);
MessageBox.Show("数据下载完成", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
//Context.ProcessDispatcher.WriteToProcess("LEDProcess", "NewData", null);
//Context.ProcessDispatcher.WriteToProcess("CreatePackAndPrintDataProcess", "NewData", null);
//Context.ProcessDispatcher.WriteToProcess("CurrentOrderProcess", "CurrentOrderA", new int[] { -1 });
//Context.ProcessDispatcher.WriteToProcess("monitorView", "ProgressState", new ProgressState());
}
else
{
MessageBox.Show("没有需要分拣的订单数据。", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception e)
{
Logger.Error("下载数据失败！原因：" + e.Message);
}
}
protected override void StateChanged(StateItem stateItem, IProcessDispatcher dispatcher)
{
/* 处理事项：
* 二层小车进入缓存站台
*/
object obj = ObjectUtil.GetObject(stateItem.State);
if (obj == null || obj.ToString() == "0")
{
return;
}
string WriteItem = "";
try
{
switch (stateItem.ItemName)
{
case "02_1_475":
WriteItem = "02_2_475";
break;
case "02_1_440":
WriteItem = "02_2_440";
break;
case "02_1_412":
WriteItem = "02_2_412";
break;
}
string TaskNo = obj.ToString().PadLeft(4, '0');
TaskDal dal = new TaskDal();
string[] strValue = dal.GetTaskInfo(TaskNo);
if (!string.IsNullOrEmpty(strValue[0]))
{
dal.UpdateTaskDetailState(string.Format("TASK_ID='{0}' AND ITEM_NO=5", strValue[0]), "2"); //更新
ChannelDal cDal = new ChannelDal();
cDal.UpdateOutChannelTime(strValue[0]);
WriteToService("StockPLC_02", WriteItem, 1);
}
//读取码盘机是否处于，申请位；
string SeparateItem = "";
object objSeparate = ObjectUtil.GetObject(WriteToService("StockPLC_02", "02_1_372_1"));
if (objSeparate.ToString() != "0")
{
SeparateItem = "02_1_372_1";
}
else
{
objSeparate = ObjectUtil.GetObject(WriteToService("StockPLC_02", "02_1_392_1"));
if (objSeparate.ToString() != "0")
{
SeparateItem = "02_1_392_1";
}
}
if (SeparateItem != "")
{
WriteToProcess("StockOutSeparateProcess", SeparateItem, 1);
}
}
catch (Exception e)
{
Logger.Error("THOK.XC.Process.Process_02.StockOutCacheProcess，原因：" + e.Message);
}
}
public static ChannelModel GetChannelIdByLink(string link)
{
var info = GetInfoByLink(link);
if (info == new Tuple <string, string, string, string>("", "", "", "") || string.IsNullOrEmpty(info.Item2) || string.IsNullOrEmpty(info.Item3))
{
return(null);
}
var type = info.Item1;
var channelLinkName = info.Item2;
var title = info.Item3;
var cateLinkName = info.Item4;
ChannelModel channel = ChannelDal.Get(GetChannelInfoByLink(link, false).link, EnumChannelQueryKey.LinkName);
if (channel == null)
{
//insert new channelid
if (info.Item1.ToLower() != "events")
{
var channelInfo = GetChannelInfoByLink(link, false);
ChannelModel newchannel = new ChannelModel()
{
CreateTime = DateTime.Now,
UpdateTime = DateTime.Now,
Name = channelInfo.title, // info.Item2,
Description = channelInfo.descrtiption, // info.Item2,
Image = channelInfo.image,
LinkName = channelInfo.link,
ParentId = null,
ParentType = EnumChannelParent.Default,
Status = EnumChannelStatus.Normal
};
ChannelDal.AddChannel(newchannel);
channel = ChannelDal.Get(info.Item2, EnumChannelQueryKey.Name);
}
else
{
var bigChannelInfo = GetChannelInfoByLink(link, true);
//新建大频道.再建小频道
ChannelDal.AddChannel(new ChannelModel()
{
CreateTime = DateTime.Now,
UpdateTime = DateTime.Now,
Name = bigChannelInfo.title, //info.Item2,
Description = bigChannelInfo.descrtiption, //info.Item2,
Image = bigChannelInfo.image,
LinkName = bigChannelInfo.link,
ParentId = null,
ParentType = EnumChannelParent.Events,
Status = EnumChannelStatus.Normal
});
var parentChanenl = ChannelDal.Get(bigChannelInfo.title, EnumChannelQueryKey.Name);
var channelInfo = GetChannelInfoByLink(link, false);
ChannelDal.AddChannel(new ChannelModel()
{
CreateTime = DateTime.Now,
UpdateTime = DateTime.Now,
Name = channelInfo.title, // info.Item3,
Description = channelInfo.descrtiption, // info.Item3,
Image = channelInfo.image,
LinkName = channelInfo.link,
ParentId = parentChanenl.Id.ToString(),
ParentType = EnumChannelParent.Events,
Status = EnumChannelStatus.Normal
});
channel = ChannelDal.Get(info.Item3, EnumChannelQueryKey.Name);
}
}
return(channel);
}
protected override void StateChanged(StateItem stateItem, IProcessDispatcher dispatcher)
{
/* 处理事项：
* 二层出库拆盘完成
* stateItem.State ：参数 - 请求的卷烟编码。
*/
object obj = ObjectUtil.GetObject(stateItem.State);
if (obj == null || obj.ToString() == "0")
{
return;
}
string WriteItem = "";
string FromStation = "";
string strTaskItem = "";
object objTaskNo;
try
{
switch (stateItem.ItemName)
{
case "02_1_372_1":
FromStation = "372";
WriteItem = "02_2_372";
strTaskItem = "02_1_372_2";
break;
case "02_1_392_1":
FromStation = "392";
WriteItem = "02_2_392";
strTaskItem = "02_1_392_2";
break;
}
objTaskNo = ObjectUtil.GetObject(WriteToService("StockPLC_02", strTaskItem));
string TaskNo = objTaskNo.ToString().PadLeft(4, '0');
TaskDal dal = new TaskDal();
string[] strValue = dal.GetTaskInfo(TaskNo);
if (!string.IsNullOrEmpty(strValue[0]))
{
bool blnvalue = dal.SeparateTaskDetailStart(strValue[0]); //判断该任务是否开始执行
if (!blnvalue)
{
ChannelDal cdal = new ChannelDal();
string strChannelNo = cdal.InsertChannel(strValue[0], strValue[1]);//分配缓存道
if (strChannelNo != "")
{
dal.UpdateTaskDetailState(string.Format("TASK_ID='{0}' AND ITEM_NO=4", strValue[0]), "2");
WriteToService("StockPLC_02", WriteItem + "_1", int.Parse(strChannelNo));
WriteToService("StockPLC_02", WriteItem + "_2", 1);
dal.UpdateTaskDetailStation(FromStation, strChannelNo, "1", string.Format("TASK_ID='{0}' AND ITEM_NO=5", strValue[0]));
}
}
}
}
catch (Exception e)
{
Logger.Error("THOK.XC.Process.Process_02.StockOutSeparateProcess，原因：" + e.Message);
}
}
public void Refresh()
{
ChannelDal channelDal = new ChannelDal();
gridControl.DataSource = channelDal.FindAllSortChannel();
}
