public bool LuuPhieuCanLan1(PhieuCanTDInfo phieuCanTDInfo) { String toDayStr = DateTime.Now.ToString(quyDinh.yyyyMMdd); phieuCanTDInfo.ID = Guid.NewGuid().ToString(); phieuCanTDInfo.NgayGio = DateTime.Now; return(_PhieuCanTDData.LuuCanlan1(phieuCanTDInfo)); }
public bool XoaPhieuCan(PhieuCanTDInfo phieuCanTDInfo) { SqlCommand cmd = new SqlCommand("DELETE FROM PHIEUCANTUDONG " + " where ID = @ID"); cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = phieuCanTDInfo.ID; return(_PhieuCanTDData.ExecuteNoneQuery(cmd) > 0); }
public bool LuuCanlan1(PhieuCanTDInfo phieuCanTDInfo) { SqlCommand cmd = new SqlCommand("INSERT INTO PHIEUCANTUDONG VALUES" + "(@ID, " + "@KLXe, " + "@NgayGio)"); cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = phieuCanTDInfo.ID; cmd.Parameters.Add("KLXe", SqlDbType.Decimal).Value = phieuCanTDInfo.KLXe; cmd.Parameters.Add("NgayGio", SqlDbType.DateTime).Value = phieuCanTDInfo.NgayGio; _PhieuCanTDData.ExecuteNoneQuery(cmd); return(true); }
public bool XoaPhieuCan(PhieuCanTDInfo phieuCanTDInfo) { return(_PhieuCanTDData.XoaPhieuCan(phieuCanTDInfo)); }
private void serialDataReceivedEventArgs(object sender, SerialDataReceivedEventArgs e) { try { TimeSpan aInterval = new System.TimeSpan(0, 0, 0, 0, 300); // Thêm một khoảng thời gian. DateTime newTime = today.Add(aInterval); if (DateTime.Now.CompareTo(newTime) > 0) { today = DateTime.Now; SerialPort sp = (SerialPort)sender; String outPut = sp.ReadExisting(); if (outPut != String.Empty) { outPut = outPut.Trim(); string[] arrayData = outPut.Split(char.Parse(Utilities.KtuNgat)); Decimal klCan = convertDataToWeight(arrayData, blKLCan.Text); // reset kl can bi khi xe ra khoi can if (klCan == 0) { Utilities.klXe = 0; } if (klCan > Utilities.TapChat) { // hien thi khoi luong sau khi tru tap chat this.blKLCan.Invoke(new System.Action(() => this.blKLCan.Text = (klCan - Utilities.TapChat).ToString())); // hien thi bang led //sp.Write("@" + (klCan - Utilities.TapChat).ToString().PadLeft(8) + "F"); } else { this.blKLCan.Invoke(new System.Action(() => this.blKLCan.Text = klCan.ToString())); // hien thi bang led //sp.Write("@" + klCan.ToString().PadLeft(8) + "F"); } // hien thi led theo format A000000T000000G000000, tuong ung voi CanTong, CanBi va KlHang if (Utilities.klXe == 0) { sp.Write("A" + klCan.ToString().PadLeft(6, '0') + "T000000G000000"); } else { sp.Write("A" + klCan.ToString().PadLeft(6, '0') + "T" + Utilities.klXe.ToString().PadLeft(6, '0') + "G" + (klCan - Utilities.klXe).ToString().PadLeft(6, '0')); } if (decimal.Parse(blKLCan.Text) == KLXe) { if (luu == true) { TimeSpan timel = new System.TimeSpan(0, 0, 0, timespan, 0); if ((DateTime.Now - tgluu) >= timel) { if (KLXe > KLMax) { PhieuCanTDInfo phieuCanTDInfo = new PhieuCanTDInfo(); phieuCanTDInfo.KLXe = KLXe; phieuCanTDInfo.NgayGio = DateTime.Now; m_phieucanCtrl.LuuPhieuCanLan1(phieuCanTDInfo); luu = false; } else { } } } } else { tgluu = DateTime.Now; KLXe = decimal.Parse(blKLCan.Text); luu = true; } } } aInterval = new System.TimeSpan(0, 0, 0, 0, 0); } catch (Exception) { Utilities.serialPortCOM.closeConnection(frmMain); } }