You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
638 lines
32 KiB
638 lines
32 KiB
using DyeingComputer.UserClass;
|
|
using DyeingComputer.ViewModel;
|
|
using DyeingComputer.Windows;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Collections.ObjectModel;
|
|
using System.ComponentModel;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Text.RegularExpressions;
|
|
using System.Threading.Tasks;
|
|
using System.Windows;
|
|
using System.Windows.Controls;
|
|
using System.Windows.Data;
|
|
using System.Windows.Documents;
|
|
using System.Windows.Input;
|
|
using System.Windows.Media;
|
|
using System.Windows.Media.Animation;
|
|
using System.Windows.Media.Imaging;
|
|
using System.Windows.Navigation;
|
|
using System.Windows.Shapes;
|
|
using System.Windows.Threading;
|
|
using static DyeingComputer.UserClass.SqliteHelper;
|
|
using static DyeingComputer.Windows.ViewStep;
|
|
|
|
namespace DyeingComputer.View
|
|
{
|
|
/// <summary>
|
|
/// TechnologicalProcessView.xaml 的交互逻辑
|
|
/// </summary>
|
|
public partial class TechnologicalProcessView : UserControl
|
|
{
|
|
public event PropertyChangedEventHandler PropertyChanged;
|
|
protected virtual void OnPropertyChanged(string propertyName)
|
|
{
|
|
if (PropertyChanged != null)
|
|
PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
|
|
}
|
|
public void RaisePropertyChanged(string propertyName)
|
|
{
|
|
if (PropertyChanged != null)
|
|
{
|
|
if (propertyName != null)
|
|
{
|
|
PropertyChanged.Invoke(this, new PropertyChangedEventArgs(propertyName));
|
|
}
|
|
}
|
|
}
|
|
|
|
public TechnologicalProcessView()
|
|
{
|
|
InitializeComponent();
|
|
//Grid.DataContext = new MainWindowViewModel();
|
|
// FocusManager.SetFocusedElement(Grid, Grid);
|
|
// if (workName != null)
|
|
// {
|
|
// TechnologicalProcess_Import();
|
|
// }
|
|
// else
|
|
// {
|
|
TechnologicalProcess_sql();
|
|
// }
|
|
|
|
// ProgramgroupView_edit.IsEnabled = false;
|
|
// ProgramgroupView_del.IsEnabled = false;
|
|
// ProgramgroupView_Insert.IsEnabled = false;
|
|
|
|
tblDatas.Columns.Add("ParameterSet", Type.GetType("System.String"));
|
|
tblDatas.Columns.Add("Value", Type.GetType("System.Double"));
|
|
tblDatas.Columns.Add("ID", Type.GetType("System.String"));
|
|
;
|
|
ParameterSet_d();
|
|
}
|
|
private void ParameterSet_d()
|
|
{
|
|
tblDatas.Clear();
|
|
DataRow newRow;
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.PumpSpeed + " (%)";//主泵速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1020");
|
|
newRow["ID"] = "1020";
|
|
tblDatas.Rows.Add(newRow);
|
|
if (MainWindowViewModel.MT17 == 1)
|
|
{
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.Blower + " (%)";//风机速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1021");
|
|
newRow["ID"] = "1021";
|
|
tblDatas.Rows.Add(newRow);
|
|
}
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.Swing + " (%)";//摆布速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1030");
|
|
newRow["ID"] = "1030";
|
|
tblDatas.Rows.Add(newRow);
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.ClothWheel + " (M/min)";//布轮速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1025");
|
|
newRow["ID"] = "ClothWheel";
|
|
tblDatas.Rows.Add(newRow);
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.ClothWheel + "1 (M/min)";//提不论速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1025");
|
|
newRow["ID"] = "1025";
|
|
tblDatas.Rows.Add(newRow);
|
|
if (MainWindowViewModel.MT18 >= 2)
|
|
{
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.ClothWheel + "2 (M/min)";//提不论速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1026");
|
|
newRow["ID"] = "1026";
|
|
tblDatas.Rows.Add(newRow);
|
|
}
|
|
if (MainWindowViewModel.MT18 >= 3)
|
|
{
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.ClothWheel + "3 (M/min)";//提不论速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1027");
|
|
newRow["ID"] = "1027";
|
|
tblDatas.Rows.Add(newRow);
|
|
}
|
|
if (MainWindowViewModel.MT18 >= 4)
|
|
{
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.ClothWheel + "4 (M/min)";//提不论速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1028");
|
|
newRow["ID"] = "1028";
|
|
tblDatas.Rows.Add(newRow);
|
|
}
|
|
if (MainWindowViewModel.MT18 >= 5)
|
|
{
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.ClothWheel + "5 (M/min)";//提不论速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1029");
|
|
newRow["ID"] = "1029";
|
|
tblDatas.Rows.Add(newRow);
|
|
}
|
|
if (MainWindowViewModel.MT18 >= 6)
|
|
{
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.ClothWheel + "6 (M/min)";//提不论速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1035");
|
|
newRow["ID"] = "1035";
|
|
tblDatas.Rows.Add(newRow);
|
|
}
|
|
if (MainWindowViewModel.MT18 >= 7)
|
|
{
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.ClothWheel + "7 (M/min)";//提不论速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1036");
|
|
newRow["ID"] = "1036";
|
|
tblDatas.Rows.Add(newRow);
|
|
}
|
|
if (MainWindowViewModel.MT18 >= 8)
|
|
{
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.ClothWheel + "8 (M/min)";//提不论速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1037");
|
|
newRow["ID"] = "1037";
|
|
tblDatas.Rows.Add(newRow);
|
|
}
|
|
if (MainWindowViewModel.MT18 >= 9)
|
|
{
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.ClothWheel + "9 (M/min)";//提不论速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1038");
|
|
newRow["ID"] = "1038";
|
|
tblDatas.Rows.Add(newRow);
|
|
}
|
|
if (MainWindowViewModel.MT18 >= 10)
|
|
{
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.ClothWheel + "10 (M/min)";//提不论速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1039");
|
|
newRow["ID"] = "1039";
|
|
tblDatas.Rows.Add(newRow);
|
|
}
|
|
if (MainWindowViewModel.MT18 >= 11)
|
|
{
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.ClothWheel + "11 (M/min)";//提不论速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1040");
|
|
newRow["ID"] = "1040";
|
|
tblDatas.Rows.Add(newRow);
|
|
}
|
|
if (MainWindowViewModel.MT18 >= 12)
|
|
{
|
|
newRow = tblDatas.NewRow();
|
|
newRow["ParameterSet"] = Properties.Resources.ClothWheel + "12 (M/min)";//提不论速度
|
|
newRow["Value"] = MainWindowViewModel.Selet_dtm("1041");
|
|
newRow["ID"] = "1041";
|
|
tblDatas.Rows.Add(newRow);
|
|
}
|
|
|
|
Parameter_set.ItemsSource = tblDatas.DefaultView;
|
|
|
|
}
|
|
private void Parameter_set_BeginningEdit(object sender, DataGridBeginningEditEventArgs e)
|
|
{
|
|
if (MainWindowViewModel._Lock_bool)
|
|
{
|
|
MainWindowViewModel.USERinf(Properties.Resources.LockedState + "\n" +
|
|
Properties.Resources.TCOIR + "\n" + Properties.Resources.PCATRIL);
|
|
return;
|
|
}
|
|
}
|
|
|
|
private void Parameter_set_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
|
|
{
|
|
string VID;
|
|
string newValue = (e.EditingElement as TextBox).Text;//获得输入单元格信息
|
|
|
|
int rownum = Parameter_set.SelectedIndex;//获取鼠标选中行并定义变量
|
|
if (rownum != -1)//判断鼠标定位是否有效
|
|
{
|
|
string Vname = (Parameter_set.Columns[0].GetCellContent(Parameter_set.Items[rownum]) as TextBlock).Text;//定位第0列，
|
|
VID = (Parameter_set.Columns[2].GetCellContent(Parameter_set.Items[rownum]) as TextBlock).Text;//定位第列，
|
|
try
|
|
{
|
|
if (VID == "ClothWheel")
|
|
{
|
|
MainWindowViewModel.Updata_dtm("1025", Convert.ToDouble(newValue));
|
|
MainWindowViewModel.Updata_dtm("1026", Convert.ToDouble(newValue));
|
|
MainWindowViewModel.Updata_dtm("1027", Convert.ToDouble(newValue));
|
|
MainWindowViewModel.Updata_dtm("1028", Convert.ToDouble(newValue));
|
|
MainWindowViewModel.Updata_dtm("1029", Convert.ToDouble(newValue));
|
|
MainWindowViewModel.Updata_dtm("1035", Convert.ToDouble(newValue));
|
|
MainWindowViewModel.Updata_dtm("1036", Convert.ToDouble(newValue));
|
|
MainWindowViewModel.Updata_dtm("1037", Convert.ToDouble(newValue));
|
|
MainWindowViewModel.Updata_dtm("1038", Convert.ToDouble(newValue));
|
|
MainWindowViewModel.Updata_dtm("1039", Convert.ToDouble(newValue));
|
|
MainWindowViewModel.Updata_dtm("1040", Convert.ToDouble(newValue));
|
|
MainWindowViewModel.Updata_dtm("1041", Convert.ToDouble(newValue));
|
|
}
|
|
else
|
|
{
|
|
int i = Convert.ToInt16(newValue);
|
|
if (i > 999) i = 999;
|
|
if ((VID == "1020") || (VID == "1021") || (VID == "1041"))
|
|
{
|
|
if (i > 100) i = 100;
|
|
}
|
|
MainWindowViewModel.Updata_dtm(VID, i);
|
|
}
|
|
APILog.LOGlog(MainWindowViewModel.WorkNumder.ToString(), "UserActions", "Parameter",
|
|
"ID=" + VID + ";Name=" + Vname + ";Value=" + newValue);
|
|
}
|
|
catch { }
|
|
ParameterSet_d();
|
|
}
|
|
}//参数设置
|
|
private void DyeingMachine_Click(object sender, RoutedEventArgs e)//染色剂
|
|
{
|
|
Receip.Visibility = Visibility.Collapsed;
|
|
Parameter_set.Visibility = Visibility.Collapsed;
|
|
}
|
|
private void Receipt_Click(object sender, RoutedEventArgs e)//领料单
|
|
{
|
|
Receip.Visibility = Visibility.Visible;
|
|
Parameter_set.Visibility = Visibility.Collapsed;
|
|
//SQLiteHelpers = new SQLiteHelper(DBAddress); //数据库连接路径
|
|
//SQLiteHelpers.Open(); //打开数据库
|
|
string sql_script = "select * from Dyelot where WorkOrder = '" + MainWindowViewModel.WorkNumder + "'";
|
|
MainWindowViewModel.Dyelot_dat = MainWindow.SQLiteHelpers.ExecuteDataSet(sql_script, null).Tables[0]; //转换显示
|
|
Receip.ItemsSource = MainWindowViewModel.Dyelot_dat.DefaultView;
|
|
// SQLiteHelpers.Close(); //关闭连接
|
|
}
|
|
private void ParameterSet_Click(object sender, RoutedEventArgs e)//参数
|
|
{
|
|
Parameter_set.Visibility = Visibility.Visible;
|
|
Receip.Visibility = Visibility.Collapsed;
|
|
}
|
|
|
|
DataTable tblDatas = new DataTable("Datas");
|
|
public static object workName;
|
|
// public static SQLiteHelper SQLiteHelpers = null; //定义数据库
|
|
// public static readonly string DBAddress = Environment.CurrentDirectory + "\\DataBase\\800COMPUTER.db"; //数据库路径
|
|
//public static DataSet sql; //内存数据缓存
|
|
string Numder = null;
|
|
string ID = null;
|
|
string P1 = "0", P2 = "0", P3 = "0", P4 = "0", P5 = "0";
|
|
|
|
/* private void TechnologicalProcess_Import()
|
|
{
|
|
SQLiteHelpers = new SQLiteHelper(DBAddress); //数据库连接路径
|
|
SQLiteHelpers.Open(); //打开数据库
|
|
int r = 0;
|
|
string sql_script = "select * from WorkorderSteps where ProgramID = '" + workName + "'";
|
|
if (sql != null) sql.Clear(); //清空缓存
|
|
sql = SQLiteHelpers.ExecuteDataSet(sql_script, null); //读取表写入缓存
|
|
MainWindowViewModel.ProgramName = SQLiteHelpers.ExecuteScalar("select ProgramName from WorkOrder where ProgramID = '" + workName + "'", null).ToString();
|
|
if (sql != null) MainWindowViewModel.dt_TP = sql.Tables[0]; //转换显示计划表
|
|
|
|
SQLiteHelpers.Delete("RUN", null, null); //删除run信息
|
|
DataTable data_t = new DataTable();
|
|
data_t = sql.Tables[0].Clone();
|
|
data_t.Columns.Add("DYELOT", typeof(string)); //添加列
|
|
int a = sql.Tables[0].Rows.Count;
|
|
for (int i = 0; i < a; i++)
|
|
{
|
|
data_t.Clear();//清空
|
|
DataRow dt = sql.Tables[0].Rows[i];//行转
|
|
DataRow dr = data_t.NewRow();
|
|
dr.ItemArray = dt.ItemArray;
|
|
dr.BeginEdit(); //添加订单号
|
|
dr["DYELOT"] = MainWindowViewModel.WorkNumder;
|
|
dr.EndEdit();
|
|
data_t.Rows.InsertAt(dr, 0); //行转换
|
|
|
|
r = SQLiteHelpers.InsertData("RUN", SQLiteHelpers.DataTableToDictionary(data_t));//行插入
|
|
}
|
|
SQLiteHelpers.Close(); //关闭连接
|
|
}*/
|
|
private void TechnologicalProcess_sql()
|
|
{
|
|
//SQLiteHelpers = new SQLiteHelper(DBAddress); //数据库连接路径
|
|
//SQLiteHelpers.Open(); //打开数据库
|
|
string sql_script = "select * from RUN";
|
|
MainWindowViewModel.dt_TP = MainWindow.SQLiteHelpers.ExecuteDataSet(sql_script, null).Tables[0]; //读取表写入缓存
|
|
try
|
|
{
|
|
MainWindowViewModel.ProgramName = MainWindow.SQLiteHelpers.ExecuteScalar("select Program from RUN where Step = '1'", null).ToString();
|
|
MainWindowViewModel.WorkNumder = MainWindow.SQLiteHelpers.ExecuteScalar("select WorkOrder from RUN where Step = '1'", null).ToString();
|
|
}
|
|
catch (Exception) { }
|
|
//SQLiteHelpers.Close(); //关闭连接
|
|
// if (sql != null)
|
|
}
|
|
private void UserControl_Loaded(object sender, RoutedEventArgs e)
|
|
{
|
|
// FocusManager.SetFocusedElement(Grid, Grid);
|
|
// Grid.DataContext = new MainWindowViewModel();
|
|
}
|
|
private void ProgramgroupView_edit_Click(object sender, RoutedEventArgs e)//编辑按钮
|
|
{
|
|
if (!MainWindowViewModel._Lock_bool)
|
|
{
|
|
// if (string.IsNullOrEmpty(Numder)) { Numder = null; P1 = "0"; P2 = "0"; P3 = "0"; P4 = "0"; P5 = "0"; }
|
|
if (ID == null) return;//ID = sql.Tables[0].Rows.Count.ToString();
|
|
APILog.LOGlog(MainWindowViewModel.WorkNumder.ToString(), "UserActions", "Edit", "STEP = " + ID);
|
|
ViewStep viewstop = new ViewStep(Numder, MainWindowViewModel.dt_TP.Select("STEP = " + ID).First());
|
|
viewstop.boxNAME.IsEnabled = false;
|
|
//viewstop.no.IsEnabled = false;
|
|
viewstop.data = ID;
|
|
viewstop.AddressUpdated += new ViewStep.AddressUpdateHandler(Address_ButtonClicked);
|
|
viewstop.ShowDialog();
|
|
}
|
|
else
|
|
{
|
|
MainWindowViewModel.USERinf(Properties.Resources.LockedState + "\n" +
|
|
Properties.Resources.TCOIR + "\n" + Properties.Resources.PCATRIL);
|
|
}
|
|
}
|
|
private void Address_ButtonClicked(object sender, AddressUpdateEventArgs e)//编辑返回结果
|
|
{
|
|
int n = Convert.ToInt16(ID);
|
|
ID = null;
|
|
if (e.PNAME != "")
|
|
{
|
|
DataRow dr = MainWindowViewModel.dt_TP.Rows[n - 1];
|
|
dr.BeginEdit();
|
|
dr["StepID"] = e.StepID;
|
|
dr["StepName"] = e.StepNAME;
|
|
dr["ParameterName"] = e.PNAME;
|
|
dr["Parameter1"] = e.Row_DAT.Field<double>("Parameter1");
|
|
dr["Parameter2"] = e.Row_DAT.Field<double>("Parameter2");
|
|
dr["Parameter3"] = e.Row_DAT.Field<double>("Parameter3");
|
|
dr["Parameter4"] = e.Row_DAT.Field<double>("Parameter4");
|
|
dr["Parameter5"] = e.Row_DAT.Field<double>("Parameter5");
|
|
dr["Parameter1_S1"] = e.Row_DAT.Field<double>("Parameter1_S1");
|
|
dr["Parameter2_S1"] = e.Row_DAT.Field<double>("Parameter2_S1");
|
|
dr["Parameter3_S1"] = e.Row_DAT.Field<double>("Parameter3_S1");
|
|
dr["Parameter4_S1"] = e.Row_DAT.Field<double>("Parameter4_S1");
|
|
dr["Parameter5_S1"] = e.Row_DAT.Field<double>("Parameter5_S1");
|
|
dr["Parameter1_S2"] = e.Row_DAT.Field<double>("Parameter1_S2");
|
|
dr["Parameter2_S2"] = e.Row_DAT.Field<double>("Parameter2_S2");
|
|
dr["Parameter3_S2"] = e.Row_DAT.Field<double>("Parameter3_S2");
|
|
dr["Parameter4_S2"] = e.Row_DAT.Field<double>("Parameter4_S2");
|
|
dr["Parameter5_S2"] = e.Row_DAT.Field<double>("Parameter5_S2");
|
|
dr["Parameter1_S3"] = e.Row_DAT.Field<double>("Parameter1_S3");
|
|
dr["Parameter2_S3"] = e.Row_DAT.Field<double>("Parameter2_S3");
|
|
dr["Parameter3_S3"] = e.Row_DAT.Field<double>("Parameter3_S3");
|
|
dr["Parameter4_S3"] = e.Row_DAT.Field<double>("Parameter4_S3");
|
|
dr["Parameter5_S3"] = e.Row_DAT.Field<double>("Parameter5_S3");
|
|
dr["StepName_S1"] = e.Row_DAT.Field<string>("StepName_S1");
|
|
dr["StepName_S2"] = e.Row_DAT.Field<string>("StepName_S2");
|
|
dr["StepName_S3"] = e.Row_DAT.Field<string>("StepName_S3");
|
|
dr["StepID_S1"] = e.Row_DAT.Field<string>("StepID_S1");
|
|
dr["StepID_S2"] = e.Row_DAT.Field<string>("StepID_S2");
|
|
dr["StepID_S3"] = e.Row_DAT.Field<string>("StepID_S3");
|
|
dr.EndEdit();
|
|
|
|
// MainWindowViewModel.dt_TP = sql.Tables[0];
|
|
GridSTEP.SelectedIndex = -1;
|
|
}
|
|
else
|
|
{
|
|
GridSTEP.SelectedIndex = -1;
|
|
MainWindowViewModel.User_Button = true;
|
|
return;
|
|
}
|
|
//SQLiteHelpers = new SQLiteHelper(DBAddress); //数据库连接路径
|
|
//SQLiteHelpers.Open(); //打开数据库
|
|
MainWindow.SQLiteHelpers.Delete("RUN", null, null);
|
|
for (int i = 0; i < MainWindowViewModel.dt_TP.Rows.Count; i++)
|
|
{
|
|
DataRow dt = MainWindowViewModel.dt_TP.Rows[i];//行转换
|
|
dt.BeginEdit(); //添加订单号
|
|
dt["DYELOT"] = MainWindowViewModel.Dyelot;
|
|
dt.EndEdit();
|
|
MainWindow.SQLiteHelpers.InsertData("RUN", MainWindow.SQLiteHelpers.ToDictionary(dt));//行插入
|
|
}
|
|
//SQLiteHelpers.Close(); //关闭连接
|
|
APILog.LOGlog(MainWindowViewModel.WorkNumder.ToString(), "UserActions", "EDIT STEP = " + n,
|
|
"StepID=" + e.StepID + ";StepName=" + e.StepNAME + ";P=" + string.Join(",", e.Row_DAT.ItemArray));
|
|
MainWindowViewModel.User_Button = true;
|
|
}
|
|
public static void Dat()//行号刷新
|
|
{
|
|
int a = MainWindowViewModel.dt_TP.Rows.Count;
|
|
for (int i = 0; i < a; i++)
|
|
{
|
|
DataRow dr = MainWindowViewModel.dt_TP.Rows[i];
|
|
dr.BeginEdit();
|
|
dr["Step"] = i + 1;
|
|
dr.EndEdit();
|
|
}
|
|
}
|
|
private void ProgramgroupView_del_Click(object sender, RoutedEventArgs e)//删除
|
|
{
|
|
if (!MainWindowViewModel._Lock_bool)
|
|
{
|
|
int d = 0;
|
|
int a = MainWindowViewModel.dt_TP.Rows.Count;
|
|
|
|
if (ID != null) { d = Convert.ToInt16(ID); } else { return; }
|
|
MainWindowViewModel.dt_TP.Rows.RemoveAt(d - 1);
|
|
Dat();
|
|
GridSTEP.SelectedIndex = -1;
|
|
|
|
// SQLiteHelpers = new SQLiteHelper(DBAddress); //数据库连接路径
|
|
// SQLiteHelpers.Open(); //打开数据库
|
|
MainWindow.SQLiteHelpers.Delete("RUN", null, null);
|
|
DataTable data_t = MainWindowViewModel.dt_TP.Clone();
|
|
a = MainWindowViewModel.dt_TP.Rows.Count;
|
|
for (int i = 0; i < a; i++)
|
|
{
|
|
data_t.Clear();//清空
|
|
DataRow dt = MainWindowViewModel.dt_TP.Rows[i];//行转换
|
|
DataRow drT = data_t.NewRow();
|
|
drT.ItemArray = dt.ItemArray;
|
|
data_t.Rows.InsertAt(drT, 0);
|
|
drT.BeginEdit(); //添加订单号
|
|
drT["DYELOT"] = MainWindowViewModel.WorkNumder;
|
|
drT.EndEdit();
|
|
MainWindow.SQLiteHelpers.InsertData("RUN", MainWindow.SQLiteHelpers.DataTableToDictionary(data_t));//行插入
|
|
}
|
|
//SQLiteHelpers.Close(); //关闭连接
|
|
APILog.LOGlog(MainWindowViewModel.WorkNumder.ToString(), "UserActions", "Delete", "STEP = " + ID);
|
|
MainWindowViewModel.User_Button = true;
|
|
}
|
|
else
|
|
{
|
|
MainWindowViewModel.USERinf(Properties.Resources.LockedState + "\n" +
|
|
Properties.Resources.TCOIR + "\n" + Properties.Resources.PCATRIL);
|
|
}
|
|
}
|
|
|
|
private void ProgramgroupView_Insert_Click(object sender, RoutedEventArgs e)//插入
|
|
{
|
|
if (!MainWindowViewModel._Lock_bool)
|
|
{
|
|
int d = 0;
|
|
//SQLiteHelpers = new SQLiteHelper(DBAddress); //数据库连接路径
|
|
//SQLiteHelpers.Open(); //打开数据库
|
|
string ProgramID = MainWindow.SQLiteHelpers.ExecuteScalar("select ProgramID from RUN where Step = '1'", null).ToString();
|
|
string ProgramNAME = MainWindow.SQLiteHelpers.ExecuteScalar("select Program from RUN where Step = '1'", null).ToString();
|
|
// SQLiteHelpers.Close();
|
|
|
|
if (ID != null) { d = Convert.ToInt16(ID); } else { return; }
|
|
DataRow dr = MainWindowViewModel.dt_TP.NewRow();//添加表数据
|
|
//
|
|
dr["WorkOrder"] = MainWindowViewModel.WorkNumder;
|
|
dr["ProgramID"] = ProgramID;
|
|
dr["Program"] = ProgramNAME;
|
|
dr["Parameter1"] = 0;
|
|
dr["Parameter2"] = 0;
|
|
dr["Parameter3"] = 0;
|
|
dr["Parameter4"] = 0;
|
|
dr["Parameter5"] = 0;
|
|
dr["Parameter6"] = 0;
|
|
dr["Parameter7"] = 0;
|
|
dr["Parameter8"] = 0;
|
|
dr["Parameter9"] = 0;
|
|
dr["Parameter10"] = 0;
|
|
dr["Parameter1_S1"] = 0;
|
|
dr["Parameter2_S1"] = 0;
|
|
dr["Parameter3_S1"] = 0;
|
|
dr["Parameter4_S1"] = 0;
|
|
dr["Parameter5_S1"] = 0;
|
|
dr["Parameter1_S2"] = 0;
|
|
dr["Parameter2_S2"] = 0;
|
|
dr["Parameter3_S2"] = 0;
|
|
dr["Parameter4_S2"] = 0;
|
|
dr["Parameter5_S2"] = 0;
|
|
dr["Parameter1_S3"] = 0;
|
|
dr["Parameter2_S3"] = 0;
|
|
dr["Parameter3_S3"] = 0;
|
|
dr["Parameter4_S3"] = 0;
|
|
dr["Parameter5_S3"] = 0;
|
|
dr["StepName_S1"] = " ";
|
|
dr["StepName_S2"] = " ";
|
|
dr["StepName_S3"] = " ";
|
|
dr["StepID_S1"] = "000";
|
|
dr["StepID_S2"] = "000";
|
|
dr["StepID_S3"] = "000";
|
|
MainWindowViewModel.dt_TP.Rows.InsertAt(dr, d - 1);
|
|
// ID = null;
|
|
Dat();
|
|
APILog.LOGlog(MainWindowViewModel.WorkNumder.ToString(), "UserActions", "Insert", "STEP = " + ID);
|
|
if (ID == null) return;// ID = MainWindowViewModel.dt_TP.Rows.Count.ToString();
|
|
ViewStep viewstop = new ViewStep(null, MainWindowViewModel.dt_TP.Select("STEP = " + ID).First());
|
|
viewstop.boxNAME.IsEnabled = false;
|
|
//viewstop.no.IsEnabled = false;
|
|
viewstop.data = ID;
|
|
viewstop.AddressUpdated += new ViewStep.AddressUpdateHandler(Address_InsertClicked);
|
|
viewstop.ShowDialog();
|
|
}
|
|
else
|
|
{
|
|
MainWindowViewModel.USERinf(Properties.Resources.LockedState + "\n" +
|
|
Properties.Resources.TCOIR + "\n" + Properties.Resources.PCATRIL);
|
|
}
|
|
}
|
|
private void Address_InsertClicked(object sender, AddressUpdateEventArgs e)//插入返回结果
|
|
{
|
|
int n = Convert.ToInt16(ID);
|
|
ID = null;
|
|
if (e.PNAME != "")
|
|
{
|
|
DataRow dr = MainWindowViewModel.dt_TP.Rows[n - 1];
|
|
dr.BeginEdit();
|
|
dr["StepID"] = e.StepID;
|
|
dr["StepName"] = e.StepNAME;
|
|
dr["ParameterName"] = e.PNAME;
|
|
dr["Parameter1"] = e.Row_DAT.Field<double>("Parameter1");
|
|
dr["Parameter2"] = e.Row_DAT.Field<double>("Parameter1");
|
|
dr["Parameter3"] = e.Row_DAT.Field<double>("Parameter1");
|
|
dr["Parameter4"] = e.Row_DAT.Field<double>("Parameter1");
|
|
dr["Parameter5"] = e.Row_DAT.Field<double>("Parameter1");
|
|
dr["Parameter1_S1"] = e.Row_DAT.Field<double>("Parameter1_S1");
|
|
dr["Parameter2_S1"] = e.Row_DAT.Field<double>("Parameter2_S1");
|
|
dr["Parameter3_S1"] = e.Row_DAT.Field<double>("Parameter3_S1");
|
|
dr["Parameter4_S1"] = e.Row_DAT.Field<double>("Parameter4_S1");
|
|
dr["Parameter5_S1"] = e.Row_DAT.Field<double>("Parameter5_S1");
|
|
dr["Parameter1_S2"] = e.Row_DAT.Field<double>("Parameter1_S2");
|
|
dr["Parameter2_S2"] = e.Row_DAT.Field<double>("Parameter2_S2");
|
|
dr["Parameter3_S2"] = e.Row_DAT.Field<double>("Parameter3_S2");
|
|
dr["Parameter4_S2"] = e.Row_DAT.Field<double>("Parameter4_S2");
|
|
dr["Parameter5_S2"] = e.Row_DAT.Field<double>("Parameter5_S2");
|
|
dr["Parameter1_S3"] = e.Row_DAT.Field<double>("Parameter1_S3");
|
|
dr["Parameter2_S3"] = e.Row_DAT.Field<double>("Parameter2_S3");
|
|
dr["Parameter3_S3"] = e.Row_DAT.Field<double>("Parameter3_S3");
|
|
dr["Parameter4_S3"] = e.Row_DAT.Field<double>("Parameter4_S3");
|
|
dr["Parameter5_S3"] = e.Row_DAT.Field<double>("Parameter5_S3");
|
|
dr["StepName_S1"] = e.Row_DAT.Field<string>("StepName_S1");
|
|
dr["StepName_S2"] = e.Row_DAT.Field<string>("StepName_S2");
|
|
dr["StepName_S3"] = e.Row_DAT.Field<string>("StepName_S3");
|
|
dr["StepID_S1"] = e.Row_DAT.Field<string>("StepID_S1");
|
|
dr["StepID_S2"] = e.Row_DAT.Field<string>("StepID_S2");
|
|
dr["StepID_S3"] = e.Row_DAT.Field<string>("StepID_S3");
|
|
dr.EndEdit();
|
|
GridSTEP.SelectedIndex = -1;
|
|
}
|
|
else
|
|
{
|
|
MainWindowViewModel.dt_TP.Rows.RemoveAt(n - 1);
|
|
Dat();
|
|
GridSTEP.SelectedIndex = -1;
|
|
MainWindowViewModel.User_Button = true;
|
|
return;
|
|
}
|
|
//SQLiteHelpers = new SQLiteHelper(DBAddress); //数据库连接路径
|
|
//SQLiteHelpers.Open(); //打开数据库
|
|
MainWindow.SQLiteHelpers.Delete("RUN", null, null);
|
|
for (int i = 0; i < MainWindowViewModel.dt_TP.Rows.Count; i++)
|
|
{
|
|
DataRow dt = MainWindowViewModel.dt_TP.Rows[i];//行转换
|
|
dt.BeginEdit(); //添加订单号
|
|
dt["DYELOT"] = MainWindowViewModel.Dyelot;
|
|
dt.EndEdit();
|
|
MainWindow.SQLiteHelpers.InsertData("RUN", MainWindow.SQLiteHelpers.ToDictionary(dt));//行插入
|
|
}
|
|
//SQLiteHelpers.Close(); //关闭连接
|
|
APILog.LOGlog(MainWindowViewModel.WorkNumder.ToString(), "UserActions", "Insert STEP = " + n,
|
|
"StepID=" + e.StepID + ";StepName=" + e.StepNAME + ";P=" + string.Join(",", e.Row_DAT.ItemArray));
|
|
MainWindowViewModel.User_Button = true;
|
|
}
|
|
private void ProgramgroupView_Jump_Click(object sender, RoutedEventArgs e)
|
|
{
|
|
if (!MainWindowViewModel._Lock_bool)
|
|
{
|
|
DataRow dr = MainWindowViewModel.dt_TP.Select("Step='" + ID + "'").First();
|
|
dr.BeginEdit();
|
|
dr["RUN"] = 2;
|
|
dr.EndEdit();
|
|
MainWindowViewModel.User_Button = true;
|
|
MainWindowViewModel.RUN_STEPID = Convert.ToInt16(ID);//插入步骤号
|
|
MainWindowViewModel.STEP_START(Numder, Convert.ToDouble(P1), Convert.ToDouble(P2), Convert.ToDouble(P3),
|
|
Convert.ToDouble(P4), Convert.ToDouble(P5));
|
|
APILog.LOGlog(MainWindowViewModel.WorkNumder.ToString(), "UserActions", "Jump", "STEP = " + ID +
|
|
";StepID=" + Numder + ";P1=" + P1 + ";P2=" + P2 + ";P3=" + P3 + ";P4=" + P4 + ";P5=" + P5);
|
|
}
|
|
else
|
|
{
|
|
MainWindowViewModel.USERinf(Properties.Resources.LockedState + "\n" +
|
|
Properties.Resources.TCOIR + "\n" + Properties.Resources.PCATRIL);
|
|
}
|
|
}//跳步
|
|
private void Grid_SelectionChanged(object sender, SelectionChangedEventArgs e)
|
|
{
|
|
// if (MainWindowViewModel.WORK_RUN == 2) GridSTEP.SelectedIndex = MainWindowViewModel.RUN_STEPID - 1;//设定图表显示
|
|
int rownum = GridSTEP.SelectedIndex;//获取鼠标选中行并定义变量
|
|
if (rownum != -1)//判断鼠标定位是否有效
|
|
{
|
|
ID = (GridSTEP.Columns[2].GetCellContent(GridSTEP.Items[rownum]) as TextBlock).Text;//定位第0列，
|
|
Numder = (GridSTEP.Columns[3].GetCellContent(GridSTEP.Items[rownum]) as TextBlock).Text;//定位第1列，
|
|
P1 = (GridSTEP.Columns[6].GetCellContent(GridSTEP.Items[rownum]) as TextBlock).Text;//定位第6列，
|
|
P2 = (GridSTEP.Columns[7].GetCellContent(GridSTEP.Items[rownum]) as TextBlock).Text;//定位第7列，
|
|
P3 = (GridSTEP.Columns[8].GetCellContent(GridSTEP.Items[rownum]) as TextBlock).Text;//定位第8列，
|
|
P4 = (GridSTEP.Columns[9].GetCellContent(GridSTEP.Items[rownum]) as TextBlock).Text;//定位第9列，
|
|
P5 = (GridSTEP.Columns[10].GetCellContent(GridSTEP.Items[rownum]) as TextBlock).Text;//定位第10列，
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
|