private void FmLoad(object sender, EventArgs e) { this.InitGrid(GridFile); var dal = new MCardDAL(); var modInfo = dal.GetMomRow(CardNo); var cardM = dal.GetCardMain(CardNo); string fldr = cardM.cInvCode.Substring(0, 4) + modInfo.cInvCode.Substring(2); basePath = Information.FileServerInfo.FtpAddress + "\\" + modInfo.cInvCode + "\\" + fldr; this.gridControl1.DataSource = this.GetFileList(basePath); this.GridFile.DoubleClick += new EventHandler(new Action <object, EventArgs>((x, y) => { var curfile = GridFile.GetFocusedRow() as FileInformaion; if (curfile.FileExt == "文件夹") { this.curPath = curfile.FileFullName; this.gridControl1.DataSource = this.GetFileList(curPath); } else { ProcessStartInfo info = new ProcessStartInfo(); info.WorkingDirectory = basePath; info.FileName = curfile.FileFullName; Process.Start(info); } })); }
private void BtnExport_Click(object sender, EventArgs e) { if (listCard.Count < 1) { throw new Exception("没有记录, 请先扫描流转卡!"); } List <string> cards = new List <string>(); listCard.ForEach(x => { cards.Add(x.M.CardNo); }); var dt = new MCardDAL().GetExportTable(cards.ToArray()); using (var sfd = new SaveFileDialog()) { sfd.DefaultExt = "xlsx"; sfd.Filter = "* Excel文件|*.xlsx"; if (sfd.ShowDialog() == DialogResult.OK) { NPOIHelper.TableToExcel(dt, sfd.FileName); MsgBox.ShowInfoMsg("导出成功!"); } } }
private void BtnPrint_Click(object sender, EventArgs e) { #region 打印 if (string.IsNullOrEmpty(cardNo)) { throw new Exception("未生成流转卡!"); } MCardDAL mdal = new MCardDAL(); DataTable dtMain = mdal.GetHead(cardNo); DataTable dtDetail = mdal.GetBody(cardNo); string path = Application.StartupPath.Trim('\\'); this.report1.Load(path + "\\ReportPrint\\产品跟踪卡.frx"); this.report1.RegisterData(dtMain, "M"); this.report1.RegisterData(dtDetail, "D"); this.report1.GetDataSource("M").Enabled = true; this.report1.GetDataSource("D").Enabled = true; this.report1.Show(); #endregion }
private void Btn_MoCards_Click(object sender, EventArgs e) { var handleArray = gridView1.GetSelectedRows(); StringBuilder sb = new StringBuilder(); var cardDal = new MCardDAL(); foreach (int handle in handleArray) { var guid = gridView1.GetRowCellValue(handle, "guid").ToString(); var wocode = gridView1.GetRowCellValue(handle, "WOCode").ToString(); if (dal.ExistRef(guid)) { sb.Append("指令单:" + wocode + " 已存在流转卡, 不能批量生成!\r\n"); continue; } var model = dal.Get(guid); if (model.bClosed) { sb.Append("指令单:" + model.WOCode + " 已关闭, 不能创建!\r\n"); continue; } else if (model.WorkOrderRouter.Rows.Count < 1) { sb.Append("指令单:" + model.WOCode + " 没有工艺, 创建失败!\r\n"); continue; } foreach (DataRow r in model.WorkOrderDetail.Rows) { if (r["RouterId"].ToString() == "") { sb.Append("指令单:" + model.WOCode + " 有子件尚未分配领用工序, 创建失败!\r\n"); continue; } } cardDal.CreateCard(model.Guid, 1, model.iQuantity); } if (sb.ToString() == "") { sb.Append("创建成功!"); } MsgBox.ShowInfoMsg(sb.ToString()); }
private void OpenCard() { #region 打开已已开工,未完工卡 List <string> wheres = new List <string>() { "operationId = " + operationId, "isnull(bComplete,0) = 0", "isnull(bClosed,0) = 0", "(iStatus > 0 and iStatus < 5 or MotypeId in (select MotypeId from motypecontrol where bOrderOff = 1)) " }; if (equipmentId != 0) { wheres.Add("EQId = " + equipmentId); } var ls = new MCardDAL().GetCardDetails(wheres.ToArray()); ls.ForEach(x => { MCardControl control = new MCardControl(x.CardNo, equipmentId); control.CloseParentTab = CloseTab; var tab = NewPage(control); control.Settime = new MCardControl.SetTimeDelegate( new Action <decimal>(seconds => { if (seconds < 0) { tab.PredefinedColor = eTabItemColor.Red; tab.Text = x.CardNo + " [超时]"; return; } var min = Math.Floor(seconds / 60); var hours = Math.Floor(min / 60); var leftSec = seconds % 60; var str = " [" + hours.ToString() + "小时 " + min.ToString() + "分" + leftSec.ToString() + "秒]"; tab.Text = x.CardNo + str; }) ); }); #endregion }
private void gridView1_DoubleClick(object sender, EventArgs e) { #region 查询报工记录明细 string cardNo = gridView1.GetFocusedRowCellValue("CardNo").ToString(); MCardDAL dal = new MCardDAL(); List <string> wheres = new List <string>(); wheres.Add("t1.CardNo = '" + cardNo + "'"); DataTable dt = dal.GetRepRecord(wheres, null); FmRepList frm = new FmRepList(dt); frm.ShowDialog(); #endregion }
private void BtnPrint_Click(object sender, EventArgs e) { #region 打印 if (string.IsNullOrEmpty(cardNo)) { throw new Exception("未生成流转卡!"); } MCardDAL mdal = new MCardDAL(); DataTable dtMain = mdal.GetHead(cardNo); DataTable dtDetail = mdal.GetBody(cardNo); string path = ".\\ReportPrint\\产品跟踪卡.frx"; var rep = FReportHelper.GetReport(path, dtMain, dtDetail); rep.Show(); #endregion }