?? orderprint.aspx.cs
字號:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;
using System.Diagnostics ;
using CounterManage.Components;
using CrystalDecisions.CrystalReports.Engine ;
using CrystalDecisions.Shared ;
namespace netorder
{
/// <summary>
/// OrderPrint 的摘要說明。
/// </summary>
public class OrderPrint : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.Label Label4;
protected System.Web.UI.WebControls.TextBox TextBox3;
protected System.Web.UI.WebControls.RadioButton RadioButton1;
protected System.Web.UI.WebControls.RadioButton RadioButton2;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.TextBox TextBox4;
protected System.Web.UI.WebControls.TextBox TextBox5;
protected System.Web.UI.WebControls.Label Label6;
protected System.Web.UI.WebControls.TextBox TextBox6;
protected System.Web.UI.WebControls.Label Label7;
protected System.Web.UI.WebControls.ListBox ListBox2;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.Button Button2;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.Label Label1;
private DataTable myTable,myTable1;
private DataRow myRow,myRow1;
protected System.Web.UI.WebControls.Label Label8;
protected System.Web.UI.WebControls.RadioButton RadioButton3;
protected System.Web.UI.WebControls.RadioButton RadioButton4;
protected System.Web.UI.WebControls.RadioButton RadioButton5;
protected System.Web.UI.WebControls.DataGrid DataGrid2;
protected System.Web.UI.WebControls.Button Button3;
protected System.Web.UI.WebControls.Label Label9;
protected System.Web.UI.WebControls.TextBox Textbox7;
protected System.Web.UI.WebControls.ListBox ListBox3;
protected string strRes ;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此處放置用戶代碼以初始化頁面
string temp;
string EndDate,BeginDate;
temp = Session["UserId"].ToString().Trim();
if(temp.Length == 0 )
{
Response.Redirect(@"Login.aspx");
return;
}
if (!IsPostBack)
{
SqlConnection thisConnection = new SqlConnection(Session["connStr"].ToString() );
thisConnection.Open();
String MdType = "",QueryTxt = "";
MdType = Session["OrderType"].ToString().Trim();
//付值店鋪
QueryTxt = " select NA from [SYSTEM] where IDCO = '001' and CO= '" + Session["WebShop"] +"'";
SqlDataAdapter thisAdapter = new SqlDataAdapter(
QueryTxt,thisConnection);
DataSet ds = new DataSet();
thisAdapter.Fill(ds,"webshop");
this.myTable = ds.Tables[0];
for (int i = 0; i <myTable.Rows.Count; i++)
{
String shopna = "" ;
myRow = myTable.Rows[i];
shopna = myRow[0].ToString().Trim();
this.TextBox1.Text = shopna;
//this.DropDownList1.Items[i].Text = shopna;
}
//付值管理部
String TXTwebshop;
TXTwebshop = Session["Shop"].ToString().Trim();
TXTwebshop = TXTwebshop.Substring(1,1);
QueryTxt = " select NA from [SYSTEM] where IDCO = '002' and CO= '0" + TXTwebshop +"'";
SqlDataAdapter thisAdapter1 = new SqlDataAdapter(
QueryTxt,thisConnection);
DataSet ds1 = new DataSet();
thisAdapter1.Fill(ds1,"shop");
this.myTable1 = ds1.Tables[0];
for (int j = 0; j <myTable1.Rows.Count; j++)
{
String shopna = "" ;
myRow1 = myTable1.Rows[j];
shopna = myRow1[0].ToString().Trim().Substring(0,2) + "課";
this.TextBox2.Text = shopna;
}
QueryTxt = "SELECT Convert(char(10),Getdate(),126)";
thisAdapter = new SqlDataAdapter(
QueryTxt,thisConnection);
ds = new DataSet();
thisAdapter.Fill(ds,"BeginDate");
this.myTable = ds.Tables[0];
this.myRow = this.myTable.Rows[0];
BeginDate = this.myRow[0].ToString().Substring(0,8) + "01" ;
EndDate = this.myRow[0].ToString().Trim() ;
this.TextBox5.Text = BeginDate;
this.TextBox6.Text = EndDate;
QueryTxt = Refresh_list();
QueryTxt = GetSql(QueryTxt) + " Order by A.OrderNO";
thisAdapter = new SqlDataAdapter(
QueryTxt,thisConnection);
ds = new DataSet();
thisAdapter.Fill(ds,"MdCashOrderList");
this.DataGrid1.DataSource = ds.Tables["MdCashOrderList"].DefaultView ;
this.DataGrid1.DataBind();
thisConnection.Close();
}
//付值訂貨單編號
}
private string Refresh_list()
{
string MdSql;
MdSql = "SELECT A.OrderNO,A.StoCo,A.StoNA,A.ItCo,A.ItNA,A.STD,A.Sell,A.OrderQut,Convert(Dec(18,2),(A.Sell * A.OrderQut * A.OrdUN)) Amount, " +
" A.OrderDate,A.ReceiveDate,A.Cost,A.CreateDate, " +
" A.UpdateDate,A.PageNO,A.[LineNO],A.UserName,A.ITDECO,A.alertflag,A.OrdUN,A.PaymentNo, (case when A.Status = '0' then '基礎' else '追加' end) StatusName," +
" (case A.ConfirmFlag when '0' then '開單' " +
" when '1' then '課長確認' " +
" when '2' then '店鋪部長確認' " +
" when '3' then '本部部長確認' " +
" when '4' then '勾對' " +
" when '9' then '作廢' " +
" else '結束' " +
" end) flag " +
" FROM CashOrder A, " +
" userMaster B " +
" WHERE A.UserId = B.UserID " +
" AND A.OrderQut > 0 ";
return MdSql;
}
private string Refresh_sum()
{
string MdSql;
MdSql = " SELECT A.ItCo,A.ItNA,A.STD,A.OrdUN,SUM(A.OrderQut) OrderQut,Convert(Dec(18,2),SUM(A.Sell * A.OrderQut * A.OrdUN)) SellAmount, " +
" SUM(A.Cost * A.OrderQut * A.OrdUN) CostAmount " +
" FROM CashOrder A, " +
" userMaster B" +
" WHERE A.UserId = B.UserID " ;
return MdSql ;
}
#region Web 窗體設計器生成的代碼
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
private void InitializeComponent()
{
this.Button3.Click += new System.EventHandler(this.Button3_Click);
this.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
this.Button2.Click += new System.EventHandler(this.Button2_Click);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void NAR(Object o)
{
try{System.Runtime.InteropServices.Marshal.ReleaseComObject(o);}
catch{}
finally{o = null;}
}
private void Button1_Click(object sender, System.EventArgs e)
{
string MdSql,GroupSql,tablename,Rptname;
ReportDocument rpt ;
ModuleFun MFun = new ModuleFun();
//初始化數據窗口，同時獲取查詢數據的基本SQL
if(this.RadioButton1.Checked == true)
{
this.DataGrid1.Visible = true;
this.DataGrid2.Visible = false;
MdSql = Refresh_list() ;
GroupSql = "" ;
tablename = "OrderList";
Rptname = "OrderListRpt.rpt";
}
else
{
this.DataGrid1.Visible = false;
this.DataGrid2.Visible = true;
MdSql = Refresh_sum();
GroupSql = " GROUP BY A.ItCo,A.ItNA,A.STD,A.OrdUN HAVING SUM(A.OrderQut) > 0 " ;
tablename = "OrderSum";
Rptname = "OrderSumRpt.rpt";
}
//為拼SQL做準備
MdSql = GetSql(MdSql);
if (GroupSql != "")
{
MdSql = MdSql + GroupSql;
}
else
{
MdSql = MdSql + " Order by A.OrderNO" ;
}
SqlConnection thisConn = new SqlConnection(Session["connStr"].ToString());
thisConn.Open();
SqlDataAdapter thisAdapter = new SqlDataAdapter(MdSql,thisConn);
DataSet ds = new DataSet();
thisAdapter.Fill(ds,tablename);
rpt =MFun.GetReportDocument(MFun.GetReportPath(this, Rptname), ds);
this.Session["frmPreview_rpt"] = rpt;
//dayin
strRes = MFun.GetOpenCheckStr();
}
private void Button2_Click(object sender, System.EventArgs e)
{
string MdSql,GroupSql;
int Message;
//初始化數據窗口，同時獲取查詢數據的基本SQL
if(this.RadioButton1.Checked == true)
{
this.DataGrid1.Visible = true;
this.DataGrid2.Visible = false;
MdSql = Refresh_list() ;
GroupSql = "" ;
Message = 1;
}
else
{
this.DataGrid1.Visible = false;
this.DataGrid2.Visible = true;
MdSql = Refresh_sum();
GroupSql = " GROUP BY A.ItCo,A.ItNA,A.STD,A.OrdUN HAVING SUM(A.OrderQut) > 0 " ;
Message = 2;
}
//為拼SQL做準備
MdSql = GetSql(MdSql);
if (GroupSql != "")
{
MdSql = MdSql + GroupSql;
}
else
{
MdSql = MdSql + " Order by A.OrderNO" ;
}
SqlConnection thisConnection = new SqlConnection(Session["connStr"].ToString() );
thisConnection.Open();
SqlDataAdapter thisAdapter2 = new SqlDataAdapter(
MdSql,thisConnection);
DataSet ds2 = new DataSet();
thisAdapter2.Fill(ds2,"ReportDsi");
if(Message == 1 )
{
this.DataGrid1.DataSource = ds2.Tables["ReportDsi"].DefaultView ;
this.DataGrid1.DataBind();
}
else
{
this.DataGrid2.DataSource = ds2.Tables["ReportDsi"].DefaultView ;
this.DataGrid2.DataBind();
}
thisConnection.Close();
}
private string GetSql(string textSql)
{
string txtTemp,FiledTemp;
//首先判斷當前登入人員的身份，店鋪人員只能看本店鋪的訂貨信息，本部人員只能看到代開的訂貨信息。
txtTemp = Session["Shop"].ToString().Trim();
txtTemp = txtTemp.Substring(0,1);
//textSql = textSql + " AND Right(A.ITDECO,1) = '"+ Session["WebShop"].ToString().Trim().Substring(1,1) +"'";
if(txtTemp == "1")
{
//說明是本部人員，則只要服務部相同就可以
textSql = textSql + " AND A.ITDECO = '"+ Session["Shop"].ToString().Trim() +"' ";
}
else
{
//說明是店鋪人員,不但服務部開頭必須為0，還需要是同店鋪的信息才能顯示
textSql = textSql + " AND (LEFT(A.ITDECO,1) = '0' AND A.StoCo = '"+ Session["WebShop"].ToString().Trim() +"')";
}
//輸入的查詢條件
//訂貨單信息
txtTemp = this.TextBox3.Text ;
if (txtTemp != "")
{
//輸入了訂貨單信息的查詢條件
textSql = textSql + " AND A.IndentNo = '"+ txtTemp +"'";
}
//申請單號信息
txtTemp = this.Textbox7.Text ;
if (txtTemp != "")
{
textSql = textSql + " AND A.PaymentNo = '"+ txtTemp +"'";
}
//廠商輸入的為代碼
txtTemp = this.TextBox4.Text ;
if(txtTemp != "")
{
//輸入了廠商查詢信息
textSql = textSql + " AND ((case when isnull(A.CmpNA,'') = '' then A.CmpABBV else A.CmpNA end) = '"+ txtTemp +"' or (case when isnull(A.CmpNA,'') = '' then A.CmpCo else A.CmpNA end) = '"+ txtTemp +"')";
}
//時間條件
//首先判斷是那個字段要進行查詢
FiledTemp = "";
if (this.RadioButton3.Checked ==true)
{
//制單日期
FiledTemp = " Convert(char(10),A.CreateDate,126) ";
}
if(this.RadioButton4.Checked == true )
{
//訂貨日期
FiledTemp = " Convert(char(10),A.OrderDate,126) ";
}
if(this.RadioButton5.Checked == true )
{
//確認日期
FiledTemp = " Convert(char(10),A.ConfirmDate,126) ";
}
if(FiledTemp == "" )
{
return "";
}
txtTemp = this.TextBox5.Text ;
if(txtTemp != "")
{
//起始時間
textSql = textSql + " AND " + FiledTemp + " >= '" + txtTemp + "' ";
}
txtTemp = this.TextBox6.Text ;
if(txtTemp != "")
{
//結束時間
textSql = textSql + " AND " + FiledTemp + " <= '" + txtTemp + "' ";
}
//狀態條件
txtTemp = this.ListBox2.SelectedValue ;
if(txtTemp != "-1" && txtTemp != "" ) textSql = textSql + " and A.ConfirmFlag = '"+ txtTemp + "'" ;
//金額差異條件
txtTemp = this.ListBox3.SelectedValue ;
if(txtTemp != "0" && txtTemp != "")
{
if(txtTemp == "1")
{
textSql = textSql + " and (IsNull(A.InvoiceNo,'') in (select InvoiceNo from InvoiceTable where IsNull(Invoice_Amount,0) <> IsNull(Finish_Amount,0))) " ;
}
else
{
textSql = textSql + " and (IsNull(A.InvoiceNo,'') in (select InvoiceNo from InvoiceTable where IsNull(Invoice_Amount,0) = IsNull(Finish_Amount,0)))" ;
}
}
return textSql;
}
private void Button3_Click(object sender, System.EventArgs e)
{
Response.Redirect(@"main.aspx");
}
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -