private void 删除_功率测量仪表数据()
{
if (_form == null)
{
_form = new FormElement();
}
_form.deleteTabs(new string[] { "dbo.功率测量仪表" });
}
private void 删除_液力耦合器数据()
{
if (_form == null)
{
_form = new FormElement();
}
_form.deleteTabs(new string[] { "dbo.液力耦合器" });
}
private void 保存_出口压力仪表数据()
{
if (_form == null)
{
_form = new FormElement();
}
_form.SaveTabs(new string[] { "dbo.出口压力仪表" });
}
private void 删除_转速测量数据()
{
if (_form == null)
{
_form = new FormElement();
}
_form.deleteTabs(new string[] { "dbo.转速测量" });
}
private void 水泵型号管理_Load(object sender, EventArgs e)
{
if (_form == null)
{
_form = new FormElement();
}
_form.LoadTabs(new string[] { "dbo.水泵型号管理" }, new decimal[] { -1 });
_form.AddControlByLayout(this.panel_用户名称, "dbo.水泵型号管理", "用户名称");
_form.AddControlByLayout(this.panel_出厂编号, "dbo.水泵型号管理", "出厂编号");
_form.AddControlByLayout(this.panel_水泵型号, "dbo.水泵型号管理", "水泵型号");
_form.AddControlByLayout(this.panel_水泵类型, "dbo.水泵型号管理", "水泵类型");
_form.AddControlByLayout(this.panel_额定流量, "dbo.水泵型号管理", "额定流量");
_form.AddControlByLayout(this.panel_额定扬程, "dbo.水泵型号管理", "额定扬程");
_form.AddControlByLayout(this.panel_额定轴功率, "dbo.水泵型号管理", "额定轴功率");
_form.AddControlByLayout(this.panel_汽蚀余量, "dbo.水泵型号管理", "汽蚀余量");
_form.AddControlByLayout(this.panel_进口直径, "dbo.水泵型号管理", "进口直径");
_form.AddControlByLayout(this.panel_出口直径, "dbo.水泵型号管理", "出口直径");
_form.AddControlByLayout(this.panel_额定转速, "dbo.水泵型号管理", "额定转速");
_form.AddControlByLayout(this.panel_工况1_流量, "dbo.水泵型号管理", "工况1_流量");
_form.AddControlByLayout(this.panel_工况1_扬程, "dbo.水泵型号管理", "工况1_扬程");
_form.AddControlByLayout(this.panel_工况1_轴功率, "dbo.水泵型号管理", "工况1_轴功率");
_form.AddControlByLayout(this.panel_工况1_汽蚀余量, "dbo.水泵型号管理", "工况1_汽蚀余量");
_form.AddControlByLayout(this.panel_工况2_流量, "dbo.水泵型号管理", "工况2_流量");
_form.AddControlByLayout(this.panel_工况2_扬程, "dbo.水泵型号管理", "工况2_扬程");
_form.AddControlByLayout(this.panel_工况2_轴功率, "dbo.水泵型号管理", "工况2_轴功率");
_form.AddControlByLayout(this.panel_工况2_汽蚀余量, "dbo.水泵型号管理", "工况2_汽蚀余量");
_form.AddControlByLayout(this.panel_工况3_流量, "dbo.水泵型号管理", "工况3_流量");
_form.AddControlByLayout(this.panel_工况3_扬程, "dbo.水泵型号管理", "工况3_扬程");
_form.AddControlByLayout(this.panel_工况3_轴功率, "dbo.水泵型号管理", "工况3_轴功率");
_form.AddControlByLayout(this.panel_工况3_汽蚀余量, "dbo.水泵型号管理", "工况3_汽蚀余量");
_form.AddControlByLayout(this.panel_工况4_流量, "dbo.水泵型号管理", "工况4_流量");
_form.AddControlByLayout(this.panel_工况4_扬程, "dbo.水泵型号管理", "工况4_扬程");
_form.AddControlByLayout(this.panel_工况4_轴功率, "dbo.水泵型号管理", "工况4_轴功率");
_form.AddControlByLayout(this.panel_工况4_汽蚀余量, "dbo.水泵型号管理", "工况4_汽蚀余量");
_form.AddControlByLayout(this.panel_工况5_流量, "dbo.水泵型号管理", "工况5_流量");
_form.AddControlByLayout(this.panel_工况5_扬程, "dbo.水泵型号管理", "工况5_扬程");
_form.AddControlByLayout(this.panel_工况5_轴功率, "dbo.水泵型号管理", "工况5_轴功率");
_form.AddControlByLayout(this.panel_工况5_汽蚀余量, "dbo.水泵型号管理", "工况5_汽蚀余量");
查询_水泵型号管理数据();
}
private void 删除_水泵型号管理数据()
{
if (_form == null)
{
_form = new FormElement();
}
_form.deleteTabs(new string[] { "dbo.水泵型号管理" });
}
private void 保存_水泵型号管理数据()
{
if (_form == null)
{
_form = new FormElement();
}
Decimal[] ID = _form.SaveTabs(new string[] { "dbo.水泵型号管理" });
foreach (Decimal _ID in ID)
{
添加图片ToDB(_ID);
break;
}
}
private void 电机型号管理_Load(object sender, EventArgs e)
{
if (_form == null)
{
_form = new FormElement();
}
_form.LoadTabs(new string[] { "dbo.电机型号管理" }, new decimal[] { -1 });
_form.AddControlByLayout(this.panel_电机制造商, "dbo.电机型号管理", "电机制造商");
_form.AddControlByLayout(this.panel_出厂编号, "dbo.电机型号管理", "出厂编号");
_form.AddControlByLayout(this.panel_电机型号, "dbo.电机型号管理", "电机型号");
_form.AddControlByLayout(this.panel_额定电压, "dbo.电机型号管理", "额定电压");
_form.AddControlByLayout(this.panel_额定电流, "dbo.电机型号管理", "额定电流");
_form.AddControlByLayout(this.panel_额定功率, "dbo.电机型号管理", "额定功率");
_form.AddControlByLayout(this.panel_额定效率, "dbo.电机型号管理", "额定效率");
查询_电机型号管理数据();
}
// public void 控件
private void 保存_电机型号管理数据()
{
if (_form == null)
{
_form = new FormElement();
}
_form.SaveTabs(new string[] { "dbo.电机型号管理" });
}
private void 振动测量仪表_Load(object sender, EventArgs e)
{
if (_form == null)
{
_form = new FormElement();
}
_form.LoadTabs(new string[] { "dbo.振动测量仪表" }, new decimal[] { -1 });
_form.AddControlByLayout(this.panel_仪器名称, "dbo.振动测量仪表", "仪器名称");
_form.AddControlByLayout(this.panel_仪器型号, "dbo.振动测量仪表", "仪器型号");
_form.AddControlByLayout(this.panel_检定单位, "dbo.振动测量仪表", "检定单位");
查询_振动测量仪表数据();
}
private void 流量仪表_Load(object sender, EventArgs e)
{
if (_form == null)
{
_form = new FormElement();
}
_form.LoadTabs(new string[] { "dbo.流量仪表" }, new decimal[] { -1 });
_form.AddControlByLayout(this.panel_流量计类型, "dbo.流量仪表", "流量计类型");
_form.AddControlByLayout(this.panel_传出转速上限, "dbo.流量仪表", "传出转速上限");
_form.AddControlByLayout(this.panel_流量计编号, "dbo.流量仪表", "流量计编号");
_form.AddControlByLayout(this.panel_传出转速下限, "dbo.流量仪表", "传出转速下限");
_form.AddControlByLayout(this.panel_传递功率, "dbo.流量仪表", "传递功率");
_form.AddControlByLayout(this.panel_流量计规格, "dbo.流量仪表", "流量计规格");
_form.AddControlByLayout(this.panel_传入转速, "dbo.流量仪表", "传入转速");
_form.AddControlByLayout(this.panel_传递效率, "dbo.流量仪表", "传递效率");
查询_流量仪表数据();
}
private void 删除_试验组数据()
{
if (_form == null)
{
_form = new FormElement();
}
_form.deleteTabs(new string[] { "dbo.生成试验组" });
}
private void 保存_试验组数据()
{
string[] str = new string[15];
string[] strFiled = new string[15];
string strTemp = "";
if (_form == null)
{
_form = new FormElement();
}
str[0] = _form.GetControlElementByInfo("dbo.生成试验组", "试验日期").GetValue();
strFiled[0] = "试验日期";
str[1] = _form.GetControlElementByInfo("dbo.生成试验组", "试验编号").GetValue();
strFiled[1] = "试验编号";
str[2] = _form.GetControlElementByInfo("dbo.生成试验组", "试验组名").GetValue();
strFiled[2] = "试验组名";
strTemp = _form.GetControlElementByInfo("dbo.生成试验组", "被试水泵ID").GetValue();
strFiled[3] = "被试水泵ID";
str[3] = data_被试水泵.获取ID(strTemp);
strTemp = _form.GetControlElementByInfo("dbo.生成试验组", "拖动电机ID").GetValue();
strFiled[4] = "拖动电机ID";
str[4] = data_拖动电机.获取ID(strTemp);
strTemp = _form.GetControlElementByInfo("dbo.生成试验组", "流量仪表ID").GetValue();
strFiled[5] = "流量仪表ID";
str[5] = data_流量仪表.获取ID(strTemp);
strTemp = _form.GetControlElementByInfo("dbo.生成试验组", "转速测量ID").GetValue();
strFiled[6] = "转速测量ID";
str[6] = data_转速测量.获取ID(strTemp);
strTemp = _form.GetControlElementByInfo("dbo.生成试验组", "进口压力仪表ID").GetValue();
strFiled[7] = "进口压力仪表ID";
str[7] = data_进口压力仪表.获取ID(strTemp);
strTemp = _form.GetControlElementByInfo("dbo.生成试验组", "出口压力仪表ID").GetValue();
strFiled[8] = "出口压力仪表ID";
str[8] = data_出口压力仪表.获取ID(strTemp);
strTemp = _form.GetControlElementByInfo("dbo.生成试验组", "功率测量仪表ID").GetValue();
strFiled[9] = "功率测量仪表ID";
str[9] = data_功率测量仪表.获取ID(strTemp);
strTemp = _form.GetControlElementByInfo("dbo.生成试验组", "温度测量仪表ID").GetValue();
strFiled[10] = "温度测量仪表ID";
str[10] = data_温度测量仪表.获取ID(strTemp);
strTemp = _form.GetControlElementByInfo("dbo.生成试验组", "液力耦合器ID").GetValue();
strFiled[11] = "液力耦合器ID";
str[11] = data_液力耦合器.获取ID(strTemp);
//-----------------add室温--------------begin
strFiled[12] = "室温";
str[12] = _form.GetControlElementByInfo("dbo.生成试验组", "室温").GetValue();
//---------------- add 室温------------end
strFiled[13] = "水温";
str[13] = _form.GetControlElementByInfo("dbo.生成试验组", "水温").GetValue();
strFiled[14] = "气压";
str[14] = _form.GetControlElementByInfo("dbo.生成试验组", "气压").GetValue();
_form.SaveTabs("dbo.生成试验组", strFiled,str);
}
private void 生成试验组_Load(object sender, EventArgs e)
{
if (_form == null)
{
_form = new FormElement();
}
_form.LoadTabs(new string[] { "dbo.生成试验组" }, new decimal[] { -1 });
_form.AddControlByLayout(this.panel_试验日期, "dbo.生成试验组", "试验日期");
_form.AddControlByLayout(this.panel_试验组名, "dbo.生成试验组", "试验组名");
_form.AddControlByLayout(this.panel_试验编号, "dbo.生成试验组", "试验编号");
//-----------------add室温--------------begin
_form.AddControlByLayout(this.panel_室温, "dbo.生成试验组", "室温");
//---------------- add 室温------------end
_form.AddControlByLayout(this.panel_水温, "dbo.生成试验组", "水温");
_form.AddControlByLayout(this.panel_气压, "dbo.生成试验组", "气压");
_form.AddControlByLayout(this.panel_被试水泵, "dbo.生成试验组", "被试水泵ID");
_form.AddControlByLayout(this.panel_拖动电机, "dbo.生成试验组", "拖动电机ID");
_form.AddControlByLayout(this.panel_流量仪表, "dbo.生成试验组", "流量仪表ID");
_form.AddControlByLayout(this.panel_转速测量, "dbo.生成试验组", "转速测量ID");
_form.AddControlByLayout(this.panel_进口压力仪表, "dbo.生成试验组", "进口压力仪表ID");
_form.AddControlByLayout(this.panel_出口压力仪表, "dbo.生成试验组", "出口压力仪表ID");
_form.AddControlByLayout(this.panel_功率测量仪表, "dbo.生成试验组", "功率测量仪表ID");
_form.AddControlByLayout(this.panel_温度测量仪表, "dbo.生成试验组", "温度测量仪表ID");
_form.AddControlByLayout(this.panel_液力耦合器, "dbo.生成试验组", "液力耦合器ID");
查询_试验组数据();
刷新控件数据();
}
private bool insert水泵环境参数配置(int ID)
{
string strSql = "insert into dbo.水泵环境参数 (ID,出厂编号,流量通道,流量最大量程,进口压力通道,进口压力量程," +
"出口压力通道,出口压力量程,变比,偏移量,常量) values (" +
ID + ",";
strSql += "'";
strSql += m_str出厂编号;
strSql += "','";
strSql += c流量.SelectedItem;
strSql += "',";
strSql += Convert.ToSingle(c流量最大量程.Text);
strSql += ",'";
strSql += c进口压力.SelectedItem;
strSql += "',";
strSql += System.Convert.ToSingle(t进口压力.Text);
strSql += ",'";
strSql += c出口压力.SelectedItem;
strSql += "',";
strSql += System.Convert.ToSingle(t出口压力.Text);
strSql += ",";
strSql += System.Convert.ToSingle(a.Text);
strSql += ",";
strSql += System.Convert.ToSingle(b.Text);
strSql += ",";
strSql += System.Convert.ToSingle(c.Text);
strSql += ")";
try
{
if (_form == null)
{
_form = new FormElement();
}
_form.ExcuteSql(strSql);
}
catch (System.Exception ex)
{
return false;
}
return true;
}
private bool update水泵环境参数配置(int ID)
{
string strSql = "update dbo.水泵环境参数 set ";
strSql += "出厂编号='";
strSql += m_str出厂编号;
strSql += "',";
strSql += "流量通道='";
strSql += c流量.SelectedItem;
strSql += "',";
strSql += "流量最大量程=";
strSql += Convert.ToSingle(c流量最大量程.Text);
strSql += ",";
strSql += "进口压力通道='";
strSql += c进口压力.SelectedItem;
strSql += "',";
strSql += "进口压力量程=";
strSql += System.Convert.ToSingle(t进口压力.Text);
strSql += ",";
strSql += "出口压力通道='";
strSql += c出口压力.SelectedItem;
strSql += "',";
strSql += "出口压力量程=";
strSql += System.Convert.ToSingle(t出口压力.Text);
strSql += ",";
strSql += "变比=";
strSql += System.Convert.ToSingle(a.Text);
strSql += ",";
strSql += "偏移量=";
strSql += System.Convert.ToSingle(b.Text);
strSql += ",";
strSql += "常量=";
strSql += System.Convert.ToSingle(c.Text);
strSql += " where ID=" + ID;
try
{
if (_form == null)
{
_form = new FormElement();
}
_form.ExcuteSql(strSql);
}
catch (System.Exception ex)
{
return false;
}
return true;
}
private void 出口压力仪表_Load(object sender, EventArgs e)
{
if (_form == null)
{
_form = new FormElement();
}
_form.LoadTabs(new string[] { "dbo.出口压力仪表" }, new decimal[] { -1 });
_form.AddControlByLayout(this.panel_变送器型号, "dbo.出口压力仪表", "变送器型号");
_form.AddControlByLayout(this.panel_变送器编号, "dbo.出口压力仪表", "变送器编号");
_form.AddControlByLayout(this.panel_出口表距, "dbo.出口压力仪表", "出口表距");
_form.AddControlByLayout(this.panel_量程上限, "dbo.出口压力仪表", "量程上限");
_form.AddControlByLayout(this.panel_量程下限, "dbo.出口压力仪表", "量程下限");
_form.AddControlByLayout(this.panel_有效期, "dbo.出口压力仪表", "有效期");
查询_出口压力仪表数据();
}
private void 转速测量_Load(object sender, EventArgs e)
{
if (_form == null)
{
_form = new FormElement();
}
_form.LoadTabs(new string[] { "dbo.转速测量" }, new decimal[] { -1 });
_form.AddControlByLayout(this.panel_传感器类型, "dbo.转速测量", "传感器类型");
_form.AddControlByLayout(this.panel_传感器编号, "dbo.转速测量", "传感器编号");
_form.AddControlByLayout(this.panel_测量方式, "dbo.转速测量", "测量方式");
查询_转速测量数据();
}
private void 功率测量仪表_Load(object sender, EventArgs e)
{
if (_form == null)
{
_form = new FormElement();
}
_form.LoadTabs(new string[] { "dbo.功率测量仪表" }, new decimal[] { -1 });
_form.AddControlByLayout(this.panel_测功方式, "dbo.功率测量仪表", "测功方式");
_form.AddControlByLayout(this.panel_扭矩传感器规格, "dbo.功率测量仪表", "扭矩传感器规格");
_form.AddControlByLayout(this.panel_二次仪表编号, "dbo.功率测量仪表", "二次仪表编号");
_form.AddControlByLayout(this.panel_扭矩传感器编号, "dbo.功率测量仪表", "扭矩传感器编号");
_form.AddControlByLayout(this.panel_检定有效日期, "dbo.功率测量仪表", "检定有效日期");
_form.AddControlByLayout(this.panel_电测功电压选择, "dbo.功率测量仪表", "电测功电压选择");
_form.AddControlByLayout(this.panel_变送器编号, "dbo.功率测量仪表", "变送器编号");
查询_功率测量仪表数据();
}
private void 液力耦合器_Load(object sender, EventArgs e)
{
if (_form == null)
{
_form = new FormElement();
}
_form.LoadTabs(new string[] { "dbo.液力耦合器" }, new decimal[] { -1 });
_form.AddControlByLayout(this.panel_耦合器制造商, "dbo.液力耦合器", "耦合器制造商");
_form.AddControlByLayout(this.panel_耦合器型号, "dbo.液力耦合器", "耦合器型号");
_form.AddControlByLayout(this.panel_出厂编号, "dbo.液力耦合器", "出厂编号");
_form.AddControlByLayout(this.panel_传递功率, "dbo.液力耦合器", "传递功率");
_form.AddControlByLayout(this.panel_传入转速, "dbo.液力耦合器", "传入转速");
_form.AddControlByLayout(this.panel_传出转速上限, "dbo.液力耦合器", "传出转速上限");
_form.AddControlByLayout(this.panel_传出转速下限, "dbo.液力耦合器", "传出转速下限");
_form.AddControlByLayout(this.panel_传递效率, "dbo.液力耦合器", "传递效率");
查询_水泵型号管理数据();
}