/// <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);
}
