コード例 #1
0
        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();
        }
コード例 #2
0
        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();
        }
コード例 #3
0
 /// <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;
 }
コード例 #4
0
        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;
        }
コード例 #5
0
        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
        }
コード例 #6
0
        /// <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
        }
コード例 #7
0
        /// <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;     //滴速
        }
コード例 #8
0
        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();
        }
コード例 #9
0
        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;
        }
コード例 #10
0
ファイル: TJItemDialog.cs プロジェクト: scaperow/-V2.0
        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;
        }
コード例 #11
0
        /// <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;
        }
コード例 #12
0
ファイル: UnusedTestDataView.cs プロジェクト: scaperow/-V2.0
        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;
            }
        }
コード例 #13
0
        /// <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;
        }
コード例 #14
0
        /// <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;
        }
コード例 #15
0
        /// <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;
                }
            }
        }
コード例 #16
0
        /// <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);
        }
コード例 #17
0
        /// <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++;
            }
        }
コード例 #18
0
        /// <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);
        }
コード例 #19
0
        /// <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);
        }
コード例 #20
0
        /// <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);
        }
コード例 #21
0
        /// <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
        }
コード例 #22
0
        /// <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);
        }
コード例 #23
0
        /// <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);
        }
コード例 #24
0
 /// <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();
 }
コード例 #25
0
        /// <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);
        }
コード例 #26
0
 /// <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);
 }
コード例 #27
0
 /// <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);
 }
コード例 #28
0
        /// <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);
        }
コード例 #29
0
        /// <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);
        }
コード例 #30
0
        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;
        }