public void BindingDataWithFilter(string username)
{
Permissions.BSL_PermissionsClient client = new Permissions.BSL_PermissionsClient();
Permissions.data_Permissions[] PermissionsList = client.GetPermissionByUser(username);
strPermission.DataSource = PermissionsList;
strPermission.DataBind();
BSL_GLXAccountClient AccountClient = new BSL_GLXAccountClient();
data_GLXAccount[] Companies = AccountClient.GetAll(username);
strGLXAccount.DataSource = Companies;
strGLXAccount.DataBind();
BSL_RequisitionWkshNameClient WkshClient = new BSL_RequisitionWkshNameClient();
data_RequisitionWkshName[] WkshList = WkshClient.GetDataByUser(username);
strWorksheet.DataSource = WkshList;
strWorksheet.DataBind();
BSL_LocationAndAccountClient LocationClient = new BSL_LocationAndAccountClient();
data_LocationAndAccount[] Locations = LocationClient.GetLocationByUser(username);
strLocationAndAccount.DataSource = Locations;
strLocationAndAccount.DataBind();
}
private void BindddXMProject2()
{
#region 项目名称绑定
//项目名称绑定--选取自运营项目
if (HozestERPContext.Current.User.CustomerID == 7 || HozestERPContext.Current.User.CustomerID == 84 || HozestERPContext.Current.User.CustomerID == 658 || HozestERPContext.Current.User.CustomerID == 682 || HozestERPContext.Current.User.CustomerID == 670)
{
ddXMProject2.Items.Clear();
var projectList = base.XMProjectService.GetXMProjectList();
Ext.Net.Store Store = ddXMProject2.GetStore();
projectList.Add(new XMProject()
{
ProjectName = "---所有---",
Id = -1,
});
Store.DataSource = projectList.OrderBy(a => a.Id);
Store.DataBind();
ddXMProject2.SelectedIndex = 0;
ddXMProject2.Value = "-1";
}
else
{
ddXMProject2.Items.Clear();
var projectList = base.XMProjectService.GetXMProjectListSS(HozestERPContext.Current.User.CustomerID, 0)
.GroupBy(p => new { p.Id, p.ProjectName })
.Select(p => new
{
Id = p.Key.Id,
ProjectName = p.Key.ProjectName
});
if (projectList.Count() == 0)
{
Ext.Net.ListItem liProject = new Ext.Net.ListItem();
liProject.Text = "---无项目权限---";
liProject.Value = "0";
ddXMProject2.Items.Add(liProject);
ddXMProject2.Value = 0;
}
else
{
Ext.Net.Store Store = ddXMProject2.GetStore();
Store.DataSource = projectList;
Store.DataBind();
ddXMProject2.SelectedIndex = 0;
ddXMProject2.Value = projectList.ToList()[0].Id;
}
Ext.Net.ListItem liProject1 = new Ext.Net.ListItem();
liProject1.Text = "---所有---";
liProject1.Value = "99";
ddXMProject2.Items.Add(liProject1);
ddXMProject2.Value = 99;
}
#endregion
this.ddXMProject2_SelectedIndexChanged(null, null);//店铺
}
public void BindDataComboBox()
{
using (GLXRequisitionWkshName.BSL_RequisitionWkshNameClient client = new GLXRequisitionWkshName.BSL_RequisitionWkshNameClient())
{
string comp = GlobalVariable.CompanyName;
string UserName = GlobalVariable.UserName;
IList <GLXRequisitionWkshName.data_RequisitionWkshName> BatchList = client.GetAll(comp, UserName);
strBatchs.DataSource = BatchList;
strBatchs.DataBind();
}
}
public void BindingDataWithFilter(string f, string t)
{
DateTime FDate;
DateTime TDate;
if (string.IsNullOrEmpty(f) || string.IsNullOrEmpty(t))
{
bookmarkKey = null;
FDate = dfFromDate.SelectedDate;
TDate = dfToDate.SelectedDate;
}
else
{
FDate = DateTime.Parse(f);
TDate = DateTime.Parse(t);
}
//if (TDate.AddMonths(-6) > FDate)
//{
// Ext.Net.X.Msg.Show(new MessageBoxConfig
// {
// Title = "Thông báo",
// Message = "Bạn vui lòng chọn lại ngày để xem. <br> Lưu ý: Thông tin chỉ được truy vấn trong vòng 6 tháng.",
// Icon = MessageBox.Icon.WARNING,
// Buttons = MessageBox.Button.OK
// });
//}
PurchaseOrderList.PurchaseOrderList_Service svc = new PurchaseOrderList.PurchaseOrderList_Service();
svc.Url = common.ReBuildUrl(svc.Url, GlobalVariable.CompanyName);
svc.Credentials = common.CheckCredentials();
List <PurchaseOrderList.PurchaseOrderList_Filter> ReqFilters = new List <PurchaseOrderList.PurchaseOrderList_Filter>();
PurchaseOrderList.PurchaseOrderList_Filter DocDateFilter = new PurchaseOrderList.PurchaseOrderList_Filter();
DocDateFilter.Field = PurchaseOrderList.PurchaseOrderList_Fields.Document_Date;
DocDateFilter.Criteria = String.Format("{0}..{1}", dfFromDate.SelectedDate.Date.ToString("MM/dd/yyyy"), dfToDate.SelectedDate.Date.ToString("MM/dd/yyyy"));
ReqFilters.Add(DocDateFilter);
PurchaseOrderList.PurchaseOrderList[] results = svc.ReadMultiple(ReqFilters.ToArray(), bookmarkKey, fetchSize);
List <PurchaseOrderList.PurchaseOrderList> POList = new List <PurchaseOrderList.PurchaseOrderList>();
while (results.Length > 0)
{
bookmarkKey = results.Last().Key;
POList.AddRange(results);
results = svc.ReadMultiple(ReqFilters.ToArray(), bookmarkKey, fetchSize);
}
strItems.DataSource = POList;
strItems.DataBind();
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
if (!Ext.Net.X.IsAjaxRequest)
{
this.ResourceManager.AddDirectMethodControl(this);
}
#region Load Company Info
Common common = new Common();
Companies.Companies_Service svc = new GLXNAVWebApp.Companies.Companies_Service();
svc.Credentials = common.CheckCredentials();
Companies.Companies[] results = svc.ReadMultiple(null, "", 20);
foreach (Companies.Companies item in results)
{
//if (item.Name == "GALAXY_MASTERDATA" || item.Name == "GALAXY_HCM" || item.Name == "GALAXY_BMT_COPY") continue;
cbgCinema.Add(new Checkbox {
ID = item.Name, BoxLabel = item.Name
});
cboCompanyCard.Items.Add(new ListItem {
Text = item.Name, Value = item.Name
});
}
#endregion Load Company Info
#region Load Location and Batch
List <LocationData> locations = GetLocation();
List <BatchData> batches = GetBatch();
foreach (LocationData item in locations)
{
cboLocation.Items.Add(new ListItem {
Text = item.Name, Value = item.Code
});
}
foreach (BatchData item in batches)
{
cboBatch.Items.Add(new ListItem {
Text = item.Name, Value = item.Code
});
}
#endregion Load Location and Batch
#region Load User
BSL_GLXAccountClient AccountClient = new BSL_GLXAccountClient();
data_Account[] AccountList = AccountClient.GetAllAccount(GlobalVariable.UserName);
strUsername.DataSource = AccountList;
strUsername.DataBind();
#endregion Load User
}
public void BindingDataWithFilter(string batch)
{
GLXNAVWebApp.ReqWorksheet.ReqWorksheet_Service svc = new GLXNAVWebApp.ReqWorksheet.ReqWorksheet_Service();
svc.Url = common.ReBuildUrl(svc.Url, GlobalVariable.CompanyName);
svc.Credentials = common.CheckCredentials();
//GLXNAVWebApp.ReqWorksheet.ReqWorksheet_Fields.
GLXNAVWebApp.ReqWorksheet.ReqWorksheet[] result = svc.ReadMultiple(batch, null, bookmarkKey, fetchSize);
List <GLXNAVWebApp.ReqWorksheet.ReqWorksheet> reqWorksheet = new List <GLXNAVWebApp.ReqWorksheet.ReqWorksheet>();
while (result.Length > 0)
{
bookmarkKey = result.Last().Key;
reqWorksheet.AddRange(result);
result = svc.ReadMultiple(batch, null, bookmarkKey, fetchSize);
}
strItems.DataSource = reqWorksheet;
strItems.DataBind();
}
protected override void CreateChildControls()
{
// Store
JsonReader jsonReader = new JsonReader();
jsonReader.IDProperty = "ID";
jsonReader.Fields.Add("ID");
jsonReader.Fields.Add("Title");
jsonReader.Fields.Add("IconUrl");
_store = new Store { ID = ID + "Store" };
_store.Reader.Add(jsonReader);
var items = GetItems();
if (!ExtNet.IsAjaxRequest)
{
_store.DataSource = items;
_store.DataBind();
}
Controls.Add(_store);
// Grid Panel
_gridPanel = new ChildrenEditorGridPanel { ID = ID + "GridPanel" };
_gridPanel.AddItemButtonClicked += OnGridPanelAddItemButtonClicked;
_gridPanel.ItemsRemoved += OnGridPanelItemsRemoved;
Controls.Add(_gridPanel);
_gridPanel.StoreID = _store.ID;
// Editor Windows
foreach (ContentItem contentItem in items)
AddEditorWindow(contentItem);
base.CreateChildControls();
}
private void InitModel()
{
if (this.ItemType != null)
{
Model item = new Model();
PropertyInfo[] infoArray2 = this.ItemType.GetProperties();
GridFilters filters = new GridFilters();
filters.MenuFilterText = "搜索";
filters.ID = "filters" + ID;
for (int i = 0; i < infoArray2.Length; i++)
{
Func<ColumnBase, bool> predicate = null;
PropertyInfo property = infoArray2[i];
ModelField field = new ModelField
{
Name = property.Name
};
#region 映射字段类型
string fullName = property.PropertyType.FullName;
if (fullName.Contains("System.Int"))
{
var enumDataTypeAttr = AttributeHelper.GetAttribute<EnumDataTypeAttribute>(property);
if (enumDataTypeAttr == null)
{
field.Type = ModelFieldType.Int;
}
}
else if (fullName.Contains("System.DateTime"))
{
field.Type = ModelFieldType.Date;
}
else if (fullName.Contains("System.Single"))
{
field.Type = ModelFieldType.Float;
}
else if (fullName.Contains("System.Boolean"))
{
field.Type = ModelFieldType.Boolean;
}
else if (fullName.Contains("System.String"))
{
field.Type = ModelFieldType.String;
}
else if (!property.PropertyType.IsPrimitive)
{
field.Type = ModelFieldType.Object;
}
else
{
field.Type = ModelFieldType.Auto;
}
#endregion
item.Fields.Add(field);
if (predicate == null)
{
predicate = x => x.DataIndex == property.Name;
}
ColumnBase column = this.ColumnModel.Columns.FirstOrDefault<ColumnBase>(predicate);
if (column == null)
{
ColumnBase base2;
DataGridColumnAttribute displayAttr = AttributeHelper.GetAttribute<DataGridColumnAttribute>(property);
FilterAttribute filterAttr = AttributeHelper.GetAttribute<FilterAttribute>(property);
bool simpleFilterable = filterAttr != null && filterAttr.Enabled && filterAttr.FilterType == null;
GridFilter filter = null;
#region 映射列类型
if (fullName.Contains("System.Int")
|| fullName.Contains("System.Single")
|| fullName.Contains("System.Decimal")
|| fullName.Contains("System.Double"))
{
NumberColumn column1 = new NumberColumn
{
Format = this.GetFormat(displayAttr, "0")
};
base2 = column1;
if (simpleFilterable && filterAttr.FilterType == null)
{
filter = new NumericFilter();
}
}
else if (fullName.Contains("System.DateTime"))
{
DateColumn column2 = new DateColumn
{
Format = this.GetFormat(displayAttr, "Y-m-d")
};
base2 = column2;
if (simpleFilterable)
{
filter = new DateFilter()
{
AfterText = "在这之后",
BeforeText = "在这之前",
OnText = "在这天"
};
}
}
else if (fullName.Contains("System.Boolean"))
{
string[] strArray = this.GetFormat(displayAttr, "是|否").Split(new char[] { '|' });
BooleanColumn column4 = new BooleanColumn
{
TrueText = strArray[0],
FalseText = strArray[1]
};
base2 = column4;
if (simpleFilterable)
{
filter = new BooleanFilter()
{
NoText = strArray[1],
YesText = strArray[0]
};
}
}
else if (fullName.Contains("System.String"))
{
base2 = new Column();
if (simpleFilterable)
{
filter = new StringFilter();
}
}
else if (!property.PropertyType.IsPrimitive)
{
base2 = new Column();
if (simpleFilterable)
{
filter = new StringFilter();
}
}
else
{
base2 = new Column();
if (simpleFilterable)
{
filter = new StringFilter();
}
}
#endregion
#region 生成外键过滤器
if (filterAttr != null && filterAttr.Enabled && filterAttr.FilterType != null)
{
Store store = new Store();
store.ID = "filterStore" + property.Name;
if (filterAttr.FilterType.IsEnum)
{
var valueType = filterAttr.FilterType;
var values = Enum.GetValues(valueType);
var names = Enum.GetNames(valueType);
List<KeyValueModel> enumDict = new List<KeyValueModel>();
for (int it = 0; it < values.Length; it++)
{
var fieldInfo = valueType.GetField(names[it]);
var descAttr = AttributeHelper.GetAttribute<DescriptionAttribute>(fieldInfo);
if (descAttr == null)
{
throw new Exception("枚举必须要有Description");
}
int key = (int)values.GetValue(it);
enumDict.Add(new KeyValueModel()
{
Id = key,
Name = descAttr.Description
});
}
Model model = new Model();
model.Fields.Add(new ModelField("Id", ModelFieldType.Int));
model.Fields.Add(new ModelField("Name", ModelFieldType.String));
store.Model.Add(model);
store.DataSource = enumDict;
store.DataBind();
filter = new ListFilter()
{
StoreID = store.ID,
Single = true,
IDField = "Id",
LabelField = "Name"
};
}
else
{
var filterObject = Activator.CreateInstance(filterAttr.FilterType);
var filterGen = filterObject as ForeignFilterBase;
if (filterGen == null)
{
throw new ArgumentException("FilterAttribute中的FilterType的类型必须为ForeignFilterBase的子类或枚举类型");
}
store.Model.Add(filterGen.GetModel());
store.DataSource = filterGen.GetData();
store.DataBind();
filter = new ListFilter()
{
StoreID = store.ID,
Single = true,
IDField = filterGen.IdField,
LabelField = filterGen.LabelField
};
}
Bin.Add(store);
}
#endregion
base2.Text = (displayAttr == null) ? property.Name : displayAttr.DisplayName;
base2.DataIndex = property.Name;
if (displayAttr != null && displayAttr.Width != -1)
base2.Width = displayAttr.Width;
if (displayAttr != null && displayAttr.ValueType != null)
{
Type valueType = displayAttr.ValueType;
var values = Enum.GetValues(valueType);
var names = Enum.GetNames(valueType);
Dictionary<int, string> enumDict = new Dictionary<int, string>();
List<string> valueList = new List<string>();
for (int it = 0; it < values.Length; it++)
{
var fieldInfo = valueType.GetField(names[it]);
var descAttr = AttributeHelper.GetAttribute<DescriptionAttribute>(fieldInfo);
int key = (int)values.GetValue(it);
enumDict.Add(key, descAttr.Description);
valueList.Add("values[\"" + names[it] + "\"]=\"" + (descAttr != null ? descAttr.Description : names[it]) + "\";");
}
base2.Renderer.Fn = "function(){var values=Array();" + string.Join(string.Empty, valueList) + "return values[arguments[0]];}";
}
if (filter != null)
{
filter.DataIndex = property.Name;
filters.Filters.Add(filter);
}
column = base2;
this.ColumnModel.Columns.Add(base2);
}
column.TabIndex = (short)i;
}
Features.Add(filters);
if (this.ColumnModel.Columns.Count >= 10)
{
this.AutoScroll = true;
}
var list = ColumnModel.Columns.OrderBy(x => x.TabIndex).ToList();
ColumnModel.Columns.Clear();
ColumnModel.Columns.AddRange(list);
this._store.Model.Add(item);
}
}
protected void loadgrid2(object sender, DirectEventArgs e)
{
var store = new Store { ID = "Store1" };
var reader = new JsonReader { IDProperty = "ID" };
reader.Fields.Add("ID", "Type", "Heji", "Biaodanhao", "Tijiao");
reader.Fields.Add(new RecordField
{
Name = "Level",
Convert = { Handler = "return ".ConcatWith(1, ";") }
});
store.Reader.Add(reader);
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Type");
dt.Columns.Add("Heji");
dt.Columns.Add("Biaodanhao");
dt.Columns.Add("Tijiao");
DataRow dr = dt.NewRow();
dr["ID"] = "10";
dr["Type"] = "差旅费";
dr["Heji"] = "100";
dr["Biaodanhao"] = "BJS1101";
dr["Tijiao"] = "2012-12-11";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = "11";
dr["Type"] = "通用费用";
dr["Heji"] = "1100";
dr["Biaodanhao"] = "BJS1112";
dr["Tijiao"] = "2012-12-21";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = "12";
dr["Type"] = "差旅费";
dr["Heji"] = "100";
dr["Biaodanhao"] = "BJS1123";
dr["Tijiao"] = "2012-12-31";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = "13";
dr["Type"] = "通用费用";
dr["Heji"] = "100";
dr["Biaodanhao"] = "BJS1134";
dr["Tijiao"] = "2012-11-11";
dt.Rows.Add(dr);
var grid = new GridPanel
{
ID = "Grid1",
Store = {
store
},
AutoScroll = true,
Border = false,
Title = "可按住Ctrl以多选,然后点击右侧"+"按钮向右侧添加数据.",
Height = 530
};
//build columns
grid.ColumnModel.Columns.Add(new RowNumbererColumn { Width = 25 });
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Biaodanhao", Header = "表单号" });
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Type", Header = "单据类型" });
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Heji", Header = "合计" });
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Tijiao", Header = "提交时间" });
grid.ColumnModel.ID = "Grid1_CM";
var view = new Ext.Net.GridView
{
ID = "Grid1_View",
ForceFit = true
};
grid.View.Add(view);
var sm = new RowSelectionModel { ID = "Grid1_SM" };
//sm.Listeners.BeforeRowSelect.Handler = "return false;";//合计类不允许选择
grid.SelectionModel.Add(sm);
// add expander for all levels except last (last level is 5)
view.Listeners.BeforeRefresh.Fn = "clean";
var re = new RowExpander
{
ID = "Grid1_RE",
EnableCaching = true,
Template = { ID = "Grid1_TPL", Html = "<div id=\"row_{ID}\" style=\"background-color:white;\"></div>" }
};
re.Listeners.BeforeExpand.Fn = "loadLevel";
grid.Plugins.Add(re);
Panel5.Items.Add(grid);
store.DataSource = dt;
store.DataBind();
grid.Listeners.ViewReady.Fn = "expangrid";
grid.Listeners.ViewReady.Single = true;
grid.Render();
//X.AddScript("expandallgrid();");
//re.ExpandAll();
//BuildLevel(int level, string recId, string gridId,string dtype)
//
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// if (dt.Rows[i]["Type"].ToString() == "差旅费")
// {
// var newgridid = "L2_" + dt.Rows[i]["ID"].ToString() + "_Grid";
// var store2 = new Store { ID = "L2_" + dt.Rows[i]["ID"].ToString() + "_Store" };
// var reader2 = new JsonReader { IDProperty = "ID" };
// reader.Fields.Add("ID", "Type", "Heji", "Biaodanhao", "Tijiao");
// reader.Fields.Add(new RecordField
// {
// Name = "Level",
// Convert = { Handler = "return ".ConcatWith(2, ";") }
// });
// store2.Reader.Add(reader2);
// DataTable dt2 = new DataTable();
// dt2.Columns.Add("ID");
// dt2.Columns.Add("Type");
// dt2.Columns.Add("Heji");
// dt2.Columns.Add("Biaodanhao");
// dt2.Columns.Add("Tijiao");
// Random ran = new Random();
// DataRow dr2 = dt2.NewRow();
// dr2["ID"] = dt.Rows[i]["ID"].ToString() + "0";
// dr2["Type"] = "票价合计";
// dr2["Heji"] = "120";
// dr2["Biaodanhao"] = (120 * Math.Round((decimal)ran.Next(1, 10), 1)).ToString();
// dr2["Tijiao"] = "2012-12-11";
// dt2.Rows.Add(dr2);
// dr2 = dt2.NewRow();
// dr2["ID"] = dt.Rows[i]["ID"].ToString() + "1";
// dr2["Type"] = "酒店";
// dr2["Heji"] = "120";
// dr2["Biaodanhao"] = (120 * Math.Round((decimal)ran.Next(1, 10), 1)).ToString();
// dr2["Tijiao"] = "2012-12-11";
// dt2.Rows.Add(dr2);
// dr2 = dt2.NewRow();
// dr2["ID"] = dt.Rows[i]["ID"].ToString() + "2";
// dr2["Type"] = "交通费";
// dr2["Heji"] = "120";
// dr2["Biaodanhao"] = (120 * Math.Round((decimal)ran.Next(1, 10), 1)).ToString();
// dr2["Tijiao"] = "2012-12-11";
// dt2.Rows.Add(dr2);
// dr2 = dt2.NewRow();
// dr2["ID"] = dt.Rows[i]["ID"].ToString() + "3";
// dr2["Type"] = "膳食费";
// dr2["Heji"] = "120";
// dr2["Biaodanhao"] = (120 * Math.Round((decimal)ran.Next(1, 10), 1)).ToString();
// dr2["Tijiao"] = "2012-12-11";
// dt2.Rows.Add(dr2);
// dr2 = dt2.NewRow();
// dr2["ID"] = dt.Rows[i]["ID"].ToString() + "4";
// dr2["Type"] = "机场费";
// dr2["Heji"] = "120";
// dr2["Biaodanhao"] = (120 * Math.Round((decimal)ran.Next(1, 10), 1)).ToString();
// dr2["Tijiao"] = "2012-12-11";
// dt2.Rows.Add(dr2);
// dr2 = dt2.NewRow();
// dr2["ID"] = dt.Rows[i]["ID"].ToString() + "5";
// dr2["Type"] = "其他";
// dr2["Heji"] = "120";
// dr2["Biaodanhao"] = (120 * Math.Round((decimal)ran.Next(1, 10), 1)).ToString();
// dr2["Tijiao"] = "2012-12-11";
// dt2.Rows.Add(dr2);
// dr2 = dt2.NewRow();
// dr2["ID"] = dt.Rows[i]["ID"].ToString() + "6";
// dr2["Type"] = "每日津贴";
// dr2["Heji"] = "120";
// dr2["Biaodanhao"] = (120 * Math.Round((decimal)ran.Next(1, 10), 1)).ToString();
// dr2["Tijiao"] = "2012-12-11";
// dt2.Rows.Add(dr2);
// var grid2 = new GridPanel
// {
// ID = newgridid,
// Store = {
// store2
// },
// AutoHeight = true,
// AutoScroll = true,
// EnableColumnMove = false,
// };
// //build columns
// grid2.ColumnModel.Columns.Add(new RowNumbererColumn { Width = 25 });
// grid2.ColumnModel.Columns.Add(new Column { DataIndex = "Type", Header = "费用类型", Resizable = false });
// grid2.ColumnModel.Columns.Add(new Column { DataIndex = "Heji", Header = "合计", Resizable = false });
// grid2.ColumnModel.Columns.Add(new Column { DataIndex = "Biaodanhao", Header = "公司预支", Resizable = false });
// grid2.ColumnModel.ID = newgridid + "_CM";
// var view2 = new Ext.Net.GridView
// {
// ID = newgridid+"_View",
// ForceFit = true
// };
// grid2.View.Add(view2);
// var sm2 = new RowSelectionModel { ID = newgridid+"_SM" };
// sm2.Listeners.BeforeRowSelect.Handler = "return false;";//合计类不允许选择
// grid2.SelectionModel.Add(sm2);
// // add expander for all levels except last (last level is 5)
// view2.Listeners.BeforeRefresh.Fn = "clean";
// var re2 = new RowExpander
// {
// ID = newgridid+"_RE",
// EnableCaching = true,
// Template = { ID = newgridid+"_TPL", Html = "<div id=\"row_{ID}\" style=\"background-color:white;\"></div>" }
// };
// //re2.Listeners.BeforeExpand.Fn = "loadLevel";
// grid2.Plugins.Add(re2);
// var renderEl2 = "row_" + dt.Rows[i]["ID"].ToString();
// X.Get(renderEl2).SwallowEvent(new string[] { "click", "mousedown", "mouseup", "dblclick" }, true);
// this.RemoveFromCache(newgridid, "Grid1");
// store2.DataSource = dt2;
// store2.DataBind();
// grid.Render(renderEl2, RenderMode.RenderTo);
// this.AddToCache(newgridid, "Grid1");
// }
//}
//if (1 == 1)
//{
// grid.Title = "可按住Ctrl以多选.";
// grid.Height = 400;
// grid.AutoHeight = false;
// grid.Border = false;
// //this.Form.Controls.Add(grid);
// Panel5.Html = "";
// Panel5.Items.Add(grid);
// //grid.Plugins.Add(new PanelResizer());
//}
//else
//{
//var renderEl = "row_" + recId;
//X.Get(renderEl).SwallowEvent(new string[] { "click", "mousedown", "mouseup", "dblclick" }, true);
//this.RemoveFromCache(newGridId, gridId);
//grid.Render(renderEl, RenderMode.RenderTo);
//this.AddToCache(newGridId, gridId);
//}
//
}
public void BuildLevel(int level, string recId, string gridId,string dtype)
{
var storeId = "L".ConcatWith(level, "_", recId, "_Store");
var newGridId = "L".ConcatWith(level, "_", recId, "_Grid");
// build store
var store = new Store { ID = storeId };
var reader = new JsonReader { IDProperty = "ID" };
reader.Fields.Add("ID", "Type", "Heji", "Biaodanhao", "Tijiao");
reader.Fields.Add(new RecordField
{
Name = "Level",
Convert = { Handler = "return ".ConcatWith(level, ";") }
});
store.Reader.Add(reader);
//store.CustomConfig.Add(new ConfigItem("level", level.ToString(), ParameterMode.Raw));
// bind store
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Type");
dt.Columns.Add("Heji");
dt.Columns.Add("Biaodanhao");
dt.Columns.Add("Tijiao");
if (level == 1)
{
DataRow dr = dt.NewRow();
dr["ID"] = "0";
dr["Type"] = "差旅费";
dr["Heji"] = "100";
dr["Biaodanhao"] = "BJS110" + level.ToString();
dr["Tijiao"] = "2012-12-11";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = "1";
dr["Type"] = "通用费用";
dr["Heji"] = "1100";
dr["Biaodanhao"] = "BJS111" + level.ToString();
dr["Tijiao"] = "2012-12-21";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = "2";
dr["Type"] = "差旅费";
dr["Heji"] = "100";
dr["Biaodanhao"] = "BJS112" + level.ToString();
dr["Tijiao"] = "2012-12-31";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = "3";
dr["Type"] = "通用费用";
dr["Heji"] = "100";
dr["Biaodanhao"] = "BJS113" + level.ToString();
dr["Tijiao"] = "2012-11-11";
dt.Rows.Add(dr);
}
else if(level == 2)
{
if (dtype == "差旅费")
{
Random ran = new Random();
DataRow dr = dt.NewRow();
dr["ID"] = recId + "20";
dr["Type"] = "票价合计";
dr["Heji"] = "120";
dr["Biaodanhao"] = (120 * Math.Round((decimal)ran.Next(1, 10), 1)).ToString();
dr["Tijiao"] = "2012-12-11";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = recId + "21";
dr["Type"] = "酒店";
dr["Heji"] = "120";
dr["Biaodanhao"] = (120 * Math.Round((decimal)ran.Next(1, 10), 1)).ToString();
dr["Tijiao"] = "2012-12-11";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = recId + "22";
dr["Type"] = "交通费";
dr["Heji"] = "120";
dr["Biaodanhao"] = (120 * Math.Round((decimal)ran.Next(1, 10), 1)).ToString();
dr["Tijiao"] = "2012-12-11";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = recId + "23";
dr["Type"] = "膳食费";
dr["Heji"] = "120";
dr["Biaodanhao"] = (120 * Math.Round((decimal)ran.Next(1, 10), 1)).ToString();
dr["Tijiao"] = "2012-12-11";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = recId + "24";
dr["Type"] = "机场费";
dr["Heji"] = "120";
dr["Biaodanhao"] = (120 * Math.Round((decimal)ran.Next(1, 10), 1)).ToString();
dr["Tijiao"] = "2012-12-11";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = recId + "25";
dr["Type"] = "其他";
dr["Heji"] = "120";
dr["Biaodanhao"] = (120 * Math.Round((decimal)ran.Next(1, 10), 1)).ToString();
dr["Tijiao"] = "2012-12-11";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = recId + "26";
dr["Type"] = "每日津贴";
dr["Heji"] = "120";
dr["Biaodanhao"] = (120 * Math.Round((decimal)ran.Next(1, 10), 1)).ToString();
dr["Tijiao"] = "2012-12-11";
dt.Rows.Add(dr);
}
else
{
DataRow dr = dt.NewRow();
dr = dt.NewRow();
dr["ID"] = recId + "20";
dr["Type"] = "交际费";
dr["Heji"] = "100";
dr["Biaodanhao"] = "BJS110" + level.ToString();
dr["Tijiao"] = "2012-12-11";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = recId + "21";
dr["Type"] = "交通费";
dr["Heji"] = "1100";
dr["Biaodanhao"] = "BJS111" + level.ToString();
dr["Tijiao"] = "2012-12-21";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = recId + "22";
dr["Type"] = "通讯费";
dr["Heji"] = "100";
dr["Biaodanhao"] = "BJS112" + level.ToString();
dr["Tijiao"] = "2012-12-31";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = recId + "23";
dr["Type"] = "其他费用";
dr["Heji"] = "100";
dr["Biaodanhao"] = "BJS113" + level.ToString();
dr["Tijiao"] = "2012-11-11";
dt.Rows.Add(dr);
}
}
else if (level == 3 && dtype != "差旅费")
{
for (int i = 0; i < 4; i++)
{
DataRow dr = dt.NewRow();
dr["ID"] = recId + "3" + i.ToString();
dr["Type"] = "其他费用";
dr["Heji"] = (100 + i).ToString();
dr["Biaodanhao"] = "费用描述";
dr["Tijiao"] = "2012-11-11";
dt.Rows.Add(dr);
}
}
//var data = new List<object>();
//for (int i = 1; i <= 9; i++)
//{
// data.Add(new { ID = recId.ConcatWith("_R", i), Biaodanhao = "Level".ConcatWith(level, ": Row " + i), Type = "Level".ConcatWith(level, ": Row " + i), Heji = "Level".ConcatWith(level, ": Row " + i), Tijiao = "Level".ConcatWith(level, ": Row " + i) });
//}
//build grid
var grid = new GridPanel
{
ID = newGridId,
Store = {
store
},
AutoHeight = true,
AutoScroll = true,
EnableColumnMove = level == 1,
};
//build columns
grid.ColumnModel.Columns.Add(new RowNumbererColumn { Width = 25 });
if (level==1)
{
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Biaodanhao", Header = "表单号" });
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Type", Header = "单据类型" });
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Heji", Header = "合计" });
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Tijiao", Header = "提交时间" });
}
else if(level == 2)
{
if (dtype == "差旅费")
{
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Type", Header = "费用类型", Resizable = false });
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Heji", Header = "合计", Resizable = false });
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Biaodanhao", Header = "公司预支", Resizable = false });
}
else
{
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Type", Header = "单据类型", Resizable = false });
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Heji", Header = "合计", Resizable = false });
}
}
else if (level == 3)
{
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Heji", Header = "金额", Resizable = false });
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Heji", Header = "费用描述", Resizable = false });
}
grid.ColumnModel.ID = newGridId + "_CM";
// build view
var view = new Ext.Net.GridView
{
ID = newGridId + "_View",
ForceFit = true
};
grid.View.Add(view);
// build selection model
var sm = new RowSelectionModel { ID = newGridId + "_SM" };
//if (level != 3 && dtype != "差旅费")
//{
// sm.Listeners.BeforeRowSelect.Handler = "return false;";//合计类不允许选择
//}
grid.SelectionModel.Add(sm);
RowExpander rem = new RowExpander();
// add expander for all levels except last (last level is 5)
if (level < 3 && dtype != "差旅费")
{
view.Listeners.BeforeRefresh.Fn = "clean";
var re = new RowExpander
{
ID = newGridId + "_RE",
EnableCaching = true,
Template = { ID = newGridId + "_TPL", Html = "<div id=\"row_{ID}\" style=\"background-color:white;\"></div>" }
};
re.Listeners.BeforeExpand.Fn = "loadLevel";
rem = re;
grid.Plugins.Add(re);
}
store.DataSource = dt;
store.DataBind();
if (level == 1)
{
grid.Title = "可按住Ctrl以多选.";
grid.Height = 400;
grid.AutoHeight = false;
grid.Border = false;
//this.Form.Controls.Add(grid);
Panel5.Html = "";
Panel5.Items.Add(grid);
//grid.Plugins.Add(new PanelResizer());
}
else
{
var renderEl = "row_" + recId;
X.Get(renderEl).SwallowEvent(new string[] { "click", "mousedown", "mouseup", "dblclick" }, true);
this.RemoveFromCache(newGridId, gridId);
if (level < 3)
{
grid.Listeners.ViewReady.Fn = "expangrid";
grid.Listeners.ViewReady.Single = true;
}
grid.Render(renderEl, RenderMode.RenderTo);
this.AddToCache(newGridId, gridId);
}
//string gl = newGridId;
////记录选择行的空间名
//if (level == 3 || (level == 2 && dtype == "差旅费"))
//{
// X.AddScript("var st=Hidden1.getValue();Hidden1.setValue(st+='" + gl + ",');");
// //X.AddScript("var st=TextField1.getValue();TextField1.setValue(st+='" + gl + ",');");
//}
}
public override void RenderView(System.Web.Mvc.ViewContext viewContext, System.IO.TextWriter writer)
{
RenderMain(writer);
var _formPanel = new ValidatedForm();
_formPanel.BodyPadding = 10;
_formPanel.Layout = "table";
_formPanel.Url = Url.Action("AddAccount");
_formPanel.LayoutConfig.Add(new TableLayoutConfig()
{
Columns = 2
});
_formPanel.ID = "addForm";
_formPanel.DefaultAnchor = "100%";
var _txtUsername = new TextField();
_txtUsername.ID = "txtUsername";
_txtUsername.Name = "Username";
_txtUsername.ColSpan = 1;
_txtUsername.Width = 300;
_txtUsername.AllowBlank = false;
_txtUsername.FieldLabel = "用户名";
_txtUsername.EmptyText = "输入用户名";
_formPanel.Add(_txtUsername);
var _comboStatus = new ComboBox();
_comboStatus.EmptyText = "选择状态";
_comboStatus.Name = "Status";
var _comboStatusStore = new Store();
_comboStatusStore.ID = "comboStoreStatus";
_comboStatus.AllowBlank = false;
_comboStatus.BlankText = "必须选择一个状态";
_comboStatusStore.Model.Add(ComponentHelper.GetModel(
new Dictionary<string, ModelFieldType>(){
{"Id",ModelFieldType.Int},{"Name",ModelFieldType.String}
}));
_comboStatus.ValueHiddenName = "Status";
_comboStatus.SimpleSubmit = true;
_comboStatus.DisplayField = "Name";
_comboStatus.ValueField = "Id";
_comboStatus.Store.Add(_comboStatusStore);
_comboStatus.FieldLabel = "状态";
_comboStatus.Editable = false;
_comboStatusStore.DataSource = EnumHelper.GetList(typeof(BaseStatuses), (k, v) =>
{
return new
{
Id = k,
Name = v
};
});
_comboStatusStore.DataBind();
_formPanel.Add(_comboStatus);
var _txtMemo = new TextArea();
_txtMemo.Width = 750;
_txtMemo.Name = "Description";
_txtMemo.ColSpan = 2;
_txtMemo.FieldLabel = "描述";
_txtMemo.Height = 80;
_formPanel.Add(_txtMemo);
var _treeRoleSelector = new TreePanelNodeMover();
_treeRoleSelector.LeftReadProxy.Url = Url.Action("GetNotAddedRoles");
_treeRoleSelector.RightReadProxy.Url = Url.Action("GetAddedRoles");
_treeRoleSelector.Height = 180;
_treeRoleSelector.Width = 750;
_treeRoleSelector.ColSpan = 2;
_treeRoleSelector.ID = "treeRoles";
_formPanel.Add(_treeRoleSelector);
_formPanel.Add(new Hidden()
{
Name = "RoleIds",
ID = "hdnRoleIds"
});
var _btnAdd = new Button();
_btnAdd.Text = "添加";
_btnAdd.Icon = Icon.Add;
_btnAdd.Handler = _treeRoleSelector.SyncAddedNodes("hdnRoleIds") + "App." + _formPanel.ID + ".submitData(function(r){if(r.success){" + HideWindowReloadGrid("gridUsers") + "}})";
_formPanel.Buttons.Add(_btnAdd);
writer.Write(_formPanel.ToBuilder().ToHtmlString());
}
public void BuildLevel(int level, string recId, string gridId)
{
var storeId = "L".ConcatWith(level, "_", recId, "_Store");
var newGridId = "L".ConcatWith(level, "_", recId, "_Grid");
// build store
var store = new Store { ID = storeId };
var reader = new JsonReader { IDProperty = "ID" };
reader.Fields.Add("ID", "Name");
reader.Fields.Add(new RecordField
{
Name = "Level",
Convert = { Handler = "return ".ConcatWith(level, ";") }
});
store.Reader.Add(reader);
store.CustomConfig.Add(new ConfigItem("level", level.ToString(), ParameterMode.Raw));
// bind store
var data = new List<object>();
for (int i = 1; i <= 9; i++)
{
data.Add(new { ID = recId.ConcatWith("_R", i), Name = "Level".ConcatWith(level, ": Row " + i) });
}
//build grid
var grid = new GridPanel
{
ID = newGridId,
Store = {
store
},
AutoHeight = true,
EnableColumnMove = level == 1
};
//build columns
grid.ColumnModel.Columns.Add(new RowNumbererColumn { Width = 25 });
if (level==1)
{
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Name", Header = "Name" });
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Name", Header = "Class" });
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Name", Header = "Class1" });
}
else
{
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Name", Header = "Name", Resizable = false });
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Name", Header = "Class", Resizable = false });
grid.ColumnModel.Columns.Add(new Column { DataIndex = "Name", Header = "Class1", Resizable = false });
}
grid.ColumnModel.ID = newGridId + "_CM";
// build view
var view = new Ext.Net.GridView
{
ID = newGridId + "_View",
ForceFit = true
};
grid.View.Add(view);
// build selection model
var sm = new RowSelectionModel { ID = newGridId + "_SM" };
if (level != 3)
{
sm.Listeners.BeforeRowSelect.Handler = "return false;";//合计类不允许选择
}
grid.SelectionModel.Add(sm);
// add expander for all levels except last (last level is 5)
if (level < 3)
{
view.Listeners.BeforeRefresh.Fn = "clean";
var re = new RowExpander
{
ID = newGridId + "_RE",
EnableCaching = true,
Template = { ID = newGridId + "_TPL", Html = "<div id=\"row_{ID}\" style=\"background-color:white;\"></div>" }
};
re.Listeners.BeforeExpand.Fn = "loadLevel";
grid.Plugins.Add(re);
}
store.DataSource = data;
store.DataBind();
if (level == 1)
{
grid.Title = "MultiLevel grid";
grid.Width = 600;
grid.Height = 600;
grid.AutoHeight = false;
//this.Form.Controls.Add(grid);
Container1.Items.Add(grid);
grid.Plugins.Add(new PanelResizer());
}
else
{
var renderEl = "row_" + recId;
X.Get(renderEl).SwallowEvent(new string[] { "click", "mousedown", "mouseup", "dblclick" }, true);
this.RemoveFromCache(newGridId, gridId);
grid.Render(renderEl, RenderMode.RenderTo);
this.AddToCache(newGridId, gridId);
}
}
protected void ddXMProject2_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddXMProject2.Value.ToString().Trim().Length > 0)
{
//店铺数据源
if (HozestERPContext.Current.User.CustomerID == 7 || HozestERPContext.Current.User.CustomerID == 84 || HozestERPContext.Current.User.CustomerID == 658)
{
var nickList = base.XMOrderInfoAPIService.GetXMNickList("", Convert.ToInt32(true), Convert.ToInt32(ddXMProject2.Value));
ddlNick2.Items.Clear();
Ext.Net.Store Store = ddlNick2.GetStore();
nickList.Add(new XMNick()
{
nick = "---所有---",
nick_id = -1,
});
Store.DataSource = nickList.OrderBy(a => a.nick_id);
Store.DataBind();
ddlNick2.SelectedIndex = 0;
if (!Page.IsPostBack)
{
ddlNick2.Value = "-1";
}
}
else
{
//其他
var nickList = base.XMOrderInfoAPIService.GetXMNickListSS("", Convert.ToInt32(true), Convert.ToInt32(ddXMProject2.Value), HozestERPContext.Current.User.CustomerID, 0);
ddlNick2.Items.Clear();
if (nickList.Count() == 0)
{
nickList.Add(new XMNick()
{
nick = "---无店铺权限---",
nick_id = 0,
});
Ext.Net.Store Store = ddlNick2.GetStore();
Store.DataSource = nickList;
Store.DataBind();
ddlNick2.SelectedIndex = 0;
if (!Page.IsPostBack)
{
ddlNick2.Value = "0";
}
}
else
{
if (nickList.Count() > 0)
{
nickList.Insert(0, new XMNick()
{
nick = "---所有---",
nick_id = 99,
});
Ext.Net.Store Store = ddlNick2.GetStore();
Store.DataSource = nickList;
Store.DataBind();
ddlNick2.SelectedIndex = 0;
if (!Page.IsPostBack)
{
ddlNick2.Value = "99";
}
}
}
}
}
}