/// <summary>
/// ���ݲ���categoryId����ȡͼ�������ϸ��Ϣ
/// </summary>
/// <param name="topicID">ͼ�����ID</param>
public void LoadData(int categoryId)
{
Database db=new Database(); //ʵ����һ��Database��
string sql="";
sql="Select * from [Category] where CategoryId = "+ categoryId ;
DataRow dr=db.GetDataRow(sql); //����Database���GetDataRow������ѯ�û�����
//���ݲ�ѯ�õ������ݣ��Գ�Ա��ֵ
if(dr!=null)
{
this._categoryId=GetSafeData.ValidateDataRow_N(dr,"CategoryId");
this._categoryName=GetSafeData.ValidateDataRow_S(dr,"CategoryName");
this._exist=true;
}
else
{
this._exist=false;
}
}
/// <summary>
/// ���ݲ���bookID����ȡͼ����ϸ��Ϣ
/// </summary>
/// <param name="topicID">ͼ��ID</param>
public void LoadData(int bookID)
{
Database db=new Database(); //ʵ����һ��Database��
string sql="";
sql="Select * from [Book] where BookID = "+ bookID ;
DataRow dr=db.GetDataRow(sql); //����Database���GetDataRow������ѯ�û�����
//���ݲ�ѯ�õ������ݣ��Գ�Ա��ֵ
if(dr!=null)
{
this._bookId=GetSafeData.ValidateDataRow_N(dr,"BookID");
this._bookName=GetSafeData.ValidateDataRow_S(dr,"BookName");
this._categoryId=GetSafeData.ValidateDataRow_N(dr,"CategoryId");
this._price=GetSafeData.ValidateDataRow_F(dr,"Price");
this._publisher=GetSafeData.ValidateDataRow_S(dr,"Publisher");
this._publishDate=GetSafeData.ValidateDataRow_T(dr,"PublishDate");
this._author=GetSafeData.ValidateDataRow_S(dr,"Author");
this._pageNum=GetSafeData.ValidateDataRow_N(dr,"PageNum");
this._pictureUrl=GetSafeData.ValidateDataRow_S(dr,"PictureUrl");
this._description=GetSafeData.ValidateDataRow_S(dr,"Description");
this._saleCount=GetSafeData.ValidateDataRow_N(dr,"SaleCount");
this._exist=true;
}
else
{
this._exist=false;
}
}
/// <summary>
/// ���ݲ���loginName����ȡ�û���ϸ��Ϣ
/// </summary>
/// <param name="userId">�û�ID</param>
public void LoadData(int userId)
{
Database db=new Database(); //ʵ����һ��Database��
string sql="";
sql="Select * from [User] where UserId = "+userId.ToString();
DataRow dr=db.GetDataRow(sql); //����Database���GetDataRow������ѯ�û�����
//���ݲ�ѯ�õ������ݣ��Գ�Ա��ֵ
if(dr!=null)
{
this._userID=GetSafeData.ValidateDataRow_N(dr,"UserID");
this._loginName=GetSafeData.ValidateDataRow_S(dr,"loginName");
this._userName=GetSafeData.ValidateDataRow_S(dr,"UserName");
this._password=GetSafeData.ValidateDataRow_S(dr,"PassWord");
this._address=GetSafeData.ValidateDataRow_S(dr,"Address");
this._zip=GetSafeData.ValidateDataRow_S(dr,"Zip");
this._exist=true;
}
else
{
this._exist=false;
}
}
/// <summary>
/// �ж��Ƿ���ڵ�¼��ΪloginName���û�
/// </summary>
/// <param name="loginName">�û���¼��</param>
/// <returns>������ڣ�����true��������false</returns>
public static bool HasUser(string loginName)
{
Database db=new Database();
string sql="";
sql="Select * from [User] where [LoginName] = "
+SqlStringConstructor.GetQuotedString(loginName);
DataRow row=db.GetDataRow(sql);
if(row!=null)
return true;
else
return false;
}
