public Form_Partner()
{
InitializeComponent();
dsCycle.Tables.Add();
dsCycle.Tables[0].Columns.Add("name", typeof(string));
dsCycle.Tables[0].Columns.Add("value", typeof(int));
dsCycle.Tables[0].Rows.Add("未定义", 0);
dsCycle.Tables[0].Rows.Add("每月", 1);
dsCycle.Tables[0].Rows.Add("每季度", 2);
dsCycle.Tables[0].Rows.Add("每半年", 3);
dsCycle.Tables[0].Rows.Add("每年", 4);
CalendarColumn start = new CalendarColumn();
start.HeaderText="起始时间";
start.Width = 85;
CalendarColumn end = new CalendarColumn();
end.HeaderText = "起始时间";
end.Width = 85;
dataGridView_volume.Columns.Insert(3, start);
dataGridView_volume.Columns.Insert(4, end);
groupbox_info.Text = "股东信息";
groupbox_info.ForeColor = Color.FromKnownColor(KnownColor.ControlText);
}
private void Frm_comRequerimiento_Load(object sender, EventArgs e)
{
try
{
MenuSistema.Cls_Menus menu = new MenuSistema.Cls_Menus();
menu.ObtenerPermisos(Id_Perfil, Convert.ToInt32(Tag.ToString()), ref lectura, ref escritura, ref elimina);
this.OperacionesDelUsuario();
Clases.Empresa.CargarEmpresas(comboBoxEmpresa);
this.comboBoxEmpresa.SelectedValue = Clases.Usuario.EmpresaLogeada.EmpresaIngresada.ToString();
// cargo en una coleccion los productos por unica vez
BLL.Procedures.H_ARTICULOSDEPOSITO _art = new BLL.Procedures.H_ARTICULOSDEPOSITO();
_articulosItem = _art.ItemList(); //le paso la colección de artículos
CargarRubros();
CargarSubRubros();
CargarLugaresEntrega(Clases.Usuario.EmpresaLogeada.EmpresaIngresada);
TraerMarcasArticulos();
//calendar
CalendarColumn col = new CalendarColumn();
this.dataGridViewReq.Columns.Add(col);
this.dataGridViewReq.Columns[(int)Col_Detalle.FENTREGA].HeaderText = "Fecha Necesidad";
this.dataGridViewReq.Columns[(int)Col_Detalle.FENTREGA].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//calendar
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Frm_ModificacionRequerimiento_Load(object sender, EventArgs e)
{
//PERMISOS
MenuSistema.Cls_Menus menu = new MenuSistema.Cls_Menus();
menu.ObtenerPermisos(Id_Perfil, Convert.ToInt32(Tag.ToString()), ref lectura, ref escritura, ref elimina);
this.OperacionesDelUsuario();
this.Text = "Modificación de Requerimientos de la empresa: ";
//FIN PERMISOS
//calendar
CalendarColumn col = new CalendarColumn();
this.dataGridViewReqItems.Columns.Add(col);
this.dataGridViewReqItems.Columns[(int)Col_ReqItem.FENTREGA].HeaderText = "Fecha Entrega";
this.dataGridViewReqItems.Columns[(int)Col_ReqItem.FENTREGA].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
this.dataGridViewReqItems.AutoGenerateColumns = false;
// cargo en una coleccion los productos por unica vez
BLL.Procedures.H_ARTICULOSDEPOSITO _art = new BLL.Procedures.H_ARTICULOSDEPOSITO();
_articulosItem = _art.ItemList();//le paso la colección de artículos
this.CargarLugaresEntrega(Clases.Usuario.EmpresaLogeada.EmpresaIngresada.ToString());
TraeItemsPendientes();
}
private void Frm_Vtos_Load(object sender, EventArgs e)
{
//calendar
CalendarColumn col = new CalendarColumn();
this.dataGridViewVtos.Columns.Add(col);
this.dataGridViewVtos.Columns[(int)Col_Vtos.VTO].Name = "FechaVto";
this.dataGridViewVtos.Columns[(int)Col_Vtos.VTO].HeaderText = "Fecha Vencimiento";
//this.dataGridViewVtos.Columns[(int)Col_Vtos.VTO].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
this.dataGridViewVtos.Columns[(int)Col_Vtos.VTO].Width = 130;
this.dataGridViewVtos.Columns[(int)Col_Vtos.VTO].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//calendar
//CARGO LA LISTA AL GRID Y BORRO SUS DATOS...
this.dataGridViewVtos.Rows.Clear();
int indice;
foreach (Entities.Tables.STKVENCIMIENTO item in _listVto)
{
indice = dataGridViewVtos.Rows.Add();
dataGridViewVtos.Rows[indice].Cells[(int)Col_Vtos.CANTIDAD].Value = item.CANTIDAD; //CANTIDAD
dataGridViewVtos.Rows[indice].Cells[(int)Col_Vtos.VTO].Value = item.VTO; //VTO
}
this.labelCodigoArticulo.Text = _codigoArticuloVto;
labelDescripArticulo.Text = _descripArticuloVto;
_listVto.Clear(); //ES PORQUE EN ESTA LISTA VUELVO A CARGAR LOS DATOS ACTUALIZADOS PARA ENVIARLOS AL FORM PRINCIPAL
}
// ------ Изучение BindingSource -----
// Метод привязки данных с использованием BindingSource
private void BindingMemory()
{
// Инициализация BindingSource
MemorFile memoryFiles = new MemorFile();
memoryFiles.Memories.Add(new Memory());
bindSrc.DataSource = memoryFiles;
bindSrc.DataMember = "Memories";
// Связываем через BindingSource dtpMemory с объектом memoryFiles
dtpMemory.DataBindings.Add("Value", bindSrc, "Date");
dtpMemory.DataBindings[0].DataSourceUpdateMode = DataSourceUpdateMode.OnPropertyChanged;
tbMemory.DataBindings.Add("Text", bindSrc, "Text");
tbMemory.DataBindings[0].DataSourceUpdateMode = DataSourceUpdateMode.OnPropertyChanged;
// Связывание BindingNavigator и BindingSource
bindNavigator.BindingSource = bindSrc;
// Добавление DataGridView
grid.AutoGenerateColumns = false;
grid.DataSource = bindSrc;
DataGridViewTextBoxColumn tbColumn = new DataGridViewTextBoxColumn();
grid.Columns.Add(tbColumn);
grid.Columns[0].DataPropertyName = "Text";
grid.Columns[0].Name = "Text";
CalendarColumn calColumn = new CalendarColumn();
grid.Columns.Add(calColumn);
grid.Columns[1].DataPropertyName = "Date";
grid.Columns[1].Name = "Date";
}
private static void AddDateColumn(DataGridView grd, ArrayList columns)
{
if (columns == null)
{
return;
}
foreach (DataGridViewColumn gc in columns)
{
if (grd.Columns.Contains(gc.DataPropertyName) &&
gc.CellType == typeof(CalendarColumn))
{
continue;
}
CalendarColumn col = new CalendarColumn();
col.Name = gc.DataPropertyName;
col.DataPropertyName = gc.DataPropertyName;
col.HeaderText = gc.HeaderText;
col.DisplayIndex = gc.DisplayIndex;
grd.Columns.Add(col);
gc.Visible = false;
grd.Columns.Remove(gc);
}
}
public DataGridViewWithBinding()
{
Text = "DataGridView with Binding";
Width *= 2;
// Initialize the BindingSource.
FileNewOnClick(null, EventArgs.Empty);
// Create DataGridView control.
DataGridView grid = new DataGridView();
grid.Parent = this;
grid.AutoSize = true;
grid.Dock = DockStyle.Fill;
// Bind the control to the data source.
grid.AutoGenerateColumns = false;
grid.DataSource = bindsrc;
// Create desired columns for DataGridView.
DataGridViewComboBoxColumn colCombo = new DataGridViewComboBoxColumn();
colCombo.DataPropertyName = "Courtesy";
colCombo.DataSource = Enum.GetValues(typeof(CourtesyTitle));
colCombo.HeaderText = "Courtesy";
grid.Columns.Add(colCombo);
DataGridViewTextBoxColumn colText = new DataGridViewTextBoxColumn();
colText.DataPropertyName = "FirstName";
colText.HeaderText = "First Name";
grid.Columns.Add(colText);
colText = new DataGridViewTextBoxColumn();
colText.DataPropertyName = "LastName";
colText.HeaderText = "Last Name";
grid.Columns.Add(colText);
CalendarColumn colBirth = new CalendarColumn();
colBirth.DataPropertyName = "BirthDate";
colBirth.HeaderText = "Birth Date";
grid.Columns.Add(colBirth);
DataGridViewCheckBoxColumn colCheck = new DataGridViewCheckBoxColumn();
colCheck.DataPropertyName = "Enrolled";
colCheck.HeaderText = "Enrolled?";
grid.Columns.Add(colCheck);
// Create the menu.
MenuStrip menu = new MenuStrip();
menu.Parent = this;
ToolStripMenuItem item = (ToolStripMenuItem)menu.Items.Add("&File");
item.DropDownItems.Add("&New", null, FileNewOnClick);
item.DropDownItems.Add("&Open...", null, FileOpenOnClick);
item.DropDownItems.Add("Save &As...", null, FileSaveAsOnClick);
}
// Este contrutor é utilizado quando queremos carregar o form com uma reuniao ja existente
public MeetingView(int idUser, Meeting meeting, List <UserTask> tasks, List <MeetingInvite> guestList)
{
InitializeComponent();
// Reuniao existente
this.newMeeting = false;
this.meeting = meeting;
this.idUser = idUser;
this.buttonExportPdf.Visible = true;
this.buttonDelete.Visible = true;
this.buttonAttendeeList.Visible = true;
this.buttonSendMinutes.Visible = true;
this.buttonUploadAttendeeList.Visible = true;
// Instancia a classe controller
this.controller = new MeetingController();
// Carrega lista de utilizadores
loadUsersList();
// Activa o botao de iniciar a reuniao
this.groupBoxRecord.Visible = true;
// Definir o campo de data/hora com o formato dia/mes/ano hora:minuto
this.dateTimePickerStart.Format = DateTimePickerFormat.Custom;
this.dateTimePickerStart.CustomFormat = "dd/MM/yyyy HH:mm";
// Load duration options
loadDuration();
// Carregar categorias para a linkedlist e combobox
loadTypesList();
// Adiciona a coluna custom de data na grid
CalendarColumn col = new CalendarColumn();
int colno = this.dataGridViewTasks.Columns.Add(col);
this.dataGridViewTasks.Columns[colno].HeaderText = "Deadline";
// Carrega valores da meeting
this.guestList = guestList;
this.dateTimePickerStart.Value = this.meeting.startTime;
this.textBoxSubject.Text = this.meeting.subject;
this.textBoxAgenda.Text = this.meeting.agendaDescription;
this.textBoxMeetingminutes.Text = this.meeting.meetingMinutes;
this.textBoxTranscription.Text = this.meeting.audioTranscription;
selectDuration(this.meeting.durationMinutes);
selectType(this.meeting.idType);
loadTasks(tasks); // Carrega lista de tarefas
this.panelEditMeeting.Visible = true;
// Carrega audio da reuniao
loadMeetingAudio();
// Mostra a coluna de presença na list ade convidados
showGuests();
loadUsersWithSelected(guestList); // Carrega users na base de dados e marca os selecioandos
}
private void DefinirColumnas()
{
//dataGridViewConsolidado.DataKeyNames = new string[] { "Id" };
//*****COLUMNA F.ENTREGA1
CalendarColumn col = new CalendarColumn();
this.dataGridViewConsolidado.Columns.Add(col);
this.dataGridViewConsolidado.Columns[(int)Col_GridDetalle.FENTREGA1].HeaderText = "F.Entrega1";
this.dataGridViewConsolidado.Columns[(int)Col_GridDetalle.FENTREGA1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
this.dataGridViewConsolidado.Columns[(int)Col_GridDetalle.FENTREGA1].Width = 90;
//COLUMNA CANTIDAD F.ENTREGA1
DataGridViewColumn _col = new DataGridViewColumn();
_col.HeaderText = "Cantidad";
_col.Name = "Cantidad";
_col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
_col.Width = 80;
DataGridViewCell cell = new DataGridViewTextBoxCell();
_col.CellTemplate = cell;
_col.DefaultCellStyle.Format = "N2";
this.dataGridViewConsolidado.Columns.Add(_col);
//*****COLUMNA F.ENTREGA2
//col = new CalendarColumn();
//this.dataGridViewConsolidado.Columns.Add(col);
//this.dataGridViewConsolidado.Columns[(int)Col_GridDetalle.FENTREGA2].HeaderText = "F.Entrega2";
//this.dataGridViewConsolidado.Columns[(int)Col_GridDetalle.FENTREGA2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//this.dataGridViewConsolidado.Columns[(int)Col_GridDetalle.FENTREGA2].Width = 90;
////COLUMNA CANTIDAD F.ENTREGA2
//_col = new DataGridViewColumn();
//_col.HeaderText = "Cantidad2";
//_col.Name = "Cantidad2";
//_col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
//_col.Width = 80;
//cell = new DataGridViewTextBoxCell();
//_col.CellTemplate = cell;
//_col.DefaultCellStyle.Format = "N2";
//this.dataGridViewConsolidado.Columns.Add(_col);
//*****COLUMNA F.ENTREGA3
//col = new CalendarColumn();
//this.dataGridViewConsolidado.Columns.Add(col);
//this.dataGridViewConsolidado.Columns[(int)Col_GridDetalle.FENTREGA3].HeaderText = "F.Entrega3";
//this.dataGridViewConsolidado.Columns[(int)Col_GridDetalle.FENTREGA3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//this.dataGridViewConsolidado.Columns[(int)Col_GridDetalle.FENTREGA3].Width = 90;
////COLUMNA CANTIDAD F.ENTREGA2
//_col = new DataGridViewColumn();
//_col.HeaderText = "Cantidad3";
//_col.Name = "Cantidad3";
//_col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
//_col.Width = 80;
//cell = new DataGridViewTextBoxCell();
//_col.CellTemplate = cell;
//_col.DefaultCellStyle.Format = "N2";
//this.dataGridViewConsolidado.Columns.Add(_col);
}
void AddStyle(DataGridView grid, int tableID)
{
grid.AutoGenerateColumns = false;
DataColumnCollection cols = ds.Tables[tableID].Columns;
foreach (DataColumn dc in cols)
{
DataGridViewColumn col = null;
if (dc.DataType == typeof(bool))
{
col = new DataGridViewCheckBoxColumn();
}
else if (dc.DataType == typeof(DateTime))
{
col = new CalendarColumn();
col.DefaultCellStyle.Format = "d";
}
else if (dc.DataType == typeof(decimal))
{
col = new DataGridViewTextBoxColumn();
col.DefaultCellStyle.Format = "f2";
}
else if (dc.ColumnName == "Course")
{
DataGridViewComboBoxColumn combo = new DataGridViewComboBoxColumn();
combo.DataSource = courses;
col = combo;
}
else if (dc.ColumnName == "Mark")
{
dc.DefaultValue = (byte)2;
DataGridViewComboBoxColumn combo = new DataGridViewComboBoxColumn();
combo.Items.Add((byte)2);
combo.Items.Add((byte)3);
combo.Items.Add((byte)4);
combo.Items.Add((byte)5);
col = combo;
}
else
{
col = new DataGridViewTextBoxColumn();
}
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
if (dc == cols[cols.Count - 1])
{
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
col.DataPropertyName = dc.ColumnName;
col.HeaderText = dc.ColumnName;
grid.Columns.Add(col);
}
grid.DefaultCellStyle.SelectionBackColor = Color.LightSteelBlue;
grid.DefaultCellStyle.SelectionForeColor = Color.Black;
grid.AlternatingRowsDefaultCellStyle.BackColor = tableID == 0 ? Color.Wheat : Color.FromArgb(200, 255, 200);
}
private void Medicamento_Solicitado_Load(object sender, EventArgs e)
{
Trae_Medicamento_Solicitado_Sin_Autorizar();
//calendar
CalendarColumn col = new CalendarColumn();
this.dataGridViewMedicamentos.Columns.Add(col);
this.dataGridViewMedicamentos.Columns[(int)Col_Medicamentos_Solicitados.FECHA_HASTA].HeaderText = "Autorizar Hasta";
this.dataGridViewMedicamentos.Columns[(int)Col_Medicamentos_Solicitados.FECHA_HASTA].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
private void Form1_Load(object sender, EventArgs e)
{
CalendarColumn col = new CalendarColumn();
this.dataGridView1.Columns.Add(col);
this.dataGridView1.RowCount = 5;
foreach (DataGridViewRow row in this.dataGridView1.Rows)
{
row.Cells[0].Value = DateTime.Now;
}
}
private void CalendarControlCell_Load(object sender, EventArgs e)
{
CalendarColumn col = new CalendarColumn();
this.dataGridView1.Columns.Add(col);
this.dataGridView1.RowCount = 5;
foreach (DataGridViewRow row in this.dataGridView1.Rows)
{
row.Cells[0].Value = DateTime.Now;
}
}
public static void Initialize(DataGridView dgv)
{
dgv.Rows.Clear();
dgv.Columns.Clear();
var userNumberColumn = new DataGridViewTextBoxColumn
{
HeaderText = "ID",
ValueType = typeof(Int32),
AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader,
ReadOnly = true,
ToolTipText = "Read only column"
};
var loginColumn = new DataGridViewTextBoxColumn
{
HeaderText = "Username"
};
var passwordColumn = new DataGridViewTextBoxColumn
{
HeaderText = "Password"
};
var specialCodeColumn = new DataGridViewComboBoxColumn
{
HeaderText = "Special Code",
DisplayMember = "special_code",
ValueMember = "id"
};
var genderColumn = new DataGridViewTextBoxColumn
{
HeaderText = "gender"
};
var signUpDateColumn = new CalendarColumn
{
HeaderText = "Sign up date"
};
var birthDateColumn = new CalendarColumn
{
HeaderText = "Birth date"
};
dgv.Columns.AddRange(userNumberColumn, loginColumn, passwordColumn, specialCodeColumn, genderColumn, signUpDateColumn, birthDateColumn);
using (var ctx = new UsersContext())
{
specialCodeColumn.DataSource = ctx.specials.ToList(); // Get assosiate for last column
var rows = ctx.awp_users.OrderBy(o => o.id).ToList(); // sort by ASC
foreach (var rec in rows)
{
var rowIndex = dgv.Rows.Add(rec.id, rec.login_, rec.password, rec.id_special, rec.gender, rec.signup_date, rec.birth_date);
dgv.Rows[rowIndex].Cells[2].Tag = rec.salt;
}
}
}
public static void Initialize(DataGridView dgv)
{
dgv.Rows.Clear();
dgv.Columns.Clear();
var knightNumberColumn = new DataGridViewTextBoxColumn
{
HeaderText = "ID",
ValueType = typeof(Int32),
AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader,
ReadOnly = true,
ToolTipText = "Read only column"
};
var knightNameColumn = new DataGridViewTextBoxColumn
{
HeaderText = "Knight name"
};
var birthDateColumn = new CalendarColumn
{
HeaderText = "Knight Birth Date"
};
var honorColumn = new DataGridViewTextBoxColumn
{
HeaderText = "Honor",
ValueType = typeof(Int32)
};
var squireNameColumn = new DataGridViewComboBoxColumn
{
HeaderText = "Name of squire",
DisplayMember = "name",
ValueMember = "id_squire"
};
dgv.Columns.AddRange(knightNumberColumn, knightNameColumn, birthDateColumn, honorColumn, squireNameColumn);
using (var ctx = new TournamentsContext())
{
squireNameColumn.DataSource = ctx.squires.ToList(); // Get assosiate for last column
var knightRows = ctx.knights.OrderBy(kni => kni.id_knight).ToList(); // sort by ASC
foreach (var knight in knightRows)
{
// Question!
// Should I change snake_Case to pascalCase???
dgv.Rows.Add(knight.id_knight, knight.name, knight.birth_date, knight.honor, knight.id_squire);
}
}
}
private void FrmPlanificationSoins_Load(object sender, EventArgs e)
{
colDateHeure = new CalendarColumn();
// TODO: This line of code loads data into the 'bD5B6TP1_ConstantinBrassardLaheyDataSet.NoEtNomsAssistants' table. You can move, or remove it, as needed.
this.noEtNomsAssistantsTableAdapter.Fill(this.bD5B6TP1_ConstantinBrassardLaheyDataSet.NoEtNomsAssistants);
// TODO: This line of code loads data into the 'bD5B6TP1_ConstantinBrassardLaheyDataSet.NoEtNomsAssistants' table. You can move, or remove it, as needed.
this.noEtNomsAssistantsTableAdapter.Fill(this.bD5B6TP1_ConstantinBrassardLaheyDataSet.NoEtNomsAssistants);
// TODO: This line of code loads data into the 'bD5B6TP1_ConstantinBrassardLaheyDataSet.NoEtNomsClientsInvites' table. You can move, or remove it, as needed.
this.noEtNomsClientsInvitesTableAdapter.Fill(this.bD5B6TP1_ConstantinBrassardLaheyDataSet.NoEtNomsClientsInvites);
// TODO: This line of code loads data into the 'bD5B6TP1_ConstantinBrassardLaheyDataSet.NoEtDescriptionSoin' table. You can move, or remove it, as needed.
this.noEtDescriptionSoinTableAdapter.Fill(this.bD5B6TP1_ConstantinBrassardLaheyDataSet.NoEtDescriptionSoin);
// TODO: This line of code loads data into the 'bD5B6TP1_ConstantinBrassardLaheyDataSet.PlanifSoin' table. You can move, or remove it, as needed.
this.planifSoinTableAdapter.Fill(this.bD5B6TP1_ConstantinBrassardLaheyDataSet.PlanifSoin);
planifSoinTableAdapter.Adapter.RowUpdated += GestionConflits.GenererGestionConflit("DateHeure", "le rendezvous cédulé le");
}
/// <summary>
/// Populates data grid and combo boxes.
/// </summary>
private void SetupForm()
{
// reference survey list
dgvRefSurveys.AutoGenerateColumns = false;
DataGridViewColumn column1 = new DataGridViewTextBoxColumn();
column1.DataPropertyName = "CheckID";
column1.Name = "CheckID";
column1.Visible = false;
dgvRefSurveys.Columns.Add(column1);
DataGridViewComboBoxColumn column2 = new DataGridViewComboBoxColumn();
column2.DataPropertyName = "SID";
column2.DataSource = DBAction.GetAllSurveys();
column2.DisplayMember = "SurveyCode";
column2.ValueMember = "SID";
column2.Name = "Survey";
dgvRefSurveys.Columns.Add(column2);
CalendarColumn column3 = new CalendarColumn();
column3.DataPropertyName = "SurveyDate";
column3.Name = "Date";
dgvRefSurveys.Columns.Add(column3);
// survey filter list
dgvSurveys.DataSource = DBAction.GetSurveyCheckSurveys();
// combo boxes
cboCheckType.DisplayMember = "CheckName";
cboCheckType.ValueMember = "ID";
cboCheckType.DataSource = new BindingList <SurveyCheckType>(DBAction.GetSurveyCheckTypes());
cboSurvey.DisplayMember = "SurveyCode";
cboSurvey.ValueMember = "SID";
cboSurvey.DataSource = new BindingList <Survey>(DBAction.GetAllSurveys());
cboCheckInit.DisplayMember = "Name";
cboCheckInit.ValueMember = "ID";
cboCheckInit.DataSource = new BindingList <Person>(DBAction.GetPeople());
}
private void Form1_Load(object sender, EventArgs e)
{
DataGridViewTextBoxColumn t = new DataGridViewTextBoxColumn();
t.HeaderText = "test";
DataGridViewComboBoxColumn c = new DataGridViewComboBoxColumn();
c.HeaderText = "formula";
ButtonColumn col = new ButtonColumn();
CalendarColumn col2 = new CalendarColumn();
this.dataGridView1.Columns.AddRange(t, col, c, col2);
//this.dataGridView1.RowCount = 5;
//foreach (DataGridViewRow row in this.dataGridView1.Rows)
//{
// row.Cells[0].Value = DateTime.Now;
//}
}
private void Frm_AutorizacionOrdenCompra_Load(object sender, EventArgs e)
{
//PERMISOS
MenuSistema.Cls_Menus menu = new MenuSistema.Cls_Menus();
menu.ObtenerPermisos(Id_Perfil, Convert.ToInt32(Tag.ToString()), ref lectura, ref escritura, ref elimina);
this.OperacionesDelUsuario();
//calendar
CalendarColumn col = new CalendarColumn();
this.dataGridViewOCItem.Columns.Add(col);
this.dataGridViewOCItem.Columns[(int)Col_OCItem.FECHA_DE_ENTREGA].HeaderText = "Fecha Entrega";
this.dataGridViewOCItem.Columns[(int)Col_OCItem.FECHA_DE_ENTREGA].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//FIN PERMISOS
this.Text = "Autorización Orden de Compra Empresa: " + Clases.Usuario.EmpresaLogeada.EmpresaIngresada.ToString();
TraeOCPendientes();
}
private void FrmEntregaDepagos_Load(object sender, EventArgs e)
{
MenuSistema.Cls_Menus menu = new MenuSistema.Cls_Menus();
menu.ObtenerPermisos(Id_Perfil, Convert.ToInt32(Tag.ToString()), ref lectura, ref escritura, ref elimina);
this.OperacionesDelUsuario();
//calendar
CalendarColumn col = new CalendarColumn();
this.dataGridViewRetiro.Columns.Add(col);
this.dataGridViewRetiro.Columns[(int)Col_FacturaOP.FechaRetiro].HeaderText = "Fecha Entrega";
//calendar
//this.dataGridViewRetiro.AutoGenerateColumns = false;
CargarFacturas();
}
private void InitializeDgvStage()
{
dgvStage.Rows.Clear();
dgvStage.Columns.Clear();
dgvStage.Columns.Add(new DataGridViewTextBoxColumn
{
Name = "idЭтапа",
Visible = false
});
dgvStage.Columns.Add("Название_этапа", "Название этапа");
dgvStage.Columns.Add("Место_провеления", "Место проведения");
dgvStage.Columns.Add(new CalendarColumn
{
Name = "Дата_начала",
HeaderText = @"Дата начала"
});
var f = new CalendarColumn();
dgvStage.Columns.Add(new CalendarColumn
{
Name = "Дата_конца",
HeaderText = @"Дата конца"
});
var cups = new DataGridViewComboBoxColumn
{
HeaderText = @"Кубок мира",
Name = "Кубок"
};
dgvStage.Columns.Add(cups);
using (var ctx = new WorldCupsContext())
{
var listCups = ctx.Кубок_мира.ToDictionary(item => item.idКубка_мира, item => "(" + item.idКубка_мира + ") " + item.Название_кубка);
cups.DataSource = listCups.Values.ToList();
foreach (var race in ctx.Этап_кубка_мира)
{
var rowIdx = dgvStage.Rows.Add(race.idЭтапа_кубка_мира, race.Название_этапа, race.Место_провеления,
race.Дата_начала, race.Дата_конца, listCups[race.idКубка_мира]);
dgvStage.Rows[rowIdx].Tag = race;
}
}
}
public UnboundDataGridViewWithCalendar()
{
Text = "Unbound DataGridView with Calendar";
Width *= 2;
DataGridView grid = new DataGridView();
grid.Parent = this;
grid.AutoSize = true;
grid.Dock = DockStyle.Fill;
DataGridViewComboBoxColumn colCombo = new DataGridViewComboBoxColumn();
colCombo.Name = "Courtesy";
colCombo.HeaderText = "Courtesy";
colCombo.DataSource = Enum.GetValues(typeof(CourtesyTitle));
colCombo.ValueType = typeof(CourtesyTitle);
grid.Columns.Add(colCombo);
DataGridViewTextBoxColumn colText = new DataGridViewTextBoxColumn();
colText.Name = "FirstName";
colText.HeaderText = "First Name";
grid.Columns.Add(colText);
colText = new DataGridViewTextBoxColumn();
colText.Name = "LastName";
colText.HeaderText = "Last Name";
grid.Columns.Add(colText);
CalendarColumn colBirth = new CalendarColumn();
colBirth.Name = "BirthDate";
colBirth.HeaderText = "Birth Date";
grid.Columns.Add(colBirth);
DataGridViewCheckBoxColumn colCheck = new DataGridViewCheckBoxColumn();
colCheck.Name = "Enrolled";
colCheck.HeaderText = "Enrolled?";
grid.Columns.Add(colCheck);
}
//private void GeneraTXTBinonexo()
//{
// try
// {
// //-------------- ESTRUCTURA UPLOAD P.TXT ---------------------------
// //1-CODIGO DE ITEM VARCHAR(20)
// //2-CANTIDAD TOTAL NUMERO(10)
// //3-NRO DE NECESIDAD VARCHAR(20)--- ES INTERNO DE STACATALINA
// //4-FECHA_01 FECHA(DD/MM//YYYY)
// //5-CANTIDAD_01 NUMERO(10)
// //6-FECHA_02 FECHA(DD/MM//YYYY) --CAMPO NO OBLIGATORIO
// //7-CANTIDAD_02 NUMERO(10) -- CAMPO NO OBLIGATORIO
// //HASTA 24 FECHAS POSIBLES DE ENTREGA
// string itemTXT = string.Empty;
// string codProdTXT = string.Empty;
// Int32 cantidadTXT = 0;
// string nroNecesidad="99";
// if (this.saveFileDialog1.ShowDialog() != DialogResult.Cancel)
// {
// string SPath = this.saveFileDialog1.FileName;
// for (int i = 0; i < this.dataGridViewDetalleReqDisponibles.Rows.Count; i++)
// {
// codProdTXT = dataGridViewDetalleReqDisponibles.Rows[i].Cells[(int)Col_RequerimientoItem.ARTICULO_ID].Value.ToString().Trim();
// cantidadTXT = Convert.ToInt32(dataGridViewDetalleReqDisponibles.Rows[i].Cells[(int)Col_RequerimientoItem.CANTIDAD].Value);
// itemTXT = codProdTXT + ";" + cantidadTXT + ";" + nroNecesidad;
// Clases.Functions.TextFileAppend(SPath + ".txt", itemTXT);
// }
// }
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// }
//}
#endregion
#region Eventos
private void Frm_OrdenCompraSegunReq_Load(object sender, EventArgs e)
{
//PERMISOS
MenuSistema.Cls_Menus menu = new MenuSistema.Cls_Menus();
menu.ObtenerPermisos(Id_Perfil, Convert.ToInt32(Tag.ToString()), ref lectura, ref escritura, ref elimina);
this.OperacionesDelUsuario();
//calendar
CalendarColumn col = new CalendarColumn();
this.dataGridViewDetalleReqDisponibles.Columns.Add(col);
this.dataGridViewDetalleReqDisponibles.Columns[(int)Col_RequerimientoItem.FECHA_DE_ENTREGA].HeaderText = "Fecha Entrega";
this.dataGridViewDetalleReqDisponibles.Columns[(int)Col_RequerimientoItem.FECHA_DE_ENTREGA].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//TRAE LOS REQUERIMIENTOS
this.Text = "Generación de Ordenes de Compra según Requerimiento Empresa: " + Clases.Usuario.EmpresaLogeada.EmpresaIngresada.ToString();
TraeRequerimientosPendientes();
CargarProveedor(Clases.Usuario.EmpresaLogeada.EmpresaIngresada);
TraerMarcasArticulos();
labelImporteOC.Text = ("0").ToString(culture);
}
void CreateColumn()
{
DataGridViewTextBoxColumn t = new DataGridViewTextBoxColumn();
t.HeaderText = "参照按纽";
t.Name = ColumnNames.buttonColumn.ToString();
DataGridViewComboBoxColumn c = new DataGridViewComboBoxColumn();
c.HeaderText = "formula";
ButtonColumn col = new ButtonColumn();
col.HeaderText = "button";
col.Name = ColumnNames.accountCode.ToString();
col.Width = 300;
CalendarColumn col2 = new CalendarColumn();
this.dgvButton.Columns.AddRange(t, col, c, col2);
}
public void AddCalendar(string ColumnName, string HeaderText)
{
Columns.Remove(ColumnName);
CalendarColumn column_addcalendar = new CalendarColumn();
column_addcalendar.DataPropertyName = ColumnName;
column_addcalendar.Name = ColumnName;
column_addcalendar.HeaderText = HeaderText;
Columns.Add(column_addcalendar);
int j, i;
string[] k;
char a;
a = ',';
k = m_DataColumns.Split(a);
i = k.Length - 1;
j = 0;
while ((j < i) && (k[j].IndexOf(ColumnName) == -1))
{
j = j + 1;
}
Columns[i].DisplayIndex = j;
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(MaterialRation));
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle6 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle15 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle16 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle17 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle8 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle9 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle10 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle11 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle12 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle13 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle14 = new System.Windows.Forms.DataGridViewCellStyle();
this.toolStrip1 = new System.Windows.Forms.ToolStrip();
this.toolStripLabel1 = new System.Windows.Forms.ToolStripLabel();
this.cmb_project = new System.Windows.Forms.ToolStripComboBox();
this.toolStripLabel2 = new System.Windows.Forms.ToolStripLabel();
this.imageList1 = new System.Windows.Forms.ImageList(this.components);
this.contextMenuStrip1 = new System.Windows.Forms.ContextMenuStrip(this.components);
this.导出MEO创建申请单ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
this.审核MEO创建申请单ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
this.calendarColumn1 = new DetailInfo.CalendarColumn();
this.dataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn2 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn3 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn4 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn5 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn6 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn7 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn8 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn9 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn10 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn11 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn12 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.calendarColumn2 = new DetailInfo.CalendarColumn();
this.dataGridViewTextBoxColumn13 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn15 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn16 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn17 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn18 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn19 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn20 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn21 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn22 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn23 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn24 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn25 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn26 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn27 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn28 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn29 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn30 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn31 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn32 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn33 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn34 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn35 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn36 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn37 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn38 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn39 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn40 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn41 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn42 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn43 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn44 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn45 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn46 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn47 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn48 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn49 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn50 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn51 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn52 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dateColumn1 = new DetailInfo.CalendarColumn();
this.remark = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.update_date = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.updator = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.create_date = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.creater = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.information = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.reason_code = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.require_date = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dmssqty = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.require_qty = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.supplycircle = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.updatedate = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.updater = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.createdate = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.creator = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.part_unit = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.contract = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.part_no = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.system_id = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.require_no = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.meolineno = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.require_id = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn14 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.State = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.project_id = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.btn_query = new System.Windows.Forms.Button();
this.label17 = new System.Windows.Forms.Label();
this.cmb_reason = new System.Windows.Forms.ComboBox();
this.label16 = new System.Windows.Forms.Label();
this.textBox1 = new System.Windows.Forms.TextBox();
this.btn_queryERP = new System.Windows.Forms.Button();
this.btn_export = new System.Windows.Forms.Button();
this.label15 = new System.Windows.Forms.Label();
this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker();
this.label13 = new System.Windows.Forms.Label();
this.dateTimePicker2 = new System.Windows.Forms.DateTimePicker();
this.label11 = new System.Windows.Forms.Label();
this.label10 = new System.Windows.Forms.Label();
this.dateTimePicker3 = new System.Windows.Forms.DateTimePicker();
this.dateTimePicker4 = new System.Windows.Forms.DateTimePicker();
this.button3 = new System.Windows.Forms.Button();
this.label8 = new System.Windows.Forms.Label();
this.cmb_state = new System.Windows.Forms.ComboBox();
this.button2 = new System.Windows.Forms.Button();
this.label7 = new System.Windows.Forms.Label();
this.txt_meono = new System.Windows.Forms.TextBox();
this.label23 = new System.Windows.Forms.Label();
this.label22 = new System.Windows.Forms.Label();
this.label21 = new System.Windows.Forms.Label();
this.textBox5 = new System.Windows.Forms.TextBox();
this.label12 = new System.Windows.Forms.Label();
this.textBox4 = new System.Windows.Forms.TextBox();
this.textBox3 = new System.Windows.Forms.TextBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.cmb_site2 = new System.Windows.Forms.ComboBox();
this.cmb_discipline2 = new System.Windows.Forms.ComboBox();
this.label25 = new System.Windows.Forms.Label();
this.label24 = new System.Windows.Forms.Label();
this.label20 = new System.Windows.Forms.Label();
this.label19 = new System.Windows.Forms.Label();
this.cmb_partno = new System.Windows.Forms.ComboBox();
this.cmb_partname = new System.Windows.Forms.ComboBox();
this.label18 = new System.Windows.Forms.Label();
this.tb_manual = new System.Windows.Forms.TextBox();
this.label26 = new System.Windows.Forms.Label();
this.txt_creator = new System.Windows.Forms.TextBox();
this.tabPage1 = new System.Windows.Forms.TabPage();
this.groupBox4 = new System.Windows.Forms.GroupBox();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.dgv1 = new System.Windows.Forms.DataGridView();
this.行 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.Ration_id = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dt_qy = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dt_fx = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dt_zy = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dt_zl = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.零件号 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.零件描述 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.total_qty = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.meo_qty = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.left_qty = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.reserved_qty = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.需求数量 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.单位 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.MEO_ERP = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.txt_drawingno = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.blockid = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.需求日期 = new DetailInfo.CalendarColumn();
this.备注 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.MEO_ID = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.label9 = new System.Windows.Forms.Label();
this.cmb_block = new System.Windows.Forms.ComboBox();
this.label3 = new System.Windows.Forms.Label();
this.tb_discipline = new System.Windows.Forms.TextBox();
this.tb_type = new System.Windows.Forms.TextBox();
this.cmb_discipline = new System.Windows.Forms.ComboBox();
this.label6 = new System.Windows.Forms.Label();
this.btn_select = new System.Windows.Forms.Button();
this.tb_fx = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.tb_area = new System.Windows.Forms.TextBox();
this.label4 = new System.Windows.Forms.Label();
this.label1 = new System.Windows.Forms.Label();
this.button1 = new System.Windows.Forms.Button();
this.btn_new = new System.Windows.Forms.Button();
this.cmb_site = new System.Windows.Forms.ComboBox();
this.label14 = new System.Windows.Forms.Label();
this.btn_del = new System.Windows.Forms.Button();
this.btn_save = new System.Windows.Forms.Button();
this.label2 = new System.Windows.Forms.Label();
this.tabControl1 = new System.Windows.Forms.TabControl();
this.toolStrip1.SuspendLayout();
this.contextMenuStrip1.SuspendLayout();
this.tabPage1.SuspendLayout();
this.groupBox4.SuspendLayout();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dgv1)).BeginInit();
this.groupBox1.SuspendLayout();
this.tabControl1.SuspendLayout();
this.SuspendLayout();
//
// toolStrip1
//
this.toolStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
this.toolStripLabel1,
this.cmb_project,
this.toolStripLabel2});
this.toolStrip1.Location = new System.Drawing.Point(0, 0);
this.toolStrip1.Name = "toolStrip1";
this.toolStrip1.Size = new System.Drawing.Size(1046, 25);
this.toolStrip1.TabIndex = 5;
this.toolStrip1.Text = "toolStrip1";
//
// toolStripLabel1
//
this.toolStripLabel1.Name = "toolStripLabel1";
this.toolStripLabel1.Size = new System.Drawing.Size(65, 22);
this.toolStripLabel1.Text = "请选择项目";
//
// cmb_project
//
this.cmb_project.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cmb_project.Name = "cmb_project";
this.cmb_project.Size = new System.Drawing.Size(400, 25);
this.cmb_project.SelectedIndexChanged += new System.EventHandler(this.cmb_project_SelectedIndexChanged);
//
// toolStripLabel2
//
this.toolStripLabel2.ForeColor = System.Drawing.Color.Red;
this.toolStripLabel2.Name = "toolStripLabel2";
this.toolStripLabel2.Size = new System.Drawing.Size(11, 22);
this.toolStripLabel2.Text = "*";
//
// imageList1
//
this.imageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream")));
this.imageList1.TransparentColor = System.Drawing.Color.Transparent;
this.imageList1.Images.SetKeyName(0, "系统图标.ico");
this.imageList1.Images.SetKeyName(1, "folder_documents.png");
this.imageList1.Images.SetKeyName(2, "kappfinder.png");
this.imageList1.Images.SetKeyName(3, "kpersonalizer.png");
this.imageList1.Images.SetKeyName(4, "Rank.ico");
this.imageList1.Images.SetKeyName(5, "20090314152858Z1.jpg");
//
// contextMenuStrip1
//
this.contextMenuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
this.导出MEO创建申请单ToolStripMenuItem,
this.审核MEO创建申请单ToolStripMenuItem});
this.contextMenuStrip1.Name = "contextMenuStrip1";
this.contextMenuStrip1.Size = new System.Drawing.Size(173, 48);
//
// 导出MEO创建申请单ToolStripMenuItem
//
this.导出MEO创建申请单ToolStripMenuItem.Name = "导出MEO创建申请单ToolStripMenuItem";
this.导出MEO创建申请单ToolStripMenuItem.Size = new System.Drawing.Size(172, 22);
this.导出MEO创建申请单ToolStripMenuItem.Text = "导出MEO创建申请单";
this.导出MEO创建申请单ToolStripMenuItem.Click += new System.EventHandler(this.导出MEO创建申请单ToolStripMenuItem_Click);
//
// 审核MEO创建申请单ToolStripMenuItem
//
this.审核MEO创建申请单ToolStripMenuItem.Name = "审核MEO创建申请单ToolStripMenuItem";
this.审核MEO创建申请单ToolStripMenuItem.Size = new System.Drawing.Size(172, 22);
this.审核MEO创建申请单ToolStripMenuItem.Text = "审核MEO创建申请单";
this.审核MEO创建申请单ToolStripMenuItem.Click += new System.EventHandler(this.审核MEO创建申请单ToolStripMenuItem_Click);
//
// calendarColumn1
//
this.calendarColumn1.HeaderText = "需求日期";
this.calendarColumn1.Name = "calendarColumn1";
this.calendarColumn1.Width = 42;
//
// dataGridViewTextBoxColumn1
//
this.dataGridViewTextBoxColumn1.HeaderText = "行";
this.dataGridViewTextBoxColumn1.Name = "dataGridViewTextBoxColumn1";
this.dataGridViewTextBoxColumn1.ReadOnly = true;
this.dataGridViewTextBoxColumn1.Width = 42;
//
// dataGridViewTextBoxColumn2
//
this.dataGridViewTextBoxColumn2.HeaderText = "序号";
this.dataGridViewTextBoxColumn2.Name = "dataGridViewTextBoxColumn2";
this.dataGridViewTextBoxColumn2.ReadOnly = true;
this.dataGridViewTextBoxColumn2.Width = 51;
//
// dataGridViewTextBoxColumn3
//
this.dataGridViewTextBoxColumn3.HeaderText = "零件号";
this.dataGridViewTextBoxColumn3.Name = "dataGridViewTextBoxColumn3";
this.dataGridViewTextBoxColumn3.ReadOnly = true;
this.dataGridViewTextBoxColumn3.Width = 61;
//
// dataGridViewTextBoxColumn4
//
dataGridViewCellStyle1.BackColor = System.Drawing.SystemColors.Window;
this.dataGridViewTextBoxColumn4.DefaultCellStyle = dataGridViewCellStyle1;
this.dataGridViewTextBoxColumn4.HeaderText = "零件类型";
this.dataGridViewTextBoxColumn4.Name = "dataGridViewTextBoxColumn4";
this.dataGridViewTextBoxColumn4.ReadOnly = true;
this.dataGridViewTextBoxColumn4.Width = 61;
//
// dataGridViewTextBoxColumn5
//
dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Window;
this.dataGridViewTextBoxColumn5.DefaultCellStyle = dataGridViewCellStyle2;
this.dataGridViewTextBoxColumn5.HeaderText = "零件规格";
this.dataGridViewTextBoxColumn5.Name = "dataGridViewTextBoxColumn5";
this.dataGridViewTextBoxColumn5.ReadOnly = true;
this.dataGridViewTextBoxColumn5.Width = 61;
//
// dataGridViewTextBoxColumn6
//
this.dataGridViewTextBoxColumn6.HeaderText = "预估数量";
this.dataGridViewTextBoxColumn6.Name = "dataGridViewTextBoxColumn6";
this.dataGridViewTextBoxColumn6.ReadOnly = true;
this.dataGridViewTextBoxColumn6.Width = 61;
//
// dataGridViewTextBoxColumn7
//
this.dataGridViewTextBoxColumn7.HeaderText = "项目内库存量";
this.dataGridViewTextBoxColumn7.Name = "dataGridViewTextBoxColumn7";
this.dataGridViewTextBoxColumn7.ReadOnly = true;
this.dataGridViewTextBoxColumn7.Width = 72;
//
// dataGridViewTextBoxColumn8
//
this.dataGridViewTextBoxColumn8.HeaderText = "积压库存";
this.dataGridViewTextBoxColumn8.Name = "dataGridViewTextBoxColumn8";
this.dataGridViewTextBoxColumn8.ReadOnly = true;
this.dataGridViewTextBoxColumn8.Width = 61;
//
// dataGridViewTextBoxColumn9
//
dataGridViewCellStyle3.ForeColor = System.Drawing.Color.Firebrick;
this.dataGridViewTextBoxColumn9.DefaultCellStyle = dataGridViewCellStyle3;
this.dataGridViewTextBoxColumn9.HeaderText = "已申请数量";
this.dataGridViewTextBoxColumn9.Name = "dataGridViewTextBoxColumn9";
this.dataGridViewTextBoxColumn9.ReadOnly = true;
this.dataGridViewTextBoxColumn9.Width = 72;
//
// dataGridViewTextBoxColumn10
//
dataGridViewCellStyle4.ForeColor = System.Drawing.Color.Firebrick;
this.dataGridViewTextBoxColumn10.DefaultCellStyle = dataGridViewCellStyle4;
this.dataGridViewTextBoxColumn10.HeaderText = "申请数量";
this.dataGridViewTextBoxColumn10.Name = "dataGridViewTextBoxColumn10";
this.dataGridViewTextBoxColumn10.ReadOnly = true;
this.dataGridViewTextBoxColumn10.Width = 61;
//
// dataGridViewTextBoxColumn11
//
dataGridViewCellStyle5.BackColor = System.Drawing.SystemColors.Window;
this.dataGridViewTextBoxColumn11.DefaultCellStyle = dataGridViewCellStyle5;
this.dataGridViewTextBoxColumn11.HeaderText = "单位";
this.dataGridViewTextBoxColumn11.Name = "dataGridViewTextBoxColumn11";
this.dataGridViewTextBoxColumn11.ReadOnly = true;
this.dataGridViewTextBoxColumn11.Width = 51;
//
// dataGridViewTextBoxColumn12
//
this.dataGridViewTextBoxColumn12.HeaderText = "ERPMEO号";
this.dataGridViewTextBoxColumn12.Name = "dataGridViewTextBoxColumn12";
this.dataGridViewTextBoxColumn12.Visible = false;
this.dataGridViewTextBoxColumn12.Width = 72;
//
// calendarColumn2
//
this.calendarColumn2.HeaderText = "需求日期";
this.calendarColumn2.Name = "calendarColumn2";
this.calendarColumn2.Width = 42;
//
// dataGridViewTextBoxColumn13
//
this.dataGridViewTextBoxColumn13.DataPropertyName = "project_id";
this.dataGridViewTextBoxColumn13.Frozen = true;
this.dataGridViewTextBoxColumn13.HeaderText = "MEO_ID";
this.dataGridViewTextBoxColumn13.Name = "dataGridViewTextBoxColumn13";
this.dataGridViewTextBoxColumn13.ReadOnly = true;
this.dataGridViewTextBoxColumn13.Visible = false;
this.dataGridViewTextBoxColumn13.Width = 66;
//
// dataGridViewTextBoxColumn15
//
this.dataGridViewTextBoxColumn15.DataPropertyName = "approveflag";
this.dataGridViewTextBoxColumn15.Frozen = true;
this.dataGridViewTextBoxColumn15.HeaderText = "审核";
this.dataGridViewTextBoxColumn15.Name = "dataGridViewTextBoxColumn15";
this.dataGridViewTextBoxColumn15.ReadOnly = true;
this.dataGridViewTextBoxColumn15.Width = 54;
//
// dataGridViewTextBoxColumn16
//
this.dataGridViewTextBoxColumn16.DataPropertyName = "require_id";
this.dataGridViewTextBoxColumn16.HeaderText = "MEOID";
this.dataGridViewTextBoxColumn16.Name = "dataGridViewTextBoxColumn16";
this.dataGridViewTextBoxColumn16.ReadOnly = true;
this.dataGridViewTextBoxColumn16.Visible = false;
this.dataGridViewTextBoxColumn16.Width = 60;
//
// dataGridViewTextBoxColumn17
//
this.dataGridViewTextBoxColumn17.DataPropertyName = "meolineno";
this.dataGridViewTextBoxColumn17.Frozen = true;
this.dataGridViewTextBoxColumn17.HeaderText = "meolineno";
this.dataGridViewTextBoxColumn17.Name = "dataGridViewTextBoxColumn17";
this.dataGridViewTextBoxColumn17.ReadOnly = true;
this.dataGridViewTextBoxColumn17.Visible = false;
this.dataGridViewTextBoxColumn17.Width = 84;
//
// dataGridViewTextBoxColumn18
//
this.dataGridViewTextBoxColumn18.DataPropertyName = "require_no";
this.dataGridViewTextBoxColumn18.Frozen = true;
this.dataGridViewTextBoxColumn18.HeaderText = "MEO手工号";
this.dataGridViewTextBoxColumn18.Name = "dataGridViewTextBoxColumn18";
this.dataGridViewTextBoxColumn18.ReadOnly = true;
this.dataGridViewTextBoxColumn18.Width = 84;
//
// dataGridViewTextBoxColumn19
//
this.dataGridViewTextBoxColumn19.DataPropertyName = "system_id";
this.dataGridViewTextBoxColumn19.HeaderText = "系统ID";
this.dataGridViewTextBoxColumn19.Name = "dataGridViewTextBoxColumn19";
this.dataGridViewTextBoxColumn19.ReadOnly = true;
this.dataGridViewTextBoxColumn19.Visible = false;
this.dataGridViewTextBoxColumn19.Width = 66;
//
// dataGridViewTextBoxColumn20
//
this.dataGridViewTextBoxColumn20.DataPropertyName = "id";
this.dataGridViewTextBoxColumn20.HeaderText = "零件ID";
this.dataGridViewTextBoxColumn20.Name = "dataGridViewTextBoxColumn20";
this.dataGridViewTextBoxColumn20.ReadOnly = true;
this.dataGridViewTextBoxColumn20.Visible = false;
this.dataGridViewTextBoxColumn20.Width = 66;
//
// dataGridViewTextBoxColumn21
//
this.dataGridViewTextBoxColumn21.DataPropertyName = "part_no";
this.dataGridViewTextBoxColumn21.Frozen = true;
this.dataGridViewTextBoxColumn21.HeaderText = "零件编码";
this.dataGridViewTextBoxColumn21.Name = "dataGridViewTextBoxColumn21";
this.dataGridViewTextBoxColumn21.ReadOnly = true;
this.dataGridViewTextBoxColumn21.Width = 78;
//
// dataGridViewTextBoxColumn22
//
this.dataGridViewTextBoxColumn22.DataPropertyName = "part_type";
this.dataGridViewTextBoxColumn22.HeaderText = "零件名称";
this.dataGridViewTextBoxColumn22.Name = "dataGridViewTextBoxColumn22";
this.dataGridViewTextBoxColumn22.ReadOnly = true;
this.dataGridViewTextBoxColumn22.Width = 78;
//
// dataGridViewTextBoxColumn23
//
this.dataGridViewTextBoxColumn23.DataPropertyName = "part_spec";
this.dataGridViewTextBoxColumn23.HeaderText = "零件规格";
this.dataGridViewTextBoxColumn23.Name = "dataGridViewTextBoxColumn23";
this.dataGridViewTextBoxColumn23.ReadOnly = true;
this.dataGridViewTextBoxColumn23.Width = 78;
//
// dataGridViewTextBoxColumn24
//
this.dataGridViewTextBoxColumn24.DataPropertyName = "part_size_stand";
this.dataGridViewTextBoxColumn24.HeaderText = "尺寸标准";
this.dataGridViewTextBoxColumn24.Name = "dataGridViewTextBoxColumn24";
this.dataGridViewTextBoxColumn24.ReadOnly = true;
this.dataGridViewTextBoxColumn24.Width = 78;
//
// dataGridViewTextBoxColumn25
//
this.dataGridViewTextBoxColumn25.DataPropertyName = "parentid";
this.dataGridViewTextBoxColumn25.HeaderText = "零件类ID";
this.dataGridViewTextBoxColumn25.Name = "dataGridViewTextBoxColumn25";
this.dataGridViewTextBoxColumn25.ReadOnly = true;
this.dataGridViewTextBoxColumn25.Visible = false;
this.dataGridViewTextBoxColumn25.Width = 78;
//
// dataGridViewTextBoxColumn26
//
this.dataGridViewTextBoxColumn26.DataPropertyName = "contract";
this.dataGridViewTextBoxColumn26.HeaderText = "所属域";
this.dataGridViewTextBoxColumn26.Name = "dataGridViewTextBoxColumn26";
this.dataGridViewTextBoxColumn26.ReadOnly = true;
this.dataGridViewTextBoxColumn26.Width = 66;
//
// dataGridViewTextBoxColumn27
//
this.dataGridViewTextBoxColumn27.DataPropertyName = "part_mat";
this.dataGridViewTextBoxColumn27.HeaderText = "材质";
this.dataGridViewTextBoxColumn27.Name = "dataGridViewTextBoxColumn27";
this.dataGridViewTextBoxColumn27.ReadOnly = true;
this.dataGridViewTextBoxColumn27.Width = 54;
//
// dataGridViewTextBoxColumn28
//
this.dataGridViewTextBoxColumn28.DataPropertyName = "part_cert";
this.dataGridViewTextBoxColumn28.HeaderText = "零件证书";
this.dataGridViewTextBoxColumn28.Name = "dataGridViewTextBoxColumn28";
this.dataGridViewTextBoxColumn28.ReadOnly = true;
this.dataGridViewTextBoxColumn28.Width = 78;
//
// dataGridViewTextBoxColumn29
//
this.dataGridViewTextBoxColumn29.DataPropertyName = "part_unit";
this.dataGridViewTextBoxColumn29.HeaderText = "单位";
this.dataGridViewTextBoxColumn29.Name = "dataGridViewTextBoxColumn29";
this.dataGridViewTextBoxColumn29.ReadOnly = true;
this.dataGridViewTextBoxColumn29.Width = 54;
//
// dataGridViewTextBoxColumn30
//
this.dataGridViewTextBoxColumn30.DataPropertyName = "part_unitdensity";
this.dataGridViewTextBoxColumn30.HeaderText = "单位密度";
this.dataGridViewTextBoxColumn30.Name = "dataGridViewTextBoxColumn30";
this.dataGridViewTextBoxColumn30.ReadOnly = true;
this.dataGridViewTextBoxColumn30.Width = 78;
//
// dataGridViewTextBoxColumn31
//
this.dataGridViewTextBoxColumn31.DataPropertyName = "part_densityunit";
this.dataGridViewTextBoxColumn31.HeaderText = "密度单位";
this.dataGridViewTextBoxColumn31.Name = "dataGridViewTextBoxColumn31";
this.dataGridViewTextBoxColumn31.ReadOnly = true;
this.dataGridViewTextBoxColumn31.Width = 78;
//
// dataGridViewTextBoxColumn32
//
this.dataGridViewTextBoxColumn32.DataPropertyName = "part_level";
this.dataGridViewTextBoxColumn32.HeaderText = "零件级别";
this.dataGridViewTextBoxColumn32.Name = "dataGridViewTextBoxColumn32";
this.dataGridViewTextBoxColumn32.ReadOnly = true;
this.dataGridViewTextBoxColumn32.Width = 78;
//
// dataGridViewTextBoxColumn33
//
this.dataGridViewTextBoxColumn33.DataPropertyName = "part_spec1";
this.dataGridViewTextBoxColumn33.HeaderText = "规格1";
this.dataGridViewTextBoxColumn33.Name = "dataGridViewTextBoxColumn33";
this.dataGridViewTextBoxColumn33.ReadOnly = true;
this.dataGridViewTextBoxColumn33.Visible = false;
this.dataGridViewTextBoxColumn33.Width = 60;
//
// dataGridViewTextBoxColumn34
//
this.dataGridViewTextBoxColumn34.DataPropertyName = "part_spec2";
this.dataGridViewTextBoxColumn34.HeaderText = "规格2";
this.dataGridViewTextBoxColumn34.Name = "dataGridViewTextBoxColumn34";
this.dataGridViewTextBoxColumn34.ReadOnly = true;
this.dataGridViewTextBoxColumn34.Visible = false;
this.dataGridViewTextBoxColumn34.Width = 60;
//
// dataGridViewTextBoxColumn35
//
this.dataGridViewTextBoxColumn35.DataPropertyName = "part_spec3";
this.dataGridViewTextBoxColumn35.HeaderText = "规格3";
this.dataGridViewTextBoxColumn35.Name = "dataGridViewTextBoxColumn35";
this.dataGridViewTextBoxColumn35.ReadOnly = true;
this.dataGridViewTextBoxColumn35.Visible = false;
this.dataGridViewTextBoxColumn35.Width = 60;
//
// dataGridViewTextBoxColumn36
//
this.dataGridViewTextBoxColumn36.DataPropertyName = "part_spec4";
this.dataGridViewTextBoxColumn36.HeaderText = "规格4";
this.dataGridViewTextBoxColumn36.Name = "dataGridViewTextBoxColumn36";
this.dataGridViewTextBoxColumn36.ReadOnly = true;
this.dataGridViewTextBoxColumn36.Visible = false;
this.dataGridViewTextBoxColumn36.Width = 60;
//
// dataGridViewTextBoxColumn37
//
this.dataGridViewTextBoxColumn37.DataPropertyName = "part_spec5";
this.dataGridViewTextBoxColumn37.HeaderText = "规格5";
this.dataGridViewTextBoxColumn37.Name = "dataGridViewTextBoxColumn37";
this.dataGridViewTextBoxColumn37.ReadOnly = true;
this.dataGridViewTextBoxColumn37.Visible = false;
this.dataGridViewTextBoxColumn37.Width = 60;
//
// dataGridViewTextBoxColumn38
//
this.dataGridViewTextBoxColumn38.DataPropertyName = "creator";
this.dataGridViewTextBoxColumn38.HeaderText = "创建人";
this.dataGridViewTextBoxColumn38.Name = "dataGridViewTextBoxColumn38";
this.dataGridViewTextBoxColumn38.ReadOnly = true;
this.dataGridViewTextBoxColumn38.Visible = false;
this.dataGridViewTextBoxColumn38.Width = 66;
//
// dataGridViewTextBoxColumn39
//
this.dataGridViewTextBoxColumn39.DataPropertyName = "createdate";
this.dataGridViewTextBoxColumn39.HeaderText = "创建日期";
this.dataGridViewTextBoxColumn39.Name = "dataGridViewTextBoxColumn39";
this.dataGridViewTextBoxColumn39.ReadOnly = true;
this.dataGridViewTextBoxColumn39.Visible = false;
this.dataGridViewTextBoxColumn39.Width = 78;
//
// dataGridViewTextBoxColumn40
//
this.dataGridViewTextBoxColumn40.DataPropertyName = "updater";
this.dataGridViewTextBoxColumn40.HeaderText = "更新人";
this.dataGridViewTextBoxColumn40.Name = "dataGridViewTextBoxColumn40";
this.dataGridViewTextBoxColumn40.ReadOnly = true;
this.dataGridViewTextBoxColumn40.Visible = false;
this.dataGridViewTextBoxColumn40.Width = 66;
//
// dataGridViewTextBoxColumn41
//
this.dataGridViewTextBoxColumn41.DataPropertyName = "updatedate";
this.dataGridViewTextBoxColumn41.HeaderText = "更新日期";
this.dataGridViewTextBoxColumn41.Name = "dataGridViewTextBoxColumn41";
this.dataGridViewTextBoxColumn41.ReadOnly = true;
this.dataGridViewTextBoxColumn41.Visible = false;
this.dataGridViewTextBoxColumn41.Width = 78;
//
// dataGridViewTextBoxColumn42
//
this.dataGridViewTextBoxColumn42.DataPropertyName = "supplycircle";
this.dataGridViewTextBoxColumn42.HeaderText = "采购周期";
this.dataGridViewTextBoxColumn42.Name = "dataGridViewTextBoxColumn42";
this.dataGridViewTextBoxColumn42.ReadOnly = true;
this.dataGridViewTextBoxColumn42.Width = 78;
//
// dataGridViewTextBoxColumn43
//
this.dataGridViewTextBoxColumn43.DataPropertyName = "require_qty";
this.dataGridViewTextBoxColumn43.HeaderText = "申请数量";
this.dataGridViewTextBoxColumn43.Name = "dataGridViewTextBoxColumn43";
this.dataGridViewTextBoxColumn43.ReadOnly = true;
this.dataGridViewTextBoxColumn43.Width = 78;
//
// dataGridViewTextBoxColumn44
//
this.dataGridViewTextBoxColumn44.DataPropertyName = "dmssqty";
this.dataGridViewTextBoxColumn44.HeaderText = "已下发数量";
this.dataGridViewTextBoxColumn44.Name = "dataGridViewTextBoxColumn44";
this.dataGridViewTextBoxColumn44.ReadOnly = true;
this.dataGridViewTextBoxColumn44.Width = 90;
//
// dataGridViewTextBoxColumn45
//
this.dataGridViewTextBoxColumn45.DataPropertyName = "require_date";
this.dataGridViewTextBoxColumn45.HeaderText = "需求日期";
this.dataGridViewTextBoxColumn45.Name = "dataGridViewTextBoxColumn45";
this.dataGridViewTextBoxColumn45.ReadOnly = true;
this.dataGridViewTextBoxColumn45.Width = 78;
//
// dataGridViewTextBoxColumn46
//
this.dataGridViewTextBoxColumn46.DataPropertyName = "reason_code";
this.dataGridViewTextBoxColumn46.HeaderText = "申请原因";
this.dataGridViewTextBoxColumn46.Name = "dataGridViewTextBoxColumn46";
this.dataGridViewTextBoxColumn46.ReadOnly = true;
this.dataGridViewTextBoxColumn46.Width = 78;
//
// dataGridViewTextBoxColumn47
//
this.dataGridViewTextBoxColumn47.DataPropertyName = "information";
this.dataGridViewTextBoxColumn47.HeaderText = "备注";
this.dataGridViewTextBoxColumn47.Name = "dataGridViewTextBoxColumn47";
this.dataGridViewTextBoxColumn47.ReadOnly = true;
this.dataGridViewTextBoxColumn47.Visible = false;
this.dataGridViewTextBoxColumn47.Width = 54;
//
// dataGridViewTextBoxColumn48
//
this.dataGridViewTextBoxColumn48.DataPropertyName = "creater";
this.dataGridViewTextBoxColumn48.HeaderText = "申请人";
this.dataGridViewTextBoxColumn48.Name = "dataGridViewTextBoxColumn48";
this.dataGridViewTextBoxColumn48.ReadOnly = true;
this.dataGridViewTextBoxColumn48.Width = 66;
//
// dataGridViewTextBoxColumn49
//
this.dataGridViewTextBoxColumn49.DataPropertyName = "create_date";
this.dataGridViewTextBoxColumn49.HeaderText = "申请日期";
this.dataGridViewTextBoxColumn49.Name = "dataGridViewTextBoxColumn49";
this.dataGridViewTextBoxColumn49.ReadOnly = true;
this.dataGridViewTextBoxColumn49.Width = 78;
//
// dataGridViewTextBoxColumn50
//
this.dataGridViewTextBoxColumn50.DataPropertyName = "updator";
this.dataGridViewTextBoxColumn50.HeaderText = "更新人";
this.dataGridViewTextBoxColumn50.Name = "dataGridViewTextBoxColumn50";
this.dataGridViewTextBoxColumn50.ReadOnly = true;
this.dataGridViewTextBoxColumn50.Width = 66;
//
// dataGridViewTextBoxColumn51
//
this.dataGridViewTextBoxColumn51.DataPropertyName = "update_date";
this.dataGridViewTextBoxColumn51.HeaderText = "更新日期";
this.dataGridViewTextBoxColumn51.Name = "dataGridViewTextBoxColumn51";
this.dataGridViewTextBoxColumn51.ReadOnly = true;
this.dataGridViewTextBoxColumn51.Visible = false;
this.dataGridViewTextBoxColumn51.Width = 78;
//
// dataGridViewTextBoxColumn52
//
this.dataGridViewTextBoxColumn52.DataPropertyName = "remark";
this.dataGridViewTextBoxColumn52.HeaderText = "申请备注";
this.dataGridViewTextBoxColumn52.Name = "dataGridViewTextBoxColumn52";
this.dataGridViewTextBoxColumn52.ReadOnly = true;
this.dataGridViewTextBoxColumn52.Width = 78;
//
// dateColumn1
//
this.dateColumn1.HeaderText = "需求日期";
this.dateColumn1.Name = "dateColumn1";
this.dateColumn1.Width = 42;
//
// remark
//
this.remark.DataPropertyName = "remark";
this.remark.HeaderText = "申请备注";
this.remark.Name = "remark";
this.remark.ReadOnly = true;
this.remark.Width = 78;
//
// update_date
//
this.update_date.DataPropertyName = "update_date";
this.update_date.HeaderText = "更新日期";
this.update_date.Name = "update_date";
this.update_date.ReadOnly = true;
this.update_date.Visible = false;
this.update_date.Width = 78;
//
// updator
//
this.updator.DataPropertyName = "updator";
this.updator.HeaderText = "更新人";
this.updator.Name = "updator";
this.updator.ReadOnly = true;
this.updator.Width = 66;
//
// create_date
//
this.create_date.DataPropertyName = "create_date";
this.create_date.HeaderText = "申请日期";
this.create_date.Name = "create_date";
this.create_date.ReadOnly = true;
this.create_date.Width = 78;
//
// creater
//
this.creater.DataPropertyName = "creater";
this.creater.HeaderText = "申请人";
this.creater.Name = "creater";
this.creater.ReadOnly = true;
this.creater.Width = 66;
//
// information
//
this.information.DataPropertyName = "information";
this.information.HeaderText = "备注";
this.information.Name = "information";
this.information.ReadOnly = true;
this.information.Visible = false;
this.information.Width = 54;
//
// reason_code
//
this.reason_code.DataPropertyName = "reason_code";
this.reason_code.HeaderText = "申请原因";
this.reason_code.Name = "reason_code";
this.reason_code.ReadOnly = true;
this.reason_code.Width = 78;
//
// require_date
//
this.require_date.DataPropertyName = "require_date";
this.require_date.HeaderText = "需求日期";
this.require_date.Name = "require_date";
this.require_date.ReadOnly = true;
this.require_date.Width = 78;
//
// dmssqty
//
this.dmssqty.DataPropertyName = "dmssqty";
this.dmssqty.HeaderText = "已下发数量";
this.dmssqty.Name = "dmssqty";
this.dmssqty.ReadOnly = true;
this.dmssqty.Width = 90;
//
// require_qty
//
this.require_qty.DataPropertyName = "require_qty";
this.require_qty.HeaderText = "申请数量";
this.require_qty.Name = "require_qty";
this.require_qty.ReadOnly = true;
this.require_qty.Width = 78;
//
// supplycircle
//
this.supplycircle.DataPropertyName = "supplycircle";
this.supplycircle.HeaderText = "采购周期";
this.supplycircle.Name = "supplycircle";
this.supplycircle.ReadOnly = true;
this.supplycircle.Width = 78;
//
// updatedate
//
this.updatedate.DataPropertyName = "updatedate";
this.updatedate.HeaderText = "更新日期";
this.updatedate.Name = "updatedate";
this.updatedate.ReadOnly = true;
this.updatedate.Visible = false;
this.updatedate.Width = 78;
//
// updater
//
this.updater.DataPropertyName = "updater";
this.updater.HeaderText = "更新人";
this.updater.Name = "updater";
this.updater.ReadOnly = true;
this.updater.Visible = false;
this.updater.Width = 66;
//
// createdate
//
this.createdate.DataPropertyName = "createdate";
this.createdate.HeaderText = "创建日期";
this.createdate.Name = "createdate";
this.createdate.ReadOnly = true;
this.createdate.Visible = false;
this.createdate.Width = 78;
//
// creator
//
this.creator.DataPropertyName = "creator";
this.creator.HeaderText = "创建人";
this.creator.Name = "creator";
this.creator.ReadOnly = true;
this.creator.Visible = false;
this.creator.Width = 66;
//
// part_unit
//
this.part_unit.DataPropertyName = "unit_meas";
this.part_unit.HeaderText = "单位";
this.part_unit.Name = "part_unit";
this.part_unit.ReadOnly = true;
this.part_unit.Width = 54;
//
// contract
//
this.contract.DataPropertyName = "contract";
this.contract.HeaderText = "所属域";
this.contract.Name = "contract";
this.contract.ReadOnly = true;
this.contract.Width = 66;
//
// part_no
//
this.part_no.DataPropertyName = "part_no";
this.part_no.Frozen = true;
this.part_no.HeaderText = "零件编码";
this.part_no.Name = "part_no";
this.part_no.ReadOnly = true;
this.part_no.Width = 78;
//
// system_id
//
this.system_id.DataPropertyName = "system_id";
this.system_id.Frozen = true;
this.system_id.HeaderText = "区域";
this.system_id.Name = "system_id";
this.system_id.ReadOnly = true;
this.system_id.Visible = false;
this.system_id.Width = 54;
//
// require_no
//
this.require_no.DataPropertyName = "require_no";
this.require_no.Frozen = true;
this.require_no.HeaderText = "MEO手工号";
this.require_no.Name = "require_no";
this.require_no.ReadOnly = true;
this.require_no.Width = 84;
//
// meolineno
//
this.meolineno.DataPropertyName = "meolineno";
this.meolineno.Frozen = true;
this.meolineno.HeaderText = "meolineno";
this.meolineno.Name = "meolineno";
this.meolineno.ReadOnly = true;
this.meolineno.Visible = false;
this.meolineno.Width = 84;
//
// require_id
//
this.require_id.DataPropertyName = "require_id";
this.require_id.Frozen = true;
this.require_id.HeaderText = "MEOID";
this.require_id.Name = "require_id";
this.require_id.ReadOnly = true;
this.require_id.Visible = false;
this.require_id.Width = 60;
//
// dataGridViewTextBoxColumn14
//
this.dataGridViewTextBoxColumn14.DataPropertyName = "MEO_ERP";
this.dataGridViewTextBoxColumn14.Frozen = true;
this.dataGridViewTextBoxColumn14.HeaderText = "ERP_MEO号";
this.dataGridViewTextBoxColumn14.Name = "dataGridViewTextBoxColumn14";
this.dataGridViewTextBoxColumn14.ReadOnly = true;
this.dataGridViewTextBoxColumn14.Width = 84;
//
// State
//
this.State.DataPropertyName = "state";
this.State.Frozen = true;
this.State.HeaderText = "状态";
this.State.Name = "State";
this.State.ReadOnly = true;
this.State.Resizable = System.Windows.Forms.DataGridViewTriState.True;
this.State.Width = 54;
//
// project_id
//
this.project_id.DataPropertyName = "project_id";
this.project_id.Frozen = true;
this.project_id.HeaderText = "项目ID";
this.project_id.Name = "project_id";
this.project_id.ReadOnly = true;
this.project_id.Visible = false;
this.project_id.Width = 66;
//
// btn_query
//
this.btn_query.Location = new System.Drawing.Point(7, 164);
this.btn_query.Name = "btn_query";
this.btn_query.Size = new System.Drawing.Size(73, 23);
this.btn_query.TabIndex = 35;
this.btn_query.Text = "查询(内部)";
this.btn_query.UseVisualStyleBackColor = true;
this.btn_query.Click += new System.EventHandler(this.btn_query_Click);
//
// label17
//
this.label17.AutoSize = true;
this.label17.Location = new System.Drawing.Point(8, 91);
this.label17.Name = "label17";
this.label17.Size = new System.Drawing.Size(53, 12);
this.label17.TabIndex = 38;
//
// cmb_reason
//
this.cmb_reason.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cmb_reason.FormattingEnabled = true;
this.cmb_reason.Location = new System.Drawing.Point(60, 87);
this.cmb_reason.Name = "cmb_reason";
this.cmb_reason.Size = new System.Drawing.Size(180, 20);
this.cmb_reason.TabIndex = 39;
//
// label16
//
this.label16.AutoSize = true;
this.label16.Location = new System.Drawing.Point(480, 42);
this.label16.Name = "label16";
this.label16.Size = new System.Drawing.Size(53, 12);
this.label16.TabIndex = 40;
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(557, 38);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(139, 21);
this.textBox1.TabIndex = 41;
//
// btn_queryERP
//
this.btn_queryERP.Location = new System.Drawing.Point(295, 164);
this.btn_queryERP.Name = "btn_queryERP";
this.btn_queryERP.Size = new System.Drawing.Size(73, 23);
this.btn_queryERP.TabIndex = 42;
this.btn_queryERP.Text = "查询(ERP)";
this.btn_queryERP.UseVisualStyleBackColor = true;
this.btn_queryERP.Visible = false;
this.btn_queryERP.Click += new System.EventHandler(this.btn_queryERP_Click);
//
// btn_export
//
this.btn_export.Location = new System.Drawing.Point(151, 164);
this.btn_export.Name = "btn_export";
this.btn_export.Size = new System.Drawing.Size(73, 23);
this.btn_export.TabIndex = 43;
this.btn_export.Text = "导出";
this.btn_export.UseVisualStyleBackColor = true;
//
// label15
//
this.label15.AutoSize = true;
this.label15.Location = new System.Drawing.Point(8, 115);
this.label15.Name = "label15";
this.label15.Size = new System.Drawing.Size(77, 12);
this.label15.TabIndex = 44;
//
// dateTimePicker1
//
this.dateTimePicker1.Checked = false;
this.dateTimePicker1.CustomFormat = "yyyy-MM-dd";
this.dateTimePicker1.Format = System.Windows.Forms.DateTimePickerFormat.Custom;
this.dateTimePicker1.Location = new System.Drawing.Point(99, 111);
this.dateTimePicker1.Name = "dateTimePicker1";
this.dateTimePicker1.ShowCheckBox = true;
this.dateTimePicker1.Size = new System.Drawing.Size(140, 21);
this.dateTimePicker1.TabIndex = 45;
//
// label13
//
this.label13.AutoSize = true;
this.label13.Location = new System.Drawing.Point(246, 115);
this.label13.Name = "label13";
this.label13.Size = new System.Drawing.Size(77, 12);
this.label13.TabIndex = 46;
//
// dateTimePicker2
//
this.dateTimePicker2.Checked = false;
this.dateTimePicker2.CustomFormat = "yyyy-MM-dd";
this.dateTimePicker2.Format = System.Windows.Forms.DateTimePickerFormat.Custom;
this.dateTimePicker2.Location = new System.Drawing.Point(339, 111);
this.dateTimePicker2.Name = "dateTimePicker2";
this.dateTimePicker2.ShowCheckBox = true;
this.dateTimePicker2.Size = new System.Drawing.Size(136, 21);
this.dateTimePicker2.TabIndex = 47;
//
// label11
//
this.label11.AutoSize = true;
this.label11.Location = new System.Drawing.Point(7, 140);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(77, 12);
this.label11.TabIndex = 48;
//
// label10
//
this.label10.AutoSize = true;
this.label10.Location = new System.Drawing.Point(246, 140);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(77, 12);
this.label10.TabIndex = 49;
//
// dateTimePicker3
//
this.dateTimePicker3.Checked = false;
this.dateTimePicker3.CustomFormat = "yyyy-MM-dd";
this.dateTimePicker3.Format = System.Windows.Forms.DateTimePickerFormat.Custom;
this.dateTimePicker3.Location = new System.Drawing.Point(99, 136);
this.dateTimePicker3.Name = "dateTimePicker3";
this.dateTimePicker3.ShowCheckBox = true;
this.dateTimePicker3.Size = new System.Drawing.Size(140, 21);
this.dateTimePicker3.TabIndex = 50;
//
// dateTimePicker4
//
this.dateTimePicker4.Checked = false;
this.dateTimePicker4.CustomFormat = "yyyy-MM-dd";
this.dateTimePicker4.Format = System.Windows.Forms.DateTimePickerFormat.Custom;
this.dateTimePicker4.Location = new System.Drawing.Point(340, 136);
this.dateTimePicker4.Name = "dateTimePicker4";
this.dateTimePicker4.ShowCheckBox = true;
this.dateTimePicker4.Size = new System.Drawing.Size(135, 21);
this.dateTimePicker4.TabIndex = 51;
//
// button3
//
this.button3.Location = new System.Drawing.Point(223, 164);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(73, 23);
this.button3.TabIndex = 90;
this.button3.Text = "关闭";
this.button3.UseVisualStyleBackColor = true;
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// label8
//
this.label8.AutoSize = true;
this.label8.Location = new System.Drawing.Point(481, 67);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(47, 12);
this.label8.TabIndex = 91;
//
// cmb_state
//
this.cmb_state.FormattingEnabled = true;
this.cmb_state.Items.AddRange(new object[] {
"已审核",
"未审核"});
this.cmb_state.Location = new System.Drawing.Point(557, 63);
this.cmb_state.Name = "cmb_state";
this.cmb_state.Size = new System.Drawing.Size(139, 20);
this.cmb_state.TabIndex = 92;
//
// button2
//
this.button2.Location = new System.Drawing.Point(79, 164);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(73, 23);
this.button2.TabIndex = 93;
this.button2.Text = "保存";
this.button2.UseVisualStyleBackColor = true;
//
// label7
//
this.label7.AutoSize = true;
this.label7.Location = new System.Drawing.Point(480, 18);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(59, 12);
this.label7.TabIndex = 19;
//
// txt_meono
//
this.txt_meono.Location = new System.Drawing.Point(557, 14);
this.txt_meono.Name = "txt_meono";
this.txt_meono.Size = new System.Drawing.Size(139, 21);
this.txt_meono.TabIndex = 94;
//
// label23
//
this.label23.AutoSize = true;
this.label23.Location = new System.Drawing.Point(247, 42);
this.label23.Name = "label23";
this.label23.Size = new System.Drawing.Size(29, 12);
this.label23.TabIndex = 123;
//
// label22
//
this.label22.AutoSize = true;
this.label22.Location = new System.Drawing.Point(6, 42);
this.label22.Name = "label22";
this.label22.Size = new System.Drawing.Size(29, 12);
this.label22.TabIndex = 124;
//
// label21
//
this.label21.AutoSize = true;
this.label21.Location = new System.Drawing.Point(8, 18);
this.label21.Name = "label21";
this.label21.Size = new System.Drawing.Size(29, 12);
this.label21.TabIndex = 125;
//
// textBox5
//
this.textBox5.BackColor = System.Drawing.Color.White;
this.textBox5.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.textBox5.ForeColor = System.Drawing.SystemColors.Desktop;
this.textBox5.Location = new System.Drawing.Point(59, 14);
this.textBox5.Name = "textBox5";
this.textBox5.ReadOnly = true;
this.textBox5.Size = new System.Drawing.Size(180, 21);
this.textBox5.TabIndex = 126;
//
// label12
//
this.label12.AutoSize = true;
this.label12.Location = new System.Drawing.Point(247, 18);
this.label12.Name = "label12";
this.label12.Size = new System.Drawing.Size(29, 12);
this.label12.TabIndex = 127;
//
// textBox4
//
this.textBox4.BackColor = System.Drawing.Color.White;
this.textBox4.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.textBox4.ForeColor = System.Drawing.SystemColors.Desktop;
this.textBox4.Location = new System.Drawing.Point(300, 14);
this.textBox4.Name = "textBox4";
this.textBox4.ReadOnly = true;
this.textBox4.Size = new System.Drawing.Size(174, 21);
this.textBox4.TabIndex = 128;
//
// textBox3
//
this.textBox3.BackColor = System.Drawing.Color.White;
this.textBox3.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.textBox3.ForeColor = System.Drawing.SystemColors.Desktop;
this.textBox3.Location = new System.Drawing.Point(300, 38);
this.textBox3.Name = "textBox3";
this.textBox3.ReadOnly = true;
this.textBox3.Size = new System.Drawing.Size(174, 21);
this.textBox3.TabIndex = 129;
//
// textBox2
//
this.textBox2.BackColor = System.Drawing.Color.White;
this.textBox2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.textBox2.ForeColor = System.Drawing.SystemColors.Desktop;
this.textBox2.Location = new System.Drawing.Point(59, 38);
this.textBox2.Name = "textBox2";
this.textBox2.ReadOnly = true;
this.textBox2.Size = new System.Drawing.Size(180, 21);
this.textBox2.TabIndex = 130;
//
// cmb_site2
//
this.cmb_site2.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cmb_site2.FormattingEnabled = true;
this.cmb_site2.Location = new System.Drawing.Point(59, 63);
this.cmb_site2.Name = "cmb_site2";
this.cmb_site2.Size = new System.Drawing.Size(181, 20);
this.cmb_site2.TabIndex = 131;
//
// cmb_discipline2
//
this.cmb_discipline2.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cmb_discipline2.FormattingEnabled = true;
this.cmb_discipline2.Location = new System.Drawing.Point(300, 63);
this.cmb_discipline2.Name = "cmb_discipline2";
this.cmb_discipline2.Size = new System.Drawing.Size(174, 20);
this.cmb_discipline2.TabIndex = 132;
//
// label25
//
this.label25.AutoSize = true;
this.label25.Location = new System.Drawing.Point(8, 67);
this.label25.Name = "label25";
this.label25.Size = new System.Drawing.Size(17, 12);
this.label25.TabIndex = 133;
//
// label24
//
this.label24.AutoSize = true;
this.label24.Location = new System.Drawing.Point(247, 67);
this.label24.Name = "label24";
this.label24.Size = new System.Drawing.Size(29, 12);
this.label24.TabIndex = 134;
//
// label20
//
this.label20.AutoSize = true;
this.label20.Location = new System.Drawing.Point(247, 91);
this.label20.Name = "label20";
this.label20.Size = new System.Drawing.Size(53, 12);
this.label20.TabIndex = 135;
//
// label19
//
this.label19.AutoSize = true;
this.label19.Location = new System.Drawing.Point(480, 91);
this.label19.Name = "label19";
this.label19.Size = new System.Drawing.Size(53, 12);
this.label19.TabIndex = 136;
//
// cmb_partno
//
this.cmb_partno.FormattingEnabled = true;
this.cmb_partno.Location = new System.Drawing.Point(300, 87);
this.cmb_partno.Name = "cmb_partno";
this.cmb_partno.Size = new System.Drawing.Size(174, 20);
this.cmb_partno.TabIndex = 137;
//
// cmb_partname
//
this.cmb_partname.FormattingEnabled = true;
this.cmb_partname.Location = new System.Drawing.Point(557, 87);
this.cmb_partname.Name = "cmb_partname";
this.cmb_partname.Size = new System.Drawing.Size(139, 20);
this.cmb_partname.TabIndex = 138;
//
// label18
//
this.label18.AutoSize = true;
this.label18.Location = new System.Drawing.Point(482, 115);
this.label18.Name = "label18";
this.label18.Size = new System.Drawing.Size(59, 12);
this.label18.TabIndex = 141;
//
// tb_manual
//
this.tb_manual.Location = new System.Drawing.Point(558, 111);
this.tb_manual.Name = "tb_manual";
this.tb_manual.Size = new System.Drawing.Size(138, 21);
this.tb_manual.TabIndex = 142;
//
// label26
//
this.label26.AutoSize = true;
this.label26.Location = new System.Drawing.Point(482, 140);
this.label26.Name = "label26";
this.label26.Size = new System.Drawing.Size(41, 12);
this.label26.TabIndex = 143;
//
// txt_creator
//
this.txt_creator.Location = new System.Drawing.Point(557, 136);
this.txt_creator.Name = "txt_creator";
this.txt_creator.Size = new System.Drawing.Size(139, 21);
this.txt_creator.TabIndex = 144;
//
// tabPage1
//
this.tabPage1.BackColor = System.Drawing.SystemColors.InactiveCaptionText;
this.tabPage1.Controls.Add(this.groupBox4);
this.tabPage1.Location = new System.Drawing.Point(4, 21);
this.tabPage1.Name = "tabPage1";
this.tabPage1.Padding = new System.Windows.Forms.Padding(3);
this.tabPage1.Size = new System.Drawing.Size(1038, 526);
this.tabPage1.TabIndex = 0;
this.tabPage1.Text = "下发材料";
//
// groupBox4
//
this.groupBox4.Controls.Add(this.groupBox2);
this.groupBox4.Controls.Add(this.groupBox1);
this.groupBox4.Dock = System.Windows.Forms.DockStyle.Fill;
this.groupBox4.Location = new System.Drawing.Point(3, 3);
this.groupBox4.Name = "groupBox4";
this.groupBox4.Size = new System.Drawing.Size(1032, 520);
this.groupBox4.TabIndex = 46;
this.groupBox4.TabStop = false;
//
// groupBox2
//
this.groupBox2.Controls.Add(this.dgv1);
this.groupBox2.Dock = System.Windows.Forms.DockStyle.Fill;
this.groupBox2.Location = new System.Drawing.Point(3, 112);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(1026, 405);
this.groupBox2.TabIndex = 43;
this.groupBox2.TabStop = false;
this.groupBox2.Text = "MSS材料列表";
//
// dgv1
//
this.dgv1.AllowUserToAddRows = false;
this.dgv1.AllowUserToOrderColumns = true;
this.dgv1.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.DisplayedCells;
this.dgv1.AutoSizeRowsMode = System.Windows.Forms.DataGridViewAutoSizeRowsMode.DisplayedCells;
dataGridViewCellStyle6.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
dataGridViewCellStyle6.BackColor = System.Drawing.SystemColors.Control;
dataGridViewCellStyle6.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
dataGridViewCellStyle6.ForeColor = System.Drawing.SystemColors.WindowText;
dataGridViewCellStyle6.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle6.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
dataGridViewCellStyle6.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
this.dgv1.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle6;
this.dgv1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dgv1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.行,
this.Ration_id,
this.dt_qy,
this.dt_fx,
this.dt_zy,
this.dt_zl,
this.零件号,
this.零件描述,
this.total_qty,
this.meo_qty,
this.left_qty,
this.reserved_qty,
this.需求数量,
this.单位,
this.MEO_ERP,
this.txt_drawingno,
this.blockid,
this.需求日期,
this.备注,
this.MEO_ID});
this.dgv1.ContextMenuStrip = this.contextMenuStrip1;
dataGridViewCellStyle15.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
dataGridViewCellStyle15.BackColor = System.Drawing.SystemColors.Window;
dataGridViewCellStyle15.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
dataGridViewCellStyle15.ForeColor = System.Drawing.SystemColors.ControlText;
dataGridViewCellStyle15.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle15.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
dataGridViewCellStyle15.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
this.dgv1.DefaultCellStyle = dataGridViewCellStyle15;
this.dgv1.Dock = System.Windows.Forms.DockStyle.Fill;
this.dgv1.EditMode = System.Windows.Forms.DataGridViewEditMode.EditOnEnter;
this.dgv1.Location = new System.Drawing.Point(3, 17);
this.dgv1.Name = "dgv1";
dataGridViewCellStyle16.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
dataGridViewCellStyle16.BackColor = System.Drawing.SystemColors.Control;
dataGridViewCellStyle16.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
dataGridViewCellStyle16.ForeColor = System.Drawing.SystemColors.WindowText;
dataGridViewCellStyle16.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle16.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
dataGridViewCellStyle16.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
this.dgv1.RowHeadersDefaultCellStyle = dataGridViewCellStyle16;
this.dgv1.RowHeadersWidthSizeMode = System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders;
dataGridViewCellStyle17.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
this.dgv1.RowsDefaultCellStyle = dataGridViewCellStyle17;
this.dgv1.RowTemplate.Height = 23;
this.dgv1.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect;
this.dgv1.Size = new System.Drawing.Size(1020, 385);
this.dgv1.TabIndex = 34;
this.dgv1.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgv1_CellContentClick);
this.dgv1.CellDoubleClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgv1_CellDoubleClick);
this.dgv1.CellValueChanged += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgv1_CellValueChanged);
//
// 行
//
this.行.HeaderText = "行";
this.行.Name = "行";
this.行.ReadOnly = true;
this.行.Width = 42;
//
// Ration_id
//
this.Ration_id.HeaderText = "mssid";
this.Ration_id.Name = "Ration_id";
this.Ration_id.Visible = false;
this.Ration_id.Width = 60;
//
// dt_qy
//
this.dt_qy.HeaderText = "区域";
this.dt_qy.Name = "dt_qy";
this.dt_qy.ReadOnly = true;
this.dt_qy.Width = 51;
//
// dt_fx
//
this.dt_fx.HeaderText = "分项";
this.dt_fx.Name = "dt_fx";
this.dt_fx.ReadOnly = true;
this.dt_fx.Width = 51;
//
// dt_zy
//
this.dt_zy.HeaderText = "专业";
this.dt_zy.Name = "dt_zy";
this.dt_zy.ReadOnly = true;
this.dt_zy.Width = 51;
//
// dt_zl
//
this.dt_zl.HeaderText = "种类";
this.dt_zl.Name = "dt_zl";
this.dt_zl.ReadOnly = true;
this.dt_zl.Width = 51;
//
// 零件号
//
this.零件号.HeaderText = "零件号";
this.零件号.Name = "零件号";
this.零件号.Width = 61;
//
// 零件描述
//
dataGridViewCellStyle7.BackColor = System.Drawing.SystemColors.Window;
this.零件描述.DefaultCellStyle = dataGridViewCellStyle7;
this.零件描述.HeaderText = "零件描述";
this.零件描述.Name = "零件描述";
this.零件描述.ReadOnly = true;
this.零件描述.Width = 61;
//
// total_qty
//
dataGridViewCellStyle8.ForeColor = System.Drawing.Color.Red;
this.total_qty.DefaultCellStyle = dataGridViewCellStyle8;
this.total_qty.HeaderText = "总申请数量";
this.total_qty.Name = "total_qty";
this.total_qty.ReadOnly = true;
this.total_qty.Width = 72;
//
// meo_qty
//
dataGridViewCellStyle9.ForeColor = System.Drawing.Color.Red;
this.meo_qty.DefaultCellStyle = dataGridViewCellStyle9;
this.meo_qty.HeaderText = "已下发数量";
this.meo_qty.Name = "meo_qty";
this.meo_qty.ReadOnly = true;
this.meo_qty.Width = 72;
//
// left_qty
//
dataGridViewCellStyle10.ForeColor = System.Drawing.Color.Red;
this.left_qty.DefaultCellStyle = dataGridViewCellStyle10;
this.left_qty.HeaderText = "余下申请数量";
this.left_qty.Name = "left_qty";
this.left_qty.ReadOnly = true;
this.left_qty.Width = 72;
//
// reserved_qty
//
dataGridViewCellStyle11.ForeColor = System.Drawing.Color.Red;
this.reserved_qty.DefaultCellStyle = dataGridViewCellStyle11;
this.reserved_qty.HeaderText = "可用项目预留";
this.reserved_qty.Name = "reserved_qty";
this.reserved_qty.ReadOnly = true;
this.reserved_qty.Width = 72;
//
// 需求数量
//
dataGridViewCellStyle12.ForeColor = System.Drawing.Color.Blue;
this.需求数量.DefaultCellStyle = dataGridViewCellStyle12;
this.需求数量.HeaderText = "需求数量";
this.需求数量.Name = "需求数量";
this.需求数量.Width = 61;
//
// 单位
//
dataGridViewCellStyle13.BackColor = System.Drawing.SystemColors.Window;
this.单位.DefaultCellStyle = dataGridViewCellStyle13;
this.单位.HeaderText = "单位";
this.单位.Name = "单位";
this.单位.ReadOnly = true;
this.单位.Width = 51;
//
// MEO_ERP
//
this.MEO_ERP.HeaderText = "ERPMEO号";
this.MEO_ERP.Name = "MEO_ERP";
this.MEO_ERP.Width = 72;
//
// txt_drawingno
//
this.txt_drawingno.HeaderText = "图纸号";
this.txt_drawingno.Name = "txt_drawingno";
this.txt_drawingno.Width = 61;
//
// blockid
//
this.blockid.HeaderText = "分段号";
this.blockid.Name = "blockid";
this.blockid.Width = 61;
//
// 需求日期
//
dataGridViewCellStyle14.Format = "yyyy-MM-dd";
dataGridViewCellStyle14.NullValue = null;
this.需求日期.DefaultCellStyle = dataGridViewCellStyle14;
this.需求日期.HeaderText = "需求日期";
this.需求日期.Name = "需求日期";
this.需求日期.Width = 42;
//
// 备注
//
this.备注.HeaderText = "备注";
this.备注.Name = "备注";
this.备注.Width = 51;
//
// MEO_ID
//
this.MEO_ID.HeaderText = "MEO_ID";
this.MEO_ID.Name = "MEO_ID";
this.MEO_ID.Visible = false;
this.MEO_ID.Width = 66;
//
// groupBox1
//
this.groupBox1.Controls.Add(this.label9);
this.groupBox1.Controls.Add(this.cmb_block);
this.groupBox1.Controls.Add(this.label3);
this.groupBox1.Controls.Add(this.tb_discipline);
this.groupBox1.Controls.Add(this.tb_type);
this.groupBox1.Controls.Add(this.cmb_discipline);
this.groupBox1.Controls.Add(this.label6);
this.groupBox1.Controls.Add(this.btn_select);
this.groupBox1.Controls.Add(this.tb_fx);
this.groupBox1.Controls.Add(this.label5);
this.groupBox1.Controls.Add(this.tb_area);
this.groupBox1.Controls.Add(this.label4);
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Controls.Add(this.button1);
this.groupBox1.Controls.Add(this.btn_new);
this.groupBox1.Controls.Add(this.cmb_site);
this.groupBox1.Controls.Add(this.label14);
this.groupBox1.Controls.Add(this.btn_del);
this.groupBox1.Controls.Add(this.btn_save);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Dock = System.Windows.Forms.DockStyle.Top;
this.groupBox1.Location = new System.Drawing.Point(3, 17);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(1026, 95);
this.groupBox1.TabIndex = 42;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "MSS基本信息";
//
// label9
//
this.label9.AutoSize = true;
this.label9.ForeColor = System.Drawing.Color.Red;
this.label9.Location = new System.Drawing.Point(511, 43);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(11, 12);
this.label9.TabIndex = 157;
this.label9.Text = "*";
//
// cmb_block
//
this.cmb_block.FormattingEnabled = true;
this.cmb_block.Location = new System.Drawing.Point(524, 41);
this.cmb_block.Name = "cmb_block";
this.cmb_block.Size = new System.Drawing.Size(200, 20);
this.cmb_block.TabIndex = 156;
//
// label3
//
this.label3.AutoSize = true;
this.label3.ForeColor = System.Drawing.Color.Red;
this.label3.Location = new System.Drawing.Point(483, 44);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(29, 12);
this.label3.TabIndex = 155;
this.label3.Text = "分段";
//
// tb_discipline
//
this.tb_discipline.BackColor = System.Drawing.Color.White;
this.tb_discipline.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.tb_discipline.ForeColor = System.Drawing.SystemColors.MenuHighlight;
this.tb_discipline.Location = new System.Drawing.Point(524, 13);
this.tb_discipline.Name = "tb_discipline";
this.tb_discipline.ReadOnly = true;
this.tb_discipline.Size = new System.Drawing.Size(200, 21);
this.tb_discipline.TabIndex = 122;
//
// tb_type
//
this.tb_type.BackColor = System.Drawing.Color.White;
this.tb_type.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.tb_type.ForeColor = System.Drawing.SystemColors.MenuHighlight;
this.tb_type.Location = new System.Drawing.Point(780, 13);
this.tb_type.Name = "tb_type";
this.tb_type.ReadOnly = true;
this.tb_type.Size = new System.Drawing.Size(199, 21);
this.tb_type.TabIndex = 121;
//
// cmb_discipline
//
this.cmb_discipline.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cmb_discipline.FormattingEnabled = true;
this.cmb_discipline.Location = new System.Drawing.Point(279, 40);
this.cmb_discipline.Name = "cmb_discipline";
this.cmb_discipline.Size = new System.Drawing.Size(199, 20);
this.cmb_discipline.TabIndex = 120;
//
// label6
//
this.label6.AutoSize = true;
this.label6.Location = new System.Drawing.Point(246, 43);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(29, 12);
this.label6.TabIndex = 119;
this.label6.Text = "专业";
//
// btn_select
//
this.btn_select.Enabled = false;
this.btn_select.Location = new System.Drawing.Point(84, 66);
this.btn_select.Name = "btn_select";
this.btn_select.Size = new System.Drawing.Size(75, 24);
this.btn_select.TabIndex = 116;
this.btn_select.Text = "查询";
this.btn_select.UseVisualStyleBackColor = true;
this.btn_select.Click += new System.EventHandler(this.btn_select_Click);
//
// tb_fx
//
this.tb_fx.BackColor = System.Drawing.Color.White;
this.tb_fx.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.tb_fx.ForeColor = System.Drawing.SystemColors.MenuHighlight;
this.tb_fx.Location = new System.Drawing.Point(279, 13);
this.tb_fx.Name = "tb_fx";
this.tb_fx.ReadOnly = true;
this.tb_fx.Size = new System.Drawing.Size(199, 21);
this.tb_fx.TabIndex = 115;
//
// label5
//
this.label5.AutoSize = true;
this.label5.Location = new System.Drawing.Point(245, 18);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(29, 12);
this.label5.TabIndex = 114;
this.label5.Text = "分项";
//
// tb_area
//
this.tb_area.BackColor = System.Drawing.Color.White;
this.tb_area.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.tb_area.ForeColor = System.Drawing.SystemColors.MenuHighlight;
this.tb_area.Location = new System.Drawing.Point(41, 13);
this.tb_area.Name = "tb_area";
this.tb_area.ReadOnly = true;
this.tb_area.Size = new System.Drawing.Size(200, 21);
this.tb_area.TabIndex = 113;
//
// label4
//
this.label4.AutoSize = true;
this.label4.Location = new System.Drawing.Point(7, 17);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(29, 12);
this.label4.TabIndex = 112;
this.label4.Text = "区域";
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(483, 16);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(29, 12);
this.label1.TabIndex = 111;
this.label1.Text = "专业";
//
// button1
//
this.button1.Location = new System.Drawing.Point(234, 66);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(75, 24);
this.button1.TabIndex = 108;
this.button1.Text = "关闭";
this.button1.UseVisualStyleBackColor = true;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// btn_new
//
this.btn_new.Location = new System.Drawing.Point(309, 66);
this.btn_new.Name = "btn_new";
this.btn_new.Size = new System.Drawing.Size(75, 24);
this.btn_new.TabIndex = 68;
this.btn_new.Text = "清空";
this.btn_new.UseVisualStyleBackColor = true;
this.btn_new.Visible = false;
//
// cmb_site
//
this.cmb_site.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cmb_site.FormattingEnabled = true;
this.cmb_site.Location = new System.Drawing.Point(41, 40);
this.cmb_site.Name = "cmb_site";
this.cmb_site.Size = new System.Drawing.Size(200, 20);
this.cmb_site.TabIndex = 66;
//
// label14
//
this.label14.AutoSize = true;
this.label14.Location = new System.Drawing.Point(6, 44);
this.label14.Name = "label14";
this.label14.Size = new System.Drawing.Size(17, 12);
this.label14.TabIndex = 65;
this.label14.Text = "域";
//
// btn_del
//
this.btn_del.Location = new System.Drawing.Point(159, 66);
this.btn_del.Name = "btn_del";
this.btn_del.Size = new System.Drawing.Size(75, 24);
this.btn_del.TabIndex = 64;
this.btn_del.Text = "导出";
this.btn_del.UseVisualStyleBackColor = true;
this.btn_del.Click += new System.EventHandler(this.btn_del_Click);
//
// btn_save
//
this.btn_save.Enabled = false;
this.btn_save.Location = new System.Drawing.Point(9, 66);
this.btn_save.Name = "btn_save";
this.btn_save.Size = new System.Drawing.Size(75, 24);
this.btn_save.TabIndex = 61;
this.btn_save.Text = "保存";
this.btn_save.UseVisualStyleBackColor = true;
this.btn_save.Click += new System.EventHandler(this.btn_save_Click);
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(739, 17);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(29, 12);
this.label2.TabIndex = 42;
this.label2.Text = "种类";
//
// tabControl1
//
this.tabControl1.Controls.Add(this.tabPage1);
this.tabControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.tabControl1.Location = new System.Drawing.Point(0, 25);
this.tabControl1.Name = "tabControl1";
this.tabControl1.SelectedIndex = 0;
this.tabControl1.Size = new System.Drawing.Size(1046, 551);
this.tabControl1.TabIndex = 7;
this.tabControl1.SelectedIndexChanged += new System.EventHandler(this.tabControl1_SelectedIndexChanged);
this.tabControl1.TabIndexChanged += new System.EventHandler(this.tabControl1_TabIndexChanged);
//
// MaterialRation
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(1046, 576);
this.Controls.Add(this.tabControl1);
this.Controls.Add(this.toolStrip1);
this.Name = "MaterialRation";
this.Text = "材料下发页面";
this.Load += new System.EventHandler(this.MaterialRationAdd_Load);
this.toolStrip1.ResumeLayout(false);
this.toolStrip1.PerformLayout();
this.contextMenuStrip1.ResumeLayout(false);
this.tabPage1.ResumeLayout(false);
this.groupBox4.ResumeLayout(false);
this.groupBox2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dgv1)).EndInit();
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
this.tabControl1.ResumeLayout(false);
this.ResumeLayout(false);
this.PerformLayout();
}
private void AddActualDatesColoumn()
{
CalendarColumn c = new CalendarColumn();
FlightGridView.Columns.Add(c);
}
public static DataGridViewColumn CreateDataGridViewColumn(RuleColumn rcolumn)
{
if (rcolumn == null)
{
return(null);
}
DataGridViewColumn gcolumn = null;
switch (rcolumn.DataType)
{
case DataTypes.dtBoolean:
gcolumn = new DataGridViewCheckBoxColumn();
break;
case DataTypes.dtDateTime:
gcolumn = new CalendarColumn("yyyy-MM-dd HH:mm:ss");
break;
case DataTypes.dtDate:
gcolumn = new CalendarColumn("yyyy-MM-dd");
break;
case DataTypes.dtTime:
gcolumn = new CalendarColumn("HH:mm:ss");
break;
case DataTypes.dtBLOB:
gcolumn = new DataGridViewImageColumn();
break;
default:
if (rcolumn.HasMapInfo)
{
DataMap dm = SystemContext.MapManager.FromMapInfo(rcolumn.MapInfo);
if (dm != null)
{
DataTable mtable = dm.GetMapTable(rcolumn.GetLocalType());
if (mtable != null && mtable.Rows.Count > 0)
{
gcolumn = new DataGridViewComboBoxColumn();
DataGridViewComboBoxCell combboxcell = gcolumn.CellTemplate as DataGridViewComboBoxCell;
if (combboxcell != null)
{
combboxcell.DataSource = mtable;
combboxcell.ValueMember = "Key";
combboxcell.DisplayMember = "Value";
}
}
}
}
else if (rcolumn.HasMask)
{
gcolumn = new MaskedTextBoxColumn(rcolumn.Mask);
}
else
{
switch (rcolumn.UiCtrOpt)
{
case UICtrOpt.TextButton:
gcolumn = new TextBoxButtonColumn();
break;
default:
gcolumn = new DataGridViewTextBoxColumn();
break;
}
}
break;
}
if (gcolumn == null)
{
gcolumn = new DataGridViewTextBoxColumn();
}
gcolumn.Name = rcolumn.ColumnName;
gcolumn.HeaderText = rcolumn.Label;
gcolumn.DataPropertyName = rcolumn.ColumnName;
gcolumn.Width = rcolumn.Width;
gcolumn.Visible = rcolumn.ListCtrlVision; //rcolumn.Visible;
gcolumn.SortMode = DataGridViewColumnSortMode.Automatic;
if (rcolumn.HasDisplayFormat)
{
gcolumn.CellTemplate.Style.Format = rcolumn.DisplayFormat;
}
if (gcolumn.Visible && gcolumn.Width < 100)
{
if (gcolumn.Width == 0)
{
gcolumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader;
}
else
{
gcolumn.Width = 100;
}
}
return(gcolumn);
}
public void listviewBind(string sql)
{
//���IJ������������Լ�����
ds = PartParameter.QueryPartPara(sql);
dgv1.DataSource = ds.Tables[0].DefaultView;
DataGridViewComboBoxColumn dgvcom = new DataGridViewComboBoxColumn();
DataSet blockds = PartParameter.QueryPartPara("select block_id,description from project_block_tab where project_id=" + ecprojectid.ToString()+" order by description");
DataRow rowdim = blockds.Tables[0].NewRow();
rowdim[0]=1;
blockds.Tables[0].Rows.InsertAt(rowdim, 0);
dgvcom.DataSource = blockds.Tables[0].DefaultView;
dgvcom.DisplayMember = "description";
dgvcom.ValueMember = "description";
dgvcom.HeaderText="�ֶ�";
dgvcom.Name = "�ֶ�";
dgvcom.ReadOnly= false;
CalendarColumn dgvcal = new CalendarColumn();
dgvcal.HeaderText = "Ԥ������";
dgvcal.Name = "Ԥ������";
//DateColumn dgvcaln = new DateColumn();
//dgvcaln.HeaderText = "������";
if (!dgv1.Columns.Contains("Ԥ������"))
{
//dgv1.Columns.Add(dgvcom);
//dgv1.Columns.Add(dgvcal);
//dgv1.Columns.Add(dgvcaln);
//dgv1.Columns["Ԥ������"].Width = 200;
}
dgv1.Columns["Ԥ����"].Width = 100;
//dgv1.Columns["�ֶ�"].Width = 100;
dgv1.Columns["Ԥ����"].ValueType = typeof(double);
dgv1.Columns["��"].ReadOnly = true;
dgv1.Columns["���"].ReadOnly = true;
dgv1.Columns["�����"].ReadOnly = true;
dgv1.Columns["������"].ReadOnly = true;
dgv1.Columns["������"].ReadOnly = true;
dgv1.Columns["����"].ReadOnly = true;
dgv1.Columns["֤��"].ReadOnly = true;
dgv1.Columns["��λ"].ReadOnly = true;
dgv1.Columns["�ܶȵ�λ"].ReadOnly = true;
dgv1.Columns["�ȼ�"].ReadOnly = true;
dgv1.Columns["��λ�ܶ�"].ReadOnly = true;
dgv1.Columns["parentid"].Visible = false;
#region �����е�ֻ����
//int specnum = PartParameter.GetSpecCou(activity);
//if (specnum != 0)
//{
// if (specnum > 0)
// {
// string colstr = PartParameter.GetSpecName(activity, "1").Trim();
// dgv1.Columns[colstr].ReadOnly = true;
// }
// if (specnum > 1)
// {
// string colstr = PartParameter.GetSpecName(activity, "2").Trim();
// dgv1.Columns[colstr].ReadOnly = true;
// }
// if (specnum > 2)
// {
// string colstr = PartParameter.GetSpecName(activity, "3").Trim();
// dgv1.Columns[colstr].ReadOnly = true;
// }
// if (specnum > 3)
// {
// string colstr = PartParameter.GetSpecName(activity, "4").Trim();
// dgv1.Columns[colstr].ReadOnly = true;
// }
//}
#endregion
#region �������ù���Ԥ��ֵ������
//if (dgv1.RowCount != 0)
//{
// List<PartParameter> pp = PartParameter.FindPartList(systemid,mmtypeid, ProjectId,LoginUser,1);
// //if (pp.Count != 0)
// // {
// for (int i = 0; i < dgv1.Rows.Count; i++)
// {
// int partid = int.Parse(dgv1.Rows[i].Cells["���"].Value.ToString());
// PartParameter pone = pp.Find(delegate(PartParameter bb) { return bb.ID == partid; });
// if (pone != null)
// {
// dgv1.Rows[i].Cells["Ԥ����"].Value = pone.PREDICTION_QTY;
// //DataGridViewComboBoxCell combo = new DataGridViewComboBoxCell();
// dgv1.Rows[i].Cells["Ԥ��ϵ��"].Value = pone.PREDICTION_ALERT;
// if (pone.BLOCKID != "0")
// {
// dgv1.Rows[i].Cells["����"].Value = pone.CREATEDATE;
// dgv1.Rows[i].Cells["�ֶ�"].Value = pone.BLOCKID;
// //DataGridViewComboBoxCell combo = dgv1.Rows[i].Cells["�ֶ�"] as DataGridViewComboBoxCell;
// //combo.DataSource = blockds.Tables[0];
// //combo.DisplayMember = "description";
// //combo.ValueMember = "block_id";
// //combo.Value = pone.BLOCKID;
// }
// }
// else
// {
// dgv1.Rows[i].Cells["Ԥ����"].Value = 0;
// dgv1.Rows[i].Cells["Ԥ��ϵ��"].Value = 0;
// }
// }
// //}
//}
#endregion
}
private void But_connect_Click(object sender, EventArgs e)
{
connection = new SqlConnection(connectString);
connection.Open();
//MessageBox.Show(connection.State.ToString());
ds = new DataSet("Northwind");
SqlCommand command;
daState = new SqlDataAdapter();
command = new SqlCommand("Select * From State", connection);
daState.SelectCommand = command;
dtState = ds.Tables.Add("State");
daState.Fill(dtState);
daCustomer = new SqlDataAdapter();
// - SELECT
command = new SqlCommand("Select ':)' as Etykieta,* From Customer", connection);
daCustomer.SelectCommand = command;
// - INSERT
command = new SqlCommand("INSERT INTO Customer (FirstName,LastName,Address,City,State,ZipCode,AccountNumber) VALUES (@FirstName,@LastName,@Address,@City,@State,@ZipCode,@AccountNumber)", connection);
//command.Parameters.Add("@id", SqlDbType.Int, 0, "id");
command.Parameters.Add("@FirstName", SqlDbType.NVarChar, 40, "FirstName");
command.Parameters.Add("@LastName", SqlDbType.NVarChar, 40, "LastName");
command.Parameters.Add("@Address", SqlDbType.NVarChar, 40, "Address");
command.Parameters.Add("@City", SqlDbType.NVarChar, 40, "City");
command.Parameters.Add("@State", SqlDbType.NVarChar, 40, "State");
command.Parameters.Add("@ZipCode", SqlDbType.NVarChar, 40, "ZipCode");
command.Parameters.Add("@AccountNumber", SqlDbType.NVarChar, 40, "AccountNumber");
daCustomer.InsertCommand = command;
// - UPDATE
command = new SqlCommand("UPDATE Customer SET FirstName = @FirstName, LastName = @LastName, Address = @Address, City = @City, State = @State, ZipCode = @ZipCode, AccountNumber = @AccountNumber WHERE id = @oldid", connection);
//command.Parameters.Add("@id", SqlDbType.NChar, 5, "id");
command.Parameters.Add("@FirstName", SqlDbType.NVarChar, 40, "FirstName");
command.Parameters.Add("@LastName", SqlDbType.NVarChar, 40, "LastName");
command.Parameters.Add("@Address", SqlDbType.NVarChar, 40, "Address");
command.Parameters.Add("@City", SqlDbType.NVarChar, 40, "City");
command.Parameters.Add("@State", SqlDbType.NVarChar, 40, "State");
command.Parameters.Add("@ZipCode", SqlDbType.NVarChar, 40, "ZipCode");
command.Parameters.Add("@AccountNumber", SqlDbType.NVarChar, 40, "AccountNumber");
SqlParameter parameter = command.Parameters.Add("@oldid", SqlDbType.Int, 0, "id");
parameter.SourceVersion = DataRowVersion.Original;
daCustomer.UpdateCommand = command;
// - DELETE
command = new SqlCommand("DELETE FROM Customer WHERE id = @id", connection);
// Add the parameters for the DeleteCommand.
parameter = command.Parameters.Add("@id", SqlDbType.Int, 0, "id");
parameter.SourceVersion = DataRowVersion.Original;
daCustomer.DeleteCommand = command;
dtCustomer = ds.Tables.Add("Customer");
daCustomer.Fill(dtCustomer);
bsCustomer = new BindingSource();
bsCustomer.DataSource = dtCustomer;
//bsCustomer.CurrentChanged += new EventHandler(Current_Changed);
GridCustomer.AutoSize = false;
GridCustomer.DataSource = bsCustomer;
NavigatorCustomer.BindingSource = bsCustomer;
GridCustomer.Use(p =>
{
p.ColumnHeadersDefaultCellStyle.Font = new Font("Tahoma", 9, FontStyle.Bold);
p.ColumnHeadersDefaultCellStyle.ForeColor = Color.Black;
p.ColumnHeadersDefaultCellStyle.BackColor = Color.Yellow;
p.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
p.EnableHeadersVisualStyles = false;
p.AutoGenerateColumns = false;
p.Columns.Clear();
int iCol;
iCol = p.Columns.Add("col_FirstName", "Imię");
p.Columns[iCol].DataPropertyName = "FirstName";
iCol = p.Columns.Add("col_LastName", "Nazwisko");
p.Columns[iCol].DataPropertyName = "LastName";
iCol = p.Columns.Add("col_Address", "Ulica");
p.Columns[iCol].DataPropertyName = "Address";
iCol = p.Columns.Add("col_City", "Miejscowość");
p.Columns[iCol].DataPropertyName = "City";
//iCol = p.Columns.Add("col_State", "Województwo");
//p.Columns[iCol].DataPropertyName = "State";
DataGridViewComboBoxColumn cb = new DataGridViewComboBoxColumn();
cb.HeaderText = "Województwo";
cb.DataPropertyName = "State";
cb.Name = "col_State";
cb.MaxDropDownItems = 4;
cb.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;
//cb.Items.Add("Śląskie");
//cb.Items.Add("Małopolskie");
cb.DataSource = dtState;
cb.ValueMember = "name";
cb.DisplayMember = "name";
p.Columns.Add(cb);
iCol = p.Columns.Add("col_ZipCode", "Kod pocztowy");
p.Columns[iCol].DataPropertyName = "ZipCode";
iCol = p.Columns.Add("col_AccountNumber", "Nr konta");
p.Columns[iCol].DataPropertyName = "AccountNumber";
//p.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
});
daOrder = new SqlDataAdapter();
// - SELECT
command = new SqlCommand("Select * From Orders", connection);
daOrder.SelectCommand = command;
// - INSERT
command = new SqlCommand("INSERT INTO ORDERS (CustomerId,OrderDate,Invoice,Paymend,Price) VALUES (@CustomerId,@OrderDate,@Invoice,@Paymend,@Price)", connection);
command.Parameters.Add("@CustomerId", SqlDbType.Int, 0, "CustomerId");
command.Parameters.Add("@OrderDate", SqlDbType.Date, 0, "OrderDate");
command.Parameters.Add("@Invoice", SqlDbType.NVarChar, 100, "Invoice");
command.Parameters.Add("@Paymend", SqlDbType.Int, 0, "Paymend");
command.Parameters.Add("@Price", SqlDbType.Money, 0, "Price");
daOrder.InsertCommand = command;
// - UPDATE
command = new SqlCommand("UPDATE ORDERS SET OrderDate = @OrderDate, Invoice = @Invoice, Paymend = @Paymend, Price = @Price WHERE id = @oldid", connection);
command.Parameters.Add("@OrderDate", SqlDbType.Date, 0, "OrderDate");
command.Parameters.Add("@Invoice", SqlDbType.NVarChar, 100, "Invoice");
command.Parameters.Add("@Paymend", SqlDbType.Int, 0, "Paymend");
command.Parameters.Add("@Price", SqlDbType.Money, 0, "Price");
parameter = command.Parameters.Add("@oldid", SqlDbType.Int, 0, "id");
parameter.SourceVersion = DataRowVersion.Original;
daOrder.UpdateCommand = command;
// - DELETE
command = new SqlCommand("DELETE FROM ORDERS WHERE id = @id", connection);
// Add the parameters for the DeleteCommand.
parameter = command.Parameters.Add("@id", SqlDbType.Int, 0, "id");
parameter.SourceVersion = DataRowVersion.Original;
daOrder.DeleteCommand = command;
dtOrder = ds.Tables.Add("Orders");
daOrder.Fill(dtOrder);
DataRelation relCustOrder = new DataRelation("CustomersOrders", dtCustomer.Columns["id"], dtOrder.Columns["customerID"]);
// Add the relation to the DataSet.
ds.Relations.Add(relCustOrder);
bsOrder = new BindingSource();
bsOrder.DataSource = bsCustomer;
bsOrder.DataMember = "CustomersOrders";
// --
NavigatorOrder.BindingSource = bsOrder;
GridOrder.Use(p =>
{
p.DataSource = bsOrder;
p.AutoSize = false;
p.ColumnHeadersDefaultCellStyle.Font = new Font("Tahoma", 9, FontStyle.Bold);
p.ColumnHeadersDefaultCellStyle.ForeColor = Color.Black;
p.ColumnHeadersDefaultCellStyle.BackColor = Color.Yellow;
p.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
p.EnableHeadersVisualStyles = false;
p.AutoGenerateColumns = false;
p.Columns.Clear();
//p.Columns.Add("OrderDate", "Data zamówienia");
DataGridViewColumn col1 = new DataGridViewTextBoxColumn();
col1.DataPropertyName = "Invoice";
col1.Name = "Invoice";
col1.HeaderText = "Nr paragonu";
col1.ValueType = typeof(string);
p.Columns.Add(col1);
col1.Dispose();
//DataGridViewColumn col2 = new DataGridViewTextBoxColumn();
CalendarColumn col2 = new CalendarColumn();
col2.DataPropertyName = "OrderDate";
col2.Name = "OrderDate";
col2.HeaderText = "Data zamówienia";
col2.ValueType = typeof(DateTime);
p.Columns.Add(col2);
col2.Dispose();
DataGridViewCheckBoxColumn chbox = new DataGridViewCheckBoxColumn();
chbox.DataPropertyName = "Paymend";
chbox.Name = "Paymend";
chbox.HeaderText = "Czy zapłacone";
chbox.ValueType = typeof(int);
p.Columns.Add(chbox);
DataGridViewTextBoxColumn col4 = new DataGridViewTextBoxColumn();
col4.DataPropertyName = "Price";
col4.Name = "Price";
col4.HeaderText = "Kwota";
col4.ValueType = typeof(float);
col4.DefaultCellStyle.Format = "c";
p.Columns.Add(col4);
DataGridViewImageColumn img = new DataGridViewImageColumn();
img.Name = "Image";
img.HeaderText = "Ikona";
img.ValuesAreIcons = true;
p.Columns.Add(img);
});
ControlsStat();
}
private void consultaDatos(string codigoClienteConsulta)
{
#region " Creamos la tabla del datagridview que contendrá los datos "
DataGridViewColumn columnaDgw;
columnaDgw = new DataGridViewTextBoxColumn();
columnaDgw.HeaderText = "Id";
columnaDgw.Name = "Id";
columnaDgw.Resizable = DataGridViewTriState.False;
columnaDgw.Width = 100;
this.dgvRejillaDatos.Columns.Add(columnaDgw);
columnaDgw = new DataGridViewTextBoxColumn();
columnaDgw.HeaderText = "Factura";
columnaDgw.Name = "Factura";
columnaDgw.Resizable = DataGridViewTriState.False;
columnaDgw.Width = 100;
this.dgvRejillaDatos.Columns.Add(columnaDgw);
columnaDgw = new DataGridViewTextBoxColumn();
columnaDgw.HeaderText = "Fecha";
columnaDgw.Name = "Fecha";
columnaDgw.Resizable = DataGridViewTriState.False;
columnaDgw.Width = 100;
this.dgvRejillaDatos.Columns.Add(columnaDgw);
columnaDgw = new DataGridViewTextBoxColumn();
columnaDgw.HeaderText = "Cliente";
columnaDgw.Name = "Cliente";
columnaDgw.Resizable = DataGridViewTriState.False;
columnaDgw.Width = 300;
this.dgvRejillaDatos.Columns.Add(columnaDgw);
columnaDgw = new DataGridViewTextBoxColumn();
columnaDgw.HeaderText = "Importe";
columnaDgw.Name = "Importe";
columnaDgw.Resizable = DataGridViewTriState.False;
columnaDgw.Width = 100;
this.dgvRejillaDatos.Columns.Add(columnaDgw);
columnaDgw = new CalendarColumn();
columnaDgw.HeaderText = "Fec.Anotación";
columnaDgw.Name = "Fec.Anotación";
columnaDgw.Resizable = DataGridViewTriState.False;
columnaDgw.Width = 100;
this.dgvRejillaDatos.Columns.Add(columnaDgw);
columnaDgw = new DataGridViewTextBoxColumn();
columnaDgw.HeaderText = "Anotación";
columnaDgw.Name = "Anotación";
columnaDgw.Resizable = DataGridViewTriState.False;
columnaDgw.Width = 100;
this.dgvRejillaDatos.Columns.Add(columnaDgw);
columnaDgw = new DataGridViewCheckBoxColumn();
columnaDgw.HeaderText = "Punteado";
columnaDgw.Name = "Punteado";
columnaDgw.Resizable = DataGridViewTriState.False;
columnaDgw.Width = 80;
this.dgvRejillaDatos.Columns.Add(columnaDgw);
#endregion
// La primera columna, que es la que tiene el Id, no debe ser visible.
this.dgvRejillaDatos.Columns[0].Visible = false;
#region " Realizamos las consultas pertinentes "
decimal idCliente;
string codigoCliente;
string nombreCliente;
//decimal idCobro;
decimal idFacturaVenta;
string factura;
string fechaFactura;
string importe;
string fechaAnotacion = "";
string anotacion = "";
decimal punteado = 0;
// Variables de trabajo.
decimal ejercicio = 0;
decimal serie = 0;
decimal numero = 0;
decimal variableTemporal = 0;
int indiceRegistro = 0;
string consultaCobros = "select * from Cobros";
//if (codigoClienteConsulta == "*")
//{
// consultaCobros = "select * from Cobros";
//}
//else
//{
// consultaCobros = "select * from Cobros where IdCliente = '" + codigoClienteConsulta + "'";
//}
// Obtenemos los datos guardados en el fichero cp.
//this.tablaConsulta.Clear();
//Kripto.CargaDatos(this.tablaConsulta);
// Recogemos todos los datos de cobros y los respasamos para ir montando la tabla a mostrar.
//sql.ConsultarSQL(consultaCobros, this.tablaCobros, false);
//for (int a = 0; a != this.tablaCobros.Rows.Count; a++)
//{
// // Obtenemos la factura.
// ejercicio = Convert.ToDecimal(this.tablaCobros.Rows[a].ItemArray[5]);
// serie = Convert.ToDecimal(this.tablaCobros.Rows[a].ItemArray[6]);
// numero = Convert.ToDecimal(this.tablaCobros.Rows[a].ItemArray[7]);
// factura = ejercicio + "-" + string.Format("{0:00}", serie) + "-" + string.Format("{0:000000}", numero);
// // Obtenemos la fecha de la factura.
// fechaFactura = Convert.ToDateTime(this.tablaCobros.Rows[a].ItemArray[8]).ToShortDateString();
// // Obtenemos el importe del descuento.
// variableTemporal = Convert.ToDecimal(this.tablaCobros.Rows[a].ItemArray[19]);
// importe = string.Format("{0:C}", variableTemporal);
// // Obtenemos el idFacturaVenta.
// idFacturaVenta = Convert.ToDecimal(this.tablaCobros.Rows[a].ItemArray[3]);
// // Obtenemos el id del cliente para pintar su nombre.
// idCliente = Convert.ToDecimal(this.tablaCobros.Rows[a].ItemArray[10]);
// sql.ConsultarSQL("select * from Clientes where Id = '" + idCliente + "'", this.tablaClientes, false);
// // Obtenemos el código del cliente.
// codigoCliente = Convert.ToString(this.tablaClientes.Rows[0].ItemArray[3]);
// // Obtenemos el nombre del cliente.
// nombreCliente = Convert.ToString(this.tablaClientes.Rows[0].ItemArray[8]);
// Insertamos un nuevo registro.
this.dgvRejillaDatos.Rows.Add();
this.configuraDataGridView(indiceRegistro, false);
// Rellenamos los datos del nuevo registro creado.
this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Id"].Value = 0; // idFacturaVenta;
this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Factura"].Value = "100"; //factura;
this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Fecha"].Value = "10/10/2015"; // fechaFactura;
this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Cliente"].Value = "Nombre Cliente "; // codigoCliente + " " + nombreCliente;
this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Importe"].Value = "1200"; // importe;
this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Fec.Anotación"].Value = ""; // fechaAnotacion;
this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Anotación"].Value = "120"; // anotacion;
this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Punteado"].Value = punteado;
// Incrementamos el indiceRegistro para que apunte bien al registro correspondiente de la rejilla.
indiceRegistro++;
// // Insertamos las líneas correspondientes a las anotaciones.
// // Esto sale del fichero cp
// if (tablaConsulta.Rows.Count > 0)
// {
// tablaConsulta.DefaultView.RowFilter = "IdFactura = " + idFacturaVenta;
// DataView vista = tablaConsulta.DefaultView;
// for (int b = 0; b != vista.Count; b++)
// {
// this.dgvRejillaDatos.Rows.Add();
// this.configuraDataGridView(indiceRegistro, true);
// // Rellenamos los datos del nuevo registro creado.
// this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Id"].Value = vista[b].Row.ItemArray[0];
// this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Factura"].Value = "";
// this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Fecha"].Value = "";
// this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Cliente"].Value = "";
// this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Importe"].Value = "";
// this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Fec.Anotación"].Value = vista[b].Row.ItemArray[3];
// this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Anotación"].Value = vista[b].Row.ItemArray[4];
// this.dgvRejillaDatos.Rows[indiceRegistro].Cells["Punteado"].Value = Convert.ToInt32(vista[b].Row.ItemArray[5]);
// // Incrementamos el indiceRegistro para que apunte bien al registro correspondiente de la rejilla.
// indiceRegistro++;
// }
// }
//}
#endregion
}
private void ResizeGridArticulos()
{
//bisCaducidad.DataSource = new List<EntradaDetalle>();
dgvEntradaCaducidad.AutoGenerateColumns = false;
dgvEntradaCaducidad.AllowUserToAddRows = true;
//dgvArticulos0.AutoSize = true;
DataGridViewColumn column = new DataGridViewTextBoxColumn
{
DataPropertyName = "NoLote",
Name = "No. Lote",
Width = 200,
SortMode = DataGridViewColumnSortMode.NotSortable,
Resizable = DataGridViewTriState.False,
MaxInputLength = 18
};
dgvEntradaCaducidad.Columns.Add(column);
column = new DataGridViewTextBoxColumn
{
DataPropertyName = "Cantidad",
Name = "Cantidad",
Width = 60,
SortMode = DataGridViewColumnSortMode.NotSortable,
Resizable = DataGridViewTriState.False,
DefaultCellStyle = { Alignment = DataGridViewContentAlignment.MiddleRight }
};
dgvEntradaCaducidad.Columns.Add(column);
column = new CalendarColumn()
{
DataPropertyName = "FechaCaducidad",
Name = "Caducidad",
Width = 120,
SortMode = DataGridViewColumnSortMode.NotSortable,
Resizable = DataGridViewTriState.False,
};
dgvEntradaCaducidad.Columns.Add(column);
column = new DataGridViewTextBoxColumn
{
DataPropertyName = "IdEntradaDetalle",
Name = "IdEntradaDetalle",
Width = 0,
SortMode = DataGridViewColumnSortMode.NotSortable,
Resizable = DataGridViewTriState.False,
};
dgvEntradaCaducidad.Columns.Add(column);
dgvEntradaCaducidad.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle();
this.nameColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.assignmentDateColumn = new Gradebook.View.Calendar.CalendarColumn();
this.dueDateColumn = new Gradebook.View.Calendar.CalendarColumn();
this.pointsColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
this.SuspendLayout();
//
// nameColumn
//
this.nameColumn.DataPropertyName = "Name";
this.nameColumn.HeaderText = "Name";
this.nameColumn.Name = "nameColumn";
this.nameColumn.Width = 60;
//
// assignmentDateColumn
//
this.assignmentDateColumn.DataPropertyName = "AssignmentDate";
dataGridViewCellStyle3.Format = "mm/dd/yy";
this.assignmentDateColumn.DefaultCellStyle = dataGridViewCellStyle3;
this.assignmentDateColumn.HeaderText = "Assignment Date";
this.assignmentDateColumn.Name = "assignmentDateColumn";
this.assignmentDateColumn.Width = 103;
//
// dueDateColumn
//
this.dueDateColumn.DataPropertyName = "DueDate";
dataGridViewCellStyle4.Format = "mm/dd/yy";
this.dueDateColumn.DefaultCellStyle = dataGridViewCellStyle4;
this.dueDateColumn.HeaderText = "Due Date";
this.dueDateColumn.Name = "dueDateColumn";
this.dueDateColumn.Width = 72;
//
// pointsColumn
//
this.pointsColumn.DataPropertyName = "Points";
this.pointsColumn.HeaderText = "Points";
this.pointsColumn.Name = "pointsColumn";
this.pointsColumn.Width = 61;
//
// AssignmentGrid
//
this.AllowUserToOrderColumns = true;
this.AutoGenerateColumns = false;
this.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.AllCells;
this.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.nameColumn,
this.assignmentDateColumn,
this.dueDateColumn,
this.pointsColumn
});
this.CellEndEdit += new System.Windows.Forms.DataGridViewCellEventHandler(this.AssignmentGrid_CellEndEdit);
this.UserDeletedRow += new System.Windows.Forms.DataGridViewRowEventHandler(this.AssignmentGrid_UserDeletedRow);
this.UserDeletingRow += new System.Windows.Forms.DataGridViewRowCancelEventHandler(this.AssignmentGrid_UserDeletingRow);
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
this.ResumeLayout(false);
}
/// ------------------------------------------------------------------------------------
/// <summary>
/// Creates a calendar control grid column that hosts calendar (date) cells.
/// </summary>
/// ------------------------------------------------------------------------------------
public static DataGridViewColumn CreateCalendarControlColumn(string name, string headerText,
Func<DateTime> getDefaultValue, CalendarCell.UserAction whenToUseDefault)
{
var col = new CalendarColumn(getDefaultValue, whenToUseDefault);
col.HeaderCell.Style.Font = SystemFonts.MenuFont;
col.Name = name;
col.HeaderText = headerText;
return col;
}
private static void buildTheColumns()
{
// idColumn
idCol = new DataGridViewTextBoxColumn();
idCol.Name = LINE_ID_NAME;
idCol.HeaderText = "id";
idCol.DataPropertyName = "id";
idCol.Visible = false;
// transactionIDColumn
transactionIDCol = new DataGridViewTextBoxColumn();
transactionIDCol.Name = TRANSACTION_ID_NAME;
transactionIDCol.HeaderText = "transactionID";
transactionIDCol.DataPropertyName = "transactionID";
transactionIDCol.Visible = false;
// dateColumn
dateCol = new CalendarColumn();
dateCol.Name = DATE_NAME;
dateCol.HeaderText = "Date";
dateCol.DataPropertyName = "date";
dateCol.SortMode = DataGridViewColumnSortMode.NotSortable;
dateCol.Resizable = DataGridViewTriState.True;
dateCol.Visible = true;
dateCol.Width = 85;
// typeIDColumn
lineTypeCol = new DataGridViewComboBoxColumn();
lineTypeCol.Name = LINE_TYPE_ID_NAME;
lineTypeCol.HeaderText = "Type";
lineTypeCol.DataPropertyName = "typeID";
lineTypeCol.DataSource = typeColBindingSource;
lineTypeCol.DisplayMember = "name";
lineTypeCol.ValueMember = "id";
lineTypeCol.AutoComplete = true;
lineTypeCol.SortMode = DataGridViewColumnSortMode.NotSortable;
lineTypeCol.Resizable = DataGridViewTriState.True;
lineTypeCol.DisplayStyleForCurrentCellOnly = true;
lineTypeCol.Width = 80;
lineTypeCol.Visible = true;
// oppAccountIDColumn
oppAccountIDCol = new DataGridViewComboBoxColumn();
oppAccountIDCol.Name = OPP_ACCOUNT_ID_NAME;
oppAccountIDCol.HeaderText = "Source / Destination";
oppAccountIDCol.DataPropertyName = "oppAccountID";
oppAccountIDCol.DataSource = oppAccountColBindingSource;
oppAccountIDCol.DisplayMember = "name";
oppAccountIDCol.ValueMember = "id";
oppAccountIDCol.SortMode = DataGridViewColumnSortMode.NotSortable;
oppAccountIDCol.Resizable = DataGridViewTriState.True;
oppAccountIDCol.DisplayStyleForCurrentCellOnly = true;
oppAccountIDCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
oppAccountIDCol.FillWeight = 120;
oppAccountIDCol.Visible = true;
// descriptionColumn
descriptionCol = new DataGridViewTextBoxColumn();
descriptionCol.Name = DESCRIPTION_NAME;
descriptionCol.HeaderText = "Description";
descriptionCol.DataPropertyName = "description";
descriptionCol.SortMode = DataGridViewColumnSortMode.NotSortable;
descriptionCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
descriptionCol.FillWeight = 200;
descriptionCol.Visible = true;
// confirmationNumColumn
confirmationNumCol = new DataGridViewTextBoxColumn();
confirmationNumCol.Name = CONFIRMATION_NUM_NAME;
confirmationNumCol.HeaderText = "Confirmation #";
confirmationNumCol.DataPropertyName = "confirmationNumber";
confirmationNumCol.SortMode = DataGridViewColumnSortMode.NotSortable;
confirmationNumCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
confirmationNumCol.FillWeight = 100;
confirmationNumCol.Visible = true;
// envelopeIDColumn
envelopeIDCol = new DataGridViewComboBoxColumn();
envelopeIDCol.Name = ENVELOPE_ID_NAME;
envelopeIDCol.HeaderText = "Envelope";
envelopeIDCol.DataPropertyName = "envelopeID";
envelopeIDCol.DataSource = envelopeColBindingSource;
envelopeIDCol.DisplayMember = "name";
envelopeIDCol.ValueMember = "id";
envelopeIDCol.SortMode = DataGridViewColumnSortMode.NotSortable;
envelopeIDCol.DisplayStyleForCurrentCellOnly = true;
envelopeIDCol.Resizable = DataGridViewTriState.True;
envelopeIDCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
envelopeIDCol.FillWeight = 100;
envelopeIDCol.Visible = true;
// creditAmountColumn
creditAmountCol = new DataGridViewTextBoxColumn();
creditAmountCol.Name = CREDIT_AMOUNT_NAME;
creditAmountCol.HeaderText = "Credit";
creditAmountCol.DataPropertyName = "creditAmount";
creditAmountCol.SortMode = DataGridViewColumnSortMode.NotSortable;
creditAmountCol.DefaultCellStyle = new MyCellStyleMoney();
creditAmountCol.Width = 65;
// completeColumn
completeCol = new DataGridViewTextBoxColumn();
completeCol.Name = COMPLETE_NAME;
completeCol.HeaderText = "CR";
completeCol.DataPropertyName = "complete";
completeCol.SortMode = DataGridViewColumnSortMode.NotSortable;
completeCol.DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
completeCol.Width = 25;
completeCol.ReadOnly = true;
// debitAmountColumn
debitAmountCol = new DataGridViewTextBoxColumn();
debitAmountCol.Name = DEBIT_AMOUNT_NAME;
debitAmountCol.HeaderText = "Debit";
debitAmountCol.DataPropertyName = "debitAmount";
debitAmountCol.SortMode = DataGridViewColumnSortMode.NotSortable;
debitAmountCol.DefaultCellStyle = new MyCellStyleMoney();
debitAmountCol.Visible = true;
debitAmountCol.Width = 65;
// balanceAmountColumn
balanceAmountCol = new DataGridViewTextBoxColumn();
balanceAmountCol.Name = BALANCE_AMOUNT_NAME;
balanceAmountCol.HeaderText = "Balance";
balanceAmountCol.DataPropertyName = "balanceAmount";
balanceAmountCol.SortMode = DataGridViewColumnSortMode.NotSortable;
balanceAmountCol.DefaultCellStyle = new MyCellStyleMoney();
balanceAmountCol.ReadOnly = true;
balanceAmountCol.Visible = true;
balanceAmountCol.Width = 75;
}
public static void InitDataGridViewColumns(DataGridView grid, DataTable table)
{
if (grid == null || table == null)
{
return;
}
//if (grid.Columns.Count > 0)
// grid.Columns.Clear();
if (grid.Columns.Count == 0)
{
grid.EditingControlShowing -= new DataGridViewEditingControlShowingEventHandler(DataGridViewEditingControlShowing);
grid.EditingControlShowing += new DataGridViewEditingControlShowingEventHandler(DataGridViewEditingControlShowing);
DataRule dr = TableUtil.GetDataRule(table);
if (dr != null)
{
DataColumnCollection columns = table.Columns;
if (columns.Count > 0)
{
DataGridViewColumn gcolumn;
RuleColumn rcolumn;
foreach (DataColumn column in columns)
{
rcolumn = TableUtil.GetRuleColumn(column);
if (rcolumn != null)
{
gcolumn = CreateDataGridViewColumn(rcolumn);
grid.Columns.Add(gcolumn);
}
else
{
InitDataGridViewColumns(grid, dr);
break;
}
}
}
else
{
InitDataGridViewColumns(grid, dr);
}
}
else if (table.Columns.Count > 0)
{
DataGridViewColumn gcolumn;
foreach (DataColumn column in table.Columns)
{
if (TableUtil.StrProperty(column, "Visible").Equals("0"))
{
continue;
}
gcolumn = null;
string datatype = column.DataType.ToString();
if (datatype.Equals("System.Boolean"))
{
gcolumn = new DataGridViewCheckBoxColumn();
gcolumn.Width = column.MaxLength > 50 ? column.MaxLength : 50;
gcolumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
else if (datatype.Equals("System.DateTime"))
{
gcolumn = new CalendarColumn("yyyy-MM-dd HH:mm:ss");
gcolumn.Width = 130;
gcolumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
else
{
string mapInfo = TableUtil.StrProperty(column, "MapInfo");
if (!mapInfo.Equals(""))
{
DataMap dm = SystemContext.MapManager.FromMapInfo(mapInfo);
if (dm != null)
{
DataTable mtable = dm.GetMapTable(null);
if (mtable != null && mtable.Rows.Count > 0)
{
gcolumn = new DataGridViewComboBoxColumn();
DataGridViewComboBoxCell combboxcell = gcolumn.CellTemplate as DataGridViewComboBoxCell;
if (combboxcell != null)
{
combboxcell.DataSource = mtable;
combboxcell.ValueMember = "Key";
combboxcell.DisplayMember = "Value";
}
}
}
}
if (gcolumn == null)
{
gcolumn = new DataGridViewTextBoxColumn();
gcolumn.Width = column.MaxLength > 100 ? column.MaxLength : 100;
gcolumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
}
gcolumn.Name = column.ColumnName;
gcolumn.HeaderText = column.Caption;
gcolumn.DataPropertyName = column.ColumnName;
//gcolumn.Width = column.MaxLength;
//gcolumn.Width = column.MaxLength > 100 ? column.MaxLength : 100;
//gcolumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader;
grid.Columns.Add(gcolumn);
}
}
grid.AutoGenerateColumns = false;
grid.DataSource = GetBindingSource(table);
}
else
{
DataColumn column;
string mapInfo;
foreach (DataGridViewColumn gcolumn in grid.Columns)
{
column = table.Columns[gcolumn.DataPropertyName];
if (column != null)
{
mapInfo = TableUtil.StrProperty(column, "MapInfo");
if (!mapInfo.Equals(""))
{
DataMap dm = SystemContext.MapManager.FromMapInfo(mapInfo);
if (dm != null)
{
DataTable mtable = dm.GetMapTable(null);
if (mtable != null && mtable.Rows.Count > 0)
{
DataGridViewComboBoxCell combboxcell = gcolumn.CellTemplate as DataGridViewComboBoxCell;
if (combboxcell != null)
{
combboxcell.DataSource = mtable;
combboxcell.ValueMember = "Key";
combboxcell.DisplayMember = "Value";
}
}
}
}
}
}
grid.AutoGenerateColumns = false;
grid.DataSource = GetBindingSource(table);
}
grid.CellLeave -= new DataGridViewCellEventHandler(DataGridView_CellLeave);
grid.CellLeave += new DataGridViewCellEventHandler(DataGridView_CellLeave);
}
public void cargarDataGridViewCupones(DataGridView dgv, IEnumerable<Object> lista , String p_modoEdicion )
{
//dgv.Rows.Clear();
dgv.Columns.Clear();
foreach (var item in lista)
{
Type t = item.GetType();
PropertyInfo[] pi = t.GetProperties();
foreach (PropertyInfo p in pi)
{
DataGridViewColumn columna = new DataGridViewColumn();
DataGridViewCell cell = new DataGridViewTextBoxCell();
columna.CellTemplate = cell;
columna.Name = p.Name;
columna.HeaderText = p.Name;
columna.ReadOnly = true;
columna.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgv.Columns.Add(columna);
}
break;
}
DataGridViewCheckBoxColumn doWork = new DataGridViewCheckBoxColumn();
doWork.Name = "CONCILIAR";
doWork.HeaderText = "CONCILIAR";
doWork.FalseValue = "0";
doWork.TrueValue = "1";
dgv.Columns.Add(doWork);
if (p_modoEdicion !="SI") {
CalendarColumn doWork1 = new CalendarColumn();
doWork1.Name = "FECHA_ACREDITACION";
doWork1.HeaderText = "FECHA DE ACREDITACION";
doWork1.DefaultCellStyle.Format = "d";
dgv.Columns.Add(doWork1);
}
foreach (object item in lista)
{
var row = dgv.Rows.Add();
Type t =item.GetType();
PropertyInfo[] pi = t.GetProperties();
foreach (PropertyInfo p in pi)
{
Console.WriteLine(p.Name + " " + p.GetValue(item, null));
dgv.Rows[row].Cells[p.Name].Value = p.GetValue(item, null);
}
if (p_modoEdicion=="SI")
{
dgv.Rows[row].Cells["CONCILIAR"].Value = true;
dgv.Rows[row].Cells["FECHA_ACREDITACION"].Value = dgv.Rows[row].Cells["FECHA_ACREDITACION"].Value.ToString().Remove(10);
}
}
}
////////////////////////////////////////////////////////////////////////////////////////////
// Functions Private
////////////////////////////////////////////////////////////////////////////////////////////
private void buildTheDataGridView(bool thisCD)
{
// lineItemIDColumn
this.lineItemIDColumn = new DataGridViewTextBoxColumn();
this.lineItemIDColumn.Name = "lineItemIDColumn";
this.lineItemIDColumn.HeaderText = "lineItemID";
this.lineItemIDColumn.DataPropertyName = "id";
this.lineItemIDColumn.Width = 40;
this.lineItemIDColumn.Visible = false;
// transactionIDColumn
this.transactionIDColumn = new DataGridViewTextBoxColumn();
this.transactionIDColumn.Name = "transactionIDColumn";
this.transactionIDColumn.HeaderText = "transactionID";
this.transactionIDColumn.DataPropertyName = "transactionID";
this.transactionIDColumn.Width = 40;
this.transactionIDColumn.Visible = false;
// dateColumn
this.dateColumn = new CalendarColumn();
this.dateColumn.Name = "dateColumn";
this.dateColumn.HeaderText = "Date";
this.dateColumn.DataPropertyName = "date";
this.dateColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
this.dateColumn.Resizable = DataGridViewTriState.True;
this.dateColumn.Width = 85;
this.dateColumn.Visible = true;
// typeIDColumn
this.typeIDColumn = new DataGridViewComboBoxColumn();
this.typeIDColumn.Name = "typeIDColumn";
this.typeIDColumn.HeaderText = "Type";
this.typeIDColumn.DataSource = this.BindingSourceTypeIDCol;
this.typeIDColumn.DataPropertyName = "typeID";
this.typeIDColumn.DisplayMember = "name";
this.typeIDColumn.ValueMember = "id";
this.typeIDColumn.AutoComplete = true;
this.typeIDColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
this.typeIDColumn.Resizable = DataGridViewTriState.True;
this.typeIDColumn.DisplayStyleForCurrentCellOnly = true;
this.typeIDColumn.Width = 80;
this.typeIDColumn.Visible = true;
// accountIDColumn
this.accountIDColumn = new DataGridViewComboBoxColumn();
this.accountIDColumn.Name = "accountIDColumn";
this.accountIDColumn.HeaderText = "Source / Destination";
this.accountIDColumn.DataSource = this.BindingSourceAccountIDCol;
this.accountIDColumn.DataPropertyName = "accountID";
this.accountIDColumn.DisplayMember = "name";
this.accountIDColumn.ValueMember = "id";
this.accountIDColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
this.accountIDColumn.Resizable = DataGridViewTriState.True;
this.accountIDColumn.DisplayStyleForCurrentCellOnly = true;
this.accountIDColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
this.accountIDColumn.FillWeight = 120;
this.accountIDColumn.Visible = true;
// descriptionColumn
this.descriptionColumn = new DataGridViewTextBoxColumn();
this.descriptionColumn.Name = "descriptionColumn";
this.descriptionColumn.HeaderText = "Description";
this.descriptionColumn.DataPropertyName = "description";
this.descriptionColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
this.descriptionColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
this.descriptionColumn.FillWeight = 200;
this.descriptionColumn.Visible = true;
// confirmationNumColumn
this.confirmationNumColumn = new DataGridViewTextBoxColumn();
this.confirmationNumColumn.Name = "confirmationNumColumn";
this.confirmationNumColumn.HeaderText = "Confirmation #";
this.confirmationNumColumn.DataPropertyName = "confirmationNumber";
this.confirmationNumColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
this.confirmationNumColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
this.confirmationNumColumn.FillWeight = 100;
this.confirmationNumColumn.Visible = true;
// envelopeIDColumn
this.envelopeIDColumn = new DataGridViewComboBoxColumn();
this.envelopeIDColumn.Name = "envelopeIDColumn";
this.envelopeIDColumn.HeaderText = "Envelope";
this.envelopeIDColumn.DataSource = this.BindingSourceEnvelopeIDCol;
this.envelopeIDColumn.DataPropertyName = "envelopeID";
this.envelopeIDColumn.DisplayMember = "name";
this.envelopeIDColumn.ValueMember = "id";
this.envelopeIDColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
this.envelopeIDColumn.DisplayStyleForCurrentCellOnly = true;
this.envelopeIDColumn.Resizable = DataGridViewTriState.True;
this.envelopeIDColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
this.envelopeIDColumn.FillWeight = 100;
this.envelopeIDColumn.Visible = false;
this.envelopeIDColumn.ReadOnly = true;
// completeColumn
this.completeColumn = new DataGridViewTextBoxColumn();
this.completeColumn.Name = "completeColumn";
this.completeColumn.HeaderText = "CR";
this.completeColumn.DataPropertyName = "complete";
this.completeColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
this.completeColumn.DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
this.completeColumn.Width = 25;
this.completeColumn.ReadOnly = true;
// creditDebitColumn
this.creditDebitColumn = new DataGridViewTextBoxColumn();
this.creditDebitColumn.Name = "creditDebitColumn";
this.creditDebitColumn.HeaderText = "CD";
this.creditDebitColumn.DataPropertyName = "creditDebit";
this.creditDebitColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
this.creditDebitColumn.Width = 20;
this.creditDebitColumn.Visible = false;
// amountColumn
this.amountColumn = new DataGridViewTextBoxColumn();
this.amountColumn.Name = "amountColumn";
this.amountColumn.HeaderText = "Amount";
this.amountColumn.DataPropertyName = "amount";
this.amountColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
this.amountColumn.DefaultCellStyle = new MyCellStyleMoney();
this.amountColumn.Width = 65;
// This Data Grid View
this.Name = "theDataGridView";
this.DataSource = this.BindingSourceLineItemDGV;
this.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
this.SelectionMode = DataGridViewSelectionMode.CellSelect;
this.Dock = DockStyle.Fill;
this.AutoGenerateColumns = false;
this.AllowUserToOrderColumns = false;
this.AllowUserToDeleteRows = false;
this.AllowUserToResizeRows = false;
this.AllowUserToAddRows = true;
this.RowHeadersVisible = false;
this.ShowCellErrors = false;
this.ShowRowErrors = false;
this.MultiSelect = false;
this.Columns.AddRange(
new DataGridViewColumn[]
{
this.dateColumn,
this.lineItemIDColumn,
this.transactionIDColumn,
this.typeIDColumn,
this.accountIDColumn,
this.descriptionColumn,
this.confirmationNumColumn,
this.envelopeIDColumn,
this.completeColumn,
this.creditDebitColumn,
this.amountColumn
}
);
if (thisCD)
{
this.accountIDColumn.HeaderText = "Destination Account";
}
else
{
this.accountIDColumn.HeaderText = "Source Account";
}
}
private void buildGridViewInventory()
{
view.dgvInventory.Columns.Clear();
view.dgvInventory.ReadOnly = false;
view.dgvInventory.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
DataGridViewRow row = view.dgvInventory.RowTemplate;
row.Height = 35;
row.MinimumHeight = 26;
DataGridViewCellStyle cellStyleMiddleRight = new DataGridViewCellStyle();
cellStyleMiddleRight.Alignment = DataGridViewContentAlignment.MiddleRight;
DataGridViewCellStyle cellStyleColor1 = new DataGridViewCellStyle();
cellStyleColor1.BackColor = Color.WhiteSmoke;
cellStyleColor1.Alignment = DataGridViewContentAlignment.MiddleRight;
CalendarColumn colDate = new CalendarColumn();
colDate.HeaderText = "Date";
colDate.Name = "colDate";
colDate.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
colDate.Width = 100;
colDate.DataPropertyName = "regDate";
view.dgvInventory.Columns.Add(colDate);
DataGridViewTextBoxColumn colDOINVNO = new DataGridViewTextBoxColumn();
colDOINVNO.HeaderText = "D.O Invoice No.";
colDOINVNO.Name = "colDOINVNO";
colDOINVNO.DataPropertyName = "DOInvoiceNo";
colDOINVNO.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
colDOINVNO.Width = 130;
view.dgvInventory.Columns.Add(colDOINVNO);
DataGridViewComboBoxColumn colCustomer = new DataGridViewComboBoxColumn();
colCustomer.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;
colCustomer.HeaderText = "Customer";
colCustomer.Name = "colCustomer";
colCustomer.DataSource = customerModel.getAllCustomers();
colCustomer.DisplayMember = "customerName";
colCustomer.ValueMember = "customerID";
colCustomer.DataPropertyName = "customerId";
view.dgvInventory.Columns.Add(colCustomer);
DataGridViewTextBoxColumn colRecD = new DataGridViewTextBoxColumn();
colRecD.HeaderText = "REC'D";
colRecD.DefaultCellStyle = cellStyleMiddleRight;
colRecD.Name = "colRecD";
colRecD.DataPropertyName = "recd";
colRecD.ValueType = typeof(int);
colRecD.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
colRecD.Width = 80;
view.dgvInventory.Columns.Add(colRecD);
DataGridViewTextBoxColumn colLSold = new DataGridViewTextBoxColumn();
colLSold.HeaderText = "Sold";
colLSold.DefaultCellStyle = cellStyleMiddleRight;
colLSold.Name = "colLSold";
colLSold.DataPropertyName = "lSold";
colLSold.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
colLSold.Width = 80;
view.dgvInventory.Columns.Add(colLSold);
DataGridViewTextBoxColumn colGOnHand = new DataGridViewTextBoxColumn();
colGOnHand.ReadOnly = true;
colGOnHand.DefaultCellStyle = cellStyleMiddleRight;
colGOnHand.Name = "colGOnHand";
colGOnHand.HeaderText = "G. On Hand";
colGOnHand.DataPropertyName = "gOnHand";
colGOnHand.DefaultCellStyle = cellStyleColor1;
view.dgvInventory.Columns.Add(colGOnHand);
DataGridViewTextBoxColumn colPrice = new DataGridViewTextBoxColumn();
colPrice.HeaderText = "Price 1";
colPrice.DefaultCellStyle = cellStyleMiddleRight;
colPrice.Name = "colPrice";
colPrice.DataPropertyName = "price";
colPrice.ValueType = Type.GetType("System.Decimal");
colPrice.DefaultCellStyle.Format = "0.00##";
colPrice.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
colPrice.Width = 80;
view.dgvInventory.Columns.Add(colPrice);
DataGridViewTextBoxColumn colLRecD = new DataGridViewTextBoxColumn();
colLRecD.HeaderText = "REC'D";
colLRecD.DefaultCellStyle = cellStyleMiddleRight;
colLRecD.Name = "colRecD";
colLRecD.DataPropertyName = "oemRecd";
colLRecD.ValueType = typeof(int);
colLRecD.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
colRecD.Width = 80;
view.dgvInventory.Columns.Add(colLRecD);
DataGridViewTextBoxColumn colRSold = new DataGridViewTextBoxColumn();
colRSold.HeaderText = "Sold";
colRSold.DefaultCellStyle = cellStyleMiddleRight;
colRSold.Name = "colRSold";
colRSold.DataPropertyName = "rSold";
colRSold.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
colRSold.Width = 80;
view.dgvInventory.Columns.Add(colRSold);
DataGridViewTextBoxColumn colIMOnHand = new DataGridViewTextBoxColumn();
colIMOnHand.HeaderText = "OEM On Hand";
colIMOnHand.ReadOnly = true;
colIMOnHand.DefaultCellStyle = cellStyleMiddleRight;
colIMOnHand.Name = "colIMOnHand";
colIMOnHand.DataPropertyName = "imOnHand";
colIMOnHand.DefaultCellStyle = cellStyleColor1;
view.dgvInventory.Columns.Add(colIMOnHand);
DataGridViewTextBoxColumn colPrice2 = new DataGridViewTextBoxColumn();
colPrice2.HeaderText = "Price 2";
colPrice2.DefaultCellStyle = cellStyleMiddleRight;
colPrice2.Name = "colPrice";
colPrice2.DataPropertyName = "price2";
colPrice2.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
colPrice2.Width = 80;
colPrice2.ValueType = Type.GetType("System.Decimal");
colPrice2.DefaultCellStyle.Format = "0.00##";
view.dgvInventory.Columns.Add(colPrice2);
DataGridViewTextBoxColumn colTotalAvailabel = new DataGridViewTextBoxColumn();
colTotalAvailabel.ReadOnly = true;
colTotalAvailabel.DefaultCellStyle = cellStyleMiddleRight;
colTotalAvailabel.Name = "colTotalAvailabel";
colTotalAvailabel.HeaderText = "Total Availabel";
colTotalAvailabel.DataPropertyName = "totalAvailabel";
colTotalAvailabel.DefaultCellStyle = cellStyleColor1;
view.dgvInventory.Columns.Add(colTotalAvailabel);
DataGridViewTextBoxColumn colTotalDemand = new DataGridViewTextBoxColumn();
colTotalDemand.ReadOnly = true;
colTotalDemand.DefaultCellStyle = cellStyleMiddleRight;
colTotalDemand.Name = "colTotalDemand";
colTotalDemand.HeaderText = "Total Demand";
colTotalDemand.DataPropertyName = "totalDemand";
colTotalDemand.DefaultCellStyle = cellStyleColor1;
view.dgvInventory.Columns.Add(colTotalDemand);
DataGridViewTextBoxColumn colDetail = new DataGridViewTextBoxColumn();
colDetail.HeaderText = "Remark";
colDetail.Name = "colDetail";
colDetail.DataPropertyName = "detail";
view.dgvInventory.Columns.Add(colDetail);
}
