sms_goodschk.cs

来自「库存管理系统,对企业仓库的产品进行管理,使用C#语句 .net 平台开发」· CS 代码 · 共 86 行

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;

namespace FORU_SMS_
{
    public partial class SMS_GoodsChk : Form
    {
        BaseClass.DataConn Dconn = new FORU_SMS_.BaseClass.DataConn();
        BaseClass.DataClass Dclass = new FORU_SMS_.BaseClass.DataClass();
        SqlDataAdapter adpter = new SqlDataAdapter();
        DataSet ds;
        public SMS_GoodsChk()
        {
            InitializeComponent();
        }

        private void SMS_GoodsChk_Load(object sender, EventArgs e)
        {
            dGridView.Controls.Add(hScrollBar1);
        }

        private void toolStripButton2_Click(object sender, EventArgs e)
        {
            ds = Dclass.GetDataSet("select * from V_Check", "V_Check");
            dGridView.DataSource = ds.Tables[0];
        }

        private void toolStripButton3_Click(object sender, EventArgs e)
        {
            ds = Dclass.GetDataSet("select * from V_Check", "V_Check");
            CrystalReport.SMS_GoodsReport Greport = new FORU_SMS_.CrystalReport.SMS_GoodsReport(ds.Tables[0]);
            Greport.Show();

            //SqlCommand sqlcom = new SqlCommand("select * from V_Check", Dconn.OpenConn());
            //adpter = new SqlDataAdapter();
            //adpter.SelectCommand = sqlcom;
            //ds = new DataSet();
            //adpter.Fill(ds);
            //CrystalReport.SMS_GoodsReport Greport = new FORU_SMS_.CrystalReport.SMS_GoodsReport(ds.Tables[0]);
            //Greport.Show();
        }

        private void toolStripButton4_Click(object sender, EventArgs e)
        {
            this.saveFileDialog1.Filter = "Microsoft Office Excel 工作簿(*.xls)|*.xls";
            this.saveFileDialog1.Title = "导出数据";
            this.saveFileDialog1.ShowDialog();
            int j;
            ds = Dclass.GetDataSet("select * from V_Check", "V_Check");
            if (saveFileDialog1.FileName != "")
            {
                StreamWriter strWriter = System.IO.File.CreateText(this.saveFileDialog1.FileName);
                strWriter.Write("<table border='1'>");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    strWriter.Write("<tr>");
                    for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
                    {
                        strWriter.Write("<td>");
                        strWriter.Write(ds.Tables[0].Columns[i].ToString());
                    }
                    for (j = 0; j < ds.Tables[0].Rows.Count; j++)
                    {
                        strWriter.Write("<tr>");
                        for (int k = 0; k < ds.Tables[0].Columns.Count; k++)
                        {
                            strWriter.Write("<td>");
                            strWriter.Write(ds.Tables[0].Rows[j][k].ToString());
                        }
                    }

                }
                strWriter.Close();
                MessageBox.Show("成功导出数据！");
            }
        }

    }
}