private object[] GetDeleteEmpList(UltraWebGrid ugrd, int deleteCount) { object[] objEmp = new object[(deleteCount == 0 ? ugrd.Rows.Count : deleteCount)]; int i = 0; if (deleteCount == 0) { foreach (UltraGridRow gr in ugrd.Rows) { objEmp[i] = gr.Cells.FromKey("EMP_REF_ID").Value; i++; } } else { TemplatedColumn col_Check; foreach (UltraGridRow gr in ugrd.Rows) { col_Check = (TemplatedColumn)gr.Cells.FromKey("selchk").Column; if (((CheckBox)((CellItem)col_Check.CellItems[gr.BandIndex]).FindControl("cBox")).Checked) { objEmp[i] = gr.Cells.FromKey("EMP_REF_ID").Value; i++; } } } return(objEmp); }
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e) { UltraWebGrid uwg = (UltraWebGrid)e.Layout.Grid; ColumnsCollection AirlineCols = uwg.Bands[0].Columns; ColumnsCollection WeightBreakCols = uwg.Bands[1].Columns; AirlineCols.FromKey("airline").Hidden = true; WeightBreakCols.FromKey("airline").Hidden = true; AirlineCols.FromKey("dba_name").Header.Caption = "Airline"; AirlineCols.FromKey("carrier_code").Header.Caption = "Carrier Code"; AirlineCols.FromKey("share").Header.Caption = "Profit Share (%)"; WeightBreakCols.FromKey("weight_break").Header.Caption = "Weight Break"; WeightBreakCols.FromKey("kg_lb").Header.Caption = "Kg/Lb"; WeightBreakCols.FromKey("rate").Header.Caption = "Freight Charge Rate"; WeightBreakCols.FromKey("fl_rate").Header.Caption = "Fuel Surcharge Rate"; WeightBreakCols.FromKey("sec_rate").Header.Caption = "Securoty Surcharge Rate"; WeightBreakCols.FromKey("weight_break").Width = Unit.Pixel(100); WeightBreakCols.FromKey("kg_lb").Width = Unit.Pixel(35); WeightBreakCols.FromKey("rate").Width = Unit.Pixel(60); WeightBreakCols.FromKey("fl_rate").Width = Unit.Pixel(60); WeightBreakCols.FromKey("sec_rate").Width = Unit.Pixel(60); }
/// <summary> /// 删除抄送人员 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDelActorCopy_ServerClick(object sender, System.EventArgs e) { try { Procedure procedure = (Procedure)Session["Procedure"]; Task task = (Task)Session["Task"]; task.RemoveTaskActor(this.DelObjectCode.Value, false); DataSet ds = Rms.WorkFlow.DefinitionManager.SaveProcedureDefinitionData(procedure); UltraWebGrid UWGridCopyCase = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(1).FindControl("UltraWebGrid3")); UWGridCopyCase.DataSource = new DataView(ds.Tables["WorkFlowTaskActor"], String.Format("TaskCode='{0}' and TaskActorID='1'", task.TaskCode), "IOrder", DataViewRowState.CurrentRows); UWGridCopyCase.DataBind(); for (int i = 0; i < UWGridCopyCase.Rows.Count; i++) { if ((string)UWGridCopyCase.Rows[i].Cells[6].Value == "1") { UWGridCopyCase.Rows[i].Cells[4].Value = true; } else { UWGridCopyCase.Rows[i].Cells[4].Value = false; } UWGridCopyCase.Rows[i].Cells[7].Value = "<a href='javascript:deleteActor(\"" + (string)UWGridCopyCase.Rows[i].Cells[0].Value + "\",\"1\")'>删除</a>"; } Session["Procedure"] = procedure; } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); } }
public GridHelper(UltraWebGrid grid, System.Web.UI.WebControls.CheckBox chbSelectAll) { this._grid = grid; this._chbSelectAll = chbSelectAll; this.InitGridHelper(); }
private void SetAllTimeTop() { ltrScript.Text = ""; TugrdUpStgList = this.ugwtKpiTab.FindControl("ugrdUpStgList") as UltraWebGrid; TugrdStgPerDept = this.ugwtKpiTab.FindControl("ugrdStgPerDept") as UltraWebGrid; TiBtnAddUpStg = this.ugwtKpiTab.FindControl("iBtnAddUpStg") as ImageButton; TiBtnDelUpStg = this.ugwtKpiTab.FindControl("iBtnDelUpStg") as ImageButton; TugrdKPIPerStg = this.ugwtKpiTab.FindControl("ugrdKPIPerStg") as UltraWebGrid; TugrdKPIAll = this.ugwtKpiTab.FindControl("ugrdKPIAll") as UltraWebGrid; TiBtnAddKpi = this.ugwtKpiTab.FindControl("iBtnAddKpi") as ImageButton; TiBtnDelKpi = this.ugwtKpiTab.FindControl("iBtnDelKpi") as ImageButton; TiBtnFindKpi = this.ugwtKpiTab.FindControl("iBtnFindKpi") as ImageButton; TtxtFindKpiID = this.ugwtKpiTab.FindControl("txtFindKpiID") as TextBox; TtxtFindKpiNM = this.ugwtKpiTab.FindControl("txtFindKpiNM") as TextBox; TlblWeightTotal = this.ugwtKpiTab.FindControl("lblWeightTotal") as Label; MicroBSC.Biz.Common.Biz.Biz_Com_Code_Info objCode = new MicroBSC.Biz.Common.Biz.Biz_Com_Code_Info(); ddlMAP_KPI_TYPE_H.DataSource = objCode.GetCodeListPerCategory("BS0017", "Y").Tables[0]; ddlMAP_KPI_TYPE_H.DataTextField = "CODE_NAME"; ddlMAP_KPI_TYPE_H.DataValueField = "ETC_CODE"; ddlMAP_KPI_TYPE_H.DataBind(); ddlMAP_KPI_TYPE_H.Items.Insert(0, new ListItem("::선택::", "")); }
protected void initEnvironment() { exMsg.Text = ""; lblRowCount.Text = "0"; UltraWebGrid.Clear(); ltrScript.Text = ""; ibtnDownExcel.Visible = false; }
protected void InitializeUWG(object sender, LayoutEventArgs e) { UltraWebGrid uwg = (UltraWebGrid)e.Layout.Grid; e.Layout.Bands[0].DataKeyField = "elt_account_number,rate_type,origin_port,dest_port,kg_lb,customer_no"; e.Layout.Bands[1].DataKeyField = "elt_account_number,rate_type,origin_port,dest_port,kg_lb,customer_no,airline"; e.Layout.Bands[2].DataKeyField = "elt_account_number,rate_type,origin_port,dest_port,kg_lb,customer_no,airline,item_no"; FormatColumns(uwg); }
protected void Page_Load(object sender, EventArgs e) { UltraWebGrid uwg = (UltraWebGrid)RateWebGrid.FindControl("UltraWebGrid1"); uwg.InitializeLayout += new InitializeLayoutEventHandler(this.InitializeUWG); DropDownList lst = (DropDownList)RateWebGrid.FindControl("lstRateTypes"); lst.SelectedValue = rate_type; }
/// ******************************************************************************************* /// <summary> /// 角色列表特殊字段帮定,格式化 /// </summary> /// ******************************************************************************************* private void RoleGridDataBound() { Procedure procedure = (Procedure)Session["Procedure"]; UltraWebGrid UWGridCase3 = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(2).FindControl("UltraWebGrid3")); for (int i = 0; i < UWGridCase3.Rows.Count; i++) { if ((string)UWGridCase3.Rows[i].Cells[5].Value == "1") { UWGridCase3.Rows[i].Cells[2].Value = true; } else if ((string)UWGridCase3.Rows[i].Cells[5].Value == "2") { UWGridCase3.Rows[i].Cells[2].Value = true; //UWGridCase3.Rows[i]. = ; } else { UWGridCase3.Rows[i].Cells[2].Value = false; } string UserCodes = ""; string StationCodes = ""; Role RoleCase = procedure.GetRole((string)UWGridCase3.Rows[i].Cells[0].Value); System.Collections.IDictionaryEnumerator ieRoleComprise = RoleCase.GetRoleCompriseEnumerator(); while (ieRoleComprise.MoveNext()) { RoleComprise RoleCompriseCase = (RoleComprise)ieRoleComprise.Value; if (RoleCompriseCase.RoleType == RoleType.Porson) { if (UserCodes == "") { UserCodes = RoleCompriseCase.RoleCompriseItem; } else { UserCodes += "," + RoleCompriseCase.RoleCompriseItem; } } if (RoleCompriseCase.RoleType == RoleType.Station) { if (StationCodes == "") { StationCodes = RoleCompriseCase.RoleCompriseItem; } else { StationCodes += "," + RoleCompriseCase.RoleCompriseItem; } } } UWGridCase3.Rows[i].Cells[4].Value = "<a href='#' onclick='javascript:SelectRoleComprise(\"" + (string)UWGridCase3.Rows[i].Cells[0].Value + "\",\"" + UserCodes + "\",\"" + StationCodes + "\");return false;'>角色维护</a>"; } }
private object[,] GetInsertEmpList(UltraWebGrid ugrd, int addedCount) { object[,] objEmp = new object[(addedCount == 0 ? ugrd.Rows.Count : addedCount), 2]; for (int i = (addedCount == 0 ? 0 : ugrd.Rows.Count - addedCount); i < ugrd.Rows.Count; i++) { objEmp[(addedCount == 0 ? i : i - (ugrd.Rows.Count - addedCount)), 0] = DataTypeUtility.GetToInt32(ugrd.Rows[i].Cells.FromKey("EMP_REF_ID").Value); objEmp[(addedCount == 0 ? i : i - (ugrd.Rows.Count - addedCount)), 1] = DataTypeUtility.GetToInt32(ugrd.Rows[i].Cells.FromKey("SORT_ORDER").Value); } return(objEmp); }
private void SetSortOrder(UltraWebGrid ugrd) { for (int i = 0; i < ugrd.Rows.Count; i++) { if (DataTypeUtility.GetToInt32(ugrd.Rows[i].Cells.FromKey("SORT_ORDER").Value) != i + 1) { ugrd.Rows[i].Cells.FromKey("SORT_ORDER").Value = i + 1; } } }
private void InitializeGrid(UltraWebGrid grid) { Infragistics.WebUI.UltraWebGrid.ColumnHeader ch; foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in grid.DisplayLayout.Bands[0].Columns) { c.Header.RowLayoutColumnInfo.OriginY = 1; } // 단일 헤더 합침 ch = grid.DisplayLayout.Bands[0].Columns.FromKey("PRJ_CODE").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = grid.DisplayLayout.Bands[0].Columns.FromKey("PRJ_NAME").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = grid.DisplayLayout.Bands[0].Columns.FromKey("PROCEED_RATE").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = grid.DisplayLayout.Bands[0].Columns.FromKey("OWNER_EMP_NAME").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = grid.DisplayLayout.Bands[0].Columns.FromKey("TASK_OWNER_NAME").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = grid.DisplayLayout.Bands[0].Columns.FromKey("EFFECTIVENESS").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Caption = "계획기간"; ch.RowLayoutColumnInfo.OriginY = 0; ch.RowLayoutColumnInfo.OriginX = 8; ch.RowLayoutColumnInfo.SpanX = 2; ch.Style.Height = Unit.Pixel(20); grid.DisplayLayout.Bands[0].HeaderLayout.Add(ch); grid.DisplayLayout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center; ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Caption = "비 용"; ch.RowLayoutColumnInfo.OriginY = 0; ch.RowLayoutColumnInfo.OriginX = 10; ch.RowLayoutColumnInfo.SpanX = 2; ch.Style.Height = Unit.Pixel(20); grid.DisplayLayout.Bands[0].HeaderLayout.Add(ch); grid.DisplayLayout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center; }
protected void Page_Load(object sender, EventArgs e) { TugrdQuestionItem = this.ugrdKpiStatusTab.FindControl("ugrdQuestionItem") as UltraWebGrid; ltrScript.Text = ""; if (!Page.IsPostBack) { this.SetFormData(); this.SetButton(); } }
private void DoFocusLine(UltraWebGrid ugrd, int emp_ref_id) { foreach (UltraGridRow gr in ugrd.Rows) { if (DataTypeUtility.GetToInt32(gr.Cells.FromKey("EMP_REF_ID")) == emp_ref_id) { gr.Selected = true; gr.Activate(); return; } } }
/// ******************************************************************************************* /// <summary> /// 加载路由数据 /// </summary> /// ******************************************************************************************* private void RouterGridDataBound() { Procedure procedure = (Procedure)Session["Procedure"]; DataSet procedureDS = Rms.WorkFlow.DefinitionManager.SaveProcedureDefinitionData(procedure); BLL.WorkFlowRule.FillRouterTaskName(procedureDS); UltraWebGrid UWGridCase2 = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(1).FindControl("UltraWebGrid2")); UWGridCase2.DataSource = new DataView(procedureDS.Tables["WorkFlowRouter"], "", "SortID", DataViewRowState.CurrentRows); UWGridCase2.DataBind(); for (int i = 0; i < UWGridCase2.Rows.Count; i++) { UWGridCase2.Rows[i].Cells[6].Value = "<a href='javascript:deleteRouter(" + (string)UWGridCase2.Rows[i].Cells[0].Value + ")'>删除</a>"; foreach (DataRow drw in procedureDS.Tables["WorkFlowCondition"].Select("RouterCode='" + UWGridCase2.Rows[i].Cells[0].Value + "'")) { UWGridCase2.Rows[i].Cells[5].Value = drw["Description"].ToString(); } } ValueList contactTypeFromTask = UWGridCase2.Columns[2].ValueList; ValueList contactTypeToTask = UWGridCase2.Columns[3].ValueList; System.Collections.IDictionaryEnumerator ie = procedure.GetTaskEnumerator(); DataTable dt = new DataTable(); dt.Columns.Add("TaskCode"); dt.Columns.Add("TaskName"); dt.Columns.Add("TaskID"); while (ie.MoveNext()) { Task task = (Task)ie.Value; DataRow drNew = dt.NewRow(); drNew["TaskCode"] = task.TaskCode; drNew["TaskName"] = task.TaskName; drNew["TaskID"] = task.TaskID; dt.Rows.Add(drNew); // contactTypeFromTask.ValueListItems.Add(task.TaskCode,task.TaskName); // contactTypeToTask.ValueListItems.Add(task.TaskCode,task.TaskName); } foreach (DataRow dr in dt.Select("", "TaskID", System.Data.DataViewRowState.CurrentRows)) { contactTypeFromTask.ValueListItems.Add(dr["TaskCode"].ToString(), dr["TaskName"].ToString()); contactTypeToTask.ValueListItems.Add(dr["TaskCode"].ToString(), dr["TaskName"].ToString()); } }
/// <summary> /// 체크박스가 있는 그리드에서 체크되어 있는 값을 반영된 DataTable에 넣어주어서 /// 반환한다. /// </summary> /// <param name="ultraWebGrid"></param> /// <param name="checkBoxID"></param> /// <param name="cellKey_checkBox"></param> /// <param name="cellKey_value"></param> /// <param name="blankDataTable"></param> /// <returns></returns> public static DataTable GetDataTableByCheckValue(UltraWebGrid ultraWebGrid , string checkBoxID , string cellKey_checkBox , string[] cellKey_values , DataTable blankDataTable) { return(GetDataTableByCheckValue(ultraWebGrid , checkBoxID , cellKey_checkBox , cellKey_values , blankDataTable , false)); }
private void DoDeleteEmp(UltraWebGrid ugrdDel, int delCount) { //for (int i = ugrdDel.Rows.Count - 1; i < delCount; i++) //{ // ugrdDel.Rows[ugrdDel.Rows.Count - 1].Delete(); //} int j = ugrdDel.Rows.Count; for (int i = ugrdDel.Rows.Count - 1; i > j - delCount - 1; i--) { ugrdDel.Rows[i].Delete(); } }
private int GetSortOrder(UltraWebGrid gr) { int rtnValue = 0; for (int i = 0; i < gr.Rows.Count - 1; i++) { if (DataTypeUtility.GetToInt32(gr.Rows[i].Cells.FromKey("SORT_ORDER").Value) > rtnValue) { rtnValue = DataTypeUtility.GetToInt32(gr.Rows[i].Cells.FromKey("SORT_ORDER").Value); } } return(rtnValue + 1); }
/// ******************************************************************************************* /// <summary> /// 加载数据帮定列表 /// </summary> /// ******************************************************************************************* private void LoadDataGrid() { Procedure procedure = (Procedure)Session["Procedure"]; UltraWebGrid UWGridCase3 = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(2).FindControl("UltraWebGrid3")); UltraWebGrid UWGridCase4 = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(3).FindControl("UltraWebGrid4")); DataGrid dgList1 = ((DataGrid)this.UltraWebTab1.Tabs.GetTab(1).FindControl("dgList")); DataSet procedureDS = Rms.WorkFlow.DefinitionManager.SaveProcedureDefinitionData(procedure); //任务帮定 TaskGridDataBound(); //路由帮定 RouterGridDataBound(); //角色帮定 UWGridCase3.DataSource = new DataView(procedureDS.Tables["WorkFlowRole"], "", "Remak", DataViewRowState.CurrentRows); UWGridCase3.DataBind(); for (int i = 0; i < UWGridCase3.Rows.Count; i++) { UWGridCase3.Rows[i].Cells[6].Value = "<a href='javascript:deleteRole(\"" + (string)UWGridCase3.Rows[i].Cells[0].Value + "\")'>删除</a>"; } RoleGridDataBound(); if (Request["Debug"] + "" == "1") { //属性帮定 UWGridCase4.DataSource = new DataView(procedureDS.Tables["WorkFlowProcedureProperty"], "", "Remak", DataViewRowState.CurrentRows); UWGridCase4.DataBind(); dgList1.DataSource = new DataView(procedureDS.Tables["WorkFlowProcedureProperty"], "", "", DataViewRowState.CurrentRows); dgList1.DataBind(); for (int i = 0; i < UWGridCase4.Rows.Count; i++) { UWGridCase4.Rows[i].Cells[4].Value = "<a href='javascript:deleteProperty(\"" + (string)UWGridCase4.Rows[i].Cells[0].Value + "\")'>删除</a>"; } this.RoleTypeBound(UWGridCase4.Columns[2].ValueList); this.UltraWebTab1.Tabs[3].Visible = true; } else { this.UltraWebTab1.Tabs[3].Visible = false; } procedureDS.Dispose(); }
private int GetEmpCount(UltraWebGrid gr) { int rtnValue = 0; TemplatedColumn col_Check; foreach (UltraGridRow insertGR in gr.Rows) { col_Check = (TemplatedColumn)insertGR.Cells.FromKey("selchk").Column; if (((CheckBox)((CellItem)col_Check.CellItems[insertGR.BandIndex]).FindControl("cBox")).Checked) { rtnValue++; } } return(rtnValue); }
public static bool EnableSort(ref UltraWebGrid dg, int sortColIndex) { // Call this method and then rely on index to process sort! if (dg.Page != null) { if (dg.Columns.FromKey("s_a") != null) { dg.Columns.Remove(dg.Columns.FromKey("s_a")); } UltraGridColumn sortCol = new UltraGridColumn("s_a", "", ColumnType.NotSet, null); dg.Columns.Insert(sortColIndex, sortCol); dg.Columns.FromKey("s_a").Width = Unit.Pixel(35); return(true); } return(false); }
protected void Page_Load(object sender, EventArgs e) { TugrdBias = this.ugrdKpiStatusTab.FindControl("ugrdBias") as UltraWebGrid; TchartBias = this.ugrdKpiStatusTab.FindControl("chartBias") as Chart; TddlEstGroup = this.ugrdKpiStatusTab.FindControl("ddlEstGroup") as DropDownList; if (!IsPostBack) { this.SetEstGroup(); this.SetInitForm(); this.SetEstStatusGrid(); //this.SetPointsForGraph(); } else { } }
private void CheckBind(UltraWebGrid grid) { int EsttermRefID; int kpiRefID; int prjRefID; foreach (UltraGridRow row in grid.Rows) { EsttermRefID = DataTypeUtility.GetToInt32(row.Cells.FromKey("ESTTERM_REF_ID").Value); kpiRefID = DataTypeUtility.GetToInt32(row.Cells.FromKey("KPI_REF_ID").Value); Biz_Bsc_Kpi_Prj objKpiPrj = new Biz_Bsc_Kpi_Prj(); foreach (UltraGridColumn col in grid.Columns) { try { prjRefID = DataTypeUtility.GetToInt32(col.Header.Column.Key); } catch { prjRefID = 0; } if (prjRefID != 0) { DataTable dt = objKpiPrj.GetOneList(EsttermRefID , kpiRefID , prjRefID).Tables[0]; if (dt.Rows.Count == 0 || dt.Rows.Count > 1) { continue; } else { if (DataTypeUtility.GetToInt32(dt.Rows[0]["KPI_REF_ID"]) == kpiRefID && DataTypeUtility.GetToInt32(dt.Rows[0]["PRJ_REF_ID"]) == prjRefID) { row.Cells.FromKey(col.Header.Column.Key).Value = "<img src='../images/checkbox.gif' border='0' width='15px' height='15px' valign='middle'>"; // row.Cells.FromKey(col.Header.Column.Key).Value = "V"; } } } } } }
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e) { UltraWebGrid uwg = (UltraWebGrid)e.Layout.Grid; ColumnsCollection disputeTotal = uwg.Bands[0].Columns; ColumnsCollection disputeItem = uwg.Bands[1].Columns; disputeTotal.FromKey("elt_account_number").Hidden = true; disputeTotal.FromKey("org_account_number").Hidden = true; disputeItem.FromKey("elt_account_number").Hidden = true; disputeItem.FromKey("vendor_number").Hidden = true; disputeItem.FromKey("memo").Hidden = true; disputeTotal.FromKey("dba_name").Header.Caption = "Vendor"; disputeTotal.FromKey("class_code").Header.Caption = "Class"; disputeTotal.FromKey("business_phone").Header.Caption = "Phone"; disputeItem.FromKey("print_id").Header.Caption = "Tran No"; disputeItem.FromKey("bill_number").Header.Caption = "Bill No"; disputeItem.FromKey("bill_date").Header.Caption = "Tran Date"; disputeItem.FromKey("pmt_method").Header.Caption = "Payment"; disputeItem.FromKey("memo").Header.Caption = "Memo"; disputeItem.FromKey("file_no").Header.Caption = "File No"; disputeItem.FromKey("amt_due").Header.Caption = "Due Amount"; disputeItem.FromKey("amt_paid").Header.Caption = "Paid Amount"; disputeItem.FromKey("amt_dispute").Header.Caption = "Disputed Amount"; disputeTotal.FromKey("dba_name").Width = Unit.Pixel(267); disputeTotal.FromKey("class_code").Width = Unit.Pixel(80); disputeTotal.FromKey("business_phone").Width = Unit.Pixel(100); disputeTotal.FromKey("Bill Amount").Width = Unit.Pixel(100); disputeTotal.FromKey("Paid Amount").Width = Unit.Pixel(100); disputeTotal.FromKey("Balance").Width = Unit.Pixel(100); disputeTotal.FromKey("Dispute Amount").Width = Unit.Pixel(100); disputeItem.FromKey("bill_number").Width = Unit.Pixel(100); disputeItem.FromKey("print_id").Width = Unit.Pixel(100); disputeItem.FromKey("bill_date").Width = Unit.Pixel(80); disputeItem.FromKey("file_no").Width = Unit.Pixel(165); disputeItem.FromKey("pmt_method").Width = Unit.Pixel(70); disputeItem.FromKey("amt_due").Width = Unit.Pixel(100); disputeItem.FromKey("amt_paid").Width = Unit.Pixel(100); disputeItem.FromKey("amt_dispute").Width = Unit.Pixel(100); disputeItem.FromKey("bill_date").Format = "MM/dd/yyyy"; }
public bool IsInExport = false; // Added by Icyer 2006/12/26 @ YHI 标识是否导出操作,如果是导出则不用计算总数 public WebQueryHelper( HtmlInputButton queryButton, HtmlInputButton exportButton, UltraWebGrid grid, PagerSizeSelector selector, PagerToolBar toolBar, ControlLibrary.Web.Language.LanguageComponent languageComponent) { //variable this.cmdQuery = queryButton; this.cmdGridExport = exportButton; this.gridWebGrid = grid; this.pagerSizeSelector = selector; this.pagerToolBar = toolBar; this.languageComponent1 = languageComponent; //export this.excelExporter = new BenQGuru.eMES.Web.Helper.ExcelExporter(); this.excelExporter.Page = this.gridWebGrid.Page; this.excelExporter.FormatExportRecordHandle = new FormatExportRecordDelegate(this.FormatExportRecord); this.excelExporter.LoadExportDataHandle = new LoadExportDataDelegate(this.LoadDataSource); this.excelExporter.LanguageComponent = this.languageComponent1; this.excelExporter.GetColumnHeaderTextHandle = new GetColumnHeaderTextDelegate(GetColumnHeaderText); //register event if (this.cmdQuery != null) { this.cmdQuery.ServerClick += new EventHandler(cmdQuery_ServerClick); } if (this.cmdGridExport != null) { this.cmdGridExport.ServerClick += new EventHandler(cmdGridExport_ServerClick); } if (this.gridWebGrid != null) { this.gridWebGrid.ClickCellButton += new ClickCellButtonEventHandler(gridWebGrid_ClickCellButton); } if (this.pagerToolBar != null) { this.pagerToolBar.OnPagerToolBarClick += new EventHandler(this.PagerToolBar_OnPagerToolBarClick); } if (this.pagerSizeSelector != null) { this.pagerSizeSelector.OnPagerSizeChanged += new BenQGuru.eMES.Web.Helper.PagerSizeSelector.PagerSizeChangedHandle(pagerSizeSelector_OnPagerSizeChanged); } }
private void GridDoLayout(UltraWebGrid grid) { Biz_Prj_Info objPrjInfo = new Biz_Prj_Info(); _iprjType = WebUtility.GetByValueDropDownList(ddlPrjType); _iprjCode = txtPrjCode.Text.Trim(); _iprjName = txtPrjName.Text.Trim(); DataTable dt = objPrjInfo.GetTotalFootInfo(_iprjCode , _iprjName , _iprjType).Tables[0]; UltraGridRow row = new UltraGridRow(); grid.Rows.Add(row); UltraGridRow row2 = new UltraGridRow(); grid.Rows.Add(row2); UltraGridRow row3 = new UltraGridRow(); grid.Rows.Add(row3); row.Cells.FromKey("KPI_NAME").Value = "<B>소요예산 : </B>"; row2.Cells.FromKey("KPI_NAME").Value = "<B>집행현황 : </B>"; row3.Cells.FromKey("KPI_NAME").Value = "<B>진행율(%): </B>"; foreach (UltraGridColumn col in grid.Columns) { foreach (DataRow dr in dt.Rows) { if (col.Header.Column.Key == dr["PRJ_REF_ID"].ToString()) { double dTotalBudget = DataTypeUtility.GetToDouble(dr["TOTAL_BUDGET"]); row.Cells.FromKey(col.Header.Column.Key).Value = dTotalBudget.ToString("###,##0.#0"); double dExecAmount = DataTypeUtility.GetToDouble(dr["EXEC_AMOUNT"]); row2.Cells.FromKey(col.Header.Column.Key).Value = dExecAmount.ToString("###,##0.#0"); double dTotalRate = DataTypeUtility.GetToDouble(dr["RATE"]); row3.Cells.FromKey(col.Header.Column.Key).Value = dTotalRate.ToString("##0.#0"); } } } }
protected void FormatColumns(UltraWebGrid uwg) { ColumnsCollection routeCols = uwg.Bands[0].Columns; ColumnsCollection airlineCols = uwg.Bands[1].Columns; ColumnsCollection weightCols = uwg.Bands[2].Columns; routeCols.FromKey("agent_no").Hidden = true; airlineCols.FromKey("agent_no").Hidden = true; weightCols.FromKey("agent_no").Hidden = true; routeCols.FromKey("dba_name").Header.Caption = "Agent"; UltraGridColumn AgentCol = uwg.Bands[0].Columns.FromKey("dba_name"); AgentCol.EditorControlID = "TextAgent"; AgentCol.Type = ColumnType.Custom; AgentCol.DataType = "System.String"; AgentCol.Width = Unit.Pixel(300); }
/// <summary> /// 체크된Row를 삭제합니다. /// </summary> /// <param name="ultraWebGrid"></param> /// <param name="checkBoxID"></param> /// <param name="cellKey_checkBox"></param> public static void SetRemoveRow(UltraWebGrid ultraWebGrid , string checkBoxID , string cellKey_checkBox) { int cntRow = (ultraWebGrid.Rows.Count - 1); UltraGridRow row; for (int i = cntRow; i >= 0; i--) { row = ultraWebGrid.Rows[i]; TemplatedColumn col_cBox = (TemplatedColumn)row.Band.Columns.FromKey(cellKey_checkBox); CheckBox cBox = (CheckBox)((CellItem)col_cBox.CellItems[row.BandIndex]).FindControl(checkBoxID); if (cBox.Checked) { ultraWebGrid.Rows.RemoveAt(i); } } }
protected void cmdGridExport_ServerClick(object sender, System.EventArgs e) { UltraWebGrid Grid2 = null; Grid2 = this.gridHelper.Grid; for (int i = Grid2.Rows.Count - 1; i >= 0; i--) { UltraGridRow row = Grid2.Rows[i]; if (bool.Parse(row.Cells[0].ToString()) && row.Cells.FromKey("ImportResult").Value.ToString() == "导入成功") { Grid2.Rows.Remove(Grid2.Rows[i]); } } Grid2.Columns.Remove(Grid2.Columns[0]); //UltraWebGridExcelExporter1.Export(Grid2); }
/// ******************************************************************************************* /// <summary> /// 添加角色 /// </summary> /// ******************************************************************************************* private void SaveRoleData() { try { Procedure procedure = (Procedure)Session["Procedure"]; UltraWebGrid UWGridCase = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(2).FindControl("UltraWebGrid3")); for (int i = 0; i < UWGridCase.Rows.Count; i++) { bool isNew = (UWGridCase.Rows[i].Cells[0].Text == null); Role RoleCase = null; if (isNew) { RoleCase = Rms.WorkFlow.DefinitionManager.NewRole(); RoleCase.ProcedureCode = procedure.ProcedureCode; procedure.AddNewRole(RoleCase); } else { RoleCase = procedure.GetRole(UWGridCase.Rows[i].Cells[0].Text); } RoleCase.RoleName = (string)UWGridCase.Rows[i].Cells[1].Value; if ((bool)UWGridCase.Rows[i].Cells[2].Value) { //RoleCase.ProcedureCode = "";???因为要求在父表中存在子键值所以当前不能使用该模式 RoleCase.RoleType = "1"; } else { RoleCase.RoleType = "0"; } RoleCase.Remak = (string)UWGridCase.Rows[i].Cells[3].Value; } Session["Procedure"] = procedure; } catch (Exception ex) { throw ex; } }
public void UltraWebGrid(UltraWebGrid tmpUltraWebGrid, string condition, string[] captionNames, string[] tableColumns) { //tmpUltraWebGrid.Clear(); //清空 tmpUltraWebGrid.Bands[0].Columns.Clear(); //清空數據列 UltraGridBand band = new UltraGridBand(); band = tmpUltraWebGrid.Bands[0]; //Head行 UltraGridColumn tmpHeadColumn = new UltraGridColumn(); UltraGridCell tmpCell = new UltraGridCell(); band.Columns.Add(tmpHeadColumn); //數據行 UltraGridColumn tmpColumn = new UltraGridColumn(); // tmpColumn.Band. band.Columns.Add(tmpColumn); //動態增加列 }
/// <summary> /// 从UltraGrid中获取数值,并返回dataset. /// </summary> /// <param name="grid"></param> /// <returns>UltraGrid中的数据</returns> public static DataSet_detail GetGridDataSet(UltraWebGrid grid) { if (grid.Rows.Count < 1) return null; DataSet_detail ds = new DataSet_detail(); DataSet_detail.TProjectTypeDetailRow dsRow; foreach (UltraGridRow row in grid.Bands[0].Grid.Rows) { if (row.DataChanged != DataChanged.Modified) continue; int ShopID = Int32.Parse(row.Cells.FromKey("ShopID").Value.ToString()); int StatTypeID = Int32.Parse(row.Cells.FromKey("StatTypeID").Value.ToString()); int ProjectTypeClassID = Int32.Parse(row.Cells.FromKey("ProjectTypeClassID").Value.ToString()); int ProjectTypeID = Int32.Parse(row.Cells.FromKey("ProjectTypeID").Value.ToString()); int StatYear = Int32.Parse(row.Cells.FromKey("StatYear").Value.ToString()); for (int i = 1; i <= 12; i++) { if (false == row.Cells[i + 2].DataChanged) continue;//从第三列开始是一月、二月、三月…… dsRow = ds.TProjectTypeDetail.NewTProjectTypeDetailRow(); dsRow["ShopID"] = ShopID; dsRow["StatTypeID"] = StatTypeID; dsRow["ProjectTypeClassID"] = ProjectTypeClassID; dsRow["ProjectTypeID"] = ProjectTypeID; dsRow["ProjectTypeDate"] = DateTime.Parse(StatYear.ToString() + "-" + i.ToString()); dsRow["ProjectTypeQty"] = Decimal.Parse(row.Cells[i + 2].Value.ToString()); ds.Tables[0].Rows.Add(dsRow); } } int records = ds.Tables[0].Rows.Count; return ds; }
/// <summary> /// 删除所有行 /// </summary> /// <param name="grid"></param> public static void ResetRowsAndColumns(UltraWebGrid grid) { grid.ResetColumns(); grid.ResetRows(); }
/// <summary> /// 设置单元格字体颜色 /// </summary> /// <param name="rowIdx"></param> /// <param name="colIdx"></param> /// <param name="color"></param> public static void SetCellBackColor(UltraWebGrid grid, int rowIdx, int colIdx, Color color) { grid.Rows[rowIdx].Cells[colIdx].Style.BackColor = color; }
/// <summary> /// 设置整行字体颜色 /// </summary> /// <param name="rowIdx"></param> /// <param name="color"></param> public static void SetRowForeColor(UltraWebGrid grid, int rowIdx, Color color) { foreach (UltraGridCell cell in grid.Rows[rowIdx].Cells) { cell.Style.ForeColor = color; } }
/// <summary> /// 在列中将相同值的单元格合并 /// </summary> /// <param name="grid"></param> /// <param name="col"></param> public static void MergeEqualValueCell(UltraWebGrid grid, int col) { grid.DisplayLayout.Bands[0].Columns[col].MergeCells = true; }
/// <summary> /// 加載數據 /// </summary> private Sheet LoadData(Sheet tmpSheet, int startRow) { UltraWebGrid uwgExport = new UltraWebGrid(); if (this.PanelData.Visible == true) { uwgExport = this.UltraWebGridOTMMonthTotal; } if (this.PanelImport.Visible == true) { uwgExport = this.UltraWebGridImport; } int nR = uwgExport.Rows.Count; //判斷數據控件中是否有數據 if (nR > 0) { int nC = uwgExport.Columns.Count; //逐行加載數據 for (int i = 0; i < nR; i++) { Row row1 = tmpSheet.CreateRow(0); Row row = tmpSheet.CreateRow(startRow + i); //每行的每列加載數據 for (int j = 1; j < 24; j++) { // if (uwgExport.Columns[j].hi) if (uwgExport.Rows[i].Cells[j].Value != null) { row.CreateCell(j - 1).SetCellValue(uwgExport.Rows[i].Cells[j].Value.ToString()); } else { row.CreateCell(j - 1).SetCellValue(""); } } DateTime YearMonth = Convert.ToDateTime(this.txtYearMonth.Text + "/01"); int DaysInMonth = DateTime.DaysInMonth(YearMonth.Year, YearMonth.Month); for (int tmp = 1; tmp < (DaysInMonth + 1); tmp++) { row.CreateCell(22 + tmp).SetCellValue(uwgExport.Rows[i].Cells.FromKey("Day" + tmp.ToString()).Value.ToString()); } } } return tmpSheet; }
public static void SetColWidth(UltraWebGrid grid, int col,int width) { grid.DisplayLayout.Bands[0].Columns[col].Width = width; //grid.DisplayLayout.Bands[0].Columns[col].Header.Style.Width = width; }
/// <summary> /// 是否使用Groupby /// </summary> /// <param name="grid"></param> /// <param name="isGroup"></param> public static void SetGridGroupByHidden(UltraWebGrid grid, bool isGroup) { grid.DisplayLayout.GroupByBox.Hidden = isGroup; }
/// <summary> /// 设置是否可以排序 /// </summary> /// <param name="startCol"></param> /// <param name="endCol"></param> public static void SetColumnSort(UltraWebGrid grid,SortIndicator sort) { for (int i = 0; i < grid.Bands[0].Columns.Count; i++) { grid.Bands[0].Columns[i].SortIndicator = sort;//禁用排序 } }
public static void SetGridColUpdating(UltraWebGrid grid, AllowUpdate allowupdate) { grid.Bands[0].AllowUpdate = allowupdate; }
/// <summary> /// 数据绑定 /// </summary> /// <param name="grid"></param> /// <param name="datasource"></param> public static void SetGridData(UltraWebGrid grid, object datasource) { grid.DataSource = datasource;//数据源设定 grid.DataBind();//绑定 }
public static void SetGridColSizing(UltraWebGrid grid, AllowSizing sizing) { grid.Bands[0].AllowColSizing = sizing; }
public static void SetGridColMoving(UltraWebGrid grid, AllowColumnMoving colMoving) { grid.Bands[0].AllowColumnMoving = colMoving; }
/// <summary> /// 设置单元格焦点 /// </summary> /// <param name="row"></param> /// <param name="col"></param> public static void SetFocusCell(UltraWebGrid grid, int row, int col) { grid.Rows[row].Cells[col].Activate(); }
/// <summary> /// 隐藏列 /// </summary> /// <param name="startColIdx"></param> /// <param name="endColIdx"></param> /// <param name="isHidden"></param> public static void SetColHidden(UltraWebGrid grid, int startColIdx, int endColIdx, bool isHidden) { for (int i = startColIdx; i < endColIdx; i++ ) { grid.DisplayLayout.Bands[0].Columns[i].Hidden = isHidden; } }
/// <summary> /// 设置grid的常规属性 /// </summary> /// <param name="grid"></param> /// <param name="ds"></param> public static void SetGridStyle(UltraWebGrid grid) { if (grid.Rows.Count < 1) return; //grid.DisplayLayout.ColHeadersVisibleDefault = ShowMarginInfo.No; //grid.DisplayLayout.FixedHeaderIndicatorDefault = FixedHeaderIndicator.Button; //style SetGridGroupByHidden(grid, true); SetColumnSort(grid, SortIndicator.Disabled); SetGridColSizing(grid, AllowSizing.Free); SetGridColMoving(grid, AllowColumnMoving.None); grid.DisplayLayout.Bands[0].HeaderStyle.BackColor = Color.FromArgb(220, 233, 246); grid.DisplayLayout.Bands[0].HeaderStyle.Height = 26; //15列以后隐藏 SetColHidden(grid, 15, grid.Bands[0].Columns.Count, true); SetColHidden(grid, 0, 1, true); MergeEqualValueCell(grid, 0); MergeEqualValueCell(grid, 1); MergeEqualValueCell(grid, 2); SetReadOnlyColumn(grid, 0); SetReadOnlyColumn(grid, 1); SetReadOnlyColumn(grid, 2); for (int colIdx = 0; colIdx < grid.Bands[0].Columns.Count; colIdx++) { if (colIdx < 3) { SetColWidth(grid, colIdx, COLWIDTH_HEADER);//Row Header Column Width. grid.Bands[0].Columns[colIdx].CellStyle.Wrap = true; } else if (colIdx >= 3 && colIdx <= 14) { SetColWidth(grid, colIdx, COLWIDTH_MONTH);//Month Value Column Width. } else { SetColWidth(grid, colIdx, 0);//Hidden Column Width. } } SetColumnHeaderAlign(grid, 3, grid.Bands[0].Columns.Count, HorizontalAlign.Center); SetColumnContentAlign(grid, 3, grid.Bands[0].Columns.Count, HorizontalAlign.Center); //隔行背景淡黄色(月份) /* for (int i = 0; i < grid.Bands[0].Grid.Rows.Count; i++) { for (int j = 0; j < grid.Bands[0].Grid.Columns.Count; j++) { if ((i % 2) != 0 && (j > 2 && j < 15)) { grid.Bands[0].Grid.Rows[i].Cells[j].Style.BackColor = Color.FromArgb(242, 242, 244); } } } */ }
protected void apAuditData(UltraWebGrid ultraWebGrid, string condition, List<string> list_remark, List<string> list_id, string OTAid, string DisSignRmark, string DisApproveEmp, int intDisApprove, string ApRemark, string BillNo, string BillTypeNo) { list_remark = new List<string>(); list_id = new List<string>(); TemplatedColumn tcolTMA = (TemplatedColumn)UltraWebGridKQU.Bands[0].Columns[0]; for (int i = 0; i < UltraWebGridKQU.Rows.Count; i++) { OTAid = ultraWebGrid.DisplayLayout.Rows[i].Cells.FromKey("ID").Text;//序號 DisSignRmark = ultraWebGrid.DisplayLayout.Rows[i].Cells.FromKey("DISSIGNRMARK").Text;//拒簽欄位 CellItem GridItem = (CellItem)tcolTMA.CellItems[i]; CheckBox chkIsHaveRight = (CheckBox)(GridItem.FindControl("CheckBoxCell")); if (chkIsHaveRight.Checked) { if (!string.IsNullOrEmpty(DisSignRmark)) { list_remark.Add(DisSignRmark); } else { Page.ClientScript.RegisterStartupScript(GetType(), "show", "alert('" + Message.wfm_disapprove_remark + "')", true); return; } list_id.Add(OTAid); condition += " id = '" + OTAid + "' or"; DisApproveEmp += ultraWebGrid.DisplayLayout.Rows[i].Cells.FromKey("WorkNo").Text + "/" + ultraWebGrid.DisplayLayout.Rows[i].Cells.FromKey("LocalName").Text + "、"; intDisApprove += 1;//拒簽 } } if (intDisApprove > 0) { condition = condition.Substring(0, condition.Length - 2); condition = " and (" + condition + ")"; DisApproveEmp = "|" + DisApproveEmp.Substring(0, DisApproveEmp.Length - 1); } else { condition = ""; DisApproveEmp = ""; } ApRemark = ApRemark + DisApproveEmp; if (intDisApprove == UltraWebGridKQE.Rows.Count) { bll.SaveDisAuditData(BillNo, CurrentUserInfo.Personcode, BillTypeNo, ApRemark, list_remark, list_id,logmodel); } else { bll.SaveAuditData(BillNo, CurrentUserInfo.Personcode, BillTypeNo, ApRemark, condition, list_remark, list_id,logmodel); } }
/// <summary> /// 设置列头对齐方式 /// </summary> /// <param name="grid"></param> /// <param name="startCol"></param> /// <param name="endCol"></param> /// <param name="ha"></param> public static void SetColumnHeaderAlign(UltraWebGrid grid, int startCol, int endCol,HorizontalAlign ha) { for (int i = startCol; i < endCol; i++) { grid.Bands[0].Columns[i].Header.Style.HorizontalAlign = ha; } }
private void BindDaysType1(string deptid, string daytype, UltraWebGrid grid) { DataTable dt = bll.GetDaysType_1(deptid, daytype); grid.DataSource = dt; grid.DataBind(); }
/// <summary> /// 设置整列为只读 /// </summary> /// <param name="startCol"></param> /// <param name="endCol"></param> public static void SetReadOnlyColumn(UltraWebGrid grid, int col) { grid.Bands[0].Columns[col].AllowUpdate = AllowUpdate.No;//不允许修改 }
/// <summary> /// 设置整列字体颜色 /// </summary> /// <param name="startCol"></param> /// <param name="endCol"></param> /// <param name="color"></param> public static void SetColumnForeColor(UltraWebGrid grid, int startCol, int endCol, Color color) { for (int i = startCol; i < endCol; i++) { grid.DisplayLayout.Bands[0].Columns[i].CellStyle.ForeColor = color; } }
/// <summary> /// 设置列宽 /// </summary> /// <param name="startColIdx"></param> /// <param name="endColIdx"></param> /// <param name="width"></param> public static void SetColWidth(UltraWebGrid grid, int startColIdx, int endColIdx, int width ) { for ( int i = startColIdx; i < endColIdx; i++ ) { grid.DisplayLayout.Bands[0].Columns[i].Width = width; //grid.DisplayLayout.Bands[0].Columns[i].Header.Style.Width = width; } }