/// <summary>
/// 更新偏好信息
/// </summary>
/// <param name="mode">模式</param>
/// <param name="file_md5">图片MD5</param>
/// <param name="prefer"></param>
/// <returns></returns>
public static int UpdatePrefer(Mode mode, string file_md5, Prefer prefer)
{
string commandText = string.Empty;
List <SQLiteParameter> paramList = new List <SQLiteParameter>();
if (prefer == Prefer.Normal)
{
commandText = string.Format("DELETE FROM {0} WHERE file_md5 = @file_md5", mode.ToString());
paramList.Add(new SQLiteParameter("@file_md5", file_md5));
}
else
{
commandText = string.Format("DELETE FROM {0} WHERE file_md5 = @file_md5;INSERT INTO {0} VALUES (@file_md5,@prefer)", mode.ToString());
paramList.Add(new SQLiteParameter("@file_md5", file_md5));
paramList.Add(new SQLiteParameter("@prefer", prefer.ToString("d")));
}
SQLiteCommand command = SQLiteHelper.CreateCommand(DBConn.prefer, commandText, paramList.ToArray());
return(SQLiteHelper.ExecuteNonQuery(command));
}
/// <summary>
/// 更新一条数据
/// </summary>
public static Boolean Update(Member model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update members set ");
strSql.Append("seller_id=@seller_id,");
strSql.Append("user_id=@user_id,");
strSql.Append("no=@no,");
strSql.Append("real_no=@real_no,");
strSql.Append("level_id=@level_id,");
strSql.Append("score=@score,");
strSql.Append("money=@money,");
strSql.Append("gift_money=@gift_money,");
strSql.Append("reg_from=@reg_from,");
strSql.Append("remark=@remark,");
strSql.Append("status=@status,");
strSql.Append("is_new=@is_new,");
strSql.Append("is_delete=@is_delete,");
strSql.Append("recommend_id=@recommend_id,");
strSql.Append("created_at=@created_at,");
strSql.Append("updated_at=@updated_at,");
strSql.Append("last_at=@last_at");
strSql.Append(" where id=@id");
List <SQLiteParameter> parameters = GetParameters(model);
SQLiteParameter idParams = new SQLiteParameter("@id", DbType.Int32, 8);
idParams.Value = model.Id;
parameters.Add(idParams);
int num = SQLiteHelper.ExecuteNonQuery(SQLiteHelper.ConnectionStringLocalTransaction, CommandType.Text, strSql.ToString(), parameters.ToArray <SQLiteParameter>());
if (num > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public static Boolean Create(OrderDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into orders_details(");
strSql.Append("order_id,goods_id,spec_id,price,num,size,color,set_meal,remark,use_flag,created_at,updated_at, last_updated_at)");
strSql.Append(" values (");
strSql.Append("@order_id,@goods_id,@spec_id,@price,@num,@size,@color,@set_meal,@remark,@use_flag,@created_at,@updated_at, @last_updated_at)");
strSql.Append(";select LAST_INSERT_ROWID()");
List <SQLiteParameter> parameters = GetParameters(model);
int num = SQLiteHelper.ExecuteNonQuery(SQLiteHelper.ConnectionStringLocalTransaction, CommandType.Text, strSql.ToString(), parameters.ToArray <SQLiteParameter>());
if (num > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 创建一个订单
/// </summary>
/// <param name="model">订单数据</param>
/// <returns></returns>
public static Boolean Create(Order model)
{
Boolean flag = false;
if (model == null)
{
return(flag);
}
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into orders(");
strSql.Append("order_no,order_name,order_body,order_url,payment_type,original_money,money,invoice_title,user_id,from_id,emp_id,order_type,order_status,feedback_status,transport_fee,remark,arrived_at,express_at,sign_at,close_at,refund_at,is_delete,created_at,updated_at,pay_at,feedback_at,buyer_id)");
strSql.Append(" values (");
strSql.Append("@order_no,@order_name,@order_body,@order_url,@payment_type,@original_money,@money,@invoice_title,@user_id,@from_id,@emp_id,@order_type,@order_status,@feedback_status,@transport_fee,@remark,@arrived_at,@express_at,@sign_at,@close_at,@refund_at,@is_delete,@created_at,@updated_at,@pay_at,@feedback_at,@buyer_id)");
strSql.Append(";select LAST_INSERT_ROWID()");
List <SQLiteParameter> parameters = GetParameters(model);
int num = SQLiteHelper.ExecuteNonQuery(SQLiteHelper.ConnectionStringLocalTransaction, CommandType.Text, strSql.ToString(), parameters.ToArray <SQLiteParameter>());
flag = num > 0;
return(flag);
}
/// <summary>
/// 创建一个订单
/// </summary>
/// <param name="model">订单数据</param>
/// <returns></returns>
public static Boolean Create(People model)
{
Boolean flag = false;
if (model == null)
{
return(flag);
}
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into peoples(");
strSql.Append("user_id,first_name,last_name,alias,gender,birthday,age,identity,photo,country_id,province_id,city_id,county_id,address,phone,tel,email,qq,msn,weight,height,hobby,interest,introduce,motto,created_at,updated_at)");
strSql.Append(" values (");
strSql.Append("@user_id,@first_name,@last_name,@alias,@gender,@birthday,@age,@identity,@photo,@country_id,@province_id,@city_id,@county_id,@address,@phone,@tel,@email,@qq,@msn,@weight,@height,@hobby,@interest,@introduce,@motto,@created_at,@updated_at)");
strSql.Append(";select LAST_INSERT_ROWID()");
List <SQLiteParameter> parameters = GetParameters(model);
SQLiteParameter idParams = new SQLiteParameter("@id", DbType.Int32, 8);
int num = SQLiteHelper.ExecuteNonQuery(SQLiteHelper.ConnectionStringLocalTransaction, CommandType.Text, strSql.ToString(), parameters.ToArray <SQLiteParameter>());
flag = num > 0;
return(flag);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static Boolean Update(OrderDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update orders_details set ");
strSql.Append("order_id=@order_id,");
strSql.Append("goods_id=@goods_id,");
strSql.Append("spec_id=@spec_id,");
strSql.Append("price=@price,");
strSql.Append("num=@num,");
strSql.Append("size=@size,");
strSql.Append("color=@color,");
strSql.Append("set_meal=@set_meal,");
strSql.Append("remark=@remark,");
strSql.Append("use_flag=@use_flag,");
strSql.Append("created_at=@created_at,");
strSql.Append("updated_at=@updated_at,");
strSql.Append("last_updated_at=@last_updated_at");
strSql.Append(" where id=@id");
List <SQLiteParameter> parameters = GetParameters(model);
SQLiteParameter idParams = new SQLiteParameter("@id", DbType.Int32, 8);
idParams.Value = model.Id;
parameters.Add(idParams);
int num = SQLiteHelper.ExecuteNonQuery(SQLiteHelper.ConnectionStringLocalTransaction, CommandType.Text, strSql.ToString(), parameters.ToArray <SQLiteParameter>());
if (num > 0)
{
return(true);
}
else
{
return(false);
}
}