DEVEXPRESS

//合计
DevExpress.XtraGrid.Columns.GridColumn col_Profit = gridView1.Columns["AMOUNT_DISCOUNT"];
col_Profit.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
col_Profit.SummaryItem.DisplayFormat = "{0:C}";

DevExpress.XtraGrid.Columns.GridColumn col_Profit3 = gridView1.Columns["DRUG_NAME"];
col_Profit3.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
col_Profit3.SummaryItem.DisplayFormat = "合计";

this.gridView1.Columns["PURCHASE_PRICE"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.gridView1.Columns["PURCHASE_PRICE"].DisplayFormat.FormatString = "C";
this.gridView1.Columns["EXPIRE_DATE"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.gridView1.Columns["EXPIRE_DATE"].DisplayFormat.FormatString = "yyyy-MM-dd";

//当单元格未释放焦点时，提交更新保存数据
this.gridView1.CloseEditor();
this.gridView1.UpdateCurrentRow();

string c_Value = "CHARGE_TYPE,DRUG_CODE,DRUG_NAME,DRUG_SPEC,CONSTRAINED_LEVEL";
string c_Name = "费别,药品代码,药名,规格,限制级别";
this.gridView1.Columns["MTRL_CODE"].Visible = false;
this.gridView1.Columns["check"].OptionsColumn.AllowEdit = true;

private void gridView2_RowCellStyle(object sender, RowCellStyleEventArgs e)
{
if (e.Column.FieldName== "OUT_QUANTITY"||e.Column.FieldName== "OUT_PRICE")
{
e.Appearance.ForeColor = Color.Red;
}
}

gridView1.CustomRowCellEditForEditing += (x, w) =>
{
if (w.Column.FieldName != "LOCATION")
return;
DevExpress.XtraGrid.Views.Grid.GridView gv = new DevExpress.XtraGrid.Views.Grid.GridView();
DevExpress.XtraEditors.Repository.RepositoryItemGridLookUpEdit repositoryItem = new DevExpress.XtraEditors.Repository.RepositoryItemGridLookUpEdit();
w.RepositoryItem = repositoryItem;
repositoryItem.DisplayMember = "货位";
repositoryItem.ValueMember = "货位";
repositoryItem.DataSource = ds_sql_location.Tables[0];
repositoryItem.View = gv;
repositoryItem.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
repositoryItem.NullText = "";
};

private DataTable GetNewDataTable(DataTable dt, string condition, string sortstr)
{
DataTable newdt = new DataTable();
newdt = dt.Clone();
DataRow[] dr = dt.Select(condition, sortstr);

if (dr == null || dr.Length == 0) return null;
for (int i = 0; i < dr.Length; i++)
{
newdt.ImportRow((DataRow)dr[i]);
}
return newdt;//返回的查询结果
}

this.dateTimePicker1.Properties.Mask.EditMask = "yyyy年MM月";
this.dateTimePicker1.Properties.VistaCalendarInitialViewStyle = DevExpress.XtraEditors.VistaCalendarInitialViewStyle.YearView;
this.dateTimePicker1.Properties.VistaCalendarViewStyle = DevExpress.XtraEditors.VistaCalendarViewStyle.YearView;

gridView1.OptionsSelection.MultiSelect = true;
gridView1.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect;
gridView1.OptionsSelection.ShowCheckBoxSelectorInColumnHeader = DevExpress.Utils.DefaultBoolean.True;

 

DevExpress.XtraGrid.Views.Base.ColumnView View = sender as DevExpress.XtraGrid.Views.Base.ColumnView;

View.SetRowCellValue(e.RowHandle, View.Columns["batch_no"], "XX-XXXX");
View.SetRowCellValue(e.RowHandle, View.Columns["expire_date"], DateTime.Now.ToString("yyyy-MM-dd"));