/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="AdminUser"></param>
/// <returns></returns>
public int UpdateAdminUser(AdminUser AdminUser)
{
string sql = $"{ CreateSqlString.UpdateSqlString(AdminUser) } WHERE SuId =@SuId";
var pars = CreateSqlString.SqlParameterArray(AdminUser);
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
/// <summary>
/// 添加信息
/// </summary>
/// <param name="Delivery"></param>
/// <returns></returns>
public int AddDelivery(Delivery Delivery)
{
string sql = CreateSqlString.InsertSqlString(Delivery);
var pars = CreateSqlString.SqlParameterArray(Delivery);
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="News"></param>
/// <returns></returns>
public int UpdateNews(News News)
{
string sql = $"{ CreateSqlString.UpdateSqlString(News) } WHERE NewsId =@NewsId";
var pars = CreateSqlString.SqlParameterArray(News);
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
/// <summary>
/// 添加信息
/// </summary>
/// <param name="AdminUser"></param>
/// <returns></returns>
public int AddAdminUser(AdminUser AdminUser)
{
string sql = CreateSqlString.InsertSqlString(AdminUser);
var pars = CreateSqlString.SqlParameterArray(AdminUser);
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="Appraise"></param>
/// <returns></returns>
public int UpdateAppraise(Appraise Appraise)
{
string sql = CreateSqlString.UpdateSqlString(Appraise) + " WHERE AppraiseId =@AppraiseId";
var pars = CreateSqlString.SqlServerParameterArray(Appraise);
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="Orders"></param>
/// <returns></returns>
public int UpdateOrders(Orders Orders)
{
string sql = CreateSqlString.UpdateSqlString(Orders) + " WHERE OrdersId =@OrdersId";
var pars = CreateSqlString.SqlServerParameterArray(Orders);
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
/// <summary>
/// 添加信息
/// </summary>
/// <param name="Product"></param>
/// <returns></returns>
public int AddProduct(Product Product)
{
//string sql = "insert into Product(ProductId,Title,CateId,MarketPrice,Price,Content,PostTime,Stock) values(@ProductId,@Title,@CateId,@MarketPrice,@Price,@Content,@PostTime,@Stock)";
string sql = CreateSqlString.InsertSqlString(Product);
var pars = CreateSqlString.SqlParameterArray(Product);
//MySqlParameter[] pars = {
// new MySqlParameter("@ProductId",MySqlDbType.VarChar,32),
// new MySqlParameter("@Title",MySqlDbType.VarChar,32),
// new MySqlParameter("@CateId",MySqlDbType.VarChar,32),
// new MySqlParameter("@MarketPrice",MySqlDbType.Decimal),
// new MySqlParameter("@Price",MySqlDbType.Decimal),
// new MySqlParameter("@Stock",MySqlDbType.Int32),
// new MySqlParameter("@PostTime",MySqlDbType.DateTime),
// new MySqlParameter("@Content",MySqlDbType.Text),
// };
//pars[0].Value = Product.ProductId;
//pars[1].Value = Product.Title;
//pars[2].Value = Product.CateId;
//pars[3].Value = Product.MarketPrice;
//pars[4].Value = Product.Price;
//pars[5].Value = Product.Content;
//pars[5].Value = Product.PostTime;
//pars[7].Value = Product.Stock;
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
/// <summary>
/// 添加信息
/// </summary>
/// <param name="Orders"></param>
/// <returns></returns>
public int AddOrders(Orders Orders)
{
string sql = CreateSqlString.InsertSqlString(Orders);
var pars = CreateSqlString.SqlServerParameterArray(Orders);
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="Product"></param>
/// <returns></returns>
public int UpdateProduct(Product Product)
{
string sql = $"{ CreateSqlString.UpdateSqlString(Product) } WHERE ProductId =@ProductId";
var pars = CreateSqlString.SqlParameterArray(Product);
//MySqlParameter[] pars = {
// new MySqlParameter("@ProductId",MySqlDbType.VarChar,32),
// new MySqlParameter("@Title",MySqlDbType.VarChar,32),
// new MySqlParameter("@CateId",MySqlDbType.VarChar,32),
// new MySqlParameter("@MarketPrice",MySqlDbType.Decimal),
// new MySqlParameter("@Price",MySqlDbType.Decimal),
// new MySqlParameter("@Stock",MySqlDbType.Int32),
// new MySqlParameter("@PostTime",MySqlDbType.DateTime),
// new MySqlParameter("@Content",MySqlDbType.Text),
// };
//pars[0].Value = Product.ProductId;
//pars[1].Value = Product.Title;
//pars[2].Value = Product.CateId;
//pars[3].Value = Product.MarketPrice;
//pars[4].Value = Product.Price;
//pars[5].Value = Product.Content;
//pars[5].Value = Product.PostTime;
//pars[7].Value = Product.Stock;
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="Photo"></param>
/// <returns></returns>
public int UpdatePhoto(Photo Photo)
{
string sql = CreateSqlString.UpdateSqlString(Photo) + " WHERE PhotoId =@PhotoId";
var pars = CreateSqlString.SqlServerParameterArray(Photo);
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="Detail"></param>
/// <returns></returns>
public int UpdateDetail(Detail Detail)
{
string sql = CreateSqlString.UpdateSqlString(Detail) + " WHERE DetailId =@DetailId";
var pars = CreateSqlString.SqlServerParameterArray(Detail);
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="Delivery"></param>
/// <returns></returns>
public int UpdateDelivery(Delivery Delivery)
{
string sql = $"{ CreateSqlString.UpdateSqlString(Delivery) } WHERE DeliveryId =@DeliveryId";
var pars = CreateSqlString.SqlParameterArray(Delivery);
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
/// <summary>
/// 添加信息
/// </summary>
/// <param name="Appraise"></param>
/// <returns></returns>
public int AddAppraise(Appraise Appraise)
{
string sql = CreateSqlString.InsertSqlString(Appraise);
var pars = CreateSqlString.SqlServerParameterArray(Appraise);
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
/// <summary>
/// 更新信息
/// </summary>
/// <param name="Favorite"></param>
/// <returns></returns>
public int UpdateFavorite(Favorite Favorite)
{
string sql = CreateSqlString.UpdateSqlString(Favorite) + " WHERE FavoriteId =@FavoriteId";
var pars = CreateSqlString.SqlServerParameterArray(Favorite);
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="category"></param>
/// <returns></returns>
public int Updatecategory(Category category)
{
string sql = $"{ CreateSqlString.UpdateSqlString(category) } WHERE CateId =@CateId";
var pars = CreateSqlString.SqlParameterArray(category);
//string sql = "UPDATE Category SET CateName = @CateName,ParentId = @ParentId, WHERE CateId = @CateId";
//MySqlParameter[] pars = {
// new MySqlParameter("@CateName",MySqlDbType.VarChar,50),
// new MySqlParameter("@ParentId",MySqlDbType.VarChar,50),
// new MySqlParameter("@CateId",MySqlDbType.VarChar),
// };
//pars[0].Value = category.CateName;
//pars[1].Value = category.ParentId;
//pars[2].Value = category.CateId;
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
/// <summary>
/// 删除用户信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DeleteDelivery(string id)
{
try
{
string sql = $"{ CreateSqlString.DeleteSqlString(new Delivery { }) } WHERE DeliveryId = @DeliveryId";
MySqlParameter[] pars =
{
new MySqlParameter("@DeliveryId", MySqlDbType.VarChar, 36)
};
pars[0].Value = id;
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
catch
{
throw;
}
}
/// <summary>
/// 删除用户信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DeleteAppraise(string id)
{
try
{
string sql = CreateSqlString.DeleteSqlString(new Appraise {
}) + " WHERE AppraiseId = @AppraiseId";
SqlParameter[] pars =
{
new SqlParameter("@AppraiseId", SqlDbType.VarChar, 36)
};
pars[0].Value = id;
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
catch
{
throw;
}
}
/// <summary>
/// 分页获取列表
/// </summary>
/// <returns></returns>
public List <Orders> GetList(int page, int index)
{
string sql = $"{CreateSqlString.SelectSqlString(new Orders { }) }limit {((page - 1) * index)}, {index}";
DataTable da = SqlHelper.GetDataTable(sql, CommandType.Text);
List <Orders> list = null;
if (da.Rows.Count > 0)
{
list = new List <Orders>();
Orders Orders = null;
foreach (DataRow row in da.Rows)
{
Orders = new Orders();
LoadEntity(Orders, row);
list.Add(Orders);
}
}
return(list);
}
/// <summary>
/// 分页获取列表
/// </summary>
/// <returns></returns>
public List <Product> GetList(int page, int index)
{
string sql = $"{CreateSqlString.SelectSqlString(new Product { }) }limit {((page - 1) * index)}, {index}";
DataTable da = SqlHelper.GetDataTable(sql, CommandType.Text);
List <Product> list = null;
if (da.Rows.Count > 0)
{
list = new List <Product>();
Product Product = null;
foreach (DataRow row in da.Rows)
{
Product = new Product();
LoadEntity(Product, row);
list.Add(Product);
}
}
return(list);
}
/// <summary>
/// 分页获取列表
/// </summary>
/// <returns></returns>
public List <AdminUser> GetList(int page, int index)
{
string sql = $"{CreateSqlString.SelectSqlString(new AdminUser { }) }limit {((page - 1) * index)}, {index}";
DataTable da = SqlHelper.GetDataTable(sql, CommandType.Text);
List <AdminUser> list = null;
if (da.Rows.Count > 0)
{
list = new List <AdminUser>();
AdminUser AdminUser = null;
foreach (DataRow row in da.Rows)
{
AdminUser = new AdminUser();
LoadEntity(AdminUser, row);
list.Add(AdminUser);
}
}
return(list);
}
/// <summary>
/// 分页获取列表
/// </summary>
/// <returns></returns>
public List <Delivery> GetList(int page, int index)
{
string sql = $"{CreateSqlString.SelectSqlString(new Delivery { }) }limit {((page - 1) * index)}, {index}";
DataTable da = SqlHelper.GetDataTable(sql, CommandType.Text);
List <Delivery> list = null;
if (da.Rows.Count > 0)
{
list = new List <Delivery>();
Delivery Delivery = null;
foreach (DataRow row in da.Rows)
{
Delivery = new Delivery();
LoadEntity(Delivery, row);
list.Add(Delivery);
}
}
return(list);
}
/// <summary>
/// 获取一条用户信息 By ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Delivery GetDeail(int id)
{
string sql = $"{ CreateSqlString.SelectSqlString(new Delivery { })} WHERE DeliveryId =@DeliveryId ";
MySqlParameter[] pars =
{
new MySqlParameter("@DeliveryId", SqlDbType.Int)
};
pars[0].Value = id;
DataTable dt = SqlHelper.GetDataTable(sql, CommandType.Text, pars);
Delivery instance = null;
if (dt.Rows.Count > 0)
{
instance = new Delivery();
LoadEntity(instance, dt.Rows[0]);
}
return(instance);
}
///// <summary>
///// 获取列表
///// </summary>
///// <returns></returns>
//public List<Orders> UserOrderDetailJoin()
//{
// string sql
// return null;
//}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public List <Orders> GetList()
{
string sql = CreateSqlString.SelectSqlString(new Orders {
});
DataTable da = SqlHelper.GetDataTable(sql, CommandType.Text);
List <Orders> list = new List <Orders>();
if (da.Rows.Count > 0)
{
list = new List <Orders>();
Orders Orders = null;
foreach (DataRow row in da.Rows)
{
Orders = new Orders();
LoadEntity(Orders, row);
list.Add(Orders);
}
}
return(list);
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public List <Photo> GetList()
{
string sql = CreateSqlString.SelectSqlString(new Photo {
});
DataTable da = SqlHelper.GetDataTable(sql, CommandType.Text);
List <Photo> list = null;
if (da.Rows.Count > 0)
{
list = new List <Photo>();
Photo Photo = null;
foreach (DataRow row in da.Rows)
{
Photo = new Photo();
LoadEntity(Photo, row);
list.Add(Photo);
}
}
return(list);
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public List <Detail> GetList()
{
string sql = CreateSqlString.SelectSqlString(new Detail {
});
DataTable da = SqlHelper.GetDataTable(sql, CommandType.Text);
List <Detail> list = null;
if (da.Rows.Count > 0)
{
list = new List <Detail>();
Detail Detail = null;
foreach (DataRow row in da.Rows)
{
Detail = new Detail();
LoadEntity(Detail, row);
list.Add(Detail);
}
}
return(list);
}
/// <summary>
/// 获取一条用户信息 By ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Appraise GetDeail(int id)
{
string sql = CreateSqlString.SelectSqlString(new Appraise {
}) + " WHERE AppraiseId =@AppraiseId ";
SqlParameter[] pars =
{
new SqlParameter("@AppraiseId", SqlDbType.Int)
};
pars[0].Value = id;
DataTable dt = SqlHelper.GetDataTable(sql, CommandType.Text, pars);
Appraise instance = null;
if (dt.Rows.Count > 0)
{
instance = new Appraise();
LoadEntity(instance, dt.Rows[0]);
}
return(instance);
}
/// <summary>
/// 分页获取列表
/// </summary>
/// <returns></returns>
public List <Favorite> GetList(int page, int index)
{
string sql = CreateSqlString.SelectSqlString(new Favorite {
}); //limit {((page - 1) * index)}, {index}";
DataTable da = SqlHelper.GetDataTable(sql, CommandType.Text);
List <Favorite> list = null;
if (da.Rows.Count > 0)
{
list = new List <Favorite>();
Favorite Favorite = null;
foreach (DataRow row in da.Rows)
{
Favorite = new Favorite();
LoadEntity(Favorite, row);
list.Add(Favorite);
}
}
return(list);
}
//public List<ProductEx> ProductJoinImage()
//{
// string sql
//}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public List <Product> GetList()
{
string sql = CreateSqlString.SelectSqlString(new Product {
});
DataTable da = SqlHelper.GetDataTable(sql, CommandType.Text);
List <Product> list = new List <Product> {
};
if (da.Rows.Count > 0)
{
list = new List <Product>();
Product Product = null;
foreach (DataRow row in da.Rows)
{
Product = new Product();
LoadEntity(Product, row);
list.Add(Product);
}
}
return(list);
}
/// <summary>
/// 分页获取列表
/// </summary>
/// <returns></returns>
public List <Appraise> GetList(int page, int index)
{
string sql = CreateSqlString.SelectSqlString(new Appraise {
}); //}limit {((page - 1) * index)}, {index}";
DataTable da = SqlHelper.GetDataTable(sql, CommandType.Text);
List <Appraise> list = new List <Appraise> {
};
if (da.Rows.Count > 0)
{
list = new List <Appraise>();
Appraise Appraise = null;
foreach (DataRow row in da.Rows)
{
Appraise = new Appraise();
LoadEntity(Appraise, row);
list.Add(Appraise);
}
}
return(list);
}
/// <summary>
/// 分页获取列表
/// </summary>
/// <returns></returns>
public List <News> GetList(int page, int index)
{
string sql = CreateSqlString.SelectSqlString(new News {
}); //+" limit " +((page - 1) * index), {index}";
DataTable da = SqlHelper.GetDataTable(sql, CommandType.Text);
List <News> list = new List <News> {
};
if (da.Rows.Count > 0)
{
list = new List <News>();
News News = null;
foreach (DataRow row in da.Rows)
{
News = new News();
LoadEntity(News, row);
list.Add(News);
}
}
return(list);
}
