private void LoadData()
{
int index = 0;
foreach (DataColumn dataCol in dataTable.Columns)
{
DevExpress.XtraGrid.Columns.GridColumn column = new DevExpress.XtraGrid.Columns.GridColumn();
column.AppearanceCell.Options.UseTextOptions = true;
if (dataCol.DataType.Name.IndexOf("STRING", StringComparison.OrdinalIgnoreCase) != -1)
{
column.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
column.DisplayFormat.FormatType = DevExpress.Utils.FormatType.None;
}
else
{
column.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
column.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
}
column.Caption = dataCol.Caption;
column.FieldName = dataCol.ColumnName;
column.Name = "datacol" + index.ToString();
column.Visible = true;
column.VisibleIndex = index;
this.grdView.Columns.Add(column);
index++;
}
grItems.DataSource = dataTable;
if (selectedDataRow != null)
{
grdView.FocusedRowHandle = grdView.GetRowHandle(dataTable.Rows.IndexOf(selectedDataRow));
}
}
private void setParentFormtxx(DbOpt.InFoDlg info_dlg)
{
if (info_dlg.dlgObj == null || info_dlg.dlgSqlMainWindow == null || info_dlg.dlgSqlMainWindow.Trim() == "")
{
return; //主窗口未传入的sql为空不操作
}
DevExpress.XtraGrid.Views.Grid.GridView gridview = (DevExpress.XtraGrid.Views.Grid.GridView)info_dlg.dlgObj;
DataTable dtParentTmp = (DataTable)gridview.GridControl.DataSource;
DataRow datarow = null;
if (info_dlg.dlgKind == DbOpt.OpenWindowKind.Open)
{
#region 找记录
dtParentTmp.PrimaryKey = new DataColumn[] { dtParentTmp.Columns["PATHWAY_ID"] };
datarow = dtParentTmp.Rows.Find(lbl_id.Text);
if (datarow == null)
{
return;
}
else
{
info_dlg.dlgdtPosition = dtParentTmp.Rows.IndexOf(datarow);
}
#endregion
}
else
{
datarow = dtParentTmp.NewRow();
}
if (datarow != null)
{
DataRow drCur = null;
DataTable dtTmp = DbOpt.GetDataTable(info_dlg.dlgSqlMainWindow + " and PATHWAY_ID='" + info_dlg.pKey1 + "'");
if (dtTmp.Rows.Count > 0)
{
drCur = dtTmp.Rows[0];
}
for (int i = 0; i < dtTmp.Columns.Count; i++)
{
datarow[i] = drCur[i];
}
if (info_dlg.dlgKind != DbOpt.OpenWindowKind.Open)
{
dtParentTmp.Rows.Add(datarow);
info_dlg.dlgdtPosition = dtParentTmp.Rows.IndexOf(datarow); //dtParentTmp.Rows.Count - 1;
//this.BindingContext[dtParentTmp].Position = info_dlg.dlgdtPosition;
}
int rowhandle = gridview.GetRowHandle(info_dlg.dlgdtPosition);
if (gridview.GetRowExpanded(rowhandle) == false)
{
gridview.ExpandAllGroups();
}
gridview.FocusedRowHandle = rowhandle;
}
}
private void DeleteSelectedRows(DevExpress.XtraGrid.Views.Grid.GridView view, int rowhandle)
{
if (view == null)
{
return;
}
view.DeleteRow(view.GetRowHandle(rowhandle));
view.RefreshData();
}
private void gridItemListView_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
GridView view = sender as GridView;
//int rowIndex = e.RowHandle;
if (e.Column.Name == "colRowNo")
{
int rowIndex = view.GetRowHandle(e.ListSourceRowIndex);
e.DisplayText = (rowIndex + 1).ToString();
}
}
private bool SelectRowByColumnValue(int columnNumber, string value)
{
if (value == null)
{
return(false);
}
var column = grdView.Columns[columnNumber];
for (int i = 0; i < grdView.RowCount; i++)
{
if (String.Equals(grdView.GetRowCellValue(i, column).ToString(), value, StringComparison.OrdinalIgnoreCase))
{
grdView.FocusedRowHandle = grdView.GetRowHandle(i);
const int pageSize = 17;
// 17 is page size.
// If select item from very first half of the page then do not do anything.
// if selected item is on the last page bottom half of the page then put last item at the bottom of the grid to make it full.
// Show selected item in the middle of the grid in mid pages.
if (grdView.FocusedRowHandle > (pageSize / 2) &&
grdView.RowCount > pageSize)
{
// Is last page bottom half?
if ((grdView.RowCount - (pageSize - 1) / 2) < grdView.FocusedRowHandle)
{
// fill last page.
grdView.TopRowIndex = grdView.RowCount - pageSize;
}
else
{
// show selected item in the middle.
grdView.TopRowIndex = grdView.FocusedRowHandle - pageSize / 2;
}
}
return(true);
}
}
return(false);
}
private void DeleteSelectedRows(DevExpress.XtraGrid.Views.Grid.GridView view, int rowhandle)
{
if (view == null)
{
return;
}
view.DeleteRow(view.GetRowHandle(rowhandle));
////int[] rows = gridView1.GetSelectedRows();
//int[] g = view.GetSelectedRows();
//DataRow[] rows = new DataRow[view.SelectedRowsCount];
//for (int i = 0; i < view.SelectedRowsCount; i++)
// rows[i] = view.GetDataRow(view.GetSelectedRows()[i]);
//view.BeginSort();
//try
//{
// foreach (DataRow row in rows)
// row.Delete();
//}
//finally
//{
// view.EndSort();
//}
view.RefreshData();
}
private void btnMemberCard_Print_Click(object sender, System.EventArgs e)
{
if (gridViewMemberCard.SelectedRowsCount != 0)
{
openFileDialog1.Filter = "Access Files ( *.mdb )| *.mdb";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
string s = openFileDialog1.FileName;
OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + s);
OleDbCommand aCommand = new OleDbCommand("Insert Into tblMemberCard(Membership_ID,Member_Name,Branch_ID) values (@Membership_ID,@Member_Name,@Branch_ID)", aConnection);
aCommand.Connection = aConnection;
aConnection.Open();
DataRow row = gridViewMemberCard.GetDataRow(gridViewMemberCard.FocusedRowHandle);
string MembershipId;
string MembershipName;
string BranchId;
int Id;
for (int i = 0; i < gridViewMemberCard.SelectedRowsCount; i++)
{
Id = Convert.ToInt32(gridViewMemberCard.GetSelectedRows().GetValue(i));
row = gridViewMemberCard.GetDataRow(gridViewMemberCard.GetRowHandle(Id));
MembershipId = (row["strMembershipId"]).ToString();
MembershipName = (row["strMemberName"]).ToString();
BranchId = (row["strBranchCode"]).ToString();
aCommand.Parameters.Add(new OleDbParameter("@Membership_ID", MembershipId));
aCommand.Parameters.Add(new OleDbParameter("@Member_Name", MembershipName));
aCommand.Parameters.Add(new OleDbParameter("@Branch_ID", BranchId));
aCommand.ExecuteNonQuery();
aCommand.Parameters.Clear();
int output;
output = 0;
SqlHelper.ExecuteNonQuery(connection, "up_tblCardRequest",
new SqlParameter("@retval", output),
new SqlParameter("@nStatusID", 1),
new SqlParameter("@dtLastEditDate", DateTime.Now),
new SqlParameter("@nEmployeeID", ((row["nEmployeeID"]).ToString()) == "" ? DBNull.Value.ToString() : (row["nEmployeeID"]).ToString()),
new SqlParameter("@nRequestID", (row["nRequestID"]).ToString())
);
// cmdToExecute.Parameters.Add(new SqlParameter("@" + column[i], (value[i]==null) ? DBNull.Value : value[i]));
SqlHelper.ExecuteNonQuery(connection, "up_tblMember",
new SqlParameter("@retval", output),
new SqlParameter("@nCardStatusID", 1),
new SqlParameter("@strCardBranchCode", "HQ"),
new SqlParameter("@strMembershipID", MembershipId)
);
}
MessageBox.Show("Print Successfully!", "Print Message");
MemberCardInit();
aConnection.Close();
}
}
else
{
MessageBox.Show("Please select at least one member!", "Print Message");
}
}
