导出EXCEL功能优化

jhz

2022-06-07 99276f88601ad793b3094c4d00ecdf62ab7983bb

导出EXCEL功能优化

 APS.sln

@@ -31,80 +31,80 @@
        Release|x86 = Release|x86
    EndGlobalSection
    GlobalSection(ProjectConfigurationPlatforms) = postSolution
        {7C30E3C9-58B7-420A-AB92-0A5117B82DDA}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
        {7C30E3C9-58B7-420A-AB92-0A5117B82DDA}.Debug|Any CPU.Build.0 = Debug|Any CPU
        {7C30E3C9-58B7-420A-AB92-0A5117B82DDA}.Debug|Any CPU.ActiveCfg = Debug|x86
        {7C30E3C9-58B7-420A-AB92-0A5117B82DDA}.Debug|Any CPU.Build.0 = Debug|x86
        {7C30E3C9-58B7-420A-AB92-0A5117B82DDA}.Debug|x86.ActiveCfg = Debug|x86
        {7C30E3C9-58B7-420A-AB92-0A5117B82DDA}.Debug|x86.Build.0 = Debug|x86
        {7C30E3C9-58B7-420A-AB92-0A5117B82DDA}.Release|Any CPU.ActiveCfg = Release|Any CPU
        {7C30E3C9-58B7-420A-AB92-0A5117B82DDA}.Release|Any CPU.Build.0 = Release|Any CPU
        {7C30E3C9-58B7-420A-AB92-0A5117B82DDA}.Release|x86.ActiveCfg = Release|x86
        {7C30E3C9-58B7-420A-AB92-0A5117B82DDA}.Release|x86.Build.0 = Release|x86
        {5061B703-B7A6-4E82-A9AA-F73FD80520BF}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
        {5061B703-B7A6-4E82-A9AA-F73FD80520BF}.Debug|Any CPU.Build.0 = Debug|Any CPU
        {5061B703-B7A6-4E82-A9AA-F73FD80520BF}.Debug|Any CPU.ActiveCfg = Debug|x86
        {5061B703-B7A6-4E82-A9AA-F73FD80520BF}.Debug|Any CPU.Build.0 = Debug|x86
        {5061B703-B7A6-4E82-A9AA-F73FD80520BF}.Debug|x86.ActiveCfg = Debug|x86
        {5061B703-B7A6-4E82-A9AA-F73FD80520BF}.Debug|x86.Build.0 = Debug|x86
        {5061B703-B7A6-4E82-A9AA-F73FD80520BF}.Release|Any CPU.ActiveCfg = Release|Any CPU
        {5061B703-B7A6-4E82-A9AA-F73FD80520BF}.Release|Any CPU.Build.0 = Release|Any CPU
        {5061B703-B7A6-4E82-A9AA-F73FD80520BF}.Release|x86.ActiveCfg = Release|x86
        {5061B703-B7A6-4E82-A9AA-F73FD80520BF}.Release|x86.Build.0 = Release|x86
        {0844CD97-FFAB-445F-A473-1380387E9A12}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
        {0844CD97-FFAB-445F-A473-1380387E9A12}.Debug|Any CPU.Build.0 = Debug|Any CPU
        {0844CD97-FFAB-445F-A473-1380387E9A12}.Debug|Any CPU.ActiveCfg = Debug|x86
        {0844CD97-FFAB-445F-A473-1380387E9A12}.Debug|Any CPU.Build.0 = Debug|x86
        {0844CD97-FFAB-445F-A473-1380387E9A12}.Debug|x86.ActiveCfg = Debug|x86
        {0844CD97-FFAB-445F-A473-1380387E9A12}.Debug|x86.Build.0 = Debug|x86
        {0844CD97-FFAB-445F-A473-1380387E9A12}.Release|Any CPU.ActiveCfg = Release|Any CPU
        {0844CD97-FFAB-445F-A473-1380387E9A12}.Release|Any CPU.Build.0 = Release|Any CPU
        {0844CD97-FFAB-445F-A473-1380387E9A12}.Release|x86.ActiveCfg = Release|x86
        {0844CD97-FFAB-445F-A473-1380387E9A12}.Release|x86.Build.0 = Release|x86
        {96ACAC1A-9550-4071-B591-EB9330A107EA}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
        {96ACAC1A-9550-4071-B591-EB9330A107EA}.Debug|Any CPU.Build.0 = Debug|Any CPU
        {96ACAC1A-9550-4071-B591-EB9330A107EA}.Debug|Any CPU.ActiveCfg = Debug|x86
        {96ACAC1A-9550-4071-B591-EB9330A107EA}.Debug|Any CPU.Build.0 = Debug|x86
        {96ACAC1A-9550-4071-B591-EB9330A107EA}.Debug|x86.ActiveCfg = Debug|x86
        {96ACAC1A-9550-4071-B591-EB9330A107EA}.Debug|x86.Build.0 = Debug|x86
        {96ACAC1A-9550-4071-B591-EB9330A107EA}.Release|Any CPU.ActiveCfg = Release|Any CPU
        {96ACAC1A-9550-4071-B591-EB9330A107EA}.Release|Any CPU.Build.0 = Release|Any CPU
        {96ACAC1A-9550-4071-B591-EB9330A107EA}.Release|x86.ActiveCfg = Release|x86
        {96ACAC1A-9550-4071-B591-EB9330A107EA}.Release|x86.Build.0 = Release|x86
        {F85DEB10-D048-4377-92FD-35FC39C37BF8}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
        {F85DEB10-D048-4377-92FD-35FC39C37BF8}.Debug|Any CPU.Build.0 = Debug|Any CPU
        {F85DEB10-D048-4377-92FD-35FC39C37BF8}.Debug|Any CPU.ActiveCfg = Debug|x86
        {F85DEB10-D048-4377-92FD-35FC39C37BF8}.Debug|Any CPU.Build.0 = Debug|x86
        {F85DEB10-D048-4377-92FD-35FC39C37BF8}.Debug|x86.ActiveCfg = Debug|x86
        {F85DEB10-D048-4377-92FD-35FC39C37BF8}.Debug|x86.Build.0 = Debug|x86
        {F85DEB10-D048-4377-92FD-35FC39C37BF8}.Release|Any CPU.ActiveCfg = Release|Any CPU
        {F85DEB10-D048-4377-92FD-35FC39C37BF8}.Release|Any CPU.Build.0 = Release|Any CPU
        {F85DEB10-D048-4377-92FD-35FC39C37BF8}.Release|x86.ActiveCfg = Release|x86
        {F85DEB10-D048-4377-92FD-35FC39C37BF8}.Release|x86.Build.0 = Release|x86
        {C518F792-17CD-4894-99E5-C0EA4F59E0F3}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
        {C518F792-17CD-4894-99E5-C0EA4F59E0F3}.Debug|Any CPU.Build.0 = Debug|Any CPU
        {C518F792-17CD-4894-99E5-C0EA4F59E0F3}.Debug|Any CPU.ActiveCfg = Debug|x86
        {C518F792-17CD-4894-99E5-C0EA4F59E0F3}.Debug|Any CPU.Build.0 = Debug|x86
        {C518F792-17CD-4894-99E5-C0EA4F59E0F3}.Debug|x86.ActiveCfg = Debug|x86
        {C518F792-17CD-4894-99E5-C0EA4F59E0F3}.Debug|x86.Build.0 = Debug|x86
        {C518F792-17CD-4894-99E5-C0EA4F59E0F3}.Release|Any CPU.ActiveCfg = Release|Any CPU
        {C518F792-17CD-4894-99E5-C0EA4F59E0F3}.Release|Any CPU.Build.0 = Release|Any CPU
        {C518F792-17CD-4894-99E5-C0EA4F59E0F3}.Release|x86.ActiveCfg = Release|x86
        {C518F792-17CD-4894-99E5-C0EA4F59E0F3}.Release|x86.Build.0 = Release|x86
        {01CC53FF-CA8F-4A01-AB93-77F4C8A78902}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
        {01CC53FF-CA8F-4A01-AB93-77F4C8A78902}.Debug|Any CPU.Build.0 = Debug|Any CPU
        {01CC53FF-CA8F-4A01-AB93-77F4C8A78902}.Debug|Any CPU.ActiveCfg = Debug|x86
        {01CC53FF-CA8F-4A01-AB93-77F4C8A78902}.Debug|Any CPU.Build.0 = Debug|x86
        {01CC53FF-CA8F-4A01-AB93-77F4C8A78902}.Debug|x86.ActiveCfg = Debug|x86
        {01CC53FF-CA8F-4A01-AB93-77F4C8A78902}.Debug|x86.Build.0 = Debug|x86
        {01CC53FF-CA8F-4A01-AB93-77F4C8A78902}.Release|Any CPU.ActiveCfg = Release|Any CPU
        {01CC53FF-CA8F-4A01-AB93-77F4C8A78902}.Release|Any CPU.Build.0 = Release|Any CPU
        {01CC53FF-CA8F-4A01-AB93-77F4C8A78902}.Release|x86.ActiveCfg = Release|x86
        {01CC53FF-CA8F-4A01-AB93-77F4C8A78902}.Release|x86.Build.0 = Release|x86
        {E4E6C11E-7772-43A2-8107-25309DD5F315}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
        {E4E6C11E-7772-43A2-8107-25309DD5F315}.Debug|Any CPU.Build.0 = Debug|Any CPU
        {E4E6C11E-7772-43A2-8107-25309DD5F315}.Debug|Any CPU.ActiveCfg = Debug|x86
        {E4E6C11E-7772-43A2-8107-25309DD5F315}.Debug|Any CPU.Build.0 = Debug|x86
        {E4E6C11E-7772-43A2-8107-25309DD5F315}.Debug|x86.ActiveCfg = Debug|x86
        {E4E6C11E-7772-43A2-8107-25309DD5F315}.Debug|x86.Build.0 = Debug|x86
        {E4E6C11E-7772-43A2-8107-25309DD5F315}.Release|Any CPU.ActiveCfg = Release|Any CPU
        {E4E6C11E-7772-43A2-8107-25309DD5F315}.Release|Any CPU.Build.0 = Release|Any CPU
        {E4E6C11E-7772-43A2-8107-25309DD5F315}.Release|x86.ActiveCfg = Release|x86
        {E4E6C11E-7772-43A2-8107-25309DD5F315}.Release|x86.Build.0 = Release|x86
        {414AB82B-092C-4D4A-808C-220607E65E7D}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
        {414AB82B-092C-4D4A-808C-220607E65E7D}.Debug|Any CPU.Build.0 = Debug|Any CPU
        {414AB82B-092C-4D4A-808C-220607E65E7D}.Debug|Any CPU.ActiveCfg = Debug|x86
        {414AB82B-092C-4D4A-808C-220607E65E7D}.Debug|Any CPU.Build.0 = Debug|x86
        {414AB82B-092C-4D4A-808C-220607E65E7D}.Debug|x86.ActiveCfg = Debug|x86
        {414AB82B-092C-4D4A-808C-220607E65E7D}.Debug|x86.Build.0 = Debug|x86
        {414AB82B-092C-4D4A-808C-220607E65E7D}.Release|Any CPU.ActiveCfg = Release|Any CPU
        {414AB82B-092C-4D4A-808C-220607E65E7D}.Release|Any CPU.Build.0 = Release|Any CPU
        {414AB82B-092C-4D4A-808C-220607E65E7D}.Release|x86.ActiveCfg = Release|x86
        {414AB82B-092C-4D4A-808C-220607E65E7D}.Release|x86.Build.0 = Release|x86
        {0BF3D95A-4A7B-45FB-92FB-9A5BB374B750}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
        {0BF3D95A-4A7B-45FB-92FB-9A5BB374B750}.Debug|Any CPU.Build.0 = Debug|Any CPU
        {0BF3D95A-4A7B-45FB-92FB-9A5BB374B750}.Debug|Any CPU.ActiveCfg = Debug|x86
        {0BF3D95A-4A7B-45FB-92FB-9A5BB374B750}.Debug|Any CPU.Build.0 = Debug|x86
        {0BF3D95A-4A7B-45FB-92FB-9A5BB374B750}.Debug|x86.ActiveCfg = Debug|x86
        {0BF3D95A-4A7B-45FB-92FB-9A5BB374B750}.Debug|x86.Build.0 = Debug|x86
        {0BF3D95A-4A7B-45FB-92FB-9A5BB374B750}.Release|Any CPU.ActiveCfg = Release|Any CPU

 AccPayM/ÆäËûÄ£¿é/YF_PayMentShouldBillList.cs

@@ -453,7 +453,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 AccPayM/Ó¦¸¶¹ÜÀí/YF_PayMentBackBillList.cs

@@ -454,7 +454,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 AccPayM/Ó¦¸¶¹ÜÀí/YF_PayMentBeforeBillList.cs

@@ -453,7 +453,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 AccPayM/Ó¦¸¶¹ÜÀí/YF_PayMentBillList.cs

@@ -453,7 +453,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 AccPayM/Ó¦¸¶¹ÜÀí/YF_PayMentOtherBillList.cs

@@ -453,7 +453,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 AccRecM/ÆäËûÄ£¿é/YS_ReceiveShouldBillList.cs

@@ -434,7 +434,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 AccRecM/Ó¦ÊÕ¹ÜÀí/YS_ReceiveBackBillList.cs

@@ -453,7 +453,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 AccRecM/Ó¦ÊÕ¹ÜÀí/YS_ReceiveBeforeBillList.cs

@@ -453,7 +453,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 AccRecM/Ó¦ÊÕ¹ÜÀí/YS_ReceiveBillList.cs

@@ -454,7 +454,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 AccRecM/Ó¦ÊÕ¹ÜÀí/YS_ReceiveOtherBillList.cs

@@ -456,7 +456,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 AccRecM/±¨±í·ÖÎö/Xs_ShouldIncomeEntryReport.cs

@@ -210,7 +210,7 @@

        private void yc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
        #endregion


 BLL/BLL.csproj

@@ -61,6 +61,11 @@
      <SpecificVersion>False</SpecificVersion>
      <HintPath>..\DLL\DBUtility.dll</HintPath>
    </Reference>
    <Reference Include="Interop.Excel, Version=1.5.0.0, Culture=neutral, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <EmbedInteropTypes>True</EmbedInteropTypes>
      <HintPath>..\DLL\Interop.Excel.dll</HintPath>
    </Reference>
    <Reference Include="Interop.grdes6Lib">
      <HintPath>..\DLL\Interop.grdes6Lib.dll</HintPath>
      <EmbedInteropTypes>True</EmbedInteropTypes>

 BLL/¹«ÓÃÄ£¿é/Gy_DataInTmp.cs

@@ -131,7 +131,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }

        //

 BLL/¹«ÓÃÄ£¿é/Xt_SystemLog_K3.cs

@@ -417,7 +417,7 @@
        //引出EXCEL
        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
    }
}

 BLL/ϵͳ¹«ÓÃCLS/ClsPub_BLL.cs

@@ -6,6 +6,8 @@
using Model;
using System.Windows.Forms;
using System.Drawing;
using System.IO;
using System.Runtime.InteropServices;

namespace BLL
{
@@ -14,6 +16,7 @@
        //上查下查
        public static void UpBillShow(DataGridView ogrd, bool isUp, Form oMainFrm)
        {
            
            //string tSql;
            //string FrmCaption = "";
            //string FrmName = "";
@@ -900,5 +903,76 @@

        }

        //[DllImport("User32.dll", CharSet = CharSet.Auto)]
        //public static extern int GetWindowThreadProcessId(IntPtr hwnd, out int ID);
        public static void DataToExcel(string sText, DataGridView grdMain)
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.Filter = "Execl文件(*.xls)|*.xls";
            saveFileDialog.FilterIndex = 0;
            saveFileDialog.RestoreDirectory = true;
            saveFileDialog.CreatePrompt = true;
            saveFileDialog.Title = "数据视图导出EXCEL文件";
            saveFileDialog.FileName = sText;
            saveFileDialog.ShowDialog();
            if (saveFileDialog.FileName == "")
            {
                return;
            }
            System.IO.Stream myStream;
            myStream = saveFileDialog.OpenFile();
            System.IO.StreamWriter sw = new System.IO.StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
            string str = "";
            DateTime start = DateTime.Now;
            try
            {
                //写标题
                for (int i = 0; i < grdMain.ColumnCount; i++)
                {
                    if (i > 0)
                    {
                        str += "\t";
                    }
                    str += grdMain.Columns[i].HeaderText;
                }
                sw.WriteLine(str);

                //写内容
                for (int j = 0; j < grdMain.Rows.Count; j++)
                {
                    string tempStr = "";
                    for (int k = 0; k < grdMain.Columns.Count; k++)
                    {
                        if (k > 0)
                        {
                            tempStr += "\t";
                        }
                        if (grdMain.Rows[j].Cells[k].Value == null)
                        {
                            tempStr += string.Empty;
                        }
                        else
                        {
                            tempStr += grdMain.Rows[j].Cells[k].Value.ToString();
                        }
                    }
                    sw.WriteLine(tempStr);
                }
                sw.Close();
                myStream.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sw.Close();
                myStream.Close();
            }
            MessageBox.Show("将此工作表导出为excel共耗时：" + DateTime.Now.Subtract(start).TotalMilliseconds.ToString() + "毫秒");
        }


    }
}

 BaseSet/¹«ÓÃ×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/Gy_Material.cs

@@ -1224,7 +1224,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
       
    }

 BaseSet/¹«ÓÃ×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/Gy_MatePriceCusList.cs

@@ -555,7 +555,7 @@

        private void yl_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }

        public string sDlgWhere = "";  //外窗体递入

 BaseSet/¹«ÓÃ×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/Gy_MatePriceSupList.cs

@@ -557,7 +557,7 @@
        public string sDlgWhere = "";  //外窗体递入
        private void yl_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }

        private void btnOK_Click(object sender, EventArgs e)

 BaseSet/¹«ÓÃ×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/Gy_ProcPriceList.cs

@@ -553,7 +553,7 @@

        private void yl_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
       


 BaseSet/¹«ÓÃ×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/Gy_SourceShiftList.cs

@@ -477,7 +477,7 @@

        private void yl_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
       


 BaseSet/¹«ÓÃ×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/Gy_UserCustomerRelationList.cs

@@ -534,7 +534,7 @@

        private void yl_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 BaseSet/¹«ÓÃ×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/Gy_UserDeptRelationList.cs

@@ -533,7 +533,7 @@

        private void yl_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 BaseSet/¹«ÓÃ×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/Gy_UserGroupRelationList.cs

@@ -534,7 +534,7 @@

        private void yl_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 BaseSet/¹«ÓÃ×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/Gy_UserMaterRelationList.cs

@@ -533,7 +533,7 @@

        private void yl_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 BaseSet/¹«ÓÃ×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/Gy_UserStockRelationList.cs

@@ -534,7 +534,7 @@

        private void yl_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 BaseSet/¹«ÓÃ×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/Gy_WorkCenterSourceBillList.cs

@@ -416,7 +416,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }

        private void shc_Click(object sender, EventArgs e)

 BaseSet/¹«ÓÃ×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/OA_EmpMessageBillModList.cs

@@ -433,7 +433,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 BaseSet/¹«ÓÃ×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/OA_FieldToChangeList.cs

@@ -433,7 +433,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 BaseSet/¹«ÓÃ×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/Xt_UserRelationSupplierList.cs

@@ -543,7 +543,7 @@

        private void yl_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 BaseSet/¹«ÓÃ×ÊÁÏ/¹¤×Ê»ù´¡×ÊÁÏ/Gy_ErrWorkPrice.cs

@@ -535,7 +535,7 @@

        private void yc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 ProM/ÆäËûÄ£¿é/Cg_ContractBillList.cs

@@ -432,7 +432,77 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            DataToExcel(this.Text, grdMain);
        }

        //[DllImport("User32.dll", CharSet = CharSet.Auto)]
        //public static extern int GetWindowThreadProcessId(IntPtr hwnd, out int ID);
        public static void DataToExcel(string sText, DataGridView grdMain)
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.Filter = "Execl文件(*.xls)|*.xls";
            saveFileDialog.FilterIndex = 0;
            saveFileDialog.RestoreDirectory = true;
            saveFileDialog.CreatePrompt = true;
            saveFileDialog.Title = "数据视图导出EXCEL文件";
            saveFileDialog.FileName = sText;
            saveFileDialog.ShowDialog();
            if (saveFileDialog.FileName == "")
            {
                return;
            }
            System.IO.Stream myStream;
            myStream = saveFileDialog.OpenFile();
            System.IO.StreamWriter sw = new System.IO.StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
            string str = "";
            DateTime start = DateTime.Now;
            try
            {
                //写标题
                for (int i = 0; i < grdMain.ColumnCount; i++)
                {
                    if (i > 0)
                    {
                        str += "\t";
                    }
                    str += grdMain.Columns[i].HeaderText;
                }
                sw.WriteLine(str);

                //写内容
                for (int j = 0; j < grdMain.Rows.Count; j++)
                {
                    string tempStr = "";
                    for (int k = 0; k < grdMain.Columns.Count; k++)
                    {
                        if (k > 0)
                        {
                            tempStr += "\t";
                        }
                        if (grdMain.Rows[j].Cells[k].Value == null)
                        {
                            tempStr += string.Empty;
                        }
                        else
                        {
                            tempStr += grdMain.Rows[j].Cells[k].Value.ToString();
                        }
                    }
                    sw.WriteLine(tempStr);
                }
                sw.Close();
                myStream.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sw.Close();
                myStream.Close();
            }
            MessageBox.Show("将此工作表导出为excel共耗时：" + DateTime.Now.Subtract(start).TotalMilliseconds.ToString() + "毫秒");
        }



 ProM/ÆäËûÄ£¿é/Cg_PORequestPriceBillList.cs

@@ -433,7 +433,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 ProM/ÆäËûÄ£¿é/Cg_SupStatusChangeBillList.cs

@@ -635,7 +635,7 @@
        //引出EXCEL
        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
        private void å…³é—­ToolStripMenuItem_Click(object sender, EventArgs e)
        {

 ProM/ίÍâ¹ÜÀí/WW_EntrustOrderBillList.cs

@@ -78,7 +78,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
        //初始化网格
        private void initGrid()

 ProM/±¨±í·ÖÎö/Cg_SupStatusChangeBillReport.cs

@@ -281,7 +281,7 @@

        private void yl_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }

        //合计 new

 ProM/²É¹º¹ÜÀí/Cg_InvoiceBillList.cs

@@ -451,9 +451,78 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            DataToExcel(this.Text, grdMain);
        }

        //[DllImport("User32.dll", CharSet = CharSet.Auto)]
        //public static extern int GetWindowThreadProcessId(IntPtr hwnd, out int ID);
        public static void DataToExcel(string sText, DataGridView grdMain)
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.Filter = "Execl文件(*.xls)|*.xls";
            saveFileDialog.FilterIndex = 0;
            saveFileDialog.RestoreDirectory = true;
            saveFileDialog.CreatePrompt = true;
            saveFileDialog.Title = "数据视图导出EXCEL文件";
            saveFileDialog.FileName = sText;
            saveFileDialog.ShowDialog();
            if (saveFileDialog.FileName == "")
            {
                return;
            }
            System.IO.Stream myStream;
            myStream = saveFileDialog.OpenFile();
            System.IO.StreamWriter sw = new System.IO.StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
            string str = "";
            DateTime start = DateTime.Now;
            try
            {
                //写标题
                for (int i = 0; i < grdMain.ColumnCount; i++)
                {
                    if (i > 0)
                    {
                        str += "\t";
                    }
                    str += grdMain.Columns[i].HeaderText;
                }
                sw.WriteLine(str);

                //写内容
                for (int j = 0; j < grdMain.Rows.Count; j++)
                {
                    string tempStr = "";
                    for (int k = 0; k < grdMain.Columns.Count; k++)
                    {
                        if (k > 0)
                        {
                            tempStr += "\t";
                        }
                        if (grdMain.Rows[j].Cells[k].Value == null)
                        {
                            tempStr += string.Empty;
                        }
                        else
                        {
                            tempStr += grdMain.Rows[j].Cells[k].Value.ToString();
                        }
                    }
                    sw.WriteLine(tempStr);
                }
                sw.Close();
                myStream.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sw.Close();
                myStream.Close();
            }
            MessageBox.Show("将此工作表导出为excel共耗时：" + DateTime.Now.Subtract(start).TotalMilliseconds.ToString() + "毫秒");
        }

        #endregion


 ProM/²É¹º¹ÜÀí/Cg_InvoiceSpecBillList.cs

@@ -453,9 +453,78 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
             DataToExcel(this.Text, grdMain);
        }

        //[DllImport("User32.dll", CharSet = CharSet.Auto)]
        //public static extern int GetWindowThreadProcessId(IntPtr hwnd, out int ID);
        public static void DataToExcel(string sText, DataGridView grdMain)
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.Filter = "Execl文件(*.xls)|*.xls";
            saveFileDialog.FilterIndex = 0;
            saveFileDialog.RestoreDirectory = true;
            saveFileDialog.CreatePrompt = true;
            saveFileDialog.Title = "数据视图导出EXCEL文件";
            saveFileDialog.FileName = sText;
            saveFileDialog.ShowDialog();
            if (saveFileDialog.FileName == "")
            {
                return;
            }
            System.IO.Stream myStream;
            myStream = saveFileDialog.OpenFile();
            System.IO.StreamWriter sw = new System.IO.StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
            string str = "";
            DateTime start = DateTime.Now;
            try
            {
                //写标题
                for (int i = 0; i < grdMain.ColumnCount; i++)
                {
                    if (i > 0)
                    {
                        str += "\t";
                    }
                    str += grdMain.Columns[i].HeaderText;
                }
                sw.WriteLine(str);

                //写内容
                for (int j = 0; j < grdMain.Rows.Count; j++)
                {
                    string tempStr = "";
                    for (int k = 0; k < grdMain.Columns.Count; k++)
                    {
                        if (k > 0)
                        {
                            tempStr += "\t";
                        }
                        if (grdMain.Rows[j].Cells[k].Value == null)
                        {
                            tempStr += string.Empty;
                        }
                        else
                        {
                            tempStr += grdMain.Rows[j].Cells[k].Value.ToString();
                        }
                    }
                    sw.WriteLine(tempStr);
                }
                sw.Close();
                myStream.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sw.Close();
                myStream.Close();
            }
            MessageBox.Show("将此工作表导出为excel共耗时：" + DateTime.Now.Subtract(start).TotalMilliseconds.ToString() + "毫秒");
        }

        #endregion


 ProM/²É¹º¹ÜÀí/Cg_POInStockBackBillList.cs

@@ -433,9 +433,78 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
             DataToExcel(this.Text, grdMain);
        }

        //[DllImport("User32.dll", CharSet = CharSet.Auto)]
        //public static extern int GetWindowThreadProcessId(IntPtr hwnd, out int ID);
        public static void DataToExcel(string sText, DataGridView grdMain)
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.Filter = "Execl文件(*.xls)|*.xls";
            saveFileDialog.FilterIndex = 0;
            saveFileDialog.RestoreDirectory = true;
            saveFileDialog.CreatePrompt = true;
            saveFileDialog.Title = "数据视图导出EXCEL文件";
            saveFileDialog.FileName = sText;
            saveFileDialog.ShowDialog();
            if (saveFileDialog.FileName == "")
            {
                return;
            }
            System.IO.Stream myStream;
            myStream = saveFileDialog.OpenFile();
            System.IO.StreamWriter sw = new System.IO.StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
            string str = "";
            DateTime start = DateTime.Now;
            try
            {
                //写标题
                for (int i = 0; i < grdMain.ColumnCount; i++)
                {
                    if (i > 0)
                    {
                        str += "\t";
                    }
                    str += grdMain.Columns[i].HeaderText;
                }
                sw.WriteLine(str);

                //写内容
                for (int j = 0; j < grdMain.Rows.Count; j++)
                {
                    string tempStr = "";
                    for (int k = 0; k < grdMain.Columns.Count; k++)
                    {
                        if (k > 0)
                        {
                            tempStr += "\t";
                        }
                        if (grdMain.Rows[j].Cells[k].Value == null)
                        {
                            tempStr += string.Empty;
                        }
                        else
                        {
                            tempStr += grdMain.Rows[j].Cells[k].Value.ToString();
                        }
                    }
                    sw.WriteLine(tempStr);
                }
                sw.Close();
                myStream.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sw.Close();
                myStream.Close();
            }
            MessageBox.Show("将此工作表导出为excel共耗时：" + DateTime.Now.Subtract(start).TotalMilliseconds.ToString() + "毫秒");
        }

        #endregion


 ProM/²É¹º¹ÜÀí/Cg_POInStockBillList.cs

@@ -437,9 +437,78 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
             DataToExcel(this.Text, grdMain);
        }

        //[DllImport("User32.dll", CharSet = CharSet.Auto)]
        //public static extern int GetWindowThreadProcessId(IntPtr hwnd, out int ID);
        public static void DataToExcel(string sText, DataGridView grdMain)
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.Filter = "Execl文件(*.xls)|*.xls";
            saveFileDialog.FilterIndex = 0;
            saveFileDialog.RestoreDirectory = true;
            saveFileDialog.CreatePrompt = true;
            saveFileDialog.Title = "数据视图导出EXCEL文件";
            saveFileDialog.FileName = sText;
            saveFileDialog.ShowDialog();
            if (saveFileDialog.FileName == "")
            {
                return;
            }
            System.IO.Stream myStream;
            myStream = saveFileDialog.OpenFile();
            System.IO.StreamWriter sw = new System.IO.StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
            string str = "";
            DateTime start = DateTime.Now;
            try
            {
                //写标题
                for (int i = 0; i < grdMain.ColumnCount; i++)
                {
                    if (i > 0)
                    {
                        str += "\t";
                    }
                    str += grdMain.Columns[i].HeaderText;
                }
                sw.WriteLine(str);

                //写内容
                for (int j = 0; j < grdMain.Rows.Count; j++)
                {
                    string tempStr = "";
                    for (int k = 0; k < grdMain.Columns.Count; k++)
                    {
                        if (k > 0)
                        {
                            tempStr += "\t";
                        }
                        if (grdMain.Rows[j].Cells[k].Value == null)
                        {
                            tempStr += string.Empty;
                        }
                        else
                        {
                            tempStr += grdMain.Rows[j].Cells[k].Value.ToString();
                        }
                    }
                    sw.WriteLine(tempStr);
                }
                sw.Close();
                myStream.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sw.Close();
                myStream.Close();
            }
            MessageBox.Show("将此工作表导出为excel共耗时：" + DateTime.Now.Subtract(start).TotalMilliseconds.ToString() + "毫秒");
        }

        #endregion


 ProM/²É¹º¹ÜÀí/Cg_POOrderBillList.cs

@@ -78,8 +78,81 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }


        //[DllImport("User32.dll", CharSet = CharSet.Auto)]
        //public static extern int GetWindowThreadProcessId(IntPtr hwnd, out int ID);
        public static void DataToExcel(string sText, DataGridView grdMain)
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.Filter = "Execl文件(*.xls)|*.xls";
            saveFileDialog.FilterIndex = 0;
            saveFileDialog.RestoreDirectory = true;
            saveFileDialog.CreatePrompt = true;
            saveFileDialog.Title = "数据视图导出EXCEL文件";
            saveFileDialog.FileName = sText;
            saveFileDialog.ShowDialog();
            if (saveFileDialog.FileName == "")
            {
                return;
            }
            System.IO.Stream myStream;
            myStream = saveFileDialog.OpenFile();
            System.IO.StreamWriter sw = new System.IO.StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
            string str = "";
            DateTime start = DateTime.Now;
            try
            {
                //写标题
                for (int i = 0; i < grdMain.ColumnCount; i++)
                {
                    if (i > 0)
                    {
                        str += "\t";
                    }
                    str += grdMain.Columns[i].HeaderText;
                }
                sw.WriteLine(str);

                //写内容
                for (int j = 0; j < grdMain.Rows.Count; j++)
                {
                    string tempStr = "";
                    for (int k = 0; k < grdMain.Columns.Count; k++)
                    {
                        if (k > 0)
                        {
                            tempStr += "\t";
                        }
                        if (grdMain.Rows[j].Cells[k].Value == null)
                        {
                            tempStr += string.Empty;
                        }
                        else
                        {
                            tempStr += grdMain.Rows[j].Cells[k].Value.ToString();
                        }
                    }
                    sw.WriteLine(tempStr);
                }
                sw.Close();
                myStream.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sw.Close();
                myStream.Close();
            }
            MessageBox.Show("将此工作表导出为excel共耗时：" + DateTime.Now.Subtract(start).TotalMilliseconds.ToString() + "毫秒");
        }


        //初始化网格
        private void initGrid()
        {

 ProM/²É¹º¹ÜÀí/Cg_POOrderBillQuery.cs

@@ -532,10 +532,79 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }

        //[DllImport("User32.dll", CharSet = CharSet.Auto)]
        //public static extern int GetWindowThreadProcessId(IntPtr hwnd, out int ID);
        public static void DataToExcel(string sText, DataGridView grdMain)
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.Filter = "Execl文件(*.xls)|*.xls";
            saveFileDialog.FilterIndex = 0;
            saveFileDialog.RestoreDirectory = true;
            saveFileDialog.CreatePrompt = true;
            saveFileDialog.Title = "数据视图导出EXCEL文件";
            saveFileDialog.FileName = sText;
            saveFileDialog.ShowDialog();
            if (saveFileDialog.FileName == "")
            {
                return;
            }
            System.IO.Stream myStream;
            myStream = saveFileDialog.OpenFile();
            System.IO.StreamWriter sw = new System.IO.StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
            string str = "";
            DateTime start = DateTime.Now;
            try
            {
                //写标题
                for (int i = 0; i < grdMain.ColumnCount; i++)
                {
                    if (i > 0)
                    {
                        str += "\t";
                    }
                    str += grdMain.Columns[i].HeaderText;
                }
                sw.WriteLine(str);

                //写内容
                for (int j = 0; j < grdMain.Rows.Count; j++)
                {
                    string tempStr = "";
                    for (int k = 0; k < grdMain.Columns.Count; k++)
                    {
                        if (k > 0)
                        {
                            tempStr += "\t";
                        }
                        if (grdMain.Rows[j].Cells[k].Value == null)
                        {
                            tempStr += string.Empty;
                        }
                        else
                        {
                            tempStr += grdMain.Rows[j].Cells[k].Value.ToString();
                        }
                    }
                    sw.WriteLine(tempStr);
                }
                sw.Close();
                myStream.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sw.Close();
                myStream.Close();
            }
            MessageBox.Show("将此工作表导出为excel共耗时：" + DateTime.Now.Subtract(start).TotalMilliseconds.ToString() + "毫秒");
        }
 
        #endregion

        #region  //打印设置

 ProM/²É¹º¹ÜÀí/Cg_PORequestBillList.cs

@@ -7,7 +7,7 @@
using System.Windows.Forms;
using gregn6Lib;
using SQLHelper;
using DBUtility;
using DBUtility; 

namespace ProM
{
@@ -433,7 +433,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 SelM/Crm_ComplainVisitBillList.cs

@@ -635,7 +635,7 @@
        //引出EXCEL
        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
        private void å…³é—­ToolStripMenuItem_Click(object sender, EventArgs e)
        {

 SelM/ÆäËûÄ£¿é/Xs_ContractBillList.cs

@@ -432,7 +432,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 SelM/ÆäËûÄ£¿é/Xs_CusRatingChangeBillList.cs

@@ -635,7 +635,7 @@
        //引出EXCEL
        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
        private void å…³é—­ToolStripMenuItem_Click(object sender, EventArgs e)
        {

 SelM/ÆäËûÄ£¿é/Xs_CusStatusChangeBillList.cs

@@ -424,7 +424,7 @@
        //引出EXCEL
        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
    }
}

 SelM/ÆäËûÄ£¿é/Xs_MonthAvgValueBillList.cs

@@ -432,7 +432,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 SelM/ÆäËûÄ£¿é/Xs_SellPlanBillList.cs

@@ -434,7 +434,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 SelM/ÆäËûÄ£¿é/Xs_SellPlanExecuteBillList.cs

@@ -434,7 +434,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 SelM/±¨±í·ÖÎö/Xs_ContactBal2_K3.cs

@@ -212,7 +212,7 @@

        private void yc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
        #endregion


 SelM/±¨±í·ÖÎö/Xs_ContactBal_K3.cs

@@ -211,7 +211,7 @@

        private void yc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
        #endregion


 SelM/ÏúÊÛ¹ÜÀí/Xs_InvoiceBillList.cs

@@ -456,7 +456,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 SelM/ÏúÊÛ¹ÜÀí/Xs_InvoiceSpecBillList.cs

@@ -454,7 +454,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 SelM/ÏúÊÛ¹ÜÀí/Xs_SeOrderBillList.cs

@@ -455,7 +455,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 SelM/ÏúÊÛ¹ÜÀí/Xs_SeOrderBillQuery.cs

@@ -532,7 +532,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 SelM/ÏúÊÛ¹ÜÀí/Xs_SeOutStockBackBillList.cs

@@ -432,7 +432,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 SelM/ÏúÊÛ¹ÜÀí/Xs_SeOutStockBillList.cs

@@ -432,7 +432,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/ÔÆÌ챨±í/Sc_POLastPriceReport.cs

@@ -241,7 +241,7 @@
         
        private void yc_Click(object sender, EventArgs e)   //Lock
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
        #endregion


 WarM/ÔÆÌ챨±í/Sc_SellGainReportByCus.cs

@@ -264,7 +264,7 @@
         
        private void yc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
        #endregion


 WarM/ÔÆÌ챨±í/Sc_SellGainReportByCusMater.cs

@@ -262,7 +262,7 @@
         
        private void yc_Click(object sender, EventArgs e)   //Lock
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
        #endregion


 WarM/ÔÆÌ챨±í/Sc_SellLastPriceReport.cs

@@ -239,7 +239,7 @@
         
        private void yc_Click(object sender, EventArgs e)   //Lock
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
        #endregion


 WarM/ÔÆÌ챨±í/Sc_SellSumReportByCus.cs

@@ -258,11 +258,80 @@
         
        private void yc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
             DataToExcel(this.Text, grdMain);
        }
        #endregion

         
        //[DllImport("User32.dll", CharSet = CharSet.Auto)]
        //public static extern int GetWindowThreadProcessId(IntPtr hwnd, out int ID);
        public static void DataToExcel(string sText, DataGridView grdMain)
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.Filter = "Execl文件(*.xls)|*.xls";
            saveFileDialog.FilterIndex = 0;
            saveFileDialog.RestoreDirectory = true;
            saveFileDialog.CreatePrompt = true;
            saveFileDialog.Title = "数据视图导出EXCEL文件";
            saveFileDialog.FileName = sText;
            saveFileDialog.ShowDialog();
            if (saveFileDialog.FileName == "")
            {
                return;
            }
            System.IO.Stream myStream;
            myStream = saveFileDialog.OpenFile();
            System.IO.StreamWriter sw = new System.IO.StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
            string str = "";
            DateTime start = DateTime.Now;
            try
            {
                //写标题
                for (int i = 0; i < grdMain.ColumnCount; i++)
                {
                    if (i > 0)
                    {
                        str += "\t";
                    }
                    str += grdMain.Columns[i].HeaderText;
                }
                sw.WriteLine(str);

                //写内容
                for (int j = 0; j < grdMain.Rows.Count; j++)
                {
                    string tempStr = "";
                    for (int k = 0; k < grdMain.Columns.Count; k++)
                    {
                        if (k > 0)
                        {
                            tempStr += "\t";
                        }
                        if (grdMain.Rows[j].Cells[k].Value == null)
                        {
                            tempStr += string.Empty;
                        }
                        else
                        {
                            tempStr += grdMain.Rows[j].Cells[k].Value.ToString();
                        }
                    }
                    sw.WriteLine(tempStr);
                }
                sw.Close();
                myStream.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sw.Close();
                myStream.Close();
            }
            MessageBox.Show("将此工作表导出为excel共耗时：" + DateTime.Now.Subtract(start).TotalMilliseconds.ToString() + "毫秒");
        }


        private void timer2_Tick(object sender, EventArgs e)
        {

 WarM/ÔÆÌ챨±í/Sc_SellSumReportByCusMater.cs

@@ -260,7 +260,7 @@
         
        private void yc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
        #endregion


 WarM/ÔÆÌ챨±í/Sc_SellSumReportByMater.cs

@@ -273,7 +273,7 @@
        
        private void yc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
        #endregion


 WarM/²Ö¿â¹ÜÀí/Kf_CheckStockBillList.cs

@@ -454,7 +454,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }
        //关闭单据
        private void Sub_CloseBill()

 WarM/²Ö¿â¹ÜÀí/Kf_EntrustInBillList.cs

@@ -432,7 +432,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/²Ö¿â¹ÜÀí/Kf_EntrustOutBillList.cs

@@ -432,7 +432,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/²Ö¿â¹ÜÀí/Kf_MateOutBillList.cs

@@ -454,7 +454,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/²Ö¿â¹ÜÀí/Kf_MateOutMaintainBackBillList.cs

@@ -454,7 +454,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/²Ö¿â¹ÜÀí/Kf_MateOutMaintainBillList.cs

@@ -454,7 +454,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/²Ö¿â¹ÜÀí/Kf_MoveStockBillList.cs

@@ -453,7 +453,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/²Ö¿â¹ÜÀí/Kf_MoveStockBillQuery.cs

@@ -710,7 +710,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/²Ö¿â¹ÜÀí/Kf_OtherInBillList.cs

@@ -454,7 +454,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/²Ö¿â¹ÜÀí/Kf_OtherOutBillList.cs

@@ -453,7 +453,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/²Ö¿â¹ÜÀí/Kf_POStockInBillList.cs

@@ -460,7 +460,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/²Ö¿â¹ÜÀí/Kf_POStockInBillQuery.cs

@@ -705,7 +705,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/²Ö¿â¹ÜÀí/Kf_ProductInBillList.cs

@@ -453,7 +453,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/²Ö¿â¹ÜÀí/Kf_SellOutBillList.cs

@@ -461,7 +461,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/²Ö¿â¹ÜÀí/Kf_SellOutBillQuery.cs

@@ -741,7 +741,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/ÆäËûÄ£¿é/Kf_EntrustProcInBillList.cs

@@ -432,7 +432,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/ÆäËûÄ£¿é/Kf_EntrustProcOutBillList.cs

@@ -432,7 +432,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/ÆäËûÄ£¿é/Kf_InceptEntInBillList.cs

@@ -432,7 +432,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/ÆäËûÄ£¿é/Kf_InceptEntOutBillList.cs

@@ -433,7 +433,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/ÆäËûÄ£¿é/Kf_MateOutRequestBillList.cs

@@ -432,7 +432,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/´æ»õºËËã/Kf_POStockInBillList_Sec.cs

@@ -529,7 +529,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/´æ»õºËËã/Kf_POStockInBillQuery_Sec.cs

@@ -591,7 +591,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/´æ»õºËËã/Kf_SellOutBillList_Sec.cs

@@ -574,7 +574,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/´æ»õºËËã/Kf_SellOutBillQuery_Sec.cs

@@ -591,7 +591,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/±¨±í·ÖÎö/KF_ICInventoryByMaterList.cs

@@ -418,7 +418,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/±¨±í·ÖÎö/KF_ICInventoryList.cs

@@ -434,7 +434,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }



 WarM/±¨±í·ÖÎö/Kf_MateOutInBookReport.cs

@@ -224,7 +224,7 @@
        
        private void yc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);//
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);//
        }
        #endregion


 WarM/±¨±í·ÖÎö/Kf_MateOutInEntryReport.cs

@@ -230,7 +230,7 @@
        
        private void yc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);//
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);//
        }
        #endregion


 WarM/ÆÚ³õ½á´æ/Kf_ICInvBal.cs

@@ -399,7 +399,7 @@

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            BLL.ClsPub_BLL.DataToExcel(this.Text, grdMain);
        }

        private void grdMain_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)