개정판 6c781c0c
issue #573 : Direct DB Connection Modify
Client Method Modify
| KCOM/Controls/Symbol.xaml.cs | ||
|---|---|---|
| 90 | 90 |
|
| 91 | 91 |
Symbol_Custom Custom = new Symbol_Custom(); |
| 92 | 92 |
List<Symbol_Custom> Custom_List = new List<Symbol_Custom>(); |
| 93 |
|
|
| 94 |
using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString())) |
|
| 93 |
ServiceDeepView.ServiceDeepViewClient client = new ServiceDeepView.ServiceDeepViewClient(App._binding, App._EndPoint); |
|
| 94 |
var symbol_Private = client.GetSymbolList(App.ViewInfo.UserID); |
|
| 95 |
foreach (var item in symbol_Private) |
|
| 95 | 96 |
{
|
| 96 |
var symbol_Private = Entity.SYMBOL_PRIVATE.Where(data => data.MEMBER_USER_ID == App.ViewInfo.UserID).ToList(); |
|
| 97 |
foreach(var item in symbol_Private) |
|
| 98 |
{
|
|
| 99 |
Custom.Name = item.NAME; |
|
| 100 |
Custom.ImageUri = item.IMAGE_URL; |
|
| 101 |
Custom.ID = item.ID; |
|
| 102 |
Custom_List.Add(Custom); |
|
| 103 |
Custom = new Symbol_Custom(); |
|
| 104 |
} |
|
| 105 |
lstSymbolPrivate.ItemsSource = Custom_List; |
|
| 106 |
|
|
| 97 |
Custom.Name = item.NAME; |
|
| 98 |
Custom.ImageUri = item.IMAGE_URL; |
|
| 99 |
Custom.ID = item.ID; |
|
| 100 |
Custom_List.Add(Custom); |
|
| 107 | 101 |
Custom = new Symbol_Custom(); |
| 108 |
Custom_List = new List<Symbol_Custom>(); |
|
| 102 |
} |
|
| 103 |
lstSymbolPrivate.ItemsSource = Custom_List; |
|
| 109 | 104 |
|
| 110 |
deptlist.ItemsSource = Entity.SYMBOL_PUBLIC.Select(data => data.DEPARTMENT).ToList(); |
|
| 105 |
Custom = new Symbol_Custom(); |
|
| 106 |
Custom_List = new List<Symbol_Custom>(); |
|
| 111 | 107 |
|
| 112 |
var symbol_Public = Entity.SYMBOL_PUBLIC.ToList();
|
|
| 108 |
deptlist.ItemsSource = client.GetPublicSymbolDeptList();
|
|
| 113 | 109 |
|
| 114 |
if (deptlist.SelectedValue != null) |
|
| 115 |
{
|
|
| 116 |
symbol_Public = symbol_Public.Where(data => data.DEPARTMENT == deptlist.SelectedValue.ToString()).ToList(); |
|
| 117 |
} |
|
| 118 |
//var symbol_Public = Entity.SYMBOL_PUBLIC.Where(data => data.DEPARTMENT == "PIPING").ToList(); |
|
| 110 |
List<SYMBOL_PUBLIC> symbol_Public; |
|
| 119 | 111 |
|
| 120 |
foreach (var item in symbol_Public) |
|
| 121 |
{
|
|
| 122 |
Custom.Name = item.NAME; |
|
| 123 |
Custom.ImageUri = item.IMAGE_URL; |
|
| 124 |
Custom.ID = item.ID; |
|
| 125 |
Custom_List.Add(Custom); |
|
| 126 |
Custom = new Symbol_Custom(); |
|
| 127 |
} |
|
| 128 |
lstSymbolPublic.ItemsSource = Custom_List; |
|
| 112 |
|
|
| 113 |
if (deptlist.SelectedValue != null) |
|
| 114 |
{
|
|
| 115 |
symbol_Public = client.GetPublicSymbolList(deptlist.SelectedValue.ToString()); |
|
| 116 |
} |
|
| 117 |
else |
|
| 118 |
{
|
|
| 119 |
symbol_Public = client.GetPublicSymbolList(null); |
|
| 120 |
} |
|
| 121 |
foreach (var item in symbol_Public) |
|
| 122 |
{
|
|
| 123 |
Custom.Name = item.NAME; |
|
| 124 |
Custom.ImageUri = item.IMAGE_URL; |
|
| 125 |
Custom.ID = item.ID; |
|
| 126 |
Custom_List.Add(Custom); |
|
| 127 |
Custom = new Symbol_Custom(); |
|
| 129 | 128 |
} |
| 129 |
lstSymbolPublic.ItemsSource = Custom_List; |
|
| 130 |
client.Close(); |
|
| 130 | 131 |
} |
| 131 | 132 |
|
| 132 | 133 |
public PngBitmapEncoder symImage(string data) |
| ... | ... | |
| 277 | 278 |
DialogMessage_Alert("Please Select Symbol", "Alert");
|
| 278 | 279 |
return; |
| 279 | 280 |
} |
| 281 |
string delItem_ID = (lstSymbolPrivate.SelectedItem as Symbol_Custom).ID; |
|
| 282 |
Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.DeleteSymbolCompleted += BaseClient_DeleteSymbolCompleted; |
|
| 283 |
Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.DeleteSymbolAsync(delItem_ID); |
|
| 284 |
|
|
| 285 |
} |
|
| 280 | 286 |
|
| 281 |
using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString())) |
|
| 282 |
{
|
|
| 283 |
string delItem_ID = (lstSymbolPrivate.SelectedItem as Symbol_Custom).ID; |
|
| 284 |
var delitem = Entity.SYMBOL_PRIVATE.Where(data => data.ID == delItem_ID).FirstOrDefault(); |
|
| 285 |
Entity.SYMBOL_PRIVATE.DeleteObject(delitem); |
|
| 286 |
Entity.SaveChanges(); |
|
| 287 |
|
|
| 288 |
DataBind(); |
|
| 289 |
} |
|
| 287 |
private void BaseClient_DeleteSymbolCompleted(object sender, ServiceDeepView.DeleteSymbolCompletedEventArgs e) |
|
| 288 |
{
|
|
| 289 |
DataBind(); |
|
| 290 | 290 |
} |
| 291 | 291 |
#endregion |
| 292 | 292 |
|
| ... | ... | |
| 301 | 301 |
|
| 302 | 302 |
try |
| 303 | 303 |
{
|
| 304 |
using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString())) |
|
| 305 |
{
|
|
| 306 |
if (RadTab.SelectedIndex == 0) |
|
| 307 |
Data_ = Entity.SYMBOL_PRIVATE.Where(data => data.ID == id).FirstOrDefault().DATA; |
|
| 308 |
else |
|
| 309 |
Data_ = Entity.SYMBOL_PUBLIC.Where(data => data.ID == id).FirstOrDefault().DATA; |
|
| 310 |
} |
|
| 304 |
Data_ = Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.GetSymbolData(id, RadTab.SelectedIndex); |
|
| 311 | 305 |
|
| 312 | 306 |
if (Data_.Contains("|DZ|"))
|
| 313 | 307 |
{
|
| ... | ... | |
| 381 | 375 |
{
|
| 382 | 376 |
if (args.DialogResult != null && args.DialogResult.Value) |
| 383 | 377 |
{
|
| 384 |
using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString())) |
|
| 385 |
{
|
|
| 386 |
string ID = (lstSymbolPrivate.SelectedItem as Symbol_Custom).ID; |
|
| 387 |
var UpdateItem = Entity.SYMBOL_PRIVATE.Where(info => info.ID == ID).FirstOrDefault(); |
|
| 388 |
|
|
| 389 |
UpdateItem.NAME = args.PromptResult; |
|
| 390 |
Entity.SaveChanges(); |
|
| 391 |
DataBind(); |
|
| 392 |
//args.PromptResult |
|
| 393 |
} |
|
| 378 |
string _id = (lstSymbolPrivate.SelectedItem as Symbol_Custom).ID; |
|
| 379 |
string _name = args.PromptResult; |
|
| 380 |
|
|
| 381 |
Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.RenameSymbolCompleted += BaseClient_RenameSymbolCompleted; |
|
| 382 |
Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.RenameSymbolAsync(_id, _name); |
|
| 383 |
|
|
| 394 | 384 |
} |
| 395 | 385 |
} |
| 386 |
|
|
| 387 |
private void BaseClient_RenameSymbolCompleted(object sender, ServiceDeepView.RenameSymbolCompletedEventArgs e) |
|
| 388 |
{
|
|
| 389 |
DataBind(); |
|
| 390 |
} |
|
| 396 | 391 |
#endregion |
| 397 | 392 |
|
| 398 | 393 |
#region Wheel Event |
내보내기 Unified diff
