ywitem.cs

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

using System;
using System.Web;
using System.Web.UI;
using System.Data;
using System.Data.OleDb;


using Jinrm.Data;
//using Jinrm.Public;


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

		#region 自定义变量
		private string ywitemid= "";//
		private string ywitembh= "";//
		private string ywitemtype= "";//
		private string wpersonid= "";//
		private string worgbaseid= "";//
		private string posttime= "";//
		private string description= "";//
		
		private string zgbmresult= "";//
		private string zgbmdotime= "";//
		private string wzgbmorgbaseid= "";//
		private string zgbmdescription= "";//

		private string gzcresult= "";//
		private string gzcdotime= "";//
		private string wsystemuserid= "";//
		private string gzcdescription= "";//
		#endregion

		#region 自定义属性
		/// <summary>
		/// YWItemID属性说明：
		/// </summary>
		public string YWItemID
		{
			get
			{
				return ywitemid;
			}
			set
			{
				ywitemid = value;
			}
		}

		/// <summary>
		/// YWItemBH属性说明：
		/// </summary>
		public string YWItemBH
		{
			get
			{
				return ywitembh;
			}
			set
			{
				ywitembh = value;
			}
		}

		/// <summary>
		/// YWItemType属性说明：
		/// </summary>
		public string YWItemType
		{
			get
			{
				return ywitemtype;
			}
			set
			{
				ywitemtype = value;
			}
		}

		/// <summary>
		/// WPersonId属性说明：
		/// </summary>
		public string WPersonId
		{
			get
			{
				return wpersonid;
			}
			set
			{
				wpersonid = value;
			}
		}

		/// <summary>
		/// WOrgBaseId属性说明：
		/// </summary>
		public string WOrgBaseId
		{
			get
			{
				return worgbaseid;
			}
			set
			{
				worgbaseid = value;
			}
		}

		/// <summary>
		/// PostTime属性说明：
		/// </summary>
		public string PostTime
		{
			get
			{
				return posttime;
			}
			set
			{
				posttime = value;
			}
		}

		/// <summary>
		/// Description属性说明：
		/// </summary>
		public string Description
		{
			get
			{
				return description;
			}
			set
			{
				description = value;
			}
		}

		/// <summary>
		/// ZGBMResult属性说明：
		/// </summary>
		public string ZGBMResult
		{
			get
			{
				return zgbmresult;
			}
			set
			{
				zgbmresult = value;
			}
		}

		/// <summary>
		/// ZGBMDoTime属性说明：
		/// </summary>
		public string ZGBMDoTime
		{
			get
			{
				return zgbmdotime;
			}
			set
			{
				zgbmdotime = value;
			}
		}

		/// <summary>
		/// WZGBMOrgBaseId属性说明：
		/// </summary>
		public string WZGBMOrgBaseId
		{
			get
			{
				return wzgbmorgbaseid;
			}
			set
			{
				wzgbmorgbaseid = value;
			}
		}

		/// <summary>
		/// ZGBMDescription属性说明：
		/// </summary>
		public string ZGBMDescription
		{
			get
			{
				return zgbmdescription;
			}
			set
			{
				zgbmdescription = value;
			}
		}

		/// <summary>
		/// GZCResult属性说明：
		/// </summary>
		public string GZCResult
		{
			get
			{
				return gzcresult;
			}
			set
			{
				gzcresult = value;
			}
		}

		/// <summary>
		/// GZCDoTime属性说明：
		/// </summary>
		public string GZCDoTime
		{
			get
			{
				return gzcdotime;
			}
			set
			{
				gzcdotime = value;
			}
		}

		/// <summary>
		/// WSystemUserID属性说明：
		/// </summary>
		public string WSystemUserID
		{
			get
			{
				return wsystemuserid;
			}
			set
			{
				wsystemuserid = value;
			}
		}

		/// <summary>
		/// GZCDescription属性说明：
		/// </summary>
		public string GZCDescription
		{
			get
			{
				return gzcdescription;
			}
			set
			{
				gzcdescription = value;
			}
		}

		#endregion

		/// <summary>
		/// 业务操作类
		/// </summary>
		public YWItem()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		#region 设置属性
		/// <summary>
		/// 设置属性
		/// </summary>
		/// <param name="Id"></param>
		public void SetProperty(string Id)
		{
//			OleDbDataReader ds.Tables[0].Rows[0] = conn.GetDr("*","YWItem","YWItemID ='" + Id + "' ");
//			if(ds.Tables[0].Rows[0].Read())
			DataSet ds = conn.GetDs("*","YWItem","YWItemID ='" + Id + "' ","");
			if(ds.Tables[0].Rows.Count == 1)
			{
				ywitemid = ds.Tables[0].Rows[0]["YWItemID"].ToString();//
				ywitemtype = ds.Tables[0].Rows[0]["YWItemType"].ToString();//
				wpersonid = ds.Tables[0].Rows[0]["WPersonId"].ToString();//
				worgbaseid = ds.Tables[0].Rows[0]["WOrgBaseId"].ToString();//
				posttime = ds.Tables[0].Rows[0]["PostTime"].ToString();//
				description = ds.Tables[0].Rows[0]["Description"].ToString();//
				
				zgbmresult = ds.Tables[0].Rows[0]["ZGBMResult"].ToString();//
				zgbmdotime = ds.Tables[0].Rows[0]["ZGBMDoTime"].ToString();//
				wzgbmorgbaseid = ds.Tables[0].Rows[0]["WZGBMOrgBaseId"].ToString();//
				zgbmdescription = ds.Tables[0].Rows[0]["ZGBMDescription"].ToString();//
				
				gzcresult = ds.Tables[0].Rows[0]["GZCResult"].ToString();//
				gzcdotime = ds.Tables[0].Rows[0]["GZCDoTime"].ToString();//
				wsystemuserid = ds.Tables[0].Rows[0]["WSystemUserID"].ToString();//
				gzcdescription = ds.Tables[0].Rows[0]["GZCDescription"].ToString();//
			}
			conn.Close();
		}
		#endregion

		#region Update方法
		/// <summary>
		/// 
		/// </summary>
		public void UpdateYWItem()
		{
			if(conn.CheckIsExist("YWItem", "YWItemID = '"+ this.ywitemid +"'") == false)//如果ID不存在,先要创建ID和排序号
			{
				this.ywitemid = GetFlowNumber(worgbaseid);
				conn.ExecInsert("YWItem","YWItemID"," '"+ this.ywitemid +"' ");
			}

			UpdateBasic();
		}

		private void UpdateBasic()
		{
			//Y240daa1e-1802-4808-8a15-4c1e245b41ac-20061019001
			conn.ExecUpdate("YWItem",
				"YWItemBH = '"+ this.ywitemid.Substring(38,11) +//
				"',YWItemType = '"+ this.ywitemtype +//
				"',WPersonId = '"+ this.wpersonid +//
				"',WOrgBaseId = '"+ this.worgbaseid +//
				"',PostTime = '"+ this.posttime +//
				"',Description = '"+ this.description +//
				
				"',ZGBMResult = '"+ this.zgbmresult +//
				"',ZGBMDoTime = '"+ this.zgbmdotime +//
				"',WZGBMOrgBaseId = '"+ this.wzgbmorgbaseid +//
				"',ZGBMDescription = '"+ this.zgbmdescription +//
				
				"',GZCResult = '"+ this.gzcresult +//
				"',GZCDoTime = '"+ this.gzcdotime +//
				"',WSystemUserID = '"+ this.wsystemuserid +//
				"',GZCDescription = '"+ this.gzcdescription +//
				"'","YWItemID = '"+ this.ywitemid +"'");
		}

		///<summary>
		///  根据数据库表名称识别出流水号//YW+OrgBaseId+年月日+编号
		///</summary>
		public string GetFlowNumber(string _OrgBaseId)
		{
			string flag = "Y";
			int ID = 1;
			string str = "";
			string FlowNumber = "";
			try 
			{

				FlowNumber = flag + _OrgBaseId + "-" + DateTime.Now.ToString("yyyyMMdd");
				
				string sqlstr = "select top 1 * from YWItem where YWItemID like '%" + FlowNumber + "%' order by PostTime desc";

//				OleDbDataReader dr = conn.GetDr(sqlstr);
//				if(dr.Read())
				DataSet ds = conn.GetDs(sqlstr,"");
				if(ds.Tables[0].Rows.Count == 1)
				{
					str= ds.Tables[0].Rows[0]["YWItemID"].ToString();
					str = str.Substring(9,3);
					ID = int.Parse(str) + 1;
				}

				FlowNumber += ID.ToString().PadLeft(3,'0');;
				conn.Close();
				return FlowNumber;
			}
			catch
			{
				conn.Close();
				return "-1";
			}
		}
		#endregion
	}
}