/// <summary>
/// 这个函数的作用就是打开文件时，将数据库中的所有记录填写到窗体上
/// </summary>
/// <param name="pro_Id"></param>
public bool SearchDatabaseFillEntity(int pro_Id)
{
ProjinfoHandle projinfoHandle = new ProjinfoHandle();
ScaffordParaHandle scaf = new ScaffordParaHandle();
DataTable dt = projinfoHandle.SearchInfo(pro_Id);
DataTable dtPara = scaf.SearchPara(pro_Id);
//判断dt的合理性
if (dt.Rows.Count == 1 && dtPara.Rows.Count == 1)//正确的dt会只查询出一行
{
try
{
//工程信息
ProjectInfo.Clear();
ProjectInfo.Pro_Id = pro_Id;
ProjectInfo.Pro_Name = dt.Rows[0]["pro_name"].ToString();
ProjectInfo.Pro_Type = dt.Rows[0]["pro_type"].ToString();
ProjectInfo.Con_Province = dt.Rows[0]["con_province"].ToString();
ProjectInfo.Con_City = dt.Rows[0]["con_city"].ToString();
ProjectInfo.Unit = dt.Rows[0]["unit"].ToString();
ProjectInfo.Con_Unit = dt.Rows[0]["con_unit"].ToString();
ProjectInfo.Sup_Unit = dt.Rows[0]["sup_unit"].ToString();
ProjectInfo.Con_Area = double.Parse(dt.Rows[0]["con_area"].ToString());
ProjectInfo.Con_Height = double.Parse(dt.Rows[0]["con_height"].ToString());
ProjectInfo.Des_Unit = dt.Rows[0]["des_unit"].ToString();
//脚手架参数
ScaffoldPara.Clear();
ScaffoldPara.Sca_Type = dtPara.Rows[0]["sca_type"].ToString();
ScaffoldPara.Con_Layers = (int)dtPara.Rows[0]["con_layers"];
ScaffoldPara.Act_Layers = (int)dtPara.Rows[0]["act_layers"];
ScaffoldPara.Soil_Types = dtPara.Rows[0]["soil_types"].ToString();
ScaffoldPara.Rough_Level = dtPara.Rows[0]["rough_level"].ToString();
ScaffoldPara.Cha_Value = (double)dtPara.Rows[0]["cha_value"];
ScaffoldPara.Pad_Area = (double)dtPara.Rows[0]["pad_area"];
ScaffoldPara.Anchor_Style = dtPara.Rows[0]["anchor_style"].ToString();
ScaffoldPara.Anchor_Type = dtPara.Rows[0]["anchor_type"].ToString();
ScaffoldPara.Anchor_Model = dtPara.Rows[0]["anchor_model"].ToString();
ScaffoldPara.Anchor_Connect = dtPara.Rows[0]["anchor_connect"].ToString();
ScaffoldPara.Sca_Situation = dtPara.Rows[0]["sca_situation"].ToString();
ScaffoldPara.Bui_Status = dtPara.Rows[0]["bui_status"].ToString();
ScaffoldPara.Bui_Distance = (double)dtPara.Rows[0]["bui_distance"];
ScaffoldPara.Per_Brace = (int)dtPara.Rows[0]["per_brace"];
ScaffoldPara.Per_Level = (int)dtPara.Rows[0]["per_level"];
ScaffoldPara.Per_Set = (int)dtPara.Rows[0]["per_set"];
ScaffoldPara.La = (double)dtPara.Rows[0]["la"];
ScaffoldPara.Lb = (double)dtPara.Rows[0]["lb"];
ScaffoldPara.H = (double)dtPara.Rows[0]["h"];
ScaffoldPara.Fast_Num = (int)dtPara.Rows[0]["fast_num"];
ScaffoldPara.Fitting_Model = dtPara.Rows[0]["fitting_model"].ToString();
ScaffoldPara.Step_Num = (int)dtPara.Rows[0]["step_num"];
//材料库
MaterialLib.clearMaterialLib();
MaterialLib.dtMaterial = new SQLOperations().GetMateriallib(ProjectInfo.Pro_Id); //为复现dgv中的内容，于数据库查询dt
new SQLOperations().FillValidArray(MaterialLib.dtMaterial); //为解决不打开材料库时数据消失的问题，复现validArray
return(true);
}
catch
{
ErrorService.Show("写入了不合法字符");
return(false);
}
}
else
{
ErrorService.Show("本机数据库与工程文件不匹配");
return(false);
}
}
