kjqj_view.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 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.KJQJ
{
	/// <summary>
	/// KJQJ_VIEW 的摘要说明。
	/// </summary>
	public class KJQJ_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.HtmlControls.HtmlForm Form1;
		protected System.Web.UI.WebControls.LinkButton Linkbutton2;

		Com.Ascs.Plp.CW.CW_KJQJ  CW_KJQJ= new Com.Ascs.Plp.CW.CW_KJQJ();
		Com.Ascs.Plp.CW.CW_KJQJMgr CW_KJQJMgr = new Com.Ascs.Plp.CW.CW_KJQJMgr();
		protected System.Web.UI.WebControls.DropDownList DDL_KJND;
		SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
		protected Com.Ascs.Plp.Cw.Publics.CwInfo cwinfo = new CwInfo();
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			try
			{
				// 在此处放置用户代码以初始化页面
				this.VerifyPage();                           //登录检查
				this.VerifyPage("zt_kjqj_mgr");

				if (!this.IsPostBack)  //判断第一次显示
				{
					this.Label1.Text=this.CurrentEmployee.EmplName;
					ViewState["JGDM"]=this.CurrentJGXX.JGDM.ToString();
					//会计年度的绑定
					cwinfo.LocateKJND(this.DDL_KJND, this.CurrentJGXX.JGDM);
					ViewState["KJND"]=this.Request.QueryString["KJND"];
					if(ViewState["KJND"]==null)
						ViewState["KJND"]=DateTime.Now.Year.ToString();
					this.DDL_KJND.SelectedIndex=-1;
					this.DDL_KJNDBind(ViewState["KJND"].ToString());

					//删除的判断标记
					ViewState["DEL"]=this.CW_KJQJMgr.GetQYKJQJ(ViewState["JGDM"].ToString(),ViewState["KJND"].ToString())[0];
				
					//启用的判断标记
					string sReturnQY=string.Empty;
					ViewState["QY"]=this.CW_KJQJMgr.sQY(ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ref sReturnQY);
					ViewState["sReturnQY"]=sReturnQY;

					//增加的判断标记
					string sReturn=string.Empty;
					ViewState["bAddKJQJ"]=this.CW_KJQJMgr.sADDKJQJ(ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ref sReturn);
					ViewState["sReturn"]=sReturn;
				
					ViewState["sql"]=string.Format("select * from VIEW_KJQJ where JGDM='{0}' and KJND='{1}' order by KSRQ",ViewState["JGDM"].ToString(),this.DDL_KJND.SelectedItem.Value);
					//处理DataGrid控件（绑定DataGrid控件 -> 检查是否需要定位 -> 给导航文本赋值）
					if(CommonService.HandleDataGrid(this, ViewState["sql"].ToString(), DataGrid1, "Data", Label2, Label3, Label4) == false)
						this.Response.Redirect("../../publics/Error.aspx?errmsg=在处理数据时发生错误。"); 

				}
				else
				{
					//检查回发的请求操作是否是要进入上页或下页
					if(CommonService.PageNavigate(this, DataGrid1, "Data", Label2, Label3, Label4) == false)
						this.Response.Redirect("../../publics/Error.aspx?errmsg=在处理数据时发生错误。");
				}
			}
			catch(Exception e1)
			{
				LogService.Write ("显示会计科目时产生异常。");
				LogService.Write (e1.Message);
				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.DDL_KJND.SelectedIndexChanged += new System.EventHandler(this.DDL_KJND_SelectedIndexChanged);
			this.LinkButton1.Click += new System.EventHandler(this.LinkButton1_Click);
			this.Linkbutton2.Click += new System.EventHandler(this.Linkbutton2_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void LinkButton1_Click(object sender, System.EventArgs e)
		{
			try
			{
				string maxKJQJBH=this.CW_KJQJMgr.GetMaxKJQJBH(ViewState["JGDM"].ToString(),ViewState["KJND"].ToString());
				this.cn.Open();//启动连接
				SqlCommand mySqlCommand=new SqlCommand();
				mySqlCommand.Connection=cn;
				SqlTransaction myTrans = this.cn.BeginTransaction();//建立事务
				mySqlCommand.Transaction = myTrans;//绑定事务
				//调用修改方法进行修改
				bool Flag = this.CW_KJQJMgr.DelCW_KJQJ(mySqlCommand,ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),maxKJQJBH);
				if(Flag)
				{
					myTrans.Commit();
					CommonService.BindDataGrid(this,ViewState["sql"].ToString(),this.DataGrid1,"Data",true);
				}
				else
				{
					myTrans.Rollback();
				}
				cn.Close();

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

				//删除的判断标记
				ViewState["DEL"]=this.CW_KJQJMgr.GetQYKJQJ(ViewState["JGDM"].ToString(),ViewState["KJND"].ToString())[0];
				
				//启用的判断标记
				string sReturnQY=string.Empty;
				ViewState["QY"]=this.CW_KJQJMgr.sQY(ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ref sReturnQY);
				ViewState["sReturnQY"]=sReturnQY;

				//增加的判断标记
				string sReturn=string.Empty;
				ViewState["bAddKJQJ"]=this.CW_KJQJMgr.sADDKJQJ(ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ref sReturn);
				ViewState["sReturn"]=sReturn;
			}
			catch(Exception e1)
			{
				LogService.Write ("删除会计期间时产生异常。");
				LogService.Write (e1.Message);
				Prompt.PromptError(this,"删除会计时产生异常。");
			}
			
		}

		private void Linkbutton2_Click(object sender, System.EventArgs e)
		{
			try
			{
				string sReturnQY=ViewState["sReturnQY"].ToString();
				string sMinKJQJBH=this.CW_KJQJMgr.GetMinKJQJBH(ViewState["JGDM"].ToString(),ViewState["KJND"].ToString());
				if(sMinKJQJBH!=string.Empty)
				{
				
					try
					{
						this.CW_KJQJ = this.CW_KJQJMgr.GetCW_KJQJ(ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),sMinKJQJBH);
						if(sReturnQY=="ZTQYBJ")
							this.CW_KJQJ.ZTQYBJ="1";
						if(sReturnQY=="DQQJBJ,ZTQYBJ")
						{
							this.CW_KJQJ.ZTQYBJ="1";
							this.CW_KJQJ.DQQJBJ="1";
						}
						this.cn.Open();//启动连接
						SqlCommand mySqlCommand=new SqlCommand();
						mySqlCommand.Connection=cn;
						SqlTransaction myTrans = this.cn.BeginTransaction();//建立事务
						mySqlCommand.Transaction = myTrans;//绑定事务
						//调用修改方法进行修改
						bool Flag = this.CW_KJQJMgr.UpdateCW_KJQJ(mySqlCommand,this.CW_KJQJ);
						if(Flag)
						{
							myTrans.Commit();
							ViewState["DEL"]="1";

							//启用的判断标记
							ViewState["QY"]=this.CW_KJQJMgr.sQY(ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ref sReturnQY);
							ViewState["sReturnQY"]=sReturnQY;

							//增加的判断标记
							string sReturn=string.Empty;
							ViewState["bAddKJQJ"]=this.CW_KJQJMgr.sADDKJQJ(ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ref sReturn);
							ViewState["sReturn"]=sReturn;
						}
						else
						{
							myTrans.Rollback();
						}
						cn.Close();
					}
					catch
					{
						//重定向到错误页面
						Response.Write("<script language=javascript>window.opener.location='../../Publics/Error.aspx?errmsg=凭证细目未能成功修改。';</script>");
					}
				
				}
				ViewState["sql"]=string.Format("select * from VIEW_KJQJ where JGDM='{0}' and KJND='{1}' order by KSRQ",ViewState["JGDM"].ToString(),this.DDL_KJND.SelectedItem.Value);
				//处理DataGrid控件（绑定DataGrid控件 -> 检查是否需要定位 -> 给导航文本赋值）
				if(CommonService.ReBindDataGrid(this, ViewState["sql"].ToString(), DataGrid1, "Data", Label2, Label3, Label4) == false)
					this.Response.Redirect("../../publics/Error.aspx?errmsg=在处理数据时发生错误。");
			}
			catch(Exception e1)
			{
				LogService.Write ("启用会计期间时产生异常。");
				LogService.Write (e1.Message);
				Prompt.PromptError(this,"启用会计时产生异常。");
			}
			
		}


		private void DDL_KJNDBind(string KJND)
		{
			try
			{
				this.DDL_KJND.Items.RemoveAt(0);
				this.DDL_KJND.SelectedIndex=-1;
				if(KJND.Trim()!=string.Empty)
					this.DDL_KJND.Items.FindByValue(KJND.Trim()).Selected=true;
			}
			catch(Exception e1)
			{
				LogService.Write ("会计年度绑定时产生异常。");
				LogService.Write (e1.Message);
				Prompt.PromptError(this,"会计年度绑定时产生异常。");
			}
		}

		private void DDL_KJND_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			try
			{
				if(this.DDL_KJND.SelectedIndex>-1)
				{
					ViewState["KJND"]=this.DDL_KJND.SelectedItem.Value;

					//删除的判断标记
					ViewState["DEL"]=this.CW_KJQJMgr.GetQYKJQJ(ViewState["JGDM"].ToString(),ViewState["KJND"].ToString())[0];

					//启用的判断标记
					string sReturnQY=string.Empty;
					ViewState["QY"]=this.CW_KJQJMgr.sQY(ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ref sReturnQY);
					ViewState["sReturnQY"]=sReturnQY;

					//增加的判断标记
					string sReturn=string.Empty;
					ViewState["bAddKJQJ"]=this.CW_KJQJMgr.sADDKJQJ(ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ref sReturn);
					ViewState["sReturn"]=sReturn;

					ViewState["sql"]=string.Format("select * from VIEW_KJQJ where JGDM='{0}' and KJND='{1}' order by KSRQ",ViewState["JGDM"].ToString(),this.DDL_KJND.SelectedItem.Value);
				}
				//处理DataGrid控件（绑定DataGrid控件 -> 检查是否需要定位 -> 给导航文本赋值）
				if(CommonService.HandleDataGrid(this, ViewState["sql"].ToString(), DataGrid1, "Data", Label2, Label3, Label4) == false)
					this.Response.Redirect("../../publics/Error.aspx?errmsg=在处理数据时发生错误。");
			}
			catch(Exception e1)
			{
				LogService.Write ("会计年度选择时产生异常。");
				LogService.Write (e1.Message);
				Prompt.PromptError(this,"会计年度时产生异常。");
			}
			 
		}


	}
}