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.common;
using com.ascs.plp.publics;
using Com.Ascs.Plp.Cw.Publics;

namespace PLP.CWZZ.KJKM
{
	/// <summary>
	/// KJKM_VIEW 的摘要說明。
	/// </summary>
	public class KJKM_VIEW :com.unicafe.ui.UnicafePage
	{
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.LinkButton LinkButton1;
		protected System.Web.UI.WebControls.LinkButton LinkButton2;
		protected System.Web.UI.HtmlControls.HtmlForm Form1;
		SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
		Com.Ascs.Plp.CW.CW_KJKM CW_KJKM = new Com.Ascs.Plp.CW.CW_KJKM();
		Com.Ascs.Plp.CW.CW_KJKMMgr CW_KJKMMgr=new Com.Ascs.Plp.CW.CW_KJKMMgr();
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		protected System.Web.UI.WebControls.DropDownList DropDownList2;
		protected System.Web.UI.WebControls.LinkButton Linkbutton3;
		protected Com.Ascs.Plp.Cw.Publics.CwInfo cwinfo = new CwInfo();
		string sql;
	

		private void Page_Load(object sender, System.EventArgs e)
		{
			this.VerifyPage();                            //登錄檢查
			this.VerifyPage("zt_kjkm_mgr");
			1.ToString();

			if (!this.IsPostBack)  //判斷第一次顯示
			{
				this.Label1.Text=this.CurrentEmployee.EmplName;
				cwinfo.LocateKJND(DropDownList2, this.CurrentJGXX.JGDM);

				//根據(jù)session值決定是否需要將數(shù)據(jù)定位到某個會計年度的某個科目類型上
				try
				{
					string KJND, KMLX;
					KJND = this.Session["KJND"].ToString();
					KMLX = this.Session["KMLX"].ToString();
					CommonService.LocateDropDownList(DropDownList2, KJND);
					CommonService.LocateDropDownList(DropDownList1, KMLX);
					this.Session.Remove("KJND");
					this.Session.Remove("KMLX");

					//根據(jù)科目類型重新設(shè)置查詢條件，如果選擇全部則全部查詢，反之則查詢選定類別的會計科目
					if(this.DropDownList1.SelectedItem.Value != "0")
					{
						ViewState["sql"] = "Select * From CW_KJKM Where KJND = '" + DropDownList2.SelectedItem.Value + "' And LB = '" + this.DropDownList1.SelectedItem.Value + "'";;
					}
					else
					{
						ViewState["sql"] = "Select * From CW_KJKM Where KJND = '" + DropDownList2.SelectedItem.Value + "'";
					}
				}
				catch
				{
					ViewState["sql"]= "select * from CW_KJKM Where KJND = '" + DropDownList2.SelectedItem.Value + "'";
				}

				sql = ViewState["sql"].ToString();

				//處理DataGrid控件（綁定DataGrid控件 -> 檢查是否需要定位 -> 給導(dǎo)航文本賦值）
				if(CommonService.HandleDataGrid(this, sql, DataGrid1, "Data", Label2, Label3, Label4) == false)
				{
					Prompt.PromptError(this, "在處理數(shù)據(jù)時發(fā)生錯誤。");
				}
			}
			else
			{
				//檢查回發(fā)的請求操作是否是要進(jìn)入上頁或下頁
				if(CommonService.PageNavigate(this, DataGrid1, "Data", Label2, Label3, Label4) == false)
				{
					Prompt.PromptError(this, "在翻頁重新綁定數(shù)據(jù)時發(fā)生錯誤。");
				}
			}
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：該調(diào)用是 ASP.NET Web 窗體設(shè)計器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設(shè)計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內(nèi)容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.DropDownList2.SelectedIndexChanged += new System.EventHandler(this.DropDownList2_SelectedIndexChanged);
			this.DropDownList1.SelectedIndexChanged += new System.EventHandler(this.DropDownList1_SelectedIndexChanged);
			this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);
			this.LinkButton1.Click += new System.EventHandler(this.LinkButton1_Click);
			this.LinkButton2.Click += new System.EventHandler(this.LinkButton2_Click);
			this.Linkbutton3.Click += new System.EventHandler(this.Linkbutton3_Click);
			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)
		{
			string[] DataTypes = {"string","string"};
			string[] pk = {"Hidden1","Hidden2"};

			//調(diào)用刪除方法對選中的數(shù)據(jù)進(jìn)行刪除
			CommonService.DelSelectRecord(this,DataGrid1,ViewState["sql"].ToString(),"Data","CheckBox1",DataTypes,pk,"Com.Ascs.Plp.CW.CW_KJKMMgr","DelCW_KJKM","某些科目已經(jīng)使用，或者還有下級科目，不允許刪除。");

			//對頁面導(dǎo)航文本進(jìn)行重新賦值
			CommonService.PageNavigatorText(DataGrid1,Label2, Label3, Label4);
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************







		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 將字段值“是”、“否”由標(biāo)志改為中文描述
		/// </summary>
		/// <param name="obj"></param>
		/// <returns></returns>
		/// **************************************************************************
		public static string ValueToString(Object obj)
		{
			string sReturn=string.Empty;
			switch(obj.ToString())
			{
				case "0":
					sReturn="";
					break;
				case "1":
					sReturn="<font face=\"Wingdings 2\" size=\"4\">P</font>";
					break;
			}
			return sReturn;
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************





		
		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 將科目類別代碼轉(zhuǎn)換成文字描述
		/// </summary>
		/// <param name="obj"></param>
		/// <returns></returns>
		/// **************************************************************************
		public string ValueToTypeString(Object obj)
		{
			string sReturn=string.Empty;
			switch(obj.ToString())
			{
				case "1":
					sReturn="資產(chǎn)";
					break;
				case "2":
					sReturn="負(fù)債";
					break;
				case "3":
					sReturn="權(quán)益";
					break;
				case "4":
					sReturn="成本";
					break;
				case "5":
					sReturn="損益";
					break;
			}
			return sReturn;
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************
	



		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 獲取要操作的記錄的主關(guān)鍵字?jǐn)?shù)組
		/// </summary>
		/// <param name="CheckBoxName"></param>
		/// <param name="DataTypes"></param>
		/// <param name="Pk"></param>
		/// <param name="dg"></param>
		/// <returns></returns>
		/// **************************************************************************
		private ArrayList GetPk(string CheckBoxName,string[] DataTypes,string[] Pk,DataGrid dg)
		{
			ArrayList ArPks=new ArrayList();
			int n=0;
			if(dg.Items.Count>0)
			{
				for (int i=0; i<dg.Items.Count; i++)
				{
					//將當(dāng)前行賦值給一個DataGridItem對象
					DataGridItem _item = dg.Items[i];

					//判斷當(dāng)前行上的CheckBox控件賦值給一個CheckBox對象
					CheckBox CheckFlag = (CheckBox)_item.FindControl(CheckBoxName);   

					//判斷當(dāng)前行上的復(fù)選框是否被選中，如果被選中則進(jìn)行刪除處理，否則不予處理
					if(CheckFlag.Checked == true)