diff --git a/RbFreqStandMeasure/R_DataBase/Service/Impl/DeviceServiceImpl.cs b/RbFreqStandMeasure/R_DataBase/Service/Impl/DeviceServiceImpl.cs index b2213e4..2fc89ad 100644 --- a/RbFreqStandMeasure/R_DataBase/Service/Impl/DeviceServiceImpl.cs +++ b/RbFreqStandMeasure/R_DataBase/Service/Impl/DeviceServiceImpl.cs @@ -486,54 +486,73 @@ adap.Fill(dt); if (dt != null && dt.Rows.Count > 0) { + DeviceView deviceView = new DeviceView(); + if(dt.Rows[0][0] != DBNull.Value) deviceView.Id = Convert.ToInt64(dt.Rows[0][0]); + if (dt.Rows[0][1] != DBNull.Value) deviceView.DevName = dt.Rows[0][1].ToString(); + if (dt.Rows[0][2] != DBNull.Value) deviceView.DevCode = dt.Rows[0][2].ToString(); + if (dt.Rows[0][3] != DBNull.Value) deviceView.DevTypeId = dt.Rows[0][3].ToString(); + if (dt.Rows[0][4] != DBNull.Value) deviceView.DevModel = dt.Rows[0][4].ToString(); + if (dt.Rows[0][5] != DBNull.Value) deviceView.RegTime = dt.Rows[0][5].ToString(); + if (dt.Rows[0][6] != DBNull.Value) deviceView.CustomerName = dt.Rows[0][6].ToString(); + if (dt.Rows[0][7] != DBNull.Value) deviceView.CustomerDev = dt.Rows[0][7].ToString(); + if (dt.Rows[0][8] != DBNull.Value) deviceView.Channel = dt.Rows[0][8].ToString(); + if (dt.Rows[0][9] != DBNull.Value) deviceView.Active = Convert.ToInt32(dt.Rows[0][9]); + if (dt.Rows[0][10] != DBNull.Value) deviceView.StartTime = Convert.ToDateTime(dt.Rows[0][10]).ToString("yyyy - MM - dd HH: mm:ss"); + if (dt.Rows[0][11] != DBNull.Value) deviceView.EndTime = Convert.ToDateTime(dt.Rows[0][11]).ToString("yyyy - MM - dd HH: mm:ss"); + if (dt.Rows[0][12] != DBNull.Value) deviceView.StatusId = dt.Rows[0][12].ToString(); + if (dt.Rows[0][13] != DBNull.Value) deviceView.Stability = dt.Rows[0][13].ToString(); + if (dt.Rows[0][14] != DBNull.Value) deviceView.Accuracy = dt.Rows[0][14].ToString(); + if (dt.Rows[0][15] != DBNull.Value) deviceView.BootFeature = dt.Rows[0][15].ToString(); + if (dt.Rows[0][16] != DBNull.Value) deviceView.AgeRate = dt.Rows[0][16].ToString(); + if (dt.Rows[0][17] != DBNull.Value) deviceView.DetectionItemId = Convert.ToInt64(dt.Rows[0][17]); } - using (MySqlDataReader aReader = aCommand.ExecuteReader()) - { - while (aReader.Read()) - { - DeviceView deviceView = new DeviceView(); + //using (MySqlDataReader aReader = aCommand.ExecuteReader()) + //{ + // while (aReader.Read()) + // { + // DeviceView deviceView = new DeviceView(); - if (!aReader.IsDBNull(0)) deviceView.Id = Convert.ToInt64(aReader.GetString(0)); // id - if (!aReader.IsDBNull(1)) deviceView.DevName = aReader.GetString(1); // devName - if (!aReader.IsDBNull(2)) deviceView.DevCode = aReader.GetString(2); // devCode - if (!aReader.IsDBNull(3)) - { - deviceView.DevTypeId = aReader.GetString(3); // devType - //deviceView.DevTypeName = dictService.getNameByCode("devType", aReader.GetString(3)); - } - if (!aReader.IsDBNull(4)) deviceView.DevModel = aReader.GetString(4); // devModel - if (!aReader.IsDBNull(5)) - { - DateTime reg = aReader.GetDateTime(5); // regTime - deviceView.RegTime = reg.ToString("yyyy-MM-dd"); - } - if (!aReader.IsDBNull(6)) deviceView.CustomerName = aReader.GetString(6); // customName - if (!aReader.IsDBNull(7)) deviceView.CustomerDev = aReader.GetString(7); // customDev - if (!aReader.IsDBNull(8)) deviceView.Channel = aReader.GetString(8); - if (!aReader.IsDBNull(9)) deviceView.Active = Convert.ToInt32(aReader.GetString(9)); - if (!aReader.IsDBNull(10)) - { - DateTime reg = aReader.GetDateTime(10); // regTime - deviceView.StartTime = reg.ToString("yyyy-MM-dd HH:mm:ss"); - } - if (!aReader.IsDBNull(11)) - { - DateTime reg = aReader.GetDateTime(11); // regTime - deviceView.EndTime = reg.ToString("yyyy-MM-dd HH:mm:ss"); - } - if (!aReader.IsDBNull(12)) deviceView.StatusId = aReader.GetString(12); - if (!aReader.IsDBNull(13)) deviceView.Stability = aReader.GetString(13); - if (!aReader.IsDBNull(14)) deviceView.Accuracy = aReader.GetString(14); - if (!aReader.IsDBNull(15)) deviceView.BootFeature = aReader.GetString(15); - if (!aReader.IsDBNull(16)) deviceView.AgeRate = aReader.GetString(16); - if (!aReader.IsDBNull(17)) deviceView.DetectionItemId = Convert.ToInt64(aReader.GetString(17)); + // if (!aReader.IsDBNull(0)) deviceView.Id = Convert.ToInt64(aReader.GetString(0)); // id + // if (!aReader.IsDBNull(1)) deviceView.DevName = aReader.GetString(1); // devName + // if (!aReader.IsDBNull(2)) deviceView.DevCode = aReader.GetString(2); // devCode + // if (!aReader.IsDBNull(3)) + // { + // deviceView.DevTypeId = aReader.GetString(3); // devType + // //deviceView.DevTypeName = dictService.getNameByCode("devType", aReader.GetString(3)); + // } + // if (!aReader.IsDBNull(4)) deviceView.DevModel = aReader.GetString(4); // devModel + // if (!aReader.IsDBNull(5)) + // { + // DateTime reg = aReader.GetDateTime(5); // regTime + // deviceView.RegTime = reg.ToString("yyyy-MM-dd"); + // } + // if (!aReader.IsDBNull(6)) deviceView.CustomerName = aReader.GetString(6); // customName + // if (!aReader.IsDBNull(7)) deviceView.CustomerDev = aReader.GetString(7); // customDev + // if (!aReader.IsDBNull(8)) deviceView.Channel = aReader.GetString(8); + // if (!aReader.IsDBNull(9)) deviceView.Active = Convert.ToInt32(aReader.GetString(9)); + // if (!aReader.IsDBNull(10)) + // { + // DateTime reg = aReader.GetDateTime(10); // regTime + // deviceView.StartTime = reg.ToString("yyyy-MM-dd HH:mm:ss"); + // } + // if (!aReader.IsDBNull(11)) + // { + // DateTime reg = aReader.GetDateTime(11); // regTime + // deviceView.EndTime = reg.ToString("yyyy-MM-dd HH:mm:ss"); + // } + // if (!aReader.IsDBNull(12)) deviceView.StatusId = aReader.GetString(12); + // if (!aReader.IsDBNull(13)) deviceView.Stability = aReader.GetString(13); + // if (!aReader.IsDBNull(14)) deviceView.Accuracy = aReader.GetString(14); + // if (!aReader.IsDBNull(15)) deviceView.BootFeature = aReader.GetString(15); + // if (!aReader.IsDBNull(16)) deviceView.AgeRate = aReader.GetString(16); + // if (!aReader.IsDBNull(17)) deviceView.DetectionItemId = Convert.ToInt64(aReader.GetString(17)); - deviceViewList.Add(deviceView); + // deviceViewList.Add(deviceView); - aCommand.Dispose(); - } - } + // aCommand.Dispose(); + // } + //} if (deviceViewList.Count > 0) { diff --git a/RbFreqStandMeasure/R_DataBase/Service/Impl/DeviceServiceImpl.cs b/RbFreqStandMeasure/R_DataBase/Service/Impl/DeviceServiceImpl.cs index b2213e4..2fc89ad 100644 --- a/RbFreqStandMeasure/R_DataBase/Service/Impl/DeviceServiceImpl.cs +++ b/RbFreqStandMeasure/R_DataBase/Service/Impl/DeviceServiceImpl.cs @@ -486,54 +486,73 @@ adap.Fill(dt); if (dt != null && dt.Rows.Count > 0) { + DeviceView deviceView = new DeviceView(); + if(dt.Rows[0][0] != DBNull.Value) deviceView.Id = Convert.ToInt64(dt.Rows[0][0]); + if (dt.Rows[0][1] != DBNull.Value) deviceView.DevName = dt.Rows[0][1].ToString(); + if (dt.Rows[0][2] != DBNull.Value) deviceView.DevCode = dt.Rows[0][2].ToString(); + if (dt.Rows[0][3] != DBNull.Value) deviceView.DevTypeId = dt.Rows[0][3].ToString(); + if (dt.Rows[0][4] != DBNull.Value) deviceView.DevModel = dt.Rows[0][4].ToString(); + if (dt.Rows[0][5] != DBNull.Value) deviceView.RegTime = dt.Rows[0][5].ToString(); + if (dt.Rows[0][6] != DBNull.Value) deviceView.CustomerName = dt.Rows[0][6].ToString(); + if (dt.Rows[0][7] != DBNull.Value) deviceView.CustomerDev = dt.Rows[0][7].ToString(); + if (dt.Rows[0][8] != DBNull.Value) deviceView.Channel = dt.Rows[0][8].ToString(); + if (dt.Rows[0][9] != DBNull.Value) deviceView.Active = Convert.ToInt32(dt.Rows[0][9]); + if (dt.Rows[0][10] != DBNull.Value) deviceView.StartTime = Convert.ToDateTime(dt.Rows[0][10]).ToString("yyyy - MM - dd HH: mm:ss"); + if (dt.Rows[0][11] != DBNull.Value) deviceView.EndTime = Convert.ToDateTime(dt.Rows[0][11]).ToString("yyyy - MM - dd HH: mm:ss"); + if (dt.Rows[0][12] != DBNull.Value) deviceView.StatusId = dt.Rows[0][12].ToString(); + if (dt.Rows[0][13] != DBNull.Value) deviceView.Stability = dt.Rows[0][13].ToString(); + if (dt.Rows[0][14] != DBNull.Value) deviceView.Accuracy = dt.Rows[0][14].ToString(); + if (dt.Rows[0][15] != DBNull.Value) deviceView.BootFeature = dt.Rows[0][15].ToString(); + if (dt.Rows[0][16] != DBNull.Value) deviceView.AgeRate = dt.Rows[0][16].ToString(); + if (dt.Rows[0][17] != DBNull.Value) deviceView.DetectionItemId = Convert.ToInt64(dt.Rows[0][17]); } - using (MySqlDataReader aReader = aCommand.ExecuteReader()) - { - while (aReader.Read()) - { - DeviceView deviceView = new DeviceView(); + //using (MySqlDataReader aReader = aCommand.ExecuteReader()) + //{ + // while (aReader.Read()) + // { + // DeviceView deviceView = new DeviceView(); - if (!aReader.IsDBNull(0)) deviceView.Id = Convert.ToInt64(aReader.GetString(0)); // id - if (!aReader.IsDBNull(1)) deviceView.DevName = aReader.GetString(1); // devName - if (!aReader.IsDBNull(2)) deviceView.DevCode = aReader.GetString(2); // devCode - if (!aReader.IsDBNull(3)) - { - deviceView.DevTypeId = aReader.GetString(3); // devType - //deviceView.DevTypeName = dictService.getNameByCode("devType", aReader.GetString(3)); - } - if (!aReader.IsDBNull(4)) deviceView.DevModel = aReader.GetString(4); // devModel - if (!aReader.IsDBNull(5)) - { - DateTime reg = aReader.GetDateTime(5); // regTime - deviceView.RegTime = reg.ToString("yyyy-MM-dd"); - } - if (!aReader.IsDBNull(6)) deviceView.CustomerName = aReader.GetString(6); // customName - if (!aReader.IsDBNull(7)) deviceView.CustomerDev = aReader.GetString(7); // customDev - if (!aReader.IsDBNull(8)) deviceView.Channel = aReader.GetString(8); - if (!aReader.IsDBNull(9)) deviceView.Active = Convert.ToInt32(aReader.GetString(9)); - if (!aReader.IsDBNull(10)) - { - DateTime reg = aReader.GetDateTime(10); // regTime - deviceView.StartTime = reg.ToString("yyyy-MM-dd HH:mm:ss"); - } - if (!aReader.IsDBNull(11)) - { - DateTime reg = aReader.GetDateTime(11); // regTime - deviceView.EndTime = reg.ToString("yyyy-MM-dd HH:mm:ss"); - } - if (!aReader.IsDBNull(12)) deviceView.StatusId = aReader.GetString(12); - if (!aReader.IsDBNull(13)) deviceView.Stability = aReader.GetString(13); - if (!aReader.IsDBNull(14)) deviceView.Accuracy = aReader.GetString(14); - if (!aReader.IsDBNull(15)) deviceView.BootFeature = aReader.GetString(15); - if (!aReader.IsDBNull(16)) deviceView.AgeRate = aReader.GetString(16); - if (!aReader.IsDBNull(17)) deviceView.DetectionItemId = Convert.ToInt64(aReader.GetString(17)); + // if (!aReader.IsDBNull(0)) deviceView.Id = Convert.ToInt64(aReader.GetString(0)); // id + // if (!aReader.IsDBNull(1)) deviceView.DevName = aReader.GetString(1); // devName + // if (!aReader.IsDBNull(2)) deviceView.DevCode = aReader.GetString(2); // devCode + // if (!aReader.IsDBNull(3)) + // { + // deviceView.DevTypeId = aReader.GetString(3); // devType + // //deviceView.DevTypeName = dictService.getNameByCode("devType", aReader.GetString(3)); + // } + // if (!aReader.IsDBNull(4)) deviceView.DevModel = aReader.GetString(4); // devModel + // if (!aReader.IsDBNull(5)) + // { + // DateTime reg = aReader.GetDateTime(5); // regTime + // deviceView.RegTime = reg.ToString("yyyy-MM-dd"); + // } + // if (!aReader.IsDBNull(6)) deviceView.CustomerName = aReader.GetString(6); // customName + // if (!aReader.IsDBNull(7)) deviceView.CustomerDev = aReader.GetString(7); // customDev + // if (!aReader.IsDBNull(8)) deviceView.Channel = aReader.GetString(8); + // if (!aReader.IsDBNull(9)) deviceView.Active = Convert.ToInt32(aReader.GetString(9)); + // if (!aReader.IsDBNull(10)) + // { + // DateTime reg = aReader.GetDateTime(10); // regTime + // deviceView.StartTime = reg.ToString("yyyy-MM-dd HH:mm:ss"); + // } + // if (!aReader.IsDBNull(11)) + // { + // DateTime reg = aReader.GetDateTime(11); // regTime + // deviceView.EndTime = reg.ToString("yyyy-MM-dd HH:mm:ss"); + // } + // if (!aReader.IsDBNull(12)) deviceView.StatusId = aReader.GetString(12); + // if (!aReader.IsDBNull(13)) deviceView.Stability = aReader.GetString(13); + // if (!aReader.IsDBNull(14)) deviceView.Accuracy = aReader.GetString(14); + // if (!aReader.IsDBNull(15)) deviceView.BootFeature = aReader.GetString(15); + // if (!aReader.IsDBNull(16)) deviceView.AgeRate = aReader.GetString(16); + // if (!aReader.IsDBNull(17)) deviceView.DetectionItemId = Convert.ToInt64(aReader.GetString(17)); - deviceViewList.Add(deviceView); + // deviceViewList.Add(deviceView); - aCommand.Dispose(); - } - } + // aCommand.Dispose(); + // } + //} if (deviceViewList.Count > 0) { diff --git a/RbFreqStandMeasure/bin/Debug/RbFreqStandMeasure.exe b/RbFreqStandMeasure/bin/Debug/RbFreqStandMeasure.exe index ad92b91..1d3a64b 100644 --- a/RbFreqStandMeasure/bin/Debug/RbFreqStandMeasure.exe +++ b/RbFreqStandMeasure/bin/Debug/RbFreqStandMeasure.exe Binary files differ