findinfo.cs

企业管理信息化之财务管理系统

				LogService.Write ("在根据产品代码获取对应的产品名称时发生错误。");
				LogService.Write (e.Message);
				return "Error";
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************


	
	
	
	
		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 根据客户代码获取客户全称
		/// </summary>
		/// <param name="KhId">客户代码</param>
		/// <returns>成功执行时返回客户名称，产生异常时返回"Error"，参数为空时返回null</returns>
		/// **************************************************************************
		public static string FindKh(string KhId)
		{
			if(KhId == null)
				return null;

			string KhName;
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select KHMC From KHXX Where KHDM = '" + KhId + "'";
			cmd.CommandText = sql;
			Connection.Open();
			try
			{
				KhName = cmd.ExecuteScalar().ToString();
				Connection.Close();
				return KhName;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("FindKh(string KhId)");
				LogService.Write ("在根据客户代码获取对应的客户全称时发生错误。");
				LogService.Write (e.Message);
				return "Error";
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************
	

	
	


		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 根据承运商代码获取承运商全称
		/// </summary>
		/// <param name="CysId">承运商代码</param>
		/// <returns>成功执行时返回承运商全称，产生异常时返回"Error"，参数为空时返回null</returns>
		/// **************************************************************************
		public static string FindCys(string CysId)
		{
			if(CysId == null)
				return null;

			string CysName;
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select CYSMC From CYSXX Where CYSDM = '" + CysId + "'";
			cmd.CommandText = sql;
			Connection.Open();
			try
			{
				CysName = cmd.ExecuteScalar().ToString();
				Connection.Close();
				return CysName;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("FindCys(string CysId)");
				LogService.Write ("在根据承运商代码获取对应的承运商全称时发生错误。");
				LogService.Write (e.Message);
				return "Error";
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************
	





		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 根据维修站代码获取维修站全称
		/// </summary>
		/// <param name="WxzId">维修站代码</param>
		/// <returns>成功执行时返回维修站全称，产生异常时返回"Error"，参数为空时返回null</returns>
		/// **************************************************************************
		public static string FindWxz(string WxzId)
		{
			if(WxzId == null)
				return null;

			string WxzName;
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select WXZMC From WXZXX Where WXZDM = '" + WxzId + "'";
			cmd.CommandText = sql;
			Connection.Open();
			try
			{
				WxzName = cmd.ExecuteScalar().ToString();
				Connection.Close();
				return WxzName;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("FindWxz(string WxzId)");
				LogService.Write ("在根据维修站代码获取对应的维修站全称时发生错误。");
				LogService.Write (e.Message);
				return "Error";
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************
	





		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 根据出入库类型代码获取出入库类型名称
		/// </summary>
		/// <param name="CrklxId">出入库类型代码</param>
		/// <returns>成功执行时返回出入库类型名称，产生异常时返回"Error"，参数为空时返回null</returns>
		/// **************************************************************************
		public static string FindCrklx(string CrklxId)
		{
			if(CrklxId == null)
				return null;

			string CrklxName;
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select CRKLXMC From CRKLX Where CRKLXDM = '" + CrklxId + "'";
			cmd.CommandText = sql;
			Connection.Open();
			
			try
			{
				CrklxName = cmd.ExecuteScalar().ToString();
				Connection.Close();
				return CrklxName;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("FindCrklx(string CrklxId)");
				LogService.Write ("在根据出入库类型代码获取对应的出入库类型名称时发生错误。");
				LogService.Write (e.Message);
				return "Error";
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************





		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 根据信用级别代码获取信用级别名称
		/// </summary>
		/// <param name="XyjbId">信用级别代码</param>
		/// <returns>成功执行时返回信用级别名称，产生异常时返回"Error"，参数为空时返回null</returns>
		/// **************************************************************************
		public static string FindXyjb(string XyjbId)
		{
			if(XyjbId == null)
				return null;

			string XyjbName;
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select XYJBMC From XYJB Where XYJBDM = '" + XyjbId + "'";
			cmd.CommandText = sql;
			Connection.Open();
			
			try
			{
				XyjbName = cmd.ExecuteScalar().ToString();
				Connection.Close();
				return XyjbName;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("FindXyjb(string XyjbId)");
				LogService.Write ("在根据信用级别代码获取对应的信用级别名称时发生错误。");
				LogService.Write (e.Message);
				return "Error";
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************







		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 根据竞争对手代码获取竞争对手全称
		/// </summary>
		/// <param name="JzdsId">竞争对手代码</param>
		/// <returns>成功执行时返回竞争对手全称，产生异常时返回"Error"，参数为空时返回null</returns>
		/// **************************************************************************
		public static string FindJzds(string JzdsId)
		{
			if(JzdsId == null)
				return null;

			string JzdsName;
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select DSMC From JZDS Where DSDM = '" + JzdsId + "'";
			cmd.CommandText = sql;
			Connection.Open();
			
			try
			{
				JzdsName = cmd.ExecuteScalar().ToString();
				Connection.Close();
				return JzdsName;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("FindJzds(string JzdsId)");
				LogService.Write ("在根据竞争对手代码获取对应的竞争对手全称时发生错误。");
				LogService.Write (e.Message);
				return "Error";
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************






		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 根据系统参数代码获取系统参数名称
		/// </summary>
		/// <param name="XtcsId">系统参数代码</param>
		/// <returns>成功执行时返回系统参数名称，产生异常时返回"Error"，参数为空时返回null</returns>
		/// **************************************************************************
		public static string FindXtcs(string XtcsId)
		{
			if(XtcsId == null)
				return null;

			string XtcsName;
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select CSMC From XTCS Where CSDM = '" + XtcsId + "'";
			cmd.CommandText = sql;
			Connection.Open();
			
			try
			{
				XtcsName = cmd.ExecuteScalar().ToString();
				Connection.Close();
				return XtcsName;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("FindXtcs(string XtcsId)");
				LogService.Write ("在根据系统参数代码获取对应的系统参数名称时发生错误。参数代码是：[" + XtcsId + "]。");
				LogService.Write (e.Message);
				return "Error";
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************








		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 根据计量单位代码获取计量单位名称
		/// </summary>
		/// <param name="JldwId">计量单位代码</param>
		/// <returns>成功执行时返回计量单位名称，产生异常时返回"Error"，参数为空时返回null</returns>
		/// **************************************************************************
		public static string FindJldw(string JldwId)
		{
			if(JldwId == null)
				return null;

			string JldwName;
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select JLDWMC From JLDW Where JLDWDM = '" + JldwId + "'";
			cmd.CommandText = sql;
			Connection.Open();
			
			try
			{
				JldwName = cmd.ExecuteScalar().ToString();
				Connection.Close();
				return JldwName;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("FindJldw(string JldwId)");
				LogService.Write ("在根据计量单位代码获取对应的计量单位名称时发生错误。");
				LogService.Write (e.Message);
				return "Error";
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************



		

		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 根据采购计划代码获取采购计划名称
		/// </summary>
		/// <param name="CgjhId">采购计划代码</param>
		/// <returns>成功执行时返回采购计划名称，产生异常时返回"Error"，参数为空时返回null</returns>
		/// **************************************************************************
		public static string FindCgjh(string CgjhId)
		{
			if(CgjhId == null)
				return null;

			string CgjhName;
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select JHMC From CGJHDB Where JHDID = '" + CgjhId + "'";
			cmd.CommandText = sql;
			Connection.Open();
			
			try
			{
				CgjhName = cmd.ExecuteScalar().ToString();
				Connection.Close();
				return CgjhName;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("FindCgjh(string JgjhId)");
				LogService.Write ("在根据采购计划代码获取对应的采购计划名称时发生错误。");
				LogService.Write (e.Message);
				return "Error";
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************