public string UserInfo(string UserId, string SessionId)
{
if (!(UserId != "0") || !(SessionId != "0"))
{
return(this.GetJsonResult(0, "登陆已超时，请您重新登陆！"));
}
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = string.Format("SELECT '1' as result,Id,Money,IsDel,IsEnable,sessionId\r\n ,Convert(varchar(10),cast(round(Point/10.0,2) as numeric(10,2))) as Point\r\n ,'0' as email\r\n ,'0' as notice\r\n FROM [N_User] a where Id={0} and sessionId='{1}'", (object)UserId, (object)SessionId);
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["IsDel"].Equals((object)"1") || dataTable.Rows[0]["IsEnable"].Equals((object)"1"))
{
return(this.GetJsonResult(0, "您的账户存在未知问题，请于客服联系！"));
}
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", (object)UserId);
dbOperHandler.AddFieldItem("ontime", (object)DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("IsOnline", (object)1);
dbOperHandler.Update("N_User");
dbOperHandler.Dispose();
return(this.ConverTableToJSON(dataTable));
}
dbOperHandler.Dispose();
return(this.GetJsonResult(0, "登陆已超时，请您重新登陆"));
}
}
public string ChangePayPassword(string _userid, string _oldPassword, string _newPassword)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", (object)_userid);
object field = dbOperHandler.GetField("N_User", "PayPass");
if (field == null)
{
return(this.GetJsonResult(0, "原取款密码错误！"));
}
if (!(field.ToString().ToLower() == MD5.Last64(MD5.Lower32(_oldPassword))))
{
return(this.GetJsonResult(0, "原取款密码错误！"));
}
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", (object)_userid);
dbOperHandler.AddFieldItem("PayPass", (object)MD5.Last64(MD5.Lower32(_newPassword)));
dbOperHandler.AddFieldItem("IP", (object)Const.GetUserIp);
if (dbOperHandler.Update("N_User") > 0)
{
return(this.GetJsonResult(1, "取款密码修改成功！"));
}
return(this.GetJsonResult(0, "取款密码修改失败！"));
}
}
public int UpdateInfo(string UserId, string Question, string Answer)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=" + UserId;
dbOperHandler.AddFieldItem(nameof(Question), (object)Question);
dbOperHandler.AddFieldItem(nameof(Answer), (object)Answer);
return(dbOperHandler.Update("N_User"));
}
}
public int DeletesByUserReceive(string UserId)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "ReceiveId=@UserId";
dbOperHandler.AddConditionParameter("@UserId", (object)UserId);
dbOperHandler.AddFieldItem("IsRead", (object)"1");
dbOperHandler.AddFieldItem("IsDelReceive", (object)"1");
return(dbOperHandler.Update("N_UserEmail"));
}
}
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, "银行资料绑定失败！"));
}
}
public int UpdateInfo(string UserId, string Question, string Answer)
{
int result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=" + UserId;
dbOperHandler.AddFieldItem("Question", Question);
dbOperHandler.AddFieldItem("Answer", Answer);
result = dbOperHandler.Update("N_User");
}
return(result);
}
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 UpdateInfo(string UserId, string QQ, string Email, string Mobile)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=" + UserId;
dbOperHandler.AddFieldItem(nameof(QQ), (object)QQ);
dbOperHandler.AddFieldItem(nameof(Email), (object)Email);
dbOperHandler.AddFieldItem(nameof(Mobile), (object)Mobile);
if (dbOperHandler.Update("N_User") > 0)
{
return(this.GetJsonResult(1, "基本信息保存成功！"));
}
return(this.GetJsonResult(0, "基本信息保存失败！"));
}
}
public string ClearUserPassword(string _userid, string Password)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", (object)_userid);
dbOperHandler.AddFieldItem("PassWord", (object)MD5.Last64(MD5.Lower32(Password)));
dbOperHandler.AddFieldItem("IP", (object)Const.GetUserIp);
if (dbOperHandler.Update("N_User") > 0)
{
return(this.GetJsonResult(1, "重置密码成功！"));
}
return(this.GetJsonResult(0, "重置密码失败！"));
}
}
public string UpdateContractState(string UserId, string state)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Type=1 and UserId=@UserId";
dbOperHandler.AddConditionParameter("@UserId", (object)UserId);
dbOperHandler.AddFieldItem("IsUsed", (object)state);
dbOperHandler.AddFieldItem("STime2", (object)DateTime.Now);
if (dbOperHandler.Update("N_UserContract") > 0)
{
return(this.JsonResult(1, "契约签订成功！"));
}
}
return(this.JsonResult(0, "契约签订失败！"));
}
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 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 int Save(string userId, string bankId, string checkCode, Decimal money)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
int num = 0;
if (bankId == "888")
{
num = 1;
}
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "select top 1 * from Sys_Info";
DataTable dataTable = dbOperHandler.GetDataTable();
if (Convert.ToDecimal(money) < Convert.ToDecimal(dataTable.Rows[0]["MinCharge"].ToString()))
{
return(-1);
}
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("SsId", (object)SsId.Charge);
dbOperHandler.AddFieldItem("UserId", (object)userId);
dbOperHandler.AddFieldItem("BankId", (object)bankId);
dbOperHandler.AddFieldItem("CheckCode", (object)checkCode);
dbOperHandler.AddFieldItem("InMoney", (object)money);
dbOperHandler.AddFieldItem("STime", (object)DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("State", (object)num);
return(dbOperHandler.Insert("N_UserCharge"));
}
}
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 UpdateState(string _id)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", (object)_id);
dbOperHandler.AddFieldItem("IsRead", (object)"1");
dbOperHandler.Update("N_UserEmail");
}
}
public int DeletesSend(string _id)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", (object)_id);
dbOperHandler.AddFieldItem("IsDelSend", (object)"1");
return(dbOperHandler.Update("N_UserEmail"));
}
}
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 string ChangeUserPassword(string _userid, string _oldPassword, string _newPassword)
{
string jsonResult;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", _userid);
object field = dbOperHandler.GetField("N_User", "PassWord");
if (field != null)
{
if (field.ToString().ToLower() == MD5.Last64(MD5.Lower32(_oldPassword)))
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", _userid);
dbOperHandler.AddFieldItem("PassWord", MD5.Last64(MD5.Lower32(_newPassword)));
dbOperHandler.AddFieldItem("IP", Const.GetUserIp);
if (dbOperHandler.Update("N_User") > 0)
{
jsonResult = base.GetJsonResult(1, "登录密码修改成功！");
}
else
{
jsonResult = base.GetJsonResult(0, "登录密码修改失败！");
}
}
else
{
jsonResult = base.GetJsonResult(0, "原登录密码错误！");
}
}
else
{
jsonResult = base.GetJsonResult(0, "原登录密码错误！");
}
}
return(jsonResult);
}
public int UpdatePoint(string UserId, string Point)
{
int result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=" + UserId;
dbOperHandler.AddFieldItem("Point", Point);
result = dbOperHandler.Update("N_User");
}
return(result);
}
public string Login(string UserName, string UserPass)
{
UserName = UserName.ToLower().Replace("'", "");
UserPass = MD5.Last64(MD5.Lower32(UserPass));
string text = Guid.NewGuid().ToString().Replace("-", "");
string result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = string.Format("SELECT TOP 1 '1' as result,a.Id,ParentId,UserGroup,Convert(varchar(10),cast(round(Point/10.0,2) as numeric(10,2))) as Point,\r\n UserName,Money,'{0}' as SessionId,LastTime,OnTime,IP,a.IsEnable,IsGetCash,IsBet,IsTranAcc,EnableSeason,LoginId,\r\n case when b.Id is null then '0' else '1' end as IsBank,'0' as email,'0' as notice \r\n FROM N_User a left join N_UserBank b on a.Id=b.UserId\r\n where username='******' and password='******' and isDel=0", text, UserName, UserPass);
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
if (Convert.ToInt32(dataTable.Rows[0]["IsEnable"].ToString()) == 1)
{
result = base.GetJsonResult(0, "您的账户存在未知问题，请于客服联系！");
}
else if (Convert.ToInt32(dataTable.Rows[0]["IsEnable"].ToString()) == 2)
{
result = base.GetJsonResult(0, "对不起，您的网络不稳定，请重新登录！！");
}
else
{
this.ClearSession();
Cookie.SetObj("UserId", dataTable.Rows[0]["Id"].ToString());
Cookie.SetObj("UserName", UserName);
Cookie.SetObj("UserPoint", dataTable.Rows[0]["Point"].ToString());
Cookie.SetObj("SessionId", text);
string clientIP = IPHelp.ClientIP;
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", dataTable.Rows[0]["Id"].ToString());
dbOperHandler.AddFieldItem("LastTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("ontime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("IP", clientIP);
dbOperHandler.AddFieldItem("sessionId", text);
dbOperHandler.AddFieldItem("IsOnline", 1);
dbOperHandler.AddFieldItem("Source", 0);
dbOperHandler.Update("N_User");
dbOperHandler.Dispose();
IPScaner iPScaner = new IPScaner();
iPScaner.DataPath = HttpContext.Current.Server.MapPath("Data/qqwry.dat");
iPScaner.IP = clientIP;
string address = iPScaner.IPLocation() + iPScaner.ErrMsg;
string browser = HttpContext.Current.Request.Browser.Browser + " " + HttpContext.Current.Request.Browser.Version;
string oSNameByUserAgent = this.GetOSNameByUserAgent(HttpContext.Current.Request.UserAgent);
new LogUserLoginDAL().Save(dataTable.Rows[0]["Id"].ToString(), address, browser, oSNameByUserAgent, clientIP);
result = base.ConverTableToJSON(dataTable);
}
}
else
{
dbOperHandler.Dispose();
result = base.GetJsonResult(0, "登录失败，用户名或密码错误！");
}
}
return(result);
}
public string UpdateInfo(string UserId, string QQ, string Email, string Mobile)
{
string jsonResult;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=" + UserId;
dbOperHandler.AddFieldItem("QQ", QQ);
dbOperHandler.AddFieldItem("Email", Email);
dbOperHandler.AddFieldItem("Mobile", Mobile);
if (dbOperHandler.Update("N_User") > 0)
{
jsonResult = base.GetJsonResult(1, "基本信息保存成功！");
}
else
{
jsonResult = base.GetJsonResult(0, "基本信息保存失败！");
}
}
return(jsonResult);
}
public int ReadedUserMessage(string UserId)
{
int result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=@UserId";
dbOperHandler.AddConditionParameter("@UserId", UserId);
dbOperHandler.AddFieldItem("IsRead", "1");
result = dbOperHandler.Update("N_UserMessage");
}
return(result);
}
public int UpdateIsRead(string Id)
{
int result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", Id);
dbOperHandler.AddFieldItem("IsRead", "1");
result = dbOperHandler.Update("N_UserEmail");
}
return(result);
}
public int DeletesByUserSend(string UserId)
{
int result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=@UserId";
dbOperHandler.AddConditionParameter("@SendId", UserId);
dbOperHandler.AddFieldItem("IsDelSend", "1");
result = dbOperHandler.Update("N_UserEmail");
}
return(result);
}
public int DeletesReceive(string _id)
{
int result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", _id);
dbOperHandler.AddFieldItem("IsDelReceive", "1");
result = dbOperHandler.Update("N_UserEmail");
}
return(result);
}
public string SaveContractState(string UserId)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=@UserId";
dbOperHandler.AddConditionParameter("@UserId", UserId);
dbOperHandler.AddFieldItem("IsUsed", 0);
if (dbOperHandler.Update("Act_UserFHDetail") > 0)
{
return(base.GetJsonResult(1, "契约签订成功！"));
}
}
return(base.GetJsonResult(0, "契约签订失败！"));
}
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 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 int SaveChargeInfo(string SsId, string UserId, string BankId, string CheckCode, Decimal Money)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
int num = 0;
if (BankId == "888")
{
num = 1;
}
dbOperHandler.Reset();
dbOperHandler.AddFieldItem(nameof(SsId), (object)SsId);
dbOperHandler.AddFieldItem(nameof(UserId), (object)UserId);
dbOperHandler.AddFieldItem(nameof(BankId), (object)BankId);
dbOperHandler.AddFieldItem(nameof(CheckCode), (object)CheckCode);
dbOperHandler.AddFieldItem("InMoney", (object)Money);
dbOperHandler.AddFieldItem("STime", (object)DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("State", (object)num);
return(dbOperHandler.Insert("N_UserCharge"));
}
}
public void GetMsgJSON(string UserId, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "select top 1 Id,title,Msg from N_UserMessage with(nolock) where IsRead=0 and UserId=" + UserId + " order by Id desc";
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", (object)dataTable.Rows[0]["Id"].ToString());
dbOperHandler.AddFieldItem("IsRead", (object)"1");
dbOperHandler.Update("N_UserMessage");
_jsonstr = this.ConverTableToJSON(dataTable);
}
else
{
_jsonstr = "[{\"title\":\"0\",\"msg\":\"0\"}]";
}
dataTable.Clear();
dataTable.Dispose();
}
}
