/// <summary>
/// 每日收集币清除
/// </summary>
public void UpdateDcolletGold1(long DcolletGold)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_CmgToplist set ");
strSql.Append("DcolletGold=@DcolletGold ");
SqlParameter[] parameters =
{
new SqlParameter("@DcolletGold", SqlDbType.Int, 4)
};
parameters[1].Value = DcolletGold;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新字段
/// </summary>
public void Updatesid1(int sid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_CmgToplist set ");
strSql.Append("sid=@sid ");
SqlParameter[] parameters =
{
new SqlParameter("@sid", SqlDbType.Int, 4)
};
parameters[0].Value = sid;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// me_更新用户等级——减
/// </summary>
public void Update_dengji2(int usid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_NC_user set ");
strSql.Append("grade=grade-1 ");
strSql.Append(" where usid=@usid ");
SqlParameter[] parameters =
{
new SqlParameter("@usid", SqlDbType.Int, 4)
};
parameters[0].Value = usid;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// me_更新用户试玩领取的时间
/// </summary>
public void Updatecishu(int UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_SWB set ");
strSql.Append("XK3IsGet='" + DateTime.Now + "' ");
strSql.Append(" where UserID=@UserID ");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4)
};
parameters[0].Value = UserID;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新赞助币
/// </summary>
public void UpdateYcolletGold(int usID, long YcolletGold)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_CmgToplist set ");
strSql.Append("YcolletGold=YcolletGold+@YcolletGold ");
strSql.Append(" where usID=@usID ");
SqlParameter[] parameters =
{
new SqlParameter("@usID", SqlDbType.Int, 4),
new SqlParameter("@YcolletGold", SqlDbType.Int, 4)
};
parameters[0].Value = usID;
parameters[1].Value = YcolletGold;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新address
/// </summary>
public void UpdateAddress(long ID, string address)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_yg_BuyLists set ");
strSql.Append("Address=@address ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@address", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
parameters[1].Value = address;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新在线时间
/// </summary>
public void UpdateTime(int UsID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_numsManage set ");
strSql.Append("loginTime=@loginTime ");
strSql.Append(" where UsID=@UsID ");
SqlParameter[] parameters =
{
new SqlParameter("@UsID", SqlDbType.Int, 4),
new SqlParameter("@loginTime", SqlDbType.DateTime)
};
parameters[0].Value = UsID;
parameters[1].Value = DateTime.Now;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新管理密码
/// </summary>
public void UpdatePwd(int UsID, string Pwd)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_numsManage set ");
strSql.Append("Pwd=@Pwd");
strSql.Append(" where UsID=@UsID ");
SqlParameter[] parameters =
{
new SqlParameter("@UsID", SqlDbType.Int, 4),
new SqlParameter("@Pwd", SqlDbType.VarChar, 20)
};
parameters[0].Value = UsID;
parameters[1].Value = Pwd;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新密码保护答案为手机后六位
/// </summary>
public void UpdateAnswer(string Answer, string Mobile)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Question set ");
strSql.Append("Answer=@Answer ");
strSql.Append(" where Mobile=@Mobile ");
SqlParameter[] parameters =
{
new SqlParameter("@Answer", SqlDbType.NVarChar, 50),
new SqlParameter("@Mobile", SqlDbType.NVarChar, 50)
};
parameters[0].Value = Answer;
parameters[1].Value = Mobile;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新修改密码的次数
/// </summary>
public void UpdateChangeCount(int changecount, int account)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Question set ");
strSql.Append("changecount=@changecount ");
strSql.Append(" where ID=@account ");
SqlParameter[] parameters =
{
new SqlParameter("@changecount", SqlDbType.Int, 4),
new SqlParameter("@account", SqlDbType.Int, 4)
};
parameters[0].Value = changecount;
parameters[1].Value = account;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新手机号
/// </summary>
public void UpdateMobile(int ID, string Mobile)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Question set ");
strSql.Append("Mobile=@Mobile ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@Mobile", SqlDbType.NVarChar, 50)
};
parameters[0].Value = ID;
parameters[1].Value = Mobile;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// me_更新施肥次数
/// </summary>
public void Update_shifeinum(int usid, int big_shifei)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_NC_user set ");
strSql.Append("big_shifei=big_shifei+@big_shifei ");
strSql.Append(" where usid=@usid ");
SqlParameter[] parameters =
{
new SqlParameter("@usid", SqlDbType.Int, 4),
new SqlParameter("@big_shifei", SqlDbType.BigInt, 8)
};
parameters[0].Value = usid;
parameters[1].Value = big_shifei;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新randyuID
/// </summary>
public void UpdaterandyuID(string randyuID, int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Cmg_Top set ");
strSql.Append("randyuID=@randyuID ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@randyuID", SqlDbType.NVarChar, 100)
};
parameters[0].Value = id;
parameters[1].Value = randyuID;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新每月收集币
/// </summary>
public void UpdateMcolletGold(int Bid, long McolletGold)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Cmg_Top set ");
strSql.Append("McolletGold=@McolletGold ");
strSql.Append(" where Bid=@Bid ");
SqlParameter[] parameters =
{
new SqlParameter("@Bid", SqlDbType.Int, 4),
new SqlParameter("@McolletGold", SqlDbType.BigInt, 8)
};
parameters[0].Value = Bid;
parameters[1].Value = McolletGold;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// me_更新用户经验
/// </summary>
public void Update_Experience(int usid, long experience)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_NC_user set ");
strSql.Append("Experience=Experience+@experience ");
strSql.Append(" where usid=@usid ");
SqlParameter[] parameters =
{
new SqlParameter("@usid", SqlDbType.Int, 4),
new SqlParameter("@experience", SqlDbType.BigInt, 8)
};
parameters[0].Value = usid;
parameters[1].Value = experience;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新Jid
/// </summary>
public void UpdateJid(int Bid, int jID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Cmg_Top set ");
strSql.Append("jID=@jID ");
strSql.Append(" where Bid=@Bid ");
SqlParameter[] parameters =
{
new SqlParameter("@Bid", SqlDbType.Int, 4),
new SqlParameter("@jID", SqlDbType.Int, 4)
};
parameters[0].Value = Bid;
parameters[1].Value = jID;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// me_更新用户虚拟币/更新消费记录
/// </summary>
public void UpdateiGold(int UserID, long iGold)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_SWB set ");
strSql.Append("XK3Money=XK3Money+@iGold ");
strSql.Append(" where UserID=@UserID ");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@iGold", SqlDbType.BigInt, 8)
};
parameters[0].Value = UserID;
parameters[1].Value = iGold;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新连续签到天数
/// </summary>
public void UpdateQdweek(int UsID, int Qdweek)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_DrawJifen set ");
strSql.Append("Qdweek=@Qdweek ");
strSql.Append(" where UsID=@UsID ");
SqlParameter[] parameters =
{
new SqlParameter("@UsID", SqlDbType.Int, 4),
new SqlParameter("@Qdweek", SqlDbType.Int, 4)
};
parameters[0].Value = UsID;
parameters[1].Value = Qdweek;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 通过Ident更新
/// price的值
/// /// </summary>
public void UpdatePriceForIdent(string Ident, long price)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_WinnersGame set ");
strSql.Append("price=@price ");
strSql.Append(" where Ident=@Ident ");
SqlParameter[] parameters =
{
new SqlParameter("@Ident", SqlDbType.NVarChar, 50),
new SqlParameter("@price", SqlDbType.BigInt, 8)
};
parameters[0].Value = Ident;
parameters[1].Value = price;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
public void updateother(long other, int CID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_SfList set ");
strSql.Append("other=@other ");
strSql.Append(" where CID=@CID ");
SqlParameter[] parameters =
{
new SqlParameter("@other", SqlDbType.BigInt, 8),
new SqlParameter("@CID", SqlDbType.Int, 4)
};
parameters[0].Value = other;
parameters[1].Value = CID;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新end_time
/// </summary>
public void Updateend_time(DateTime end_time, int CID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_SfList set ");
strSql.Append("end_time=@end_time ");
strSql.Append(" where CID=@CID ");
SqlParameter[] parameters =
{
new SqlParameter("@end_time", SqlDbType.DateTime, 8),
new SqlParameter("@CID", SqlDbType.Int, 4)
};
parameters[0].Value = end_time;
parameters[1].Value = CID;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// me_更新用户金币
/// </summary>
public void Update_jinbi(int usid, long iGoid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_NC_user set ");
strSql.Append("Goid=Goid+@iGoid ");
strSql.Append(" where usid=@usid ");
SqlParameter[] parameters =
{
new SqlParameter("@usid", SqlDbType.Int, 4),
new SqlParameter("@iGoid", SqlDbType.BigInt, 8)
};
parameters[0].Value = usid;
parameters[1].Value = iGoid;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新下注数
/// </summary>
/// <param name="PayCount"></param>
/// <param name="CID"></param>
public void UpdatePayCount(int PayCount, int CID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_BQCList set ");
strSql.Append("PayCount=@PayCount ");
strSql.Append(" where CID=@CID ");
SqlParameter[] parameters =
{
new SqlParameter("@PayCount", SqlDbType.Int, 4),
new SqlParameter("@CID", SqlDbType.Int, 4)
};
parameters[0].Value = PayCount;
parameters[1].Value = CID;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
public void updateNowprize(long nowprize, int CID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_BQCList set ");
strSql.Append("nowprize=@nowprize ");
strSql.Append(" where CID=@CID ");
SqlParameter[] parameters =
{
new SqlParameter("@nowprize", SqlDbType.BigInt, 8),
new SqlParameter("@CID", SqlDbType.Int, 4)
};
parameters[0].Value = nowprize;
parameters[1].Value = CID;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新用户积分
/// </summary>
public void UpdateJifen(int UsID, int Jifen)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_DrawJifen set ");
strSql.Append("Jifen=Jifen+@Jifen ");
strSql.Append(" where UsID=@UsID ");
SqlParameter[] parameters =
{
new SqlParameter("@UsID", SqlDbType.Int, 4),
new SqlParameter("@Jifen", SqlDbType.Int, 4)
};
parameters[0].Value = UsID;
parameters[1].Value = Jifen;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
public void UpdateExpiry(int Expiry, int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Cmg_Top set ");
strSql.Append("Expiry=@Expiry ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@Expiry", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = Expiry;
parameters[1].Value = ID;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// me_更新土地类型
/// </summary>
public void Update_tdlx(int usid, int tuditpye)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_NC_user set ");
strSql.Append("tuditpye=@tuditpye ");
strSql.Append(" where usid=@usid ");
SqlParameter[] parameters =
{
new SqlParameter("@usid", SqlDbType.Int, 4),
new SqlParameter("@tuditpye", SqlDbType.Int, 4)
};
parameters[0].Value = usid;
parameters[1].Value = tuditpye;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 通过Id更新
/// price的值
/// /// </summary>
public void UpdatePrice(int ID, long price)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_WinnersGame set ");
strSql.Append("price=@price ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@price", SqlDbType.BigInt, 8)
};
parameters[0].Value = ID;
parameters[1].Value = price;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// me_更新快捷下注
/// </summary>
public void Update_1(int UsID, string Settings, int type)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Public_User set ");
strSql.Append("Settings=@Settings ");
strSql.Append(" where UsID=@UsID and type=@type");
SqlParameter[] parameters =
{
new SqlParameter("@UsID", SqlDbType.Int, 4),
new SqlParameter("@Settings", SqlDbType.NVarChar),
new SqlParameter("@type", SqlDbType.Int, 4)
};
parameters[0].Value = UsID;
parameters[1].Value = Settings;
parameters[2].Value = type;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新时间
/// </summary>
public void updatetime1(int id, DateTime updatetime)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Cmg_Top set ");
strSql.Append("time=@time ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@time", SqlDbType.DateTime)
};
parameters[0].Value = id;
parameters[1].Value = updatetime;
SqlHelperUser.ExecuteSql(strSql.ToString(), parameters);
}