/// <summary>
/// 根据不同的项目类型 设置单元格属性
/// </summary>
/// <param name="fp">需更改的FarPoint</param>
/// <param name="itemType">项目类型</param>
/// <param name="rowIndex">单元格行索引</param>
/// <param name="columnIndex">单元格列索引</param>
protected void SetReportCellType(FPItem fp, FarPoint.Win.Spread.SheetView sv, Neusoft.HISFC.Models.Preparation.EnumStencilItemType itemType, int rowIndex, int columnIndex)
{
switch (itemType)
{
case Neusoft.HISFC.Models.Preparation.EnumStencilItemType.Person:
fp.SetColumnList(sv, this.alStaticEmployee, columnIndex);
break;
case Neusoft.HISFC.Models.Preparation.EnumStencilItemType.Dept:
fp.SetColumnList(sv, this.alStaticDept, columnIndex);
break;
case Neusoft.HISFC.Models.Preparation.EnumStencilItemType.Date:
Neusoft.FrameWork.WinForms.Classes.MarkCellType.DateTimeCellType markDateCellType = new Neusoft.FrameWork.WinForms.Classes.MarkCellType.DateTimeCellType();
sv.Cells[rowIndex, columnIndex].CellType = markDateCellType;
break;
case Neusoft.HISFC.Models.Preparation.EnumStencilItemType.Number:
Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType numCellType = new Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType();
sv.Cells[rowIndex, columnIndex].CellType = numCellType;
break;
default:
break;
}
}
/// <summary>
/// 根据不同的项目类型 设置单元格属性
/// </summary>
/// <param name="itemType">项目类型</param>
/// <param name="rowIndex">单元格行索引</param>
/// <param name="columnIndex">单元格列索引</param>
private void SetReportCellType(Neusoft.HISFC.Models.Preparation.EnumStencilItemType itemType, int rowIndex, int columnIndex)
{
switch (itemType)
{
case Neusoft.HISFC.Models.Preparation.EnumStencilItemType.Person:
this.fsReport.SetColumnList(this.fsReport_Sheet1, this.alStaticEmployee, columnIndex);
break;
case Neusoft.HISFC.Models.Preparation.EnumStencilItemType.Dept:
this.fsReport.SetColumnList(this.fsReport_Sheet1, this.alStaticDept, columnIndex);
break;
case Neusoft.HISFC.Models.Preparation.EnumStencilItemType.Date:
Neusoft.FrameWork.WinForms.Classes.MarkCellType.DateTimeCellType markDateCellType = new Neusoft.FrameWork.WinForms.Classes.MarkCellType.DateTimeCellType();
this.fsReport_Sheet1.Cells[rowIndex, columnIndex].CellType = markDateCellType;
break;
case Neusoft.HISFC.Models.Preparation.EnumStencilItemType.Number:
Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType numCellType = new Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType();
this.fsReport_Sheet1.Cells[rowIndex, columnIndex].CellType = numCellType;
break;
default:
break;
}
}
public int Init()
{
this.sysTime = consManager.GetDateTimeFromSysDateTime();
Neusoft.FrameWork.WinForms.Classes.MarkCellType.DateTimeCellType markDateCellType = new Neusoft.FrameWork.WinForms.Classes.MarkCellType.DateTimeCellType();
markDateCellType.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.TimeOnly;
this.neuSpread1_Sheet1.Columns[1].CellType = markDateCellType;
this.neuSpread1_Sheet1.Columns[2].CellType = markDateCellType;
return(1);
}
/// <summary>
/// 显示库存药品时进行格式化
/// {D06724D9-C415-4a6b-8E93-0FF175CB7A8A} 20091230
/// </summary>
private void SetFormatForStorageAndDict(int showBatchNO)
{
this.neuSpread1_Sheet1.Columns.Get(0).Label = "药品编码";
this.neuSpread1_Sheet1.Columns.Get(0).Width = 90F;
this.neuSpread1_Sheet1.Columns.Get(0).Visible = true;
this.neuSpread1_Sheet1.Columns.Get(1).Label = "药品名称";
this.neuSpread1_Sheet1.Columns.Get(1).Visible = true;
this.neuSpread1_Sheet1.Columns.Get(1).Width = 160F;
this.neuSpread1_Sheet1.Columns.Get(2).Label = "规格";
this.neuSpread1_Sheet1.Columns.Get(2).Width = 80F;
this.neuSpread1_Sheet1.Columns.Get(2).Visible = true;
this.neuSpread1_Sheet1.Columns.Get(3).Label = "批号";
this.neuSpread1_Sheet1.Columns.Get(3).Width = 70F;
this.neuSpread1_Sheet1.Columns.Get(3).Visible = Neusoft.FrameWork.Function.NConvert.ToBoolean(showBatchNO);
Neusoft.FrameWork.WinForms.Classes.MarkCellType.DateTimeCellType markDateTimeCellType = new Neusoft.FrameWork.WinForms.Classes.MarkCellType.DateTimeCellType();
markDateTimeCellType.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate;
this.neuSpread1_Sheet1.Columns.Get(4).CellType = markDateTimeCellType;
this.neuSpread1_Sheet1.Columns.Get(4).Label = "有效期";
this.neuSpread1_Sheet1.Columns.Get(4).Width = 66F;
this.neuSpread1_Sheet1.Columns.Get(4).Visible = true;
this.neuSpread1_Sheet1.Columns.Get(5).Label = "库存";
this.neuSpread1_Sheet1.Columns.Get(5).Width = 70F;
Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType markNumCellType = new Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType();
markNumCellType.DecimalPlaces = 3;
this.neuSpread1_Sheet1.Columns[5].CellType = markNumCellType;
this.neuSpread1_Sheet1.Columns.Get(5).Visible = true;
this.neuSpread1_Sheet1.Columns.Get(6).Label = "单位";
this.neuSpread1_Sheet1.Columns.Get(6).Width = 35F;
this.neuSpread1_Sheet1.Columns.Get(6).Visible = true;
this.neuSpread1_Sheet1.Columns.Get(7).Label = "厂家";
this.neuSpread1_Sheet1.Columns.Get(7).Width = 110F;
this.neuSpread1_Sheet1.Columns.Get(7).Visible = true;
Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType markNumCellType2 = new Neusoft.FrameWork.WinForms.Classes.MarkCellType.NumCellType();
markNumCellType2.DecimalPlaces = 2;
this.neuSpread1_Sheet1.Columns[8].CellType = markNumCellType2;
this.neuSpread1_Sheet1.Columns.Get(8).Label = "进价";
this.neuSpread1_Sheet1.Columns.Get(8).Width = 60F;
this.neuSpread1_Sheet1.Columns.Get(8).Visible = true;
this.neuSpread1_Sheet1.Columns[9].CellType = markNumCellType2;
this.neuSpread1_Sheet1.Columns.Get(9).Label = "零售价";
this.neuSpread1_Sheet1.Columns.Get(9).Width = 60F;
this.neuSpread1_Sheet1.Columns.Get(9).Visible = true;
this.neuSpread1_Sheet1.Columns.Get(10).Label = "医保";
this.neuSpread1_Sheet1.Columns.Get(10).Width = 39F;
this.neuSpread1_Sheet1.Columns.Get(10).Visible = false;
this.neuSpread1_Sheet1.Columns.Get(11).Label = "拼音码";
this.neuSpread1_Sheet1.Columns.Get(11).Visible = false;
this.neuSpread1_Sheet1.Columns.Get(12).Label = "五笔码";
this.neuSpread1_Sheet1.Columns.Get(12).Visible = false;
this.neuSpread1_Sheet1.Columns.Get(13).Label = "通用名拼音码";
this.neuSpread1_Sheet1.Columns.Get(13).Visible = false;
this.neuSpread1_Sheet1.Columns.Get(14).Label = "通用名五笔码";
this.neuSpread1_Sheet1.Columns.Get(14).Visible = false;
}
