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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
| private void Button_Click_1(object sender, RoutedEventArgs e)
{
var p = dg.SelectedItem as Zzfzz;
var x = xm.SelectedItem as jjkcsoft.Models.Xm;
var x1 = nd.SelectedItem as jjkcsoft.Models.Nd;
var pzh = "";
var zy = "";
var kmbh = "";
double dfje = 0;
double jfje = 0;
double ye = 0;
DateTime v_kssj, v_jssj;
if (p == null)
{
var result = MessageBoxX.Show("请选择要更新的行", "Warning", Application.Current.MainWindow, MessageBoxButton.OK, new MessageBoxXConfigurations()
{
MessageBoxIcon = MessageBoxIcon.Warning,
ButtonBrush = "#F1C825".ToColor().ToBrush(),
});
return;
}
using (var conn = DbHelper.getCon())
{
int count = conn.Query<int>("select * from TAB where id=@id", new { id = p.id }).FirstOrDefault();
int gs = conn.Query<int>("select count(1) from TAB where xmbh=@xmbh and kmbh=@kmbh and nd=@nd", new { xmbh = x.xmbh ,kmbh=p.kmbh ,nd=x1.nd}).FirstOrDefault();
gs = gs + 1;
switch (p.kmbh)
{
case "8.1":
kmbh = p.kmbh;
v_kssj = p.sj.AddDays(1 - p.sj.Day);
v_jssj = p.sj.AddDays(1 - p.sj.Day).AddMonths(1).AddDays(-1);
dfje = conn.Query<double>("select sum(jejf) from TAB where xmbh=@xmbh and kmbh not in ('8.1','8.2','8.3') and nd=@nd and sj>=@kssj and sj<=@jssj", new { xmbh = x.xmbh, nd = x1.nd, kssj = v_kssj, jssj = v_jssj }).FirstOrDefault();
pzh = "结-" + p.sj.ToString("MM") + gs.ToString().PadLeft(2, '0');
break;
case "8.2":
kmbh = p.kmbh;
v_kssj = p.sj.AddDays(1 - p.sj.Day);
v_jssj = p.sj.AddDays(1 - p.sj.Day).AddMonths(1).AddDays(-1);
jfje = conn.Query<double>("select sum(jejf) from TAB where xmbh=@xmbh and kmbh not in ('8.1','8.2','8.3') and nd=@nd and sj>=@kssj and sj<=@jssj", new { xmbh = x.xmbh, nd = x1.nd, kssj = v_kssj, jssj = v_jssj }).FirstOrDefault();
dfje = conn.Query<double>("select sum(jedf) from TAB where xmbh=@xmbh and kmbh not in ('8.1','8.2','8.3') and nd=@nd and sj>=@kssj and sj<=@jssj", new { xmbh = x.xmbh, nd = x1.nd, kssj = v_kssj, jssj = v_jssj }).FirstOrDefault();
zy = "本月合计";
break;
case "8.3":
kmbh = p.kmbh;
v_kssj = DateTime.Parse(p.sj.ToString("yyyy-01-01"));
v_jssj=DateTime.Parse(p.sj.ToString("yyyy-01-01")).AddYears(1).AddDays(-1);
jfje = conn.Query<double>("select sum(jejf) from TAB where xmbh=@xmbh and kmbh not in ('8.1','8.2','8.3') and nd=@nd and sj>=@kssj and sj<=@jssj", new { xmbh = x.xmbh, nd = x1.nd, kssj = v_kssj, jssj = v_jssj }).FirstOrDefault();
dfje = conn.Query<double>("select sum(jedf) from TAB where xmbh=@xmbh and kmbh not in ('8.1','8.2','8.3') and nd=@nd and sj>=@kssj and sj<=@jssj", new { xmbh = x.xmbh, nd = x1.nd, kssj = v_kssj, jssj = v_jssj }).FirstOrDefault();
zy = "本年累计";
break;
default:
pzh = p.kmbh + "-" + p.sj.ToString("MM") + gs.ToString().PadLeft(2, '0');
zy = p.zy;
kmbh = p.kmbh;
dfje = p.jedf;
jfje = p.jejf;
ye = p.ye;
break;
}
if (count == 0)
{
conn.Execute("insert into TAB(c1,c2,c3) values(@c1,@c2,@c3)", new
{c1=c1,c2=c2,c3=c3
});
}
else
{
conn.Execute("update TAB set c1=@c1,c2=@c2 where id=@id", new
{
{c1=c1,c2=c2,c3=c3
});
}
var result = MessageBoxX.Show("保存成功", "Success", Application.Current.MainWindow, MessageBoxButton.OK, new MessageBoxXConfigurations()
{
MessageBoxIcon = MessageBoxIcon.Success,
ButtonBrush = "#75CD43".ToColor().ToBrush(),
});
}
}
|
