日期:2014-05-16 浏览次数:21375 次
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using Calculate_Time.Compents;
namespace Fcc_Sales_Web.Cai_Wu
{
public partial class CW_Reconciliation : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataGridDataBind();//绑定数据
}
Check_All.Checked = false;
}
private void DataGridDataBind()
{
string utime = DateTime.Now.ToString("dd");//获取当前日期
string strSQL = "";
strSQL = "select Recon_date,Cust_NO, Cust_Name "+
"from Cust_Recon " +
"where Recon_date >= '" + utime + "' and Recon_date <= '" + utime + "'+2 and Recon_state = '"+DropDownList1.SelectedValue+"' " +
"order by Cust_Name ";
DataTable dt = new DataTable();
dt = SQL.GetVATTable(strSQL);
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void Check_CheckedChanged(object sender, EventArgs e)
{
List<string