private void DoFastAddInfo()
{
TabPageEdit tab = tabs[xtabItemInfo.SelectedTabPageIndex];
DataRow drFoc = tab.GridViewEdit.GetFocusedDataRow();
if (drFoc == null)
{
return;
}
Form frmEx = StaticFunctions.GetExistedChildForm(this.ParentForm, "frmBsuSetQueryFastAddInfo");
if (frmEx != null)
{
frmEx.Close();
frmEx.Dispose();
}
frmBsuSetQueryFastAddInfo frm = new frmBsuSetQueryFastAddInfo();
frm.Q_OR_E = "E";
frm.SetClass = drFoc["Menus_Class"].ToString();
frm.StrType = "2";
frm.MdiParent = this.ParentForm;
frm.FrmEditorBaseP = this;
frm.Show();
}
private void DoQuery()
{
if (Convert.ToString(txtClass.EditValue) == string.Empty)
{
return;
}
List <string> lisSpParmValue = new List <string>();
string[] strKey = "ClassName,EUser_Id,EDept_Id,Fy_Id,flag".Split(",".ToCharArray());
lisSpParmValue.AddRange(new string[] { Convert.ToString(txtClass.EditValue),
CApplication.App.CurrentSession.UserId.ToString(),
CApplication.App.CurrentSession.DeptId.ToString(),
CApplication.App.CurrentSession.FyId.ToString(),
"1" });
DataSet dtAdd = this.DataRequest_By_DataSet(strSpName, strKey, lisSpParmValue.ToArray());
if (dtAdd == null)
{
return;
}
blInitBound = true;
gridCMain.DataSource = dtAdd.Tables[0].DefaultView;
gridVMain.BestFitColumns();
blInitBound = false;
TabPageEdit tab = tabs[xtabItemInfo.SelectedTabPageIndex];
gridView_FocusedRowChanged(tab.GridViewEdit, new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs(-1, tab.GridViewEdit.FocusedRowHandle));
}
private void frmBsuSetQuery_Load(object sender, EventArgs e)
{
List <string> lisSpParmValue = new List <string>();
string[] strKey = "ClassType,EUser_Id,EDept_Id,Fy_Id,flag".Split(",".ToCharArray());
lisSpParmValue.AddRange(new string[] {
strClassType,
CApplication.App.CurrentSession.UserId.ToString(),
CApplication.App.CurrentSession.DeptId.ToString(),
CApplication.App.CurrentSession.FyId.ToString(),
"1"
});
DataSet dtAdd = this.DataRequest_By_DataSet(strSpName, strKey, lisSpParmValue.ToArray());
if (dtAdd == null)
{
return;
}
blInitBound = true;
gridCMain.DataSource = dtAdd.Tables[0].DefaultView;
gridVMain.BestFitColumns();
gridCTab.DataSource = dtAdd.Tables[1].DefaultView;
gridVTab.BestFitColumns();
gridCBtn.DataSource = dtAdd.Tables[2].DefaultView;
gridVBtn.BestFitColumns();
gridCBtnM.DataSource = dtAdd.Tables[3].DefaultView;
gridVBtnM.BestFitColumns();
blInitBound = false;
TabPageEdit tab = tabs[xtabItemInfo.SelectedTabPageIndex];
gridView_FocusedRowChanged(tab.GridViewEdit, new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs(-1, tab.GridViewEdit.FocusedRowHandle));
}
private void DoDelete()
{
TabPageEdit tab = tabs[xtabItemInfo.SelectedTabPageIndex];
if (tab.GridViewEdit.SelectedRowsCount <= 0)
{
return;
}
string strKeyIds = string.Empty;
foreach (int i in tab.GridViewEdit.GetSelectedRows())
{
DataRow dr = tab.GridViewEdit.GetDataRow(i);
if (dr.RowState == DataRowState.Added)
{
continue;
}
strKeyIds += strKeyIds == string.Empty ? dr[tab.StrKeyId].ToString() : "," + dr[tab.StrKeyId].ToString();
}
if (strKeyIds == string.Empty)
{
return;
}
if (MessageBox.Show("是否删除", "操作确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) != System.Windows.Forms.DialogResult.Yes)
{
return;
}
List <string> lisSpParmValue = new List <string>();
string[] strKey = "strKeyIds,EUser_Id,EDept_Id,Fy_Id,flag".Split(",".ToCharArray());
lisSpParmValue.AddRange(new string[] {
strKeyIds,
CApplication.App.CurrentSession.UserId.ToString(),
CApplication.App.CurrentSession.DeptId.ToString(),
CApplication.App.CurrentSession.FyId.ToString(),
tab.DeleteFlag
});
DataSet dtAdd = this.DataRequest_By_DataSet(strSpName, strKey, lisSpParmValue.ToArray());
if (dtAdd == null)
{
return;
}
blInitBound = true;
tab.GridViewEdit.DeleteSelectedRows();
DataTable dtInfo = (tab.GridViewEdit.GridControl.DataSource as DataView).Table;
dtInfo.AcceptChanges();
blInitBound = false;
gridView_FocusedRowChanged(tab.GridViewEdit, new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs(-1, tab.GridViewEdit.FocusedRowHandle));
MessageBox.Show("操作完成.");
}
private void gridView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
if (e.FocusedRowHandle <= -1 || blInitBound)
{
return;
}
TabPageEdit tab = tabs[xtabItemInfo.SelectedTabPageIndex];
DataRow dr = tab.GridViewEdit.GetFocusedDataRow();
if (dr == null)
{
return;
}
StaticFunctions.SetControlBindings(tab.CtrParentControl, tab.GridViewEdit.GridControl.DataSource as DataView, dr);
}
private void AddIndex()
{
TabPageEdit tab = tabs[xtabItemInfo.SelectedTabPageIndex];
if (tab.GridViewEdit.SelectedRowsCount <= 0)
{
return;
}
int idx = int.Parse(txtIdx.EditValue.ToString());
foreach (int i in tab.GridViewEdit.GetSelectedRows())
{
DataRow dr = tab.GridViewEdit.GetDataRow(i);
dr["ShowIndex"] = int.Parse(dr["ShowIndex"].ToString()) + idx;
}
}
private void DoAdd()
{
TabPageEdit tab = tabs[xtabItemInfo.SelectedTabPageIndex];
tab.GridViewEdit.ClearColumnsFilter();
tab.GridViewEdit.ClearSorting();
DataTable dtInfo = (tab.GridViewEdit.GridControl.DataSource as DataView).Table;
DataRow drNew = dtInfo.NewRow();
foreach (Control ctrParent in tab.CtrParentControl)
{
StaticFunctions.SetContrDefaultValue(ctrParent, dtShow, drNew);
}
blInitBound = true;
dtInfo.Rows.Add(drNew);//可能引发gridView1_FocusedRowChanged
tab.GridViewEdit.MoveLast();
blInitBound = false;
gridView_FocusedRowChanged(tab.GridViewEdit, new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs(-1, tab.GridViewEdit.FocusedRowHandle));
}
private void Copy()
{
TabPageEdit tab = tabs[xtabItemInfo.SelectedTabPageIndex];
if (tab.GridViewEdit.SelectedRowsCount <= 0)
{
return;
}
DataTable dtInfo = (tab.GridViewEdit.GridControl.DataSource as DataView).Table;
blInitBound = true;
foreach (int i in tab.GridViewEdit.GetSelectedRows())
{
DataRow dr = tab.GridViewEdit.GetDataRow(i);
DataRow drNew = dtInfo.NewRow();
drNew.ItemArray = dr.ItemArray;
drNew[tab.StrKeyId] = DBNull.Value;
dtInfo.Rows.Add(drNew);
}
tab.GridViewEdit.MoveLast();
blInitBound = false;
gridView_FocusedRowChanged(tab.GridViewEdit, new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs(-1, tab.GridViewEdit.FocusedRowHandle));
}
private void xtabItemInfo_SelectedPageChanged(object sender, DevExpress.XtraTab.TabPageChangedEventArgs e)
{
TabPageEdit tab = tabs[xtabItemInfo.SelectedTabPageIndex];
gridView_FocusedRowChanged(tab.GridViewEdit, new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs(-1, tab.GridViewEdit.FocusedRowHandle));
}
private void DoSave()
{
string strField = string.Empty;
string strValues = string.Empty;
TabPageEdit tab = tabs[xtabItemInfo.SelectedTabPageIndex];
int iFocu = tab.GridViewEdit.FocusedRowHandle;
tab.GridViewEdit.FocusedRowHandle = -1;
tab.GridViewEdit.FocusedRowHandle = iFocu;
DataTable dtInfo = (tab.GridViewEdit.GridControl.DataSource as DataView).Table;
if (dtInfo.GetChanges() == null)
{
return;
}
foreach (DataRow dr in dtInfo.Rows)
{
if (dr.RowState == DataRowState.Added)
{
strValues = StaticFunctions.GetAddValues(dr, tab.StrFileds, out strField);
List <string> lisSpParmValue = new List <string>();
string[] strKey = "ClassType,strFields,strFieldValues,EUser_Id,EDept_Id,Fy_Id,flag".Split(",".ToCharArray());
lisSpParmValue.AddRange(new string[] { strClassType,
strField,
strValues,
CApplication.App.CurrentSession.UserId.ToString(),
CApplication.App.CurrentSession.DeptId.ToString(),
CApplication.App.CurrentSession.FyId.ToString(),
tab.AddFlag });
DataSet dtAdd = this.DataRequest_By_DataSet(strSpName, strKey, lisSpParmValue.ToArray());
if (dtAdd == null)
{
return;
}
DataRow drNew = dtAdd.Tables[0].Rows[0];
dr[tab.StrKeyId] = drNew[tab.StrKeyId];
}
else if (dr.RowState == DataRowState.Modified)
{
strValues = StaticFunctions.GetUpdateValues(dtInfo, dr, tab.StrFileds);
if (strValues == string.Empty)
{
continue;
}
List <string> lisSpParmValue = new List <string>();
string[] strKey = "strEditSql,Key_Id,EUser_Id,EDept_Id,Fy_Id,flag".Split(",".ToCharArray());
lisSpParmValue.AddRange(new string[] {
strValues,
dr[tab.StrKeyId].ToString(),
CApplication.App.CurrentSession.UserId.ToString(),
CApplication.App.CurrentSession.DeptId.ToString(),
CApplication.App.CurrentSession.FyId.ToString(),
tab.EditFlag
});
DataTable dtAdd = this.DataRequest_By_DataTable(strSpName, strKey, lisSpParmValue.ToArray());
if (dtAdd == null)
{
return;
}
}
}
dtInfo.AcceptChanges();
MessageBox.Show("操作完成.");
}