private OperationReturn ModifyUserExtInfo(SessionInfo session, List <string> listParams) { OperationReturn optReturn = new OperationReturn(); optReturn.Result = true; optReturn.Code = 0; try { if (listParams.Count < 5) { optReturn.Result = false; optReturn.Code = Defines.RET_PARAM_INVALID; optReturn.Message = string.Format("Param count invalid"); return(optReturn); } string userID, strEmail, strPhone, strBirthday, strHeadIcon; //0 UserID //1 Email //2 Phone //3 Birthday //4 HeadIcon userID = listParams[0]; strEmail = listParams[1]; strPhone = listParams[2]; strBirthday = listParams[3]; strHeadIcon = listParams[4]; string rentToken = session.RentInfo.Token; string strSql; int count; switch (session.DBType) { //MSSQL case 2: strSql = string.Format("SELECT COUNT(1) FROM T_11_101_{0} WHERE C001 = {1} AND C002 = 1" , rentToken , userID); optReturn = MssqlOperation.GetRecordCount(session.DBConnectionString, strSql); if (!optReturn.Result) { return(optReturn); } count = Convert.ToInt32(optReturn.Data); //表中不存在,新增 if (count <= 0) { strSql = string.Format( "INSERT INTO T_11_101_{0} (C001,C002,C011,C012,C013,C014) VALUES ({1},1,'{2}','{3}','{4}','{5}')" , rentToken , userID , strEmail , strPhone , strBirthday , strHeadIcon); optReturn = MssqlOperation.ExecuteSql(session.DBConnectionString, strSql); return(optReturn); } strSql = string.Format( "UPDATE T_11_101_{0} SET C011 = '{1}', C012 = '{2}', C013 = '{3}', C014 = '{4}' WHERE C001 = {5} AND C002 =1" , rentToken , strEmail , strPhone , strBirthday , strHeadIcon , userID); optReturn = MssqlOperation.ExecuteSql(session.DBConnectionString, strSql); return(optReturn); //ORCL case 3: strSql = string.Format("SELECT COUNT(1) FROM T_11_101_{0} WHERE C001 = {1} AND C002 = 1" , rentToken , userID); optReturn = OracleOperation.GetRecordCount(session.DBConnectionString, strSql); if (!optReturn.Result) { return(optReturn); } count = Convert.ToInt32(optReturn.Data); //表中不存在,新增 if (count <= 0) { strSql = string.Format( "INSERT INTO T_11_101_{0} (C001,C002,C011,C012,C013,C014) VALUES ({1},1,'{2}','{3}','{4}','{5}')" , rentToken , userID , strEmail , strPhone , strBirthday , strHeadIcon); optReturn = OracleOperation.ExecuteSql(session.DBConnectionString, strSql); return(optReturn); } strSql = string.Format( "UPDATE T_11_101_{0} SET C011 = '{1}', C012 = '{2}', C013 = '{3}', C014 = '{4}' WHERE C001 = {5} AND C002 =1" , rentToken , strEmail , strPhone , strBirthday , strHeadIcon , userID); optReturn = OracleOperation.ExecuteSql(session.DBConnectionString, strSql); return(optReturn); } } catch (Exception ex) { optReturn.Result = false; optReturn.Code = Defines.RET_FAIL; optReturn.Message = ex.Message; } return(optReturn); }
private OperationReturn ModifyUserInfo(SessionInfo session, List <string> listParams) { OperationReturn optReturn = new OperationReturn(); optReturn.Result = true; optReturn.Code = 0; try { if (listParams.Count < 8) { optReturn.Result = false; optReturn.Code = Defines.RET_PARAM_INVALID; optReturn.Message = string.Format("Param count invalid"); return(optReturn); } string strID, account, fullName, strLock, strReset, IsActive, validTime, invalidTime, IsOrgManagement; //0 UserID //1 Account //2 FullName //3 Lock ( C 解除锁定, U 界面锁定,D 老杨禁用) //4 ResetPassword //5 IsAcitve //6 ValidTime //7 InValidTime //8 IsOrgManagement ////9 Org strID = listParams[0]; account = listParams[1]; fullName = listParams[2]; strLock = listParams[3]; strReset = listParams[4]; IsActive = listParams[5]; validTime = listParams[6]; invalidTime = listParams[7]; //IsOrgManagement = listParams[8]; //Org = listParams[9]; account = EncryptToDB(account); fullName = EncryptToDB(fullName); validTime = EncryptToDB(validTime); invalidTime = EncryptToDB(invalidTime); string rentToken = session.RentInfo.Token; string strSql; int count; string strLockSql; switch (session.DBType) { //MSSQL case 2: strSql = string.Format("SELECT COUNT(1) FROM T_11_005_{0} WHERE C001 <> {1} AND C002 = '{2}'" , rentToken , strID , account); optReturn = MssqlOperation.GetRecordCount(session.DBConnectionString, strSql); if (!optReturn.Result) { return(optReturn); } count = Convert.ToInt32(optReturn.Data); //账户名已经存在 if (count > 0) { optReturn.Result = false; optReturn.Code = Defines.RET_DBACCESS_EXIST; optReturn.Message = string.Format("User account already exist."); return(optReturn); } strLockSql = string.Empty; //if (strLock == "C") //{ // strLockSql = string.Format(", C008 = '0', C009 = 'N'"); //} //else if (strLock == "U") //{ // strLockSql = string.Format(", C008 = '1', C009 = 'U'"); //} if (strLock == "CL") { strLockSql = string.Format(", C008 = '0', C009 = 'N' ,C024 = 0 "); } else if (strLock == "CU") { strLockSql = string.Format(", C008 = '0', C009 = 'N'"); } else if (strLock == "CD") { strLockSql = string.Format(", C008 = '0', C009 = 'N', C013 = '{0}'", EncryptToDB(DateTime.Now.ToString())); } else if (strLock == "U") { strLockSql = string.Format(", C008 = '1', C009 = 'U'"); } strSql = string.Format( "UPDATE T_11_005_{0} SET C002 = '{1}', C003 = '{2}'{3} ,C010='{5}' ,C017='{6}',C018='{7}',C027='{8}' WHERE C001 = {4}", rentToken, account, fullName, strLockSql, strID, IsActive, validTime, invalidTime, "0"); optReturn = MssqlOperation.ExecuteSql(session.DBConnectionString, strSql); if (!optReturn.Result) { return(optReturn); } if (strReset == "1") { //重置密码 listParams = new List <string>(); listParams.Add(strID); listParams.Add("0"); listParams.Add(string.Empty); optReturn = ModifyUserPassword(session, listParams); } break; //ORCL case 3: strSql = string.Format("SELECT COUNT(1) FROM T_11_005_{0} WHERE C001 <> {1} AND C002 = '{2}' " , rentToken , strID , account); optReturn = OracleOperation.GetRecordCount(session.DBConnectionString, strSql); if (!optReturn.Result) { return(optReturn); } count = Convert.ToInt32(optReturn.Data); //账户名已经存在 if (count > 0) { optReturn.Result = false; optReturn.Code = Defines.RET_DBACCESS_EXIST; optReturn.Message = string.Format("User account already exist."); return(optReturn); } strLockSql = string.Empty; //if (strLock == "C") //{ // strLockSql = string.Format(", C008 = '0', C009 = 'N'"); //} //else if (strLock == "U") //{ // strLockSql = string.Format(", C008 = '1', C009 = 'U'"); //} if (strLock == "CL") { strLockSql = string.Format(", C008 = '0', C009 = 'N' ,C024 = 0 "); } else if (strLock == "CU") { strLockSql = string.Format(", C008 = '0', C009 = 'N'"); } else if (strLock == "U") { strLockSql = string.Format(", C008 = '1', C009 = 'U'"); } strSql = string.Format( "UPDATE T_11_005_{0} SET C002 = '{1}', C003 = '{2}'{3} ,C010='{5}' ,C017='{6}',C018='{7}',C027='{8}' WHERE C001 = {4}", rentToken, account, fullName, strLockSql, strID, IsActive, validTime, invalidTime, "0"); optReturn = OracleOperation.ExecuteSql(session.DBConnectionString, strSql); if (!optReturn.Result) { return(optReturn); } if (strReset == "1") { //重置密码 listParams = new List <string>(); listParams.Add(strID); listParams.Add("0"); listParams.Add(string.Empty); optReturn = ModifyUserPassword(session, listParams); } break; } } catch (Exception ex) { optReturn.Result = false; optReturn.Code = Defines.RET_FAIL; optReturn.Message = ex.Message; } return(optReturn); }