/// <summary>
///
/// </summary>
/// <param name="session"></param>
/// <param name="lstParams"></param>
/// lstParams[0] : bookmarkLevelID
/// lstParams[1] : Level color
/// <returns></returns>
private OperationReturn ModifyBookmarkLevel(SessionInfo session, List <string> lstParams)
{
OperationReturn optReturn = new OperationReturn();
optReturn.Result = true;
optReturn.Code = Defines.RET_SUCCESS;
if (lstParams == null || lstParams.Count < 2)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("Request param is null or count invalid");
return(optReturn);
}
try
{
string strToken = session.RentInfo.Token;
string strLevelID = lstParams[0];
string strColor = lstParams[1];
string strSql = string.Empty;
switch (session.DBType)
{
case 2:
strSql = "update T_11_009_{0} set C006 = '{1}' where C001 = {2} and C000 = 3";
strSql = string.Format(strSql, strToken, strColor, strLevelID);
optReturn = MssqlOperation.ExecuteSql(session.DBConnectionString, strSql);
break;
case 3:
strSql = "update T_11_009_{0} set C006 = '{1}' where C001 = {2} and C000 = 3";
strSql = string.Format(strSql, strToken, strColor, strLevelID);
optReturn = OracleOperation.ExecuteSql(session.DBConnectionString, strSql);
break;
}
optReturn.Message += " ; " + strSql;
if (!optReturn.Result)
{
optReturn.Code = (int)S5100WcfErrorCode.ModifyBookmarkLevelException;
}
}
catch (Exception ex)
{
optReturn.Code = Defines.RET_FAIL;
optReturn.Result = false;
optReturn.Message = ex.Message;
}
return(optReturn);
}
private OperationReturn DeleteKeyWorld(SessionInfo session, List <string> lstParams)
{
OperationReturn optReturn = new OperationReturn();
try
{
if (lstParams == null || lstParams.Count < 1)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("Request param is null or count invalid");
return(optReturn);
}
string rentToken = session.RentInfo.Token;
string strKeyWorldID = lstParams[0];
string strSql = string.Empty;
optReturn.Result = true;
optReturn.Code = Defines.RET_SUCCESS;
switch (session.DBType)
{
case 2:
strSql = " update T_11_009_{0} SET C010 = '1' where C001 = {1}";
strSql = string.Format(strSql, rentToken, strKeyWorldID);
optReturn = MssqlOperation.ExecuteSql(session.DBConnectionString, strSql);
break;
case 3:
strSql = " update T_11_009_{0} SET C010 = '1' where C001 = {1}";
strSql = string.Format(strSql, rentToken, strKeyWorldID);
optReturn = OracleOperation.ExecuteSql(session.DBConnectionString, strSql);
break;
}
optReturn.Message += ";" + strSql;
if (!optReturn.Result)
{
optReturn.Code = (int)S5100WcfErrorCode.AddBookmarkLevelError;
return(optReturn);
}
optReturn = GenerateKeyWorldXml(session, null);
if (!optReturn.Result)
{
return(optReturn);
}
List <string> lstParamInUpload = new List <string>();
lstParamInUpload.Add(optReturn.StringValue);
optReturn = UploadKeyWorldXml(session, lstParamInUpload);
if (!optReturn.Result)
{
return(optReturn);
}
optReturn.Data = strKeyWorldID.ToString();
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
optReturn.Exception = ex;
}
return(optReturn);
}
/// <summary>
/// 添加关键词
/// </summary>
/// <param name="session"></param>
/// <param name="lstParams"></param>
/// lstParams[0] : 关键词
/// lstParams[1] : 等级ID
/// <returns></returns>
private OperationReturn AddKeyWorld(SessionInfo session, List <string> lstParams)
{
OperationReturn optReturn = new OperationReturn();
try
{
if (lstParams == null || lstParams.Count < 2)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("Request param is null or count invalid");
return(optReturn);
}
string rentToken = session.RentInfo.Token;
string strLevelID = lstParams[1];
string strKeyWorld = S5100EncryptOperation.EncryptWithM002(lstParams[0]);
string strSql = string.Empty;
optReturn.Result = true;
optReturn.Code = Defines.RET_SUCCESS;
List <string> lst = new List <string>();
lst.Add("51");
lst.Add("501");
optReturn = GetSerialID(session, lst);
if (!optReturn.Result)
{
return(optReturn);
}
string str = optReturn.Data as string;
long keyWorldID = 0;
long.TryParse(str, out keyWorldID);
if (keyWorldID == 0)
{
optReturn.Result = false;
optReturn.Code = (int)S5100WcfErrorCode.SerialIDConvertError;
optReturn.Message = str;
return(optReturn);
}
switch (session.DBType)
{
case 2:
strSql = "insert into T_11_009_{4} (C000,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010)"
+ "values (4,{0},0,0,'1',0,'{1}','{2}','kw','{3}','0')";
strSql = string.Format(strSql, keyWorldID, strKeyWorld, session.UserID, strLevelID, rentToken);
optReturn = MssqlOperation.ExecuteSql(session.DBConnectionString, strSql);
break;
case 3:
strSql = "insert into T_11_009_{4} (C000,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010)"
+ "values (4,{0},0,0,'1',0,'{1}','{2}','kw','{3}','0')";
strSql = string.Format(strSql, keyWorldID, strKeyWorld, session.UserID, strLevelID, rentToken);
optReturn = OracleOperation.ExecuteSql(session.DBConnectionString, strSql);
break;
}
optReturn.Message += ";" + strSql;
if (!optReturn.Result)
{
optReturn.Code = (int)S5100WcfErrorCode.AddBookmarkLevelError;
return(optReturn);
}
optReturn = GenerateKeyWorldXml(session, null);
if (!optReturn.Result)
{
optReturn.Data = keyWorldID.ToString();
return(optReturn);
}
List <string> lstParamInUpload = new List <string>();
lstParamInUpload.Add(optReturn.StringValue);
optReturn = UploadKeyWorldXml(session, lstParamInUpload);
if (!optReturn.Result)
{
optReturn.Data = keyWorldID.ToString();
return(optReturn);
}
optReturn.Data = keyWorldID.ToString();
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
optReturn.Exception = ex;
}
return(optReturn);
}
/// <summary>
/// 添加标签等级
/// </summary>
/// <param name="session"></param>
/// <param name="lstParams"></param>
/// lstParams[0] : 等级名称
/// lstParams[1] : 等级颜色
/// <returns></returns>
private OperationReturn AddBookmarkLevel(SessionInfo session, List <string> lstParams)
{
OperationReturn optReturn = new OperationReturn();
try
{
//ListParam
//0 用户编号
if (lstParams == null || lstParams.Count < 1)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("Request param is null or count invalid");
return(optReturn);
}
string rentToken = session.RentInfo.Token;
string strSql = string.Empty;
optReturn.Result = true;
optReturn.Code = Defines.RET_SUCCESS;
List <string> lst = new List <string>();
lst.Add("51");
lst.Add("309");
optReturn = GetSerialID(session, lst);
if (!optReturn.Result)
{
return(optReturn);
}
string str = optReturn.Data as string;
long levelID = 0;
long.TryParse(str, out levelID);
if (levelID == 0)
{
optReturn.Result = false;
optReturn.Code = (int)S5100WcfErrorCode.SerialIDConvertError;
optReturn.Message = str;
return(optReturn);
}
switch (session.DBType)
{
case 2:
strSql = "insert into T_11_009_{0}(C000,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010)"
+ "values (3,{1},0,0,'1',0,'{2}','{3}','BM','{4}','0')";
strSql = string.Format(strSql, rentToken, levelID, S5100EncryptOperation.EncryptWithM002(lstParams[1]), session.UserID, lstParams[0]);
optReturn = MssqlOperation.ExecuteSql(session.DBConnectionString, strSql);
break;
case 3:
strSql = "insert into T_11_009_{0}(C000,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010)"
+ "values (3,{1},0,0,'1',0,'{2}','{3}','BM','{4}',0)";
strSql = string.Format(strSql, rentToken, levelID, S5100EncryptOperation.EncryptWithM002(lstParams[1]), session.UserID, lstParams[0]);
optReturn = OracleOperation.ExecuteSql(session.DBConnectionString, strSql);
break;
}
if (!optReturn.Result)
{
optReturn.Code = (int)S5100WcfErrorCode.AddBookmarkLevelError;
return(optReturn);
}
optReturn.Data = levelID.ToString();
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
optReturn.Exception = ex;
}
return(optReturn);
}
