private void InitListManager() { ucListManager.ID = "DEntityList"; ucListManager.IsChildList = false; ucListManager.ListLabel = "Entity List"; ucListManager.AllowAdd = true; ucListManager.AddBtnPostBackUrl = GetUrl(EntityEdit.PageUrl); ucListManager.NeedListInstances += new NeedListInstancesEventHandler(ucListManager_NeedListInstances); ucListManager.InstanceRowNewing += new InstanceRowNewingEventHandler(ucListManager_InstanceRowNewing); ucListManager.InstanceRowSaving += new InstanceRowSavingEventHandler(ucListManager_InstanceRowSaving); ucListManager.Columns.Add(new GridViewEditCommandColumn()); GridViewHyperLinkColumn hc = new GridViewHyperLinkColumn(); ucListManager.Columns.Add(hc); hc.Caption = "Entity Code"; hc.DataTextField = DEntityDto.FLD_Code; hc.DataNavigateUrlFormatString = string.Format("{0}?{1}={{0}}", ServerPath + EntityManager.PageUrl, EntityManager.QryEntityId); hc.DataNavigateUrlFields = new string[] { DEntityDto.FLD_StringId }; ucListManager.Columns.Add(new GridViewDataTextColumn("Description", DEntityDto.FLD_Description)); ucListManager.Columns.Add(new GridViewDataCheckColumn("Allow Add Item", DEntityDto.FLD_AllowAddItem)); ucListManager.Columns.Add(new GridViewDataCheckColumn("Allow Edit Item", DEntityDto.FLD_AllowEditItem)); ucListManager.Columns.Add(new GridViewDataCheckColumn("Allow Delete Item", DEntityDto.FLD_AllowDeleteItem)); GridViewDataCheckColumn cc = new GridViewDataCheckColumn("Is BuiltIn", DEntityDto.FLD_IsBuiltIn); ucListManager.Columns.Add(cc); cc.IsReadOnly = true; }
private void CreateDetailColumns(ASPxGridView detailGrid) { GridViewCommandColumn colCmd = new GridViewCommandColumn(); colCmd.ShowEditButton = true; colCmd.ShowNewButton = true; colCmd.ShowDeleteButton = true; detailGrid.Columns.Add(colCmd); GridViewDataColumn colProductID = new GridViewDataColumn(); colProductID.FieldName = "ProductID"; colProductID.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False; detailGrid.Columns.Add(colProductID); detailGrid.Columns.Add(new GridViewDataColumn("ProductName")); GridViewDataTextColumn colCategoryID = new GridViewDataTextColumn(); colCategoryID.FieldName = "CategoryID"; colCategoryID.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False; detailGrid.Columns.Add(colCategoryID); detailGrid.Columns.Add(new GridViewDataColumn("UnitPrice")); GridViewDataCheckColumn colDiscontinued = new GridViewDataCheckColumn(); colDiscontinued.FieldName = "Discontinued"; detailGrid.Columns.Add(colDiscontinued); }
/// <summary> /// Returns <see cref="GridViewEditDataColumn"/> instance based on meta data passed in column argument. /// </summary> /// <param name="column">An instance of <see cref="ColumnMeta"/> containing meta data of column to be created.</param> /// <param name="connectionString">Connection string to underlying database.</param> /// <returns></returns> internal static GridViewEditDataColumn AddGridViewDataColumn(ColumnMeta column, string connectionString) { GridViewEditDataColumn dataColumn = null; // As per 11 Oct 2016, the following evaluation criteria for data type and its column editor are not yet complete. // We still has some works to do to deal with picture and blob/document. (--github.com/ganagus) // --- if ((new TypeCode[] { TypeCode.String, TypeCode.Int64, TypeCode.Int32, TypeCode.Single, TypeCode.Decimal }) .Contains(column.DataType) && !column.IsForeignKey && string.IsNullOrEmpty(column.EnumTypeName)) { // regular text column, editor => text box dataColumn = AddGridViewDataTextColumn(column, dataColumn); } else if (!string.IsNullOrEmpty(column.EnumTypeName)) { // enum data type column, editor => check box dataColumn = AddGridViewEnumColumn(column, dataColumn); } // foreign key should be rendered in combo box column else if (column.IsForeignKey) { // foreign key column, it's a look up to other table, editor => combo box dataColumn = AddGridViewForeignKeyColumn(column, dataColumn, connectionString); } else if (column.DataType == TypeCode.DateTime) { // date / datetime column, editor => DevExpress date editor dataColumn = new GridViewDataDateColumn(); if (column.Name.ToLower() == "createddate" || column.Name.ToLower() == "modifieddate") { //hide createdby, createddate, modifiedby, modifieddate from edit form //dataColumn.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False; } } else if (column.DataType == TypeCode.Boolean) { // boolean column, editor => check box dataColumn = new GridViewDataCheckColumn(); } else { // other data type, default to text box dataColumn = new GridViewDataTextColumn(); } if (column.IsIdentity) { dataColumn.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False; } dataColumn.FieldName = column.Name; dataColumn.Caption = column.Caption; dataColumn.VisibleIndex = column.OrderNo; return(dataColumn); }
/// <summary> /// Ham tạo Column cho Gridview loại GridViewDataCheckColumn /// </summary> /// <param name="Caption">Tiêu đề cho column</param> /// <param name="FieldName">FieldName cho column</param> /// <param name="Width">Độ rộng cho column</param> /// <returns>GridViewDataCheckColumn</returns> public GridViewDataCheckColumn BuildCheckColumn(string Caption, string FieldName, string Alias, int Width) { GridViewDataCheckColumn checkColumn = new GridViewDataCheckColumn(); checkColumn.Caption = Caption; checkColumn.FieldName = Alias + FieldName; checkColumn.MinWidth = 80; if (Width != 0) checkColumn.Width = Unit.Pixel(Width); return checkColumn; }
private void loadMasterData() { dthiDTO = new clsDiaDiemThi_DTO(); DataTable dt = new DataTable(); dt = dthiDAL.getDiaDiemThi(dthiDTO); cboDiemThi.ValueField = "MaDiemThi"; cboDiemThi.TextField = "DiaChi"; cboDiemThi.DataSource = dt; cboDiemThi.DataBind(); //GridViewDataComboBoxColumn gclDiemThi = gvPhongThi.Columns["DiaChi"] as GridViewDataComboBoxColumn; //gclDiemThi.PropertiesComboBox.DataSource = dt; //gclDiemThi.PropertiesComboBox.ValueField = "MaDienThi"; //gclDiemThi.PropertiesComboBox.TextField = "TenDiemThi"; GridViewDataCheckColumn gclTrangThai = gvPhongThi.Columns["TrangThai"] as GridViewDataCheckColumn; gclTrangThai.PropertiesCheckEdit.DisplayTextChecked = "Chon"; }
internal static void BuildColumnsByEntity(BusinessMapper.eEntities entidad, ASPxGridView gv) { if (BusinessMapper.AbmConfigXmlPath == null || BusinessMapper.AbmConfigXmlPath == string.Empty) throw new Exception("Path del archivo AbmConfig.xml sin definir."); XmlDocument xDoc = new XmlDocument(); xDoc.Load(BusinessMapper.AbmConfigXmlPath); gv.Columns.Clear(); if (xDoc.SelectSingleNode( "Entities/Entity[@EntityName='" + entidad.ToString() + "']") == null) throw new AbmConfigXMLException("No existe la configuración de mapeo para la entidad: " + entidad.ToString()); foreach (XmlNode nodeControl in xDoc.SelectSingleNode( "Entities/Entity[@EntityName='" + entidad.ToString() + "']").ChildNodes) { if (nodeControl.Attributes["ControlType"].Value == "ComboBox") { GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; var mapInfo = BusinessMapper.GetMapInfo(nodeControl.Attributes["EntityName"].Value); gvc.PropertiesComboBox.TextField = mapInfo.EntityTextField; gvc.PropertiesComboBox.ValueField = mapInfo.EntityValueField; gvc.PropertiesComboBox.DataSource = mapInfo.DAOHandler.ReadAll(""); gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "RadioButtonList") { GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gvc.PropertiesComboBox.Items.Clear(); foreach (XmlNode item in nodeControl.ChildNodes[0].ChildNodes) { gvc.PropertiesComboBox.Items.Add(item.Attributes["Name"].Value, item.Attributes["Value"].Value); } gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "TextBox" || nodeControl.Attributes["ControlType"].Value == "SpinEdit" || nodeControl.Attributes["ControlType"].Value == "TimeEdit") { GridViewDataTextColumn gvc = new GridViewDataTextColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "DateEdit") { GridViewDataDateColumn gvc = new GridViewDataDateColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "CheckBox") { GridViewDataCheckColumn gvc = new GridViewDataCheckColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gv.Columns.Add(gvc); } } }
internal static void BuildColumnsByEntity(BusinessMapper.eEntities entidad, ASPxGridView gv) { if (BusinessMapper.AbmConfigXmlPath == null || BusinessMapper.AbmConfigXmlPath == string.Empty) { throw new Exception("Path del archivo AbmConfig.xml sin definir."); } XmlDocument xDoc = new XmlDocument(); xDoc.Load(BusinessMapper.AbmConfigXmlPath); gv.Columns.Clear(); if (xDoc.SelectSingleNode( "Entities/Entity[@EntityName='" + entidad.ToString() + "']") == null) { throw new AbmConfigXMLException("No existe la configuración de mapeo para la entidad: " + entidad.ToString()); } foreach (XmlNode nodeControl in xDoc.SelectSingleNode( "Entities/Entity[@EntityName='" + entidad.ToString() + "']").ChildNodes) { if (nodeControl.Attributes["ControlType"].Value == "ComboBox") { GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; var mapInfo = BusinessMapper.GetMapInfo(nodeControl.Attributes["EntityName"].Value); gvc.PropertiesComboBox.TextField = mapInfo.EntityTextField; gvc.PropertiesComboBox.ValueField = mapInfo.EntityValueField; gvc.PropertiesComboBox.DataSource = mapInfo.DAOHandler.ReadAll(""); gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "RadioButtonList") { GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gvc.PropertiesComboBox.Items.Clear(); foreach (XmlNode item in nodeControl.ChildNodes[0].ChildNodes) { gvc.PropertiesComboBox.Items.Add(item.Attributes["Name"].Value, item.Attributes["Value"].Value); } gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "TextBox" || nodeControl.Attributes["ControlType"].Value == "SpinEdit" || nodeControl.Attributes["ControlType"].Value == "TimeEdit") { GridViewDataTextColumn gvc = new GridViewDataTextColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "DateEdit") { GridViewDataDateColumn gvc = new GridViewDataDateColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "CheckBox") { GridViewDataCheckColumn gvc = new GridViewDataCheckColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gv.Columns.Add(gvc); } } }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["user"] == null) { Response.Redirect("~/Default.aspx"); } else { if (!new UserSecurity().CheckFormPermission((int)Global.formSecurity.Sallary, Request.Cookies["user"]["Permission"].ToString())) { Response.Redirect("~/HR/UnAuthorized.aspx"); } } //HashSet<string> addedColumns = new HashSet<string>{{ "ID", "EmpName", "EmpCode", "totalPenalty", "VacationsWithDeduction", "totalLiability", "FinalSalary", "Paid" }; ResourceManager rm; if (Session["lang"] == "ar-EG") { rm = new ResourceManager("Sallary.ar-EG", System.Reflection.Assembly.GetExecutingAssembly()); } else { rm = new ResourceManager("Sallary", System.Reflection.Assembly.GetExecutingAssembly()); } if (!IsPostBack) { PayGrades pg = new PayGrades(); pg.getSallaryItems(); DataTable dt = pg.PayGradesSallaryItems; GridViewDataColumn ThisBool = new GridViewDataColumn(); //ThisBool = (GridViewColumn)ASPxGridView1.Columns[0]; //ASPxGridView1.Columns.Clear(); //ASPxGridView1.Columns.Add(ThisBool); DataRow dr = dt.NewRow(); dr["Name"] = "EmpID"; dt.Rows.InsertAt(dr, 0); dr = dt.NewRow(); dr["Name"] = "EmpName"; dt.Rows.InsertAt(dr, 1); dr = dt.NewRow(); dr["Name"] = "EmpCode"; dt.Rows.InsertAt(dr, 2); dr = dt.NewRow(); dr["Name"] = "totalPenalty"; dt.Rows.InsertAt(dr, dt.Rows.Count); dr = dt.NewRow(); dr["Name"] = "VacationsWithDeduction"; dt.Rows.InsertAt(dr, dt.Rows.Count); dr = dt.NewRow(); dr["Name"] = "totalLiability"; dt.Rows.InsertAt(dr, dt.Rows.Count); dr = dt.NewRow(); dr["Name"] = "FinalSalary"; dt.Rows.InsertAt(dr, dt.Rows.Count); dr = dt.NewRow(); dr["Name"] = "Paid"; dt.Rows.InsertAt(dr, dt.Rows.Count); /*dr["Name"] = "EmpID"; * dt.Rows.InsertAt(dr, 0); * dr = dt.NewRow(); * dr["Name"] = GetLocalResourceObject("EmpName").ToString(); * dt.Rows.InsertAt(dr, 1); * dr = dt.NewRow(); * dr["Name"] = GetLocalResourceObject("EmpCode").ToString(); * dt.Rows.InsertAt(dr, 2); * dr = dt.NewRow(); * dr["Name"] = GetLocalResourceObject("totalPenalty").ToString(); * dt.Rows.InsertAt(dr, dt.Rows.Count); * dr = dt.NewRow(); * dr["Name"] = GetLocalResourceObject("VacationsWithDeduction").ToString(); * dt.Rows.InsertAt(dr, dt.Rows.Count); * dr = dt.NewRow(); * dr["Name"] = GetLocalResourceObject("totalLiability").ToString(); * dt.Rows.InsertAt(dr, dt.Rows.Count); * dr = dt.NewRow(); * dr["Name"] = GetLocalResourceObject("FinalSalary").ToString(); * dt.Rows.InsertAt(dr, dt.Rows.Count); * dr = dt.NewRow(); * dr["Name"] = GetLocalResourceObject("Paid").ToString(); * dt.Rows.InsertAt(dr, dt.Rows.Count);*/ /* dt.Rows.InsertAt(dr, 1); * dt.Columns.Add("EmpID"); * dt.Columns.Add("EmpName"); * dt.Columns.Add("EmpCode"); * dt.Columns.Add("totalDeserved"); * dt.Columns.Add("totalLiability"); * dt.Columns.Add("FinalSalary"); * dt.Columns.Add("Paid");*/ int added = 0; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Name"] != "Paid") { if (dt.Rows[i]["Nature"].ToString() == "2" && added == 0) { ThisBool = new GridViewDataColumn(); ThisBool.Caption = GetLocalResourceObject("Rewards").ToString(); ThisBool.FieldName = "Rewards"; ThisBool.Visible = true; ASPxGridView1.Columns.Add(ThisBool); ThisBool = new GridViewDataColumn(); ThisBool.Caption = GetLocalResourceObject("totalDeserved").ToString(); ThisBool.FieldName = "totalDeserved"; ThisBool.Visible = true; ASPxGridView1.Columns.Add(ThisBool); added = 1; } ThisBool = new GridViewDataColumn(); if (GetLocalResourceObject(dt.Rows[i]["Name"].ToString()) != null) { ThisBool.Caption = GetLocalResourceObject(dt.Rows[i]["Name"].ToString()).ToString(); } else { ThisBool.Caption = dt.Rows[i]["Name"].ToString(); } ThisBool.FieldName = dt.Rows[i]["Name"].ToString(); if (dt.Rows[i]["Name"].ToString() == "EmpID") { ThisBool.Visible = false; } else { ThisBool.Visible = true; } ASPxGridView1.Columns.Add(ThisBool); } else { GridViewDataCheckColumn ThisBool2 = new GridViewDataCheckColumn(); ThisBool2.Caption = GetLocalResourceObject("Paid").ToString(); ThisBool2.FieldName = "Paid"; ThisBool2.Visible = true; ASPxGridView1.Columns.Add(ThisBool2); } } } else { if (ddlMonth.SelectedValue != "" && ddlYear.SelectedValue != "") { FillGrid(); DataTable dt = (DataTable)Session["table"]; ASPxGridView1.DataSource = dt; // ThisBool.FieldName = "Discontinued"; ASPxGridView1.DataBind(); } } AddSubmitEvent(); }