private void selectOracleData() { string szQuery = "EENG_MDM_LABEL_PKG.NGLS_LABEL_OUTPUT"; try { using (OracleConnection oracleConnection = new OracleConnection(ConfigurationSettings.AppSettings["GERP_ConnectionString"])) { oracleConnection.Open(); //한국어로 나와야 해서 실행함. using (OracleCommand oracleCommand = new OracleCommand("ALTER SESSION SET nls_language = '" + _search_lang + "'", oracleConnection)) { oracleCommand.ExecuteNonQuery(); } using (OracleCommand oracleCommand = new OracleCommand(szQuery, oracleConnection)) { //oracleCommand.CommandType = CommandType.Text; oracleCommand.CommandType = CommandType.StoredProcedure; oracleCommand.Parameters.Add("P_RETURN_STATUS", OracleType.VarChar, 2000).Direction = ParameterDirection.Output; oracleCommand.Parameters.Add("P_ERROR_MESSAGE", OracleType.VarChar, 2000).Direction = ParameterDirection.Output; oracleCommand.Parameters.Add("P_GUBUN", OracleType.VarChar).Value = _search_gubun; //"I"; oracleCommand.Parameters.Add("P_SITE_CODE", OracleType.VarChar).Value = _search_factory; //"P11"; oracleCommand.Parameters.Add("P_INPUT_CODE", OracleType.VarChar).Value = _search_code; //"PAA007321/18L"; oracleCommand.Parameters.Add("P_RESULT", OracleType.Cursor).Direction = ParameterDirection.Output; using (OracleDataAdapter oracleDataAdapter = new OracleDataAdapter(oracleCommand)) { try { DataSet dataSet = new DataSet(); oracleDataAdapter.Fill(dataSet); _erpDataTable = dataSet.Tables[0]; _p_return_status = ComUtils.GetNotNullToString(oracleCommand.Parameters["P_RETURN_STATUS"].Value); _p_error_message = ComUtils.GetNotNullToString(oracleCommand.Parameters["P_ERROR_MESSAGE"].Value); } catch (Exception ex) { _gerp_exception_yn = "Y"; //오라클에서 조회된 결과가 없을 경우 exception 으로 빠지는데 임의로 빈 DataTable 을 생성하여 오류를 방지하고자 함.(조회된 데이터가 없을 때 화면 초기화 하는 역활도 함.) //{"ORA-06502: PL/SQL: numeric or value error: character string buffer too small\nORA-06512: at \"APPS.EENG_MDM_LABEL_PKG\", line 283\nORA-06502: PL/SQL: numeric or value error: character string buffer too small\nORA-06512: at line 1\n"} //{"ORA-24338: statement handle not executed\n"} _erpDataTable = new DataTable(); _erpDataTable.Rows.Add(_erpDataTable.NewRow()); _p_return_status = ComUtils.GetNotNullToString(oracleCommand.Parameters["P_RETURN_STATUS"].Value); _p_error_message = ComUtils.GetNotNullToString(oracleCommand.Parameters["P_ERROR_MESSAGE"].Value); } } } } } catch (Exception ex) { //throw ex; } }
private void InitDefaultData() { //쿠키값이 있다면 id 세팅 uid.Value = GetCookie("LOGIN_ID_SAVE"); //이미 로그인이 되어 있다면. if (ComUtils.GetNotNullToString(Session["LOGIN_ID"]) != "") { Response.Redirect("/Basic/Main/BasicMain.aspx"); } }
private void SaveData() { Hashtable hash = new Hashtable(); StringBuilder columnSql = new StringBuilder(); //파라메터 처리 makeQueryDataValue(columnSql, hash, "@company_code", ComUtils.GetDefaultString(Request["company_code"], "")); makeQueryDataValue(columnSql, hash, "@site_code", ComUtils.GetDefaultString(Request["site_code"], "")); makeQueryDataValue(columnSql, hash, "@item_number", ComUtils.GetDefaultString(Request["item_number"], "")); makeQueryDataValue(columnSql, hash, "@lot_number", ComUtils.GetDefaultString(Request["lot_number"], "")); makeQueryDataValue(columnSql, hash, "@prod_qty", ComUtils.GetDefaultString(Request["prod_qty"], "")); makeQueryDataValue(columnSql, hash, "@prod_qty_kg", ComUtils.GetDefaultString(Request["prod_qty_kg"], "")); makeQueryDataValue(columnSql, hash, "@so_qty", ComUtils.GetDefaultString(Request["so_qty"], "")); makeQueryDataValue(columnSql, hash, "@so_qty_kg", ComUtils.GetDefaultString(Request["so_qty_kg"], "")); makeQueryDataValue(columnSql, hash, "@mfg_date", ComUtils.GetDefaultString(Request["mfg_date"], "")); makeQueryDataValue(columnSql, hash, "@alternateitem", ComUtils.GetDefaultString(Request["alternateitem"], "")); makeQueryDataValue(columnSql, hash, "@salesrep_name", ComUtils.GetDefaultString(Request["salesrep_name"], "")); makeQueryDataValue(columnSql, hash, "@item_desc", ComUtils.GetDefaultString(Request["item_desc"], "")); makeQueryDataValue(columnSql, hash, "@item_desc2", ComUtils.GetDefaultString(Request["item_desc2"], "")); makeQueryDataValue(columnSql, hash, "@wip_item_desc", ComUtils.GetDefaultString(Request["wip_item_desc"], "")); makeQueryDataValue(columnSql, hash, "@mix_item_code", ComUtils.GetDefaultString(Request["mix_item_code"], "")); makeQueryDataValue(columnSql, hash, "@label_color_type_name", ComUtils.GetDefaultString(Request["label_color_type_name"], "")); makeQueryDataValue(columnSql, hash, "@label_color_type_code", ComUtils.GetDefaultString(Request["label_color_type_code"], "")); makeQueryDataValue(columnSql, hash, "@mix_rate", ComUtils.GetDefaultString(Request["mix_rate"], "")); makeQueryDataValue(columnSql, hash, "@msds_code", ComUtils.GetDefaultString(Request["msds_code"], "")); makeQueryDataValue(columnSql, hash, "@inwha_point", ComUtils.GetDefaultString(Request["inwha_point"], "")); makeQueryDataValue(columnSql, hash, "@risk_material", ComUtils.GetDefaultString(Request["risk_material"], "")); makeQueryDataValue(columnSql, hash, "@cautionclass", ComUtils.GetDefaultString(Request["cautionclass"], "")); makeQueryDataValue(columnSql, hash, "@chemical_name", ComUtils.GetDefaultString(Request["chemical_name"], "")); makeQueryDataValue(columnSql, hash, "@include_rate", ComUtils.GetDefaultString(Request["include_rate"], "")); makeQueryDataValue(columnSql, hash, "@regulatory_year", ComUtils.GetDefaultString(Request["regulatory_year"], "")); makeQueryDataValue(columnSql, hash, "@regulatory_lv_name", ComUtils.GetDefaultString(Request["regulatory_lv_name"], "")); makeQueryDataValue(columnSql, hash, "@regulatory_lv1_name", ComUtils.GetDefaultString(Request["regulatory_lv1_name"], "")); makeQueryDataValue(columnSql, hash, "@regulatory_lv2_name", ComUtils.GetDefaultString(Request["regulatory_lv2_name"], "")); makeQueryDataValue(columnSql, hash, "@regulatory_voc_value", ComUtils.GetDefaultString(Request["regulatory_voc_value"], "")); makeQueryDataValue(columnSql, hash, "@voc_value", ComUtils.GetDefaultString(Request["voc_value"], "")); makeQueryDataValue(columnSql, hash, "@water_diluent_code", ComUtils.GetDefaultString(Request["water_diluent_code"], "")); makeQueryDataValue(columnSql, hash, "@diluent_rate", ComUtils.GetDefaultString(Request["diluent_rate"], "")); makeQueryDataValue(columnSql, hash, "@car_type", ComUtils.GetDefaultString(Request["car_type"], "")); makeQueryDataValue(columnSql, hash, "@kungwha_item_code", ComUtils.GetDefaultString(Request["kungwha_item_code"], "")); makeQueryDataValue(columnSql, hash, "@type_code", ComUtils.GetDefaultString(Request["type_code"], "")); makeQueryDataValue(columnSql, hash, "@used_type_code", ComUtils.GetDefaultString(Request["used_type_code"], "")); makeQueryDataValue(columnSql, hash, "@dopo_dimension", ComUtils.GetDefaultString(Request["dopo_dimension"], "")); makeQueryDataValue(columnSql, hash, "@label_type", ComUtils.GetDefaultString(Request["label_type"], "")); makeQueryDataValue(columnSql, hash, "@label_type_disp", ComUtils.GetDefaultString(Request["label_type_disp"], "")); makeQueryDataValue(columnSql, hash, "@airback_exist_flag", ComUtils.GetDefaultString(Request["airback_exist_flag"], "")); makeQueryDataValue(columnSql, hash, "@available_period", ComUtils.GetDefaultString(Request["available_period"], "")); makeQueryDataValue(columnSql, hash, "@actual_capacity", ComUtils.GetDefaultString(Request["actual_capacity"], "")); makeQueryDataValue(columnSql, hash, "@color_type", ComUtils.GetDefaultString(Request["color_type"], "")); makeQueryDataValue(columnSql, hash, "@remark", ComUtils.GetDefaultString(Request["remark"], "")); makeQueryDataValue(columnSql, hash, "@customer_item_number", ComUtils.GetDefaultString(Request["customer_item_number"], "")); makeQueryDataValue(columnSql, hash, "@customer_factory", ComUtils.GetDefaultString(Request["customer_factory"], "")); makeQueryDataValue(columnSql, hash, "@packing_weight", ComUtils.GetDefaultString(Request["packing_weight"], "")); makeQueryDataValue(columnSql, hash, "@can_weight", ComUtils.GetDefaultString(Request["can_weight"], "")); makeQueryDataValue(columnSql, hash, "@color_code", ComUtils.GetDefaultString(Request["color_code"], "")); makeQueryDataValue(columnSql, hash, "@material_spec", ComUtils.GetDefaultString(Request["material_spec"], "")); makeQueryDataValue(columnSql, hash, "@qr_color_code", ComUtils.GetDefaultString(Request["qr_color_code"], "")); makeQueryDataValue(columnSql, hash, "@qr_item_type", ComUtils.GetDefaultString(Request["qr_item_type"], "")); makeQueryDataValue(columnSql, hash, "@gravity", ComUtils.GetDefaultString(Request["gravity"], "")); makeQueryDataValue(columnSql, hash, "@toxic", ComUtils.GetDefaultString(Request["toxic"], "")); makeQueryDataValue(columnSql, hash, "@accident_contrast", ComUtils.GetDefaultString(Request["accident_contrast"], "")); makeQueryDataValue(columnSql, hash, "@restricted", ComUtils.GetDefaultString(Request["restricted"], "")); makeQueryDataValue(columnSql, hash, "@prohibited_handling", ComUtils.GetDefaultString(Request["prohibited_handling"], "")); makeQueryDataValue(columnSql, hash, "@hallucinant_flag", ComUtils.GetDefaultString(Request["hallucinant_flag"], "")); makeQueryDataValue(columnSql, hash, "@engineer_name", ComUtils.GetDefaultString(Request["engineer_name"], "")); makeQueryDataValue(columnSql, hash, "@un_number", ComUtils.GetDefaultString(Request["un_number"], "")); makeQueryDataValue(columnSql, hash, "@can_code", ComUtils.GetDefaultString(Request["can_code"], "")); makeQueryDataValue(columnSql, hash, "@web_viscosity_sec", ComUtils.GetDefaultString(Request["web_viscosity_sec"], "")); makeQueryDataValue(columnSql, hash, "@web_viscosity_20c", ComUtils.GetDefaultString(Request["web_viscosity_20c"], "")); makeQueryDataValue(columnSql, hash, "@web_undiluted_lot", ComUtils.GetDefaultString(Request["web_undiluted_lot"], "")); makeQueryDataValue(columnSql, hash, "@web_nv", ComUtils.GetDefaultString(Request["web_nv"], "")); makeQueryDataValue(columnSql, hash, "@web_lot_output", ComUtils.GetDefaultString(Request["web_lot_output"], "")); makeQueryDataValue(columnSql, hash, "@web_coloring_heat", ComUtils.GetDefaultString(Request["web_coloring_heat"], "")); makeQueryDataValue(columnSql, hash, "@web_grading", ComUtils.GetDefaultString(Request["web_grading"], "")); makeQueryDataValue(columnSql, hash, "@web_gloss", ComUtils.GetDefaultString(Request["web_gloss"], "")); makeQueryDataValue(columnSql, hash, "@web_dft", ComUtils.GetDefaultString(Request["web_dft"], "")); makeQueryDataValue(columnSql, hash, "@web_viscosity_standard", ComUtils.GetDefaultString(Request["web_viscosity_standard"], "")); makeQueryDataValue(columnSql, hash, "@web_viscosity_real", ComUtils.GetDefaultString(Request["web_viscosity_real"], "")); makeQueryDataValue(columnSql, hash, "@picture", ComUtils.GetDefaultString(Request["picture"], "")); makeQueryDataValue(columnSql, hash, "@signal", ComUtils.GetDefaultString(Request["signal"], "")); makeQueryDataValue(columnSql, hash, "@danger_expression", ComUtils.GetDefaultString(Request["danger_expression"], "")); makeQueryDataValue(columnSql, hash, "@precaution_prevention", ComUtils.GetDefaultString(Request["precaution_prevention"], "")); makeQueryDataValue(columnSql, hash, "@precaution_react", ComUtils.GetDefaultString(Request["precaution_react"], "")); makeQueryDataValue(columnSql, hash, "@precaution_storage", ComUtils.GetDefaultString(Request["precaution_storage"], "")); makeQueryDataValue(columnSql, hash, "@precaution_disuse", ComUtils.GetDefaultString(Request["precaution_disuse"], "")); makeQueryDataValue(columnSql, hash, "@mark_type", ComUtils.GetDefaultString(Request["mark_type"], "")); makeQueryDataValue(columnSql, hash, "@certification_no", ComUtils.GetDefaultString(Request["certification_no"], "")); makeQueryDataValue(columnSql, hash, "@certification_spec", ComUtils.GetDefaultString(Request["certification_spec"], "")); makeQueryDataValue(columnSql, hash, "@nrl_labeltype_company", ComUtils.GetDefaultString(Request["nrl_labeltype_company"], "")); makeQueryDataValue(columnSql, hash, "@nrl_labeltype_a", ComUtils.GetDefaultString(Request["nrl_labeltype_a"], "")); makeQueryDataValue(columnSql, hash, "@nrl_labeltype_b", ComUtils.GetDefaultString(Request["nrl_labeltype_b"], "")); makeQueryDataValue(columnSql, hash, "@nrl_labeltype_c", ComUtils.GetDefaultString(Request["nrl_labeltype_c"], "")); makeQueryDataValue(columnSql, hash, "@print_yn", "N"); //=====makeQueryDataValue(columnSql, hash, "@print_date", ""); //데이터 안넘김(인쇄할때 업데이트) makeQueryDataValue(columnSql, hash, "@regid", ComUtils.GetNotNullToString(Session["LOGIN_ID"])); makeQueryDataValue(columnSql, hash, "@regname", ComUtils.GetNotNullToString(Session["USER_NAME_KR"])); //=====makeQueryDataValue(columnSql, hash, "@regdate", ""); //데이터 안넘김(기본값이 getdate()) makeQueryDataValue(columnSql, hash, "@q_gubun", ComUtils.GetDefaultString(Request["q_gubun"], "")); makeQueryDataValue(columnSql, hash, "@q_code", ComUtils.GetDefaultString(Request["q_code"], "")); makeQueryDataValue(columnSql, hash, "@q_lang", ComUtils.GetDefaultString(Request["q_lang"], "")); makeQueryDataValue(columnSql, hash, "@q_factory", ComUtils.GetDefaultString(Request["q_factory"], "")); //최종쿼리생성 String query = string.Empty; query += "INSERT INTO GLMS_LABELINFO_TBL ( "; query += columnSql.ToString().Replace("@", ""); query += ") VALUES ( "; query += columnSql.ToString(); query += "); "; query += "SELECT SCOPE_IDENTITY() "; using (SqlConnection connection = new SqlConnection(ConfigurationSettings.AppSettings["DarwinPortal_ConnectionString"])) { connection.Open(); using (SqlCommand command = new SqlCommand(query, connection)) { foreach (DictionaryEntry pair in hash) { command.Parameters.AddWithValue(pair.Key.ToString(), pair.Value); } //resultSeq.Value = "" + command.ExecuteNonQuery(); resultSeq.Value = "" + command.ExecuteScalar(); } } }