报表功能实现

技术2022-05-11 52

<% @ Page Language="C#" AutoEventWireup="true" CodeFile="CaiXiaoCunSouJia.aspx.cs" Inherits="InterFace_Reports_CaiXiaoCunSouJia" ValidateRequest="false" %> <! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" > < html xmlns ="http://www.w3.org/1999/xhtml" > < head runat ="server" > < title > 主要产品产、销、存、售价情况信息页面 </ title > < script type ="text/javascript" src ="../../js/popcalendar.js" ></ script > < link href ="../../css/style.css" rel ="stylesheet" type ="text/css" /> </ head > < body > < form id ="formKeHuXinXi" runat ="server" > < div > < table > < tr > < td > < asp:Label ID ="LabelStatus" runat ="server" Font-Size ="10pt" Text ="当前状态:" ></ asp:Label ></ td > < td > < asp:Menu ID ="MenuCaidan" runat ="server" BackColor ="#FFFFC0" DynamicHorizontalOffset ="2" Font-Names ="Verdana" Font-Size ="0.8em" ForeColor ="#990000" OnMenuItemClick ="MenuCaidan_MenuItemClick" Orientation ="Horizontal" StaticSubMenuIndent ="10px" > < StaticMenuItemStyle Font-Size ="10pt" HorizontalPadding ="5px" VerticalPadding ="2px" /> < DynamicHoverStyle BackColor ="#990000" ForeColor ="White" /> < DynamicMenuStyle BackColor ="#FFFBD6" /> < StaticSelectedStyle BackColor ="Gold" /> < DynamicSelectedStyle BackColor ="#FFCC66" /> < DynamicMenuItemStyle HorizontalPadding ="5px" VerticalPadding ="2px" /> < Items > < asp:MenuItem Text ="报表导航" Value ="报表导航" ></ asp:MenuItem > < asp:MenuItem Selected ="True" Text ="报表基本信息栏" Value ="报表基本信息栏" ></ asp:MenuItem > < asp:MenuItem Text ="报表详细信息" Value ="报表详细信息" ></ asp:MenuItem > < asp:MenuItem Text ="添加报表基本信息" Value ="添加报表基本信息" ></ asp:MenuItem > < asp:MenuItem Text ="编辑报表基本信息" Value ="编辑报表基本信息" ></ asp:MenuItem > </ Items > < StaticItemTemplate > <% # Eval("Text") %> </ StaticItemTemplate > < StaticHoverStyle BackColor ="#FFC0C0" Font-Overline ="False" Font-Underline ="True" ForeColor ="White" /> </ asp:Menu > </ td > </ tr > </ table > < table style ="border-top-width: 0px" > < tr valign ="top" > < td style ="height: 7px" > < img alt ="图象" height ="5" src ="../../Images/funcLine.JPG" width ="933" /></ td > </ tr > </ table > < asp:MultiView ID ="MultiViewXinXiGuanLi" runat ="server" ActiveViewIndex ="0" > < asp:View ID ="ViewXinXiLan" runat ="server" > < table > < tr > < td > < table > < tr > < td > < asp:Image ID ="ImageShouYe" runat ="server" ImageUrl ="~/DatabaseImg/100.jpg" /></ td > </ tr > </ table > </ td > < td > < table > < tr > < td style ="width: 99px" > 选择类别名称 </ td > < td > 条件 </ td > < td > 输入要查询的条件值 </ td > </ tr > < tr > < td style ="width: 99px" > < asp:DropDownList ID ="DropDownListLeiBeiOne" runat ="server" Width ="100px" > </ asp:DropDownList ></ td > < td > < asp:DropDownList ID ="DropDownListTiaoJianOne" runat ="server" Width ="80px" > </ asp:DropDownList ></ td > < td > < asp:TextBox ID ="TextBoxOne" runat ="server" class ="smallInput" ></ asp:TextBox ></ td > </ tr > < tr > < td style ="width: 99px" > < asp:DropDownList ID ="DropDownListLeiBeiTwo" runat ="server" Width ="100px" > </ asp:DropDownList ></ td > < td > < asp:DropDownList ID ="DropDownListTiaoJianTwo" runat ="server" Width ="80px" > </ asp:DropDownList ></ td > < td > < asp:TextBox ID ="TextBoxTwo" runat ="server" class ="smallInput" ></ asp:TextBox ></ td > </ tr > < tr > < td style ="width: 99px" > < asp:DropDownList ID ="DropDownListLeiBeiThree" runat ="server" Width ="100px" > </ asp:DropDownList ></ td > < td > < asp:DropDownList ID ="DropDownListTiaoJianThree" runat ="server" Width ="80px" > </ asp:DropDownList ></ td > < td > < asp:TextBox ID ="TextBoxThree" runat ="server" class ="smallInput" ></ asp:TextBox ></ td > </ tr > < tr > < td style ="width: 99px" > < asp:DropDownList ID ="DropDownListLeiBeiFour" runat ="server" Width ="100px" > </ asp:DropDownList ></ td > < td > < asp:DropDownList ID ="DropDownListTiaoJianFour" runat ="server" Width ="80px" > </ asp:DropDownList ></ td > < td > < asp:TextBox ID ="TextBoxFour" runat ="server" class ="smallInput" ></ asp:TextBox ></ td > </ tr > < tr > < td style ="width: 99px" > < font color ="blue" > < asp:Label ID ="Labelchaxunfangshi" runat ="server" Text ="查询排序方式：" ></ asp:Label ></ font ></ td > < td > < asp:DropDownList ID ="DropDownListPaiXuFangShi" runat ="server" BackColor ="Transparent" ForeColor ="Blue" Width ="80px" > </ asp:DropDownList ></ td > < td > </ td > </ tr > </ table > </ td > < td style ="height: 176px" > < table > < tr > < td style ="height: 50px" > < asp:Button ID ="ButtonTiJianChaXun" runat ="server" Height ="50px" OnClick ="ButtonTiJianChaXun_Click" Text ="条件查询" /></ td > </ tr > </ table > </ td > </ tr > </ table > < img alt ="图象" height ="5" src ="../../Images/funcLine.JPG" width ="933" />< br /> < table > < tr > < td > < asp:Button ID ="ButtonTianJia" runat ="server" Font-Size ="12pt" OnClick ="ButtonTianJia_Click" Text ="添加" /> < asp:Button ID ="ButtonBianJi" runat ="server" Font-Size ="12pt" OnClick ="ButtonBianJi_Click" Text ="编辑" /> < asp:Button ID ="ButtonShanChu" runat ="server" Font-Size ="12pt" OnClick ="ButtonShanChu_Click" OnClientClick ="return confirm('确认要删除吗？');" Text ="删除" /> < asp:Button ID ="ButtonChaYue" runat ="server" Font-Size ="12pt" OnClick ="ButtonChaYue_Click" Text ="报表详细信息" /> < asp:Button ID ="ButtonChaKan" runat ="server" Font-Size ="12pt" OnClick ="ButtonChaKan_Click" Text ="查看报表详细信息" /> </ td > </ tr > </ table > < asp:GridView ID ="GridViewXinXiLan" runat ="server" AllowPaging ="True" AutoGenerateColumns ="False" CellPadding ="4" DataKeyNames ="SN" ForeColor ="#333333" GridLines ="None" OnPageIndexChanging ="GridViewXinXiLan_PageIndexChanging" OnSelectedIndexChanged ="GridViewXinXiLan_SelectedIndexChanged" > < FooterStyle BackColor ="#507CD1" Font-Bold ="True" Font-Size ="Small" ForeColor ="White" /> < RowStyle BackColor ="#EFF3FB" /> < EditRowStyle BackColor ="#2461BF" /> < SelectedRowStyle BackColor ="DodgerBlue" Font-Bold ="False" ForeColor ="#333333" /> < PagerStyle BackColor ="#2461BF" ForeColor ="White" HorizontalAlign ="Center" /> < HeaderStyle BackColor ="#507CD1" Font-Bold ="True" Font-Size ="10pt" ForeColor ="White" /> < AlternatingRowStyle BackColor ="White" /> < Columns > < asp:TemplateField > < EditItemTemplate > < asp:CheckBox ID ="CheckBox1" runat ="server" /> </ EditItemTemplate > < ItemTemplate > < asp:CheckBox ID ="CheckBoxFuXuan" runat ="server" /> </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="选择" ShowHeader ="False" > < ItemTemplate > < asp:LinkButton ID ="LinkButton1" runat ="server" CausesValidation ="False" CommandName ="Select" Text ="选择" ></ asp:LinkButton > </ ItemTemplate > < ItemStyle Wrap ="False" /> </ asp:TemplateField > < asp:BoundField DataField ="报表日期" HeaderText ="报表日期" > < ItemStyle Wrap ="False" /> < HeaderStyle Wrap ="False" /> </ asp:BoundField > < asp:BoundField DataField ="报表编号" HeaderText ="报表编号" > < ItemStyle Wrap ="False" /> < HeaderStyle Wrap ="False" /> </ asp:BoundField > < asp:BoundField DataField ="报表名称" HeaderText ="报表名称" NullDisplayText =" " > < ItemStyle Wrap ="False" /> < HeaderStyle Wrap ="False" /> </ asp:BoundField > < asp:BoundField DataField ="编制单位" HeaderText ="编制单位" > < ItemStyle Wrap ="False" /> < HeaderStyle Wrap ="False" /> </ asp:BoundField > < asp:BoundField DataField ="企业负责人" HeaderText ="企业负责人" HtmlEncode ="False" > < ItemStyle Wrap ="False" /> < HeaderStyle Wrap ="False" /> </ asp:BoundField > < asp:BoundField DataField ="统计负责人" HeaderText ="统计负责人" NullDisplayText =" " > < HeaderStyle Wrap ="False" /> </ asp:BoundField > < asp:BoundField DataField ="填表人" HeaderText ="填表人" > < HeaderStyle Wrap ="False" /> </ asp:BoundField > < asp:BoundField DataField ="联系电话" HeaderText ="联系电话" > < HeaderStyle Wrap ="False" /> </ asp:BoundField > < asp:BoundField DataField ="报出日期" HeaderText ="报出日期" > < ItemStyle Wrap ="False" /> </ asp:BoundField > < asp:BoundField DataField ="主管领导" HeaderText ="主管领导" /> < asp:BoundField DataField ="录入人" HeaderText ="录入人" > < ItemStyle Wrap ="False" /> </ asp:BoundField > < asp:BoundField DataField ="备注" HeaderText ="备注" > < ItemStyle Wrap ="False" /> </ asp:BoundField > < asp:BoundField DataField ="SN" HeaderText ="SN" Visible ="False" /> </ Columns > < PagerSettings Visible ="False" /> </ asp:GridView > < table > < tr > < td > < asp:CheckBox ID ="CheckBoxAll" runat ="server" AutoPostBack ="True" OnCheckedChanged ="CheckBoxAll_CheckedChanged" Text ="选择全部" /> < asp:LinkButton ID ="lnkbtnFirst" runat ="server" OnClick ="PagerButtonClick" > 首页 </ asp:LinkButton > < asp:LinkButton ID ="lnkbtnPre" runat ="server" OnClick ="PagerButtonClick" > 上一页 </ asp:LinkButton > < asp:LinkButton ID ="lnkbtnNext" runat ="server" OnClick ="PagerButtonClick" > 下一页 </ asp:LinkButton > < asp:LinkButton ID ="lnkbtnLast" runat ="server" OnClick ="PagerButtonClick" > 尾页 </ asp:LinkButton > < asp:Label ID ="lblCurrentIndex" runat ="server" Text ="第?页" ></ asp:Label > < asp:Label ID ="lblPageCount" runat ="server" Text ="共?页" ></ asp:Label > < asp:Label ID ="lblRecordCount" runat ="server" Text ="记录数" ></ asp:Label > < asp:TextBox ID ="txtJumpPage" runat ="server" Width ="24px" > 1 </ asp:TextBox > < asp:LinkButton ID ="lnkbtnJumpPage" runat ="server" OnClick ="lnkbtnJumpPage_Click" > 跳转 </ asp:LinkButton ></ td > </ tr > </ table > </ asp:View > < asp:View ID ="ViewXiangXiXinXi" runat ="server" > < table > < tr > < td style ="width: 65px; height: 405px" valign ="top" > < asp:Image ID ="ImageXiangXi" runat ="server" ImageUrl ="~/DatabaseImg/he.jpg" /></ td > < td style ="height: 405px" > < table > < tr > < td align ="right" > < asp:Label ID ="LabelBaoBiaoRiQi" runat ="server" Text ="报表日期" ></ asp:Label ></ td > < td style ="width: 553px" > < asp:TextBox ID ="TextBoxBaoBiaoRiQi" runat ="server" class ="smallInput" value ="" Width ="132px" ></ asp:TextBox > < img id ="Image_blqx1" alt ="图像" onclick ="popUpCalendar(this,document.forms[0].TextBoxBaoBiaoRiQi,'yyyy-mm-dd')" src ="../../images/calendar.gif" style ="cursor: hand" /></ td > </ tr > < tr > < td align ="right" style ="height: 15px" > < asp:Label ID ="LabelBaoBiaoBianHao" runat ="server" Text ="报表编号" ></ asp:Label ></ td > < td style ="width: 553px; height: 15px" > < asp:TextBox ID ="TextBoxBaoBiaoBianHao" runat ="server" class ="smallInput" value ="" Width ="132px" ></ asp:TextBox ></ td > </ tr > < tr valign ="top" > < td align ="right" style ="height: 18px" > < asp:Label ID ="LabelBaoBiaoMingCheng" runat ="server" Text ="报表名称" ></ asp:Label ></ td > < td style ="height: 18px" > < asp:TextBox ID ="TextBoxBaoBiaoMingCheng" runat ="server" class ="smallInput" Width ="300px" ReadOnly ="True" > 主要产品产、销、存及售价情况统计表 </ asp:TextBox ></ td > </ tr > < tr > < td align ="right" > < asp:Label ID ="LabelBianZhiDanWei" runat ="server" Text ="编制单位" ></ asp:Label ></ td > < td >< asp:DropDownList ID ="DropDownListBianZhiDanWei" runat ="server" class ="smallInput" Width ="300px" > </ asp:DropDownList ></ td > </ tr > < tr > < td align ="right" style ="height: 19px" > < asp:Label ID ="LabelQiYeFuZeRen" runat ="server" Text ="企业负责人" ></ asp:Label ></ td > < td style ="height: 19px" > < asp:TextBox ID ="TextBoxQiYeFuZeRen" runat ="server" class ="smallInput" ></ asp:TextBox ></ td > </ tr > < tr > < td align ="right" > < asp:Label ID ="LabelTongJiFuZeRen" runat ="server" Text ="统计负责人" ></ asp:Label ></ td > < td > < asp:TextBox ID ="TextBoxTongJiFuZeRen" runat ="server" class ="smallInput" ></ asp:TextBox ></ td > </ tr > < tr > < td align ="right" > < asp:Label ID ="LabelTianBiaoRen" runat ="server" Text ="填表人" ></ asp:Label ></ td > < td > < asp:TextBox ID ="TextBoxTianBiaoRen" runat ="server" class ="smallInput" ></ asp:TextBox ></ td > </ tr > < tr > < td align ="right" > < asp:Label ID ="LabelLianXiDianHua" runat ="server" Text ="联系电话" ></ asp:Label ></ td > < td > < asp:TextBox ID ="TextBoxLianXiDianHua" runat ="server" class ="smallInput" ></ asp:TextBox ></ td > </ tr > < tr > < td align ="right" > < asp:Label ID ="LabelBaoChuRiQi" runat ="server" Text ="报出日期" ></ asp:Label ></ td > < td > < asp:TextBox ID ="TextBoxBaoChuRiQi" runat ="server" class ="smallInput" ></ asp:TextBox > < img id ="Img1" alt ="图像" onclick ="popUpCalendar(this,document.forms[0].TextBoxBaoChuRiQi,'yyyy-mm-dd')" src ="../../images/calendar.gif" style ="cursor: hand" /></ td > </ tr > < tr > < td align ="right" > < asp:Label ID ="LabelZhuGuanLingDao" runat ="server" Text ="主管领导" ></ asp:Label ></ td > < td > < asp:TextBox ID ="TextBoxZhuGuanLingDao" runat ="server" class ="smallInput" ></ asp:TextBox ></ td > </ tr > < tr > < td align ="right" > < asp:Label ID ="LabelLuRuRen" runat ="server" Text ="录入人" ></ asp:Label ></ td > < td > < asp:TextBox ID ="TextBoxLuRuRen" runat ="server" class ="smallInput" ></ asp:TextBox ></ td > </ tr > < tr > < td align ="right" valign ="top" > < asp:Label ID ="LabelBeiZhu" runat ="server" Text ="备注" ></ asp:Label ></ td > < td > < asp:TextBox ID ="TextBoxBeiZhu" runat ="server" class ="smallInput" Height ="100px" TextMode ="MultiLine" Width ="400px" ></ asp:TextBox ></ td > </ tr > </ table > </ td > </ tr > < tr > < td style ="width: 65px" > </ td > < td align ="center" > < asp:Button ID ="ButtonCaoZuo" runat ="server" OnClick ="ButtonCaoZuo_Click" Text ="操作类型" /> </ td > </ tr > </ table > < asp:Label ID ="LabelZhuJian" runat ="server" Text ="隐藏主键" Visible ="False" ></ asp:Label > </ asp:View > < asp:View ID ="ViewReports" runat ="server" > < asp:Label ID ="LabelReportTitle" runat ="server" Text ="报表名称" ></ asp:Label >< br /> < asp:GridView ID ="GridViewTianJia" runat ="server" AutoGenerateColumns ="False" DataKeyNames ="SN" OnRowCancelingEdit ="GridViewTianJia_RowCancelingEdit" OnRowDataBound ="GridViewTianJia_RowDataBound" OnRowDeleting ="GridViewTianJia_RowDeleting" OnRowEditing ="GridViewTianJia_RowEditing" OnRowUpdating ="GridViewTianJia_RowUpdating" > < Columns > < asp:TemplateField HeaderText ="编辑" ShowHeader ="False" > < EditItemTemplate > < asp:LinkButton ID ="LinkButton1" runat ="server" CausesValidation ="True" CommandName ="Update" Text ="更新" ></ asp:LinkButton > < asp:LinkButton ID ="LinkButton2" runat ="server" CausesValidation ="False" CommandName ="Cancel" Text ="取消" ></ asp:LinkButton > </ EditItemTemplate > < ItemStyle Wrap ="False" /> < ItemTemplate > < asp:LinkButton ID ="LinkButton1" runat ="server" CausesValidation ="False" CommandName ="Edit" Text ="编辑" ></ asp:LinkButton > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="操作" ShowHeader ="False" > < ItemStyle Wrap ="False" /> < ItemTemplate > < asp:LinkButton ID ="LinkButton3" runat ="server" CausesValidation ="False" CommandName ="Delete" Text ="删除" ></ asp:LinkButton > < asp:LinkButton ID ="LinkButtonTianJia" runat ="server" Visible ="False" > 添加保存 </ asp:LinkButton > < asp:LinkButton ID ="LinkButtonQuXiao" runat ="server" OnClick ="LinkButtonQuXiao_Click" Visible ="False" > 取消 </ asp:LinkButton > </ ItemTemplate > </ asp:TemplateField > < asp:BoundField DataField ="ID" HeaderText ="ID" Visible ="False" > < ItemStyle Wrap ="False" /> </ asp:BoundField > < asp:TemplateField HeaderText ="编号" > < EditItemTemplate > < asp:TextBox ID ="TextBoxBianHao" runat ="server" Text ='<%# Eval("编号") % > ' Width="20px"> </ asp:TextBox > </ EditItemTemplate > < ItemTemplate > < asp:Label ID ="LabelBianHao" runat ="server" Text ='<%# Bind("编号") % > '> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="生产企业" > < EditItemTemplate > < asp:TextBox ID ="TextBoxShenChanQiYe" runat ="server" Text ='<%# Eval("生产企业") % > ' Width="100px"> </ asp:TextBox > </ EditItemTemplate > < ItemTemplate > < asp:Label ID ="LabelShenChanQiYi" runat ="server" Text ='<%# Bind("生产企业") % > '> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="产品名称" > < EditItemTemplate > < asp:TextBox ID ="TextBoxChanPinMingChen" runat ="server" Text ='<%# Eval("产品名称") % > ' Width="100px"> </ asp:TextBox > </ EditItemTemplate > < ItemTemplate > < asp:Label ID ="LabelChanPinMingChen" runat ="server" Text ='<%# Bind("产品名称") % > ' > </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="计量单位" > < EditItemTemplate > < asp:TextBox ID ="TextBoxJiLiangDanWei" runat ="server" Text ='<%# Eval("计量单位") % > ' Width="50px"> </ asp:TextBox > </ EditItemTemplate > < ItemStyle Wrap ="False" /> < ItemTemplate > < asp:Label ID ="LabelJiLiangDanWei" runat ="server" Text ='<%# Bind("计量单位") % > '> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="生产量本年实际" > < EditItemTemplate > < asp:TextBox ID ="TextBoxShenChanLiangBenNian" runat ="server" Text ='<%# Eval("生产量本年实际") % > ' Width="70px"> </ asp:TextBox > </ EditItemTemplate > < ItemStyle Wrap ="False" /> < ItemTemplate > < asp:Label ID ="LabelShenChanLiangBenNian" runat ="server" Text ='<%# Bind("生产量本年实际") % > '> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="生产量去年实际" > < EditItemTemplate > < asp:TextBox ID ="TextBoxShenChanLiangQuNian" runat ="server" Text ='<%# Eval("生产量去年实际") % > ' Width="70"> </ asp:TextBox > </ EditItemTemplate > < ItemStyle Wrap ="False" /> < ItemTemplate > < asp:Label ID ="LabelShenChanLiangQuNian" runat ="server" Text ='<%# Bind("生产量去年实际") % > '> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="销售量本年实际" > < EditItemTemplate > < asp:TextBox ID ="TextBoxXiaoShouLiangBenNian" runat ="server" Text ='<%# Eval("销售量本年实际") % > ' Width="70px"> </ asp:TextBox > </ EditItemTemplate > < ItemStyle Wrap ="False" /> < ItemTemplate > < asp:Label ID ="LabelXiaoShouLiangBenNian" runat ="server" Text ='<%# Bind("销售量本年实际") % > '> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="销售量去年实际" > < EditItemTemplate > < asp:TextBox ID ="TextBoxXiaoShouLiangQuNian" runat ="server" Text ='<%# Eval("销售量去年实际") % > ' Width="70"> </ asp:TextBox > </ EditItemTemplate > < ItemStyle Wrap ="False" /> < ItemTemplate > < asp:Label ID ="LabelXiaoShouLiangQuNian" runat ="server" Text ='<%# Bind("销售量去年实际") % > ' > </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="库存量年初库存" > < EditItemTemplate > < asp:TextBox ID ="TextBoxKuCunLiangNianChu" runat ="server" Text ='<%# Eval("库存量年初库存") % > ' Width="70"> </ asp:TextBox > </ EditItemTemplate > < ItemStyle Wrap ="False" /> < ItemTemplate > < asp:Label ID ="LabelKuCunLiangNianChu" runat ="server" Text ='<%# Bind("库存量年初库存") % > '> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="库存量期末库存" > < EditItemTemplate > < asp:TextBox ID ="TextBoxKuCunLiangQiMo" runat ="server" Text ='<%# Eval("库存量期末库存") % > ' Width="70"> </ asp:TextBox > </ EditItemTemplate > < ItemStyle Wrap ="False" /> < ItemTemplate > < asp:Label ID ="LabelKuCunLiangQiMo" runat ="server" Text ='<%# Bind("库存量期末库存") % > '> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="平均售价本年实际(元)" > < EditItemTemplate > < asp:TextBox ID ="TextBoxPingJunShouJiaBenNian" runat ="server" Text ='<%# Eval("平均售价本年实际") % > ' Width="70"> </ asp:TextBox > </ EditItemTemplate > < ItemStyle Wrap ="False" /> < ItemTemplate > < asp:Label ID ="LabelPingJunShouJiaBenNian" runat ="server" Text ='<%# Bind("平均售价本年实际") % > ' Width="70"> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="平均售价去年实际(元)" > < EditItemTemplate > < asp:TextBox ID ="TextBoxPingJunShouJiaQuNian" runat ="server" Text ='<%# Eval("平均售价去年实际") % > ' Width="70"> </ asp:TextBox > </ EditItemTemplate > < ItemStyle Wrap ="False" /> < ItemTemplate > < asp:Label ID ="LabelPingJunShouJiaQuNian" runat ="server" Text ='<%# Bind("平均售价去年实际") % > '> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="产销率本年实际(%)" > < EditItemTemplate > < asp:TextBox ID ="TextBoxChanXiaoLvBenNian" runat ="server" Text ='<%# Eval("产销率本年实际") % > ' Width="70"> </ asp:TextBox > </ EditItemTemplate > < ItemStyle Wrap ="False" /> < ItemTemplate > < asp:Label ID ="LabelChanXiaoLvBenNian" runat ="server" Text ='<%# Bind("产销率本年实际") % > '> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="产销率去年实际(%)" > < EditItemTemplate > < asp:TextBox ID ="TextBoxChanXiaoLvQuNian" runat ="server" Text ='<%# Eval("产销率去年实际") % > ' Width="70"> </ asp:TextBox > </ EditItemTemplate > < ItemStyle Wrap ="False" /> < ItemTemplate > < asp:Label ID ="LabelChanXiaoLvQuNian" runat ="server" Text ='<%# Bind("产销率去年实际") % > '> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="市场占有率本年实际(%)" > < EditItemTemplate > < asp:TextBox ID ="TextBoxShiChangBenNian" runat ="server" Text ='<%# Eval("市场占有率本年实际") % > ' Width="70"> </ asp:TextBox > </ EditItemTemplate > < ItemStyle Wrap ="False" /> < ItemTemplate > < asp:Label ID ="LabelShiChangBenNian" runat ="server" Text ='<%# Bind("市场占有率本年实际") % > '> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="市场占有率去年实际(%)" > < EditItemTemplate > < asp:TextBox ID ="TextBoxShiChangQuNian" runat ="server" Text ='<%# Eval("市场占有率去年实际") % > ' Width="70"> </ asp:TextBox > </ EditItemTemplate > < ItemStyle Wrap ="False" /> < ItemTemplate > < asp:Label ID ="LabelShiChangQuNian" runat ="server" Text ='<%# Bind("市场占有率去年实际") % > '> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:BoundField DataField ="SN" HeaderText ="SN" Visible ="False" /> </ Columns > < EmptyDataTemplate > 建立日期生产企业产品名称计量单位生产量本年实际生产量去年实际销售量本年实际销售量去年实际库存量年初库存库库存量期末库存平均售价本年实际平均售价去年实际产效率本年实际产效率去年实际市场占有率本年实际市场占有率去年实际 </ EmptyDataTemplate > < HeaderStyle Font-Size ="10pt" /> < RowStyle HorizontalAlign ="Right" /> < EditRowStyle HorizontalAlign ="Right" /> </ asp:GridView > < asp:Button ID ="ButtonXinZen" runat ="server" OnClick ="ButtonXinZen_Click" Text ="新增" /> < asp:Button ID ="ButtonCal" runat ="server" OnClick ="ButtonCal_Click" Text ="计算" /> < asp:Button ID ="ButtonClear" runat ="server" OnClick ="ButtonClear_Click" Text ="清除多余表格" /> < asp:Button ID ="ButtonExcel" runat ="server" OnClick ="ButtonExcel_Click" Text ="导出到Excel" /> < asp:Label ID ="Label1" runat ="server" Visible ="False" ></ asp:Label ></ asp:View > </ asp:MultiView > </ div > </ form > </ body > </ html >

/*----------------------------------------------------------------// Copyright (C) 2007 // 作者：马如林// 时间：2007/09/20// 文件名：// 文件功能描述：// 主要产品产、销、存、售价情况信息页面// // // 修改标识：// 修改描述：// //----------------------------------------------------------------*/ using System.Globalization; using System.Data.OracleClient; using System.IO; using System.Text; using Hhxx.App_Code.DatabaseOperate; using Hhxx.App_Code.Database; using Hhxx.App_Code.Common; using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class InterFace_Reports_CaiXiaoCunSouJia : System.Web.UI.Page { // 报表信息查询 private static String baoBiaoMingCheng = "主要产品产、销、存及售价情况统计表"; // 报表查询语句 private String querySql = "SELECT * FROM baobiaoxinxi where 报表名称='" + baoBiaoMingCheng + "'" ; // 统计使用参数 private decimal totalstock = 0; protected void Page_Load(object sender, EventArgs e) { this.MenuCaidan.Items[0].Enabled = true; this.MenuCaidan.Items[1].Enabled = true; this.MenuCaidan.Items[2].Enabled = false; this.MenuCaidan.Items[3].Enabled = false; this.MenuCaidan.Items[4].Enabled = false; if (!Page.IsPostBack) { dropDownListInit(); // 初始化默认Gridview的SQL语句 fillGridView(querySql); } // gridview 换行控制 this.GridViewXinXiLan.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); } /// <summary> /// 点击菜单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void MenuCaidan_MenuItemClick(object sender, MenuEventArgs e) { switch (MenuCaidan.SelectedItem.Text.Trim()) { case "报表导航": { Server.Transfer("~/InterFace/zonggongsi.aspx"); } break; case "报表基本信息栏": { MultiViewXinXiGuanLi.ActiveViewIndex = 0; fillGridView(querySql); break; } case "报表详细信息": MultiViewXinXiGuanLi.ActiveViewIndex = 2; break; case "添加报表基本信息": MultiViewXinXiGuanLi.ActiveViewIndex = 1; break; case "编辑报表基本信息": MultiViewXinXiGuanLi.ActiveViewIndex = 1; break; default: break; } } /// <summary> /// 条件查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ButtonTiJianChaXun_Click(object sender, EventArgs e) { String strCondition = ""; String strChoose = ""; if (TextBoxOne.Text.Trim().Length != 0) { String tempStr = DropDownListTiaoJianOne.SelectedItem.Value; switch (tempStr) { case "包含": strChoose = " LIKE "; break; case "不包含": strChoose = " NOT LIKE "; break; } if (strCondition.Length == 0) { strCondition = strCondition + DropDownListLeiBeiOne.SelectedItem.Value + strChoose + "'%" + TextBoxOne.Text.Trim() + "%'"; } else { strCondition = strCondition + "AND " + DropDownListLeiBeiOne.SelectedItem.Value + strChoose + "'%" + TextBoxOne.Text.Trim() + "%'"; } } if (TextBoxTwo.Text.Trim().Length != 0) { String tempStr = DropDownListTiaoJianTwo.SelectedItem.Value; switch (tempStr) { case "包含": strChoose = " LIKE "; break; case "不包含": strChoose = " NOT LIKE "; break; } if (strCondition.Length == 0) { strCondition = strCondition + DropDownListLeiBeiTwo.SelectedItem.Value + strChoose + "'%" + TextBoxTwo.Text.Trim() + "%'"; } else { strCondition = strCondition + "AND " + DropDownListLeiBeiTwo.SelectedItem.Value + strChoose + "'%" + TextBoxTwo.Text.Trim() + "%'"; } } if (TextBoxThree.Text.Trim().Length != 0) { String tempStr = DropDownListTiaoJianThree.SelectedItem.Value; switch (tempStr) { case "等于": strChoose = "="; break; case "大于": strChoose = ">"; break; case "小于": strChoose = "<"; break; } if (strCondition.Length == 0) { strCondition = strCondition + DropDownListLeiBeiThree.SelectedItem.Value + strChoose + TextBoxThree.Text.Trim(); } else { strCondition = strCondition + "AND " + DropDownListLeiBeiThree.SelectedItem.Value + strChoose + TextBoxThree.Text.Trim(); } } if (TextBoxFour.Text.Trim().Length != 0) { String tempStr = DropDownListTiaoJianFour.SelectedItem.Value; switch (tempStr) { case "等于": strChoose = "="; break; case "大于": strChoose = ">"; break; case "小于": strChoose = "<"; break; } if (strCondition.Length == 0) { strCondition = strCondition + DropDownListLeiBeiFour.SelectedItem.Value + strChoose + TextBoxFour.Text.Trim(); } else { strCondition = strCondition + "AND " + DropDownListLeiBeiFour.SelectedItem.Value + strChoose + TextBoxFour.Text.Trim(); } } if (strCondition.Length != 0) { strCondition = " where " + strCondition; } strCondition = strCondition + " ORDER BY " + DropDownListPaiXuFangShi.SelectedItem.Value.Trim(); String strSql = querySql + strCondition; String mQuerySql = strSql; // 填充表格 fillGridView(mQuerySql); // 保存SQL语句 ViewState["sql"] = mQuerySql; } /// <summary> /// 初始化DropDownList /// </summary> private void dropDownListInit() { GetTableInformation getTableInformation = new GetTableInformation(); // 获取表结构信息 Hashtable tableInfor = getTableInformation.getTableInfor("baobiaoxinxi"); // 移除SN tableInfor.Remove("SN"); tableInfor.Remove("报表名称"); foreach (DictionaryEntry de in tableInfor) { String key = de.Key.ToString(); String value = de.Value.ToString(); switch (value) { case "CHAR": DropDownListLeiBeiOne.Items.Add(key); DropDownListLeiBeiTwo.Items.Add(key); // 排序方式下拉框添加数据字段 DropDownListPaiXuFangShi.Items.Add(key); break; case "VARCHAR2": DropDownListLeiBeiOne.Items.Add(key); DropDownListLeiBeiTwo.Items.Add(key); // 排序方式下拉框添加数据字段 DropDownListPaiXuFangShi.Items.Add(key); break; case "NUMBER": DropDownListLeiBeiThree.Items.Add(key); DropDownListLeiBeiFour.Items.Add(key); // 排序方式下拉框添加数据字段 DropDownListPaiXuFangShi.Items.Add(key); break; } } DropDownListTiaoJianOne.Items.Add("包含"); DropDownListTiaoJianOne.Items.Add("不包含"); DropDownListTiaoJianTwo.Items.Add("包含"); DropDownListTiaoJianTwo.Items.Add("不包含"); DropDownListTiaoJianThree.Items.Add("等于"); DropDownListTiaoJianThree.Items.Add("小于"); DropDownListTiaoJianThree.Items.Add("大于"); DropDownListTiaoJianFour.Items.Add("等于"); DropDownListTiaoJianFour.Items.Add("小于"); DropDownListTiaoJianFour.Items.Add("大于"); if (DropDownListLeiBeiOne.Items.Count == 0) { this.DropDownListLeiBeiOne.Visible = false; this.DropDownListTiaoJianOne.Visible = false; this.TextBoxOne.Visible = false; } if (DropDownListLeiBeiTwo.Items.Count == 0) { this.DropDownListLeiBeiTwo.Visible = false; this.DropDownListTiaoJianTwo.Visible = false; this.TextBoxTwo.Visible = false; } if (DropDownListLeiBeiThree.Items.Count == 0) { this.DropDownListLeiBeiThree.Visible = false; this.DropDownListTiaoJianThree.Visible = false; this.TextBoxThree.Visible = false; } if (DropDownListLeiBeiFour.Items.Count == 0) { this.DropDownListLeiBeiFour.Visible = false; this.DropDownListTiaoJianFour.Visible = false; this.TextBoxFour.Visible = false; } } /// <summary> /// 填充GridView /// </summary> private void fillGridView(String querySql) { DataSet ds = new DataSet(); ds = GetData(querySql); // 清空以前的数据源 GridViewXinXiLan.DataSource = null; // 将ds作为信息栏GridView的数据源 GridViewXinXiLan.DataSource = ds; // 绑定数据 GridViewXinXiLan.DataBind(); // 分页的相关参数设置 getRefSet(ds); // 保存数据源防止丢失 VS的破Bug ViewState["GridViewXinXiLan_DataSource"] = GridViewXinXiLan.DataSource; // 保存SQL语句 ViewState["sql"] = querySql; } /// <summary> /// 转换SQL查询结果为DataSet /// </summary> /// <returns>ds</returns> private DataSet GetData(String querySql) { String connStr = OracleHelper.DatabaseConnStr; // 创建数据集 DataSet ds = OracleHelper.ExeSqlForDataSet(connStr, CommandType.Text, querySql, null); return ds; } /// <summary> /// 首页，上一页，下一页，尾页公用的点击程序 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void PagerButtonClick(object sender, EventArgs e) { // CommandArgument对应该对象在页面初始化后的设定值 // 减1 是因为系统默认首页的PageIndex为0，为了符合人们的正常思维而使用 // 重新绑定 GridViewXinXiLan.DataSource = ViewState["GridViewXinXiLan_DataSource"]; GridViewXinXiLan.PageIndex = Convert.ToInt32(((LinkButton)sender).CommandArgument) - 1; GridViewXinXiLan.DataBind(); // 更新当前页面显示值 lblCurrentIndex.Text = "第 " + (GridViewXinXiLan.PageIndex + 1).ToString() + " 页"; // 更新参数 lnkbtnPre.CommandArgument = (GridViewXinXiLan.PageIndex == 0 ? "1" : GridViewXinXiLan.PageIndex.ToString()); lnkbtnNext.CommandArgument = (GridViewXinXiLan.PageCount == 1 ? GridViewXinXiLan.PageCount.ToString() : (GridViewXinXiLan.PageIndex + 2).ToString()); } /// <summary> /// 分页的相关参数设置 /// </summary> /// <param name="ds"></param> protected void getRefSet(DataSet ds) { lblCurrentIndex.Text = "第 " + (GridViewXinXiLan.PageIndex + 1).ToString() + " 页"; lblPageCount.Text = "共 " + GridViewXinXiLan.PageCount.ToString() + " 页"; lblRecordCount.Text = "总共 " + ds.Tables[0].Rows.Count.ToString() + " 条"; if (ds.Tables[0].Rows.Count == 0) { lnkbtnFirst.Visible = false; lnkbtnPre.Visible = false; lnkbtnNext.Visible = false; lnkbtnLast.Visible = false; lblCurrentIndex.Visible = false; lblPageCount.Visible = false; lblRecordCount.Visible = false; this.lnkbtnJumpPage.Visible = false; this.txtJumpPage.Visible = false; this.CheckBoxAll.Visible = false; } else if (GridViewXinXiLan.PageCount == 1) { lnkbtnFirst.Visible = false; lnkbtnPre.Visible = false; lnkbtnNext.Visible = false; lnkbtnLast.Visible = false; this.CheckBoxAll.Visible = true; } // 设置LinkButton此时对应的参数 lnkbtnFirst.CommandArgument = "1"; lnkbtnPre.CommandArgument = (GridViewXinXiLan.PageIndex == 0 ? "1" : GridViewXinXiLan.PageIndex.ToString()); lnkbtnNext.CommandArgument = (GridViewXinXiLan.PageCount == 1 ? GridViewXinXiLan.PageCount.ToString() : (GridViewXinXiLan.PageIndex + 2).ToString()); lnkbtnLast.CommandArgument = GridViewXinXiLan.PageCount.ToString(); } /// <summary> /// 跳转到指定页面，页面参数由txtJumpPage获取 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lnkbtnJumpPage_Click(object sender, EventArgs e) { // 减1 是因为系统默认首页的PageIndex为0，为了符合人们的正常思维而使用 // 重新绑定 GridViewXinXiLan.DataSource = ViewState["GridViewXinXiLan_DataSource"]; GridViewXinXiLan.PageIndex = int.Parse(txtJumpPage.Text) - 1; GridViewXinXiLan.DataBind(); // 更新当前页面显示值 lblCurrentIndex.Text = "第 " + (GridViewXinXiLan.PageIndex + 1).ToString() + " 页"; // 更新参数 lnkbtnPre.CommandArgument = (GridViewXinXiLan.PageIndex == 0 ? "1" : GridViewXinXiLan.PageIndex.ToString()); lnkbtnNext.CommandArgument = (GridViewXinXiLan.PageCount == 1 ? GridViewXinXiLan.PageCount.ToString() : (GridViewXinXiLan.PageIndex + 2).ToString()); } /// <summary> /// 解决数据源不能分页的问题 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridViewXinXiLan_PageIndexChanging(object sender, GridViewPageEventArgs e) { // 读取数据源设定显示值并绑定 GridViewXinXiLan.DataSource = ViewState["GridViewXinXiLan_DataSource"]; GridViewXinXiLan.PageIndex = e.NewPageIndex; GridViewXinXiLan.DataBind(); } /// <summary> /// 复选框选择 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void CheckBoxAll_CheckedChanged(object sender, EventArgs e) { for (int i = 0; i <= GridViewXinXiLan.Rows.Count - 1; i++) { CheckBox cbox = (CheckBox)GridViewXinXiLan.Rows[i].FindControl("CheckBoxFuXuan"); if (CheckBoxAll.Checked == true) { cbox.Checked = true; this.CheckBoxAll.Text = "取消全选"; } else { cbox.Checked = false; this.CheckBoxAll.Text = "全部选择"; } } } /// <summary> /// 返回首页面 /// </summary> private void BackIndex() { MultiViewXinXiGuanLi.ActiveViewIndex = 0; MenuCaidan.Items[1].Enabled = true; MenuCaidan.Items[1].Selected = true; fillGridView(querySql); } /// <summary> /// 选择 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridViewXinXiLan_SelectedIndexChanged(object sender, EventArgs e) { CheckBox cb = this.GridViewXinXiLan.SelectedRow.FindControl("CheckBoxFuXuan") as CheckBox; cb.Checked = true; } /// <summary> /// 相关下拉列表复原 /// </summary> private void dropDownListRecover() { // 编制单位 String conn = OracleHelper.DatabaseConnStr; this.DropDownListBianZhiDanWei.Items.Clear(); String queryBianZhiDanWei = "SELECT 名称 FROM XITONGZIDIAN WHERE ID='05010101' ORDER BY 序号"; OracleDataReader drBianZhiDanWei = OracleHelper.ExecuteReader(conn, CommandType.Text, queryBianZhiDanWei, null); while (drBianZhiDanWei.Read()) { this.DropDownListBianZhiDanWei.Items.Add(drBianZhiDanWei.GetString(0).Trim()); } drBianZhiDanWei.Close(); } /// <summary> /// 添加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ButtonTianJia_Click(object sender, EventArgs e) { this.MenuCaidan.Items[3].Enabled = true; MenuCaidan.Items[3].Selected = true; MultiViewXinXiGuanLi.ActiveViewIndex = 1; // 建立日期 // 生成GUID String tempGuid = System.Guid.NewGuid().ToString().Replace("-", ""); this.LabelZhuJian.Text = tempGuid; //操作 this.ButtonCaoZuo.Visible = true; this.ButtonCaoZuo.Enabled = true; this.ButtonCaoZuo.Text = "下一步"; TextBoxBaoBiaoRiQi.Text = ""; TextBoxBaoBiaoBianHao.Text = ""; TextBoxQiYeFuZeRen.Text = ""; TextBoxTongJiFuZeRen.Text = ""; TextBoxTianBiaoRen.Text = ""; TextBoxLianXiDianHua.Text = ""; TextBoxBaoChuRiQi.Text = ""; TextBoxZhuGuanLingDao.Text = ""; TextBoxLuRuRen.Text = ""; TextBoxBeiZhu.Text = ""; // 初始化下拉框 dropDownListRecover(); } /// <summary> /// 编辑 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ButtonBianJi_Click(object sender, EventArgs e) { if (this.GridViewXinXiLan.SelectedRow != null) { // 主键 this.LabelZhuJian.Text = this.GridViewXinXiLan.DataKeys[this.GridViewXinXiLan.SelectedRow.RowIndex][0].ToString(); this.MenuCaidan.Items[4].Enabled = true; MenuCaidan.Items[4].Selected = true; MultiViewXinXiGuanLi.ActiveViewIndex = 1; this.ButtonCaoZuo.Text = "保存更新"; this.ButtonCaoZuo.Enabled = true; this.ButtonCaoZuo.Visible = true; dropDownListRecover(); TextBoxBaoBiaoRiQi.Text = this.GridViewXinXiLan.Rows[this.GridViewXinXiLan.SelectedRow.RowIndex].Cells[2].Text.ToString(); TextBoxBaoBiaoBianHao.Text = this.GridViewXinXiLan.Rows[this.GridViewXinXiLan.SelectedRow.RowIndex].Cells[3].Text.ToString(); DropDownListBianZhiDanWei.Items.Remove(this.GridViewXinXiLan.Rows[this.GridViewXinXiLan.SelectedRow.RowIndex].Cells[5].Text.ToString().Trim()); DropDownListBianZhiDanWei.Items.Insert(0, this.GridViewXinXiLan.Rows[this.GridViewXinXiLan.SelectedRow.RowIndex].Cells[5].Text.ToString().Trim()); TextBoxQiYeFuZeRen.Text = this.GridViewXinXiLan.Rows[this.GridViewXinXiLan.SelectedRow.RowIndex].Cells[6].Text.ToString(); TextBoxTongJiFuZeRen.Text = this.GridViewXinXiLan.Rows[this.GridViewXinXiLan.SelectedRow.RowIndex].Cells[7].Text.ToString(); TextBoxTianBiaoRen.Text = this.GridViewXinXiLan.Rows[this.GridViewXinXiLan.SelectedRow.RowIndex].Cells[8].Text.ToString(); TextBoxLianXiDianHua.Text = this.GridViewXinXiLan.Rows[this.GridViewXinXiLan.SelectedRow.RowIndex].Cells[9].Text.ToString(); TextBoxBaoChuRiQi.Text = this.GridViewXinXiLan.Rows[this.GridViewXinXiLan.SelectedRow.RowIndex].Cells[10].Text.ToString(); TextBoxZhuGuanLingDao.Text = this.GridViewXinXiLan.Rows[this.GridViewXinXiLan.SelectedRow.RowIndex].Cells[11].Text.ToString(); TextBoxLuRuRen.Text = this.GridViewXinXiLan.Rows[this.GridViewXinXiLan.SelectedRow.RowIndex].Cells[12].Text.ToString(); TextBoxBeiZhu.Text = this.GridViewXinXiLan.Rows[this.GridViewXinXiLan.SelectedRow.RowIndex].Cells[13].Text.ToString(); } else { // 错误信息提示 String tip = "请选择行!"; Response.Write("<script>alert('" + tip + "')</script>"); } } /// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ButtonShanChu_Click(object sender, EventArgs e) { // 选择数组 ArrayList selectedItems = new ArrayList(); for (int i = 0; i < this.GridViewXinXiLan.Rows.Count; i++) { string id = this.GridViewXinXiLan.DataKeys[i][0].ToString(); CheckBox cb = this.GridViewXinXiLan.Rows[i].FindControl("CheckBoxFuXuan") as CheckBox; if (selectedItems.Contains(id) && !cb.Checked) { selectedItems.Remove(id); } if (!selectedItems.Contains(id) && cb.Checked) { selectedItems.Add(id); } } // 判断是否有复选框被选择 if (selectedItems.Count == 0) { // 错误信息提示 String tip = "请选择行!"; Response.Write("<script>alert('" + tip + "')</script>"); return; } // 一个个删除 foreach (object tmp in selectedItems) { // 删除需要开启事务 // 删除主表 String delSql = "DELETE FROM baobiaoxinxi WHERE SN = " + "'" + tmp.ToString().Trim() + "'"; // 删除子表 String delSubSql = "DELETE FROM cxcs Where ID = " + "'" + tmp.ToString().Trim() + "'"; OracleConnection conn = new OracleConnection(OracleHelper.DatabaseConnStr); conn.Open(); OracleTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { OracleHelper.ExecuteNonQuery(trans, CommandType.Text, delSql, null); OracleHelper.ExecuteNonQuery(trans, CommandType.Text, delSubSql, null); trans.Commit(); } catch (Exception ex) { trans.Rollback(); ex.ToString(); } finally { conn.Close(); } } // 刷新删除页面 // 读取数据源设定显示值并绑定 // 保存SQL语句 String sql = ViewState["sql"].ToString(); fillGridView(ViewState["sql"].ToString()); // 获取字符串中的字符正则表达式并转换为整形 this.GridViewXinXiLan.PageIndex = Convert.ToInt32(System.Text.RegularExpressions.Regex.Replace(this.lblCurrentIndex.Text, @"[^d]*", "")) - 1; } /// <summary> /// 报表详细信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ButtonChaYue_Click(object sender, EventArgs e) { if (this.GridViewXinXiLan.SelectedRow != null) { this.LabelZhuJian.Text = this.GridViewXinXiLan.DataKeys[this.GridViewXinXiLan.SelectedRow.RowIndex][0].ToString(); this.MenuCaidan.Items[2].Enabled = true; MenuCaidan.Items[2].Selected = true; MultiViewXinXiGuanLi.ActiveViewIndex = 2; LabelReportTitle.Text = this.GridViewXinXiLan.Rows[this.GridViewXinXiLan.SelectedRow.RowIndex].Cells[4].Text.ToString(); // 初始化默认Gridview的SQL语句 RecoveryGridView(); showButton(); } else { // 错误信息提示 String tip = "请选择行!"; Response.Write("<script>alert('" + tip + "')</script>"); } } /// <summary> /// 操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ButtonCaoZuo_Click(object sender, EventArgs e) { switch (this.ButtonCaoZuo.Text) { case "下一步": { if (validTerm()) { if (MainTable() == 1) { this.MenuCaidan.Items[2].Enabled = true; MenuCaidan.Items[2].Selected = true; MultiViewXinXiGuanLi.ActiveViewIndex = 2; // 初始化表格 InitTable(20); ShowTable(); showButton(); LabelReportTitle.Text = baoBiaoMingCheng; } } } break; case "保存更新": { UpdateInformation(); } break; default: break; } } /// <summary> /// 初始化表结构 /// </summary> /// <param name="rowsNum">行数</param> /// <returns></returns> protected int InitTable(int rowsNum) { int result = 1; String sqlInsert = "INSERT INTO cxcs(ID,编号,生产企业,产品名称,计量单位,生产量本年实际,生产量去年实际,销售量本年实际,销售量去年实际," +"库存量年初库存,库存量期末库存,平均售价本年实际,平均售价去年实际,产销率本年实际,产销率去年实际,市场占有率本年实际," +"市场占有率去年实际,SN) " + "VALUES(:id,:bh,:scqy,:cpmc,:jldw,:sclbnsj,:sclqnsj,:xslbnsj,:xslqnsj,:kclnckc,:kclqmkc,:pjsjbnsj,:pjsjqnsj,:cxlbnsj,:cxlqnsj," +":sczylbnsj,:sczylqnsj,:sn)"; OracleParameter[] parms = { new OracleParameter(":id", OracleType.Char, 32), new OracleParameter(":bh", OracleType.Number, 8), new OracleParameter(":scqy", OracleType.VarChar, 512), new OracleParameter(":cpmc", OracleType.VarChar, 512), new OracleParameter(":jldw", OracleType.Char, 32), new OracleParameter(":sclbnsj", OracleType.Char, 32), new OracleParameter(":sclqnsj", OracleType.Char, 32), new OracleParameter(":xslbnsj", OracleType.Char, 32), new OracleParameter(":xslqnsj", OracleType.Char, 32), new OracleParameter(":kclnckc", OracleType.Char, 32), new OracleParameter(":kclqmkc", OracleType.Char, 32), new OracleParameter(":pjsjbnsj", OracleType.Char, 32), new OracleParameter(":pjsjqnsj", OracleType.Char, 32), new OracleParameter(":cxlbnsj", OracleType.Char, 32), new OracleParameter(":cxlqnsj", OracleType.Char, 32), new OracleParameter(":sczylbnsj", OracleType.Char, 32), new OracleParameter(":sczylqnsj", OracleType.Char, 32), new OracleParameter(":sn", OracleType.Char, 32) }; parms[0].Value = this.LabelZhuJian.Text.Trim(); parms[1].Value = 1.0; parms[2].Value = ""; parms[3].Value = ""; parms[4].Value = ""; parms[5].Value = ""; parms[6].Value = ""; parms[7].Value = ""; parms[8].Value = ""; parms[9].Value = ""; parms[10].Value = ""; parms[11].Value = ""; parms[12].Value = ""; parms[13].Value = ""; parms[14].Value = ""; parms[15].Value = ""; parms[16].Value = ""; parms[17].Value = ""; OracleConnection conn = new OracleConnection(OracleHelper.DatabaseConnStr); for (int i = 0; i < rowsNum; i++) { parms[1].Value = Convert.ToDouble(i+1); parms[17].Value = System.Guid.NewGuid().ToString().Replace("-", ""); conn.Open(); OracleTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { OracleHelper.ExecuteNonQuery(trans, CommandType.Text, sqlInsert, parms); trans.Commit(); } catch (Exception ex) { trans.Rollback(); ex.ToString(); result = 0; } finally { conn.Close(); } } return result; } /// <summary> /// 显示表 /// </summary> protected void ShowTable() { GridViewTianJia.EditIndex = -1; RecoveryGridView(); } /// <summary> /// 填充GridView /// </summary> private void fillGridViewTianJia(String querySql) { DataSet ds = new DataSet(); ds = GetData(querySql); // 清空以前的数据源 GridViewTianJia.DataSource = null; // 将ds作为信息栏GridView的数据源 GridViewTianJia.DataSource = ds; // 绑定数据 GridViewTianJia.DataBind(); // 保存数据源防止丢失 VS的破Bug ViewState["GridViewTianJia_DataSource"] = this.GridViewTianJia.DataSource; // 保存SQL语句 ViewState["sql"] = querySql; // gridview 换行控制 this.GridViewTianJia.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); // GridViewTianJia.FooterRow.Visible = false; } /// <summary> /// 添加到主表 /// </summary> protected int MainTable() { int result = 1; // 保存到Label LabelZhuJian.Text = System.Guid.NewGuid().ToString().Replace("-", ""); String sqlInsert = "INSERT INTO baobiaoxinxi(报表日期,报表编号,报表名称,编制单位,企业负责人,统计负责人,填表人,联系电话,报出日期,主管领导,备注,录入人,SN) " + "VALUES(:bbrq,:bbbh,:bbmc,:bzdw,:qyfzr,:tjfzr,:tbr,:lxdh,:bcrq,:zgld,:bz,:lrr,:sn)"; OracleParameter[] parms = { new OracleParameter(":bbrq", OracleType.Char, 10), new OracleParameter(":bbbh", OracleType.Char, 128), new OracleParameter(":bbmc", OracleType.VarChar, 512), new OracleParameter(":bzdw", OracleType.VarChar, 512), new OracleParameter(":qyfzr", OracleType.Char, 20), new OracleParameter(":tjfzr", OracleType.Char, 20), new OracleParameter(":tbr", OracleType.Char, 20), new OracleParameter(":lxdh", OracleType.Char, 32), new OracleParameter(":bcrq", OracleType.Char, 20), new OracleParameter(":zgld", OracleType.Char, 20), new OracleParameter(":bz", OracleType.VarChar, 1024), new OracleParameter(":lrr", OracleType.Char, 20), new OracleParameter(":sn", OracleType.Char, 32) }; parms[0].Value = this.TextBoxBaoBiaoRiQi.Text.Trim(); parms[1].Value = this.TextBoxBaoBiaoBianHao.Text.Trim(); parms[2].Value = this.TextBoxBaoBiaoMingCheng.Text.Trim(); parms[3].Value = this.DropDownListBianZhiDanWei.SelectedItem.Text.Trim(); parms[4].Value = this.TextBoxQiYeFuZeRen.Text.Trim(); parms[5].Value = this.TextBoxTongJiFuZeRen.Text.Trim(); parms[6].Value = this.TextBoxTianBiaoRen.Text.Trim(); parms[7].Value = this.TextBoxLianXiDianHua.Text.Trim(); parms[8].Value = this.TextBoxBaoChuRiQi.Text.Trim(); parms[9].Value = this.TextBoxZhuGuanLingDao.Text.Trim(); parms[10].Value = this.TextBoxBeiZhu.Text.Trim(); parms[11].Value = this.TextBoxLuRuRen.Text.Trim(); parms[12].Value = this.LabelZhuJian.Text.Trim(); OracleConnection conn = new OracleConnection(OracleHelper.DatabaseConnStr); conn.Open(); OracleTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { OracleHelper.ExecuteNonQuery(trans, CommandType.Text, sqlInsert, parms); trans.Commit(); } catch (Exception ex) { trans.Rollback(); ex.ToString(); result = 0; } finally { conn.Close(); } return result; } /// <summary> /// 验证项是否正确输入 /// </summary> /// <returns></returns> private Boolean validTerm() { if (this.TextBoxBaoBiaoBianHao.Text.Length == 0) { // 错误信息提示 String tip = "报表编号不可为空"; Response.Write("<script>alert('" + tip + "')</script>"); return false; } return true; } /// <summary> /// 更新信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void UpdateInformation() { String sqlUpdate = "UPDATE baobiaoxinxi SET 报表日期=:bbrq,报表编号=:bbbh,报表名称=:bbmc,编制单位=:bzdw,企业负责人=:qyfzr,统计负责人=:tjfzr," + "填表人=:tbr,联系电话=:lxdh," + "报出日期=:bcrq,主管领导=:zgld,备注=:bz,录入人=:lrr" + " WHERE SN=:sn"; OracleParameter[] parms = { new OracleParameter(":bbrq", OracleType.Char, 10), new OracleParameter(":bbbh", OracleType.Char, 128), new OracleParameter(":bbmc", OracleType.VarChar, 512), new OracleParameter(":bzdw", OracleType.VarChar, 512), new OracleParameter(":qyfzr", OracleType.Char, 20), new OracleParameter(":tjfzr", OracleType.Char, 20), new OracleParameter(":tbr", OracleType.Char, 20), new OracleParameter(":lxdh", OracleType.Char, 32), new OracleParameter(":bcrq", OracleType.Char, 20), new OracleParameter(":zgld", OracleType.Char, 20), new OracleParameter(":bz", OracleType.VarChar, 1024), new OracleParameter(":lrr", OracleType.Char, 20), new OracleParameter(":sn", OracleType.Char, 32) }; parms[0].Value = this.TextBoxBaoBiaoRiQi.Text.Trim(); parms[1].Value = this.TextBoxBaoBiaoBianHao.Text.Trim(); parms[2].Value = this.TextBoxBaoBiaoMingCheng.Text.Trim(); parms[3].Value = this.DropDownListBianZhiDanWei.SelectedItem.Text.Trim(); parms[4].Value = this.TextBoxQiYeFuZeRen.Text.Trim(); parms[5].Value = this.TextBoxTongJiFuZeRen.Text.Trim(); parms[6].Value = this.TextBoxTianBiaoRen.Text.Trim(); parms[7].Value = this.TextBoxLianXiDianHua.Text.Trim(); parms[8].Value = this.TextBoxBaoChuRiQi.Text.Trim(); parms[9].Value = this.TextBoxZhuGuanLingDao.Text.Trim(); parms[10].Value = this.TextBoxBeiZhu.Text.Trim(); parms[11].Value = this.TextBoxLuRuRen.Text.Trim(); parms[12].Value = this.LabelZhuJian.Text.Trim(); OracleConnection conn = new OracleConnection(OracleHelper.DatabaseConnStr); conn.Open(); OracleTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { OracleHelper.ExecuteNonQuery(trans, CommandType.Text, sqlUpdate, parms); trans.Commit(); } catch (Exception ex) { trans.Rollback(); ex.ToString(); } finally { conn.Close(); } BackIndex(); } /// <summary> /// 行更新 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridViewTianJia_RowUpdating(object sender, GridViewUpdateEventArgs e) { String sqlUpdate = "UPDATE cxcs SET 编号=:bh,生产企业=:scqy,产品名称=:cpmc,计量单位=:jldw,生产量本年实际=:sclbnsj,生产量去年实际=:sclqnsj," + "销售量本年实际=:xslbnsj,销售量去年实际=:xslqnsj,库存量年初库存=:kclnckc,库存量期末库存=:kclqmkc,平均售价本年实际=:pjsjbnsj, " + "平均售价去年实际=:pjsjqnsj,产销率本年实际=:cxlbnsj,产销率去年实际=:cxlqnsj,市场占有率本年实际=:sczylbnsj," + "市场占有率去年实际=:sczylqnsj " + " WHERE SN=:sn"; OracleParameter[] parms = { new OracleParameter(":bh", OracleType.Number, 8), new OracleParameter(":scqy", OracleType.VarChar, 512), new OracleParameter(":cpmc", OracleType.VarChar, 512), new OracleParameter(":jldw", OracleType.Char, 32), new OracleParameter(":sclbnsj", OracleType.Char, 32), new OracleParameter(":sclqnsj", OracleType.Char, 32), new OracleParameter(":xslbnsj", OracleType.Char, 32), new OracleParameter(":xslqnsj", OracleType.Char, 32), new OracleParameter(":kclnckc", OracleType.Char, 32), new OracleParameter(":kclqmkc", OracleType.Char, 32), new OracleParameter(":pjsjbnsj", OracleType.Char, 32), new OracleParameter(":pjsjqnsj", OracleType.Char, 32), new OracleParameter(":cxlbnsj", OracleType.Char, 32), new OracleParameter(":cxlqnsj", OracleType.Char, 32), new OracleParameter(":sczylbnsj", OracleType.Char, 32), new OracleParameter(":sczylqnsj", OracleType.Char, 32), new OracleParameter(":sn", OracleType.Char, 32) }; parms[0].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxBianHao")).Text.Trim(); parms[1].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxShenChanQiYe")).Text.Trim(); parms[2].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxChanPinMingChen")).Text.Trim(); parms[3].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxJiLiangDanWei")).Text.Trim(); parms[4].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxShenChanLiangBenNian")).Text.Trim(); parms[5].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxShenChanLiangQuNian")).Text.Trim(); parms[6].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxXiaoShouLiangBenNian")).Text.Trim(); parms[7].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxXiaoShouLiangQuNian")).Text.Trim(); parms[8].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxKuCunLiangNianChu")).Text.Trim(); parms[9].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxKuCunLiangQiMo")).Text.Trim(); parms[10].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxPingJunShouJiaBenNian")).Text.Trim(); parms[11].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxPingJunShouJiaQuNian")).Text.Trim(); parms[12].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxChanXiaoLvBenNian")).Text.Trim(); parms[13].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxChanXiaoLvQuNian")).Text.Trim(); parms[14].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxShiChangBenNian")).Text.Trim(); parms[15].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxShiChangQuNian")).Text.Trim(); parms[16].Value = GridViewTianJia.DataKeys[e.RowIndex].Values[0].ToString().Trim(); OracleConnection conn = new OracleConnection(OracleHelper.DatabaseConnStr); conn.Open(); OracleTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { OracleHelper.ExecuteNonQuery(trans, CommandType.Text, sqlUpdate, parms); trans.Commit(); } catch (Exception ex) { trans.Rollback(); ex.ToString(); } finally { conn.Close(); } GridViewTianJia.EditIndex = -1; RecoveryGridView(); } /// <summary> /// 取消 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void LinkButtonQuXiao_Click(object sender, EventArgs e) { GridViewTianJia.EditIndex = -1; RecoveryGridView(); } /// <summary> /// 取消编辑 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridViewTianJia_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { GridViewTianJia.EditIndex = -1; RecoveryGridView(); } /// <summary> /// 绑定 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridViewTianJia_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { if (DataBinder.Eval(e.Row.DataItem, "生产量本年实际").ToString().Length != 0) { totalstock += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "生产量本年实际")); } } else if (e.Row.RowType == DataControlRowType.Footer) { e.Row.Cells[3].Text = "统计"; e.Row.Cells[3].HorizontalAlign = HorizontalAlign.Right; e.Row.Cells[7].Text = totalstock.ToString(); e.Row.Cells[7].HorizontalAlign = HorizontalAlign.Right; } } /// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridViewTianJia_RowDeleting(object sender, GridViewDeleteEventArgs e) { String sn = GridViewTianJia.DataKeys[e.RowIndex].Values[0].ToString().Trim(); String delSql = "DELETE FROM cxcs WHERE SN = '" + sn + "'"; OracleConnection conn = new OracleConnection(OracleHelper.DatabaseConnStr); conn.Open(); OracleTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { OracleHelper.ExecuteNonQuery(trans, CommandType.Text, delSql, null); trans.Commit(); } catch (Exception ex) { trans.Rollback(); ex.ToString(); } finally { conn.Close(); } GridViewTianJia.EditIndex = -1; RecoveryGridView(); } protected void GridViewTianJia_RowEditing(object sender, GridViewEditEventArgs e) { GridViewTianJia.EditIndex = e.NewEditIndex; RecoveryGridView(); } /// <summary> /// 新增一行 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ButtonXinZen_Click(object sender, EventArgs e) { String sqlInsert = "INSERT INTO cxcs(ID,编号,生产企业,产品名称,计量单位,生产量本年实际,生产量去年实际,销售量本年实际,销售量去年实际," + "库存量年初库存,库存量期末库存,平均售价本年实际,平均售价去年实际,产销率本年实际,产销率去年实际,市场占有率本年实际," + "市场占有率去年实际,SN) " + "VALUES(:id,:bh,:scqy,:cpmc,:jldw,:sclbnsj,:sclqnsj,:xslbnsj,:xslqnsj,:kclnckc,:kclqmkc,:pjsjbnsj,:pjsjqnsj,:cxlbnsj,:cxlqnsj," + ":sczylbnsj,:sczylqnsj,:sn)"; OracleParameter[] parms = { new OracleParameter(":id", OracleType.Char, 32), new OracleParameter(":bh", OracleType.Number, 8), new OracleParameter(":scqy", OracleType.VarChar, 512), new OracleParameter(":cpmc", OracleType.VarChar, 512), new OracleParameter(":jldw", OracleType.Char, 32), new OracleParameter(":sclbnsj", OracleType.Char, 32), new OracleParameter(":sclqnsj", OracleType.Char, 32), new OracleParameter(":xslbnsj", OracleType.Char, 32), new OracleParameter(":xslqnsj", OracleType.Char, 32), new OracleParameter(":kclnckc", OracleType.Char, 32), new OracleParameter(":kclqmkc", OracleType.Char, 32), new OracleParameter(":pjsjbnsj", OracleType.Char, 32), new OracleParameter(":pjsjqnsj", OracleType.Char, 32), new OracleParameter(":cxlbnsj", OracleType.Char, 32), new OracleParameter(":cxlqnsj", OracleType.Char, 32), new OracleParameter(":sczylbnsj", OracleType.Char, 32), new OracleParameter(":sczylqnsj", OracleType.Char, 32), new OracleParameter(":sn", OracleType.Char, 32) }; parms[0].Value = this.LabelZhuJian.Text.Trim(); parms[1].Value = Math.Ceiling(getMaxSeq() + 1.0); parms[2].Value = ""; parms[3].Value = ""; parms[4].Value = ""; parms[5].Value = ""; parms[6].Value = ""; parms[7].Value = ""; parms[8].Value = ""; parms[9].Value = ""; parms[10].Value = ""; parms[11].Value = ""; parms[12].Value = ""; parms[13].Value = ""; parms[14].Value = ""; parms[15].Value = ""; parms[16].Value = ""; parms[17].Value = System.Guid.NewGuid().ToString().Replace("-", ""); OracleConnection conn = new OracleConnection(OracleHelper.DatabaseConnStr); conn.Open(); OracleTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { OracleHelper.ExecuteNonQuery(trans, CommandType.Text, sqlInsert, parms); trans.Commit(); } catch (Exception ex) { trans.Rollback(); ex.ToString(); } finally { conn.Close(); } GridViewTianJia.EditIndex = -1; RecoveryGridView(); } /// <summary> /// 获取当前编号的最大值 /// </summary> /// <returns></returns> private double getMaxSeq() { double result = 1.0; String conn = OracleHelper.DatabaseConnStr; String queryBiaoTou = "SELECT MAX(编号) FROM cxcs WHERE ID='" + LabelZhuJian.Text.Trim() + "' "; OracleDataReader drBiaoTou = OracleHelper.ExecuteReader(conn, CommandType.Text, queryBiaoTou, null); while (drBiaoTou.Read()) { result = drBiaoTou.GetDouble(0); } drBiaoTou.Close(); return result; } /// <summary> /// 导出到Excel /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ButtonExcel_Click(object sender, EventArgs e) { Response.ClearContent(); string fileName = Server.UrlEncode("主要产品产销存统计表.xls"); Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName); Response.ContentType = "application/excel"; StringWriter sw = new StringWriter(); ExportHead(); HtmlTextWriter htw = new HtmlTextWriter(sw); // 去除第1第2列 GridViewTianJia.Columns[0].Visible = false; GridViewTianJia.Columns[1].Visible = false; GridViewTianJia.RenderControl(htw); Response.Write(sw); ExportFoot(); Response.End(); } /// <summary> /// 导出表头 /// </summary> private void ExportHead() { String conn = OracleHelper.DatabaseConnStr; String queryBiaoTou = "SELECT * FROM baobiaoxinxi WHERE SN='"+ LabelZhuJian.Text.Trim()+ "' "; OracleDataReader drBiaoTou = OracleHelper.ExecuteReader(conn, CommandType.Text, queryBiaoTou, null); while (drBiaoTou.Read()) { Response.Write("<table><tr><td>报表日期:</td><td>" + drBiaoTou.GetString(0)+"</td></tr>"); Response.Write("<table><tr><td>报表编号:</td><td>" + drBiaoTou.GetString(1)+"</td></tr></table>"); Response.Write("<table><tr><td>报表名称:</td><td>" + drBiaoTou.GetString(2) + "</td></tr></table>"); Response.Write("<table><tr><td>编制单位:</td><td>" + drBiaoTou.GetString(3) + "</td></tr></table>"); Response.Write("<table><tr><td>企业负责人:</td><td>" + drBiaoTou.GetString(4) + "</td></tr></table>"); Response.Write("<table><tr><td>统计负责人:</td><td>" + drBiaoTou.GetString(5) + "</td></tr></table>"); Response.Write("<table><tr><td>填表人:</td><td>" + drBiaoTou.GetString(6) + "</td></tr></table>"); Response.Write("<table><tr><td>联系电话:</td><td>" + drBiaoTou.GetString(7) + "</td></tr></table>"); Response.Write("<table><tr><td>报出日期:</td><td>" + drBiaoTou.GetString(8) + "</td></tr></table>"); Response.Write("<table><tr><td>主管领导:</td><td>" + drBiaoTou.GetString(9) + "</td></tr></table>"); Response.Write("<table><tr><td>备注:</td><td>" + drBiaoTou.GetString(10) + "</td></tr></table>"); Response.Write("<table><tr><td>录入人:</td><td>" + drBiaoTou.GetString(11) + "</td></tr></table>"); Response.Write("<br> "); } drBiaoTou.Close(); } /// <summary> /// 导出表尾 /// </summary> private void ExportFoot() { // 示例 // Response.Write("<table><tr><td>单位负责人:</td><td> </td><td>统计负责人:</td><td></td><td>填报人:</td></tr></table>"); } /// <summary> /// 必须要的 /// </summary> /// <param name="control"></param> public override void VerifyRenderingInServerForm(Control control) { } protected void ButtonClear_Click(object sender, EventArgs e) { String delStr = "生产企业 is null "; String delSql = "DELETE FROM cxcs WHERE ID = '" + this.LabelZhuJian.Text.Trim() + "' AND " + delStr; OracleConnection conn = new OracleConnection(OracleHelper.DatabaseConnStr); conn.Open(); OracleTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { OracleHelper.ExecuteNonQuery(trans, CommandType.Text, delSql, null); trans.Commit(); } catch (Exception ex) { trans.Rollback(); ex.ToString(); } finally { conn.Close(); } GridViewTianJia.EditIndex = -1; RecoveryGridView(); } /// <summary> /// 恢复GridView显示 /// </summary> private void RecoveryGridView() { // 初始化默认Gridview的SQL语句 String querySql = "SELECT ID,编号,生产企业,产品名称,计量单位,生产量本年实际,生产量去年实际,销售量本年实际,销售量去年实际," + "库存量年初库存,库存量期末库存,平均售价本年实际,平均售价去年实际,产销率本年实际,产销率去年实际,市场占有率本年实际," + "市场占有率去年实际,SN" + " FROM cxcs WHERE ID='" + this.LabelZhuJian.Text.Trim() + "' ORDER BY 编号"; fillGridViewTianJia(querySql); } /// <summary> /// 计算 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ButtonCal_Click(object sender, EventArgs e) { GridViewTianJia.FooterRow.Visible = true; } /// <summary> /// 查看按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ButtonChaKan_Click(object sender, EventArgs e) { if (this.GridViewXinXiLan.SelectedRow != null) { this.LabelZhuJian.Text = this.GridViewXinXiLan.DataKeys[this.GridViewXinXiLan.SelectedRow.RowIndex][0].ToString(); this.MenuCaidan.Items[2].Enabled = true; MenuCaidan.Items[2].Selected = true; MultiViewXinXiGuanLi.ActiveViewIndex = 2; LabelReportTitle.Text = this.GridViewXinXiLan.Rows[this.GridViewXinXiLan.SelectedRow.RowIndex].Cells[4].Text.ToString(); RecoveryGridView(); hiddenButton(); } else { // 错误信息提示 String tip = "请选择行!"; Response.Write("<script>alert('" + tip + "')</script>"); } } /// <summary> /// 隐藏按钮 /// </summary> private void hiddenButton() { // 隐藏前2列 GridViewTianJia.Columns[0].Visible = false; GridViewTianJia.Columns[1].Visible = false; ButtonXinZen.Visible = false; ButtonXinZen.Enabled = false; ButtonClear.Visible = false; ButtonClear.Enabled = false; } /// <summary> /// 显示按钮 /// </summary> private void showButton() { GridViewTianJia.Columns[0].Visible = true; GridViewTianJia.Columns[1].Visible = true; ButtonXinZen.Visible = true; ButtonXinZen.Enabled = true; ButtonClear.Visible = true; ButtonClear.Enabled = true; }}

3 演示效果

下次贴

专利

最新回复(0)