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);
}
}