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
}
