/// <summary> /// 添加气密结果 /// </summary> /// <returns></returns> private bool AddQMResult() { DAL_dt_qm_Info dal = new DAL_dt_qm_Info(); Model_dt_qm_Info model = new Model_dt_qm_Info(); for (int i = 0; i < 2; i++) { var desc = this.dgv_levelIndex.Rows[i].Cells["Quantity"].Value.ToString(); model.info_DangH = _tempTong; model.dt_Code = _tempCode; if (desc == "单位缝长") { model.qm_Z_FC = this.dgv_levelIndex.Rows[i].Cells["PressureZ"].Value.ToString(); model.qm_F_FC = this.dgv_levelIndex.Rows[i].Cells["PressureF"].Value.ToString(); } else if (desc == "单位面积") { model.qm_Z_MJ = this.dgv_levelIndex.Rows[i].Cells["PressureZ"].Value.ToString(); model.qm_F_MJ = this.dgv_levelIndex.Rows[i].Cells["PressureF"].Value.ToString(); } } for (int i = 0; i < 3; i++) { if (i == 0) { model.qm_s_z_fj100 = this.dgv_WindSpeed.Rows[i].Cells["Pressure_Z"].Value.ToString(); model.qm_s_z_zd100 = this.dgv_WindSpeed.Rows[i].Cells["Pressure_Z_Z"].Value.ToString(); model.qm_s_f_fj100 = this.dgv_WindSpeed.Rows[i].Cells["Pressure_F"].Value.ToString(); model.qm_s_f_zd100 = this.dgv_WindSpeed.Rows[i].Cells["Pressure_F_Z"].Value.ToString(); } else if (i == 1) { model.qm_s_z_fj150 = this.dgv_WindSpeed.Rows[i].Cells["Pressure_Z"].Value.ToString(); model.qm_s_z_zd150 = this.dgv_WindSpeed.Rows[i].Cells["Pressure_Z_Z"].Value.ToString(); model.qm_s_f_fj150 = this.dgv_WindSpeed.Rows[i].Cells["Pressure_F"].Value.ToString(); model.qm_s_f_zd150 = this.dgv_WindSpeed.Rows[i].Cells["Pressure_F_Z"].Value.ToString(); } else if (i == 2) { model.qm_j_z_fj100 = this.dgv_WindSpeed.Rows[i].Cells["Pressure_Z"].Value.ToString(); model.qm_j_z_zd100 = this.dgv_WindSpeed.Rows[i].Cells["Pressure_Z_Z"].Value.ToString(); model.qm_j_f_fj100 = this.dgv_WindSpeed.Rows[i].Cells["Pressure_F"].Value.ToString(); model.qm_j_f_zd100 = this.dgv_WindSpeed.Rows[i].Cells["Pressure_F_Z"].Value.ToString(); } } return(dal.Add(model)); }
/// <summary> /// 添加气密信息 /// </summary> /// <param name="mode"></param> public bool Add(Model_dt_qm_Info model) { //删除结果 SQLiteHelper.ExecuteNonQuery("delete from dt_qm_Info where dt_Code='" + model.dt_Code + "' and info_DangH = '" + model.info_DangH + "'"); var sql = string.Format(@"insert into dt_qm_Info (dt_Code,info_DangH,qm_Z_FC,qm_F_FC,qm_Z_MJ,qm_F_MJ, qm_s_z_fj100,qm_s_z_fj150,qm_j_z_fj100,qm_s_z_zd100,qm_s_z_zd150,qm_j_z_zd100,qm_s_f_fj100,qm_s_f_fj150,qm_j_f_fj100,qm_s_f_zd100,qm_s_f_zd150,qm_j_f_zd100 ) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}')", model.dt_Code, model.info_DangH, model.qm_Z_FC, model.qm_F_FC, model.qm_Z_MJ, model.qm_F_MJ, model.qm_s_z_fj100, model.qm_s_z_fj150, model.qm_j_z_fj100, model.qm_s_z_zd100, model.qm_s_z_zd150, model.qm_j_z_zd100, model.qm_s_f_fj100, model.qm_s_f_fj150, model.qm_j_f_fj100, model.qm_s_f_zd100, model.qm_s_f_zd150, model.qm_j_f_zd100 ); var res = SQLiteHelper.ExecuteNonQuery(sql) > 0 ? true : false; if (res) { new DAL_dt_Info().UpdateTestType(model.dt_Code, model.info_DangH, PublicEnum.SystemItem.Airtight, 1); } return(true); }
/// <summary> /// 获取本次检测的结果 /// </summary> /// <param name="code">编号</param> /// <returns></returns> // public Model_dt_Settings Getdt_SettingsResByCode(string code) // { // string sql = @"select t.*,t1.info_DangH,t2.qm_Z_FC,t2.qm_F_FC,t2.qm_Z_MJ,t2.qm_F_MJ,t3.sm_PaDesc,t3.sm_Pa,t3.sm_Remark, // qm_s_z_fj100,qm_s_z_fj150,qm_j_z_fj100,qm_s_z_zd100,qm_s_z_zd150,qm_j_z_zd100,qm_s_f_fj100,qm_s_f_fj150,qm_j_f_fj100,qm_s_f_zd100,qm_s_f_zd150,qm_j_f_zd100 //from dt_Settings t // left join dt_Info t1 on t.dt_Code = t1.dt_Code // left join dt_qm_Info t2 on t2.dt_Code = t1.dt_Code and t1.info_DangH = t2.info_DangH // where t.dt_Code ='" + code + "'"; // DataRow dr = SQLiteHelper.ExecuteDataRow(sql); // if (dr == null) // return null; // DataTable dt = dr.Table; // Model_dt_Settings dt_Settings = new Model_dt_Settings(); // List<Model_dt_Info> dt_InfoList = new List<Model_dt_Info>(); // List<Model_dt_qm_Info> dt_qm_InfoList = new List<Model_dt_qm_Info>(); // List<Model_dt_sm_Info> dt_sm_InfoList = new List<Model_dt_sm_Info>(); // for (int i = 0; i < dt.Rows.Count; i++) // { // Model_dt_Info dt_Info = new Model_dt_Info(); // Model_dt_qm_Info dt_qm_Info = new Model_dt_qm_Info(); // Model_dt_sm_Info dt_sm_Info = new Model_dt_sm_Info(); // if (i == 0) // { // dt_Settings.WeiTuoBianHao = dt.Rows[i]["WeiTuoBianHao"].ToString(); // dt_Settings.WeiTuoDanWei = dt.Rows[i]["WeiTuoDanWei"].ToString(); // dt_Settings.WeiTuoRen = dt.Rows[i]["WeiTuoRen"].ToString(); // dt_Settings.YangPinMingCheng = dt.Rows[i]["YangPinMingCheng"].ToString(); // dt_Settings.CaiYangFangShi = dt.Rows[i]["CaiYangFangShi"].ToString(); // dt_Settings.JianYanXiangMu = dt.Rows[i]["JianYanXiangMu"].ToString(); // dt_Settings.GuiGeXingHao = dt.Rows[i]["GuiGeXingHao"].ToString(); // dt_Settings.GuiGeShuLiang = dt.Rows[i]["GuiGeShuLiang"].ToString(); // dt_Settings.JianYanRiQi = dt.Rows[i]["JianYanRiQi"].ToString(); // dt_Settings.KaiQiFangShi = dt.Rows[i]["KaiQiFangShi"].ToString(); // dt_Settings.DaQiYaLi = dt.Rows[i]["DaQiYaLi"].ToString(); // dt_Settings.BoLiPinZhong = dt.Rows[i]["BoLiPinZhong"].ToString(); // dt_Settings.DangQianWenDu = dt.Rows[i]["DangQianWenDu"].ToString(); // dt_Settings.BoLiHouDu = dt.Rows[i]["BoLiHouDu"].ToString(); // dt_Settings.ZongMianJi = dt.Rows[i]["ZongMianJi"].ToString(); // dt_Settings.ZuiDaBoLi = dt.Rows[i]["ZuiDaBoLi"].ToString(); // dt_Settings.KaiQiFengChang = dt.Rows[i]["KaiQiFengChang"].ToString(); // dt_Settings.BoLiMiFeng = dt.Rows[i]["BoLiMiFeng"].ToString(); // dt_Settings.XiangQianFangShi = dt.Rows[i]["XiangQianFangShi"].ToString(); // dt_Settings.ShuiMiDengJiSheJiZhi = dt.Rows[i]["ShuiMiDengJiSheJiZhi"].ToString(); // dt_Settings.KuangShanMiFang = dt.Rows[i]["KuangShanMiFang"].ToString(); // dt_Settings.QiMiZhengYaDanWeiFengChangSheJiZhi = dt.Rows[i]["QiMiZhengYaDanWeiFengChangSheJiZhi"].ToString(); // dt_Settings.ZhengYaQiMiDengJiSheJiZhi = dt.Rows[i]["ZhengYaQiMiDengJiSheJiZhi"].ToString(); // dt_Settings.QiMiFuYaDanWeiFengChangSheJiZhi = dt.Rows[i]["QiMiFuYaDanWeiFengChangSheJiZhi"].ToString(); // dt_Settings.FuYaQiMiDengJiSheJiZhi = dt.Rows[i]["FuYaQiMiDengJiSheJiZhi"].ToString(); // dt_Settings.ShuiMiSheJiZhi = dt.Rows[i]["ShuiMiSheJiZhi"].ToString(); // dt_Settings.QiMiZhengYaDanWeiMianJiSheJiZhi = dt.Rows[i]["QiMiZhengYaDanWeiMianJiSheJiZhi"].ToString(); // dt_Settings.QiMiFuYaDanWeiMianJiSheJiZhi = dt.Rows[i]["QiMiFuYaDanWeiMianJiSheJiZhi"].ToString(); // dt_Settings.JianYanYiJu = dt.Rows[i]["JianYanYiJu"].ToString(); // dt_Settings.GongChengMingCheng = dt.Rows[i]["GongChengMingCheng"].ToString(); // dt_Settings.GongChengDiDian = dt.Rows[i]["GongChengDiDian"].ToString(); // dt_Settings.ShengChanDanWei = dt.Rows[i]["ShengChanDanWei"].ToString(); // dt_Settings.JianLiDanWei = dt.Rows[i]["JianLiDanWei"].ToString(); // dt_Settings.JianZhengRen = dt.Rows[i]["JianZhengRen"].ToString(); // dt_Settings.JianZhengHao = dt.Rows[i]["JianZhengHao"].ToString(); // dt_Settings.ShiGongDanWei = dt.Rows[i]["ShiGongDanWei"].ToString(); // dt_Settings.WuJinJianZhuangKuang = dt.Rows[i]["WuJinJianZhuangKuang"].ToString(); // dt_Settings.SuLiaoChuangChenJinChiCun = dt.Rows[i]["SuLiaoChuangChenJinChiCun"].ToString(); // dt_Settings.ShiFouJiaLuoSi = dt.Rows[i]["ShiFouJiaLuoSi"].ToString(); // dt_Settings.XingCaiGuiGe = dt.Rows[i]["XingCaiGuiGe"].ToString(); // dt_Settings.XingCaiBiHou = dt.Rows[i]["XingCaiBiHou"].ToString(); // dt_Settings.XingCaiShengChanChang = dt.Rows[i]["XingCaiShengChanChang"].ToString(); // dt_Settings.dt_Code = dt.Rows[i]["dt_Code"].ToString(); // dt_Settings.dt_Create = DateTime.Parse(dt.Rows[i]["dt_Create"].ToString()); // dt_Settings.GanJianChangDu = dt.Rows[i]["GanJianChangDu"].ToString(); // dt_Settings.KangFengYaDengJiSheJiZhi = dt.Rows[i]["KangFengYaDengJiSheJiZhi"].ToString(); // dt_Settings.KangFengYaSheJiZhi = dt.Rows[i]["KangFengYaSheJiZhi"].ToString(); // dt_Settings.DanShanDanSuoDian = dt.Rows[i]["DanShanDanSuoDian"].ToString(); // } // dt_Info.dt_Code = dt.Rows[i]["dt_Code"].ToString(); // dt_Info.info_Create = ""; // dt_Info.info_DangH = dt.Rows[i]["info_DangH"].ToString(); // dt_InfoList.Add(dt_Info); // dt_qm_Info.dt_Code = dt.Rows[i]["dt_Code"].ToString(); // dt_qm_Info.info_DangH = dt.Rows[i]["info_DangH"].ToString(); // dt_qm_Info.qm_F_FC = dt.Rows[i]["qm_F_FC"].ToString(); // dt_qm_Info.qm_F_MJ = dt.Rows[i]["qm_F_MJ"].ToString(); // dt_qm_Info.qm_Z_FC = dt.Rows[i]["qm_Z_FC"].ToString(); // dt_qm_Info.qm_Z_MJ = dt.Rows[i]["qm_Z_MJ"].ToString(); // dt_qm_Info.qm_s_z_fj100 = dt.Rows[i]["qm_s_z_fj100"].ToString(); // dt_qm_Info.qm_s_z_fj150 = dt.Rows[i]["qm_s_z_fj150"].ToString(); // dt_qm_Info.qm_j_z_fj100 = dt.Rows[i]["qm_j_z_fj100"].ToString(); // dt_qm_Info.qm_s_z_zd100 = dt.Rows[i]["qm_s_z_zd100"].ToString(); // dt_qm_Info.qm_s_z_zd150 = dt.Rows[i]["qm_s_z_zd150"].ToString(); // dt_qm_Info.qm_j_z_zd100 = dt.Rows[i]["qm_j_z_zd100"].ToString(); // dt_qm_Info.qm_s_f_fj100 = dt.Rows[i]["qm_s_f_fj100"].ToString(); // dt_qm_Info.qm_s_f_fj150 = dt.Rows[i]["qm_s_f_fj150"].ToString(); // dt_qm_Info.qm_j_f_fj100 = dt.Rows[i]["qm_j_f_fj100"].ToString(); // dt_qm_Info.qm_s_f_zd100 = dt.Rows[i]["qm_s_f_zd100"].ToString(); // dt_qm_Info.qm_s_f_zd150 = dt.Rows[i]["qm_s_f_zd150"].ToString(); // dt_qm_Info.qm_j_f_zd100 = dt.Rows[i]["qm_j_f_zd100"].ToString(); // dt_qm_InfoList.Add(dt_qm_Info); // dt_sm_Info.dt_Code = dt.Rows[i]["dt_Code"].ToString(); // dt_sm_Info.info_DangH = dt.Rows[i]["info_DangH"].ToString(); // dt_sm_Info.sm_Pa = dt.Rows[i]["sm_Pa"].ToString(); // dt_sm_Info.sm_PaDesc = dt.Rows[i]["sm_PaDesc"].ToString(); // dt_sm_Info.sm_Remark = dt.Rows[i]["sm_Remark"].ToString(); // dt_sm_InfoList.Add(dt_sm_Info); // } // dt_Settings.dt_sm_Info = dt_sm_InfoList; // dt_Settings.dt_qm_Info = dt_qm_InfoList; // dt_Settings.dt_InfoList = dt_InfoList; // return dt_Settings; // } /// <summary> /// 根据编号获取本次检测信息 /// </summary> /// <param name="code"></param> /// <returns></returns> public Model_dt_Settings GetInfoByCode(string code) { Model_dt_Settings settings = new Model_dt_Settings(); var dt_settings = SQLiteHelper.ExecuteDataRow("select * from dt_settings where dt_Code='" + code + "'")?.Table; settings.WeiTuoBianHao = dt_settings.Rows[0]["WeiTuoBianHao"].ToString(); settings.WeiTuoDanWei = dt_settings.Rows[0]["WeiTuoDanWei"].ToString(); settings.WeiTuoRen = dt_settings.Rows[0]["WeiTuoRen"].ToString(); settings.YangPinMingCheng = dt_settings.Rows[0]["YangPinMingCheng"].ToString(); settings.CaiYangFangShi = dt_settings.Rows[0]["CaiYangFangShi"].ToString(); settings.JianYanXiangMu = dt_settings.Rows[0]["JianYanXiangMu"].ToString(); settings.GuiGeXingHao = dt_settings.Rows[0]["GuiGeXingHao"].ToString(); settings.GuiGeShuLiang = dt_settings.Rows[0]["GuiGeShuLiang"].ToString(); settings.JianYanRiQi = dt_settings.Rows[0]["JianYanRiQi"].ToString(); settings.KaiQiFangShi = dt_settings.Rows[0]["KaiQiFangShi"].ToString(); settings.DaQiYaLi = dt_settings.Rows[0]["DaQiYaLi"].ToString(); settings.BoLiPinZhong = dt_settings.Rows[0]["BoLiPinZhong"].ToString(); settings.DangQianWenDu = dt_settings.Rows[0]["DangQianWenDu"].ToString(); settings.BoLiHouDu = dt_settings.Rows[0]["BoLiHouDu"].ToString(); settings.ZongMianJi = dt_settings.Rows[0]["ZongMianJi"].ToString(); settings.ZuiDaBoLi = dt_settings.Rows[0]["ZuiDaBoLi"].ToString(); settings.KaiQiFengChang = dt_settings.Rows[0]["KaiQiFengChang"].ToString(); settings.BoLiMiFeng = dt_settings.Rows[0]["BoLiMiFeng"].ToString(); settings.XiangQianFangShi = dt_settings.Rows[0]["XiangQianFangShi"].ToString(); settings.ShuiMiDengJiSheJiZhi = dt_settings.Rows[0]["ShuiMiDengJiSheJiZhi"].ToString(); settings.KuangShanMiFang = dt_settings.Rows[0]["KuangShanMiFang"].ToString(); settings.QiMiZhengYaDanWeiFengChangSheJiZhi = dt_settings.Rows[0]["QiMiZhengYaDanWeiFengChangSheJiZhi"].ToString(); settings.ZhengYaQiMiDengJiSheJiZhi = dt_settings.Rows[0]["ZhengYaQiMiDengJiSheJiZhi"].ToString(); settings.QiMiFuYaDanWeiFengChangSheJiZhi = dt_settings.Rows[0]["QiMiFuYaDanWeiFengChangSheJiZhi"].ToString(); settings.FuYaQiMiDengJiSheJiZhi = dt_settings.Rows[0]["FuYaQiMiDengJiSheJiZhi"].ToString(); settings.ShuiMiSheJiZhi = dt_settings.Rows[0]["ShuiMiSheJiZhi"].ToString(); settings.QiMiZhengYaDanWeiMianJiSheJiZhi = dt_settings.Rows[0]["QiMiZhengYaDanWeiMianJiSheJiZhi"].ToString(); settings.QiMiFuYaDanWeiMianJiSheJiZhi = dt_settings.Rows[0]["QiMiFuYaDanWeiMianJiSheJiZhi"].ToString(); settings.JianYanYiJu = dt_settings.Rows[0]["JianYanYiJu"].ToString(); settings.GongChengMingCheng = dt_settings.Rows[0]["GongChengMingCheng"].ToString(); settings.GongChengDiDian = dt_settings.Rows[0]["GongChengDiDian"].ToString(); settings.ShengChanDanWei = dt_settings.Rows[0]["ShengChanDanWei"].ToString(); settings.JianLiDanWei = dt_settings.Rows[0]["JianLiDanWei"].ToString(); settings.JianZhengRen = dt_settings.Rows[0]["JianZhengRen"].ToString(); settings.JianZhengHao = dt_settings.Rows[0]["JianZhengHao"].ToString(); settings.ShiGongDanWei = dt_settings.Rows[0]["ShiGongDanWei"].ToString(); settings.WuJinJianZhuangKuang = dt_settings.Rows[0]["WuJinJianZhuangKuang"].ToString(); settings.SuLiaoChuangChenJinChiCun = dt_settings.Rows[0]["SuLiaoChuangChenJinChiCun"].ToString(); settings.ShiFouJiaLuoSi = dt_settings.Rows[0]["ShiFouJiaLuoSi"].ToString(); settings.XingCaiGuiGe = dt_settings.Rows[0]["XingCaiGuiGe"].ToString(); settings.XingCaiBiHou = dt_settings.Rows[0]["XingCaiBiHou"].ToString(); settings.XingCaiShengChanChang = dt_settings.Rows[0]["XingCaiShengChanChang"].ToString(); settings.GanJianChangDu = dt_settings.Rows[0]["GanJianChangDu"].ToString(); settings.KangFengYaDengJiSheJiZhi = dt_settings.Rows[0]["KangFengYaDengJiSheJiZhi"].ToString(); settings.KangFengYaSheJiZhi = dt_settings.Rows[0]["KangFengYaSheJiZhi"].ToString(); settings.DanShanDanSuoDian = dt_settings.Rows[0]["DanShanDanSuoDian"].ToString(); settings.dt_Code = dt_settings.Rows[0]["dt_Code"].ToString(); var dt_Info = SQLiteHelper.ExecuteDataRow("select * from dt_Info where dt_Code='" + code + "' order by info_DangH")?.Table; if (dt_Info != null) { List <Model_dt_Info> list = new List <Model_dt_Info>(); foreach (DataRow item in dt_Info.Rows) { #region Model_dt_Info model = new Model_dt_Info(); model.dt_Code = item["dt_Code"].ToString(); model.info_Create = item["info_Create"].ToString(); model.info_DangH = item["info_DangH"].ToString(); model.Watertight = Convert.ToInt32(item["Watertight"].ToString()); model.WindPressure = Convert.ToInt32(item["WindPressure"].ToString()); model.Airtight = Convert.ToInt32(item["Airtight"].ToString()); list.Add(model); #endregion } if (list.Count > 0) { settings.dt_InfoList = list; } } var dt_qm_Info = SQLiteHelper.ExecuteDataRow("select * from dt_qm_Info where dt_Code='" + code + "' order by info_DangH")?.Table; if (dt_qm_Info != null) { List <Model_dt_qm_Info> list = new List <Model_dt_qm_Info>(); foreach (DataRow item in dt_qm_Info.Rows) { #region Model_dt_qm_Info model = new Model_dt_qm_Info(); model.dt_Code = item["dt_Code"].ToString(); model.info_DangH = item["info_DangH"].ToString(); model.qm_Z_FC = item["qm_Z_FC"].ToString(); model.qm_F_FC = item["qm_F_FC"].ToString(); model.qm_Z_MJ = item["qm_Z_MJ"].ToString(); model.qm_F_MJ = item["qm_F_MJ"].ToString(); model.qm_s_z_fj100 = item["qm_s_z_fj100"].ToString(); model.qm_s_z_fj150 = item["qm_s_z_fj150"].ToString(); model.qm_j_z_fj100 = item["qm_j_z_fj100"].ToString(); model.qm_s_z_zd100 = item["qm_s_z_zd100"].ToString(); model.qm_s_z_zd150 = item["qm_s_z_zd150"].ToString(); model.qm_j_z_zd100 = item["qm_j_z_zd100"].ToString(); model.qm_s_f_fj100 = item["qm_s_f_fj100"].ToString(); model.qm_s_f_fj150 = item["qm_s_f_fj150"].ToString(); model.qm_j_f_fj100 = item["qm_j_f_fj100"].ToString(); model.qm_s_f_zd100 = item["qm_s_f_zd100"].ToString(); model.qm_s_f_zd150 = item["qm_s_f_zd150"].ToString(); model.qm_j_f_zd100 = item["qm_j_f_zd100"].ToString(); list.Add(model); #endregion } if (list.Count > 0) { settings.dt_qm_Info = list; } } var dt_sm_Info = SQLiteHelper.ExecuteDataRow("select * from dt_sm_Info where dt_Code='" + code + "' order by info_DangH")?.Table; if (dt_sm_Info != null) { List <Model_dt_sm_Info> list = new List <Model_dt_sm_Info>(); foreach (DataRow item in dt_sm_Info.Rows) { #region Model_dt_sm_Info model = new Model_dt_sm_Info(); model.dt_Code = item["dt_Code"].ToString(); model.info_DangH = item["info_DangH"].ToString(); model.sm_PaDesc = item["sm_PaDesc"].ToString(); model.sm_Pa = item["sm_Pa"].ToString(); model.sm_Remark = item["sm_Remark"].ToString(); model.Method = item["Method"].ToString(); list.Add(model); #endregion } if (list.Count > 0) { settings.dt_sm_Info = list; } } var dt_kfy_Info = SQLiteHelper.ExecuteDataRow("select * from dt_kfy_Info where dt_Code='" + code + "' order by info_DangH")?.Table; if (dt_kfy_Info != null) { List <Model_dt_kfy_Info> list = new List <Model_dt_kfy_Info>(); foreach (DataRow item in dt_kfy_Info.Rows) { #region Model_dt_kfy_Info model = new Model.DataBase.Model_dt_kfy_Info(); model.z_one_250 = item["z_one_250"].ToString(); model.z_two_250 = item["z_two_250"].ToString(); model.z_three_250 = item["z_three_250"].ToString(); model.z_nd_250 = item["z_nd_250"].ToString(); model.z_ix_250 = item["z_ix_250"].ToString(); model.f_one_250 = item["f_one_250"].ToString(); model.f_two_250 = item["f_two_250"].ToString(); model.f_three_250 = item["f_three_250"].ToString(); model.f_nd_250 = item["f_nd_250"].ToString(); model.f_ix_250 = item["f_ix_250"].ToString(); model.z_one_500 = item["z_one_500"].ToString(); model.z_two_500 = item["z_two_500"].ToString(); model.z_three_500 = item["z_three_500"].ToString(); model.z_nd_500 = item["z_nd_500"].ToString(); model.z_ix_500 = item["z_ix_500"].ToString(); model.f_one_500 = item["f_one_500"].ToString(); model.f_two_500 = item["f_two_500"].ToString(); model.f_three_500 = item["f_three_500"].ToString(); model.f_nd_500 = item["f_nd_500"].ToString(); model.f_ix_500 = item["f_ix_500"].ToString(); model.z_one_750 = item["z_one_750"].ToString(); model.z_two_750 = item["z_two_750"].ToString(); model.z_three_750 = item["z_three_750"].ToString(); model.z_nd_750 = item["z_nd_750"].ToString(); model.z_ix_750 = item["z_ix_750"].ToString(); model.f_one_750 = item["f_one_750"].ToString(); model.f_two_750 = item["f_two_750"].ToString(); model.f_three_750 = item["f_three_750"].ToString(); model.f_nd_750 = item["f_nd_750"].ToString(); model.f_ix_750 = item["f_ix_750"].ToString(); model.z_one_1000 = item["z_one_1000"].ToString(); model.z_two_1000 = item["z_two_1000"].ToString(); model.z_three_1000 = item["z_three_1000"].ToString(); model.z_nd_1000 = item["z_nd_1000"].ToString(); model.z_ix_1000 = item["z_ix_1000"].ToString(); model.f_one_1000 = item["f_one_1000"].ToString(); model.f_two_1000 = item["f_two_1000"].ToString(); model.f_three_1000 = item["f_three_1000"].ToString(); model.f_nd_1000 = item["f_nd_1000"].ToString(); model.f_ix_1000 = item["f_ix_1000"].ToString(); model.z_one_1250 = item["z_one_1250"].ToString(); model.z_two_1250 = item["z_two_1250"].ToString(); model.z_three_1250 = item["z_three_1250"].ToString(); model.z_nd_1250 = item["z_nd_1250"].ToString(); model.z_ix_1250 = item["z_ix_1250"].ToString(); model.f_one_1250 = item["f_one_1250"].ToString(); model.f_two_1250 = item["f_two_1250"].ToString(); model.f_three_1250 = item["f_three_1250"].ToString(); model.f_nd_1250 = item["f_nd_1250"].ToString(); model.f_ix_1250 = item["f_ix_1250"].ToString(); model.z_one_1500 = item["z_one_1500"].ToString(); model.z_two_1500 = item["z_two_1500"].ToString(); model.z_three_1500 = item["z_three_1500"].ToString(); model.z_nd_1500 = item["z_nd_1500"].ToString(); model.z_ix_1500 = item["z_ix_1500"].ToString(); model.f_one_1500 = item["f_one_1500"].ToString(); model.f_two_1500 = item["f_two_1500"].ToString(); model.f_three_1500 = item["f_three_1500"].ToString(); model.f_nd_1500 = item["f_nd_1500"].ToString(); model.f_ix_1500 = item["f_ix_1500"].ToString(); model.z_one_1750 = item["z_one_1750"].ToString(); model.z_two_1750 = item["z_two_1750"].ToString(); model.z_three_1750 = item["z_three_1750"].ToString(); model.z_nd_1750 = item["z_nd_1750"].ToString(); model.z_ix_1750 = item["z_ix_1750"].ToString(); model.f_one_1750 = item["f_one_1750"].ToString(); model.f_two_1750 = item["f_two_1750"].ToString(); model.f_three_1750 = item["f_three_1750"].ToString(); model.f_nd_1750 = item["f_nd_1750"].ToString(); model.f_ix_1750 = item["f_ix_1750"].ToString(); model.z_one_2000 = item["z_one_2000"].ToString(); model.z_two_2000 = item["z_two_2000"].ToString(); model.z_three_2000 = item["z_three_2000"].ToString(); model.z_nd_2000 = item["z_nd_2000"].ToString(); model.z_ix_2000 = item["z_ix_2000"].ToString(); model.f_one_2000 = item["f_one_2000"].ToString(); model.f_two_2000 = item["f_two_2000"].ToString(); model.f_three_2000 = item["f_three_2000"].ToString(); model.f_nd_2000 = item["f_nd_2000"].ToString(); model.f_ix_2000 = item["f_ix_2000"].ToString(); model.p1 = item["p1"].ToString(); model.p2 = item["p2"].ToString(); model.p3 = item["p3"].ToString(); model._p1 = item["_p1"].ToString(); model._p2 = item["_p2"].ToString(); model._p3 = item["_p3"].ToString(); model.CheckLock = int.Parse(item["CheckLock"].ToString()); model.info_DangH = item["info_DangH"].ToString(); list.Add(model); #endregion } if (list.Count > 0) { settings.dt_kfy_Info = list; } } return(settings); }
/// <summary> /// 添加气密信息 /// </summary> /// <param name="mode"></param> public bool Add(Model_dt_qm_Info model) { //删除结果 SQLiteHelper.ExecuteNonQuery("delete from dt_qm_Info where testcount= " + model.testcount + " and dt_Code='" + model.dt_Code + "' and info_DangH = '" + model.info_DangH + "'"); var sql = string.Format(@"insert into dt_qm_Info (dt_Code,info_DangH,qm_Z_FC,qm_F_FC,qm_Z_MJ,qm_F_MJ, qm_s_z_fj10 , qm_s_z_fj30 , qm_s_z_fj50 , qm_s_z_fj70 , qm_s_z_fj100 , qm_s_z_fj150 , qm_j_z_fj100 , qm_j_z_fj70 , qm_j_z_fj50 , qm_j_z_fj30 , qm_j_z_fj10 , qm_s_z_zd10 , qm_s_z_zd30 , qm_s_z_zd50 , qm_s_z_zd70 , qm_s_z_zd100 , qm_s_z_zd150 , qm_j_z_zd100 , qm_j_z_zd70 , qm_j_z_zd50 , qm_j_z_zd30 , qm_j_z_zd10 , qm_s_f_fj10 , qm_s_f_fj30 , qm_s_f_fj50 , qm_s_f_fj70 , qm_s_f_fj100 , qm_s_f_fj150 , qm_j_f_fj100 , qm_j_f_fj70 , qm_j_f_fj50 , qm_j_f_fj30 , qm_j_f_fj10 , qm_s_f_zd10 , qm_s_f_zd30 , qm_s_f_zd50 , qm_s_f_zd70 , qm_s_f_zd100 , qm_s_f_zd150 , qm_j_f_zd100 , qm_j_f_zd70 , qm_j_f_zd50 , qm_j_f_zd30 , qm_j_f_zd10 , testcount, testtype, sjz_value, sjz_z_fj, sjz_z_zd, sjz_f_fj, sjz_f_zd ) values('{0}','{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}')", model.dt_Code, model.info_DangH, model.qm_Z_FC, model.qm_F_FC, model.qm_Z_MJ, model.qm_F_MJ, model.qm_s_z_fj10, model.qm_s_z_fj30, model.qm_s_z_fj50, model.qm_s_z_fj70, model.qm_s_z_fj100, model.qm_s_z_fj150, model.qm_j_z_fj100, model.qm_j_z_fj70, model.qm_j_z_fj50, model.qm_j_z_fj30, model.qm_j_z_fj10, model.qm_s_z_zd10, model.qm_s_z_zd30, model.qm_s_z_zd50, model.qm_s_z_zd70, model.qm_s_z_zd100, model.qm_s_z_zd150, model.qm_j_z_zd100, model.qm_j_z_zd70, model.qm_j_z_zd50, model.qm_j_z_zd30, model.qm_j_z_zd10, model.qm_s_f_fj10, model.qm_s_f_fj30, model.qm_s_f_fj50, model.qm_s_f_fj70, model.qm_s_f_fj100, model.qm_s_f_fj150, model.qm_j_f_fj100, model.qm_j_f_fj70, model.qm_j_f_fj50, model.qm_j_f_fj30, model.qm_j_f_fj10, model.qm_s_f_zd10, model.qm_s_f_zd30, model.qm_s_f_zd50, model.qm_s_f_zd70, model.qm_s_f_zd100, model.qm_s_f_zd150, model.qm_j_f_zd100, model.qm_j_f_zd70, model.qm_j_f_zd50, model.qm_j_f_zd30, model.qm_j_f_zd10, model.testcount, model.testtype, model.sjz_value, model.sjz_z_fj, model.sjz_z_zd, model.sjz_f_fj, model.sjz_f_zd ); var res = SQLiteHelper.ExecuteNonQuery(sql) > 0 ? true : false; if (res) { new DAL_dt_Info().UpdateTestType(model.dt_Code, model.info_DangH, PublicEnum.SystemItem.Airtight, 1); } return(true); }
/// <summary> /// 获取本次检测的结果 /// </summary> /// <param name="code">编号</param> /// <returns></returns> public Model_dt_Settings Getdt_SettingsResByCode(string code) { string sql = @"select t.*,t1.info_DangH,t2.qm_Z_FC,t2.qm_F_FC,t2.qm_Z_MJ,t2.qm_F_MJ,t3.sm_PaDesc,t3.sm_Pa,t3.sm_Remark, qm_s_z_fj100,qm_s_z_fj150,qm_j_z_fj100,qm_s_z_zd100,qm_s_z_zd150,qm_j_z_zd100,qm_s_f_fj100,qm_s_f_fj150,qm_j_f_fj100,qm_s_f_zd100,qm_s_f_zd150,qm_j_f_zd100 from dt_Settings t left join dt_Info t1 on t.dt_Code = t1.dt_Code left join dt_qm_Info t2 on t2.dt_Code = t1.dt_Code and t1.info_DangH = t2.info_DangH left join dt_sm_Info t3 on t3.dt_Code = t1.dt_Code and t1.info_DangH = t3.info_DangH where t.dt_Code ='" + code + "'"; DataRow dr = SQLiteHelper.ExecuteDataRow(sql); if (dr == null) { return(null); } DataTable dt = dr.Table; Model_dt_Settings dt_Settings = new Model_dt_Settings(); List <Model_dt_Info> dt_InfoList = new List <Model_dt_Info>(); List <Model_dt_qm_Info> dt_qm_InfoList = new List <Model_dt_qm_Info>(); List <Model_dt_sm_Info> dt_sm_InfoList = new List <Model_dt_sm_Info>(); for (int i = 0; i < dt.Rows.Count; i++) { Model_dt_Info dt_Info = new Model_dt_Info(); Model_dt_qm_Info dt_qm_Info = new Model_dt_qm_Info(); Model_dt_sm_Info dt_sm_Info = new Model_dt_sm_Info(); if (i == 0) { dt_Settings.WeiTuoBianHao = dt.Rows[i]["WeiTuoBianHao"].ToString(); dt_Settings.WeiTuoDanWei = dt.Rows[i]["WeiTuoDanWei"].ToString(); dt_Settings.WeiTuoRen = dt.Rows[i]["WeiTuoRen"].ToString(); dt_Settings.YangPinMingCheng = dt.Rows[i]["YangPinMingCheng"].ToString(); dt_Settings.CaiYangFangShi = dt.Rows[i]["CaiYangFangShi"].ToString(); dt_Settings.JianYanXiangMu = dt.Rows[i]["JianYanXiangMu"].ToString(); dt_Settings.GuiGeXingHao = dt.Rows[i]["GuiGeXingHao"].ToString(); dt_Settings.GuiGeShuLiang = dt.Rows[i]["GuiGeShuLiang"].ToString(); dt_Settings.JianYanRiQi = dt.Rows[i]["JianYanRiQi"].ToString(); dt_Settings.KaiQiFangShi = dt.Rows[i]["KaiQiFangShi"].ToString(); dt_Settings.DaQiYaLi = dt.Rows[i]["DaQiYaLi"].ToString(); dt_Settings.BoLiPinZhong = dt.Rows[i]["BoLiPinZhong"].ToString(); dt_Settings.DangQianWenDu = dt.Rows[i]["DangQianWenDu"].ToString(); dt_Settings.BoLiHouDu = dt.Rows[i]["BoLiHouDu"].ToString(); dt_Settings.ZongMianJi = dt.Rows[i]["ZongMianJi"].ToString(); dt_Settings.ZuiDaBoLi = dt.Rows[i]["ZuiDaBoLi"].ToString(); dt_Settings.KaiQiFengChang = dt.Rows[i]["KaiQiFengChang"].ToString(); dt_Settings.BoLiMiFeng = dt.Rows[i]["BoLiMiFeng"].ToString(); dt_Settings.XiangQianFangShi = dt.Rows[i]["XiangQianFangShi"].ToString(); dt_Settings.ShuiMiDengJiSheJiZhi = dt.Rows[i]["ShuiMiDengJiSheJiZhi"].ToString(); dt_Settings.KuangShanMiFang = dt.Rows[i]["KuangShanMiFang"].ToString(); dt_Settings.QiMiZhengYaDanWeiFengChangSheJiZhi = dt.Rows[i]["QiMiZhengYaDanWeiFengChangSheJiZhi"].ToString(); dt_Settings.ZhengYaQiMiDengJiSheJiZhi = dt.Rows[i]["ZhengYaQiMiDengJiSheJiZhi"].ToString(); dt_Settings.QiMiFuYaDanWeiFengChangSheJiZhi = dt.Rows[i]["QiMiFuYaDanWeiFengChangSheJiZhi"].ToString(); dt_Settings.FuYaQiMiDengJiSheJiZhi = dt.Rows[i]["FuYaQiMiDengJiSheJiZhi"].ToString(); dt_Settings.ShuiMiSheJiZhi = dt.Rows[i]["ShuiMiSheJiZhi"].ToString(); dt_Settings.QiMiZhengYaDanWeiMianJiSheJiZhi = dt.Rows[i]["QiMiZhengYaDanWeiMianJiSheJiZhi"].ToString(); dt_Settings.QiMiFuYaDanWeiMianJiSheJiZhi = dt.Rows[i]["QiMiFuYaDanWeiMianJiSheJiZhi"].ToString(); dt_Settings.JianYanYiJu = dt.Rows[i]["JianYanYiJu"].ToString(); dt_Settings.GongChengMingCheng = dt.Rows[i]["GongChengMingCheng"].ToString(); dt_Settings.GongChengDiDian = dt.Rows[i]["GongChengDiDian"].ToString(); dt_Settings.ShengChanDanWei = dt.Rows[i]["ShengChanDanWei"].ToString(); dt_Settings.JianLiDanWei = dt.Rows[i]["JianLiDanWei"].ToString(); dt_Settings.JianZhengRen = dt.Rows[i]["JianZhengRen"].ToString(); dt_Settings.JianZhengHao = dt.Rows[i]["JianZhengHao"].ToString(); dt_Settings.ShiGongDanWei = dt.Rows[i]["ShiGongDanWei"].ToString(); dt_Settings.WuJinJianZhuangKuang = dt.Rows[i]["WuJinJianZhuangKuang"].ToString(); dt_Settings.SuLiaoChuangChenJinChiCun = dt.Rows[i]["SuLiaoChuangChenJinChiCun"].ToString(); dt_Settings.ShiFouJiaLuoSi = dt.Rows[i]["ShiFouJiaLuoSi"].ToString(); dt_Settings.XingCaiGuiGe = dt.Rows[i]["XingCaiGuiGe"].ToString(); dt_Settings.XingCaiBiHou = dt.Rows[i]["XingCaiBiHou"].ToString(); dt_Settings.XingCaiShengChanChang = dt.Rows[i]["XingCaiShengChanChang"].ToString(); dt_Settings.dt_Code = dt.Rows[i]["dt_Code"].ToString(); dt_Settings.dt_Create = DateTime.Parse(dt.Rows[i]["dt_Create"].ToString()); } dt_Info.dt_Code = dt.Rows[i]["dt_Code"].ToString(); dt_Info.info_Create = ""; dt_Info.info_DangH = dt.Rows[i]["info_DangH"].ToString(); dt_InfoList.Add(dt_Info); dt_qm_Info.dt_Code = dt.Rows[i]["dt_Code"].ToString(); dt_qm_Info.info_DangH = dt.Rows[i]["info_DangH"].ToString(); dt_qm_Info.qm_F_FC = dt.Rows[i]["qm_F_FC"].ToString(); dt_qm_Info.qm_F_MJ = dt.Rows[i]["qm_F_MJ"].ToString(); dt_qm_Info.qm_Z_FC = dt.Rows[i]["qm_Z_FC"].ToString(); dt_qm_Info.qm_Z_MJ = dt.Rows[i]["qm_Z_MJ"].ToString(); dt_qm_Info.qm_s_z_fj100 = dt.Rows[i]["qm_s_z_fj100"].ToString(); dt_qm_Info.qm_s_z_fj150 = dt.Rows[i]["qm_s_z_fj150"].ToString(); dt_qm_Info.qm_j_z_fj100 = dt.Rows[i]["qm_j_z_fj100"].ToString(); dt_qm_Info.qm_s_z_zd100 = dt.Rows[i]["qm_s_z_zd100"].ToString(); dt_qm_Info.qm_s_z_zd150 = dt.Rows[i]["qm_s_z_zd150"].ToString(); dt_qm_Info.qm_j_z_zd100 = dt.Rows[i]["qm_j_z_zd100"].ToString(); dt_qm_Info.qm_s_f_fj100 = dt.Rows[i]["qm_s_f_fj100"].ToString(); dt_qm_Info.qm_s_f_fj150 = dt.Rows[i]["qm_s_f_fj150"].ToString(); dt_qm_Info.qm_j_f_fj100 = dt.Rows[i]["qm_j_f_fj100"].ToString(); dt_qm_Info.qm_s_f_zd100 = dt.Rows[i]["qm_s_f_zd100"].ToString(); dt_qm_Info.qm_s_f_zd150 = dt.Rows[i]["qm_s_f_zd150"].ToString(); dt_qm_Info.qm_j_f_zd100 = dt.Rows[i]["qm_j_f_zd100"].ToString(); dt_qm_InfoList.Add(dt_qm_Info); dt_sm_Info.dt_Code = dt.Rows[i]["dt_Code"].ToString(); dt_sm_Info.info_DangH = dt.Rows[i]["info_DangH"].ToString(); dt_sm_Info.sm_Pa = dt.Rows[i]["sm_Pa"].ToString(); dt_sm_Info.sm_PaDesc = dt.Rows[i]["sm_PaDesc"].ToString(); dt_sm_Info.sm_Remark = dt.Rows[i]["sm_Remark"].ToString(); dt_sm_InfoList.Add(dt_sm_Info); } dt_Settings.dt_sm_Info = dt_sm_InfoList; dt_Settings.dt_qm_Info = dt_qm_InfoList; dt_Settings.dt_InfoList = dt_InfoList; return(dt_Settings); }
/// <summary> /// 获取本次检测的结果 /// </summary> /// <param name="code">编号</param> /// <returns></returns> // public Model_dt_Settings Getdt_SettingsResByCode(string code) // { // string sql = @"select t.*,t1.info_DangH,t2.qm_Z_FC,t2.qm_F_FC,t2.qm_Z_MJ,t2.qm_F_MJ,t3.sm_PaDesc,t3.sm_Pa,t3.sm_Remark, // qm_s_z_fj100,qm_s_z_fj150,qm_j_z_fj100,qm_s_z_zd100,qm_s_z_zd150,qm_j_z_zd100,qm_s_f_fj100,qm_s_f_fj150,qm_j_f_fj100,qm_s_f_zd100,qm_s_f_zd150,qm_j_f_zd100 //from dt_Settings t // left join dt_Info t1 on t.dt_Code = t1.dt_Code // left join dt_qm_Info t2 on t2.dt_Code = t1.dt_Code and t1.info_DangH = t2.info_DangH // where t.dt_Code ='" + code + "'"; // DataRow dr = SQLiteHelper.ExecuteDataRow(sql); // if (dr == null) // return null; // DataTable dt = dr.Table; // Model_dt_Settings dt_Settings = new Model_dt_Settings(); // List<Model_dt_Info> dt_InfoList = new List<Model_dt_Info>(); // List<Model_dt_qm_Info> dt_qm_InfoList = new List<Model_dt_qm_Info>(); // List<Model_dt_sm_Info> dt_sm_InfoList = new List<Model_dt_sm_Info>(); // for (int i = 0; i < dt.Rows.Count; i++) // { // Model_dt_Info dt_Info = new Model_dt_Info(); // Model_dt_qm_Info dt_qm_Info = new Model_dt_qm_Info(); // Model_dt_sm_Info dt_sm_Info = new Model_dt_sm_Info(); // if (i == 0) // { // dt_Settings.WeiTuoBianHao = dt.Rows[i]["WeiTuoBianHao"].ToString(); // dt_Settings.WeiTuoDanWei = dt.Rows[i]["WeiTuoDanWei"].ToString(); // dt_Settings.WeiTuoRen = dt.Rows[i]["WeiTuoRen"].ToString(); // dt_Settings.YangPinMingCheng = dt.Rows[i]["YangPinMingCheng"].ToString(); // dt_Settings.CaiYangFangShi = dt.Rows[i]["CaiYangFangShi"].ToString(); // dt_Settings.JianYanXiangMu = dt.Rows[i]["JianYanXiangMu"].ToString(); // dt_Settings.GuiGeXingHao = dt.Rows[i]["GuiGeXingHao"].ToString(); // dt_Settings.GuiGeShuLiang = dt.Rows[i]["GuiGeShuLiang"].ToString(); // dt_Settings.JianYanRiQi = dt.Rows[i]["JianYanRiQi"].ToString(); // dt_Settings.KaiQiFangShi = dt.Rows[i]["KaiQiFangShi"].ToString(); // dt_Settings.DaQiYaLi = dt.Rows[i]["DaQiYaLi"].ToString(); // dt_Settings.BoLiPinZhong = dt.Rows[i]["BoLiPinZhong"].ToString(); // dt_Settings.DangQianWenDu = dt.Rows[i]["DangQianWenDu"].ToString(); // dt_Settings.BoLiHouDu = dt.Rows[i]["BoLiHouDu"].ToString(); // dt_Settings.ZongMianJi = dt.Rows[i]["ZongMianJi"].ToString(); // dt_Settings.ZuiDaBoLi = dt.Rows[i]["ZuiDaBoLi"].ToString(); // dt_Settings.KaiQiFengChang = dt.Rows[i]["KaiQiFengChang"].ToString(); // dt_Settings.BoLiMiFeng = dt.Rows[i]["BoLiMiFeng"].ToString(); // dt_Settings.XiangQianFangShi = dt.Rows[i]["XiangQianFangShi"].ToString(); // dt_Settings.ShuiMiDengJiSheJiZhi = dt.Rows[i]["ShuiMiDengJiSheJiZhi"].ToString(); // dt_Settings.KuangShanMiFang = dt.Rows[i]["KuangShanMiFang"].ToString(); // dt_Settings.QiMiZhengYaDanWeiFengChangSheJiZhi = dt.Rows[i]["QiMiZhengYaDanWeiFengChangSheJiZhi"].ToString(); // dt_Settings.ZhengYaQiMiDengJiSheJiZhi = dt.Rows[i]["ZhengYaQiMiDengJiSheJiZhi"].ToString(); // dt_Settings.QiMiFuYaDanWeiFengChangSheJiZhi = dt.Rows[i]["QiMiFuYaDanWeiFengChangSheJiZhi"].ToString(); // dt_Settings.FuYaQiMiDengJiSheJiZhi = dt.Rows[i]["FuYaQiMiDengJiSheJiZhi"].ToString(); // dt_Settings.ShuiMiSheJiZhi = dt.Rows[i]["ShuiMiSheJiZhi"].ToString(); // dt_Settings.QiMiZhengYaDanWeiMianJiSheJiZhi = dt.Rows[i]["QiMiZhengYaDanWeiMianJiSheJiZhi"].ToString(); // dt_Settings.QiMiFuYaDanWeiMianJiSheJiZhi = dt.Rows[i]["QiMiFuYaDanWeiMianJiSheJiZhi"].ToString(); // dt_Settings.JianYanYiJu = dt.Rows[i]["JianYanYiJu"].ToString(); // dt_Settings.GongChengMingCheng = dt.Rows[i]["GongChengMingCheng"].ToString(); // dt_Settings.GongChengDiDian = dt.Rows[i]["GongChengDiDian"].ToString(); // dt_Settings.ShengChanDanWei = dt.Rows[i]["ShengChanDanWei"].ToString(); // dt_Settings.JianLiDanWei = dt.Rows[i]["JianLiDanWei"].ToString(); // dt_Settings.JianZhengRen = dt.Rows[i]["JianZhengRen"].ToString(); // dt_Settings.JianZhengHao = dt.Rows[i]["JianZhengHao"].ToString(); // dt_Settings.ShiGongDanWei = dt.Rows[i]["ShiGongDanWei"].ToString(); // dt_Settings.WuJinJianZhuangKuang = dt.Rows[i]["WuJinJianZhuangKuang"].ToString(); // dt_Settings.SuLiaoChuangChenJinChiCun = dt.Rows[i]["SuLiaoChuangChenJinChiCun"].ToString(); // dt_Settings.ShiFouJiaLuoSi = dt.Rows[i]["ShiFouJiaLuoSi"].ToString(); // dt_Settings.XingCaiGuiGe = dt.Rows[i]["XingCaiGuiGe"].ToString(); // dt_Settings.XingCaiBiHou = dt.Rows[i]["XingCaiBiHou"].ToString(); // dt_Settings.XingCaiShengChanChang = dt.Rows[i]["XingCaiShengChanChang"].ToString(); // dt_Settings.dt_Code = dt.Rows[i]["dt_Code"].ToString(); // dt_Settings.dt_Create = DateTime.Parse(dt.Rows[i]["dt_Create"].ToString()); // dt_Settings.GanJianChangDu = dt.Rows[i]["GanJianChangDu"].ToString(); // dt_Settings.KangFengYaDengJiSheJiZhi = dt.Rows[i]["KangFengYaDengJiSheJiZhi"].ToString(); // dt_Settings.KangFengYaSheJiZhi = dt.Rows[i]["KangFengYaSheJiZhi"].ToString(); // dt_Settings.DanShanDanSuoDian = dt.Rows[i]["DanShanDanSuoDian"].ToString(); // } // dt_Info.dt_Code = dt.Rows[i]["dt_Code"].ToString(); // dt_Info.info_Create = ""; // dt_Info.info_DangH = dt.Rows[i]["info_DangH"].ToString(); // dt_InfoList.Add(dt_Info); // dt_qm_Info.dt_Code = dt.Rows[i]["dt_Code"].ToString(); // dt_qm_Info.info_DangH = dt.Rows[i]["info_DangH"].ToString(); // dt_qm_Info.qm_F_FC = dt.Rows[i]["qm_F_FC"].ToString(); // dt_qm_Info.qm_F_MJ = dt.Rows[i]["qm_F_MJ"].ToString(); // dt_qm_Info.qm_Z_FC = dt.Rows[i]["qm_Z_FC"].ToString(); // dt_qm_Info.qm_Z_MJ = dt.Rows[i]["qm_Z_MJ"].ToString(); // dt_qm_Info.qm_s_z_fj100 = dt.Rows[i]["qm_s_z_fj100"].ToString(); // dt_qm_Info.qm_s_z_fj150 = dt.Rows[i]["qm_s_z_fj150"].ToString(); // dt_qm_Info.qm_j_z_fj100 = dt.Rows[i]["qm_j_z_fj100"].ToString(); // dt_qm_Info.qm_s_z_zd100 = dt.Rows[i]["qm_s_z_zd100"].ToString(); // dt_qm_Info.qm_s_z_zd150 = dt.Rows[i]["qm_s_z_zd150"].ToString(); // dt_qm_Info.qm_j_z_zd100 = dt.Rows[i]["qm_j_z_zd100"].ToString(); // dt_qm_Info.qm_s_f_fj100 = dt.Rows[i]["qm_s_f_fj100"].ToString(); // dt_qm_Info.qm_s_f_fj150 = dt.Rows[i]["qm_s_f_fj150"].ToString(); // dt_qm_Info.qm_j_f_fj100 = dt.Rows[i]["qm_j_f_fj100"].ToString(); // dt_qm_Info.qm_s_f_zd100 = dt.Rows[i]["qm_s_f_zd100"].ToString(); // dt_qm_Info.qm_s_f_zd150 = dt.Rows[i]["qm_s_f_zd150"].ToString(); // dt_qm_Info.qm_j_f_zd100 = dt.Rows[i]["qm_j_f_zd100"].ToString(); // dt_qm_InfoList.Add(dt_qm_Info); // dt_sm_Info.dt_Code = dt.Rows[i]["dt_Code"].ToString(); // dt_sm_Info.info_DangH = dt.Rows[i]["info_DangH"].ToString(); // dt_sm_Info.sm_Pa = dt.Rows[i]["sm_Pa"].ToString(); // dt_sm_Info.sm_PaDesc = dt.Rows[i]["sm_PaDesc"].ToString(); // dt_sm_Info.sm_Remark = dt.Rows[i]["sm_Remark"].ToString(); // dt_sm_InfoList.Add(dt_sm_Info); // } // dt_Settings.dt_sm_Info = dt_sm_InfoList; // dt_Settings.dt_qm_Info = dt_qm_InfoList; // dt_Settings.dt_InfoList = dt_InfoList; // return dt_Settings; // } /// <summary> /// 根据编号获取本次检测信息 /// </summary> /// <param name="code"></param> /// <returns></returns> public Model_dt_Settings GetInfoByCode(string code) { Model_dt_Settings settings = new Model_dt_Settings(); var dt_Info = SQLiteHelper.ExecuteDataRow("select * from dt_Info where dt_Code='" + code + "' order by info_DangH")?.Table; if (dt_Info != null) { List <Model_dt_Info> list = new List <Model_dt_Info>(); foreach (DataRow item in dt_Info.Rows) { #region Model_dt_Info model = new Model_dt_Info(); model.dt_Code = item["dt_Code"].ToString(); model.info_Create = item["info_Create"].ToString(); model.info_DangH = item["info_DangH"].ToString(); model.Watertight = Convert.ToInt32(item["Watertight"].ToString()); model.WindPressure = Convert.ToInt32(item["WindPressure"].ToString()); model.Airtight = Convert.ToInt32(item["Airtight"].ToString()); list.Add(model); #endregion } if (list.Count > 0) { settings.dt_InfoList = list; } } var dt_qm_Info = SQLiteHelper.ExecuteDataRow("select * from dt_qm_Info where dt_Code='" + code + "' order by info_DangH")?.Table; if (dt_qm_Info != null) { List <Model_dt_qm_Info> list = new List <Model_dt_qm_Info>(); foreach (DataRow item in dt_qm_Info.Rows) { #region Model_dt_qm_Info model = new Model_dt_qm_Info(); model.dt_Code = item["dt_Code"].ToString(); model.info_DangH = item["info_DangH"].ToString(); model.qm_Z_FC = item["qm_Z_FC"].ToString(); model.qm_F_FC = item["qm_F_FC"].ToString(); model.qm_Z_MJ = item["qm_Z_MJ"].ToString(); model.qm_F_MJ = item["qm_F_MJ"].ToString(); model.qm_s_z_fj100 = item["qm_s_z_fj100"].ToString(); model.qm_s_z_fj150 = item["qm_s_z_fj150"].ToString(); model.qm_j_z_fj100 = item["qm_j_z_fj100"].ToString(); model.qm_s_z_zd100 = item["qm_s_z_zd100"].ToString(); model.qm_s_z_zd150 = item["qm_s_z_zd150"].ToString(); model.qm_j_z_zd100 = item["qm_j_z_zd100"].ToString(); model.qm_s_f_fj100 = item["qm_s_f_fj100"].ToString(); model.qm_s_f_fj150 = item["qm_s_f_fj150"].ToString(); model.qm_j_f_fj100 = item["qm_j_f_fj100"].ToString(); model.qm_s_f_zd100 = item["qm_s_f_zd100"].ToString(); model.qm_s_f_zd150 = item["qm_s_f_zd150"].ToString(); model.qm_j_f_zd100 = item["qm_j_f_zd100"].ToString(); list.Add(model); #endregion } if (list.Count > 0) { settings.dt_qm_Info = list; } } var dt_sm_Info = SQLiteHelper.ExecuteDataRow("select * from dt_sm_Info where dt_Code='" + code + "' order by info_DangH")?.Table; if (dt_sm_Info != null) { List <Model_dt_sm_Info> list = new List <Model_dt_sm_Info>(); foreach (DataRow item in dt_sm_Info.Rows) { #region Model_dt_sm_Info model = new Model_dt_sm_Info(); model.dt_Code = item["dt_Code"].ToString(); model.info_DangH = item["info_DangH"].ToString(); model.sm_PaDesc = item["sm_PaDesc"].ToString(); model.sm_Pa = item["sm_Pa"].ToString(); model.sm_Remark = item["sm_Remark"].ToString(); list.Add(model); #endregion } if (list.Count > 0) { settings.dt_sm_Info = list; } } var dt_kfy_Info = SQLiteHelper.ExecuteDataRow("select * from dt_kfy_Info where dt_Code='" + code + "' order by info_DangH")?.Table; if (dt_kfy_Info != null) { List <Model_dt_kfy_Info> list = new List <Model_dt_kfy_Info>(); foreach (DataRow item in dt_kfy_Info.Rows) { #region Model_dt_kfy_Info model = new Model.DataBase.Model_dt_kfy_Info(); model.z_one_250 = item["z_one_250"].ToString(); model.z_two_250 = item["z_two_250"].ToString(); model.z_three_250 = item["z_three_250"].ToString(); model.z_nd_250 = item["z_nd_250"].ToString(); model.z_ix_250 = item["z_ix_250"].ToString(); model.f_one_250 = item["f_one_250"].ToString(); model.f_two_250 = item["f_two_250"].ToString(); model.f_three_250 = item["f_three_250"].ToString(); model.f_nd_250 = item["f_nd_250"].ToString(); model.f_ix_250 = item["f_ix_250"].ToString(); model.z_one_500 = item["z_one_500"].ToString(); model.z_two_500 = item["z_two_500"].ToString(); model.z_three_500 = item["z_three_500"].ToString(); model.z_nd_500 = item["z_nd_500"].ToString(); model.z_ix_500 = item["z_ix_500"].ToString(); model.f_one_500 = item["f_one_500"].ToString(); model.f_two_500 = item["f_two_500"].ToString(); model.f_three_500 = item["f_three_500"].ToString(); model.f_nd_500 = item["f_nd_500"].ToString(); model.f_ix_500 = item["f_ix_500"].ToString(); model.z_one_750 = item["z_one_750"].ToString(); model.z_two_750 = item["z_two_750"].ToString(); model.z_three_750 = item["z_three_750"].ToString(); model.z_nd_750 = item["z_nd_750"].ToString(); model.z_ix_750 = item["z_ix_750"].ToString(); model.f_one_750 = item["f_one_750"].ToString(); model.f_two_750 = item["f_two_750"].ToString(); model.f_three_750 = item["f_three_750"].ToString(); model.f_nd_750 = item["f_nd_750"].ToString(); model.f_ix_750 = item["f_ix_750"].ToString(); model.z_one_1000 = item["z_one_1000"].ToString(); model.z_two_1000 = item["z_two_1000"].ToString(); model.z_three_1000 = item["z_three_1000"].ToString(); model.z_nd_1000 = item["z_nd_1000"].ToString(); model.z_ix_1000 = item["z_ix_1000"].ToString(); model.f_one_1000 = item["f_one_1000"].ToString(); model.f_two_1000 = item["f_two_1000"].ToString(); model.f_three_1000 = item["f_three_1000"].ToString(); model.f_nd_1000 = item["f_nd_1000"].ToString(); model.f_ix_1000 = item["f_ix_1000"].ToString(); model.z_one_1250 = item["z_one_1250"].ToString(); model.z_two_1250 = item["z_two_1250"].ToString(); model.z_three_1250 = item["z_three_1250"].ToString(); model.z_nd_1250 = item["z_nd_1250"].ToString(); model.z_ix_1250 = item["z_ix_1250"].ToString(); model.f_one_1250 = item["f_one_1250"].ToString(); model.f_two_1250 = item["f_two_1250"].ToString(); model.f_three_1250 = item["f_three_1250"].ToString(); model.f_nd_1250 = item["f_nd_1250"].ToString(); model.f_ix_1250 = item["f_ix_1250"].ToString(); model.z_one_1500 = item["z_one_1500"].ToString(); model.z_two_1500 = item["z_two_1500"].ToString(); model.z_three_1500 = item["z_three_1500"].ToString(); model.z_nd_1500 = item["z_nd_1500"].ToString(); model.z_ix_1500 = item["z_ix_1500"].ToString(); model.f_one_1500 = item["f_one_1500"].ToString(); model.f_two_1500 = item["f_two_1500"].ToString(); model.f_three_1500 = item["f_three_1500"].ToString(); model.f_nd_1500 = item["f_nd_1500"].ToString(); model.f_ix_1500 = item["f_ix_1500"].ToString(); model.z_one_1750 = item["z_one_1750"].ToString(); model.z_two_1750 = item["z_two_1750"].ToString(); model.z_three_1750 = item["z_three_1750"].ToString(); model.z_nd_1750 = item["z_nd_1750"].ToString(); model.z_ix_1750 = item["z_ix_1750"].ToString(); model.f_one_1750 = item["f_one_1750"].ToString(); model.f_two_1750 = item["f_two_1750"].ToString(); model.f_three_1750 = item["f_three_1750"].ToString(); model.f_nd_1750 = item["f_nd_1750"].ToString(); model.f_ix_1750 = item["f_ix_1750"].ToString(); model.z_one_2000 = item["z_one_2000"].ToString(); model.z_two_2000 = item["z_two_2000"].ToString(); model.z_three_2000 = item["z_three_2000"].ToString(); model.z_nd_2000 = item["z_nd_2000"].ToString(); model.z_ix_2000 = item["z_ix_2000"].ToString(); model.f_one_2000 = item["f_one_2000"].ToString(); model.f_two_2000 = item["f_two_2000"].ToString(); model.f_three_2000 = item["f_three_2000"].ToString(); model.f_nd_2000 = item["f_nd_2000"].ToString(); model.f_ix_2000 = item["f_ix_2000"].ToString(); list.Add(model); #endregion } if (list.Count > 0) { settings.dt_kfy_Info = list; } } return(settings); }
/// <summary> /// 根据编号获取本次检测信息 /// </summary> /// <param name="code"></param> /// <returns></returns> public Model_dt_Settings GetInfoByCode(string code) { Model_dt_Settings settings = new Model_dt_Settings(); var dt_settings = SQLiteHelper.ExecuteDataRow("select * from dt_settings where dt_Code='" + code + "'")?.Table; settings.weituobianhao = dt_settings.Rows[0]["weituobianhao"].ToString(); settings.weituodanwei = dt_settings.Rows[0]["weituodanwei"].ToString(); settings.dizhi = dt_settings.Rows[0]["dizhi"].ToString(); settings.dianhua = dt_settings.Rows[0]["dianhua"].ToString(); settings.chouyangriqi = dt_settings.Rows[0]["chouyangriqi"].ToString(); settings.chouyangdidian = dt_settings.Rows[0]["chouyangdidian"].ToString(); settings.gongchengmingcheng = dt_settings.Rows[0]["gongchengmingcheng"].ToString(); settings.gongchengdidian = dt_settings.Rows[0]["gongchengdidian"].ToString(); settings.shengchandanwei = dt_settings.Rows[0]["shengchandanwei"].ToString(); settings.jiancexiangmu = dt_settings.Rows[0]["jiancexiangmu"].ToString(); settings.jiancedidian = dt_settings.Rows[0]["jiancedidian"].ToString(); settings.jianceriqi = dt_settings.Rows[0]["jianceriqi"].ToString(); settings.jianceshebei = dt_settings.Rows[0]["jianceshebei"].ToString(); settings.jianceyiju = dt_settings.Rows[0]["jianceyiju"].ToString(); settings.yangpinmingcheng = dt_settings.Rows[0]["yangpinmingcheng"].ToString(); settings.yangpinshangbiao = dt_settings.Rows[0]["yangpinshangbiao"].ToString(); settings.yangpinzhuangtai = dt_settings.Rows[0]["yangpinzhuangtai"].ToString(); settings.guigexinghao = dt_settings.Rows[0]["guigexinghao"].ToString(); settings.kaiqifangshi = dt_settings.Rows[0]["kaiqifangshi"].ToString(); settings.mianbanpinzhong = dt_settings.Rows[0]["mianbanpinzhong"].ToString(); settings.zuidamianban = dt_settings.Rows[0]["zuidamianban"].ToString(); settings.mianbanhoudu = dt_settings.Rows[0]["mianbanhoudu"].ToString(); settings.anzhuangfangshi = dt_settings.Rows[0]["anzhuangfangshi"].ToString(); settings.mianbanxiangqian = dt_settings.Rows[0]["mianbanxiangqian"].ToString(); settings.kuangshanmifeng = dt_settings.Rows[0]["kuangshanmifeng"].ToString(); settings.wujinpeijian = dt_settings.Rows[0]["wujinpeijian"].ToString(); settings.jianceshuliang = dt_settings.Rows[0]["jianceshuliang"].ToString(); settings.dangqiandanghao = dt_settings.Rows[0]["dangqiandanghao"].ToString(); settings.dangqianwendu = dt_settings.Rows[0]["dangqianwendu"].ToString(); settings.daqiyali = dt_settings.Rows[0]["daqiyali"].ToString(); settings.kaiqifengchang = dt_settings.Rows[0]["kaiqifengchang"].ToString(); settings.shijianmianji = dt_settings.Rows[0]["shijianmianji"].ToString(); settings.ganjianchangdu = dt_settings.Rows[0]["ganjianchangdu"].ToString(); settings.penlinshuiliang = dt_settings.Rows[0]["penlinshuiliang"].ToString(); settings.qimidanweifengchangshejizhi = dt_settings.Rows[0]["qimidanweifengchangshejizhi"].ToString(); settings.qimidanweimianjishejizhi = dt_settings.Rows[0]["qimidanweimianjishejizhi"].ToString(); settings.shuimijingyashejizhi = dt_settings.Rows[0]["shuimijingyashejizhi"].ToString(); settings.shuimidongyashejizhi = dt_settings.Rows[0]["shuimidongyashejizhi"].ToString(); settings.kangfengyazhengyashejizhi = dt_settings.Rows[0]["kangfengyazhengyashejizhi"].ToString(); settings.kangfengyafuyashejizhi = dt_settings.Rows[0]["kangfengyafuyashejizhi"].ToString(); settings.danshandansuodian = dt_settings.Rows[0]["danshandansuodian"].ToString(); settings.dt_Code = dt_settings.Rows[0]["dt_Code"].ToString(); var dt_Info = SQLiteHelper.ExecuteDataRow("select * from dt_Info where dt_Code='" + code + "' order by info_DangH")?.Table; if (dt_Info != null) { List <Model_dt_Info> list = new List <Model_dt_Info>(); foreach (DataRow item in dt_Info.Rows) { #region Model_dt_Info model = new Model_dt_Info(); model.dt_Code = item["dt_Code"].ToString(); model.info_Create = item["info_Create"].ToString(); model.info_DangH = item["info_DangH"].ToString(); model.Watertight = Convert.ToInt32(item["Watertight"].ToString()); model.WindPressure = Convert.ToInt32(item["WindPressure"].ToString()); model.Airtight = Convert.ToInt32(item["Airtight"].ToString()); list.Add(model); #endregion } if (list.Count > 0) { settings.dt_InfoList = list; } } var dt_qm_Info = SQLiteHelper.ExecuteDataRow("select * from dt_qm_Info where dt_Code='" + code + "' order by info_DangH")?.Table; if (dt_qm_Info != null) { List <Model_dt_qm_Info> list = new List <Model_dt_qm_Info>(); foreach (DataRow item in dt_qm_Info.Rows) { #region Model_dt_qm_Info model = new Model_dt_qm_Info(); model.dt_Code = item["dt_Code"].ToString(); model.info_DangH = item["info_DangH"].ToString(); model.qm_Z_FC = item["qm_Z_FC"].ToString(); model.qm_F_FC = item["qm_F_FC"].ToString(); model.qm_Z_MJ = item["qm_Z_MJ"].ToString(); model.qm_F_MJ = item["qm_F_MJ"].ToString(); model.qm_s_z_fj100 = item["qm_s_z_fj100"].ToString(); model.qm_s_z_fj150 = item["qm_s_z_fj150"].ToString(); model.qm_j_z_fj100 = item["qm_j_z_fj100"].ToString(); model.qm_s_z_zd100 = item["qm_s_z_zd100"].ToString(); model.qm_s_z_zd150 = item["qm_s_z_zd150"].ToString(); model.qm_j_z_zd100 = item["qm_j_z_zd100"].ToString(); model.qm_s_f_fj100 = item["qm_s_f_fj100"].ToString(); model.qm_s_f_fj150 = item["qm_s_f_fj150"].ToString(); model.qm_j_f_fj100 = item["qm_j_f_fj100"].ToString(); model.qm_s_f_zd100 = item["qm_s_f_zd100"].ToString(); model.qm_s_f_zd150 = item["qm_s_f_zd150"].ToString(); model.qm_j_f_zd100 = item["qm_j_f_zd100"].ToString(); list.Add(model); #endregion } if (list.Count > 0) { settings.dt_qm_Info = list; } } var dt_sm_Info = SQLiteHelper.ExecuteDataRow("select * from dt_sm_Info where dt_Code='" + code + "' order by info_DangH")?.Table; if (dt_sm_Info != null) { List <Model_dt_sm_Info> list = new List <Model_dt_sm_Info>(); foreach (DataRow item in dt_sm_Info.Rows) { #region Model_dt_sm_Info model = new Model_dt_sm_Info(); model.dt_Code = item["dt_Code"].ToString(); model.info_DangH = item["info_DangH"].ToString(); model.sm_PaDesc = item["sm_PaDesc"].ToString(); model.sm_Pa = item["sm_Pa"].ToString(); model.sm_Remark = item["sm_Remark"].ToString(); model.Method = item["Method"].ToString(); list.Add(model); #endregion } if (list.Count > 0) { settings.dt_sm_Info = list; } } var dt_kfy_Info = SQLiteHelper.ExecuteDataRow("select * from dt_kfy_Info where dt_Code='" + code + "' order by info_DangH")?.Table; if (dt_kfy_Info != null) { List <Model_dt_kfy_Info> list = new List <Model_dt_kfy_Info>(); foreach (DataRow item in dt_kfy_Info.Rows) { #region Model_dt_kfy_Info model = new Model.DataBase.Model_dt_kfy_Info(); model.z_one_250 = item["z_one_250"].ToString(); model.z_two_250 = item["z_two_250"].ToString(); model.z_three_250 = item["z_three_250"].ToString(); model.z_nd_250 = item["z_nd_250"].ToString(); model.z_ix_250 = item["z_ix_250"].ToString(); model.f_one_250 = item["f_one_250"].ToString(); model.f_two_250 = item["f_two_250"].ToString(); model.f_three_250 = item["f_three_250"].ToString(); model.f_nd_250 = item["f_nd_250"].ToString(); model.f_ix_250 = item["f_ix_250"].ToString(); model.z_one_500 = item["z_one_500"].ToString(); model.z_two_500 = item["z_two_500"].ToString(); model.z_three_500 = item["z_three_500"].ToString(); model.z_nd_500 = item["z_nd_500"].ToString(); model.z_ix_500 = item["z_ix_500"].ToString(); model.f_one_500 = item["f_one_500"].ToString(); model.f_two_500 = item["f_two_500"].ToString(); model.f_three_500 = item["f_three_500"].ToString(); model.f_nd_500 = item["f_nd_500"].ToString(); model.f_ix_500 = item["f_ix_500"].ToString(); model.z_one_750 = item["z_one_750"].ToString(); model.z_two_750 = item["z_two_750"].ToString(); model.z_three_750 = item["z_three_750"].ToString(); model.z_nd_750 = item["z_nd_750"].ToString(); model.z_ix_750 = item["z_ix_750"].ToString(); model.f_one_750 = item["f_one_750"].ToString(); model.f_two_750 = item["f_two_750"].ToString(); model.f_three_750 = item["f_three_750"].ToString(); model.f_nd_750 = item["f_nd_750"].ToString(); model.f_ix_750 = item["f_ix_750"].ToString(); model.z_one_1000 = item["z_one_1000"].ToString(); model.z_two_1000 = item["z_two_1000"].ToString(); model.z_three_1000 = item["z_three_1000"].ToString(); model.z_nd_1000 = item["z_nd_1000"].ToString(); model.z_ix_1000 = item["z_ix_1000"].ToString(); model.f_one_1000 = item["f_one_1000"].ToString(); model.f_two_1000 = item["f_two_1000"].ToString(); model.f_three_1000 = item["f_three_1000"].ToString(); model.f_nd_1000 = item["f_nd_1000"].ToString(); model.f_ix_1000 = item["f_ix_1000"].ToString(); model.z_one_1250 = item["z_one_1250"].ToString(); model.z_two_1250 = item["z_two_1250"].ToString(); model.z_three_1250 = item["z_three_1250"].ToString(); model.z_nd_1250 = item["z_nd_1250"].ToString(); model.z_ix_1250 = item["z_ix_1250"].ToString(); model.f_one_1250 = item["f_one_1250"].ToString(); model.f_two_1250 = item["f_two_1250"].ToString(); model.f_three_1250 = item["f_three_1250"].ToString(); model.f_nd_1250 = item["f_nd_1250"].ToString(); model.f_ix_1250 = item["f_ix_1250"].ToString(); model.z_one_1500 = item["z_one_1500"].ToString(); model.z_two_1500 = item["z_two_1500"].ToString(); model.z_three_1500 = item["z_three_1500"].ToString(); model.z_nd_1500 = item["z_nd_1500"].ToString(); model.z_ix_1500 = item["z_ix_1500"].ToString(); model.f_one_1500 = item["f_one_1500"].ToString(); model.f_two_1500 = item["f_two_1500"].ToString(); model.f_three_1500 = item["f_three_1500"].ToString(); model.f_nd_1500 = item["f_nd_1500"].ToString(); model.f_ix_1500 = item["f_ix_1500"].ToString(); model.z_one_1750 = item["z_one_1750"].ToString(); model.z_two_1750 = item["z_two_1750"].ToString(); model.z_three_1750 = item["z_three_1750"].ToString(); model.z_nd_1750 = item["z_nd_1750"].ToString(); model.z_ix_1750 = item["z_ix_1750"].ToString(); model.f_one_1750 = item["f_one_1750"].ToString(); model.f_two_1750 = item["f_two_1750"].ToString(); model.f_three_1750 = item["f_three_1750"].ToString(); model.f_nd_1750 = item["f_nd_1750"].ToString(); model.f_ix_1750 = item["f_ix_1750"].ToString(); model.z_one_2000 = item["z_one_2000"].ToString(); model.z_two_2000 = item["z_two_2000"].ToString(); model.z_three_2000 = item["z_three_2000"].ToString(); model.z_nd_2000 = item["z_nd_2000"].ToString(); model.z_ix_2000 = item["z_ix_2000"].ToString(); model.f_one_2000 = item["f_one_2000"].ToString(); model.f_two_2000 = item["f_two_2000"].ToString(); model.f_three_2000 = item["f_three_2000"].ToString(); model.f_nd_2000 = item["f_nd_2000"].ToString(); model.f_ix_2000 = item["f_ix_2000"].ToString(); model.p1 = item["p1"].ToString(); model.p2 = item["p2"].ToString(); model.p3 = item["p3"].ToString(); model.pMax = item["z_pMax"].ToString(); model._p1 = item["_p1"].ToString(); model._p2 = item["_p2"].ToString(); model._p3 = item["_p3"].ToString(); model._pMax = item["f_pMax"].ToString(); model.CheckLock = int.Parse(item["CheckLock"].ToString()); model.info_DangH = item["info_DangH"].ToString(); model.testtype = int.Parse(item["testtype"].ToString()); list.Add(model); #endregion } if (list.Count > 0) { settings.dt_kfy_Info = list; } } return(settings); }
public List <Model_dt_qm_Info> GetQMListByCode(string code) { List <Model_dt_qm_Info> list = new List <Model_dt_qm_Info>(); var dt_qm_Info = SQLiteHelper.ExecuteDataRow("select * from dt_qm_Info where dt_Code='" + code + "' order by info_DangH")?.Table; if (dt_qm_Info != null) { foreach (DataRow item in dt_qm_Info.Rows) { #region Model_dt_qm_Info model = new Model_dt_qm_Info(); model.dt_Code = item["dt_Code"].ToString(); model.info_DangH = item["info_DangH"].ToString(); model.qm_Z_FC = item["qm_Z_FC"].ToString(); model.qm_F_FC = item["qm_F_FC"].ToString(); model.qm_Z_MJ = item["qm_Z_MJ"].ToString(); model.qm_F_MJ = item["qm_F_MJ"].ToString(); model.qm_s_z_fj10 = item["qm_s_z_fj10"].ToString(); model.qm_s_z_fj30 = item["qm_s_z_fj30"].ToString(); model.qm_s_z_fj50 = item["qm_s_z_fj50"].ToString(); model.qm_s_z_fj70 = item["qm_s_z_fj70"].ToString(); model.qm_s_z_fj100 = item["qm_s_z_fj100"].ToString(); model.qm_s_z_fj150 = item["qm_s_z_fj150"].ToString(); model.qm_j_z_fj100 = item["qm_j_z_fj100"].ToString(); model.qm_j_z_fj70 = item["qm_j_z_fj70"].ToString(); model.qm_j_z_fj50 = item["qm_j_z_fj50"].ToString(); model.qm_j_z_fj30 = item["qm_j_z_fj30"].ToString(); model.qm_j_z_fj10 = item["qm_j_z_fj10"].ToString(); model.qm_s_z_zd10 = item["qm_s_z_zd10"].ToString(); model.qm_s_z_zd30 = item["qm_s_z_zd30"].ToString(); model.qm_s_z_zd50 = item["qm_s_z_zd50"].ToString(); model.qm_s_z_zd70 = item["qm_s_z_zd70"].ToString(); model.qm_s_z_zd100 = item["qm_s_z_zd100"].ToString(); model.qm_s_z_zd150 = item["qm_s_z_zd150"].ToString(); model.qm_j_z_zd100 = item["qm_j_z_zd100"].ToString(); model.qm_j_z_zd70 = item["qm_j_z_zd70"].ToString(); model.qm_j_z_zd50 = item["qm_j_z_zd50"].ToString(); model.qm_j_z_zd30 = item["qm_j_z_zd30"].ToString(); model.qm_j_z_zd10 = item["qm_j_z_zd10"].ToString(); model.qm_s_f_fj10 = item["qm_s_f_fj10"].ToString(); model.qm_s_f_fj30 = item["qm_s_f_fj30"].ToString(); model.qm_s_f_fj50 = item["qm_s_f_fj50"].ToString(); model.qm_s_f_fj70 = item["qm_s_f_fj70"].ToString(); model.qm_s_f_fj100 = item["qm_s_f_fj100"].ToString(); model.qm_s_f_fj150 = item["qm_s_f_fj150"].ToString(); model.qm_j_f_fj100 = item["qm_j_f_fj100"].ToString(); model.qm_j_f_fj70 = item["qm_j_f_fj70"].ToString(); model.qm_j_f_fj50 = item["qm_j_f_fj50"].ToString(); model.qm_j_f_fj30 = item["qm_j_f_fj30"].ToString(); model.qm_j_f_fj10 = item["qm_j_f_fj10"].ToString(); model.qm_s_f_zd10 = item["qm_s_f_zd10"].ToString(); model.qm_s_f_zd30 = item["qm_s_f_zd30"].ToString(); model.qm_s_f_zd50 = item["qm_s_f_zd50"].ToString(); model.qm_s_f_zd70 = item["qm_s_f_zd70"].ToString(); model.qm_s_f_zd100 = item["qm_s_f_zd100"].ToString(); model.qm_s_f_zd150 = item["qm_s_f_zd150"].ToString(); model.qm_j_f_zd100 = item["qm_j_f_zd100"].ToString(); model.qm_j_f_zd70 = item["qm_j_f_zd70"].ToString(); model.qm_j_f_zd50 = item["qm_j_f_zd50"].ToString(); model.qm_j_f_zd30 = item["qm_j_f_zd30"].ToString(); model.qm_j_f_zd10 = item["qm_j_f_zd10"].ToString(); model.testcount = int.Parse(item["testcount"].ToString()); model.testtype = item["testtype"]?.ToString(); model.sjz_z_fj = item["sjz_z_fj"]?.ToString(); model.sjz_z_zd = item["sjz_z_zd"]?.ToString(); model.sjz_f_zd = item["sjz_f_zd"]?.ToString(); model.sjz_f_fj = item["sjz_f_fj"]?.ToString(); model.sjz_value = item["sjz_value"]?.ToString(); list.Add(model); #endregion } } return(list); }