/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.chat_message model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into chat_message(");
strSql.Append("chat_ID,chat_FROM,chat_TO,chat_content,chat_time,chat_comment,chat_state)");
strSql.Append(" values (");
strSql.Append("@chat_ID,@chat_FROM,@chat_TO,@chat_content,@chat_time,@chat_comment,@chat_state)");
SqlParameter[] parameters = {
new SqlParameter("@chat_ID", SqlDbType.Int,4),
new SqlParameter("@chat_FROM", SqlDbType.Int,4),
new SqlParameter("@chat_TO", SqlDbType.Int,4),
new SqlParameter("@chat_content", SqlDbType.VarChar,400),
new SqlParameter("@chat_time", SqlDbType.DateTime),
new SqlParameter("@chat_comment", SqlDbType.VarChar,200),
new SqlParameter("@chat_state", SqlDbType.VarChar,30)};
parameters[0].Value = model.chat_ID;
parameters[1].Value = model.chat_FROM;
parameters[2].Value = model.chat_TO;
parameters[3].Value = model.chat_content;
parameters[4].Value = model.chat_time;
parameters[5].Value = model.chat_comment;
parameters[6].Value = model.chat_state;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.album model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into album(");
strSql.Append("user_telphone,album_time,album_comment,album_isvalid,album_isprivate)");
strSql.Append(" values (");
strSql.Append("@user_telphone,@album_time,@album_comment,@album_isvalid,@album_isprivate)");
SqlParameter[] parameters = {
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@album_time", SqlDbType.DateTime),
new SqlParameter("@album_comment", SqlDbType.VarChar,200),
new SqlParameter("@album_isvalid", SqlDbType.Bit,1),
new SqlParameter("@album_isprivate", SqlDbType.Bit,1)};
parameters[0].Value = model.user_telphone;
parameters[1].Value = model.album_time;
parameters[2].Value = model.album_comment;
parameters[3].Value = model.album_isvalid;
parameters[4].Value = model.album_isprivate;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.sendgift model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sendgift(");
strSql.Append("sendgift_ID,virtualgoods_ID,sender_id,accepter_id,send_time,sendgift_comment,sendgift_msg,sendgift_count)");
strSql.Append(" values (");
strSql.Append("@sendgift_ID,@virtualgoods_ID,@sender_id,@accepter_id,@send_time,@sendgift_comment,@sendgift_msg,@sendgift_count)");
SqlParameter[] parameters = {
new SqlParameter("@sendgift_ID", SqlDbType.Int,4),
new SqlParameter("@virtualgoods_ID", SqlDbType.Int,4),
new SqlParameter("@sender_id", SqlDbType.Int,4),
new SqlParameter("@accepter_id", SqlDbType.Int,4),
new SqlParameter("@send_time", SqlDbType.DateTime),
new SqlParameter("@sendgift_comment", SqlDbType.VarChar,200),
new SqlParameter("@sendgift_msg", SqlDbType.VarChar,200),
new SqlParameter("@sendgift_count", SqlDbType.Int,4)};
parameters[0].Value = model.sendgift_ID;
parameters[1].Value = model.virtualgoods_ID;
parameters[2].Value = model.sender_id;
parameters[3].Value = model.accepter_id;
parameters[4].Value = model.send_time;
parameters[5].Value = model.sendgift_comment;
parameters[6].Value = model.sendgift_msg;
parameters[7].Value = model.sendgift_count;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.travleapply model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into travleapply(");
strSql.Append("travleapply_ID,travle_ID,applyer_ID,apply_time,apply_state,apply_msg)");
strSql.Append(" values (");
strSql.Append("@travleapply_ID,@travle_ID,@applyer_ID,@apply_time,@apply_state,@apply_msg)");
SqlParameter[] parameters = {
new SqlParameter("@travleapply_ID", SqlDbType.Int,4),
new SqlParameter("@travle_ID", SqlDbType.Int,4),
new SqlParameter("@applyer_ID", SqlDbType.Int,4),
new SqlParameter("@apply_time", SqlDbType.DateTime),
new SqlParameter("@apply_state", SqlDbType.VarChar,30),
new SqlParameter("@apply_msg", SqlDbType.VarChar,400)};
parameters[0].Value = model.travleapply_ID;
parameters[1].Value = model.travle_ID;
parameters[2].Value = model.applyer_ID;
parameters[3].Value = model.apply_time;
parameters[4].Value = model.apply_state;
parameters[5].Value = model.apply_msg;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.wealthindex model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wealthindex(");
strSql.Append("wealthindex_ID,user_telphone,wealthindex_changevalue,wealthindex_time,wealthindex_comment,wealthindex_changetype,wealthindex_result)");
strSql.Append(" values (");
strSql.Append("@wealthindex_ID,@user_telphone,@wealthindex_changevalue,@wealthindex_time,@wealthindex_comment,@wealthindex_changetype,@wealthindex_result)");
SqlParameter[] parameters = {
new SqlParameter("@wealthindex_ID", SqlDbType.Int,4),
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@wealthindex_changevalue", SqlDbType.Float,8),
new SqlParameter("@wealthindex_time", SqlDbType.DateTime),
new SqlParameter("@wealthindex_comment", SqlDbType.VarChar,200),
new SqlParameter("@wealthindex_changetype", SqlDbType.VarChar,50),
new SqlParameter("@wealthindex_result", SqlDbType.Float,8)};
parameters[0].Value = model.wealthindex_ID;
parameters[1].Value = model.user_telphone;
parameters[2].Value = model.wealthindex_changevalue;
parameters[3].Value = model.wealthindex_time;
parameters[4].Value = model.wealthindex_comment;
parameters[5].Value = model.wealthindex_changetype;
parameters[6].Value = model.wealthindex_result;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.account model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into account(");
strSql.Append("account_id,user_telphone,account_balance,account_change,account_changetype,account_change_time,account_change_comment)");
strSql.Append(" values (");
strSql.Append("@account_id,@user_telphone,@account_balance,@account_change,@account_changetype,@account_change_time,@account_change_comment)");
SqlParameter[] parameters = {
new SqlParameter("@account_id", SqlDbType.Int,4),
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@account_balance", SqlDbType.Float,8),
new SqlParameter("@account_change", SqlDbType.Float,8),
new SqlParameter("@account_changetype", SqlDbType.VarChar,30),
new SqlParameter("@account_change_time", SqlDbType.DateTime),
new SqlParameter("@account_change_comment", SqlDbType.VarChar,200)};
parameters[0].Value = model.account_id;
parameters[1].Value = model.user_telphone;
parameters[2].Value = model.account_balance;
parameters[3].Value = model.account_change;
parameters[4].Value = model.account_changetype;
parameters[5].Value = model.account_change_time;
parameters[6].Value = model.account_change_comment;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.gpslocation model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into gpslocation(");
strSql.Append("user_telphone,location_lat,location_lng)");
strSql.Append(" values (");
strSql.Append("@user_telphone,@location_lat,@location_lng)");
SqlParameter[] parameters = {
//new SqlParameter("@gps_id", SqlDbType.Int,4)
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@location_lat", SqlDbType.Decimal,9),
new SqlParameter("@location_lng", SqlDbType.Decimal,9)};
//parameters[0].Value = model.gps_id;
parameters[0].Value = model.user_telphone;
parameters[1].Value = model.location_lat;
parameters[2].Value = model.location_lng;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.audio model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into audio(");
//strSql.Append("audio_id,user_telphone,audio_url,audio_time,audio_comment,audio_state)");
strSql.Append("user_telphone,audio_url,audio_time,audio_comment,audio_state)");
strSql.Append(" values (");
//strSql.Append("@audio_id,@user_telphone,@audio_url,@audio_time,@audio_comment,@audio_state)");
strSql.Append("@user_telphone,@audio_url,@audio_time,@audio_comment,@audio_state)");
SqlParameter[] parameters = {
//new SqlParameter("@audio_id", SqlDbType.Int,4)
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@audio_url", SqlDbType.VarChar,200),
new SqlParameter("@audio_time", SqlDbType.DateTime),
new SqlParameter("@audio_comment", SqlDbType.VarChar,200),
new SqlParameter("@audio_state", SqlDbType.VarChar,30)};
//parameters[0].Value = model.audio_id;
parameters[0].Value = model.user_telphone;
parameters[1].Value = model.audio_url;
parameters[2].Value = model.audio_time;
parameters[3].Value = model.audio_comment;
parameters[4].Value = model.audio_state;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.log model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into log(");
strSql.Append("user_telphone,log_ip,log_time,LAT,LNG)");
strSql.Append(" values (");
strSql.Append("@user_telphone,@log_ip,@log_time,@LAT,@LNG)");
SqlParameter[] parameters = {
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@log_ip", SqlDbType.VarChar,20),
new SqlParameter("@log_time", SqlDbType.DateTime),
new SqlParameter("@LAT", SqlDbType.Decimal,9),
new SqlParameter("@LNG", SqlDbType.Decimal,9)};
parameters[0].Value = model.user_telphone;
parameters[1].Value = model.log_ip;
parameters[2].Value = model.log_time;
parameters[3].Value = model.LAT;
parameters[4].Value = model.LNG;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.personphoto model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into personphoto(");
strSql.Append("album_id,personphoto_path)");
strSql.Append(" values (");
strSql.Append("@album_id,@personphoto_path)");
SqlParameter[] parameters = {
new SqlParameter("@album_id", SqlDbType.Int,4),
new SqlParameter("@personphoto_path", SqlDbType.VarChar,200)};
parameters[0].Value = model.album_id;
parameters[1].Value = model.personphoto_path;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.VIP model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into VIP(");
strSql.Append("VIPID,user_telphone,VIP_change_credit,VIP_change_comment,VIP_change_time,VIP_credit,VIP_level,VIP_change_type)");
strSql.Append(" values (");
strSql.Append("@VIPID,@user_telphone,@VIP_change_credit,@VIP_change_comment,@VIP_change_time,@VIP_credit,@VIP_level,@VIP_change_type)");
SqlParameter[] parameters = {
new SqlParameter("@VIPID", SqlDbType.Int,4),
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@VIP_change_credit", SqlDbType.Float,8),
new SqlParameter("@VIP_change_comment", SqlDbType.VarChar,200),
new SqlParameter("@VIP_change_time", SqlDbType.DateTime),
new SqlParameter("@VIP_credit", SqlDbType.Float,8),
new SqlParameter("@VIP_level", SqlDbType.Int,4),
new SqlParameter("@VIP_change_type", SqlDbType.VarChar,20)};
parameters[0].Value = model.VIPID;
parameters[1].Value = model.user_telphone;
parameters[2].Value = model.VIP_change_credit;
parameters[3].Value = model.VIP_change_comment;
parameters[4].Value = model.VIP_change_time;
parameters[5].Value = model.VIP_credit;
parameters[6].Value = model.VIP_level;
parameters[7].Value = model.VIP_change_type;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.smsCode model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into smsCode(");
strSql.Append("user_telphone,smscode_sendtime,smscode)");
strSql.Append(" values (");
strSql.Append("@user_telphone,@smscode_sendtime,@smscode)");
SqlParameter[] parameters = {
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@smscode_sendtime", SqlDbType.DateTime),
new SqlParameter("@smscode", SqlDbType.VarChar,8)};
parameters[0].Value = model.user_telphone;
parameters[1].Value = model.smscode_sendtime;
parameters[2].Value = model.smscode;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.ownvirtualgoods model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ownvirtualgoods(");
strSql.Append("property_ID,virtualgoods_ID,user_telphone,property_count)");
strSql.Append(" values (");
strSql.Append("@property_ID,@virtualgoods_ID,@user_telphone,@property_count)");
SqlParameter[] parameters = {
new SqlParameter("@property_ID", SqlDbType.Int,4),
new SqlParameter("@virtualgoods_ID", SqlDbType.Int,4),
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@property_count", SqlDbType.Int,4)};
parameters[0].Value = model.property_ID;
parameters[1].Value = model.virtualgoods_ID;
parameters[2].Value = model.user_telphone;
parameters[3].Value = model.property_count;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.sms model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sms(");
strSql.Append("user_telphone,sms_content,sms_time,sms_comment,sms_ispay)");
strSql.Append(" values (");
strSql.Append("@user_telphone,@sms_content,@sms_time,@sms_comment,@sms_ispay)");
SqlParameter[] parameters = {
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@sms_content", SqlDbType.VarChar,280),
new SqlParameter("@sms_time", SqlDbType.DateTime),
new SqlParameter("@sms_comment", SqlDbType.VarChar,400),
new SqlParameter("@sms_ispay", SqlDbType.Bit,1)};
parameters[0].Value = model.user_telphone;
parameters[1].Value = model.sms_content;
parameters[2].Value = model.sms_time;
parameters[3].Value = model.sms_comment;
parameters[4].Value = model.sms_ispay;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.friendchange model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into friendchange(");
strSql.Append("friendchange_ID,friend_id,user_telphone,friendchange_time,friendchange_op,friendchange_comment)");
strSql.Append(" values (");
strSql.Append("@friendchange_ID,@friend_id,@user_telphone,@friendchange_time,@friendchange_op,@friendchange_comment)");
SqlParameter[] parameters = {
new SqlParameter("@friendchange_ID", SqlDbType.Int,4),
new SqlParameter("@friend_id", SqlDbType.Int,4),
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@friendchange_time", SqlDbType.DateTime),
new SqlParameter("@friendchange_op", SqlDbType.VarChar,20),
new SqlParameter("@friendchange_comment", SqlDbType.VarChar,100)};
parameters[0].Value = model.friendchange_ID;
parameters[1].Value = model.friend_id;
parameters[2].Value = model.user_telphone;
parameters[3].Value = model.friendchange_time;
parameters[4].Value = model.friendchange_op;
parameters[5].Value = model.friendchange_comment;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.friend model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into friend(");
strSql.Append("friend_id,friend_from,friend_to,friend_time,friend_state,friend_comment)");
strSql.Append(" values (");
strSql.Append("@friend_id,@friend_from,@friend_to,@friend_time,@friend_state,@friend_comment)");
SqlParameter[] parameters = {
new SqlParameter("@friend_id", SqlDbType.Int,4),
new SqlParameter("@friend_from", SqlDbType.VarChar,20),
new SqlParameter("@friend_to", SqlDbType.VarChar,20),
new SqlParameter("@friend_time", SqlDbType.DateTime),
new SqlParameter("@friend_state", SqlDbType.VarChar,20),
new SqlParameter("@friend_comment", SqlDbType.VarChar,200)};
parameters[0].Value = model.friend_id;
parameters[1].Value = model.friend_from;
parameters[2].Value = model.friend_to;
parameters[3].Value = model.friend_time;
parameters[4].Value = model.friend_state;
parameters[5].Value = model.friend_comment;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.virtualgoods model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into virtualgoods(");
strSql.Append("virtualgoods_ID,virtualgoods_name,virtualgoods_price,virtualgoods_comment,virtualgoods_pic_url,virtualgoods_type,virtualgoods_fun)");
strSql.Append(" values (");
strSql.Append("@virtualgoods_ID,@virtualgoods_name,@virtualgoods_price,@virtualgoods_comment,@virtualgoods_pic_url,@virtualgoods_type,@virtualgoods_fun)");
SqlParameter[] parameters = {
new SqlParameter("@virtualgoods_ID", SqlDbType.Int,4),
new SqlParameter("@virtualgoods_name", SqlDbType.VarChar,30),
new SqlParameter("@virtualgoods_price", SqlDbType.Float,8),
new SqlParameter("@virtualgoods_comment", SqlDbType.VarChar,200),
new SqlParameter("@virtualgoods_pic_url", SqlDbType.VarChar,200),
new SqlParameter("@virtualgoods_type", SqlDbType.VarChar,30),
new SqlParameter("@virtualgoods_fun", SqlDbType.VarChar,40)};
parameters[0].Value = model.virtualgoods_ID;
parameters[1].Value = model.virtualgoods_name;
parameters[2].Value = model.virtualgoods_price;
parameters[3].Value = model.virtualgoods_comment;
parameters[4].Value = model.virtualgoods_pic_url;
parameters[5].Value = model.virtualgoods_type;
parameters[6].Value = model.virtualgoods_fun;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.comment model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into comment(");
strSql.Append("评价编号,travle_ID,user_telphone,评价字典编号,评价时间)");
strSql.Append(" values (");
strSql.Append("@评价编号,@travle_ID,@user_telphone,@评价字典编号,@评价时间)");
SqlParameter[] parameters = {
new SqlParameter("@评价编号", SqlDbType.Int,4),
new SqlParameter("@travle_ID", SqlDbType.Int,4),
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@评价字典编号", SqlDbType.Int,4),
new SqlParameter("@评价时间", SqlDbType.DateTime)};
parameters[0].Value = model.评价编号;
parameters[1].Value = model.travle_ID;
parameters[2].Value = model.user_telphone;
parameters[3].Value = model.评价字典编号;
parameters[4].Value = model.评价时间;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.enshrine model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into enshrine(");
strSql.Append("enshrine_id,travle_ID,user_telphone,enshrine_time,enshrine_islvalid)");
strSql.Append(" values (");
strSql.Append("@enshrine_id,@travle_ID,@user_telphone,@enshrine_time,@enshrine_islvalid)");
SqlParameter[] parameters = {
new SqlParameter("@enshrine_id", SqlDbType.Int,4),
new SqlParameter("@travle_ID", SqlDbType.Int,4),
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@enshrine_time", SqlDbType.DateTime),
new SqlParameter("@enshrine_islvalid", SqlDbType.Bit,1)};
parameters[0].Value = model.enshrine_id;
parameters[1].Value = model.travle_ID;
parameters[2].Value = model.user_telphone;
parameters[3].Value = model.enshrine_time;
parameters[4].Value = model.enshrine_islvalid;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.comment_dic model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into comment_dic(");
strSql.Append("评价字典编号,评价字典内容,对应分值)");
strSql.Append(" values (");
strSql.Append("@评价字典编号,@评价字典内容,@对应分值)");
SqlParameter[] parameters = {
new SqlParameter("@评价字典编号", SqlDbType.Int,4),
new SqlParameter("@评价字典内容", SqlDbType.VarChar,100),
new SqlParameter("@对应分值", SqlDbType.Int,4)};
parameters[0].Value = model.评价字典编号;
parameters[1].Value = model.评价字典内容;
parameters[2].Value = model.对应分值;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.recharge model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into recharge(");
strSql.Append("recharge_ID,user_telphone,recharge_plat,recharge_money,recharge_time,recharge_code,recharge_comment)");
strSql.Append(" values (");
strSql.Append("@recharge_ID,@user_telphone,@recharge_plat,@recharge_money,@recharge_time,@recharge_code,@recharge_comment)");
SqlParameter[] parameters = {
new SqlParameter("@recharge_ID", SqlDbType.Int,4),
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@recharge_plat", SqlDbType.VarChar,30),
new SqlParameter("@recharge_money", SqlDbType.Float,8),
new SqlParameter("@recharge_time", SqlDbType.DateTime),
new SqlParameter("@recharge_code", SqlDbType.VarChar,100),
new SqlParameter("@recharge_comment", SqlDbType.VarChar,200)};
parameters[0].Value = model.recharge_ID;
parameters[1].Value = model.user_telphone;
parameters[2].Value = model.recharge_plat;
parameters[3].Value = model.recharge_money;
parameters[4].Value = model.recharge_time;
parameters[5].Value = model.recharge_code;
parameters[6].Value = model.recharge_comment;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.user_tb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into user_tb(");
strSql.Append("user_telphone,user_sex,user_nikeName,user_photo,user_birthday,user_height,user_weight,user_address,user_job,user_income,user_pwd,user_marrystate,user_edu,personcenter_bg,user_photo_state,user_state)");
strSql.Append(" values (");
strSql.Append("@user_telphone,@user_sex,@user_nikeName,@user_photo,@user_birthday,@user_height,@user_weight,@user_address,@user_job,@user_income,@user_pwd,@user_marrystate,@user_edu,@personcenter_bg,@user_photo_state,@user_state)");
SqlParameter[] parameters = {
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@user_sex", SqlDbType.Bit,1),
new SqlParameter("@user_nikeName", SqlDbType.VarChar,40),
new SqlParameter("@user_photo", SqlDbType.VarChar,100),
new SqlParameter("@user_birthday", SqlDbType.DateTime),
new SqlParameter("@user_height", SqlDbType.VarChar,20),
new SqlParameter("@user_weight", SqlDbType.VarChar,20),
new SqlParameter("@user_address", SqlDbType.VarChar,50),
new SqlParameter("@user_job", SqlDbType.VarChar,40),
new SqlParameter("@user_income", SqlDbType.VarChar,20),
new SqlParameter("@user_pwd", SqlDbType.VarChar,100),
new SqlParameter("@user_marrystate", SqlDbType.VarChar,20),
new SqlParameter("@user_edu", SqlDbType.VarChar,20),
new SqlParameter("@personcenter_bg", SqlDbType.VarChar,200),
new SqlParameter("@user_photo_state", SqlDbType.VarChar,30),
new SqlParameter("@user_state", SqlDbType.VarChar,20)};
parameters[0].Value = model.user_telphone;
parameters[1].Value = model.user_sex;
parameters[2].Value = model.user_nikeName;
parameters[3].Value = model.user_photo;
parameters[4].Value = model.user_birthday;
parameters[5].Value = model.user_height;
parameters[6].Value = model.user_weight;
parameters[7].Value = model.user_address;
parameters[8].Value = model.user_job;
parameters[9].Value = model.user_income;
parameters[10].Value = model.user_pwd;
parameters[11].Value = model.user_marrystate;
parameters[12].Value = model.user_edu;
parameters[13].Value = model.personcenter_bg;
parameters[14].Value = model.user_photo_state;
parameters[15].Value = model.user_state;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.carInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into carInfo(");
strSql.Append("user_telphone,car_level,car_brand,car_type,car_photo1,car_photo2,car_photo3,car_photo1_state,car_photo2_state,car_photo3_state)");
strSql.Append(" values (");
strSql.Append("@user_telphone,@car_level,@car_brand,@car_type,@car_photo1,@car_photo2,@car_photo3,@car_photo1_state,@car_photo2_state,@car_photo3_state)");
SqlParameter[] parameters = {
//new SqlParameter("@car_id", SqlDbType.Int,4)
new SqlParameter("@user_telphone", SqlDbType.VarChar,20),
new SqlParameter("@car_level", SqlDbType.VarChar,50),
new SqlParameter("@car_brand", SqlDbType.VarChar,30),
new SqlParameter("@car_type", SqlDbType.VarChar,30),
new SqlParameter("@car_photo1", SqlDbType.VarChar,200),
new SqlParameter("@car_photo2", SqlDbType.VarChar,200),
new SqlParameter("@car_photo3", SqlDbType.VarChar,200),
new SqlParameter("@car_photo1_state", SqlDbType.VarChar,30),
new SqlParameter("@car_photo2_state", SqlDbType.VarChar,30),
new SqlParameter("@car_photo3_state", SqlDbType.VarChar,30)};
//parameters[0].Value = model.car_id;
parameters[0].Value = model.user_telphone;
parameters[1].Value = model.car_level;
parameters[2].Value = model.car_brand;
parameters[3].Value = model.car_type;
parameters[4].Value = model.car_photo1;
parameters[5].Value = model.car_photo2;
parameters[6].Value = model.car_photo3;
parameters[7].Value = model.car_photo1_state;
parameters[8].Value = model.car_photo2_state;
parameters[9].Value = model.car_photo3_state;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(la.Model.wealthindex model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update wealthindex set ");
strSql.Append("wealthindex_changevalue=@wealthindex_changevalue,");
strSql.Append("wealthindex_time=@wealthindex_time,");
strSql.Append("wealthindex_comment=@wealthindex_comment,");
strSql.Append("wealthindex_changetype=@wealthindex_changetype,");
strSql.Append("wealthindex_result=@wealthindex_result");
strSql.Append(" where wealthindex_ID=@wealthindex_ID and user_telphone=@user_telphone ");
SqlParameter[] parameters = {
new SqlParameter("@wealthindex_changevalue", SqlDbType.Float,8),
new SqlParameter("@wealthindex_time", SqlDbType.DateTime),
new SqlParameter("@wealthindex_comment", SqlDbType.VarChar,200),
new SqlParameter("@wealthindex_changetype", SqlDbType.VarChar,50),
new SqlParameter("@wealthindex_result", SqlDbType.Float,8),
new SqlParameter("@wealthindex_ID", SqlDbType.Int,4),
new SqlParameter("@user_telphone", SqlDbType.VarChar,20)};
parameters[0].Value = model.wealthindex_changevalue;
parameters[1].Value = model.wealthindex_time;
parameters[2].Value = model.wealthindex_comment;
parameters[3].Value = model.wealthindex_changetype;
parameters[4].Value = model.wealthindex_result;
parameters[5].Value = model.wealthindex_ID;
parameters[6].Value = model.user_telphone;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(la.Model.friendchange model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update friendchange set ");
strSql.Append("friendchange_time=@friendchange_time,");
strSql.Append("friendchange_op=@friendchange_op,");
strSql.Append("friendchange_comment=@friendchange_comment");
strSql.Append(" where friendchange_ID=@friendchange_ID and friend_id=@friend_id and user_telphone=@user_telphone ");
SqlParameter[] parameters = {
new SqlParameter("@friendchange_time", SqlDbType.DateTime),
new SqlParameter("@friendchange_op", SqlDbType.VarChar,20),
new SqlParameter("@friendchange_comment", SqlDbType.VarChar,100),
new SqlParameter("@friendchange_ID", SqlDbType.Int,4),
new SqlParameter("@friend_id", SqlDbType.Int,4),
new SqlParameter("@user_telphone", SqlDbType.VarChar,20)};
parameters[0].Value = model.friendchange_time;
parameters[1].Value = model.friendchange_op;
parameters[2].Value = model.friendchange_comment;
parameters[3].Value = model.friendchange_ID;
parameters[4].Value = model.friend_id;
parameters[5].Value = model.user_telphone;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
public OperationRequestDataContract(la instance)
{
_internal = instance;
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.sendgift model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(la.Model.sendgift model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(la.Model.account model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(la.Model.comment_dic model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update comment_dic set ");
strSql.Append("评价字典内容=@评价字典内容,");
strSql.Append("对应分值=@对应分值");
strSql.Append(" where 评价字典编号=@评价字典编号 ");
SqlParameter[] parameters = {
new SqlParameter("@评价字典内容", SqlDbType.VarChar,100),
new SqlParameter("@对应分值", SqlDbType.Int,4),
new SqlParameter("@评价字典编号", SqlDbType.Int,4)};
parameters[0].Value = model.评价字典内容;
parameters[1].Value = model.对应分值;
parameters[2].Value = model.评价字典编号;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(la.Model.account model)
{
return dal.Add(model);
}
