public void T() { #region 市政取芯数据录入求值 sql = $"select m.*,s.jcxm,s.BZMD_S1 from {ysjbmc} m inner join {sjbmc} e on e.recid = m.sysjbrecid inner join s_lqx s on s.recid = e.sysjbrecid where m.sysjbrecid = '{recid}' "; dt = CommonDao.GetDataTableTran(sql); if (dt.Count > 0) { var dic = dt[0]; string jcxm = "、" + dic["jcxm"].Replace(',', '、') + "、"; if (jcxm.Contains("、厚度、")) { dic["hd"] = Math.Round((dic["schd1"].GetSafeDouble() + dic["schd2"].GetSafeDouble() + dic["schd3"].GetSafeDouble() + dic["schd4"].GetSafeDouble()) / 4, 2).ToString("0.00"); } else { dic["hd"] = "----"; } if (jcxm.Contains("、密度(表干法、水中法、蜡封法)、")) { if (dic["syff"] == "表干法" || dic["syff"] == "水中重法") { dic["md"] = Math.Round(dic["kqzzl"].GetSafeDouble() / (dic["bgzl"].GetSafeDouble() - dic["szzl"].GetSafeDouble()) * 0.9771, 3).ToString("F3"); } else if (dic["syff"] == "蜡封法") { if (dic["sfhs"] == "是") //用滑石粉 { dic["md"] = Math.Round(dic["sjkz"].GetSafeDouble() / ((dic["lkzl"].GetSafeDouble() - dic["lszl"].GetSafeDouble()) - ((dic["lkzl"].GetSafeDouble() - dic["thkz"].GetSafeDouble()) / dic["slmd"].GetSafeDouble() + (dic["thkz"].GetSafeDouble() - dic["sjkz"].GetSafeDouble()) / dic["hsmd"].GetSafeDouble())) * 0.9771, 3).ToString("F3"); } else { dic["md"] = Math.Round(dic["sjkz"].GetSafeDouble() / ((dic["lkzl"].GetSafeDouble() - dic["lszl"].GetSafeDouble()) - (dic["lkzl"].GetSafeDouble() - dic["sjkz"].GetSafeDouble()) / dic["slmd"].GetSafeDouble()) * 0.9771, 3).ToString("F3"); } } else { dic["syff"] = "----"; } if (MatchValue.IsNumeric(dic["md"]) && MatchValue.IsNumeric(dic["BZMD_S1"])) { dic["YSD"] = Math.Round(dic["md"].GetSafeDouble() / dic["BZMD_S1"].GetSafeDouble() * 100, 2).GetSafeString(); } } else { dic["syff"] = "----"; } upsqls.Add($"update {ysjbmc} set hd = '{dic["hd"]}',ysd = '{dic["ysd"]}' where sysjbrecid = '{recid}'"); upsqls.Add($"update {sjbmc} set SCHD = '{dic["hd"]}',SCYSD = '{dic["ysd"]}',MD = '{dic["md"]}' where recid = '{recid}'"); } #endregion }