kjkmid.aspx.cs

企业管理信息化之财务管理系统

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 的摘要说明。
	/// </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)
		{
			// 在此处放置用户代码以初始化页面
			this.VerifyPage();

			if (!this.IsPostBack)
			{
				//获取控件名参数值，如没有则提示后退出
				ViewState["ControlName"] = this.Request.QueryString["ControlName"];
				if(ViewState["ControlName"] == null)
				{
					Prompt.PromptError(this,"缺少参数 [父窗口用于接收返回值的输入框控件名] ！");
					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);

				//决定会计年度的限制模式
				if(this.Request.QueryString["KJND"] == "")
				{
					//Prompt.PromptMessage(this, "不限制会计年度！");
				}
				else if(this.Request.QueryString["KJND"] == "NOW" || this.Request.QueryString["KJND"] == null)
				{
					CheckBox1.Enabled = false;
					DropDownList1.Enabled = false;
					//Prompt.PromptMessage(this, "限制为当前会计年度！");
				}
				else
				{
					CheckBox1.Enabled = false;
					DropDownList1.Enabled = false;
					CommonService.LocateDropDownList(DropDownList1,this.Request.QueryString["KJND"]);
					//Prompt.PromptMessage(this, "限制为" + this.Request.QueryString["KJND"] +"会计年度！");
				}

				// 给绑定DataGrid控件的SQL语句进行赋值（注意，SQL语句赋值之后不要再修改）
				ViewState["sql"] =	"Select LBMC=" +
									"(Case When LB='1' Then '资产' When LB='2' Then '负债' When LB='3' Then '权益' 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控件 -> 检查是否需要定位 -> 给导航文本赋值）
				if(CommonService.HandleDataGrid(this, sql, DataGrid1, "Data2", Label1, Label2, Label3) == false)
					Prompt.PromptError(this,"在处理数据时发生错误。");
			}
			else
			{
				//检查回发的请求操作是否是要进入上页或下页
				if(CommonService.PageNavigate(this, DataGrid1, "Data2", Label1, Label2, Label3) == false)
					Prompt.PromptError(this,"在处理数据时发生错误。");
			}
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </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>
		/// 查询事件处理函数
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void LinkButton1_Click(object sender, System.EventArgs e)
		{
			BindGrid();
		}
		/// *****************************************************************************
		/// END
		/// *****************************************************************************




		/// *****************************************************************************
		/// BEIGIN
		/// <summary>
		/// 与DataGrid1绑定数据
		/// </summary>
		/// *****************************************************************************
		private void BindGrid()
		{
			//根据选择的条件进行查询条件的组合和生成
			sql =	"Select LBMC=" +
				"(Case When LB='1' Then '资产' When LB='2' Then '负债' When LB='3' Then '权益' When LB='4' Then '成本' When LB='5' Then '损益' End), " +
				"KMBM, KMMC From CW_KJKM Where 1=1 ";
			if (CheckBox1.Checked == true && DropDownList1.SelectedItem.Value != "-- 会计年度 --")
			{
				KJNDStatement = "And KJND = '" + DropDownList1.SelectedItem.Value +"' ";
			}
			else
			{
				Prompt.PromptAlert(this,"请选择会计年度！");
				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控件 -> 给导航文本赋值）
			if(CommonService.ReBindDataGrid(this, sql, DataGrid1, "Data2", Label1, Label2, Label3) == false)
				Prompt.PromptError(this,"在处理数据时发生错误。");
		}
		/// *****************************************************************************
		/// END
		/// *****************************************************************************





		/// *****************************************************************************
		/// BEIGIN
		/// <summary>
		/// 为数据行添加对鼠标移动的响应代码
		/// </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>
		/// 会计年度复选框状态改变事件处理函数
		/// </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>
		/// 科目类别复选框状态改变事件处理函数
		/// </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>
		/// 科目编码复选框状态改变事件处理函数
		/// </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>
		/// 科目名称复选框状态改变事件处理函数
		/// </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>
		/// 产品列表选择项改变事件处理函数
		/// </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
		/// *****************************************************************************

	}
}