Exemple #1
0
        void t_btn2_Click(object sender, EventArgs e)
        {
            ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text);
            FormFunctions fFunc = new FormFunctions(user_id_lbl.Text, user_hash_lbl.Text);
            List<string> fldLabels = new List<string>();
            DataSet ds = new DataSet();
            fldLabels.AddRange(new string[] { "Printing", "PrintingType", "MagneticTape", "MagneticTapeType", "ColLay", "ColLayType", "HydraulicPress", "HydraulicPressType", "SheetCut", "SheetCutType", "DieCut", "DieCutType", "Personalization", "PersonalizationType" });

            string query = " SELECT " + string.Join(", ", fldLabels);
            query += " FROM graphics_vars_gang ";
            query += " WHERE gang_number = " + ((Button)sender).Tag.ToString();

            ds = dbc.SelectMyDA(query);
            fFunc.createXML_gang_mid("Mid Production Instruction Sheet", fldLabels, ds);
        }