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_ISOMETRIC_IMPORT WHERE PROJECT_ID IN (0, -1, " + proj_id + ")"); ExcelImport.Import_Excel_File(FilePath, Extension, "PIP_ISOMETRIC_IMPORT", "PIP_ISOMETRIC_IMPORT_PK", "PROJECT_ID", Session["PROJECT_ID"].ToString()); WebTools.ExecNonQuery("BEGIN PKG_IMPORT_ISO.PRC_IMPORT_ISO(" + proj_id + ");END;"); Master.ShowSuccess("Isometric list imported!"); } // method
private static void ImportSPS(string Extension, string FilePath, string proj_id) { WebTools.ExecNonQuery("DELETE FROM PIP_SUPP_MTO_SPS WHERE PROJECT_ID IN (0, -1, " + proj_id + ")"); ExcelImport.Import_Excel_File(FilePath, Extension, "PIP_SUPP_MTO_SPS", "PK_SUPP_MTO_SPS", "PROJECT_ID", proj_id); WebTools.ExecNonQuery("DELETE FROM PIP_SUPP_MTO_SPS WHERE ITEM_NAME='TEXT' OR ITEM_TYPE='TEXT'"); }
private static void ImportSuppMTO(string Extension, string FilePath, string proj_id) { WebTools.ExecNonQuery("DELETE FROM PIP_SUPP_MTO_LINE_ID WHERE PROJECT_ID IN (0, -1, " + proj_id + ")"); ExcelImport.Import_Excel_File(FilePath, Extension, "PIP_SUPP_MTO_LINE_ID", "UK_PIP_SUPP_MTO_LINE_ID", "PROJECT_ID", proj_id); WebTools.ExecNonQuery("DELETE FROM PIP_SUPP_MTO_LINE_ID WHERE ITEM_NAME='TEXT' OR ITEM_TYPE='TEXT'"); WebTools.ExecNonQuery("UPDATE PIP_SUPP_MTO_LINE_ID SET NOTE=UPPER(NOTE)"); WebTools.ExecNonQuery("UPDATE PIP_SUPP_MTO_LINE_ID SET SCOPE_NAME=UPPER(SCOPE_NAME)"); WebTools.ExecNonQuery("UPDATE PIP_SUPP_MTO_LINE_ID SET AREA_NAME=UPPER(AREA_NAME)"); WebTools.ExecNonQuery("BEGIN PKG_UPDATE_SUPP_MTO.INSERT_MTO(" + proj_id + ");END;"); }
protected void btnImport_Click(object sender, EventArgs e) { if (FileUpload1.HasFile) { 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 FIELD_WELDING_IMPORT WHERE PROJECT_ID=" + Session["PROJECT_ID"].ToString()); //Import_Excel_File(FilePath, Extension, "Yes"); ExcelImport.Import_Excel_File(FilePath, Extension, "FIELD_WELDING_IMPORT", "PK_FIELD_WELDING_IMPORT", "PROJECT_ID", Session["PROJECT_ID"].ToString()); // update proj_id WebTools.ExecNonQuery("UPDATE FIELD_WELDING_IMPORT SET PROJECT_ID=" + Session["PROJECT_ID"].ToString() + " WHERE PROJECT_ID IS NULL"); Save_Welding(); } }