/// <summary>
/// ���붩����Ϣ
/// </summary>
/// <param name="st_order"></param>
/// <returns></returns>
public int InsertOrder(ST_BookBiz.ST_OrderEntity st_order)
{
string sqlString = @"insert into ST_Order(ST_UserID,ST_CreateTime,ST_Ship,ST_Payment,ST_Sum,ST_Desciption,ST_Consignee,ST_ConsingeeEmail,ST_ConsingeePhone,ST_ConsingeeAddress,ST_ConsingeePostcode,ST_ConsingeeGender)
values('"+st_order.ST_UserID+"','"+st_order.ST_CreateTime+"','"+st_order.ST_Ship+"','"+st_order.ST_Payment+"','"+st_order.ST_Sum+"','"+st_order.ST_Desciption+"','"+st_order.ST_Consignee+"','"+st_order.ST_ConsingeeEmail+"','"+st_order.ST_ConsingeePhone+"','"+st_order.ST_ConsingeeAddress+"','"+st_order.ST_ConsingeePostcode+"','"+st_order.ST_ConsingeeGender+"'); select scope_identity();";
object obj = SqlHelper.ExecuteScalar(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
if(obj!=null)
return int.Parse(obj.ToString());
return 0;
}
/// <summary>
/// �����û���Ϣ
/// </summary>
/// <param name="st_user"></param>
/// <returns></returns>
public int InsertUser(ST_BookBiz.ST_UserEntity st_user)
{
string sqlString = @"insert into ST_Users(ST_Name,ST_Pass,ST_TrueName,ST_Address,ST_Telephone,ST_Email,ST_Postcode,ST_Gender,ST_Type)
values('"+st_user.ST_Name+"','"+st_user.ST_Pass+"','"+st_user.ST_TrueName+"','"+st_user.ST_Address+"','"+st_user.ST_Telephone+"','"+st_user.ST_Email+"','"+st_user.ST_Postcode+"','"+st_user.ST_Gender+"','User'); select scope_identity();";
object obj = SqlHelper.ExecuteScalar(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
if(obj!=null)
return int.Parse(obj.ToString());
return 0;
}
/// <summary>
/// ������Ʒ��Ϣ
/// </summary>
/// <param name="st_product"></param>
public void UpdateProduct(ST_BookBiz.ST_ProductEntity st_product)
{
string sqlString = "update ST_Product set ST_ProductName='"+st_product.ST_ProductName+"',ST_Price='"+st_product.ST_Price+"',ST_SoldPrice='"+st_product.ST_SoldPrice+"',ST_Publisher='"+st_product.ST_Publisher+"',ST_ISBN='"+st_product.ST_ISBN+"',ST_Page='"+st_product.ST_Page+"',ST_PublishDate='"+st_product.ST_PublishDate+"',ST_ClassID='"+st_product.ST_ClassID+"',ST_Image='"+st_product.ST_Image+"',ST_IsSelling='"+(st_product.ST_IsSelling?1:0)+"' where ST_ProductID="+st_product.ST_ProductID;
SqlHelper.ExecuteNonQuery(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
}
/// <summary>
/// ������Ʒ��Ϣ
/// </summary>
/// <param name="st_product"></param>
/// <returns></returns>
public int InsertProduct(ST_BookBiz.ST_ProductEntity st_product)
{
string sqlString = @"insert into ST_Product(ST_ProductName,ST_Price,ST_SoldPrice,ST_Publisher,ST_ISBN,ST_Page,ST_PublishDate,ST_ClassID,ST_Image,ST_IsSelling)
values('"+st_product.ST_ProductName+"','"+st_product.ST_Price+"','"+st_product.ST_SoldPrice+"','"+st_product.ST_Publisher+"','"+st_product.ST_ISBN+"','"+st_product.ST_Page+"','"+st_product.ST_PublishDate+"','"+st_product.ST_ClassID+"','"+st_product.ST_Image+"','"+(st_product.ST_IsSelling?1:0)+"'); select scope_identity();";
object obj = SqlHelper.ExecuteScalar(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
if(obj!=null)
return int.Parse(obj.ToString());
return 0;
}
/// <summary>
/// �����û���Ϣ
/// </summary>
/// <param name="st_user"></param>
public void UpdateUser(ST_BookBiz.ST_UserEntity st_user)
{
string sqlString = "update ST_Users set ST_Name='"+st_user.ST_Name+"',ST_Pass='******',ST_TrueName='"+st_user.ST_TrueName+"',ST_Address='"+st_user.ST_Address+"',ST_Telephone='"+st_user.ST_Telephone+"',ST_Email='"+st_user.ST_Email+"',ST_Postcode='"+st_user.ST_Postcode+"',ST_Gender='"+st_user.ST_Gender+"' where st_userid="+st_user.ST_UserID;
SqlHelper.ExecuteNonQuery(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
}
