protected void btnImport_Click(object sender, EventArgs e) { if (!FileUpload1.HasFile) { return; } string proj_id = Session["PROJECT_ID"].ToString(); string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName); string Extension = Path.GetExtension(FileUpload1.PostedFile.FileName); string FolderPath = WebTools.SessionDataPath(); string FilePath = FolderPath + FileName; FileUpload1.SaveAs(FilePath); // delete old data WebTools.ExecNonQuery("DELETE FROM PIP_MSR_IMPORT"); WebTools.ExecNonQuery("DELETE FROM PIP_PO_DETAIL"); WebTools.ExecNonQuery("DELETE FROM PIP_PO"); FileStream stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); ExcelImport.ImporNpoi(stream, "PIP_MSR_IMPORT", "", "PROJECT_ID", proj_id); WebTools.ExecNonQuery("DELETE PIP_MSR_IMPORT WHERE PO_NO='TEXT' OR AMD_NO='TEXT' OR MATERIAL_DESCRIPTION1='TEXT'"); WebTools.ExecNonQuery("UPDATE PIP_MSR_IMPORT SET MATERIAL_DESCRIPTION1=UPPER(MATERIAL_DESCRIPTION1)"); WebTools.ExecNonQuery("UPDATE PIP_MSR_IMPORT SET MATERIAL_DESCRIPTION2=UPPER(MATERIAL_DESCRIPTION2)"); WebTools.ExecNonQuery("UPDATE PIP_MSR_IMPORT SET IDENT_CD=MATERIAL_DESCRIPTION1 WHERE IDENT_CD IS NULL AND MATERIAL_DESCRIPTION1 IS NOT NULL"); WebTools.ExecNonQuery("DELETE PIP_MSR_IMPORT WHERE IDENT_CD IS NULL"); WebTools.ExecNonQuery("BEGIN PKG_IMPORT_PO.APPEND_PO(" + proj_id + ");END;"); Master.ShowSuccess("PO imported!"); } // method
protected void btnImport_Click(object sender, EventArgs e) { if (!FileUpload1.HasFile) { return; } string proj_id = Session["PROJECT_ID"].ToString(); string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName); string Extension = Path.GetExtension(FileUpload1.PostedFile.FileName); string FolderPath = WebTools.SessionDataPath(); string FilePath = FolderPath + FileName; FileUpload1.SaveAs(FilePath); // delete old data WebTools.ExecNonQuery("DELETE FROM IMPORT_CMS_SPL_AVL WHERE PROJECT_ID IN (0, -1, " + Session["PROJECT_ID"].ToString() + ")"); FileStream stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); ExcelImport.ImporNpoi(stream, "IMPORT_CMS_SPL_AVL", "PK_IMPORT_CMS_SPL_AVL", "PROJECT_ID", proj_id); WebTools.ExecNonQuery("BEGIN PKG_IMPORT_CMS_SPL_AVL.UPDATE_SPOOL(" + Session["PROJECT_ID"].ToString() + ");END;"); Master.ShowSuccess("CMS Material Available Status imported!"); } // method
private void ImportCccSpool(string Extension, string FilePath, string proj_id) { WebTools.ExecNonQuery("DELETE FROM CCC_IMPORT_SPOOL WHERE PROJECT_ID IN (0, -1, " + proj_id + ")"); FileStream fs = new FileStream(FilePath, FileMode.Open); ExcelImport.ImporNpoi(fs, "CCC_IMPORT_SPOOL", "CCC_IMPORT_SPOOL_UK1", "PROJECT_ID", proj_id); WebTools.ExecNonQuery("DELETE FROM CCC_IMPORT_SPOOL WHERE ISO_TITLE1='TEXT' OR SPOOLNO='TEXT'"); WebTools.ExecNonQuery("BEGIN PKG_CCC_IMPORT_MTO.PRC_IMPORT_SPL(" + proj_id + ");END;"); }