/**
* 根据model_no和step_name更新选中的数据
* */
public static bool UpdateData(HPO_Model hPO_Model)
{
bool flag = false;
flag = OilP.Dao.HPO_DAO.UpdateData(hPO_Model);
return(flag);
}
public static HPO_Model StringToHPOModel(int length, string[] readline)
{
HPO_Model hPO_Model = new HPO_Model();
hPO_Model.Model_no = readline[0];
hPO_Model.Manufacturer = readline[1];
hPO_Model.Curve = readline[2];
hPO_Model.Step_name = readline[3];
hPO_Model.Round_speed = readline[4];
hPO_Model.Drv_a = readline[5];
hPO_Model.Rail_pressure = readline[6];
hPO_Model.Oil_p_standard = readline[7];
hPO_Model.Oil_p_deviationr = readline[8];
hPO_Model.Oil_h_standard = readline[9];
hPO_Model.Oil_h_deviationr = readline[10];
hPO_Model.Start_angle = readline[11];
hPO_Model.Voltage = readline[12];
hPO_Model.Oil_j_pressure = readline[13];
hPO_Model.Oil_h_pressure = readline[14];
hPO_Model.Pump_pressure = readline[15];
hPO_Model.Motor_steering = readline[16];
hPO_Model.Test_time = readline[17];
return(hPO_Model);
}
/**
* 将Common_Rail_Injector_Test数据初始化到界面上
* */
public void fillData(HPO_Model hPO_Model)
{
//combobox赋值,测试能否成功
manus_combobox.Text = hPO_Model.Manufacturer;
step_name_TextBox.Text = hPO_Model.Step_name;
drv_a_TextBox.Text = hPO_Model.Drv_a;
rail_pressure_TextBox.Text = hPO_Model.Rail_pressure;
oil_p_standard_TextBox.Text = hPO_Model.Oil_p_standard;
oil_p_deviationr_TextBox.Text = hPO_Model.Oil_p_deviationr;
oil_h_standard_TextBox.Text = hPO_Model.Oil_h_standard;
oil_h_deviation_TextBox.Text = hPO_Model.Oil_h_deviationr;
start_angle_TextBox.Text = hPO_Model.Start_angle;
voltage_TextBox.Text = hPO_Model.Voltage;
oil_j_pressure_TextBox.Text = hPO_Model.Oil_j_pressure;
oil_h_pressure_TextBox.Text = hPO_Model.Oil_h_pressure;
pump_pressure_TextBox.Text = hPO_Model.Pump_pressure;
motor_steering_TextBox.Text = hPO_Model.Motor_steering;
test_time_TextBox.Text = hPO_Model.Test_time;
//读取数据后设置不可编辑
List <TextBox> textBoxes = new List <TextBox>();
textBoxes = GetNameOfTextBox();
SetEditable(false, textBoxes);
}
/*
* 获取页面上的数据
*/
public HPO_Model Get_data_from_page()
{
HPO_Model hPO_Model = new HPO_Model();
hPO_Model.Model_no = MODEL_NO;
hPO_Model.Manufacturer = manus_combobox.Text;
hPO_Model.Curve = "curve";
hPO_Model.Step_name = step_name_TextBox.Text;
hPO_Model.Round_speed = "round_speed";
hPO_Model.Drv_a = drv_a_TextBox.Text;
hPO_Model.Rail_pressure = rail_pressure_TextBox.Text;
hPO_Model.Oil_p_standard = oil_p_standard_TextBox.Text;
hPO_Model.Oil_p_deviationr = oil_p_deviationr_TextBox.Text;
hPO_Model.Oil_h_standard = oil_h_standard_TextBox.Text;
hPO_Model.Oil_h_deviationr = oil_h_deviation_TextBox.Text;
hPO_Model.Start_angle = start_angle_TextBox.Text;
hPO_Model.Voltage = voltage_TextBox.Text;
hPO_Model.Oil_j_pressure = oil_j_pressure_TextBox.Text;
hPO_Model.Oil_h_pressure = oil_h_pressure_TextBox.Text;
hPO_Model.Pump_pressure = pump_pressure_TextBox.Text;
hPO_Model.Motor_steering = motor_steering_TextBox.Text;
hPO_Model.Test_time = test_time_TextBox.Text;
return(hPO_Model);
}
/**
* 添加数据
* */
public static string AddData(HPO_Model data, string model_no)
{
//判断是否是已经存在的测试步骤，根据step_name
List <HPO_Model> hPO_Models = new List <HPO_Model>();
hPO_Models = OilP.Dao.HPO_DAO.QueryByModelNo(model_no);
for (int i = 0; i < hPO_Models.Count; i++)
{
if (hPO_Models[i].Step_name.ToLower().ToString().Equals(data.Step_name.ToLower().ToString()))
{
return("测试步骤添加失败：已经存在该测试步骤！");
}
}
bool flag = false;
flag = OilP.Dao.HPO_DAO.AddData(data, model_no);
if (flag)
{
return("测试步骤添加成功");
}
else
{
return("测试步骤添加失败");
}
}
/**
* 通过model_no和step_name查询所单条数据
**/
public static HPO_Model QueryByModelNoAndStepName(string model_no, string step_name)
{
HPO_Model hPO_Model = new HPO_Model();
hPO_Model = OilP.Dao.HPO_DAO.QueryByModelNoAndStepName(model_no, step_name);
return(hPO_Model);
}
/**
* 向页面填充数据
* */
public void fillData(HPO_Model hPO_Model)
{
/*转速*/
round_speed_standard_TextBox.Text = hPO_Model.Round_speed;
/* DRV电流 */
DRV_a_standard_textBox.Text = hPO_Model.Drv_a;
/*共轨压力*/
rail_pressure_standard_TextBox.Text = hPO_Model.Rail_pressure;
/*喷油量*/
oil_p_standard_TextBox.Text = hPO_Model.Oil_p_standard;
/*喷油量偏差*/
oil_p_deviation_TextBox.Text = hPO_Model.Oil_p_deviationr;
/*回油量*/
oil_h_standard_TextBox.Text = hPO_Model.Oil_h_standard;
/*回油量偏差*/
oil_h_deviation_TextBox.Text = hPO_Model.Oil_h_deviationr;
/*提前角*/
start_angle_stdasandard_TextBox.Text = hPO_Model.Start_angle;
/*电压*/
voltage_TextBox.Text = hPO_Model.Voltage;
/*进油压力*/
oil_j_pressure_TextBox.Text = hPO_Model.Oil_j_pressure;
/*回油压力*/
oil_h_pressure_TextBox.Text = hPO_Model.Oil_h_pressure;
/*泵腔压力*/
pump_pressure_TextBox.Text = hPO_Model.Pump_pressure;
/*电机转向*/
/*测量时间*/
test_time_standard_TextBox.Text = hPO_Model.Test_time;
}
/**
* 根据model_no和step_name查找详细数据
* */
public void setData(string model_no, string step_name)
{
HPO_Model hPO_Model = new HPO_Model();
hPO_Model = OilP.Service.HPO_Service.QueryByModelNoAndStepName(model_no, step_name);
//在页面上填入step_name和model_no的数据
step_name_TextBox.Text = step_name;
fillData(hPO_Model);
}
/**
* 通过反射将实体类转化成string字符串
* */
public static string GetEntityToString(HPO_Model t)
{
System.Text.StringBuilder sb = new StringBuilder();
Type type = t.GetType();
System.Reflection.PropertyInfo[] propertyInfos = type.GetProperties();
for (int i = 0; i < propertyInfos.Length; i++)
{
//带变量名的字符串
//sb.Append(propertyInfos[i].Name + ":" + propertyInfos[i].GetValue(t, null) + ",");
//不带变量名的字符串
sb.Append(propertyInfos[i].GetValue(t, null) + ",");
}
return(sb.ToString().TrimEnd(new char[] { ',' }));
}
/**
* 根据model_no和step_name获取数据
* */
public static HPO_Model QueryByModelNoAndStepName(string model_no, string step_name)
{
HPO_Model hPO_Model = new HPO_Model();
List <HPO_Model> hPO_Models = new List <HPO_Model>();
hPO_Models = QueryByModelNo(model_no);
//遍历取出step_name为传入值的数据
foreach (HPO_Model item in hPO_Models)
{
if (step_name.Equals(item.Step_name))
{
return(item);
}
}
return(new HPO_Model());
}
private void step_add_Click(object sender, RoutedEventArgs e)
{
//获取当前页面上的数据
HPO_Model hPO_Model = new HPO_Model();
hPO_Model = Get_data_from_page();
string message = OilP.Service.HPO_Service.AddData(hPO_Model, MODEL_NO);
MessageBoxResult dr = MessageBox.Show(message, "提示", MessageBoxButton.OKCancel, MessageBoxImage.Information);
if (dr == MessageBoxResult.OK)
{
//重新加载ListBox
step_ListBox.Items.Clear();
Init_step_ListBox(MODEL_NO);
}
}
/**
* 根据model_no和step_name更新选中的数据
* */
public static bool UpdateData(HPO_Model hPO_Model)
{
//读取当前model_no的文件内容保存在list中
List <HPO_Model> hPO_Models = new List <HPO_Model>();
hPO_Models = QueryByModelNo(hPO_Model.Model_no);
//将该测试步骤的数据更新进list
for (int i = 0; i < hPO_Models.Count; i++)
{
if (hPO_Model.Step_name.Equals(hPO_Models[i].Step_name))
{
hPO_Models[i] = hPO_Model;
}
}
WriteListToTxt(hPO_Model.Model_no, hPO_Models);
return(true);
}
/**
* 新增测试步骤
**/
public static bool AddData(HPO_Model data, string model_no)
{
bool flag = false;
string filePath = "../Data/CRI/" + model_no + ".txt";
FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.ReadWrite);
StreamWriter wr = new StreamWriter(fs, Encoding.UTF8);
//写入末尾
string data_string = GetEntityToString(data);
wr.BaseStream.Seek(0, SeekOrigin.End);
wr.WriteLine(data_string);
wr.Close();
fs.Close();
return(true);
}
/**
* 根据model_no获取数据集合
**/
public static List <HPO_Model> QueryByModelNo(string model_no)
{
List <HPO_Model> hPO_Models = new List <HPO_Model>();
string filePath = "../Data/CRI/" + model_no + ".txt";
FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.ReadWrite);
StreamReader rd = new StreamReader(fs, Encoding.UTF8);
string readLine;
while ((readLine = rd.ReadLine()) != null)
{
string[] data = readLine.Split(',');
int length = data.Length;
HPO_Model hPO_Model = new HPO_Model();
hPO_Model = StringToHPOModel(length, data);
hPO_Models.Add(hPO_Model);
}
rd.Close();
fs.Close();
return(hPO_Models);
}
private void step_change_Click(object sender, RoutedEventArgs e)
{
//获取选择的listbox的step_name
string step_name = ((ListBoxItem)step_ListBox.SelectedItem).Content.ToString();
HPO_Model hPO_Model = new HPO_Model();
hPO_Model = Get_data_from_page();
//根据model_no和step_name更新数据
bool flag = OilP.Service.HPO_Service.UpdateData(hPO_Model);
if (flag)
{
string message = "测试步骤更新成功";
MessageBoxResult dr = MessageBox.Show(message, "提示", MessageBoxButton.OKCancel, MessageBoxImage.Information);
}
else
{
string message = "测试步骤更新失败";
MessageBoxResult dr = MessageBox.Show(message, "提示", MessageBoxButton.OKCancel, MessageBoxImage.Information);
}
}
