print_ltx.cs

一个用vs2003编写的客户工资管理系统客户端程序/一个用vs2003编写的客户工资管理系统客户端程序

using System;
using System.Data;
using System.Data.OleDb;

using Jinrm.Data;

namespace GzglClient.BLL
{
	/// <summary>
	/// Print_LTX 的摘要说明。
	/// </summary>
	public class Print_LTX
	{
		private DoAccess conn = new DoAccess();

		public string ywitemid = "";
		public string ywitemtype = "";
		public string personid = "";
		public string worgbaseid = "";
		public string orgname = "";
		public string xsf="";

		public string name = "";
		public string sex="";
		public string birth="";
		public string gzsj="";
		public string gznx="";
		public string xxl = "";
		public string yjxl = "";

		public string zxsj = "";
		public string bz = "";

		public string ZZJBDCJE = "";
		public string ZZZGZNoDFBT = "";
		public string DoTime = "";
		public string DoMan = "";

		#region 
		public string ltxsj= "";//离退休时间
		public string lxdyzj= "";//离休待遇职级（职称）
		public string lxfhj= "0";//离休费合计
		public string lxjbf= "0";//离休基本费
		public string lxzwgwjt= "0";//离休职务岗位津贴
		public string lxzhbt= "0";//离休综合补贴

		public string txlb= "";//退休（退职）类别
		public string txdy= "";//退休（退职）待遇职级、职称、工人等级
		public string txfblhj= "0";//退休（退职）费比例合计（％）
		public string txzcbl= "0";//正常比例（％）
		public string txzjbl= "0";//因获荣誉称号、独生子女等原因增加比例（％）
		public string txfhj= "0";//退休（退职）费合计
		public string txjbf= "0";//基本退休（退职）费
		public string txzwgwjt= "0";//职务岗位津贴
		public string txzhbt= "0";//综合补贴
		public string txblbt= "0";//保留补贴
		#endregion

		#region 离休
		/// <summary>
		/// LTXSJ属性说明：离退休时间
		/// </summary>
		public string LTXSJ
		{
			get{return ltxsj;}
			set{ltxsj = value;}
		}

		/// <summary>
		/// LXDYZJ属性说明：离休待遇职级（职称）
		/// </summary>
		public string LXDYZJ
		{
			get{return lxdyzj;}
			set{lxdyzj = value;}
		}

		/// <summary>
		/// LXFHJ属性说明：离休费合计
		/// </summary>
		public string LXFHJ
		{
			get{return lxfhj;}
			set{lxfhj = value;}
		}

		/// <summary>
		/// LXJBF属性说明：离休基本费
		/// </summary>
		public string LXJBF
		{
			get{return lxjbf;}
			set{lxjbf = value;}
		}

		/// <summary>
		/// LXZWGWJT属性说明：离休职务岗位津贴
		/// </summary>
		public string LXZWGWJT
		{
			get{return lxzwgwjt;}
			set{lxzwgwjt = value;}
		}

		/// <summary>
		/// LXZHBT属性说明：离休综合补贴
		/// </summary>
		public string LXZHBT
		{
			get{return lxzhbt;}
			set{lxzhbt = value;}
		}
		#endregion

		#region 退休
		/// <summary>
		/// TXLB属性说明：退休（退职）类别
		/// </summary>
		public string TXLB
		{
			get{return txlb;}
			set{txlb = value;}
		}

		/// <summary>
		/// TXDY属性说明：退休（退职）待遇职级、职称、工人等级
		/// </summary>
		public string TXDY
		{
			get{return txdy;}
			set{txdy = value;}
		}

		/// <summary>
		/// TXFBLHJ属性说明：退休（退职）费比例合计（％）
		/// </summary>
		public string TXFBLHJ
		{
			get{return txfblhj;}
			set{txfblhj = value;}
		}

		/// <summary>
		/// TXZCBL属性说明：正常比例（％）
		/// </summary>
		public string TXZCBL
		{
			get{return txzcbl;}
			set{txzcbl = value;}
		}

		/// <summary>
		/// TXZJBL属性说明：因获荣誉称号、独生子女等原因增加比例（％）
		/// </summary>
		public string TXZJBL
		{
			get{return txzjbl;}
			set{txzjbl = value;}
		}

		/// <summary>
		/// TXFHJ属性说明：退休（退职）费合计
		/// </summary>
		public string TXFHJ
		{
			get{return txfhj;}
			set{txfhj = value;}
		}

		/// <summary>
		/// TXJBF属性说明：基本退休（退职）费
		/// </summary>
		public string TXJBF
		{
			get{return txjbf;}
			set{txjbf = value;}
		}

		/// <summary>
		/// TXZWGWJT属性说明：职务岗位津贴
		/// </summary>
		public string TXZWGWJT
		{
			get{return txzwgwjt;}
			set{txzwgwjt = value;}
		}

		/// <summary>
		/// TXZHBT属性说明：综合补贴
		/// </summary>
		public string TXZHBT
		{
			get{return txzhbt;}
			set{txzhbt = value;}
		}

		/// <summary>
		/// TXBLBT属性说明：保留补贴
		/// </summary>
		public string TXBLBT
		{
			get{return txblbt;}
			set{txblbt = value;}
		}
		#endregion

		public Print_LTX()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		/// <summary>
		/// 设置属性
		/// </summary>
		/// <returns></returns>
		public bool SetProperty()
		{
			#region
			DataSet ds = conn.GetDs("*","TaoGai_LTX","YWItemId ='" + this.ywitemid + "' ","");
			if(ds.Tables[0].Rows.Count == 1)
			{
				this.ywitemid = ds.Tables[0].Rows[0]["YWItemId"].ToString();
				this.ywitemtype = ds.Tables[0].Rows[0]["YWItemType"].ToString();
				this.personid = ds.Tables[0].Rows[0]["WPersonId"].ToString();
				this.worgbaseid = ds.Tables[0].Rows[0]["WOrgBaseId"].ToString();
				this.orgname = ds.Tables[0].Rows[0]["OrgName"].ToString();

				this.name = ds.Tables[0].Rows[0]["Name"].ToString();
				this.sex = ds.Tables[0].Rows[0]["Sex"].ToString();
				try
				{
					this.birth = Convert.ToDateTime(ds.Tables[0].Rows[0]["Birth"].ToString()).ToShortDateString();
				}
				catch{}
				try
				{
					this.gzsj = Convert.ToDateTime(ds.Tables[0].Rows[0]["Gzsj"].ToString()).ToShortDateString();
				}
				catch{}
				this.gznx = ds.Tables[0].Rows[0]["GZNX"].ToString();
//				this.xxl = conn.GetValueFromName("XL","Person_XL","WPersonId = '" + this.personid + "'");
				this.yjxl = ds.Tables[0].Rows[0]["yjxl"].ToString();

				try
				{
					this.ltxsj = Convert.ToDateTime(ds.Tables[0].Rows[0]["LTXSJ"].ToString()).ToShortDateString();
				}
				catch{}
				lxdyzj = ds.Tables[0].Rows[0]["LXDYZJ"].ToString();//离休待遇职级（职称）
				lxfhj = ds.Tables[0].Rows[0]["LXFHJ"].ToString();//离休费合计
				lxjbf = ds.Tables[0].Rows[0]["LXJBF"].ToString();//离休基本费
				lxzwgwjt = ds.Tables[0].Rows[0]["LXZWGWJT"].ToString();//离休职务岗位津贴
				lxzhbt = ds.Tables[0].Rows[0]["LXZHBT"].ToString();//离休综合补贴
				txlb = ds.Tables[0].Rows[0]["TXLB"].ToString();//退休（退职）类别
				txdy = ds.Tables[0].Rows[0]["TXDY"].ToString();//退休（退职）待遇职级、职称、工人等级
				txfblhj = ds.Tables[0].Rows[0]["TXFBLHJ"].ToString();//退休（退职）费比例合计（％）
				txzcbl = ds.Tables[0].Rows[0]["TXZCBL"].ToString();//正常比例（％）
				txzjbl = ds.Tables[0].Rows[0]["TXZJBL"].ToString();//因获荣誉称号、独生子女等原因增加比例（％）
				txfhj = ds.Tables[0].Rows[0]["TXFHJ"].ToString();//退休（退职）费合计
				txjbf = ds.Tables[0].Rows[0]["TXJBF"].ToString();//基本退休（退职）费
				txzwgwjt = ds.Tables[0].Rows[0]["TXZWGWJT"].ToString();//职务岗位津贴
				txzhbt = ds.Tables[0].Rows[0]["TXZHBT"].ToString();//综合补贴
				txblbt = ds.Tables[0].Rows[0]["TXBLBT"].ToString();//保留补贴

				this.ZZJBDCJE = ds.Tables[0].Rows[0]["ZZJBDCJE"].ToString();
				this.ZZZGZNoDFBT = ds.Tables[0].Rows[0]["ZZZGZNoDFBT"].ToString();
				this.bz = "";
				this.zxsj = ds.Tables[0].Rows[0]["ZXSJ"].ToString();
				this.DoTime = ds.Tables[0].Rows[0]["DoTime"].ToString();
				this.DoMan = ds.Tables[0].Rows[0]["DoMan"].ToString();

				txfhj = (Convert.ToDouble(ZZZGZNoDFBT)-Convert.ToDouble(ZZJBDCJE)).ToString();//离休费合计
				txjbf = (Convert.ToDouble(txfhj)-Convert.ToDouble(txzwgwjt)-Convert.ToDouble(txzhbt)-Convert.ToDouble(txblbt)).ToString();//离休基本费
			}
			return true;
			#endregion
		}

		/// <summary>
		/// 获取属性
		/// </summary>
		/// <returns></returns>
		public bool GetProperty(DataSet _ds,string _YWItemId)
		{
			this.ywitemid = _YWItemId;
			if(this.ywitemid == "")
			{
				return false;
			}

			DataView dvPerson = new DataView();
			dvPerson.Table = _ds.Tables["V_Person_GZ"];//人员基本信息
			dvPerson.RowFilter = "WYWItemId = '" + this.ywitemid + "'";

			#region 基本信息
			foreach(DataRowView drv in dvPerson)
			{
				this.personid = drv["PersonId"].ToString();
				this.worgbaseid = drv["WOrgBaseId"].ToString();

				this.name = drv["Name"].ToString();
				this.sex = drv["Sex"].ToString();
				this.birth = drv["Birth"].ToString();
				this.gzsj = drv["Gzsj"].ToString();
				this.gznx = drv["GZNX"].ToString();
				this.yjxl = drv["YJXL"].ToString();

				ltxsj = drv["LTXSJ"].ToString();//离退休时间
				lxdyzj = drv["LXDYZJ"].ToString();//离休待遇职级（职称）
				lxfhj = drv["LXFHJ"].ToString();//离休费合计
				lxjbf = drv["LXJBF"].ToString();//离休基本费
				lxzwgwjt = drv["LXZWGWJT"].ToString();//离休职务岗位津贴
				lxzhbt = drv["LXZHBT"].ToString();//离休综合补贴
				txlb = drv["TXLB"].ToString();//退休（退职）类别
				txdy = drv["TXDY"].ToString();//退休（退职）待遇职级、职称、工人等级
				txfblhj = drv["TXFBLHJ"].ToString();//退休（退职）费比例合计（％）
				txzcbl = drv["TXZCBL"].ToString();//正常比例（％）
				txzjbl = drv["TXZJBL"].ToString();//因获荣誉称号、独生子女等原因增加比例（％）
				txfhj = drv["TXFHJ"].ToString();//退休（退职）费合计
				txjbf = drv["TXJBF"].ToString();//基本退休（退职）费
				txzwgwjt = drv["TXZWGWJT"].ToString();//职务岗位津贴
				txzhbt = drv["TXZHBT"].ToString();//综合补贴
				txblbt = drv["TXBLBT"].ToString();//保留补贴
			}
			#endregion

			#region 学历
			DataView dvXL = new DataView();
			dvXL.Table = _ds.Tables["V_Person_XL"];//人员基本信息
			dvXL.RowFilter = "YWItemId = '" + this.ywitemid + "'";

			foreach(DataRowView drv in dvXL)
			{
				this.xxl = drv["XL"].ToString();
			}
			#endregion

			#region 现工资情况
			DataView dvGZ = new DataView();
			dvGZ.Table = _ds.Tables["V_GZ"];//人员基本信息
			dvGZ.RowFilter = "WYWItemId = '" + this.ywitemid + "'";

			foreach(DataRowView drv in dvGZ)
			{
				this.ZZJBDCJE = drv["ZZJBDCJE"].ToString();
				this.ZZZGZNoDFBT = drv["ZZZGZNoDFBT"].ToString();
				this.bz = "";
			}
			#endregion

			return true;
		}

		/// <summary>
		/// 更新套改信息
		/// </summary>
		public void UpdateTaoGai()
		{
			if (conn.CheckIsExist("TaoGai_LTX", "YWItemId = '"+ this.ywitemid +"'") == false)//如果不存在
			{
				conn.ExecInsert("TaoGai_LTX","YWItemId"," '"+ ywitemid +"' ");
			}

			conn.ExecUpdate("TaoGai_LTX",
				"YWItemType = '"+ this.ywitemtype +//主id
				"',WPersonId = '"+ this.personid +//姓名
				"',WOrgBaseId = '"+ this.worgbaseid +//出生年月
				"',OrgName = '"+ this.orgname +//出生年月
				"',XSF = '"+ this.xsf +//单位id
				"',Name = '"+ this.name +//姓名
				"',Sex = '"+ this.sex +//性别
				"',Birth = '"+ this.birth +//出生年月
				"',GZSJ = '"+ this.gzsj +//身份证
				"',GZNX = '"+ this.gznx +//区划
				"',XXL = '"+ this.xxl +//内设机构id
				"',YJXL = '"+ this.yjxl +//编制性质
				"',LTXSJ = '"+ this.ltxsj +//离退休时间
				"',LXDYZJ = '"+ this.lxdyzj +//离休待遇职级（职称）
				"',LXFHJ = '"+ this.lxfhj +//离休费合计
				"',LXJBF = '"+ this.lxjbf +//离休基本费
				"',LXZWGWJT = '"+ this.lxzwgwjt +//离休职务岗位津贴
				"',LXZHBT = '"+ this.lxzhbt +//离休综合补贴
				"',TXLB = '"+ this.txlb +//退休（退职）类别
				"',TXDY = '"+ this.txdy +//退休（退职）待遇职级、职称、工人等级
				"',TXFBLHJ = '"+ this.txfblhj +//退休（退职）费比例合计（％）
				"',TXZCBL = '"+ this.txzcbl +//正常比例（％）
				"',TXZJBL = '"+ this.txzjbl +//因获荣誉称号、独生子女等原因增加比例（％）
				"',TXFHJ = '"+ this.txfhj +//退休（退职）费合计
				"',TXJBF = '"+ this.txjbf +//基本退休（退职）费
				"',TXZWGWJT = '"+ this.txzwgwjt +//职务岗位津贴
				"',TXZHBT = '"+ this.txzhbt +//综合补贴
				"',TXBLBT = '"+ this.txblbt +//保留补贴
				"',BZ = '"+ this.bz +//人员排序号
				"',ZXSJ = '2006-7-1" +//人员排序号
				"',ZZJBDCJE = '"+ this.ZZJBDCJE +//人员排序号
				"',ZZZGZNoDFBT = '"+ this.ZZZGZNoDFBT +//人员排序号
				"',DoTime = '"+ this.DoTime +//人员排序号
				"',DoMan = '"+ this.DoMan +//人员排序号
				"'","YWItemId = '"+ this.ywitemid +"'");
		}
	}
}