private void button_GD_insert_gang_PS_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> fldVals = new List<string>();
DataSet ds = new DataSet();
// adding labels -->
fldNames.Clear();
fldNames.AddRange(new string[] {"GangID", "CustomerName", "PO", "Qty", "UP", "Material", "Size", "RequireQty", "PrintQty", "IssueQty", "PrintOnFaceFront", "PrintOnFaceBack", "NumberOfColorFront", "NumberOfColorBack", "SideGuideFront", "SideGuideBack", "UVCoatingFront", "UVCoatingBack" });
// <--
// adding table fields -->
fldVals.AddRange(new string[] { "gang_number", "cust_name", "cust_po_number", "(SELECT SUM(order_qty) FROM sales_vars WHERE sales_vars.cust_po_number = '"+dbc.SelectSingle("cust_po_number", "sales_vars", "id", dbc.SelectSingle("sales_vars_id", "graphics_vars_gang", "gang_number", ((Button)sender).Tag.ToString()))+"')", "up_size", "card_material", "sheet_size", "require_qty", "print_qty", "issue_qty", "PrintOnFaceFront", "PrintOnFaceBack", "NumberOfColorFront", "NumberOfColorBack", "SideGuideFront", "SideGuideBack", "UVCoatingFront", "UVCoatingBack" });
// <--
string query = " SELECT " + string.Join(", ", fldVals);
query += " FROM graphics_vars_gang ";
query += " JOIN sales_vars ON sales_vars.id = sales_vars_id ";
query += " WHERE gang_number = " + ((Button)sender).Tag.ToString();
ds = dbc.SelectMyDA(query);
fFunc.createXML_gang("Press Information Sheet", fldNames, ds);
}
