From ec44b893b2d267cc84d0aa44c65621c53f504dbc Mon Sep 17 00:00:00 2001
From: cdk <2441919651@qq.com>
Date: 星期三, 24 九月 2025 10:42:00 +0800
Subject: [PATCH] 增加考勤表导出功能
---
DevApp/Gs.DevApp/DevFrm/Sys/Frm_Config.cs | 32 ++++++++++++++++++++++++++++++++
1 files changed, 32 insertions(+), 0 deletions(-)
diff --git a/DevApp/Gs.DevApp/DevFrm/Sys/Frm_Config.cs b/DevApp/Gs.DevApp/DevFrm/Sys/Frm_Config.cs
index 4a55b0b..aa13eb8 100644
--- a/DevApp/Gs.DevApp/DevFrm/Sys/Frm_Config.cs
+++ b/DevApp/Gs.DevApp/DevFrm/Sys/Frm_Config.cs
@@ -54,6 +54,17 @@
//榻愬鍏ュ簱
sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
sb.Append(" values(newid(),'" + lb_qtRk.Text.Trim() + "','" + txt_qtRk.Text.Trim() + "','" + layoutControlItem18.Text.Trim() + "')");
+ //棰滆壊
+ sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
+ sb.Append(" values(newid(),'" + lb_colorFinish.Text.Trim() + "','" + txt_colorFinish.Text.Trim() + "','" + layoutControlItem20.Text.Trim() + "')");
+ sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
+ sb.Append(" values(newid(),'" + lb_colorIng.Text.Trim() + "','" + txt_colorIng.Text.Trim() + "','" + layoutControlItem21.Text.Trim() + "')");
+ sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
+ sb.Append(" values(newid(),'" + lb_color.Text.Trim() + "','" + txt_color.Text.Trim() + "','" + layoutControlItem22.Text.Trim() + "')");
+ //鍏堣繘鍏堝嚭
+ sb.Append(" insert into [dbo].[MES_CONFIG](guid,parameter,parameterValue,remark) ");
+ sb.Append(" values(newid(),'" +lb_OutsXjxc.Text.Trim() + "','" + txt_OutsXjxc.Text.Trim() + "','" + layoutControlItem26.Text.Trim() + "')");
+
var _obj = new
{
sql = sb.ToString(),
@@ -139,6 +150,27 @@
txt_qtRk.Text = row["parameterValue"].ToString();
continue;
}
+
+ if (row["remark"].ToString() == layoutControlItem20.Text)
+ {
+ txt_colorFinish.Text = row["parameterValue"].ToString();
+ continue;
+ }
+ if (row["remark"].ToString() == layoutControlItem21.Text)
+ {
+ txt_colorIng.Text = row["parameterValue"].ToString();
+ continue;
+ }
+ if (row["remark"].ToString() == layoutControlItem22.Text)
+ {
+ txt_color.Text = row["parameterValue"].ToString();
+ continue;
+ }
+ if (row["remark"].ToString() == layoutControlItem26.Text)
+ {
+ txt_OutsXjxc.Text = row["parameterValue"].ToString();
+ continue;
+ }
}
}
else
--
Gitblit v1.9.3