?? kjkmid.aspx.cs
字號(hào):
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
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 com.unicafe.ui;
using com.unicafe.common;
using com.unicafe.security;
using com.ascs.plp.publics;
using Com.Ascs.Plp.Cw.Publics;
namespace com.ascs.plp.publics
{
/// <summary>
/// KJKMID 的摘要說(shuō)明。
/// </summary>
public class KJKMID : com.unicafe.ui.UnicafePage
{
protected System.Web.UI.WebControls.CheckBox CheckBox1;
protected System.Web.UI.WebControls.CheckBox CheckBox2;
protected System.Web.UI.WebControls.CheckBox CheckBox3;
protected System.Web.UI.WebControls.CheckBox CheckBox4;
protected System.Web.UI.WebControls.TextBox TextBox3;
protected System.Web.UI.WebControls.TextBox TextBox4;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected string sql,KJNDStatement,KMLBStatement,KMBMStatement,KMMCStatement,MJKMStatement,EnableLimit;
protected System.Web.UI.WebControls.LinkButton LinkButton1;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.DropDownList DropDownList1;
protected System.Web.UI.WebControls.DropDownList DropDownList2;
protected System.Web.UI.WebControls.Label Label3;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此處放置用戶(hù)代碼以初始化頁(yè)面
this.VerifyPage();
if (!this.IsPostBack)
{
//獲取控件名參數(shù)值，如沒(méi)有則提示后退出
ViewState["ControlName"] = this.Request.QueryString["ControlName"];
if(ViewState["ControlName"] == null)
{
Prompt.PromptError(this,"缺少參數(shù) [父窗口用于接收返回值的輸入框控件名] ！");
this.Response.Write("<script language=javascript>window.close();</script>");
return;
}
//給下拉列表框賦初值
Com.Ascs.Plp.Cw.Publics.CwInfo cwinfo = new CwInfo(this);
cwinfo.LocateKJND(DropDownList1, this.CurrentJGXX.JGDM);
//決定會(huì)計(jì)年度的限制模式
if(this.Request.QueryString["KJND"] == "")
{
//Prompt.PromptMessage(this, "不限制會(huì)計(jì)年度！");
}
else if(this.Request.QueryString["KJND"] == "NOW" || this.Request.QueryString["KJND"] == null)
{
CheckBox1.Enabled = false;
DropDownList1.Enabled = false;
//Prompt.PromptMessage(this, "限制為當(dāng)前會(huì)計(jì)年度！");
}
else
{
CheckBox1.Enabled = false;
DropDownList1.Enabled = false;
CommonService.LocateDropDownList(DropDownList1,this.Request.QueryString["KJND"]);
//Prompt.PromptMessage(this, "限制為" + this.Request.QueryString["KJND"] +"會(huì)計(jì)年度！");
}
// 給綁定DataGrid控件的SQL語(yǔ)句進(jìn)行賦值（注意，SQL語(yǔ)句賦值之后不要再修改）
ViewState["sql"] = "Select LBMC=" +
"(Case When LB='1' Then '資產(chǎn)' When LB='2' Then '負(fù)債' When LB='3' Then '權(quán)益' When LB='4' Then '成本' When LB='5' Then '損益' End), " +
"KMBM, KMMC From CW_KJKM Where KMBM is Null ";
string sql = ViewState["sql"].ToString();
//處理DataGrid控件（綁定DataGrid控件 -> 檢查是否需要定位 -> 給導(dǎo)航文本賦值）
if(CommonService.HandleDataGrid(this, sql, DataGrid1, "Data2", Label1, Label2, Label3) == false)
Prompt.PromptError(this,"在處理數(shù)據(jù)時(shí)發(fā)生錯(cuò)誤。");
}
else
{
//檢查回發(fā)的請(qǐng)求操作是否是要進(jìn)入上頁(yè)或下頁(yè)
if(CommonService.PageNavigate(this, DataGrid1, "Data2", Label1, Label2, Label3) == false)
Prompt.PromptError(this,"在處理數(shù)據(jù)時(shí)發(fā)生錯(cuò)誤。");
}
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN：該調(diào)用是 ASP.NET Web 窗體設(shè)計(jì)器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 設(shè)計(jì)器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內(nèi)容。
/// </summary>
private void InitializeComponent()
{
this.CheckBox1.CheckedChanged += new System.EventHandler(this.CheckBox1_CheckedChanged);
this.CheckBox2.CheckedChanged += new System.EventHandler(this.CheckBox2_CheckedChanged);
this.CheckBox3.CheckedChanged += new System.EventHandler(this.CheckBox3_CheckedChanged);
this.CheckBox4.CheckedChanged += new System.EventHandler(this.CheckBox4_CheckedChanged);
this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound);
this.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
this.LinkButton1.Click += new System.EventHandler(this.LinkButton1_Click);
this.ID = "KJKMID";
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 查詢(xún)事件處理函數(shù)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void LinkButton1_Click(object sender, System.EventArgs e)
{
BindGrid();
}
/// *****************************************************************************
/// END
/// *****************************************************************************
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 與DataGrid1綁定數(shù)據(jù)
/// </summary>
/// *****************************************************************************
private void BindGrid()
{
//根據(jù)選擇的條件進(jìn)行查詢(xún)條件的組合和生成
sql = "Select LBMC=" +
"(Case When LB='1' Then '資產(chǎn)' When LB='2' Then '負(fù)債' When LB='3' Then '權(quán)益' When LB='4' Then '成本' When LB='5' Then '損益' End), " +
"KMBM, KMMC From CW_KJKM Where 1=1 ";
if (CheckBox1.Checked == true && DropDownList1.SelectedItem.Value != "-- 會(huì)計(jì)年度 --")
{
KJNDStatement = "And KJND = '" + DropDownList1.SelectedItem.Value +"' ";
}
else
{
Prompt.PromptAlert(this,"請(qǐng)選擇會(huì)計(jì)年度！");
return;
}
if (CheckBox2.Checked == true && DropDownList2.SelectedItem.Value != "0")
{
KMLBStatement = "And LB = '" + DropDownList2.SelectedItem.Value +"' ";
}
else
{
KMLBStatement = "";
}
if (CheckBox3.Checked == true && TextBox3.Text.Trim() != "")
{
KMBMStatement = "And KMBM Like '%" + TextBox3.Text + "%' ";;
}
else
{
KMBMStatement = "";
}
if (CheckBox4.Checked == true && TextBox4.Text.Trim() != "")
{
KMMCStatement = "And KMMC Like '%" + TextBox4.Text + "%' ";
}
else
{
KMMCStatement = "";
}
if(this.Request.QueryString["MJKM"] == "T")
{
MJKMStatement = "And SFMX = '1' ";
}
else if(this.Request.QueryString["MJKM"] == "F")
{
MJKMStatement = "And SFMX = '0' ";
}
else
{
MJKMStatement = "";
}
if(this.Request.QueryString["EnableLimit"] != "F")
{
EnableLimit = "And TYBJ = '0'";
}
else
{
EnableLimit = "";
}
ViewState["sql"] = sql + KJNDStatement + KMLBStatement + KMBMStatement + KMMCStatement + MJKMStatement + EnableLimit + " Order By LB,KMBM";
sql = ViewState["sql"].ToString();
//處理DataGrid控件（綁定DataGrid控件 -> 給導(dǎo)航文本賦值）
if(CommonService.ReBindDataGrid(this, sql, DataGrid1, "Data2", Label1, Label2, Label3) == false)
Prompt.PromptError(this,"在處理數(shù)據(jù)時(shí)發(fā)生錯(cuò)誤。");
}
/// *****************************************************************************
/// END
/// *****************************************************************************
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 為數(shù)據(jù)行添加對(duì)鼠標(biāo)移動(dòng)的響應(yīng)代碼
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// *****************************************************************************
protected void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if (e.Item.ItemIndex >= 0)
{
e.Item.Attributes["onMouseOver"] = "javascript:this.bgColor='LemonChiffon';";
e.Item.Attributes["onMouseOut"] = "javascript:this.bgColor='white';";
e.Item.Attributes["onClick"] = "javascript:__doPostBack('DataGrid1:_ctl" +(Convert.ToInt16(e.Item.ItemIndex+3)).ToString() + ":_ctl0','')";
e.Item.Attributes["style"] = "cursor:hand";
}
}
/// *****************************************************************************
/// END
/// *****************************************************************************
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 會(huì)計(jì)年度復(fù)選框狀態(tài)改變事件處理函數(shù)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// *****************************************************************************
private void CheckBox1_CheckedChanged(object sender, System.EventArgs e)
{
if (CheckBox1.Checked == true)
{
DropDownList1.Enabled = true;
}
else
{
DropDownList1.Enabled = false;
}
}
/// *****************************************************************************
/// END
/// *****************************************************************************
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 科目類(lèi)別復(fù)選框狀態(tài)改變事件處理函數(shù)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// *****************************************************************************
private void CheckBox2_CheckedChanged(object sender, System.EventArgs e)
{
if (CheckBox2.Checked == true)
{
DropDownList2.Enabled = true;
}
else
{
DropDownList2.SelectedIndex = 0;
DropDownList2.Enabled = false;
}
}
/// *****************************************************************************
/// END
/// *****************************************************************************
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 科目編碼復(fù)選框狀態(tài)改變事件處理函數(shù)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// *****************************************************************************
private void CheckBox3_CheckedChanged(object sender, System.EventArgs e)
{
if (CheckBox3.Checked == true)
{
TextBox3.Enabled = true;
}
else
{
TextBox3.Enabled = false;
}
}
/// *****************************************************************************
/// END
/// *****************************************************************************
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 科目名稱(chēng)復(fù)選框狀態(tài)改變事件處理函數(shù)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// *****************************************************************************
private void CheckBox4_CheckedChanged(object sender, System.EventArgs e)
{
if (CheckBox4.Checked == true)
{
TextBox4.Enabled = true;
}
else
{
TextBox4.Enabled = false;
}
}
/// *****************************************************************************
/// END
/// *****************************************************************************
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 產(chǎn)品列表選擇項(xiàng)改變事件處理函數(shù)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// *****************************************************************************
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{
string ReturnControl = ViewState["ControlName"].ToString();
string sId = DataGrid1.SelectedItem.Cells[2].Text;
string sScript = "";
sScript += "<script language=javascript>";
sScript += " window.opener.document.forms[0]." + ReturnControl + ".value = '" + sId + "';";
if (this.Request.QueryString["Submit"] == "T")
sScript += " window.opener.document.forms[0]." + ReturnControl + ".value = '" + sId + "';window.opener.document.forms[0].submit();";
sScript += " window.close();";
sScript += "</script>";
Response.Write(sScript);
}
/// *****************************************************************************
/// END
/// *****************************************************************************
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -