/// <summary>
/// 将界面上的值写入EncryptionPolicy对象
/// </summary>
/// <returns></returns>
public UMPEncryptionPolicy GetPolicyInTypeU(UMPEncryptionPolicy policy, PolicyUpdateEntry policyUpdate)
{
string strPwd = string.Empty;
if (IPageParent.iAddOrModify == (int)OperationType.Add)
{
if (chkShowPasswordI.IsChecked == true)
{
strPwd = TextPasswordShow.Text;
}
else
{
strPwd = TextPasswordHidden.Password;
}
}
else if (IPageParent.iAddOrModify == (int)OperationType.Modify)
{
if (chkChangeKey.IsChecked == true)
{
if (chkShowPasswordC.IsChecked == true)
{
strPwd = TextChangePwdShow.Text;
}
else
{
strPwd = TextChangePwdHidden.Password;
}
policyUpdate.IsUpdatePwd = true;
}
else
{
strPwd = S2400EncryptOperation.DecryptWithM002(IPageParent.policyModifying.TypeuEncryptKey);
}
if (radEnableDate.IsChecked == true)
{
policy.TypeUStartTime = DateTime.Parse(StartDateTime.Text).ToUniversalTime().ToString("yyyy-MM-dd HH:mm:ss");
policyUpdate.EffectTime = policy.TypeUStartTime;
}
else if (radEnableImmediately.IsChecked == true)
{
policy.IsImmediately = 1;
IPageParent.mainPage.GetAppServerCurrentTime();
policyUpdate.EffectTime = S2400App.GolbalCurrentEncryptionDBTime.ToString("yy-MM-dd HH:mm:ss");
}
}
policy.TypeuEncryptKey = S2400EncryptOperation.EncryptWithM002(strPwd);
return(policy);
}
/// <summary>
/// 添加或更新邮件通知参数
/// </summary>
/// <param name="session"></param>
/// <param name="lstParams"></param>
/// lstParams[0] : 是否启用邮件通知
/// lstParams[1] : SMTP
/// lstParams[2] : SMTP Port
/// lstParams[3] : 需要SSL
/// lstParams[4] : 账号
/// lstParams[5] : 密码
/// lstParams[6] : 需要身份认证
/// lstParams[7] : Email Address
/// <returns></returns>
private OperationReturn UpdateEmailInfo(SessionInfo session, List <string> lstParams)
{
OperationReturn optReturn = new OperationReturn();
try
{
string rentToken = session.RentInfo.Token;
string strSql = string.Empty;
lstParams[5] = S2400EncryptOperation.EncryptWithM002(lstParams[5]);
IDbConnection objConn = null;
IDbDataAdapter objAdapter = null;
DbCommandBuilder objCmdBuilder = null;
switch (session.DBType)
{
case 2:
strSql = string.Format("SELECT * FROM T_11_001_{0} WHERE C001 = '{1}' and C002 =24 and C004 = 24041 ORDER BY C005", rentToken, session.RentID);
optReturn = MssqlOperation.GetDataSet(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
objConn = MssqlOperation.GetConnection(session.DBConnectionString);
objAdapter = MssqlOperation.GetDataAdapter(objConn, strSql);
objCmdBuilder = MssqlOperation.GetCommandBuilder(objAdapter);
break;
case 3:
strSql = string.Format("SELECT * FROM T_11_001_{0} WHERE C001 = '{1}' AND C002 =24 AND C004 = 24041 ORDER BY C005", rentToken, session.RentID);
optReturn = OracleOperation.GetDataSet(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
objConn = OracleOperation.GetConnection(session.DBConnectionString);
objAdapter = OracleOperation.GetDataAdapter(objConn, strSql);
objCmdBuilder = OracleOperation.GetCommandBuilder(objAdapter);
break;
}
if (objConn == null || objAdapter == null || objCmdBuilder == null)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_OBJECT_NULL;
optReturn.Message = string.Format("Db object is null");
return(optReturn);
}
objCmdBuilder.ConflictOption = ConflictOption.OverwriteChanges;
objCmdBuilder.SetAllValues = false;
DataSet objDataSet = new DataSet();
objAdapter.Fill(objDataSet);
List <string> listMsg = new List <string>();
if (lstParams[0] == "0")
{
DataRow[] drs = objDataSet.Tables[0].Select("c003 = 240401");
if (drs.Count() > 0)
{
drs[0]["C006"] = lstParams[0];
drs[0]["C018"] = DateTime.Now.ToUniversalTime().ToString("yyyy-MM-dd HH:mm:ss");
drs[0]["C019"] = session.UserID;
listMsg.Add("Update Email Enable : 0");
}
}
else
{
for (int i = 0; i < lstParams.Count; i++)
{
string strParamID = "24040" + (i + 1);
DataRow[] drs = objDataSet.Tables[0].Select(string.Format("c003 = {0}", strParamID));
//如果存在 则修改
if (drs.Count() > 0)
{
drs[0]["C006"] = lstParams[i];
drs[0]["C018"] = DateTime.Now.ToUniversalTime().ToString("yyyy-MM-dd HH:mm:ss");
drs[0]["C019"] = session.UserID;
listMsg.Add(string.Format("Update {0}", lstParams[i]));
}
//如果不存在 则插入
else
{
DataRow row = objDataSet.Tables[0].NewRow();
row["C001"] = session.RentID;
row["C002"] = 24;
row["C003"] = "24040" + (i + 1);
row["C004"] = "24041";
row["C005"] = i;
row["C006"] = lstParams[i];
row["C007"] = 13;
row["C009"] = 0;
row["C010"] = 0;
row["C011"] = 0;
row["C015"] = 0;
row["C018"] = DateTime.Now.ToUniversalTime().ToString("yyyy-MM-dd HH:mm:ss");
row["C019"] = session.UserID;
row["C020"] = -1;
row["C021"] = DateTime.Now.ToUniversalTime().ToString("yyyy-MM-dd HH:mm:ss");
objDataSet.Tables[0].Rows.Add(row);
listMsg.Add(string.Format("Add {0}", lstParams[i]));
}
}
}
objAdapter.Update(objDataSet);
objDataSet.AcceptChanges();
optReturn.Data = listMsg;
optReturn.Result = true;
optReturn.Code = Defines.RET_SUCCESS;
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
optReturn.Exception = ex;
}
return(optReturn);
}