public void UpdateResult(Model_dt_Settings settings)
{
if (settings.dt_sm_Info != null && settings.dt_sm_Info.Count > 0)
{
var sql = "";
foreach (var item in settings.dt_sm_Info)
{
sql += $"update dt_sm_Info set sm_PaDesc = '{item.sm_PaDesc}', sm_Pa='{item.sm_Pa}', sm_Remark='{item.sm_Remark}' where dt_Code ='{item.dt_Code}' and info_DangH='{item.info_DangH}';";
}
SQLiteHelper.ExecuteNonQuery(sql);
}
if (settings.dt_qm_Info != null && settings.dt_qm_Info.Count > 0)
{
string sql = "";
foreach (var item in settings.dt_qm_Info)
{
sql += $"update dt_qm_Info set qm_Z_FC ='{item.qm_Z_FC}',qm_F_FC ='{item.qm_F_FC}',qm_Z_MJ ='{item.qm_Z_MJ}',qm_F_MJ ='{item.qm_F_MJ}' where dt_Code = '{item.dt_Code}' and info_DangH='{item.info_DangH}' ; ";
}
SQLiteHelper.ExecuteNonQuery(sql);
}
if (settings.dt_kfy_Info != null && settings.dt_kfy_Info.Count > 0)
{
string sql = "";
foreach (var item in settings.dt_kfy_Info)
{
sql += $"update dt_kfy_Info set p1 ='{item.p1}',p2 ='{item.p2}',p3='{item.p3}',_p1='{item._p1}' ,_p2='{item._p2}',_p3='{item._p3}' where dt_Code = '{item.dt_Code}' and info_DangH='{item.info_DangH}' ; ";
}
SQLiteHelper.ExecuteNonQuery(sql);
}
}
private Model_dt_Settings GetSettings()
{
Model_dt_Settings model = new Model_dt_Settings();
model.dt_Create = DateTime.Now;
model.dt_Code = this.btn_JianYanBianHao.Text;
model.weituobianhao = this.txt_WeiTuoBianHao.Text;
model.weituodanwei = this.txt_WeiTuoDanWei.Text;
model.dizhi = this.txt_dizhi.Text;
model.dianhua = this.txt_dianhua.Text;
model.chouyangriqi = this.txt_chouyangriqi.Text;
model.chouyangdidian = this.txt_chouyangdidian.Text;
model.gongchengmingcheng = this.txt_gongchengmingcheng.Text;
model.gongchengdidian = this.txt_gongchengdidian.Text;
model.shengchandanwei = this.txt_shengchandanwei.Text;
model.jiancexiangmu = this.cb_JianCeXiangMu.Text;
model.jiancedidian = this.txt_jiancedidian.Text;
model.jianceriqi = this.txt_JianCeRiQi.Text;
model.jianceshebei = this.txt_jianceshebei.Text;
model.jianceyiju = this.cb_jianceyiju.Text;
model.yangpinmingcheng = this.txt_YangPinMingCheng.Text;
model.yangpinshangbiao = this.txt_yangpinshangbiao.Text;
model.yangpinzhuangtai = this.txt_yangpinzhuangtai.Text;
model.guigexinghao = this.txt_GuiGeXingHao.Text;
model.kaiqifangshi = this.cb_KaiQiFangShi.Text;
model.mianbanpinzhong = this.cb_mianbanpinzhong.Text;
model.zuidamianban = this.txt_zuidamianban.Text;
model.mianbanhoudu = this.txt_mianbanhoudu.Text;
model.anzhuangfangshi = this.cb_anzhuangfangshi.Text;
model.mianbanxiangqian = this.cb_mianbanxiangqian.Text;
model.kuangshanmifeng = this.cb_KuangShanMiFang.Text;
model.wujinpeijian = this.txt_wujinpeijian.Text;
model.jianceshuliang = this.txt_jianceshuliang.Text;
model.dangqiandanghao = this.cb_DangQianDangHao.Text;
model.dangqianwendu = this.txt_DangQianWenDu.Text;
model.daqiyali = this.txt_DaQiYaLi.Text;
model.kaiqifengchang = this.txt_KaiQiFengChang.Text;
model.shijianmianji = this.txt_shijianmianji.Text;
model.ganjianchangdu = this.txt_ganjianchangdu.Text;
model.penlinshuiliang = this.txt_penlinshuiliang.Text;
model.qimidanweifengchangshejizhi = this.txt_qimidangweifengchangshejizhi.Text;
model.qimidanweimianjishejizhi = this.txt_QiMiDanWeiMianJiSheJiZhi.Text;
model.shuimijingyashejizhi = this.txt_shuimijingyashejizhi.Text;
model.shuimidongyashejizhi = this.txt_shuimidongyashejizhi.Text;
model.kangfengyazhengyashejizhi = this.txt_kangfengyazhengyashejizhi.Text;
model.kangfengyafuyashejizhi = this.txt_kangfengyafuyashejizhi.Text;
model.danshandansuodian = this.cbb_danshandansuodian.Text;
model.kangfengyazhengp3shejizhi = this.txt_kangfengyazhengp3shejizhi.Text;
model.kangfengyazhengpmaxshejizhi = this.txt_kangfengyazhengpmaxshejizhi.Text;
return(model);
}
private Model_dt_Settings GetSettings()
{
Model_dt_Settings model = new Model_dt_Settings();
model.dt_Create = DateTime.Now;
model.dt_Code = this.btn_JianYanBianHao.Text;
model.WeiTuoBianHao = this.btn_WeiTuoBianHao.Text;
model.WeiTuoDanWei = this.btn_WeiTuoDanWei.Text;
model.WeiTuoRen = this.btn_WeiTuoRen.Text;
model.YangPinMingCheng = this.btn_YangPinMingCheng.Text;
model.CaiYangFangShi = this.cb_CaiYangFangShi.Text;
model.JianYanXiangMu = this.cb_JianYanXiangMu.Text;
model.GuiGeXingHao = this.btn_GuiGeXingHao.Text;
model.GuiGeShuLiang = this.btn_GuiGeShuLiang.Text;
model.JianYanRiQi = this.btn_JianYanRiQi.Text;
model.KaiQiFangShi = this.cb_KaiQiFangShi.Text;
model.DaQiYaLi = this.btn_DaQiYaLi.Text;
model.BoLiPinZhong = this.cb_BoLiPinZhong.Text;
model.DangQianWenDu = this.btn_DangQianWenDu.Text;
model.BoLiHouDu = this.btn_BoLiHouDu.Text;
model.ZongMianJi = this.btn_ZongMianJi.Text;
model.ZuiDaBoLi = this.btn_ZuiDaBoLi.Text;
model.KaiQiFengChang = this.btn_KaiQiFengChang.Text;
model.BoLiMiFeng = this.cb_BoLiMiFeng.Text;
model.XiangQianFangShi = this.cb_XiangQianFangShi.Text;
model.ShuiMiDengJiSheJiZhi = this.btn_ShuiMiDengJiSheJiZhi.Text;
model.KuangShanMiFang = this.cb_KuangShanMiFang.Text;
model.QiMiZhengYaDanWeiFengChangSheJiZhi = this.btn_QiMiZhengYaDanWeiFengChangSheJiZhi.Text;
model.ZhengYaQiMiDengJiSheJiZhi = this.btn_ZhengYaQiMiDengJiSheJiZhi.Text;
model.QiMiFuYaDanWeiFengChangSheJiZhi = this.btn_QiMiFuYaDanWeiFengChangSheJiZhi.Text;
model.FuYaQiMiDengJiSheJiZhi = this.btn_FuYaQiMiDengJiSheJiZhi.Text;
model.ShuiMiSheJiZhi = this.btn_ShuiMiSheJiZhi.Text;
model.QiMiZhengYaDanWeiMianJiSheJiZhi = this.btn_QiMiZhengYaDanWeiMianJiSheJiZhi.Text;
model.QiMiFuYaDanWeiMianJiSheJiZhi = this.btn_QiMiFuYaDanWeiMianJiSheJiZhi.Text;
model.JianYanYiJu = this.cb_JianYanYiJu.Text;
model.GongChengMingCheng = this.btn_GongChengMingCheng.Text;
model.GongChengDiDian = this.btn_GongChengDiDian.Text;
model.ShengChanDanWei = this.btn_ShengChanDanWei.Text;
model.JianLiDanWei = this.btn_JianLiDanWei.Text;
model.JianZhengRen = this.btn_JianZhengRen.Text;
model.JianZhengHao = this.btn_JianZhengHao.Text;
model.ShiGongDanWei = this.btn_ShiGongDanWei.Text;
model.WuJinJianZhuangKuang = this.btn_WuJinJianZhuangKuang.Text;
model.SuLiaoChuangChenJinChiCun = this.btn_SuLiaoChuangChenJinChiCun.Text;
model.ShiFouJiaLuoSi = this.btn_ShiFouJiaLuoSi.Text;
model.XingCaiGuiGe = this.btn_XingCaiGuiGe.Text;
model.XingCaiBiHou = this.btn_XingCaiBiHou.Text;
model.XingCaiShengChanChang = this.btn_XingCaiShengChanChang.Text;
model.GanJianChangDu = this.txt_ganjianchadu.Text;
model.KangFengYaDengJiSheJiZhi = this.txt_KangFengyadengjishejizhi.Text;
model.KangFengYaSheJiZhi = this.txt_kangfengyashejizhi.Text;
model.DanShanDanSuoDian = this.cbb_danshandansuodian.Text;
return(model);
}
private Dictionary <string, string> GetTong2(Model_dt_Settings settings)
{
Dictionary <string, string> dc = new Dictionary <string, string>();
dc.Add("检测条件第0樘委托人", settings.WeiTuoRen);
dc.Add("检测条件第0樘委托单位", settings.WeiTuoDanWei);
dc.Add("检测条件第0樘委托编号", settings.WeiTuoBianHao);
dc.Add("检测条件第0樘工程名称", settings.GongChengMingCheng);
dc.Add("检测条件第0樘开启方式", settings.KaiQiFangShi);
dc.Add("检测条件第0樘样品名称", settings.YangPinMingCheng);
dc.Add("检测条件第0樘委托日期", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验编号", settings.dt_Code);
dc.Add("检测条件第0樘玻璃品种", settings.BoLiPinZhong);
dc.Add("检测条件第0樘玻璃密封", settings.BoLiMiFeng);
dc.Add("检测条件第0樘生产单位", settings.ShengChanDanWei);
dc.Add("检测条件第0樘镶嵌方式", settings.XiangQianFangShi);
dc.Add("检测条件第0樘框扇密封", settings.KuangShanMiFang);
dc.Add("检测条件第0樘检验日期", DateTime.Now.ToString("yyyy-MM-dd"));
dc.Add("检测条件第0樘检验日期1", DateTime.Now.ToString("yyyy-MM-dd"));
//dc.Add("检测条件第0樘资料编号", settings);
dc.Add("检测条件第0樘型号规格", settings.GuiGeXingHao);
if (settings.JianYanXiangMu == "水密性能检测" || settings.JianYanXiangMu == "气密性能及水密性能检测")
{
dc.Add("检测条件第0樘第一樘水密性能", settings.dt_sm_Info?.Find(t => t.info_DangH == "第1樘")?.sm_Pa ?? "0");
dc.Add("检测条件第0樘第二樘水密性能", settings.dt_sm_Info?.Find(t => t.info_DangH == "第2樘")?.sm_Pa ?? "0");
}
else
{
dc.Add("检测条件第0樘第一樘水密性能", "--");
dc.Add("检测条件第0樘第二樘水密性能", "--");
}
if (settings.JianYanXiangMu == "气密性能检测" || settings.JianYanXiangMu == "气密性能及水密性能检测")
{
dc.Add("检测条件第1樘正缝长渗透量", settings.dt_qm_Info?.Find(t => t.info_DangH == "第1樘")?.qm_Z_FC ?? "0");
dc.Add("检测条件第1樘正面积渗透量", settings.dt_qm_Info?.Find(t => t.info_DangH == "第1樘")?.qm_Z_MJ ?? "0");
dc.Add("检测条件第2樘正缝长渗透量", settings.dt_qm_Info?.Find(t => t.info_DangH == "第2樘")?.qm_Z_FC ?? "0");
dc.Add("检测条件第2樘正面积渗透量", settings.dt_qm_Info?.Find(t => t.info_DangH == "第2樘")?.qm_Z_MJ ?? "0");
}
else
{
dc.Add("检测条件第1樘正缝长渗透量", "--");
dc.Add("检测条件第1樘正面积渗透量", "--");
dc.Add("检测条件第2樘正缝长渗透量", "--");
dc.Add("检测条件第2樘正面积渗透量", "--");
}
return(dc);
}
public ComplexAssessment(string code)
{
InitializeComponent();
this._code = code;
if (!DefaultBase.IsSetTong)
{
MessageBox.Show("请先检测设定", "检测", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
DefaultBase.IsOpenComplexAssessment = false;
return;
}
this._settings = new DAL_dt_Settings().GetInfoByCode(_code);
InitResult();
}
/// <summary>
/// 获取不标准的等级
/// 范式 气密正负缝长平均值等级 与 气密正负压缝长平均值等级 最大的最次
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
private int Get_QMLevel(Model_dt_Settings settings, int type)
{
qm_z_FC = 0; qm_f_FC = 0; qm_z_MJ = 0; qm_f_MJ = 0;
for (int i = 0; i < settings.dt_qm_Info.Count; i++)
{
qm_z_FC += double.Parse(settings.dt_qm_Info[i].qm_Z_FC.ToString());
qm_f_FC += double.Parse(settings.dt_qm_Info[i].qm_F_FC.ToString());
qm_z_MJ += double.Parse(settings.dt_qm_Info[i].qm_Z_MJ.ToString());
qm_f_MJ += double.Parse(settings.dt_qm_Info[i].qm_F_MJ.ToString());
}
qm_z_FC = Math.Round(qm_z_FC / settings.dt_qm_Info.Count, 2);
qm_f_FC = Math.Round(qm_f_FC / settings.dt_qm_Info.Count, 2);
qm_z_MJ = Math.Round(qm_z_MJ / settings.dt_qm_Info.Count, 2);
qm_f_MJ = Math.Round(qm_f_MJ / settings.dt_qm_Info.Count, 2);
return(GetQM_MaxLevel(qm_z_FC, qm_f_FC, qm_z_MJ, qm_f_MJ, type));
}
/// <summary>
/// 获取水密等级
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
private int Get_SMLevel(Model_dt_Settings settings)
{
int qmValue = 0;
if (settings != null && settings.dt_qm_Info.Count > 0)
{
if (settings.dt_sm_Info.Count == 3)
{
List <int> list = new List <int>()
{
int.Parse(settings.dt_sm_Info[0].sm_Pa.ToString()), int.Parse(settings.dt_sm_Info[1].sm_Pa.ToString()), int.Parse(settings.dt_sm_Info[2].sm_Pa.ToString())
};
list.Sort();
int min = list[0], intermediate = list[1], max = list[2];
int minlevel = GetQMLevelList.Find(t => t.value == min).level,
intermediatelevel = GetQMLevelList.Find(t => t.value == intermediate).level,
maxlevel = GetQMLevelList.Find(t => t.value == max).level;
if ((maxlevel - intermediatelevel) > 2)
{
max = GetQMLevelList.Find(t => t.level == (intermediatelevel + 2)).value;
}
qmValue = (min + intermediate + max) / 3;
}
else
{
for (int i = 0; i < settings.dt_sm_Info.Count; i++)
{
if (string.IsNullOrWhiteSpace(settings.dt_sm_Info[0].sm_Pa))
{
qmValue = 0;
break;
}
qmValue += int.Parse(settings.dt_sm_Info[0].sm_Pa.ToString());
}
qmValue = qmValue / settings.dt_sm_Info.Count;
}
}
return(GetSMLevel(qmValue));
}
/// <summary>
/// 获取门窗检测报告文档
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
private Dictionary <string, string> GetDWDetectionReport(Model_dt_Settings settings)
{
Dictionary <string, string> dc = new Dictionary <string, string>();
dc.Add("检测条件第0樘型号规格", settings.GuiGeXingHao);
dc.Add("检测条件第0樘大气压力", settings.DaQiYaLi);
dc.Add("检测条件第0樘委托单位", settings.WeiTuoDanWei);
dc.Add("检测条件第0樘委托单位重复1", settings.WeiTuoDanWei);
dc.Add("检测条件第0樘工程名称", settings.GongChengMingCheng);
dc.Add("检测条件第0樘开启方式", settings.KaiQiFangShi);
dc.Add("检测条件第0樘开启缝长", settings.KaiQiFengChang);
dc.Add("检测条件第0樘当前温度", settings.DangQianWenDu);
dc.Add("检测条件第0樘总面积", settings.ZongMianJi);
dc.Add("检测条件第0樘最大玻璃", settings.ZuiDaBoLi);
dc.Add("检测条件第0樘来样方式", settings.CaiYangFangShi);
dc.Add("检测条件第0樘来样方式重复1", settings.CaiYangFangShi);
dc.Add("检测条件第0樘样品名称", settings.YangPinMingCheng);
dc.Add("检测条件第0樘样品名称重复1", settings.YangPinMingCheng);
dc.Add("检测条件第0樘框扇密封", settings.KuangShanMiFang);
dc.Add("检测条件第0樘检验数量", settings.GuiGeShuLiang);
dc.Add("检测条件第0樘检验日期", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验日期重复1", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验日期重复2", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验编号", settings.dt_Code);
dc.Add("检测条件第0樘检验编号重复1", settings.dt_Code);
dc.Add("检测条件第0樘检验编号重复2", settings.dt_Code);
dc.Add("检测条件第0樘检验编号重复3", settings.dt_Code);
dc.Add("检测条件第0樘检验项目", settings.JianYanXiangMu);
dc.Add("检测条件第0樘正压气密等级设计值", settings.ZhengYaQiMiDengJiSheJiZhi);
dc.Add("检测条件第0樘负压气密等级设计值", settings.FuYaQiMiDengJiSheJiZhi);
if (settings.dt_qm_Info.Count > 0)
{
var z_qm_level = formula.Get_Z_AirTightLevel(settings.dt_qm_Info);
dc.Add("检测条件第0樘综合气密正压等级", z_qm_level.ToString());
var f_qm_level = formula.Get_F_AirTightLevel(settings.dt_qm_Info);
dc.Add("检测条件第0樘综合气密负压等级", f_qm_level.ToString());
}
else
{
dc.Add("检测条件第0樘综合气密正压等级", "--");
dc.Add("检测条件第0樘综合气密负压等级", "--");
}
if (settings.dt_sm_Info.Count > 0)
{
var sm_level = formula.GetWaterTightLevel(settings.dt_sm_Info);
var YL = formula.GetWaterTightPressure(settings.dt_sm_Info);
dc.Add("检测条件第0樘水密等级", sm_level.ToString());
// dc.Add("检测条件第0樘水密等级设计值", sm_level.ToString());
dc.Add("检测条件第0樘水密等级设计值", settings.ShuiMiDengJiSheJiZhi.ToString());
dc.Add("检测条件第0樘水密保持风压", YL.ToString());
}
else
{
dc.Add("检测条件第0樘水密等级", "--");
dc.Add("检测条件第0樘水密等级设计值", "--");
dc.Add("检测条件第0樘水密保持风压", "--");
}
double zFc = 0, fFc = 0, zMj = 0, fMj = 0;
if (settings.dt_qm_Info != null && settings.dt_qm_Info.Count > 0)
{
zFc = Math.Round(settings.dt_qm_Info.Sum(t => double.Parse(t.qm_Z_FC)) / settings.dt_qm_Info.Count, 2);
fFc = Math.Round(settings.dt_qm_Info.Sum(t => double.Parse(t.qm_F_FC)) / settings.dt_qm_Info.Count, 2);
zMj = Math.Round(settings.dt_qm_Info.Sum(t => double.Parse(t.qm_Z_MJ)) / settings.dt_qm_Info.Count, 2);
fMj = Math.Round(settings.dt_qm_Info.Sum(t => double.Parse(t.qm_F_MJ)) / settings.dt_qm_Info.Count, 2);
}
dc.Add("检测条件第0樘正缝长渗透量", zFc.ToString());
dc.Add("检测条件第0樘负缝长渗透量", fFc.ToString());
dc.Add("检测条件第0樘正面积渗透量", zMj.ToString());
dc.Add("检测条件第0樘负面积渗透量", fMj.ToString());
dc.Add("检测条件第0樘玻璃品种", settings.BoLiPinZhong);
dc.Add("检测条件第0樘玻璃密封", settings.BoLiMiFeng);
dc.Add("检测条件第0樘生产单位", settings.ShengChanDanWei);
dc.Add("检测条件第0樘负责人", settings.WeiTuoRen);
dc.Add("检测条件第0樘镶嵌方式", settings.XiangQianFangShi);
return(dc);
}
/// <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>
public bool Add(Model_dt_Settings model, string tong)
{
var res = false;
string delsql = "delete from dt_Settings where dt_Code='" + model.dt_Code + "'";
SQLiteHelper.ExecuteNonQuery(delsql);
#region 添加主表
string sql = string.Format(@"
insert into dt_Settings
(
WeiTuoBianHao,
WeiTuoDanWei,
WeiTuoRen ,
YangPinMingCheng,
CaiYangFangShi , -- int
JianYanXiangMu , -- int
GuiGeXingHao,
GuiGeShuLiang ,
JianYanRiQi ,
KaiQiFangShi , -- int
DaQiYaLi,
BoLiPinZhong , -- int
DangQianWenDu ,
BoLiHouDu ,
ZongMianJi ,
ZuiDaBoLi ,
KaiQiFengChang ,
BoLiMiFeng , -- int
XiangQianFangShi , -- int
ShuiMiDengJiSheJiZhi ,
KuangShanMiFang , -- int
QiMiZhengYaDanWeiFengChangSheJiZhi ,
ZhengYaQiMiDengJiSheJiZhi ,
QiMiFuYaDanWeiFengChangSheJiZhi,
FuYaQiMiDengJiSheJiZhi ,
ShuiMiSheJiZhi ,
QiMiZhengYaDanWeiMianJiSheJiZhi ,
QiMiFuYaDanWeiMianJiSheJiZhi,
JianYanYiJu , -- int
GongChengMingCheng ,
GongChengDiDian,
ShengChanDanWei ,
JianLiDanWei,
JianZhengRen,
JianZhengHao ,
ShiGongDanWei ,
WuJinJianZhuangKuang ,
SuLiaoChuangChenJinChiCun ,
ShiFouJiaLuoSi ,
XingCaiGuiGe ,
XingCaiBiHou ,
XingCaiShengChanChang,
dt_Code,
dt_Create,
GanJianChangDu,
KangFengYaDengJiSheJiZhi,
KangFengYaSheJiZhi,
DanShanDanSuoDian
)
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}',datetime('now'),'{43}','{44}','{45}','{46}')",
model.WeiTuoBianHao,
model.WeiTuoDanWei,
model.WeiTuoRen,
model.YangPinMingCheng,
model.CaiYangFangShi,
model.JianYanXiangMu,
model.GuiGeXingHao,
model.GuiGeShuLiang,
model.JianYanRiQi,
model.KaiQiFangShi,
model.DaQiYaLi,
model.BoLiPinZhong,
model.DangQianWenDu,
model.BoLiHouDu,
model.ZongMianJi,
model.ZuiDaBoLi,
model.KaiQiFengChang,
model.BoLiMiFeng,
model.XiangQianFangShi,
model.ShuiMiDengJiSheJiZhi,
model.KuangShanMiFang,
model.QiMiZhengYaDanWeiFengChangSheJiZhi,
model.ZhengYaQiMiDengJiSheJiZhi,
model.QiMiFuYaDanWeiFengChangSheJiZhi,
model.FuYaQiMiDengJiSheJiZhi,
model.ShuiMiSheJiZhi,
model.QiMiZhengYaDanWeiMianJiSheJiZhi,
model.QiMiFuYaDanWeiMianJiSheJiZhi,
model.JianYanYiJu,
model.GongChengMingCheng,
model.GongChengDiDian,
model.ShengChanDanWei,
model.JianLiDanWei,
model.JianZhengRen,
model.JianZhengHao,
model.ShiGongDanWei,
model.WuJinJianZhuangKuang,
model.SuLiaoChuangChenJinChiCun,
model.ShiFouJiaLuoSi,
model.XingCaiGuiGe,
model.XingCaiBiHou,
model.XingCaiShengChanChang,
model.dt_Code,
model.GanJianChangDu,
model.KangFengYaDengJiSheJiZhi,
model.KangFengYaSheJiZhi,
model.DanShanDanSuoDian
);
res = SQLiteHelper.ExecuteNonQuery(sql) > 0 ? true : false;
#endregion
#region 添加实验樘号记录
if (res)
{
var table = SQLiteHelper.ExecuteDataRow("select * from dt_Info where info_DangH = '" + tong + "' and dt_Code = '" + model.dt_Code + "'")?.Table;
if (table == null || table.Rows.Count == 0)
{
sql = string.Format("insert into dt_Info (info_DangH,info_Create,dt_Code,Airtight,Watertight,WindPressure) values('{0}',datetime('now'),'{1}',0,0,0)", tong, model.dt_Code);
return(SQLiteHelper.ExecuteNonQuery(sql) > 0 ? true : false);
}
}
#endregion
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 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);
}
/// <summary>
/// 获取检测报告文档
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
private Dictionary <string, string> GetDetectionReport(Model_dt_Settings settings)
{
Dictionary <string, string> dc = new Dictionary <string, string>();
dc.Add("实验室气压", settings.DaQiYaLi);
dc.Add("实验室温度", settings.DangQianWenDu);
dc.Add("集流管经", (DefaultBase._D * 1000).ToString());
dc.Add("检测条件第0樘五金件状况", settings.WuJinJianZhuangKuang);
dc.Add("检测条件第0樘型号规格", settings.GuiGeXingHao);
dc.Add("检测条件第0樘大气压力", settings.DaQiYaLi);
dc.Add("检测条件第0樘委托单位", settings.WeiTuoDanWei);
dc.Add("检测条件第0樘委托单位重复1", settings.WeiTuoDanWei);
dc.Add("检测条件第0樘委托单位重复2", settings.WeiTuoDanWei);
dc.Add("检测条件第0樘委托单位重复3", settings.WeiTuoDanWei);
dc.Add("检测条件第0樘工程名称", settings.GongChengMingCheng);
dc.Add("检测条件第0樘工程地点", settings.GongChengDiDian);
dc.Add("检测条件第0樘开启缝长", settings.KaiQiFengChang);
dc.Add("检测条件第0樘开启缝长重复1", settings.KaiQiFengChang);
dc.Add("检测条件第0樘当前温度", settings.DangQianWenDu);
dc.Add("检测条件第0樘总面积", settings.ZongMianJi);
dc.Add("检测条件第0樘总面积重复2", settings.ZongMianJi);
dc.Add("检测条件第0樘最大玻璃", settings.ZuiDaBoLi);
dc.Add("检测条件第0樘来样方式", settings.CaiYangFangShi);
dc.Add("检测条件第0樘样品名称", settings.YangPinMingCheng);
dc.Add("检测条件第0樘样品名称重复1", settings.YangPinMingCheng);
dc.Add("检测条件第0樘样品名称重复2", settings.YangPinMingCheng);
dc.Add("检测条件第0樘样品名称重复3", settings.YangPinMingCheng);
dc.Add("检测条件第0樘框扇密封", settings.KuangShanMiFang);
dc.Add("检测条件第0樘检验数量", settings.GuiGeShuLiang);
dc.Add("检测条件第0樘检验编号", settings.dt_Code);
dc.Add("检测条件第0樘检验编号重复1", settings.dt_Code);
dc.Add("检测条件第0樘检验编号重复2", settings.dt_Code);
dc.Add("检测条件第0樘检验编号重复3", settings.dt_Code);
dc.Add("检测条件第0樘检验编号重复4", settings.dt_Code);
dc.Add("检测条件第0樘检验日期重复1", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验日期重复2", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验日期重复3", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验日期重复4", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验日期重复5", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验项目", settings.JianYanXiangMu);
dc.Add("检测条件第0樘正压气密等级设计值", settings.ZhengYaQiMiDengJiSheJiZhi);
dc.Add("检测条件第0樘水密等级设计值", settings.ShuiMiDengJiSheJiZhi);
dc.Add("检测条件第0樘玻璃厚度", settings.BoLiHouDu);
dc.Add("检测条件第0樘玻璃品种", settings.BoLiPinZhong);
dc.Add("检测条件第0樘玻璃密封", settings.BoLiMiFeng);
dc.Add("检测条件第0樘负压气密等级设计值", settings.FuYaQiMiDengJiSheJiZhi);
dc.Add("检测条件第0樘镶嵌方式", settings.XiangQianFangShi);
if (settings.JianYanXiangMu == "气密性能检测" || settings.JianYanXiangMu == "气密性能及水密性能检测")
{
#region 气密
var qm_zy_level = Get_QMLevel(settings, 1);
dc.Add("检测条件第0樘综合气密等级", qm_zy_level.ToString());
var qm_fy_level = Get_QMLevel(settings, 2);
dc.Add("检测条件气密性能负压属国标等级", qm_fy_level.ToString());
if (settings.dt_qm_Info != null && settings.dt_qm_Info.Count > 0)
{
Formula formula = new Formula();
for (int i = 0; i < settings.dt_qm_Info.Count; i++)
{
if (i == 0)
{
dc.Add("气密检测第1樘总的渗透正升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_zd100).ToString("#0.00"));
dc.Add("气密检测第1樘总的渗透正降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_z_zd100).ToString("#0.00"));
dc.Add("气密检测第1樘总的渗透负升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_zd100).ToString("#0.00"));
dc.Add("气密检测第1樘总的渗透负降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_f_zd100).ToString("#0.00"));
dc.Add("气密检测第1樘附加渗透负升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_fj150).ToString("#0.00"));
dc.Add("气密检测第1樘总的渗透负升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_zd150).ToString("#0.00"));
dc.Add("气密检测第1樘总的渗透正升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_zd150).ToString("#0.00"));
dc.Add("气密检测第1樘附加渗透正升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_fj150).ToString("#0.00"));
dc.Add("气密检测第1樘附加渗透正升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_fj100).ToString("#0.00"));
dc.Add("气密检测第1樘附加渗透正降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_z_fj100).ToString("#0.00"));
dc.Add("气密检测第1樘附加渗透负升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_fj100).ToString("#0.00"));
dc.Add("气密检测第1樘附加渗透负降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_f_fj100).ToString("#0.00"));
dc.Add("流量第一樘升100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_fj100)).ToString("#0.00"));
dc.Add("流量第一樘升150附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_fj150)).ToString("#0.00"));
dc.Add("流量第一樘负升150附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_fj150)).ToString("#0.00"));
dc.Add("流量第一樘负升100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_fj100)).ToString("#0.00"));
dc.Add("流量第一樘负升100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_zd100)).ToString("#0.00"));
dc.Add("流量第一樘升100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_zd100)).ToString("#0.00"));
dc.Add("流量第一樘升150总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_zd150)).ToString("#0.00"));
dc.Add("流量第一樘负升150总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_zd150)).ToString("#0.00"));
dc.Add("流量第一樘降100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_z_zd100)).ToString("#0.00"));
dc.Add("流量第一樘降100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_z_fj100)).ToString("#0.00"));
dc.Add("流量第一樘负降100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_f_zd100)).ToString("#0.00"));
dc.Add("流量第一樘负降100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_f_fj100)).ToString("#0.00"));
}
if (i == 1)
{
dc.Add("气密检测第2樘总的渗透正升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_zd100).ToString("#0.00"));
dc.Add("气密检测第2樘总的渗透正升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_zd150).ToString("#0.00"));
dc.Add("气密检测第2樘总的渗透负升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_zd150).ToString("#0.00"));
dc.Add("气密检测第2樘附加渗透负升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_fj150).ToString("#0.00"));
dc.Add("气密检测第2樘附加渗透正升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_fj150).ToString("#0.00"));
dc.Add("气密检测第2樘总的渗透正降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_z_zd100).ToString("#0.00"));
dc.Add("气密检测第2樘总的渗透负升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_zd100).ToString("#0.00"));
dc.Add("气密检测第2樘总的渗透负降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_f_zd100).ToString("#0.00"));
dc.Add("气密检测第2樘附加渗透正升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_fj100).ToString("#0.00"));
dc.Add("气密检测第2樘附加渗透正降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_z_fj100).ToString("#0.00"));
dc.Add("气密检测第2樘附加渗透负升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_fj100).ToString("#0.00"));
dc.Add("气密检测第2樘附加渗透负降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_f_fj100).ToString("#0.00"));
//第二樘
dc.Add("流量第二樘升100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_fj100)).ToString("#0.00"));
dc.Add("流量第二樘升150附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_fj150)).ToString("#0.00"));
dc.Add("流量第二樘负升150附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_fj150)).ToString("#0.00"));
dc.Add("流量第二樘负升100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_fj100)).ToString("#0.00"));
dc.Add("流量第二樘负升100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_zd100)).ToString("#0.00"));
dc.Add("流量第二樘升100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_zd100)).ToString("#0.00"));
dc.Add("流量第二樘升150总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_zd150)).ToString("#0.00"));
dc.Add("流量第二樘负升150总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_zd150)).ToString("#0.00"));
dc.Add("流量第二樘降100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_z_zd100)).ToString("#0.00"));
dc.Add("流量第二樘降100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_z_fj100)).ToString("#0.00"));
dc.Add("流量第二樘负降100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_f_zd100)).ToString("#0.00"));
dc.Add("流量第二樘负降100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_f_fj100)).ToString("#0.00"));
}
if (i == 2)
{
dc.Add("气密检测第3樘总的渗透正升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_zd100).ToString("#0.00"));
dc.Add("气密检测第3樘总的渗透正升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_zd150).ToString("#0.00"));
dc.Add("气密检测第3樘总的渗透负升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_zd150).ToString("#0.00"));
dc.Add("气密检测第3樘附加渗透负升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_fj150).ToString("#0.00"));
dc.Add("气密检测第3樘附加渗透正升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_fj150).ToString("#0.00"));
dc.Add("气密检测第3樘总的渗透正降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_z_zd100).ToString("#0.00"));
dc.Add("气密检测第3樘总的渗透负升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_zd100).ToString("#0.00"));
dc.Add("气密检测第3樘总的渗透负降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_f_zd100).ToString("#0.00"));
dc.Add("气密检测第3樘附加渗透正升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_fj100).ToString("#0.00"));
dc.Add("气密检测第3樘附加渗透正降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_z_fj100).ToString("#0.00"));
dc.Add("气密检测第3樘附加渗透负升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_fj100).ToString("#0.00"));
dc.Add("气密检测第3樘附加渗透负降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_f_fj100).ToString("#0.00"));
//流量
dc.Add("流量第三樘负升100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_zd100)).ToString("#0.00"));
dc.Add("流量第三樘升100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_zd100)).ToString("#0.00"));
dc.Add("流量第三樘负升100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_fj100)).ToString("#0.00"));
dc.Add("流量第三樘升100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_fj100)).ToString("#0.00"));
dc.Add("流量第三樘升150总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_zd150)).ToString("#0.00"));
dc.Add("流量第三樘负升150总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_zd150)).ToString("#0.00"));
dc.Add("流量第三樘升150附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_fj150)).ToString("#0.00"));
dc.Add("流量第三樘负升150附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_fj150)).ToString("#0.00"));
dc.Add("流量第三樘负降100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_f_zd100)).ToString("#0.00"));
dc.Add("流量第三樘降100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_z_zd100)).ToString("#0.00"));
dc.Add("流量第三樘降100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_z_fj100)).ToString("#0.00"));
dc.Add("流量第三樘负降100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_f_fj100)).ToString("#0.00"));
}
}
}
#endregion
}
else
{
dc.Add("检测条件第0樘综合气密等级", "--");
}
if (settings.JianYanXiangMu == "水密性能检测" || settings.JianYanXiangMu == "气密性能及水密性能检测")
{
#region 水密
var sm_level = Get_SMLevel(settings);
dc.Add("检测条件第0樘水密等级", sm_level.ToString());
if (settings.dt_sm_Info != null && settings.dt_sm_Info.Count > 0)
{
for (int i = 0; i < settings.dt_sm_Info.Count; i++)
{
string[] arr = settings.dt_sm_Info[i].sm_PaDesc.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
var one = "";
var two = "";
if (arr.Length == 0)
{
continue;
}
else if (arr.Length == 1)
{
one = arr[0];
}
else if (arr.Length == 2)
{
one = arr[0]; two = arr[1];
}
if (i == 0)
{
if (settings.dt_sm_Info[i].sm_Pa == "0")
{
dc.Add("水密检测第1樘压力0帕状态", one);
dc.Add("水密检测第1樘压力0帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "100")
{
dc.Add("水密检测第1樘压力100帕状态", one);
dc.Add("水密检测第1樘压力100帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "150")
{
dc.Add("水密检测第1樘压力150帕状态", one);
dc.Add("水密检测第1樘压力150帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "200")
{
dc.Add("水密检测第1樘压力200帕状态", one);
dc.Add("水密检测第1樘压力200帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "250")
{
dc.Add("水密检测第1樘压力250帕状态", one);
dc.Add("水密检测第1樘压力250帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "300")
{
dc.Add("水密检测第1樘压力300帕状态", one);
dc.Add("水密检测第1樘压力300帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "350")
{
dc.Add("水密检测第1樘压力350帕状态", one);
dc.Add("水密检测第1樘压力350帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "400")
{
dc.Add("水密检测第1樘压力400帕状态", one);
dc.Add("水密检测第1樘压力400帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "500")
{
dc.Add("水密检测第1樘压力500帕状态", "36");
dc.Add("水密检测第1樘压力500帕部位", "36");
}
if (settings.dt_sm_Info[i].sm_Pa == "600")
{
dc.Add("水密检测第1樘压力600帕状态", one);
dc.Add("水密检测第1樘压力600帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "700")
{
dc.Add("水密检测第1樘压力700帕状态", one);
dc.Add("水密检测第1樘压力700帕部位", two);
}
dc.Add("水密检测第1樘水密实验备注", settings.dt_sm_Info[i].sm_Remark);
}
if (i == 1)
{
if (settings.dt_sm_Info[i].sm_Pa == "0")
{
dc.Add("水密检测第2樘压力0帕状态", one);
dc.Add("水密检测第2樘压力0帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "100")
{
dc.Add("水密检测第2樘压力100帕状态", one);
dc.Add("水密检测第2樘压力100帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "150")
{
dc.Add("水密检测第2樘压力150帕状态", one);
dc.Add("水密检测第2樘压力150帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "200")
{
dc.Add("水密检测第2樘压力200帕状态", one);
dc.Add("水密检测第2樘压力200帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "250")
{
dc.Add("水密检测第2樘压力250帕状态", one);
dc.Add("水密检测第2樘压力250帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "300")
{
dc.Add("水密检测第2樘压力300帕状态", one);
dc.Add("水密检测第2樘压力300帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "350")
{
dc.Add("水密检测第2樘压力350帕状态", one);
dc.Add("水密检测第2樘压力350帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "400")
{
dc.Add("水密检测第2樘压力400帕状态", one);
dc.Add("水密检测第2樘压力400帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "500")
{
dc.Add("水密检测第2樘压力500帕状态", "36");
dc.Add("水密检测第2樘压力500帕部位", "36");
}
if (settings.dt_sm_Info[i].sm_Pa == "600")
{
dc.Add("水密检测第2樘压力600帕状态", one);
dc.Add("水密检测第2樘压力600帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "700")
{
dc.Add("水密检测第2樘压力700帕状态", one);
dc.Add("水密检测第2樘压力700帕部位", two);
}
dc.Add("水密检测第2樘水密实验备注", settings.dt_sm_Info[i].sm_Remark);
}
if (i == 2)
{
if (settings.dt_sm_Info[i].sm_Pa == "0")
{
dc.Add("水密检测第3樘压力0帕状态", one);
dc.Add("水密检测第3樘压力0帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "100")
{
dc.Add("水密检测第3樘压力100帕状态", one);
dc.Add("水密检测第3樘压力100帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "150")
{
dc.Add("水密检测第3樘压力150帕状态", one);
dc.Add("水密检测第3樘压力150帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "200")
{
dc.Add("水密检测第3樘压力200帕状态", one);
dc.Add("水密检测第3樘压力200帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "250")
{
dc.Add("水密检测第3樘压力250帕状态", one);
dc.Add("水密检测第3樘压力250帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "300")
{
dc.Add("水密检测第3樘压力300帕状态", one);
dc.Add("水密检测第3樘压力300帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "350")
{
dc.Add("水密检测第3樘压力350帕状态", one);
dc.Add("水密检测第3樘压力350帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "400")
{
dc.Add("水密检测第3樘压力400帕状态", one);
dc.Add("水密检测第3樘压力400帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "500")
{
dc.Add("水密检测第3樘压力500帕状态", "36");
dc.Add("水密检测第3樘压力500帕部位", "36");
}
if (settings.dt_sm_Info[i].sm_Pa == "600")
{
dc.Add("水密检测第3樘压力600帕状态", one);
dc.Add("水密检测第3樘压力600帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "700")
{
dc.Add("水密检测第3樘压力700帕状态", one);
dc.Add("水密检测第3樘压力700帕部位", two);
}
dc.Add("水密检测第3樘水密实验备注", settings.dt_sm_Info[i].sm_Remark);
}
}
}
#endregion
}
else
{
dc.Add("检测条件第0樘水密等级", "--");
}
dc.Add("检测条件第0樘正缝长渗透量", qm_z_FC.ToString());
dc.Add("检测条件第0樘负缝长渗透量", qm_f_FC.ToString());
dc.Add("检测条件第0樘正面积渗透量", qm_z_MJ.ToString());
dc.Add("检测条件第0樘负面积渗透量", qm_f_MJ.ToString());
dc.Add("检测条件第0樘水密检测方法", "--法");
return(dc);
}
/// <summary>
/// 获取门窗检测报告文档
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
private Dictionary <string, string> GetDWDetectionReport(Model_dt_Settings settings)
{
Dictionary <string, string> dc = new Dictionary <string, string>();
dc.Add("检测条件第0樘型号规格", settings.GuiGeXingHao);
dc.Add("检测条件第0樘大气压力", settings.DaQiYaLi);
dc.Add("检测条件第0樘委托单位", settings.WeiTuoDanWei);
dc.Add("检测条件第0樘委托单位重复1", settings.WeiTuoDanWei);
dc.Add("检测条件第0樘工程名称", settings.GongChengMingCheng);
dc.Add("检测条件第0樘开启方式", settings.KaiQiFangShi);
dc.Add("检测条件第0樘开启缝长", settings.KaiQiFengChang);
dc.Add("检测条件第0樘当前温度", settings.DangQianWenDu);
dc.Add("检测条件第0樘总面积", settings.ZongMianJi);
dc.Add("检测条件第0樘最大玻璃", settings.ZuiDaBoLi);
dc.Add("检测条件第0樘来样方式", settings.CaiYangFangShi);
dc.Add("检测条件第0樘来样方式重复1", settings.CaiYangFangShi);
dc.Add("检测条件第0樘样品名称", settings.YangPinMingCheng);
dc.Add("检测条件第0樘样品名称重复1", settings.YangPinMingCheng);
dc.Add("检测条件第0樘框扇密封", settings.KuangShanMiFang);
dc.Add("检测条件第0樘检验数量", settings.GuiGeShuLiang);
dc.Add("检测条件第0樘检验日期", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验日期重复1", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验日期重复2", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验编号", settings.dt_Code);
dc.Add("检测条件第0樘检验编号重复1", settings.dt_Code);
dc.Add("检测条件第0樘检验编号重复2", settings.dt_Code);
dc.Add("检测条件第0樘检验编号重复3", settings.dt_Code);
dc.Add("检测条件第0樘检验项目", settings.JianYanXiangMu);
dc.Add("检测条件第0樘正压气密等级设计值", settings.ZhengYaQiMiDengJiSheJiZhi);
if (settings.JianYanXiangMu == "气密性能检测" || settings.JianYanXiangMu == "气密性能及水密性能检测")
{
var qm_zy_level = Get_QMLevel(settings, 1);
dc.Add("检测条件第0樘综合气密等级", qm_zy_level.ToString());
var qm_fy_level = Get_QMLevel(settings, 2);
dc.Add("检测条件气密性能负压属国标等级", qm_fy_level.ToString());
}
else
{
dc.Add("检测条件第0樘综合气密等级", "--");
}
if (settings.JianYanXiangMu == "水密性能检测" || settings.JianYanXiangMu == "气密性能及水密性能检测")
{
var sm_level = Get_SMLevel(settings);
var YL = Get_SMYL(settings);
dc.Add("检测条件第0樘水密等级", sm_level.ToString());
dc.Add("检测条件第0樘水密等级设计值", sm_level.ToString());
dc.Add("检测条件第0樘水密保持风压", YL.ToString());
}
else
{
dc.Add("检测条件第0樘水密等级", "--");
dc.Add("检测条件第0樘水密等级设计值", "--");
dc.Add("检测条件第0樘水密保持风压", "--");
}
dc.Add("检测条件第0樘正缝长渗透量", qm_z_FC.ToString());
dc.Add("检测条件第0樘负缝长渗透量", qm_f_FC.ToString());
dc.Add("检测条件第0樘正面积渗透量", qm_z_MJ.ToString());
dc.Add("检测条件第0樘负面积渗透量", qm_f_MJ.ToString());
dc.Add("检测条件第0樘玻璃品种", settings.BoLiPinZhong);
dc.Add("检测条件第0樘玻璃密封", settings.BoLiMiFeng);
dc.Add("检测条件第0樘生产单位", settings.ShengChanDanWei);
dc.Add("检测条件第0樘负压气密等级设计值", settings.FuYaQiMiDengJiSheJiZhi);
dc.Add("检测条件第0樘负责人", settings.WeiTuoRen);
dc.Add("检测条件第0樘镶嵌方式", settings.XiangQianFangShi);
return(dc);
}
/// <summary>
/// 获取检测报告文档
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
private Dictionary <string, string> GetDetectionReport(Model_dt_Settings settings, string file)
{
Dictionary <string, string> dc = new Dictionary <string, string>();
#region 基础
dc.Add("检测条件第0樘杆件长度", settings.GanJianChangDu);
dc.Add("实验室气压", settings.DaQiYaLi);
dc.Add("实验室温度", settings.DangQianWenDu);
dc.Add("集流管经", (DefaultBase._D * 1000).ToString());
dc.Add("检测条件第0樘五金件状况", settings.WuJinJianZhuangKuang);
dc.Add("检测条件第0樘型号规格", settings.GuiGeXingHao);
dc.Add("检测条件第0樘大气压力", settings.DaQiYaLi);
dc.Add("检测条件第0樘委托单位", settings.WeiTuoDanWei);
dc.Add("检测条件第0樘委托单位重复1", settings.WeiTuoDanWei);
dc.Add("检测条件第0樘委托单位重复2", settings.WeiTuoDanWei);
dc.Add("检测条件第0樘委托单位重复3", settings.WeiTuoDanWei);
dc.Add("检测条件第0樘工程名称", settings.GongChengMingCheng);
dc.Add("检测条件第0樘工程地点", settings.GongChengDiDian);
dc.Add("检测条件第0樘开启缝长", settings.KaiQiFengChang);
dc.Add("检测条件第0樘开启缝长重复1", settings.KaiQiFengChang);
dc.Add("检测条件第0樘当前温度", settings.DangQianWenDu);
dc.Add("检测条件第0樘总面积", settings.ZongMianJi);
dc.Add("检测条件第0樘总面积重复2", settings.ZongMianJi);
dc.Add("检测条件第0樘最大玻璃", settings.ZuiDaBoLi);
dc.Add("检测条件第0樘来样方式", settings.CaiYangFangShi);
dc.Add("检测条件第0樘样品名称", settings.YangPinMingCheng);
dc.Add("检测条件第0樘样品名称重复1", settings.YangPinMingCheng);
dc.Add("检测条件第0樘样品名称重复2", settings.YangPinMingCheng);
dc.Add("检测条件第0樘样品名称重复3", settings.YangPinMingCheng);
dc.Add("检测条件第0樘框扇密封", settings.KuangShanMiFang);
dc.Add("检测条件第0樘检验数量", settings.GuiGeShuLiang);
dc.Add("检测条件第0樘检验编号", settings.dt_Code);
dc.Add("检测条件第0樘检验编号重复1", settings.dt_Code);
dc.Add("检测条件第0樘检验编号重复2", settings.dt_Code);
dc.Add("检测条件第0樘检验编号重复3", settings.dt_Code);
dc.Add("检测条件第0樘检验编号重复4", settings.dt_Code);
dc.Add("检测条件第0樘检验编号重复5", settings.dt_Code);
dc.Add("检测条件第0樘检验日期重复1", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验日期重复2", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验日期重复3", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验日期重复4", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验日期重复5", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验日期重复6", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验日期重复7", settings.JianYanRiQi);
dc.Add("检测条件第0樘检验项目", settings.JianYanXiangMu);
dc.Add("检测条件第0樘正压气密等级设计值", settings.ZhengYaQiMiDengJiSheJiZhi);
dc.Add("检测条件第0樘负压气密等级设计值", settings.FuYaQiMiDengJiSheJiZhi);
dc.Add("检测条件第0樘水密等级设计值", settings.ShuiMiDengJiSheJiZhi);
dc.Add("检测条件第0樘玻璃厚度", settings.BoLiHouDu);
dc.Add("检测条件第0樘玻璃品种", settings.BoLiPinZhong);
dc.Add("检测条件第0樘玻璃密封", settings.BoLiMiFeng);
dc.Add("检测条件第0樘抗风压等级设计值", settings.KangFengYaDengJiSheJiZhi);
dc.Add("检测条件第0樘镶嵌方式", settings.XiangQianFangShi);
dc.Add("检测条件第0樘单扇单锁点", settings.DanShanDanSuoDian);
#endregion
if (settings.dt_qm_Info.Count > 0)
{
#region 气密
//检测条件第0樘综合气密等级
var z_qm_level = formula.Get_Z_AirTightLevel(settings.dt_qm_Info);
dc.Add("检测条件第0樘正压气密等级", z_qm_level.ToString());
var f_qm_level = formula.Get_F_AirTightLevel(settings.dt_qm_Info);
dc.Add("检测条件第0樘负压气密等级", f_qm_level.ToString());
if (settings.dt_qm_Info != null && settings.dt_qm_Info.Count > 0)
{
for (int i = 0; i < settings.dt_qm_Info.Count; i++)
{
if (i == 0)
{
dc.Add("气密检测第1樘总的渗透正升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_zd100).ToString("#0.00"));
dc.Add("气密检测第1樘总的渗透正降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_z_zd100).ToString("#0.00"));
dc.Add("气密检测第1樘总的渗透负升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_zd100).ToString("#0.00"));
dc.Add("气密检测第1樘总的渗透负降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_f_zd100).ToString("#0.00"));
dc.Add("气密检测第1樘附加渗透负升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_fj150).ToString("#0.00"));
dc.Add("气密检测第1樘总的渗透负升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_zd150).ToString("#0.00"));
dc.Add("气密检测第1樘总的渗透正升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_zd150).ToString("#0.00"));
dc.Add("气密检测第1樘附加渗透正升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_fj150).ToString("#0.00"));
dc.Add("气密检测第1樘附加渗透正升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_fj100).ToString("#0.00"));
dc.Add("气密检测第1樘附加渗透正降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_z_fj100).ToString("#0.00"));
dc.Add("气密检测第1樘附加渗透负升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_fj100).ToString("#0.00"));
dc.Add("气密检测第1樘附加渗透负降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_f_fj100).ToString("#0.00"));
dc.Add("流量第一樘升100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_fj100)).ToString("#0.00"));
dc.Add("流量第一樘升150附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_fj150)).ToString("#0.00"));
dc.Add("流量第一樘负升150附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_fj150)).ToString("#0.00"));
dc.Add("流量第一樘负升100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_fj100)).ToString("#0.00"));
dc.Add("流量第一樘负升100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_zd100)).ToString("#0.00"));
dc.Add("流量第一樘升100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_zd100)).ToString("#0.00"));
dc.Add("流量第一樘升150总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_zd150)).ToString("#0.00"));
dc.Add("流量第一樘负升150总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_zd150)).ToString("#0.00"));
dc.Add("流量第一樘降100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_z_zd100)).ToString("#0.00"));
dc.Add("流量第一樘降100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_z_fj100)).ToString("#0.00"));
dc.Add("流量第一樘负降100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_f_zd100)).ToString("#0.00"));
dc.Add("流量第一樘负降100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_f_fj100)).ToString("#0.00"));
}
if (i == 1)
{
dc.Add("气密检测第2樘总的渗透正升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_zd100).ToString("#0.00"));
dc.Add("气密检测第2樘总的渗透正升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_zd150).ToString("#0.00"));
dc.Add("气密检测第2樘总的渗透负升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_zd150).ToString("#0.00"));
dc.Add("气密检测第2樘附加渗透负升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_fj150).ToString("#0.00"));
dc.Add("气密检测第2樘附加渗透正升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_fj150).ToString("#0.00"));
dc.Add("气密检测第2樘总的渗透正降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_z_zd100).ToString("#0.00"));
dc.Add("气密检测第2樘总的渗透负升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_zd100).ToString("#0.00"));
dc.Add("气密检测第2樘总的渗透负降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_f_zd100).ToString("#0.00"));
dc.Add("气密检测第2樘附加渗透正升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_fj100).ToString("#0.00"));
dc.Add("气密检测第2樘附加渗透正降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_z_fj100).ToString("#0.00"));
dc.Add("气密检测第2樘附加渗透负升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_fj100).ToString("#0.00"));
dc.Add("气密检测第2樘附加渗透负降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_f_fj100).ToString("#0.00"));
//第二樘
dc.Add("流量第二樘升100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_fj100)).ToString("#0.00"));
dc.Add("流量第二樘升150附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_fj150)).ToString("#0.00"));
dc.Add("流量第二樘负升150附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_fj150)).ToString("#0.00"));
dc.Add("流量第二樘负升100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_fj100)).ToString("#0.00"));
dc.Add("流量第二樘负升100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_zd100)).ToString("#0.00"));
dc.Add("流量第二樘升100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_zd100)).ToString("#0.00"));
dc.Add("流量第二樘升150总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_zd150)).ToString("#0.00"));
dc.Add("流量第二樘负升150总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_zd150)).ToString("#0.00"));
dc.Add("流量第二樘降100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_z_zd100)).ToString("#0.00"));
dc.Add("流量第二樘降100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_z_fj100)).ToString("#0.00"));
dc.Add("流量第二樘负降100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_f_zd100)).ToString("#0.00"));
dc.Add("流量第二樘负降100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_f_fj100)).ToString("#0.00"));
}
if (i == 2)
{
dc.Add("气密检测第3樘总的渗透正升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_zd100).ToString("#0.00"));
dc.Add("气密检测第3樘总的渗透正升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_zd150).ToString("#0.00"));
dc.Add("气密检测第3樘总的渗透负升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_zd150).ToString("#0.00"));
dc.Add("气密检测第3樘附加渗透负升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_fj150).ToString("#0.00"));
dc.Add("气密检测第3樘附加渗透正升压150帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_fj150).ToString("#0.00"));
dc.Add("气密检测第3樘总的渗透正降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_z_zd100).ToString("#0.00"));
dc.Add("气密检测第3樘总的渗透负升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_zd100).ToString("#0.00"));
dc.Add("气密检测第3樘总的渗透负降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_f_zd100).ToString("#0.00"));
dc.Add("气密检测第3樘附加渗透正升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_z_fj100).ToString("#0.00"));
dc.Add("气密检测第3樘附加渗透正降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_z_fj100).ToString("#0.00"));
dc.Add("气密检测第3樘附加渗透负升压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_s_f_fj100).ToString("#0.00"));
dc.Add("气密检测第3樘附加渗透负降压100帕时风速", double.Parse(settings.dt_qm_Info[i].qm_j_f_fj100).ToString("#0.00"));
//流量
dc.Add("流量第三樘负升100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_zd100)).ToString("#0.00"));
dc.Add("流量第三樘升100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_zd100)).ToString("#0.00"));
dc.Add("流量第三樘负升100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_fj100)).ToString("#0.00"));
dc.Add("流量第三樘升100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_fj100)).ToString("#0.00"));
dc.Add("流量第三樘升150总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_zd150)).ToString("#0.00"));
dc.Add("流量第三樘负升150总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_zd150)).ToString("#0.00"));
dc.Add("流量第三樘升150附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_z_fj150)).ToString("#0.00"));
dc.Add("流量第三樘负升150附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_s_f_fj150)).ToString("#0.00"));
dc.Add("流量第三樘负降100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_f_zd100)).ToString("#0.00"));
dc.Add("流量第三樘降100总的", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_z_zd100)).ToString("#0.00"));
dc.Add("流量第三樘降100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_z_fj100)).ToString("#0.00"));
dc.Add("流量第三樘负降100附加", formula.MathFlow(double.Parse(settings.dt_qm_Info[i].qm_j_f_fj100)).ToString("#0.00"));
}
}
}
#endregion
}
else
{
dc.Add("检测条件第0樘综合气密等级", "--");
}
if (settings.dt_sm_Info.Count > 0)
{
#region 水密
var sm_level = formula.GetWaterTightLevel(settings.dt_sm_Info);
dc.Add("检测条件第0樘水密等级", sm_level.ToString());
for (int i = 0; i < settings.dt_sm_Info.Count; i++)
{
if (i == 0)
{
dc.Add("检测条件第0樘水密检测方法", settings.dt_sm_Info[i].Method);
}
string[] arr = settings.dt_sm_Info[i].sm_PaDesc.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
var one = "";
var two = "";
if (arr.Length == 0)
{
continue;
}
else if (arr.Length == 1)
{
one = arr[0];
}
else if (arr.Length == 2)
{
one = arr[0];
two = arr[1];
}
if (two.Contains("▲") || two.Contains("●"))
{
if (i == 0)
{
//if (settings.dt_sm_Info[i].sm_Pa == "0")
//{
// dc.Add("水密检测第1樘压力0帕状态", one);
// dc.Add("水密检测第1樘压力0帕部位", two);
//}
if (settings.dt_sm_Info[i].sm_Pa == "0")
{
dc.Add("水密检测第1樘压力100帕状态", one);
dc.Add("水密检测第1樘压力100帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "100")
{
dc.Add("水密检测第1樘压力150帕状态", one);
dc.Add("水密检测第1樘压力150帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "150")
{
dc.Add("水密检测第1樘压力200帕状态", one);
dc.Add("水密检测第1樘压力200帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "200")
{
dc.Add("水密检测第1樘压力250帕状态", one);
dc.Add("水密检测第1樘压力250帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "250")
{
dc.Add("水密检测第1樘压力300帕状态", one);
dc.Add("水密检测第1樘压力300帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "300")
{
dc.Add("水密检测第1樘压力350帕状态", one);
dc.Add("水密检测第1樘压力350帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "350")
{
dc.Add("水密检测第1樘压力400帕状态", one);
dc.Add("水密检测第1樘压力400帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "400")
{
dc.Add("水密检测第1樘压力500帕状态", one);
dc.Add("水密检测第1樘压力500帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "500")
{
dc.Add("水密检测第1樘压力600帕状态", one);
dc.Add("水密检测第1樘压力600帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "600")
{
dc.Add("水密检测第1樘压力700帕状态", one);
dc.Add("水密检测第1樘压力700帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "700")
{
dc.Add("水密检测第1樘压力700帕状态", one);
dc.Add("水密检测第1樘压力700帕部位", two);
}
dc.Add("水密检测第1樘水密实验备注", settings.dt_sm_Info[i].sm_Remark);
}
if (i == 1)
{
//if (settings.dt_sm_Info[i].sm_Pa == "0")
//{
// dc.Add("水密检测第2樘压力0帕状态", one);
// dc.Add("水密检测第2樘压力0帕部位", two);
//}
if (settings.dt_sm_Info[i].sm_Pa == "0")
{
dc.Add("水密检测第2樘压力100帕状态", one);
dc.Add("水密检测第2樘压力100帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "100")
{
dc.Add("水密检测第2樘压力150帕状态", one);
dc.Add("水密检测第2樘压力150帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "150")
{
dc.Add("水密检测第2樘压力200帕状态", one);
dc.Add("水密检测第2樘压力200帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "200")
{
dc.Add("水密检测第2樘压力250帕状态", one);
dc.Add("水密检测第2樘压力250帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "250")
{
dc.Add("水密检测第2樘压力300帕状态", one);
dc.Add("水密检测第2樘压力300帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "300")
{
dc.Add("水密检测第2樘压力350帕状态", one);
dc.Add("水密检测第2樘压力350帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "350")
{
dc.Add("水密检测第2樘压力400帕状态", one);
dc.Add("水密检测第2樘压力400帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "400")
{
dc.Add("水密检测第2樘压力500帕状态", one);
dc.Add("水密检测第2樘压力500帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "500")
{
dc.Add("水密检测第2樘压力600帕状态", one);
dc.Add("水密检测第2樘压力600帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "600")
{
dc.Add("水密检测第2樘压力700帕状态", one);
dc.Add("水密检测第2樘压力700帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "700")
{
dc.Add("水密检测第2樘压力700帕状态", one);
dc.Add("水密检测第2樘压力700帕部位", two);
}
dc.Add("水密检测第2樘水密实验备注", settings.dt_sm_Info[i].sm_Remark);
}
if (i == 2)
{
//if (settings.dt_sm_Info[i].sm_Pa == "0")
//{
// dc.Add("水密检测第3樘压力0帕状态", one);
// dc.Add("水密检测第3樘压力0帕部位", two);
//}
if (settings.dt_sm_Info[i].sm_Pa == "0")
{
dc.Add("水密检测第3樘压力100帕状态", one);
dc.Add("水密检测第3樘压力100帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "100")
{
dc.Add("水密检测第3樘压力150帕状态", one);
dc.Add("水密检测第3樘压力150帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "150")
{
dc.Add("水密检测第3樘压力200帕状态", one);
dc.Add("水密检测第3樘压力200帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "200")
{
dc.Add("水密检测第3樘压力250帕状态", one);
dc.Add("水密检测第3樘压力250帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "250")
{
dc.Add("水密检测第3樘压力300帕状态", one);
dc.Add("水密检测第3樘压力300帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "300")
{
dc.Add("水密检测第3樘压力350帕状态", one);
dc.Add("水密检测第3樘压力350帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "350")
{
dc.Add("水密检测第3樘压力400帕状态", one);
dc.Add("水密检测第3樘压力400帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "400")
{
dc.Add("水密检测第3樘压力500帕状态", one);
dc.Add("水密检测第3樘压力500帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "500")
{
dc.Add("水密检测第3樘压力600帕状态", one);
dc.Add("水密检测第3樘压力600帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "600")
{
dc.Add("水密检测第3樘压力700帕状态", one);
dc.Add("水密检测第3樘压力700帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "700")
{
dc.Add("水密检测第2樘压力700帕状态", one);
dc.Add("水密检测第2樘压力700帕部位", two);
}
dc.Add("水密检测第3樘水密实验备注", settings.dt_sm_Info[i].sm_Remark);
}
}
else
{
if (i == 0)
{
if (settings.dt_sm_Info[i].sm_Pa == "0")
{
dc.Add("水密检测第1樘压力0帕状态", one);
dc.Add("水密检测第1樘压力0帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "100")
{
dc.Add("水密检测第1樘压力100帕状态", one);
dc.Add("水密检测第1樘压力100帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "150")
{
dc.Add("水密检测第1樘压力150帕状态", one);
dc.Add("水密检测第1樘压力150帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "200")
{
dc.Add("水密检测第1樘压力200帕状态", one);
dc.Add("水密检测第1樘压力200帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "250")
{
dc.Add("水密检测第1樘压力250帕状态", one);
dc.Add("水密检测第1樘压力250帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "300")
{
dc.Add("水密检测第1樘压力300帕状态", one);
dc.Add("水密检测第1樘压力300帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "350")
{
dc.Add("水密检测第1樘压力350帕状态", one);
dc.Add("水密检测第1樘压力350帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "400")
{
dc.Add("水密检测第1樘压力400帕状态", one);
dc.Add("水密检测第1樘压力400帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "500")
{
dc.Add("水密检测第1樘压力500帕状态", one);
dc.Add("水密检测第1樘压力500帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "600")
{
dc.Add("水密检测第1樘压力600帕状态", one);
dc.Add("水密检测第1樘压力600帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "700")
{
dc.Add("水密检测第1樘压力700帕状态", one);
dc.Add("水密检测第1樘压力700帕部位", two);
}
dc.Add("水密检测第1樘水密实验备注", settings.dt_sm_Info[i].sm_Remark);
}
if (i == 1)
{
if (settings.dt_sm_Info[i].sm_Pa == "0")
{
dc.Add("水密检测第2樘压力0帕状态", one);
dc.Add("水密检测第2樘压力0帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "100")
{
dc.Add("水密检测第2樘压力100帕状态", one);
dc.Add("水密检测第2樘压力100帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "150")
{
dc.Add("水密检测第2樘压力150帕状态", one);
dc.Add("水密检测第2樘压力150帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "200")
{
dc.Add("水密检测第2樘压力200帕状态", one);
dc.Add("水密检测第2樘压力200帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "250")
{
dc.Add("水密检测第2樘压力250帕状态", one);
dc.Add("水密检测第2樘压力250帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "300")
{
dc.Add("水密检测第2樘压力300帕状态", one);
dc.Add("水密检测第2樘压力300帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "350")
{
dc.Add("水密检测第2樘压力350帕状态", one);
dc.Add("水密检测第2樘压力350帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "400")
{
dc.Add("水密检测第2樘压力400帕状态", one);
dc.Add("水密检测第2樘压力400帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "500")
{
dc.Add("水密检测第2樘压力500帕状态", "36");
dc.Add("水密检测第2樘压力500帕部位", "36");
}
if (settings.dt_sm_Info[i].sm_Pa == "600")
{
dc.Add("水密检测第2樘压力600帕状态", one);
dc.Add("水密检测第2樘压力600帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "700")
{
dc.Add("水密检测第2樘压力700帕状态", one);
dc.Add("水密检测第2樘压力700帕部位", two);
}
dc.Add("水密检测第2樘水密实验备注", settings.dt_sm_Info[i].sm_Remark);
}
if (i == 2)
{
if (settings.dt_sm_Info[i].sm_Pa == "0")
{
dc.Add("水密检测第3樘压力0帕状态", one);
dc.Add("水密检测第3樘压力0帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "100")
{
dc.Add("水密检测第3樘压力100帕状态", one);
dc.Add("水密检测第3樘压力100帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "150")
{
dc.Add("水密检测第3樘压力150帕状态", one);
dc.Add("水密检测第3樘压力150帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "200")
{
dc.Add("水密检测第3樘压力200帕状态", one);
dc.Add("水密检测第3樘压力200帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "250")
{
dc.Add("水密检测第3樘压力250帕状态", one);
dc.Add("水密检测第3樘压力250帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "300")
{
dc.Add("水密检测第3樘压力300帕状态", one);
dc.Add("水密检测第3樘压力300帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "350")
{
dc.Add("水密检测第3樘压力350帕状态", one);
dc.Add("水密检测第3樘压力350帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "400")
{
dc.Add("水密检测第3樘压力400帕状态", one);
dc.Add("水密检测第3樘压力400帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "500")
{
dc.Add("水密检测第3樘压力500帕状态", "36");
dc.Add("水密检测第3樘压力500帕部位", "36");
}
if (settings.dt_sm_Info[i].sm_Pa == "600")
{
dc.Add("水密检测第3樘压力600帕状态", one);
dc.Add("水密检测第3樘压力600帕部位", two);
}
if (settings.dt_sm_Info[i].sm_Pa == "700")
{
dc.Add("水密检测第3樘压力700帕状态", one);
dc.Add("水密检测第3樘压力700帕部位", two);
}
dc.Add("水密检测第3樘水密实验备注", settings.dt_sm_Info[i].sm_Remark);
}
}
}
#endregion
}
else
{
dc.Add("检测条件第0樘水密等级", "--");
}
#region 缝长计算
double zFc = 0, fFc = 0, zMj = 0, fMj = 0;
if (settings.dt_qm_Info != null && settings.dt_qm_Info.Count > 0)
{
zFc = Math.Round(settings.dt_qm_Info.Sum(t => double.Parse(t.qm_Z_FC)) / settings.dt_qm_Info.Count, 2);
fFc = Math.Round(settings.dt_qm_Info.Sum(t => double.Parse(t.qm_F_FC)) / settings.dt_qm_Info.Count, 2);
zMj = Math.Round(settings.dt_qm_Info.Sum(t => double.Parse(t.qm_Z_MJ)) / settings.dt_qm_Info.Count, 2);
fMj = Math.Round(settings.dt_qm_Info.Sum(t => double.Parse(t.qm_F_MJ)) / settings.dt_qm_Info.Count, 2);
}
dc.Add("检测条件第0樘正缝长渗透量", zFc.ToString());
dc.Add("检测条件第0樘负缝长渗透量", fFc.ToString());
dc.Add("检测条件第0樘正面积渗透量", zMj.ToString());
dc.Add("检测条件第0樘负面积渗透量", fMj.ToString());
#endregion
return(dc);
}
/// <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>
public bool Add(Model_dt_Settings model, string tong)
{
var res = false;
string delsql = "delete from dt_Settings where dt_Code='" + model.dt_Code + "'";
SQLiteHelper.ExecuteNonQuery(delsql);
#region 添加主表
string sql = string.Format(@"
insert into dt_Settings
(
weituobianhao,
weituodanwei,
dizhi,
dianhua,
chouyangriqi,
chouyangdidian,
gongchengmingcheng,
gongchengdidian,
shengchandanwei,
jiancexiangmu,
jiancedidian,
jianceriqi,
jianceshebei,
jianceyiju,
yangpinmingcheng,
yangpinshangbiao,
yangpinzhuangtai,
guigexinghao,
kaiqifangshi,
mianbanpinzhong,
zuidamianban,
mianbanhoudu,
anzhuangfangshi,
mianbanxiangqian,
kuangshanmifeng,
wujinpeijian,
jianceshuliang,
dangqiandanghao,
dangqianwendu,
daqiyali,
kaiqifengchang,
shijianmianji,
ganjianchangdu,
penlinshuiliang,
qimidanweifengchangshejizhi,
qimidanweimianjishejizhi,
shuimijingyashejizhi,
shuimidongyashejizhi,
kangfengyazhengyashejizhi,
kangfengyafuyashejizhi,
danshandansuodian,
dt_Code,
dt_Create,
kangfengyazhengp3shejizhi,
kangfengyazhengpmaxshejizhi
)
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}' ,datetime('now'),'{42}','{43}')",
model.weituobianhao,
model.weituodanwei,
model.dizhi,
model.dianhua,
model.chouyangriqi,
model.chouyangdidian,
model.gongchengmingcheng,
model.gongchengdidian,
model.shengchandanwei,
model.jiancexiangmu,
model.jiancedidian,
model.jianceriqi,
model.jianceshebei,
model.jianceyiju,
model.yangpinmingcheng,
model.yangpinshangbiao,
model.yangpinzhuangtai,
model.guigexinghao,
model.kaiqifangshi,
model.mianbanpinzhong,
model.zuidamianban,
model.mianbanhoudu,
model.anzhuangfangshi,
model.mianbanxiangqian,
model.kuangshanmifeng,
model.wujinpeijian,
model.jianceshuliang,
model.dangqiandanghao,
model.dangqianwendu,
model.daqiyali,
model.kaiqifengchang,
model.shijianmianji,
model.ganjianchangdu,
model.penlinshuiliang,
model.qimidanweifengchangshejizhi,
model.qimidanweimianjishejizhi,
model.shuimijingyashejizhi,
model.shuimidongyashejizhi,
model.kangfengyazhengyashejizhi,
model.kangfengyafuyashejizhi,
model.danshandansuodian,
model.dt_Code,
model.kangfengyazhengp3shejizhi,
model.kangfengyazhengpmaxshejizhi
);
res = SQLiteHelper.ExecuteNonQuery(sql) > 0 ? true : false;
#endregion
#region 添加实验樘号记录
if (res)
{
var table = SQLiteHelper.ExecuteDataRow("select * from dt_Info where info_DangH = '" + tong + "' and dt_Code = '" + model.dt_Code + "'")?.Table;
if (table == null || table.Rows.Count == 0)
{
sql = string.Format("insert into dt_Info (info_DangH,info_Create,dt_Code,Airtight,Watertight,WindPressure) values('{0}',datetime('now'),'{1}',0,0,0)", tong, model.dt_Code);
return(SQLiteHelper.ExecuteNonQuery(sql) > 0 ? true : false);
}
}
#endregion
return(true);
}