public int SaveMonthQuarterTicket(SoatVeTransactionModel item) { try { using (SqlCommand cmd = TKUtils.InitCommand("Add_SoatVeThangQui")) { // Add param cmd.Parameters.Add("@Result", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@sGioSoat", SqlDbType.Int).Value = CheckTime; cmd.Parameters.Add("@sNgaySoat", SqlDbType.DateTime).Value = new DateTime(int.Parse(item.CheckDate.Split('/')[2].Split(' ')[0]), int.Parse(item.CheckDate.Split('/')[0]), int.Parse(item.CheckDate.Split('/')[1])); cmd.Parameters.Add("@sMSLane", SqlDbType.VarChar, 3).Value = LaneID; cmd.Parameters.Add("@sLogin", SqlDbType.VarChar, 20).Value = LoginID; cmd.Parameters.Add("@sCa", SqlDbType.VarChar, 3).Value = ShiftID; cmd.Parameters.Add("@sMSLoaiXe", SqlDbType.VarChar, 2).Value = ""; //biến checker hiện giờ dùng chứa datestring cmd.Parameters.Add("@sChecker", SqlDbType.VarChar, 20).Value = item.CheckDate; cmd.Parameters.Add("@sSoXe", SqlDbType.VarChar, 20).Value = item.RecogPlateNumber; cmd.Parameters.Add("@sF0", SqlDbType.VarChar, 1).Value = F0; cmd.Parameters.Add("@sF1", SqlDbType.VarChar, 1).Value = F1; cmd.Parameters.Add("@sF2", SqlDbType.VarChar, 1).Value = F2; cmd.Parameters.Add("@sImageId", SqlDbType.NVarChar, 20).Value = item.ImageID; cmd.Parameters.Add("@sTID", SqlDbType.VarChar, 20).Value = TicketID; if (item.TicketID.Substring(0, 1) == "B") { cmd.Parameters.Add("@sMSLoaiVe", SqlDbType.VarChar, 2).Value = "2" + item.VehicleClassID; } else if (item.TicketID.Substring(0, 1) == "C") { cmd.Parameters.Add("@sMSLoaiVe", SqlDbType.VarChar, 2).Value = "3" + item.VehicleClassID; } cmd.Parameters.Add("@sGiaVe", SqlDbType.Int).Value = item.ChargeAmount; //if (this.SFTPUsername.Equals("station0075")) //{ // cmd.Parameters.Add("@sMSTram", SqlDbType.VarChar, 1).Value = StationID; //} //Tam add cmd.Parameters.Add("@sEtagID", SqlDbType.VarChar, 24).Value = ""; // Thuc thi stored ExecuteNonQuery(cmd); // Kiem tra ket qua int retValue = int.Parse(cmd.Parameters["@Result"].Value.ToString()); return((retValue > 0) ? 1 : 0); } } catch (Exception ex) { TKUtils.WriteLogFile(GetType() + "." + MethodBase.GetCurrentMethod().Name, ex.Message); //STORED_MONTH_QUARTER_TICKET, ex.Message); return(0); } }
private void btnReadFile_Click(object sender, EventArgs e) { try { this.DBView.Rows.Clear(); //lstTran.Clear(); if (string.IsNullOrEmpty(this.txtpathfile.Text)) { MessageBox.Show("Vui lòng chọn file trước !"); } else if (!File.Exists(this.txtpathfile.Text)) { MessageBox.Show("File không tồn tại !"); } else { using (FileStream fs = File.Open(this.txtpathfile.Text, FileMode.Open)) { using (StreamReader sr = new StreamReader(fs)) { List <SoatVeTransactionModel> lstTemp = new List <SoatVeTransactionModel>(); string dataLine; while ((dataLine = sr.ReadLine()) != null) { if (dataLine.Contains("---------------") || string.IsNullOrEmpty(dataLine)) { } else { var stringArr = dataLine.Split('-'); var TransactionType = stringArr[0].Split('[')[1]; var stringArr1 = stringArr[1].Split('|'); SoatVeTransactionModel item = SoatVeTransactionModel.CreateTransactionbyString2(TransactionType, stringArr1); if (item != null) { lstTemp.Add(item); } } } this.lstTran = lstTemp; } fs.Close(); } MessageBox.Show("Read file succees"); } } catch (Exception ex) { TKUtils.WriteLogFile(this.GetType() + "." + System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message); //STORED_ONCE_TICKET, ex.Message); } }
public int SaveForceOpen(SoatVeTransactionModel item) { try { using (SqlCommand cmd = TKUtils.InitCommand("Add_ForceOpen")) { // Add param cmd.Parameters.Add("@Result", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@sTID", SqlDbType.VarChar, 20).Value = TicketID; cmd.Parameters.Add("@sMSLane", SqlDbType.VarChar, 3).Value = LaneID; cmd.Parameters.Add("@sLogin", SqlDbType.VarChar, 20).Value = LoginID; cmd.Parameters.Add("@sCa", SqlDbType.VarChar, 3).Value = ShiftID; cmd.Parameters.Add("@sGioMo", SqlDbType.Int).Value = CheckTime; cmd.Parameters.Add("@sNgaySoat", SqlDbType.DateTime).Value = new DateTime(int.Parse(item.CheckDate.Split('/')[2].Split(' ')[0]), int.Parse(item.CheckDate.Split('/')[0]), int.Parse(item.CheckDate.Split('/')[1])); cmd.Parameters.Add("@sGioDong", SqlDbType.Int).Value = CheckTime; cmd.Parameters.Add("@sNgayDong", SqlDbType.DateTime).Value = new DateTime(int.Parse(item.CheckDate.Split('/')[2].Split(' ')[0]), int.Parse(item.CheckDate.Split('/')[0]), int.Parse(item.CheckDate.Split('/')[1])); //cmd.Parameters.Add("@sTramID", SqlDbType.Int).Value = StationID; //cmd.Parameters.Add("@sReason", SqlDbType.Int).Value = Reason; //cmd.Parameters.Add("@sTicketType", SqlDbType.Int).Value = Reason; // (int)Category;???? //Biến checker chỗ này hiện giờ dùng chứa datestring cmd.Parameters.Add("@sChecker", SqlDbType.VarChar, 20).Value = item.Checker; cmd.Parameters.Add("@sSoXe", SqlDbType.VarChar, 20).Value = item.RecogPlateNumber; cmd.Parameters.Add("@sF0", SqlDbType.VarChar, 1).Value = F0; cmd.Parameters.Add("@sF1", SqlDbType.VarChar, 1).Value = F1; cmd.Parameters.Add("@sF2", SqlDbType.VarChar, 1).Value = F2; cmd.Parameters.Add("@sImageId", SqlDbType.NVarChar, 20).Value = item.ImageID; //if (this.SFTPUsername.Equals("station0075")) //{ // cmd.Parameters.Add("@sMSTram", SqlDbType.VarChar, 1).Value = StationID; //} //Tam add cmd.Parameters.Add("@sEtagID", SqlDbType.VarChar, 24).Value = ""; // Thuc thi stored ExecuteNonQuery(cmd); // Kiem tra ket qua int retValue = int.Parse(cmd.Parameters["@Result"].Value.ToString()); return((retValue > 0) ? 1 : 0); } } catch (Exception ex) { TKUtils.WriteLogFile(GetType() + "." + MethodBase.GetCurrentMethod().Name, ex.Message); //STORED_FORCE_TICKET+Category.ToString(), ex.Message); } return(0); }
public int ExecuteNonQuery(SqlCommand pCommand) { int numRows = 0; SqlConnection connection = null; try { using (connection = new SqlConnection(_connectionString)) { pCommand.Connection = connection; pCommand.Connection.Open(); numRows = pCommand.ExecuteNonQuery(); } } catch (Exception ex) { TKUtils.WriteLogFile(GetType() + "." + MethodBase.GetCurrentMethod().Name, ex.Message); //STORED_ONCE_TICKET, ex.Message); } return(numRows); }
public int CommitRFID(SoatVeTransactionModel item) { int res = 0; SqlCommand cmd = null; try { using (cmd = TKUtils.InitCommand("TRP_spCheckObuAccount_RFID")) { cmd.Parameters.Add("@Activity", SqlDbType.NVarChar, 50).Value = "Save"; cmd.Parameters.Add("@ReturnMsg", SqlDbType.NVarChar, 500).Direction = ParameterDirection.Output; cmd.Parameters.Add("@ReturnValue", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@ObuID", SqlDbType.NVarChar).Value = item.ObuID; var dt = new DateTime(int.Parse(item.ImageID.Substring(0, 4)), int.Parse(item.ImageID.Substring(4, 2)), int.Parse(item.ImageID.Substring(6, 2)), int.Parse(item.ImageID.Substring(8, 2)), int.Parse(item.ImageID.Substring(10, 2)), int.Parse(item.ImageID.Substring(12, 2)), int.Parse(item.ImageID.Substring(14, 3))); cmd.Parameters.Add("@CheckDate", SqlDbType.DateTime).Value = dt; cmd.Parameters.Add("@CheckTime", SqlDbType.Int).Value = item.CheckTime; cmd.Parameters.Add("@BeginBalance", SqlDbType.Int).Value = item.BeginBalance; cmd.Parameters.Add("@ChargeAmount", SqlDbType.Int).Value = item.ChargeAmount; // cmd.Parameters.Add("@Balance", SqlDbType.Int).Value = 0; cmd.Parameters.Add("@VehicleClassID", SqlDbType.Int).Value = item.VehicleClassID; //vehicle type if (string.IsNullOrEmpty(item.LoginID)) { cmd.Parameters.Add("@LoginID", SqlDbType.NVarChar).Value = "0000"; //nhan vien mac dinh, chua login } else { cmd.Parameters.Add("@LoginID", SqlDbType.NVarChar).Value = item.LoginID; } cmd.Parameters.Add("@LaneID", SqlDbType.NVarChar).Value = item.LaneID; cmd.Parameters.Add("@ShiftID", SqlDbType.NVarChar).Value = item.ShiftID; cmd.Parameters.Add("@StationID", SqlDbType.NVarChar).Value = item.StationID; cmd.Parameters.Add("@RegisPlateNumber", SqlDbType.NVarChar).Value = item.RegisPlateNumber; cmd.Parameters.Add("@PlateType", SqlDbType.SmallInt).Value = item.PlateType; cmd.Parameters.Add("@RecogPlateNumber", SqlDbType.NVarChar).Value = item.RecogPlateNumber; cmd.Parameters.Add("@IsIntelligentVeriField", SqlDbType.Bit).Value = false; cmd.Parameters.Add("@IntelVerifyResult", SqlDbType.SmallInt).Value = item.IntelVerifyResult; cmd.Parameters.Add("@ImageID", SqlDbType.NVarChar).Value = item.ImageID; cmd.Parameters.Add("@ImageStatus", SqlDbType.Int).Value = ImageStatus; //VDH 30july cmd.Parameters.Add("@IsOnlineCheck", SqlDbType.Int).Value = item.IsOnlineCheck; //VDH 30july cmd.Parameters.Add("@PeriodTicket", SqlDbType.Int).Value = item.PeriodTicket; cmd.Parameters.Add("@Checker", SqlDbType.VarChar, 20).Value = item.Checker; cmd.Parameters.Add("@F0", SqlDbType.VarChar, 1).Value = item.F0; cmd.Parameters.Add("@F1", SqlDbType.VarChar, 1).Value = item.F1; #region [20160916] HUYTO cmd.Parameters.Add("@F2", SqlDbType.VarChar, 1).Value = item.F2; #endregion cmd.Parameters.Add("@TransactionStatus", SqlDbType.Int, 1).Value = TransactionStatus; cmd.Parameters.Add("@TicketID", SqlDbType.NVarChar, 20).Value = item.TicketID; cmd.Parameters.Add("@CheckInDate", SqlDbType.DateTime).Value = new DateTime(int.Parse(item.CheckInDate.Split('/')[2].Split(' ')[0]), int.Parse(item.CheckInDate.Split('/')[0]), int.Parse(item.CheckInDate.Split('/')[1]), int.Parse(item.CheckInDate.Split(' ')[1].Split(':')[0]), int.Parse(item.CheckInDate.Split(' ')[1].Split(':')[1]), int.Parse(item.CheckInDate.Split(' ')[1].Split(':')[2])); cmd.Parameters.Add("@CommitDate", SqlDbType.DateTime).Value = new DateTime(int.Parse(item.CommitDate.Split('/')[2].Split(' ')[0]), int.Parse(item.CommitDate.Split('/')[0]), int.Parse(item.CommitDate.Split('/')[1]), int.Parse(item.CommitDate.Split(' ')[1].Split(':')[0]), int.Parse(item.CommitDate.Split(' ')[1].Split(':')[1]), int.Parse(item.CommitDate.Split(' ')[1].Split(':')[2])); cmd.Parameters.Add("@ETCStatus", SqlDbType.Char, 1).Value = item.ETCStatus; //cmd.Parameters.Add("@SequenceID", SqlDbType.BigInt).Value = item.SequenceID; cmd.Parameters.Add("@TID", SqlDbType.VarChar, 48).Value = ""; //else //{ // cmd.Parameters.Add("@SequenceID", SqlDbType.BigInt).Value = 0; //} // Thuc thi stored int numRows = ExecuteNonQuery(cmd); // Kiem tra ket qua if (numRows < 1) { res = 0; } } } catch (Exception ex) { TKUtils.WriteLogFile(GetType() + "." + MethodBase.GetCurrentMethod().Name, ex.ToString()); } finally { if (cmd != null) { cmd.Connection.Close(); cmd.Dispose(); } cmd = null; } return(res); }
public void SaveOnceTicket(SoatVeTransactionModel item) { try { using (SqlCommand cmd = InitCommand("Add_SoatVeLuot")) { // Add param cmd.Parameters.Add("@sTID", SqlDbType.VarChar, 20).Value = item.ObuID; cmd.Parameters.Add("@sMSLane", SqlDbType.VarChar, 3).Value = item.LaneID; cmd.Parameters.Add("@sGiaVe", SqlDbType.Int).Value = item.ChargeAmount; cmd.Parameters.Add("@sGioSoat", SqlDbType.Int).Value = item.CheckTime; cmd.Parameters.Add("@sNgaySoat", SqlDbType.DateTime).Value = new DateTime(int.Parse(item.CheckDate.Split('/')[2].Split(' ')[0]), int.Parse(item.CheckDate.Split('/')[1]), int.Parse(item.CheckDate.Split('/')[0])); cmd.Parameters.Add("@sLogin", SqlDbType.VarChar, 20).Value = item.LoginID; cmd.Parameters.Add("@sCa", SqlDbType.VarChar, 3).Value = item.ShiftID; cmd.Parameters.Add("@sMSLoaiVe", SqlDbType.VarChar, 2).Value = "1" + item.VehicleClassID; cmd.Parameters.Add("@sMSLoaiXe", SqlDbType.VarChar, 2).Value = ""; //biến checker hiện giờ dùng chứa datestring @ cmd.Parameters.Add("@sChecker", SqlDbType.VarChar, 20).Value = item.Checker; cmd.Parameters.Add("@sSoXe", SqlDbType.VarChar, 20).Value = item.RecogPlateNumber; cmd.Parameters.Add("@sF0", SqlDbType.VarChar, 1).Value = item.F0; cmd.Parameters.Add("@sF1", SqlDbType.VarChar, 1).Value = item.F1; cmd.Parameters.Add("@sF2", SqlDbType.VarChar, 1).Value = item.F2; cmd.Parameters.Add("@sImageId", SqlDbType.NVarChar, 20).Value = item.ImageID; //if (this.SFTPUsername.Equals("station0075")) //{ // cmd.Parameters.Add("@sMSTram", SqlDbType.VarChar, 1).Value = this.StationID; // cmd.Parameters.Add("@sKhuHoi", SqlDbType.VarChar, 1).Value = 0; // Soat tại trạm dau vào nên la 0 // cmd.Parameters.Add("@IsSGVT", SqlDbType.Int).Value = IsSGVT; // cmd.Parameters.Add("@IsVTSG", SqlDbType.Int).Value = IsVTSG; // } //Tam add cmd.Parameters.Add("@sEtagID", SqlDbType.VarChar, 24).Value = ""; cmd.Parameters.Add("@Result", SqlDbType.Int).Direction = ParameterDirection.Output; // Thuc thi stored ExecuteNonQuery(cmd); // Kiem tra ket qua int retValue = int.Parse(cmd.Parameters["@Result"].Value.ToString()); string strReturnMsg = string.Empty; // Ghi log database //CommitDatabaseLog("SaveOnceTicket", this, retValue); //return (retValue > 0) ? 1 : 0; } } catch (Exception ex) { TKUtils.WriteLogFile(GetType() + "." + MethodBase.GetCurrentMethod().Name, ex.Message); //STORED_ONCE_TICKET, ex.Message); } //return 0; }