/// <summary> /// 添加广告 /// </summary> /// <param name="loginId">登录标识</param> /// <param name="exp">体验券</param> /// <returns>ResultDesc</returns> public ResultDesc AddAdvert(string loginId, Advert exp) { ResultDesc rsdc = new ResultDesc(); var tdUser = new TradeUser(); try { #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(loginId, ref tdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } #endregion var sqlList = new List<string>(); sqlList.Add(string.Format("INSERT INTO [Trade_Advert]([ID] ,[Url] ,[Creator] ,[CreateDate],[Status] ,[Remark],[Name]) VALUES ('{0}' ,'{1}' ,'{2}' ,'{3}' ,{4} ,'{5}','{6}')", exp.ID, exp.Url, exp.Creator, exp.CreateDate, Convert.ToByte(exp.Status), exp.Remark, exp.Name)); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "添加广告出错!"; return rsdc; } rsdc.Result = true; rsdc.Desc = "添加广告成功!"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = ""; } return rsdc; }
/// <summary> /// 华夏银行签约,他行开户 /// </summary> /// <param name="userid">用户ID</param> /// <param name="OpenBank">他行开户信息</param> /// <returns>签约结果</returns> public ResultDesc ContactToHuaxiaOhterBank(string userid, OpenBankInfo OpenBank) { ResultDesc rsdc = new ResultDesc(); TradeUser TdUser = new TradeUser(); try { #region 判断用户ID是否为空 if(string.IsNullOrEmpty(userid)) { rsdc.Result = false; rsdc.Desc = "用户ID不能为空"; return rsdc; } #endregion TdUser = ComFunction.GetTradeUserByUserid(userid); //Fundinfo Fdinfo = ComFunction.GetFdinfo(string.Format("select * from Trade_FundInfo where userid='{0}' and state<>'4'", userid)); string codeDesc = string.Empty; string subUser = string.Empty; //调用华夏银行子帐户同步接口 if (!ComFunction.ContactToHuaxiaOhterBank(TdUser, OpenBank, ref codeDesc, ref subUser)) { rsdc.Result = false; rsdc.Desc = string.Format("华夏银行签约,他行开户时,失败,华夏返回消息:{0}", codeDesc); return rsdc; } //SQL语句 List<string> sqlList = new List<string>(); string sql1 = string.Format("update Trade_FundInfo set state='{0}',ConBankType='1',ConTime='{1}',BankAccount='{2}',AccountName='{3}',BankCard='{4}',OpenBank='{5}',OpenBankAddress='{6}',subUser='******' where userid='{7}' and state<>'{8}'", 2, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), OpenBank.BankAccount, OpenBank.AccountName, OpenBank.BankCard, OpenBank.OpenBank, OpenBank.OpenBankAddress, userid, 4, subUser); sqlList.Add(sql1);//0代表未签约 1表示审核中 2表示签约成功 3 表示失败 4表示已解约 if (!ComFunction.SqlTransaction(sqlList)) { LogNet4.WriteMsg(string.Format("华夏银行签约,他行开户成功,但是SQL语句执行失败,SQL语句是:{0}",sql1)); } rsdc.Result = true; rsdc.Desc = "华夏银行签约,他行开户时,成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "华夏银行签约,他行开户时,失败"; } return rsdc; }
/// <summary> /// 普通用户转经纪人 /// </summary> /// <param name="loginId">登录ID</param> /// <param name="wUserId">微交易用户ID</param> /// <returns>ResultDesc</returns> public ResultDesc BecomeEconomicMan(string loginId, string wUserId) { var rsdc = new ResultDesc(); var tdUser = new TradeUser(); try { #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(loginId, ref tdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } #endregion string operUser = tdUser.Account;//操作人 var sqlList = new List<string>(); string uSql = string.Format(@"update Base_WUser set AccountType='4' where WUserId='{0}'", wUserId); sqlList.Add(uSql); //添加操作记录 string ipmac = ComFunction.GetIpMac(tdUser.Ip, tdUser.Mac); sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)tdUser.UType, string.Format("{0}转经纪人", ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "转经纪人出错!"; return rsdc; } rsdc.Result = true; rsdc.Desc = "转经纪人成功!"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "服务器返回错误"; } return rsdc; }
/// <summary> /// 2.3.4.5 添加客户到客户组 /// </summary> /// <param name="account">客户账号</param> /// <param name="UserGroupId">客户组ID</param> /// <param name="LoginId"></param> /// <param name="tduser">添加成功后,返回的被添加的客户的信息</param> /// <returns></returns> public ResultDesc AddUserToUserGroups(string account, string UserGroupId, String LoginId, ref TradeUser tduser) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion List<string> sqlList = new List<string>(); string UserId = ComFunction.GetUserId(account); if (string.IsNullOrEmpty(UserId)) { rsdc.Result = false; rsdc.Desc = string.Format("帐号{0}不存在", account); return rsdc; } if (ComFunction.ExistUserInTheGroup(UserId, UserGroupId)) { rsdc.Result = false; rsdc.Desc = string.Format("帐号{0}已经添加到该组了", account); return rsdc; } tduser = ComFunction.GetTradeUserByUserid(UserId); sqlList.Add(string.Format("delete from Trade_User_Group where UserId='{0}' ", UserId)); sqlList.Add(string.Format("insert into Trade_User_Group(UserId, UserGroupId) values('{0}','{1}') ", UserId, UserGroupId)); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "添加客户出错"; return rsdc; } rsdc.Result = true; rsdc.Desc = "添加客户成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "添加客户失败"; } return rsdc; }
/// <summary> /// 2.3.4.2 添加客户组 /// </summary> /// <param name="ugs"></param> /// <param name="LoginId"></param> /// <returns></returns> public ResultDesc AddUserGroups(UserGroups ugs, String LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion if (string.IsNullOrEmpty(ugs.UserGroupName)) { rsdc.Result = false; rsdc.Desc = "客户组名称不能为空"; return rsdc; } List<string> sqlList = new List<string>(); sqlList.Add(string.Format(@"insert into Trade_UserGroups(UserGroupId, UserGroupName, IsDefaultGroup, AfterSecond, PlaceOrderSlipPoint, FlatOrderSlipPoint, DelayPlaceOrder, DelayFlatOrder) values('{0}','{1}',{2},{3},{4},{5},{6},{7}) ", ugs.UserGroupId, ugs.UserGroupName, ugs.IsDefaultGroup, ugs.AfterSecond, ugs.PlaceOrderSlipPoint, ugs.FlatOrderSlipPoint, ugs.DelayPlaceOrder, ugs.DelayFlatOrder)); if (1 == ugs.IsDefaultGroup)//如果新加的组为默认组时,需要把其他组全部修改为非默认组 { sqlList.Add(string.Format("update Trade_UserGroups set IsDefaultGroup=0 where UserGroupId<>'{0}'", ugs.UserGroupId)); } if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "添加客户组出错"; return rsdc; } rsdc.Result = true; rsdc.Desc = "添加客户组成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "添加客户组失败"; } return rsdc; }
/// <summary> /// 解约处理-拒绝 /// </summary> /// <param name="ApplyId"></param> /// <param name="LoginId"></param> /// <returns></returns> public ResultDesc RefusedJieYue(int ApplyId, String LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 int result = 0; System.Data.Common.DbParameter OutputParam = DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type, "@Result", DbParameterType.Int, result, ParameterDirection.Output); try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion List<string> sqlList = new List<string>(); StringBuilder strbld = new StringBuilder(); strbld.AppendFormat("update Trade_JieYue set "); strbld.AppendFormat("State=2, SHTime='{0}' ", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); strbld.AppendFormat(" where ApplyId={0}", ApplyId); sqlList.Add(strbld.ToString()); string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac); sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}解约处理-拒绝:ApplyId={0}", ApplyId, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "操作失败"; return rsdc; } rsdc.Result = true; rsdc.Desc = "操作成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "操作失败!"; } return rsdc; }
/// <summary> /// 解约处理-审核 /// </summary> /// <param name="ApplyId"></param> /// <param name="userid"></param> /// <param name="LoginId"></param> /// <returns></returns> public ResultDesc ProcessJieYue(int ApplyId, string userid, String LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion List<string> sqlList = new List<string>(); StringBuilder strbld = new StringBuilder(); strbld.AppendFormat("update Trade_JieYue set "); strbld.AppendFormat("State=1, SHTime='{0}' ", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); strbld.AppendFormat(" where ApplyId={0}", ApplyId); sqlList.Add(strbld.ToString()); //通过审核 需要把Trade_fundinfo表的state状态改为0 并且清空持卡人,银行卡号,开户行 sqlList.Add(string.Format("update trade_fundinfo set state='0',AccountName='',BankCard='',OpenBank='' where userid='{0}'", userid)); //sqlList.Add(string.Format("update trade_fundinfo set state='0' where userid='{0}'", userid));//不清空持卡人,银行卡号,开户行 string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac); sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}解约处理-审核:ApplyId={0}", ApplyId, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "审核失败"; return rsdc; } rsdc.Result = true; rsdc.Desc = "审核成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "审核失败!"; } return rsdc; }
/// <summary> /// 手工调账或库存结算 /// </summary> /// <param name="LoginId">登陆标识</param> /// <param name="TradeAccount">用户交易账号</param> /// <param name="money">调整资金</param> /// <param name="ReasonType">原因(3-库存结算,6-手工调账)</param> /// <returns>调整结果</returns> public ResultDesc ModifyUserMoney(string LoginId, string TradeAccount, double money, int ReasonType) { //ReasonType字段说明:(该接口取3,6) //0----入金(组织或管理员操作); //1----出金(组织或管理员操作); //2----订单操作 //3----库存结算(组织或管理员操作); //4----银行入金 (用户操作); //5----银行出金 (用户操作) //6----手工调账(组织或管理员操作) //7----在线回购(用户操作); //8----其他费用; ResultDesc rsdc = new ResultDesc(); string userid = string.Empty; //用户ID string operUser = string.Empty; //操作人 TradeUser TdUser = new TradeUser(); try { #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion userid = ComFunction.GetUserId(TradeAccount); //获取现有资金信息 Fundinfo Fdinfo = ComFunction.GetFdinfo(string.Format("select * from Trade_FundInfo where userid='{0}' and state<>'4'", userid)); if (Fdinfo.Money + money < 0) { rsdc.Result = false; rsdc.Desc = string.Format("{0}失败!因为用户{1}现有余额为{2},调整金额为{3},调整后的金额小于0", 3 == ReasonType ? "库存结算" : "手工调账", TradeAccount, Fdinfo.Money, money); return rsdc; } #region 数据库事务处理 //SQL语句 List<string> sqlList = new List<string>(); //添加调整资金sql语句 sqlList.Add(string.Format("update Trade_FundInfo set money=money+{0} where userid='{1}' and state<>'4'", money, userid)); //添加资金变动记录sql语句 sqlList.Add(string.Format("insert into Fund_Change([userId],[reason],[Oldvalue],[NewValue],[OperUser],[OperTime],[RelaOrder],[ChangeValue],[CashUser]) values('{0}','{1}',{2},{3},'{4}','{5}','{6}',{7},'{8}')", userid, ReasonType, Fdinfo.Money, Fdinfo.Money + money, operUser, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), string.Empty, money, Fdinfo.CashUser)); string operrationDesc = string.Empty; if (3 == ReasonType) { operrationDesc = string.Format("对用户{0},库存结算{1}", TradeAccount, money); } else if (6 == ReasonType) { operrationDesc = string.Format("对用户{0},手工调帐{1}", TradeAccount, money); } string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac); //添加操作记录 sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, ipmac + operrationDesc)); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "调整资金出错"; return rsdc; } rsdc.Result = true; rsdc.Desc = "调整资金成功"; #endregion } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "调整资金失败"; } return rsdc; }
/// <summary> /// 客户资金资料修改 /// </summary> /// <param name="Fdinfo">资金信息</param> /// <param name="tradeAccount">用户帐号</param> /// <param name="LoginId">登陆标识</param> /// <returns>修改结果</returns> public ResultDesc ModifyUserFundinfo(Fundinfo Fdinfo, string tradeAccount, string LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 TradeUser RefTdUser = new TradeUser(); try { #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref RefTdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == RefTdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = RefTdUser.Account; #endregion //SQL语句 List<string> sqlList = new List<string>(); string userid = ComFunction.GetUserId(tradeAccount); string strdt = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"); //构造修改用户信息的sql语句 StringBuilder strbld = new StringBuilder(); strbld.AppendFormat("update Trade_FundInfo set "); //strbld.AppendFormat("ConBankType='{0}', ", string.IsNullOrEmpty(Fdinfo.ConBankType) ? string.Empty : Fdinfo.ConBankType); //strbld.AppendFormat("OpenBank='{0}', ", string.IsNullOrEmpty(Fdinfo.OpenBank) ? string.Empty : Fdinfo.OpenBank); //strbld.AppendFormat("BankAccount='{0}', ", string.IsNullOrEmpty(Fdinfo.BankAccount) ? string.Empty : Fdinfo.BankAccount); //strbld.AppendFormat("BankCard='{0}', ", string.IsNullOrEmpty(Fdinfo.BankCard) ? string.Empty : Fdinfo.BankCard); //strbld.AppendFormat("AccountName='{0}', ", string.IsNullOrEmpty(Fdinfo.AccountName) ? string.Empty : Fdinfo.AccountName); //strbld.AppendFormat("OpenBankAddress='{0}' ", string.IsNullOrEmpty(Fdinfo.OpenBankAddress) ? string.Empty : Fdinfo.OpenBankAddress); strbld.AppendFormat("DongJieMoney={0} ", Fdinfo.DongJieMoney); strbld.AppendFormat(" where userid='{0}' and [state]<>'4'", userid); sqlList.Add(strbld.ToString()); //添加操作记录 string ipmac = ComFunction.GetIpMac(RefTdUser.Ip, RefTdUser.Mac); sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)RefTdUser.UType, string.Format("{2}修改{0}的冻结资金为{1}", tradeAccount, Fdinfo.DongJieMoney, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "修改用户资金资料出错"; return rsdc; } rsdc.Result = true; rsdc.Desc = "修改用户资金资料成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "修改用户资金资料失败"; } return rsdc; }
/// <summary> /// 修改交易日 /// </summary> /// <param name="DtSet">交易日信息</param> /// <param name="LoginId">管理员登陆标识</param> /// <returns>修改结果</returns> public ResultDesc ModifyDateSetEx(DateSet DtSet, string LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion List<string> sqlList = new List<string>(); StringBuilder strbld = new StringBuilder(); strbld.AppendFormat("update Trade_DateSetEx set "); strbld.AppendFormat("Istrade={0},", DtSet.Istrade ? 0 : 1); strbld.AppendFormat("Starttime='{0}',", DtSet.Starttime); strbld.AppendFormat("Endtime='{0}',", DtSet.Endtime); strbld.AppendFormat("[Desc]='{0}'", DtSet.Desc); strbld.AppendFormat(" where pricecode='{0}' and Weekday='{1}'", DtSet.PriceCode, DtSet.Weekday); sqlList.Add(strbld.ToString()); //添加操作记录 string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac); sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{4}修改交易日{0}-{1},{2}-{3}", DtSet.PriceCode, DtSet.Weekday, DtSet.Starttime, DtSet.Endtime, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "修改交易日出错"; return rsdc; } if ("1" == ComFunction.InterType) { ComFunction.ModifyDateSetEx(DtSet); } rsdc.Result = true; rsdc.Desc = "修该交易日成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "修改交易日失败"; } return rsdc; }
/// <summary> /// 手动报价 /// </summary> /// <param name="LoginId">登陆标识</param> /// <param name="PriceCode">行情编码</param> /// <param name="RealPrice">实时价</param> /// <returns>结果描述</returns> public ResultDesc ManualPrice(String LoginId, string PriceCode, double RealPrice) { ResultDesc rsdc = new ResultDesc(); try { TcpClient client = new TcpClient(); client.Connect(new IPEndPoint(IPAddress.Parse(ComFunction.recvip), Convert.ToInt32(ComFunction.recvport))); NetworkStream NetStream = client.GetStream(); double water = 0; double rate = 1; double coefxs = 1; double coefficient = 1; if (!ComFunction.GetWaterAndRate(PriceCode, ref water, ref rate, ref coefxs, ref coefficient)) { rsdc.Result = false; rsdc.Desc = "手工报价遇到错误"; return rsdc; } RealPrice = ((RealPrice - water) / (coefficient * rate)) * coefxs; //数据格式:Manual + Tab键 + 行情编码 +Tab键 + 时间(yyyyMMddHHmmss) + Tab键 +开盘价 + Tab键 +最高价 + Tab键 + 最低价 +Tab键 + 收盘价 +Tab键 +成交量 //Manual是手动报价标识 string data = string.Format("Manual\t{0}\t{1}\t{2}\t{2}\t{2}\t{2}\t1", PriceCode, DateTime.Now.ToString("yyyyMMddHHmmss"), RealPrice); byte[] temp = Encoding.ASCII.GetBytes(string.Format("[datalen={0}]{1}", data.Length, data)); NetStream.Write(temp, 0, temp.Length); NetStream.Flush(); client.Close(); NetStream.Close(); rsdc.Result = true; rsdc.Desc = "手工报价成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "手工报价失败"; } return rsdc; }
/// <summary> /// 添加商品信息 /// </summary> /// <param name="TdProduct">商品信息信息</param> /// <param name="LoginId">管理员登陆标识</param> /// <returns>添加结果</returns> public ResultDesc AddTradeProduct(TradeProduct TdProduct, String LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion List<string> sqlList = new List<string>(); TradeDataSource tdsource = ComFunction.GetTradeDataSource(TdProduct.Pricecode); //Goodscode用Pricecode赋值 sqlList.Add(string.Format("insert into Trade_Product([ProductName],[productcode],[goodscode],[pricecode],[adjustbase],[adjustcount],[pricedot],[valuedot],[setBase],[holdbase],[expressionfee],[sellfee],[maxprice],[minprice],[maxtime],[Ordemoneyfee],[Ordemoney],[buystoragefee],[sellstoragefee],[state],[unit],[lowerprice],[starttime],[endtime]) values('{0}','{1}','{2}','{3}',{4},{5},{6},{7},{8},{9},'{10}','{11}',{12},{13},{14},'{15}',{16},'{17}','{18}','{19}',{20},{21},'{22}','{23}')", TdProduct.ProductName, TdProduct.Productcode, TdProduct.Pricecode, TdProduct.Pricecode, TdProduct.Adjustbase, tdsource.adjustcount, TdProduct.Pricedot, TdProduct.Valuedot, TdProduct.SetBase, TdProduct.Holdbase, TdProduct.Expressionfee, TdProduct.Sellfee, TdProduct.Maxprice, TdProduct.Minprice, TdProduct.Maxtime, TdProduct.Ordemoneyfee, TdProduct.Ordemoney, TdProduct.Buystoragefee, TdProduct.Sellstoragefee, TdProduct.State, TdProduct.Unit, TdProduct.Lowerprice, TdProduct.Starttime, TdProduct.Endtime)); string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac); //添加操作记录 sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}添加商品信息:{0}", TdProduct.ProductName, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "添加商品信息出错"; return rsdc; } rsdc.Result = true; rsdc.Desc = "添加商品信息成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "添加商品信息失败"; } return rsdc; }
/// <summary> /// 新闻公告添加 /// </summary> /// <param name="TdNews">新闻</param> /// <param name="LoginId">登陆标识</param> /// <returns>添加结果</returns> public ResultDesc AddTradeNews(TradeNews TdNews, String LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion if (string.IsNullOrEmpty(TdNews.ID)) { rsdc.Result = false; rsdc.Desc = "ID不能为空"; return rsdc; } if (string.IsNullOrEmpty(TdNews.NewsTitle)) { rsdc.Result = false; rsdc.Desc = "标题不能为空"; return rsdc; } List<string> sqlList = new List<string>(); sqlList.Add(string.Format("insert into Trade_News([ID],[NewsTitle],[NewsContent],[PubPerson],[PubTime],[Status],[NewsType],[OverView]) values('{0}','{1}','{2}','{3}','{4}',{5},{6},'{7}')", TdNews.ID, TdNews.NewsTitle, TdNews.NewsContent, TdNews.PubPerson, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), (int)TdNews.Status, (int)TdNews.NType, string.IsNullOrEmpty(TdNews.OverView) ? string.Empty : TdNews.OverView)); string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac); sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}添加新闻公告:{0}", TdNews.NewsTitle, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "添加操作失败,请重试!"; return rsdc; } rsdc.Result = true; rsdc.Desc = "添加操作成功!"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "添加操作失败,请重试!"; } return rsdc; }
/// <summary> /// 添加过滤Mac /// </summary> /// <param name="TdMac">过滤Mac信息</param> /// <param name="LoginId">管理员登陆标识</param>\ /// <param name="ID">返回ID</param> /// <returns>添加结果</returns> public ResultDesc AddTradeMac(TradeMac TdMac, String LoginId, ref string ID) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion List<string> sqlList = new List<string>(); ID = System.Guid.NewGuid().ToString().Replace("-", ""); sqlList.Add(string.Format("insert into Trade_Mac([mac],[desc],[ID]) values('{0}','{1}','{2}')", TdMac.MAC, TdMac.Desc, ID)); string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac); //添加操作记录 sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}添加过滤Mac:{0}", TdMac.ID, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "添加过滤Mac出错"; return rsdc; } rsdc.Result = true; rsdc.Desc = "添加过滤Mac成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "添加过滤Mac失败"; } return rsdc; }
/// <summary> /// 编辑体验券 /// </summary> /// <param name="loginId">登录标识</param> /// <param name="exp">体验券</param> /// <returns>ResultDesc</returns> public ResultDesc EditExperience(string loginId, Experience exp) { ResultDesc rsdc = new ResultDesc(); var tdUser = new TradeUser(); try { #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(loginId, ref tdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } #endregion var sqlList = new List<string>(); exp.StartDate = exp.StartDate != null && exp.StartDate == DateTime.MinValue ? DateTime.MinValue : exp.StartDate; exp.EndDate = exp.EndDate != null && exp.EndDate == DateTime.MinValue ? DateTime.MinValue : exp.EndDate; exp.EffectiveTime = exp.EffectiveTime != null && exp.EffectiveTime == DateTime.MinValue ? DateTime.MinValue : exp.EffectiveTime; sqlList.Add(string.Format("UPDATE [TRADE_EXPERIENCE] SET [EX_NAME] ='{0}',[EX_TYPE] ={1},[EX_ANMOUNT] = {2} ,[EX_RECHARGE] ={3} ,[EX_NUM] = {4} ," + "[EX_STARTDATE] = '{5}',[EX_ENDDATE] = '{6}' ,[EX_CREATID] ='{7}' ,[EX_EFFECTIVE] ={8} ,[EX_EFFECTIVETIME] ='{9}' WHERE ID ={10}", exp.Name, exp.Type, exp.Annount, exp.Rceharge, exp.Num, exp.StartDate, exp.EndDate, exp.CreatID, exp.Effective, exp.EffectiveTime, exp.Id)); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "编辑体验券出错!"; return rsdc; } rsdc.Result = true; rsdc.Desc = "编辑体验券成功!"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = ""; } return rsdc; }
/// <summary> /// 编辑广告 /// </summary> /// <param name="loginId">登录标识</param> /// <param name="exp">广告</param> /// <returns>ResultDesc</returns> public ResultDesc EditAdvert(string loginId, Advert exp) { ResultDesc rsdc = new ResultDesc(); var tdUser = new TradeUser(); try { #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(loginId, ref tdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } #endregion var sqlList = new List<string>(); sqlList.Add(string.Format("UPDATE [TradeDB].[dbo].[Trade_Advert] SET [Url] = '{0}',[Status] = {1},[Remark] ='{2}',[Name]='{3}' WHERE ID='{4}'", exp.Url, Convert.ToByte(exp.Status), exp.Remark, exp.Name, exp.ID)); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "编辑广告出错!"; return rsdc; } rsdc.Result = true; rsdc.Desc = "编辑广告成功!"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = ""; } return rsdc; }
/// <summary> /// 修改客户资料 /// </summary> /// <param name="TdUser">用户信息</param> /// <param name="Fdinfo">资金信息</param> /// <param name="LoginId">登陆标识</param> /// <returns>修改结果</returns> public ResultDesc ModifyTradeUserEx(TradeUser TdUser, Fundinfo Fdinfo, string LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 TradeUser RefTdUser = new TradeUser(); try { #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref RefTdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == RefTdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = RefTdUser.Account; #endregion if (string.IsNullOrEmpty(TdUser.Account)) { rsdc.Result = false; rsdc.Desc = "用户账号不能为空"; return rsdc; } if (string.IsNullOrEmpty(TdUser.LoginPwd)) { rsdc.Result = false; rsdc.Desc = "用户密码不能为空"; return rsdc; } //if (string.IsNullOrEmpty(TdUser.CardNum)) //{ // rsdc.Result = false; // rsdc.Desc = "证件号码不能为空"; // return rsdc; //} string OrgId = string.Empty; if (!string.IsNullOrEmpty(TdUser.OrgName)) { //判断组织ID是否存在 if (!ComFunction.ExistOrgName(TdUser.OrgName, ref OrgId)) { rsdc.Result = false; rsdc.Desc = "你所指定的组织名称不存在"; return rsdc; } } //判断用户输入的证件号码在其他有效用户中是否已经被使用 //if (ComFunction.CardNumIsExist(TdUser.Account, TdUser.CardNum)) //{ // rsdc.Result = false; // rsdc.Desc = "证件号码已经被使用"; // return rsdc; //} UserType Utype = ComFunction.GetUserType(TdUser.Account); //if (UserType.OrgType == Utype && !string.IsNullOrEmpty(OrgId) && !string.IsNullOrEmpty(TdUser.BindAccount)) //{ // if (!ComFunction.ExistNormalAccount(TdUser.BindAccount, OrgId)) // { // rsdc.Result = false; // rsdc.Desc = "你所指定的绑定帐号不存在"; // return rsdc; // } //} //if (UserType.NormalType == Utype && string.IsNullOrEmpty(TdUser.CashPwd)) //{ // rsdc.Result = false; // rsdc.Desc = "资金密码不能为空"; // return rsdc; //} //SQL语句 List<string> sqlList = new List<string>(); string userid = ComFunction.GetUserId(TdUser.Account); string strdt = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"); //构造修改用户信息的sql语句 StringBuilder strbld = new StringBuilder(); string ipmac = ComFunction.GetIpMac(RefTdUser.Ip, RefTdUser.Mac); //TdUser.OrderUnit = 1;//手数单位默认为1 strbld.AppendFormat("update Base_User set "); strbld.AppendFormat("UserName='******',", string.IsNullOrEmpty(TdUser.UserName) ? string.Empty : TdUser.UserName); strbld.AppendFormat("CardNum='{0}',", string.IsNullOrEmpty(TdUser.CardNum) ? string.Empty : TdUser.CardNum); strbld.AppendFormat("OrgId='{0}',", string.IsNullOrEmpty(OrgId) ? string.Empty : OrgId); strbld.AppendFormat("PhoneNum='{0}',", string.IsNullOrEmpty(TdUser.PhoneNum) ? string.Empty : TdUser.PhoneNum); strbld.AppendFormat("TelNum='{0}',", string.IsNullOrEmpty(TdUser.TelNum) ? string.Empty : TdUser.TelNum); strbld.AppendFormat("Email='{0}',", string.IsNullOrEmpty(TdUser.Email) ? string.Empty : TdUser.Email); strbld.AppendFormat("LinkMan='{0}',", string.IsNullOrEmpty(TdUser.LinkMan) ? string.Empty : TdUser.LinkMan); strbld.AppendFormat("LinkAdress='{0}',", string.IsNullOrEmpty(TdUser.LinkAdress) ? string.Empty : TdUser.LinkAdress); strbld.AppendFormat("Sex='{0}',", string.IsNullOrEmpty(TdUser.Sex) ? "1" : TdUser.Sex); strbld.AppendFormat("[Status]='{0}',", string.IsNullOrEmpty(TdUser.Status) ? "0" : TdUser.Status); strbld.AppendFormat("LoginPwd='{0}',", Des3.Des3EncodeCBC(string.IsNullOrEmpty(TdUser.LoginPwd) ? "123456" : TdUser.LoginPwd)); if (Utype == UserType.OrgType) { strbld.AppendFormat("CardType='{0}',", string.IsNullOrEmpty(TdUser.CardType) ? "1" : TdUser.CardType); strbld.AppendFormat("BindAccount='{0}',", string.IsNullOrEmpty(TdUser.BindAccount) ? string.Empty : TdUser.BindAccount); } else if (Utype == UserType.NormalType) { strbld.AppendFormat("CardType='{0}',", string.IsNullOrEmpty(TdUser.CardType) ? "1" : TdUser.CardType); strbld.AppendFormat("AccountType='{0}',", string.IsNullOrEmpty(TdUser.AccountType) ? "0" : TdUser.AccountType); strbld.AppendFormat("OpenMan='{0}',", string.IsNullOrEmpty(TdUser.OpenMan) ? string.Empty : TdUser.OpenMan); strbld.AppendFormat("OrderPhone='{0}',", string.IsNullOrEmpty(TdUser.OrderPhone) ? string.Empty : TdUser.OrderPhone); strbld.AppendFormat("CashPwd='{0}',", Des3.Des3EncodeCBC(string.IsNullOrEmpty(TdUser.CashPwd) ? "123456" : TdUser.CashPwd)); strbld.AppendFormat("MinTrade={0},", TdUser.MinTrade); strbld.AppendFormat("OrderUnit={0},", TdUser.OrderUnit); strbld.AppendFormat("MaxTrade={0},", TdUser.MaxTrade); strbld.AppendFormat("CorporationName='{0}',", string.IsNullOrEmpty(TdUser.CorporationName) ? string.Empty : TdUser.CorporationName); strbld.AppendFormat("PermitRcash={0},", TdUser.PermitRcash ? 1 : 0); strbld.AppendFormat("PermitCcash={0},", TdUser.PermitCcash ? 1 : 0); strbld.AppendFormat("PermitDhuo={0},", TdUser.PermitDhuo ? 1 : 0); strbld.AppendFormat("PermitHshou={0},", TdUser.PermitHshou ? 1 : 0); strbld.AppendFormat("PermitRstore={0},", TdUser.PermitRstore ? 1 : 0); strbld.AppendFormat("PermitDelOrder={0},", TdUser.PermitDelOrder ? 1 : 0); } strbld.AppendFormat("LastUpdateTime='{0}',", strdt); //修改时间 strbld.AppendFormat("LastUpdateID='{0}'", operUser); //修改人 strbld.AppendFormat(" where Account='{0}' and userid='{1}'", TdUser.Account, userid); sqlList.Add(strbld.ToString()); //修改资金信息 sqlList.Add(string.Format("update Trade_FundInfo set AccountName='{0}',BankCard='{1}',OpenBank='{2}',ConBankType='{4}' where userid='{3}'", TdUser.UserName, Fdinfo.BankCard, Fdinfo.OpenBank, userid, Fdinfo.ConBankType)); //com.individual.helper.LogNet4.WriteMsg(strbld.ToString()); //添加操作记录 sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)RefTdUser.UType, string.Format("{1}修改用户{0}", TdUser.Account, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "修改用户资料出错"; return rsdc; } rsdc.Result = true; rsdc.Desc = "修改用户资料成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "修改用户资料失败"; } return rsdc; }
/// <summary> /// 修改节假日 /// </summary> /// <param name="Hliday">节假日信息</param> /// <param name="LoginId">管理员登陆标识</param> /// <returns>修改结果</returns> public ResultDesc ModifyHoliday(DateHoliday Hliday, string LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion List<string> sqlList = new List<string>(); StringBuilder strbld = new StringBuilder(); strbld.AppendFormat("update Trade_HolidayEx set "); strbld.AppendFormat("Starttime='{0}',", Hliday.Starttime); strbld.AppendFormat("Endtime='{0}',", Hliday.Endtime); strbld.AppendFormat("[Desc]='{0}',", Hliday.Desc); strbld.AppendFormat("HoliName='{0}',", Hliday.HoliName); strbld.AppendFormat("pricecode='{0}' ", Hliday.PriceCode); strbld.AppendFormat(" where ID='{0}'", Hliday.ID); sqlList.Add(strbld.ToString()); string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac); sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{3}修改节假日:{0},{1}-{2}", Hliday.ID, Hliday.Starttime, Hliday.Endtime, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "修改节假日出错"; return rsdc; } if ("1" == ComFunction.InterType) { ComFunction.ModifyHoliday(Hliday); } rsdc.Result = true; //rsdc.Desc = "修该节假日成功"; rsdc.Desc = strbld.ToString(); } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "修改节假日失败"; } return rsdc; }
/// <summary> /// 2.3.4.4 修改客户组 /// </summary> /// <param name="ugs"></param> /// <param name="LoginId"></param> /// <returns></returns> public ResultDesc ModifyUserGroups(UserGroups ugs, String LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion if (string.IsNullOrEmpty(ugs.UserGroupName)) { rsdc.Result = false; rsdc.Desc = "客户组名称不能为空"; return rsdc; } List<string> sqlList = new List<string>(); StringBuilder strbld = new StringBuilder(); strbld.Append("update Trade_UserGroups set "); strbld.AppendFormat(" UserGroupName='{0}',", string.IsNullOrEmpty(ugs.UserGroupName) ? string.Empty : ugs.UserGroupName); strbld.AppendFormat(" IsDefaultGroup={0},", ugs.IsDefaultGroup); strbld.AppendFormat(" AfterSecond={0},", ugs.AfterSecond); strbld.AppendFormat(" PlaceOrderSlipPoint={0},", ugs.PlaceOrderSlipPoint); strbld.AppendFormat(" FlatOrderSlipPoint={0},", ugs.FlatOrderSlipPoint); strbld.AppendFormat(" DelayPlaceOrder={0},", ugs.DelayPlaceOrder); strbld.AppendFormat(" DelayFlatOrder={0} ", ugs.DelayFlatOrder); strbld.AppendFormat(" where UserGroupId='{0}'", ugs.UserGroupId); sqlList.Add(strbld.ToString()); if (1 == ugs.IsDefaultGroup)//如果修改的组被设置为默认组时,需要把其他组全部修改为非默认组 { sqlList.Add(string.Format("update Trade_UserGroups set IsDefaultGroup=0 where UserGroupId<>'{0}'", ugs.UserGroupId)); } if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "修改客户组出错"; return rsdc; } rsdc.Result = true; rsdc.Desc = "修改客户组成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "修改客户组失败"; } return rsdc; }
/// <summary> /// 修改过滤Mac /// </summary> /// <param name="TdMac">过滤Mac信息</param> /// <param name="LoginId">管理员登陆标识</param> /// <returns>修改结果</returns> public ResultDesc ModifyTradeMac(TradeMac TdMac, String LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion List<string> sqlList = new List<string>(); StringBuilder strbld = new StringBuilder(); strbld.AppendFormat("update Trade_Mac set "); strbld.AppendFormat("Mac='{0}',", TdMac.MAC); strbld.AppendFormat("[desc]='{0}'", TdMac.Desc); strbld.AppendFormat(" where ID='{0}'", TdMac.ID); sqlList.Add(strbld.ToString()); //添加操作记录 string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac); sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}修改过滤Mac:{0}", TdMac.ID, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "修改过滤Mac出错"; return rsdc; } rsdc.Result = true; rsdc.Desc = "修该过滤Mac成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "修改过滤Mac失败"; } return rsdc; }
/// <summary> /// 出金付款处理 /// </summary> /// <param name="ApplyId"></param> /// <param name="LoginId"></param> /// <param name="state">处理状态,"1"-已付款,"2"已拒绝 "3"处理中 "4"处理失败</param> /// <returns></returns> public ResultDesc ProcessChuJin(int ApplyId, String LoginId,ref string state) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion List<string> sqlList = new List<string>(); StringBuilder strbld = new StringBuilder(); #region 暂时作废 //string ret_cod = string.Empty; //string ret_msg = string.Empty; //string ret_cod2 = string.Empty;//中间状态2000 2001 2003 2005 2007 2008 //string ret_msg2 = string.Empty; //int itmp = 0;//临时变量 //#region 调银行接口 //ComFunction.ProcessChuJin(ApplyId, ref ret_cod, ref ret_msg, ref ret_cod2, ref ret_msg2); //#endregion //strbld.AppendFormat("update Trade_ChuJin set "); //if ("0000" == ret_cod && "0000" == ret_cod2) //{ // strbld.AppendFormat(" State=1, FkTime='{0}' ", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); // strbld.AppendFormat(" where ApplyId={0}", ApplyId); // sqlList.Add(strbld.ToString()); //} //else if ("2000" == ret_cod2 || "2001" == ret_cod2 || "2003" == ret_cod2 || "2005" == ret_cod2 || "2007" == ret_cod2 || "2008" == ret_cod2) //{ // strbld.AppendFormat(" FkTime='{0}',", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); // strbld.AppendFormat(" State=3 where ApplyId={0}", ApplyId);//状态改为正在处理 // sqlList.Add(strbld.ToString()); // itmp = 1; //} ////失败代码0001 0002 1000 1001 1002 1999 2002 2004 2006 //else if ("0001" == ret_cod2 || "0002" == ret_cod2 || "1000" == ret_cod2 || "1001" == ret_cod2 || "1002" == ret_cod2 // || "1999" == ret_cod2 || "2002" == ret_cod2 || "2004" == ret_cod2 || "2006" == ret_cod2) //{ // strbld.AppendFormat(" State=4, FkTime='{0}' ", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); // strbld.AppendFormat(" where ApplyId={0}", ApplyId); // sqlList.Add(strbld.ToString()); // itmp = 2; //} //else //{ // rsdc.Result = false; // rsdc.Desc = "付款失败!"; // return rsdc; //} #endregion #region 改为微信支付后,付款功能直接修改状态为处理中 strbld.AppendFormat("update Trade_ChuJin set "); //strbld.AppendFormat(" FkTime='{0}',", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); if (ConfigurationManager.AppSettings["VersionFlag"] == "HFB") { strbld.AppendFormat(" State=1 where ApplyId={0}", ApplyId); //状态改为已付款(黑琥珀) state = "1"; } else { strbld.AppendFormat(" State=3 where ApplyId={0}", ApplyId);//状态改为正在处理 state = "3"; } sqlList.Add(strbld.ToString()); #endregion string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac); sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}出金处理:ApplyId={0}", ApplyId, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { com.individual.helper.LogNet4.WriteMsg("付款已处理,但数据库sql执行失败了!"); state = "4"; } rsdc.Result = true; rsdc.Desc = "处理中"; //if (1 == itmp) //{ // rsdc.Desc = "3";//表示正在处理 //} //else if (2 == itmp) //{ // rsdc.Desc = "4";//表示交易处理失败 //} } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "付款失败!"; state = "4"; } return rsdc; }
/// <summary> /// 添加交易设置 /// </summary> /// <param name="TdSet">交易设置信息</param> /// <param name="LoginId">登陆标识</param> /// <returns>添加结果</returns> public ResultDesc AddTradeSet(TradeSet TdSet, String LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion List<string> sqlList = new List<string>(); sqlList.Add(string.Format("insert into Trade_Set([ObjName],[ObjCode],[ObjValue],[Remark]) values('{0}','{1}','{2}','{3}')", TdSet.ObjName, TdSet.ObjCode, TdSet.ObjValue, TdSet.Remark)); string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac); sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}添加交易设置:{0}", TdSet.ObjCode, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "添加交易设置出错"; return rsdc; } rsdc.Result = true; rsdc.Desc = "添加交易设置成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "添加交易设置失败"; } return rsdc; }
/// <summary> /// 拒绝出金 /// </summary> /// <param name="ApplyId"></param> /// <param name="LoginId"></param> /// <returns></returns> public ResultDesc RefusedChuJin(int ApplyId, String LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 int result = 0; System.Data.Common.DbParameter OutputParam = DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type, "@Result", DbParameterType.Int, result, ParameterDirection.Output); try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion DbHelper.RunProcedureExecuteSql("Proc_RefusedChuJin", new System.Data.Common.DbParameter[]{ DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type, "@ApplyID", DbParameterType.Int, ApplyId, ParameterDirection.Input), DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type, "@OperUser", DbParameterType.String, operUser, ParameterDirection.Input), OutputParam}); result = Convert.ToInt32(OutputParam.Value); if (0 == result) { rsdc.Result = false; rsdc.Desc = "操作失败"; return rsdc; } rsdc.Result = true; rsdc.Desc = "操作成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "操作失败!"; } return rsdc; }
/// <summary> /// 新闻公告修改 /// </summary> /// <param name="TdNews">新闻</param> /// <param name="LoginId">登陆标识</param> /// <returns>修改结果</returns> public ResultDesc ModifyTradeNews(TradeNews TdNews, String LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion List<string> sqlList = new List<string>(); StringBuilder strbld = new StringBuilder(); strbld.AppendFormat("update Trade_News set "); strbld.AppendFormat("NewsContent='{0}',", TdNews.NewsContent); strbld.AppendFormat("NewsType={0},", (int)TdNews.NType); strbld.AppendFormat("Status={0},", (int)TdNews.Status); // strbld.AppendFormat("PubTime='{0}',", TdNews.PubTime.ToString("yyyy-MM-dd")); strbld.AppendFormat("PubPerson='{0}',", TdNews.PubPerson); strbld.AppendFormat("OverView='{0}',", string.IsNullOrEmpty(TdNews.OverView) ? string.Empty : TdNews.OverView); strbld.AppendFormat("NewsTitle='{0}' ", TdNews.NewsTitle); strbld.AppendFormat(" where ID='{0}'", TdNews.ID); sqlList.Add(strbld.ToString()); string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac); //添加操作记录 sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}修改新闻公告,{0}", TdNews.ID, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "保存出错,请重试!"; return rsdc; } rsdc.Result = true; rsdc.Desc = "保存成功!"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "保存出错,请重试!"; } return rsdc; }
/// <summary> /// 新增交易用户 /// </summary> /// <param name="TdUser">用户信息</param> /// <param name="Fdinfo">资金信息</param> /// <param name="UType">用户类型</param> /// <param name="LoginId">登陆标识</param> /// <returns>结果描述</returns> public ResultDesc AddTradeUserEx(TradeUser TdUser, Fundinfo Fdinfo, UserType UType, string LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 TradeUser RefTdUser = new TradeUser(); try { #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref RefTdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } #endregion if (UserType.NormalType == RefTdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = RefTdUser.Account; if (string.IsNullOrEmpty(TdUser.Account)) { rsdc.Result = false; rsdc.Desc = "用户账号不能为空"; return rsdc; } if (string.IsNullOrEmpty(TdUser.LoginPwd)) { rsdc.Result = false; rsdc.Desc = "用户密码不能为空"; return rsdc; } if (UserType.NormalType == UType && string.IsNullOrEmpty(TdUser.CashPwd)) { rsdc.Result = false; rsdc.Desc = "资金密码不能为空"; return rsdc; } if (string.IsNullOrEmpty(TdUser.CardNum)) { rsdc.Result = false; rsdc.Desc = "证件号码不能为空"; return rsdc; } if (string.IsNullOrEmpty(TdUser.UserID)) { rsdc.Result = false; rsdc.Desc = "用户ID不能为空"; return rsdc; } string OrgId = string.Empty; if (!string.IsNullOrEmpty(TdUser.OrgName)) { //判断组织ID是否存在 if (!ComFunction.ExistOrgName(TdUser.OrgName, ref OrgId)) { rsdc.Result = false; rsdc.Desc = "你所指定的组织名称不存在"; return rsdc; } } bool tradeAccountExist = false; //判断用户账号 或 证件号码是否已经被使用 if (ComFunction.CardNumIsExist(TdUser.Account, TdUser.CardNum, ref tradeAccountExist)) { rsdc.Result = false; rsdc.Desc = "证件号码已经被使用"; return rsdc; } if (tradeAccountExist) { rsdc.Result = false; rsdc.Desc = string.Format("账号{0}已经存在", TdUser.Account); return rsdc; } if (UserType.OrgType == UType && !string.IsNullOrEmpty(OrgId) && !string.IsNullOrEmpty(TdUser.BindAccount)) { if (!ComFunction.ExistNormalAccount(TdUser.BindAccount, OrgId)) { rsdc.Result = false; rsdc.Desc = "你所指定的绑定帐号不存在"; return rsdc; } } int ute = (int)UType; //SQL语句 List<string> sqlList = new List<string>(); StringBuilder strbld = new StringBuilder(); //string userid = System.Guid.NewGuid().ToString().Replace("-", ""); string strdt = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"); string ipmac = ComFunction.GetIpMac(RefTdUser.Ip, RefTdUser.Mac); //TdUser.OrderUnit = 1;//手数单位默认为1 if (UserType.NormalType == UType) { //构造新增基本用户信息的sql语句 strbld.AppendFormat(@"insert into Base_User([userId],[userName],[status],[Accounttype],[CorporationName], [Account],[LoginPwd],[cashPwd],[CardType],[CardNum],[OrgId],[PhoneNum],[TelNum],[Email],[LinkMan],[LinkAdress], [OrderPhone],[sex],[OpenMan],[OpenTime],[LastUpdateTime],[LastUpdateID],[LoginID],[Ip],[Mac],[Online],[MinTrade], [OrderUnit],[MaxTrade],[PermitRcash],[PermitCcash],[PermitDhuo],[PermitHshou],[PermitRstore],[PermitDelOrder], [UserType]) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',", TdUser.UserID, string.IsNullOrEmpty(TdUser.UserName) ? string.Empty : TdUser.UserName, TdUser.Status, TdUser.AccountType, string.IsNullOrEmpty(TdUser.CorporationName) ? string.Empty : TdUser.CorporationName, TdUser.Account, Des3.Des3EncodeCBC(TdUser.LoginPwd), Des3.Des3EncodeCBC(TdUser.CashPwd)); strbld.AppendFormat("'{0}','{1}','{2}','{3}','{4}','{5}','{6}',", TdUser.CardType, TdUser.CardNum, string.IsNullOrEmpty(OrgId) ? string.Empty : OrgId, TdUser.PhoneNum, TdUser.TelNum, TdUser.Email, TdUser.LinkMan); strbld.AppendFormat("'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',", TdUser.LinkAdress, TdUser.OrderPhone, TdUser.Sex, TdUser.OpenMan, strdt, strdt, operUser, string.Empty); strbld.AppendFormat("'{0}','{1}',{2},{3},{4},{5},", string.Empty, string.Empty, 0, TdUser.MinTrade, TdUser.OrderUnit, TdUser.MaxTrade); strbld.AppendFormat("{0},{1},{2},{3},{4},{5},{6})", TdUser.PermitRcash ? 1 : 0, TdUser.PermitCcash ? 1 : 0, TdUser.PermitDhuo ? 1 : 0, TdUser.PermitHshou ? 1 : 0, TdUser.PermitRstore ? 1 : 0, TdUser.PermitDelOrder ? 1 : 0, ute); sqlList.Add(strbld.ToString()); //构造新增用户资金信息的sql语句 sqlList.Add(string.Format("insert into Trade_FundInfo([userId],[state],[money],[OccMoney],[frozenMoney],[BankAccount],[AccountName],[BankCard],[CashUser],[SubUser],[ConBankType],[OpenBank],[OpenBankAddress],[SameBank]) values('{0}','{1}',{2},{3},{4},'{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}',{13})", TdUser.UserID, 0, 0, 0, 0, string.Empty, TdUser.UserName, Fdinfo.BankCard, System.Guid.NewGuid().ToString().Replace("-", ""), string.Empty, Fdinfo.ConBankType, Fdinfo.OpenBank, string.Empty, 0)); //添加默认分组 string UserGroupId = ComFunction.GetUserGroupId(); if (!string.IsNullOrEmpty(UserGroupId)) { sqlList.Add(string.Format("insert into Trade_User_Group(UserId, UserGroupId) values('{0}','{1}') ", TdUser.UserID, UserGroupId)); } //添加操作记录 sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)RefTdUser.UType, string.Format("{1}新增账号{0}", TdUser.Account, ipmac))); } else if (UserType.AdminType == UType) { //构造新增管理员信息的sql语句 strbld.AppendFormat(@"insert into Base_User([userId],[userName],[status],[Accounttype],[Account],[LoginPwd], [CardType],[CardNum],[PhoneNum],[TelNum],[Email],[LinkAdress],[sex],[OpenTime], [LastUpdateTime],[LastUpdateID],[Online],[UserType]) values('{0}','{1}','{2}','{3}','{4}','{5}',", TdUser.UserID, string.IsNullOrEmpty(TdUser.UserName) ? string.Empty : TdUser.UserName, TdUser.Status, 0, TdUser.Account, Des3.Des3EncodeCBC(TdUser.LoginPwd)); strbld.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", 1, TdUser.CardNum, TdUser.PhoneNum, TdUser.TelNum, TdUser.Email); strbld.AppendFormat("'{0}','{1}','{2}','{3}','{4}',{5},{6})", TdUser.LinkAdress, TdUser.Sex, strdt, strdt, operUser, 0, ute); sqlList.Add(strbld.ToString()); //添加操作记录 sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)RefTdUser.UType, string.Format("{1}新增管理员{0}", TdUser.Account, ipmac))); } else if (UType == UserType.OrgType) { //构造新增组织用户信息的sql语句 strbld.AppendFormat(@"insert into Base_User([userId],[userName],[status],[Accounttype],[Account],[LoginPwd], [CardType],[CardNum],[OrgId],[PhoneNum],[TelNum],[Email],[LinkAdress],[sex],[OpenTime], [LastUpdateTime],[LastUpdateID],[Online],[UserType],[BindAccount]) values('{0}','{1}','{2}','{3}','{4}','{5}',", TdUser.UserID, string.IsNullOrEmpty(TdUser.UserName) ? string.Empty : TdUser.UserName, TdUser.Status, 1, TdUser.Account, Des3.Des3EncodeCBC(TdUser.LoginPwd)); strbld.AppendFormat("'{0}','{1}','{2}','{3}','{4}','{5}',", TdUser.CardType, TdUser.CardNum, string.IsNullOrEmpty(OrgId) ? string.Empty : OrgId, TdUser.PhoneNum, TdUser.TelNum, TdUser.Email); strbld.AppendFormat("'{0}','{1}','{2}','{3}','{4}',{5},{6},'{7}')", TdUser.LinkAdress, TdUser.Sex, strdt, strdt, operUser, 0, ute, string.IsNullOrEmpty(TdUser.BindAccount) ? string.Empty : TdUser.BindAccount); sqlList.Add(strbld.ToString()); //添加操作记录 sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)RefTdUser.UType, string.Format("{1}新增组织用户{0}", TdUser.Account, ipmac))); } if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "新增用户出错"; return rsdc; } rsdc.Result = true; rsdc.Desc = "新增用户成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "新增用户失败"; } return rsdc; }
/// <summary> /// 修改商品信息 /// </summary> /// <param name="TdProduct">商品信息信息</param> /// <param name="LoginId">管理员登陆标识</param> /// <returns>修改结果</returns> public ResultDesc ModifyTradeProduct(TradeProduct TdProduct, String LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion List<string> sqlList = new List<string>(); StringBuilder strbld = new StringBuilder(); strbld.AppendFormat("update Trade_Product set "); strbld.AppendFormat("ProductName='{0}',", TdProduct.ProductName); strbld.AppendFormat("Adjustbase={0},", TdProduct.Adjustbase); //strbld.AppendFormat("Adjustcount={0},", TdProduct.Adjustcount); strbld.AppendFormat("Expressionfee='{0}',", TdProduct.Expressionfee); strbld.AppendFormat("Holdbase={0},", TdProduct.Holdbase); strbld.AppendFormat("Lowerprice={0},", TdProduct.Lowerprice); strbld.AppendFormat("Maxprice={0},", TdProduct.Maxprice); strbld.AppendFormat("Maxtime={0},", TdProduct.Maxtime); strbld.AppendFormat("Minprice={0},", TdProduct.Minprice); //strbld.AppendFormat("Ordemoney={0},", TdProduct.Ordemoney); strbld.AppendFormat("Ordemoneyfee='{0}',", TdProduct.Ordemoneyfee); strbld.AppendFormat("Pricedot={0},", TdProduct.Pricedot); //strbld.AppendFormat("Sellfee='{0}',", TdProduct.Sellfee); strbld.AppendFormat("Sellstoragefee='{0}',", TdProduct.Sellstoragefee); strbld.AppendFormat("SetBase={0},", TdProduct.SetBase); strbld.AppendFormat("State='{0}',", TdProduct.State); strbld.AppendFormat("Unit={0},", TdProduct.Unit); strbld.AppendFormat("Valuedot={0},", TdProduct.Valuedot); strbld.AppendFormat("Buystoragefee='{0}',", TdProduct.Buystoragefee); strbld.AppendFormat("Pricecode='{0}',", TdProduct.Pricecode); //strbld.AppendFormat("Goodscode='{0}',", TdProduct.Goodscode); strbld.AppendFormat("starttime='{0}',", TdProduct.Starttime); strbld.AppendFormat("endtime='{0}'", TdProduct.Endtime); strbld.AppendFormat(" where Productcode='{0}'", TdProduct.Productcode); sqlList.Add(strbld.ToString()); string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac); //添加操作记录 sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}修改商品信息:{0}", TdProduct.ProductName, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "修改商品信息出错"; return rsdc; } rsdc.Result = true; rsdc.Desc = "修该商品信息成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "修改商品信息失败"; } return rsdc; }
/// <summary> /// 添加体验券 /// </summary> /// <param name="loginId">登录标识</param> /// <param name="exp">体验券</param> /// <returns>ResultDesc</returns> public ResultDesc AddExperience(string loginId, Experience exp) { ResultDesc rsdc = new ResultDesc(); var tdUser = new TradeUser(); try { #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(loginId, ref tdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } #endregion var sqlList = new List<string>(); sqlList.Add(string.Format("INSERT INTO [TRADE_EXPERIENCE]([EX_NAME] ,[EX_TYPE] ,[EX_ANMOUNT] ,[EX_RECHARGE] ,[EX_NUM] ,[EX_STARTDATE] ,[EX_ENDDATE] ," + "[EX_CREATID] ,[EX_EFFECTIVE],[EX_EFFECTIVETIME]) VALUES ('{0}',{1},{2},{3},{4},'{5}','{6}','{7}',{8},'{9}')", exp.Name, exp.Type, exp.Annount, exp.Rceharge, exp.Num, exp.StartDate, exp.EndDate, exp.CreatID, exp.Effective, exp.EffectiveTime )); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "添加体验券出错!"; return rsdc; } rsdc.Result = true; rsdc.Desc = "添加体验券成功!"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = ""; } return rsdc; }
/// <summary> /// 修改汇率和水 /// </summary> /// <param name="TdRate">汇率和水信息</param> /// <param name="LoginId">管理员登陆标识</param> /// <returns>修改结果</returns> public ResultDesc ModifyTradeRate(TradeRate TdRate, String LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion List<string> sqlList = new List<string>(); int result = ComFunction.ModifyWaterAndRate(TdRate); //添加操作记录 if (1 == result) { string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac); sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}修改汇率和水:{0}", TdRate.PriceCode, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "修改汇率和水出错1"; return rsdc; } rsdc.Result = true; rsdc.Desc = "修该汇率和水成功"; } else { rsdc.Result = false; rsdc.Desc = "修改汇率和水出错2"; return rsdc; } } catch (Exception ex) { rsdc.Result = false; rsdc.Desc = "修改汇率和水失败"; } return rsdc; }
private void Save() { TradeNews news = new TradeNews(); news.NewsTitle = txtTitle.Text; news.OverView = txtOverView.Text; news.NewsContent = NewsContent.InnerText; if (string.IsNullOrEmpty(news.NewsContent)) { MessageBox("请填写内容!"); return; } if (string.IsNullOrEmpty(news.NewsTitle)) { MessageBox("请填写标题!"); return; } if (string.IsNullOrEmpty(news.OverView)) { MessageBox("请填写摘要!"); return; } if (news.NewsContent.Length > 4000) { MessageBox("内容不能超过4000字符!"); return; } if (news.NewsTitle.Length > 200) { MessageBox("标题不能超过200字符!"); return; } if (news.OverView.Length > 2000) { MessageBox("摘要不能超过2000字符!"); return; } int type = 0; if (!string.IsNullOrEmpty(ddlType.SelectedItem.Value)) { type = int.Parse(ddlType.SelectedItem.Value); } else { MessageBox("请选择新闻类型!"); return; } news.NType = (NewsType)type; news.PubPerson = Account; int status=1; status=rbEnable.Checked ? 1 : 0; news.Status = (NewsStatus)status; ResultDesc result = new ResultDesc(); if (string.IsNullOrEmpty(ID)) { news.ID = Guid.NewGuid().ToString("n"); result= GetManager.AddTradeNews(news, LoginId); } else { news.ID = ID; result = GetManager.ModifyTradeNews(news, LoginId); } MessageBox(result.Desc); }
/// <summary> /// 修改交易设置 /// </summary> /// <param name="TdSet">交易设置</param> /// <param name="LoginId">管理员登陆标识</param> /// <returns>修改结果</returns> public ResultDesc ModifyTradeSet(TradeSet TdSet, string LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion #region 验证数据 if (!ComFunction.ValidateTradeSet(TdSet)) { rsdc.Result = false; rsdc.Desc = "值不正确"; return rsdc; } #endregion List<string> sqlList = new List<string>(); StringBuilder strbld = new StringBuilder(); strbld.AppendFormat("update Trade_Set set "); strbld.AppendFormat("ObjName='{0}',", TdSet.ObjName); strbld.AppendFormat("ObjValue='{0}',", TdSet.ObjValue); strbld.AppendFormat("Remark='{0}' ", TdSet.Remark); strbld.AppendFormat("where ObjCode='{0}'", TdSet.ObjCode); sqlList.Add(strbld.ToString()); string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac); //添加操作记录 sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}修改交易设置,{0}", TdSet.ObjCode, ipmac))); if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "修改交易设置出错"; return rsdc; } rsdc.Result = true; rsdc.Desc = "修该交易设置成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "修改交易设置失败"; } return rsdc; }