main.cs

用vs2005写的一个生产任务管理系统。数据的统计和综合查询是主要功能

using System; 

namespace RWSB.Modules
{
	public class Module
	{
		public static string UserName(int UserID)
		{
			RWSB.DatabaseOper.DatabaseConnect oDatabaseOper=new RWSB.DatabaseOper.DatabaseConnect();
			return oDatabaseOper.GetValueBySql("select UserName from Users where ID='"+UserID.ToString()+"'");
		}
		public static string[] UserName(int[] UserID)
		{	
			if(UserID.Length<=0)
				return new string[0];
			string sql="select UserName from Users  where ID in (";
			for(int i=0;i<UserID.Length;i++)
			{
				if(i>0)
					sql+=",";
				sql+="'"+UserID[i].ToString()+"'";
				
			}
			sql+=")";
			RWSB.DatabaseOper.DatabaseConnect oDatabaseOper=new RWSB.DatabaseOper.DatabaseConnect();
			System.Collections.ArrayList oArrayList=oDatabaseOper.getData(sql);
			string[] username=new string[oArrayList.Count];
			for(int i=0;i<oArrayList.Count;i++)
			{
				username[i]=oArrayList[i].ToString();
			}
			return username;
		}
		
	}
}