/// <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);
}
}
