private void FormatearSpread() { FarPoint.Win.Spread.CellType.TextCellType tipoTexto = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.NumberCellType tipoEntero = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType tipoDoble = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.PercentCellType tipoPorcentaje = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType tipoHora = new FarPoint.Win.Spread.CellType.DateTimeCellType(); spDirectorios.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; spDirectorios.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; spDirectorios.ActiveSheet.ColumnHeader.Rows[0].Height = Principal.alturaEncabezadosChicoSpread; spDirectorios.ActiveSheet.Rows[-1].Height = Principal.alturaEncabezadosGrandeSpread; spDirectorios.ActiveSheet.GrayAreaBackColor = Color.White; spDirectorios.ActiveSheet.OperationMode = FarPoint.Win.Spread.OperationMode.SingleSelect; spDirectorios.Font = new Font(Principal.tipoLetraSpread, Principal.tamañoLetraSpread, FontStyle.Regular); spDirectorios.ActiveSheet.ColumnHeader.Rows[0].Font = new Font(Principal.tipoLetraSpread, Principal.tamañoLetraSpread, FontStyle.Bold); int numeracion = 0; spDirectorios.ActiveSheet.Columns[numeracion].Tag = "id"; numeracion += 1; spDirectorios.ActiveSheet.Columns[numeracion].Tag = "nombre"; numeracion += 1; spDirectorios.ActiveSheet.Columns[numeracion].Tag = "descripcion"; numeracion += 1; spDirectorios.ActiveSheet.Columns[numeracion].Tag = "esPredeterminado"; numeracion += 1; spDirectorios.ActiveSheet.Columns["id"].Width = 50; spDirectorios.ActiveSheet.Columns["nombre"].Width = 400; spDirectorios.ActiveSheet.Columns["descripcion"].Width = 500; spDirectorios.ActiveSheet.Columns["esPredeterminado"].Width = 200; spDirectorios.ActiveSheet.ColumnHeader.Cells[0, spDirectorios.ActiveSheet.Columns["id"].Index].Value = "No.".ToUpper(); spDirectorios.ActiveSheet.ColumnHeader.Cells[0, spDirectorios.ActiveSheet.Columns["nombre"].Index].Value = "Nombre".ToUpper(); spDirectorios.ActiveSheet.ColumnHeader.Cells[0, spDirectorios.ActiveSheet.Columns["descripcion"].Index].Value = "Descripción".ToUpper(); spDirectorios.ActiveSheet.ColumnHeader.Cells[0, spDirectorios.ActiveSheet.Columns["esPredeterminado"].Index].Value = "Es Predeterminado?".ToUpper(); Application.DoEvents(); }
private void TemperatureDialog_Load(object sender, EventArgs e) { ComboTemperature.DataSource = TemperatureHelperClient.GetTemperatureTypes(TestRoomCode); FpSpread_Info.Rows.Count = 0; FpSpread_Info.Columns.Count = 12; FpSpread_Info.ColumnHeader.Cells[0, 0].Text = "ID"; FpSpread_Info.ColumnHeader.Cells[0, 1].Text = "试验室编码"; FpSpread_Info.ColumnHeader.Cells[0, 2].Text = "试验日期"; FpSpread_Info.ColumnHeader.Cells[0, 3].Text = "早晨温度"; FpSpread_Info.ColumnHeader.Cells[0, 4].Text = "中午温度"; FpSpread_Info.ColumnHeader.Cells[0, 5].Text = "傍晚温度"; FpSpread_Info.ColumnHeader.Cells[0, 6].Text = "平均温度"; FpSpread_Info.ColumnHeader.Cells[0, 7].Text = "备注"; FpSpread_Info.ColumnHeader.Cells[0, 8].Text = "LastEditUser"; FpSpread_Info.ColumnHeader.Cells[0, 9].Text = "LastEditTime"; FpSpread_Info.ColumnHeader.Cells[0, 10].Text = "IsUpdated"; FpSpread_Info.ColumnHeader.Cells[0, 11].Text = "TemperatureType"; FarPoint.Win.Spread.CellType.DateTimeCellType datetime = new FarPoint.Win.Spread.CellType.DateTimeCellType(); datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate; FarPoint.Win.Spread.CellType.NumberCellType number = new FarPoint.Win.Spread.CellType.NumberCellType(); number.DecimalPlaces = 1; number.FixedPoint = true; FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType(); //number var TemperatureType = Convert.ToInt32(ComboTemperature.SelectedValue); DataTable Data = ModuleHelperClient.GetTemperatureList("000", new DateTime(2014, 1, 2), new DateTime(2014, 1, 1), TemperatureType); FpSpread_Info.DataSource = Data; FpSpread_Info.Columns[0].Visible = false; FpSpread_Info.Columns[1].Visible = false; FpSpread_Info.Columns[2].CellType = datetime; FpSpread_Info.Columns[2].Locked = true; FpSpread_Info.Columns[3].CellType = number; FpSpread_Info.Columns[4].CellType = number; FpSpread_Info.Columns[5].CellType = number; FpSpread_Info.Columns[6].CellType = number; FpSpread_Info.Columns[6].Locked = true; FpSpread_Info.Columns[7].CellType = text; FpSpread_Info.Columns[8].Visible = false; FpSpread_Info.Columns[9].Visible = false; FpSpread_Info.Columns[10].Visible = false; FpSpread_Info.Columns[11].Visible = false; FpSpread_Info.Columns[2].Width = 100; FpSpread_Info.Columns[3].Width = 100; FpSpread_Info.Columns[4].Width = 100; FpSpread_Info.Columns[5].Width = 100; FpSpread_Info.Columns[6].Width = 100; FpSpread_Info.Columns[7].Width = 200; DateTimePicker_Start.Value = DateTime.Now.AddMonths(-1); DateTimePicker_End.Value = DateTime.Now; SetDefaultStyle(); }
/// <summary> /// 设置列的类型 /// </summary> private void InitColumnsType() { FarPoint.Win.Spread.CellType.ImageCellType imageCellType = new FarPoint.Win.Spread.CellType.ImageCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType2 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).CellType = imageCellType; this.fpSpread1_Sheet1.Columns.Get(0).CellType = imageCellType; this.fpSpread1_Sheet1.Columns.Get(3).CellType = dateTimeCellType2; dateTimeCellType2.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime; }
private void setGrdViewH() { FarPoint.Win.Spread.EnhancedInterfaceRenderer outlinelook = new FarPoint.Win.Spread.EnhancedInterfaceRenderer(); outlinelook.RangeGroupBackgroundColor = Color.LightGreen; outlinelook.RangeGroupButtonBorderColor = Color.Red; outlinelook.RangeGroupLineColor = Color.Blue; grdView.InterfaceRenderer = outlinelook; grdView.BorderStyle = BorderStyle.None; grdView.Sheets[0].Columns[2, colgrd].AllowAutoFilter = true; grdView.Sheets[0].Columns[2, colgrd].AllowAutoSort = true; grdView.Sheets[0].AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu; FarPoint.Win.Spread.CellType.NumberCellType objNumCell = new FarPoint.Win.Spread.CellType.NumberCellType(); objNumCell.DecimalPlaces = 0; objNumCell.MinimumValue = 1; objNumCell.MaximumValue = 9999; objNumCell.ShowSeparator = false; FarPoint.Win.Spread.CellType.DateTimeCellType datecell = new FarPoint.Win.Spread.CellType.DateTimeCellType(); datecell.DateSeparator = " | "; datecell.TimeSeparator = "."; datecell.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime; FarPoint.Win.Spread.CellType.CurrencyCellType ctest = new FarPoint.Win.Spread.CellType.CurrencyCellType(); FarPoint.Win.Spread.CellType.TextCellType objTextCell = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.ButtonCellType buttencell = new FarPoint.Win.Spread.CellType.ButtonCellType(); FarPoint.Win.Spread.CellType.ComboBoxCellType combocell = new FarPoint.Win.Spread.CellType.ComboBoxCellType(); combocell.Items = sC.mHisDB.fm20; //grdView.Sheets.Count = 1; grdView.Sheets[0].ColumnCount = colCnt; grdView.Sheets[0].OperationMode = FarPoint.Win.Spread.OperationMode.RowMode; grdView.Sheets[0].ColumnHeader.Cells[0, colE].Text = "edit"; grdView.Sheets[0].ColumnHeader.Cells[0, colS].Text = "save"; grdView.Sheets[0].ColumnHeader.Cells[0, colCode].Text = "FN_CD"; grdView.Sheets[0].ColumnHeader.Cells[0, colDesc].Text = "Description"; grdView.Sheets[0].ColumnHeader.Cells[0, colGrpss2].Text = "grd_ss_2"; grdView.Sheets[0].ColumnHeader.Cells[0, colgrd].Text = "GRD_CD"; grdView.Sheets[0].Columns[colE].Width = 50; grdView.Sheets[0].Columns[colS].Width = 50; grdView.Sheets[0].Columns[colCode].Width = 80; grdView.Sheets[0].Columns[colDesc].Width = 250; grdView.Sheets[0].Columns[colGrpss2].Width = 250; grdView.Sheets[0].Columns[colgrd].Width = 300; grdView.Sheets[0].Columns[colE].CellType = buttencell; grdView.Sheets[0].Columns[colS].CellType = buttencell; grdView.Sheets[0].Columns[colCode].CellType = objTextCell; grdView.Sheets[0].Columns[colDesc].CellType = objTextCell; grdView.Sheets[0].Columns[colgrd].CellType = objTextCell; grdView.Sheets[0].Columns[colGrpss2].CellType = combocell; grdView.Sheets[0].Columns[coledit].Visible = false; }
public static void SetDateFormat(FarPoint.Win.Spread.Column col) { string strDateFormat = Common.CurrentUserInfomation.DateFormatString; FarPoint.Win.Spread.CellType.DateTimeCellType type = new FarPoint.Win.Spread.CellType.DateTimeCellType(); type.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined; type.UserDefinedFormat = strDateFormat; col.CellType = type; //type.user define FormatException }
/// <summary> /// 设置Farpoint显示格式 /// </summary> private void SetFpFormat() { FarPoint.Win.Spread.CellType.NumberCellType numbCellType = new FarPoint.Win.Spread.CellType.NumberCellType(); numbCellType.DecimalPlaces = 0; numbCellType.MaximumValue = 9999; numbCellType.MinimumValue = 0; FarPoint.Win.Spread.CellType.DateTimeCellType dtCellType = new FarPoint.Win.Spread.CellType.DateTimeCellType(); dtCellType.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined; dtCellType.UserDefinedFormat = "yyyy-MM-dd"; dtCellType.ReadOnly = true; FarPoint.Win.Spread.CellType.TextCellType txtCellType = new FarPoint.Win.Spread.CellType.TextCellType(); txtCellType.ReadOnly = true; #region "设置每列的颜色" this.neuSpread1_Sheet1.Columns[0].CellType = dtCellType; this.neuSpread1_Sheet1.Columns[0].BackColor = System.Drawing.SystemColors.Control; this.neuSpread1_Sheet1.ColumnHeader.Columns[0].Label = "日期"; this.neuSpread1_Sheet1.ColumnHeader.Columns[0].Width = 90f; this.neuSpread1_Sheet1.Columns[1].CellType = txtCellType; this.neuSpread1_Sheet1.Columns[1].Visible = false; this.neuSpread1_Sheet1.Columns[2].CellType = txtCellType; this.neuSpread1_Sheet1.Columns[2].BackColor = System.Drawing.SystemColors.Control; this.neuSpread1_Sheet1.ColumnHeader.Columns[2].Label = "科室名称"; this.neuSpread1_Sheet1.Columns[3].CellType = numbCellType; this.neuSpread1_Sheet1.ColumnHeader.Columns[3].Label = "编制内病床数"; this.neuSpread1_Sheet1.ColumnHeader.Columns[3].Width = 90f; this.neuSpread1_Sheet1.Columns[3].BackColor = System.Drawing.SystemColors.Control; this.neuSpread1_Sheet1.Columns[4].CellType = numbCellType; this.neuSpread1_Sheet1.ColumnHeader.Columns[4].Label = "原有病人数"; this.neuSpread1_Sheet1.Columns[4].BackColor = System.Drawing.SystemColors.Control; this.neuSpread1_Sheet1.Columns[5].CellType = numbCellType; this.neuSpread1_Sheet1.ColumnHeader.Columns[5].Label = "常规入院数"; this.neuSpread1_Sheet1.Columns[6].CellType = numbCellType; this.neuSpread1_Sheet1.ColumnHeader.Columns[6].Label = "转入数"; this.neuSpread1_Sheet1.Columns[7].CellType = numbCellType; this.neuSpread1_Sheet1.ColumnHeader.Columns[7].Label = "常规出院数"; this.neuSpread1_Sheet1.Columns[8].CellType = numbCellType; this.neuSpread1_Sheet1.ColumnHeader.Columns[8].Label = "转出数"; this.neuSpread1_Sheet1.Columns[9].CellType = numbCellType; this.neuSpread1_Sheet1.ColumnHeader.Columns[9].Label = "陪护人数"; this.neuSpread1_Sheet1.Columns[10].CellType = numbCellType; this.neuSpread1_Sheet1.Columns[10].ForeColor = Color.Red; this.neuSpread1_Sheet1.Columns[10].Font = new Font("Arial", 9, FontStyle.Bold); this.neuSpread1_Sheet1.ColumnHeader.Columns[10].Label = "期末实有人数"; this.neuSpread1_Sheet1.ColumnHeader.Columns[10].Width = 100f; this.neuSpread1_Sheet1.Columns[11].CellType = numbCellType; this.neuSpread1_Sheet1.Columns[11].Visible = false; #endregion }
/// <summary> /// 设置格式 /// </summary> private void SetFP() { FarPoint.Win.Spread.CellType.TextCellType txtOnly = new FarPoint.Win.Spread.CellType.TextCellType(); txtOnly.ReadOnly = true; FarPoint.Win.Spread.CellType.TextCellType txt = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateType = new FarPoint.Win.Spread.CellType.DateTimeCellType(); dateType.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime; this.neuSpread1_Sheet1.Columns[1].Visible = false; this.neuSpread1_Sheet1.Columns[2].CellType = txtOnly; this.neuSpread1_Sheet1.Columns[3].CellType = txtOnly; this.neuSpread1_Sheet1.Columns[4].CellType = txtOnly; this.neuSpread1_Sheet1.Columns[5].CellType = txtOnly; this.neuSpread1_Sheet1.Columns[6].CellType = txtOnly; this.neuSpread1_Sheet1.Columns[7].CellType = txtOnly; this.neuSpread1_Sheet1.Columns[8].CellType = txtOnly; this.neuSpread1_Sheet1.Columns[9].CellType = txtOnly; this.neuSpread1_Sheet1.Columns[10].CellType = txtOnly; this.neuSpread1_Sheet1.Columns[11].CellType = txtOnly; this.neuSpread1_Sheet1.Columns[13].CellType = txtOnly; //配药护士 this.neuSpread1_Sheet1.Columns[14].CellType = txtOnly; //注射护士 this.neuSpread1_Sheet1.Columns[17].CellType = txtOnly; //拔针护士 if (this.formSet == "配药") //配药确认 { this.neuSpread1_Sheet1.Columns[14].Visible = false; //注射护士 this.neuSpread1_Sheet1.Columns[15].Visible = false; //注射时间 this.neuSpread1_Sheet1.Columns[17].Visible = false; //拔针人 this.neuSpread1_Sheet1.Columns[18].Visible = false; //拔针时间 this.neuSpread1_Sheet1.Columns[19].Visible = false; //送急诊时间 } if (this.formSet == "注射") //注射确认 { this.neuSpread1_Sheet1.Columns[13].Visible = false; //配药护士 this.neuSpread1_Sheet1.Columns[17].Visible = false; //拔针人 this.neuSpread1_Sheet1.Columns[18].Visible = false; //拔针时间 } if (this.formSet == "拔针") //拔针确认 { this.neuSpread1_Sheet1.Columns[13].Visible = false; //配药护士 this.neuSpread1_Sheet1.Columns[14].Visible = false; //注射护士 this.neuSpread1_Sheet1.Columns[15].Visible = false; //注射时间 this.neuSpread1_Sheet1.Columns[19].Visible = false; //送急诊时间 } this.neuSpread1_Sheet1.Columns[9].Visible = false; // this.neuSpread1_Sheet1.Columns[10].Visible = false; // this.neuSpread1_Sheet1.Columns[11].Visible = false; // this.neuSpread1_Sheet1.Columns[12].Visible = false; // this.neuSpread1_Sheet1.Columns[16].Visible = false; //滴速 }
private void NotifyUserMsgDlg_Load(object sender, EventArgs e) { FpSpread_Info.Columns.Count = 10; FpSpread_Info.ColumnHeader.RowCount = 1; FpSpread_Info.ColumnHeader.Cells[0, 0].Text = "SessionID"; FpSpread_Info.ColumnHeader.Cells[0, 0].Tag = "SessionID"; FpSpread_Info.ColumnHeader.Cells[0, 1].Text = "LineID"; FpSpread_Info.ColumnHeader.Cells[0, 1].Tag = "LineID"; FpSpread_Info.ColumnHeader.Cells[0, 2].Text = "选择"; FpSpread_Info.ColumnHeader.Cells[0, 2].Tag = "SelectTag"; FpSpread_Info.ColumnHeader.Cells[0, 3].Text = "线路名称"; FpSpread_Info.ColumnHeader.Cells[0, 3].Tag = "LineName"; FpSpread_Info.ColumnHeader.Cells[0, 4].Text = "标段名称"; FpSpread_Info.ColumnHeader.Cells[0, 4].Tag = "SegmentName"; FpSpread_Info.ColumnHeader.Cells[0, 5].Text = "单位名称"; FpSpread_Info.ColumnHeader.Cells[0, 5].Tag = "CompanyName"; FpSpread_Info.ColumnHeader.Cells[0, 6].Text = "试验室名称"; FpSpread_Info.ColumnHeader.Cells[0, 6].Tag = "TestRoomName"; FpSpread_Info.ColumnHeader.Cells[0, 7].Text = "用户名"; FpSpread_Info.ColumnHeader.Cells[0, 7].Tag = "UserName"; FpSpread_Info.ColumnHeader.Cells[0, 8].Text = "最后活动时间"; FpSpread_Info.ColumnHeader.Cells[0, 8].Tag = "LastActiveTime"; FpSpread_Info.ColumnHeader.Cells[0, 9].Text = "登录时间"; FpSpread_Info.ColumnHeader.Cells[0, 9].Tag = "LoginTime"; FpSpread_Info.Columns[0].Width = 10; FpSpread_Info.Columns[1].Width = 10; FpSpread_Info.Columns[2].Width = 40; FpSpread_Info.Columns[3].Width = 100; FpSpread_Info.Columns[4].Width = 60; FpSpread_Info.Columns[5].Width = 100; FpSpread_Info.Columns[6].Width = 80; FpSpread_Info.Columns[7].Width = 80; FpSpread_Info.Columns[8].Width = 120; FpSpread_Info.Columns[9].Width = 120; FpSpread_Info.Columns[0].Visible = false; FpSpread_Info.Columns[1].Visible = false; FarPoint.Win.Spread.CellType.DateTimeCellType datetime = new FarPoint.Win.Spread.CellType.DateTimeCellType(); datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.LongDateWithTime; FpSpread_Info.Columns[8].CellType = datetime; FpSpread_Info.Columns[9].CellType = datetime; CheckBoxCellType checkBox = new CheckBoxCellType(); FpSpread_Info.Columns[2].CellType = checkBox; DataOnlineUser = LineHelperClient.GetOnlineUserList(); BindLines(); //BindData(); }
private void PXReportDialog_Load(object sender, EventArgs e) { DateTime start = DateTime.Parse("2013-7-1"); if (DateTime.Now.AddDays(-30) > start) { start = DateTime.Now.AddDays(-30); } DateTimePicker_Start.Text = start.ToString("yyyy年M月dd日"); DateTimePicker_End.Text = DateTime.Now.ToString("yyyy年M月dd日"); FpSpread_Info.Columns.Count = 10; FpSpread_Info.ColumnHeader.RowCount = 1; FpSpread_Info.ColumnHeader.Cells[0, 0].Text = "施工标段"; FpSpread_Info.Columns[0].Width = 60; FpSpread_Info.ColumnHeader.Cells[0, 1].Text = "施工单位"; FpSpread_Info.Columns[1].Width = 60; FpSpread_Info.ColumnHeader.Cells[0, 2].Text = "施工试验室"; FpSpread_Info.Columns[2].Width = 80; FpSpread_Info.ColumnHeader.Cells[0, 3].Text = "平行委托编号"; FpSpread_Info.Columns[3].Width = 100; FpSpread_Info.ColumnHeader.Cells[0, 4].Text = "平行报告编号"; FpSpread_Info.Columns[4].Width = 100; FpSpread_Info.ColumnHeader.Cells[0, 5].Text = "平行报告日期"; FpSpread_Info.Columns[5].Width = 80; FpSpread_Info.ColumnHeader.Cells[0, 6].Text = "施工委托编号"; FpSpread_Info.Columns[6].Width = 100; FpSpread_Info.ColumnHeader.Cells[0, 7].Text = "施工报告编号"; FpSpread_Info.Columns[7].Width = 100; FpSpread_Info.ColumnHeader.Cells[0, 8].Text = "施工报告日期"; FpSpread_Info.Columns[8].Width = 80; FpSpread_Info.ColumnHeader.Cells[0, 9].Text = "平行时间"; FpSpread_Info.Columns[9].Width = 80; FarPoint.Win.Spread.CellType.DateTimeCellType datetime = new FarPoint.Win.Spread.CellType.DateTimeCellType(); datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate; FpSpread_Info.Columns[5].CellType = datetime; FpSpread_Info.Columns[8].CellType = datetime; FpSpread_Info.Columns[9].CellType = datetime; }
private void TemperatureDialog_Load(object sender, EventArgs e) { FpSpread_Info.Rows.Count = 0; FpSpread_Info.Columns.Count = 12; FpSpread_Info.ColumnHeader.Cells[0, 0].Text = "ID"; FpSpread_Info.ColumnHeader.Cells[0, 1].Text = "项名称"; FpSpread_Info.ColumnHeader.Cells[0, 2].Text = "项类型"; FpSpread_Info.ColumnHeader.Cells[0, 3].Text = "权重"; FpSpread_Info.ColumnHeader.Cells[0, 4].Text = "中午温度"; FpSpread_Info.ColumnHeader.Cells[0, 5].Text = "傍晚温度"; FpSpread_Info.ColumnHeader.Cells[0, 6].Text = "平均温度"; FpSpread_Info.ColumnHeader.Cells[0, 7].Text = "备注"; FpSpread_Info.ColumnHeader.Cells[0, 10].Text = "IsUpdated"; FarPoint.Win.Spread.CellType.DateTimeCellType datetime = new FarPoint.Win.Spread.CellType.DateTimeCellType(); datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate; FarPoint.Win.Spread.CellType.NumberCellType number = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType(); //number FpSpread_Info.Columns[0].Visible = false; FpSpread_Info.Columns[1].Visible = false; FpSpread_Info.Columns[2].CellType = datetime; FpSpread_Info.Columns[2].Locked = true; FpSpread_Info.Columns[3].CellType = number; FpSpread_Info.Columns[4].CellType = number; FpSpread_Info.Columns[5].CellType = number; FpSpread_Info.Columns[6].CellType = number; FpSpread_Info.Columns[6].Locked = true; FpSpread_Info.Columns[7].CellType = text; FpSpread_Info.Columns[8].Visible = false; FpSpread_Info.Columns[9].Visible = false; FpSpread_Info.Columns[10].Visible = false; FpSpread_Info.Columns[11].Visible = false; int TemperatureType = 0; DataTable Data = ModuleHelperClient.GetTemperatureList("000", new DateTime(2014, 1, 2), new DateTime(2014, 1, 1), TemperatureType); FpSpread_Info.DataSource = Data; FpSpread_Info.Columns[2].Width = 100; FpSpread_Info.Columns[3].Width = 100; FpSpread_Info.Columns[4].Width = 100; FpSpread_Info.Columns[5].Width = 100; FpSpread_Info.Columns[6].Width = 100; FpSpread_Info.Columns[7].Width = 200; }
/// <summary> /// 设置Farpoint显示格式 /// </summary> private void SetFarPointFormat() { Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType numbType = new Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType(); FarPoint.Win.Spread.CellType.TextCellType txtonly = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType txttype = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.ComboBoxCellType cmbType = new FarPoint.Win.Spread.CellType.ComboBoxCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dtimeType = new FarPoint.Win.Spread.CellType.DateTimeCellType(); // 有效无效 string[] items = new string[] { "有效", "无效" }; numbType.DecimalPlaces = 0; numbType.MaximumValue = 99999; numbType.MinimumValue = 0; txtonly.ReadOnly = true; cmbType.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.CtrlArrows; cmbType.Items = items; this.neuSpread1_Sheet1.Columns[0].CellType = txtonly; this.neuSpread1_Sheet1.Columns[0].Width = 100; this.neuSpread1_Sheet1.Columns[0].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.neuSpread1_Sheet1.Columns[1].CellType = txtonly; this.neuSpread1_Sheet1.Columns[1].Width = 140; this.neuSpread1_Sheet1.Columns[1].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.neuSpread1_Sheet1.Columns[2].CellType = txtonly; this.neuSpread1_Sheet1.Columns[2].Width = 100; this.neuSpread1_Sheet1.Columns[2].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.neuSpread1_Sheet1.Columns[2].Resizable = false; this.neuSpread1_Sheet1.Columns[3].CellType = numbType; this.neuSpread1_Sheet1.Columns[4].CellType = numbType; this.neuSpread1_Sheet1.Columns[5].CellType = txttype; this.neuSpread1_Sheet1.Columns[5].Width = 70; this.neuSpread1_Sheet1.Columns[6].CellType = cmbType; this.neuSpread1_Sheet1.Columns[6].Width = 80; this.neuSpread1_Sheet1.Columns[7].CellType = txttype; this.neuSpread1_Sheet1.Columns[7].Width = 200; this.neuSpread1_Sheet1.Columns[7].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.neuSpread1_Sheet1.Columns[8].Visible = false; }
private void UnusedTestDataView_Load(object sender, EventArgs e) { FpSpread_Info.Rows.Count = 0; FpSpread_Info.Columns.Count = 12; FpSpread_Info.ColumnHeader.Cells[0, 0].Text = "是否入库"; FpSpread_Info.ColumnHeader.Cells[0, 1].Text = "是否离线"; FpSpread_Info.ColumnHeader.Cells[0, 2].Text = "试验日期"; FpSpread_Info.ColumnHeader.Cells[0, 3].Text = "委托编号"; FpSpread_Info.ColumnHeader.Cells[0, 4].Text = "试验项目"; FpSpread_Info.ColumnHeader.Cells[0, 5].Text = "序号"; FpSpread_Info.ColumnHeader.Cells[0, 6].Text = "试验用户"; FpSpread_Info.ColumnHeader.Cells[0, 7].Text = "试验结果"; FpSpread_Info.ColumnHeader.Cells[0, 8].Text = "ModuleID"; FpSpread_Info.ColumnHeader.Cells[0, 9].Text = "ID"; FpSpread_Info.ColumnHeader.Cells[0, 10].Text = "试验室编码"; FpSpread_Info.ColumnHeader.Cells[0, 11].Text = "机器编码"; FarPoint.Win.Spread.CellType.DateTimeCellType datetime = new FarPoint.Win.Spread.CellType.DateTimeCellType(); datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime; FarPoint.Win.Spread.CellType.NumberCellType number = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType(); //number FpSpread_Info.Columns[2].CellType = datetime; FpSpread_Info.Columns[8].Visible = false; FpSpread_Info.Columns[9].Visible = false; SearchUnusedTestData("!@##@!"); btnManualUploadMQ.Text = "启动实时队列"; if (Yqun.Common.ContextCache.ApplicationContext.Current.UserCode == "-2" && Yqun.Common.ContextCache.ApplicationContext.Current.UserName == "谭利平") { btnManualUploadMQ.Visible = true; btnReloadMQ.Visible = true; btnStartMQAll.Visible = true; } else { btnManualUploadMQ.Visible = false; //btnReloadMQ.Visible = false; btnStartMQAll.Visible = false; } if (Yqun.Common.ContextCache.ApplicationContext.Current.UserCode == "-1") { btnReloadMQ.Visible = true; } }
/// <summary> /// 初始化列表 /// </summary> private void SetFp( ) { FarPoint.Win.Spread.CellType.TextCellType textCellType1 = new FarPoint.Win.Spread.CellType.TextCellType( ); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType1 = new FarPoint.Win.Spread.CellType.DateTimeCellType( ); dateTimeCellType1.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.TimeOnly; this.neuSpread1_Sheet1.Columns.Get(0).CellType = textCellType1; this.neuSpread1_Sheet1.Columns.Get(0).Label = "取药科室编码"; this.neuSpread1_Sheet1.Columns.Get(0).Visible = false; this.neuSpread1_Sheet1.Columns.Get(1).AllowAutoSort = true; this.neuSpread1_Sheet1.Columns.Get(1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.neuSpread1_Sheet1.Columns.Get(1).Label = "取药科室"; this.neuSpread1_Sheet1.Columns.Get(1).Locked = true; this.neuSpread1_Sheet1.Columns.Get(1).Width = 165F; this.neuSpread1_Sheet1.Columns.Get(2).AllowAutoSort = true; this.neuSpread1_Sheet1.Columns.Get(2).Label = "药品类别"; this.neuSpread1_Sheet1.Columns.Get(2).Width = 82F; this.neuSpread1_Sheet1.Columns.Get(2).CellType = comboBoxCellType1; this.neuSpread1_Sheet1.Columns.Get(3).Label = "开始时间"; this.neuSpread1_Sheet1.Columns.Get(3).Width = 92F; this.neuSpread1_Sheet1.Columns.Get(3).CellType = dateTimeCellType1; this.neuSpread1_Sheet1.Columns.Get(4).Label = "结束时间"; this.neuSpread1_Sheet1.Columns.Get(4).Width = 92F; this.neuSpread1_Sheet1.Columns.Get(4).CellType = dateTimeCellType1; this.neuSpread1_Sheet1.Columns.Get(5).Label = "备注"; this.neuSpread1_Sheet1.Columns.Get(5).Width = 119F; this.neuSpread1_Sheet1.Columns.Get(6).CellType = textCellType1; this.neuSpread1_Sheet1.Columns.Get(6).Label = "拼音码"; this.neuSpread1_Sheet1.Columns.Get(6).Visible = false; this.neuSpread1_Sheet1.Columns.Get(6).Width = 129F; this.neuSpread1_Sheet1.Columns.Get(7).CellType = textCellType1; this.neuSpread1_Sheet1.Columns.Get(7).Label = "五笔码"; this.neuSpread1_Sheet1.Columns.Get(7).Visible = false; this.neuSpread1_Sheet1.Columns.Get(7).Width = 129F; }
/// <summary> /// 表格列设置 /// </summary> protected virtual void SetColumnType() { Neusoft.HISFC.Models.Material.MaterialAddRate addRate = new Neusoft.HISFC.Models.Material.MaterialAddRate(); FarPoint.Win.Spread.CellType.ComboBoxCellType cmbRateKindCellType = new FarPoint.Win.Spread.CellType.ComboBoxCellType(); FarPoint.Win.Spread.CellType.NumberCellType numType = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dtType = new FarPoint.Win.Spread.CellType.DateTimeCellType(); cmbRateKindCellType.Items = addRate.RateKind.StringItems; this.FpAddRate_Sheet1.Columns[0].Visible = false; this.FpAddRate_Sheet1.Columns[1].Visible = false; this.FpAddRate_Sheet1.Columns[2].CellType = cmbRateKindCellType; this.FpAddRate_Sheet1.Columns[2].Locked = true; this.FpAddRate_Sheet1.Columns[4].CellType = numType; this.FpAddRate_Sheet1.Columns[5].CellType = numType; this.FpAddRate_Sheet1.Columns[6].CellType = numType; this.FpAddRate_Sheet1.Columns[7].CellType = numType; this.FpAddRate_Sheet1.Columns[8].Visible = false; this.FpAddRate_Sheet1.Columns[9].CellType = dtType; this.FpAddRate_Sheet1.Columns[10].Visible = false; }
/// <summary> /// 根据配置文件设置Fp显示 /// </summary> /// <param name="sv"></param> /// <param name="doc"></param> public static void SetFpByConfig(FarPoint.Win.Spread.SheetView sv, System.Xml.XmlDocument doc) { System.Xml.XmlNode nodeCollection = doc.SelectSingleNode("/Setting"); for (int i = 0; i < nodeCollection.ChildNodes.Count; i++) { if (sv.Columns.Count <= i) { return; } System.Xml.XmlNode node = nodeCollection.ChildNodes[i]; sv.Columns[i].Label = node.Attributes["Label"].Value; sv.Columns[i].Visible = Neusoft.FrameWork.Function.NConvert.ToBoolean(node.Attributes["Visible"].Value); sv.Columns[i].Width = (float)Neusoft.FrameWork.Function.NConvert.ToInt32(node.Attributes["Width"].Value); switch (node.Attributes["CellType"].Value) { case "文本": sv.Columns[i].CellType = new FarPoint.Win.Spread.CellType.TextCellType(); break; case "数值": FarPoint.Win.Spread.CellType.NumberCellType num = new FarPoint.Win.Spread.CellType.NumberCellType(); if (node.Attributes["Param"].Value != "") { num.DecimalPlaces = Neusoft.FrameWork.Function.NConvert.ToInt32(node.Attributes["Param"].Value); } sv.Columns[i].CellType = num; break; case "日期": FarPoint.Win.Spread.CellType.DateTimeCellType timeCell = new FarPoint.Win.Spread.CellType.DateTimeCellType(); sv.Columns[i].CellType = timeCell; break; default: sv.Columns[i].CellType = new FarPoint.Win.Spread.CellType.TextCellType(); break; } } }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { FarPoint.Win.Spread.TipAppearance tipAppearance1 = new FarPoint.Win.Spread.TipAppearance(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType1 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ucPermissionManager)); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType2 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType1 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType3 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); this.neuPanel1 = new Neusoft.FrameWork.WinForms.Controls.NeuPanel(); this.neuPanel3 = new Neusoft.FrameWork.WinForms.Controls.NeuPanel(); this.neuPanel2 = new Neusoft.FrameWork.WinForms.Controls.NeuPanel(); this.neuSpread1 = new Neusoft.FrameWork.WinForms.Controls.NeuSpread(); this.neuSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.ucPatient1 = new Neusoft.HISFC.Components.Common.Controls.ucPatient(); this.ucQueryInpatientNo1 = new Neusoft.HISFC.Components.Common.Controls.ucQueryInpatientNo(); this.neuPanel1.SuspendLayout(); this.neuPanel3.SuspendLayout(); this.neuPanel2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1_Sheet1)).BeginInit(); this.SuspendLayout(); // // neuPanel1 // this.neuPanel1.Controls.Add(this.neuPanel3); this.neuPanel1.Controls.Add(this.neuPanel2); this.neuPanel1.Dock = System.Windows.Forms.DockStyle.Top; this.neuPanel1.Location = new System.Drawing.Point(0, 0); this.neuPanel1.Name = "neuPanel1"; this.neuPanel1.Size = new System.Drawing.Size(864, 45); this.neuPanel1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuPanel1.TabIndex = 0; this.neuPanel1.TabStop = true; // // neuPanel3 // this.neuPanel3.Controls.Add(this.ucPatient1); this.neuPanel3.Dock = System.Windows.Forms.DockStyle.Fill; this.neuPanel3.Location = new System.Drawing.Point(228, 0); this.neuPanel3.Name = "neuPanel3"; this.neuPanel3.Size = new System.Drawing.Size(636, 45); this.neuPanel3.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuPanel3.TabIndex = 6; // // neuPanel2 // this.neuPanel2.Controls.Add(this.ucQueryInpatientNo1); this.neuPanel2.Dock = System.Windows.Forms.DockStyle.Left; this.neuPanel2.Location = new System.Drawing.Point(0, 0); this.neuPanel2.Name = "neuPanel2"; this.neuPanel2.Size = new System.Drawing.Size(228, 45); this.neuPanel2.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuPanel2.TabIndex = 5; // // neuSpread1 // this.neuSpread1.About = "2.5.2007.2005"; this.neuSpread1.AccessibleDescription = "neuSpread1, Sheet1, Row 0, Column 0, "; this.neuSpread1.BackColor = System.Drawing.Color.White; this.neuSpread1.Dock = System.Windows.Forms.DockStyle.Fill; this.neuSpread1.FileName = ""; this.neuSpread1.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.neuSpread1.IsAutoSaveGridStatus = false; this.neuSpread1.IsCanCustomConfigColumn = false; this.neuSpread1.Location = new System.Drawing.Point(0, 45); this.neuSpread1.Name = "neuSpread1"; this.neuSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.neuSpread1_Sheet1 }); this.neuSpread1.Size = new System.Drawing.Size(864, 443); this.neuSpread1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuSpread1.TabIndex = 2; tipAppearance1.BackColor = System.Drawing.SystemColors.Info; tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText; this.neuSpread1.TextTipAppearance = tipAppearance1; this.neuSpread1.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.neuSpread1.CellDoubleClick += new FarPoint.Win.Spread.CellClickEventHandler(this.neuSpread1_CellDoubleClick); // // neuSpread1_Sheet1 // this.neuSpread1_Sheet1.Reset(); this.neuSpread1_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.neuSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.neuSpread1_Sheet1.ColumnCount = 7; this.neuSpread1_Sheet1.RowCount = 5; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "授权科室"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "授权医生"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "处方起始日"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "处方结束日"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "授权说明"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "操作者"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "授权时间"; this.neuSpread1_Sheet1.Columns.Get(0).Label = "授权科室"; this.neuSpread1_Sheet1.Columns.Get(0).Width = 130F; this.neuSpread1_Sheet1.Columns.Get(1).Label = "授权医生"; this.neuSpread1_Sheet1.Columns.Get(1).Width = 83F; dateTimeCellType1.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType1.Calendar"))); dateTimeCellType1.DateDefault = new System.DateTime(2007, 1, 5, 11, 33, 12, 0); dateTimeCellType1.TimeDefault = new System.DateTime(2007, 1, 5, 11, 33, 12, 0); this.neuSpread1_Sheet1.Columns.Get(2).CellType = dateTimeCellType1; this.neuSpread1_Sheet1.Columns.Get(2).Label = "处方起始日"; this.neuSpread1_Sheet1.Columns.Get(2).Width = 106F; dateTimeCellType2.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType2.Calendar"))); dateTimeCellType2.DateDefault = new System.DateTime(2007, 1, 5, 11, 34, 47, 0); dateTimeCellType2.TimeDefault = new System.DateTime(2007, 1, 5, 11, 34, 47, 0); this.neuSpread1_Sheet1.Columns.Get(3).CellType = dateTimeCellType2; this.neuSpread1_Sheet1.Columns.Get(3).Label = "处方结束日"; this.neuSpread1_Sheet1.Columns.Get(3).Width = 109F; this.neuSpread1_Sheet1.Columns.Get(4).Label = "授权说明"; this.neuSpread1_Sheet1.Columns.Get(4).Width = 127F; this.neuSpread1_Sheet1.Columns.Get(5).CellType = textCellType1; this.neuSpread1_Sheet1.Columns.Get(5).Label = "操作者"; this.neuSpread1_Sheet1.Columns.Get(5).Width = 72F; dateTimeCellType3.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType3.Calendar"))); dateTimeCellType3.DateDefault = new System.DateTime(2007, 1, 5, 11, 35, 41, 0); dateTimeCellType3.TimeDefault = new System.DateTime(2007, 1, 5, 11, 35, 41, 0); this.neuSpread1_Sheet1.Columns.Get(6).CellType = dateTimeCellType3; this.neuSpread1_Sheet1.Columns.Get(6).Label = "授权时间"; this.neuSpread1_Sheet1.Columns.Get(6).Width = 111F; this.neuSpread1_Sheet1.GrayAreaBackColor = System.Drawing.Color.White; this.neuSpread1_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.SingleSelect; this.neuSpread1_Sheet1.RowHeader.Columns.Default.Resizable = false; this.neuSpread1_Sheet1.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single; this.neuSpread1_Sheet1.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Row; this.neuSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; // // ucPatient1 // this.ucPatient1.BackColor = System.Drawing.SystemColors.Control; this.ucPatient1.ColumnHeight = 32; this.ucPatient1.ColumnWidth = 192; this.ucPatient1.Dock = System.Windows.Forms.DockStyle.Fill; this.ucPatient1.IsShowDetail = false; this.ucPatient1.Location = new System.Drawing.Point(0, 0); this.ucPatient1.Name = "ucPatient1"; this.ucPatient1.S1_Name = true; this.ucPatient1.S2_DateIn = false; this.ucPatient1.S3_PatientDept = true; this.ucPatient1.S4_Remain = true; this.ucPatient1.S5_Birthday = true; this.ucPatient1.S6_Cautioner = false; this.ucPatient1.S7_PayKind = true; this.ucPatient1.S8_MoneyAlert = false; this.ucPatient1.S9_PactName = true; this.ucPatient1.Sa_CautionMoney = false; this.ucPatient1.Sb_Bill = true; this.ucPatient1.Sc_Available = true; this.ucPatient1.Sd_AttendingDoctor = true; this.ucPatient1.Se_AdmittingDoctor = true; this.ucPatient1.Sf_AdmittingNurse = true; this.ucPatient1.Sg_ThisBill = false; this.ucPatient1.Size = new System.Drawing.Size(636, 45); this.ucPatient1.TabIndex = 1; // // ucQueryInpatientNo1 // this.ucQueryInpatientNo1.InputType = 0; this.ucQueryInpatientNo1.Location = new System.Drawing.Point(14, 8); this.ucQueryInpatientNo1.Name = "ucQueryInpatientNo1"; this.ucQueryInpatientNo1.ShowState = Neusoft.HISFC.Components.Common.Controls.enuShowState.InHos; this.ucQueryInpatientNo1.Size = new System.Drawing.Size(198, 27); this.ucQueryInpatientNo1.TabIndex = 4; this.ucQueryInpatientNo1.myEvent += new Neusoft.HISFC.Components.Common.Controls.myEventDelegate(this.ucQueryInpatientNo1_myEvent); // // ucPermissionManager // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.Controls.Add(this.neuSpread1); this.Controls.Add(this.neuPanel1); this.Name = "ucPermissionManager"; this.Size = new System.Drawing.Size(864, 488); this.Load += new System.EventHandler(this.ucPermissionManager_Load); this.neuPanel1.ResumeLayout(false); this.neuPanel3.ResumeLayout(false); this.neuPanel2.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1_Sheet1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// 设置列属性 /// </summary> public static void ReadColumnProperty(FarPoint.Win.Spread.SheetView fv, string FileName) { XmlDocument doc = new XmlDocument(); if (FileName == "") { return; } try { StreamReader sr = new StreamReader(FileName, System.Text.Encoding.Default); string cleandown = sr.ReadToEnd(); doc.LoadXml(cleandown); sr.Close(); // doc.LoadXml(FileName); } catch { return; } XmlNodeList nodes = doc.SelectNodes("//Column"); int id = 0; fv.Columns.Count = nodes.Count; foreach (XmlNode node in nodes) { try { int width = int.Parse(node.Attributes["width"].Value); fv.Columns[id].Width = width; } catch { } try { bool visible = bool.Parse(node.Attributes["visible"].Value); fv.Columns[id].Visible = visible; } catch { } try { bool enable = bool.Parse(node.Attributes["enable"].Value); fv.Columns[id].Locked = !enable; } catch { } try { string name = node.Attributes["name"].Value; fv.Columns[id].Label = name; } catch { } try { string displayname = node.Attributes["displayname"].Value; if (displayname != "") { fv.Columns[id].Label = displayname; } } catch { } try { string type = node.Attributes["type"].Value; if (type == "TextCellType")//FarPoint.Win.Spread.CellType. { fv.Columns[id].CellType = new FarPoint.Win.Spread.CellType.TextCellType(); } else if (type == "ComboBoxCellType") { fv.Columns[id].CellType = new FarPoint.Win.Spread.CellType.ComboBoxCellType(); } else if (type == "CurrencyCellType") { fv.Columns[id].CellType = new FarPoint.Win.Spread.CellType.CurrencyCellType(); } else if (type == "CheckBoxCellType") { fv.Columns[id].CellType = new FarPoint.Win.Spread.CellType.CheckBoxCellType(); } else if (type == "DateTimeCellType") { FarPoint.Win.Spread.CellType.DateTimeCellType dtCellType = new FarPoint.Win.Spread.CellType.DateTimeCellType(); dtCellType.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime; fv.Columns[id].CellType = dtCellType; } else if (type == "ButtonCellType") { fv.Columns[id].CellType = new FarPoint.Win.Spread.CellType.ButtonCellType(); } } catch { } try { bool sort = bool.Parse(node.Attributes["sort"].Value); fv.Columns[id].AllowAutoSort = sort; } catch { } id++; } }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ucMessage)); FarPoint.Win.Spread.TipAppearance tipAppearance1 = new FarPoint.Win.Spread.TipAppearance(); FarPoint.Win.Spread.CellType.ImageCellType imageCellType1 = new FarPoint.Win.Spread.CellType.ImageCellType(); FarPoint.Win.Spread.CellType.ImageCellType imageCellType2 = new FarPoint.Win.Spread.CellType.ImageCellType(); FarPoint.Win.Spread.CellType.ImageCellType imageCellType3 = new FarPoint.Win.Spread.CellType.ImageCellType(); FarPoint.Win.Spread.CellType.ImageCellType imageCellType4 = new FarPoint.Win.Spread.CellType.ImageCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType1 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType1 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); this.panel1 = new System.Windows.Forms.Panel(); this.neuComboBox1 = new Neusoft.FrameWork.WinForms.Controls.NeuComboBox(this.components); this.button4 = new System.Windows.Forms.Button(); this.button3 = new System.Windows.Forms.Button(); this.button2 = new System.Windows.Forms.Button(); this.button1 = new System.Windows.Forms.Button(); this.fpSpread1 = new FarPoint.Win.Spread.FpSpread(); this.fpSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).BeginInit(); this.SuspendLayout(); // // panel1 // this.panel1.BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.panel1.Controls.Add(this.neuComboBox1); this.panel1.Controls.Add(this.button4); this.panel1.Controls.Add(this.button3); this.panel1.Controls.Add(this.button2); this.panel1.Controls.Add(this.button1); this.panel1.Dock = System.Windows.Forms.DockStyle.Top; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(519, 50); this.panel1.TabIndex = 0; // // neuComboBox1 // this.neuComboBox1.ArrowBackColor = System.Drawing.Color.Silver; this.neuComboBox1.FormattingEnabled = true; this.neuComboBox1.IsEnter2Tab = false; this.neuComboBox1.IsFlat = true; this.neuComboBox1.IsLike = true; this.neuComboBox1.Location = new System.Drawing.Point(202, 29); this.neuComboBox1.Name = "neuComboBox1"; this.neuComboBox1.PopForm = null; this.neuComboBox1.ShowCustomerList = false; this.neuComboBox1.ShowID = false; this.neuComboBox1.Size = new System.Drawing.Size(84, 20); this.neuComboBox1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Flat; this.neuComboBox1.TabIndex = 4; this.neuComboBox1.Tag = ""; this.neuComboBox1.ToolBarUse = false; this.neuComboBox1.SelectedIndexChanged += new System.EventHandler(this.neuComboBox1_SelectedIndexChanged); // // button4 // this.button4.Image = global::Neusoft.HISFC.Components.Message.Properties.Resources.delete; this.button4.Location = new System.Drawing.Point(151, 0); this.button4.Name = "button4"; this.button4.Size = new System.Drawing.Size(52, 52); this.button4.TabIndex = 3; this.button4.UseVisualStyleBackColor = true; this.button4.Click += new System.EventHandler(this.button4_Click); // // button3 // this.button3.BackColor = System.Drawing.SystemColors.ControlLightLight; this.button3.Image = ((System.Drawing.Image)(resources.GetObject("button3.Image"))); this.button3.Location = new System.Drawing.Point(101, 0); this.button3.Name = "button3"; this.button3.Size = new System.Drawing.Size(52, 52); this.button3.TabIndex = 2; this.button3.Text = " "; this.button3.UseVisualStyleBackColor = false; this.button3.Click += new System.EventHandler(this.button3_Click); // // button2 // this.button2.BackColor = System.Drawing.SystemColors.ControlLightLight; this.button2.Image = global::Neusoft.HISFC.Components.Message.Properties.Resources.receive; this.button2.Location = new System.Drawing.Point(51, 0); this.button2.Name = "button2"; this.button2.Size = new System.Drawing.Size(52, 52); this.button2.TabIndex = 1; this.button2.Text = " "; this.button2.UseVisualStyleBackColor = false; this.button2.Click += new System.EventHandler(this.button2_Click); // // button1 // this.button1.BackColor = System.Drawing.SystemColors.ControlLightLight; this.button1.Image = global::Neusoft.HISFC.Components.Message.Properties.Resources.write; this.button1.Location = new System.Drawing.Point(1, -1); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(52, 52); this.button1.TabIndex = 0; this.button1.Text = " "; this.button1.UseVisualStyleBackColor = false; this.button1.Click += new System.EventHandler(this.button1_Click); // // fpSpread1 // this.fpSpread1.About = "2.5.2007.2005"; this.fpSpread1.AccessibleDescription = "fpSpread1, Sheet1, Row 0, Column 0, "; this.fpSpread1.BackColor = System.Drawing.SystemColors.Control; this.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill; this.fpSpread1.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpSpread1.Location = new System.Drawing.Point(0, 50); this.fpSpread1.Name = "fpSpread1"; this.fpSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.fpSpread1_Sheet1 }); this.fpSpread1.Size = new System.Drawing.Size(519, 283); this.fpSpread1.TabIndex = 1; tipAppearance1.BackColor = System.Drawing.SystemColors.Info; tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText; this.fpSpread1.TextTipAppearance = tipAppearance1; this.fpSpread1.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpSpread1.CellDoubleClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpSpread1_CellDoubleClick); // // fpSpread1_Sheet1 // this.fpSpread1_Sheet1.Reset(); this.fpSpread1_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread1_Sheet1.ColumnCount = 7; this.fpSpread1_Sheet1.RowCount = 10; this.fpSpread1_Sheet1.ActiveSkin = new FarPoint.Win.Spread.SheetSkin("CustomSkin1", System.Drawing.SystemColors.HighlightText, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.LightGray, FarPoint.Win.Spread.GridLines.Both, System.Drawing.SystemColors.GradientInactiveCaption, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, false, false, false, true, true); imageCellType1.Style = FarPoint.Win.RenderStyle.Normal; imageCellType1.TransparencyColor = System.Drawing.Color.Empty; imageCellType1.TransparencyTolerance = 0; this.fpSpread1_Sheet1.Cells.Get(1, 0).CellType = imageCellType1; imageCellType2.Style = FarPoint.Win.RenderStyle.Normal; imageCellType2.TransparencyColor = System.Drawing.Color.Empty; imageCellType2.TransparencyTolerance = 0; this.fpSpread1_Sheet1.Cells.Get(2, 0).CellType = imageCellType2; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).BackColor = System.Drawing.SystemColors.GradientInactiveCaption; imageCellType3.Style = FarPoint.Win.RenderStyle.Normal; imageCellType3.TransparencyColor = System.Drawing.Color.Empty; imageCellType3.TransparencyTolerance = 0; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).CellType = imageCellType3; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = " "; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 1).BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 2).BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 3).BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 4).BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.fpSpread1_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.fpSpread1_Sheet1.ColumnHeader.DefaultStyle.Locked = false; this.fpSpread1_Sheet1.ColumnHeader.DefaultStyle.Parent = "HeaderDefault"; imageCellType4.Style = FarPoint.Win.RenderStyle.Stretch; imageCellType4.TransparencyColor = System.Drawing.Color.Empty; imageCellType4.TransparencyTolerance = 0; this.fpSpread1_Sheet1.Columns.Get(0).CellType = imageCellType4; this.fpSpread1_Sheet1.Columns.Get(0).Label = " "; this.fpSpread1_Sheet1.Columns.Get(0).Width = 17F; this.fpSpread1_Sheet1.Columns.Get(1).Width = 77F; this.fpSpread1_Sheet1.Columns.Get(2).CellType = textCellType1; this.fpSpread1_Sheet1.Columns.Get(2).Width = 164F; dateTimeCellType1.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType1.Calendar"))); dateTimeCellType1.DateDefault = new System.DateTime(2008, 4, 11, 12, 19, 23, 0); dateTimeCellType1.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.LongDateWithTime; dateTimeCellType1.TimeDefault = new System.DateTime(2008, 4, 11, 12, 19, 23, 0); this.fpSpread1_Sheet1.Columns.Get(3).CellType = dateTimeCellType1; this.fpSpread1_Sheet1.Columns.Get(3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet1.Columns.Get(3).Width = 141F; this.fpSpread1_Sheet1.Columns.Get(4).Width = 59F; this.fpSpread1_Sheet1.Columns.Get(5).Visible = false; this.fpSpread1_Sheet1.Columns.Get(6).Visible = false; this.fpSpread1_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.SingleSelect; this.fpSpread1_Sheet1.RowHeader.Columns.Default.Resizable = false; this.fpSpread1_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.fpSpread1_Sheet1.RowHeader.DefaultStyle.Locked = false; this.fpSpread1_Sheet1.RowHeader.DefaultStyle.Parent = "HeaderDefault"; this.fpSpread1_Sheet1.Rows.Get(0).Height = 19F; this.fpSpread1_Sheet1.Rows.Get(2).Height = 21F; this.fpSpread1_Sheet1.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single; this.fpSpread1_Sheet1.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Row; this.fpSpread1_Sheet1.SheetCornerStyle.BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.fpSpread1_Sheet1.SheetCornerStyle.Locked = false; this.fpSpread1_Sheet1.SheetCornerStyle.Parent = "HeaderDefault"; this.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; // // ucMessage // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.Controls.Add(this.fpSpread1); this.Controls.Add(this.panel1); this.Name = "ucMessage"; this.Size = new System.Drawing.Size(519, 333); this.Load += new System.EventHandler(this.ucMessage_Load); this.panel1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); FarPoint.Win.Spread.TipAppearance tipAppearance1 = new FarPoint.Win.Spread.TipAppearance(); FarPoint.Win.Spread.TipAppearance tipAppearance2 = new FarPoint.Win.Spread.TipAppearance(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType1 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType2 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType1 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ucStockPlan)); FarPoint.Win.Spread.CellType.NumberCellType numberCellType3 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType4 = new FarPoint.Win.Spread.CellType.NumberCellType(); this.lbPlanBill = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.lbPlanInfo = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.lbTitle = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.neuPanel1 = new Neusoft.FrameWork.WinForms.Controls.NeuPanel(); this.fpStockApprove = new Neusoft.FrameWork.WinForms.Controls.NeuSpread(); this.neuPanel2 = new Neusoft.FrameWork.WinForms.Controls.NeuPanel(); this.lbCost = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.splitContainer1 = new System.Windows.Forms.SplitContainer(); this.tabControl1 = new System.Windows.Forms.TabControl(); this.tbStockHistory = new System.Windows.Forms.TabPage(); this.fpHistory = new Neusoft.FrameWork.WinForms.Controls.NeuSpread(); this.tvList = new Neusoft.HISFC.Components.Material.Plan.tvPlanList(this.components); this.fpStockApprove_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.fpHistory_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.neuPanel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpStockApprove)).BeginInit(); this.neuPanel2.SuspendLayout(); this.splitContainer1.Panel1.SuspendLayout(); this.splitContainer1.Panel2.SuspendLayout(); this.splitContainer1.SuspendLayout(); this.tabControl1.SuspendLayout(); this.tbStockHistory.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpHistory)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpStockApprove_Sheet1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpHistory_Sheet1)).BeginInit(); this.SuspendLayout(); // // lbPlanBill // this.lbPlanBill.AutoSize = true; this.lbPlanBill.Location = new System.Drawing.Point(260, 53); this.lbPlanBill.Name = "lbPlanBill"; this.lbPlanBill.Size = new System.Drawing.Size(41, 12); this.lbPlanBill.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lbPlanBill.TabIndex = 1; this.lbPlanBill.Text = "单据号"; // // lbPlanInfo // this.lbPlanInfo.AutoSize = true; this.lbPlanInfo.Location = new System.Drawing.Point(17, 53); this.lbPlanInfo.Name = "lbPlanInfo"; this.lbPlanInfo.Size = new System.Drawing.Size(131, 12); this.lbPlanInfo.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lbPlanInfo.TabIndex = 1; this.lbPlanInfo.Text = "计划科室{0} 计划人{1}"; // // lbTitle // this.lbTitle.Font = new System.Drawing.Font("宋体", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.lbTitle.ForeColor = System.Drawing.SystemColors.ControlText; this.lbTitle.Location = new System.Drawing.Point(277, 11); this.lbTitle.Name = "lbTitle"; this.lbTitle.Size = new System.Drawing.Size(248, 27); this.lbTitle.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lbTitle.TabIndex = 0; this.lbTitle.Text = "采 购 单"; this.lbTitle.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; // // neuPanel1 // this.neuPanel1.Controls.Add(this.fpStockApprove); this.neuPanel1.Controls.Add(this.neuPanel2); this.neuPanel1.Dock = System.Windows.Forms.DockStyle.Fill; this.neuPanel1.Location = new System.Drawing.Point(0, 0); this.neuPanel1.Name = "neuPanel1"; this.neuPanel1.Size = new System.Drawing.Size(713, 348); this.neuPanel1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuPanel1.TabIndex = 1; // // fpStockApprove // this.fpStockApprove.About = "2.5.2007.2005"; this.fpStockApprove.AccessibleDescription = "fpStockApprove"; this.fpStockApprove.BackColor = System.Drawing.Color.White; this.fpStockApprove.Dock = System.Windows.Forms.DockStyle.Fill; this.fpStockApprove.FileName = ""; this.fpStockApprove.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpStockApprove.IsAutoSaveGridStatus = false; this.fpStockApprove.IsCanCustomConfigColumn = false; this.fpStockApprove.Location = new System.Drawing.Point(0, 77); this.fpStockApprove.Name = "fpStockApprove"; this.fpStockApprove.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.fpStockApprove_Sheet1 }); this.fpStockApprove.Size = new System.Drawing.Size(713, 271); this.fpStockApprove.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.fpStockApprove.TabIndex = 2; tipAppearance1.BackColor = System.Drawing.SystemColors.Info; tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText; this.fpStockApprove.TextTipAppearance = tipAppearance1; this.fpStockApprove.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpStockApprove.CellDoubleClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpStockApprove_CellDoubleClick); this.fpStockApprove.CellClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpStockApprove_CellClick); this.fpStockApprove.SelectionChanged += new FarPoint.Win.Spread.SelectionChangedEventHandler(this.fpStockApprove_SelectionChanged); this.fpStockApprove.EditModeOff += new System.EventHandler(this.fpStockApprove_EditModeOff); this.fpStockApprove.Change += new FarPoint.Win.Spread.ChangeEventHandler(this.fpStockApprove_Change); this.fpStockApprove.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.fpStockApprove_KeyPress); // // neuPanel2 // this.neuPanel2.Controls.Add(this.lbTitle); this.neuPanel2.Controls.Add(this.lbCost); this.neuPanel2.Controls.Add(this.lbPlanInfo); this.neuPanel2.Controls.Add(this.lbPlanBill); this.neuPanel2.Dock = System.Windows.Forms.DockStyle.Top; this.neuPanel2.Location = new System.Drawing.Point(0, 0); this.neuPanel2.Name = "neuPanel2"; this.neuPanel2.Size = new System.Drawing.Size(713, 77); this.neuPanel2.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuPanel2.TabIndex = 4; // // lbCost // this.lbCost.AutoSize = true; this.lbCost.ForeColor = System.Drawing.Color.Blue; this.lbCost.Location = new System.Drawing.Point(452, 53); this.lbCost.Name = "lbCost"; this.lbCost.Size = new System.Drawing.Size(53, 12); this.lbCost.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lbCost.TabIndex = 3; this.lbCost.Text = "计划金额"; // // splitContainer1 // this.splitContainer1.Dock = System.Windows.Forms.DockStyle.Fill; this.splitContainer1.FixedPanel = System.Windows.Forms.FixedPanel.Panel1; this.splitContainer1.Location = new System.Drawing.Point(0, 0); this.splitContainer1.Name = "splitContainer1"; // // splitContainer1.Panel1 // this.splitContainer1.Panel1.Controls.Add(this.tvList); // // splitContainer1.Panel2 // this.splitContainer1.Panel2.Controls.Add(this.neuPanel1); this.splitContainer1.Panel2.Controls.Add(this.tabControl1); this.splitContainer1.Size = new System.Drawing.Size(887, 501); this.splitContainer1.SplitterDistance = 170; this.splitContainer1.TabIndex = 1; // // tabControl1 // this.tabControl1.Controls.Add(this.tbStockHistory); this.tabControl1.Dock = System.Windows.Forms.DockStyle.Bottom; this.tabControl1.Location = new System.Drawing.Point(0, 348); this.tabControl1.Name = "tabControl1"; this.tabControl1.SelectedIndex = 0; this.tabControl1.Size = new System.Drawing.Size(713, 153); this.tabControl1.TabIndex = 2; // // tbStockHistory // this.tbStockHistory.Controls.Add(this.fpHistory); this.tbStockHistory.Location = new System.Drawing.Point(4, 21); this.tbStockHistory.Name = "tbStockHistory"; this.tbStockHistory.Padding = new System.Windows.Forms.Padding(3); this.tbStockHistory.Size = new System.Drawing.Size(705, 128); this.tbStockHistory.TabIndex = 0; this.tbStockHistory.Text = "历史采购计划信息"; this.tbStockHistory.UseVisualStyleBackColor = true; // // fpHistory // this.fpHistory.About = "2.5.2007.2005"; this.fpHistory.AccessibleDescription = "fpHistory, Sheet1, Row 0, Column 0, "; this.fpHistory.BackColor = System.Drawing.Color.White; this.fpHistory.Dock = System.Windows.Forms.DockStyle.Fill; this.fpHistory.FileName = ""; this.fpHistory.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpHistory.IsAutoSaveGridStatus = false; this.fpHistory.IsCanCustomConfigColumn = false; this.fpHistory.Location = new System.Drawing.Point(3, 3); this.fpHistory.Name = "fpHistory"; this.fpHistory.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.fpHistory_Sheet1 }); this.fpHistory.Size = new System.Drawing.Size(699, 122); this.fpHistory.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.fpHistory.TabIndex = 0; tipAppearance2.BackColor = System.Drawing.SystemColors.Info; tipAppearance2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance2.ForeColor = System.Drawing.SystemColors.InfoText; this.fpHistory.TextTipAppearance = tipAppearance2; this.fpHistory.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; // // tvList // this.tvList.Dock = System.Windows.Forms.DockStyle.Fill; this.tvList.HideSelection = false; this.tvList.Location = new System.Drawing.Point(0, 0); this.tvList.Name = "tvList"; this.tvList.Size = new System.Drawing.Size(170, 501); this.tvList.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.tvList.TabIndex = 0; this.tvList.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.tvList_AfterSelect); // // fpStockApprove_Sheet1 // this.fpStockApprove_Sheet1.Reset(); this.fpStockApprove_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.fpStockApprove_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpStockApprove_Sheet1.ColumnCount = 11; this.fpStockApprove_Sheet1.RowCount = 0; this.fpStockApprove_Sheet1.ActiveSkin = new FarPoint.Win.Spread.SheetSkin("CustomSkin3", System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.LightGray, FarPoint.Win.Spread.GridLines.Both, System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, false, false, false, true, true); this.fpStockApprove_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "物品名称"; this.fpStockApprove_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "规 格"; this.fpStockApprove_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "计划购入价"; this.fpStockApprove_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "计划数量"; this.fpStockApprove_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "单位"; this.fpStockApprove_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "审核金额"; this.fpStockApprove_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "供货公司"; this.fpStockApprove_Sheet1.ColumnHeader.Cells.Get(0, 7).Value = "生产厂家"; this.fpStockApprove_Sheet1.ColumnHeader.Cells.Get(0, 8).Value = "备注"; this.fpStockApprove_Sheet1.ColumnHeader.Cells.Get(0, 9).Value = "科室库存"; this.fpStockApprove_Sheet1.ColumnHeader.Cells.Get(0, 10).Value = "全院库存"; this.fpStockApprove_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.fpStockApprove_Sheet1.ColumnHeader.DefaultStyle.Locked = false; this.fpStockApprove_Sheet1.ColumnHeader.DefaultStyle.Parent = "HeaderDefault"; this.fpStockApprove_Sheet1.Columns.Get(0).Label = "物品名称"; this.fpStockApprove_Sheet1.Columns.Get(0).Locked = true; this.fpStockApprove_Sheet1.Columns.Get(0).Width = 100F; this.fpStockApprove_Sheet1.Columns.Get(1).Label = "规 格"; this.fpStockApprove_Sheet1.Columns.Get(1).Locked = true; this.fpStockApprove_Sheet1.Columns.Get(2).BackColor = System.Drawing.Color.SeaShell; this.fpStockApprove_Sheet1.Columns.Get(2).CellType = numberCellType1; this.fpStockApprove_Sheet1.Columns.Get(2).Label = "计划购入价"; this.fpStockApprove_Sheet1.Columns.Get(2).Width = 75F; this.fpStockApprove_Sheet1.Columns.Get(3).BackColor = System.Drawing.Color.SeaShell; this.fpStockApprove_Sheet1.Columns.Get(3).CellType = numberCellType2; this.fpStockApprove_Sheet1.Columns.Get(3).Label = "计划数量"; this.fpStockApprove_Sheet1.Columns.Get(3).Width = 70F; this.fpStockApprove_Sheet1.Columns.Get(4).Label = "单位"; this.fpStockApprove_Sheet1.Columns.Get(4).Locked = true; this.fpStockApprove_Sheet1.Columns.Get(5).Label = "审核金额"; this.fpStockApprove_Sheet1.Columns.Get(5).Locked = true; this.fpStockApprove_Sheet1.Columns.Get(6).BackColor = System.Drawing.Color.SeaShell; this.fpStockApprove_Sheet1.Columns.Get(6).Label = "供货公司"; this.fpStockApprove_Sheet1.Columns.Get(6).Width = 100F; this.fpStockApprove_Sheet1.Columns.Get(7).Label = "生产厂家"; this.fpStockApprove_Sheet1.Columns.Get(7).Locked = true; this.fpStockApprove_Sheet1.Columns.Get(7).Width = 100F; this.fpStockApprove_Sheet1.Columns.Get(8).BackColor = System.Drawing.Color.SeaShell; this.fpStockApprove_Sheet1.Columns.Get(8).Label = "备注"; this.fpStockApprove_Sheet1.Columns.Get(8).Width = 100F; this.fpStockApprove_Sheet1.Columns.Get(9).Label = "科室库存"; this.fpStockApprove_Sheet1.Columns.Get(9).Locked = true; this.fpStockApprove_Sheet1.Columns.Get(9).Width = 70F; this.fpStockApprove_Sheet1.Columns.Get(10).Label = "全院库存"; this.fpStockApprove_Sheet1.Columns.Get(10).Locked = true; this.fpStockApprove_Sheet1.Columns.Get(10).Width = 70F; this.fpStockApprove_Sheet1.DataAutoSizeColumns = false; this.fpStockApprove_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode; this.fpStockApprove_Sheet1.RowHeader.Columns.Default.Resizable = false; this.fpStockApprove_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.fpStockApprove_Sheet1.RowHeader.DefaultStyle.Locked = false; this.fpStockApprove_Sheet1.RowHeader.DefaultStyle.Parent = "HeaderDefault"; this.fpStockApprove_Sheet1.SheetCornerStyle.BackColor = System.Drawing.Color.White; this.fpStockApprove_Sheet1.SheetCornerStyle.Locked = false; this.fpStockApprove_Sheet1.SheetCornerStyle.Parent = "HeaderDefault"; this.fpStockApprove_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; this.fpStockApprove.SetActiveViewport(1, 0); // // fpHistory_Sheet1 // this.fpHistory_Sheet1.Reset(); this.fpHistory_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.fpHistory_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpHistory_Sheet1.ColumnCount = 7; this.fpHistory_Sheet1.RowCount = 0; this.fpHistory_Sheet1.ActiveSkin = new FarPoint.Win.Spread.SheetSkin("CustomSkin1", System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.LightGray, FarPoint.Win.Spread.GridLines.Both, System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, false, false, false, true, true); this.fpHistory_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "入库日期"; this.fpHistory_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "采购数量"; this.fpHistory_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "单位"; this.fpHistory_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "购入价"; this.fpHistory_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "供货公司"; this.fpHistory_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "生产厂家"; this.fpHistory_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "备注"; this.fpHistory_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.fpHistory_Sheet1.ColumnHeader.DefaultStyle.Locked = false; this.fpHistory_Sheet1.ColumnHeader.DefaultStyle.Parent = "HeaderDefault"; dateTimeCellType1.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType1.Calendar"))); dateTimeCellType1.DateDefault = new System.DateTime(2007, 11, 18, 20, 0, 59, 0); dateTimeCellType1.TimeDefault = new System.DateTime(2007, 11, 18, 20, 0, 59, 0); this.fpHistory_Sheet1.Columns.Get(0).CellType = dateTimeCellType1; this.fpHistory_Sheet1.Columns.Get(0).Label = "入库日期"; this.fpHistory_Sheet1.Columns.Get(0).Width = 120F; this.fpHistory_Sheet1.Columns.Get(1).CellType = numberCellType3; this.fpHistory_Sheet1.Columns.Get(1).Label = "采购数量"; this.fpHistory_Sheet1.Columns.Get(1).Width = 70F; this.fpHistory_Sheet1.Columns.Get(3).CellType = numberCellType4; this.fpHistory_Sheet1.Columns.Get(3).Label = "购入价"; this.fpHistory_Sheet1.Columns.Get(3).Width = 70F; this.fpHistory_Sheet1.Columns.Get(4).Label = "供货公司"; this.fpHistory_Sheet1.Columns.Get(4).Width = 100F; this.fpHistory_Sheet1.Columns.Get(5).Label = "生产厂家"; this.fpHistory_Sheet1.Columns.Get(5).Width = 100F; this.fpHistory_Sheet1.Columns.Get(6).Label = "备注"; this.fpHistory_Sheet1.Columns.Get(6).Width = 100F; this.fpHistory_Sheet1.DefaultStyle.Locked = true; this.fpHistory_Sheet1.DefaultStyle.Parent = "DataAreaDefault"; this.fpHistory_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode; this.fpHistory_Sheet1.RowHeader.Columns.Default.Resizable = false; this.fpHistory_Sheet1.RowHeader.Columns.Get(0).Width = 37F; this.fpHistory_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.fpHistory_Sheet1.RowHeader.DefaultStyle.Locked = false; this.fpHistory_Sheet1.RowHeader.DefaultStyle.Parent = "HeaderDefault"; this.fpHistory_Sheet1.SheetCornerStyle.BackColor = System.Drawing.Color.White; this.fpHistory_Sheet1.SheetCornerStyle.Locked = false; this.fpHistory_Sheet1.SheetCornerStyle.Parent = "HeaderDefault"; this.fpHistory_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; this.fpHistory.SetActiveViewport(1, 0); // // ucStockPlan // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.BackColor = System.Drawing.Color.White; this.Controls.Add(this.splitContainer1); this.Name = "ucStockPlan"; this.Size = new System.Drawing.Size(887, 501); this.Load += new System.EventHandler(this.ucStockPlan_Load); this.neuPanel1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.fpStockApprove)).EndInit(); this.neuPanel2.ResumeLayout(false); this.neuPanel2.PerformLayout(); this.splitContainer1.Panel1.ResumeLayout(false); this.splitContainer1.Panel2.ResumeLayout(false); this.splitContainer1.ResumeLayout(false); this.tabControl1.ResumeLayout(false); this.tbStockHistory.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.fpHistory)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpStockApprove_Sheet1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpHistory_Sheet1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { FarPoint.Win.Spread.TipAppearance tipAppearance1 = new FarPoint.Win.Spread.TipAppearance(); FarPoint.Win.Spread.CellType.CheckBoxCellType checkBoxCellType1 = new FarPoint.Win.Spread.CellType.CheckBoxCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType1 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType2 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType3 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType4 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType1 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ucDummyStockManager)); FarPoint.Win.Spread.TipAppearance tipAppearance2 = new FarPoint.Win.Spread.TipAppearance(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType5 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType6 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType7 = new FarPoint.Win.Spread.CellType.NumberCellType(); this.neuTabControl1 = new Neusoft.FrameWork.WinForms.Controls.NeuTabControl(); this.tabPage1 = new System.Windows.Forms.TabPage(); this.splitContainer1 = new System.Windows.Forms.SplitContainer(); this.tvPatient = new Common.Controls.baseTreeView(); this.patientSpread1 = new Neusoft.FrameWork.WinForms.Controls.NeuSpread(); this.patientSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.neuGroupBox1 = new Neusoft.FrameWork.WinForms.Controls.NeuGroupBox(); this.dtpEnd = new Neusoft.FrameWork.WinForms.Controls.NeuDateTimePicker(); this.dtpBegin = new Neusoft.FrameWork.WinForms.Controls.NeuDateTimePicker(); this.neuLabel2 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.neuLabel1 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.tabPage2 = new System.Windows.Forms.TabPage(); this.deptSpread = new Neusoft.FrameWork.WinForms.Controls.NeuSpread(); this.deptSpread_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.neuGroupBox2 = new Neusoft.FrameWork.WinForms.Controls.NeuGroupBox(); this.txtFilter = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox(); this.neuLabel3 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.neuTabControl1.SuspendLayout(); this.tabPage1.SuspendLayout(); this.splitContainer1.Panel1.SuspendLayout(); this.splitContainer1.Panel2.SuspendLayout(); this.splitContainer1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.patientSpread1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.patientSpread1_Sheet1)).BeginInit(); this.neuGroupBox1.SuspendLayout(); this.tabPage2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.deptSpread)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.deptSpread_Sheet1)).BeginInit(); this.neuGroupBox2.SuspendLayout(); this.SuspendLayout(); // // neuTabControl1 // this.neuTabControl1.Controls.Add(this.tabPage1); this.neuTabControl1.Controls.Add(this.tabPage2); this.neuTabControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.neuTabControl1.Location = new System.Drawing.Point(0, 0); this.neuTabControl1.Name = "neuTabControl1"; this.neuTabControl1.SelectedIndex = 0; this.neuTabControl1.Size = new System.Drawing.Size(696, 450); this.neuTabControl1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuTabControl1.TabIndex = 0; // // tabPage1 // this.tabPage1.Controls.Add(this.splitContainer1); this.tabPage1.Controls.Add(this.neuGroupBox1); this.tabPage1.Location = new System.Drawing.Point(4, 21); this.tabPage1.Name = "tabPage1"; this.tabPage1.Size = new System.Drawing.Size(688, 425); this.tabPage1.TabIndex = 0; this.tabPage1.Text = "患者预扣信息"; this.tabPage1.UseVisualStyleBackColor = true; // // splitContainer1 // this.splitContainer1.Dock = System.Windows.Forms.DockStyle.Fill; this.splitContainer1.Location = new System.Drawing.Point(0, 40); this.splitContainer1.Name = "splitContainer1"; // // splitContainer1.Panel1 // this.splitContainer1.Panel1.Controls.Add(this.tvPatient); // // splitContainer1.Panel2 // this.splitContainer1.Panel2.Controls.Add(this.patientSpread1); this.splitContainer1.Size = new System.Drawing.Size(688, 385); this.splitContainer1.SplitterDistance = 144; this.splitContainer1.SplitterWidth = 3; this.splitContainer1.TabIndex = 1; // // tvPatient // this.tvPatient.Dock = System.Windows.Forms.DockStyle.Fill; this.tvPatient.HideSelection = false; this.tvPatient.Location = new System.Drawing.Point(0, 0); this.tvPatient.Name = "tvPatient"; this.tvPatient.Size = new System.Drawing.Size(144, 385); this.tvPatient.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.tvPatient.TabIndex = 0; this.tvPatient.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.tvPatient_AfterSelect); // // patientSpread1 // this.patientSpread1.About = "2.5.2007.2005"; this.patientSpread1.AccessibleDescription = "patientSpread1, Sheet1"; this.patientSpread1.BackColor = System.Drawing.Color.White; this.patientSpread1.Dock = System.Windows.Forms.DockStyle.Fill; this.patientSpread1.FileName = ""; this.patientSpread1.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.patientSpread1.IsAutoSaveGridStatus = false; this.patientSpread1.IsCanCustomConfigColumn = false; this.patientSpread1.Location = new System.Drawing.Point(0, 0); this.patientSpread1.Name = "patientSpread1"; this.patientSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.patientSpread1_Sheet1 }); this.patientSpread1.Size = new System.Drawing.Size(541, 385); this.patientSpread1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.patientSpread1.TabIndex = 0; tipAppearance1.BackColor = System.Drawing.SystemColors.Info; tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText; this.patientSpread1.TextTipAppearance = tipAppearance1; this.patientSpread1.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; // // patientSpread1_Sheet1 // this.patientSpread1_Sheet1.Reset(); this.patientSpread1_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.patientSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.patientSpread1_Sheet1.ColumnCount = 9; this.patientSpread1_Sheet1.RowCount = 0; this.patientSpread1_Sheet1.ActiveSkin = new FarPoint.Win.Spread.SheetSkin("CustomSkin3", System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.LightGray, FarPoint.Win.Spread.GridLines.Both, System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, false, false, false, true, true); this.patientSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "选中"; this.patientSpread1_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "药品名称"; this.patientSpread1_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "规格"; this.patientSpread1_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "零售价"; this.patientSpread1_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "付数"; this.patientSpread1_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "预扣量"; this.patientSpread1_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "单位"; this.patientSpread1_Sheet1.ColumnHeader.Cells.Get(0, 7).Value = "预扣金额"; this.patientSpread1_Sheet1.ColumnHeader.Cells.Get(0, 8).Value = " 预扣时间"; this.patientSpread1_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.patientSpread1_Sheet1.ColumnHeader.DefaultStyle.Locked = false; this.patientSpread1_Sheet1.ColumnHeader.DefaultStyle.Parent = "HeaderDefault"; this.patientSpread1_Sheet1.Columns.Get(0).BackColor = System.Drawing.Color.SeaShell; this.patientSpread1_Sheet1.Columns.Get(0).CellType = checkBoxCellType1; this.patientSpread1_Sheet1.Columns.Get(0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.patientSpread1_Sheet1.Columns.Get(0).Label = "选中"; this.patientSpread1_Sheet1.Columns.Get(0).Locked = false; this.patientSpread1_Sheet1.Columns.Get(0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.patientSpread1_Sheet1.Columns.Get(1).Label = "药品名称"; this.patientSpread1_Sheet1.Columns.Get(1).Width = 130F; this.patientSpread1_Sheet1.Columns.Get(2).Label = "规格"; this.patientSpread1_Sheet1.Columns.Get(2).Width = 80F; this.patientSpread1_Sheet1.Columns.Get(3).CellType = numberCellType1; this.patientSpread1_Sheet1.Columns.Get(3).Label = "零售价"; this.patientSpread1_Sheet1.Columns.Get(4).CellType = numberCellType2; this.patientSpread1_Sheet1.Columns.Get(4).Label = "付数"; this.patientSpread1_Sheet1.Columns.Get(4).Width = 45F; this.patientSpread1_Sheet1.Columns.Get(5).CellType = numberCellType3; this.patientSpread1_Sheet1.Columns.Get(5).Label = "预扣量"; this.patientSpread1_Sheet1.Columns.Get(5).Width = 85F; this.patientSpread1_Sheet1.Columns.Get(6).Label = "单位"; this.patientSpread1_Sheet1.Columns.Get(6).Width = 48F; this.patientSpread1_Sheet1.Columns.Get(7).CellType = numberCellType4; this.patientSpread1_Sheet1.Columns.Get(7).Label = "预扣金额"; this.patientSpread1_Sheet1.Columns.Get(7).Width = 85F; dateTimeCellType1.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType1.Calendar"))); dateTimeCellType1.DateDefault = new System.DateTime(2007, 8, 1, 9, 8, 59, 0); dateTimeCellType1.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime; dateTimeCellType1.TimeDefault = new System.DateTime(2007, 8, 1, 9, 8, 59, 0); this.patientSpread1_Sheet1.Columns.Get(8).CellType = dateTimeCellType1; this.patientSpread1_Sheet1.Columns.Get(8).Label = " 预扣时间"; this.patientSpread1_Sheet1.Columns.Get(8).Width = 179F; this.patientSpread1_Sheet1.DefaultStyle.Locked = true; this.patientSpread1_Sheet1.DefaultStyle.Parent = "DataAreaDefault"; this.patientSpread1_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode; this.patientSpread1_Sheet1.RowHeader.Columns.Default.Resizable = false; this.patientSpread1_Sheet1.RowHeader.Columns.Get(0).Width = 37F; this.patientSpread1_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.patientSpread1_Sheet1.RowHeader.DefaultStyle.Locked = false; this.patientSpread1_Sheet1.RowHeader.DefaultStyle.Parent = "HeaderDefault"; this.patientSpread1_Sheet1.SheetCornerStyle.BackColor = System.Drawing.Color.White; this.patientSpread1_Sheet1.SheetCornerStyle.Locked = false; this.patientSpread1_Sheet1.SheetCornerStyle.Parent = "HeaderDefault"; this.patientSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; this.patientSpread1.SetActiveViewport(1, 0); // // neuGroupBox1 // this.neuGroupBox1.Controls.Add(this.dtpEnd); this.neuGroupBox1.Controls.Add(this.dtpBegin); this.neuGroupBox1.Controls.Add(this.neuLabel2); this.neuGroupBox1.Controls.Add(this.neuLabel1); this.neuGroupBox1.Dock = System.Windows.Forms.DockStyle.Top; this.neuGroupBox1.Location = new System.Drawing.Point(0, 0); this.neuGroupBox1.Name = "neuGroupBox1"; this.neuGroupBox1.Size = new System.Drawing.Size(688, 40); this.neuGroupBox1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuGroupBox1.TabIndex = 0; this.neuGroupBox1.TabStop = false; // // dtpEnd // this.dtpEnd.CustomFormat = "yyyy-MM-dd HH:mm:ss"; this.dtpEnd.Format = System.Windows.Forms.DateTimePickerFormat.Custom; this.dtpEnd.Location = new System.Drawing.Point(258, 13); this.dtpEnd.Name = "dtpEnd"; this.dtpEnd.Size = new System.Drawing.Size(144, 21); this.dtpEnd.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.dtpEnd.TabIndex = 1; // // dtpBegin // this.dtpBegin.CustomFormat = "yyyy-MM-dd HH:mm:ss"; this.dtpBegin.Format = System.Windows.Forms.DateTimePickerFormat.Custom; this.dtpBegin.Location = new System.Drawing.Point(77, 12); this.dtpBegin.Name = "dtpBegin"; this.dtpBegin.Size = new System.Drawing.Size(144, 21); this.dtpBegin.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.dtpBegin.TabIndex = 1; // // neuLabel2 // this.neuLabel2.AutoSize = true; this.neuLabel2.ForeColor = System.Drawing.Color.Blue; this.neuLabel2.Location = new System.Drawing.Point(231, 17); this.neuLabel2.Name = "neuLabel2"; this.neuLabel2.Size = new System.Drawing.Size(17, 12); this.neuLabel2.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuLabel2.TabIndex = 0; this.neuLabel2.Text = "-"; // // neuLabel1 // this.neuLabel1.AutoSize = true; this.neuLabel1.ForeColor = System.Drawing.Color.Blue; this.neuLabel1.Location = new System.Drawing.Point(6, 17); this.neuLabel1.Name = "neuLabel1"; this.neuLabel1.Size = new System.Drawing.Size(65, 12); this.neuLabel1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuLabel1.TabIndex = 0; this.neuLabel1.Text = "预扣时间:"; // // tabPage2 // this.tabPage2.Controls.Add(this.deptSpread); this.tabPage2.Controls.Add(this.neuGroupBox2); this.tabPage2.Location = new System.Drawing.Point(4, 21); this.tabPage2.Name = "tabPage2"; this.tabPage2.Size = new System.Drawing.Size(688, 425); this.tabPage2.TabIndex = 1; this.tabPage2.Text = "科室库存信息"; this.tabPage2.UseVisualStyleBackColor = true; // // deptSpread // this.deptSpread.About = "2.5.2007.2005"; this.deptSpread.AccessibleDescription = "deptSpread, Sheet1"; this.deptSpread.BackColor = System.Drawing.Color.White; this.deptSpread.Dock = System.Windows.Forms.DockStyle.Fill; this.deptSpread.EditModeReplace = true; this.deptSpread.FileName = ""; this.deptSpread.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.deptSpread.IsAutoSaveGridStatus = false; this.deptSpread.IsCanCustomConfigColumn = false; this.deptSpread.Location = new System.Drawing.Point(0, 40); this.deptSpread.Name = "deptSpread"; this.deptSpread.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.deptSpread_Sheet1 }); this.deptSpread.Size = new System.Drawing.Size(688, 385); this.deptSpread.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.deptSpread.TabIndex = 0; tipAppearance2.BackColor = System.Drawing.SystemColors.Info; tipAppearance2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance2.ForeColor = System.Drawing.SystemColors.InfoText; this.deptSpread.TextTipAppearance = tipAppearance2; this.deptSpread.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; // // deptSpread_Sheet1 // this.deptSpread_Sheet1.Reset(); this.deptSpread_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.deptSpread_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.deptSpread_Sheet1.ColumnCount = 12; this.deptSpread_Sheet1.RowCount = 0; this.deptSpread_Sheet1.ActiveSkin = new FarPoint.Win.Spread.SheetSkin("CustomSkin3", System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.LightGray, FarPoint.Win.Spread.GridLines.Both, System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, false, false, false, true, true); this.deptSpread_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "药品名称"; this.deptSpread_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "规格"; this.deptSpread_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "零售价"; this.deptSpread_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "生产厂家"; this.deptSpread_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "实际库存"; this.deptSpread_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "原预扣量"; this.deptSpread_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "预扣库存"; this.deptSpread_Sheet1.ColumnHeader.Cells.Get(0, 7).Value = "单位"; this.deptSpread_Sheet1.ColumnHeader.Cells.Get(0, 8).Value = "药品编码"; this.deptSpread_Sheet1.ColumnHeader.Cells.Get(0, 9).Value = "拼音码"; this.deptSpread_Sheet1.ColumnHeader.Cells.Get(0, 10).Value = "五笔码"; this.deptSpread_Sheet1.ColumnHeader.Cells.Get(0, 11).Value = "自定义码"; this.deptSpread_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.deptSpread_Sheet1.ColumnHeader.DefaultStyle.Locked = false; this.deptSpread_Sheet1.ColumnHeader.DefaultStyle.Parent = "HeaderDefault"; this.deptSpread_Sheet1.Columns.Get(0).Label = "药品名称"; this.deptSpread_Sheet1.Columns.Get(0).Width = 148F; this.deptSpread_Sheet1.Columns.Get(1).Label = "规格"; this.deptSpread_Sheet1.Columns.Get(1).Width = 80F; this.deptSpread_Sheet1.Columns.Get(2).CellType = numberCellType5; this.deptSpread_Sheet1.Columns.Get(2).Label = "零售价"; this.deptSpread_Sheet1.Columns.Get(2).Width = 85F; this.deptSpread_Sheet1.Columns.Get(3).Label = "生产厂家"; this.deptSpread_Sheet1.Columns.Get(3).Width = 147F; this.deptSpread_Sheet1.Columns.Get(4).CellType = numberCellType6; this.deptSpread_Sheet1.Columns.Get(4).Label = "实际库存"; this.deptSpread_Sheet1.Columns.Get(4).Width = 96F; this.deptSpread_Sheet1.Columns.Get(5).Label = "原预扣量"; this.deptSpread_Sheet1.Columns.Get(5).Visible = false; this.deptSpread_Sheet1.Columns.Get(5).Width = 65F; this.deptSpread_Sheet1.Columns.Get(6).BackColor = System.Drawing.Color.SeaShell; this.deptSpread_Sheet1.Columns.Get(6).CellType = numberCellType7; this.deptSpread_Sheet1.Columns.Get(6).Label = "预扣库存"; this.deptSpread_Sheet1.Columns.Get(6).Locked = false; this.deptSpread_Sheet1.Columns.Get(6).Width = 87F; this.deptSpread_Sheet1.Columns.Get(7).Label = "单位"; this.deptSpread_Sheet1.Columns.Get(7).Width = 48F; this.deptSpread_Sheet1.Columns.Get(8).Label = "药品编码"; this.deptSpread_Sheet1.Columns.Get(8).Visible = false; this.deptSpread_Sheet1.Columns.Get(9).Label = "拼音码"; this.deptSpread_Sheet1.Columns.Get(9).Visible = false; this.deptSpread_Sheet1.Columns.Get(10).Label = "五笔码"; this.deptSpread_Sheet1.Columns.Get(10).Visible = false; this.deptSpread_Sheet1.Columns.Get(11).Label = "自定义码"; this.deptSpread_Sheet1.Columns.Get(11).Visible = false; this.deptSpread_Sheet1.Columns.Get(11).Width = 66F; this.deptSpread_Sheet1.DataAutoSizeColumns = false; this.deptSpread_Sheet1.DefaultStyle.Locked = true; this.deptSpread_Sheet1.DefaultStyle.Parent = "DataAreaDefault"; this.deptSpread_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode; this.deptSpread_Sheet1.RowHeader.Columns.Default.Resizable = false; this.deptSpread_Sheet1.RowHeader.Columns.Get(0).Width = 37F; this.deptSpread_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.deptSpread_Sheet1.RowHeader.DefaultStyle.Locked = false; this.deptSpread_Sheet1.RowHeader.DefaultStyle.Parent = "HeaderDefault"; this.deptSpread_Sheet1.SheetCornerStyle.BackColor = System.Drawing.Color.White; this.deptSpread_Sheet1.SheetCornerStyle.Locked = false; this.deptSpread_Sheet1.SheetCornerStyle.Parent = "HeaderDefault"; this.deptSpread_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; this.deptSpread.SetActiveViewport(1, 0); // // neuGroupBox2 // this.neuGroupBox2.Controls.Add(this.txtFilter); this.neuGroupBox2.Controls.Add(this.neuLabel3); this.neuGroupBox2.Dock = System.Windows.Forms.DockStyle.Top; this.neuGroupBox2.Location = new System.Drawing.Point(0, 0); this.neuGroupBox2.Name = "neuGroupBox2"; this.neuGroupBox2.Size = new System.Drawing.Size(688, 40); this.neuGroupBox2.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuGroupBox2.TabIndex = 1; this.neuGroupBox2.TabStop = false; // // txtFilter // this.txtFilter.Location = new System.Drawing.Point(77, 12); this.txtFilter.Name = "txtFilter"; this.txtFilter.Size = new System.Drawing.Size(144, 21); this.txtFilter.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.txtFilter.TabIndex = 2; this.txtFilter.TextChanged += new System.EventHandler(this.txtFilter_TextChanged); this.txtFilter.KeyDown += new System.Windows.Forms.KeyEventHandler(this.txtFilter_KeyDown); // // neuLabel3 // this.neuLabel3.AutoSize = true; this.neuLabel3.ForeColor = System.Drawing.Color.Blue; this.neuLabel3.Location = new System.Drawing.Point(6, 17); this.neuLabel3.Name = "neuLabel3"; this.neuLabel3.Size = new System.Drawing.Size(65, 12); this.neuLabel3.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuLabel3.TabIndex = 1; this.neuLabel3.Text = "过 滤 框:"; // // ucDummyStockManager // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.Controls.Add(this.neuTabControl1); this.Name = "ucDummyStockManager"; this.Size = new System.Drawing.Size(696, 450); this.neuTabControl1.ResumeLayout(false); this.tabPage1.ResumeLayout(false); this.splitContainer1.Panel1.ResumeLayout(false); this.splitContainer1.Panel2.ResumeLayout(false); this.splitContainer1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.patientSpread1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.patientSpread1_Sheet1)).EndInit(); this.neuGroupBox1.ResumeLayout(false); this.neuGroupBox1.PerformLayout(); this.tabPage2.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.deptSpread)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.deptSpread_Sheet1)).EndInit(); this.neuGroupBox2.ResumeLayout(false); this.neuGroupBox2.PerformLayout(); this.ResumeLayout(false); }
/// <summary> /// 设置Farpoint显示格式 /// </summary> private void SetFpFormat() { FarPoint.Win.Spread.CellType.NumberCellType numbCellType = new FarPoint.Win.Spread.CellType.NumberCellType(); numbCellType.DecimalPlaces = 0; numbCellType.MaximumValue = 9999; numbCellType.MinimumValue = 0; FarPoint.Win.Spread.CellType.DateTimeCellType dtCellType = new FarPoint.Win.Spread.CellType.DateTimeCellType(); dtCellType.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined; dtCellType.UserDefinedFormat = "yyyy-MM-dd"; dtCellType.ReadOnly = true; FarPoint.Win.Spread.CellType.TextCellType txtCellType = new FarPoint.Win.Spread.CellType.TextCellType(); txtCellType.ReadOnly = true; #region 设置每列的属性 this.neuSpread1_Sheet1.Columns[0].CellType = dtCellType; this.neuSpread1_Sheet1.Columns[0].BackColor = System.Drawing.SystemColors.Control; this.neuSpread1_Sheet1.ColumnHeader.Columns[0].Label = "日期"; this.neuSpread1_Sheet1.ColumnHeader.Columns[0].Width = 90f; this.neuSpread1_Sheet1.Columns[1].CellType = txtCellType; this.neuSpread1_Sheet1.Columns[1].Visible = false; this.neuSpread1_Sheet1.Columns[2].CellType = txtCellType; this.neuSpread1_Sheet1.Columns[2].BackColor = System.Drawing.SystemColors.Control; this.neuSpread1_Sheet1.ColumnHeader.Columns[2].Label = "科室名称"; this.neuSpread1_Sheet1.Columns[3].CellType = numbCellType; this.neuSpread1_Sheet1.ColumnHeader.Columns[3].Label = "门诊人数"; this.neuSpread1_Sheet1.ColumnHeader.Columns[3].Width = 90f; this.neuSpread1_Sheet1.Columns[4].CellType = numbCellType; this.neuSpread1_Sheet1.ColumnHeader.Columns[4].Label = "急诊人数"; this.neuSpread1_Sheet1.ColumnHeader.Columns[4].Width = 90f; this.neuSpread1_Sheet1.Columns[5].CellType = numbCellType; this.neuSpread1_Sheet1.ColumnHeader.Columns[5].Label = "急诊死亡人数"; this.neuSpread1_Sheet1.ColumnHeader.Columns[5].Width = 90f; this.neuSpread1_Sheet1.Columns[6].CellType = numbCellType; this.neuSpread1_Sheet1.ColumnHeader.Columns[6].Label = "观察人数"; this.neuSpread1_Sheet1.ColumnHeader.Columns[6].Width = 90f; this.neuSpread1_Sheet1.Columns[7].CellType = numbCellType; this.neuSpread1_Sheet1.ColumnHeader.Columns[7].Label = "观察死亡人数"; this.neuSpread1_Sheet1.ColumnHeader.Columns[7].Width = 90f; this.neuSpread1_Sheet1.Columns[8].CellType = numbCellType; this.neuSpread1_Sheet1.Columns[8].Visible = false; this.neuSpread1_Sheet1.ColumnHeader.Columns[8].Label = "复诊人数"; this.neuSpread1_Sheet1.ColumnHeader.Columns[8].Width = 90f; this.neuSpread1_Sheet1.Columns[9].CellType = numbCellType; this.neuSpread1_Sheet1.ColumnHeader.Columns[9].Label = "其他门诊诊疗人次数"; this.neuSpread1_Sheet1.ColumnHeader.Columns[9].Width = 110f; this.neuSpread1_Sheet1.Columns[10].CellType = numbCellType; this.neuSpread1_Sheet1.Columns[10].Visible = false; this.neuSpread1_Sheet1.ColumnHeader.Columns[10].Label = "专家门诊人数"; this.neuSpread1_Sheet1.ColumnHeader.Columns[10].Width = 90f; this.neuSpread1_Sheet1.Columns[11].CellType = numbCellType; this.neuSpread1_Sheet1.Columns[11].Visible = false; this.neuSpread1_Sheet1.ColumnHeader.Columns[11].Label = "医保患者人数"; this.neuSpread1_Sheet1.ColumnHeader.Columns[11].Width = 90f; this.neuSpread1_Sheet1.Columns[12].CellType = numbCellType; this.neuSpread1_Sheet1.ColumnHeader.Columns[12].Label = "体检健康检查人数"; this.neuSpread1_Sheet1.ColumnHeader.Columns[12].Width = 110f; #endregion }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { FarPoint.Win.Spread.TipAppearance tipAppearance1 = new FarPoint.Win.Spread.TipAppearance(); FarPoint.Win.Spread.CellType.CheckBoxCellType checkBoxCellType1 = new FarPoint.Win.Spread.CellType.CheckBoxCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType1 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType1 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ucPay)); FarPoint.Win.Spread.CellType.NumberCellType numberCellType1 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType2 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType3 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType4 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType5 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType6 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.ComboBoxCellType comboBoxCellType1 = new FarPoint.Win.Spread.CellType.ComboBoxCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType2 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType2 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); FarPoint.Win.Spread.TipAppearance tipAppearance2 = new FarPoint.Win.Spread.TipAppearance(); FarPoint.Win.Spread.CellType.TextCellType textCellType3 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType7 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType8 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType4 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType3 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); this.splitContainer1 = new System.Windows.Forms.SplitContainer(); this.neuSpread1 = new Neusoft.FrameWork.WinForms.Controls.NeuSpread(); this.neuSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.neuGroupBox1 = new Neusoft.FrameWork.WinForms.Controls.NeuGroupBox(); this.lbInfo = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.rbUnPay = new System.Windows.Forms.RadioButton(); this.rbPay = new System.Windows.Forms.RadioButton(); this.lbCompany = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.neuSpread2 = new Neusoft.FrameWork.WinForms.Controls.NeuSpread(); this.neuSpread2_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.splitContainer1.Panel1.SuspendLayout(); this.splitContainer1.Panel2.SuspendLayout(); this.splitContainer1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1_Sheet1)).BeginInit(); this.neuGroupBox1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread2_Sheet1)).BeginInit(); this.SuspendLayout(); // // splitContainer1 // this.splitContainer1.Dock = System.Windows.Forms.DockStyle.Fill; this.splitContainer1.Location = new System.Drawing.Point(0, 0); this.splitContainer1.Name = "splitContainer1"; this.splitContainer1.Orientation = System.Windows.Forms.Orientation.Horizontal; // // splitContainer1.Panel1 // this.splitContainer1.Panel1.Controls.Add(this.neuSpread1); this.splitContainer1.Panel1.Controls.Add(this.neuGroupBox1); // // splitContainer1.Panel2 // this.splitContainer1.Panel2.Controls.Add(this.neuSpread2); this.splitContainer1.Size = new System.Drawing.Size(711, 352); this.splitContainer1.SplitterDistance = 169; this.splitContainer1.TabIndex = 1; // // neuSpread1 // this.neuSpread1.About = "2.5.2007.2005"; this.neuSpread1.AccessibleDescription = "neuSpread1, Sheet1"; this.neuSpread1.BackColor = System.Drawing.Color.White; this.neuSpread1.Dock = System.Windows.Forms.DockStyle.Fill; this.neuSpread1.EditModeReplace = true; this.neuSpread1.FileName = ""; this.neuSpread1.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.neuSpread1.IsAutoSaveGridStatus = false; this.neuSpread1.IsCanCustomConfigColumn = false; this.neuSpread1.Location = new System.Drawing.Point(0, 39); this.neuSpread1.Name = "neuSpread1"; this.neuSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.neuSpread1_Sheet1 }); this.neuSpread1.Size = new System.Drawing.Size(711, 130); this.neuSpread1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuSpread1.TabIndex = 2; tipAppearance1.BackColor = System.Drawing.SystemColors.Info; tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText; this.neuSpread1.TextTipAppearance = tipAppearance1; this.neuSpread1.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.neuSpread1.SelectionChanged += new FarPoint.Win.Spread.SelectionChangedEventHandler(this.neuSpread1_SelectionChanged); // // neuSpread1_Sheet1 // this.neuSpread1_Sheet1.Reset(); this.neuSpread1_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.neuSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.neuSpread1_Sheet1.ColumnCount = 16; this.neuSpread1_Sheet1.RowCount = 0; this.neuSpread1_Sheet1.ActiveSkin = new FarPoint.Win.Spread.SheetSkin("CustomSkin3", System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.LightGray, FarPoint.Win.Spread.GridLines.Both, System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, false, false, false, true, true); this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "付款"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "发票号"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "发票日期"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "发票金额"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "优惠金额"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "应付金额"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "已付金额"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 7).Value = "本次付款"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 8).Value = "运费"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 9).Value = "付款类型"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 10).Value = "开户银行"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 11).Value = "银行帐号"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 12).Value = "入库科室"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 13).Value = "入库单据号"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 14).Value = "未付款凭证"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 15).Value = "未付款凭证日期"; this.neuSpread1_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.neuSpread1_Sheet1.ColumnHeader.DefaultStyle.Locked = false; this.neuSpread1_Sheet1.ColumnHeader.DefaultStyle.Parent = "HeaderDefault"; this.neuSpread1_Sheet1.Columns.Get(0).CellType = checkBoxCellType1; this.neuSpread1_Sheet1.Columns.Get(0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.neuSpread1_Sheet1.Columns.Get(0).Label = "付款"; this.neuSpread1_Sheet1.Columns.Get(0).Width = 43F; this.neuSpread1_Sheet1.Columns.Get(1).CellType = textCellType1; this.neuSpread1_Sheet1.Columns.Get(1).Label = "发票号"; this.neuSpread1_Sheet1.Columns.Get(1).Width = 75F; dateTimeCellType1.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType1.Calendar"))); dateTimeCellType1.DateDefault = new System.DateTime(2007, 3, 16, 15, 58, 47, 0); dateTimeCellType1.TimeDefault = new System.DateTime(2007, 3, 16, 15, 58, 47, 0); this.neuSpread1_Sheet1.Columns.Get(2).CellType = dateTimeCellType1; this.neuSpread1_Sheet1.Columns.Get(2).Label = "发票日期"; this.neuSpread1_Sheet1.Columns.Get(2).Locked = false; this.neuSpread1_Sheet1.Columns.Get(2).Width = 110F; this.neuSpread1_Sheet1.Columns.Get(3).CellType = numberCellType1; this.neuSpread1_Sheet1.Columns.Get(3).Label = "发票金额"; this.neuSpread1_Sheet1.Columns.Get(4).BackColor = System.Drawing.Color.SeaShell; this.neuSpread1_Sheet1.Columns.Get(4).CellType = numberCellType2; this.neuSpread1_Sheet1.Columns.Get(4).Label = "优惠金额"; this.neuSpread1_Sheet1.Columns.Get(4).Locked = false; this.neuSpread1_Sheet1.Columns.Get(5).CellType = numberCellType3; this.neuSpread1_Sheet1.Columns.Get(5).Formula = "RC[-2]-RC[-1]"; this.neuSpread1_Sheet1.Columns.Get(5).Label = "应付金额"; this.neuSpread1_Sheet1.Columns.Get(6).CellType = numberCellType4; this.neuSpread1_Sheet1.Columns.Get(6).Label = "已付金额"; this.neuSpread1_Sheet1.Columns.Get(7).BackColor = System.Drawing.Color.SeaShell; this.neuSpread1_Sheet1.Columns.Get(7).CellType = numberCellType5; this.neuSpread1_Sheet1.Columns.Get(7).Label = "本次付款"; this.neuSpread1_Sheet1.Columns.Get(7).Locked = false; this.neuSpread1_Sheet1.Columns.Get(8).BackColor = System.Drawing.Color.SeaShell; this.neuSpread1_Sheet1.Columns.Get(8).CellType = numberCellType6; this.neuSpread1_Sheet1.Columns.Get(8).Label = "运费"; this.neuSpread1_Sheet1.Columns.Get(8).Locked = false; comboBoxCellType1.ButtonAlign = FarPoint.Win.ButtonAlign.Right; comboBoxCellType1.Items = new string[] { "现金", "支票" }; this.neuSpread1_Sheet1.Columns.Get(9).CellType = comboBoxCellType1; this.neuSpread1_Sheet1.Columns.Get(9).Label = "付款类型"; this.neuSpread1_Sheet1.Columns.Get(9).Locked = false; this.neuSpread1_Sheet1.Columns.Get(10).Label = "开户银行"; this.neuSpread1_Sheet1.Columns.Get(10).Locked = false; this.neuSpread1_Sheet1.Columns.Get(10).Width = 150F; this.neuSpread1_Sheet1.Columns.Get(11).Label = "银行帐号"; this.neuSpread1_Sheet1.Columns.Get(11).Locked = false; this.neuSpread1_Sheet1.Columns.Get(11).Width = 80F; this.neuSpread1_Sheet1.Columns.Get(12).Label = "入库科室"; this.neuSpread1_Sheet1.Columns.Get(12).Width = 92F; this.neuSpread1_Sheet1.Columns.Get(13).CellType = textCellType2; this.neuSpread1_Sheet1.Columns.Get(13).Label = "入库单据号"; this.neuSpread1_Sheet1.Columns.Get(13).Width = 75F; this.neuSpread1_Sheet1.Columns.Get(14).Label = "未付款凭证"; this.neuSpread1_Sheet1.Columns.Get(14).Width = 74F; dateTimeCellType2.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType2.Calendar"))); dateTimeCellType2.DateDefault = new System.DateTime(2008, 3, 11, 16, 6, 46, 0); dateTimeCellType2.TimeDefault = new System.DateTime(2008, 3, 11, 16, 6, 46, 0); this.neuSpread1_Sheet1.Columns.Get(15).CellType = dateTimeCellType2; this.neuSpread1_Sheet1.Columns.Get(15).Label = "未付款凭证日期"; this.neuSpread1_Sheet1.Columns.Get(15).Width = 97F; this.neuSpread1_Sheet1.DefaultStyle.Locked = true; this.neuSpread1_Sheet1.DefaultStyle.Parent = "DataAreaDefault"; this.neuSpread1_Sheet1.RowHeader.Columns.Default.Resizable = false; this.neuSpread1_Sheet1.RowHeader.Columns.Get(0).Width = 37F; this.neuSpread1_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.neuSpread1_Sheet1.RowHeader.DefaultStyle.Locked = false; this.neuSpread1_Sheet1.RowHeader.DefaultStyle.Parent = "HeaderDefault"; this.neuSpread1_Sheet1.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Row; this.neuSpread1_Sheet1.SheetCornerStyle.BackColor = System.Drawing.Color.White; this.neuSpread1_Sheet1.SheetCornerStyle.Locked = false; this.neuSpread1_Sheet1.SheetCornerStyle.Parent = "HeaderDefault"; this.neuSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; this.neuSpread1.SetActiveViewport(1, 0); // // neuGroupBox1 // this.neuGroupBox1.Controls.Add(this.lbInfo); this.neuGroupBox1.Controls.Add(this.rbUnPay); this.neuGroupBox1.Controls.Add(this.rbPay); this.neuGroupBox1.Controls.Add(this.lbCompany); this.neuGroupBox1.Dock = System.Windows.Forms.DockStyle.Top; this.neuGroupBox1.Location = new System.Drawing.Point(0, 0); this.neuGroupBox1.Name = "neuGroupBox1"; this.neuGroupBox1.Size = new System.Drawing.Size(711, 39); this.neuGroupBox1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuGroupBox1.TabIndex = 1; this.neuGroupBox1.TabStop = false; // // lbInfo // this.lbInfo.AutoSize = true; this.lbInfo.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.lbInfo.ForeColor = System.Drawing.Color.Blue; this.lbInfo.Location = new System.Drawing.Point(504, 17); this.lbInfo.Name = "lbInfo"; this.lbInfo.Size = new System.Drawing.Size(203, 14); this.lbInfo.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lbInfo.TabIndex = 3; this.lbInfo.Text = "查询之前请您认真设定查询条件"; // // rbUnPay // this.rbUnPay.AutoSize = true; this.rbUnPay.Checked = true; this.rbUnPay.ForeColor = System.Drawing.Color.Blue; this.rbUnPay.Location = new System.Drawing.Point(353, 17); this.rbUnPay.Name = "rbUnPay"; this.rbUnPay.Size = new System.Drawing.Size(59, 16); this.rbUnPay.TabIndex = 1; this.rbUnPay.TabStop = true; this.rbUnPay.Text = "未结存"; this.rbUnPay.UseVisualStyleBackColor = true; this.rbUnPay.CheckedChanged += new System.EventHandler(this.rbUnPay_CheckedChanged); // // rbPay // this.rbPay.AutoSize = true; this.rbPay.ForeColor = System.Drawing.Color.Blue; this.rbPay.Location = new System.Drawing.Point(434, 17); this.rbPay.Name = "rbPay"; this.rbPay.Size = new System.Drawing.Size(59, 16); this.rbPay.TabIndex = 1; this.rbPay.TabStop = true; this.rbPay.Text = "已结存"; this.rbPay.UseVisualStyleBackColor = true; this.rbPay.CheckedChanged += new System.EventHandler(this.rbPay_CheckedChanged); // // lbCompany // this.lbCompany.AutoSize = true; this.lbCompany.Dock = System.Windows.Forms.DockStyle.Fill; this.lbCompany.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.lbCompany.ForeColor = System.Drawing.Color.Blue; this.lbCompany.Location = new System.Drawing.Point(3, 17); this.lbCompany.Name = "lbCompany"; this.lbCompany.Size = new System.Drawing.Size(77, 14); this.lbCompany.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lbCompany.TabIndex = 0; this.lbCompany.Text = "结存单位:"; this.lbCompany.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // neuSpread2 // this.neuSpread2.About = "2.5.2007.2005"; this.neuSpread2.AccessibleDescription = "neuSpread2, Sheet1"; this.neuSpread2.BackColor = System.Drawing.Color.White; this.neuSpread2.Dock = System.Windows.Forms.DockStyle.Fill; this.neuSpread2.FileName = ""; this.neuSpread2.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.neuSpread2.IsAutoSaveGridStatus = false; this.neuSpread2.IsCanCustomConfigColumn = false; this.neuSpread2.Location = new System.Drawing.Point(0, 0); this.neuSpread2.Name = "neuSpread2"; this.neuSpread2.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.neuSpread2_Sheet1 }); this.neuSpread2.Size = new System.Drawing.Size(711, 179); this.neuSpread2.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuSpread2.TabIndex = 0; tipAppearance2.BackColor = System.Drawing.SystemColors.Info; tipAppearance2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance2.ForeColor = System.Drawing.SystemColors.InfoText; this.neuSpread2.TextTipAppearance = tipAppearance2; this.neuSpread2.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; // // neuSpread2_Sheet1 // this.neuSpread2_Sheet1.Reset(); this.neuSpread2_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.neuSpread2_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.neuSpread2_Sheet1.ColumnCount = 8; this.neuSpread2_Sheet1.RowCount = 0; this.neuSpread2_Sheet1.ActiveSkin = new FarPoint.Win.Spread.SheetSkin("CustomSkin3", System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.LightGray, FarPoint.Win.Spread.GridLines.Both, System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, false, false, false, true, true); this.neuSpread2_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "发票号"; this.neuSpread2_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "本次付款"; this.neuSpread2_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "运费"; this.neuSpread2_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "付款类型"; this.neuSpread2_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "开户银行"; this.neuSpread2_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "银行帐号"; this.neuSpread2_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "付款人"; this.neuSpread2_Sheet1.ColumnHeader.Cells.Get(0, 7).Value = "付款日期"; this.neuSpread2_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.neuSpread2_Sheet1.ColumnHeader.DefaultStyle.Locked = false; this.neuSpread2_Sheet1.ColumnHeader.DefaultStyle.Parent = "HeaderDefault"; this.neuSpread2_Sheet1.Columns.Get(0).CellType = textCellType3; this.neuSpread2_Sheet1.Columns.Get(0).Label = "发票号"; this.neuSpread2_Sheet1.Columns.Get(0).Width = 81F; this.neuSpread2_Sheet1.Columns.Get(1).CellType = numberCellType7; this.neuSpread2_Sheet1.Columns.Get(1).Label = "本次付款"; this.neuSpread2_Sheet1.Columns.Get(2).CellType = numberCellType8; this.neuSpread2_Sheet1.Columns.Get(2).Label = "运费"; this.neuSpread2_Sheet1.Columns.Get(3).CellType = textCellType4; this.neuSpread2_Sheet1.Columns.Get(3).Label = "付款类型"; this.neuSpread2_Sheet1.Columns.Get(4).Label = "开户银行"; this.neuSpread2_Sheet1.Columns.Get(4).Width = 134F; this.neuSpread2_Sheet1.Columns.Get(5).Label = "银行帐号"; this.neuSpread2_Sheet1.Columns.Get(5).Width = 86F; this.neuSpread2_Sheet1.Columns.Get(6).Label = "付款人"; this.neuSpread2_Sheet1.Columns.Get(6).Width = 66F; dateTimeCellType3.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType3.Calendar"))); dateTimeCellType3.DateDefault = new System.DateTime(2007, 3, 16, 16, 4, 39, 0); dateTimeCellType3.TimeDefault = new System.DateTime(2007, 3, 16, 16, 4, 39, 0); this.neuSpread2_Sheet1.Columns.Get(7).CellType = dateTimeCellType3; this.neuSpread2_Sheet1.Columns.Get(7).Label = "付款日期"; this.neuSpread2_Sheet1.Columns.Get(7).Width = 120F; this.neuSpread2_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode; this.neuSpread2_Sheet1.RowHeader.Columns.Default.Resizable = false; this.neuSpread2_Sheet1.RowHeader.Columns.Get(0).Width = 37F; this.neuSpread2_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.neuSpread2_Sheet1.RowHeader.DefaultStyle.Locked = false; this.neuSpread2_Sheet1.RowHeader.DefaultStyle.Parent = "HeaderDefault"; this.neuSpread2_Sheet1.SheetCornerStyle.BackColor = System.Drawing.Color.White; this.neuSpread2_Sheet1.SheetCornerStyle.Locked = false; this.neuSpread2_Sheet1.SheetCornerStyle.Parent = "HeaderDefault"; this.neuSpread2_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; this.neuSpread2.SetActiveViewport(1, 0); // // ucPay // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.BackColor = System.Drawing.Color.White; this.Controls.Add(this.splitContainer1); this.Name = "ucPay"; this.Size = new System.Drawing.Size(711, 352); this.splitContainer1.Panel1.ResumeLayout(false); this.splitContainer1.Panel2.ResumeLayout(false); this.splitContainer1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1_Sheet1)).EndInit(); this.neuGroupBox1.ResumeLayout(false); this.neuGroupBox1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread2_Sheet1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { FarPoint.Win.Spread.TipAppearance tipAppearance1 = new FarPoint.Win.Spread.TipAppearance(); FarPoint.Win.Spread.CellType.CheckBoxCellType checkBoxCellType1 = new FarPoint.Win.Spread.CellType.CheckBoxCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType1 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ucConfirm)); FarPoint.Win.Spread.CellType.NumberCellType numberCellType1 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType2 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType3 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); this.panel1 = new System.Windows.Forms.Panel(); this.neuSpread1 = new Neusoft.FrameWork.WinForms.Controls.NeuSpread(); this.neuSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.splitter1 = new System.Windows.Forms.Splitter(); this.panel2 = new System.Windows.Forms.Panel(); this.neuGroupBox2 = new Neusoft.FrameWork.WinForms.Controls.NeuGroupBox(); this.txtBirthday = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox(); this.neuLabel6 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.txtAge = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox(); this.neuLabel7 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.txtSex = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox(); this.neuLabel4 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.txtName = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox(); this.neuLabel5 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.neuGroupBox1 = new Neusoft.FrameWork.WinForms.Controls.NeuGroupBox(); this.dtpExec = new Neusoft.FrameWork.WinForms.Controls.NeuDateTimePicker(); this.neuLabel3 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.txtOrder = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox(); this.neuLabel2 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.txtCardNo = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox(); this.neuLabel1 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.ucDosageAlter1 = new Neusoft.HISFC.Components.Nurse.Inject.ucDosageAlter(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1_Sheet1)).BeginInit(); this.panel2.SuspendLayout(); this.neuGroupBox2.SuspendLayout(); this.neuGroupBox1.SuspendLayout(); this.SuspendLayout(); // // panel1 // this.panel1.Controls.Add(this.neuSpread1); this.panel1.Controls.Add(this.ucDosageAlter1); this.panel1.Controls.Add(this.splitter1); this.panel1.Controls.Add(this.panel2); this.panel1.Dock = System.Windows.Forms.DockStyle.Fill; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(748, 508); this.panel1.TabIndex = 0; // // neuSpread1 // this.neuSpread1.About = "3.0.2004.2005"; this.neuSpread1.AccessibleDescription = "neuSpread1, Sheet1, Row 0, Column 0, "; this.neuSpread1.BackColor = System.Drawing.Color.White; this.neuSpread1.Dock = System.Windows.Forms.DockStyle.Fill; this.neuSpread1.FileName = ""; this.neuSpread1.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.neuSpread1.IsAutoSaveGridStatus = false; this.neuSpread1.IsCanCustomConfigColumn = false; this.neuSpread1.Location = new System.Drawing.Point(206, 0); this.neuSpread1.Name = "neuSpread1"; this.neuSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.neuSpread1_Sheet1 }); this.neuSpread1.Size = new System.Drawing.Size(542, 286); this.neuSpread1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuSpread1.TabIndex = 2; tipAppearance1.BackColor = System.Drawing.SystemColors.Info; tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText; this.neuSpread1.TextTipAppearance = tipAppearance1; this.neuSpread1.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.neuSpread1.ButtonClicked += new FarPoint.Win.Spread.EditorNotifyEventHandler(this.neuSpread1_ButtonClicked); this.neuSpread1.CellDoubleClick += new FarPoint.Win.Spread.CellClickEventHandler(this.neuSpread1_CellDoubleClick); this.neuSpread1.CellClick += new FarPoint.Win.Spread.CellClickEventHandler(this.neuSpread1_CellClick); this.neuSpread1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.neuSpread1_KeyDown); // // neuSpread1_Sheet1 // this.neuSpread1_Sheet1.Reset(); this.neuSpread1_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.neuSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.neuSpread1_Sheet1.ColumnCount = 21; this.neuSpread1_Sheet1.RowCount = 0; this.neuSpread1_Sheet1.ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Blank; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "Seq"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "顺序号"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "患者姓名"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "开单医生"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "科别"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "午别"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 7).Value = "医嘱"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 8).Value = "组合"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 9).Value = "每次量"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 10).Value = "频次"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 11).Value = "用法"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 12).Value = "皮试?"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 13).Value = "配药护士"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 14).Value = "注射护士"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 15).Value = "注射时间"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 16).Value = "滴速"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 17).Value = "拔针人"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 18).Value = "拔针时间"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 19).Value = "送急诊时间"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 20).Value = "备注"; this.neuSpread1_Sheet1.ColumnHeader.Rows.Get(0).Height = 30F; this.neuSpread1_Sheet1.Columns.Get(0).CellType = checkBoxCellType1; this.neuSpread1_Sheet1.Columns.Get(0).Width = 27F; this.neuSpread1_Sheet1.Columns.Get(1).Label = "Seq"; this.neuSpread1_Sheet1.Columns.Get(1).Width = 26F; this.neuSpread1_Sheet1.Columns.Get(2).Label = "顺序号"; this.neuSpread1_Sheet1.Columns.Get(2).Width = 33F; this.neuSpread1_Sheet1.Columns.Get(4).Label = "开单医生"; this.neuSpread1_Sheet1.Columns.Get(4).Width = 56F; this.neuSpread1_Sheet1.Columns.Get(5).Label = "科别"; this.neuSpread1_Sheet1.Columns.Get(5).Width = 70F; this.neuSpread1_Sheet1.Columns.Get(6).Label = "午别"; this.neuSpread1_Sheet1.Columns.Get(6).Width = 32F; this.neuSpread1_Sheet1.Columns.Get(7).Label = "医嘱"; this.neuSpread1_Sheet1.Columns.Get(7).Width = 150F; this.neuSpread1_Sheet1.Columns.Get(8).Font = new System.Drawing.Font("Microsoft Sans Serif", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.neuSpread1_Sheet1.Columns.Get(8).ForeColor = System.Drawing.Color.Red; this.neuSpread1_Sheet1.Columns.Get(8).Label = "组合"; this.neuSpread1_Sheet1.Columns.Get(8).Width = 22F; this.neuSpread1_Sheet1.Columns.Get(9).Label = "每次量"; this.neuSpread1_Sheet1.Columns.Get(9).Width = 65F; this.neuSpread1_Sheet1.Columns.Get(10).Label = "频次"; this.neuSpread1_Sheet1.Columns.Get(10).Width = 39F; this.neuSpread1_Sheet1.Columns.Get(11).Label = "用法"; this.neuSpread1_Sheet1.Columns.Get(11).Width = 41F; this.neuSpread1_Sheet1.Columns.Get(12).Label = "皮试?"; this.neuSpread1_Sheet1.Columns.Get(12).Width = 27F; this.neuSpread1_Sheet1.Columns.Get(13).Label = "配药护士"; this.neuSpread1_Sheet1.Columns.Get(13).Width = 56F; this.neuSpread1_Sheet1.Columns.Get(14).Label = "注射护士"; this.neuSpread1_Sheet1.Columns.Get(14).Width = 58F; dateTimeCellType1.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType1.Calendar"))); dateTimeCellType1.CalendarSurroundingDaysColor = System.Drawing.SystemColors.GrayText; dateTimeCellType1.DateDefault = new System.DateTime(2007, 3, 10, 15, 3, 57, 0); dateTimeCellType1.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined; dateTimeCellType1.MaximumTime = System.TimeSpan.Parse("23:59:59"); dateTimeCellType1.SpinButton = true; dateTimeCellType1.TimeDefault = new System.DateTime(2007, 3, 10, 15, 3, 57, 0); dateTimeCellType1.UserDefinedFormat = "yyyy-MM-dd HH:mm"; this.neuSpread1_Sheet1.Columns.Get(15).CellType = dateTimeCellType1; this.neuSpread1_Sheet1.Columns.Get(15).Label = "注射时间"; this.neuSpread1_Sheet1.Columns.Get(15).Width = 100F; numberCellType1.MaximumValue = 9999999; numberCellType1.MinimumValue = 0; numberCellType1.SpinDecimalIncrement = 1F; this.neuSpread1_Sheet1.Columns.Get(16).CellType = numberCellType1; this.neuSpread1_Sheet1.Columns.Get(16).Label = "滴速"; this.neuSpread1_Sheet1.Columns.Get(16).Width = 26F; dateTimeCellType2.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.Arrows; dateTimeCellType2.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType2.Calendar"))); dateTimeCellType2.CalendarSurroundingDaysColor = System.Drawing.SystemColors.GrayText; dateTimeCellType2.DateDefault = new System.DateTime(2007, 3, 10, 15, 3, 57, 0); dateTimeCellType2.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined; dateTimeCellType2.MaximumTime = System.TimeSpan.Parse("23:59:59"); dateTimeCellType2.TimeDefault = new System.DateTime(2007, 3, 10, 15, 3, 57, 0); dateTimeCellType2.UserDefinedFormat = "yy-MM-dd HH:mm"; this.neuSpread1_Sheet1.Columns.Get(18).CellType = dateTimeCellType2; this.neuSpread1_Sheet1.Columns.Get(18).Label = "拔针时间"; this.neuSpread1_Sheet1.Columns.Get(18).Width = 101F; dateTimeCellType3.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType3.Calendar"))); dateTimeCellType3.CalendarSurroundingDaysColor = System.Drawing.SystemColors.GrayText; dateTimeCellType3.DateDefault = new System.DateTime(2007, 3, 10, 15, 3, 57, 0); dateTimeCellType3.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined; dateTimeCellType3.TimeDefault = new System.DateTime(2007, 3, 10, 15, 3, 57, 0); dateTimeCellType3.UserDefinedFormat = "yyyy-MM-dd HH:mm"; this.neuSpread1_Sheet1.Columns.Get(19).CellType = dateTimeCellType3; this.neuSpread1_Sheet1.Columns.Get(19).Label = "送急诊时间"; this.neuSpread1_Sheet1.Columns.Get(19).Width = 108F; this.neuSpread1_Sheet1.Columns.Get(20).Label = "备注"; this.neuSpread1_Sheet1.Columns.Get(20).Width = 117F; this.neuSpread1_Sheet1.GrayAreaBackColor = System.Drawing.SystemColors.Window; this.neuSpread1_Sheet1.RowHeader.Columns.Default.Resizable = false; this.neuSpread1_Sheet1.RowHeader.Columns.Get(0).Width = 34F; this.neuSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; this.neuSpread1.SetActiveViewport(0, 1, 0); // // splitter1 // this.splitter1.Location = new System.Drawing.Point(200, 0); this.splitter1.Name = "splitter1"; this.splitter1.Size = new System.Drawing.Size(6, 508); this.splitter1.TabIndex = 1; this.splitter1.TabStop = false; // // panel2 // this.panel2.BackColor = System.Drawing.Color.Linen; this.panel2.Controls.Add(this.neuGroupBox2); this.panel2.Controls.Add(this.neuGroupBox1); this.panel2.Dock = System.Windows.Forms.DockStyle.Left; this.panel2.ForeColor = System.Drawing.Color.Black; this.panel2.Location = new System.Drawing.Point(0, 0); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(200, 508); this.panel2.TabIndex = 0; // // neuGroupBox2 // this.neuGroupBox2.Controls.Add(this.txtBirthday); this.neuGroupBox2.Controls.Add(this.neuLabel6); this.neuGroupBox2.Controls.Add(this.txtAge); this.neuGroupBox2.Controls.Add(this.neuLabel7); this.neuGroupBox2.Controls.Add(this.txtSex); this.neuGroupBox2.Controls.Add(this.neuLabel4); this.neuGroupBox2.Controls.Add(this.txtName); this.neuGroupBox2.Controls.Add(this.neuLabel5); this.neuGroupBox2.Dock = System.Windows.Forms.DockStyle.Top; this.neuGroupBox2.Location = new System.Drawing.Point(0, 151); this.neuGroupBox2.Name = "neuGroupBox2"; this.neuGroupBox2.Size = new System.Drawing.Size(200, 192); this.neuGroupBox2.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuGroupBox2.TabIndex = 1; this.neuGroupBox2.TabStop = false; this.neuGroupBox2.Text = "患者信息"; // // txtBirthday // this.txtBirthday.IsEnter2Tab = false; this.txtBirthday.Location = new System.Drawing.Point(76, 132); this.txtBirthday.Name = "txtBirthday"; this.txtBirthday.Size = new System.Drawing.Size(114, 21); this.txtBirthday.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.txtBirthday.TabIndex = 11; // // neuLabel6 // this.neuLabel6.AutoSize = true; this.neuLabel6.Location = new System.Drawing.Point(11, 135); this.neuLabel6.Name = "neuLabel6"; this.neuLabel6.Size = new System.Drawing.Size(53, 12); this.neuLabel6.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuLabel6.TabIndex = 10; this.neuLabel6.Text = "出生日期"; // // txtAge // this.txtAge.IsEnter2Tab = false; this.txtAge.Location = new System.Drawing.Point(76, 96); this.txtAge.Name = "txtAge"; this.txtAge.Size = new System.Drawing.Size(114, 21); this.txtAge.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.txtAge.TabIndex = 9; // // neuLabel7 // this.neuLabel7.AutoSize = true; this.neuLabel7.Location = new System.Drawing.Point(11, 99); this.neuLabel7.Name = "neuLabel7"; this.neuLabel7.Size = new System.Drawing.Size(53, 12); this.neuLabel7.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuLabel7.TabIndex = 8; this.neuLabel7.Text = "年 龄"; // // txtSex // this.txtSex.IsEnter2Tab = false; this.txtSex.Location = new System.Drawing.Point(76, 61); this.txtSex.Name = "txtSex"; this.txtSex.Size = new System.Drawing.Size(114, 21); this.txtSex.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.txtSex.TabIndex = 7; // // neuLabel4 // this.neuLabel4.AutoSize = true; this.neuLabel4.Location = new System.Drawing.Point(11, 64); this.neuLabel4.Name = "neuLabel4"; this.neuLabel4.Size = new System.Drawing.Size(53, 12); this.neuLabel4.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuLabel4.TabIndex = 6; this.neuLabel4.Text = "性 别"; // // txtName // this.txtName.IsEnter2Tab = false; this.txtName.Location = new System.Drawing.Point(76, 25); this.txtName.Name = "txtName"; this.txtName.Size = new System.Drawing.Size(114, 21); this.txtName.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.txtName.TabIndex = 5; // // neuLabel5 // this.neuLabel5.AutoSize = true; this.neuLabel5.Location = new System.Drawing.Point(11, 28); this.neuLabel5.Name = "neuLabel5"; this.neuLabel5.Size = new System.Drawing.Size(53, 12); this.neuLabel5.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuLabel5.TabIndex = 4; this.neuLabel5.Text = "姓 名"; // // neuGroupBox1 // this.neuGroupBox1.Controls.Add(this.dtpExec); this.neuGroupBox1.Controls.Add(this.neuLabel3); this.neuGroupBox1.Controls.Add(this.txtOrder); this.neuGroupBox1.Controls.Add(this.neuLabel2); this.neuGroupBox1.Controls.Add(this.txtCardNo); this.neuGroupBox1.Controls.Add(this.neuLabel1); this.neuGroupBox1.Dock = System.Windows.Forms.DockStyle.Top; this.neuGroupBox1.Location = new System.Drawing.Point(0, 0); this.neuGroupBox1.Name = "neuGroupBox1"; this.neuGroupBox1.Size = new System.Drawing.Size(200, 151); this.neuGroupBox1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuGroupBox1.TabIndex = 0; this.neuGroupBox1.TabStop = false; // // dtpExec // this.dtpExec.IsEnter2Tab = false; this.dtpExec.Location = new System.Drawing.Point(76, 96); this.dtpExec.Name = "dtpExec"; this.dtpExec.Size = new System.Drawing.Size(114, 21); this.dtpExec.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.dtpExec.TabIndex = 5; // // neuLabel3 // this.neuLabel3.AutoSize = true; this.neuLabel3.Location = new System.Drawing.Point(11, 100); this.neuLabel3.Name = "neuLabel3"; this.neuLabel3.Size = new System.Drawing.Size(53, 12); this.neuLabel3.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuLabel3.TabIndex = 4; this.neuLabel3.Text = "执行日期"; // // txtOrder // this.txtOrder.IsEnter2Tab = false; this.txtOrder.Location = new System.Drawing.Point(76, 61); this.txtOrder.Name = "txtOrder"; this.txtOrder.Size = new System.Drawing.Size(114, 21); this.txtOrder.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.txtOrder.TabIndex = 3; this.txtOrder.KeyDown += new System.Windows.Forms.KeyEventHandler(this.txtOrder_KeyDown); // // neuLabel2 // this.neuLabel2.AutoSize = true; this.neuLabel2.Location = new System.Drawing.Point(11, 64); this.neuLabel2.Name = "neuLabel2"; this.neuLabel2.Size = new System.Drawing.Size(53, 12); this.neuLabel2.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuLabel2.TabIndex = 2; this.neuLabel2.Text = "队 列 号"; // // txtCardNo // this.txtCardNo.IsEnter2Tab = false; this.txtCardNo.Location = new System.Drawing.Point(76, 25); this.txtCardNo.Name = "txtCardNo"; this.txtCardNo.Size = new System.Drawing.Size(114, 21); this.txtCardNo.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.txtCardNo.TabIndex = 1; this.txtCardNo.KeyDown += new System.Windows.Forms.KeyEventHandler(this.txtCardNo_KeyDown); // // neuLabel1 // this.neuLabel1.AutoSize = true; this.neuLabel1.Location = new System.Drawing.Point(11, 28); this.neuLabel1.Name = "neuLabel1"; this.neuLabel1.Size = new System.Drawing.Size(53, 12); this.neuLabel1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuLabel1.TabIndex = 0; this.neuLabel1.Text = "病 历 号"; // // ucDosageAlter1 // this.ucDosageAlter1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(241)))), ((int)(((byte)(247)))), ((int)(((byte)(213))))); this.ucDosageAlter1.Dock = System.Windows.Forms.DockStyle.Bottom; this.ucDosageAlter1.IsPrint = false; this.ucDosageAlter1.Location = new System.Drawing.Point(206, 286); this.ucDosageAlter1.Name = "ucDosageAlter1"; this.ucDosageAlter1.QueryDate = new System.DateTime(2010, 7, 23, 15, 13, 41, 174); this.ucDosageAlter1.Size = new System.Drawing.Size(542, 222); this.ucDosageAlter1.TabIndex = 3; this.ucDosageAlter1.Visible = false; // // ucConfirm // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.Controls.Add(this.panel1); this.Name = "ucConfirm"; this.Size = new System.Drawing.Size(748, 508); this.Load += new System.EventHandler(this.ucConfirm_Load); this.panel1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1_Sheet1)).EndInit(); this.panel2.ResumeLayout(false); this.neuGroupBox2.ResumeLayout(false); this.neuGroupBox2.PerformLayout(); this.neuGroupBox1.ResumeLayout(false); this.neuGroupBox1.PerformLayout(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(TRN150_NGInquiry)); FarPoint.Win.Spread.CellType.TextCellType textCellType1 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType2 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType3 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType4 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType1 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType5 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType1 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType6 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType7 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType8 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType9 = new FarPoint.Win.Spread.CellType.TextCellType(); this.rdoGroupItem = new EVOFramework.Windows.Forms.EVORadioButton(); this.rdoGroupItemLotNo = new EVOFramework.Windows.Forms.EVORadioButton(); this.dtPeriodBegin = new EVOFramework.Windows.Forms.EVODateTextBoxWithCalendar(); this.dtPeriodEnd = new EVOFramework.Windows.Forms.EVODateTextBoxWithCalendar(); this.tlpTitle = new System.Windows.Forms.TableLayoutPanel(); this.label1 = new EVOFramework.Windows.Forms.EVOLabel(); this.lblItemCode = new EVOFramework.Windows.Forms.EVOLabel(); this.txtItemDesc = new EVOFramework.Windows.Forms.EVOTextBox(); this.btnItemCode = new EVOFramework.Windows.Forms.EVOButton(); this.txtItemFrom = new Rubik.Forms.UserControl.ItemTextBox(); this.evoTextBox1 = new EVOFramework.Windows.Forms.EVOTextBox(); this.evoButton1 = new EVOFramework.Windows.Forms.EVOButton(); this.txtItemTo = new Rubik.Forms.UserControl.ItemTextBox(); this.evoLabel1 = new EVOFramework.Windows.Forms.EVOLabel(); this.lblWorkResultDate = new EVOFramework.Windows.Forms.EVOLabel(); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.label2 = new System.Windows.Forms.Label(); this.btlFind = new System.Windows.Forms.Button(); this.evoPanel1 = new EVOFramework.Windows.Forms.EVOPanel(); this.txtLotNumber = new EVOFramework.Windows.Forms.EVOTextBox(); this.fpView = new FarPoint.Win.Spread.FpSpread(); this.shtView = new FarPoint.Win.Spread.SheetView(); this.evoLabel2 = new EVOFramework.Windows.Forms.EVOLabel(); this.pnlContainer.SuspendLayout(); this.tlpTitle.SuspendLayout(); this.groupBox1.SuspendLayout(); this.evoPanel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpView)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.shtView)).BeginInit(); this.SuspendLayout(); // // pnlContainer // this.pnlContainer.BackColor = System.Drawing.Color.AliceBlue; this.pnlContainer.Controls.Add(this.evoTextBox1); this.pnlContainer.Controls.Add(this.label2); this.pnlContainer.Controls.Add(this.dtPeriodBegin); this.pnlContainer.Controls.Add(this.lblWorkResultDate); this.pnlContainer.Controls.Add(this.evoButton1); this.pnlContainer.Controls.Add(this.txtItemTo); this.pnlContainer.Controls.Add(this.evoLabel1); this.pnlContainer.Controls.Add(this.txtItemDesc); this.pnlContainer.Controls.Add(this.txtItemFrom); this.pnlContainer.Controls.Add(this.btnItemCode); this.pnlContainer.Controls.Add(this.lblItemCode); this.pnlContainer.Controls.Add(this.dtPeriodEnd); this.pnlContainer.Controls.Add(this.groupBox1); this.pnlContainer.Controls.Add(this.evoPanel1); this.pnlContainer.Font = new System.Drawing.Font("Tahoma", 12F); this.pnlContainer.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); this.pnlContainer.Size = new System.Drawing.Size(879, 517); // // rdoGroupItem // this.rdoGroupItem.AppearanceName = ""; this.rdoGroupItem.Checked = true; this.rdoGroupItem.ControlID = null; this.rdoGroupItem.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222))); this.rdoGroupItem.Location = new System.Drawing.Point(6, 17); this.rdoGroupItem.Name = "rdoGroupItem"; this.rdoGroupItem.PathString = null; this.rdoGroupItem.Size = new System.Drawing.Size(109, 26); this.rdoGroupItem.SpecificValue = null; this.rdoGroupItem.TabIndex = 3; this.rdoGroupItem.TabStop = true; this.rdoGroupItem.Text = "By Item"; this.rdoGroupItem.UseVisualStyleBackColor = true; this.rdoGroupItem.CheckedChanged += new System.EventHandler(this.rdoGroupItem_CheckedChanged); // // rdoGroupItemLotNo // this.rdoGroupItemLotNo.AppearanceName = ""; this.rdoGroupItemLotNo.ControlID = null; this.rdoGroupItemLotNo.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222))); this.rdoGroupItemLotNo.Location = new System.Drawing.Point(121, 17); this.rdoGroupItemLotNo.Name = "rdoGroupItemLotNo"; this.rdoGroupItemLotNo.PathString = null; this.rdoGroupItemLotNo.Size = new System.Drawing.Size(148, 25); this.rdoGroupItemLotNo.SpecificValue = null; this.rdoGroupItemLotNo.TabIndex = 2; this.rdoGroupItemLotNo.Text = "By Item, Lot No."; this.rdoGroupItemLotNo.UseVisualStyleBackColor = true; // // dtPeriodBegin // this.dtPeriodBegin.AppearanceName = ""; this.dtPeriodBegin.AppearanceReadOnlyName = ""; this.dtPeriodBegin.BackColor = System.Drawing.Color.Transparent; this.dtPeriodBegin.ControlID = ""; this.dtPeriodBegin.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222))); this.dtPeriodBegin.Format = "dd/MM/yyyy"; this.dtPeriodBegin.Location = new System.Drawing.Point(475, 63); this.dtPeriodBegin.MinimumSize = new System.Drawing.Size(100, 0); this.dtPeriodBegin.Name = "dtPeriodBegin"; this.dtPeriodBegin.NZValue = ((EVOFramework.NZDateTime)(resources.GetObject("dtPeriodBegin.NZValue"))); this.dtPeriodBegin.PathString = null; this.dtPeriodBegin.PathValue = ((object)(resources.GetObject("dtPeriodBegin.PathValue"))); this.dtPeriodBegin.ReadOnly = false; this.dtPeriodBegin.ShowButton = true; this.dtPeriodBegin.Size = new System.Drawing.Size(139, 26); this.dtPeriodBegin.TabIndex = 7; this.dtPeriodBegin.Value = null; // // dtPeriodEnd // this.dtPeriodEnd.AppearanceName = ""; this.dtPeriodEnd.AppearanceReadOnlyName = ""; this.dtPeriodEnd.BackColor = System.Drawing.Color.Transparent; this.dtPeriodEnd.ControlID = ""; this.dtPeriodEnd.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222))); this.dtPeriodEnd.Format = "dd/MM/yyyy"; this.dtPeriodEnd.Location = new System.Drawing.Point(670, 62); this.dtPeriodEnd.MinimumSize = new System.Drawing.Size(100, 0); this.dtPeriodEnd.Name = "dtPeriodEnd"; this.dtPeriodEnd.NZValue = ((EVOFramework.NZDateTime)(resources.GetObject("dtPeriodEnd.NZValue"))); this.dtPeriodEnd.PathString = null; this.dtPeriodEnd.PathValue = ((object)(resources.GetObject("dtPeriodEnd.PathValue"))); this.dtPeriodEnd.ReadOnly = false; this.dtPeriodEnd.ShowButton = true; this.dtPeriodEnd.Size = new System.Drawing.Size(145, 26); this.dtPeriodEnd.TabIndex = 8; this.dtPeriodEnd.Value = null; // // tlpTitle // this.tlpTitle.ColumnCount = 1; this.tlpTitle.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 100F)); this.tlpTitle.Controls.Add(this.label1, 0, 0); this.tlpTitle.Location = new System.Drawing.Point(0, 0); this.tlpTitle.Margin = new System.Windows.Forms.Padding(0); this.tlpTitle.Name = "tlpTitle"; this.tlpTitle.RowCount = 2; this.tlpTitle.RowStyles.Add(new System.Windows.Forms.RowStyle()); this.tlpTitle.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 44F)); this.tlpTitle.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 44F)); this.tlpTitle.Size = new System.Drawing.Size(404, 44); this.tlpTitle.TabIndex = 45; // // label1 // this.label1.AppearanceName = "Title"; this.label1.AutoSize = true; this.label1.ControlID = ""; this.label1.Dock = System.Windows.Forms.DockStyle.Top; this.label1.Font = new System.Drawing.Font("Tahoma", 24F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point, ((byte)(222))); this.label1.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(192))))); this.label1.Location = new System.Drawing.Point(3, 0); this.label1.Name = "label1"; this.label1.PathString = null; this.label1.PathValue = "NG Inquiry"; this.label1.Size = new System.Drawing.Size(398, 39); this.label1.TabIndex = 35; this.label1.Text = "NG Inquiry"; // // lblItemCode // this.lblItemCode.AppearanceName = ""; this.lblItemCode.ControlID = ""; this.lblItemCode.Location = new System.Drawing.Point(6, 58); this.lblItemCode.Name = "lblItemCode"; this.lblItemCode.PathString = null; this.lblItemCode.PathValue = "Part From:"; this.lblItemCode.Size = new System.Drawing.Size(117, 35); this.lblItemCode.TabIndex = 100010; this.lblItemCode.Text = "Part From:"; this.lblItemCode.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // txtItemDesc // this.txtItemDesc.AppearanceName = ""; this.txtItemDesc.AppearanceReadOnlyName = ""; this.txtItemDesc.ControlID = ""; this.txtItemDesc.DisableRestrictChar = false; this.txtItemDesc.Enabled = false; this.txtItemDesc.HelpButton = null; this.txtItemDesc.Location = new System.Drawing.Point(385, 63); this.txtItemDesc.MaxLength = 50; this.txtItemDesc.Name = "txtItemDesc"; this.txtItemDesc.PathString = "ItemDesc.Value"; this.txtItemDesc.PathValue = ""; this.txtItemDesc.Size = new System.Drawing.Size(20, 27); this.txtItemDesc.TabIndex = 100013; this.txtItemDesc.Visible = false; // // btnItemCode // this.btnItemCode.AppearanceName = ""; this.btnItemCode.AutoSize = true; this.btnItemCode.BackgroundImage = global::Rubik.Forms.Properties.Resources.VIEW; this.btnItemCode.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch; this.btnItemCode.ControlID = null; this.btnItemCode.Location = new System.Drawing.Point(345, 61); this.btnItemCode.Name = "btnItemCode"; this.btnItemCode.Size = new System.Drawing.Size(34, 29); this.btnItemCode.TabIndex = 100012; this.btnItemCode.TabStop = false; this.btnItemCode.UseVisualStyleBackColor = true; // // txtItemFrom // this.txtItemFrom.AllowNegative = true; this.txtItemFrom.AppearanceName = ""; this.txtItemFrom.AppearanceReadOnlyName = ""; this.txtItemFrom.CharacterCasing = System.Windows.Forms.CharacterCasing.Upper; this.txtItemFrom.CheckEmpty = true; this.txtItemFrom.CheckExist = false; this.txtItemFrom.CheckNotExist = true; this.txtItemFrom.ControlID = ""; this.txtItemFrom.CustomerCode = null; this.txtItemFrom.CustomerNameTextBox = null; this.txtItemFrom.Decimal = new decimal(new int[] { 0, 0, 0, 0 }); this.txtItemFrom.DecimalPoint = '.'; this.txtItemFrom.DescriptionTextBox = this.txtItemDesc; this.txtItemFrom.DigitsInGroup = 0; this.txtItemFrom.Double = 0D; this.txtItemFrom.FixDecimalPosition = true; this.txtItemFrom.Flags = 0; this.txtItemFrom.GroupSeparator = ','; this.txtItemFrom.HelpButton = this.btnItemCode; this.txtItemFrom.Int = 0; this.txtItemFrom.ItemType = null; this.txtItemFrom.Location = new System.Drawing.Point(129, 62); this.txtItemFrom.Long = ((long)(0)); this.txtItemFrom.MaxDecimalPlaces = 0; this.txtItemFrom.MaxLength = 50; this.txtItemFrom.MaxWholeDigits = 10; this.txtItemFrom.Name = "txtItemFrom"; this.txtItemFrom.NegativeSign = '-'; this.txtItemFrom.PathString = "ItemCode.Value"; this.txtItemFrom.PathValue = ""; this.txtItemFrom.Prefix = ""; this.txtItemFrom.RangeMax = 9999999999D; this.txtItemFrom.RangeMin = 0D; this.txtItemFrom.SelectedCustomerData = null; this.txtItemFrom.SelectedItemData = null; this.txtItemFrom.SelectedItemProcessData = null; this.txtItemFrom.Size = new System.Drawing.Size(210, 27); this.txtItemFrom.SqlOperator = Rubik.eSqlOperator.In; this.txtItemFrom.TabIndex = 100011; this.txtItemFrom.TextAlign = System.Windows.Forms.HorizontalAlignment.Right; // // evoTextBox1 // this.evoTextBox1.AppearanceName = ""; this.evoTextBox1.AppearanceReadOnlyName = ""; this.evoTextBox1.ControlID = ""; this.evoTextBox1.DisableRestrictChar = false; this.evoTextBox1.Enabled = false; this.evoTextBox1.HelpButton = null; this.evoTextBox1.Location = new System.Drawing.Point(385, 97); this.evoTextBox1.MaxLength = 50; this.evoTextBox1.Name = "evoTextBox1"; this.evoTextBox1.PathString = "ItemDesc.Value"; this.evoTextBox1.PathValue = ""; this.evoTextBox1.Size = new System.Drawing.Size(20, 27); this.evoTextBox1.TabIndex = 100017; this.evoTextBox1.Visible = false; // // evoButton1 // this.evoButton1.AppearanceName = ""; this.evoButton1.AutoSize = true; this.evoButton1.BackgroundImage = global::Rubik.Forms.Properties.Resources.VIEW; this.evoButton1.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch; this.evoButton1.ControlID = null; this.evoButton1.Location = new System.Drawing.Point(345, 96); this.evoButton1.Name = "evoButton1"; this.evoButton1.Size = new System.Drawing.Size(34, 29); this.evoButton1.TabIndex = 100016; this.evoButton1.TabStop = false; this.evoButton1.UseVisualStyleBackColor = true; // // txtItemTo // this.txtItemTo.AllowNegative = true; this.txtItemTo.AppearanceName = ""; this.txtItemTo.AppearanceReadOnlyName = ""; this.txtItemTo.CharacterCasing = System.Windows.Forms.CharacterCasing.Upper; this.txtItemTo.CheckEmpty = true; this.txtItemTo.CheckExist = false; this.txtItemTo.CheckNotExist = true; this.txtItemTo.ControlID = ""; this.txtItemTo.CustomerCode = null; this.txtItemTo.CustomerNameTextBox = null; this.txtItemTo.Decimal = new decimal(new int[] { 0, 0, 0, 0 }); this.txtItemTo.DecimalPoint = '.'; this.txtItemTo.DescriptionTextBox = this.evoTextBox1; this.txtItemTo.DigitsInGroup = 0; this.txtItemTo.Double = 0D; this.txtItemTo.FixDecimalPosition = true; this.txtItemTo.Flags = 0; this.txtItemTo.GroupSeparator = ','; this.txtItemTo.HelpButton = this.evoButton1; this.txtItemTo.Int = 0; this.txtItemTo.ItemType = null; this.txtItemTo.Location = new System.Drawing.Point(129, 97); this.txtItemTo.Long = ((long)(0)); this.txtItemTo.MaxDecimalPlaces = 0; this.txtItemTo.MaxLength = 50; this.txtItemTo.MaxWholeDigits = 10; this.txtItemTo.Name = "txtItemTo"; this.txtItemTo.NegativeSign = '-'; this.txtItemTo.PathString = "ItemCode.Value"; this.txtItemTo.PathValue = ""; this.txtItemTo.Prefix = ""; this.txtItemTo.RangeMax = 9999999999D; this.txtItemTo.RangeMin = 0D; this.txtItemTo.SelectedCustomerData = null; this.txtItemTo.SelectedItemData = null; this.txtItemTo.SelectedItemProcessData = null; this.txtItemTo.Size = new System.Drawing.Size(210, 27); this.txtItemTo.SqlOperator = Rubik.eSqlOperator.In; this.txtItemTo.TabIndex = 100015; this.txtItemTo.TextAlign = System.Windows.Forms.HorizontalAlignment.Right; // // evoLabel1 // this.evoLabel1.AppearanceName = ""; this.evoLabel1.ControlID = ""; this.evoLabel1.Location = new System.Drawing.Point(6, 92); this.evoLabel1.Name = "evoLabel1"; this.evoLabel1.PathString = null; this.evoLabel1.PathValue = "Part To:"; this.evoLabel1.Size = new System.Drawing.Size(117, 35); this.evoLabel1.TabIndex = 100014; this.evoLabel1.Text = "Part To:"; this.evoLabel1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // lblWorkResultDate // this.lblWorkResultDate.AppearanceName = ""; this.lblWorkResultDate.ControlID = ""; this.lblWorkResultDate.Location = new System.Drawing.Point(424, 59); this.lblWorkResultDate.Name = "lblWorkResultDate"; this.lblWorkResultDate.PathString = null; this.lblWorkResultDate.PathValue = "Date"; this.lblWorkResultDate.Size = new System.Drawing.Size(45, 33); this.lblWorkResultDate.TabIndex = 100019; this.lblWorkResultDate.Text = "Date"; this.lblWorkResultDate.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // groupBox1 // this.groupBox1.Controls.Add(this.rdoGroupItemLotNo); this.groupBox1.Controls.Add(this.rdoGroupItem); this.groupBox1.Location = new System.Drawing.Point(428, 85); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(300, 50); this.groupBox1.TabIndex = 100020; this.groupBox1.TabStop = false; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(626, 66); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(28, 19); this.label2.TabIndex = 100021; this.label2.Text = "To"; // // btlFind // this.btlFind.Location = new System.Drawing.Point(734, 100); this.btlFind.Name = "btlFind"; this.btlFind.Size = new System.Drawing.Size(60, 28); this.btlFind.TabIndex = 100022; this.btlFind.Text = "Find"; this.btlFind.UseVisualStyleBackColor = true; this.btlFind.Click += new System.EventHandler(this.btlFind_Click); // // evoPanel1 // this.evoPanel1.AppearanceName = ""; this.evoPanel1.Controls.Add(this.txtLotNumber); this.evoPanel1.Controls.Add(this.fpView); this.evoPanel1.Controls.Add(this.btlFind); this.evoPanel1.Controls.Add(this.tlpTitle); this.evoPanel1.Controls.Add(this.evoLabel2); this.evoPanel1.Dock = System.Windows.Forms.DockStyle.Fill; this.evoPanel1.Location = new System.Drawing.Point(0, 0); this.evoPanel1.Margin = new System.Windows.Forms.Padding(0); this.evoPanel1.Name = "evoPanel1"; this.evoPanel1.Size = new System.Drawing.Size(879, 517); this.evoPanel1.TabIndex = 100023; // // txtLotNumber // this.txtLotNumber.AppearanceName = ""; this.txtLotNumber.AppearanceReadOnlyName = ""; this.txtLotNumber.ControlID = ""; this.txtLotNumber.DisableRestrictChar = false; this.txtLotNumber.HelpButton = null; this.txtLotNumber.Location = new System.Drawing.Point(129, 131); this.txtLotNumber.MaxLength = 20; this.txtLotNumber.Name = "txtLotNumber"; this.txtLotNumber.PathString = "LotNo.Value"; this.txtLotNumber.PathValue = ""; this.txtLotNumber.Size = new System.Drawing.Size(210, 27); this.txtLotNumber.TabIndex = 100023; // // fpView // this.fpView.About = "2.5.2015.2005"; this.fpView.AccessibleDescription = "fpView, Sheet1"; this.fpView.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.fpView.BackColor = System.Drawing.Color.AliceBlue; this.fpView.ColumnSplitBoxPolicy = FarPoint.Win.Spread.SplitBoxPolicy.AsNeeded; this.fpView.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpView.Location = new System.Drawing.Point(0, 169); this.fpView.Name = "fpView"; this.fpView.RightToLeft = System.Windows.Forms.RightToLeft.No; this.fpView.RowSplitBoxPolicy = FarPoint.Win.Spread.SplitBoxPolicy.AsNeeded; this.fpView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Both; this.fpView.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.shtView }); this.fpView.Size = new System.Drawing.Size(879, 350); this.fpView.TabIndex = 100018; this.fpView.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpView.KeyDown += new System.Windows.Forms.KeyEventHandler(this.fpView_KeyDown); // // shtView // this.shtView.Reset(); this.shtView.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.shtView.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.shtView.ColumnCount = 11; this.shtView.RowCount = 0; this.shtView.AutoGenerateColumns = false; this.shtView.ColumnHeader.Cells.Get(0, 0).Value = "Part Code"; this.shtView.ColumnHeader.Cells.Get(0, 1).Value = "Part Desc "; this.shtView.ColumnHeader.Cells.Get(0, 2).Value = "Short Name"; this.shtView.ColumnHeader.Cells.Get(0, 3).Value = "Lot No."; this.shtView.ColumnHeader.Cells.Get(0, 4).Value = "Tran Date"; this.shtView.ColumnHeader.Cells.Get(0, 5).Value = "Shift"; this.shtView.ColumnHeader.Cells.Get(0, 6).Value = "NG Qty"; this.shtView.ColumnHeader.Cells.Get(0, 7).Value = "NG Reason"; this.shtView.ColumnHeader.Cells.Get(0, 8).Value = "WO No."; this.shtView.ColumnHeader.Cells.Get(0, 9).Value = "Remark"; this.shtView.ColumnHeader.Cells.Get(0, 10).Value = "Work Result Type"; this.shtView.ColumnHeader.Rows.Get(0).Height = 40F; this.shtView.Columns.Get(0).AllowAutoFilter = true; this.shtView.Columns.Get(0).AllowAutoSort = true; this.shtView.Columns.Get(0).CellType = textCellType1; this.shtView.Columns.Get(0).Label = "Part Code"; this.shtView.Columns.Get(0).Locked = true; this.shtView.Columns.Get(0).Tag = "Part Code"; this.shtView.Columns.Get(0).Width = 160F; this.shtView.Columns.Get(1).AllowAutoFilter = true; this.shtView.Columns.Get(1).AllowAutoSort = true; this.shtView.Columns.Get(1).CellType = textCellType2; this.shtView.Columns.Get(1).Label = "Part Desc "; this.shtView.Columns.Get(1).Locked = true; this.shtView.Columns.Get(1).Tag = "Part Description"; this.shtView.Columns.Get(1).Width = 180F; this.shtView.Columns.Get(2).AllowAutoFilter = true; this.shtView.Columns.Get(2).AllowAutoSort = true; this.shtView.Columns.Get(2).CellType = textCellType3; this.shtView.Columns.Get(2).Label = "Short Name"; this.shtView.Columns.Get(2).Locked = true; this.shtView.Columns.Get(2).Tag = "Short Name"; this.shtView.Columns.Get(2).Width = 140F; this.shtView.Columns.Get(3).AllowAutoSort = true; this.shtView.Columns.Get(3).CellType = textCellType4; this.shtView.Columns.Get(3).Label = "Lot No."; this.shtView.Columns.Get(3).Locked = true; this.shtView.Columns.Get(3).Tag = "Lot No."; this.shtView.Columns.Get(3).Width = 108F; this.shtView.Columns.Get(4).AllowAutoFilter = true; this.shtView.Columns.Get(4).AllowAutoSort = true; dateTimeCellType1.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType1.Calendar"))); dateTimeCellType1.DateDefault = new System.DateTime(2011, 5, 13, 16, 12, 12, 0); dateTimeCellType1.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined; dateTimeCellType1.TimeDefault = new System.DateTime(2011, 5, 13, 16, 12, 12, 0); dateTimeCellType1.TwoDigitYearMax = 2029; dateTimeCellType1.UserDefinedFormat = "dd/MM/yyyy"; this.shtView.Columns.Get(4).CellType = dateTimeCellType1; this.shtView.Columns.Get(4).Label = "Tran Date"; this.shtView.Columns.Get(4).Locked = true; this.shtView.Columns.Get(4).Tag = "Tran Date"; this.shtView.Columns.Get(4).Width = 116F; this.shtView.Columns.Get(5).AllowAutoFilter = true; this.shtView.Columns.Get(5).AllowAutoSort = true; this.shtView.Columns.Get(5).CellType = textCellType5; this.shtView.Columns.Get(5).Label = "Shift"; this.shtView.Columns.Get(5).Locked = true; this.shtView.Columns.Get(5).Tag = "Shift"; this.shtView.Columns.Get(5).Width = 80F; this.shtView.Columns.Get(6).AllowAutoFilter = true; this.shtView.Columns.Get(6).AllowAutoSort = true; numberCellType1.DecimalPlaces = 6; numberCellType1.DecimalSeparator = "."; numberCellType1.FixedPoint = false; this.shtView.Columns.Get(6).CellType = numberCellType1; this.shtView.Columns.Get(6).Label = "NG Qty"; this.shtView.Columns.Get(6).Locked = true; this.shtView.Columns.Get(6).Tag = "NG Qty"; this.shtView.Columns.Get(6).Width = 100F; this.shtView.Columns.Get(7).AllowAutoFilter = true; this.shtView.Columns.Get(7).AllowAutoSort = true; this.shtView.Columns.Get(7).CellType = textCellType6; this.shtView.Columns.Get(7).Label = "NG Reason"; this.shtView.Columns.Get(7).Locked = true; this.shtView.Columns.Get(7).Tag = "NG Reason"; this.shtView.Columns.Get(7).Width = 130F; this.shtView.Columns.Get(8).AllowAutoFilter = true; this.shtView.Columns.Get(8).AllowAutoSort = true; this.shtView.Columns.Get(8).CellType = textCellType7; this.shtView.Columns.Get(8).Label = "WO No."; this.shtView.Columns.Get(8).Locked = true; this.shtView.Columns.Get(8).Tag = "WO No."; this.shtView.Columns.Get(8).Width = 101F; this.shtView.Columns.Get(9).AllowAutoFilter = true; this.shtView.Columns.Get(9).AllowAutoSort = true; this.shtView.Columns.Get(9).CellType = textCellType8; this.shtView.Columns.Get(9).Label = "Remark"; this.shtView.Columns.Get(9).Locked = true; this.shtView.Columns.Get(9).Tag = "Remark"; this.shtView.Columns.Get(9).Width = 105F; this.shtView.Columns.Get(10).AllowAutoFilter = true; this.shtView.Columns.Get(10).AllowAutoSort = true; this.shtView.Columns.Get(10).CellType = textCellType9; this.shtView.Columns.Get(10).Label = "Work Result Type"; this.shtView.Columns.Get(10).Locked = true; this.shtView.Columns.Get(10).Tag = "Work Result Type"; this.shtView.Columns.Get(10).Width = 162F; this.shtView.DataAutoCellTypes = false; this.shtView.DataAutoHeadings = false; this.shtView.DataAutoSizeColumns = false; this.shtView.RowHeader.Columns.Default.Resizable = true; this.shtView.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single; this.shtView.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Row; this.shtView.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; this.fpView.SetActiveViewport(0, 1, 0); // // evoLabel2 // this.evoLabel2.AppearanceName = ""; this.evoLabel2.ControlID = ""; this.evoLabel2.Location = new System.Drawing.Point(6, 126); this.evoLabel2.Name = "evoLabel2"; this.evoLabel2.PathString = null; this.evoLabel2.PathValue = "Lot No:"; this.evoLabel2.Size = new System.Drawing.Size(114, 35); this.evoLabel2.TabIndex = 100017; this.evoLabel2.Text = "Lot No:"; this.evoLabel2.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // TRN150_NGInquiry // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.ClientSize = new System.Drawing.Size(879, 575); this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); this.Name = "TRN150_NGInquiry"; this.Text = "TRN150: NG Inquiry"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.TRN150_NGInquiry_Load); this.pnlContainer.ResumeLayout(false); this.pnlContainer.PerformLayout(); this.tlpTitle.ResumeLayout(false); this.tlpTitle.PerformLayout(); this.groupBox1.ResumeLayout(false); this.evoPanel1.ResumeLayout(false); this.evoPanel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpView)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.shtView)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { FarPoint.Win.Spread.TipAppearance tipAppearance1 = new FarPoint.Win.Spread.TipAppearance(); FarPoint.Win.Spread.CellType.CheckBoxCellType checkBoxCellType1 = new FarPoint.Win.Spread.CellType.CheckBoxCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType1 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType2 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType3 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType1 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ucCompoundBack)); FarPoint.Win.Spread.CellType.TextCellType textCellType1 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType2 = new FarPoint.Win.Spread.CellType.TextCellType(); this.neuGroupBox1 = new Neusoft.FrameWork.WinForms.Controls.NeuGroupBox(); this.lbPatient = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.txtCompoundGroup = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox(); this.neuLabel1 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.fpApply = new Neusoft.FrameWork.WinForms.Controls.NeuSpread(); this.fpApply_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.neuGroupBox1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpApply)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpApply_Sheet1)).BeginInit(); this.SuspendLayout(); // // neuGroupBox1 // this.neuGroupBox1.Controls.Add(this.lbPatient); this.neuGroupBox1.Controls.Add(this.txtCompoundGroup); this.neuGroupBox1.Controls.Add(this.neuLabel1); this.neuGroupBox1.Dock = System.Windows.Forms.DockStyle.Top; this.neuGroupBox1.Location = new System.Drawing.Point(0, 0); this.neuGroupBox1.Name = "neuGroupBox1"; this.neuGroupBox1.Size = new System.Drawing.Size(730, 38); this.neuGroupBox1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuGroupBox1.TabIndex = 0; this.neuGroupBox1.TabStop = false; // // lbPatient // this.lbPatient.AutoSize = true; this.lbPatient.ForeColor = System.Drawing.Color.Blue; this.lbPatient.Location = new System.Drawing.Point(217, 16); this.lbPatient.Name = "lbPatient"; this.lbPatient.Size = new System.Drawing.Size(53, 12); this.lbPatient.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lbPatient.TabIndex = 2; this.lbPatient.Text = "患者信息"; // // txtCompoundGroup // this.txtCompoundGroup.Location = new System.Drawing.Point(81, 13); this.txtCompoundGroup.Name = "txtCompoundGroup"; this.txtCompoundGroup.Size = new System.Drawing.Size(130, 21); this.txtCompoundGroup.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.txtCompoundGroup.TabIndex = 1; this.txtCompoundGroup.KeyDown += new System.Windows.Forms.KeyEventHandler(this.txtCompoundGroup_KeyDown); // // neuLabel1 // this.neuLabel1.AutoSize = true; this.neuLabel1.ForeColor = System.Drawing.Color.Blue; this.neuLabel1.Location = new System.Drawing.Point(6, 16); this.neuLabel1.Name = "neuLabel1"; this.neuLabel1.Size = new System.Drawing.Size(71, 12); this.neuLabel1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuLabel1.TabIndex = 0; this.neuLabel1.Text = "批次流水号:"; // // fpApply // this.fpApply.About = "2.5.2007.2005"; this.fpApply.AccessibleDescription = "fpApply, Sheet1, Row 0, Column 0, "; this.fpApply.BackColor = System.Drawing.Color.White; this.fpApply.Dock = System.Windows.Forms.DockStyle.Fill; this.fpApply.FileName = ""; this.fpApply.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpApply.IsAutoSaveGridStatus = false; this.fpApply.IsCanCustomConfigColumn = false; this.fpApply.Location = new System.Drawing.Point(0, 38); this.fpApply.Name = "fpApply"; this.fpApply.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.fpApply_Sheet1 }); this.fpApply.Size = new System.Drawing.Size(730, 368); this.fpApply.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.fpApply.TabIndex = 1; tipAppearance1.BackColor = System.Drawing.SystemColors.Info; tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText; this.fpApply.TextTipAppearance = tipAppearance1; this.fpApply.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; // // fpApply_Sheet1 // this.fpApply_Sheet1.Reset(); this.fpApply_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.fpApply_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpApply_Sheet1.ColumnCount = 14; this.fpApply_Sheet1.RowCount = 0; this.fpApply_Sheet1.ActiveSkin = new FarPoint.Win.Spread.SheetSkin("CustomSkin1", System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.LightGray, FarPoint.Win.Spread.GridLines.Both, System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, false, false, false, true, true); this.fpApply_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "[床号]姓名"; this.fpApply_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "选中"; this.fpApply_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "药品[规格]"; this.fpApply_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "零售价"; this.fpApply_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "用量"; this.fpApply_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "单位"; this.fpApply_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "总量"; this.fpApply_Sheet1.ColumnHeader.Cells.Get(0, 7).Value = "单位"; this.fpApply_Sheet1.ColumnHeader.Cells.Get(0, 8).Value = "频次"; this.fpApply_Sheet1.ColumnHeader.Cells.Get(0, 9).Value = "用法"; this.fpApply_Sheet1.ColumnHeader.Cells.Get(0, 10).Value = "用药时间"; this.fpApply_Sheet1.ColumnHeader.Cells.Get(0, 11).Value = "开方医生"; this.fpApply_Sheet1.ColumnHeader.Cells.Get(0, 12).Value = "申请时间"; this.fpApply_Sheet1.ColumnHeader.Cells.Get(0, 13).Value = "批次号"; this.fpApply_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.fpApply_Sheet1.ColumnHeader.DefaultStyle.Locked = false; this.fpApply_Sheet1.ColumnHeader.DefaultStyle.Parent = "HeaderDefault"; this.fpApply_Sheet1.Columns.Get(0).Label = "[床号]姓名"; this.fpApply_Sheet1.Columns.Get(0).MergePolicy = FarPoint.Win.Spread.Model.MergePolicy.Always; this.fpApply_Sheet1.Columns.Get(0).Width = 78F; this.fpApply_Sheet1.Columns.Get(1).BackColor = System.Drawing.Color.SeaShell; this.fpApply_Sheet1.Columns.Get(1).CellType = checkBoxCellType1; this.fpApply_Sheet1.Columns.Get(1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpApply_Sheet1.Columns.Get(1).Label = "选中"; this.fpApply_Sheet1.Columns.Get(1).Locked = false; this.fpApply_Sheet1.Columns.Get(1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpApply_Sheet1.Columns.Get(1).Width = 38F; this.fpApply_Sheet1.Columns.Get(2).Label = "药品[规格]"; this.fpApply_Sheet1.Columns.Get(2).Width = 140F; this.fpApply_Sheet1.Columns.Get(3).CellType = numberCellType1; this.fpApply_Sheet1.Columns.Get(3).Label = "零售价"; this.fpApply_Sheet1.Columns.Get(4).CellType = numberCellType2; this.fpApply_Sheet1.Columns.Get(4).Label = "用量"; this.fpApply_Sheet1.Columns.Get(5).Label = "单位"; this.fpApply_Sheet1.Columns.Get(5).Width = 40F; this.fpApply_Sheet1.Columns.Get(6).CellType = numberCellType3; this.fpApply_Sheet1.Columns.Get(6).Label = "总量"; this.fpApply_Sheet1.Columns.Get(7).Label = "单位"; this.fpApply_Sheet1.Columns.Get(7).Width = 40F; this.fpApply_Sheet1.Columns.Get(8).Label = "频次"; this.fpApply_Sheet1.Columns.Get(8).Width = 46F; this.fpApply_Sheet1.Columns.Get(9).Label = "用法"; this.fpApply_Sheet1.Columns.Get(9).Width = 50F; dateTimeCellType1.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType1.Calendar"))); dateTimeCellType1.DateDefault = new System.DateTime(2007, 8, 21, 10, 9, 47, 0); dateTimeCellType1.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime; dateTimeCellType1.TimeDefault = new System.DateTime(2007, 8, 21, 10, 9, 47, 0); this.fpApply_Sheet1.Columns.Get(10).CellType = dateTimeCellType1; this.fpApply_Sheet1.Columns.Get(10).Label = "用药时间"; this.fpApply_Sheet1.Columns.Get(10).Width = 113F; this.fpApply_Sheet1.Columns.Get(11).CellType = textCellType1; this.fpApply_Sheet1.Columns.Get(11).Label = "开方医生"; this.fpApply_Sheet1.Columns.Get(11).Width = 70F; this.fpApply_Sheet1.Columns.Get(12).Label = "申请时间"; this.fpApply_Sheet1.Columns.Get(12).Width = 104F; this.fpApply_Sheet1.Columns.Get(13).CellType = textCellType2; this.fpApply_Sheet1.Columns.Get(13).Label = "批次号"; this.fpApply_Sheet1.Columns.Get(13).Width = 103F; this.fpApply_Sheet1.DefaultStyle.Locked = true; this.fpApply_Sheet1.DefaultStyle.Parent = "DataAreaDefault"; this.fpApply_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode; this.fpApply_Sheet1.RowHeader.Columns.Default.Resizable = false; this.fpApply_Sheet1.RowHeader.Columns.Get(0).Width = 37F; this.fpApply_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.fpApply_Sheet1.RowHeader.DefaultStyle.Locked = false; this.fpApply_Sheet1.RowHeader.DefaultStyle.Parent = "HeaderDefault"; this.fpApply_Sheet1.SheetCornerStyle.BackColor = System.Drawing.Color.White; this.fpApply_Sheet1.SheetCornerStyle.Locked = false; this.fpApply_Sheet1.SheetCornerStyle.Parent = "HeaderDefault"; this.fpApply_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; this.fpApply.SetActiveViewport(1, 0); // // ucCompoundBack // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.BackColor = System.Drawing.Color.White; this.Controls.Add(this.fpApply); this.Controls.Add(this.neuGroupBox1); this.Name = "ucCompoundBack"; this.Size = new System.Drawing.Size(730, 406); this.neuGroupBox1.ResumeLayout(false); this.neuGroupBox1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpApply)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpApply_Sheet1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { FarPoint.Win.Spread.TipAppearance tipAppearance1 = new FarPoint.Win.Spread.TipAppearance(); FarPoint.Win.Spread.CellType.CheckBoxCellType checkBoxCellType1 = new FarPoint.Win.Spread.CellType.CheckBoxCellType(); FarPoint.Win.Spread.CellType.CheckBoxCellType checkBoxCellType2 = new FarPoint.Win.Spread.CellType.CheckBoxCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType1 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType1 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ucClinicDiagnoseInput)); FarPoint.Win.Spread.CellType.TextCellType textCellType2 = new FarPoint.Win.Spread.CellType.TextCellType(); this.neuPanel1 = new Neusoft.FrameWork.WinForms.Controls.NeuPanel(); this.neuSpread1 = new Neusoft.FrameWork.WinForms.Controls.NeuSpread(); this.neuSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.neuPanel2 = new Neusoft.FrameWork.WinForms.Controls.NeuPanel(); this.ucDiagnose1 = new Neusoft.HISFC.Components.Common.Controls.ucDiagnose(); this.neuPanel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1_Sheet1)).BeginInit(); this.SuspendLayout(); // // neuPanel1 // this.neuPanel1.Controls.Add(this.neuSpread1); this.neuPanel1.Dock = System.Windows.Forms.DockStyle.Fill; this.neuPanel1.Location = new System.Drawing.Point(0, 0); this.neuPanel1.Name = "neuPanel1"; this.neuPanel1.Size = new System.Drawing.Size(683, 133); this.neuPanel1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuPanel1.TabIndex = 0; // // neuSpread1 // this.neuSpread1.About = "2.5.2007.2005"; this.neuSpread1.AccessibleDescription = "neuSpread1, Sheet1, Row 0, Column 0, "; this.neuSpread1.AllowDragFill = true; this.neuSpread1.BackColor = System.Drawing.Color.Azure; this.neuSpread1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.neuSpread1.Dock = System.Windows.Forms.DockStyle.Fill; this.neuSpread1.EditModePermanent = true; this.neuSpread1.EditModeReplace = true; this.neuSpread1.FileName = ""; this.neuSpread1.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never; this.neuSpread1.IsAutoSaveGridStatus = false; this.neuSpread1.IsCanCustomConfigColumn = false; this.neuSpread1.Location = new System.Drawing.Point(0, 0); this.neuSpread1.Name = "neuSpread1"; this.neuSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.neuSpread1_Sheet1 }); this.neuSpread1.Size = new System.Drawing.Size(683, 133); this.neuSpread1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuSpread1.TabIndex = 0; tipAppearance1.BackColor = System.Drawing.SystemColors.Info; tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText; this.neuSpread1.TextTipAppearance = tipAppearance1; this.neuSpread1.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; // // neuSpread1_Sheet1 // this.neuSpread1_Sheet1.Reset(); this.neuSpread1_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.neuSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.neuSpread1_Sheet1.ColumnCount = 8; this.neuSpread1_Sheet1.ActiveSkin = new FarPoint.Win.Spread.SheetSkin("CustomSkin1", System.Drawing.SystemColors.Control, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.LightGray, FarPoint.Win.Spread.GridLines.Both, System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, false, false, true, true, true); this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "诊断类别"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "是否主诊断"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "描述"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "ICD10"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "诊断名称"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "诊断日期"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "诊断医师代码"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 7).Value = "诊断医师"; this.neuSpread1_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.neuSpread1_Sheet1.ColumnHeader.DefaultStyle.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold); this.neuSpread1_Sheet1.ColumnHeader.DefaultStyle.Locked = false; this.neuSpread1_Sheet1.ColumnHeader.DefaultStyle.Parent = "HeaderDefault"; this.neuSpread1_Sheet1.ColumnHeader.Rows.Get(0).Height = 26F; this.neuSpread1_Sheet1.Columns.Get(0).Label = "诊断类别"; this.neuSpread1_Sheet1.Columns.Get(0).Width = 69F; this.neuSpread1_Sheet1.Columns.Get(1).CellType = checkBoxCellType1; this.neuSpread1_Sheet1.Columns.Get(1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.neuSpread1_Sheet1.Columns.Get(1).Label = "是否主诊断"; this.neuSpread1_Sheet1.Columns.Get(1).Width = 49F; this.neuSpread1_Sheet1.Columns.Get(2).CellType = checkBoxCellType2; this.neuSpread1_Sheet1.Columns.Get(2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.neuSpread1_Sheet1.Columns.Get(2).Label = "描述"; this.neuSpread1_Sheet1.Columns.Get(2).Width = 49F; this.neuSpread1_Sheet1.Columns.Get(3).CellType = textCellType1; this.neuSpread1_Sheet1.Columns.Get(3).Label = "ICD10"; this.neuSpread1_Sheet1.Columns.Get(3).Width = 48F; this.neuSpread1_Sheet1.Columns.Get(4).Label = "诊断名称"; this.neuSpread1_Sheet1.Columns.Get(4).Width = 220F; dateTimeCellType1.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType1.Calendar"))); dateTimeCellType1.DateDefault = new System.DateTime(2007, 6, 13, 14, 53, 0, 0); dateTimeCellType1.TimeDefault = new System.DateTime(2007, 6, 13, 14, 53, 0, 0); this.neuSpread1_Sheet1.Columns.Get(5).CellType = dateTimeCellType1; this.neuSpread1_Sheet1.Columns.Get(5).Label = "诊断日期"; this.neuSpread1_Sheet1.Columns.Get(5).Width = 94F; this.neuSpread1_Sheet1.Columns.Get(6).Label = "诊断医师代码"; this.neuSpread1_Sheet1.Columns.Get(6).Visible = false; this.neuSpread1_Sheet1.Columns.Get(6).Width = 49F; this.neuSpread1_Sheet1.Columns.Get(7).CellType = textCellType2; this.neuSpread1_Sheet1.Columns.Get(7).Label = "诊断医师"; this.neuSpread1_Sheet1.Columns.Get(7).Width = 94F; this.neuSpread1_Sheet1.RowHeader.Columns.Default.Resizable = false; this.neuSpread1_Sheet1.RowHeader.Columns.Get(0).Width = 40F; this.neuSpread1_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.neuSpread1_Sheet1.RowHeader.DefaultStyle.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold); this.neuSpread1_Sheet1.RowHeader.DefaultStyle.Locked = false; this.neuSpread1_Sheet1.RowHeader.DefaultStyle.Parent = "HeaderDefault"; this.neuSpread1_Sheet1.Rows.Get(0).Height = 21F; this.neuSpread1_Sheet1.SheetCornerStyle.BackColor = System.Drawing.Color.White; this.neuSpread1_Sheet1.SheetCornerStyle.Locked = false; this.neuSpread1_Sheet1.SheetCornerStyle.Parent = "HeaderDefault"; this.neuSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; // // neuPanel2 // this.neuPanel2.Dock = System.Windows.Forms.DockStyle.Bottom; this.neuPanel2.Location = new System.Drawing.Point(0, 133); this.neuPanel2.Name = "neuPanel2"; this.neuPanel2.Size = new System.Drawing.Size(683, 46); this.neuPanel2.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuPanel2.TabIndex = 1; // // ucDiagnose1 // this.ucDiagnose1.BackColor = System.Drawing.SystemColors.ControlDark; this.ucDiagnose1.Location = new System.Drawing.Point(256, 49); this.ucDiagnose1.Name = "ucDiagnose1"; this.ucDiagnose1.Size = new System.Drawing.Size(341, 127); this.ucDiagnose1.TabIndex = 1; // // ucClinicDiagnoseInput // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.Controls.Add(this.ucDiagnose1); this.Controls.Add(this.neuPanel1); this.Controls.Add(this.neuPanel2); this.Name = "ucClinicDiagnoseInput"; this.Size = new System.Drawing.Size(683, 179); this.neuPanel1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1_Sheet1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// 디자이너 지원에 필요한 메서드입니다. /// 이 메서드의 내용을 코드 편집기로 수정하지 마세요. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); FarPoint.Win.Spread.EnhancedFocusIndicatorRenderer enhancedFocusIndicatorRenderer1 = new FarPoint.Win.Spread.EnhancedFocusIndicatorRenderer(); FarPoint.Win.Spread.EnhancedScrollBarRenderer enhancedScrollBarRenderer1 = new FarPoint.Win.Spread.EnhancedScrollBarRenderer(); FarPoint.Win.Spread.EnhancedScrollBarRenderer enhancedScrollBarRenderer2 = new FarPoint.Win.Spread.EnhancedScrollBarRenderer(); FarPoint.Win.Spread.CellType.TextCellType textCellType1 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType2 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType3 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType4 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType5 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType1 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(설비등록Control)); FarPoint.Win.Spread.CellType.NumberCellType numberCellType1 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType6 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType7 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType8 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType9 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType10 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType11 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType2 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType3 = new FarPoint.Win.Spread.CellType.NumberCellType(); this.serialPort1 = new System.IO.Ports.SerialPort(this.components); this.panel1 = new System.Windows.Forms.Panel(); this.label1 = new System.Windows.Forms.Label(); this.buttonExit = new System.Windows.Forms.Button(); this.buttonPrint = new System.Windows.Forms.Button(); this.buttonExcel = new System.Windows.Forms.Button(); this.buttonDelete = new System.Windows.Forms.Button(); this.buttonSave = new System.Windows.Forms.Button(); this.buttonAdd = new System.Windows.Forms.Button(); this.button이력카드등록 = new System.Windows.Forms.Button(); this.button이력카드인쇄 = new System.Windows.Forms.Button(); this.folderBrowserDialog1 = new System.Windows.Forms.FolderBrowserDialog(); this.fpSpread설비등록 = new FarPoint.Win.Spread.FpSpread(); this.fpSpread설비등록_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.설비BindingSource = new System.Windows.Forms.BindingSource(this.components); this.설비등록DS = new Erp.YulChonMold.설비.설비등록DS(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread설비등록)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread설비등록_Sheet1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.설비BindingSource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.설비등록DS)).BeginInit(); this.SuspendLayout(); // // panel1 // this.panel1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(88)))), ((int)(((byte)(89)))), ((int)(((byte)(106))))); this.panel1.Controls.Add(this.label1); this.panel1.Controls.Add(this.buttonExit); this.panel1.Controls.Add(this.buttonPrint); this.panel1.Controls.Add(this.buttonExcel); this.panel1.Controls.Add(this.buttonDelete); this.panel1.Controls.Add(this.buttonSave); this.panel1.Controls.Add(this.buttonAdd); this.panel1.Controls.Add(this.button이력카드등록); this.panel1.Controls.Add(this.button이력카드인쇄); this.panel1.Dock = System.Windows.Forms.DockStyle.Top; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(985, 58); this.panel1.TabIndex = 0; // // label1 // this.label1.Font = new System.Drawing.Font("맑은 고딕", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129))); this.label1.ForeColor = System.Drawing.SystemColors.Window; this.label1.Location = new System.Drawing.Point(15, 13); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(128, 37); this.label1.TabIndex = 9; this.label1.Text = "설비 등록"; // // buttonExit // this.buttonExit.FlatAppearance.BorderSize = 0; this.buttonExit.FlatStyle = System.Windows.Forms.FlatStyle.Flat; this.buttonExit.Font = new System.Drawing.Font("맑은 고딕", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129))); this.buttonExit.ForeColor = System.Drawing.Color.White; this.buttonExit.Location = new System.Drawing.Point(884, 10); this.buttonExit.Name = "buttonExit"; this.buttonExit.Size = new System.Drawing.Size(85, 42); this.buttonExit.TabIndex = 1; this.buttonExit.Text = "종료"; this.buttonExit.UseVisualStyleBackColor = true; // // buttonPrint // this.buttonPrint.FlatAppearance.BorderSize = 0; this.buttonPrint.FlatStyle = System.Windows.Forms.FlatStyle.Flat; this.buttonPrint.Font = new System.Drawing.Font("맑은 고딕", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129))); this.buttonPrint.ForeColor = System.Drawing.Color.White; this.buttonPrint.Location = new System.Drawing.Point(807, 10); this.buttonPrint.Name = "buttonPrint"; this.buttonPrint.Size = new System.Drawing.Size(85, 42); this.buttonPrint.TabIndex = 2; this.buttonPrint.Text = "인쇄"; this.buttonPrint.UseVisualStyleBackColor = true; // // buttonExcel // this.buttonExcel.FlatAppearance.BorderSize = 0; this.buttonExcel.FlatStyle = System.Windows.Forms.FlatStyle.Flat; this.buttonExcel.Font = new System.Drawing.Font("맑은 고딕", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129))); this.buttonExcel.ForeColor = System.Drawing.Color.White; this.buttonExcel.Location = new System.Drawing.Point(727, 10); this.buttonExcel.Name = "buttonExcel"; this.buttonExcel.Size = new System.Drawing.Size(85, 42); this.buttonExcel.TabIndex = 3; this.buttonExcel.Text = "엑셀"; this.buttonExcel.UseVisualStyleBackColor = true; // // buttonDelete // this.buttonDelete.FlatAppearance.BorderSize = 0; this.buttonDelete.FlatStyle = System.Windows.Forms.FlatStyle.Flat; this.buttonDelete.Font = new System.Drawing.Font("맑은 고딕", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129))); this.buttonDelete.ForeColor = System.Drawing.Color.White; this.buttonDelete.Location = new System.Drawing.Point(649, 10); this.buttonDelete.Name = "buttonDelete"; this.buttonDelete.Size = new System.Drawing.Size(85, 42); this.buttonDelete.TabIndex = 4; this.buttonDelete.Text = "삭제"; this.buttonDelete.UseVisualStyleBackColor = true; this.buttonDelete.Click += new System.EventHandler(this.buttonDelete_Click); // // buttonSave // this.buttonSave.FlatAppearance.BorderSize = 0; this.buttonSave.FlatStyle = System.Windows.Forms.FlatStyle.Flat; this.buttonSave.Font = new System.Drawing.Font("맑은 고딕", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129))); this.buttonSave.ForeColor = System.Drawing.Color.White; this.buttonSave.Location = new System.Drawing.Point(572, 10); this.buttonSave.Name = "buttonSave"; this.buttonSave.Size = new System.Drawing.Size(85, 42); this.buttonSave.TabIndex = 5; this.buttonSave.Text = "저장"; this.buttonSave.UseVisualStyleBackColor = true; this.buttonSave.Click += new System.EventHandler(this.buttonSave_Click); // // buttonAdd // this.buttonAdd.FlatAppearance.BorderSize = 0; this.buttonAdd.FlatStyle = System.Windows.Forms.FlatStyle.Flat; this.buttonAdd.Font = new System.Drawing.Font("맑은 고딕", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129))); this.buttonAdd.ForeColor = System.Drawing.Color.White; this.buttonAdd.Location = new System.Drawing.Point(493, 10); this.buttonAdd.Name = "buttonAdd"; this.buttonAdd.Size = new System.Drawing.Size(85, 42); this.buttonAdd.TabIndex = 6; this.buttonAdd.Text = "추가"; this.buttonAdd.UseVisualStyleBackColor = true; this.buttonAdd.Click += new System.EventHandler(this.buttonAdd_Click); // // button이력카드등록 // this.button이력카드등록.FlatAppearance.BorderSize = 0; this.button이력카드등록.FlatStyle = System.Windows.Forms.FlatStyle.Flat; this.button이력카드등록.Font = new System.Drawing.Font("맑은 고딕", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129))); this.button이력카드등록.ForeColor = System.Drawing.Color.White; this.button이력카드등록.Location = new System.Drawing.Point(237, 10); this.button이력카드등록.Name = "button이력카드등록"; this.button이력카드등록.Size = new System.Drawing.Size(118, 42); this.button이력카드등록.TabIndex = 7; this.button이력카드등록.Text = "이력카드등록"; this.button이력카드등록.UseVisualStyleBackColor = true; this.button이력카드등록.Click += new System.EventHandler(this.button이력카드등록_Click); // // button이력카드인쇄 // this.button이력카드인쇄.FlatAppearance.BorderSize = 0; this.button이력카드인쇄.FlatStyle = System.Windows.Forms.FlatStyle.Flat; this.button이력카드인쇄.Font = new System.Drawing.Font("맑은 고딕", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129))); this.button이력카드인쇄.ForeColor = System.Drawing.Color.White; this.button이력카드인쇄.Location = new System.Drawing.Point(368, 10); this.button이력카드인쇄.Name = "button이력카드인쇄"; this.button이력카드인쇄.Size = new System.Drawing.Size(119, 42); this.button이력카드인쇄.TabIndex = 8; this.button이력카드인쇄.Text = "이력카드인쇄"; this.button이력카드인쇄.UseVisualStyleBackColor = true; this.button이력카드인쇄.Click += new System.EventHandler(this.button이력카드인쇄_Click); // // fpSpread설비등록 // this.fpSpread설비등록.AccessibleDescription = ""; this.fpSpread설비등록.ClipboardOptions = FarPoint.Win.Spread.ClipboardOptions.ColumnHeaders; this.fpSpread설비등록.Dock = System.Windows.Forms.DockStyle.Fill; this.fpSpread설비등록.EditModeReplace = true; this.fpSpread설비등록.FocusRenderer = enhancedFocusIndicatorRenderer1; this.fpSpread설비등록.Font = new System.Drawing.Font("맑은 고딕", 11.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129))); this.fpSpread설비등록.HorizontalScrollBar.Buttons = new FarPoint.Win.Spread.FpScrollBarButtonCollection("BackwardLineButton,ThumbTrack,ForwardLineButton"); this.fpSpread설비등록.HorizontalScrollBar.Name = ""; enhancedScrollBarRenderer1.ArrowColor = System.Drawing.Color.Black; enhancedScrollBarRenderer1.ArrowHoveredColor = System.Drawing.Color.Black; enhancedScrollBarRenderer1.ArrowSelectedColor = System.Drawing.Color.Black; enhancedScrollBarRenderer1.ButtonBackgroundColor = System.Drawing.Color.Silver; enhancedScrollBarRenderer1.ButtonBorderColor = System.Drawing.Color.DarkGray; enhancedScrollBarRenderer1.ButtonHoveredBackgroundColor = System.Drawing.Color.DarkGray; enhancedScrollBarRenderer1.ButtonHoveredBorderColor = System.Drawing.Color.DimGray; enhancedScrollBarRenderer1.ButtonSelectedBackgroundColor = System.Drawing.Color.DimGray; enhancedScrollBarRenderer1.ButtonSelectedBorderColor = System.Drawing.Color.Gray; enhancedScrollBarRenderer1.TrackBarBackgroundColor = System.Drawing.Color.DarkGray; enhancedScrollBarRenderer1.TrackBarSelectedBackgroundColor = System.Drawing.Color.Gray; this.fpSpread설비등록.HorizontalScrollBar.Renderer = enhancedScrollBarRenderer1; this.fpSpread설비등록.HorizontalScrollBar.TabIndex = 48; this.fpSpread설비등록.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpSpread설비등록.Location = new System.Drawing.Point(0, 58); this.fpSpread설비등록.Name = "fpSpread설비등록"; this.fpSpread설비등록.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.fpSpread설비등록_Sheet1 }); this.fpSpread설비등록.Size = new System.Drawing.Size(985, 469); this.fpSpread설비등록.Skin = FarPoint.Win.Spread.DefaultSpreadSkins.Metallic; this.fpSpread설비등록.TabIndex = 1; this.fpSpread설비등록.VerticalScrollBar.Buttons = new FarPoint.Win.Spread.FpScrollBarButtonCollection("BackwardLineButton,ThumbTrack,ForwardLineButton"); this.fpSpread설비등록.VerticalScrollBar.Name = ""; enhancedScrollBarRenderer2.ArrowColor = System.Drawing.Color.Black; enhancedScrollBarRenderer2.ArrowHoveredColor = System.Drawing.Color.Black; enhancedScrollBarRenderer2.ArrowSelectedColor = System.Drawing.Color.Black; enhancedScrollBarRenderer2.ButtonBackgroundColor = System.Drawing.Color.Silver; enhancedScrollBarRenderer2.ButtonBorderColor = System.Drawing.Color.DarkGray; enhancedScrollBarRenderer2.ButtonHoveredBackgroundColor = System.Drawing.Color.DarkGray; enhancedScrollBarRenderer2.ButtonHoveredBorderColor = System.Drawing.Color.DimGray; enhancedScrollBarRenderer2.ButtonSelectedBackgroundColor = System.Drawing.Color.DimGray; enhancedScrollBarRenderer2.ButtonSelectedBorderColor = System.Drawing.Color.Gray; enhancedScrollBarRenderer2.TrackBarBackgroundColor = System.Drawing.Color.DarkGray; enhancedScrollBarRenderer2.TrackBarSelectedBackgroundColor = System.Drawing.Color.Gray; this.fpSpread설비등록.VerticalScrollBar.Renderer = enhancedScrollBarRenderer2; this.fpSpread설비등록.VerticalScrollBar.TabIndex = 49; this.fpSpread설비등록.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpSpread설비등록.EditModeOff += new System.EventHandler(this.fpSpread1_EditModeOff); // // fpSpread설비등록_Sheet1 // this.fpSpread설비등록_Sheet1.Reset(); this.fpSpread설비등록_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread설비등록_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread설비등록_Sheet1.ColumnCount = 15; this.fpSpread설비등록_Sheet1.ActiveColumnIndex = -1; this.fpSpread설비등록_Sheet1.ActiveRowIndex = -1; this.fpSpread설비등록_Sheet1.ColumnFooter.DefaultStyle.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.General; this.fpSpread설비등록_Sheet1.ColumnFooter.DefaultStyle.NoteIndicatorColor = System.Drawing.Color.Red; this.fpSpread설비등록_Sheet1.ColumnFooter.DefaultStyle.Parent = "ColumnHeaderMetallic"; this.fpSpread설비등록_Sheet1.ColumnFooter.DefaultStyle.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.General; this.fpSpread설비등록_Sheet1.ColumnFooterSheetCornerStyle.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.General; this.fpSpread설비등록_Sheet1.ColumnFooterSheetCornerStyle.NoteIndicatorColor = System.Drawing.Color.Red; this.fpSpread설비등록_Sheet1.ColumnFooterSheetCornerStyle.Parent = "CornerMetallic"; this.fpSpread설비등록_Sheet1.ColumnFooterSheetCornerStyle.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.General; this.fpSpread설비등록_Sheet1.ColumnHeader.DefaultStyle.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.General; this.fpSpread설비등록_Sheet1.ColumnHeader.DefaultStyle.NoteIndicatorColor = System.Drawing.Color.Red; this.fpSpread설비등록_Sheet1.ColumnHeader.DefaultStyle.Parent = "ColumnHeaderMetallic"; this.fpSpread설비등록_Sheet1.ColumnHeader.DefaultStyle.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.General; this.fpSpread설비등록_Sheet1.ColumnHeader.Rows.Get(0).Height = 30F; this.fpSpread설비등록_Sheet1.Columns.Get(0).BackColor = System.Drawing.Color.LightYellow; textCellType1.AllowEditorVerticalAlign = true; this.fpSpread설비등록_Sheet1.Columns.Get(0).CellType = textCellType1; this.fpSpread설비등록_Sheet1.Columns.Get(0).DataField = "관리코드"; this.fpSpread설비등록_Sheet1.Columns.Get(0).Font = new System.Drawing.Font("맑은 고딕", 12F); this.fpSpread설비등록_Sheet1.Columns.Get(0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(0).Locked = true; this.fpSpread설비등록_Sheet1.Columns.Get(0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(0).Width = 138F; this.fpSpread설비등록_Sheet1.Columns.Get(1).BackColor = System.Drawing.Color.LightYellow; textCellType2.AllowEditorVerticalAlign = true; this.fpSpread설비등록_Sheet1.Columns.Get(1).CellType = textCellType2; this.fpSpread설비등록_Sheet1.Columns.Get(1).DataField = "관리번호"; this.fpSpread설비등록_Sheet1.Columns.Get(1).Font = new System.Drawing.Font("맑은 고딕", 12F); this.fpSpread설비등록_Sheet1.Columns.Get(1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(1).Locked = true; this.fpSpread설비등록_Sheet1.Columns.Get(1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(1).Width = 135F; textCellType3.AllowEditorVerticalAlign = true; this.fpSpread설비등록_Sheet1.Columns.Get(2).CellType = textCellType3; this.fpSpread설비등록_Sheet1.Columns.Get(2).DataField = "품명"; this.fpSpread설비등록_Sheet1.Columns.Get(2).Font = new System.Drawing.Font("맑은 고딕", 12F); this.fpSpread설비등록_Sheet1.Columns.Get(2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(2).Width = 113F; textCellType4.AllowEditorVerticalAlign = true; this.fpSpread설비등록_Sheet1.Columns.Get(3).CellType = textCellType4; this.fpSpread설비등록_Sheet1.Columns.Get(3).DataField = "규격"; this.fpSpread설비등록_Sheet1.Columns.Get(3).Font = new System.Drawing.Font("맑은 고딕", 12F); this.fpSpread설비등록_Sheet1.Columns.Get(3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(3).Width = 156F; textCellType5.AllowEditorVerticalAlign = true; this.fpSpread설비등록_Sheet1.Columns.Get(4).CellType = textCellType5; this.fpSpread설비등록_Sheet1.Columns.Get(4).DataField = "제조회사"; this.fpSpread설비등록_Sheet1.Columns.Get(4).Font = new System.Drawing.Font("맑은 고딕", 12F); this.fpSpread설비등록_Sheet1.Columns.Get(4).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(4).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(4).Width = 156F; dateTimeCellType1.AllowEditorVerticalAlign = true; dateTimeCellType1.Calendar = new System.Globalization.GregorianCalendar(System.Globalization.GregorianCalendarTypes.Localized); dateTimeCellType1.CalendarSurroundingDaysColor = System.Drawing.SystemColors.GrayText; dateTimeCellType1.MaximumTime = System.TimeSpan.Parse("23:59:59.9999999"); dateTimeCellType1.TimeDefault = new System.DateTime(2018, 11, 8, 17, 13, 16, 0); this.fpSpread설비등록_Sheet1.Columns.Get(5).CellType = dateTimeCellType1; this.fpSpread설비등록_Sheet1.Columns.Get(5).DataField = "구입일자"; this.fpSpread설비등록_Sheet1.Columns.Get(5).Font = new System.Drawing.Font("맑은 고딕", 12F); this.fpSpread설비등록_Sheet1.Columns.Get(5).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(5).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(5).Width = 156F; numberCellType1.AllowEditorVerticalAlign = true; numberCellType1.DecimalPlaces = 0; numberCellType1.LeadingZero = FarPoint.Win.Spread.CellType.LeadingZero.Yes; numberCellType1.MaximumValue = 2147483647D; numberCellType1.MinimumValue = -2147483648D; numberCellType1.ShowSeparator = true; this.fpSpread설비등록_Sheet1.Columns.Get(6).CellType = numberCellType1; this.fpSpread설비등록_Sheet1.Columns.Get(6).DataField = "금액"; this.fpSpread설비등록_Sheet1.Columns.Get(6).Font = new System.Drawing.Font("맑은 고딕", 12F); this.fpSpread설비등록_Sheet1.Columns.Get(6).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(6).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(6).Width = 127F; textCellType6.AllowEditorVerticalAlign = true; this.fpSpread설비등록_Sheet1.Columns.Get(7).CellType = textCellType6; this.fpSpread설비등록_Sheet1.Columns.Get(7).DataField = "설치장소"; this.fpSpread설비등록_Sheet1.Columns.Get(7).Font = new System.Drawing.Font("맑은 고딕", 12F); this.fpSpread설비등록_Sheet1.Columns.Get(7).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(7).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(7).Width = 102F; textCellType7.AllowEditorVerticalAlign = true; this.fpSpread설비등록_Sheet1.Columns.Get(8).CellType = textCellType7; this.fpSpread설비등록_Sheet1.Columns.Get(8).DataField = "등급"; this.fpSpread설비등록_Sheet1.Columns.Get(8).Font = new System.Drawing.Font("맑은 고딕", 12F); this.fpSpread설비등록_Sheet1.Columns.Get(8).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(8).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(8).Width = 64F; textCellType8.AllowEditorVerticalAlign = true; this.fpSpread설비등록_Sheet1.Columns.Get(9).CellType = textCellType8; this.fpSpread설비등록_Sheet1.Columns.Get(9).DataField = "관리부서"; this.fpSpread설비등록_Sheet1.Columns.Get(9).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(9).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(9).Width = 120F; textCellType9.AllowEditorVerticalAlign = true; this.fpSpread설비등록_Sheet1.Columns.Get(10).CellType = textCellType9; this.fpSpread설비등록_Sheet1.Columns.Get(10).DataField = "관리책임자"; this.fpSpread설비등록_Sheet1.Columns.Get(10).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(10).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(10).Width = 135F; textCellType10.AllowEditorVerticalAlign = true; this.fpSpread설비등록_Sheet1.Columns.Get(11).CellType = textCellType10; this.fpSpread설비등록_Sheet1.Columns.Get(11).DataField = "수리업체"; this.fpSpread설비등록_Sheet1.Columns.Get(11).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(11).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(11).Width = 126F; textCellType11.AllowEditorVerticalAlign = true; this.fpSpread설비등록_Sheet1.Columns.Get(12).CellType = textCellType11; this.fpSpread설비등록_Sheet1.Columns.Get(12).DataField = "수리업체연락처"; this.fpSpread설비등록_Sheet1.Columns.Get(12).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(12).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread설비등록_Sheet1.Columns.Get(12).Width = 135F; numberCellType2.AllowEditorVerticalAlign = true; numberCellType2.DecimalPlaces = 0; numberCellType2.LeadingZero = FarPoint.Win.Spread.CellType.LeadingZero.Yes; numberCellType2.MaximumValue = 2147483647D; numberCellType2.MinimumValue = -2147483648D; this.fpSpread설비등록_Sheet1.Columns.Get(13).CellType = numberCellType2; this.fpSpread설비등록_Sheet1.Columns.Get(13).DataField = "관리순번"; this.fpSpread설비등록_Sheet1.Columns.Get(13).Visible = false; this.fpSpread설비등록_Sheet1.Columns.Get(13).Width = 135F; numberCellType3.AllowEditorVerticalAlign = true; numberCellType3.DecimalPlaces = 0; numberCellType3.LeadingZero = FarPoint.Win.Spread.CellType.LeadingZero.Yes; numberCellType3.MaximumValue = 2147483647D; numberCellType3.MinimumValue = -2147483648D; this.fpSpread설비등록_Sheet1.Columns.Get(14).CellType = numberCellType3; this.fpSpread설비등록_Sheet1.Columns.Get(14).DataField = "설비종류"; this.fpSpread설비등록_Sheet1.Columns.Get(14).Visible = false; this.fpSpread설비등록_Sheet1.Columns.Get(14).Width = 102F; this.fpSpread설비등록_Sheet1.DataAutoCellTypes = false; this.fpSpread설비등록_Sheet1.DataAutoSizeColumns = false; this.fpSpread설비등록_Sheet1.DataSource = this.설비BindingSource; this.fpSpread설비등록_Sheet1.DefaultStyle.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.General; this.fpSpread설비등록_Sheet1.DefaultStyle.Locked = false; this.fpSpread설비등록_Sheet1.DefaultStyle.NoteIndicatorColor = System.Drawing.Color.Red; this.fpSpread설비등록_Sheet1.DefaultStyle.Parent = "DataAreaDefault"; this.fpSpread설비등록_Sheet1.DefaultStyle.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.General; this.fpSpread설비등록_Sheet1.DisplayZero = false; this.fpSpread설비등록_Sheet1.FilterBar.DefaultStyle.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.General; this.fpSpread설비등록_Sheet1.FilterBar.DefaultStyle.NoteIndicatorColor = System.Drawing.Color.Red; this.fpSpread설비등록_Sheet1.FilterBar.DefaultStyle.Parent = "FilterBarMetallic"; this.fpSpread설비등록_Sheet1.FilterBar.DefaultStyle.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.General; this.fpSpread설비등록_Sheet1.FilterBarHeaderStyle.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.General; this.fpSpread설비등록_Sheet1.FilterBarHeaderStyle.NoteIndicatorColor = System.Drawing.Color.Red; this.fpSpread설비등록_Sheet1.FilterBarHeaderStyle.Parent = "RowHeaderMetallic"; this.fpSpread설비등록_Sheet1.FilterBarHeaderStyle.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.General; this.fpSpread설비등록_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode; this.fpSpread설비등록_Sheet1.RowHeader.Columns.Default.Resizable = false; this.fpSpread설비등록_Sheet1.RowHeader.DefaultStyle.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.General; this.fpSpread설비등록_Sheet1.RowHeader.DefaultStyle.NoteIndicatorColor = System.Drawing.Color.Red; this.fpSpread설비등록_Sheet1.RowHeader.DefaultStyle.Parent = "RowHeaderMetallic"; this.fpSpread설비등록_Sheet1.RowHeader.DefaultStyle.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.General; this.fpSpread설비등록_Sheet1.RowHeader.Visible = false; this.fpSpread설비등록_Sheet1.SheetCornerStyle.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.General; this.fpSpread설비등록_Sheet1.SheetCornerStyle.NoteIndicatorColor = System.Drawing.Color.Red; this.fpSpread설비등록_Sheet1.SheetCornerStyle.Parent = "CornerMetallic"; this.fpSpread설비등록_Sheet1.SheetCornerStyle.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.General; this.fpSpread설비등록_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; // // 설비BindingSource // this.설비BindingSource.DataMember = "설비"; this.설비BindingSource.DataSource = this.설비등록DS; // // 설비등록DS // this.설비등록DS.DataSetName = "설비등록DS"; this.설비등록DS.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // 설비등록Control // this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.Controls.Add(this.fpSpread설비등록); this.Controls.Add(this.panel1); this.Name = "설비등록Control"; this.Size = new System.Drawing.Size(985, 527); this.Load += new System.EventHandler(this.설비등록_Load); this.panel1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.fpSpread설비등록)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread설비등록_Sheet1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.설비BindingSource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.설비등록DS)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { FarPoint.Win.Spread.TipAppearance tipAppearance1 = new FarPoint.Win.Spread.TipAppearance(); FarPoint.Win.Spread.CellType.TextCellType textCellType1 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType2 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType3 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType4 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.ComboBoxCellType comboBoxCellType1 = new FarPoint.Win.Spread.CellType.ComboBoxCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType1 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ucBookingTemplet)); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType2 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); this.neuSpread1 = new Neusoft.FrameWork.WinForms.Controls.NeuFpEnter(); this.neuSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1_Sheet1)).BeginInit(); this.SuspendLayout(); // // neuSpread1 // this.neuSpread1.About = "2.5.2007.2005"; this.neuSpread1.AccessibleDescription = "neuSpread1, Sheet1"; this.neuSpread1.BackColor = System.Drawing.Color.White; this.neuSpread1.Dock = System.Windows.Forms.DockStyle.Fill; this.neuSpread1.EditModePermanent = true; this.neuSpread1.EditModeReplace = true; this.neuSpread1.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.neuSpread1.Location = new System.Drawing.Point(0, 0); this.neuSpread1.Name = "neuSpread1"; this.neuSpread1.SelectNone = false; this.neuSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.neuSpread1_Sheet1 }); this.neuSpread1.ShowListWhenOfFocus = false; this.neuSpread1.Size = new System.Drawing.Size(804, 442); this.neuSpread1.TabIndex = 0; tipAppearance1.BackColor = System.Drawing.SystemColors.Info; tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText; this.neuSpread1.TextTipAppearance = tipAppearance1; this.neuSpread1.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.neuSpread1.ComboCloseUp += new FarPoint.Win.Spread.EditorNotifyEventHandler(this.neuSpread1_ComboCloseUp); this.neuSpread1.KeyEnter += new Neusoft.FrameWork.WinForms.Controls.NeuFpEnter.keyDown(this.neuSpread1_KeyEnter); // // neuSpread1_Sheet1 // this.neuSpread1_Sheet1.Reset(); this.neuSpread1_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.neuSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.neuSpread1_Sheet1.ColumnCount = 12; this.neuSpread1_Sheet1.RowCount = 0; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "项目代码"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "项目名称"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "单位标识"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "预约限额"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "特诊预约限额"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "午别"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "有效标识"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 7).Value = "注意事项"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 8).Value = "旧午别"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 10).Value = "开始时间"; this.neuSpread1_Sheet1.ColumnHeader.Cells.Get(0, 11).Value = "结束时间"; this.neuSpread1_Sheet1.Columns.Get(0).CellType = textCellType1; this.neuSpread1_Sheet1.Columns.Get(0).Label = "项目代码"; this.neuSpread1_Sheet1.Columns.Get(0).Width = 80F; this.neuSpread1_Sheet1.Columns.Get(1).CellType = textCellType2; this.neuSpread1_Sheet1.Columns.Get(1).Label = "项目名称"; this.neuSpread1_Sheet1.Columns.Get(1).Width = 100F; this.neuSpread1_Sheet1.Columns.Get(2).CellType = textCellType3; this.neuSpread1_Sheet1.Columns.Get(2).Label = "单位标识"; this.neuSpread1_Sheet1.Columns.Get(2).Width = 80F; this.neuSpread1_Sheet1.Columns.Get(4).CellType = textCellType4; this.neuSpread1_Sheet1.Columns.Get(4).Label = "特诊预约限额"; this.neuSpread1_Sheet1.Columns.Get(4).Width = 100F; comboBoxCellType1.ButtonAlign = FarPoint.Win.ButtonAlign.Right; comboBoxCellType1.Items = new string[] { "有效", "无效" }; this.neuSpread1_Sheet1.Columns.Get(6).CellType = comboBoxCellType1; this.neuSpread1_Sheet1.Columns.Get(6).Label = "有效标识"; this.neuSpread1_Sheet1.Columns.Get(7).Label = "注意事项"; this.neuSpread1_Sheet1.Columns.Get(7).Width = 300F; this.neuSpread1_Sheet1.Columns.Get(8).Label = "旧午别"; this.neuSpread1_Sheet1.Columns.Get(8).Visible = false; this.neuSpread1_Sheet1.Columns.Get(9).Visible = false; dateTimeCellType1.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType1.Calendar"))); dateTimeCellType1.DateDefault = new System.DateTime(2008, 7, 15, 0, 0, 0, 0); dateTimeCellType1.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.TimeOnly; dateTimeCellType1.TimeDefault = new System.DateTime(2008, 7, 15, 0, 0, 0, 0); this.neuSpread1_Sheet1.Columns.Get(10).CellType = dateTimeCellType1; this.neuSpread1_Sheet1.Columns.Get(10).Label = "开始时间"; this.neuSpread1_Sheet1.Columns.Get(10).Width = 112F; dateTimeCellType2.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType2.Calendar"))); dateTimeCellType2.DateDefault = new System.DateTime(2008, 7, 15, 14, 37, 35, 0); dateTimeCellType2.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.TimeOnly; dateTimeCellType2.TimeDefault = new System.DateTime(2008, 7, 15, 14, 37, 35, 0); this.neuSpread1_Sheet1.Columns.Get(11).CellType = dateTimeCellType2; this.neuSpread1_Sheet1.Columns.Get(11).Label = "结束时间"; this.neuSpread1_Sheet1.Columns.Get(11).Width = 104F; this.neuSpread1_Sheet1.RowHeader.Columns.Default.Resizable = false; this.neuSpread1_Sheet1.RowHeader.Columns.Get(0).Width = 37F; this.neuSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; this.neuSpread1.SetActiveViewport(1, 0); // // ucBookingTemplet // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.Controls.Add(this.neuSpread1); this.Name = "ucBookingTemplet"; this.Size = new System.Drawing.Size(804, 442); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.neuSpread1_Sheet1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { FarPoint.Win.Spread.TipAppearance tipAppearance1 = new FarPoint.Win.Spread.TipAppearance(); FarPoint.Win.Spread.CellType.TextCellType textCellType1 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType2 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType3 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType1 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ucMedTechBookingArrange)); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType2 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType numCellType1 = new Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType(); Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType numCellType2 = new Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType(); Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType numCellType3 = new Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType(); Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType numCellType4 = new Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType(); this.fpSpread1 = new Neusoft.FrameWork.WinForms.Controls.NeuFpEnter(); this.fpSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).BeginInit(); this.SuspendLayout(); // // fpSpread1 // this.fpSpread1.About = "2.5.2007.2005"; this.fpSpread1.AccessibleDescription = "fpSpread1, Sheet1"; this.fpSpread1.BackColor = System.Drawing.SystemColors.Control; this.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill; this.fpSpread1.EditModePermanent = true; this.fpSpread1.EditModeReplace = true; this.fpSpread1.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpSpread1.Location = new System.Drawing.Point(0, 0); this.fpSpread1.Name = "fpSpread1"; this.fpSpread1.SelectNone = false; this.fpSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.fpSpread1_Sheet1 }); this.fpSpread1.ShowListWhenOfFocus = false; this.fpSpread1.Size = new System.Drawing.Size(749, 473); this.fpSpread1.TabIndex = 0; tipAppearance1.BackColor = System.Drawing.SystemColors.Info; tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText; this.fpSpread1.TextTipAppearance = tipAppearance1; this.fpSpread1.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpSpread1.KeyEnter += new Neusoft.FrameWork.WinForms.Controls.NeuFpEnter.keyDown(this.fpSpread1_KeyEnter); // // fpSpread1_Sheet1 // this.fpSpread1_Sheet1.Reset(); this.fpSpread1_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread1_Sheet1.ColumnCount = 12; this.fpSpread1_Sheet1.RowCount = 0; this.fpSpread1_Sheet1.ActiveSkin = new FarPoint.Win.Spread.SheetSkin("CustomSkin1", System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.LightGray, FarPoint.Win.Spread.GridLines.Both, System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, false, false, false, true, true); this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "项目代码"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "项目名称"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "午别"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "开始时间"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "结束时间"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "预约限额"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "特诊预约限额"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 7).Value = "已经预约数"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 8).Value = "特诊预约数"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 9).Value = "旧午别"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 10).Value = "单位标识"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 11).Value = "执行设备"; this.fpSpread1_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.fpSpread1_Sheet1.ColumnHeader.DefaultStyle.Locked = false; this.fpSpread1_Sheet1.ColumnHeader.DefaultStyle.Parent = "HeaderDefault"; this.fpSpread1_Sheet1.Columns.Get(0).CellType = textCellType1; this.fpSpread1_Sheet1.Columns.Get(0).Label = "项目代码"; this.fpSpread1_Sheet1.Columns.Get(0).Width = 90F; this.fpSpread1_Sheet1.Columns.Get(1).CellType = textCellType2; this.fpSpread1_Sheet1.Columns.Get(1).Label = "项目名称"; this.fpSpread1_Sheet1.Columns.Get(1).Width = 120F; this.fpSpread1_Sheet1.Columns.Get(2).CellType = textCellType3; this.fpSpread1_Sheet1.Columns.Get(2).Label = "午别"; dateTimeCellType1.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType1.Calendar"))); dateTimeCellType1.DateDefault = new System.DateTime(2008, 7, 15, 15, 25, 50, 0); dateTimeCellType1.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.TimeOnly; dateTimeCellType1.TimeDefault = new System.DateTime(2008, 7, 15, 15, 25, 50, 0); this.fpSpread1_Sheet1.Columns.Get(3).CellType = dateTimeCellType1; this.fpSpread1_Sheet1.Columns.Get(3).Label = "开始时间"; this.fpSpread1_Sheet1.Columns.Get(3).Width = 101F; dateTimeCellType2.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType2.Calendar"))); dateTimeCellType2.DateDefault = new System.DateTime(2008, 7, 15, 15, 26, 11, 0); dateTimeCellType2.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.TimeOnly; dateTimeCellType2.TimeDefault = new System.DateTime(2008, 7, 15, 15, 26, 11, 0); this.fpSpread1_Sheet1.Columns.Get(4).CellType = dateTimeCellType2; this.fpSpread1_Sheet1.Columns.Get(4).Label = "结束时间"; this.fpSpread1_Sheet1.Columns.Get(4).Width = 100F; this.fpSpread1_Sheet1.Columns.Get(5).CellType = numCellType1; this.fpSpread1_Sheet1.Columns.Get(5).Label = "预约限额"; this.fpSpread1_Sheet1.Columns.Get(5).Width = 80F; this.fpSpread1_Sheet1.Columns.Get(6).CellType = numCellType2; this.fpSpread1_Sheet1.Columns.Get(6).Label = "特诊预约限额"; this.fpSpread1_Sheet1.Columns.Get(6).Width = 100F; numCellType3.ReadOnly = true; this.fpSpread1_Sheet1.Columns.Get(7).CellType = numCellType3; this.fpSpread1_Sheet1.Columns.Get(7).Label = "已经预约数"; this.fpSpread1_Sheet1.Columns.Get(7).Width = 100F; numCellType4.ReadOnly = true; this.fpSpread1_Sheet1.Columns.Get(8).CellType = numCellType4; this.fpSpread1_Sheet1.Columns.Get(8).Label = "特诊预约数"; this.fpSpread1_Sheet1.Columns.Get(8).Width = 90F; this.fpSpread1_Sheet1.Columns.Get(9).Label = "旧午别"; this.fpSpread1_Sheet1.Columns.Get(9).Visible = false; this.fpSpread1_Sheet1.Columns.Get(10).Label = "单位标识"; this.fpSpread1_Sheet1.Columns.Get(10).Visible = false; this.fpSpread1_Sheet1.Columns.Get(11).Label = "执行设备"; this.fpSpread1_Sheet1.Columns.Get(11).Width = 85F; this.fpSpread1_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode; this.fpSpread1_Sheet1.RowHeader.Columns.Default.Resizable = false; this.fpSpread1_Sheet1.RowHeader.Columns.Get(0).Width = 37F; this.fpSpread1_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.fpSpread1_Sheet1.RowHeader.DefaultStyle.Locked = false; this.fpSpread1_Sheet1.RowHeader.DefaultStyle.Parent = "HeaderDefault"; this.fpSpread1_Sheet1.SheetCornerStyle.BackColor = System.Drawing.Color.White; this.fpSpread1_Sheet1.SheetCornerStyle.Locked = false; this.fpSpread1_Sheet1.SheetCornerStyle.Parent = "HeaderDefault"; this.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; this.fpSpread1.SetActiveViewport(1, 0); // // ucMedTechBookingArrange // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.Controls.Add(this.fpSpread1); this.Name = "ucMedTechBookingArrange"; this.Size = new System.Drawing.Size(749, 473); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).EndInit(); this.ResumeLayout(false); }
private void setGrdViewH() { FarPoint.Win.Spread.EnhancedInterfaceRenderer outlinelook = new FarPoint.Win.Spread.EnhancedInterfaceRenderer(); outlinelook.RangeGroupBackgroundColor = Color.LightGreen; outlinelook.RangeGroupButtonBorderColor = Color.Red; outlinelook.RangeGroupLineColor = Color.Blue; grdView.InterfaceRenderer = outlinelook; grdView.Sheets[0].OperationMode = FarPoint.Win.Spread.OperationMode.RowMode; grdView.BorderStyle = BorderStyle.None; grdView.Sheets[0].Columns[0, 2].AllowAutoFilter = true; grdView.Sheets[0].Columns[0, 2].AllowAutoSort = true; grdView.Sheets[0].AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu; FarPoint.Win.Spread.CellType.NumberCellType objNumCell = new FarPoint.Win.Spread.CellType.NumberCellType(); objNumCell.DecimalPlaces = 0; objNumCell.MinimumValue = 1; objNumCell.MaximumValue = 9999; objNumCell.ShowSeparator = false; FarPoint.Win.Spread.CellType.DateTimeCellType datecell = new FarPoint.Win.Spread.CellType.DateTimeCellType(); datecell.DateSeparator = " | "; datecell.TimeSeparator = "."; datecell.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime; FarPoint.Win.Spread.CellType.CurrencyCellType ctest = new FarPoint.Win.Spread.CellType.CurrencyCellType(); ctest.SetCalculatorText("Accept", "Cancel"); FarPoint.Win.Spread.CellType.TextCellType objTextCell = new FarPoint.Win.Spread.CellType.TextCellType(); //grdView.sheet //grdView.Height = 330; //grdView.Width = 765; grdView.Sheets[0].ColumnCount = colCnt; grdView.Sheets[0].RowCount = 1; //grdView.Sheets[0].ColumnHeader.Cells[0, 0].Text = "Check #"; grdView.Sheets[0].Columns[colId].CellType = objTextCell; grdView.Sheets[0].Columns[colbtid].CellType = objTextCell; grdView.Sheets[0].Columns[colinvno].CellType = objTextCell; grdView.Sheets[0].Columns[colsvdate].CellType = objTextCell; grdView.Sheets[0].Columns[colbillmuad].CellType = objTextCell; grdView.Sheets[0].Columns[collccode].CellType = objTextCell; grdView.Sheets[0].Columns[colstdcode].CellType = objTextCell; grdView.Sheets[0].Columns[coldesc1].CellType = objTextCell; grdView.Sheets[0].Columns[colqty].CellType = objTextCell; grdView.Sheets[0].Columns[colup].CellType = objTextCell; grdView.Sheets[0].Columns[colchargeamt].CellType = objTextCell; grdView.Sheets[0].Columns[colclaimup].CellType = objTextCell; grdView.Sheets[0].Columns[colsvrefid].CellType = objTextCell; grdView.Sheets[0].Columns[colclaimcat].CellType = objTextCell; grdView.Sheets[0].Columns[colEdit].CellType = objTextCell; grdView.Sheets[0].Columns[colClaimamount].CellType = objTextCell; grdView.Sheets[0].Columns[colId].Visible = false; grdView.Sheets[0].Columns[colbtid].Visible = false; grdView.Sheets[0].Columns[colEdit].Visible = false; grdView.Sheets[0].SheetName = "BillTran Items"; grdView.Sheets[0].Columns[colinvno].Width = 100; grdView.Sheets[0].Columns[colsvdate].Width = 120; grdView.Sheets[0].Columns[colbillmuad].Width = 50; grdView.Sheets[0].Columns[collccode].Width = 50; grdView.Sheets[0].Columns[colstdcode].Width = 50; grdView.Sheets[0].Columns[coldesc1].Width = 250; grdView.Sheets[0].Columns[colqty].Width = 50; grdView.Sheets[0].Columns[colup].Width = 80; grdView.Sheets[0].Columns[colchargeamt].Width = 60; grdView.Sheets[0].Columns[colclaimup].Width = 50; grdView.Sheets[0].Columns[colsvrefid].Width = 80; grdView.Sheets[0].Columns[colclaimcat].Width = 50; grdView.Sheets[0].Columns[colClaimamount].Width = 50; grdView.Sheets[0].ColumnHeader.Cells[0, colinvno].Text = "invno"; grdView.Sheets[0].ColumnHeader.Cells[0, colsvdate].Text = "svdate"; grdView.Sheets[0].ColumnHeader.Cells[0, colbillmuad].Text = "billmuad"; grdView.Sheets[0].ColumnHeader.Cells[0, collccode].Text = "lccode"; grdView.Sheets[0].ColumnHeader.Cells[0, colstdcode].Text = "stdcode"; grdView.Sheets[0].ColumnHeader.Cells[0, coldesc1].Text = "description"; grdView.Sheets[0].ColumnHeader.Cells[0, colqty].Text = "qty"; grdView.Sheets[0].ColumnHeader.Cells[0, colup].Text = "up"; grdView.Sheets[0].ColumnHeader.Cells[0, colchargeamt].Text = "chargeamt"; grdView.Sheets[0].ColumnHeader.Cells[0, colclaimup].Text = "claimup"; grdView.Sheets[0].ColumnHeader.Cells[0, colsvrefid].Text = "svrefid"; grdView.Sheets[0].ColumnHeader.Cells[0, colclaimcat].Text = "claimcat"; grdView.Sheets[0].ColumnHeader.Cells[0, colClaimamount].Text = "claimamount"; grdView.Sheets[0].RestrictRows = true; }