private void BtnSave_Onclick(object sender, RoutedEventArgs e)
{
if (TabStyle != null)
{
switch (TabStyle.SelectedIndex)
{
case 0:
DetailGrid.CommitEdit();
// _viewModel.SaveDetailRow();
break;
case 1:
if (!_viewModel.Loading)
{
_viewModel.SaveSalesOrderOperationsList();
}
// _viewModel.SaveSalesOrderOperations();
break;
case 2:
SubEventGrid.CommitEdit();
break;
case 3:
_viewModel.SaveBom();
break;
}
}
}
void editForm_LoadControlComplete(object sender, EventArgs e)
{
DetailGrid grid = editForm.FindChildControl <DetailGrid>("OrderGrid");
if (grid != null)
{
grid.SetGridFix();
grid.ADGrid.Columns.ForEach(item =>
{
item.CanUserSort = false;
});
grid.ADGrid.Columns[2].HeaderStyle = null;
grid.ADGrid.Columns[2].HeaderStyle = Resources["activeStyle"] as Style;
//如果是公司预算管理员：则自己的公司不可以修改
if (IsFbAdmin == 1)
{
if (currentTreeViewItem != null)
{
OrderEntity entity = currentTreeViewItem.DataContext as OrderEntity;
string StrCompany = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
string SelectCompany = (entity.Entity as VirtualCompany).ID;
if (StrCompany == SelectCompany)
{
grid.ADGrid.Columns[2].IsReadOnly = true;
}
else
{
grid.ADGrid.Columns[2].IsReadOnly = false;
}
}
}
grid.ADGrid.Columns[3].Visibility = Visibility.Collapsed;
grid.ADGrid.Columns[4].Visibility = Visibility.Collapsed;
grid.ADGrid.Columns[5].Visibility = Visibility.Collapsed;
grid.ADGrid.Columns[6].Visibility = Visibility.Collapsed;
grid.ADGrid.Columns[7].Visibility = Visibility.Collapsed;
List <string> groups = new List <string> {
"Entity.T_FB_SUBJECT.T_FB_SUBJECTTYPE.SUBJECTTYPENAME"
};
grid.Groups = groups;
//活动经费处理
OrderEntity oe = grid.DataContext as OrderEntity;
oe.FBEntity.CollectionEntity.ForEach(p =>
{
p.FBEntities.ForEach(item =>
{
var v = item.Entity as T_FB_SUBJECTCOMPANY;
if (v != null && v.T_FB_SUBJECT.SUBJECTID == DataCore.SystemSetting.MONEYASSIGNSUBJECTID)
{
item.Entity.PropertyChanged += new System.ComponentModel.PropertyChangedEventHandler(DeatilEntity_PropertyChanged);
DeatilEntity_PropertyChanged(item.Entity, null);
}
});
});
}
}
protected void AddDetailGrid(Grid grid)
{
DetailGrid detail = new DetailGrid();
detail.ID = "grid" + level.ToString();
detail.AutoGenerateColumns = false;
detail.Serialize = false;
detail.AllowPageSizeSelection = false;
detail.AllowPaging = false;
detail.PageSize = -1;
detail.AllowAddingRecords = true;
detail.Width = Unit.Percentage(97);
detail.ForeignKeys = "CategoryID";
detail.ClientSideEvents.ExposeSender = true;
detail.ClientSideEvents.OnClientPopulateControls = "onPopulateControls";
detail.ClientSideEvents.OnBeforeClientDelete = "onBeforeClientDelete";
foreach (Column column in grid.Columns)
{
Column newColumn = column.Clone() as Column;
newColumn.SortOrder = SortOrderType.None;
detail.Columns.Add(newColumn);
}
detail.MasterDetailSettings = grid.MasterDetailSettings;
detail.DataSourceNeeded += Grid1_DataSourceNeeded;
detail.InsertCommand += Grid1_InsertCommand;
detail.UpdateCommand += Grid1_UpdateCommand;
detail.DeleteCommand += Grid1_DeleteCommand;
grid.DetailGrids.Add(detail);
}
/// <summary>
///
/// </summary>
/// <param name="synchronizationRoot"></param>
/// <returns></returns>
protected override DetailGrid CreateInstance(DetailGrid synchronizationRoot)
{
DataBoundDetailGrid grid = new DataBoundDetailGrid(this, synchronizationRoot);
//grid.SetDisplayManager(this.DisplayManager, this.GridName);
grid.DisplayManager = this.DisplayManager.Clone() as IDisplayManager;
grid.GridName = this.GridName;
grid.DisplayManager.BindingControls.Clear();
grid.DisplayManager.BindingControls.Add(grid);
ISearchManagerWithParent fm = grid.DisplayManager.SearchManager as ISearchManagerWithParent;
if (fm != null)
{
DataBoundDetailGrid parentGrid = this.ParentGrid as DataBoundDetailGrid;
if (parentGrid != null)
{
fm.ParentDisplayManager = parentGrid.DisplayManager;
}
}
// 模版能复制事件，其实为当新Instance事件触发时，也会调用模版的触发处理函数
return(grid);
}
void editForm_LoadControlComplete(object sender, EventArgs e)
{
EditForm editForm = sender as EditForm;
DetailGrid grid = editForm.FindChildControl <DetailGrid>("OrderGrid");
if (grid != null)
{
grid.SetGridFix();
grid.ADGrid.Columns.ForEach(item =>
{
item.CanUserSort = false;
});
grid.ADGrid.Columns[2].HeaderStyle = null;
grid.ADGrid.Columns[2].HeaderStyle = Resources["activeStyle"] as Style;
List <string> groups = new List <string> {
"Entity.T_FB_SUBJECT.T_FB_SUBJECTTYPE.SUBJECTTYPENAME"
};
grid.Groups = groups;
}
//初始化活动经费
BeginMoneyAssign(grid);
}
protected override void OnLoadControlComplete()
{
DetailGrid dGrid = this.EditForm.FindControl("OrderGrid") as DetailGrid;
if (dGrid != null && !this.EditForm.IsReInitForm)
{
dGrid.ToolBars[0].Title = "选择需要汇总的公司";
dGrid.AddToolBarItems(dGrid.ToolBars);
double width = dGrid.ADGrid.Columns[dGrid.ADGrid.Columns.Count - 1].Width.Value;
dGrid.ToolBarItemClick += new EventHandler <ToolBarItemClickEventArgs>(dGrid_ToolBarItemClick);
}
Grid grid = this.EditForm["DetailRemark"] as Grid;
if (grid != null)
{
grid.Height = 250;
StackPanel sp = new StackPanel();
sp.Children.Add(new TextBlock {
Text = "汇总提示：", FontSize = 12
});
sp.Children.Add(new TextBlock {
Text = "1.此功能可满足2级预算汇总功能，若未设置，即按单个公司生成月度预算汇总。", FontSize = 12
});
sp.Children.Add(new TextBlock {
Text = "2.设置的汇总人即最后一级汇总提交人", FontSize = 12
});
grid.Children.Add(sp);
}
}
private void DetailGrid_KeyUp(object sender, KeyEventArgs e)
{
if (e.Key == Key.Down)
{
var currentRowIndex = (_viewModel.SelectedMainRow.DetailsList.IndexOf(_viewModel.SelectedDetailRow));
if (currentRowIndex == (_viewModel.SelectedMainRow.DetailsList.Count - 1))
{
_viewModel.AddNewDetailRow(true);
DetailGrid.BeginEdit();
}
}
if (e.Key == Key.Delete && ModifierKeys.Shift == Keyboard.Modifiers)
{
if (!_viewModel.SelectedMainRow.Approved)
{
_viewModel.SelectedDetailRows.Clear();
foreach (var row in DetailGrid.SelectedItems)
{
_viewModel.SelectedDetailRows.Add((TblGlChequeTransactionDetailViewModel)row);
}
_viewModel.DeleteDetailRow();
}
}
try { } catch { }
}
protected void AddDetailGrid(Grid grid)
{
DetailGrid detail = new DetailGrid();
detail.ID = "grid" + level.ToString();
detail.AutoGenerateColumns = false;
detail.Serialize = false;
detail.AllowPageSizeSelection = false;
detail.AllowPaging = false;
detail.PageSize = -1;
detail.AllowAddingRecords = true;
detail.Width = Unit.Percentage(97);
detail.ForeignKeys = "CategoryID";
detail.ClientSideEvents.ExposeSender = true;
detail.ClientSideEvents.OnClientPopulateControls = "onPopulateControls";
detail.ClientSideEvents.OnBeforeClientDelete = "onBeforeClientDelete";
foreach (Column column in grid.Columns)
{
Column newColumn = column.Clone() as Column;
newColumn.SortOrder = SortOrderType.None;
detail.Columns.Add(newColumn);
}
detail.MasterDetailSettings = grid.MasterDetailSettings;
detail.DataSourceNeeded += Grid1_DataSourceNeeded;
detail.InsertCommand += Grid1_InsertCommand;
detail.UpdateCommand += Grid1_UpdateCommand;
detail.DeleteCommand += Grid1_DeleteCommand;
grid.DetailGrids.Add(detail);
}
/// <summary>
///
/// </summary>
/// <param name="synchronizationRoot"></param>
/// <returns></returns>
protected override DetailGrid CreateInstance(DetailGrid synchronizationRoot)
{
DataUnboundDetailGrid grid = new DataUnboundDetailGrid(this, synchronizationRoot);
//grid.SetDisplayManager(this.DisplayManager, this.GridName);
grid.DisplayManager = this.DisplayManager.Clone() as IDisplayManager;
grid.GridName = this.GridName;
grid.DisplayManager.BindingControls.Clear();
grid.DisplayManager.BindingControls.Add(grid);
// 如果parent还是DetailGrid，此时因为是从Template复制，ParentDisplayManager也为Tempalte的Parent，
// 应该是从具体的Parent DetailGrid里来
ISearchManagerWithParent smp = grid.DisplayManager.SearchManager as ISearchManagerWithParent;
if (smp != null)
{
DataBoundDetailGrid parentGrid = this.ParentGrid as DataBoundDetailGrid;
if (parentGrid != null)
{
smp.ParentDisplayManager = parentGrid.DisplayManager;
}
}
return(grid);
}
void SimpleSelect(int R) {
try {
DetailGrid.Select(R);
}
catch {
}
}
/// <summary>
/// Crea una nuova riga e legge le righe del raggruppamento corrente in spesaview
/// </summary>
private void CollegaRigheADocumento(bool quiet) {
if (TempTable==null || TempTable.Rows.Count == 0) {
if (!quiet) MessageBox.Show("Non ci sono anagrafiche da processare");
btnSuccessivo.Enabled = false;
grpConferma.Enabled = false;
return;
}
DataRow CurrRow = TempTable.Rows[0];
DS.registrymainview.Clear();
ctrl.GetFormData(true);
string field = (rdoCF.Checked) ? "cf" : "p_iva";
string filter = QHS.AppAnd(QHS.MCmp(CurrRow, new string [] {"idregistryclass", field}),
QHS.CmpNe("multi_cf", 'S'));
if (!chkNonAttive.Checked) filter = QHS.AppAnd(filter, QHS.NullOrEq("active", 'S'));
if (cmbRegistryClass.SelectedIndex > 0)
filter = QHS.AppAnd(filter, QHS.CmpEq("idregistryclass", cmbRegistryClass.SelectedValue));
DataAccess.RUN_SELECT_INTO_TABLE(conn as DataAccess, DS.registrymainview,
"title ASC," + field + " ASC",
filter,
null, false);
MetaData.FreshForm(this, false);
// Seleziono solo la prima riga (in previsione che l'utente voglia cliccare sul bottone Attiva una sola anagrafica
if (DS.registrymainview.Rows.Count == 0) return;
btnMultiCF.Enabled = (DS.registrymainview.Select(QHC.CmpEq("idregistryclass", "22")).Length == 0);
DetailGrid.Select(0);
}
private void ColumnManageCell_MouseDown(object sender, MouseEventArgs e)
{
Cell cell = (Cell)sender;
GridInfo gridInfo = ADInfoBll.Instance.GetGridInfo(m_grid.GridName);
if (!Authority.AuthorizeByRule(gridInfo.AllowInnerMenu) && !Authority.IsDeveloper())
{
return;
}
if (e.Button == MouseButtons.Right)
{
// DetailGrid只是从DetailGridTemplate复制，Constructor里的grid只是模版
DetailGrid detailGrid = ((Xceed.Grid.ColumnManagerCell)sender).ParentGrid;
if (detailGrid is DataBoundDetailGrid)
{
m_grid = detailGrid as DataBoundDetailGrid;
}
m_contextMenuManagerColumnCell = cell;
contextMenuStrip2.Show(cell.PointToScreen(new System.Drawing.Point(e.X, e.Y)));
}
else
{
m_contextMenuManagerColumnCell = null;
}
}
private void ExportExcel_Click(object sender, RoutedEventArgs e)
{
if (TabStyle != null)
{
switch (TabStyle.SelectedIndex)
{
case 0:
//_viewModel.GetDetaildataFull(DetailGrid);
DetailGrid.ExportExcel("Po");
break;
case 1:
SalesOrderOperationGrid.ExportExcel("Operations Colors");
break;
case 2:
SubEventGrid.ExportExcel("Sample Event");
break;
case 3:
BomGrid.ExportExcel("Bom");
break;
}
}
}
void unifica(bool stepForward){
string dataMember = DetailGrid.DataMember;
CurrencyManager cm = DetailGrid.BindingContext[DS, dataMember] as CurrencyManager;
if (cm == null) return;
DataView view = cm.List as DataView;
if (view == null) {
MessageBox.Show(this, "Selezionare una anagrafica");
return;
}
int numRigheSel;
DataRow RowSelected;
RowSelected = null;
object idregSelected;
idregSelected = DBNull.Value;
numRigheSel = 0;
for (int i = 0; i < view.Count; i++) {
if (DetailGrid.IsSelected(i)) {
DataRow R = GetGridRow(i);
if (R == null) continue;
numRigheSel++;
RowSelected = R;
}
}
if (!(numRigheSel == 1)) {
MessageBox.Show(this, "Selezionare un'anagrafica");
return;
}
if (!(RowSelected == null)) {
idregSelected = RowSelected["idreg"];
}
for (int i = 0; i < view.Count; i++) {
object idreg = view[i].Row["idreg"];
string filter = QHC.CmpEq("idreg", idreg);
DataRow[] Registry = DS.registrymainview.Select(filter);
if (Registry.Length == 0) {
MessageBox.Show(this, "Errore, griglia e tabella dati disallineate! Contattare il settore assistenza");
return;
}
DataRow r = Registry[0];
// N.B. Imposto toredirect a idreg esplicitamente nel caso ci siano ancora anagrafiche non attivate
if (!(DetailGrid.IsSelected(i))) {
r["active"] = "N";
r["toredirect"] = idregSelected;
}
}
if (saveData()) {
MessageBox.Show(this, "Anagrafiche aggiornate");
btnSuccessivo.Enabled = true;
if (stepForward) btnSuccessivo_Click(null, null);
}
else {
grpConferma.Enabled = true;
btnSuccessivo.Enabled = false;
}
}
private void DetailsApply()
{
if (!String.IsNullOrEmpty(CurrentCategoryID))
{
DetailSource.SelectParameters["CategoryID"].DefaultValue = CurrentCategoryID;
DetailGrid.DataBind();
}
}
void deatilGridBar_ItemClicked(object sender, ToolBar.ToolBarItemClickArgs e)
{
if (e.Key == "S1")
{
this.SumType = 0;
}
else
{
this.SumType = 1;
}
//this.InitData();
DetailGrid grid = this.EditForm.FindControl("OrderGrid") as DetailGrid;
if (grid != null)
{
if (this.SumType == 0)
{
int i = 1;
if (grid.ADGrid.Columns[0].GetType() == typeof(DataGridIconColumn))
{
i = 2;
}
grid.ADGrid.Columns[i - 1].Visibility = Visibility.Visible;
grid.ADGrid.Columns[i].Visibility = Visibility.Visible;
grid.ADGrid.Columns[i + 3].Visibility = Visibility.Visible;
grid.ADGrid.Columns[i + 1].Visibility = Visibility.Collapsed;
grid.ADGrid.Columns[i + 2].Visibility = Visibility.Collapsed;
grid.ADGrid.Columns[i + 4].Visibility = Visibility.Collapsed;
grid.ADGrid.Columns[i + 5].Visibility = Visibility.Collapsed;
grid.ItemsSource = this.OrderEntity.GetRelationFBEntities(typeof(V_SubjectCompanySum).Name);
}
else
{
int i = 1;
if (grid.ADGrid.Columns[0].GetType() == typeof(DataGridIconColumn))
{
i = 2;
}
grid.ADGrid.Columns[i - 1].Visibility = Visibility.Collapsed;
grid.ADGrid.Columns[i].Visibility = Visibility.Collapsed;
grid.ADGrid.Columns[i + 2].Visibility = Visibility.Visible;
grid.ADGrid.Columns[i + 1].Visibility = Visibility.Visible;
grid.ADGrid.Columns[i + 3].Visibility = Visibility.Visible;
grid.ADGrid.Columns[i + 4].Visibility = Visibility.Visible;
if ((this.EditForm.OperationType == OperationTypes.Add ||
this.EditForm.OperationType == OperationTypes.Edit ||
this.EditForm.OperationType == OperationTypes.ReSubmit))
{
grid.ADGrid.Columns[i + 5].Visibility = Visibility.Visible;
}
grid.ItemsSource = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_COMPANYBUDGETSUMDETAIL).Name);
}
}
}
//protected void preambleLists_SelectedIndexChanged(object sender, EventArgs e)
//{
// try
// {
// var selectedQtype = long.Parse(DropDownList1.SelectedValue);
// var QType = _db.T_Question.Select(s => s.PreambleId).Distinct();
// var Qt = _db.T_QuestionTypes.FirstOrDefault(s => s.Id == selectedQtype);
// var QTypeCount = QType.Count();
// var QTC = QTypeCount++;
// var selectedpreamble = long.Parse(preambleLists.SelectedValue);
// if (selectedpreamble == 0)
// {
// PreambleName.Text = Qt.Name + " " + QTC;
// preambleText.Text = "";
// PreamblePreview.Text = "";
// preview.Visible = false;
// preambleRow.Visible = true;
// preambleNameRow.Visible = true;
// }
// else if (selectedpreamble != -1 && selectedpreamble != 0)
// {
// var id = QPid.Value;
// if (!(string.IsNullOrEmpty(id)))
// {
// var preamble = _db.T_QuestionPreamble.FirstOrDefault(s => s.Id == selectedpreamble);
// PreamblePreview.Text = "";
// PreambleNamePreview.Text = "";
// preview.Visible = false;
// QPid.Value = preamble.Id.ToString();
// PreambleName.Text = preamble.Name;
// preambleText.Text = preamble.Body;
// preambleNameRow.Visible = true;
// preambleRow.Visible = true;
// }
// else
// {
// var preamble = _db.T_QuestionPreamble.FirstOrDefault(s => s.Id == selectedpreamble);
// PreambleName.Text = "";
// preambleText.Text = "";
// preambleNameRow.Visible = false;
// preambleRow.Visible = false;
// PreambleNamePreview.Text = preamble.Name;
// PreamblePreview.Text = preamble.Body;
// preview.Visible = true;
// }
// }
// else
// {
// PreambleName.Text = "";
// preambleText.Text = "";
// PreamblePreview.Text = "";
// PreambleNamePreview.Text = "";
// preview.Visible = false;
// preambleNameRow.Visible = false;
// preambleRow.Visible = false;
// }
// }
// catch (Exception ex)
// {
// ErecruitHelper.SetErrorData(ex, Session);
// Response.Redirect("ErrorPage.aspx", false);
// }
//}
protected void PreviewUpload_Click(object sender, EventArgs e)
{
var tenantId = long.Parse(SessionHelper.GetTenantID(HttpContext.Current.Session));
HttpPostedFile file = QuestionFile.PostedFile;
if (file != null && file.ContentLength > 0)
{
string fname = Path.GetFileName(file.FileName);
string fullFilePath = Path.GetFullPath(file.FileName);
string ext = System.IO.Path.GetExtension(file.FileName);
string fileID = Guid.NewGuid().ToString();
string path = "";
// var all = new List<string[]>();
if (Directory.Exists(Server.MapPath("~/UploadedQuestions/")))
{
path = Server.MapPath(Path.Combine("~/UploadedQuestions/", fileID + ext));
// PPath = Path.Combine("~/Passports/", cand.Code + ext);
file.SaveAs(path);
}
else
{
Directory.CreateDirectory(Server.MapPath("~/UploadedQuestions/"));
path = Server.MapPath(Path.Combine("~/UploadedQuestions/", fileID + ext));
// PPath = Path.Combine("~/Passports/", cand.Code + ext);
file.SaveAs(path);
}
var data = File.ReadAllBytes(path);
ImportFromExcel import = new ImportFromExcel();
if (ext == ".xls")
{
import.LoadXls(data);
}
else if (ext == ".xlsx")
{
import.LoadXlsx(data);
}
//first parameter it's the sheet number in the excel workbook
//second paramter it's the number of rows to skip at the start(we have an header in the file)
List <QuestionUploadModel> all = import.ExcelToList <QuestionUploadModel>(0, 1);
var obj = new List <object>();
foreach (var s in all)
{
obj.Add(new { Question = s.Question, Section = s.Section, A = s.A, B = s.B, C = s.C, D = s.D, E = s.E, Answer = s.Answer });
}
DetailGrid.DataSource = obj;
DetailGrid.DataBind();
ViewActiveTitle.Value = "Import Preview";
ViewActive.Value = "1";
FileID.Value = path;
EXT.Value = ext;
resultLbl.Text = "";
//}
// QuestionFile.Value = fullFilePath;
}
}
protected override void OnLoadControlComplete()
{
DetailGrid grid = this.EditForm.FindControl("OrderGrid") as DetailGrid;
if (grid != null)
{
grid.CheckSame = CheckSameSubject;
}
this.OrderEntity.ReferencedData["Entity.REPAYTYPE"] = DataCore.FindRefData("BorrowTypeData", 1);
}
private void btnAttivo_Click(object sender, EventArgs e) {
string dataMember = DetailGrid.DataMember;
CurrencyManager cm = DetailGrid.BindingContext[DS, dataMember] as CurrencyManager;
if (cm == null) return;
DataView view = cm.List as DataView;
if (view == null) {
MessageBox.Show(this, "Selezionare una anagrafica");
return;
}
int numRigheSel;
numRigheSel = 0;
for (int i = 0; i < view.Count; i++) {
if (DetailGrid.IsSelected(i)) {
DataRow R = GetGridRow(i);
if (R == null) continue;
numRigheSel++;
}
}
if (!(numRigheSel == 1)) {
MessageBox.Show(this, "Selezionare un'anagrafica");
return;
}
for (int i = 0; i < view.Count; i++) {
object idreg = view[i].Row["idreg"];
string filter = QHC.CmpEq("idreg", idreg);
DataRow[] Registry = DS.registrymainview.Select(filter);
if (Registry.Length == 0) {
MessageBox.Show(this, "Errore, griglia e tabella dati disallineate! Contattare il settore assistenza");
return;
}
DataRow r = Registry[0];
// N.B. Imposto anche active a S esplicitamente nel caso ci siano ancora anagrafiche con active a NULL
r["active"] = (DetailGrid.IsSelected(i)) ? "S" : "N";
}
if (saveData()) {
MessageBox.Show(this, "Anagrafiche aggiornate");
//TempTable.Rows.RemoveAt(0);//questo codice sarà eseguito in btnSuccessivo_Click()
//TempTable.AcceptChanges();
//grpConferma.Enabled = false;
btnSuccessivo.Enabled = true;
btnSuccessivo_Click(sender, e);
}
else {
grpConferma.Enabled = true;
btnSuccessivo.Enabled = false;
}
}
private void ExportExcel_Click(object sender, RoutedEventArgs e)
{
if (_viewModel.SelectedDetailRow != null && _viewModel.SelectedDetailRow.Iserial != 0)
{
DetailGrid.ExportExcel("SubFamily");
}
else
{
MainGrid.ExportExcel("Family");
}
}
protected override void OnLoadControlComplete()
{
DetailGrid grid = this.EditForm.FindControl("OrderGrid") as DetailGrid;
if (grid != null)
{
grid.CheckSame = CheckSameSubject;
}
this.OrderEntity.OrderPropertyChanged += new EventHandler <OrderPropertyChangedArgs>(OrderEntity_OrderPropertyChanged);
this.OrderEntity.CollectionEntityChanged += new EventHandler <EntityChangedArgs>(OrderEntity_CollectionEntityChanged);
}
private void SetSortDetails()
{
var details = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_SUMSETTINGSDETAIL).Name);
DetailGrid dgrid = this.EditForm.FindControl("OrderGrid") as DetailGrid;
if (dgrid != null)
{
dgrid.ClearValue(DetailGrid.ItemsSourceProperty);
dgrid.ItemsSource = details;
}
}
public IControlAction GetUIElement()
{
DetailGrid adg = new DetailGrid();
// adg.GridItems = this.GridItems;
if (ShowToolBar == "false")
{
adg.ShowToolBar = false;
}
adg.OrderDetailGridInfo = this;
return(adg);
}
public decimal CalculateDiscountPorcentage(DetailGrid row, decimal discount)
{
if (row.Subtotal != null)
{
row.Descuento = discount;
//row.Subtotal = ((row.PrecioVenta * Convert.ToInt16(row.Cantidad)) - discount).ToString("F");
row.Porcentage = (discount / Convert.ToDecimal(row.Subtotal));
return(row.Porcentage);
}
return(row.Porcentage);
}
private bool CheckGridAsc(DetailGrid currentGrid, int startx, int starty)
{
for (int j = starty; j < currentGrid.Columns.Count; ++j)
{
if (CheckCellValue(currentGrid.DataRows[startx].Cells[j]))
{
SetCurrentCell(currentGrid.DataRows[startx].Cells[j]);
return(true);
}
if (CheckDetailGridAsc(currentGrid.DataRows[startx]))
{
return(true);
}
}
// 只有当前行搜索DetailGrid
//if (CheckDetailGridAsc(currentGrid.DataRows[startx]))
// return true;
//Xceed.Grid.Collections.ReadOnlyDataRowList list = m_grid.GetSortedDataRows(false);
for (int i = startx + 1; i < currentGrid.DataRows.Count; ++i)
{
for (int j = 0; j < currentGrid.Columns.Count; ++j)
{
if (CheckCellValue(currentGrid.DataRows[i].Cells[j]))
{
SetCurrentCell(currentGrid.DataRows[i].Cells[j]);
return(true);
}
}
if (CheckDetailGridAsc(currentGrid.DataRows[i]))
{
return(true);
}
}
if (currentGrid.ParentGrid != null)
{
int newx = currentGrid.ParentDataRow.Index + 1;
int newy = 0;
if (newx < currentGrid.ParentDataRow.ParentGrid.DataRows.Count)
{
if (CheckGridAsc(currentGrid.ParentGrid, newx, newy))
{
return(true);
}
}
}
return(false);
}
public void SortGrid(Object sender, GridViewSortEventArgs e)
{
// Create a DataView from the DataTable.
DataView dv = new DataView(dtTableContents);
// The DataView provides an easy way to sort. Simply set the
// Sort property with the name of the field to sort by.
dv.Sort = e.SortExpression;
// Re-bind the data source and specify that it should be sorted
// by the field specified in the SortExpression property.
DetailGrid.DataSource = dv;
DetailGrid.DataBind();
}
protected override void OnLoadControlComplete()
{
DetailGrid dGrid = this.EditForm.FindControl("OrderGrid") as DetailGrid;
if (dGrid != null && !this.EditForm.IsReInitForm)
{
double width = dGrid.ADGrid.Columns[dGrid.ADGrid.Columns.Count - 1].Width.Value;
dGrid.ToolBarItemClick += new EventHandler <ToolBarItemClickEventArgs>(dGrid_ToolBarItemClick);
dGrid.LoadRowDetailComplete += new EventHandler <ActionCompletedEventArgs <UIElement> >(dGrid_LoadRowDetailComplete);
}
this.OrderEntity.OrderPropertyChanged += new EventHandler <OrderPropertyChangedArgs>(OrderEntity_OrderPropertyChanged);
this.OrderEntity.CollectionEntityChanged += new EventHandler <EntityChangedArgs>(OrderEntity_CollectionEntityChanged);
}
private bool CheckGridDesc(DetailGrid currentGrid, int startx, int starty)
{
for (int j = starty; j >= 0; --j)
{
if (CheckDetailGridDesc(currentGrid.DataRows[startx]))
{
return(true);
}
if (CheckCellValue(currentGrid.DataRows[startx].Cells[j]))
{
SetCurrentCell(currentGrid.DataRows[startx].Cells[j]);
return(true);
}
}
//if (CheckDetailGridDesc(currentGrid.DataRows[startx]))
// return true;
for (int i = startx - 1; i >= 0; --i)
{
if (CheckDetailGridDesc(currentGrid.DataRows[i]))
{
return(true);
}
for (int j = currentGrid.Columns.Count - 1; j >= 0; --j)
{
if (CheckCellValue(currentGrid.DataRows[i].Cells[j]))
{
SetCurrentCell(currentGrid.DataRows[i].Cells[j]);
return(true);
}
}
}
if (currentGrid.ParentGrid != null)
{
int newx = currentGrid.ParentDataRow.Index - 1;
int newy = currentGrid.ParentDataRow.ParentGrid.Columns.Count - 1;
if (newx >= 0)
{
if (CheckGridDesc(currentGrid.ParentGrid, newx, newy))
{
return(true);
}
}
}
return(false);
}
private void GroupData()
{
// ObservableCollection<FBEntity> listDetail = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_COMPANYBUDGETMODDETAIL).Name);
DetailGrid grid = this.EditForm.FindControl("OrderGrid") as DetailGrid;
if (grid != null)
{
grid.Groups = new List <string>()
{
"Entity.OwnerDepartmentName"
};
}
}
private void btnSpecialAction_Click(object sender, EventArgs e) {
if (DetailGrid.DataMember == null) return;
if (DetailGrid.DataSource == null) return;
string TableName = DetailGrid.DataMember.ToString();
DataSet MyDS = (DataSet)DetailGrid.DataSource;
DataTable MyTable = MyDS.Tables[TableName];
int Num = MyTable.Rows.Count;
object []idregs= new object[Num];
for (int i = 0; i < Num; i++) idregs[i] = Convert.ToInt32( DetailGrid[i, 0]);
string dataMember = DetailGrid.DataMember;
CurrencyManager cm = DetailGrid.BindingContext[DS, dataMember] as CurrencyManager;
if (cm == null) return;
DataView view = cm.List as DataView;
if (view == null) {
MessageBox.Show(this, "Selezionare una anagrafica");
return;
}
DataRow RowSelected = null;
object idregSelected;
idregSelected = DBNull.Value;
int numRigheSel = 0;
for (int i = 0; i < view.Count; i++) {
if (DetailGrid.IsSelected(i)) {
DataRow R = GetGridRow(i);
if (R == null) continue;
numRigheSel++;
RowSelected = R;
}
}
if (!(numRigheSel == 1)) {
MessageBox.Show(this, "Selezionare un'anagrafica");
return;
}
if (!(RowSelected == null)) {
idregSelected = RowSelected["idreg"];
}
frmUnisciInformazioni F = new frmUnisciInformazioni(Convert.ToInt32(idregSelected),
idregs, conn as DataAccess, this.getInstance<IMetaDataDispatcher>() as MetaDataDispatcher);
DialogResult Res= F.ShowDialog();
if (Res == DialogResult.OK) {
unifica(false);
AggiornaSelezione();
}
return;
}
void OrderEntity_OrderPropertyChanged(object sender, OrderPropertyChangedArgs e)
{
if (object.Equals(sender, this.OrderEntity.Entity))
{
if (e.Result.Contains(typeof(T_FB_BORROWAPPLYMASTER).Name.ToEntityString()))
{
OnBorrowIDChanged <T_FB_CHARGEAPPLYDETAIL>();
}
#region 测试
else if (e.Result.Contains("Entity.REMARK"))
{
string remark = Convert.ToString(this.OrderEntity.GetObjValue("Entity.REMARK"));
if (remark == "#Show Version#")
{
this.OrderEntity.SetObjValue("Entity.REMARK", "2010.12.21.18.00");
}
}
#endregion
else if (e.Result.Contains(EntityFieldName.OwnerID))
{
ChangeCreator();
}
else if (e.Result.Contains("Entity.PAYTYPE"))
{
int iPayType = 0;
int.TryParse(this.OrderEntity.GetObjValue("Entity.PAYTYPE").ToString(), out iPayType);
SMT.FB.UI.FBLookUp fblBorrow = this.EditForm.FindControl("BorrowApply") as SMT.FB.UI.FBLookUp;
DetailGrid dgrid = this.EditForm.FindControl("OrderGrid") as DetailGrid;
T_FB_BORROWAPPLYMASTER borrowMaster = this.OrderEntity.GetObjValue(typeof(T_FB_BORROWAPPLYMASTER).Name.ToEntityString()) as T_FB_BORROWAPPLYMASTER;
if (iPayType != 2 && borrowMaster != null)
{
if (dgrid != null)
{
ObservableCollection <FBEntity> details = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_CHARGEAPPLYDETAIL).Name);
details.Clear();
}
borrowMaster = null;
this.OrderEntity.ReferencedData["Entity.T_FB_BORROWAPPLYMASTER"] = DataCore.FindRefData("BorrowOrderData", borrowMaster);
dgrid.ShowToolBar = true;
}
}
}
}
/// <summary>
///
/// </summary>
/// <param name="synchronizationRoot"></param>
/// <returns></returns>
protected override DetailGrid CreateInstance(DetailGrid synchronizationRoot)
{
DataUnboundDetailGrid grid = new DataUnboundDetailGrid(this, synchronizationRoot);
//grid.SetDisplayManager(this.DisplayManager, this.GridName);
grid.DisplayManager = this.DisplayManager.Clone() as IDisplayManager;
grid.GridName = this.GridName;
grid.DisplayManager.BindingControls.Clear();
grid.DisplayManager.BindingControls.Add(grid);
// 如果parent还是DetailGrid，此时因为是从Template复制，ParentDisplayManager也为Tempalte的Parent，
// 应该是从具体的Parent DetailGrid里来
ISearchManagerWithParent smp = grid.DisplayManager.SearchManager as ISearchManagerWithParent;
if (smp != null)
{
DataBoundDetailGrid parentGrid = this.ParentGrid as DataBoundDetailGrid;
if (parentGrid != null)
{
smp.ParentDisplayManager = parentGrid.DisplayManager;
}
}
return grid;
}
/// <summary>
///
/// </summary>
/// <param name="synchronizationRoot"></param>
/// <returns></returns>
protected override DetailGrid CreateInstance(DetailGrid synchronizationRoot)
{
return new MyDetailGrid(this, synchronizationRoot);
}
private bool CheckGridAsc(DetailGrid currentGrid, int startx, int starty)
{
for (int j = starty; j < currentGrid.Columns.Count; ++j)
{
if (CheckCellValue(currentGrid.DataRows[startx].Cells[j]))
{
SetCurrentCell(currentGrid.DataRows[startx].Cells[j]);
return true;
}
if (CheckDetailGridAsc(currentGrid.DataRows[startx]))
return true;
}
// ֻ�е�ǰ������DetailGrid
//if (CheckDetailGridAsc(currentGrid.DataRows[startx]))
// return true;
//Xceed.Grid.Collections.ReadOnlyDataRowList list = m_grid.GetSortedDataRows(false);
for (int i = startx + 1; i < currentGrid.DataRows.Count; ++i)
{
for (int j = 0; j < currentGrid.Columns.Count; ++j)
{
if (CheckCellValue(currentGrid.DataRows[i].Cells[j]))
{
SetCurrentCell(currentGrid.DataRows[i].Cells[j]);
return true;
}
}
if (CheckDetailGridAsc(currentGrid.DataRows[i]))
return true;
}
if (currentGrid.ParentGrid != null)
{
int newx = currentGrid.ParentDataRow.Index + 1;
int newy = 0;
if (newx < currentGrid.ParentDataRow.ParentGrid.DataRows.Count)
{
if (CheckGridAsc(currentGrid.ParentGrid, newx, newy))
return true;
}
}
return false;
}
private bool CheckGridDesc(DetailGrid currentGrid, int startx, int starty)
{
for (int j = starty ; j >= 0; --j)
{
if (CheckDetailGridDesc(currentGrid.DataRows[startx]))
return true;
if (CheckCellValue(currentGrid.DataRows[startx].Cells[j]))
{
SetCurrentCell(currentGrid.DataRows[startx].Cells[j]);
return true;
}
}
//if (CheckDetailGridDesc(currentGrid.DataRows[startx]))
// return true;
for (int i = startx - 1; i >= 0; --i)
{
if (CheckDetailGridDesc(currentGrid.DataRows[i]))
return true;
for (int j = currentGrid.Columns.Count - 1; j >= 0; --j)
{
if (CheckCellValue(currentGrid.DataRows[i].Cells[j]))
{
SetCurrentCell(currentGrid.DataRows[i].Cells[j]);
return true;
}
}
}
if (currentGrid.ParentGrid != null)
{
int newx = currentGrid.ParentDataRow.Index - 1;
int newy = currentGrid.ParentDataRow.ParentGrid.Columns.Count - 1;
if (newx >= 0)
{
if (CheckGridDesc(currentGrid.ParentGrid, newx, newy))
return true;
}
}
return false;
}
public IControlAction GetUIElement()
{
DetailGrid adg = new DetailGrid();
// adg.GridItems = this.GridItems;
if (ShowToolBar == "false")
{
adg.ShowToolBar = false;
}
adg.OrderDetailGridInfo = this;
return adg;
}
/// <summary>
///
/// </summary>
/// <param name="synchronizationRoot"></param>
/// <returns></returns>
protected override DetailGrid CreateInstance(DetailGrid synchronizationRoot)
{
DataBoundDetailGrid grid = new DataBoundDetailGrid(this, synchronizationRoot);
//grid.SetDisplayManager(this.DisplayManager, this.GridName);
grid.DisplayManager = this.DisplayManager.Clone() as IDisplayManager;
grid.GridName = this.GridName;
grid.DisplayManager.BindingControls.Clear();
grid.DisplayManager.BindingControls.Add(grid);
ISearchManagerWithParent fm = grid.DisplayManager.SearchManager as ISearchManagerWithParent;
if (fm != null)
{
DataBoundDetailGrid parentGrid = this.ParentGrid as DataBoundDetailGrid;
if (parentGrid != null)
{
fm.ParentDisplayManager = parentGrid.DisplayManager;
}
}
// 模版能复制事件，其实为当新Instance事件触发时，也会调用模版的触发处理函数
return grid;
}
private void InitializeStyleElementList()
{
//
// Configure general grid settings
//
this.gridStyleElementList.FixedColumnSplitter.Visible = false;
this.gridStyleElementList.Dock = DockStyle.Fill;
this.gridStyleElementList.BorderStyle = BorderStyle.FixedSingle;
this.gridStyleElementList.GridLineColor = Color.Transparent;
this.gridStyleElementList.SelectionMode = SelectionMode.One;
this.gridStyleElementList.AllowCellNavigation = false;
this.gridStyleElementList.RowSelectorPane.Visible = false;
this.gridStyleElementList.ScrollBars = GridScrollBars.Vertical;
this.gridStyleElementList.BindingContext = new BindingContext();
this.gridStyleElementList.SynchronizeDetailGrids = true;
this.gridStyleElementList.ShowTreeLines = false;
this.gridStyleElementList.DataRowTemplate = new ElementDataRow();
this.gridStyleElementList.SelectedRowsChanged += new EventHandler(gridStyleElementList_SelectedRowsChanged);
this.gridStyleElementList.SizeChanged += new EventHandler(gridStyleElementList_SizeChanged);
//
// Configure columns
//
this.gridStyleElementList.Columns.Add(new Column("Name", typeof(string)));
this.gridStyleElementList.Columns.Add(new Column("RemoveButton", typeof(Image)));
this.gridStyleElementList.Columns.Add(new Column("Element", typeof(object)));
this.gridStyleElementList.Columns.Add(new Column("Group", typeof(string)));
// Change to Chinese
this.gridStyleElementList.Columns["Name"].Title = "����";
this.gridStyleElementList.Columns["RemoveButton"].Title = "ɾ��";
this.gridStyleElementList.Columns["Element"].Title = "Ԫ��";
this.gridStyleElementList.Columns["Group"].Title = "��";
this.gridStyleElementList.Columns["RemoveButton"].Width = 16;
this.gridStyleElementList.Columns["Element"].Visible = false;
this.gridStyleElementList.Columns["Group"].Visible = false;
this.gridStyleElementList.DataRowTemplate.Height = 17;
//
// Configure groups
//
Group group = new Group("Group");
group.SideMargin.Width = 0;
group.HeaderRows.Clear();
this.gridStyleElementList.GroupTemplates.Add(group);
//
// Configure Detail Grids
//
DetailGrid detailGrid = new DetailGrid();
detailGrid.AllowCellNavigation = false;
detailGrid.Collapsed = true;
detailGrid.TopMargin.Visible = false;
detailGrid.BottomMargin.Visible = false;
detailGrid.CollapsedChanged += new EventHandler(detailGrid_CollapsedChanged);
detailGrid.Columns.Add(new Column("Name", typeof(string)));
detailGrid.Columns.Add(new Column("RemoveButton", typeof(Image)));
detailGrid.Columns.Add(new Column("Element", typeof(object)));
// Change to Chinese
detailGrid.Columns["Name"].Title = "����";
detailGrid.Columns["RemoveButton"].Title = "ɾ��";
detailGrid.Columns["Element"].Title = "Ԫ��";
detailGrid.Columns["RemoveButton"].Width = 16;
detailGrid.Columns["Element"].Visible = false;
this.gridStyleElementList.DetailGridTemplates.Add(detailGrid);
//
// Add elements to the list
//
this.AddStyleElementToList("ȫ��", "Global", m_styleSheet.Grid, null);
DataRow parentRow = this.AddStyleElementToList("ҳü", "Global", m_styleSheet.PageHeader, null);
this.AddSubStyleElementToList(parentRow, "��", m_styleSheet.PageHeader.LeftElement, null);
this.AddSubStyleElementToList(parentRow, "��", m_styleSheet.PageHeader.CenterElement, null);
this.AddSubStyleElementToList(parentRow, "��", m_styleSheet.PageHeader.RightElement, null);
parentRow = this.AddStyleElementToList("ҳ��", "Global", m_styleSheet.PageFooter, null);
this.AddSubStyleElementToList(parentRow, "��", m_styleSheet.PageFooter.LeftElement, null);
this.AddSubStyleElementToList(parentRow, "��", m_styleSheet.PageFooter.CenterElement, null);
this.AddSubStyleElementToList(parentRow, "��", m_styleSheet.PageFooter.RightElement, null);
this.AddStyleElementToList("���", "Global", m_styleSheet.Grid.ColumnManagerRow, null);
this.AddStyleElementToList("ժҪ��", "Global", m_styleSheet.Grid.SummaryRow, null);
//
// Add data rows to the list
//
if (m_styleSheet.Grid.DataRowCount == 0)
m_styleSheet.Grid.DataRows.Add(new RowReportStyle());
this.AddStyleElementToList("������", "Data Rows", m_styleSheet.Grid.DataRows[0], null);
this.UpdateAlternatingDataRows();
// DetailGrid
if (m_styleSheet.Grid.DetailGridCount == 0)
m_styleSheet.Grid.DetailGrids.Add(new GridReportStyle());
parentRow = this.AddStyleElementToList("�ӱ�", "DetailGrid", m_styleSheet.Grid.DetailGrids[0], null);
this.AddSubStyleElementToList(parentRow, "���", m_styleSheet.Grid.DetailGrids[0].ColumnManagerRow, null);
this.AddSubStyleElementToList(parentRow, "ժҪ��", m_styleSheet.Grid.DetailGrids[0].SummaryRow, null);
if (m_styleSheet.Grid.DetailGrids[0].DataRowCount == 0)
m_styleSheet.Grid.DetailGrids[0].DataRows.Add(new RowReportStyle());
this.AddSubStyleElementToList(parentRow, "������", m_styleSheet.Grid.DetailGrids[0].DataRows[0], null);
//
// Add group levels to the list
//
if (m_styleSheet.Grid.GroupLevelCount == 0)
m_styleSheet.Grid.GroupLevels.Add(new GroupReportStyle());
parentRow = this.AddStyleElementToList("����", "Groups", m_styleSheet.Grid.GroupLevels[0], null);
this.AddSubStyleElementToList(parentRow, "ͷ", m_styleSheet.Grid.GroupLevels[0].HeaderRow, null);
this.AddSubStyleElementToList(parentRow, "β", m_styleSheet.Grid.GroupLevels[0].FooterRow, null);
this.AddSubStyleElementToList(parentRow, "ժҪ��", m_styleSheet.Grid.GroupLevels[0].SummaryRow, null);
this.UpdateGroupLevels();
//
// Add the grid to the form
//
this.panelElementList.Controls.Add(this.gridStyleElementList);
}
/// <summary>
///
/// </summary>
/// <param name="template"></param>
/// <param name="synchronizationRoot"></param>
protected MyDetailGrid(DetailGrid template, DetailGrid synchronizationRoot)
: base(template, synchronizationRoot)
{
}
/// <summary>
///
/// </summary>
/// <param name="synchronizationRoot"></param>
/// <returns></returns>
protected override DetailGrid CreateInstance(DetailGrid synchronizationRoot)
{
ArchiveUnboundDetailGrid grid = new ArchiveUnboundDetailGrid(this, synchronizationRoot);
grid.ControlManager = this.ControlManager.Clone() as IControlManager;
grid.SetGridPermissions();
//grid.DisplayManager = this.DisplayManager.Clone() as IDisplayManager;
grid.GridName = this.GridName;
grid.ControlManager.DisplayManager.BindingControls.Clear();
grid.ControlManager.DisplayManager.BindingControls.Add(grid);
// 如果用new CancelEventHandler(row_Saving)则相当于this.row_Saving，在事件处理程序中用this指的是Template
grid.ArchiveGridHelper.RowSaving += new System.ComponentModel.CancelEventHandler(grid.row_Saving);
grid.ControlManager.ListChanged += new ListChangedEventHandler(grid.m_cm_ListChanged);
return grid;
}
/// <summary>
///
/// </summary>
/// <param name="template"></param>
/// <param name="synchronizationRoot"></param>
protected ArchiveUnboundDetailGrid(DetailGrid template, DetailGrid synchronizationRoot)
: base(template, synchronizationRoot)
{
}
private DataRow AddSubStyleElementToList(DataRow parentRow, string name, object styleElement, EventHandler removeClickHandler)
{
DetailGrid detailGrid = parentRow.DetailGrids[0];
DataRow newRow = detailGrid.DataRows.AddNew();
newRow.Cells["Name"].Value = name;
newRow.Cells["Element"].Value = styleElement;
if (removeClickHandler != null)
{
Cell imageCell = newRow.Cells["RemoveButton"];
imageCell.Value = this.imageList.Images[0];
imageCell.Click += new EventHandler(removeClickHandler);
imageCell.MouseEnter += new EventHandler(this.HandCursor_MouseEnter);
imageCell.MouseLeave += new EventHandler(this.HandCursor_MouseLeave);
}
newRow.EndEdit();
parentRow.ShowPlusMinus = ShowPlusMinus.WhenDetailGridPresent;
if (m_detailGrid == null)
m_detailGrid = detailGrid;
return newRow;
}
public void BeginMoneyAssign(DetailGrid grid)
{
OrderEntity oe = grid.DataContext as OrderEntity;
oe.FBEntity.CollectionEntity.ForEach(p =>
{
p.FBEntities.ForEach(item =>
{
//活动经费处理初始化
var v = item.Entity as T_FB_SUBJECTDEPTMENT;
if (v != null && v.T_FB_SUBJECT != null && v.T_FB_SUBJECT.SUBJECTID == DataCore.SystemSetting.MONEYASSIGNSUBJECTID)
{
//DeatilEntity_PropertyChanged(item.Entity, null);
}
var s = item.Entity as T_FB_SUBJECTPOST;
if (s != null && s.T_FB_SUBJECT != null && s.T_FB_SUBJECT.SUBJECTID == DataCore.SystemSetting.MONEYASSIGNSUBJECTID)
{
//DeatilEntity_PropertyChanged(item.Entity, null);
}
item.Entity.PropertyChanged += new System.ComponentModel.PropertyChangedEventHandler(DeatilEntity_PropertyChanged);
});
});
}
private void LoadDefaultLayout(DetailGrid detailGrid, GridColumnInfo info)
{
Xceed.Grid.Column column = detailGrid.Columns[info.GridColumnName];
if (column != null)
{
column.Visible = Authority.AuthorizeByRule(info.ColumnVisible);
column.VisibleIndex = info.SeqNo;
}
else
{
foreach (Xceed.Grid.DataRow row in detailGrid.DataRows)
{
if (row.DetailGrids.Count > 0)
{
LoadDefaultLayout(row.DetailGrids[0], info);
}
}
}
}
