using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;
using?Class_DB;

namespace?Class_BU
{
????public?class?BU_HXX
????{
????????DB_Database?MyDBdatabase?=?new?DB_Database（）;

????????#region??查詢會員表中的所有會員信息??（2009-01-06??何小霞）
????????///?

????????///?查詢會員表中的所有會員信息
????????///?

????????///?返回表
????????public?DataTable?Check_Member（）
????????{
????????????StringBuilder?check_str?=?new?StringBuilder（）;
????????????check_str.Append（“select?Member_No?Member_Name?Member_NameFirst?Member_Sex?“）;
????????????check_str.Append（“Member_Tel?Member_Address?Count_Could?Count_Surplus?“）;
????????????check_str.Append（“Money_Deposit?Count_Total?Reg_DateTime?Remarks?Admin_No???“）;
????????????check_str.Append（“from?Book_MemberBasic??“）;
????????????check_str.Append（“where?Reg_DateTime??between??‘“?+?DateTime.Now.Year.ToString（）?+?“-“?+?DateTime.Now.Month.ToString（）?+?“-“?+?DateTime.Now.Day.ToString（）?+?“?“?+?“00:00:00“?+?“‘“）;
????????????check_str.Append（“??and?‘“?+?DateTime.Now.Year.ToString（）?+?“-“?+?DateTime.Now.Month.ToString（）?+?“-“?+?DateTime.Now.Day.ToString（）?+?“?“?+?“23:59:59“?+?“‘“）;
????????????DataTable?Member_table?=?new?DataTable（）;
????????????Member_table?=?MyDBdatabase.Get_table（check_str.ToString（））;
????????????if?（Member_table?==?null）
????????????{
????????????????return?null;
????????????}
????????????else
????????????{
????????????????return?Member_table;
????????????}
????????}
????????#endregion

????????#region??根據(jù)會員注冊登記日期查詢統(tǒng)計該天的新增會員總數(shù)??（2009-01-06??何小霞）
????????///?

????????///?根據(jù)會員注冊登記日期查詢統(tǒng)計該天的新增會員總數(shù)
????????///?

????????///?今日日期
????????///?返回表
????????public?DataTable?Check_newaddmember（）
????????{
????????????StringBuilder?check_str?=?new?StringBuilder（）;
????????????check_str.Append（“select?count（Member_No）?as?‘今日共新增會員‘?“）;
????????????check_str.Append（“from?Book_MemberBasic??“）;
????????????check_str.Append（“where?Reg_DateTime?between?‘“?+?DateTime.Now.Year.ToString（）?+?“-“?+?DateTime.Now.Month.ToString（）?+?“-“?+?DateTime.Now.Day.ToString（）?+?“?“?+?“00:00:00“?+?“‘?“）;
????????????check_str.Append（“??and?‘“?+?DateTime.Now.Year.ToString（）?+?“-“?+?DateTime.Now.Month.ToString（）?+?“-“?+?DateTime.Now.Day.ToString（）?+?“?“?+?“23:59:59“?+?“‘?“）;
????????????DataTable?Newaddmember_table?=?new?DataTable（）;
????????????Newaddmember_table?=?MyDBdatabase.Get_table（check_str.ToString（））;
????????????if?（Newaddmember_table?==?null）
????????????{
????????????????return?null;
????????????}
????????????else
????????????{
????????????????return?Newaddmember_table;
????????????}
????????}
????????#endregion

????????#region??根據(jù)會員注冊登記日期和會員性別查詢統(tǒng)計該天的新增會員，統(tǒng)計男會員多少人??（2009-01-06??何小霞）
????????///?

????????///?根據(jù)會員注冊登記日期和會員性別查詢統(tǒng)計該天的新增會員，統(tǒng)計男會員多少人
????????///?

????????///?