Frm_LocationStatusChange.xaml.cs
1.94 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
using HHWCS.Bll;
using HHWCS.Model;
using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
namespace HHWCSHost.View.Location
{
/// <summary>
/// Frm_LocationStatusChange.xaml 的交互逻辑
/// </summary>
public partial class Frm_LocationStatusChange : Window
{
public List<string> LocationCodes { get; set; }
public Frm_LocationStatusChange(List<string> list)
{
InitializeComponent();
LocationCodes = list;
cbx_status.ItemsSource = AppCommon.GetLocationStatus();
cbx_status.DisplayMemberPath = "Value";
cbx_status.SelectedValuePath = "Key";
cbx_status.SelectedIndex = 0;
txt_LocaiontIds.Text = String.Join(",", list.ToArray());
}
private void btn_Cancel_Click(object sender, RoutedEventArgs e)
{
this.Close();
}
private void btn_Verify_Click(object sender, RoutedEventArgs e)
{
try
{
String sql = "update location set `status` = '" + cbx_status.SelectedValue.ToString() + "' where code in ('" + String.Join(",", LocationCodes.ToArray()) + "')";
int i = MySqlHelper.ExecuteNonQuery(AppCommon.ConnectionString, sql);
if (i > 0)
{
MessageBox.Show("更新成功");
}
else
{
MessageBox.Show("更新失败");
}
}
catch (Exception ex)
{
MessageBox.Show("更新出现异常：" + ex.ToString());
}
}
}
}