private void LoadDatabaseInfo()
{
try
{
if (Session == null || Session.AppServerInfo == null)
{
return;
}
WebRequest webRequest = new WebRequest();
webRequest.Code = (int)RequestCode.WSGetDBInfo;
webRequest.Session = Session;
webRequest.ListData.Add(Session.UserID.ToString());
Service11012Client client = new Service11012Client(
WebHelper.CreateBasicHttpBinding(Session)
, WebHelper.CreateEndpointAddress(Session.AppServerInfo, "Service11012"));
WebReturn webReturn = client.DoOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
WriteLog("LoadDBInfo", string.Format("Fail.\t{0}\t{1}", webReturn.Code, webReturn.Message));
return;
}
if (webReturn.ListData == null ||
webReturn.ListData.Count < 6)
{
WriteLog("LoadDBInfo", string.Format("Fail.\tDatabase param count invalid"));
return;
}
DatabaseInfo dbInfo = Session.DatabaseInfo;
if (dbInfo == null)
{
dbInfo = new DatabaseInfo();
}
int intValue;
string strValue;
if (webReturn.ListData.Count > 0)
{
strValue = webReturn.ListData[0];
if (int.TryParse(strValue, out intValue))
{
dbInfo.TypeID = intValue;
}
}
if (webReturn.ListData.Count > 1)
{
strValue = webReturn.ListData[1];
dbInfo.Host = strValue;
}
if (webReturn.ListData.Count > 2)
{
strValue = webReturn.ListData[2];
if (int.TryParse(strValue, out intValue))
{
dbInfo.Port = intValue;
}
}
if (webReturn.ListData.Count > 3)
{
strValue = webReturn.ListData[3];
dbInfo.DBName = strValue;
}
if (webReturn.ListData.Count > 4)
{
strValue = webReturn.ListData[4];
dbInfo.LoginName = strValue;
}
if (webReturn.ListData.Count > 5)
{
strValue = webReturn.ListData[5];
dbInfo.Password = strValue;
}
Session.DatabaseInfo = dbInfo;
Session.DBType = dbInfo.TypeID;
IsDBSetted = true;
WriteLog("LoadDBInfo", string.Format("LoadDatabaseInfo end.\t{0}", dbInfo));
}
catch (Exception ex)
{
WriteLog("LoadDBInfo", string.Format("LoadDatabaseInfo fail.\t{0}", ex.Message));
}
}
private void LoadLanguageInfos()
{
try
{
if (CurrentApp.Session == null || CurrentApp.Session.LangTypeInfo == null)
{
return;
}
mListLanguageInfos.Clear();
WebRequest webRequest = new WebRequest();
webRequest.Code = (int)RequestCode.WSGetLangList;
webRequest.Session = CurrentApp.Session;
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add(string.Format("31{0}0", ConstValue.SPLITER_CHAR));
webRequest.ListData.Add(string.Format("3101{0}0", ConstValue.SPLITER_CHAR));
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add(string.Empty);
Service11012Client client = new Service11012Client(
WebHelper.CreateBasicHttpBinding(CurrentApp.Session)
, WebHelper.CreateEndpointAddress(CurrentApp.Session.AppServerInfo, "Service11012"));
WebReturn webReturn = client.DoOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
ShowException(string.Format("{0}\t{1}", webReturn.Code, webReturn.Message));
}
for (int i = 0; i < webReturn.ListData.Count; i++)
{
OperationReturn optReturn = XMLHelper.DeserializeObject <LanguageInfo>(webReturn.ListData[i]);
if (!optReturn.Result)
{
ShowException(string.Format("{0}\t{1}", optReturn.Code, optReturn.Message));
return;
}
LanguageInfo langInfo = optReturn.Data as LanguageInfo;
if (langInfo == null)
{
ShowException(string.Format("LanguageInfo is null"));
return;
}
ScoreLangauge scoreLanguage = new ScoreLangauge();
scoreLanguage.LangID = langInfo.LangID;
scoreLanguage.Display = langInfo.Display;
string name = langInfo.Name;
if (name.StartsWith("OBJ301"))
{
scoreLanguage.Code = name;
scoreLanguage.Category = langInfo.Page;
mListLanguageInfos.Add(scoreLanguage);
}
if (name.StartsWith("PRO301"))
{
scoreLanguage.Code = name;
scoreLanguage.Category = langInfo.Page;
mListLanguageInfos.Add(scoreLanguage);
}
if (name.StartsWith("PROD301"))
{
scoreLanguage.Code = name;
scoreLanguage.Category = langInfo.Page;
mListLanguageInfos.Add(scoreLanguage);
}
if (name.StartsWith("3101GRP301"))
{
scoreLanguage.Code = name;
scoreLanguage.Category = langInfo.Page;
mListLanguageInfos.Add(scoreLanguage);
}
if (name.StartsWith("3101Designer"))
{
scoreLanguage.Category = langInfo.Page;
scoreLanguage.Code = name.Substring(12);
mListLanguageInfos.Add(scoreLanguage);
}
if (name.StartsWith("3101ToolBar"))
{
scoreLanguage.Category = langInfo.Page;
scoreLanguage.Code = name.Substring(11);
mListLanguageInfos.Add(scoreLanguage);
}
if (name.StartsWith("3101ScoreViewer"))
{
scoreLanguage.Category = langInfo.Page;
scoreLanguage.Code = name.Substring(15);
mListLanguageInfos.Add(scoreLanguage);
}
if (name.StartsWith("3101PropertyViewer"))
{
scoreLanguage.Category = langInfo.Page;
scoreLanguage.Code = name.Substring(18);
mListLanguageInfos.Add(scoreLanguage);
}
if (name.StartsWith("3101ObjectViewer"))
{
scoreLanguage.Category = langInfo.Page;
scoreLanguage.Code = name.Substring(16);
mListLanguageInfos.Add(scoreLanguage);
}
}
}
catch (Exception ex)
{
ShowException(ex.Message);
}
}
private void InitControlOrgs(TreeObjectItem parentItem, string parentID)
{
try
{
WebRequest webRequest = new WebRequest();
webRequest.Session = SessionInfo;
webRequest.Code = (int)RequestCode.WSGetUserObjList;
webRequest.ListData.Add(SessionInfo.UserID.ToString());
webRequest.ListData.Add("0");
webRequest.ListData.Add(ConstValue.RESOURCE_ORG.ToString());
webRequest.ListData.Add(parentID);
Service11012Client client = new Service11012Client(
WebHelper.CreateBasicHttpBinding(SessionInfo),
WebHelper.CreateEndpointAddress(
SessionInfo.AppServerInfo,
"Service11012"));
WebReturn webReturn = client.DoOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
return;
}
if (webReturn.ListData == null)
{
return;
}
for (int i = 0; i < webReturn.ListData.Count; i++)
{
string strInfo = webReturn.ListData[i];
string[] arrInfo = strInfo.Split(new[] { ConstValue.SPLITER_CHAR },
StringSplitOptions.RemoveEmptyEntries);
if (arrInfo.Length < 2)
{
continue;
}
string strID = arrInfo[0];
string strName = arrInfo[1];
TreeObjectItem item = new TreeObjectItem();
item.ObjType = ConstValue.RESOURCE_ORG;
item.ObjID = Convert.ToInt64(strID);
item.Name = strName;
item.Data = strInfo;
if (strID == ConstValue.ORG_ROOT.ToString())
{
item.Icon = "Images/root.ico";
}
else
{
item.Icon = "Images/org.ico";
}
InitControlOrgs(item, strID);
InitControlUsers(item, strID);
InitControlAgents(item, strID);
Dispatcher.Invoke(new Action(() => parentItem.AddChild(item)));
mListObjects.Add(item);
}
}
catch (Exception ex)
{
TreeObjectEventArgs args = new TreeObjectEventArgs();
args.Code = 999;
args.Message = ex.Message;
OnTreeObjectEvent(args);
}
}
private void SaveRecordEncryptConfig()
{
try
{
if (ListRecordEncryptInfos == null)
{
return;
}
List <UserParamInfo> listInfos = new List <UserParamInfo>();
for (int i = 0; i < ListRecordEncryptInfos.Count; i++)
{
var item = ListRecordEncryptInfos[i];
if (!item.IsRemember)
{
continue;
}
UserParamInfo up = new UserParamInfo();
up.UserID = App.Session.UserID;
up.ParamID = S3104Consts.USER_PARAM_GROUP_ENCRYPTINFO * 1000 + 1 + i;
up.GroupID = S3104Consts.USER_PARAM_GROUP_ENCRYPTINFO;
up.SortID = i;
up.DataType = DBDataType.NVarchar;
string strValue = string.Format("{0}{1}{2}{1}{3}",
item.ServerAddress,
ConstValue.SPLITER_CHAR_3,
item.Password,
item.EndTime.ToString("yyyyMMddHHmmss"));
up.ParamValue = strValue;
listInfos.Add(up);
}
int cout = listInfos.Count;
if (cout <= 0)
{
return;
}
OperationReturn optReturn;
WebRequest webRequest = new WebRequest();
webRequest.Code = (int)RequestCode.WSSaveUserParamList;
webRequest.Session = App.Session;
webRequest.ListData.Add(App.Session.UserInfo.UserID.ToString());
webRequest.ListData.Add(cout.ToString());
for (int i = 0; i < cout; i++)
{
var up = listInfos[i];
optReturn = XMLHelper.SeriallizeObject(up);
if (!optReturn.Result)
{
App.ShowExceptionMessage(string.Format("Fail.\t{0}\t{1}", optReturn.Code, optReturn.Message));
return;
}
webRequest.ListData.Add(optReturn.Data.ToString());
}
//App.MonitorHelper.AddWebRequest(webRequest);
Service11012Client client = new Service11012Client(WebHelper.CreateBasicHttpBinding(App.Session),
WebHelper.CreateEndpointAddress(App.Session.AppServerInfo, "Service11012"));
WebHelper.SetServiceClient(client);
WebReturn webReturn = client.DoOperation(webRequest);
//App.MonitorHelper.AddWebReturn(webReturn);
client.Close();
if (!webReturn.Result)
{
App.ShowExceptionMessage(string.Format("WSFail.\t{0}\t{1}", webReturn.Code, webReturn.Message));
}
}
catch (Exception ex)
{
App.WriteLog("SaveEncryptConfig", string.Format("Fail.\t{0}", ex.Message));
}
}
private void InitMemoUsers()
{
try
{
List <string> listUserID = new List <string>();
for (int i = 0; i < mListRecordMemos.Count; i++)
{
string strUserID = mListRecordMemos[i].UserID.ToString();
if (!listUserID.Contains(strUserID))
{
listUserID.Add(strUserID);
}
}
if (listUserID.Count <= 0)
{
return;
}
WebRequest webRequest = new WebRequest();
webRequest.Session = CurrentApp.Session;
webRequest.Code = (int)RequestCode.WSGetResourceProperty;
webRequest.ListData.Add("102");
webRequest.ListData.Add("Account");
webRequest.ListData.Add(listUserID.Count.ToString());
for (int i = 0; i < listUserID.Count; i++)
{
webRequest.ListData.Add(listUserID[i]);
}
Service11012Client client = new Service11012Client(
WebHelper.CreateBasicHttpBinding(CurrentApp.Session),
WebHelper.CreateEndpointAddress(
CurrentApp.Session.AppServerInfo,
"Service11012"));
WebReturn webReturn = client.DoOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
ShowException(string.Format("Fail.\t{0}\t{1}", webReturn.Code, webReturn.Message));
return;
}
if (webReturn.ListData == null)
{
ShowException(string.Format("Fail.\tListData is null"));
return;
}
mListUsers.Clear();
for (int i = 0; i < webReturn.ListData.Count; i++)
{
string strInfo = webReturn.ListData[i];
string[] arrInfo = strInfo.Split(new[] { ConstValue.SPLITER_CHAR },
StringSplitOptions.RemoveEmptyEntries);
if (arrInfo.Length < 2)
{
continue;
}
long id = Convert.ToInt64(arrInfo[0]);
string account = arrInfo[1];
if (id == CurrentApp.Session.UserID)
{
continue;
}
BasicUserItem item = new BasicUserItem();
item.UserID = id;
item.Name = account;
mListUsers.Add(item);
}
}
catch (Exception ex)
{
ShowException(ex.Message);
}
}
private void LoadUserOrgs(ObjectItem parentItem)
{
string OrgID = string.Empty;
try
{
WebRequest webRequest = new WebRequest();
webRequest.Session = CurrentApp.Session;
webRequest.Code = (int)RequestCode.WSGetUserObjList;
webRequest.ListData.Add(UserItem.ObjID.ToString());
webRequest.ListData.Add("0");
webRequest.ListData.Add(ConstValue.RESOURCE_ORG.ToString());
webRequest.ListData.Add("-1");
Service11012Client client = new Service11012Client(
WebHelper.CreateBasicHttpBinding(CurrentApp.Session),
WebHelper.CreateEndpointAddress(
CurrentApp.Session.AppServerInfo,
"Service11012"));
WebHelper.SetServiceClient(client);
WebReturn webReturn = client.DoOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
ShowException(string.Format("Fail.\t{0}\t{1}", webReturn.Code, webReturn.Message));
}
if (webReturn.ListData == null)
{
ShowException(string.Format("Fail.\tListData is null"));
}
if (webReturn.ListData.Count > 0)
//for (int i = 0; i < webReturn.ListData.Count; i++)
{
string strInfo = webReturn.ListData[0];
string[] arrInfo = strInfo.Split(new[] { ConstValue.SPLITER_CHAR },
StringSplitOptions.RemoveEmptyEntries);
if (arrInfo.Length < 2)
{
return;
}
OrgID = arrInfo[0];
string strName = arrInfo[1];
ObjectItem item = new ObjectItem();
item.ObjType = ConstValue.RESOURCE_ORG;
item.ObjID = Convert.ToInt64(OrgID);
item.Name = strName;
item.Data = strInfo;
if (OrgID == ConstValue.ORG_ROOT.ToString())
{
item.Icon = "Images/root.ico";
}
else
{
item.Icon = "Images/org.ico";
}
LoadAvaliableOrgs(item, OrgID);
LoadAvaliableUsers(item, OrgID);
if (PageParent.InitParameter.Contains("A"))
{
LoadAvaliableAgents(item, OrgID);
}
if (PageParent.InitParameter.Contains("E"))
{
LoadAvaliableExts(item, OrgID);
}
if (PageParent.InitParameter.Contains("R"))
{
LoadAvaliableRealExts(item, OrgID);
}
Dispatcher.Invoke(new Action(() => parentItem.AddChild(item)));
mListObjectItems.Add(item);
}
}
catch (Exception ex)
{
ShowException(ex.Message);
}
}
/// <summary>
/// 获得当前用户可以管理的用户
/// </summary>
/// <returns></returns>
public static OperationReturn GetCotrlUser()
{
OperationReturn optReturn = new OperationReturn();
optReturn.Result = true;
optReturn.Code = Defines.RET_SUCCESS;
Service11012Client client = null;
try
{
string strUserID = App.Session.UserID.ToString();
WebRequest webRequest = new WebRequest();
webRequest.Code = (int)RequestCode.WSGetUserCtlObjList;
webRequest.Session = App.Session;
webRequest.ListData.Add(App.Session.UserInfo.UserID.ToString());
webRequest.ListData.Add("1");
webRequest.ListData.Add(ConstValue.RESOURCE_USER.ToString());
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add("3");
App.MonitorHelper.AddWebRequest(webRequest);
client = new Service11012Client(WebHelper.CreateBasicHttpBinding(App.Session),
WebHelper.CreateEndpointAddress(App.Session.AppServerInfo, "Service11012"));
WebHelper.SetServiceClient(client);
WebReturn webReturn = client.DoOperation(webRequest);
App.MonitorHelper.AddWebReturn(webReturn);
client.Close();
if (!webReturn.Result)
{
optReturn.Result = false;
optReturn.Code = webReturn.Code;
optReturn.Message = webReturn.Message;
return(optReturn);
}
if (webReturn.ListData == null)
{
optReturn.Result = false;
optReturn.Code = (int)S6106WcfErrorCode.GetUserPermissionFailed;
return(optReturn);
}
List <string> lstUserIDs = new List <string>();
ResourceObject res = null;
for (int i = 0; i < webReturn.ListData.Count; i++)
{
optReturn = XMLHelper.DeserializeObject <ResourceObject>(webReturn.ListData[i]);
if (optReturn.Result)
{
res = optReturn.Data as ResourceObject;
lstUserIDs.Add(res.ObjID.ToString());
}
}
optReturn.Data = lstUserIDs;
return(optReturn);
}
catch (Exception ex)
{
App.ShowExceptionMessage(ex.Message);
return(optReturn);
}
finally
{
if (client != null)
{
if (client.State == System.ServiceModel.CommunicationState.Opened)
{
client.Close();
}
}
}
}
private void LoadCustomColumnData()
{
try
{
mListObject_Kpi.Clear();
WebRequest webRequest = new WebRequest();
webRequest.Code = (int)RequestCode.WSGetUserViewColumnList;
webRequest.Session = CurrentApp.Session;
webRequest.ListData.Add(CurrentApp.Session.UserInfo.UserID.ToString());
webRequest.ListData.Add("4602001");
Service11012Client client = new Service11012Client(WebHelper.CreateBasicHttpBinding(CurrentApp.Session),
WebHelper.CreateEndpointAddress(CurrentApp.Session.AppServerInfo, "Service11012"));
WebReturn webReturn = client.DoOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
ShowException(string.Format("Fail.\t{0}\t{1}", webReturn.Code, webReturn.Message));
return;
}
List <ViewColumnInfo> listColumns = new List <ViewColumnInfo>();
for (int i = 0; i < webReturn.ListData.Count; i++)
{
OperationReturn optReturn = XMLHelper.DeserializeObject <ViewColumnInfo>(webReturn.ListData[i]);
if (!optReturn.Result)
{
ShowException(string.Format("Fail.\t{0}\t{1}", optReturn.Code, optReturn.Message));
return;
}
ViewColumnInfo columnInfo = optReturn.Data as ViewColumnInfo;
if (columnInfo != null)
{
columnInfo.Display = columnInfo.ColumnName;
listColumns.Add(columnInfo);
}
}
listColumns = listColumns.OrderBy(c => c.SortID).ToList();
if (listColumns.Where(p => p.SortID == 0).First().ColumnName == "UERName")//按对象分组
{
rabObject.IsChecked = true;
}
else
{
rabKpi.IsChecked = true;
}
mListCustomColumns.Clear();
for (int i = 0; i < listColumns.Count; i++)
{
ViewColumnInfoItem item = new ViewColumnInfoItem(listColumns[i]);
item.Display = CurrentApp.GetLanguageInfo(string.Format("4601P00{0}", item.LangID.ToString().Substring(1, 3)), item.ColumnName);
item.StrIsVisible = CurrentApp.GetLanguageInfo(string.Format("4601P0004{0}", listColumns[i].Visibility), listColumns[i].Visibility);
if (i % 2 != 0)
{
item.Background = Brushes.LightGray;
}
else
{
item.Background = Brushes.AntiqueWhite;
}
if (item.ColumnName == "UERName" || item.ColumnName == "KPIName")//对象、PM指标列不能修改顺序,在提交应用时再加上去
{
mListObject_Kpi.Add(listColumns[i]);
}
else
{
mListCustomColumns.Add(item);
}
}
}
catch (Exception ex)
{
ShowException(ex.Message);
}
}
private void BrowseIconImage()
{
try
{
OpenFileDialog dialog = new OpenFileDialog();
dialog.Title = string.Format("Select a image as Alarm icon");
dialog.Multiselect = false;
dialog.Filter = "Support Image|*.jpg;*.jpeg;*.png;*.bmp;*.gif";
var result = dialog.ShowDialog();
if (result != true)
{
return;
}
string strFile = dialog.FileName;
if (!File.Exists(strFile))
{
return;
}
#region 背景图片
FileInfo fileInfo = new FileInfo(strFile);
string strExt = fileInfo.Extension;
strExt = strExt.TrimStart('.');
if (fileInfo.Length > 1024 * 1024 * 5)
{
//图片文件超过5M，不允许上传
ShowException(string.Format("Image file too big, can not upload."));
return;
}
int length = (int)fileInfo.Length;
byte[] buffer = File.ReadAllBytes(strFile);
UploadRequest request = new UploadRequest();
request.Session = CurrentApp.Session;
request.Code = (int)RequestCode.WSUploadFile;
request.ListData.Add(length.ToString());
request.ListData.Add("4415");
request.ListData.Add("1"); //先上传到MediaData临时目录
request.ListData.Add(string.Empty); //自动生成文件名
request.ListData.Add(strExt); //扩展名
request.Content = buffer;
Service11012Client client = new Service11012Client(
WebHelper.CreateBasicHttpBinding(CurrentApp.Session),
WebHelper.CreateEndpointAddress(CurrentApp.Session.AppServerInfo, "Service11012"));
WebReturn webReturn = client.UploadOperation(request);
client.Close();
if (!webReturn.Result)
{
ShowException(string.Format("WSFail.\t{0}\t{1}", webReturn.Code, webReturn.Message));
return;
}
string strTemp = webReturn.Data;
if (string.IsNullOrEmpty(strTemp))
{
ShowException(string.Format("Fail.\tFileName empty!"));
return;
}
mAlarmIcon = strTemp;
CurrentApp.WriteLog("UploadIconImage", string.Format("End.\t{0}", mAlarmIcon));
string strUrl = string.Format("{0}://{1}:{2}/{3}/{4}",
CurrentApp.Session.AppServerInfo.Protocol,
CurrentApp.Session.AppServerInfo.Address,
CurrentApp.Session.AppServerInfo.Port,
ConstValue.TEMP_DIR_MEDIADATA,
mAlarmIcon);
BitmapImage bitmap = new BitmapImage();
bitmap.BeginInit();
bitmap.UriSource = new Uri(strUrl, UriKind.Absolute);
bitmap.EndInit();
ImageIcon.Source = bitmap;
Image imgTip = new Image();
imgTip.Source = new BitmapImage(new Uri(strUrl, UriKind.Absolute));
imgTip.Stretch = Stretch.Uniform;
ImageIcon.ToolTip = imgTip;
#endregion
}
catch (Exception ex)
{
ShowException(ex.Message);
}
}
private OperationReturn RemoveAlarmInfoList(SessionInfo session, List <string> listParams)
{
OperationReturn optReturn = new OperationReturn();
optReturn.Result = true;
optReturn.Code = 0;
try
{
//ListParam
//0 用户编码
//1 待删除的告警信息总数
//2... 待删除告警信息的SerialID
if (listParams == null || listParams.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 strUserID = listParams[0];
string strCount = listParams[1];
int intCount;
if (!int.TryParse(strCount, out intCount))
{
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("AlarmInfo count param invalid");
return(optReturn);
}
if (listParams.Count < intCount + 2)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("AlarmInfo count invalid");
return(optReturn);
}
List <long> listAlarmInfoIDs = new List <long>();
for (int i = 0; i < intCount; i++)
{
string strID = listParams[i + 2];
long id;
if (!long.TryParse(strID, out id))
{
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("AlarmInfo serialID invalid");
return(optReturn);
}
listAlarmInfoIDs.Add(id);
}
//将SerialID插入到临时表中
WebRequest webRequest = new WebRequest();
webRequest.Session = session;
webRequest.Code = (int)RequestCode.WSInsertTempData;
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add(intCount.ToString());
for (int i = 0; i < intCount; i++)
{
string strInfo = listAlarmInfoIDs[i].ToString();
webRequest.ListData.Add(strInfo);
}
Service11012Client client = new Service11012Client(WebHelper.CreateBasicHttpBinding(session),
WebHelper.CreateEndpointAddress(session.AppServerInfo, "Service11012"));
WebReturn webReturn = client.DoOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
optReturn.Result = false;
optReturn.Code = webReturn.Code;
optReturn.Message = webReturn.Message;
return(optReturn);
}
string strTempID = webReturn.Data;
string rentToken = session.RentInfo.Token;
string strSql;
switch (session.DBType)
{
//MSSQL
case 2:
strSql =
string.Format(
"DELETE FROM T_25_007 WHERE C001 IN (SELECT C011 FROM T_00_901 WHERE C001 = {0})",
strTempID);
optReturn = MssqlOperation.ExecuteSql(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
strSql =
string.Format(
"DELETE FROM T_25_008 WHERE C002 IN (SELECT C011 FROM T_00_901 WHERE C001 = {0})",
strTempID);
optReturn = MssqlOperation.ExecuteSql(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
break;
//ORCL
case 3:
strSql =
string.Format(
"DELETE FROM T_25_007 WHERE C001 IN (SELECT C011 FROM T_00_901 WHERE C001 = {0})",
strTempID);
optReturn = OracleOperation.ExecuteSql(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
strSql =
string.Format(
"DELETE FROM T_25_008 WHERE C002 IN (SELECT C011 FROM T_00_901 WHERE C001 = {0})",
strTempID);
optReturn = OracleOperation.ExecuteSql(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
break;
default:
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("Database type not support");
return(optReturn);
}
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
optReturn.Exception = ex;
}
return(optReturn);
}
private OperationReturn RemoveResourceObjectData(SessionInfo session, List <string> listParams)
{
OperationReturn optReturn = new OperationReturn();
optReturn.Result = true;
optReturn.Code = 0;
try
{
//ListParam
//0 资源总数
//1... 资源编码
if (listParams == null || listParams.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 strCount = listParams[0];
int intCount;
if (!int.TryParse(strCount, out intCount))
{
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("Resource id count param invalid");
return(optReturn);
}
if (listParams.Count < intCount + 1)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("Resource id count invalid");
return(optReturn);
}
if (intCount > 0)
{
WebRequest webRequest = new WebRequest();
webRequest.Session = session;
webRequest.Code = (int)RequestCode.WSInsertTempData;
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add(intCount.ToString());
for (int i = 0; i < intCount; i++)
{
webRequest.ListData.Add(listParams[i + 1]);
}
Service11012Client client = new Service11012Client(WebHelper.CreateBasicHttpBinding(session),
WebHelper.CreateEndpointAddress(session.AppServerInfo, "Service11012"));
WebReturn webReturn = client.DoOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
optReturn.Result = false;
optReturn.Code = webReturn.Code;
optReturn.Message = webReturn.Message;
return(optReturn);
}
string strID = webReturn.Data;
string rentToken = session.RentInfo.Token;
string strSql;
switch (session.DBType)
{
case 2:
strSql =
string.Format(
"DELETE FROM T_11_101_{0} WHERE C001 IN (SELECT C011 FROM T_00_901 WHERE C001 = {1})",
rentToken,
strID);
optReturn = MssqlOperation.ExecuteSql(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
break;
case 3:
strSql =
string.Format(
"DELETE FROM T_11_101_{0} WHERE C001 IN (SELECT C011 FROM T_00_901 WHERE C001 = {1})",
rentToken,
strID);
optReturn = OracleOperation.ExecuteSql(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
break;
default:
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("Database type not support");
return(optReturn);
}
}
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
}
return(optReturn);
}
protected override void InitLanguageInfos()
{
base.InitLanguageInfos();
try
{
if (Session == null || Session.LangTypeInfo == null)
{
return;
}
//ListLanguageInfos.Clear();
WebRequest webRequest = new WebRequest();
webRequest.Code = (int)RequestCode.WSGetLangList;
webRequest.Session = Session;
//ListParams
//0 LangID
//1 PreName（语言内容编码的前缀，比如 FO:模块、操作显示语言）
//2 ModuleID
//3 SubModuleID
//4 Page
//5 Name
webRequest.ListData.Add(Session.LangTypeInfo.LangID.ToString());
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add("11");
webRequest.ListData.Add("1102");
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add(string.Empty);
Service11012Client client = new Service11012Client(WebHelper.CreateBasicHttpBinding(Session), WebHelper.CreateEndpointAddress(Session.AppServerInfo, "Service11012"));
WebHelper.SetServiceClient(client);
WebReturn webReturn = client.DoOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
ShowExceptionMessage(string.Format("{0}\t{1}", webReturn.Code, webReturn.Message));
}
for (int i = 0; i < webReturn.ListData.Count; i++)
{
OperationReturn optReturn = XMLHelper.DeserializeObject <LanguageInfo>(webReturn.ListData[i]);
if (!optReturn.Result)
{
ShowExceptionMessage(string.Format("{0}\t{1}", optReturn.Code, optReturn.Message));
return;
}
LanguageInfo langInfo = optReturn.Data as LanguageInfo;
if (langInfo == null)
{
ShowExceptionMessage(string.Format("LanguageInfo is null"));
return;
}
ListLanguageInfos.Add(langInfo);
}
//MessageBox.Show(name+" 1:ok");
//ListParams
//0 LangID
//1 PreName（语言内容编码的前缀，比如 FO:模块、操作显示语言）
//2 ModuleID
//3 SubModuleID
//4 Page
//5 Name
webRequest = new WebRequest();
webRequest.Session = Session;
webRequest.Code = (int)RequestCode.WSGetLangList;
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add("FO");
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add(string.Empty);
client = new Service11012Client(WebHelper.CreateBasicHttpBinding(Session), WebHelper.CreateEndpointAddress(Session.AppServerInfo, "Service11012"));
WebHelper.SetServiceClient(client);
webReturn = client.DoOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
ShowExceptionMessage(string.Format("{0}\t{1}", webReturn.Code, webReturn.Message));
}
for (int i = 0; i < webReturn.ListData.Count; i++)
{
OperationReturn optReturn = XMLHelper.DeserializeObject <LanguageInfo>(webReturn.ListData[i]);
if (!optReturn.Result)
{
ShowExceptionMessage(string.Format("{0}\t{1}", optReturn.Code, optReturn.Message));
return;
}
LanguageInfo langInfo = optReturn.Data as LanguageInfo;
if (langInfo == null)
{
ShowExceptionMessage(string.Format("LanguageInfo is null"));
return;
}
if (ListLanguageInfos.Where(p => p.LangID == langInfo.LangID && p.Name == langInfo.Name).Count() == 0)
{
ListLanguageInfos.Add(langInfo);
}
}
//MessageBox.Show(name+" 2:ok");
webRequest = new WebRequest();
webRequest.Session = Session;
webRequest.Code = (int)RequestCode.WSGetLangList;
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add("COM");
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add(string.Empty);
webRequest.ListData.Add(string.Empty);
client = new Service11012Client(WebHelper.CreateBasicHttpBinding(Session), WebHelper.CreateEndpointAddress(Session.AppServerInfo, "Service11012"));
WebHelper.SetServiceClient(client);
webReturn = client.DoOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
ShowExceptionMessage(string.Format("{0}\t{1}", webReturn.Code, webReturn.Message));
}
for (int i = 0; i < webReturn.ListData.Count; i++)
{
OperationReturn optReturn = XMLHelper.DeserializeObject <LanguageInfo>(webReturn.ListData[i]);
if (!optReturn.Result)
{
ShowExceptionMessage(string.Format("{0}\t{1}", optReturn.Code, optReturn.Message));
return;
}
LanguageInfo langInfo = optReturn.Data as LanguageInfo;
if (langInfo == null)
{
ShowExceptionMessage(string.Format("LanguageInfo is null"));
return;
}
if (ListLanguageInfos.Where(p => p.LangID == langInfo.LangID && p.Name == langInfo.Name).Count() == 0)
{
ListLanguageInfos.Add(langInfo);
}
} //MessageBox.Show(name+" 3:ok");
}
catch (Exception ex)
{
//ShowExceptionMessage(ex.Message);
}
}
private OperationReturn SaveNewDomainInfo(DataSet dataSet, SessionInfo session, BasicDomainInfo DI)
{
OperationReturn optReturn = new OperationReturn();
optReturn.Result = true;
optReturn.Code = 0;
try
{
//如果没有重名，则添加到数据库
WebRequest webRequest = new WebRequest();
webRequest.Session = session;
webRequest.Code = (int)RequestCode.WSGetSerialID;
webRequest.ListData.Add("11");
webRequest.ListData.Add("110");
webRequest.ListData.Add(DateTime.Now.ToString("yyyyMMddHHmmss"));
Service11012Client client = new Service11012Client(WebHelper.CreateBasicHttpBinding(session),
WebHelper.CreateEndpointAddress(session.AppServerInfo, "Service11012"));
WebReturn webReturn = client.DoOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
optReturn.Result = false;
optReturn.Code = webReturn.Code;
optReturn.Message = webReturn.Message;
return(optReturn);
}
string strNewID = webReturn.Data;
if (string.IsNullOrEmpty(strNewID))
{
optReturn.Result = false;
optReturn.Code = Defines.RET_STRING_EMPTY;
optReturn.Message = string.Format("New Domain ID is empty");
return(optReturn);
}
int dex = dataSet.Tables[0].Rows.Count;
DataRow NewRow = dataSet.Tables[0].NewRow();
NewRow["C001"] = strNewID;
NewRow["C002"] = session.RentInfo.Token;
NewRow["C003"] = EncryptToDB002(DI.DomainName.Trim());
NewRow["C004"] = dex.ToString();
NewRow["C005"] = EncryptToDB002(DI.DomainUserName.Trim());
NewRow["C006"] = EncryptToDB003(string.Format("{0}@{1}", strNewID, DI.DomainUserPassWord.Trim()).Trim());
NewRow["C007"] = null;
NewRow["C008"] = "1";
NewRow["C009"] = "0";
NewRow["C010"] = DI.IsActiveLogin ? 1 : 0;
NewRow["C011"] = session.UserID.ToString();
NewRow["C012"] = DateTime.Now.ToUniversalTime().ToString("yyyyMMddHHmmss");
NewRow["C999"] = DI.Description;
dataSet.Tables[0].Rows.Add(NewRow);
optReturn.Data = dataSet;
return(optReturn);
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = 88;
optReturn.Message = string.Format("SaveNewDomainInfo Fail:{0}", ex.Message);
return(optReturn);
}
}
private void LoadAvaliableOrgs(OrgUserItem parentItem, string parentId)
{
try
{
WebRequest webRequest = new WebRequest
{
Session = CurrentApp.Session,
Code = (int)RequestCode.WSGetUserObjList
};
webRequest.ListData.Add(CurrentApp.Session.UserID.ToString());
webRequest.ListData.Add("0");
webRequest.ListData.Add(ConstValue.RESOURCE_ORG.ToString());
webRequest.ListData.Add(parentId);
Service11012Client client = new Service11012Client(
WebHelper.CreateBasicHttpBinding(CurrentApp.Session),
WebHelper.CreateEndpointAddress(
CurrentApp.Session.AppServerInfo,
"Service11012"));
WebReturn webReturn = client.DoOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
ShowException(string.Format("Fail.\t{0}\t{1}", webReturn.Code, webReturn.Message));
return;
}
if (webReturn.ListData == null)
{
ShowException("Fail.\tListData is null");
return;
}
foreach (string strInfo in webReturn.ListData)
{
string[] arrInfo = strInfo.Split(new[] { ConstValue.SPLITER_CHAR },
StringSplitOptions.RemoveEmptyEntries);
if (arrInfo.Length < 2)
{
continue;
}
string strId = arrInfo[0];
string strName = arrInfo[1];
OrgUserItem item = new OrgUserItem
{
ObjType = ConstValue.RESOURCE_ORG,
ObjID = Convert.ToInt64(strId),
Name = strName,
Data = strInfo,
Icon = strId == ConstValue.ORG_ROOT.ToString() ? "Images/rootorg.ico" : "Images/org.ico"
};
LoadAvaliableOrgs(item, strId);
//LoadAvaliableUsers(item, strID);
if (S3603App.GroupingWay.Contains("A"))
{
LoadAvaliableAgent(item, strId);
}
Dispatcher.Invoke(new Action(() => parentItem.AddChild(item)));
_mListOrgUserItems.Add(item);
}
}
catch (Exception ex)
{
ShowException(ex.Message);
}
}
