private void DataBindingMenuRole(int menu_ref_id) { RoleInfos role = new RoleInfos(); UltraWebGrid2.DataSource = role.GetMenuRoles(menu_ref_id); UltraWebGrid2.DataBind(); }
private void DoBinding_TgtEmp() { DataTable DT = bizMulEstTargetPool.Get_MulTgtEmp_List(COMP_ID, DEPT_REF_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID); UltraWebGrid2.DataSource = DT; UltraWebGrid2.DataBind(); }
private void DoBinding_Emp(int dept_ref_id) { DataTable dtDeptEmp = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" DEPT_REF_ID = {0} ", dept_ref_id), " EMP_NAME "); UltraWebGrid2.DataSource = dtDeptEmp; UltraWebGrid2.DataBind(); //if (rdoEstTypeList.SelectedIndex.Equals(0)) //{ // MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp bizMulEstEmp = new MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp(); //} //else //{ //} if (dtDeptEmp.Rows.Count > 0) { ibnEmp.Enabled = true; } else { ibnEmp.Enabled = false; } }
protected void doBind_prjEmp() { UltraWebGrid2.Clear(); MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data(); DT_EMP_EST_DATA = bizEstData.GetEstData(COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID, DIRECTION_TYPE, EST_EMP_ID, 0); MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new Biz_Prj_Data(); string est_id = "3Q";//프로젝트 기여도 평가 EST_ID DT_PRJ_DATA = bizPrjData.Get_Prj_Data_List(PRJ_REF_ID , COMP_ID , est_id , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID); DataTable dtPrj_PM_Data = DataTypeUtility.FilterSortDataTable(DT_PRJ_DATA, "TGT_DEPT_ID=-1 AND TGT_EMP_ID=-1"); object point = dtPrj_PM_Data.Rows[0]["POINT"]; PRJ_POINT = DataTypeUtility.GetString(point); UltraWebGrid2.DataSource = DT_PRJ_DATA; UltraWebGrid2.DataBind(); }
private void DataLoad() { ApprovalLines app = new ApprovalLines(); UltraWebGrid2.DataSource = app.GetApprovalLine(biz_type_code, EmpID); UltraWebGrid2.DataBind(); }
private void DataBindingRole() { Biz_RoleInfos role = new Biz_RoleInfos(); UltraWebGrid2.DataSource = role.GetRoleInfos(); UltraWebGrid2.DataBind(); }
private void BindingPosBiz(string pos_knd_id) { Biz_PositionKindBizMaps posKndBiz = new Biz_PositionKindBizMaps(); DataSet ds = posKndBiz.GetPosKndBizMap(pos_knd_id, ""); UltraWebGrid2.DataSource = ds; UltraWebGrid2.DataBind(); }
private void DataBindingUnit(string unit_type) { UnitTypeInfos unitInfo = new UnitTypeInfos(unit_type); DataSet ds = unitInfo.GetAllUnitTypeInfo(unit_type); UltraWebGrid2.DataSource = ds; UltraWebGrid2.DataBind(); }
private void DoBinding_InPower() { MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT(); DataTable dtNHIT = bizNHIT.GetInPower(CR_YEAR); UltraWebGrid2.DataSource = dtNHIT; UltraWebGrid2.DataBind(); }
private void KndBizMapGridBinding() { Biz_PositionKindBizMaps maps = new Biz_PositionKindBizMaps(); DataSet ds = maps.GetPosKndBizMaps(); UltraWebGrid2.DataSource = ds; UltraWebGrid2.DataBind(); }
protected void Project_Detail_Bind() { object StartDate = this.prj_sDate.Value; object EndDate = this.prj_eDate.Value; DataTable DT = bizPmsInfo.Get_Project_Detail(PRJ_ID, (DateTime)StartDate, (DateTime)EndDate); UltraWebGrid2.DataSource = DT; UltraWebGrid2.DataBind(); }
private void DetailGridBinding(string pos_id) { Biz_Positions positions = new Biz_Positions("EST_POSITION_" + pos_id, pos_id); DataSet ds = positions.GetPositions(); UltraWebGrid2.DataSource = ds; UltraWebGrid2.DataBind(); InitForm(); }
// 평가단계별 등급코드를 가져온다 private void BindThresholdStepList() { Biz_Bsc_Threshold_Step biz = new Biz_Bsc_Threshold_Step(); string strLevel = GetValue(ddlLevel.SelectedValue); DataSet ds = biz.GetThresholdLevelList(strLevel); UltraWebGrid2.DataSource = ds; UltraWebGrid2.DataBind(); }
private void DoBinding_Emp(string TGT_DEPT_ID) { UltraWebGrid2.Clear(); Biz_Mul_Est_Data bizMulEstData = new Biz_Mul_Est_Data(); DataTable DT = bizMulEstData.Get_Est_Status_By_Emp(hdfEstID.Value, ESTTERM_REF_ID.ToString(), ESTTERM_SUB_ID.ToString(), TGT_DEPT_ID); UltraWebGrid2.DataSource = DT; UltraWebGrid2.DataBind(); }
private void BindingCommandNameRoleMap(int role_ref_id) { Biz_ButtonCommandRoleMaps btnCmdRoleMap = new Biz_ButtonCommandRoleMaps(); _dtButtonCommandRole = btnCmdRoleMap.GetButtonCommandRoleMap(role_ref_id, "").Tables[0]; Biz_ButtonCommandInfos btnCmdInfo = new Biz_ButtonCommandInfos(); UltraWebGrid2.DataSource = btnCmdInfo.GetButtonCommandInfos(); UltraWebGrid2.DataBind(); }
private void DataBindingFamily(string sabun) { string query = @"SELECT FAMILY.EMP_SABUN_T, FAMILY.EMP_RELATION, -- 관계 FAMILY.EMP_NAME, -- 가족 명 FAMILY.EMP_BRTH_DATE, -- 생년월일 FAMILY.EMP_JOB -- 직업 FROM SEM_EMPLOYEE_FAMILY FAMILY WHERE FAMILY.EMP_SABUN_T = '" + sabun + @"'"; UltraWebGrid2.DataSource = GetDataSet(query); UltraWebGrid2.DataBind(); }
private void BindEstJob(int comp_id, string est_id) { if (!est_id.Equals("")) { Biz_JobEstMaps jobEstMap = new Biz_JobEstMaps(); _dtEstJobMap = jobEstMap.GetJobEstMap(comp_id, est_id, "").Tables[0]; } Biz_JobInfos jobInfo = new Biz_JobInfos(); UltraWebGrid2.DataSource = jobInfo.GetJobInfos("N"); UltraWebGrid2.DataBind(); }
private void SetGrid2() { UltraWebGrid2.Clear(); MicroBSC.Integration.BSC.Biz.Biz_Bsc_Intro_Score bizObj = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Intro_Score(); DataTable dtObj = bizObj.GetOrgRankBonbuDesc(IEstTermRefID, IYmd, "4", "TS", 5); if (dtObj.Rows.Count > 0) { UltraWebGrid2.DataSource = dtObj; UltraWebGrid2.DataBind(); } }
private void DoBinding_Emp(string cr_year, string cr_month, string project_name) { UltraWebGrid2.Clear(); MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT(); DataTable dtNHIT = bizNHIT.GetEmpProjectDetail(cr_year , cr_month , project_name); UltraWebGrid2.DataSource = dtNHIT; UltraWebGrid2.DataBind(); lblEmpTotal.Text = string.Format("(Total : {0})", dtNHIT.Rows.Count); }
private void GridBinding2(int comp_id, int estterm_ref_id, string est_id) { Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails(); _dtEstScale = deptEstDetail.GetDeptEstDetail(comp_id, estterm_ref_id, 0, est_id).Tables[0]; Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales(); _dtPosScale = deptPosScale.GetDeptPosScale(comp_id, estterm_ref_id, 0, est_id).Tables[0]; UltraWebGrid2.Clear(); UltraWebGrid2.DataSource = BizUtility.GetDeptTree(" "); UltraWebGrid2.DataBind(); }
public void DoBindingTempleteMap(int templete_code) { UltraWebGrid2.Clear(); MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool bizBscKpiPool = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool(); DataTable dtBscKpiPool = bizBscKpiPool.GetKpiPool_DB("" , "" , "" , 0 , templete_code); UltraWebGrid2.DataSource = dtBscKpiPool; UltraWebGrid2.DataBind(); //lblRowCount.Text = dtBscKpiPool.Rows.Count.ToString(); }
protected void llenarvacio() { UltraWebGrid2.ResetColumns(); UltraWebGrid2.DataBind(); UltraWebGrid2.DisplayLayout.ScrollBar = ScrollBar.Never; UltraWebGrid2.Columns.Add("Centro trabajo"); UltraWebGrid2.Columns.Add("Banco"); UltraWebGrid2.Columns.Add("Fecha inicio"); UltraWebGrid2.Columns.Add("Fecha fin"); UltraWebGrid2.Columns.Add("Autorizado"); UltraWebGrid2.Columns.Add("Autoriza"); UltraWebGrid2.Columns.Add("Activo"); UltraWebGrid2.Columns[0].Header.Caption = "Centro de trabajo"; UltraWebGrid2.Columns[1].Header.Caption = "Banco"; UltraWebGrid2.Columns[2].Header.Caption = "Fecha inicio"; UltraWebGrid2.Columns[3].Header.Caption = "Fecha fin"; UltraWebGrid2.Columns[4].Header.Caption = "Autorizado"; UltraWebGrid2.Columns[5].Header.Caption = "Autoriza"; UltraWebGrid2.Columns[6].Header.Caption = "Activo"; UltraWebGrid2.Columns[0].Header.Style.Wrap = true; UltraWebGrid2.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[0].Width = 100; UltraWebGrid2.Columns[1].Width = 65; UltraWebGrid2.Columns[4].Width = 75; UltraWebGrid2.Columns[5].Width = 90; UltraWebGrid2.Columns[6].Width = 70; }
private void BindQuestionDeptEmpMapGrid() { Biz_QuestionDeptEmpMaps questionDeptEmpMaps = new Biz_QuestionDeptEmpMaps(); UltraWebGrid2.Clear(); DataSet ds = null; if (OwnerTypeMode == OwnerType.Emp_User) { pnlDept.Visible = false; pnlEmp.Visible = true; ds = questionDeptEmpMaps.GetQuestionEmpMapping(COMP_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID , EST_ID , Q_OBJ_ID , 0 , 0 , OwnerType.Emp_User); } else if (OwnerTypeMode == OwnerType.Dept) { pnlDept.Visible = true; pnlEmp.Visible = false; ds = questionDeptEmpMaps.GetQuestionDeptMapping(COMP_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID , EST_ID , Q_OBJ_ID , 0); hdfEstDept.Value = WebUtility.GetValueForSplit(ds.Tables[0] , "TGT_DEPT_ID" , ","); } UltraWebGrid2.DataSource = ds; UltraWebGrid2.DataBind(); }
private void PerformGetAllData(string strCommandText) { UltraWebGrid2.ResetColumns(); UltraWebGrid2.ResetBands(); ConnectStr = (new igFunctions.DB().getConStr()); SqlConnection Con = new SqlConnection(ConnectStr); SqlCommand cmdCusData = new SqlCommand(strCommandText, Con); SqlDataAdapter Adap = new SqlDataAdapter(); Con.Open(); Adap.SelectCommand = cmdCusData; Adap.Fill(ds, "AllData"); Con.Close(); UltraWebGrid2.DataSource = ds.Tables["AllData"].DefaultView; UltraWebGrid2.DataBind(); }
protected void btnBuscaDetalle_Click(object sender, EventArgs e) { String msg = ""; try { int id = Convert.ToInt32(hIdInventario.Value); UltraWebGrid2.DataSource = new server.Inventarios().InventarioEnProcesoDetalle(id); UltraWebGrid2.DataBind(); if (UltraWebGrid2.Rows.Count > 0) { UltraWebGrid2.Columns[0].Hidden = true; } } catch { msg = "Hubo un problema al generar el Inventario, intente nuevamente."; CallBackManager.AddScriptBlock(this.Page, WebAsyncRefreshPanel2, "<script type='text/javascript'>alert('" + msg + "');</script>"); } }
private void PerformDataBind() { UltraWebGrid1.DataSource = ds.Tables["HEAD"].DefaultView; UltraWebGrid2.DataSource = ds_AS.Tables["HEAD"].DefaultView; UltraWebGrid3.DataSource = ds_LE.Tables["HEAD"].DefaultView; UltraWebGrid1.DataBind(); UltraWebGrid2.DataBind(); UltraWebGrid3.DataBind(); if (UltraWebGrid1.Rows.Count < 1) { lblNoData.Text = "No Data was found!"; lblNoData.Visible = true; } else { UltraWebGrid1.Visible = false; lblNoData.Visible = false; } }
private void DoBinding_Emp(int dept_ref_id) { string filter = string.Format(" TGT_DEPT_ID = {0} ", dept_ref_id); string sort = "TGT_EMP_NAME"; string[] groupBy = { "TGT_DEPT_ID" , "TGT_DEPT_NAME" , "TGT_EMP_ID" , "TGT_EMP_NAME" , "TGT_POS_CLS_ID" , "TGT_POS_CLS_NAME" , "TGT_POS_DUT_ID" , "TGT_POS_DUT_NAME" , "TGT_POS_GRP_ID" , "TGT_POS_GRP_NAME" , "TGT_POS_RNK_ID" , "TGT_POS_RNK_NAME" , "TGT_POS_KND_ID" , "TGT_POS_KND_NAME" , "DIRECTION_TYPE" }; UltraWebGrid2.Columns[1].BaseColumnName = "TGT_EMP_NAME"; UltraWebGrid2.Columns[2].BaseColumnName = "TGT_POS_KND_NAME"; UltraWebGrid2.Columns[3].BaseColumnName = "TGT_POS_CLS_NAME"; UltraWebGrid2.Columns[4].BaseColumnName = "TGT_POS_DUT_NAME"; UltraWebGrid2.Columns[5].BaseColumnName = "TGT_EMP_ID"; DataTable dtDeptEmp = DataTypeUtility.FilterSortDataTable(DataTypeUtility.GetGroupByDataTable(DataTypeUtility.FilterSortDataTable(DT_ESTTARGETMAP, filter) , groupBy) , "" , sort); UltraWebGrid2.DataSource = dtDeptEmp; UltraWebGrid2.DataBind(); }
private void DoBinding_Emp(int dept_ref_id) { string filter = string.Format(" TGT_DEPT_ID = {0} ", dept_ref_id); string sort = "TGT_EMP_NAME"; string[] groupBy = { "TGT_DEPT_ID" , "TGT_DEPT_NAME" , "TGT_EMP_ID" , "TGT_EMP_NAME" , "TGT_POS_CLS_ID" , "TGT_POS_CLS_NAME" , "TGT_POS_DUT_ID" , "TGT_POS_DUT_NAME" , "TGT_POS_GRP_ID" , "TGT_POS_GRP_NAME" , "TGT_POS_RNK_ID" , "TGT_POS_RNK_NAME" , "TGT_POS_KND_ID" , "TGT_POS_KND_NAME" , "DIRECTION_TYPE" }; UltraWebGrid2.Columns[1].BaseColumnName = "TGT_EMP_NAME"; UltraWebGrid2.Columns[2].BaseColumnName = "TGT_POS_KND_NAME"; UltraWebGrid2.Columns[3].BaseColumnName = "TGT_POS_CLS_NAME"; UltraWebGrid2.Columns[4].BaseColumnName = "TGT_POS_DUT_NAME"; UltraWebGrid2.Columns[5].BaseColumnName = "TGT_EMP_ID"; //if (rdoEstTypeList.SelectedIndex.Equals(0)) //{ // filter = string.Format(" EST_DEPT_ID = {0} ", dept_ref_id); // sort = "EST_EMP_NAME"; // groupBy = new string[] { "EST_DEPT_ID" // ,"EST_DEPT_NAME" // ,"EST_EMP_ID" // ,"EST_EMP_NAME" // ,"EST_POS_CLS_ID" // ,"EST_POS_CLS_NAME" // ,"EST_POS_DUT_ID" // ,"EST_POS_DUT_NAME" // ,"EST_POS_GRP_ID" // ,"EST_POS_GRP_NAME" // ,"EST_POS_RNK_ID" // ,"EST_POS_RNK_NAME" // ,"EST_POS_KND_ID" // ,"EST_POS_KND_NAME" }; // UltraWebGrid2.Columns[1].BaseColumnName = "EST_EMP_NAME"; // UltraWebGrid2.Columns[2].BaseColumnName = "EST_POS_KND_NAME"; // UltraWebGrid2.Columns[3].BaseColumnName = "EST_POS_CLS_NAME"; // UltraWebGrid2.Columns[4].BaseColumnName = "EST_POS_DUT_NAME"; //} DataTable dtDeptEmp = DataTypeUtility.FilterSortDataTable(DataTypeUtility.GetGroupByDataTable(DataTypeUtility.FilterSortDataTable(DT_ESTTARGETMAP, filter) , groupBy) , "" , sort); UltraWebGrid2.DataSource = dtDeptEmp; UltraWebGrid2.DataBind(); //if (dtDeptEmp.Rows.Count > 0) //{ // ibnEmp.Enabled = true; //} //else //{ // ibnEmp.Enabled = false; //} }
protected void btnBuscar_click(object sender, EventArgs e) { try { DropDownList cmbPlanta = ((DropDownList)Page.Master.FindControl("cmbPlanta")); svcSCPP.SCPPClient svc = new svcSCPP.SCPPClient(); int planta = int.Parse(cmbPlanta.SelectedValue); int centroTrab = int.Parse(cmbCentroTrabajo.SelectedValue); int maquina = int.Parse(cmbMaquina.SelectedValue); int active = Convert.ToInt32(ddlActivos.SelectedValue); List <Common.SolutionEntityFramework.BaseSolutionEntity> Lista = svc.ObtenerConfiguracionBanco(planta, centroTrab, maquina, active); UltraWebGrid2.DataSource = Lista; if (Lista.Count <= 0) { llenarvacio(); } else { UltraWebGrid2.ResetColumns(); UltraWebGrid2.DataBind(); UltraWebGrid2.DisplayLayout.ScrollBar = ScrollBar.Auto; UltraWebGrid2.Columns[0].Header.Caption = "Centro de trabajo"; UltraWebGrid2.Columns[1].Header.Caption = "Banco"; UltraWebGrid2.Columns[2].Header.Caption = "Límite de vaciadas"; UltraWebGrid2.Columns[3].Header.Caption = "Vaciadas acumuladas"; UltraWebGrid2.Columns[4].Header.Caption = "Fecha inicio"; UltraWebGrid2.Columns[5].Header.Caption = "Fecha fin"; UltraWebGrid2.Columns[6].Header.Caption = "Autorizado"; UltraWebGrid2.Columns[7].Header.Caption = "Autoriza"; UltraWebGrid2.Columns[8].Header.Caption = "Activo"; UltraWebGrid2.Columns[9].Header.Caption = "CodCT"; UltraWebGrid2.Columns[10].Header.Caption = "CodMaquina"; UltraWebGrid2.Columns[11].Header.Caption = "CodUsuarioAutoriza"; UltraWebGrid2.Columns[12].Header.Caption = "CodUsuarioAlta"; UltraWebGrid2.Columns[13].Header.Caption = "CodConfigBanco"; UltraWebGrid2.Columns[14].Header.Caption = "ExceptionMessage"; UltraWebGrid2.Columns[0].Header.Style.Wrap = true; UltraWebGrid2.Columns[2].Header.Style.Wrap = true; UltraWebGrid2.Columns[3].Header.Style.Wrap = true; UltraWebGrid2.Columns[6].Width = 80; UltraWebGrid2.Columns[7].Width = 130; UltraWebGrid2.Columns[8].Width = 70; UltraWebGrid2.Columns[0].Width = 150; UltraWebGrid2.Columns[1].Width = 150; UltraWebGrid2.Columns[4].Width = 90; UltraWebGrid2.Columns[5].Width = 90; UltraWebGrid2.Columns[0].AllowResize = AllowSizing.Fixed; UltraWebGrid2.Columns[1].AllowResize = AllowSizing.Fixed; UltraWebGrid2.Columns[2].AllowResize = AllowSizing.Fixed; UltraWebGrid2.Columns[3].AllowResize = AllowSizing.Fixed; UltraWebGrid2.Columns[4].AllowResize = AllowSizing.Fixed; UltraWebGrid2.Columns[5].AllowResize = AllowSizing.Fixed; UltraWebGrid2.Columns[6].AllowResize = AllowSizing.Fixed; UltraWebGrid2.Columns[7].AllowResize = AllowSizing.Fixed; UltraWebGrid2.Columns[8].AllowResize = AllowSizing.Fixed; UltraWebGrid2.Columns[0].CellStyle.HorizontalAlign = HorizontalAlign.Left; UltraWebGrid2.Columns[1].CellStyle.HorizontalAlign = HorizontalAlign.Left; UltraWebGrid2.Columns[2].CellStyle.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[3].CellStyle.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[4].CellStyle.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[5].CellStyle.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[6].CellStyle.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[7].CellStyle.HorizontalAlign = HorizontalAlign.Left; UltraWebGrid2.Columns[8].CellStyle.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[7].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[8].Header.Style.HorizontalAlign = HorizontalAlign.Center; UltraWebGrid2.Columns[4].Format = "dd-MM-yyyy"; UltraWebGrid2.Columns[5].Format = "dd-MM-yyyy"; UltraWebGrid2.Columns[2].Hidden = true; UltraWebGrid2.Columns[3].Hidden = true; UltraWebGrid2.Columns[9].Hidden = true; UltraWebGrid2.Columns[10].Hidden = true; UltraWebGrid2.Columns[11].Hidden = true; UltraWebGrid2.Columns[12].Hidden = true; UltraWebGrid2.Columns[13].Hidden = true; UltraWebGrid2.Columns[14].Hidden = true; UltraWebGrid2.Width = 800; } } catch (Exception ex) { CallBackManager.AddScriptBlock(this.Page, WebAsyncRefreshPanel1, "<script type='text/javascript'>alert('No se encontraron datos');</script>"); } }
protected void Page_Load(object sender, EventArgs e) { try { svcSCPPHH.SCPP_HHClient d = new svcSCPPHH.SCPP_HHClient(); BC.SCPP_HH bc = new BC.SCPP_HH(); DataSet ds = new DataSet();//d.SyncServHH(DropDownList1.SelectedValue.ToString(), DateTime.Today.Date.AddDays(-20), DateTime.Today, DateTime.Today); //DataSet ds = bc.SyncServHH(DropDownList1.SelectedValue.ToString(), DateTime.Today.Date.AddDays(-20), DateTime.Today, DateTime.Today); //List<DataSet> lds = d.SyncServHHLDS(DateTime.Today.Date.AddDays(-30), DateTime.Today, DateTime.Today); //List<StringReader[]> lxmlDS = bc.SyncServHH(DateTime.Today.Date.AddDays(-30), DateTime.Today, DateTime.Today); //DataSet beRes = new DataSet(); //List<DataSet> lds = new List<DataSet>(); //foreach (StringReader[] xmlSR in lxmlDS) //{ // beRes.Clear(); // beRes = new DataSet(); // beRes.ReadXmlSchema(xmlSR[0]); // beRes.ReadXml(xmlSR[1], XmlReadMode.Auto); // lds.Add(beRes); //} //DataTable dt = d.TablasCatalogosHH(); DataTable dt = null; try { dt = d.Login("a", "a"); } catch { } try { dt = d.ObtenerSupervisorPorDefecto(42); } catch { } DataSet xmlDS = new DataSet(); DataSet ds2 = new DataSet(); try { StringReader xmlSchema = new StringReader(ds.GetXmlSchema().ToString()); StringReader xmlInfo = new StringReader(ds.GetXml().ToString()); StringReader[] xmlDataSet = { xmlSchema, xmlInfo }; ds2.ReadXmlSchema(xmlDataSet[0]); ds2.ReadXml(xmlDataSet[1], XmlReadMode.Auto); } catch { } if (ds2.Tables.Count > 0) { UltraWebGrid1.DataSource = ds2.Tables[0]; String tableName = ds2.Tables[1].TableName.Substring(3).ToString(); ObtenerUpdate(ds2.Tables[1], tableName); UltraWebGrid2.DataSource = ds2.Tables[1]; UltraWebGrid3.DataSource = ds2.Tables[2]; } int i = d.ActualizarColorPieza(21, 3); UltraWebGrid1.DataBind(); UltraWebGrid2.DataBind(); UltraWebGrid3.DataBind(); } catch (Exception er) { CallBackManager.AddScriptBlock(this.Page, WebAsyncRefreshPanel1, "<script type='text/javascript'>alert('" + er.Message.Replace("'", "\"") + "');</script>"); Console.Write("Error:" + er.Message); } }