/// <summary>
/// 按条码查询工件信息
/// </summary>
/// <param name="workId"></param>
/// <param name="MoList"></param>
/// <returns></returns>
public bool QueryData(Int32 tab, ref List <ModalWeightInfoTable> MoList)
{
bool bRet = true;
try
{
DataSet dt;
SQLiteParameter[] parameters =
{
new SQLiteParameter("@Tab", DbType.Int32)
};
parameters[0].Value = tab;
dt = SQLiteHelper.Query(SQL_SELECT_ONE, parameters);
if (dt != null)
{
if (MoList == null)
{
MoList = new List <ModalWeightInfoTable>();
}
foreach (DataRow dr in dt.Tables[0].Rows)
{
ModalWeightInfoTable tmp = new ModalWeightInfoTable();
tmp.Row2Model(dr);
MoList.Add(tmp);
}
}
}
catch (Exception ex)
{
Util.LogManager.Logger.Error("查询记录是出现错误，错误为{0}", ex.ToString());
bRet = false;
}
return(bRet);
}
public bool QueryData(ref List <ModalWeightInfoTable> MoList)
{
bool bRet = true;
try
{
DataSet dt = SQLiteHelper.Query(SQL_SELECT_ALL);
if (dt != null)
{
if (MoList == null)
{
MoList = new List <ModalWeightInfoTable>();
}
foreach (DataRow dr in dt.Tables[0].Rows)
{
ModalWeightInfoTable tmp = new ModalWeightInfoTable();
tmp.Row2Model(dr);
MoList.Add(tmp);
}
}
}
catch (Exception ex)
{
Util.LogManager.Logger.Error("查询记录是出现错误，错误为{0}", ex.ToString());
bRet = false;
}
return(bRet);
}
/// <summary>
/// 按时间查询工件信息
/// </summary>
/// <param name="workId"></param>
/// <param name="MoList"></param>
/// <returns></returns>
public bool QueryData(string time1, string time2, ref List <ModalWeightInfoTable> MoList)
{
bool bRet = true;
try
{
DataSet dt;
string sql = string.Format("{0} where Time BETWEEN '{1}' AND '{2}'", SQL_SELECT, time1, time2);
dt = SQLiteHelper.Query(sql);
if (dt != null)
{
if (MoList == null)
{
MoList = new List <ModalWeightInfoTable>();
}
foreach (DataRow dr in dt.Tables[0].Rows)
{
ModalWeightInfoTable tmp = new ModalWeightInfoTable();
tmp.Row2Model(dr);
MoList.Add(tmp);
}
}
}
catch (Exception ex)
{
Util.LogManager.Logger.Error("查询记录是出现错误，错误为{0}", ex.ToString());
bRet = false;
}
return(bRet);
}
/// <summary>
/// 克隆函数
/// </summary>
public object Clone()
{
ModalWeightInfoTable ds = new ModalWeightInfoTable();
ds.Number = Number;
ds.BodyWeight = BodyWeight;
ds.Time = Time;
ds.Tab = Tab;
return(ds);
}
/// <summary>
/// 删除一个
/// </summary>
/// <returns></returns>
public int DeleteData(ModalWeightInfoTable Mo)
{
int iRet = 0;
try
{
SQLiteParameter[] parameters = { new SQLiteParameter("@Number", DbType.Int32),
new SQLiteParameter("@Time", DbType.String) };
parameters[0].Value = Mo.Number;
parameters[1].Value = Mo.Time;
iRet = SQLiteHelper.ExecuteSql(SQL_DELETE_ONE, parameters);
}
catch (Exception ex)
{
Util.LogManager.Logger.Error("删除数据出现错误，错误为{0}", ex.ToString());
iRet = 0;
}
return(iRet);
}
/// <summary>
/// 按条件查询条码信息
/// </summary>
/// <param name="condition"></param>
/// <param name="MoList"></param>
/// <returns></returns>
public int AddData(ModalWeightInfoTable Mo)
{
int iRet = 0;
try
{
SQLiteParameter[] parameters = { new SQLiteParameter("@Number", DbType.Int32),
new SQLiteParameter("@BodyWeight", DbType.String),
new SQLiteParameter("@Time", DbType.String),
new SQLiteParameter("@Tab", DbType.Int32) };
parameters[0].Value = Mo.Number;
parameters[1].Value = Mo.BodyWeight;
parameters[2].Value = Mo.Time;
parameters[3].Value = Mo.Tab;
iRet = SQLiteHelper.ExecuteSql(SQL_INSERT, parameters);
}
catch (Exception ex)
{
Util.LogManager.Logger.Error("插入数据库出现错误，错误为{0}", ex.ToString());
iRet = 0;
}
return(iRet);
}
private void Receive_Weight(Object sender, tcpCommEventArgs e)
{
this.Dispatcher.Invoke(() =>
{
ModalWeightInfoTable weightinfo = new ModalWeightInfoTable();
weightDtaGrid.ItemsSource = null;
CacheRece = e.ReceiveMessage;
weightinfo.Number = ++number;
weightinfo.BodyWeight = CacheRece;
weightinfo.Time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
weightinfo.Tab = 0;
//WeightList.Add(weightinfo);
//weightDtaGrid.ItemsSource = null;
//weightDtaGrid.ItemsSource = WeightList;
dal.AddData(weightinfo);
List <ModalWeightInfoTable> templist = new List <ModalWeightInfoTable>();
dal.QueryData(ref templist);
weightDtaGrid.ItemsSource = null;
weightDtaGrid.ItemsSource = templist;
WeightList.Clear();
WeightList = templist;
});
}
private void ElapseSpurtSend(object Sender, ElapsedEventArgs e)
{
if (timerBool)
{
lock (timerLock)
{
if (timerBool)
{
timerBool = false;
int CurrentCount = 0; //喷码枪的初始值是1
string recStr = tcputility.SendAndReceive(String.Format("GET_COUNTER_INFO 1\n"));
if (recStr.Contains("ACK-GET_COUNTER_INFO"))
{
CurrentCount = Convert.ToInt32(recStr.Split(',')[2]);
}
if (CurrentCount > LastCount) //说明喷码了，或者到了时间间隔跳过了（时间大概20多秒），
{
List <ModalWeightInfoTable> UnSendList = new List <ModalWeightInfoTable>();
dal.QueryData(tab: 0, ref UnSendList);
if (UnSendList == null || UnSendList.Count == 0)
{
return;
}
ModalWeightInfoTable moWeiht = UnSendList[0];
string str = Regex.Match(moWeiht.BodyWeight, @"([0-9].[0-9]{1,})").Value.Replace(".", "");
recStr = tcputility.SendAndReceive(String.Format("D{0}{1}\n", str.PadRight(4, '0'), new Random().Next(0, 9)));
if (recStr.Contains("ACK-Auto Data Received")) //如果发送成功，记录下来
{
LastCount = CurrentCount;
this.Dispatcher.Invoke(() =>
{
dal.UpData(moWeiht.Number, 1);
List <ModalWeightInfoTable> templist = new List <ModalWeightInfoTable>();
dal.QueryData(ref templist);
weightDtaGrid.ItemsSource = null;
weightDtaGrid.ItemsSource = templist;
WeightList.Clear();
WeightList = templist;
SpurtList.Add(new ModalSpurtCodeInfo
{
Counter = CurrentCount + 1,
SpurtCode = str
});
SpurtDtaGrid.ItemsSource = null;
SpurtDtaGrid.ItemsSource = SpurtList;
});
}
else
{
AutoDeleteMessageBox Auto = new AutoDeleteMessageBox(); // 自动关闭窗口
System.Windows.Forms.MessageBox.Show("发送喷码值失败！", "MessageBox");
return;
}
}
timerBool = true;
}
}
}
}