/// <summary> /// 得到一个对象实体 /// </summary> public lgk.Model.tb_bonus GetModel(long ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,UserID,TypeID,Amount,Revenue,sf,AddTime,IsSettled,Source,SourceEn,SttleTime,FromUserID,Bonus001,Bonus002,Bonus003,Bonus004,Bonus005,Bonus006,Bonus007,Batch from tb_bonus "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.BigInt) }; parameters[0].Value = ID; lgk.Model.tb_bonus model = new lgk.Model.tb_bonus(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void ProcessRequest(HttpContext context) { string result = "error"; string message = ""; string dates = ""; string strID = context.Request["ID"]; string strUserID = context.Request["UserID"]; decimal Money = 0; long ID = 0; long UserID = 0; if (string.IsNullOrEmpty(strID) || strID.Trim() == string.Empty || string.IsNullOrEmpty(strUserID) || strUserID.Trim() == string.Empty) { message = "账号不存在"; SendResponse(context, result, message, dates); return; } try { ID = long.Parse(strID); UserID = long.Parse(strUserID); } catch (Exception) { ID = 0; UserID = 0; message = "账号不存在"; SendResponse(context, result, message, dates); } AllCore core = new AllCore(); lgk.Model.tb_user userModel = core.userBLL.GetModel(UserID); SqlConnection conn = new SqlConnection(sconn); conn.Open(); string sql = string.Format("select ID,RandMoney from tb_Rand where ID=" + ID + " and Flag=0 and UserID= '" + UserID + "' ;"); SqlDataAdapter da = new SqlDataAdapter(sql, conn); DataTable dt = new DataTable(); da.Fill(dt); conn.Close(); if (dt.Rows.Count > 0) { Money = decimal.Parse(dt.Rows[0]["RandMoney"].ToString()); conn.Open(); string sql_1 = "update tb_Rand set Flag=2,ClickTime=getdate() where ID='" + ID + "' and UserID= '" + UserID + "';update tb_user set BonusAccount+='" + Money + "' where UserID= '" + UserID + "'; "; SqlCommand cmd = new SqlCommand(sql_1, conn); int reInt = cmd.ExecuteNonQuery(); conn.Close(); if (reInt > 0) { AllCore AC = new AllCore(); var model = AC.userBLL.GetModel(UserID); dates = "\"Account\":{\"Emoney\":\"" + model.Emoney.ToString() + "\",\"BonusAccount\":\"" + model.BonusAccount.ToString() + "\",\"ShengYuSuanLi\":\"" + Convert.ToInt32(model.User012) + "\"}"; result = "success"; message = "领取成功!"; //明细记录 var Mjournal = new lgk.Model.tb_journal(); lgk.BLL.tb_journal Bjournal = new lgk.BLL.tb_journal(); Mjournal.UserID = UserID; Mjournal.InAmount = Money; Mjournal.OutAmount = 0; Mjournal.Remark = "领取奖励分 "; Mjournal.RemarkEn = "Collect " + Money + " clouds"; Mjournal.JournalType = 2; Mjournal.BalanceAmount = model.BonusAccount; Mjournal.JournalDate = DateTime.Now; Bjournal.Add(Mjournal); //奖项记录 lgk.Model.tb_bonus Mbonus = new lgk.Model.tb_bonus(); lgk.BLL.tb_bonus Bbonus = new lgk.BLL.tb_bonus(); Mbonus.AddTime = DateTime.Now; Mbonus.TypeID = 1; Mbonus.IsSettled = 1; Mbonus.FromUserID = UserID; Mbonus.Amount = Money; Mbonus.UserID = UserID; Mbonus.Source = "领取奖励分 "; Mbonus.sf = Money; Mbonus.SourceEn = "Collect " + Money + " clouds"; Mbonus.SttleTime = DateTime.Now; Bbonus.Add(Mbonus); //如果冻结奖励分账户大于0,激活矿机时转入明细 if (userModel.User016 > 0) { core.UpdateAccount("User016", userModel.UserID, userModel.User016, 0); // core.UpdateAccount("BonusAccount", userModel.UserID, userModel.User016, 1); // lgk.Model.tb_journal jourInfo = new lgk.Model.tb_journal(); jourInfo.UserID = userModel.UserID; jourInfo.Remark = "奖励分账户进账,冻结奖励分转入奖励分账户"; jourInfo.RemarkEn = "Cash withdrawal"; jourInfo.InAmount = userModel.User016; jourInfo.OutAmount = 0; jourInfo.BalanceAmount = core.userBLL.GetMoney(UserID, "BonusAccount"); jourInfo.JournalDate = DateTime.Now; jourInfo.JournalType = (int)Library.AccountType.奖励分; jourInfo.Journal01 = userModel.UserID; core.journalBLL.Add(jourInfo); } SendResponse(context, result, message, dates); //差一条记录 } } message = "已经领取过"; SendResponse(context, result, message, dates); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(lgk.Model.tb_bonus model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_bonus("); strSql.Append("UserID,TypeID,Amount,Revenue,sf,AddTime,IsSettled,Source,SourceEn,SttleTime,FromUserID,Bonus001,Bonus002,Bonus003,Bonus004,Bonus005,Bonus006,Bonus007,Batch)"); strSql.Append(" values ("); strSql.Append("@UserID,@TypeID,@Amount,@Revenue,@sf,@AddTime,@IsSettled,@Source,@SourceEn,@SttleTime,@FromUserID,@Bonus001,@Bonus002,@Bonus003,@Bonus004,@Bonus005,@Bonus006,@Bonus007,@Batch)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.BigInt, 8), new SqlParameter("@TypeID", SqlDbType.Int, 4), new SqlParameter("@Amount", SqlDbType.Decimal, 9), new SqlParameter("@Revenue", SqlDbType.Decimal, 9), new SqlParameter("@sf", SqlDbType.Decimal, 9), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@IsSettled", SqlDbType.Int, 4), new SqlParameter("@Source", SqlDbType.VarChar, 1000), new SqlParameter("@SourceEn", SqlDbType.VarChar, 1000), new SqlParameter("@SttleTime", SqlDbType.DateTime), new SqlParameter("@FromUserID", SqlDbType.BigInt, 8), new SqlParameter("@Bonus001", SqlDbType.Int, 4), new SqlParameter("@Bonus002", SqlDbType.Int, 4), new SqlParameter("@Bonus003", SqlDbType.VarChar, 50), new SqlParameter("@Bonus004", SqlDbType.VarChar, 50), new SqlParameter("@Bonus005", SqlDbType.Decimal, 9), new SqlParameter("@Bonus006", SqlDbType.Decimal, 9), new SqlParameter("@Bonus007", SqlDbType.DateTime), new SqlParameter("@Batch", SqlDbType.Int, 4) }; parameters[0].Value = model.UserID; parameters[1].Value = model.TypeID; parameters[2].Value = model.Amount; parameters[3].Value = model.Revenue; parameters[4].Value = model.sf; parameters[5].Value = model.AddTime; parameters[6].Value = model.IsSettled; parameters[7].Value = model.Source; parameters[8].Value = model.SourceEn; parameters[9].Value = model.SttleTime; parameters[10].Value = model.FromUserID; parameters[11].Value = model.Bonus001; parameters[12].Value = model.Bonus002; parameters[13].Value = model.Bonus003; parameters[14].Value = model.Bonus004; parameters[15].Value = model.Bonus005; parameters[16].Value = model.Bonus006; parameters[17].Value = model.Bonus007; parameters[18].Value = model.Batch; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public lgk.Model.tb_bonus DataRowToModel(DataRow row) { lgk.Model.tb_bonus model = new lgk.Model.tb_bonus(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = long.Parse(row["ID"].ToString()); } if (row["UserID"] != null && row["UserID"].ToString() != "") { model.UserID = long.Parse(row["UserID"].ToString()); } if (row["TypeID"] != null && row["TypeID"].ToString() != "") { model.TypeID = int.Parse(row["TypeID"].ToString()); } if (row["Amount"] != null && row["Amount"].ToString() != "") { model.Amount = decimal.Parse(row["Amount"].ToString()); } if (row["Revenue"] != null && row["Revenue"].ToString() != "") { model.Revenue = decimal.Parse(row["Revenue"].ToString()); } if (row["sf"] != null && row["sf"].ToString() != "") { model.sf = decimal.Parse(row["sf"].ToString()); } if (row["AddTime"] != null && row["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(row["AddTime"].ToString()); } if (row["IsSettled"] != null && row["IsSettled"].ToString() != "") { model.IsSettled = int.Parse(row["IsSettled"].ToString()); } if (row["Source"] != null) { model.Source = row["Source"].ToString(); } if (row["SourceEn"] != null) { model.SourceEn = row["SourceEn"].ToString(); } if (row["SttleTime"] != null && row["SttleTime"].ToString() != "") { model.SttleTime = DateTime.Parse(row["SttleTime"].ToString()); } if (row["FromUserID"] != null && row["FromUserID"].ToString() != "") { model.FromUserID = long.Parse(row["FromUserID"].ToString()); } if (row["Bonus001"] != null && row["Bonus001"].ToString() != "") { model.Bonus001 = int.Parse(row["Bonus001"].ToString()); } if (row["Bonus002"] != null && row["Bonus002"].ToString() != "") { model.Bonus002 = int.Parse(row["Bonus002"].ToString()); } if (row["Bonus003"] != null) { model.Bonus003 = row["Bonus003"].ToString(); } if (row["Bonus004"] != null) { model.Bonus004 = row["Bonus004"].ToString(); } if (row["Bonus005"] != null && row["Bonus005"].ToString() != "") { model.Bonus005 = decimal.Parse(row["Bonus005"].ToString()); } if (row["Bonus006"] != null && row["Bonus006"].ToString() != "") { model.Bonus006 = decimal.Parse(row["Bonus006"].ToString()); } if (row["Bonus007"] != null && row["Bonus007"].ToString() != "") { model.Bonus007 = DateTime.Parse(row["Bonus007"].ToString()); } if (row["Batch"] != null && row["Batch"].ToString() != "") { model.Batch = int.Parse(row["Batch"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_bonus model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_bonus set "); strSql.Append("UserID=@UserID,"); strSql.Append("TypeID=@TypeID,"); strSql.Append("Amount=@Amount,"); strSql.Append("Revenue=@Revenue,"); strSql.Append("sf=@sf,"); strSql.Append("AddTime=@AddTime,"); strSql.Append("IsSettled=@IsSettled,"); strSql.Append("Source=@Source,"); strSql.Append("SourceEn=@SourceEn,"); strSql.Append("SttleTime=@SttleTime,"); strSql.Append("FromUserID=@FromUserID,"); strSql.Append("Bonus001=@Bonus001,"); strSql.Append("Bonus002=@Bonus002,"); strSql.Append("Bonus003=@Bonus003,"); strSql.Append("Bonus004=@Bonus004,"); strSql.Append("Bonus005=@Bonus005,"); strSql.Append("Bonus006=@Bonus006,"); strSql.Append("Bonus007=@Bonus007,"); strSql.Append("Batch=@Batch"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.BigInt, 8), new SqlParameter("@TypeID", SqlDbType.Int, 4), new SqlParameter("@Amount", SqlDbType.Decimal, 9), new SqlParameter("@Revenue", SqlDbType.Decimal, 9), new SqlParameter("@sf", SqlDbType.Decimal, 9), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@IsSettled", SqlDbType.Int, 4), new SqlParameter("@Source", SqlDbType.VarChar, 1000), new SqlParameter("@SourceEn", SqlDbType.VarChar, 1000), new SqlParameter("@SttleTime", SqlDbType.DateTime), new SqlParameter("@FromUserID", SqlDbType.BigInt, 8), new SqlParameter("@Bonus001", SqlDbType.Int, 4), new SqlParameter("@Bonus002", SqlDbType.Int, 4), new SqlParameter("@Bonus003", SqlDbType.VarChar, 50), new SqlParameter("@Bonus004", SqlDbType.VarChar, 50), new SqlParameter("@Bonus005", SqlDbType.Decimal, 9), new SqlParameter("@Bonus006", SqlDbType.Decimal, 9), new SqlParameter("@Bonus007", SqlDbType.DateTime), new SqlParameter("@Batch", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.BigInt, 8) }; parameters[0].Value = model.UserID; parameters[1].Value = model.TypeID; parameters[2].Value = model.Amount; parameters[3].Value = model.Revenue; parameters[4].Value = model.sf; parameters[5].Value = model.AddTime; parameters[6].Value = model.IsSettled; parameters[7].Value = model.Source; parameters[8].Value = model.SourceEn; parameters[9].Value = model.SttleTime; parameters[10].Value = model.FromUserID; parameters[11].Value = model.Bonus001; parameters[12].Value = model.Bonus002; parameters[13].Value = model.Bonus003; parameters[14].Value = model.Bonus004; parameters[15].Value = model.Bonus005; parameters[16].Value = model.Bonus006; parameters[17].Value = model.Bonus007; parameters[18].Value = model.Batch; parameters[19].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }