/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_article model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into tb_article(");
strSql.Append("article_type,article_content,article_imgs,article_barrage,article_user_id,article_time,article_statu)");
strSql.Append(" values (");
strSql.Append("@article_type,@article_content,@article_imgs,@article_barrage,@article_user_id,@article_time,@article_statu)");
MySqlParameter[] parameters = {
new MySqlParameter("@article_type", MySqlDbType.Int32,4),
new MySqlParameter("@article_content", MySqlDbType.VarChar,255),
new MySqlParameter("@article_imgs", MySqlDbType.VarChar,2048),
new MySqlParameter("@article_barrage", MySqlDbType.Int32,1),
new MySqlParameter("@article_user_id", MySqlDbType.Int32,10),
new MySqlParameter("@article_time", MySqlDbType.Int32,10),
new MySqlParameter("@article_statu", MySqlDbType.Int32,3)};
parameters[0].Value = model.article_type;
parameters[1].Value = model.article_content;
parameters[2].Value = model.article_imgs;
parameters[3].Value = model.article_barrage;
parameters[4].Value = model.article_user_id;
parameters[5].Value = model.article_time;
parameters[6].Value = model.article_statu;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_lntegral_users model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into tb_lntegral_users(");
strSql.Append("openid,prizeid,address,name,cellphone,createdate)");
strSql.Append(" values (");
strSql.Append("@openid,@prizeid,@address,@name,@cellphone,@createdate)");
MySqlParameter[] parameters = {
new MySqlParameter("@openid", MySqlDbType.VarChar,45),
new MySqlParameter("@prizeid", MySqlDbType.Int32,11),
new MySqlParameter("@address", MySqlDbType.VarChar,100),
new MySqlParameter("@name", MySqlDbType.VarChar,45),
new MySqlParameter("@cellphone", MySqlDbType.VarChar,45),
new MySqlParameter("@createdate", MySqlDbType.DateTime)};
parameters[0].Value = model.openid;
parameters[1].Value = model.prizeid;
parameters[2].Value = model.address;
parameters[3].Value = model.name;
parameters[4].Value = model.cellphone;
parameters[5].Value = model.createdate;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_prizes model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into tb_prizes(");
strSql.Append("prizes_prize_name,prizes_quantity,prizes_main_img,prizes_angle,prizes_probability,prizes_remark,prizes_create_time,prizes_status)");
strSql.Append(" values (");
strSql.Append("@prizes_prize_name,@prizes_quantity,@prizes_main_img,@prizes_angle,@prizes_probability,@prizes_remark,@prizes_create_time,@prizes_status)");
MySqlParameter[] parameters = {
new MySqlParameter("@prizes_prize_name", MySqlDbType.VarChar,50),
new MySqlParameter("@prizes_quantity", MySqlDbType.Int32,11),
new MySqlParameter("@prizes_main_img", MySqlDbType.VarChar,50),
new MySqlParameter("@prizes_angle", MySqlDbType.VarChar,50),
new MySqlParameter("@prizes_probability", MySqlDbType.VarChar,50),
new MySqlParameter("@prizes_remark", MySqlDbType.VarChar,255),
new MySqlParameter("@prizes_create_time", MySqlDbType.DateTime),
new MySqlParameter("@prizes_status", MySqlDbType.Int32,11)};
parameters[0].Value = model.prizes_prize_name;
parameters[1].Value = model.prizes_quantity;
parameters[2].Value = model.prizes_main_img;
parameters[3].Value = model.prizes_angle;
parameters[4].Value = model.prizes_probability;
parameters[5].Value = model.prizes_remark;
parameters[6].Value = model.prizes_create_time;
parameters[7].Value = model.prizes_status;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_log model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into tb_log(");
strSql.Append("log_userid,log_openid,log_operation,log_event,log_remarks,log_ip,log_time,log_state)");
strSql.Append(" values (");
strSql.Append("@log_userid,@log_openid,@log_operation,@log_event,@log_remarks,@log_ip,@log_time,@log_state)");
MySqlParameter[] parameters = {
new MySqlParameter("@log_userid", MySqlDbType.Int32,11),
new MySqlParameter("@log_openid", MySqlDbType.VarChar,50),
new MySqlParameter("@log_operation", MySqlDbType.VarChar,50),
new MySqlParameter("@log_event", MySqlDbType.Text),
new MySqlParameter("@log_remarks", MySqlDbType.VarChar,255),
new MySqlParameter("@log_ip", MySqlDbType.VarChar,20),
new MySqlParameter("@log_time", MySqlDbType.DateTime),
new MySqlParameter("@log_state", MySqlDbType.Int32,5)};
parameters[0].Value = model.log_userid;
parameters[1].Value = model.log_openid;
parameters[2].Value = model.log_operation;
parameters[3].Value = model.log_event;
parameters[4].Value = model.log_remarks;
parameters[5].Value = model.log_ip;
parameters[6].Value = model.log_time;
parameters[7].Value = model.log_state;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_signin model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into tb_signin(");
strSql.Append("openid,type,createdtime)");
strSql.Append(" values (");
strSql.Append("@openid,@type,@createdtime)");
MySqlParameter[] parameters = {
new MySqlParameter("@openid", MySqlDbType.VarChar,45),
new MySqlParameter("@type", MySqlDbType.VarChar,45),
new MySqlParameter("@createdtime", MySqlDbType.DateTime)};
parameters[0].Value = model.openid;
parameters[1].Value = model.type;
parameters[2].Value = model.createdtime;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_lntegral_prize model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into tb_lntegral_prize(");
strSql.Append("lntegral_prize_name,lntegral_prize_cost,lntegral_prize_status,lntegral_prize_img,lntegral_prize_batch,lntegral_prize_num)");
strSql.Append(" values (");
strSql.Append("@lntegral_prize_name,@lntegral_prize_cost,@lntegral_prize_status,@lntegral_prize_img,@lntegral_prize_batch,@lntegral_prize_num)");
MySqlParameter[] parameters = {
new MySqlParameter("@lntegral_prize_name", MySqlDbType.VarChar,45),
new MySqlParameter("@lntegral_prize_cost", MySqlDbType.Int32,11),
new MySqlParameter("@lntegral_prize_status", MySqlDbType.VarChar,45),
new MySqlParameter("@lntegral_prize_img", MySqlDbType.VarChar,45),
new MySqlParameter("@lntegral_prize_batch", MySqlDbType.Int32,3),
new MySqlParameter("@lntegral_prize_num", MySqlDbType.Int32,5)};
parameters[0].Value = model.lntegral_prize_name;
parameters[1].Value = model.lntegral_prize_cost;
parameters[2].Value = model.lntegral_prize_status;
parameters[3].Value = model.lntegral_prize_img;
parameters[4].Value = model.lntegral_prize_batch;
parameters[5].Value = model.lntegral_prize_num;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_activity model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into tb_activity(");
strSql.Append("activity_hyid,activity_openid,activity_reason,activity_num,activity_calculate,activity_state,activity_times)");
strSql.Append(" values (");
strSql.Append("@activity_hyid,@activity_openid,@activity_reason,@activity_num,@activity_calculate,@activity_state,@activity_times)");
MySqlParameter[] parameters = {
new MySqlParameter("@activity_hyid", MySqlDbType.Int32,11),
new MySqlParameter("@activity_openid", MySqlDbType.VarChar,50),
new MySqlParameter("@activity_reason", MySqlDbType.VarChar,50),
new MySqlParameter("@activity_num", MySqlDbType.Int32,11),
new MySqlParameter("@activity_calculate", MySqlDbType.Int32,11),
new MySqlParameter("@activity_state", MySqlDbType.Int32,11),
new MySqlParameter("@activity_times", MySqlDbType.DateTime)};
parameters[0].Value = model.activity_hyid;
parameters[1].Value = model.activity_openid;
parameters[2].Value = model.activity_reason;
parameters[3].Value = model.activity_num;
parameters[4].Value = model.activity_calculate;
parameters[5].Value = model.activity_state;
parameters[6].Value = model.activity_times;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_imgs model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into tb_imgs(");
strSql.Append("imgs_path,imgs_etag,imgs_path_md5,imgs_mime,imgs_height,imgs_width,imgs_size,imgs_quote,imgs_score,imgs_score_tip,imgs_score_task,imgs_time)");
strSql.Append(" values (");
strSql.Append("@imgs_path,@imgs_etag,@imgs_path_md5,@imgs_mime,@imgs_height,@imgs_width,@imgs_size,@imgs_quote,@imgs_score,@imgs_score_tip,@imgs_score_task,@imgs_time)");
MySqlParameter[] parameters = {
new MySqlParameter("@imgs_path", MySqlDbType.VarChar,255),
new MySqlParameter("@imgs_etag", MySqlDbType.VarChar,32),
new MySqlParameter("@imgs_path_md5", MySqlDbType.VarChar,32),
new MySqlParameter("@imgs_mime", MySqlDbType.VarChar,128),
new MySqlParameter("@imgs_height", MySqlDbType.Int32,11),
new MySqlParameter("@imgs_width", MySqlDbType.Int32,11),
new MySqlParameter("@imgs_size", MySqlDbType.Int32,11),
new MySqlParameter("@imgs_quote", MySqlDbType.Int32,10),
new MySqlParameter("@imgs_score", MySqlDbType.Int32,3),
new MySqlParameter("@imgs_score_tip", MySqlDbType.Int32,3),
new MySqlParameter("@imgs_score_task", MySqlDbType.VarChar,128),
new MySqlParameter("@imgs_time", MySqlDbType.Int32,11)};
parameters[0].Value = model.imgs_path;
parameters[1].Value = model.imgs_etag;
parameters[2].Value = model.imgs_path_md5;
parameters[3].Value = model.imgs_mime;
parameters[4].Value = model.imgs_height;
parameters[5].Value = model.imgs_width;
parameters[6].Value = model.imgs_size;
parameters[7].Value = model.imgs_quote;
parameters[8].Value = model.imgs_score;
parameters[9].Value = model.imgs_score_tip;
parameters[10].Value = model.imgs_score_task;
parameters[11].Value = model.imgs_time;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_behavior model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into tb_behavior(");
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(")");
MySqlParameter[] parameters = {
};
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_news model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into tb_news(");
strSql.Append("news_category,news_title,news_introduce,news_text,news_relative_path,news_absolute_path,news_recom,news_top,news_time,news_remarks)");
strSql.Append(" values (");
strSql.Append("@news_category,@news_title,@news_introduce,@news_text,@news_relative_path,@news_absolute_path,@news_recom,@news_top,@news_time,@news_remarks)");
MySqlParameter[] parameters = {
new MySqlParameter("@news_category", MySqlDbType.VarChar,50),
new MySqlParameter("@news_title", MySqlDbType.VarChar,100),
new MySqlParameter("@news_introduce", MySqlDbType.VarChar,255),
new MySqlParameter("@news_text", MySqlDbType.Text),
new MySqlParameter("@news_relative_path", MySqlDbType.VarChar,255),
new MySqlParameter("@news_absolute_path", MySqlDbType.VarChar,255),
new MySqlParameter("@news_recom", MySqlDbType.Int32,11),
new MySqlParameter("@news_top", MySqlDbType.Int32,11),
new MySqlParameter("@news_time", MySqlDbType.DateTime),
new MySqlParameter("@news_remarks", MySqlDbType.Text)};
parameters[0].Value = model.news_category;
parameters[1].Value = model.news_title;
parameters[2].Value = model.news_introduce;
parameters[3].Value = model.news_text;
parameters[4].Value = model.news_relative_path;
parameters[5].Value = model.news_absolute_path;
parameters[6].Value = model.news_recom;
parameters[7].Value = model.news_top;
parameters[8].Value = model.news_time;
parameters[9].Value = model.news_remarks;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_figure model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into tb_figure(");
strSql.Append("figure_hyid,figure_openid,figure_title,figure_category,figure_classify,figure_sellprice,figure_introduce,figure_condition,figure_time,figure_state)");
strSql.Append(" values (");
strSql.Append("@figure_hyid,@figure_openid,@figure_title,@figure_category,@figure_classify,@figure_sellprice,@figure_introduce,@figure_condition,@figure_time,@figure_state)");
MySqlParameter[] parameters = {
new MySqlParameter("@figure_hyid", MySqlDbType.Int32,11),
new MySqlParameter("@figure_openid", MySqlDbType.VarChar,50),
new MySqlParameter("@figure_title", MySqlDbType.VarChar,100),
new MySqlParameter("@figure_category", MySqlDbType.VarChar,50),
new MySqlParameter("@figure_classify", MySqlDbType.VarChar,50),
new MySqlParameter("@figure_sellprice", MySqlDbType.Float),
new MySqlParameter("@figure_introduce", MySqlDbType.Text),
new MySqlParameter("@figure_condition", MySqlDbType.VarChar,10),
new MySqlParameter("@figure_time", MySqlDbType.DateTime),
new MySqlParameter("@figure_state", MySqlDbType.Int32,11)};
parameters[0].Value = model.figure_hyid;
parameters[1].Value = model.figure_openid;
parameters[2].Value = model.figure_title;
parameters[3].Value = model.figure_category;
parameters[4].Value = model.figure_classify;
parameters[5].Value = model.figure_sellprice;
parameters[6].Value = model.figure_introduce;
parameters[7].Value = model.figure_condition;
parameters[8].Value = model.figure_time;
parameters[9].Value = model.figure_state;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_code model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into tb_code(");
strSql.Append("code_code,code_userid,code_openid,code_prizeid,code_prize_name,code_main_img,code_remark,code_create_time,code_status)");
strSql.Append(" values (");
strSql.Append("@code_code,@code_userid,@code_openid,@code_prizeid,@code_prize_name,@code_main_img,@code_remark,@code_create_time,@code_status)");
MySqlParameter[] parameters = {
new MySqlParameter("@code_code", MySqlDbType.VarChar,50),
new MySqlParameter("@code_userid", MySqlDbType.Int32,11),
new MySqlParameter("@code_openid", MySqlDbType.VarChar,50),
new MySqlParameter("@code_prizeid", MySqlDbType.Int32,11),
new MySqlParameter("@code_prize_name", MySqlDbType.VarChar,50),
new MySqlParameter("@code_main_img", MySqlDbType.VarChar,50),
new MySqlParameter("@code_remark", MySqlDbType.VarChar,255),
new MySqlParameter("@code_create_time", MySqlDbType.DateTime),
new MySqlParameter("@code_status", MySqlDbType.Int32,11)};
parameters[0].Value = model.code_code;
parameters[1].Value = model.code_userid;
parameters[2].Value = model.code_openid;
parameters[3].Value = model.code_prizeid;
parameters[4].Value = model.code_prize_name;
parameters[5].Value = model.code_main_img;
parameters[6].Value = model.code_remark;
parameters[7].Value = model.code_create_time;
parameters[8].Value = model.code_status;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MZZ.Model.tb_signin model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update tb_signin set ");
strSql.Append("openid=@openid,");
strSql.Append("type=@type,");
strSql.Append("createdtime=@createdtime");
strSql.Append(" where id=@id");
MySqlParameter[] parameters = {
new MySqlParameter("@openid", MySqlDbType.VarChar,45),
new MySqlParameter("@type", MySqlDbType.VarChar,45),
new MySqlParameter("@createdtime", MySqlDbType.DateTime),
new MySqlParameter("@id", MySqlDbType.Int32,11)};
parameters[0].Value = model.openid;
parameters[1].Value = model.type;
parameters[2].Value = model.createdtime;
parameters[3].Value = model.id;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MZZ.Model.tb_article model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MZZ.Model.tb_lntegral_users model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update tb_lntegral_users set ");
strSql.Append("openid=@openid,");
strSql.Append("prizeid=@prizeid,");
strSql.Append("address=@address,");
strSql.Append("name=@name,");
strSql.Append("cellphone=@cellphone,");
strSql.Append("createdate=@createdate");
strSql.Append(" where id=@id");
MySqlParameter[] parameters = {
new MySqlParameter("@openid", MySqlDbType.VarChar,45),
new MySqlParameter("@prizeid", MySqlDbType.Int32,11),
new MySqlParameter("@address", MySqlDbType.VarChar,100),
new MySqlParameter("@name", MySqlDbType.VarChar,45),
new MySqlParameter("@cellphone", MySqlDbType.VarChar,45),
new MySqlParameter("@createdate", MySqlDbType.DateTime),
new MySqlParameter("@id", MySqlDbType.Int32,11)};
parameters[0].Value = model.openid;
parameters[1].Value = model.prizeid;
parameters[2].Value = model.address;
parameters[3].Value = model.name;
parameters[4].Value = model.cellphone;
parameters[5].Value = model.createdate;
parameters[6].Value = model.id;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_figure model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MZZ.Model.tb_imgs model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update tb_imgs set ");
strSql.Append("imgs_path=@imgs_path,");
strSql.Append("imgs_etag=@imgs_etag,");
strSql.Append("imgs_path_md5=@imgs_path_md5,");
strSql.Append("imgs_mime=@imgs_mime,");
strSql.Append("imgs_height=@imgs_height,");
strSql.Append("imgs_width=@imgs_width,");
strSql.Append("imgs_size=@imgs_size,");
strSql.Append("imgs_quote=@imgs_quote,");
strSql.Append("imgs_score=@imgs_score,");
strSql.Append("imgs_score_tip=@imgs_score_tip,");
strSql.Append("imgs_score_task=@imgs_score_task,");
strSql.Append("imgs_time=@imgs_time");
strSql.Append(" where imgs_id=@imgs_id");
MySqlParameter[] parameters = {
new MySqlParameter("@imgs_path", MySqlDbType.VarChar,255),
new MySqlParameter("@imgs_etag", MySqlDbType.VarChar,32),
new MySqlParameter("@imgs_path_md5", MySqlDbType.VarChar,32),
new MySqlParameter("@imgs_mime", MySqlDbType.VarChar,128),
new MySqlParameter("@imgs_height", MySqlDbType.Int32,11),
new MySqlParameter("@imgs_width", MySqlDbType.Int32,11),
new MySqlParameter("@imgs_size", MySqlDbType.Int32,11),
new MySqlParameter("@imgs_quote", MySqlDbType.Int32,10),
new MySqlParameter("@imgs_score", MySqlDbType.Int32,3),
new MySqlParameter("@imgs_score_tip", MySqlDbType.Int32,3),
new MySqlParameter("@imgs_score_task", MySqlDbType.VarChar,128),
new MySqlParameter("@imgs_time", MySqlDbType.Int32,11),
new MySqlParameter("@imgs_id", MySqlDbType.Int32,10)};
parameters[0].Value = model.imgs_path;
parameters[1].Value = model.imgs_etag;
parameters[2].Value = model.imgs_path_md5;
parameters[3].Value = model.imgs_mime;
parameters[4].Value = model.imgs_height;
parameters[5].Value = model.imgs_width;
parameters[6].Value = model.imgs_size;
parameters[7].Value = model.imgs_quote;
parameters[8].Value = model.imgs_score;
parameters[9].Value = model.imgs_score_tip;
parameters[10].Value = model.imgs_score_task;
parameters[11].Value = model.imgs_time;
parameters[12].Value = model.imgs_id;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MZZ.Model.tb_prizes model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update tb_prizes set ");
strSql.Append("prizes_prize_name=@prizes_prize_name,");
strSql.Append("prizes_quantity=@prizes_quantity,");
strSql.Append("prizes_main_img=@prizes_main_img,");
strSql.Append("prizes_angle=@prizes_angle,");
strSql.Append("prizes_probability=@prizes_probability,");
strSql.Append("prizes_remark=@prizes_remark,");
strSql.Append("prizes_create_time=@prizes_create_time,");
strSql.Append("prizes_status=@prizes_status");
strSql.Append(" where prizes_id=@prizes_id");
MySqlParameter[] parameters = {
new MySqlParameter("@prizes_prize_name", MySqlDbType.VarChar,50),
new MySqlParameter("@prizes_quantity", MySqlDbType.Int32,11),
new MySqlParameter("@prizes_main_img", MySqlDbType.VarChar,50),
new MySqlParameter("@prizes_angle", MySqlDbType.VarChar,50),
new MySqlParameter("@prizes_probability", MySqlDbType.VarChar,50),
new MySqlParameter("@prizes_remark", MySqlDbType.VarChar,255),
new MySqlParameter("@prizes_create_time", MySqlDbType.DateTime),
new MySqlParameter("@prizes_status", MySqlDbType.Int32,11),
new MySqlParameter("@prizes_id", MySqlDbType.Int32,11)};
parameters[0].Value = model.prizes_prize_name;
parameters[1].Value = model.prizes_quantity;
parameters[2].Value = model.prizes_main_img;
parameters[3].Value = model.prizes_angle;
parameters[4].Value = model.prizes_probability;
parameters[5].Value = model.prizes_remark;
parameters[6].Value = model.prizes_create_time;
parameters[7].Value = model.prizes_status;
parameters[8].Value = model.prizes_id;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_prizes model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MZZ.Model.tb_lntegral_prize model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update tb_lntegral_prize set ");
strSql.Append("lntegral_prize_name=@lntegral_prize_name,");
strSql.Append("lntegral_prize_cost=@lntegral_prize_cost,");
strSql.Append("lntegral_prize_status=@lntegral_prize_status,");
strSql.Append("lntegral_prize_img=@lntegral_prize_img,");
strSql.Append("lntegral_prize_batch=@lntegral_prize_batch,");
strSql.Append("lntegral_prize_num=@lntegral_prize_num");
strSql.Append(" where lntegral_prize_id=@lntegral_prize_id");
MySqlParameter[] parameters = {
new MySqlParameter("@lntegral_prize_name", MySqlDbType.VarChar,45),
new MySqlParameter("@lntegral_prize_cost", MySqlDbType.Int32,11),
new MySqlParameter("@lntegral_prize_status", MySqlDbType.VarChar,45),
new MySqlParameter("@lntegral_prize_img", MySqlDbType.VarChar,45),
new MySqlParameter("@lntegral_prize_batch", MySqlDbType.Int32,3),
new MySqlParameter("@lntegral_prize_num", MySqlDbType.Int32,5),
new MySqlParameter("@lntegral_prize_id", MySqlDbType.Int32,11)};
parameters[0].Value = model.lntegral_prize_name;
parameters[1].Value = model.lntegral_prize_cost;
parameters[2].Value = model.lntegral_prize_status;
parameters[3].Value = model.lntegral_prize_img;
parameters[4].Value = model.lntegral_prize_batch;
parameters[5].Value = model.lntegral_prize_num;
parameters[6].Value = model.lntegral_prize_id;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_lntegral_prize model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MZZ.Model.tb_lntegral_users model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_imgs model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MZZ.Model.tb_imgs model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MZZ.Model.tb_news model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update tb_news set ");
strSql.Append("news_category=@news_category,");
strSql.Append("news_title=@news_title,");
strSql.Append("news_introduce=@news_introduce,");
strSql.Append("news_text=@news_text,");
strSql.Append("news_relative_path=@news_relative_path,");
strSql.Append("news_absolute_path=@news_absolute_path,");
strSql.Append("news_recom=@news_recom,");
strSql.Append("news_top=@news_top,");
strSql.Append("news_time=@news_time,");
strSql.Append("news_remarks=@news_remarks");
strSql.Append(" where news_id=@news_id");
MySqlParameter[] parameters = {
new MySqlParameter("@news_category", MySqlDbType.VarChar,50),
new MySqlParameter("@news_title", MySqlDbType.VarChar,100),
new MySqlParameter("@news_introduce", MySqlDbType.VarChar,255),
new MySqlParameter("@news_text", MySqlDbType.Text),
new MySqlParameter("@news_relative_path", MySqlDbType.VarChar,255),
new MySqlParameter("@news_absolute_path", MySqlDbType.VarChar,255),
new MySqlParameter("@news_recom", MySqlDbType.Int32,11),
new MySqlParameter("@news_top", MySqlDbType.Int32,11),
new MySqlParameter("@news_time", MySqlDbType.DateTime),
new MySqlParameter("@news_remarks", MySqlDbType.Text),
new MySqlParameter("@news_id", MySqlDbType.Int32,10)};
parameters[0].Value = model.news_category;
parameters[1].Value = model.news_title;
parameters[2].Value = model.news_introduce;
parameters[3].Value = model.news_text;
parameters[4].Value = model.news_relative_path;
parameters[5].Value = model.news_absolute_path;
parameters[6].Value = model.news_recom;
parameters[7].Value = model.news_top;
parameters[8].Value = model.news_time;
parameters[9].Value = model.news_remarks;
parameters[10].Value = model.news_id;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_article model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MZZ.Model.tb_user model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update tb_user set ");
strSql.Append("user_phone=@user_phone,");
strSql.Append("user_pass=@user_pass,");
strSql.Append("user_integral=@user_integral,");
strSql.Append("user_level=@user_level,");
strSql.Append("user_data=@user_data,");
strSql.Append("user_login_time=@user_login_time,");
strSql.Append("user_login_ip=@user_login_ip,");
strSql.Append("user_create_time=@user_create_time,");
strSql.Append("user_create_ip=@user_create_ip,");
strSql.Append("user_openid=@user_openid,");
strSql.Append("user_nick_name=@user_nick_name,");
strSql.Append("user_sex=@user_sex,");
strSql.Append("user_city=@user_city,");
strSql.Append("user_country=@user_country,");
strSql.Append("user_province=@user_province,");
strSql.Append("user_language=@user_language,");
strSql.Append("user_head_img_url=@user_head_img_url,");
strSql.Append("user_sub_time=@user_sub_time,");
strSql.Append("user_sub_scribe=@user_sub_scribe,");
strSql.Append("user_up_openid=@user_up_openid,");
strSql.Append("user_uopenid_time=@user_uopenid_time,");
strSql.Append("user_status=@user_status,");
strSql.Append("user_hy_status=@user_hy_status,");
strSql.Append("user_qr_code=@user_qr_code");
strSql.Append(" where user_id=@user_id");
MySqlParameter[] parameters = {
new MySqlParameter("@user_phone", MySqlDbType.VarChar,50),
new MySqlParameter("@user_pass", MySqlDbType.VarChar,32),
new MySqlParameter("@user_integral", MySqlDbType.Int32,10),
new MySqlParameter("@user_level", MySqlDbType.Int32,3),
new MySqlParameter("@user_data", MySqlDbType.Text),
new MySqlParameter("@user_login_time", MySqlDbType.Int32,10),
new MySqlParameter("@user_login_ip", MySqlDbType.VarChar,15),
new MySqlParameter("@user_create_time", MySqlDbType.Int32,11),
new MySqlParameter("@user_create_ip", MySqlDbType.VarChar,15),
new MySqlParameter("@user_openid", MySqlDbType.VarChar,50),
new MySqlParameter("@user_nick_name", MySqlDbType.VarChar,50),
new MySqlParameter("@user_sex", MySqlDbType.Int32,11),
new MySqlParameter("@user_city", MySqlDbType.VarChar,50),
new MySqlParameter("@user_country", MySqlDbType.VarChar,50),
new MySqlParameter("@user_province", MySqlDbType.VarChar,50),
new MySqlParameter("@user_language", MySqlDbType.VarChar,50),
new MySqlParameter("@user_head_img_url", MySqlDbType.VarChar,255),
new MySqlParameter("@user_sub_time", MySqlDbType.DateTime),
new MySqlParameter("@user_sub_scribe", MySqlDbType.Bit),
new MySqlParameter("@user_up_openid", MySqlDbType.VarChar,50),
new MySqlParameter("@user_uopenid_time", MySqlDbType.DateTime),
new MySqlParameter("@user_status", MySqlDbType.Int32,11),
new MySqlParameter("@user_hy_status", MySqlDbType.Int32,11),
new MySqlParameter("@user_qr_code", MySqlDbType.VarChar,255),
new MySqlParameter("@user_id", MySqlDbType.Int32,10)};
parameters[0].Value = model.user_phone;
parameters[1].Value = model.user_pass;
parameters[2].Value = model.user_integral;
parameters[3].Value = model.user_level;
parameters[4].Value = model.user_data;
parameters[5].Value = model.user_login_time;
parameters[6].Value = model.user_login_ip;
parameters[7].Value = model.user_create_time;
parameters[8].Value = model.user_create_ip;
parameters[9].Value = model.user_openid;
parameters[10].Value = model.user_nick_name;
parameters[11].Value = model.user_sex;
parameters[12].Value = model.user_city;
parameters[13].Value = model.user_country;
parameters[14].Value = model.user_province;
parameters[15].Value = model.user_language;
parameters[16].Value = model.user_head_img_url;
parameters[17].Value = model.user_sub_time;
parameters[18].Value = model.user_sub_scribe;
parameters[19].Value = model.user_up_openid;
parameters[20].Value = model.user_uopenid_time;
parameters[21].Value = model.user_status;
parameters[22].Value = model.user_hy_status;
parameters[23].Value = model.user_qr_code;
parameters[24].Value = model.user_id;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MZZ.Model.tb_figure model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MZZ.Model.tb_lntegral_users model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MZZ.Model.tb_article model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update tb_article set ");
strSql.Append("article_type=@article_type,");
strSql.Append("article_content=@article_content,");
strSql.Append("article_imgs=@article_imgs,");
strSql.Append("article_barrage=@article_barrage,");
strSql.Append("article_user_id=@article_user_id,");
strSql.Append("article_time=@article_time,");
strSql.Append("article_statu=@article_statu");
strSql.Append(" where article_id=@article_id");
MySqlParameter[] parameters = {
new MySqlParameter("@article_type", MySqlDbType.Int32,4),
new MySqlParameter("@article_content", MySqlDbType.VarChar,255),
new MySqlParameter("@article_imgs", MySqlDbType.VarChar,2048),
new MySqlParameter("@article_barrage", MySqlDbType.Int32,1),
new MySqlParameter("@article_user_id", MySqlDbType.Int32,10),
new MySqlParameter("@article_time", MySqlDbType.Int32,10),
new MySqlParameter("@article_statu", MySqlDbType.Int32,3),
new MySqlParameter("@article_id", MySqlDbType.Int32,10)};
parameters[0].Value = model.article_type;
parameters[1].Value = model.article_content;
parameters[2].Value = model.article_imgs;
parameters[3].Value = model.article_barrage;
parameters[4].Value = model.article_user_id;
parameters[5].Value = model.article_time;
parameters[6].Value = model.article_statu;
parameters[7].Value = model.article_id;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
