pzmx_mod.aspx.cs

ASP.NET的一些开发实例,有论坛管理系统等

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.ascs.plp.publics;
using com.unicafe.ui;
using com.unicafe.common;
using com.unicafe.security;
using com.ascs.plp.common;

namespace PLP.CWZZ.PZGL
{
	/// <summary>
	/// PZMX_MOD 的摘要说明。
	/// </summary>
	public class PZMX_MOD : com.unicafe.ui.UnicafePage
	{
		protected System.Web.UI.WebControls.TextBox tb_ZY;
		protected System.Web.UI.WebControls.TextBox tb_JFJE;
		protected System.Web.UI.WebControls.TextBox tb_DFJE;
		protected System.Web.UI.WebControls.DropDownList DDL_WLHLX;
		protected System.Web.UI.WebControls.TextBox KJKM;
		protected System.Web.UI.WebControls.TextBox KMMC;
		protected System.Web.UI.WebControls.LinkButton datacheck;
		protected System.Web.UI.WebControls.DropDownList DDL_GSBM;
		protected System.Web.UI.WebControls.DropDownList DDL_GSYG;
		protected System.Web.UI.WebControls.DropDownList DDL_WLH;

		SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
		Com.Ascs.Plp.CW.CW_PZXM CW_PZXM=new Com.Ascs.Plp.CW.CW_PZXM();
		Com.Ascs.Plp.CW.CW_PZXMMgr CW_PZXMMgr=new Com.Ascs.Plp.CW.CW_PZXMMgr();
		Com.Ascs.Plp.CW.CW_PZMgr CW_PZMgr = new Com.Ascs.Plp.CW.CW_PZMgr();
		protected System.Web.UI.WebControls.RangeValidator RangeValidator1;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator2;
		Com.Ascs.Plp.CW.CW_PZ CW_PZ = new Com.Ascs.Plp.CW.CW_PZ();
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			try
			{
				// 在此处放置用户代码以初始化页面
				this.VerifyPage();
				this.VerifyPage("zz_pzgl_mgr");
				ViewState["JGDM"]=this.CurrentJGXX.JGDM;
				this.CW_PZXM.PZBH=this.Request.QueryString["PZBH"];
				this.CW_PZXM.KJND=this.Request.QueryString["KJND"];
				this.CW_PZXM.KJQJ=this.Request.QueryString["KJQJ"];
				this.CW_PZXM.JGDM=this.Request.QueryString["JGDM"];
				ViewState["KJND"]=this.Request.QueryString["KJND"];
				ViewState["CD"]=this.CW_PZXMMgr.GetYJKMCD();
				this.CW_PZXM.XH=Convert.ToInt32(this.Request.QueryString["XH"]);
				this.CW_PZXM = this.CW_PZXMMgr.GetCW_PZXM(this.CW_PZXM.PZBH,this.CW_PZXM.XH,this.CW_PZXM.KJND,this.CW_PZXM.KJQJ,this.CW_PZXM.JGDM);

				this.CW_PZ=this.CW_PZMgr.GetCW_PZ(this.CW_PZXM.PZBH,this.CW_PZXM.KJND,this.CW_PZXM.KJQJ,this.CW_PZXM.JGDM);
				if(this.CW_PZ.KGLBJ=="1")
				{
					this.tb_DFJE.Enabled=false;
					this.tb_JFJE.Enabled=false;
				}
				if(!this.IsPostBack)
				{
					try
					{
						this.tb_ZY.Text=this.CW_PZXM.ZY;
						this.KMMC.Text=this.CW_PZXM.KJKM;
						this.KJKM.Text=this.CW_PZXM.KJKM;
						if(this.CW_PZXM.JFJE!=0)
						{
							this.tb_JFJE.Text=this.CW_PZXM.JFJE.ToString();
						}
						if(this.CW_PZXM.DFJE!=0)
						{
							this.tb_DFJE.Text=this.CW_PZXM.DFJE.ToString();
						}
						this.DDLBind();
						this.DDL_GSBM.SelectedIndex=-1;
						if(this.CW_PZXM.BMBH.ToString().Trim()!=string.Empty)
							this.DDL_GSBM.Items.FindByValue(this.CW_PZXM.BMBH.ToString().Trim()).Selected=true;
						this.DDL_GSYG.SelectedIndex=-1;
						if(this.CW_PZXM.YGBH.ToString().Trim()!=string.Empty)
							this.DDL_GSYG.Items.FindByValue(this.CW_PZXM.YGBH.ToString().Trim()).Selected=true;
						this.DDL_WLHLX.SelectedIndex=-1;
						if(this.CW_PZXM.WLHLX.ToString().Trim()!=string.Empty)
							this.DDL_WLHLX.Items.FindByValue(this.CW_PZXM.WLHLX.ToString().Trim()).Selected=true;
						if(this.DDL_WLHLX.SelectedIndex>0)
						{
							this.DDL_WLHBIND();
							this.DDL_WLH.SelectedIndex=-1;
							if(this.CW_PZXM.WLHBM.ToString().Trim()!=string.Empty)
								this.DDL_WLH.Items.FindByValue(this.CW_PZXM.WLHBM.ToString().Trim()).Selected=true;
						}
					}
					catch(Exception e1)
					{
						LogService.Write(e1.Message);
						this.Response.Redirect("../../Publics/Error.aspx?errmsg=未能获取凭证细目的完整信息。");  
						return;
					}
				}
			}
			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_WLHLX.SelectedIndexChanged += new System.EventHandler(this.DDL_WLHLX_SelectedIndexChanged);
			this.datacheck.Click += new System.EventHandler(this.LinkButton1_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void LinkButton1_Click(object sender, System.EventArgs e)
		{
			try
			{
				//对表对象进行赋值
				try
				{
					this.CW_PZXM.ZY=this.tb_ZY.Text;
					this.CW_PZXM.KJKM=this.KMMC.Text.Trim();
					string sReturn=this.CHECKKJKM(this.CW_PZXM.KJND,this.CW_PZXM.KJKM,this.DDL_GSBM.SelectedIndex,this.DDL_GSYG.SelectedIndex,this.DDL_WLH.SelectedIndex,this.DDL_WLHLX.SelectedIndex);
					if(sReturn!=string.Empty)
					{
						this.Response.Write("<script>alert('"+sReturn+"')</script>");
						return;
					}
					if(this.DDL_GSBM.SelectedIndex>-1)
					{
						CW_PZXM.BMBH=this.DDL_GSBM.SelectedItem.Value;
					}
					else
					{
						CW_PZXM.BMBH=string.Empty;
					}
					if(this.DDL_GSYG.SelectedIndex>-1)
					{
						CW_PZXM.YGBH=this.DDL_GSYG.SelectedItem.Value;
					}
					else
					{
						CW_PZXM.BMBH=string.Empty;
					}
					if(this.DDL_WLH.SelectedIndex>-1)
					{
						CW_PZXM.WLHBM = this.DDL_WLH.SelectedItem.Value;
					}
					else
					{
						CW_PZXM.WLHBM=string.Empty;
					}
					if(this.DDL_WLHLX.SelectedIndex>-1)
					{
						CW_PZXM.WLHLX = this.DDL_WLHLX.SelectedItem.Value;
					}
					else
					{
						CW_PZXM.WLHLX=string.Empty;
					}
					if(this.tb_JFJE.Text.Trim()!=string.Empty)
					{
						this.CW_PZXM.JFJE=Convert.ToDecimal(this.tb_JFJE.Text);
					}
					else
					{
						CW_PZXM.JFJE=0;
					}
					if(this.tb_DFJE.Text.Trim()!=string.Empty)
					{
						this.CW_PZXM.DFJE=Convert.ToDecimal(this.tb_DFJE.Text);
					}
					else
					{
						CW_PZXM.DFJE=0;
					}
				}
				catch(Exception e1)
				{
					LogService.Write(e1.Message);
					this.Response.Redirect("../../Publics/Error.aspx?errmsg=未能获取凭证细目的完整信息。");  
					return;
				}
			
				cn.Open();
				SqlCommand mySqlCommand = new SqlCommand();
				mySqlCommand.Connection=cn;
				SqlTransaction myTrans = this.cn.BeginTransaction();//建立事务
				mySqlCommand.Transaction = myTrans;//绑定事务
				//调用修改方法进行修改
				bool Flag = this.CW_PZXMMgr.UpdateCW_PZXM(mySqlCommand,this.CW_PZXM);
				string ReturnURL=PLP.CWZZ.PZGL.PZMX_ADD.PZXMADD_CreatReturnURL(this,CW_PZXM);
				//执行完毕，提示后返回
				if(Flag == true)
				{
				
					this.MODKJKM_SYBJ(this.CW_PZXM.KJND,this.CW_PZXM.KJKM);
					//刷新父页面并关闭本窗口
					Response.Write("<script language=javascript>window.opener.location='" + ReturnURL + "';window.close();</script>");
					myTrans.Commit();
				}
				else
				{
				
					//重定向到错误页面
					Response.Write("<script language=javascript>window.opener.location='../../Publics/Error.aspx?errmsg=凭证细目未能成功修改。';</script>"); 
					myTrans.Rollback();
				}
				cn.Close();
			}
			catch(Exception e1)
			{
				LogService.Write ("修改会计凭证细目时产生异常。");
				LogService.Write (e1.Message);
				Prompt.PromptError(this,"修改会计凭证细目时产生异常。");
			}
		}


		private void DDLBind()
		{
			string sql=string.Empty;
			sql=string.Format("select DeptID,DeptName from Departments where JGDM='{0}' or DeptID='0'",ViewState["JGDM"].ToString());
			DataTable dt=this.CW_PZMgr.CreateDataTableFromSql(sql);
			if(dt.Rows.Count>0)
			{
				this.DDL_GSBM.DataSource=dt;
				this.DDL_GSBM.DataTextField="DeptName";
				this.DDL_GSBM.DataValueField="DeptID";
				this.DDL_GSBM.DataBind();
				this.DDL_GSBM.Items.Insert(0,new ListItem("请选择",""));
			}

			sql=string.Format("SELECT Employees.EmplID,Employees.EmplNameL + Employees.EmplNameF AS EmplNameL,Departments.JGDM, Employees.EmplEnabled FROM Employees INNER JOIN EmplDept ON Employees.EmplID = EmplDept.EmplID INNER JOIN Departments ON EmplDept.DeptID = Departments.DeptID where EmplEnabled='1'and JGDM='{0}'",ViewState["JGDM"].ToString());
			DataTable dt1=this.CW_PZMgr.CreateDataTableFromSql(sql);
			if(dt1.Rows.Count>0)
			{
				this.DDL_GSYG.DataSource=dt1;
				this.DDL_GSYG.DataTextField="EmplNameL";
				this.DDL_GSYG.DataValueField="EmplID";
				this.DDL_GSYG.DataBind();
				this.DDL_GSYG.Items.Insert(0,new ListItem("请选择",""));
			}
		}

		private void DDL_WLHBIND()
		{
			string sql=string.Empty;
			DataTable dt;
			switch(this.DDL_WLHLX.SelectedItem.Value)
			{
				case "0":
					this.DDL_WLH.Items.Clear();
					this.DDL_WLH.Items.Insert(0,new ListItem("请选择",""));
					break;
				case "1":
					sql=string.Format("select KHDM,KHMC from KHXX where JGDM='{0}'",ViewState["JGDM"].ToString());
					dt=this.CW_PZMgr.CreateDataTableFromSql(sql);
					if(dt.Rows.Count>0)
					{
						this.DDL_WLH.DataSource=dt;
						this.DDL_WLH.DataTextField="KHMC";
						this.DDL_WLH.DataValueField="KHDM";
						this.DDL_WLH.DataBind();
						this.DDL_WLH.Items.Insert(0,new ListItem("请选择",""));
					}
					break;
				case "2":
					sql=string.Format("select GYSDM,GYSMC from GYSXX where JGDM='{0}'",ViewState["JGDM"].ToString());
					dt=this.CW_PZMgr.CreateDataTableFromSql(sql);
					if(dt.Rows.Count>0)
					{
						this.DDL_WLH.DataSource=dt;
						this.DDL_WLH.DataTextField="GYSMC";
						this.DDL_WLH.DataValueField="GYSDM";
						this.DDL_WLH.DataBind();
						this.DDL_WLH.Items.Insert(0,new ListItem("请选择",""));
					}
					break;
				case "3":
					sql=string.Format("select JGDM,JGMC from JGXX");
					dt=this.CW_PZMgr.CreateDataTableFromSql(sql);
					if(dt.Rows.Count>0)
					{
						this.DDL_WLH.DataSource=dt;
						this.DDL_WLH.DataTextField="JGMC";
						this.DDL_WLH.DataValueField="JGDM";
						this.DDL_WLH.DataBind();
						this.DDL_WLH.Items.Insert(0,new ListItem("请选择",""));
					}
					break;
			}
		}

		private void DDL_WLHLX_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			try
			{
				this.DDL_WLHBIND();
			}
			catch(Exception e1)
			{
				LogService.Write ("选择往来户类型时产生异常。");
				LogService.Write (e1.Message);
				Prompt.PromptError(this,"选择往来户类型时产生异常。");
			}
		}

		private void MODKJKM_SYBJ(string KJND,string KJKM)
		{ 
			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();
			CW_KJKM=CW_KJKMMgr.GetCW_KJKM(KJND,KJKM);
			CW_KJKM.SFYJSY="1";
			CW_KJKMMgr.UpdateCW_KJKM(cn,CW_KJKM);
		}

		private string CHECKKJKM(string KJND,string KJKM,int BMBM,int YGBM,int WLHBM,int WLHLX)
		{
			string sReturn=string.Empty;
			string sql=string.Format("select * from CW_KJKM where KJND='{0}' and KMBM='{1}' and TYBJ='0' and SFMX='1'",KJND,KJKM);
			DataTable dt=this.CW_PZMgr.CreateDataTableFromSql(sql);
			if(dt.Rows.Count==1)
			{
				if(dt.Rows[0]["SFBMHS"].ToString()=="1"&&BMBM<1)
				{
					sReturn="该科目部门核算，请选择部门！";
				}
				else if(dt.Rows[0]["SFBMHS"].ToString()=="0"&&BMBM>0)
				{
					sReturn="该科目没有部门核算，请不要选择部门！";
					this.DDL_GSBM.SelectedIndex=0;
				}
				if(dt.Rows[0]["SFYGHS"].ToString()=="1"&&YGBM<1)
				{
					sReturn+="该科目员工核算，请选择员工！";
				}
				else if(dt.Rows[0]["SFYGHS"].ToString()=="0"&&YGBM>0)
				{
					sReturn+="该科目没有员工核算，请不要选择员工！";
					this.DDL_GSYG.SelectedIndex=0;
				}
				if(dt.Rows[0]["SFWLHHS"].ToString()=="1"&&WLHBM<1)
				{
					sReturn+="该科目往来户核算，请选择往来户！";
				}
				else if(dt.Rows[0]["SFWLHHS"].ToString()=="0")
				{
					if(WLHBM>0||WLHLX>0)
					{
						sReturn+="该科目没有往来户核算，请不要选择往来户！";
						this.DDL_WLHLX.SelectedIndex=0;
						this.DDL_WLH.SelectedIndex=0;
					}
				}
			}
			else
			{
				sReturn="科目编码书写有误请重新填写！原因有可能是：1.该科目不存在。2.该科目不是末级科目。3.该科目已经停用。";
			}
			return sReturn;
		}

	}
}