public void GetListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = _wherestr1;
dbOperHandler.Count("Flex_UserGetCash");
string sql = SqlHelp.GetSql0("row_number() over (order by Id desc) as rowid,0.0000 as sxf,*", "Flex_UserGetCash", "Id", _pagesize, _thispage, "desc", _wherestr1);
dbOperHandler.Reset();
dbOperHandler.SqlCmd = sql;
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = base.ConverTableToJSON(dataTable);
dataTable.Clear();
dataTable.Dispose();
}
}
public void GetListJSON(int page, int PSize, string whereStr, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = whereStr;
int num = dbOperHandler.Count("Flex_User");
string sql = SqlHelp.GetSql0(num + " as totalcount,row_number() over (order by Id asc) as rowid,*", "Flex_User", "Id", PSize, page, "asc", whereStr);
dbOperHandler.Reset();
dbOperHandler.SqlCmd = sql;
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = base.ConverTableToJSON(dataTable);
dataTable.Clear();
dataTable.Dispose();
}
}
public string UserTranAcc(string Type, string UserId, string ToUserId, string Money, string PassWord)
{
if (Convert.ToDecimal(Money) < new Decimal(0))
{
return(this.GetJsonResult(0, "转账金额不正确！"));
}
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", (object)UserId);
object[] fields = dbOperHandler.GetFields("N_User", "Money,PayPass");
if (fields.Length <= 0)
{
return(this.GetJsonResult(0, "账号出现问题，请您重新登陆！"));
}
if (Convert.ToDecimal(Money) > Convert.ToDecimal(fields[0]))
{
return(this.GetJsonResult(0, "您的可用余额不足"));
}
if (!MD5.Last64(MD5.Lower32(PassWord)).Equals(fields[1].ToString()))
{
return(this.GetJsonResult(0, "您的取款密码错误"));
}
if (new UserChargeDAL().SaveUpCharge(Type, UserId, ToUserId, Convert.ToDecimal(Money)) <= 0)
{
return(this.GetJsonResult(0, "转账失败！"));
}
new LogSysDAL().Save("会员管理", "Id为" + UserId + "的会员转账给Id为" + ToUserId + "的会员！");
return(this.GetJsonResult(1, "转账成功！"));
}
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public UserModel GetUserInfo(int userId)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
UserModel user = null;
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "select * from V_User where Id=" + userId;
DataTable table = dbOperHandler.GetDataTable();
if (table != null && table.Rows.Count > 0)
{
user = new UserModel();
user.Id = Convert.IsDBNull(table.Rows[0]["Id"]) ? 0 : (int)table.Rows[0]["Id"];
user.UserName = Convert.IsDBNull(table.Rows[0]["UserName"]) ? "" : table.Rows[0]["UserName"].ToString();
user.UserGroup = Convert.IsDBNull(table.Rows[0]["UserGroup"]) ? 0 : (int)table.Rows[0]["UserGroup"];
user.UserGroupName = Convert.IsDBNull(table.Rows[0]["UserGroupName"]) ? "" : table.Rows[0]["UserGroupName"].ToString();
user.ParentId = Convert.IsDBNull(table.Rows[0]["ParentId"]) ? 0 : (int)table.Rows[0]["ParentId"];
}
table.Clear();
table.Dispose();
return(user);
}
}
public void GetMessageListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = _wherestr1;
int num = dbOperHandler.Count("N_UserMessage");
string sql = SqlHelp.GetSql0(num + " as totalcount,row_number() over (order by Id desc) as rowid,dbo.f_GetUserName(UserId) as UserName,*", "N_UserMessage", "Id", _pagesize, _thispage, "desc", _wherestr1);
dbOperHandler.Reset();
dbOperHandler.SqlCmd = sql;
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = base.ConverTableToJSON2(dataTable);
dataTable.Clear();
dataTable.Dispose();
}
}
public void GetListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = _wherestr1;
int num = dbOperHandler.CountId("Flex_History");
string sql = SqlHelp.GetSql0(num + " as totalcount,row_number() over (order by STime desc) as rowid,case when moneychange>0 then Convert(varchar(20),moneychange) else '---' end inmoney,case when moneychange<0 then Convert(varchar(20),moneychange) else '---' end outmoney,*", "Flex_History", "Id", _pagesize, _thispage, "desc", _wherestr1);
dbOperHandler.Reset();
dbOperHandler.SqlCmd = sql;
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = base.ConverTableToJSON(dataTable);
dataTable.Clear();
dataTable.Dispose();
}
}
/// <summary>
/// 检查支付状态
/// </summary>
/// <param name="num">最新支付数量</param>
/// <param name="lastCkDate">上一次检查时间</param>
/// <returns></returns>
public String CheckCashState(ref int num, string lastCkDate = null)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
lastCkDate = string.IsNullOrEmpty(lastCkDate) ? "1900-01-01" : lastCkDate;
String date = string.Empty;
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "SELECT COUNT(1) AS Num, MAX(STime) AS STime FROM N_UserGetCash WHERE ISNULL(State, 0) = 0 AND STime > '" + lastCkDate + "' ORDER BY STime DESC";
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable != null && dataTable.Rows.Count > 0)
{
num = Int32.Parse(dataTable.Rows[0]["Num"].ToString());
if (!Convert.IsDBNull(dataTable.Rows[0]["STime"]))
{
date = dataTable.Rows[0]["STime"].ToString();
}
}
dataTable.Clear();
dataTable.Dispose();
return(date);
}
}
public string Save(string userId, string PayMethod, string PayBank, string PayBankAddress, string PayAccount, string PayName)
{
if (this.Exists(" PayAccount='" + PayAccount + "'"))
{
return(this.GetJsonResult(0, "绑定失败,一张银行卡只能绑一个帐户！"));
}
if (this.Exists(" UserId=" + userId) && !this.Exists(" PayName='" + PayName + "' and UserId=" + userId))
{
return(this.GetJsonResult(0, "绑定失败,同一账户下只能绑定相同的开户名卡号！"));
}
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("UserId", (object)userId);
dbOperHandler.AddFieldItem(nameof(PayMethod), (object)PayMethod);
dbOperHandler.AddFieldItem(nameof(PayBank), (object)PayBank);
dbOperHandler.AddFieldItem(nameof(PayBankAddress), (object)PayBankAddress);
dbOperHandler.AddFieldItem(nameof(PayAccount), (object)PayAccount);
dbOperHandler.AddFieldItem(nameof(PayName), (object)PayName);
dbOperHandler.AddFieldItem("AddTime", (object)DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("IsLock", (object)1);
if (dbOperHandler.Insert("N_UserBank") > 0)
{
return(this.GetJsonResult(1, "银行资料绑定成功！"));
}
return(this.GetJsonResult(0, "银行资料绑定失败！"));
}
}
/// <summary>
/// 读取随笔付支持的支付方式
/// </summary>
/// <returns></returns>
public IList <ChannelMapModel> GetSbfChannels()
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
ArrayList existsChns = new ArrayList(); //已存在的类型
IList <ChannelMapModel> channels = new List <ChannelMapModel>();
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "SELECT SysCode, SbfChannel, SbfCode FROM Sys_SbfChannelMap WHERE IsUsed = 1 ORDER BY Id DESC;";
DataTable dataTable = dbOperHandler.GetDataTable();
for (int index = 0; index < dataTable.Rows.Count; ++index)
{
string sysCode = dataTable.Rows[index]["SysCode"].ToString().Trim();
string sbfChannel = dataTable.Rows[index]["SbfChannel"].ToString().Trim();
string sbfCode = dataTable.Rows[index]["SbfCode"].ToString().Trim();
if (existsChns.Contains(sysCode) == false)
{
channels.Add(new ChannelMapModel()
{
SysCode = sysCode, SbfChannel = sbfChannel, SbfCode = sbfCode
});
existsChns.Add(sysCode);
}
}
dataTable.Clear();
dataTable.Dispose();
return(channels);
}
}
public void GetIphoneBankInfoJSON(string UserId, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=" + UserId;
dbOperHandler.Count("N_UserBank");
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "select top 3 * from V_UserBankInfo where UserId=" + UserId;
dbOperHandler.SqlCmd += "order by Id desc";
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSON(dataTable) + "}";
dataTable.Clear();
dataTable.Dispose();
}
}
public void GetIphoneListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = _wherestr1;
int totalCount = dbOperHandler.Count("Flex_ChargeRecord");
string sql0 = SqlHelp.GetSql0("row_number() over (order by Id desc) as rowid,UserName,*", "Flex_ChargeRecord", "Id", _pagesize, _thispage, "desc", _wherestr1);
dbOperHandler.Reset();
dbOperHandler.SqlCmd = sql0;
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"pagebar\" :\"" + PageBar.GetPageBar(6, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxList(<#page#>);") + "\"," + dtHelp.DT2JSON(dataTable, _pagesize * (_thispage - 1)) + "}";
dataTable.Clear();
dataTable.Dispose();
}
}
public void GetListOnlineJSON(int page, int PSize, string whereStr, string UserId, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = whereStr + " and UserCode like '%," + UserId + ",%'";
int num = dbOperHandler.Count("N_User");
string sql0 = SqlHelp.GetSql0(num.ToString() + " as totalcount,ID,UserName,UserCode,Money,LastTime", "N_User", "Id", PSize, page, "asc", whereStr + " and UserCode like '%," + UserId + ",%'");
dbOperHandler.Reset();
dbOperHandler.SqlCmd = sql0;
DataTable dataTable = dbOperHandler.GetDataTable();
string str1 = "";
if (dataTable.Rows.Count > 0)
{
for (int index1 = 0; index1 < dataTable.Rows.Count; ++index1)
{
string str2 = string.Empty;
string str3 = dataTable.Rows[index1]["UserCode"].ToString().Replace(",,", "_").Replace(",", "");
string[] strArray = str3.Substring(str3.IndexOf(UserId)).Split('_');
if (strArray.Length > 0)
{
for (int index2 = 0; index2 < strArray.Length; ++index2)
{
if (!string.IsNullOrEmpty(strArray[index2]))
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=" + strArray[index2];
str2 = str2 + dbOperHandler.GetField("N_User", "UserName") + ">";
}
}
string str4 = str2.Substring(0, str2.Length - 1);
if (index1 != 0)
{
str1 += " union all ";
}
str1 = str1 + " select " + (object)num + " as totalcount,row_number() over (order by Id asc) as rowid,ID,UserName,UserCode,Money,'" + str4 + "' as CodeName,LastTime from N_User where Id=" + dataTable.Rows[index1]["Id"];
}
}
dbOperHandler.Reset();
dbOperHandler.SqlCmd = str1;
dataTable = dbOperHandler.GetDataTable();
}
_jsonstr = this.ConverTableToJSON(dataTable);
dataTable.Clear();
dataTable.Dispose();
}
}
public string GetEmailCount(string UserId)
{
if (!(UserId != "0"))
{
return(this.GetJsonResult(0, "0"));
}
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "IsDelReceive=0 and IsRead=0 and ReceiveId=" + UserId;
int num1 = dbOperHandler.CountId("N_UserEmail");
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "IsRead=0 and UserId=" + UserId;
int num2 = dbOperHandler.CountId("N_UserMessage");
return(this.GetJsonResult(1, string.Concat((object)(num1 + num2))));
}
}
public string SaveContract(string ParentId, string UserId, Decimal money, Decimal per)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=" + UserId;
dbOperHandler.Delete("Act_UserFHDetail");
dbOperHandler.Reset();
dbOperHandler.AddFieldItem(nameof(ParentId), (object)ParentId);
dbOperHandler.AddFieldItem(nameof(UserId), (object)UserId);
dbOperHandler.AddFieldItem("MinMoney", (object)money);
dbOperHandler.AddFieldItem("Group3", (object)per);
dbOperHandler.AddFieldItem("IsUsed", (object)1);
dbOperHandler.Insert("Act_UserFHDetail");
}
return(this.JsonResult(1, "分配契约成功！"));
}
public string SaveContract(string ParentId, string UserId, decimal money, decimal per)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=" + UserId;
dbOperHandler.Delete("Act_UserFHDetail");
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("ParentId", ParentId);
dbOperHandler.AddFieldItem("UserId", UserId);
dbOperHandler.AddFieldItem("MinMoney", money);
dbOperHandler.AddFieldItem("Group3", per);
dbOperHandler.AddFieldItem("IsUsed", 1);
dbOperHandler.Insert("Act_UserFHDetail");
}
return(base.JsonResult(1, "分配契约成功！"));
}
public string Save(string userId, string PayMethod, string PayBank, string PayBankAddress, string PayAccount, string PayName, string Question, string Answer)
{
if (this.Exists(" PayAccount='" + PayAccount + "'"))
{
return(base.GetJsonResult(0, "绑定失败,一张银行卡只能绑一个帐户！"));
}
string jsonResult;
if (this.Exists(" UserId=" + userId))
{
if (!this.Exists(" PayName='" + PayName + "' and UserId=" + userId))
{
return(base.GetJsonResult(0, "绑定失败,同一账户下只能绑定相同的开户名卡号！"));
}
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=" + userId;
dbOperHandler.AddFieldItem("PayMethod", PayMethod);
dbOperHandler.AddFieldItem("PayBank", PayBank);
dbOperHandler.AddFieldItem("PayBankAddress", PayBankAddress);
dbOperHandler.AddFieldItem("PayAccount", PayAccount);
dbOperHandler.AddFieldItem("PayName", PayName);
dbOperHandler.AddFieldItem("AddTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("IsLock", 1);
if (dbOperHandler.Update("N_UserBank") > 0)
{
new UserDAL().UpdateInfo(userId, Question, Answer);
jsonResult = base.GetJsonResult(1, "银行资料绑定成功！");
return(jsonResult);
}
jsonResult = base.GetJsonResult(0, "银行资料绑定失败！");
return(jsonResult);
}
}
using (DbOperHandler dbOperHandler2 = new ComData().Doh())
{
dbOperHandler2.Reset();
dbOperHandler2.AddFieldItem("UserId", userId);
dbOperHandler2.AddFieldItem("PayMethod", PayMethod);
dbOperHandler2.AddFieldItem("PayBank", PayBank);
dbOperHandler2.AddFieldItem("PayBankAddress", PayBankAddress);
dbOperHandler2.AddFieldItem("PayAccount", PayAccount);
dbOperHandler2.AddFieldItem("PayName", PayName);
dbOperHandler2.AddFieldItem("AddTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler2.AddFieldItem("IsLock", 1);
if (dbOperHandler2.Insert("N_UserBank") > 0)
{
new UserDAL().UpdateInfo(userId, Question, Answer);
jsonResult = base.GetJsonResult(1, "银行资料绑定成功！");
}
else
{
jsonResult = base.GetJsonResult(0, "银行资料绑定失败！");
}
}
return(jsonResult);
}
public string Register(string _ParentId, string _UserGroup, string _UserName, string _Password, string _Point)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "SELECT Id FROM [N_User] WHERE [UserName]='" + _UserName.ToLower() + "'";
if (dbOperHandler.GetDataTable().Rows.Count > 0)
{
return(this.GetJsonResult(0, "账号已存在，请更换一个账号！"));
}
string str = MD5.Last64(MD5.Lower32(_Password));
object[,] _vFields1 = new object[2, 6] {
{ "ParentId", "UserGroup", "UserName", "Password", "Point", "PayPass" },
{ _ParentId, _UserGroup, _UserName.ToLower(), str, _Point, MD5.Last64(MD5.Lower32("123456")) }
};
dbOperHandler.Reset();
dbOperHandler.AddFieldItems(_vFields1);
int num = dbOperHandler.Insert("N_User");
if (num <= 0)
{
return(this.GetJsonResult(0, "添加会员失败！"));
}
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", (object)_ParentId);
object field = dbOperHandler.GetField("N_User", "UserCode");
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=" + (object)num;
dbOperHandler.AddFieldItem("UserCode", (object)(field.ToString() + Strings.PadLeft(num.ToString())));
dbOperHandler.Update("N_User");
object[,] _vFields2 = new object[2, 2] {
{ "UserId", "Change" }, { num, 0 }
};
dbOperHandler.Reset();
dbOperHandler.AddFieldItems(_vFields2);
dbOperHandler.Insert("N_UserMoneyStatAll");
return(this.GetJsonResult(1, "添加会员成功！"));
}
}
public string Save(string userId, string PayMethod, string PayBank, string PayBankAddress, string PayAccount, string PayName, string strPwd)
{
if (this.Exists(" PayAccount='" + PayAccount + "'"))
{
return(base.GetJsonResult(0, "绑定失败,一张银行卡只能绑一个帐户！"));
}
if (this.Exists(" UserId=" + userId) && !this.Exists(" PayName='" + PayName + "' and UserId=" + userId))
{
return(base.GetJsonResult(0, "绑定失败,同一账户下只能绑定相同的开户名卡号！"));
}
string jsonResult;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", userId);
object field = dbOperHandler.GetField("N_User", "PayPass");
if (!MD5.Last64(strPwd).Equals(field.ToString()))
{
jsonResult = base.GetJsonResult(0, "绑定失败,您的提现密码错误！");
}
else
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("UserId", userId);
dbOperHandler.AddFieldItem("PayMethod", PayMethod);
dbOperHandler.AddFieldItem("PayBank", PayBank);
dbOperHandler.AddFieldItem("PayBankAddress", PayBankAddress);
dbOperHandler.AddFieldItem("PayAccount", PayAccount);
dbOperHandler.AddFieldItem("PayName", PayName);
dbOperHandler.AddFieldItem("AddTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("IsLock", 1);
if (dbOperHandler.Insert("N_UserBank") > 0)
{
jsonResult = base.GetJsonResult(1, "银行资料绑定成功！");
}
else
{
jsonResult = base.GetJsonResult(0, "银行资料绑定失败！");
}
}
}
return(jsonResult);
}
public void ajaxGetProListSub(string AdminId, int page, int PSize, string whereStr, string UserName, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
bool flag = true;
if (!string.IsNullOrEmpty(UserName))
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "select Id from N_User where UserName='******' and UserCode like (select UserCode from N_User where Id=" + AdminId + ")+'%'";
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
AdminId = dataTable.Rows[0]["Id"].ToString();
}
else
{
flag = false;
_jsonstr = "[]";
}
}
if (!flag)
{
return;
}
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = " ParentId = " + AdminId + " or Id=" + AdminId;
int num = dbOperHandler.Count("N_User");
string str1 = string.Format("select {1} as totalcount, {0} as UserID,\r\n (select Convert(varchar(10),cast(round([Point]/10.0,2) as numeric(5,2))) from N_User with(nolock) where Id={0} ) as userpoint,\r\n dbo.f_GetUserName({0}) as userName,\r\n (select isnull(sum(money),0) from N_User with(nolock) where Id = {0}) as money,\r\n isnull(sum(b.Charge),0) Charge,isnull(sum(b.GetCash),0) GetCash,isnull(sum(b.Bet),0)-isnull(sum(b.Cancellation),0) Bet,isnull(sum(b.Point),0) Point,isnull(sum(b.Win),0) Win,isnull(sum(b.Cancellation),0) Cancellation,isnull(sum(b.TranAccIn),0) TranAccIn,isnull(sum(b.TranAccOut),0) TranAccOut,isnull(sum(b.Give),0) Give,isnull(sum(b.Other),0) Other,isnull(sum(b.Change),0) Change,\r\n (isnull(sum(Win),0)+isnull(sum(Point),0)+isnull(sum(Change),0)+isnull(sum(Give),0)+isnull(sum(Cancellation),0))-isnull(sum(Bet),0) as total,\r\n (isnull(sum(Charge),0)-isnull(sum(getcash),0)) as moneytotal\r\n from Flex_UserMoneyStatAll b with(nolock)\r\n where {2} and UserId={0}", (object)AdminId, (object)num, (object)whereStr) + " union all ";
dbOperHandler.Reset();
dbOperHandler.SqlCmd = SqlHelp.GetSql0("Id,UserName,Money,Point", "N_User", "ID", PSize, page, "asc", " ParentId = " + AdminId);
DataTable dataTable1 = dbOperHandler.GetDataTable();
for (int index = 0; index < dataTable1.Rows.Count; ++index)
{
string str2 = whereStr + " and UserCode like '%" + Strings.PadLeft(dataTable1.Rows[index]["Id"].ToString()) + "%'";
str1 = str1 + string.Format("select {0} as totalcount, {1} as UserID,\r\n Convert(varchar(10),cast(round({2}/10.0,2) as numeric(5,2))) as userpoint,\r\n '{3}' as userName,\r\n isnull(sum({4}),0) as money,\r\n isnull(sum(b.Charge),0) Charge,isnull(sum(b.GetCash),0) GetCash,isnull(sum(b.Bet),0)-isnull(sum(b.Cancellation),0) Bet,isnull(sum(b.Point),0) Point,isnull(sum(b.Win),0) Win,isnull(sum(b.Cancellation),0) Cancellation,isnull(sum(b.TranAccIn),0) TranAccIn,isnull(sum(b.TranAccOut),0) TranAccOut,isnull(sum(b.Give),0) Give,isnull(sum(b.Other),0) Other,isnull(sum(b.Change),0) Change,\r\n (isnull(sum(Win),0)+isnull(sum(Point),0)+isnull(sum(Change),0)+isnull(sum(Give),0)+isnull(sum(Cancellation),0))-isnull(sum(Bet),0) as total,\r\n (isnull(sum(Charge),0)-isnull(sum(getcash),0)) as moneytotal\r\n from Flex_UserMoneyStatAll b with(nolock)\r\n where {5}", (object)num, (object)dataTable1.Rows[index]["Id"].ToString(), (object)dataTable1.Rows[index]["Point"].ToString(), (object)dataTable1.Rows[index][nameof(UserName)].ToString(), (object)dataTable1.Rows[index]["Money"].ToString(), (object)str2) + " union all ";
}
string str3 = str1 + string.Format("select {2} as totalcount, '-1' as UserID,'合计' as userpoint,'' as userName,\r\n (select isnull(sum(money),0) from N_User with(nolock) where UserCode like '%,{0},%') as money,\r\n isnull(sum(b.Charge),0) Charge,isnull(sum(b.GetCash),0) GetCash,isnull(sum(b.Bet),0)-isnull(sum(b.Cancellation),0) Bet,isnull(sum(b.Point),0) Point,isnull(sum(b.Win),0) Win,isnull(sum(b.Cancellation),0) Cancellation,isnull(sum(b.TranAccIn),0) TranAccIn,isnull(sum(b.TranAccOut),0) TranAccOut,isnull(sum(b.Give),0) Give,isnull(sum(b.Other),0) Other,isnull(sum(b.Change),0) Change,\r\n (isnull(sum(Win),0)+isnull(sum(Point),0)+isnull(sum(Change),0)+isnull(sum(Give),0)+isnull(sum(Cancellation),0))-isnull(sum(Bet),0) as total,\r\n (isnull(sum(Charge),0)-isnull(sum(getcash),0)) as moneytotal\r\n FROM Flex_UserMoneyStatAll b with(nolock) where {1}", (object)AdminId, (object)(whereStr + " and UserCode like '%" + Strings.PadLeft(AdminId) + "%'"), (object)num);
dbOperHandler.Reset();
dbOperHandler.SqlCmd = str3;
DataTable dataTable2 = dbOperHandler.GetDataTable();
_jsonstr = this.ConverTableToJSON(dataTable2);
dataTable2.Clear();
dataTable2.Dispose();
}
}
public void DeleteLogs()
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "1=1";
dbOperHandler.Delete("N_UserCharge");
}
}
public void Delete(string Id)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=" + Id;
dbOperHandler.Delete("N_UserBank");
}
}
public int Check(string _cashId, string _Msg, int State)
{
int num = 0;
using (SqlConnection sqlConnection = new SqlConnection(ComData.connectionString))
{
sqlConnection.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = sqlConnection;
try
{
object[] objArray = new object[2];
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=" + _cashId;
objArray = dbOperHandler.GetFields("N_UserGetCash", "UserId,Money,ssId,STime");
}
if (State == 1)
{
SqlParameter[] values = new SqlParameter[3]
{
new SqlParameter("@Id", (object)_cashId),
new SqlParameter("@Msg", (object)_Msg),
new SqlParameter("@State", (object)1)
};
cmd.CommandText = "update N_UserGetCash set Msg=@Msg,STime2=getdate(),State=1 where Id=" + _cashId;
cmd.Parameters.AddRange(values);
num = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Parameters.Clear();
new UserMessageDAL().Save(cmd, int.Parse(objArray[0].ToString()), "提现成功", "您的" + objArray[1].ToString() + "元提现已处理，请注意查收，如有疑问请联系在线客服！");
}
if (State == 2)
{
if (new UserTotalTran().MoneyOpers(objArray[2].ToString(), objArray[0].ToString(), -Convert.ToDecimal(objArray[1].ToString()), 0, 0, 0, 2, 99, "提现失败", "您的" + objArray[1].ToString() + "元提现被拒绝，拒绝理由：（" + _Msg + "），如有疑问请联系在线客服！", "提现失败", objArray[3].ToString()) <= 0)
{
return(0);
}
SqlParameter[] values = new SqlParameter[3]
{
new SqlParameter("@Id", (object)_cashId),
new SqlParameter("@Msg", (object)_Msg),
new SqlParameter("@State", (object)2)
};
cmd.CommandText = "update N_UserGetCash set Msg=@Msg,STime2=getdate(),State=2 where Id=" + _cashId;
cmd.Parameters.AddRange(values);
num = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Parameters.Clear();
}
}
catch (Exception ex)
{
new LogExceptionDAL().Save("系统异常", ex.Message);
}
}
return(num);
}
public DataTable GetListDataTable(string Id)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "select * from Flex_UserGetCash where state=0 and Id=" + Id;
return(dbOperHandler.GetDataTable());
}
}
public void IsContract(string UserId, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = string.Format("SELECT top 1 Id from N_UserContract where UserId=" + UserId, new object[0]);
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
_jsonstr = "{\"result\" :\"1\",\"result2\" :\"1\",\"returnval\" :\"操作成功\"}";
}
else
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = string.Format("SELECT top 1 UserGroup from N_User where Id=" + UserId, new object[0]);
dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
if (Convert.ToInt32(dataTable.Rows[0]["UserGroup"]) == 4)
{
_jsonstr = "{\"result\" :\"1\",\"result2\" :\"1\",\"returnval\" :\"操作成功\"}";
}
else if (Convert.ToInt32(dataTable.Rows[0]["UserGroup"]) == 3)
{
_jsonstr = "{\"result\" :\"1\",\"result2\" :\"1\",\"returnval\" :\"操作成功\"}";
}
else if (Convert.ToInt32(dataTable.Rows[0]["UserGroup"]) == 2)
{
_jsonstr = "{\"result\" :\"0\",\"result2\" :\"1\",\"returnval\" :\"操作成功\"}";
}
else
{
_jsonstr = "{\"result\" :\"0\",\"result2\" :\"0\",\"returnval\" :\"操作成功\"}";
}
}
else
{
_jsonstr = "{\"result\" :\"0\",\"result2\" :\"0\",\"returnval\" :\"操作成功\"}";
}
}
dataTable.Clear();
dataTable.Dispose();
}
}
public int DeletesMessageById(string Id)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", (object)Id);
return(dbOperHandler.Delete("N_UserMessage"));
}
}
public int UpdatePoint(string UserId, string Point)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=" + UserId;
dbOperHandler.AddFieldItem(nameof(Point), (object)Point);
return(dbOperHandler.Update("N_User"));
}
}
public void GetContractInfo(string UserId, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = string.Format("SELECT top 1 UserGroup from N_User where Id=" + UserId);
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
if (Convert.ToInt32(dataTable.Rows[0]["UserGroup"]) == 4)
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = string.Format("SELECT 4 as [GroupId],[MinMoney],[Group3] as money,[IsUsed],[soft] FROM [Act_Day15FHSet] where GroupId=4 and IsUsed=0");
dataTable = dbOperHandler.GetDataTable();
_jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSONNOHTML(dataTable, 0, "recordcount", "table", true) + "}";
}
else if (Convert.ToInt32(dataTable.Rows[0]["UserGroup"]) == 3)
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = string.Format("SELECT 3 as [GroupId],[MinMoney],[Group3] as money,[IsUsed],[soft] FROM [Act_Day15FHSet] where GroupId=3 and IsUsed=0");
dataTable = dbOperHandler.GetDataTable();
_jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSONNOHTML(dataTable, 0, "recordcount", "table", true) + "}";
}
else if (Convert.ToInt32(dataTable.Rows[0]["UserGroup"]) >= 5)
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = string.Format("SELECT 5 as groupId");
dataTable = dbOperHandler.GetDataTable();
_jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSONNOHTML(dataTable, 0, "recordcount", "table", true) + "}";
}
else
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = string.Format("SELECT 0 as groupId,[Type],[ParentId],[UserId],[IsUsed],[STime],b.*\r\n FROM [N_UserContract] a left join [N_UserContractDetail] b on a.Id=b.UcId where Type=1 and UserId=" + UserId);
dataTable = dbOperHandler.GetDataTable();
_jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSONNOHTML(dataTable, 0, "recordcount", "table", true) + "}";
}
}
dataTable.Clear();
dataTable.Dispose();
}
}
public int UpdateMessageIsRead(string Id)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", (object)Id);
dbOperHandler.AddFieldItem("IsRead", (object)"1");
return(dbOperHandler.Update("N_UserMessage"));
}
}
public int ReadedUserReceive(string UserId)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "ReceiveId=@UserId";
dbOperHandler.AddConditionParameter("@UserId", (object)UserId);
dbOperHandler.AddFieldItem("IsRead", (object)"1");
return(dbOperHandler.Update("N_UserEmail"));
}
}
public int DeletesByUserSend(string UserId)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=@UserId";
dbOperHandler.AddConditionParameter("@SendId", (object)UserId);
dbOperHandler.AddFieldItem("IsDelSend", (object)"1");
return(dbOperHandler.Update("N_UserEmail"));
}
}
