111,126
社区成员
发帖
与我相关
我的任务
分享
namespace Js.BLL
{
public class Message
{
Js.IDAL.IMessage dal = DataBaseProvider<Js.IDAL.IMessage>.GetInstance("Message");
public Js.Model.Message[] GetMessage()
{
return dal.GetMessage();
}
}
}
namespace Js.Data
{
public class DataBaseProvider<T>
{
private DataBaseProvider()
{ }
private static T _instance = default(T);
private static object lockHelper = new object();
private static string _clsName = "";
private static void GetProvider()
{
try
{
_instance = (T)Assembly.Load("Js.Data.SqlServer").CreateInstance("Js.Data.SqlServer."+ _clsName);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public static T GetInstance(string clsName)
{
_clsName = clsName;
if (_instance == null)
{
lock (lockHelper)
{
if (_instance == null)
{
GetProvider();
}
}
}
return _instance;
}
}
}
namespace Js.Data.SqlServer
{
public class Message : Js.Data.DbHelper, Js.IDAL.IMessage
{
public Js.Model.Message[] GetMessage()
{
ArrayList ArrMsg = new ArrayList();
string SQL_STR = "SELECT [MessageBody], [MessageTime] FROM [MessageBoard] ORDER BY [MessageTime] DESC";
DbDataReader dt = ExecuteReader(CommandType.Text, SQL_STR, null);
while (dt.Read())
{
Js.Model.Message msg = new Js.Model.Message();
msg.MessageBody = (string)dt["MessageBody"];
msg.MessageTime = (DateTime)dt["MessageTime"];
ArrMsg.Add(msg);
}
return (Js.Model.Message[])ArrMsg.ToArray(typeof(Js.Model.Message));
}
}
}
private Js.BLL.Message bllMsg = new Js.BLL.Message();
//private Js.BLL.Message bllMsg = new Js.BLL.Message();
private Js.BLL.Message bllMsg = new Js.BLL.Message();