Exemple #1
0
 public static void ExportDataGridViewToTSV(DataTable DGV_Data, string strFileName)
 {
     try
     {
         string     str     = "";
         string     caption = "";
         string     s       = "";
         FileStream stream  = File.Open(strFileName, FileMode.Create, FileAccess.Write);
         for (int i = 0; i < DGV_Data.Rows.Count; i++)
         {
             byte[] bytes;
             for (int j = 0; j < DGV_Data.Columns.Count; j++)
             {
                 caption = DGV_Data.Columns[j].Caption;
                 if (caption.ToLower().IndexOf("date") >= 0)
                 {
                     str = ClsSystem.gnvl(DGV_Data.Rows[i].ItemArray[j], "");
                     if (str != "")
                     {
                         str = Convert.ToDateTime(str).ToString("yyyy-MM-dd");
                     }
                 }
                 else if ((caption.ToLower().IndexOf("quantity") >= 0) || (caption.IndexOf("amount") >= 0))
                 {
                     str = Convert.ToDecimal(ClsSystem.gnvl(DGV_Data.Rows[i].ItemArray[j], "0")).ToString("0.000");
                 }
                 else
                 {
                     str = ClsSystem.gnvl(DGV_Data.Rows[i].ItemArray[j], "");
                 }
                 if (j == 0)
                 {
                     s = str;
                 }
                 else
                 {
                     s = s + "\t" + str;
                 }
             }
             if (i == (DGV_Data.Rows.Count - 1))
             {
                 bytes = Encoding.UTF8.GetBytes(s);
             }
             else
             {
                 bytes = Encoding.UTF8.GetBytes(s + "\r\n");
             }
             stream.Write(bytes, 0, bytes.Length);
         }
         stream.Close();
     }
     catch (Exception exception)
     {
         MessageBox.Show(exception.ToString());
     }
 }
Exemple #2
0
        public static void ExportDataGridViewToExcel(DataGridView dataGridview1)
        {
            SaveFileDialog dialog = new SaveFileDialog {
                Filter           = "Execl   files   (*.xls)|*.xls",
                FilterIndex      = 0,
                RestoreDirectory = true,
                CreatePrompt     = true,
                Title            = "导出Excel文件到"
            };

            dialog.ShowDialog();
            Stream       stream = dialog.OpenFile();
            StreamWriter writer = new StreamWriter(stream, Encoding.GetEncoding("gb2312"));

            try
            {
                for (int i = 0; i < dataGridview1.Rows.Count; i++)
                {
                    string str = "";
                    for (int j = 0; j < dataGridview1.Columns.Count; j++)
                    {
                        if (j > 0)
                        {
                            str = str + "\t";
                        }
                        str = str + ClsSystem.gnvl(dataGridview1.Rows[i].Cells[j].Value, "");
                    }
                    writer.WriteLine(str);
                }
                writer.Close();
                stream.Close();
            }
            catch (Exception exception)
            {
                MessageBox.Show(exception.ToString());
            }
            finally
            {
                writer.Close();
                stream.Close();
            }
        }
Exemple #3
0
 private void cb_ok_Click(object sender, EventArgs e)
 {
     try
     {
         ClsXML.creatXML("StockSet.xml", "ServerSet");
         ClsXML.removeAllElement("StockSet.xml");
         DataSet ds = new DataSet();
         ds.Tables.Add();
         ds.Tables[0].Clear();
         ds.Tables[0].Columns.Add("Server");
         ds.Tables[0].Columns.Add("Database");
         ds.Tables[0].Columns.Add("User");
         ds.Tables[0].Columns.Add("Password");
         ds.Tables[0].Columns.Add("ItemMaster");
         ds.Tables[0].Columns.Add("Customer");
         ds.Tables[0].Columns.Add("InvStock");
         ds.Tables[0].Columns.Add("InvRK");
         ds.Tables[0].Columns.Add("InvCK");
         ds.Tables[0].Columns.Add("InvCKMonth");
         ds.Tables[0].Columns.Add("HKVendor");
         ds.Tables[0].Columns.Add("HKCustomer");
         ds.Tables[0].Rows.Add(new object[0]);
         ds.Tables[0].Rows[0]["Server"]     = ClsSystem.gnvl(this.textBoxServer.Text, "");
         ds.Tables[0].Rows[0]["Database"]   = ClsSystem.gnvl(this.textDatabase.Text, "");
         ds.Tables[0].Rows[0]["User"]       = ClsSystem.gnvl(this.textUser.Text, "");
         ds.Tables[0].Rows[0]["Password"]   = ClsSystem.gnvl(this.textPassword.Text, "");
         ds.Tables[0].Rows[0]["ItemMaster"] = ClsSystem.gnvl(this.TItemMaster.Text, "");
         ds.Tables[0].Rows[0]["Customer"]   = ClsSystem.gnvl(this.TCustomer.Text, "");
         ds.Tables[0].Rows[0]["InvStock"]   = ClsSystem.gnvl(this.TInvStock.Text, "");
         ds.Tables[0].Rows[0]["InvRK"]      = ClsSystem.gnvl(this.TInvRK.Text, "");
         ds.Tables[0].Rows[0]["InvCK"]      = ClsSystem.gnvl(this.TInvCK.Text, "");
         ds.Tables[0].Rows[0]["InvCKMonth"] = ClsSystem.gnvl(this.TInvCKMonth.Text, "");
         ds.Tables[0].Rows[0]["HKVendor"]   = ClsSystem.gnvl(this.THKVendor.Text, "");
         ds.Tables[0].Rows[0]["HKCustomer"] = ClsSystem.gnvl(this.THKCustomer.Text, "");
         ClsXML.addElement("StockSet.xml", ds);
         MessageBox.Show("保存成功!", "", MessageBoxButtons.OK);
     }
     catch (Exception exception)
     {
         MessageBox.Show(exception.Message.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Hand);
     }
 }