DIXWeb.git - Gitblit

duan

2024-08-21 f71a02229c1ba00fbecaead19256593ffb052753

提交 \| 用户 \| age
1063f3	1	using DIXPad.DataProtocol;
J	2	using DIXPadWPF.Helper;
	3	using DIXWeb.Business.MySQLBiz;
	4	using DIXWeb.DataRepository;
	5	using DIXWeb.Entity.MySQLEntity;
	6	using DIXWeb.Util;
	7	using System;
	8	using System.Collections.Generic;
	9	using System.Data;
	10	using System.Linq;
	11	using System.Text;
	12	using System.Threading.Tasks;
	13	using System.Windows;
	14	using System.Windows.Controls;
	15	using System.Windows.Data;
	16	using System.Windows.Documents;
	17	using System.Windows.Input;
	18	using System.Windows.Media;
	19	using System.Windows.Media.Imaging;
	20	using System.Windows.Navigation;
	21	using System.Windows.Shapes;
	22
	23	namespace DIXPadWPF
	24	{
	25	/// <summary>
	26	/// DixPadUpLoad.xaml 的交互逻辑
	27	/// </summary>
	28	public partial class DixPadUpLoad : Page
	29	{
	30	MySQLInspectAreaBiz ABIZ = null;
	31	MySQLInspectObjectTypeBiz BIZ = null;
	32	MySQLInspectObjectBiz OBIZ = null;
	33	MySQLInspectBaseBiz BBIZ = null;
	34	MySQLInspectFrequencyBiz BFZ = null;
	35	string _ServiceUrl { get; set; } = "";
	36	public DixPadUpLoad()
	37	{
	38	InitializeComponent();
	39	_ServiceUrl = System.Configuration.ConfigurationManager.AppSettings["ServiceUrl"].ToString();
	40	ABIZ = new MySQLInspectAreaBiz();
	41	OBIZ = new MySQLInspectObjectBiz();
	42	BBIZ = new MySQLInspectBaseBiz();
	43	BIZ = new MySQLInspectObjectTypeBiz();
	44	BFZ = new MySQLInspectFrequencyBiz();
	45	}
	46
	47	private void btnSearch_Click(object sender, RoutedEventArgs e)
	48	{
	49	string inspectobjecttype = cbInspectObjectType.Text;
	50	string inspectArea = cbInspectArea.Text;
	51	string inspectFreq = cbInspectFreq.Text;
	52	DataTable dt = OBIZ.GetAllInspectedItem(inspectobjecttype, inspectArea, inspectFreq);
	53	UploadDataGrid.ItemsSource = dt.DefaultView;
	54	cbInspectObjectType.SelectedIndex = -1;
	55	cbInspectArea.SelectedIndex = -1;
	56	cbInspectFreq.SelectedIndex = -1;
	57	}
	58	public void GetInspectObjectType()
	59	{
	60	cbInspectObjectType.Items.Clear();
	61	cbInspectObjectType.Items.Add("全选");
	62	List<MySQLInspectObjectType> list = BIZ.GetDataList("", "", new Pagination());
	63	if (list.Count > 0)
	64	{
	65	for (int i = 0; i < list.Count; i++)
	66	{
	67	string typename = list[i].Name;
	68	cbInspectObjectType.Items.Add(typename);
	69	}
	70	}
	71	}
	72	public void GetInspectArea()
	73	{
	74	cbInspectArea.Items.Clear();
	75	cbInspectArea.Items.Add("全选");
	76	List<MySQLInspectArea> list = ABIZ.GetDataList(0, new Pagination());
	77	if (list.Count > 0)
	78	{
	79	for (int i = 0; i < list.Count; i++)
	80	{
	81	string typename = list[i].Name;
	82	cbInspectArea.Items.Add(typename);
	83	}
	84	}
	85	}
	86	public void GetInspectFreq()
	87	{
	88	cbInspectFreq.Items.Clear();
	89	cbInspectFreq.Items.Add("全选");
	90	List<MySQLInspectFrequency> list = BFZ.GetDataList(0, new Pagination());
	91	if (list.Count > 0)
	92	{
	93	for (int i = 0; i < list.Count; i++)
	94	{
	95	string typename = list[i].Frequency;
	96	cbInspectFreq.Items.Add(typename);
	97	}
	98	}
	99	}
	100	private void btnUpLoad_Click(object sender, RoutedEventArgs e)
	101	{
b347b1	102	try
1063f3	103	{
b347b1	104	ResultMessage r = NetWorkCheck.NetWorkCheckResult();
J	105	if (r.Count < 0)
a70742	106	{
b347b1	107	MessageBox.Show(r.Msg, "Warning！", MessageBoxButton.OK, MessageBoxImage.Warning);
J	108	}
	109	else
	110	{
	111	DataTable dtinfo = BBIZ.GetInspectedItems();
	112	if (dtinfo.Rows.Count > 0)
a70742	113	{
b347b1	114	string sn = Guid.NewGuid().ToString();
J	115	DIXPad.RSLC.BizServiceProxy localProxy = new DIXPad.RSLC.BizServiceProxy(_ServiceUrl);
	116	DataTable table = new DataTable(Guid.NewGuid().ToString());
	117	table.Columns.Add("sn", typeof(string));
	118	table.Columns.Add("InspectObjectId", typeof(int));
	119	table.Columns.Add("InspectItemId", typeof(int));
	120	table.Columns.Add("CheckType", typeof(string));
	121	table.Columns.Add("InspectLimit", typeof(double));
	122	table.Columns.Add("NGReason", typeof(string));
	123	table.Columns.Add("TotalJudge", typeof(bool));
	124	table.Columns.Add("InspectTimes", typeof(int));
	125	table.Columns.Add("CreateTime", typeof(DateTime));
	126	table.Columns.Add("InspectOperator", typeof(string));
	127	table.Columns.Add("IsImprovedOnSite", typeof(bool));
	128	table.Columns.Add("DealDetial", typeof(string));
	129	table.Columns.Add("ReInspectTimes", typeof(int));
	130	table.Columns.Add("ImgString", typeof(string));
	131	table.Columns.Add("IsBackup", typeof(int));
	132	for (int i = 0; i < dtinfo.Rows.Count; i++)
a70742	133	{
b347b1	134	DataRow dr = table.NewRow();
J	135	dr["sn"] = sn;
	136	dr["InspectObjectId"] = Convert.ToInt32(dtinfo.Rows[i]["InspectObjectId"].ToString());
	137	dr["InspectItemId"] = Convert.ToInt32(dtinfo.Rows[i]["InspectItemId"].ToString());
	138	dr["CheckType"] = dtinfo.Rows[i]["CheckType"].ToString();
	139	dr["InspectLimit"] = double.Parse(dtinfo.Rows[i]["InspectLimit"].ToString());
	140	dr["NGReason"] = dtinfo.Rows[i]["NGReason"].ToString();
	141	string judge = dtinfo.Rows[i]["TotalJudge"].ToString();
	142	if (judge == "True")
	143	{
	144	dr["TotalJudge"] = true;
	145	}
	146	else
	147	{
	148	dr["TotalJudge"] = false;
	149	}
	150	dr["InspectTimes"] = Convert.ToInt32(dtinfo.Rows[i]["InspectTimes"].ToString());
	151	dr["CreateTime"] = Convert.ToDateTime(dtinfo.Rows[i]["CreateTime"].ToString());
	152	dr["InspectOperator"] = dtinfo.Rows[i]["InspectOperator"];
	153	string improved = dtinfo.Rows[i]["IsImprovedOnSite"].ToString();
	154	if (improved == "1")
	155	{
	156	dr["IsImprovedOnSite"] = true;
	157	}
	158	else
	159	{
	160	dr["IsImprovedOnSite"] = false;
	161	}
	162	dr["DealDetial"] = dtinfo.Rows[i]["DealDetial"];
	163	dr["ReInspectTimes"] = Convert.ToInt32(dtinfo.Rows[i]["ReInspectTimes"]);
	164	if (dtinfo.Rows[i]["ImgString"].ToString() == "")
	165	{
	166	dr["ImgString"] = "";
	167	}
	168	else
	169	{
	170	dr["ImgString"] = dtinfo.Rows[i]["ImgString"].ToString();
	171	}
	172	dr["IsBackup"] = Convert.ToInt32(dtinfo.Rows[i]["isbackup"].ToString());
	173	table.Rows.Add(dr);
a70742	174	}
J	175
b347b1	176	Dictionary<string, string> dir = new Dictionary<string, string>();
J	177	dir.Add("sn", "sn");
	178	dir.Add("InspectObjectId", "InspectObjectId");
	179	dir.Add("InspectItemId", "InspectItemId");
	180	dir.Add("CheckType", "CheckType");
	181	dir.Add("InspectLimit", "InspectLimit");
	182	dir.Add("NGReason", "NGReason");
	183	dir.Add("TotalJudge", "TotalJudge");
	184	dir.Add("InspectTimes", "InspectTimes");
	185	dir.Add("CreateTime", "CreateTime");
	186	dir.Add("InspectOperator", "InspectOperator");
	187	dir.Add("IsImprovedOnSite", "IsImprovedOnSite");
	188	dir.Add("DealDetial", "DealDetial");
	189	dir.Add("ReInspectTimes", "ReInspectTimes");
	190	dir.Add("ImgString", "ImgString");
	191	dir.Add("IsBackup", "IsBackup");
	192	Dictionary<string, object> pdir = new Dictionary<string, object>();
	193	pdir.Add("@sn", sn);
a70742	194
b347b1	195	string imgsn = Guid.NewGuid().ToString();
J	196	DataTable dtimg = BBIZ.GetImageItems();
	197	DataTable imgtable = new DataTable(Guid.NewGuid().ToString());
	198	imgtable.Columns.Add("TableSN", typeof(string));
	199	imgtable.Columns.Add("SN", typeof(string));
	200	imgtable.Columns.Add("ImgId", typeof(int));
	201	imgtable.Columns.Add("ImgString", typeof(string));
	202	for (int i = 0; i < dtimg.Rows.Count; i++)
a70742	203	{
b347b1	204	DataRow dr = imgtable.NewRow();
J	205	dr["TableSN"] = imgsn;
	206	dr["SN"] = dtimg.Rows[i]["SN"].ToString();
	207	dr["ImgId"] = Convert.ToInt32(dtimg.Rows[i]["ImgId"].ToString());
	208	dr["ImgString"] = dtimg.Rows[i]["ImgString"].ToString();
	209	imgtable.Rows.Add(dr);
	210	}
	211	Dictionary<string, string> imgdir = new Dictionary<string, string>();
	212	imgdir.Add("TableSN", "TableSN");
	213	imgdir.Add("SN", "SN");
	214	imgdir.Add("ImgId", "ImgId");
	215	imgdir.Add("ImgString", "ImgString");
	216	Dictionary<string, object> idir = new Dictionary<string, object>();
	217	idir.Add("@sn", imgsn);
	218
	219	MsgObject msg = localProxy.WSBulkCopyDataToDBWithHook(table, "InspectItemInfoDetial", dir, pdir, "yp_InspectItemInfo_bk2", DIXPad.RSLC.DBKeys.DIX);
	220	if (msg.Count > 0)
	221	{
	222	MsgObject msg1 = localProxy.WSBulkCopyDataToDBWithHook(imgtable, "ItemImgDetial", imgdir, idir, "yp_GetImageList", DIXPad.RSLC.DBKeys.DIX);
	223	if (msg1.Count > 0)
	224	{
	225	BBIZ.UpdateInspectedItems();
	226	MessageBox.Show("点检数据上传至服务端成功!", "上传成功", MessageBoxButton.OK, MessageBoxImage.Information);
	227	DataTable dt = OBIZ.GetAllInspectedItem("", "", "");
	228	UploadDataGrid.ItemsSource = dt.DefaultView;
	229	}
	230	else
	231	{
	232	MessageBox.Show("点检数据上传至服务端失败!" + msg1.Msg, "上传失败", MessageBoxButton.OK, MessageBoxImage.Error);
	233	}
a70742	234	}
J	235	else
	236	{
b347b1	237	MessageBox.Show("点检数据上传至服务端失败!" + msg.Msg, "上传失败", MessageBoxButton.OK, MessageBoxImage.Error);
a70742	238	}
J	239	}
	240	else
	241	{
b347b1	242	MessageBox.Show("当前无可上传的点检数据！请点检其他设备后再进行上传！", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
a70742	243	}
J	244	}
	245	}
b347b1	246	catch (Exception er)
J	247	{
	248	MessageBox.Show(er.Message, "Warning！", MessageBoxButton.OK, MessageBoxImage.Warning);
	249	}
	250	}
a70742	251
J	252	private void Page_Loaded(object sender, RoutedEventArgs e)
	253	{
	254	try
	255	{
1063f3	256	DataTable dt = OBIZ.GetAllInspectedItem("", "", "");
J	257	UploadDataGrid.ItemsSource = dt.DefaultView;
a70742	258	}
J	259	catch (Exception ex)
	260	{
	261	MessageBox.Show(ex.Message);
1063f3	262	}
J	263	}
	264
	265	private void btnChange_Click(object sender, RoutedEventArgs e)
	266	{
	267	var a = UploadDataGrid.CurrentItem as DataRowView;
	268	if (a != null)
	269	{
	270	MySQLInspectTypeBiz TBIZ = new MySQLInspectTypeBiz();
a70742	271	string inspecttypes = a.Row[3].ToString();
8a90d9	272	string loadstatus= a.Row[0].ToString();
a70742	273	string code = a.Row[5].ToString();
J	274	int times = Convert.ToInt32(a.Row[11].ToString());
1063f3	275	List<MySQLInspectObject> list = OBIZ.GetDataList("InspectObjectCode", code, new Pagination());
J	276	if (list.Count > 0)
	277	{
d95063	278	for (int i = 0; i < list.Count; i++)
J	279	{
	280	int inspecttypeid = list[i].InspectTypeId;
	281	List<MySQLInspectType> tlist = TBIZ.GetDataList(inspecttypeid, new Pagination());
	282	string inspecttypestr = tlist[0].Name;
	283	if (inspecttypestr == inspecttypes)
	284	{
edc224	285	DIXPadInspectItemPage dpi = new DIXPadInspectItemPage();
J	286	dpi.mpcObject = list[i];
d95063	287	dpi.InspectTimes = times;
J	288	dpi.Code = "Update";
	289	dpi.loadstatus = loadstatus;
a70742	290	dpi.createtime = Convert.ToDateTime(a.Row[12].ToString());
edc224	291	this.NavigationService.Navigate(dpi);
d95063	292	}
J	293	}
1063f3	294	}
J	295	}
	296	}
	297
	298	private void cbInspectObjectType_DropDownOpened(object sender, EventArgs e)
	299	{
	300	GetInspectObjectType();
	301	}
	302
	303	private void cbInspectArea_DropDownOpened(object sender, EventArgs e)
	304	{
	305	GetInspectArea();
	306	}
	307
	308	private void cbInspectFreq_DropDownOpened(object sender, EventArgs e)
	309	{
	310	GetInspectFreq();
	311	}
	312	}
	313	}