or
private
void
radSchedulerNavigator1_ShowWeekendStateChanged(
object
sender, StateChangedEventArgs args)
{
if
(
this
.radSchedulerDemo.ActiveView
as
SchedulerDayViewBaseView !=
null
)
{
(
this
.radSchedulerDemo.SchedulerElement.ViewElement
as
SchedulerDayViewElement).DataAreaElement.ScrollView.Value = Point.Empty;
(
this
.radSchedulerDemo.SchedulerElement.ViewElement
as
SchedulerDayViewElement).DataAreaElement.Table.ScrollToWorkHours();
}
}
foreach (GridViewRowInfo rowInfo in grdOrderlinesBase.Rows)
{
WebOrdersAppointGridView.MasterTemplate.AutoGenerateColumns =
true
;
WebOrdersAppointGridView.ShowGroupPanel =
true
;
WebOrdersAppointGridView.MasterTemplate.AllowEditRow =
true
;
WebOrdersAppointGridView.MasterTemplate.AutoExpandGroups =
true
;
WebOrdersAppointGridView.MasterTemplate.EnableFiltering =
true
;
WebOrdersAppointGridView.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
WebOrdersAppointGridView.MasterTemplate.EnableGrouping =
true
;
WebOrdersAppointGridView.MasterTemplate.AllowAddNewRow =
false
;
WebOrdersAppointGridView.MasterTemplate.AllowDragToGroup =
true
;
WebOrdersListGridView.TableElement.BeginUpdate();
WebOrdersAppointGridView.Rows.Clear();
// start read data
using
(MySqlDataReader dr = MySQLHelper.ExecuteReader(MySQLHelper.DBConnectionString, CommandType.Text, sqlText,
null
)) {
if
(!dr.HasRows) {
WebOrdersAppointGridView.TableElement.Text =
"no data to display"
;
return
;
}
else
{
WebOrdersAppointGridView.MasterTemplate.LoadFrom(dr);
}
}
WebOrdersAppointGridView.Columns[
"contact_id"
].HeaderText =
"NO."
;
WebOrdersAppointGridView.Columns[
"contact_id"
].TextAlignment = ContentAlignment.MiddleCenter;
WebOrdersAppointGridView.Columns[
"contact_id"
].Width = 70;
WebOrdersAppointGridView.Columns[
"username"
].HeaderText =
"姓名"
;
WebOrdersAppointGridView.Columns[
"username"
].Width = 150;
WebOrdersAppointGridView.Columns[
"telephone"
].HeaderText =
"联系电话"
;
WebOrdersAppointGridView.Columns[
"telephone"
].Width = 150;
WebOrdersAppointGridView.Columns[
"qq"
].HeaderText =
"联系QQ"
;
WebOrdersAppointGridView.Columns[
"qq"
].Width = 150;
WebOrdersAppointGridView.Columns[
"area_id"
].HeaderText =
"所在区域"
;
WebOrdersAppointGridView.Columns[
"area_id"
].DataType =
typeof
(
string
);
WebOrdersAppointGridView.Columns[
"area_id"
].Width = 150;
WebOrdersAppointGridView.Columns[
"address"
].HeaderText =
"所在地址"
;
WebOrdersAppointGridView.Columns[
"address"
].Width = 150;
WebOrdersAppointGridView.Columns[
"addtime"
].HeaderText =
"递交时间"
;
WebOrdersAppointGridView.Columns[
"addtime"
].TextAlignment = ContentAlignment.MiddleCenter;
WebOrdersAppointGridView.Columns[
"addtime"
].DataType =
typeof
(
string
);
WebOrdersAppointGridView.Columns[
"addtime"
].Width = 150;
WebOrdersListGridView.TableElement.EndUpdate();