kjkm_view.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.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);

				//根据session值决定是否需要将数据定位到某个会计年度的某个科目类型上
				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");

					//根据科目类型重新设置查询条件，如果选择全部则全部查询，反之则查询选定类别的会计科目
					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控件 -> 检查是否需要定位 -> 给导航文本赋值）
				if(CommonService.HandleDataGrid(this, sql, DataGrid1, "Data", Label2, Label3, Label4) == false)
				{
					Prompt.PromptError(this, "在处理数据时发生错误。");
				}
			}
			else
			{
				//检查回发的请求操作是否是要进入上页或下页
				if(CommonService.PageNavigate(this, DataGrid1, "Data", Label2, Label3, Label4) == 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.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"};

			//调用删除方法对选中的数据进行删除
			CommonService.DelSelectRecord(this,DataGrid1,ViewState["sql"].ToString(),"Data","CheckBox1",DataTypes,pk,"Com.Ascs.Plp.CW.CW_KJKMMgr","DelCW_KJKM","某些科目已经使用，或者还有下级科目，不允许删除。");

			//对页面导航文本进行重新赋值
			CommonService.PageNavigatorText(DataGrid1,Label2, Label3, Label4);
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************







		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 将字段值“是”、“否”由标志改为中文描述
		/// </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>
		/// 将科目类别代码转换成文字描述
		/// </summary>
		/// <param name="obj"></param>
		/// <returns></returns>
		/// **************************************************************************
		public string ValueToTypeString(Object obj)
		{
			string sReturn=string.Empty;
			switch(obj.ToString())
			{
				case "1":
					sReturn="资产";
					break;
				case "2":
					sReturn="负债";
					break;
				case "3":
					sReturn="权益";
					break;
				case "4":
					sReturn="成本";
					break;
				case "5":
					sReturn="损益";
					break;
			}
			return sReturn;
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************
	



		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 获取要操作的记录的主关键字数组
		/// </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++)
				{
					//将当前行赋值给一个DataGridItem对象
					DataGridItem _item = dg.Items[i];

					//判断当前行上的CheckBox控件赋值给一个CheckBox对象
					CheckBox CheckFlag = (CheckBox)_item.FindControl(CheckBoxName);   

					//判断当前行上的复选框是否被选中，如果被选中则进行删除处理，否则不予处理
					if(CheckFlag.Checked == true)