/// <summary>
		/// 得到一个对象实体
		/// </summary>
		public DB_Talk.Model.v_DispatchLog GetModel(int ID)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("  select top 1 ");
			strSql.Append("  ID, BoxID, ManagerID, dt_DateTime, DispatchNumber, DispatchTypeID, DispatchedNumbers, i_Result, i_State, vc_Memo, UserName, BoxName, ActionType, Result  ");			
			strSql.Append("  from v_DispatchLog ");
			strSql.Append("  where ID='"+ID+"'");   	  
			DB_Talk.Model.v_DispatchLog model=new DB_Talk.Model.v_DispatchLog();
			DataSet ds=GetDataSet(strSql.ToString());
			if(ds!=null && ds.Tables[0].Rows.Count>0)
			{
	            model=DataTableToList(ds)[0];						
				return model;
			}
			else
			{
				return null;
			}
		} 
		/// <summary>
		/// 获得数据列表
		/// </summary>
		public List<DB_Talk.Model.v_DispatchLog> DataTableToList(DataSet ds)
		{
			List<DB_Talk.Model.v_DispatchLog> modelList = new List<DB_Talk.Model.v_DispatchLog>();
			if (ds == null) return modelList;
            DataTable dt = ds.Tables[0];
			int rowsCount = dt.Rows.Count;
			if (rowsCount > 0)
			{
				DB_Talk.Model.v_DispatchLog model;
				for (int n = 0; n < rowsCount; n++)
				{
				  model = new DB_Talk.Model.v_DispatchLog();	
                  if(dt.Rows[n]["ID"]!=null && dt.Rows[n]["ID"].ToString()!="")
				  {
				      model.ID=int.Parse(dt.Rows[n]["ID"].ToString());
				  }
				  if(dt.Rows[n]["BoxID"]!=null && dt.Rows[n]["BoxID"].ToString()!="")
				  {
				      model.BoxID=int.Parse(dt.Rows[n]["BoxID"].ToString());
				  }
				  if(dt.Rows[n]["ManagerID"]!=null && dt.Rows[n]["ManagerID"].ToString()!="")
				  {
				      model.ManagerID=int.Parse(dt.Rows[n]["ManagerID"].ToString());
				  }
				  if(dt.Rows[n]["dt_DateTime"]!=null && dt.Rows[n]["dt_DateTime"].ToString()!="")
				  {
				      model.dt_DateTime=DateTime.Parse(dt.Rows[n]["dt_DateTime"].ToString());
				  }
				  if(dt.Rows[n]["DispatchNumber"]!=null && dt.Rows[n]["DispatchNumber"].ToString()!="")
				  {
				      model.DispatchNumber=int.Parse(dt.Rows[n]["DispatchNumber"].ToString());
				  }
				  if(dt.Rows[n]["DispatchTypeID"]!=null && dt.Rows[n]["DispatchTypeID"].ToString()!="")
				  {
				      model.DispatchTypeID=int.Parse(dt.Rows[n]["DispatchTypeID"].ToString());
				  }
				  if(dt.Rows[n]["DispatchedNumbers"]!=null && dt.Rows[n]["DispatchedNumbers"].ToString()!="")
				  {
				     model.DispatchedNumbers= dt.Rows[n]["DispatchedNumbers"].ToString();
				  }
				  if(dt.Rows[n]["i_Result"]!=null && dt.Rows[n]["i_Result"].ToString()!="")
				  {
				      model.i_Result=int.Parse(dt.Rows[n]["i_Result"].ToString());
				  }
				  if(dt.Rows[n]["i_State"]!=null && dt.Rows[n]["i_State"].ToString()!="")
				  {
				      model.i_State=int.Parse(dt.Rows[n]["i_State"].ToString());
				  }
				  if(dt.Rows[n]["vc_Memo"]!=null && dt.Rows[n]["vc_Memo"].ToString()!="")
				  {
				     model.vc_Memo= dt.Rows[n]["vc_Memo"].ToString();
				  }
				  if(dt.Rows[n]["UserName"]!=null && dt.Rows[n]["UserName"].ToString()!="")
				  {
				     model.UserName= dt.Rows[n]["UserName"].ToString();
				  }
				  if(dt.Rows[n]["BoxName"]!=null && dt.Rows[n]["BoxName"].ToString()!="")
				  {
				     model.BoxName= dt.Rows[n]["BoxName"].ToString();
				  }
				  if(dt.Rows[n]["ActionType"]!=null && dt.Rows[n]["ActionType"].ToString()!="")
				  {
				     model.ActionType= dt.Rows[n]["ActionType"].ToString();
				  }
				  if(dt.Rows[n]["Result"]!=null && dt.Rows[n]["Result"].ToString()!="")
				  {
				     model.Result= dt.Rows[n]["Result"].ToString();
				  }
				   modelList.Add(model);
				
				}
			}
			return modelList;
		}