示例#1
0
        /// <summary>
        /// Create an Excel file, and write it to a file for Leverantor data.
        /// </summary>

        //KD Changes
        private void CreateExcelforLeverantor()
        {
            try
            {
                //KD Change
                DataSet ds          = GetSupplierForBonusSetAmount();
                string  sSupplier   = string.Empty;
                DataSet dsSupplier  = new DataSet();
                string  sColumnName = string.Empty;
                for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
                {
                    //if (sSupplier != ds.Tables[0].Rows[i]["SupplierName"].ToString())
                    //KD Change
                    if (!sSupplier.Equals(ds.Tables[0].Rows[i]["SupplierName"].ToString(), StringComparison.InvariantCultureIgnoreCase))
                    {
                        sColumnName = ds.Tables[0].Rows[i]["SupplierName"].ToString();
                        dsSupplier.Tables.Add(sColumnName);

                        dsSupplier.Tables[sColumnName].Columns.Add(new DataColumn(ds.Tables[0].Columns[0].ColumnName, ds.Tables[0].Columns[0].DataType));
                        //dsSupplier.Tables[sColumnName].Columns.Add(new DataColumn(ds.Tables[0].Columns[1].ColumnName, ds.Tables[0].Columns[1].DataType));
                        dsSupplier.Tables[sColumnName].Columns.Add(new DataColumn(ds.Tables[0].Columns[2].ColumnName, ds.Tables[0].Columns[2].DataType));
                        dsSupplier.Tables[sColumnName].Columns.Add(new DataColumn(ds.Tables[0].Columns[3].ColumnName, ds.Tables[0].Columns[3].DataType));
                        dsSupplier.Tables[sColumnName].Columns.Add(new DataColumn(ds.Tables[0].Columns[4].ColumnName, ds.Tables[0].Columns[4].DataType));
                        dsSupplier.Tables[sColumnName].Columns.Add(new DataColumn(ds.Tables[0].Columns[5].ColumnName, ds.Tables[0].Columns[5].DataType));
                        dsSupplier.Tables[sColumnName].Columns.Add(new DataColumn(ds.Tables[0].Columns[6].ColumnName, ds.Tables[0].Columns[6].DataType));
                    }

                    DataRow newRow = dsSupplier.Tables[sColumnName].NewRow();
                    newRow[0] = ds.Tables[0].Rows[i][0];
                    //newRow[1] = ds.Tables[0].Rows[i]["SupplierName"].ToString();
                    newRow[1] = ds.Tables[0].Rows[i][2];
                    newRow[2] = ds.Tables[0].Rows[i][3];
                    newRow[3] = ds.Tables[0].Rows[i][4];
                    newRow[4] = ds.Tables[0].Rows[i][5];
                    newRow[5] = ds.Tables[0].Rows[i][6];

                    dsSupplier.Tables[ds.Tables[0].Rows[i]["SupplierName"].ToString()].Rows.Add(newRow);

                    sSupplier = ds.Tables[0].Rows[i]["SupplierName"].ToString();
                }

                string documentPath = ConfigurationManager.AppSettings["ReportDir"];
                string filename     = "StatisticsBonusgroupsBySupplier" + ".xlsx";
                CreateExcelFile2.CreateExcelDocument(dsSupplier, documentPath + filename);
                MessageBox.Show("Excel created successfully.");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
示例#2
0
        /// <summary>
        /// Create an Excel file, and write it to a file for Medlemsnamn data.
        /// </summary>

        //KD Changes
        private void CreateExcelforMedlemsnamn()
        {
            try
            {
                //KD Change
                DataSet ds = GetMemberForBonusSetAmount();

                //Task 202: Select all data for all year

                #region Select all data for all year For Task 202

                try
                {
                    while (false)
                    {
                        bool   isFileGenerated = false;
                        string filenameCSV     = "StatisticsBonusgroupsByMember_All";
                        string fileSavedPath   = WriteCSVFileSourcedFromDB(filenameCSV, ds, out isFileGenerated);

                        if (!string.IsNullOrEmpty(fileSavedPath))
                        {
                            MessageBox.Show("CSV Generated Successfully");
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error for CSV: " + ex);
                }

                #endregion

                #region the existing running code hide for Task 202: Select all data for all year

                //while (false)   //Task 202: Select all data for all year, extra while loop added
                {
                    string  sSupplier   = string.Empty;
                    DataSet dsSupplier  = new DataSet();
                    string  sColumnName = string.Empty;
                    for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
                    {
                        //if (sSupplier != ds.Tables[0].Rows[i]["MemberName"].ToString())
                        if (!sSupplier.Equals(ds.Tables[0].Rows[i]["MemberName"].ToString(), StringComparison.InvariantCultureIgnoreCase))
                        {
                            sColumnName = ds.Tables[0].Rows[i]["MemberName"].ToString();
                            dsSupplier.Tables.Add(sColumnName);

                            dsSupplier.Tables[sColumnName].Columns.Add(new DataColumn("Leverantörsnummer", ds.Tables[0].Columns[0].DataType));
                            //dsSupplier.Tables[sColumnName].Columns.Add(new DataColumn(ds.Tables[0].Columns[1].ColumnName, ds.Tables[0].Columns[1].DataType));
                            dsSupplier.Tables[sColumnName].Columns.Add(new DataColumn("Leverantörsnamn", ds.Tables[0].Columns[2].DataType));
                            dsSupplier.Tables[sColumnName].Columns.Add(new DataColumn("Startdatum", ds.Tables[0].Columns[3].DataType));
                            dsSupplier.Tables[sColumnName].Columns.Add(new DataColumn("Slutdatum", ds.Tables[0].Columns[4].DataType));
                            dsSupplier.Tables[sColumnName].Columns.Add(new DataColumn("Bonusgrupp namn", ds.Tables[0].Columns[5].DataType));


                            dsSupplier.Tables[sColumnName].Columns.Add(new DataColumn("Bonusgrupp belopp", ds.Tables[0].Columns[6].DataType));
                        }

                        DataRow newRow = dsSupplier.Tables[sColumnName].NewRow();
                        newRow[0] = ds.Tables[0].Rows[i][0];
                        //newRow[1] = ds.Tables[0].Rows[i]["MemberName"];
                        newRow[1] = ds.Tables[0].Rows[i][2];
                        newRow[2] = ds.Tables[0].Rows[i][3];
                        newRow[3] = ds.Tables[0].Rows[i][4];
                        newRow[4] = ds.Tables[0].Rows[i][5];
                        newRow[5] = ds.Tables[0].Rows[i][6];

                        dsSupplier.Tables[ds.Tables[0].Rows[i]["MemberName"].ToString()].Rows.Add(newRow);

                        sSupplier = ds.Tables[0].Rows[i]["MemberName"].ToString();
                    }

                    string documentPath = ConfigurationManager.AppSettings["ReportDir"];

                    //Task 202: Select all data for all year
                    string filename = "StatisticsBonusgroupsByMember" + ".xlsx";
                    //string filename = "StatisticsBonusgroupsByMember" + ".csv";

                    bool status = CreateExcelFile2.CreateExcelDocument(dsSupplier, documentPath + filename);
                    MessageBox.Show("Excel created successfully.\n" + status);
                }
                #endregion
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }