常见的C#窗体间的传值(二)
来源:互联网 发布:大学宿舍淘宝店 编辑:程序博客网 时间:2024/06/14 12:44
using Suiyi.SH.Common;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using XM.OA.Model;
namespace XM.OA.Office.Report
{
public partial class FormCoatDeliveryOrdersPrint : Form
{
public string BeginOrderDate;
public string EndOrderDate;
public string TranNo;
public string OrderNo;
public FormCoatDeliveryOrdersPrint(string _BeginOrderDate, string _EndOrderDate, string _TranNo, string _OrderNo)
{
InitializeComponent();
this.BeginOrderDate = _BeginOrderDate;
this.EndOrderDate = _EndOrderDate;
this.TranNo = _TranNo;
this.OrderNo = _OrderNo;
}
private void FormCoatDeliveryOrdersPrint_Load(object sender, EventArgs e)
{
Microsoft.Reporting.WinForms.ReportDataSource reportDeliveryOrdersPrintDataSource = new Microsoft.Reporting.WinForms.ReportDataSource();
reportDeliveryOrdersPrintDataSource.Name = "dataSetDeliveryOrders";
reportDeliveryOrdersPrintDataSource.Value = this.dataSetDeliveryOrdersBindingSource;
this.rvCoatDeliveryOrdersPrint.LocalReport.DataSources.Clear();
this.rvCoatDeliveryOrdersPrint.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSetDeliveryOrders", GetList()));
//显示报表
this.rvCoatDeliveryOrdersPrint.RefreshReport();
}
/// <summary>
/// 获取打印的数据源
/// </summary>
/// <returns></returns>
private List<OrdersDeliveryPrintModel> GetList()
{
//创建数据库连接
DBHelper dbhelper = new DBHelper();
dbhelper.OpenConnection();
string sqlDeliveryOrdersPrint = string.Format("select s.OrderNo,h.Fabric,h.MaterialUnit,s.IsCustomerUrgent,s.CuttingMember ,h.Technology,h.Quantity from Orders s join OrdersCoats h on h.OrderID =s.OrderID where s.OrderDate between '{0}'and '{1}' and s.OrderStatus ='90' and s.DeliveryDate <='{2}' and s.OrderNo <>N'' and h.Technology <>N'' order by s.DeliveryDate desc ",BeginOrderDate, EndOrderDate,DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
dbhelper.OpenConnection();
SqlCommand cmdDeliveryOrdersPrint = new SqlCommand(sqlDeliveryOrdersPrint, dbhelper.Connection);
SqlDataAdapter da = new SqlDataAdapter(cmdDeliveryOrdersPrint);
DataTable table = new DataTable();
da.Fill(table);
dbhelper.CloseConnection();
List<OrdersDeliveryPrintModel> list = new List<OrdersDeliveryPrintModel>();
OrdersDeliveryPrintModel deliveryOrders = null;
foreach (DataRow row in table.Rows)
{
deliveryOrders = new OrdersDeliveryPrintModel();
if (row.Table.Columns.Contains("OrderNo") && row["OrderNo"] != null && row["OrderNo"].ToString() != "")
{
deliveryOrders.OrderNo = row["OrderNo"].ToString();
}
if (row.Table.Columns.Contains("Fabric") && row["Fabric"] != null && row["Fabric"].ToString() != "")
{
deliveryOrders.Fabric = row["Fabric"].ToString();
}
if (row.Table.Columns.Contains("MaterialUnit") && row["MaterialUnit"] != null && row["MaterialUnit"].ToString() != "")
{
deliveryOrders.MaterialUnit = Convert.ToInt32(row["MaterialUnit"]);
}
if (row.Table.Columns.Contains("IsCustomerUrgent") && row["IsCustomerUrgent"] != null && row["IsCustomerUrgent"].ToString() != "")
{
deliveryOrders.IsCustomerUrgent = row["IsCustomerUrgent"].ToString();
}
if (row.Table.Columns.Contains("CuttingMember") && row["CuttingMember"] != null && row["CuttingMember"].ToString() != "")
{
deliveryOrders.CuttingMember = Convert.ToInt32(row["CuttingMember"]);
}
if (row.Table.Columns.Contains("Technology") && row["Technology"] != null && row["Technology"].ToString() != "")
{
deliveryOrders.Technology = row["Technology"].ToString();
}
if (row.Table.Columns.Contains("Quantity") && row["Quantity"] != null && row["Quantity"].ToString() != "")
{
deliveryOrders.Quantity = Convert.ToInt32(row["Quantity"]);
}
list.Add(deliveryOrders);
}
return list;
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using XM.OA.Model;
namespace XM.OA.Office.Report
{
public partial class FormCoatDeliveryOrdersPrint : Form
{
public string BeginOrderDate;
public string EndOrderDate;
public string TranNo;
public string OrderNo;
public FormCoatDeliveryOrdersPrint(string _BeginOrderDate, string _EndOrderDate, string _TranNo, string _OrderNo)
{
InitializeComponent();
this.BeginOrderDate = _BeginOrderDate;
this.EndOrderDate = _EndOrderDate;
this.TranNo = _TranNo;
this.OrderNo = _OrderNo;
}
private void FormCoatDeliveryOrdersPrint_Load(object sender, EventArgs e)
{
Microsoft.Reporting.WinForms.ReportDataSource reportDeliveryOrdersPrintDataSource = new Microsoft.Reporting.WinForms.ReportDataSource();
reportDeliveryOrdersPrintDataSource.Name = "dataSetDeliveryOrders";
reportDeliveryOrdersPrintDataSource.Value = this.dataSetDeliveryOrdersBindingSource;
this.rvCoatDeliveryOrdersPrint.LocalReport.DataSources.Clear();
this.rvCoatDeliveryOrdersPrint.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSetDeliveryOrders", GetList()));
//显示报表
this.rvCoatDeliveryOrdersPrint.RefreshReport();
}
/// <summary>
/// 获取打印的数据源
/// </summary>
/// <returns></returns>
private List<OrdersDeliveryPrintModel> GetList()
{
//创建数据库连接
DBHelper dbhelper = new DBHelper();
dbhelper.OpenConnection();
string sqlDeliveryOrdersPrint = string.Format("select s.OrderNo,h.Fabric,h.MaterialUnit,s.IsCustomerUrgent,s.CuttingMember ,h.Technology,h.Quantity from Orders s join OrdersCoats h on h.OrderID =s.OrderID where s.OrderDate between '{0}'and '{1}' and s.OrderStatus ='90' and s.DeliveryDate <='{2}' and s.OrderNo <>N'' and h.Technology <>N'' order by s.DeliveryDate desc ",BeginOrderDate, EndOrderDate,DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
dbhelper.OpenConnection();
SqlCommand cmdDeliveryOrdersPrint = new SqlCommand(sqlDeliveryOrdersPrint, dbhelper.Connection);
SqlDataAdapter da = new SqlDataAdapter(cmdDeliveryOrdersPrint);
DataTable table = new DataTable();
da.Fill(table);
dbhelper.CloseConnection();
List<OrdersDeliveryPrintModel> list = new List<OrdersDeliveryPrintModel>();
OrdersDeliveryPrintModel deliveryOrders = null;
foreach (DataRow row in table.Rows)
{
deliveryOrders = new OrdersDeliveryPrintModel();
if (row.Table.Columns.Contains("OrderNo") && row["OrderNo"] != null && row["OrderNo"].ToString() != "")
{
deliveryOrders.OrderNo = row["OrderNo"].ToString();
}
if (row.Table.Columns.Contains("Fabric") && row["Fabric"] != null && row["Fabric"].ToString() != "")
{
deliveryOrders.Fabric = row["Fabric"].ToString();
}
if (row.Table.Columns.Contains("MaterialUnit") && row["MaterialUnit"] != null && row["MaterialUnit"].ToString() != "")
{
deliveryOrders.MaterialUnit = Convert.ToInt32(row["MaterialUnit"]);
}
if (row.Table.Columns.Contains("IsCustomerUrgent") && row["IsCustomerUrgent"] != null && row["IsCustomerUrgent"].ToString() != "")
{
deliveryOrders.IsCustomerUrgent = row["IsCustomerUrgent"].ToString();
}
if (row.Table.Columns.Contains("CuttingMember") && row["CuttingMember"] != null && row["CuttingMember"].ToString() != "")
{
deliveryOrders.CuttingMember = Convert.ToInt32(row["CuttingMember"]);
}
if (row.Table.Columns.Contains("Technology") && row["Technology"] != null && row["Technology"].ToString() != "")
{
deliveryOrders.Technology = row["Technology"].ToString();
}
if (row.Table.Columns.Contains("Quantity") && row["Quantity"] != null && row["Quantity"].ToString() != "")
{
deliveryOrders.Quantity = Convert.ToInt32(row["Quantity"]);
}
list.Add(deliveryOrders);
}
return list;
}
}
}
0 0
- 常见的C#窗体间的传值(二)
- 常见的C#窗体间的传值(一)
- C#中常见的窗体属性
- c#窗体间的传值
- c#窗体间的传值_winvay
- C# 窗体间的传值
- c#窗体间的传值
- C# windows窗体间的传值
- C#中winform窗体的美化控件 iriskin(二)
- C#对象间的协作和信息交换(二)主窗体向从窗体传递消息
- c#不同窗体传值的问题
- c# 两个窗体之间的传值
- c#父子窗体的传值
- c#窗体间的函数传递值
- C#多项目间的窗体调用和传值
- C#利用子窗体中的构造函数 (实现了父窗体给子窗体的传值,但是子窗体的值回传暂未实现)
- C#程序设计(二十七)----创建一个如下的窗体,并在窗体上放置一个标签、一个treeviw控件
- C# winform 用子窗体刷新父窗体,子窗体改变父窗体控件的值
- iOS通知的实现
- replaceAll和replace的替换差别
- scrapy安装
- 【REST】REST、RESTFUL的理解以及SpringMVC实现Restful编程
- 如何调试nutch
- 常见的C#窗体间的传值(二)
- CCS5.5.0的include路径和lib路径的配置
- matlab学习笔记(二)---三维图形的绘制
- MyEclipse中xml的区别xml(advanced Templates)、xml(Basic Templates)、xml schema
- FTP上传经常中断处理方法
- iOS网络
- Android-性能优化之电量篇
- Ubuntu14.04编译Allwinner lichee 两个出错解决方法
- Android Adapter 详解