/// <summary> /// 获取待处理的订单 /// </summary> /// <param name="orderId">订单号</param> /// <returns></returns> public IList <CashGetModel> GetListDataTable() { using (DbOperHandler dbOperHandler = new ComData().Doh()) { IList <CashGetModel> records = new List <CashGetModel>(); StringBuilder sql = new StringBuilder("INSERT INTO N_UserGetCashHistory(SsId, UserId, UserName) VALUES"); StringBuilder sqlValue = new StringBuilder(); dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select A.SsId, A.UserId, B.UserName, A.PayBank, A.PayAccount, A.PayName, A.Money, A.Msg from N_UserGetCash A INNER JOIN N_USER B ON A.UserId=B.Id where state=0 and not exists(SELECT 1 FROM N_UserGetCashHistory WHERE SsId = A.SsId)"; DataTable table = dbOperHandler.GetDataTable(); if (table != null && table.Rows.Count > 0) { for (int i = 0; i < table.Rows.Count; i++) { if (table.Rows[i]["Money"] != null) { sqlValue.Append(String.Format("('{0}', {1}, '{2}')", table.Rows[i]["SsId"].ToString(), table.Rows[i]["UserId"].ToString(), table.Rows[i]["UserName"].ToString())); if (i < table.Rows.Count - 1) { sqlValue.Append(","); } records.Add(new CashGetModel() { SsId = table.Rows[i]["SsId"].ToString(), UserName = table.Rows[i]["UserName"].ToString(), PayBank = table.Rows[i]["PayBank"].ToString(), PayAccount = table.Rows[i]["PayAccount"].ToString(), PayName = table.Rows[i]["PayName"].ToString(), Money = Convert.ToDecimal(table.Rows[i]["Money"]), Msg = table.Rows[i]["Msg"].ToString() }); } } } if (records.Count > 0) { dbOperHandler.Reset(); sql.Append(sqlValue.ToString()); dbOperHandler.ExecuteSql(sql.ToString()); } return(records); } }
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, new object[0]); 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],[Money],[IsUsed],[soft] FROM [Act_DayGzSet] where GroupId=4 and IsUsed=0", new object[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],[Money],[IsUsed],[soft] FROM [Act_DayGzSet] where GroupId=3 and IsUsed=0", new object[0]); dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSONNOHTML(dataTable, 0, "recordcount", "table", true) + "}"; } else if (Convert.ToInt32(dataTable.Rows[0]["UserGroup"]) == 2) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("SELECT 2 as [GroupId],[MinMoney],[Money],[IsUsed],[soft] FROM [Act_DayGzSet] where GroupId=2 and IsUsed=0", new object[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", new object[0]); 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=2 and UserId=" + UserId, new object[0]); dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSONNOHTML(dataTable, 0, "recordcount", "table", true) + "}"; } } dataTable.Clear(); dataTable.Dispose(); } }
public int DeletesByUserReceive(string UserId) { int result; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "ReceiveId=@UserId"; dbOperHandler.AddConditionParameter("@UserId", UserId); dbOperHandler.AddFieldItem("IsRead", "1"); dbOperHandler.AddFieldItem("IsDelReceive", "1"); result = dbOperHandler.Update("N_UserEmail"); } return(result); }
public bool Exists(string _wherestr) { int num = 0; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr; if (dbOperHandler.Exist("N_UserBank")) { num = 1; } } return(num == 1); }
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 void GetListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; string sql0 = SqlHelp.GetSql0(dbOperHandler.Count("Flex_ChargeRecord").ToString() + " as totalcount,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 = this.ConverTableToJSON(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; string sql0 = SqlHelp.GetSql0(dbOperHandler.CountId("Flex_History").ToString() + " 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 = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = this.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; string sql0 = SqlHelp.GetSql0(dbOperHandler.Count("Flex_User").ToString() + " as totalcount,row_number() over (order by Id asc) as rowid,*", "Flex_User", "Id", PSize, page, "asc", whereStr); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = this.ConverTableToJSON(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
public string UserTranAcc(string Type, string UserId, string ToUserId, string Money, string PassWord) { if (Convert.ToDecimal(Money) < 0m) { return(base.GetJsonResult(0, "转账金额不正确!")); } string jsonResult; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", UserId); object[] fields = dbOperHandler.GetFields("N_User", "Money,PayPass"); if (fields.Length > 0) { if (Convert.ToDecimal(Money) > Convert.ToDecimal(fields[0])) { jsonResult = base.GetJsonResult(0, "您的可用余额不足"); } else if (!MD5.Last64(MD5.Lower32(PassWord)).Equals(fields[1].ToString())) { jsonResult = base.GetJsonResult(0, "您的取款密码错误"); } else if (new UserChargeDAL().SaveUpCharge(Type, UserId, ToUserId, Convert.ToDecimal(Money)) > 0) { new LogSysDAL().Save("会员管理", string.Concat(new string[] { "Id为", UserId, "的会员转账给Id为", ToUserId, "的会员!" })); jsonResult = base.GetJsonResult(1, "转账成功!"); } else { jsonResult = base.GetJsonResult(0, "转账失败!"); } } 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 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 getUserUpPointListJson(string UserId, string MinPoint, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", (object)UserId); object field = dbOperHandler.GetField("N_User", "Point"); dbOperHandler.SqlCmd = "SELECT point,Convert(varchar(10),cast(round([Point]/10.0,2) as numeric(5,2)))+'%' as title FROM [N_UserLevel] where point<" + field + " and point>=" + (object)(Convert.ToDouble(MinPoint.Replace("%", "")) * 10.0); dbOperHandler.SqlCmd += " ORDER BY Bonus asc"; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = this.ConverTableToJSON(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
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 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 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 void Send(ComData msg) { if (!syncRunning()) { return; } lock (sendQ) { sendQ.AddLast(new Packet(msg)); //if (VERBOSE) Console.WriteLine("send queued <" + sendQ.Last.Value.Key + ">: " + msg.getDataType()); } writeResetEvent.Set(); }
public static DateTime GetServerTime() { string value = ""; using (DbOperHandler dbOperHandler = new ComData().Doh()) { string sqlCmd = "select GETDATE() AS ServerTime"; dbOperHandler.Reset(); dbOperHandler.SqlCmd = sqlCmd; DataTable dataTable = dbOperHandler.GetDataTable(); value = dataTable.Rows[0]["ServerTime"].ToString(); dataTable.Clear(); dataTable.Dispose(); } return(Convert.ToDateTime(value)); }
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 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 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 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, "分配契约成功!")); }
private void tempOnRead(ComData raw) { switch (raw.getDataType()) { case ComData.REQUEST: Console.WriteLine("Requst: " + raw.GetRequest().ToString()); break; case ComData.STRING: Console.WriteLine("String : " + raw.getMessage()); break; default: Console.WriteLine(raw.getDataType()); break; } }
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("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 void getUserPointListJson(string UserId, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", UserId); object field = dbOperHandler.GetField("N_User", "Point"); dbOperHandler.SqlCmd = "SELECT point,Convert(varchar(10),cast(round([Point]/10.0,2) as numeric(5,2)))+'%' as title FROM [N_UserLevel] where point>=100 and point<" + field; DbOperHandler expr_4B = dbOperHandler; expr_4B.SqlCmd += " ORDER BY Bonus desc"; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = base.ConverTableToJSON(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
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(); } }
private void runControl(object sender, DoWorkEventArgs e) { waitForInitInfo(); // blocking long last = currentTimeMilis(); long lastAngleUpdate = currentTimeMilis(); while (!worker.CancellationPending) { long now = currentTimeMilis(); float dt = (now - last) / 10000000f; if (dt < 0.02) { continue; } ComData target = new ComData(); if (step(ref target, dt)) { comObject.sendData(target); } if ((now - lastAngleUpdate) / 10000000f >= 1f) { comObject.sendData(ComRequest.ANGLES); comObject.sendData(ComRequest.POSE); lastAngleUpdate = now; } updatePoseInfo(); updateAngleInfo(); infoForLabels.msg = ""; lock (this) { foreach (Key k in keysDown) { infoForLabels.msg += k.ToString() + "."; } } updateLabelsDelegate(infoForLabels); last = now; } }
public static string GetBetDetail(string STime, string UserId, string BetId) { if (string.IsNullOrEmpty(BetDetailDAL.ReadContentFile(STime + "\\" + UserId + "\\" + BetId + ".js"))) { string str = ""; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select [Detail] from N_UserBet where Id=" + BetId; DataTable dataTable = dbOperHandler.GetDataTable(); str = string.Concat(dataTable.Rows[0]["Detail"]); dataTable.Clear(); dataTable.Dispose(); } return(BetDetailDAL.ReadContentFile(STime + "\\" + UserId + "\\" + str + ".js")); } return(BetDetailDAL.ReadContentFile(STime + "\\" + UserId + "\\" + BetId + ".js")); }