pz_view.aspx.cs

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

				//处理DataGrid控件（绑定DataGrid控件 -> 检查是否需要定位 -> 给导航文本赋值）
				if(CommonService.HandleDataGrid(this, sql, 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,"会计年度选择时产生异常。");
			}
		}


		public static string GetToEmpName(Object obj)
		{
			string sql=string.Format("select (EmplNameL+EmpLNameF) as  EmplNameL from Employees where EmplID='{0}'",obj.ToString());
			string sReturn=string.Empty;
			Com.Ascs.Plp.CW.CW_PZMgr CW_PZMgr1 = new Com.Ascs.Plp.CW.CW_PZMgr();
			
			DataTable dt=CW_PZMgr1.CreateDataTableFromSql(sql);
			if(dt.Rows.Count>0)
			{
				sReturn=dt.Rows[0]["EmplNameL"].ToString();
			}
			return sReturn;
		}

		private void Linkbutton2_Click(object sender, System.EventArgs e)
		{
			try
			{
				string[] DataTypes = {"string","string","string","string"};
				string[] pk = {"Hidden1","Hidden2","Hidden3","Hidden4"};
				ArrayList al=this.GetPk("CheckBox1",DataTypes,pk,this.DataGrid1);
				if(al.Count>0)
				{
					for(int i=0;i<al.Count;i++)
					{
						try
						{
							object[] obj=(object[])al[i];
							string DQKJQJ=this.CW_KJQJMgr.GetDQKJQJ(obj[3].ToString())[0];
							this.CreateCXPZ(obj[0].ToString(),obj[1].ToString(),obj[2].ToString(),obj[3].ToString(),DQKJQJ);
						}
						catch
						{
							//重定向到错误页面
							Response.Write("<script language=javascript>window.opener.location='../../Publics/Error.aspx?errmsg=凭证细目未能成功修改。';</script>");
						}
					}
				
				}
				if(this.DropDownList1.SelectedItem.Value.ToString()!="0")
				{
					ViewState["sql"]=string.Format("select * from CW_PZ where JGDM='{0}' and KJND ='{1}' and KJQJ='{2}' and PZLX='{3}' order by PZBH DESC",ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ViewState["KJQJBH"].ToString(),this.DropDownList1.SelectedItem.Value.ToString()) ;
				}
				else
				{
					ViewState["sql"]=string.Format("select * from CW_PZ where JGDM='{0}' and KJND ='{1}' and KJQJ='{2}' order by PZBH DESC",ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ViewState["KJQJBH"].ToString()) ;
				}
				//处理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 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)
					{
						//获取关键字的值，逐个加入对象数组obj
						object[] obj = new object[DataTypes.Length];
						for (int j=0; j<Pk.Length; j++)
						{
							obj[j] = ((System.Web.UI.HtmlControls.HtmlInputHidden)_item.FindControl(Pk[j].ToString())).Value;     //取各项主关键字
						}
						ArPks.Insert(n,obj);
						n++;
					}					
				}
			}
			return ArPks;
		}

		private string CreateCXPZ(string PZBH,string KJND,string KJQJ,string JGDM,string DQKJQJ)
		{
			this.VerifyPage();
			string sReturn=string.Empty;
			this.CW_PZYS=this.CW_PZMgrCX.GetCW_PZ(PZBH,KJND,KJQJ,JGDM);
			this.CW_PZCX=this.CW_PZMgrCX.GetCW_PZ(PZBH,KJND,KJQJ,JGDM);
			if(this.CW_PZYS.DCBJ=="1")
			{
				sReturn="已冲销过的凭证不能再冲销！";
			}
			else if(this.CW_PZYS.GZBJ=="0")
			{
				sReturn="未审核记帐的凭证不能冲销！";
			}
			else
			{
				try
				{
					this.CW_PZYS.DCBJ="1";
					this.cn.Open();//启动连接
					SqlCommand mySqlCommand=new SqlCommand();
					mySqlCommand.Connection=cn;
					SqlTransaction myTrans = this.cn.BeginTransaction();//建立事务
					mySqlCommand.Transaction = myTrans;//绑定事务
					
					string New_PZBH=this.CW_PZMgrCX.Create_PZBH(mySqlCommand,JGDM,KJND,DQKJQJ);
					this.CW_PZCX.PZBH=New_PZBH;
					this.CW_PZCX.KJND=KJND;
					this.CW_PZCX.KJQJ=DQKJQJ;
					this.CW_PZCX.ZDR=this.CurrentEmployee.EmplID;
					this.CW_PZCX.ZDRQ=DateTime.Parse(System.DateTime.Now.ToShortDateString());
					this.CW_PZCX.SHR=string.Empty;
					this.CW_PZCX.SHRQ=Convert.ToDateTime("1900-01-01");
					this.CW_PZCX.CNR=string.Empty;
					this.CW_PZCX.CNRQ=Convert.ToDateTime("1900-01-01");
					this.CW_PZCX.GZR=string.Empty;
					this.CW_PZCX.GZRQ=Convert.ToDateTime("1900-01-01");
					this.CW_PZCX.GZBJ="0";
					this.CW_PZCX.KGLBJ="0";
					this.CW_PZCX.DCBJ="2";
					this.CW_PZCX.BZ="2";
					this.CW_PZCX.DCBH=string.Format("{0},{1}",KJQJ,PZBH);

					//新增会计凭证
					if (CW_PZMgr.AddCW_PZ(mySqlCommand,CW_PZCX)&&this.CW_PZMgrCX.UpdateCW_PZ(mySqlCommand,this.CW_PZYS))
					{
						myTrans.Commit();
					}
					else
					{
						myTrans.Rollback();
					}
					string strsql=string.Format("select * from CW_PZXM where PZBH='{0}' and KJND='{1}' and KJQJ='{2}' and JGDM='{3}'",PZBH,KJND,KJQJ,JGDM);
					DataTable dt=this.CW_PZMgrCX.CreateDataTableFromSql(strsql);
					if(dt.Rows.Count>0)
					{
						foreach(DataRow row in dt.Rows)
						{
							this.CW_PZXM.PZBH=New_PZBH;
							this.CW_PZXM.KJND=KJND;
							this.CW_PZXM.KJQJ=DQKJQJ;
							this.CW_PZXM.JGDM=row["JGDM"].ToString();
							this.CW_PZXM.ZY=string.Format("冲销{0}年度第{1}会计期间{2}号凭证",KJND,KJQJ,PZBH);
							this.CW_PZXM.KJKM=row["KJKM"].ToString();
							this.CW_PZXM.BMBH=row["BMBH"].ToString();
							this.CW_PZXM.YGBH=row["YGBH"].ToString();
							this.CW_PZXM.WLHLX=row["WLHLX"].ToString();
							this.CW_PZXM.WLHBM=row["WLHBM"].ToString();
							if(row["DFJE"].ToString()!=string.Empty)
							{
								this.CW_PZXM.DFJE=-(Convert.ToDecimal(row["DFJE"]));
							}
							else
							{
								this.CW_PZXM.DFJE=0;
							}
							if(row["JFJE"].ToString()!=string.Empty)
							{
								this.CW_PZXM.JFJE=-(Convert.ToDecimal(row["JFJE"]));
							}
							else
							{
								this.CW_PZXM.JFJE=0;
							}
							SqlCommand mySqlCommandXM = new SqlCommand();
							mySqlCommandXM.Connection=cn;
							SqlTransaction myTransXM = this.cn.BeginTransaction();//建立事务
							mySqlCommandXM.Transaction = myTransXM;//绑定事务
							if(this.CW_PZXMMgr.AddCW_PZXM(mySqlCommandXM,this.CW_PZXM))
							{
								myTransXM.Commit();
							}
							else
							{
								myTransXM.Rollback();
							}
							
						}
					}
					cn.Close();
				}
				catch(Exception e)
				{
					cn.Close();
					string str=e.Message;
					//重定向到错误页面
					Response.Write("<script language=javascript>window.opener.location='../../Publics/Error.aspx?errmsg=冲销凭证未能成功生成。';</script>");
				}
			}
			
			return sReturn;
		}

		private void GetJZBJ(string JGDM,string KJND,string KJQJBH)
		{
			this.CW_KJQJ=this.CW_KJQJMgr.GetCW_KJQJ(JGDM,KJND,KJQJBH);
			if(this.CW_KJQJ!=null)
			{
				if(this.CW_KJQJ.JZBJ=="1")
				{
					ViewState["JZBJ"]="1";
				}
				else
				{
					ViewState["JZBJ"]="0";
				}
			}
		}

		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 将字段值“是”、“否”由标志改为中文描述
		/// </summary>
		/// <param name="obj"></param>
		/// <returns></returns>
		/// **************************************************************************
		public static string ValueToString(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;
			}
			return sReturn;
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************


		private void DDL_KJQJBH_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			try
			{
				ViewState["KJND"]=this.DDL_KJND.SelectedItem.Value.ToString();
				ViewState["KJQJBH"]=this.DDL_KJQJBH.SelectedItem.Value.ToString();
				if(this.DropDownList1.SelectedItem.Value.ToString()!="0")
				{
					ViewState["sql"]=string.Format("select * from CW_PZ where JGDM='{0}' and KJND ='{1}' and KJQJ='{2}' and PZLX='{3}' order by PZBH DESC",ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ViewState["KJQJBH"].ToString(),this.DropDownList1.SelectedItem.Value.ToString()) ;
				}
				else
				{
					ViewState["sql"]=string.Format("select * from CW_PZ where JGDM='{0}' and KJND ='{1}' and KJQJ='{2}' order by PZBH DESC",ViewState["JGDM"].ToString(),ViewState["KJND"].ToString(),ViewState["KJQJBH"].ToString()) ;
				}
				this.GetJZBJ(ViewState["JGDM"].ToString(),this.DDL_KJND.SelectedItem.Value.ToString(),this.DDL_KJQJBH.SelectedItem.Value.ToString());
				//处理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,"会计期间选择时产生异常。");
			}
		}
		
	}
}