private T_OperationLog ToModel(DataRow row) { T_OperationLog model = new T_OperationLog(); model.Id = (System.Guid)SqlHelper.FromDbValue(row["Id"]); model.OperatorId = (System.Guid)SqlHelper.FromDbValue(row["OperatorId"]); model.MakeDate = (System.DateTime)SqlHelper.FromDbValue(row["MakeDate"]); model.ActionDesc = (string)SqlHelper.FromDbValue(row["ActionDesc"]); return(model); }
public T_OperationLog[] Search(string sql, SqlParameter[] parameters) { DataTable table = SqlHelper.ExecuteDataTable(sql, parameters); T_OperationLog[] logs = new T_OperationLog[table.Rows.Count]; for (int i = 0; i < table.Rows.Count; i++) { logs[i] = ToModel(table.Rows[i]); } return(logs); }
/// <summary> /// 修改指定会员密码 /// </summary> /// <param name="model"></param> /// <param name="head"></param> /// <param name="error"></param> /// <returns></returns> public bool UpdateClntPwd(ClientSearc model, HeadMessage head, out ErrorMessage error) { error = new ErrorMessage(); error.ErrNo = "0004"; try { if (model == null || string.IsNullOrEmpty(model.C_ID) || string.IsNullOrEmpty(model.C_Pwd) || string.IsNullOrEmpty(head.LoginID)) { error.ErrMsg = "参数不完整,不能修改会员密码"; return(false); } if (CommonDAL.IsH5Clnt(model.C_ID)) { string h5Mger = Db.Context_SqlServer.FromSql("select [value] from T_Cfg where Name ='H5_ManageID'").ToScalar <string>(); if (!string.Equals(h5Mger.Trim(), head.LoginID.Trim(), StringComparison.OrdinalIgnoreCase)) { error.ErrMsg = "当前登录代理不能修改H5会员的密码!"; return(false); } } string strSql = SqlTemplateCommon.GetSql("A_SaveClientModifyPassword"); if (string.IsNullOrEmpty(strSql)) { error.ErrMsg = "服务端没有读取到A_SaveClientModifyPassword数据模板,请联系管理员"; return(false); } strSql = strSql.Replace("${ClientID}", model.C_ID); strSql = strSql.Replace("${Pwd}", model.C_Pwd); Db.Context_SqlServer.FromSql(strSql).ToDataSet(); T_OperationLog opLog = new T_OperationLog(); opLog.LogID = Guid.NewGuid().ToString().Replace("-", ""); opLog.LogInfo = DateTime.Now.ToString() + "代理" + head.Account + "修改了下级代理" + model.C_UserID + "的登录密码"; opLog.LogTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now); opLog.OpID = head.LoginID; opLog.LogType = "修改代理登录密码"; if (Db.Context_SqlServer.Insert <T_OperationLog>(opLog) <= 0) { Common.LogHelper.WriteErrLog(typeof(AgentListDAL), "插入" + head.Account + "修改会员密码日志失败"); } error.ErrMsg = "会员密码修改成功"; error.ErrNo = "0000"; return(true); } catch (Exception ex) { Common.LogHelper.WriteLog(typeof(ClientListDAL), ex); error.ErrMsg = ex.Message.Replace("\r", "").Replace("\n", ""); return(false); } }
/// <summary> /// 删除子账号 /// </summary> /// <param name="model"></param> /// <param name="head"></param> /// <param name="error"></param> /// <returns></returns> public bool DeleteASub(AgentSub model, HeadMessage head, out ErrorMessage error) { error = new ErrorMessage(); error.ErrNo = "0004"; try { if (string.IsNullOrEmpty(model.AS_ID)) { error.ErrMsg = "参数不完整"; return(false); } Where <T_AgentSub> whereSql = new Where <T_AgentSub>(); whereSql.And(o => o.AgentSubID == model.AS_ID); bool res = AgentSubDAL.Delete(whereSql) > 0; if (res) { error.ErrMsg = "删除子账号成功"; error.ErrNo = "0000"; } else { error.ErrMsg = "删除子账号失败"; } T_OperationLog opLog = new T_OperationLog(); opLog.LogID = Guid.NewGuid().ToString().Replace("-", ""); opLog.LogTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now); opLog.LogType = "删除子账号"; opLog.OpID = head.LoginID; opLog.LogInfo = error.ErrMsg; if (Db.Context_SqlServer.Insert <T_OperationLog>(opLog) <= 0) { Common.LogHelper.WriteErrLog(typeof(AgentListDAL), "插入" + head.Account + "删除子账号日志失败"); } return(res); } catch (Exception ex) { Common.LogHelper.WriteLog(typeof(AgentSubDAL), ex); error.ErrMsg = ex.Message.Replace("\r", "").Replace("\n", ""); return(false); } }
/// <summary> /// 修改会员 /// </summary> /// <param name="model"></param> /// <param name="head"></param> /// <param name="error"></param> /// <returns></returns> public bool UpdateClnt(ClientSearc model, HeadMessage head, out ErrorMessage error) { error = new ErrorMessage(); error.ErrNo = "0004"; try { if (string.IsNullOrEmpty(model.C_ID)) { error.ErrMsg = "必须传递需要修改会员的ID"; return(false); } string strSql = SqlTemplateCommon.GetSql("A_UpdateT_Client"); if (string.IsNullOrEmpty(strSql)) { error.ErrMsg = "服务端没有读取到A_UpdateT_Client数据模板,请联系管理员"; return(false); } strSql = strSql.Replace("${ClientID}", model.C_ID); strSql = strSql.Replace("${LogName}", model.C_UserID); StringBuilder clntBuilder = new StringBuilder(); StringBuilder authBuilder = new StringBuilder(); StringBuilder clntExBuilder = new StringBuilder(); T_OperationLog opLog = new T_OperationLog(); StringBuilder logDesc = new StringBuilder(); logDesc.Append(DateTime.Now.ToString() + head.Account + "修改了会员" + model.C_UserID + " 以下信息:"); string pSql = "select a.AgentID A_ID,a.WashRate A_WashR,a.DrawRate A_DrawR,a.IntoRate A_IntoR,[dbo].[Base64Decode](a.F_3) A_Perm,a.Max_Z A_MX_Z,a.Min_Z A_MN_Z from T_Agent a ,T_CLient b where b.ClientID ='" + model.C_ID + "' and a.AgentID = b.AgentID"; AgentSearchModel pAgent = Db.Context_SqlServer.FromSql(pSql).ToFirst <AgentSearchModel>(); if (model.C_WashR != null && model.C_WashR > pAgent.A_WashR) { error.ErrMsg = "洗码率超出父级代理范围"; return(false); } if (pAgent.A_DrawR == 0 && model.C_DrawR != 0) { error.ErrMsg = "父级代理的和局率为0,所以此会员的和局率只能为0"; return(false); } if (pAgent.A_DrawR > 0 && model.C_DrawR <= 0) { error.ErrMsg = "父级代理的和局率不为0,所以此会员的和局率不能为0"; return(false); } if (model.C_DrawR != null && model.C_DrawR > pAgent.A_DrawR) { error.ErrMsg = "和局率超出父级代理范围"; return(false); } if (model.C_MX_Z != null && model.C_MX_Z > pAgent.A_MX_Z) { error.ErrMsg = "最大限红超出父级代理范围"; return(false); } if (model.C_MN_Z != null && model.C_MN_Z < pAgent.A_MN_Z) { error.ErrMsg = "最小限红超出父级范围"; return(false); } #region 组装修改会员Sql clntBuilder.Append("UPDATE T_Client set "); clntBuilder.Append(" ClientID ='" + model.C_ID + "'"); if (!string.IsNullOrEmpty(model.C_UserID)) { clntBuilder.Append(",LogName='" + model.C_UserID + "'"); } if (!string.IsNullOrEmpty(model.C_Name)) { clntBuilder.Append(",ClientName='" + model.C_Name + "'"); } if (model.C_MN_Z != null) { clntBuilder.Append(",Min_Z =" + model.C_MN_Z); clntBuilder.Append(",Min_X =" + model.C_MN_Z); clntBuilder.Append(",Min_XD =" + model.C_MN_Z); clntBuilder.Append(",Min_ZD =" + model.C_MN_Z); clntBuilder.Append(",Min_H =" + model.C_MN_Z); logDesc.Append("把最小限红改为了" + model.C_MN_Z + ";"); } if (model.C_MX_Z != null) { clntBuilder.Append(",Max_Z =" + model.C_MX_Z); clntBuilder.Append(",Max_X =" + model.C_MX_Z); clntBuilder.Append(",Max_XD =" + model.C_MX_Z / 10); clntBuilder.Append(",Max_ZD =" + model.C_MX_Z / 10); clntBuilder.Append(",Max_H =" + model.C_MX_Z / 10); logDesc.Append("把最大限红改为了" + model.C_MX_Z + ";"); } if (!string.IsNullOrEmpty(model.C_F2)) { clntBuilder.Append(",F_2 ='" + model.C_F2 + "'"); } if (model.C_WashT != null) { clntBuilder.Append(",WashType ='" + ((model.C_WashT) == true ? "s" : "d") + "'"); logDesc.Append("把洗码类型修改为了" + ((model.C_WashT == true) ? "双边" : "单边") + ";"); } if (model.C_WashR != null) { clntBuilder.Append(",WashRate =" + model.C_WashR); logDesc.Append("把洗码率修改为" + model.C_WashR + ";"); } if (model.C_DrawR != null) { clntBuilder.Append(",DrawRate =" + model.C_DrawR); logDesc.Append("把和局率修改为" + model.C_DrawR + ";"); } if (!string.IsNullOrEmpty(model.C_State)) { clntBuilder.Append(",State ='" + model.C_State + "'"); logDesc.Append("把状态修改为" + model.C_State + ";"); } clntBuilder.Append(" WHERE ClientID = '" + model.C_ID + "'"); strSql = strSql.Replace("${updateClient}", clntBuilder.ToString()); #endregion #region 组装修改会员限红sql authBuilder.Append("Update T_Authority set Priority='C'"); if (model.C_MX_Z != null && model.C_MX_Z >= 0) { authBuilder.Append(",Max_Z=" + model.C_MX_Z); authBuilder.Append(",Max_X=" + model.C_MX_Z); authBuilder.Append(",Max_H=" + model.C_MX_Z / 10); authBuilder.Append(",Max_XD=" + model.C_MX_Z / 10); authBuilder.Append(",Max_ZD=" + model.C_MX_Z / 10); } if (model.C_MN_Z != null && model.C_MN_Z >= 0) { authBuilder.Append(",Min_Z=" + model.C_MN_Z); authBuilder.Append(",Min_X=" + model.C_MN_Z); authBuilder.Append(",Min_H=" + model.C_MN_Z); authBuilder.Append(",Min_ZD=" + model.C_MN_Z); authBuilder.Append(",Min_XD=" + model.C_MN_Z); } authBuilder.Append(" WHERE [Priority] = 'C' and ClientID = '" + model.C_ID + "' "); strSql = strSql.Replace("${upAuthority}", authBuilder.ToString()); #endregion #region 组装修改会员赔率及显示隐藏洗码 clntExBuilder.Append("update T_ClientEx set "); clntExBuilder.Append(" ClientID ='" + model.C_ID + "'"); if (model.C_HdShow != null) { clntExBuilder.Append(",ClientDataShow=" + ((model.C_HdShow == true) ? 2 : 1)); } if (pAgent != null && !string.IsNullOrEmpty(pAgent.A_Perm) && pAgent.A_Perm.IndexOf("\"SetPV\":true") != -1) //需要所属代理有抽水权限才能修改赔率 { if (model.C_ODF != null) { clntExBuilder.Append(",Odds_Fu_Client=" + model.C_ODF); } if (model.C_ODH != null) { clntExBuilder.Append(",Odds_H_Client=" + model.C_ODH); } if (model.C_ODHe != null) { clntExBuilder.Append(",Odds_He_Client=" + model.C_ODHe); } if (model.C_ODL != null) { clntExBuilder.Append(",Odds_Long_Client=" + model.C_ODL); } if (model.C_ODX != null) { clntExBuilder.Append(",Odds_X_Client=" + model.C_ODX); } if (model.C_ODXD != null) { clntExBuilder.Append(",Odds_XD_Client=" + model.C_ODXD); } if (model.C_ODZ != null) { clntExBuilder.Append(",Odds_Z_Client=" + model.C_ODZ); } if (model.C_ODZD != null) { clntExBuilder.Append(",Odds_ZD_Client=" + model.C_ODZD); } } clntExBuilder.Append(" where ClientID ='" + model.C_ID + "'"); strSql = strSql.Replace("${upClientEx}", clntExBuilder.ToString()); #endregion strSql = strSql.Replace("##'", ""); strSql = strSql.Replace("##\"", ""); strSql = strSql.Replace("'##", ""); strSql = strSql.Replace("\"##", ""); Db.Context_SqlServer.FromSql(strSql).ToDataSet(); opLog.LogID = Guid.NewGuid().ToString().Replace("-", ""); opLog.LogTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now); opLog.LogType = "修改会员"; opLog.OpID = head.LoginID; opLog.LogInfo = logDesc.ToString(); if (Db.Context_SqlServer.Insert <T_OperationLog>(opLog) <= 0) { Common.LogHelper.WriteErrLog(typeof(AgentListDAL), "插入" + head.Account + "修改会员日志失败"); } error.ErrMsg = "修改会员成功"; error.ErrNo = "0000"; return(true); } catch (Exception ex) { Common.LogHelper.WriteLog(typeof(ClientListDAL), ex); error.ErrMsg = ex.Message.Replace("\r", "").Replace("\n", ""); return(false); } }
/// <summary> /// 新增会员 /// </summary> /// <param name="model"></param> /// <param name="head"></param> /// <param name="error"></param> /// <returns></returns> public bool InsertClient(ClientSearc model, HeadMessage head, out ErrorMessage error) { error = new ErrorMessage(); error.ErrNo = "0004"; DbTrans tran = null; DbBatch batch = null; try { #region 操作前验证 if (string.IsNullOrEmpty(model.C_UserID)) { error.ErrMsg = "新增会员时登录名称不能为空"; return(false); } if (string.IsNullOrEmpty(model.C_Name)) { error.ErrMsg = "新增会员时会员名称不能为空"; return(false); } if (string.IsNullOrEmpty(model.C_Pwd)) { error.ErrMsg = "新增会员时密码不能为空"; return(false); } if (string.IsNullOrEmpty(model.C_AID)) { error.ErrMsg = "新增会员时必须指定所属代理"; return(false); } #endregion string tableSql = SqlTemplateCommon.GetSql("T_GetAllT_Tables"); string oddSql = SqlTemplateCommon.GetSql("ClntOdds"); if (string.IsNullOrEmpty(tableSql) || string.IsNullOrEmpty(oddSql)) { error.ErrMsg = "服务端没有读取到T_GetAllT_Tables/oddSql数据模板,请联系管理员"; return(false); } List <TableModel> tableList = Db.Context_SqlServer.FromSql(tableSql).ToList <TableModel>(); //获取系统中的所有桌台 ClientOdds standardOdd = Db.Context_SqlServer.FromSql(oddSql).ToFirst <ClientOdds>(); //获取会员标准赔率对象 List <T_Authority> authList = new List <T_Authority>(); //给新增会员配置所有桌台权限 T_Client dbClnt = new T_Client(); T_ClientEx dbClntEx = new T_ClientEx(); T_OperationLog opLog = new T_OperationLog(); T_Agent pAgent = AgentListDAL.First(a => a.AgentID == model.C_AID); if (pAgent == null) { error.ErrMsg = "指定的所属代理无效,新增会员失败"; return(false); } if (model.C_WashR != null && model.C_WashR > pAgent.WashRate) { model.C_WashR = pAgent.WashRate; //如果新增会员的洗码率大于父级代理的洗码率则赋值为父级代理的洗码率 } if (pAgent.DrawRate == 0) //如果父级代理的和局率为0,则它的直属会员的和局率只能为0 { model.C_DrawR = 0; } else { if (pAgent.DrawRate > 0 && model.C_DrawR <= 0) { model.C_DrawR = pAgent.DrawRate; } else { if (model.C_DrawR != null && model.C_DrawR > pAgent.DrawRate) { model.C_DrawR = pAgent.DrawRate; //如果新增会员的和局率大于父级代理的和局率则赋值为父级代理的和局率 } } } if (model.C_MX_Z != null && model.C_MX_Z > pAgent.Max_Z) { model.C_MX_Z = pAgent.Max_Z; //如果新增会员的最大限红大于父级代理的最大限红则赋值为父级代理的最大限红 } if (model.C_MN_Z != null && model.C_MN_Z < pAgent.Min_Z) { model.C_MN_Z = pAgent.Min_Z; //如果新增会员的最小限红小于父级代理的最小限红则赋值为父级代理的最小限红 } #region 构造桌台权限 if (tableList != null && tableList.Count > 0) { foreach (var item in tableList) { T_Authority authority = new T_Authority(); authority.ClientID = model.C_ID; authority.TableID = item.T_ID; authority.Priority = "C"; if (model.C_MN_Z != null) { authority.Min_Z = model.C_MN_Z; authority.Min_ZD = model.C_MN_Z / 10; authority.Min_XD = model.C_MN_Z / 10; authority.Min_X = model.C_MN_Z; authority.Min_H = model.C_MN_Z / 10; } if (model.C_MX_Z != null) { authority.Max_ZD = model.C_MX_Z / 10; authority.Max_Z = model.C_MX_Z; authority.Max_XD = model.C_MX_Z / 10; authority.Max_X = model.C_MX_Z; authority.Max_H = model.C_MX_Z / 10; } authList.Add(authority); } } #endregion #region 构造新增会员对象 dbClnt.ClientID = Guid.NewGuid().ToString().Replace("-", ""); dbClnt.CreateID = head.LoginID; dbClnt.Balance = 0; dbClnt.Principal = 0; dbClnt.State = "YES";//新增会员默认为启用状态 dbClnt.CreateTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now); dbClnt.AgentID = model.C_AID; dbClnt.ClientName = model.C_Name; dbClnt.LogName = model.C_UserID; dbClnt.F_2 = model.C_F2; dbClnt.IsHide = "FALSE"; dbClnt.Pwd = model.C_Pwd; if (model.C_WashT != null) { dbClnt.WashType = (model.C_WashT == true) ? "S" : "D"; } if (model.C_WashR != null) { dbClnt.WashRate = model.C_WashR; } if (model.C_DrawR != null) { dbClnt.DrawRate = model.C_DrawR; } if (model.C_MN_Z != null) { dbClnt.Min_H = model.C_MN_Z / 10; dbClnt.Min_X = model.C_MN_Z; dbClnt.Min_XD = model.C_MN_Z / 10; dbClnt.Min_Z = model.C_MN_Z; dbClnt.Min_ZD = model.C_MN_Z / 10; } if (model.C_MX_Z != null) { dbClnt.Max_H = model.C_MX_Z / 10; dbClnt.Max_X = model.C_MX_Z; dbClnt.Max_XD = model.C_MX_Z / 10; dbClnt.Max_Z = model.C_MX_Z; dbClnt.Max_ZD = model.C_MX_Z / 10; } #endregion #region 构造会员扩展对象 dbClntEx.ClientID = model.C_ID; dbClntEx.ClientDataShow = (model.C_HdShow == true) ? 2 : 1; if (model.C_ODF != null) { dbClntEx.Odds_Fu_Client = (model.C_ODF > 0) ? model.C_ODF : standardOdd.C_ODF; } if (model.C_ODH != null) { dbClntEx.Odds_H_Client = (model.C_ODH > 0) ? model.C_ODH : standardOdd.C_ODH; } if (model.C_ODHe != null) { dbClntEx.Odds_He_Client = (model.C_ODHe > 0) ? model.C_ODHe : standardOdd.C_ODHe; } if (model.C_ODL != null) { dbClntEx.Odds_Long_Client = (model.C_ODL > 0) ? model.C_ODL : standardOdd.C_ODL; } if (model.C_ODX != null) { dbClntEx.Odds_X_Client = (model.C_ODX > 0) ? model.C_ODX : standardOdd.C_ODX; } if (model.C_ODXD != null) { dbClntEx.Odds_XD_Client = (model.C_ODXD > 0) ? model.C_ODXD : standardOdd.C_ODXD; } if (model.C_ODZ != null) { dbClntEx.Odds_Z_Client = (model.C_ODZ > 0) ? model.C_ODZ : standardOdd.C_ODZ; } if (model.C_ODZD != null) { dbClntEx.Odds_ZD_Client = (model.C_ODZD > 0) ? model.C_ODZD : standardOdd.C_ODZD; } #endregion #region 构造操作日志对象 opLog.LogID = Guid.NewGuid().ToString().Replace("-", ""); opLog.LogInfo = DateTime.Now.ToString() + head.Account + "新增会员" + dbClnt.LogName; opLog.LogTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now); //DateTime.Now.ToString(); opLog.OpID = head.LoginID; opLog.LogType = "新增会员"; #endregion tran = Db.Context_SqlServer.BeginTransaction(); batch = Db.Context_SqlServer.BeginBatchConnection(30, tran); tran.Insert <T_Client>(dbClnt); tran.Insert <T_ClientEx>(dbClntEx); batch.Insert <T_Authority>(authList.ToArray()); tran.Insert <T_OperationLog>(opLog); batch.Execute(); tran.Commit(); error.ErrMsg = "新增会员成功"; error.ErrNo = "0000"; return(true); } catch (Exception ex) { tran.Rollback(); Common.LogHelper.WriteLog(typeof(ClientListDAL), ex); error.ErrMsg = ex.Message.Replace("\r", "").Replace("\n", ""); return(false); } finally { if (batch != null) { batch.Close(); batch.Dispose(); } if (tran != null) { tran.Close(); tran.Dispose(); } } }
/// <summary> /// 新增子账号 /// </summary> /// <param name="model"></param> /// <param name="head"></param> /// <param name="error"></param> /// <returns></returns> public bool InsertASub(AgentSub model, HeadMessage head, out ErrorMessage error) { error = new ErrorMessage(); error.ErrNo = "0004"; try { if (string.IsNullOrEmpty(model.AS_AID)) { error.ErrMsg = "新增子账号必须指定所属代理ID"; return(false); } if (string.IsNullOrEmpty(model.AS_UserID)) { error.ErrMsg = "新增子账号必须填写子账号登录名称"; return(false); } if (string.IsNullOrEmpty(model.AS_Name)) { error.ErrMsg = "新增子账号必须填写子账号名称"; return(false); } if (string.IsNullOrEmpty(model.AS_Pwd)) { error.ErrMsg = "新增子账号必须填写子账号密码"; return(false); } T_AgentSub dbASub = new T_AgentSub(); dbASub.AgentID = model.AS_AID; dbASub.AgentSubID = Guid.NewGuid().ToString().Replace("-", ""); dbASub.State = "YES"; //model.AS_State; dbASub.Pwd = model.AS_Pwd; dbASub.LogName = model.AS_UserID; dbASub.AgentSubName = model.AS_Name; bool res = Db.Context_SqlServer.Insert <T_AgentSub>(dbASub) > 0; if (res) { error.ErrMsg = "新增子账号成功"; error.ErrNo = "0000"; } else { error.ErrMsg = "新增子账号失败"; } T_OperationLog opLog = new T_OperationLog(); opLog.LogID = Guid.NewGuid().ToString().Replace("-", ""); opLog.LogTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now); opLog.LogType = "新增子账号"; opLog.OpID = head.LoginID; opLog.LogInfo = error.ErrMsg; if (Db.Context_SqlServer.Insert <T_OperationLog>(opLog) <= 0) { Common.LogHelper.WriteErrLog(typeof(AgentListDAL), "插入" + head.Account + "新增子账号日志失败"); } return(res); } catch (Exception ex) { Common.LogHelper.WriteLog(typeof(AgentSubDAL), ex); error.ErrMsg = ex.Message.Replace("\r", "").Replace("\n", ""); return(false); } }
/// <summary> /// 修改子账号 /// </summary> /// <param name="model"></param> /// <param name="head"></param> /// <param name="error"></param> /// <returns></returns> public bool UpdateASub(AgentSub model, HeadMessage head, out ErrorMessage error) { error = new ErrorMessage(); error.ErrNo = "0004"; try { if (string.IsNullOrEmpty(model.AS_ID) || string.IsNullOrEmpty(model.AS_AID)) { error.ErrMsg = "参数不完整"; return(false); } string strSql = Common.SqlTemplateCommon.GetSql("A_UpdateT_AgentSub"); if (string.IsNullOrEmpty(strSql)) { error.ErrMsg = "服务端没有读取到A_UpdateT_AgentSub数据模板,请联系管理员"; return(false); } strSql = strSql.Replace("${AgentSubID}", model.AS_ID); strSql = strSql.Replace("${LogName}", model.AS_UserID); StringBuilder aSubBuilder = new StringBuilder(); T_OperationLog opLog = new T_OperationLog(); StringBuilder descBuilder = new StringBuilder(); descBuilder.Append(head.Account + "修改了子账号" + model.AS_UserID + ":"); aSubBuilder.Append("UPDATE T_AgentSub SET AgentSubID = '" + model.AS_ID + "'"); if (!string.IsNullOrEmpty(model.AS_Name)) { aSubBuilder.Append(",AgentSubName='" + model.AS_Name + "'"); } if (!string.IsNullOrEmpty(model.AS_UserID)) { aSubBuilder.Append(",LogName='" + model.AS_UserID + "'"); } if (!string.IsNullOrEmpty(model.AS_Pwd)) { aSubBuilder.Append(",Pwd='" + model.AS_Pwd + "'"); descBuilder.Append("修改了子账号登录密码;"); } if (!string.IsNullOrEmpty(model.AS_State)) { aSubBuilder.Append(",State='" + model.AS_State + "'"); descBuilder.Append("把子账号状态改为了" + model.AS_State + ";"); } aSubBuilder.Append(" WHERE AgentSubID ='" + model.AS_ID + "'"); strSql = strSql.Replace("${UpAgentSub}", aSubBuilder.ToString()); strSql = strSql.Replace("##'", ""); strSql = strSql.Replace("##\"", ""); strSql = strSql.Replace("'##", ""); strSql = strSql.Replace("\"##", ""); Db.Context_SqlServer.FromSql(strSql).ToDataSet(); error.ErrMsg = "修改子账号成功"; error.ErrNo = "0000"; opLog.LogID = Guid.NewGuid().ToString().Replace("-", ""); opLog.LogTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now); opLog.LogType = "修改子账号"; opLog.OpID = head.LoginID; opLog.LogInfo = descBuilder.ToString(); if (Db.Context_SqlServer.Insert <T_OperationLog>(opLog) <= 0) { Common.LogHelper.WriteErrLog(typeof(AgentListDAL), "插入" + head.Account + "修改子账号日志失败"); } return(true); } catch (Exception ex) { Common.LogHelper.WriteLog(typeof(AgentSubDAL), ex); error.ErrMsg = ex.Message.Replace("\r", "").Replace("\n", ""); return(false); } }