/// <summary> Add BtnCmdNew in Header、BtnCmdEdit、BtnCmdDelete
/// With ClientSideEvent CustomButtonClick() and AddNewClick()
/// </summary>
/// <param name="helper">this.Html</param>
/// <param name="settings">GridViewSettings</param>
public static void SetCommandButton(HtmlHelper helper, GridViewSettings settings)
{
settings.SettingsCommandButton.RenderMode = GridCommandButtonRenderMode.Button;
settings.CommandColumn.SetHeaderCaptionTemplateContent(c =>
{
helper.DevExpress().Button(button =>
{
button.Name = "BtnCmdNew";
button.Text = "New";
button.Styles.Style.Paddings.PaddingTop = 0;
button.Styles.Style.Paddings.PaddingBottom = 0;
button.Images.Image.Url = "~/Content/Icon/add_circle_outline_grey_18x18.png";
button.ClientSideEvents.Click = "AddNewClick";
}).GetHtml();
});
GridViewCommandColumnCustomButton btnEdit = new GridViewCommandColumnCustomButton();
btnEdit.ID = "BtnCmdEdit";
btnEdit.Text = "Edit";
btnEdit.Image.Url = "~/Content/Icon/edit_grey_18x18.png";
btnEdit.Styles.Style.Paddings.Padding = 0;
settings.CommandColumn.CustomButtons.Add(btnEdit);
settings.CommandColumn.ButtonRenderMode = GridCommandButtonRenderMode.Button;
GridViewCommandColumnCustomButton btnDelete = new GridViewCommandColumnCustomButton();
btnDelete.ID = "BtnCmdDelete";
btnDelete.Text = "Del";
btnDelete.Image.Url = "~/Content/Icon/delete_grey_18x18.png";
btnDelete.Styles.Style.Paddings.Padding = 0;
settings.CommandColumn.CustomButtons.Add(btnDelete);
settings.CommandColumn.ButtonRenderMode = GridCommandButtonRenderMode.Button;
}
protected void gridLabEditing_DataBound(object sender, EventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
bool hasCol = (grid.Columns.IndexOf(grid.Columns["CommandColumnGroups"]) != -1) ? true : false;
if (hasCol)
{
grid.Columns.Remove(grid.Columns["CommandColumnGroups"]);
}
GridViewCommandColumn col = new GridViewCommandColumn();
col.Name = "CommandColumnGroups";
col.CellStyle.HorizontalAlign = HorizontalAlign.Left;
for (int i = 0; i < 8; i++)
{
GridViewCommandColumnCustomButton but = new GridViewCommandColumnCustomButton();
but.ID = String.Format("grp{0}", i);
but.Text = String.Format("grp{0}", i);
but.Styles.Native = true;
col.CustomButtons.Add(but);
}
grid.Columns.Add(col);
}
protected void grid_DataBound(object sender, EventArgs e)
{
//Check to see if these have been added
bool hasCol = (grid.Columns.IndexOf(grid.Columns["CommandColumnGroups"]) != -1) ? true : false;
if (hasCol)
{
grid.Columns.Remove(grid.Columns["CommandColumnGroups"]);
}
GridViewCommandColumn col = new GridViewCommandColumn();
col.Name = "CommandColumnGroups";
GridViewCommandColumnCustomButton but = new GridViewCommandColumnCustomButton();
but.ID = "btnImportFlds";
but.Text = "Import flds from NDAR";
but.Styles.Native = true;
but.Styles.Style.Font.Size = 10;
col.CustomButtons.Add(but);
grid.Columns.Add(col);
col.Index = 0;
}
protected virtual void CreateCommandButton(GridViewCommandColumnCustomButton button)
{
var eventArgs = new ASPxGridViewCustomButtonEventArgs(button, VisibleIndex, CellType, IsRowEditing);
Grid.RaiseCustomButtonInitialize_Internal(eventArgs);
switch (eventArgs.Visible)
{
case DefaultBoolean.False:
return;
case DefaultBoolean.Default:
if (button._IsVisible(CellType, IsRowEditing))
{
break;
}
return;
}
CreateCommandButtonSpacerIfNeeded();
ControlsContainer.Add(
new GridViewCommandColumnButtonControl(eventArgs, Grid, Scripts.GetCustomButtonFuncArgs, true)
);
}
/// <summary> 新增CommandColumn 按鈕 </summary>
/// <param name="setting"></param>
/// <param name="name"></param>
/// <param name="url"></param>
/// <returns></returns>
public static GridViewSettings GetButton(GridViewSettings setting, string name, string url)
{
GridViewCommandColumnCustomButton btn = new GridViewCommandColumnCustomButton();
btn.ID = name;
btn.Text = " ";
btn.Image.Url = url;
btn.Image.Width = 20;
setting.CommandColumn.CustomButtons.Add(btn);
return(setting);
}
/// <summary>
/// Создает кнопку сохранения текущего фильтра для грида.
/// </summary>
/// <param name="settings">Настройки.</param>
/// <param name="html">Текущий html хелпер.</param>
/// <param name="model">Модель данных.</param>
public static void CreateSaveCurrentFilterButton <TGridModel>(this GridViewSettings settings, GridModelBase model,
HtmlHelper <TGridModel> html)
where TGridModel : GridModelBase
{
var button = new GridViewCommandColumnCustomButton();
button.ID = model.GridName + "ShowSaveCurrentFilter";
button.Text = "Сохранить фильтр";
button.Visibility = GridViewCustomButtonVisibility.FilterRow;
button.Image.IconID = IconID.SaveSave16x16;
settings.CommandColumn.CustomButtons.Add(button);
var popupId = model.GridName + "FilterNamePopup";
settings.ClientSideEvents.CustomButtonClick = string.Format("function(s, e){{ {0}.Show(); }}", popupId);
settings.CustomJSProperties += (s, e) =>
{
e.Properties["cpFilterExpression"] = ((ASPxGridView)s).FilterExpression;
};
}
protected void dxgridSAM_DataBound(object sender, EventArgs e)
{
SQL_utils sql = new SQL_utils("backend");
DataTable dt_grps = sql.DataTable_from_SQLstring("select * from tblgroup where studyID=" + Master.Master_studyID.ToString());
sql.Close();
ASPxGridView grid = sender as ASPxGridView;
string prefix = GetPrefix(grid);
//Check to see if these have been added
bool hasCol = (grid.Columns.IndexOf(grid.Columns["CommandColumnGroups"]) != -1) ? true : false;
if (hasCol)
{
grid.Columns.Remove(grid.Columns["CommandColumnGroups"]);
}
GridViewCommandColumn col = new GridViewCommandColumn();
col.Name = "CommandColumnGroups";
foreach (DataRow row in dt_grps.Rows)
{
string groupID = row["groupID"].ToString();
string groupabbr = row["groupabbr"].ToString();
GridViewCommandColumnCustomButton but = new GridViewCommandColumnCustomButton();
but.ID = String.Format("{0}grp{1}", prefix, groupID);
but.Text = groupabbr;
but.Styles.Native = true;
col.CustomButtons.Add(but);
}
grid.Columns.Add(col);
}
private void SetGridView()
{
gdvDataList.DataSourceID = sqlDataSource.ID;
gdvDataList.KeyFieldName = "PartyID";
GridViewDataColumn column = null;
column = new GridViewDataColumn()
{
Name = "OrganizationCode",
FieldName = "OrganizationCode",
Caption = "บริษัทตัวแทน",
};
column.Settings.AutoFilterCondition = AutoFilterCondition.Contains;
column.Settings.FilterMode = ColumnFilterMode.DisplayText;
gdvDataList.Columns.Add(column);
column = new GridViewDataColumn()
{
Name = "Name",
FieldName = "Name",
Caption = "ชื่อ",
};
column.Settings.AutoFilterCondition = AutoFilterCondition.Contains;
column.Settings.FilterMode = ColumnFilterMode.DisplayText;
gdvDataList.Columns.Add(column);
if (ShowExpiredColumn)
{
column = new GridViewDataColumn()
{
Name = "EffectiveFrom",
FieldName = "EffectiveFrom",
Caption = ResGeneral.EffectiveFrom,
};
gdvDataList.Columns.Add(column);
column = new GridViewDataColumn()
{
Name = "EffectiveTo",
FieldName = "EffectiveTo",
Caption = ResGeneral.EffectiveTo,
};
gdvDataList.Columns.Add(column);
GridViewCommandColumn commandColumn = new GridViewCommandColumn()
{
ButtonType = ButtonType.Image
};
GridViewCommandColumnCustomButton customExpire = new GridViewCommandColumnCustomButton()
{
ID = "btnExpire" + gdvDataList.ID,
Text = ResGeneral.Expire,
};
customExpire.Image.Url = ResImageURL.Expire;
commandColumn.CustomButtons.Add(customExpire);
gdvDataList.ClientSideEvents.CustomButtonClick = @"function(s,e)
{
s.DeleteRow(e.visibleIndex);
}";
}
gdvDataList.Width = Unit.Percentage(100);
gdvDataList.SettingsBehavior.ColumnResizeMode = ColumnResizeMode.Control;
gdvDataList.SettingsPager.PageSize = 25;
gdvDataList.SettingsPager.AlwaysShowPager = true;
gdvDataList.Settings.ShowFilterRow = true;
gdvDataList.Settings.ShowFilterRowMenu = true;
gdvDataList.AutoGenerateColumns = false;
gdvDataList.HtmlRowCreated += new ASPxGridViewTableRowEventHandler(HandlerMethod.gdvItemListControl_HtmlRowCreated);
gdvDataList.ClientSideEvents.RowClick = @"function(s,e)
{
" + cbClickGdvRow.ClientInstanceName + @".SendCallback(e.visibleIndex);
" + popDataList.ClientInstanceName + @".Hide();
}";
}
protected virtual void CreateCommandButton(GridViewCommandColumnCustomButton button)
{
var eventArgs = new ASPxGridViewCustomButtonEventArgs(button, VisibleIndex, CellType, IsRowEditing);
Grid.RaiseCustomButtonInitialize_Internal(eventArgs);
switch (eventArgs.Visible)
{
case DefaultBoolean.False:
return;
case DefaultBoolean.Default:
if (button._IsVisible(CellType, IsRowEditing))
{
break;
}
return;
}
CreateCommandButtonSpacerIfNeeded();
ControlsContainer.Add(
new GridViewCommandColumnButtonControl(eventArgs, Grid, Scripts.GetCustomButtonFuncArgs, true)
);
}
protected override void SetDetailColumn()
{
GridViewEditDataColumn column;
GridViewCommandColumn commandColumn = new GridViewCommandColumn()
{
Name = "Action", Caption = "Action", ButtonType = ButtonType.Image
};
GridViewCommandColumnCustomButton btnView = new GridViewCommandColumnCustomButton()
{
ID = "btnView"
};
btnView.Image.Url = "~/Images/led_icon/view_detail.png";
btnView.Image.AlternateText = "View Detail";
btnView.Visibility = GridViewCustomButtonVisibility.BrowsableRow;
commandColumn.CustomButtons.Add(btnView);
detailGrid.Columns.Add(commandColumn);
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "ID", FieldName = "TransactionID",
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "หมายเลขธุรกรรม", FieldName = "TransactionNo",
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "ประเภทธุรกรรม", FieldName = "TransactionType",
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "รหัสบัญชีหน่วย", FieldName = "AccountNo",
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "กองทุน", FieldName = "FundCode"
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "จำนวนเงิน", FieldName = "Amount"
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "จำนวนหน่วย", FieldName = "Units"
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "ต้นทุน", FieldName = "UnitCost"
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "ราคาซื้อ", FieldName = "UnitPrice"
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "Applicable Amount", FieldName = "ApplicableAmount"
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "Applicable Units", FieldName = "ApplicableUnits"
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "ภาษี", FieldName = "TaxAmount"
});
column = new GridViewDataTimeEditColumn()
{
Caption = "งวดวันที่", FieldName = "TradeDate"
};
column.PropertiesEdit.DisplayFormatString = "dd MMM yyyy";
detailGrid.Columns.Add(column);
column = new GridViewDataTimeEditColumn()
{
Caption = "วันที่มีผล", FieldName = "EffectiveDate"
};
column.PropertiesEdit.DisplayFormatString = "dd MMM yyyy";
detailGrid.Columns.Add(column);
column = new GridViewDataTimeEditColumn()
{
Caption = "วันที่ทำธุรกรรม", FieldName = "TransactionTS"
};
column.PropertiesEdit.DisplayFormatString = "dd MMM yyyy HH:mm";
detailGrid.Columns.Add(column);
}
protected override void SetDetailColumn()
{
//GridViewEditDataColumn column;
GridViewCommandColumn commandColumn = new GridViewCommandColumn()
{
Name = "Action", Caption = "Action", ButtonType = ButtonType.Image
};
GridViewCommandColumnCustomButton btnView = new GridViewCommandColumnCustomButton()
{
ID = "btnView"
};
btnView.Image.Url = ResImageURL.Detail;
btnView.Image.AlternateText = "View Detail";
btnView.Visibility = GridViewCustomButtonVisibility.BrowsableRow;
commandColumn.ShowSelectCheckbox = true;
commandColumn.CustomButtons.Add(btnView);
detailGrid.Columns.Add(commandColumn);
detailGrid.Settings.ShowFilterRow = true;
detailGrid.Settings.ShowFilterRowMenu = true;
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "ID", FieldName = "TransactionID",
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "หมายเลขธุรกรรม", FieldName = "TransactionNo",
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "ประเภทธุรกรรม", FieldName = "TransactionType",
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "รหัสพนักงาน", FieldName = "AccountNo",
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "ชื่อพนักงาน", FieldName = "MemberName",
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "กองทุน", FieldName = "FundCode"
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "ประเภทเงิน", FieldName = "InvestmentCategory"
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "เงินสะสม", FieldName = "Amount"
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "หน่วยสะสม", FieldName = "Units"
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "เงินสมทบ", FieldName = "EmployerAmount"
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "หน่วยสมทบ", FieldName = "EmployerUnits"
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "ต้นทุน/หน่วย", FieldName = "UnitCost"
});
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "ราคาซื้อ", FieldName = "UnitPrice"
});
//detailGrid.Columns.Add(new GridViewDataTextColumn() { Caption = "Applicable Amount", FieldName = "ApplicableAmount" });
//detailGrid.Columns.Add(new GridViewDataTextColumn() { Caption = "Applicable Units", FieldName = "ApplicableUnits" });
detailGrid.Columns.Add(new GridViewDataTextColumn()
{
Caption = "ภาษี", FieldName = "TaxAmount"
});
//column = new GridViewDataTimeEditColumn() { Caption = "งวดวันที่", FieldName = "TradeDate" };
//column.PropertiesEdit.DisplayFormatString = "dd MMM yyyy";
//detailGrid.Columns.Add(column);
//column = new GridViewDataTimeEditColumn() { Caption = "วันที่มีผล", FieldName = "EffectiveDate" };
//column.PropertiesEdit.DisplayFormatString = "dd MMM yyyy";
//detailGrid.Columns.Add(column);
//column = new GridViewDataTimeEditColumn() { Caption = "วันที่ทำธุรกรรม", FieldName = "TransactionTS" };
//column.PropertiesEdit.DisplayFormatString = "dd MMM yyyy HH:mm";
//detailGrid.Columns.Add(column);
}
public static bool _IsVisible(this GridViewCommandColumnCustomButton source, GridViewTableCommandCellType cellType, bool isEditingRow)
{
return(GridViewCommandColumnCustomButtonMembersRepository.IsVisible.Invoke(source, cellType, isEditingRow));
}
