findinfo.cs

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

using System;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using com.unicafe.common;


namespace com.ascs.plp.publics
{
	/// <summary>
	/// FindInfo 的摘要说明。
	/// </summary>
	public class FindInfo
	{
		/// <summary>
		/// 类构造函数
		/// </summary>
		public FindInfo()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}




		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 根据员工代号获取员工姓名
		/// </summary>
		/// <param name="EmplId">员工代号</param>
		/// <returns>成功执行时返回员工姓名，产生异常时返回"Error"，参数为空时返回null</returns>
		/// **************************************************************************
		public static string FindEmpl(string EmplId)
		{
			if(EmplId == null)
				return null;

			string EmplName;
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select (EmplNameL + EmplNameF) EmplName From Employees Where EmplId = '" + EmplId + "'";
			cmd.CommandText = sql;
			Connection.Open();
			try
			{
				EmplName = cmd.ExecuteScalar().ToString();
				Connection.Close();
				return EmplName;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("FindEmpl(string EmplId)");
				LogService.Write ("在根据员工代码获取对应的员工姓名时发生错误。");
				LogService.Write (e.Message);
				return "Error";
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************




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

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

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

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







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

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






		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 根据部门代号获取部门全称
		/// </summary>
		/// <param name="DeptID">部门代号</param>
		/// <returns>成功执行时返回部门全称，产生异常时返回"Error"，参数为空时返回null</returns>
		/// **************************************************************************
		public static string FindDept(string DeptId)
		{
			if(DeptId == null)
				return null;

			string DeptName;
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "select DeptName from departments Where DeptID = '" + DeptId + "'";
			cmd.CommandText = sql;
			Connection.Open();
			try
			{
				DeptName = cmd.ExecuteScalar().ToString();
				Connection.Close();
				return DeptName;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("FindDept(DeptId)");
				LogService.Write ("在根据部门代号获取部门全称时发生错误。");
				LogService.Write (e.Message);
				return "Error";
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************
 







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

			string CkName;
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select CKMC From CKB Where CKDM = '" + CkId + "'";
			cmd.CommandText = sql;
			Connection.Open();
			try
			{
				CkName = cmd.ExecuteScalar().ToString();
				Connection.Close();
				return CkName;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("FindKw(string CkId, string KwId)");
				LogService.Write ("在根据仓库代码获取对应的仓库名称时发生错误。");
				LogService.Write (e.Message);
				return "Error";
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************
	




		

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

			string CkName;
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select CKMC From WBKF Where CKDM = '" + CkId + "'";
			cmd.CommandText = sql;
			Connection.Open();
			try
			{
				CkName = cmd.ExecuteScalar().ToString();
				Connection.Close();
				return CkName;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("FindWbck(string CkId)");
				LogService.Write ("在根据外部仓库代码获取对应的外部仓库名称时发生错误。");
				LogService.Write (e.Message);
				return "Error";
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************






		/// **************************************************************************
		/// BEIGIN
		/// <summary>
		/// 根据仓库代码和库位代码获取库位名称
		/// </summary>
		/// <param name="CkId">仓库代码</param>
		/// <param name="KwId">库位代码</param>
		/// <returns>成功执行时返回库位名称，产生异常时返回"Error"，参数为空时返回null</returns>
		/// **************************************************************************
		public static string FindKw(string CkId, string KwId)
		{
			if(CkId == null || KwId == null)
				return null;

			string KwName;
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select KWMC From KWB Where CKDM = '" + CkId + "' And KWDM = '" + KwId + "'";
			cmd.CommandText = sql;
			Connection.Open();
			try
			{
				KwName = cmd.ExecuteScalar().ToString();
				Connection.Close();
				return KwName;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("FindKw(string CkId, string KwId)");
				LogService.Write ("在根据仓库代码和库位代码获取对应的库位名称时发生错误。");
				LogService.Write (e.Message);
				return "Error";
			}
		}
		/// **************************************************************************
		/// END
		/// **************************************************************************






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

			string CpName;
			System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
			string sql = "Select CPMC From CPJBXX Where CPDM = '" + CpId + "'";
			cmd.CommandText = sql;
			Connection.Open();
			try
			{
				CpName = cmd.ExecuteScalar().ToString();
				Connection.Close();
				return CpName;
			}
			catch(Exception e)
			{
				Connection.Close();
				LogService.Write ("FindCp(string CpId)");