private void UserControl1_Load(object sender, EventArgs e)
{
this.reload();
DevExpress.XtraGrid.Views.Grid.GridView view = gridControl1.MainView as DevExpress.XtraGrid.Views.Grid.GridView;
view.BestFitColumns();
view.OptionsPrint.AutoWidth = false;
}
private void gridView1_MasterRowExpanded(object sender, DevExpress.XtraGrid.Views.Grid.CustomMasterRowEventArgs e)
{
DevExpress.XtraGrid.Views.Grid.GridView aView = gridView1.GetDetailView(e.RowHandle, e.RelationIndex) as DevExpress.XtraGrid.Views.Grid.GridView;
if (aView != null)
{
aView.Columns["id"].Visible = false; //aView就是子View，设置VID 列为隐藏
aView.Columns["shd_bh"].Visible = false;
aView.Columns["shd_pf_bh"].Caption = "配方编号";
aView.Columns["shd_pf_sl"].Caption = "配方数量";
aView.Columns["shd_pf_jg"].Caption = "配方价格";
aView.Columns["shd_pf_ys"].Caption = "配方颜色";
aView.Columns["shd_pf_jz"].Caption = "配方胶质";
aView.Columns["shd_pf_dw"].Caption = "配方单位";
aView.Columns["shd_pf_bh"].OptionsColumn.AllowEdit = false;
aView.Columns["shd_pf_sl"].OptionsColumn.AllowEdit = false;
aView.Columns["shd_pf_jg"].OptionsColumn.AllowEdit = false;
aView.Columns["shd_pf_ys"].OptionsColumn.AllowEdit = false;
aView.Columns["shd_pf_jz"].OptionsColumn.AllowEdit = false;
aView.Columns["shd_pf_dw"].OptionsColumn.AllowEdit = false;
aView.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFullFocus;
//aView.OptionsView.ShowFooter = true ;
//aView.Columns["shd_pf_jg"].Summary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[] {
//new DevExpress.XtraGrid.GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Sum, "shd_pf_jg", "总计：{0:0.##}")});
aView.BestFitColumns();
}
}
public override void DisplayInfo()
{
//gridLookUpEdit_Hanghoa_Ban
DataSet ds_Hanghoa_Ban = objMasterService.Get_All_Ware_Dm_Hanghoa_Ban().ToDataSet();
gridLookUpEdit_Hanghoa_Ban.DataSource = ds_Hanghoa_Ban.Tables[0];
gridLookUpEdit_Ma_Hanghoa_Ban.DataSource = ds_Hanghoa_Ban.Tables[0];
//gridLookUpEdit_Loai_Hanghoa_Ban
gridLookUpEdit_Loai_Hanghoa_Ban.DataSource = objMasterService.Get_All_Ware_Dm_Loai_Hanghoa_Ban().ToDataSet().Tables[0];
//gridLookUpEdit_Nhom_Hanghoa_Ban
gridLookUpEdit_Nhom_Hanghoa_Ban.DataSource = objMasterService.Get_All_Ware_Dm_Nhom_Hanghoa_Ban().ToDataSet().Tables[0];
//dgware_Dm_Hanghoa_Ban
if (id_kh_hh_ban != null)
{
objMasterService.Ware_Hhban_Quydoi_Hhmua_Init();
dsWare_Hhban_Quydoi_Hhmua = objMasterService.Ware_Hhban_Quydoi_Hhmua_SelectByKhhhban(id_kh_hh_ban).ToDataSet();
dgware_Dm_Hanghoa_Ban.DataSource = dsWare_Hhban_Quydoi_Hhmua;
dgware_Dm_Hanghoa_Ban.DataMember = dsWare_Hhban_Quydoi_Hhmua.Tables[0].TableName;
}
gvNguyenlieu.BestFitColumns();
base.DisplayInfo();
}
private void PivotGrid_CellDoubleClick(object sender, PivotCellEventArgs e)
{
XtraForm form = new XtraForm();
form.Icon = Marbid.Module.Win.Properties.Resources.mareinico;
form.Height = 800;
form.Width = 600;
form.StartPosition = FormStartPosition.CenterScreen;
form.Owner = pivotForm;
form.Text = "Drill Down: " + ReportName;
drillGrid = new GridControl();
drillView = new DevExpress.XtraGrid.Views.Grid.GridView();
drillGrid.DataSource = e.CreateDrillDownDataSource();
drillGrid.ViewCollection.Add(drillView);
drillGrid.ForceInitialize();
drillGrid.Parent = form;
drillGrid.Dock = DockStyle.Fill;
DevExpress.XtraGrid.Views.Grid.GridView view = (DevExpress.XtraGrid.Views.Grid.GridView)drillGrid.MainView;
view.PopulateColumns();
foreach (GridColumn col in view.Columns)
{
if (col.GetType() == typeof(System.Decimal) || col.GetType() == typeof(System.Double))
{
col.DisplayFormat.FormatType = FormatType.Numeric;
col.DisplayFormat.FormatString = "n2";
}
}
view.PopupMenuShowing += DrillGrid_PopupMenuShowing;
view.OptionsView.ColumnAutoWidth = false;
view.BestFitColumns(true);
form.ShowDialog();
form.Dispose();
}
/// <summary>
/// Reconfig properties of gridview
/// </summary>
/// <param name="gridView">GridView</param>
public static void ReconfigGridView(DevExpress.XtraGrid.Views.Grid.GridView gridView)
{
gridView.BestFitColumns();
if (gridView.OptionsBehavior.ReadOnly)
{
gridView.OptionsBehavior.AllowAddRows = DevExpress.Utils.DefaultBoolean.False;
gridView.OptionsBehavior.AllowDeleteRows = DevExpress.Utils.DefaultBoolean.False;
gridView.OptionsBehavior.Editable = false;
}
if (gridView.OptionsBehavior.AllowAddRows == DevExpress.Utils.DefaultBoolean.False)
{
gridView.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None;
}
else if (gridView.OptionsBehavior.AllowAddRows == DevExpress.Utils.DefaultBoolean.True)
{
gridView.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.Bottom;
}
gridView.OptionsView.ShowGroupPanel = gridView.OptionsCustomization.AllowGroup;
gridView.OptionsView.ShowAutoFilterRow = gridView.OptionsCustomization.AllowFilter;
//if (gridView.OptionsCustomization.AllowFilter == true)
// gridView.OptionsView.ShowFilterPanelMode = DevExpress.XtraGrid.Views.Base.ShowFilterPanelMode.ShowAlways;
//else
gridView.OptionsView.ShowFilterPanelMode = DevExpress.XtraGrid.Views.Base.ShowFilterPanelMode.Never;
}
/// <summary>
/// لملئ الجريد بالبيانات
/// </summary>
/// <param name="list"></param>
/// <param name="gridview"></param>
/// <param name="gridcontrol"></param>
public static void fillGrid(object list, DevExpress.XtraGrid.Views.Grid.GridView gridview, DevExpress.XtraGrid.GridControl gridcontrol)
{
gridview.Columns.Clear();
gridcontrol.DataSource = list;
gridview.BestFitColumns();
gridview.Appearance.Row.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridview.Appearance.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridview.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFullFocus;
gridview.FixedLineWidth = 1;
gridview.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFullFocus;
gridview.GridControl = gridcontrol;
gridview.GroupPanelText = "يمكنك سحب الحقل ووضعه هنا ";
gridview.OptionsBehavior.Editable = false;
gridview.OptionsCustomization.AllowRowSizing = true;
gridview.OptionsFind.AlwaysVisible = true;
gridview.OptionsFind.FindNullPrompt = "ابحث عن اى قيمه وسيتم الاستعلام عنها";
gridview.OptionsLayout.Columns.AddNewColumns = false;
gridview.OptionsPrint.PrintPreview = true;
gridview.OptionsView.BestFitMaxRowCount = 2;
gridview.OptionsView.BestFitUseErrorInfo = DevExpress.Utils.DefaultBoolean.True;
gridview.OptionsView.ColumnAutoWidth = false;
gridview.OptionsView.EnableAppearanceEvenRow = true;
gridview.OptionsView.ShowHorizontalLines = DevExpress.Utils.DefaultBoolean.True;
gridview.PaintStyleName = "Skin";
gridview.VertScrollVisibility = DevExpress.XtraGrid.Views.Base.ScrollVisibility.Always;
}
public static void GridPrev(object list, DevExpress.XtraGrid.Views.Grid.GridView gridview, DevExpress.XtraGrid.GridControl gridcontrol)
{
gridview.Columns.Clear();
//IList collection = (IList)list;
//Service.data = list;
gridcontrol.DataSource = list;
gridview.BestFitColumns();
gridview.Appearance.Row.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridview.Appearance.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
RepositoryItemButtonEdit buttonEdit1 = new RepositoryItemButtonEdit();
buttonEdit1.Buttons[0].Kind = ButtonPredefines.Delete;
buttonEdit1.TextEditStyle = TextEditStyles.HideTextEditor;
buttonEdit1.ButtonClick += new ButtonPressedEventHandler(buttonEdit_ButtonClick2);
GridColumn unbColumn1 = gridview.Columns.AddField("حذف");
unbColumn1.UnboundType = DevExpress.Data.UnboundColumnType.String;
unbColumn1.VisibleIndex = gridview.Columns.Count;
unbColumn1.ColumnEdit = buttonEdit1;
gridview.ShowButtonMode = DevExpress.XtraGrid.Views.Base.ShowButtonModeEnum.ShowAlways;
Service.gridview = gridview;
}
private void InitGridColumns()
{
gridControl1.DataSource = data;
gridControl1.DefaultView.PopulateColumns();
gridView1.Columns["Payment Amount"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
gridView1.Columns["Payment Amount"].DisplayFormat.FormatString = "c";
gridView1.BestFitColumns();
}
public static void BestFitAllColumns(DevExpress.XtraGrid.Views.Grid.GridView gridView)
{
gridView.BestFitColumns();
for (int i = 0; i < gridView.Columns.Count; i++)
{
gridView.Columns[i].BestFit();
}
}
public void loadii(DevExpress.XtraGrid.GridControl lvpq, DevExpress.XtraGrid.Views.Grid.GridView view)
{
DataTable dt = new DataTable();
DataTable temp = new DataTable();
view.Columns.Clear();
lvpq.DataSource = hang;
/*
* temp = gen.GetTable("select * from InventoryItem order by InventoryItemCode");
* dt.Columns.Add("ID", Type.GetType("System.String"));
* dt.Columns.Add("Mã hàng hóa", Type.GetType("System.String"));
* dt.Columns.Add("Tên hàng hóa", Type.GetType("System.String"));
* dt.Columns.Add("Đơn vị tính", Type.GetType("System.String"));
* dt.Columns.Add("Đơn vị quy đổi", Type.GetType("System.String"));
* dt.Columns.Add("Tỷ lệ", Type.GetType("System.Double"));
* for (int i = 0; i < temp.Rows.Count; i++)
* {
* DataRow dr = dt.NewRow();
* dr[0] = temp.Rows[i][0].ToString();
* dr[1] = temp.Rows[i][2].ToString();
* dr[2] = temp.Rows[i][4].ToString();
* dr[3] = temp.Rows[i][6].ToString();
* dr[4] = temp.Rows[i][7].ToString();
* if (temp.Rows[i][8].ToString() == "")
* dr[5] = 1;
* else
* dr[5] = temp.Rows[i][8].ToString();
* dt.Rows.Add(dr);
* }
* lvpq.DataSource = dt;
*/
view.BestFitColumns();
view.OptionsBehavior.Editable = false;
view.OptionsSelection.EnableAppearanceFocusedCell = false;
view.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
view.Columns[0].Visible = false;
view.BestFitColumns();
view.Columns[1].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
view.Columns[1].SummaryItem.DisplayFormat = "Số dòng: {0}";
view.ShowFindPanel();
panelControl1.Visible = false;
}
internal static void GridViewEditarColumnas(DevExpress.XtraGrid.Views.Grid.GridView view, bool bSoloLectura, bool bAjustarColumnas, bool bFechaHora, List <string> ColumnasOcultar, List <string> ColumnasEditar, List <string> ColumnasNoMoneda)
{
foreach (DevExpress.XtraGrid.Columns.GridColumn columna in view.Columns)
{
if (columna.FieldName.EndsWith("_Id"))
{
columna.Visible = false;
}
columna.Caption = columna.FieldName.Replace("_", " ").ToUpper();
columna.OptionsFilter.AutoFilterCondition = DevExpress.XtraGrid.Columns.AutoFilterCondition.Contains;
if (bSoloLectura && (ColumnasEditar == null || !ColumnasEditar.Contains(columna.FieldName)))
{
columna.OptionsColumn.ReadOnly = true;
columna.OptionsColumn.AllowEdit = false;
}
if (ColumnasOcultar != null && ColumnasOcultar.Contains(columna.FieldName))
{
columna.Visible = false;
}
if (columna.ColumnType == typeof(DateTime))
{
if (bFechaHora)
{
columna.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
columna.DisplayFormat.FormatString = "g";
}
else
{
columna.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
columna.DisplayFormat.FormatString = "d";
}
}
if ((columna.ColumnType == typeof(double) || columna.ColumnType == typeof(Decimal)) && (ColumnasNoMoneda == null || !ColumnasNoMoneda.Contains(columna.FieldName)))
{
columna.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
if (string.Compare(columna.FieldName, "importe", true) == 0)
{
columna.DisplayFormat.FormatString = "c0";
}
else
{
columna.DisplayFormat.FormatString = "c2";
}
}
}
if (bAjustarColumnas)
{
view.BestFitColumns();
}
}
private void Home_Load_1(object sender, EventArgs e)
{
pat.connect();
int counter;
readStudent();
DataTable dt = new DataTable();
DataRow dr = null;
int count = 0;
foreach (PAT p in pt_list)
{
if (dt.Columns.Count == 0)
{
dt.Columns.Add("PAT Name", typeof(string));
dt.Columns.Add("Student 1", typeof(string));
dt.Columns.Add("Student 2", typeof(string));
dt.Columns.Add("Student 3", typeof(string));
dt.Columns.Add("Student 4", typeof(string));
dt.Columns.Add("Student 5", typeof(string));
dt.Columns.Add("Student 6", typeof(string));
dt.Columns.Add("Student 7", typeof(string));
dt.Columns.Add("Student 8", typeof(string));
}
dr = dt.NewRow();
dr[0] = p.name;
counter = 1;
foreach (Student1 student in st_lst)
{
foreach (Allocate al in al_list)
{
if (p.ID == al.AID && student.UOB == al.AUOB)
{
String s = student.name;
dr[counter] = s;
counter++;
}
}
}
dt.Rows.Add();
dt.Rows.InsertAt(dr, count);
count++;
}
gridControl1.DataSource = dt;
gridControl1.Refresh();
DevExpress.XtraGrid.Views.Grid.GridView view = gridControl1.MainView as DevExpress.XtraGrid.Views.Grid.GridView;
view.BestFitColumns();
view.OptionsPrint.AutoWidth = false;
}
private void gridView1_MasterRowExpanded(object sender, DevExpress.XtraGrid.Views.Grid.CustomMasterRowEventArgs e)
{
DevExpress.XtraGrid.Views.Grid.GridView aView = gridView1.GetDetailView(e.RowHandle, e.RelationIndex) as DevExpress.XtraGrid.Views.Grid.GridView;
if (aView != null)
{
aView.Columns["id"].Visible = false; //aView就是子View，设置VID 列为隐藏
aView.Columns["pid"].Visible = false;
aView.Columns["pf_yf_bh"].Caption = "原粉编号";
aView.Columns["pf_yf_sl"].Caption = "原粉数量(g)";
aView.Columns["pf_yf_bh"].OptionsColumn.AllowEdit = false;
aView.Columns["pf_yf_sl"].OptionsColumn.AllowEdit = false;
aView.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFullFocus;
aView.BestFitColumns();
}
}
private void DisplayData()
{
if (_data.DsData == null)
{
return;
}
this._bindingSource.DataSource = _data.DsData;
this._bindingSource.CurrentChanged += new EventHandler(bindingSource_CurrentChanged);
bindingSource_CurrentChanged(_bindingSource, new EventArgs());
this._bindingSource.DataMember = _data.DsData.Tables[0].TableName;
this.gcMain.DataSource = _bindingSource;
gcDetail.DataSource = _bindingSource;
gcDetail.DataMember = this._data.DrTable["TableName"].ToString();
gvMain.BestFitColumns();
gvDetail.BestFitColumns();
}
public void loadcuspro(DevExpress.XtraGrid.GridControl lvpq, DevExpress.XtraGrid.Views.Grid.GridView view)
{
view.OptionsView.ColumnAutoWidth = true;
DataTable dt = new DataTable();
DataTable temp = new DataTable();
view.Columns.Clear();
lvpq.DataSource = khach;
/*
* temp = gen.GetTable("select * from AccountingObject order by AccountingObjectCode");
* dt.Columns.Add("ID", Type.GetType("System.String"));
* dt.Columns.Add("Mã khách hàng", Type.GetType("System.String"));
* dt.Columns.Add("Tên khách hàng", Type.GetType("System.String"));
* dt.Columns.Add("Địa chỉ", Type.GetType("System.String"));
* dt.Columns.Add("Mã số thuế", Type.GetType("System.String"));
* for (int i = 0; i < temp.Rows.Count; i++)
* {
* DataRow dr = dt.NewRow();
* dr[0] = temp.Rows[i][0].ToString();
* dr[1] = temp.Rows[i][1].ToString();
* dr[2] = temp.Rows[i][2].ToString();
* dr[3] = temp.Rows[i][7].ToString();
* dr[4] = temp.Rows[i][14].ToString();
* dt.Rows.Add(dr);
* }
* lvpq.DataSource = dt;
*/
view.BestFitColumns();
view.OptionsBehavior.Editable = false;
view.OptionsSelection.EnableAppearanceFocusedCell = false;
view.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
view.Columns[0].Visible = false;
view.Columns[1].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
view.Columns[1].SummaryItem.DisplayFormat = "Số dòng: {0}";
view.ShowFindPanel();
panelControl1.Visible = false;
}
private void button2_Click(object sender, EventArgs e)
{
try
{
DevExpress.XtraGrid.Views.Grid.GridView view = gridControl1.MainView as DevExpress.XtraGrid.Views.Grid.GridView;
if (view != null)
{
view.BestFitColumns();
view.OptionsPrint.AutoWidth = false;
view.ExportToPdf("Home.pdf");
Process pdf = new Process();
pdf.StartInfo.FileName = "FoxitReader.exe";
pdf.StartInfo.Arguments = "Home.pdf";
pdf.Start();
}
}
catch (Exception a)
{
MessageBox.Show("Error: " + a);
}
}
internal static void GridEditarColumnas(DevExpress.XtraGrid.GridControl grid, bool bSoloLectura, bool bAjusteColumnas, List <string> ColumnasOcultar, bool bFechaHora, List <string> OcultarCamposDefault, List <string> ColumnasHabilitar)
{
for (int i = 0; i < grid.Views.Count; i++)
{
DevExpress.XtraGrid.Views.Grid.GridView view = (DevExpress.XtraGrid.Views.Grid.GridView)grid.Views[i];
if (view != null)
{
view.ViewCaption = view.ViewCaption.Replace("_", " ");
foreach (DevExpress.XtraGrid.Columns.GridColumn columna in view.Columns)
{
if (columna.FieldName.EndsWith("_Id"))
{
columna.Visible = false;
}
columna.Caption = columna.FieldName.Replace("_", " ").ToUpper();
columna.OptionsFilter.AutoFilterCondition = DevExpress.XtraGrid.Columns.AutoFilterCondition.Contains;
if (bSoloLectura && !ColumnasHabilitar.Contains(columna.FieldName))
{
columna.OptionsColumn.ReadOnly = true;
columna.OptionsColumn.AllowEdit = false;
}
if (ColumnasOcultar != null && ColumnasOcultar.Contains(columna.FieldName))
{
columna.Visible = false;
}
if (OcultarCamposDefault.Contains(columna.FieldName))
{
columna.Visible = false;
}
if (columna.ColumnType == typeof(DateTime))
{
if (bFechaHora)
{
columna.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
columna.DisplayFormat.FormatString = "g";
}
else
{
columna.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
columna.DisplayFormat.FormatString = "d";
}
}
if (columna.ColumnType == typeof(double))
{
columna.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
columna.DisplayFormat.FormatString = "c2";
}
}
if (bAjusteColumnas)
{
view.BestFitColumns();
}
}
}
}
/// <summary>
/// 显示所有轮胎信息
/// </summary>
public void ShowOtherMainData(string paramName, string mainId = "", string paramId = "", string paramValue = "")
{
string tableName = string.Empty;
string field1Name = string.Empty;
string field2Name = string.Empty;
XtraTabPage selectedPage = null;
LabelControl selectedLbl = null;
DevExpress.XtraGrid.GridControl selectGc = null;
DevExpress.XtraGrid.Views.Grid.GridView selectGv = null;
try
{
switch (paramName)
{
case "LTGG":
tableName = "MAIN_LTGG";
field1Name = "LTGG_ID";
field2Name = "LTGG";
selectedPage = tpLtgg;
selectedLbl = lblLtggSum;
selectGc = gcLtgg;
selectGv = gvLtgg;
break;
case "LJ":
tableName = "MAIN_LJ";
field1Name = "LJ_ID";
field2Name = "LJ";
selectedPage = tpLj;
selectedLbl = lblLjSum;
selectGc = gcLj;
selectGv = gvLj;
break;
case "ZCZBZL":
tableName = "MAIN_ZCZBZL";
field1Name = "ZCZBZL_ID";
field2Name = "ZCZBZL";
selectedPage = tpZczbzl;
selectedLbl = lblZbSum;
selectGc = gcZb;
selectGv = gvZb;
break;
default: break;
}
// 获取本地轮胎信息信息
string sql = string.Format(@"SELECT * FROM {0} WHERE 1=1", tableName);
string sqlOrder = string.Format(@" ORDER BY MAIN_ID,{0},{1}", field1Name, field2Name);
string sw = "";
if (!string.IsNullOrEmpty(mainId))
{
sw += " AND (MAIN_ID LIKE '%" + mainId + "%')";
}
if (!string.IsNullOrEmpty(paramId))
{
sw += string.Format(@" AND ({0} LIKE '%{1}%')", field1Name, paramId);
}
if (!string.IsNullOrEmpty(paramValue))
{
sw += string.Format(@" AND ({0} LIKE '%{1}%')", field2Name, paramValue);
}
DataSet ds = AccessHelper.ExecuteDataSet(AccessHelper.conn, sql + sw + sqlOrder, null);
DataTable dt = ds.Tables[0];
dt.Columns.Add("check", System.Type.GetType("System.Boolean"));
selectGc.DataSource = dt;
selectGv.BestFitColumns();
Utils.SelectItem(selectGv, false);
selectedLbl.Text = string.Format("共{0}条", dt.Rows.Count);
btnRLDCExport.SelectedTabPage = selectedPage;
}
catch (Exception ex)
{
MessageBox.Show("查询出现错误：" + ex.Message);
}
}
private void loadii(DevExpress.XtraGrid.GridControl lvpq, DevExpress.XtraGrid.Views.Grid.GridView view, string kho)
{
DataTable dt = new DataTable();
DataTable temp = new DataTable();
view.Columns.Clear();
kho = gen.GetString("select StockID from Stock where StockCode='" + kho + "'");
temp = gen.GetTable("select * from (select a.InventoryItemID,a.InventoryItemCode,a.InventoryItemName,Unit,ConvertUnit,ConvertRate,UnitPrice,SalePrice,b.InventoryCategoryName from InventoryItem a, InventoryItemCategory b where a.InventoryCategoryID=b.InventoryCategoryID) a left join (select * from StockII where StockID='" + kho + "')b on a.InventoryItemID=b.InventoryItemID order by a.InventoryItemCode,a.InventoryCategoryName");
dt.Columns.Add("ID", Type.GetType("System.String"));
dt.Columns.Add("Mã hàng hóa", Type.GetType("System.String"));
dt.Columns.Add("Tên hàng hóa", Type.GetType("System.String"));
dt.Columns.Add("Đơn vị tính", Type.GetType("System.String"));
dt.Columns.Add("Đơn vị quy đổi", Type.GetType("System.String"));
dt.Columns.Add("Tỷ lệ", Type.GetType("System.Double"));
dt.Columns.Add("Đơn giá", Type.GetType("System.Double"));
dt.Columns.Add("Đơn giá bán", Type.GetType("System.Double"));
dt.Columns.Add("Loại hàng hóa", Type.GetType("System.String"));
dt.Columns.Add("Kho", Type.GetType("System.Boolean"));
dt.Columns.Add("Chọn", Type.GetType("System.Boolean"));
for (int i = 0; i < temp.Rows.Count; i++)
{
DataRow dr = dt.NewRow();
dr[0] = temp.Rows[i][0].ToString();
dr[1] = temp.Rows[i][1].ToString();
dr[2] = temp.Rows[i][2].ToString();
dr[3] = temp.Rows[i][3].ToString();
dr[4] = temp.Rows[i][4].ToString();
if (temp.Rows[i][9].ToString() == "")
{
if (temp.Rows[i][5].ToString() != "")
{
dr[5] = temp.Rows[i][5].ToString();
}
else
{
dr[5] = 0;
}
if (temp.Rows[i][6].ToString() != "")
{
dr[6] = temp.Rows[i][6].ToString();
}
else
{
dr[6] = 0;
}
if (temp.Rows[i][7].ToString() != "")
{
dr[7] = temp.Rows[i][7].ToString();
}
else
{
dr[7] = 0;
}
dr[10] = "False";
dr[9] = "False";
}
else
{
if (temp.Rows[i][14].ToString() != "")
{
dr[5] = temp.Rows[i][14].ToString();
}
else
{
dr[5] = 0;
}
if (temp.Rows[i][15].ToString() != "")
{
dr[6] = temp.Rows[i][15].ToString();
}
else
{
dr[6] = 0;
}
if (temp.Rows[i][16].ToString() != "")
{
dr[7] = temp.Rows[i][16].ToString();
}
else
{
dr[7] = 0;
}
dr[10] = "True";
dr[9] = "True";
}
dr[8] = temp.Rows[i][8].ToString();
dt.Rows.Add(dr);
}
lvpq.DataSource = dt;
view.Columns["Tỷ lệ"].ColumnEdit = tyle;
view.Columns["Đơn giá"].ColumnEdit = dongia;
view.Columns["Đơn giá bán"].ColumnEdit = dongiaban;
view.Columns["Tỷ lệ"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
view.Columns["Tỷ lệ"].DisplayFormat.FormatString = "{0:n2}";
view.Columns["Đơn giá"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
view.Columns["Đơn giá"].DisplayFormat.FormatString = "{0:n2}";
view.Columns["Đơn giá bán"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
view.Columns["Đơn giá bán"].DisplayFormat.FormatString = "{0:n2}";
view.BestFitColumns();
view.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
view.Columns[0].Visible = false;
view.Columns[9].Visible = false;
view.Columns["Mã hàng hóa"].OptionsColumn.AllowEdit = false;
view.Columns["Tên hàng hóa"].OptionsColumn.AllowEdit = false;
view.Columns["Đơn vị tính"].OptionsColumn.AllowEdit = false;
view.Columns["Đơn vị quy đổi"].OptionsColumn.AllowEdit = false;
view.Columns["Loại hàng hóa"].OptionsColumn.AllowEdit = false;
view.Columns["Kho"].OptionsColumn.AllowEdit = false;
view.Columns[1].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
view.Columns[1].SummaryItem.DisplayFormat = "Số dòng: {0}";
}
/// <summary>
/// 显示girdview行号
/// </summary>
/// <param name="gv"></param>
public static void SetRowNum(DevExpress.XtraGrid.Views.Grid.GridView gv)
{
try
{
//添加行号
gv.IndicatorWidth = 50;
gv.CustomDrawRowIndicator += delegate(object sender, DevExpress.XtraGrid.Views.Grid.RowIndicatorCustomDrawEventArgs e)
{
e.Appearance.Font = new System.Drawing.Font("宋体", 9);
e.Info.ImageIndex = -1;
if (e.Info.IsRowIndicator && e.RowHandle >= 0)
{
e.Info.DisplayText = (e.RowHandle + 1).ToString();
}
};
//允许ctrl+c复制
gv.KeyDown += delegate(object sender, System.Windows.Forms.KeyEventArgs e)
{
if (e.Control & e.KeyCode == Keys.C)
{
Clipboard.Clear();
Clipboard.SetDataObject(gv.GetFocusedRowCellValue(gv.FocusedColumn).ToString());
e.Handled = true;
}
};
if (gv.Columns["C_EMP_ID"] != null)
{
gv.Columns["C_EMP_ID"].ColumnEdit = RV.UI.UserInfo.repoUserName;
gv.Columns["C_EMP_ID"].OptionsColumn.AllowEdit = false;
}
CommonSub commonSub = new CommonSub();
if (gv.Columns["C_SHIFT"] != null)
{
gv.Columns["C_SHIFT"].ColumnEdit = commonSub.GetBCIdDescItemComboBox();
gv.Columns["C_SHIFT"].OptionsColumn.AllowEdit = false;
}
if (gv.Columns["C_GROUP"] != null)
{
gv.Columns["C_GROUP"].ColumnEdit = commonSub.GetBZIdDescItemComboBox();
gv.Columns["C_GROUP"].OptionsColumn.AllowEdit = false;
}
if (gv.Columns["C_WE_SHIFT"] != null)
{
gv.Columns["C_WE_SHIFT"].ColumnEdit = commonSub.GetBCIdDescItemComboBox();
gv.Columns["C_WE_SHIFT"].OptionsColumn.AllowEdit = false;
}
if (gv.Columns["C_WE_GROUP"] != null)
{
gv.Columns["C_WE_GROUP"].ColumnEdit = commonSub.GetBZIdDescItemComboBox();
gv.Columns["C_WE_GROUP"].OptionsColumn.AllowEdit = false;
}
if (gv.Columns["C_PRODUCE_SHIFT"] != null)
{
gv.Columns["C_PRODUCE_SHIFT"].ColumnEdit = commonSub.GetBCIdDescItemComboBox();
gv.Columns["C_PRODUCE_SHIFT"].OptionsColumn.AllowEdit = false;
}
if (gv.Columns["C_PRODUCE_GROUP"] != null)
{
gv.Columns["C_PRODUCE_GROUP"].ColumnEdit = commonSub.GetBZIdDescItemComboBox();
gv.Columns["C_PRODUCE_GROUP"].OptionsColumn.AllowEdit = false;
}
gv.BestFitColumns();
}
catch
{
gv.BestFitColumns();
}
}
