/// <summary> /// 水密数据处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_2sjcl_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(CheckPosition) || string.IsNullOrWhiteSpace(CheckProblem)) { MessageBox.Show("选择失去焦点,请重新选择检测记录!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } Model_dt_sm_Info model = new Model_dt_sm_Info(); model.dt_Code = _tempCode; model.info_DangH = _tempTong; model.sm_Pa = CheckValue.ToString(); model.sm_PaDesc = CheckPosition + "," + CheckProblem; model.sm_Remark = txt_desc.Text; if (this.rdb_bdjy.Checked == true) { model.Method = "波动加压"; } else { model.Method = "稳定加压"; } if (new DAL_dt_sm_Info().Add(model)) { MessageBox.Show("处理成功!", "完成", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public List <Model_dt_sm_Info> GetSMListByCode(string code) { List <Model_dt_sm_Info> list = new List <Model_dt_sm_Info>(); 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) { 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(); model.testcount = int.Parse(item["testcount"].ToString()); model.sxyl = item["sxyl"].ToString(); model.xxyl = item["xxyl"].ToString(); model.gongchengjiance = item["gongchengjiance"].ToString(); list.Add(model); #endregion } } return(list); }
/// <summary> /// 添加水密信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(Model_dt_sm_Info model) { //删除 SQLiteHelper.ExecuteNonQuery("delete from dt_sm_Info where dt_Code='" + model.dt_Code + "' and info_DangH = '" + model.info_DangH + "'"); var sql = string.Format("insert into dt_sm_Info (dt_Code,info_DangH,sm_PaDesc,sm_Pa,sm_Remark) values('{0}','{1}','{2}','{3}','{4}')", model.dt_Code, model.info_DangH, model.sm_PaDesc, model.sm_Pa, model.sm_Remark); var res = SQLiteHelper.ExecuteNonQuery(sql) > 0 ? true : false; if (res) { return(new DAL_dt_Info().UpdateTestType(model.dt_Code, model.info_DangH, PublicEnum.SystemItem.Watertight, 1)); } return(true); }
/// <summary> /// 添加水密信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(Model_dt_sm_Info model) { //删除 SQLiteHelper.ExecuteNonQuery("delete from dt_sm_Info where testcount=" + model.testcount + " and dt_Code='" + model.dt_Code + "' and info_DangH = '" + model.info_DangH + "'"); var sql = string.Format("insert into dt_sm_Info (dt_Code,info_DangH,sm_PaDesc,sm_Pa,sm_Remark,Method,testcount,sxyl,xxyl,gongchengjiance) values('{0}','{1}','{2}','{3}','{4}','{5}',{6},'{7}','{8}','{9}')", model.dt_Code, model.info_DangH, model.sm_PaDesc, model.sm_Pa, model.sm_Remark, model.Method, model.testcount, model.sxyl, model.xxyl, model.gongchengjiance); var res = SQLiteHelper.ExecuteNonQuery(sql) > 0 ? true : false; if (res) { return(new DAL_dt_Info().UpdateTestType(model.dt_Code, model.info_DangH, PublicEnum.SystemItem.Watertight, 1)); } return(true); }
/// <summary> /// 水密数据处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_2sjcl_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(CheckPosition) || string.IsNullOrWhiteSpace(CheckProblem)) { MessageBox.Show("选择失去焦点,请重新选择检测记录!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.ServiceNotification); return; } Model_dt_sm_Info model = new Model_dt_sm_Info(); model.dt_Code = _tempCode; model.info_DangH = _tempTong; model.sm_Pa = CheckValue.ToString(); model.sm_PaDesc = CheckPosition + "," + CheckProblem; model.sm_Remark = txt_desc.Text; if (new DAL_dt_sm_Info().Add(model)) { MessageBox.Show("处理成功!", "完成", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.ServiceNotification); } }
/// <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="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); }