orgitem_xz.cs

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

using System;
using Jinrm.Data;

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

		#region 机构基础表 变量定义
		private string orgbaseid= "";//主id
		private string parentid= "";//父id
		private string ismainorg= "";//是否是一级单位
		private string orgareaid= "";//区划Id
		private string orgsort= "";//排序号
		private string orgname= "";//机构名称
		private string orgitname= "";//其他名称
		private string wssxtid= "";//所属系统-系统类别
		private string wjglxid="";//
		private string imageurl= "";//图标
		private string description= "";//备注
		private string isstop = "false";//是否停用，默认值false
		private string dosystem = "GZ";//默认BB（编制），GZ（工资）
		#endregion

		#region 机构基础表 属性定义
		/// <summary>
		/// OrgBaseId属性说明：主id
		/// </summary>
		public string OrgBaseId
		{
			get{return orgbaseid;}
			set{orgbaseid = value;}
		}

		/// <summary>
		/// ParentId属性说明：父id
		/// </summary>
		public string ParentId
		{
			get{return parentid;}
			set{parentid = value;}
		}

		/// <summary>
		/// IsMainOrg属性说明：是否是一级单位
		/// </summary>
		public string IsMainOrg
		{
			get{return ismainorg;}
			set{ismainorg = value;}
		}

		/// <summary>
		/// OrgAreaId属性说明：区划Id
		/// </summary>
		public string OrgAreaId
		{
			get{return orgareaid;}
			set{orgareaid = value;}
		}

		/// <summary>
		/// OrgSort属性说明：排序号
		/// </summary>
		public string OrgSort
		{
			get{return orgsort;}
			set{orgsort = value;}
		}

		/// <summary>
		/// OrgName属性说明：机构名称
		/// </summary>
		public string OrgName
		{
			get{return orgname;}
			set{orgname = value;}
		}

		/// <summary>
		/// OrgItName属性说明：其他名称
		/// </summary>
		public string OrgItName
		{
			get{return orgitname;}
			set{orgitname = value;}
		}

		/// <summary>
		/// ImageUrl属性说明：图标
		/// </summary>
		public string ImageUrl
		{
			get{return imageurl;}
			set{imageurl = value;}
		}

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

		/// <summary>
		/// IsStop属性说明：是否停用
		/// </summary>
		public string IsStop
		{
			get{return isstop;}
			set{isstop = value;}
		}

		/// <summary>
		/// DoSystem属性说明：何系统添加
		/// </summary>
		public string DoSystem
		{
			get{return dosystem;}
			set{dosystem = value;}
		}

		/// <summary>
		/// WSSXTId属性说明：所属系统-系统类别
		/// </summary>
		public string WSSXTId
		{
			get{return wssxtid;}
			set{wssxtid = value;}
		}

		/// <summary>
		/// WJGLXId属性说明：
		/// </summary>
		public string WJGLXId
		{
			get{return wjglxid;}
			set{wjglxid = value;}
		}
		#endregion

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

		#region Update方法集
		/// <summary>
		/// 主更新方法，如果Id存在则更新，不存在则创建
		/// </summary>-
		public string UpdateOrgBase()
		{
			if(conn.CheckIsExist("OrgBase", "OrgBaseId = '"+ this.orgbaseid +"'") == false)//如果ID不存在,先要创建ID和排序号
			{
				conn.ExecInsert("OrgBase","OrgBaseId"," '"+ this.orgbaseid +"' ");
			}
			
			UpdateBasic();//基本情况

			return orgbaseid;
		}

		/// <summary>
		/// 更新基本信息
		/// </summary>
		private void UpdateBasic()
		{
			conn.ExecUpdate("OrgBase",
				"OrgBaseId = '"+ this.orgbaseid +//主id
				"',ParentId = '"+ this.parentid +//父id
				"',IsMainOrg = '"+ this.ismainorg +//是否是一级单位
				"',OrgAreaId = '"+ this.orgareaid +//区划id
				"',OrgSort = '"+ this.orgsort +//排序号
				"',OrgName = '"+ this.orgname +//机构名称
				"',OrgItName = '"+ this.orgitname +//其他名称
				"',WSSXTId = '"+ this.wssxtid +//所属系统
				"',WJGLXId = '"+ this.wjglxid +//机构类型
				"',ImageUrl = '"+ this.imageurl +//图标
				"',Description = '"+ this.description +//备注
				"',IsStop = '"+ this.isstop +//是否停用
				"',DoSystem = '"+ this.dosystem +//操作的系统
				"'","OrgBaseId = '"+ orgbaseid +"'");
		}
		#endregion
	}
}