public void Init()
{
var list = new DAL_dt_Settings().GetCodeList();
cbb_code.DataSource = list;
cbb_code.DisplayMember = "name";
cbb_code.ValueMember = "id";
cbb_code.SelectedIndex = 0;
}
private void btn_Ok_Click(object sender, EventArgs e)
{
string code = btn_JianYanBianHao.Text;
if (string.IsNullOrWhiteSpace(txt_jianceshuliang.Text))
{
MessageBox.Show("请输入规格数量！", "警告！", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrWhiteSpace(cb_DangQianDangHao.Text))
{
MessageBox.Show("请设置樘号！", "警告！", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrWhiteSpace(code))
{
MessageBox.Show("请设置当前编号！", "警告！", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DAL_dt_Settings dal = new DAL_dt_Settings();
try
{
var setting = GetSettings();
var tong = this.cb_DangQianDangHao.Text;
if (dal.Add(setting, tong))
{
// MessageBox.Show("设定完成！", "完成", MessageBoxButtons.OK, MessageBoxIcon.Information);
//获取樘号
deleBottomTypeEvent(GetBottomType(true));
DefaultBase.base_SpecCount = int.Parse(txt_jianceshuliang.Text);
DefaultBase.base_TestItem = cb_JianCeXiangMu.Text;
DefaultBase.LockPoint = cbb_danshandansuodian.Text == "是" ? true : false;
int def = 0;
int.TryParse(txt_ganjianchangdu.Text, out def);
DefaultBase.BarLength = def;
this.btn_add.Enabled = true;
this.btn_select.Enabled = true;
this.btn_delete.Enabled = true;
this.btn_Ok.Enabled = true;
// this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("添加异常！", "异常", MessageBoxButtons.OK, MessageBoxIcon.Information);
Logger.Error(ex);
}
}
private void btn_Ok_Click(object sender, EventArgs e)
{
string code = btn_JianYanBianHao.Text;
if (string.IsNullOrWhiteSpace(btn_GuiGeShuLiang.Text))
{
MessageBox.Show("请输入规格数量！", "警告！", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.ServiceNotification);
return;
}
if (string.IsNullOrWhiteSpace(cb_DangQianDangHao.Text))
{
MessageBox.Show("请设置樘号！", "警告！", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.ServiceNotification);
return;
}
if (string.IsNullOrWhiteSpace(code))
{
MessageBox.Show("请设置当前编号！", "警告！", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.ServiceNotification);
return;
}
DAL_dt_Settings dal = new DAL_dt_Settings();
try
{
var setting = GetSettings();
var tong = this.cb_DangQianDangHao.Text;
if (dal.Add(setting, tong))
{
MessageBox.Show("设定完成！", "完成", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.ServiceNotification);
//获取樘号
deleBottomTypeEvent(GetBottomType(true));
DefaultBase.base_SpecCount = int.Parse(btn_GuiGeShuLiang.Text);
DefaultBase.base_TestItem = cb_JianYanXiangMu.Text;
this.btn_add.Enabled = true;
this.btn_select.Enabled = true;
this.btn_delete.Enabled = true;
this.btn_Ok.Enabled = true;
//this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("添加异常！", "异常", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.ServiceNotification);
Logger.Error(ex);
}
}
private void btn_Ok_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txt_Code.Text))
{
MessageBox.Show("请输入编号", " 警告", MessageBoxButtons.OKCancel, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.ServiceNotification);
return;
}
DataTable dt = new DAL_dt_Settings().Getdt_SettingsByCode(txt_Code.Text);
if (dt == null)
{
MessageBox.Show("暂未查询此编号内容", " 警告", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.ServiceNotification);
return;
}
var args = new TransmitEventArgs(dt.Rows[0]["dt_Code"].ToString(), dt.Rows[0]["info_DangH"].ToString());
Transmit(this, args);
this.Dispose();
}
private void btn_audit_Click(object sender, EventArgs e)
{
try
{
#region 修改数据
if (_settings.dt_qm_Info != null && _settings.dt_qm_Info.Count > 0)
{
for (int i = 0; i < _settings.dt_qm_Info.Count; i++)
{
var setting = _settings.dt_qm_Info[i];
setting.dt_Code = _code;
setting.info_DangH = groupBox1.Text;
if (i == 0)
{
setting.info_DangH = groupBox1.Text;
setting.qm_Z_FC = txt_1zfc.Text;
setting.qm_F_FC = txt_1ffc.Text;
setting.qm_Z_MJ = txt_1zmj.Text;
setting.qm_F_MJ = txt_1fmj.Text;
}
if (i == 1)
{
setting.info_DangH = groupBox2.Text;
setting.qm_Z_FC = txt_2zfc.Text;
setting.qm_F_FC = txt_2ffc.Text;
setting.qm_Z_MJ = txt_2zmj.Text;
setting.qm_F_MJ = txt_2fmj.Text;
}
if (i == 2)
{
setting.info_DangH = groupBox3.Text;
setting.qm_Z_FC = txt_3zfc.Text;
setting.qm_F_FC = txt_3ffc.Text;
setting.qm_Z_MJ = txt_3zmj.Text;
setting.qm_F_MJ = txt_3fmj.Text;
}
}
}
if (_settings.dt_sm_Info != null && _settings.dt_sm_Info.Count > 0)
{
for (int i = 0; i < _settings.dt_sm_Info.Count; i++)
{
var setting = _settings.dt_sm_Info[i];
setting.info_DangH = groupBox1.Text;
if (i == 0)
{
setting.info_DangH = groupBox1.Text;
setting.sm_Pa = txt_1fy.Text;
setting.sm_PaDesc = lbl_1resdesc.Text;
setting.sm_Remark = lbl_1desc.Text;
}
if (i == 1)
{
setting.info_DangH = groupBox2.Text;
setting.sm_Pa = txt_2fy.Text;
setting.sm_PaDesc = lbl_2resdesc.Text;
setting.sm_Remark = lbl_2desc.Text;
}
if (i == 2)
{
setting.info_DangH = groupBox3.Text;
setting.sm_Pa = txt_3fy.Text;
setting.sm_PaDesc = lbl_3resdesc.Text;
setting.sm_Remark = lbl_3desc.Text;
}
}
}
if (_settings.dt_kfy_Info != null && _settings.dt_kfy_Info.Count > 0)
{
for (int i = 0; i < _settings.dt_kfy_Info.Count; i++)
{
var setting = _settings.dt_kfy_Info[i];
setting.info_DangH = groupBox1.Text;
if (i == 0)
{
setting.info_DangH = groupBox1.Text;
setting.p1 = txt_p11.Text;
setting._p1 = txt_f_p11.Text;
setting.p2 = txt_p21.Text;
setting._p2 = txt_f_p21.Text;
setting.p3 = txt_p31.Text;
setting._p3 = txt_f_p31.Text;
}
if (i == 1)
{
setting.info_DangH = groupBox2.Text;
setting.p1 = txt_p12.Text;
setting._p1 = txt_f_p12.Text;
setting.p2 = txt_p22.Text;
setting._p2 = txt_f_p22.Text;
setting.p3 = txt_p32.Text;
setting._p3 = txt_f_p32.Text;
}
if (i == 2)
{
setting.info_DangH = groupBox3.Text;
setting.p1 = txt_p13.Text;
setting._p1 = txt_f_p13.Text;
setting.p2 = txt_p23.Text;
setting._p2 = txt_f_p23.Text;
setting.p3 = txt_p33.Text;
setting._p3 = txt_f_p33.Text;
}
}
}
new DAL_dt_qm_Info().UpdateResult(_settings);
#endregion
#region 获取设置后的樘号信息 -- 判定
InitResult();
Formula formula = new Formula();
DataTable settings = new DAL_dt_Settings().Getdt_SettingsByCode(_code);
if (settings != null && settings.Rows.Count > 0)
{
txt_sjz0.Text = settings.Rows[0]["KangFengYaSheJiZhi"].ToString();
txt_sjz1.Text = settings.Rows[0]["ShuiMiSheJiZhi"].ToString();
txt_sjz2.Text = settings.Rows[0]["QiMiZhengYaDanWeiFengChangSheJiZhi"].ToString();
txt_sjz3.Text = settings.Rows[0]["QiMiFuYaDanWeiFengChangSheJiZhi"].ToString();
txt_sjz4.Text = settings.Rows[0]["QiMiZhengYaDanWeiMianJiSheJiZhi"].ToString();
txt_sjz5.Text = settings.Rows[0]["QiMiFuYaDanWeiMianJiSheJiZhi"].ToString();
}
if (_settings.dt_qm_Info != null && _settings.dt_qm_Info.Count > 0)
{
var airTight = _settings.dt_qm_Info;
txt_dj1.Text = formula.Get_Z_AirTightLevel(airTight).ToString();
txt_dj4.Text = formula.Get_F_AirTightLevel(airTight).ToString();
double zFc = Math.Round(airTight.Sum(t => double.Parse(t.qm_Z_FC)) / airTight.Count, 2);
double fFc = Math.Round(airTight.Sum(t => double.Parse(t.qm_F_FC)) / airTight.Count, 2);
double zMj = Math.Round(airTight.Sum(t => double.Parse(t.qm_Z_MJ)) / airTight.Count, 2);
double fMj = Math.Round(airTight.Sum(t => double.Parse(t.qm_F_MJ)) / airTight.Count, 2);
if (zFc <= double.Parse(txt_sjz2.Text))
{
txt_jg2.Text = "合格";
}
else
{
txt_jg2.Text = "不合格";
}
if (fFc <= double.Parse(txt_sjz3.Text))
{
txt_jg3.Text = "合格";
}
else
{
txt_jg3.Text = "不合格";
}
if (zMj <= double.Parse(txt_sjz4.Text))
{
txt_jg4.Text = "合格";
}
else
{
txt_jg4.Text = "不合格";
}
if (fMj <= double.Parse(txt_sjz4.Text))
{
txt_jg5.Text = "合格";
}
else
{
txt_jg5.Text = "不合格";
}
}
if (_settings.dt_sm_Info != null && _settings.dt_sm_Info.Count > 0)
{
txt_dj2.Text = formula.GetWaterTightLevel(_settings.dt_sm_Info).ToString();
sm_value = _settings.dt_sm_Info.Sum(t => Convert.ToInt32(t.sm_Pa)) / _settings.dt_sm_Info.Count;
if (sm_value >= int.Parse(txt_sjz1.Text))
{
txt_jg1.Text = "合格";
}
else
{
txt_jg1.Text = "不合格";
}
}
if (_settings.dt_kfy_Info != null && _settings.dt_kfy_Info.Count > 0)
{
var value = new List <int>();
foreach (var item in _settings.dt_kfy_Info)
{
value.Add(int.Parse(item.p3));
value.Add(int.Parse(item._p3));
}
var minValue = value.Min(t => t);
txt_dj3.Text = Formula.GetWindPressureLevel(minValue).ToString();
if (minValue >= double.Parse(txt_sjz0.Text))
{
txt_jg0.Text = "合格";
}
else
{
txt_jg0.Text = "不合格";
}
}
#endregion
MessageBox.Show("生成成功！", "完成", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
Logger.Error(ex);
}
}
/// <summary>
/// 绑定控件
/// </summary>
private void BindInfoText()
{
try
{
DataTable dt = new DAL_dt_Settings().Getdt_SettingsByCode(_tempCode);
if (dt != null)
{
this.txt_WeiTuoBianHao.Text = dt.Rows[0]["weituobianhao"].ToString();
this.txt_WeiTuoDanWei.Text = dt.Rows[0]["weituodanwei"].ToString();
this.txt_dizhi.Text = dt.Rows[0]["dizhi"].ToString();
this.txt_dianhua.Text = dt.Rows[0]["dianhua"].ToString();
this.txt_chouyangriqi.Text = dt.Rows[0]["chouyangriqi"].ToString();
this.txt_chouyangdidian.Text = dt.Rows[0]["chouyangdidian"].ToString();
this.txt_gongchengmingcheng.Text = dt.Rows[0]["gongchengmingcheng"].ToString();
this.txt_gongchengdidian.Text = dt.Rows[0]["gongchengdidian"].ToString();
this.txt_shengchandanwei.Text = dt.Rows[0]["shengchandanwei"].ToString();
this.cb_JianCeXiangMu.Text = dt.Rows[0]["jiancexiangmu"].ToString();
this.txt_jiancedidian.Text = dt.Rows[0]["jiancedidian"].ToString();
this.txt_JianCeRiQi.Text = dt.Rows[0]["jianceriqi"].ToString();
this.txt_jianceshebei.Text = dt.Rows[0]["jianceshebei"].ToString();
this.cb_jianceyiju.Text = dt.Rows[0]["jianceyiju"].ToString();
this.txt_YangPinMingCheng.Text = dt.Rows[0]["yangpinmingcheng"].ToString();
this.txt_yangpinshangbiao.Text = dt.Rows[0]["yangpinshangbiao"].ToString();
this.txt_yangpinzhuangtai.Text = dt.Rows[0]["yangpinzhuangtai"].ToString();
this.txt_GuiGeXingHao.Text = dt.Rows[0]["guigexinghao"].ToString();
this.cb_KaiQiFangShi.Text = dt.Rows[0]["kaiqifangshi"].ToString();
this.cb_mianbanpinzhong.Text = dt.Rows[0]["mianbanpinzhong"].ToString();
this.txt_zuidamianban.Text = dt.Rows[0]["zuidamianban"].ToString();
this.txt_mianbanhoudu.Text = dt.Rows[0]["mianbanhoudu"].ToString();
this.cb_anzhuangfangshi.Text = dt.Rows[0]["anzhuangfangshi"].ToString();
this.cb_mianbanxiangqian.Text = dt.Rows[0]["mianbanxiangqian"].ToString();
this.cb_KuangShanMiFang.Text = dt.Rows[0]["kuangshanmifeng"].ToString();
this.txt_wujinpeijian.Text = dt.Rows[0]["wujinpeijian"].ToString();
this.txt_jianceshuliang.Text = dt.Rows[0]["jianceshuliang"].ToString();
this.cb_DangQianDangHao.Text = dt.Rows[0]["dangqiandanghao"].ToString();
this.txt_DangQianWenDu.Text = dt.Rows[0]["dangqianwendu"].ToString();
this.txt_DaQiYaLi.Text = dt.Rows[0]["daqiyali"].ToString();
this.txt_KaiQiFengChang.Text = dt.Rows[0]["kaiqifengchang"].ToString();
this.txt_shijianmianji.Text = dt.Rows[0]["shijianmianji"].ToString();
this.txt_ganjianchangdu.Text = dt.Rows[0]["ganjianchangdu"].ToString();
this.txt_penlinshuiliang.Text = dt.Rows[0]["penlinshuiliang"].ToString();
this.txt_qimidangweifengchangshejizhi.Text = dt.Rows[0]["qimidanweifengchangshejizhi"].ToString();
this.txt_QiMiDanWeiMianJiSheJiZhi.Text = dt.Rows[0]["qimidanweimianjishejizhi"].ToString();
this.txt_shuimijingyashejizhi.Text = dt.Rows[0]["shuimijingyashejizhi"].ToString();
this.txt_shuimidongyashejizhi.Text = dt.Rows[0]["shuimidongyashejizhi"].ToString();
this.txt_kangfengyazhengyashejizhi.Text = dt.Rows[0]["kangfengyazhengyashejizhi"].ToString();
this.txt_kangfengyafuyashejizhi.Text = dt.Rows[0]["kangfengyafuyashejizhi"].ToString();
this.cbb_danshandansuodian.Text = dt.Rows[0]["danshandansuodian"].ToString();
this.txt_kangfengyazhengp3shejizhi.Text = dt.Rows[0]["kangfengyazhengp3shejizhi"].ToString();
this.txt_kangfengyazhengpmaxshejizhi.Text = dt.Rows[0]["kangfengyazhengpmaxshejizhi"].ToString();
_tempCode = dt.Rows[0]["dt_Code"].ToString();
if (_tempTong == "")
{
_tempTong = dt.Rows[0]["info_DangH"].ToString();
}
cb_DangQianDangHao.Text = dt.Rows[0]["info_DangH"].ToString();
btn_JianYanBianHao.Text = dt.Rows[0]["dt_Code"].ToString();
this.cb_JianCeXiangMu.Enabled = false;
this.txt_jianceshuliang.Enabled = false;
}
else
{
btn_JianYanBianHao.Text = DateTime.Now.ToString("yyyyMMdd") + "-01";
}
if (string.IsNullOrEmpty(txt_jianceshuliang.Text))
{
txt_jianceshuliang.Text = "3";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
Logger.Error(ex);
}
}
/// <summary>
/// 绑定风速
/// </summary>
private void BindWindSpeedBase()
{
Model_dt_Settings dt_Settings = new DAL_dt_Settings().GetInfoByCode(_tempCode);
List <Pressure> pressureList = new List <Pressure>();
if (dt_Settings.dt_qm_Info != null && dt_Settings.dt_qm_Info.Count > 0)
{
var qm = dt_Settings.dt_qm_Info.FindAll(t => t.info_DangH == _tempTong && string.IsNullOrWhiteSpace(t.qm_j_f_zd100) == false).OrderBy(t => t.info_DangH);
//是否首次加载
if (IsFirst && (qm != null && qm.Count() > 0))
{
gv_list.Enabled = false;
foreach (var item in qm)
{
Pressure model1 = new Pressure();
model1.Pressure_F = string.IsNullOrWhiteSpace(item.qm_s_f_fj100) ? 0 : double.Parse(item.qm_s_f_fj100);
model1.Pressure_F_Z = string.IsNullOrWhiteSpace(item.qm_s_f_zd100) ? 0 : double.Parse(item.qm_s_f_zd100);
model1.Pressure_Z = string.IsNullOrWhiteSpace(item.qm_s_z_fj100) ? 0 : double.Parse(item.qm_s_z_fj100);
model1.Pressure_Z_Z = string.IsNullOrWhiteSpace(item.qm_s_z_zd100) ? 0 : double.Parse(item.qm_s_z_zd100);
model1.PressurePa = 100;
pressureList.Add(model1);
Pressure model2 = new Pressure();
model2.Pressure_F = string.IsNullOrWhiteSpace(item.qm_s_f_fj150) ? 0 : double.Parse(item.qm_s_f_fj150);
model2.Pressure_F_Z = string.IsNullOrWhiteSpace(item.qm_s_f_zd150) ? 0 : double.Parse(item.qm_s_f_zd150);
model2.Pressure_Z = string.IsNullOrWhiteSpace(item.qm_s_z_fj150) ? 0 : double.Parse(item.qm_s_z_fj150);
model2.Pressure_Z_Z = string.IsNullOrWhiteSpace(item.qm_s_z_zd150) ? 0 : double.Parse(item.qm_s_z_zd150);
model2.PressurePa = 150;
pressureList.Add(model2);
Pressure model3 = new Pressure();
model3.Pressure_F = string.IsNullOrWhiteSpace(item.qm_j_f_fj100) ? 0 : double.Parse(item.qm_j_f_fj100);
model3.Pressure_F_Z = string.IsNullOrWhiteSpace(item.qm_j_f_zd100) ? 0 : double.Parse(item.qm_j_f_zd100);
model3.Pressure_Z = string.IsNullOrWhiteSpace(item.qm_j_z_fj100) ? 0 : double.Parse(item.qm_j_z_fj100);
model3.Pressure_Z_Z = string.IsNullOrWhiteSpace(item.qm_j_z_zd100) ? 0 : double.Parse(item.qm_j_z_zd100);
model3.PressurePa = 100;
pressureList.Add(model3);
}
}
else
{
pressureList = pressure.GetPressure();
}
}
else
{
pressureList = pressure.GetPressure();
}
dgv_WindSpeed.DataSource = pressureList;
dgv_WindSpeed.Height = 115;
dgv_WindSpeed.RowHeadersVisible = false;
dgv_WindSpeed.AllowUserToResizeColumns = false;
dgv_WindSpeed.AllowUserToResizeRows = false;
dgv_WindSpeed.Columns[0].HeaderText = "压力Pa";
dgv_WindSpeed.Columns[0].Width = 37;
dgv_WindSpeed.Columns[0].ReadOnly = true;
dgv_WindSpeed.Columns[0].DataPropertyName = "PressurePa";
dgv_WindSpeed.Columns[1].HeaderText = "正压附加";
dgv_WindSpeed.Columns[1].Width = 55;
dgv_WindSpeed.Columns[1].DataPropertyName = "Pressure_Z";
dgv_WindSpeed.Columns[2].HeaderText = "正压总的";
dgv_WindSpeed.Columns[2].Width = 55;
dgv_WindSpeed.Columns[2].DataPropertyName = "Pressure_Z_Z";
dgv_WindSpeed.Columns[3].HeaderText = "负压附加";
dgv_WindSpeed.Columns[3].Width = 55;
dgv_WindSpeed.Columns[3].DataPropertyName = "Pressure_F";
dgv_WindSpeed.Columns[4].HeaderText = "负压总的";
dgv_WindSpeed.Columns[4].Width = 55;
dgv_WindSpeed.Columns[4].DataPropertyName = "Pressure_F_Z";
dgv_WindSpeed.Columns["Pressure_Z"].DefaultCellStyle.Format = "N2";
dgv_WindSpeed.Columns["Pressure_Z_Z"].DefaultCellStyle.Format = "N2";
dgv_WindSpeed.Columns["Pressure_F"].DefaultCellStyle.Format = "N2";
dgv_WindSpeed.Columns["Pressure_F_Z"].DefaultCellStyle.Format = "N2";
}
private void btn_audit_Click(object sender, EventArgs e)
{
try
{
#region 修改数据
if (_settings.dt_qm_Info != null && _settings.dt_qm_Info.Count > 0)
{
for (int i = 0; i < _settings.dt_qm_Info.Count; i++)
{
var setting = _settings.dt_qm_Info[i];
setting.dt_Code = _code;
setting.info_DangH = groupBox1.Text;
if (i == 0)
{
setting.qm_Z_FC = txt_1zfc.Text;
setting.qm_F_FC = txt_1ffc.Text;
setting.qm_Z_MJ = txt_1zmj.Text;
setting.qm_F_MJ = txt_1fmj.Text;
}
if (i == 1)
{
setting.info_DangH = groupBox2.Text;
setting.qm_Z_FC = txt_2zfc.Text;
setting.qm_F_FC = txt_2ffc.Text;
setting.qm_Z_MJ = txt_2zmj.Text;
setting.qm_F_MJ = txt_2fmj.Text;
}
if (i == 2)
{
setting.info_DangH = groupBox3.Text;
setting.qm_Z_FC = txt_3zfc.Text;
setting.qm_F_FC = txt_3ffc.Text;
setting.qm_Z_MJ = txt_3zmj.Text;
setting.qm_F_MJ = txt_3fmj.Text;
}
}
}
if (_settings.dt_sm_Info != null && _settings.dt_sm_Info.Count > 0)
{
for (int i = 0; i < _settings.dt_sm_Info.Count; i++)
{
var setting = _settings.dt_sm_Info[i];
setting.info_DangH = groupBox1.Text;
if (i == 0)
{
setting.sm_Pa = txt_1fy.Text;
setting.sm_PaDesc = lbl_1resdesc.Text;
setting.sm_Remark = lbl_1desc.Text;
}
if (i == 1)
{
setting.sm_Pa = txt_2fy.Text;
setting.sm_PaDesc = lbl_2resdesc.Text;
setting.sm_Remark = lbl_2desc.Text;
}
if (i == 2)
{
setting.sm_Pa = txt_3fy.Text;
setting.sm_PaDesc = lbl_3resdesc.Text;
setting.sm_Remark = lbl_3desc.Text;
}
}
new DAL_dt_qm_Info().UpdateResult(_settings);
#endregion
#region 获取设置后的樘号信息 -- 判定
InitResult();
Formula formula = new Formula();
DataTable settings = new DAL_dt_Settings().Getdt_SettingsByCode(_code);
if (settings != null && settings.Rows.Count > 0)
{
txt_sjz1.Text = settings.Rows[0]["ShuiMiSheJiZhi"].ToString();
txt_sjz2.Text = settings.Rows[0]["QiMiZhengYaDanWeiFengChangSheJiZhi"].ToString();
txt_sjz3.Text = settings.Rows[0]["QiMiFuYaDanWeiFengChangSheJiZhi"].ToString();
txt_sjz4.Text = settings.Rows[0]["QiMiZhengYaDanWeiMianJiSheJiZhi"].ToString();
txt_sjz5.Text = settings.Rows[0]["QiMiFuYaDanWeiMianJiSheJiZhi"].ToString();
}
if (_settings.dt_qm_Info != null && _settings.dt_qm_Info.Count > 0)
{
var airTight = _settings.dt_qm_Info;
txt_dj1.Text = formula.GetAirTightLevel(airTight).ToString();
double zFc = Math.Round(airTight.Sum(t => double.Parse(t.qm_Z_FC)) / airTight.Count, 2);
double fFc = Math.Round(airTight.Sum(t => double.Parse(t.qm_F_FC)) / airTight.Count, 2);
double zMj = Math.Round(airTight.Sum(t => double.Parse(t.qm_Z_MJ)) / airTight.Count, 2);
double fMj = Math.Round(airTight.Sum(t => double.Parse(t.qm_F_MJ)) / airTight.Count, 2);
if (zFc >= double.Parse(txt_sjz2.Text))
{
txt_jg2.Text = "合格";
}
else
{
txt_jg2.Text = "不合格";
}
if (fFc >= double.Parse(txt_sjz3.Text))
{
txt_jg3.Text = "合格";
}
else
{
txt_jg3.Text = "不合格";
}
if (zMj >= double.Parse(txt_sjz4.Text))
{
txt_jg4.Text = "合格";
}
else
{
txt_jg4.Text = "不合格";
}
if (fMj <= double.Parse(txt_sjz4.Text))
{
txt_jg5.Text = "合格";
}
else
{
txt_jg5.Text = "不合格";
}
}
if (_settings.dt_sm_Info != null && _settings.dt_sm_Info.Count > 0)
{
txt_dj2.Text = formula.GetWaterTightLevel(_settings.dt_sm_Info).ToString();
if (sm_value >= int.Parse(txt_sjz1.Text))
{
txt_jg1.Text = "合格";
}
else
{
txt_jg1.Text = "不合格";
}
}
if (_settings.dt_kfy_Info != null && _settings.dt_kfy_Info.Count > 0)
{
//todo:抗风压
}
#endregion
MessageBox.Show("生成成功！", "完成", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.ServiceNotification);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
Logger.Error(ex);
}
}
/// <summary>
/// 绑定水密初始值
/// </summary>
private void Initial()
{
//todo
// Model_dt_Settings dt_Settings = new DAL_dt_Settings().Getdt_SettingsResByCode(_tempCode);
Model_dt_Settings dt_Settings = new DAL_dt_Settings().GetInfoByCode(_tempCode);
List <Pressure> pressureList = new List <Pressure>();
if (dt_Settings.dt_qm_Info != null && dt_Settings.dt_qm_Info.Count > 0)
{
var sm = dt_Settings.dt_sm_Info.FindAll(t => t.info_DangH == _tempTong);
if (sm != null && sm.Count() > 0)
{
#region 绑定
var checkDesc = sm[0].sm_PaDesc;
var sm_pa = sm[0].sm_Pa;
var remark = sm[0].sm_Remark;
var flish = "";
var two = "";
string[] temp = null;
if (!string.IsNullOrWhiteSpace(checkDesc))
{
if (checkDesc.Contains("〇"))
{
temp = checkDesc.Split(new char[] { '〇' }, StringSplitOptions.RemoveEmptyEntries);
flish = temp[0];
two = "〇" + temp[1];
}
else if (checkDesc.Contains("□"))
{
temp = checkDesc.Split(new char[] { '□' }, StringSplitOptions.RemoveEmptyEntries);
flish = temp[0];
two = "□" + temp[1];
}
else if (checkDesc.Contains("△"))
{
temp = checkDesc.Split(new char[] { '△' }, StringSplitOptions.RemoveEmptyEntries);
flish = temp[0];
two = "△" + temp[1];
}
else if (checkDesc.Contains("▲"))
{
temp = checkDesc.Split(new char[] { '▲' }, StringSplitOptions.RemoveEmptyEntries);
flish = temp[0];
two = "▲" + temp[1];
}
else if (checkDesc.Contains("●"))
{
temp = checkDesc.Split(new char[] { '●' }, StringSplitOptions.RemoveEmptyEntries);
flish = temp[0];
two = "●" + temp[1];
}
else
{
temp = checkDesc.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
flish = temp[0];
two = temp[1];
}
if (sm_pa == "0")
{
cbb_1_0Pa.Text = flish;
cbb_2_0Pa.Text = two;
}
if (sm_pa == "100")
{
cbb_1_100Pa.Text = flish;
cbb_2_100Pa.Text = two;
}
if (sm_pa == "150")
{
cbb_1_150Pa.Text = flish;
cbb_2_150Pa.Text = two;
}
if (sm_pa == "200")
{
cbb_1_200Pa.Text = flish;
cbb_2_200Pa.Text = two;
}
if (sm_pa == "250")
{
cbb_1_250Pa.Text = flish;
cbb_2_250Pa.Text = two;
}
if (sm_pa == "300")
{
cbb_1_300Pa.Text = flish;
cbb_2_300Pa.Text = two;
}
if (sm_pa == "350")
{
cbb_1_350Pa.Text = flish;
cbb_2_350Pa.Text = two;
}
if (sm_pa == "400")
{
cbb_1_400Pa.Text = flish;
cbb_2_400Pa.Text = two;
}
if (sm_pa == "500")
{
cbb_1_500Pa.Text = flish;
cbb_2_500Pa.Text = two;
}
if (sm_pa == "600")
{
cbb_1_600Pa.Text = flish;
cbb_2_600Pa.Text = two;
}
if (sm_pa == "700")
{
cbb_1_700Pa.Text = flish;
cbb_2_700Pa.Text = two;
}
if (checkDesc.Contains("▲") || checkDesc.Contains("●"))
{
if (sm_pa == "100")
{
sm_pa = "0";
}
if (sm_pa == "150")
{
sm_pa = "100";
}
if (sm_pa == "200")
{
sm_pa = "150";
}
if (sm_pa == "250")
{
sm_pa = "200";
}
if (sm_pa == "300")
{
sm_pa = "250";
}
if (sm_pa == "350")
{
sm_pa = "300";
}
if (sm_pa == "400")
{
sm_pa = "350";
}
if (sm_pa == "500")
{
sm_pa = "400";
}
if (sm_pa == "600")
{
sm_pa = "500";
}
if (sm_pa == "700")
{
sm_pa = "600";
}
}
}
txt_zgfy.Text = sm_pa;
txt_desc.Text = remark;
#endregion
}
}
}
/// <summary>
/// 绑定控件
/// </summary>
private void BindInfoText()
{
try
{
DataTable dt = new DAL_dt_Settings().Getdt_SettingsByCode(_tempCode);
if (dt != null)
{
btn_WeiTuoBianHao.Text = dt.Rows[0]["WeiTuoBianHao"].ToString();
btn_WeiTuoDanWei.Text = dt.Rows[0]["WeiTuoDanWei"].ToString();
btn_WeiTuoRen.Text = dt.Rows[0]["WeiTuoRen"].ToString();
btn_YangPinMingCheng.Text = dt.Rows[0]["YangPinMingCheng"].ToString();
cb_CaiYangFangShi.Text = dt.Rows[0]["CaiYangFangShi"].ToString();
cb_JianYanXiangMu.Text = dt.Rows[0]["JianYanXiangMu"].ToString();
btn_GuiGeXingHao.Text = dt.Rows[0]["GuiGeXingHao"].ToString();
btn_GuiGeShuLiang.Text = dt.Rows[0]["GuiGeShuLiang"].ToString();
btn_JianYanRiQi.Text = dt.Rows[0]["JianYanRiQi"].ToString();
cb_KaiQiFangShi.Text = dt.Rows[0]["KaiQiFangShi"].ToString();
btn_DaQiYaLi.Text = dt.Rows[0]["DaQiYaLi"].ToString();
cb_BoLiPinZhong.Text = dt.Rows[0]["BoLiPinZhong"].ToString();
btn_DangQianWenDu.Text = dt.Rows[0]["DangQianWenDu"].ToString();
btn_BoLiHouDu.Text = dt.Rows[0]["BoLiHouDu"].ToString();
btn_ZongMianJi.Text = dt.Rows[0]["ZongMianJi"].ToString();
btn_ZuiDaBoLi.Text = dt.Rows[0]["ZuiDaBoLi"].ToString();
btn_KaiQiFengChang.Text = dt.Rows[0]["KaiQiFengChang"].ToString();
cb_BoLiMiFeng.Text = dt.Rows[0]["BoLiMiFeng"].ToString();
cb_XiangQianFangShi.Text = dt.Rows[0]["XiangQianFangShi"].ToString();
btn_ShuiMiDengJiSheJiZhi.Text = dt.Rows[0]["ShuiMiDengJiSheJiZhi"].ToString();
cb_KuangShanMiFang.Text = dt.Rows[0]["KuangShanMiFang"].ToString();
btn_QiMiZhengYaDanWeiFengChangSheJiZhi.Text = dt.Rows[0]["QiMiZhengYaDanWeiFengChangSheJiZhi"].ToString();
btn_ZhengYaQiMiDengJiSheJiZhi.Text = dt.Rows[0]["ZhengYaQiMiDengJiSheJiZhi"].ToString();
btn_QiMiFuYaDanWeiFengChangSheJiZhi.Text = dt.Rows[0]["QiMiFuYaDanWeiFengChangSheJiZhi"].ToString();
btn_FuYaQiMiDengJiSheJiZhi.Text = dt.Rows[0]["FuYaQiMiDengJiSheJiZhi"].ToString();
btn_ShuiMiSheJiZhi.Text = dt.Rows[0]["ShuiMiSheJiZhi"].ToString();
btn_QiMiZhengYaDanWeiMianJiSheJiZhi.Text = dt.Rows[0]["QiMiZhengYaDanWeiMianJiSheJiZhi"].ToString();
btn_QiMiFuYaDanWeiMianJiSheJiZhi.Text = dt.Rows[0]["QiMiFuYaDanWeiMianJiSheJiZhi"].ToString();
cb_JianYanYiJu.Text = dt.Rows[0]["JianYanYiJu"].ToString();
btn_GongChengMingCheng.Text = dt.Rows[0]["GongChengMingCheng"].ToString();
btn_GongChengDiDian.Text = dt.Rows[0]["GongChengDiDian"].ToString();
btn_ShengChanDanWei.Text = dt.Rows[0]["ShengChanDanWei"].ToString();
btn_JianLiDanWei.Text = dt.Rows[0]["JianLiDanWei"].ToString();
btn_JianZhengRen.Text = dt.Rows[0]["JianZhengRen"].ToString();
btn_JianZhengHao.Text = dt.Rows[0]["JianZhengHao"].ToString();
btn_ShiGongDanWei.Text = dt.Rows[0]["ShiGongDanWei"].ToString();
btn_WuJinJianZhuangKuang.Text = dt.Rows[0]["WuJinJianZhuangKuang"].ToString();
btn_SuLiaoChuangChenJinChiCun.Text = dt.Rows[0]["SuLiaoChuangChenJinChiCun"].ToString();
btn_ShiFouJiaLuoSi.Text = dt.Rows[0]["ShiFouJiaLuoSi"].ToString();
btn_XingCaiGuiGe.Text = dt.Rows[0]["XingCaiGuiGe"].ToString();
btn_XingCaiBiHou.Text = dt.Rows[0]["XingCaiBiHou"].ToString();
btn_XingCaiShengChanChang.Text = dt.Rows[0]["XingCaiShengChanChang"].ToString();
txt_ganjianchadu.Text = dt.Rows[0]["GanJianChangDu"].ToString();
txt_KangFengyadengjishejizhi.Text = dt.Rows[0]["KangFengYaDengJiSheJiZhi"].ToString();
txt_kangfengyashejizhi.Text = dt.Rows[0]["KangFengYaSheJiZhi"].ToString();
cbb_danshandansuodian.Text = dt.Rows[0]["DanShanDanSuoDian"].ToString();
_tempCode = dt.Rows[0]["dt_Code"].ToString();
_tempTong = dt.Rows[0]["info_DangH"].ToString();
cb_DangQianDangHao.Text = dt.Rows[0]["info_DangH"].ToString();
btn_JianYanBianHao.Text = dt.Rows[0]["dt_Code"].ToString();
this.cb_JianYanXiangMu.Enabled = false;
this.btn_GuiGeShuLiang.Enabled = false;
}
else
{
btn_JianYanBianHao.Text = DateTime.Now.ToString("yyyyMMdd") + "-01";
}
if (string.IsNullOrEmpty(btn_GuiGeShuLiang.Text))
{
btn_GuiGeShuLiang.Text = "3";
}
if (_temppressure != 0 && _temperature != 0)
{
btn_DaQiYaLi.Text = _temppressure.ToString();
btn_DangQianWenDu.Text = _temperature.ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
Logger.Error(ex);
}
}
private void Eexport(string fileName)
{
try
{
string strResult = string.Empty;
string strPath = System.Windows.Forms.Application.StartupPath + "\\template";
string strFile = string.Format(@"{0}\{1}", strPath, fileName);
FolderBrowserDialog path = new FolderBrowserDialog();
path.ShowDialog();
label3.Visible = true;
btn_ok.Enabled = false;
cm_Report.Enabled = false;
btn_close.Enabled = false;
string[] name = fileName.Split('.');
string _name = name[0] + "_" + _tempCode + "." + name[1];
var saveExcelUrl = path.SelectedPath + "\\" + _name;
Model_dt_Settings settings = new DAL_dt_Settings().Getdt_SettingsResByCode(_tempCode);
if (settings == null)
{
MessageBox.Show("未查询到相关编号");
this.Close();
return;
}
var dc = new Dictionary <string, string>();
if (fileName == "门窗检验报告.doc")
{
dc = GetDWDetectionReport(settings);
}
else if (fileName == "试验室记录.doc")
{
dc = GetDetectionReport(settings);
}
else if (fileName == "现场报告（1樘）.doc")
{
dc = GetTong1(settings);
}
else if (fileName == "现场报告（2樘）.doc")
{
dc = GetTong2(settings);
}
else if (fileName == "现场报告（3樘）.doc")
{
dc = GetTong3(settings);
}
WordUtility wu = new WordUtility(strFile, saveExcelUrl);
if (wu.GenerateWordByBookmarks(dc))
{
MessageBox.Show("导出成功", "导出成功",
MessageBoxButtons.OK,
MessageBoxIcon.None,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.ServiceNotification
);
this.Hide();
}
}
catch (Exception ex)
{
MessageBox.Show("数据出现问题，导出失败！");
this.Close();
}
}
