static void Main() { Permit perm1 = Permit.Create; Console.WriteLine(perm1.ToString()); Permit perm = Permit.Create | Permit.Read; Console.WriteLine(perm.ToString()); perm |= Permit.Delete; Console.WriteLine(perm.ToString()); }
/// <summary> /// удаляет указынный пропуск /// </summary> /// <param name="permit">удаляемый документ</param> private void DeletePermit(Permit permit) { string message = EntryControl.Resources.Message.Question.Delete; if (MessageBox.Show(message, permit.ToString(), MessageBoxButtons.YesNo) == DialogResult.Yes) { bsPermitList.Remove(permit); permit.Delete(); permit.Save(Database); } }
private void ClosePermit() { PermitMoving moving1 = Permit.Close(EntryPoint, Database.ConnectedUser); moving1.Save(Database); string message = EntryControl.Resources.Doc.Permit.PermitClose; message = message.Replace("@movingTime", moving1.MovingTime.ToString("dd.MM.yyyy HH:mm")); MessageBox.Show(message, Permit.ToString()); }
private void AddBindings() { AddBinding(tboxDocNumber, "DocNumber"); AddBinding(pickDocDate, "DocDate"); AddBinding(tboxPerson, "Person"); AddBinding(tboxVehicleMark, "VehicleMark"); AddBinding(tboxLicensePlate, "LicensePlate"); AddBinding(tboxBaseDocument, "BaseDocument"); AddBinding(tboxBaseDocNumber, "BaseDocNumber"); AddBinding(pickBaseDocDate, "BaseDocDate"); AddBinding(tboxComment, "Comment"); bsItemList.DataSource = Document.GetItemList(Database); if (Document.PermitId != 0) { Permit permit = Permit.Load(Database, Document.PermitId); tboxPermit.Text = permit.ToString(); btnFindPermit.Text = permit.ToString(); } }
private void CheckClose() { if (Permit.IsMultiEntry) { if (MessageBox.Show(EntryControl.Resources.Doc.Permit.PermitToClose, Permit.ToString(), MessageBoxButtons.YesNo) == DialogResult.Yes) { ClosePermit(); } } else { ClosePermit(); } }
private void AddBindings() { if (PlanAppoint.IsUpdated) { timer.Start(); } lblCargo.Text = PlanAppoint.Cargo.ToString(); lblVehicleMark.Text = PlanAppoint.Vehicle.ToString(); lblDriver.Text = PlanAppoint.DriverName + " (" + PlanAppoint.Contact + ")"; lblCreation.Text = PlanAppoint.CreationInfo; PlanAppoint.GetComment(Database); tboxComment.DataBindings.Add("Text", bsItem, "Comment"); if (PlanAppoint.HasPermit) { Permit permit = PlanAppoint.LoadPermit(Database); lblPermit.Text = permit.ToString(); switch (permit.PermitState.Id) { case 4: lblPermit.Text += " (закрыт)"; break; case 3: lblPermit.Text += " (заблокирован)"; break; case 2: lblPermit.Text += " (постоянный)"; break; } lboxPermitMoving.DataSource = permit.GetMovingList(Database); lboxPointList.DataSource = permit.GetAllowedPointList(Database); } else { lblPermit.Text = "не выдан"; } }
private void LoadPermit(int permitId) { Permit permit = Permit.Load(Database, permitId); tboxPermit.Text = permit.ToString(); }
private void MessagePermitIsClosed() { MessageBox.Show(EntryControl.Resources.Message.Error.PermitIsClosed, Permit.ToString()); }
private void PermitMovingForm_Shown(object sender, EventArgs e) { Text = Permit.ToString(); }
public override bool Save() { try { using (SqlConnection connection = DbControl.GetOpenConnection()) { SqlCommand command = connection.CreateCommand(); command.Parameters.Add(new SqlParameter("@ceid", System.Data.SqlDbType.VarChar)).Value = CEID.ToString(); command.Parameters.Add(new SqlParameter("@cst_id", System.Data.SqlDbType.VarChar)).Value = CSTID.ToString(); command.Parameters.Add(new SqlParameter("@lot_code", System.Data.SqlDbType.VarChar)).Value = LotCode.ToString(); command.Parameters.Add(new SqlParameter("@lot_id", System.Data.SqlDbType.VarChar)).Value = LotID == null ? "" : LotID; command.Parameters.Add(new SqlParameter("@cst_size", System.Data.SqlDbType.VarChar)).Value = CSTSize == null ? "" : CSTSize.ToString(); command.Parameters.Add(new SqlParameter("@eng_code", System.Data.SqlDbType.VarChar)).Value = EngCode == null ? "" : EngCode; command.Parameters.Add(new SqlParameter("@gls_thick", System.Data.SqlDbType.VarChar)).Value = GLSThick == null ? "" : GLSThick.ToString(); command.Parameters.Add(new SqlParameter("@host_msg", System.Data.SqlDbType.VarChar)).Value = HostMsg == null ? "" : HostMsg; command.Parameters.Add(new SqlParameter("@inline_code", System.Data.SqlDbType.VarChar)).Value = InLineCode.ToString() + ""; command.Parameters.Add(new SqlParameter("@inno", System.Data.SqlDbType.VarChar)).Value = InNo.ToString(); command.Parameters.Add(new SqlParameter("@outno", System.Data.SqlDbType.VarChar)).Value = OutNo.ToString(); command.Parameters.Add(new SqlParameter("@keyid", System.Data.SqlDbType.VarChar)).Value = KeyID == null ? "" : KeyID; command.Parameters.Add(new SqlParameter("@lot_command", System.Data.SqlDbType.VarChar)).Value = LotCommand == null ? "" : LotCommand; command.Parameters.Add(new SqlParameter("@lot_judge", System.Data.SqlDbType.VarChar)).Value = LotJudge == null ? "" : LotJudge; command.Parameters.Add(new SqlParameter("@lot_start_time", System.Data.SqlDbType.DateTime)).Value = LotStartTime.ToString("yyyy-MM-dd HH:mm:ss.fff"); command.Parameters.Add(new SqlParameter("@lot_state", System.Data.SqlDbType.VarChar)).Value = LotState.ToString(); command.Parameters.Add(new SqlParameter("@mode_code", System.Data.SqlDbType.VarChar)).Value = ModeCode == null ? "" : ModeCode; command.Parameters.Add(new SqlParameter("@part_num", System.Data.SqlDbType.VarChar)).Value = PartNum == null ? "" : PartNum; command.Parameters.Add(new SqlParameter("@permit", System.Data.SqlDbType.VarChar)).Value = Permit.ToString(); command.Parameters.Add(new SqlParameter("@port_id", System.Data.SqlDbType.VarChar)).Value = PortID == null ? "" : PortID; command.Parameters.Add(new SqlParameter("@prc_id", System.Data.SqlDbType.VarChar)).Value = PrcID == null ? "" : PrcID; command.Parameters.Add(new SqlParameter("@prod_type", System.Data.SqlDbType.VarChar)).Value = ProdType == null ? "" : ProdType; command.Parameters.Add(new SqlParameter("@rcp", System.Data.SqlDbType.VarChar)).Value = RCP == null ? "" : RCP; command.Parameters.Add(new SqlParameter("@slot_count", System.Data.SqlDbType.VarChar)).Value = SlotCount.ToString(); command.Parameters.Add(new SqlParameter("@download_time", System.Data.SqlDbType.DateTime)).Value = DownloadTime.ToString("yyyy-MM-dd HH:mm:ss.fff"); command.CommandText = "update lot_data set " + "ceid=@ceid, cst_id=@cst_id, cst_size=@cst_size, eng_code=@eng_code, gls_thick=@gls_thick, host_msg=@host_msg, inline_code=@inline_code, inno=@inno, " + "outno=@outno, keyid=@keyid, lot_command=@lot_command, lot_id=@lot_id, lot_judge=@lot_judge, lot_start_time=@lot_start_time, lot_state=@lot_state, mode_code=@mode_code, part_num=part_num, permit=@permit, " + "port_id=@port_id, prc_id=@prc_id, prod_type=@prod_type, rcp=@rcp, slot_count=@slot_count, download_time=@download_time " + "where lot_code=@lot_code"; command.Connection = connection; command.ExecuteNonQuery(); } return(true); } catch (SqlException ex) { CLogManager.Instance.Log(new CExceptionLogFormat(Catagory.Error, "EMP", ex)); } return(false); }
public override bool Add() { SqlDataReader reader = null; try { using (SqlConnection connection = DbControl.GetOpenConnection()) { SqlCommand readCommand = connection.CreateCommand(); readCommand.Parameters.Add(new SqlParameter("@lot_code", System.Data.SqlDbType.VarChar)).Value = LotCode.ToString(); readCommand.CommandText = "select * from lot_data where lot_code=@lot_code"; readCommand.Connection = connection; reader = readCommand.ExecuteReader(); if (reader.Read()) { reader.Close(); } else { reader.Close(); SqlCommand command = connection.CreateCommand(); //신규 command.Parameters.Add(new SqlParameter("@ceid", System.Data.SqlDbType.VarChar)).Value = CEID.ToString(); command.Parameters.Add(new SqlParameter("@cst_id", System.Data.SqlDbType.VarChar)).Value = CSTID.ToString() + ""; command.Parameters.Add(new SqlParameter("@lot_code", System.Data.SqlDbType.VarChar)).Value = LotCode.ToString(); command.Parameters.Add(new SqlParameter("@lot_id", System.Data.SqlDbType.VarChar)).Value = LotID == null ? "" : LotID; command.Parameters.Add(new SqlParameter("@cst_size", System.Data.SqlDbType.VarChar)).Value = CSTSize == null ? "" : CSTSize.ToString(); command.Parameters.Add(new SqlParameter("@eng_code", System.Data.SqlDbType.VarChar)).Value = EngCode == null ? "" : EngCode; command.Parameters.Add(new SqlParameter("@gls_thick", System.Data.SqlDbType.VarChar)).Value = GLSThick == null ? "" : GLSThick.ToString(); command.Parameters.Add(new SqlParameter("@host_msg", System.Data.SqlDbType.VarChar)).Value = HostMsg == null ? "" : HostMsg; command.Parameters.Add(new SqlParameter("@inline_code", System.Data.SqlDbType.VarChar)).Value = InLineCode.ToString() + ""; command.Parameters.Add(new SqlParameter("@inno", System.Data.SqlDbType.VarChar)).Value = InNo.ToString(); command.Parameters.Add(new SqlParameter("@outno", System.Data.SqlDbType.VarChar)).Value = OutNo.ToString(); command.Parameters.Add(new SqlParameter("@keyid", System.Data.SqlDbType.VarChar)).Value = KeyID == null ? "" : KeyID; command.Parameters.Add(new SqlParameter("@lot_command", System.Data.SqlDbType.VarChar)).Value = LotCommand == null ? "" : LotCommand; command.Parameters.Add(new SqlParameter("@lot_judge", System.Data.SqlDbType.VarChar)).Value = LotJudge == null ? "" : LotJudge; command.Parameters.Add(new SqlParameter("@lot_start_time", System.Data.SqlDbType.DateTime)).Value = LotStartTime.ToString("yyyy-MM-dd HH:mm:ss.fff"); command.Parameters.Add(new SqlParameter("@lot_state", System.Data.SqlDbType.VarChar)).Value = LotState.ToString(); command.Parameters.Add(new SqlParameter("@mode_code", System.Data.SqlDbType.VarChar)).Value = ModeCode == null ? "" : ModeCode; command.Parameters.Add(new SqlParameter("@part_num", System.Data.SqlDbType.VarChar)).Value = PartNum == null ? "" : PartNum; command.Parameters.Add(new SqlParameter("@permit", System.Data.SqlDbType.VarChar)).Value = Permit.ToString(); command.Parameters.Add(new SqlParameter("@port_id", System.Data.SqlDbType.VarChar)).Value = PortID == null ? "" : PortID; command.Parameters.Add(new SqlParameter("@prc_id", System.Data.SqlDbType.VarChar)).Value = PrcID == null ? "" : PrcID; command.Parameters.Add(new SqlParameter("@prod_type", System.Data.SqlDbType.VarChar)).Value = ProdType == null ? "" : ProdType; command.Parameters.Add(new SqlParameter("@rcp", System.Data.SqlDbType.VarChar)).Value = RCP == null ? "" : RCP; command.Parameters.Add(new SqlParameter("@slot_count", System.Data.SqlDbType.VarChar)).Value = SlotCount.ToString(); command.Parameters.Add(new SqlParameter("@download_time", System.Data.SqlDbType.DateTime)).Value = DownloadTime.ToString("yyyy-MM-dd HH:mm:ss.fff"); command.Connection = connection; command.CommandText = "insert into lot_data " + "(lot_code, ceid, cst_id, cst_size, eng_code, gls_thick, host_msg, inline_code, inno, outno, keyid, lot_command, lot_id, lot_judge, lot_state, mode_code, part_num, permit, port_id, prc_id, prod_type, rcp, slot_count, download_time) " + "values (@lot_code, @ceid, @cst_id, @cst_size, @eng_code, @gls_thick, @host_msg, @inline_code, @inno, @outno, @keyid, @lot_command, @lot_id, @lot_judge, @lot_state, @mode_code, @part_num, @permit, @port_id, @prc_id, @prod_type, @rcp, @slot_count, @download_time)"; command.ExecuteNonQuery(); return(true); } } } catch (SqlException ex) { CLogManager.Instance.Log(new CExceptionLogFormat(Catagory.Error, "EMP", ex)); } finally { if (reader != null) { reader.Close(); } } return(false); }