private void xemDanhMụcVậtTưCủaCụmToolStripMenuItem_Click(object sender, EventArgs e) { string code = TextUtils.ToString(grvData.GetFocusedRowCellValue(colCode)); string name = TextUtils.ToString(grvData.GetFocusedRowCellValue(colName)); string moduleCode = code.Substring(0, 10); DataTable dtDMVT = TextUtils.Select("select * from MaterialModuleLink with(nolock) where ModuleCode = '" + moduleCode + "'"); DataRow[] drs = dtDMVT.Select("Code = '" + code + "'"); if (drs.Length < 0) { return; } string stt = TextUtils.ToString(drs[0]["STT"]); DataRow[] drs1 = dtDMVT.Select("STT like '" + stt + ".%'"); if (drs1.Length > 0) { DataTable dt = drs1.CopyToDataTable(); dt.ImportRow(drs[0]); frmViewDMVT frm = new frmViewDMVT(); frm.DtDMVT = dt; frm.Code = code; frm.Name = name; frm.Show(); } }
private void btnShowDMVT_Click(object sender, EventArgs e) { string code = TextUtils.ToString(grvData.GetFocusedRowCellValue(colCodeTK)); string name = TextUtils.ToString(grvData.GetFocusedRowCellValue(colNameTK)); DataTable dtDMVT = new DataTable(); dtDMVT = LibQLSX.Select("select * from vMaterialModuleLink with(nolock) where ModuleCode = '" + code + "' order by ID"); frmViewDMVT frm = new frmViewDMVT(); frm.Name = name; frm.Code = code; frm.DtDMVT = dtDMVT.Copy(); frm.Show(); }
private void xemDanhMụcVậtTưToolStripMenuItem_Click(object sender, EventArgs e) { try { using (WaitDialogForm fWait = new WaitDialogForm("Vui lòng chờ trong giây lát", "Đang load danh mục vật tư")) { DocUtils.InitFTPQLSX(); string code = gridView1.GetFocusedRowCellValue(colModuleCode).ToString(); string name = gridView1.GetFocusedRowCellValue(colModuleName).ToString(); //string strFilePath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); //string strFTPFileName = @"//Thietke.Ck/" + code.Substring(0, 6) + "/" + code + ".Ck" + "/VT." + code + ".xlsm "; //string strSaveName = code + ".xlsm"; //if (!DocUtils.CheckExits(strFTPFileName)) //{ // MessageBox.Show("Module không có trên nguồn thiết kế!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Stop); // return; //} //DocUtils.DownloadFile(strFilePath, strSaveName, strFTPFileName); //DataTable dtDMVT = TextUtils.ExcelToDatatableNoHeader(strFilePath + "/" + strSaveName, "DMVT"); //if (File.Exists(strFilePath + "/" + strSaveName)) //{ // File.Delete(strFilePath + "/" + strSaveName); //} //dtDMVT = dtDMVT.AsEnumerable() // .Where(row => TextUtils.ToInt(row.Field<string>("F1") == "" || // row.Field<string>("F1") == null ? "0" : row.Field<string>("F1").Substring(0, 1)) > 0) // .CopyToDataTable(); DataTable dtDMVT = TextUtils.Select("select * from vMaterialModuleLink with(nolock) where ModuleCode = '" + code + "'"); // Hiển thị trên form frmViewDMVT frm = new frmViewDMVT(); frm.Name = name; frm.Code = code; frm.DtDMVT = dtDMVT.Copy(); frm.Show(); } } catch (Exception ex) { TextUtils.ShowError(ex); } }
private void btnShowDMVT_Click(object sender, EventArgs e) { try { using (WaitDialogForm fWait = new WaitDialogForm("Vui lòng chờ trong giây lát", "Đang load danh mục vật tư")) { //DocUtils.InitFTPQLSX(); string code = grvData.GetFocusedRowCellValue(colCode).ToString(); string name = grvData.GetFocusedRowCellValue(colName).ToString(); string strFilePath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); string strFTPFileName = ""; string strSaveName = ""; DocUtils.InitFTPQLSX(); DataTable dtDMVT = new DataTable(); if (code.StartsWith("TPAD.")) { //dtDMVT = LibQLSX.Select("select * from MaterialModuleLink with(nolock) where ModuleCode = '" + code + "' order by ID"); strFTPFileName = string.Format("Thietke.Ck/{0}/{1}.Ck/VT.{1}.xlsm", code.Substring(0, 6), code); strSaveName = code + ".xlsm"; } else { strFTPFileName = @"//Thietke.Dt/PCB/" + code + "/PRD." + code + "/VT." + code + ".xls"; strSaveName = code + ".xls"; } if (!DocUtils.CheckExits(strFTPFileName)) { MessageBox.Show("Module không có trên nguồn thiết kế!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } DocUtils.DownloadFile(strFilePath, strSaveName, strFTPFileName); dtDMVT = TextUtils.ExcelToDatatableNoHeader(strFilePath + "/" + strSaveName, "DMVT"); if (File.Exists(strFilePath + "/" + strSaveName)) { File.Delete(strFilePath + "/" + strSaveName); } dtDMVT.Columns["F1"].ColumnName = "STT"; dtDMVT.Columns["F2"].ColumnName = "Name"; dtDMVT.Columns["F3"].ColumnName = "ThongSo"; dtDMVT.Columns["F4"].ColumnName = "Code"; dtDMVT.Columns["F5"].ColumnName = "MaVatLieu"; dtDMVT.Columns["F6"].ColumnName = "Unit"; dtDMVT.Columns["F7"].ColumnName = "Qty"; dtDMVT.Columns["F8"].ColumnName = "VatLieu"; dtDMVT.Columns["F9"].ColumnName = "Weight"; dtDMVT.Columns["F10"].ColumnName = "Hang"; dtDMVT.Columns["F11"].ColumnName = "Description"; dtDMVT = dtDMVT.AsEnumerable() .Where(row => TextUtils.ToInt(row.Field <string>("STT") == "" || row.Field <string>("STT") == null ? "0" : row.Field <string>("STT").Substring(0, 1)) > 0) .CopyToDataTable(); // Hiển thị trên form frmViewDMVT frm = new frmViewDMVT(); frm.Name = name; frm.Code = code; frm.DtDMVT = dtDMVT.Copy(); frm.Show(); } } catch (Exception ex) { TextUtils.ShowError(ex); } }