public static Guid GetCrewGuid(string crewName, Guid positionGuid) { if (crewName.Trim().Length == 0) { return(MainForm.zeroGuid); } if (positionGuid == MainForm.zeroGuid) { return(MainForm.zeroGuid); } OleDbCommand cmd = new OleDbCommand("", MainForm.connection); cmd.CommandText = "select Count(CREW_GUID) as ReCount \n" + "from CREW \n" + "where \n" + "CREW_NAME='" + MainForm.StrToSQLStr(crewName) + "' \n" + "and CREW_POSITION_GUID=" + MainForm.GuidToStr(positionGuid); int recCount = (int)cmd.ExecuteScalar(); switch (recCount) { case 0: return(SaveNewCrew(crewName, positionGuid)); case 1: cmd.CommandText = "select CREW_GUID \n" + "from CREW \n" + "where \n" + "CREW_NAME='" + MainForm.StrToSQLStr(crewName) + "' \n" + "and CREW_POSITION_GUID=" + MainForm.GuidToStr(positionGuid); return((Guid)cmd.ExecuteScalar()); default: FormSelectCrewmemberFromList form = new FormSelectCrewmemberFromList(); form.crewmemberName = crewName; form.positionGuid = positionGuid; if (form.ShowDialog() == DialogResult.OK) { return(form.crewGuid); } else { return(MainForm.zeroGuid); } } }
private void btnInfo_Click(object sender, EventArgs e) { if (!CheckCrewExists()) { MessageBox.Show("Unable to show details for \"" + cbCrewmember.Text + "\"", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } OleDbCommand cmd = new OleDbCommand("", MainForm.connection); //Проверяем наличие имени в списке cmd.CommandText = "select Count(CREW_GUID) \n" + "from CREW \n" + "where \n" + "CREW_NAME like '" + MainForm.StrToSQLStr(cbCrewmember.Text) + "' \n" + "and CREW_POSITION_GUID=" + MainForm.GuidToStr(_positionGuid); int recCount = (int)cmd.ExecuteScalar(); if (recCount == 0) { return; } if (_crewGuid == MainForm.zeroGuid) { if (recCount == 1) { cmd.CommandText = "select CREW_GUID \n" + "from CREW \n" + "where \n" + "CREW_NAME like '" + MainForm.StrToSQLStr(cbCrewmember.Text) + "' \n" + "and CREW_POSITION_GUID=" + MainForm.GuidToStr(_positionGuid); object x = cmd.ExecuteScalar(); try { _crewGuid = (Guid)x; } catch { MessageBox.Show("Unable to get crewmember GUID", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } else { FormSelectCrewmemberFromList form = new FormSelectCrewmemberFromList(); form.crewmemberName = cbCrewmember.Text; form.positionGuid = _positionGuid; if (form.ShowDialog() == DialogResult.OK) { } } } if (cbCrewmember.SelectedValue.ToString().Length > 0) { this.Cursor = Cursors.WaitCursor; CrewDetailsForm form = new CrewDetailsForm(); //form.positionGuid = _positionGuid; form.crewGuid = MainForm.StrToGuid(cbCrewmember.SelectedValue.ToString()); //form.crewmemberName = cbCrewmember.Text; var rslt = form.ShowDialog(); if (rslt == DialogResult.OK) { FillCrewmembers(_positionGuid); //Записываем имя в поле cbCrewmember.Text = form.crewName; } this.Cursor = Cursors.Default; } }