private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From ftYearMaster Where MasterID = '" + id + "'")); if (dv.Count != 0) { ddlTerm.SelectedValue = dv[0]["Term"].ToString(); ddlYearS.SelectedValue = dv[0]["StudyYear"].ToString(); } btc.getCreateUpdateUser(lblCreate, lblUpdate, "ftYearMaster", "MasterID", id); }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From ApproveFlowDetail Where ApproveFlowDetailID = '" + id + "'")); if (dv.Count != 0) { hdfApproveFlowDetailID.Value = dv[0]["ApproveFlowDetailID"].ToString(); btc.getddlMainSubDepartment(1, ddlApproveFlow, CurrentUser.MainDeptID, null); ddlApproveFlow.SelectedValue = dv[0]["ApproveFlowID"].ToString(); ddlApproveStep.SelectedValue = dv[0]["ApproveStepID"].ToString(); ddlUserRole.SelectedValue = dv[0]["UserRoleID"].ToString(); btc.getddlPosition(1, ddlPosition, ddlUserRole.SelectedValue, null); ddlPosition.SelectedValue = dv[0]["ApprovePositionID"].ToString(); txtBudgetLimit.Text = dv[0]["BudgetLimit"].ToString(); ddlckStatus.SelectedValue = dv[0]["ckStatus"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); if (!string.IsNullOrEmpty(dv[0]["ImgPath"].ToString())) { imgPicture.ImageUrl = dv[0]["ImgPath"].ToString(); ImgBt.Visible = true; } else { imgPicture.ImageUrl = "../Image/Menu9.png"; ImgBt.Visible = false; } } btc.getCreateUpdateUser(lblCreate, lblUpdate, "ApproveFlowDetail", "ApproveFlowDetailID", id); }
private void GetData(string id) { if (String.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select a.StandardCode, a.StudyYear, b.IndicatorsCode, b.ScoreGroupID, b.IndicatorsName, b.Detail, b.DevelopIssues, IsNull(b.QualityFlag, 0) QualityFlag, b.WeightScore, b.DataSource1, b.DataSource2, b.Sort From Standard a, Indicators b Where a.StandardCode = b.StandardCode And b.IndicatorsCode = '" + id + "' ")); if (dv.Table.Rows.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); getddlStandard(1, ddlYearB.SelectedValue); ddlStandard.SelectedValue = dv[0]["StandardCode"].ToString(); txtIndicators.Text = dv[0]["IndicatorsName"].ToString(); txtDetail.Text = dv[0]["Detail"].ToString(); txtDevelopIssues.Text = dv[0]["DevelopIssues"].ToString(); cbQualityFlag.Checked = Convert.ToBoolean(dv[0]["QualityFlag"]); txtDataSource1.Text = dv[0]["DataSource1"].ToString(); txtDataSource2.Text = dv[0]["DataSource2"].ToString();; txtWeightScore.Text = dv[0]["WeightScore"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); ddlScoreGroup.SelectedValue = dv[0]["ScoreGroupID"].ToString(); getCriteria(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "Indicators", "IndicatorsCode", id); } }
private void GetData(string id) { if (String.IsNullOrEmpty(id)) { return; } string strSql = @"Select a.StandardCode, a.StudyYear, b.IndicatorsCode, b.ScoreGroupID, b.IndicatorsName, b.Detail, b.DevelopIssues, b.Sort, a.SideCode From Standard a Inner Join Indicators b On a.StandardCode = b.StandardCode Where b.IndicatorsCode = '{0}' "; DataView dv = Conn.Select(string.Format(strSql, id)); if (dv.Table.Rows.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); getddlSide(1); ddlSide.SelectedValue = dv[0]["SideCode"].ToString(); getddlStandard(1, ddlSide.SelectedValue); ddlStandard.SelectedValue = dv[0]["StandardCode"].ToString(); txtIndicators.Text = dv[0]["IndicatorsName"].ToString(); txtDetail.Text = dv[0]["Detail"].ToString(); //txtDevelopIssues.Text = dv[0]["DevelopIssues"].ToString(); //cbQualityFlag.Checked = Convert.ToBoolean(dv[0]["QualityFlag"]); //txtDataSource1.Text = dv[0]["DataSource1"].ToString(); //txtDataSource2.Text = dv[0]["DataSource2"].ToString(); ; //txtWeightScore.Text = dv[0]["WeightScore"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); //ddlScoreGroup.SelectedValue = dv[0]["ScoreGroupID"].ToString(); //getCriteria(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "Indicators", "IndicatorsCode", id); } }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } string strSql = @" Select SP.*, MSD.MainSubDeptCode, MD.MainDeptCode From StrategicPlan SP Left Join Department D On SP.DeptCode = D.DeptCode Left Join MainSubDepartment MSD On D.MainSubDeptCode = MSD.MainSubDeptCode Left Join MainDepartment MD On MSD.MainDeptCode = MD.MainDeptCode Where SP.StrategicPlanID = '{0}' "; DataView dv = Conn.Select(string.Format(strSql, id)); if (dv.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); btc.getddlMainDepartment(1, ddlMainDept, null); ddlMainDept.SelectedValue = dv[0]["MainDeptCode"].ToString(); btc.getddlMainSubDepartment(1, ddlMainSubDept, ddlMainDept.SelectedValue, null); ddlMainSubDept.SelectedValue = dv[0]["MainSubDeptCode"].ToString(); btc.getddlDepartment(1, ddlDepartment, ddlMainSubDept.SelectedValue, null, null); ddlDepartment.SelectedValue = dv[0]["DeptCode"].ToString(); txtStrategicPlan.Text = dv[0]["StrategicPlanName"].ToString(); txtDetail.Text = dv[0]["Detail"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "StrategicPlan", "StrategicPlanID", id); } }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From Strategies Where StrategiesCode = '" + id + "'")); if (dv.Count != 0) { ddlYearS.SelectedValue = dv[0]["StudyYear"].ToString(); txtStrategies.Text = dv[0]["StrategiesName"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "Strategies", "StrategiesCode", id); string strSql = " Select CorporateStrategyID, Sort As id, CorporateStrategyName " + " From CorporateStrategy " + " Where StrategiesCode = '{0}' "; dvIndicators = Conn.Select(string.Format(strSql + " Order By Sort ", id)); if (dvIndicators.Count != 0) { btDelIndicators.Visible = true; if (Session["IndicatorsSuccess"] == null) { DataTable dt1 = new DataTable(); dt1.Columns.Add("id"); dt1.Columns.Add("IndicatorsName"); DataRow dr; for (int i = 0; i < dvIndicators.Count; i++) { dr = dt1.NewRow(); dr["id"] = dvIndicators[i]["id"].ToString(); dr["IndicatorsName"] = dvIndicators[i]["CorporateStrategyName"].ToString(); dt1.Rows.Add(dr); } dvIndicators = dt1.DefaultView; Session["IndicatorsSuccess"] = dt1; } GridViewIndicators.Visible = true; GridViewIndicators.DataSource = dvIndicators; GridViewIndicators.CheckListDataField = "id"; GridViewIndicators.DataBind(); } else { btDelIndicators.Visible = false; GridViewIndicators.Visible = false; } } }
private void GetData(string id) { if (String.IsNullOrEmpty(id)) { return; } string strSql = @" Select a.ProjectsCode, a.StudyYear, S.StrategiesCode, b.ActivityCode, c.IndicatorsName2, c.Weight, c.WeightType, c.RateType, c.OffAll, c.OffThat, c.APercent, c.CkCriterion, c.Sort, c.EvaAssessment, c.EvaTool From Projects a Left Join dtStrategies S On a.ProjectsCode = S.ProjectsCode Inner Join Activity b On a.ProjectsCode = b.ProjectsCode Inner Join Indicators2 c On b.ActivityCode = c.ActivityCode Where c.Indicators2Code = '{0}' "; DataView dv = Conn.Select(string.Format(strSql, id)); if (dv.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); //getddlStrategies(1, ddlYearB.SelectedValue); //ddlStrategies.SelectedValue = dv[0]["StrategiesCode"].ToString(); getddlProjects(1, ddlYearB.SelectedValue, ""); ddlProjects.SelectedValue = dv[0]["ProjectsCode"].ToString(); getddlActivity(1, ddlProjects.SelectedValue); ddlActivity.SelectedValue = dv[0]["ActivityCode"].ToString(); getActivityDetail(ddlActivity.SelectedValue); if (btc.CkUseData(id, "Indicators2Code", "Evaluation", " And DelFlag = 0 ")) { ddlYearB.Enabled = false; //ddlStrategies.Enabled = false; ddlProjects.Enabled = false; ddlActivity.Enabled = false; } txtIndicators2.Text = dv[0]["IndicatorsName2"].ToString(); txtEvaAssessment.Text = dv[0]["EvaAssessment"].ToString(); txtEvaTool.Text = dv[0]["EvaTool"].ToString(); if (Convert.ToInt32(dv[0]["WeightType"].ToString()) == 0) { txtWeight.Text = ((Convert.ToDecimal(dv[0]["OffAll"].ToString()) * 50) / 100).ToString("#,##0"); } else { txtWeight.Text = string.IsNullOrEmpty(dv[0]["Weight"].ToString()) ? "0" : Convert.ToInt32(dv[0]["Weight"]).ToString("#,##0"); } ddlRateType.SelectedValue = dv[0]["RateType"].ToString(); txtAll.Text = string.IsNullOrEmpty(dv[0]["OffAll"].ToString()) ? "0" : Convert.ToInt32(dv[0]["OffAll"]).ToString("#,##0"); txtSort.Text = dv[0]["Sort"].ToString(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "Indicators2", "Indicators2Code", id); Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "ckRateType(1); Calculate(0);", true); } }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From StudyYear Where StudyYear = '" + id + "'")); if (dv.Count != 0) { txtStudyYear.Text = dv[0]["StudyYear"].ToString(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "StudyYear", "StudyYear", id); } }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From IdentityName Where IdentityNameCode = '" + id + "'")); if (dv.Count != 0) { txtIdentityName.Text = dv[0]["IdentityName"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); } btc.getCreateUpdateUser(lblCreate, lblUpdate, "IdentityName", "IdentityNameCode", id); }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From Department Where DeptCode = '" + id + "'")); if (dv.Count != 0) { txtDepartment.Text = dv[0]["DeptName"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "Department", "DeptCode", id); } }
private void GetData(string id) { if (String.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From SubDepartment Where DelFlag = '0' And SubDeptCode = '" + id + "' ")); if (dv.Count != 0) { txtSubDeptName.Text = dv[0]["SubDeptName"].ToString(); ddlDepartment.SelectedValue = dv[0]["DeptCode"].ToString(); txtSort.Text = dv.Table.Rows[0]["Sort"].ToString(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "SubDepartment", "SubDeptCode", id); } }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From ScoreGroup Where ScoreGroupID = '" + id + "'")); if (dv.Count != 0) { txtScoreGroup.Text = dv[0]["ScoreGroupName"].ToString(); txtWeightScore.Text = dv[0]["WeightScore"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); } btc.getCreateUpdateUser(lblCreate, lblUpdate, "ScoreGroup", "ScoreGroupID", id); }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From NewStandard Where StandardCode = '" + id + "'")); if (dv.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); txtNewStandard.Text = dv[0]["StandardName"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); } btc.getCreateUpdateUser(lblCreate, lblUpdate, "NewStandard", "StandardCode", id); }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From SubProjectType Where SubProjectTypeID = '" + id + "'")); if (dv.Count != 0) { getddlProjectType(1); ddlProjectType.SelectedValue = dv[0]["ProjectTypeID"].ToString(); txtSubProjectType.Text = dv[0]["SubProjectTypeName"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); } btc.getCreateUpdateUser(lblCreate, lblUpdate, "SubProjectType", "SubProjectTypeID", id); }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From Popularity Where PopularityID = '" + id + "'")); if (dv.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); txtPopularity.Text = dv[0]["PopularityName"].ToString(); txtDetail.Text = dv[0]["Detail"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "Popularity", "PopularityID", id); } }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From ResponseProblems Where ResponseProblemsCode = '" + id + "'")); if (dv.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); txtResponseProblems.Text = dv[0]["ResponseProblemsName"].ToString(); txtDetail.Text = dv[0]["Detail"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); } btc.getCreateUpdateUser(lblCreate, lblUpdate, "ResponseProblems", "ResponseProblemsCode", id); }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From Education21Side Where Education21SideID = '" + id + "'")); if (dv.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); ddlEvaluateType.SelectedValue = dv[0]["EvaluateType"].ToString(); txtEducation21Side.Text = dv[0]["Education21SideName"].ToString(); txtDetail.Text = dv[0]["Detail"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "Education21Side", "Education21SideID", id); } }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From Side Where SideCode = '" + id + "'")); if (dv.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); txtSide.Text = dv[0]["SideName"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); ddlScoreGroup.SelectedValue = dv[0]["ScoreGroupID"].ToString(); getCriteria(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "Side", "SideCode", id); } }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From CorporateStrategy Where CorporateStrategyID = '" + id + "'")); if (dv.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); getddlStrategies(1, ddlYearB.SelectedValue); ddlStrategies.SelectedValue = dv[0]["StrategiesCode"].ToString(); txtCorporateStrategy.Text = dv[0]["CorporateStrategyName"].ToString(); txtDetail.Text = dv[0]["Detail"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "CorporateStrategy", "CorporateStrategyID", id); } }
private void GetData(string id) { if (String.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select FactorRateID, StudyYear, Detail, Criterion, Translation, IsNull(TMin, 0) TMin, IsNull(TMax, 0) TMax From FactorRate Where DelFlag = 0 And FactorRateID = '" + id + "' ")); if (dv.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); txtDetail.Text = dv[0]["Detail"].ToString(); txtCriterion.Text = dv[0]["Criterion"].ToString(); txtTranslation.Text = dv[0]["Translation"].ToString(); txtMin.Text = Convert.ToDouble(dv[0]["TMin"]).ToString("#,##0.00"); txtMax.Text = Convert.ToDouble(dv[0]["TMax"]).ToString("#,##0.00"); } btc.getCreateUpdateUser(lblCreate, lblUpdate, "FactorRate", "FactorRateID", id); }
private void GetData(string id) { if (String.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select TcriteriaID, ScoreGroupID, Tcriteria, Detail, Criterion, Translation, IsNull(TMin, 0) TMin, IsNull(TMax, 0) TMax From TCriteria Where DelFlag = 0 And TcriteriaID = '" + id + "' ")); if (dv.Count != 0) { ddlScoreGroup.SelectedValue = dv[0]["ScoreGroupID"].ToString(); lblTcriteria.Text = dv[0]["Tcriteria"].ToString(); txtDetail.Text = dv[0]["Detail"].ToString(); txtCriterion.Text = dv[0]["Criterion"].ToString(); txtTranslation.Text = dv[0]["Translation"].ToString(); txtMin.Text = Convert.ToDouble(dv[0]["TMin"]).ToString("#,##0.00"); txtMax.Text = Convert.ToDouble(dv[0]["TMax"]).ToString("#,##0.00"); } btc.getCreateUpdateUser(lblCreate, lblUpdate, "TCriteria", "TcriteriaID", id); }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From QACategory Where QACategoryID = '" + id + "'")); if (dv.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); txtQACategory.Text = dv[0]["QACategoryName"].ToString(); txtDetail.Text = dv[0]["Detail"].ToString(); txtScore.Text = dv[0]["Score"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); //ddlScoreGroup.SelectedValue = dv[0]["ScoreGroupID"].ToString(); //getCriteria(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "QACategory", "QACategoryID", id); } }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From Expenses Where ExpensesCode = '" + id + "'")); if (dv.Count != 0) { lblExpensesCode.Text = dv[0]["ExpensesCode"].ToString(); ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); ddlYearB.Enabled = false; txtSubsidies.Text = Convert.ToDecimal(dv[0]["Subsidies"]).ToString("#,##0"); txtRevenue.Text = Convert.ToDecimal(dv[0]["Revenue"]).ToString("#,##0"); txtFree.Text = Convert.ToDecimal(dv[0]["Free"]).ToString("#,##0"); txtOther.Text = Convert.ToDecimal(dv[0]["Other"]).ToString("#,##0"); } btc.getCreateUpdateUser(lblCreate, lblUpdate, "Expenses", "ExpensesCode", id); Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "SumTotal();", true); }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } string strSql = @"Select SD.*, S.StudyYear From SufficeSide S, SufficeStandard SD Where SD.SufficeStandardID = '{0}' And S.SufficeSideID = SD.SufficeSideID "; DataView dv = Conn.Select(string.Format(strSql, id)); if (dv.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); getddlSufficeSide(1, ddlYearB.SelectedValue); ddlSufficeSide.SelectedValue = dv[0]["SufficeSideID"].ToString(); txtSufficeStandard.Text = dv[0]["SufficeStandardName"].ToString(); txtDetail.Text = dv[0]["Detail"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); } btc.getCreateUpdateUser(lblCreate, lblUpdate, "SufficeStandard", "SufficeStandardID", id); }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } string strSql = @" Select b.*, a.StudyYear From FourthAssessmentSide a, FourthAssessmentIndicator b Where b.FourthAssessmentIndicatorID = '{0}' And a.FourthAssessmentSideID = b.FourthAssessmentSideID "; DataView dv = Conn.Select(string.Format(strSql, id)); if (dv.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); getddlFourthAssessmentSide(1, ddlYearB.SelectedValue); ddlFourthAssessmentSide.SelectedValue = dv[0]["FourthAssessmentSideID"].ToString(); txtFourthAssessmentIndicator.Text = dv[0]["FourthAssessmentIndicatorName"].ToString(); txtDetail.Text = dv[0]["Detail"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); } btc.getCreateUpdateUser(lblCreate, lblUpdate, "FourthAssessmentIndicator", "FourthAssessmentIndicatorID", id); }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From RoyalAwardIndicator Where RoyalAwardIndicatorID = '" + id + "'")); if (dv.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); getddlRoyalAwardSide(1, ddlYearB.SelectedValue); ddlRoyalAwardSide.SelectedValue = dv[0]["RoyalAwardSideID"].ToString(); txtRoyalAwardIndicator.Text = dv[0]["RoyalAwardIndicatorName"].ToString(); txtComment.Text = dv[0]["Comment"].ToString(); txtDetail.Text = dv[0]["Detail"].ToString(); txtScore.Text = dv[0]["Score"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); //ddlScoreGroup.SelectedValue = dv[0]["ScoreGroupID"].ToString(); //getCriteria(); } btc.getCreateUpdateUser(lblCreate, lblUpdate, "RoyalAwardIndicator", "RoyalAwardIndicatorID", id); }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } string strSql = @" Select D.*, MD.MainDeptCode From Department D Inner Join MainSubDepartment MSD On D.MainSubDeptCode = MSD.MainSubDeptCode Inner Join MainDepartment MD On MSD.MainDeptCode = MD.MainDeptCode Where D.DeptCode = '{0}' "; DataView dv = Conn.Select(string.Format(strSql, id)); if (dv.Count != 0) { ddlMainDept.SelectedValue = dv[0]["MainDeptCode"].ToString(); btc.getddlMainSubDepartment(1, ddlMainSubDept, ddlMainDept.SelectedValue, null); ddlMainSubDept.SelectedValue = dv[0]["MainSubDeptCode"].ToString(); txtDepartment.Text = dv[0]["DeptName"].ToString(); txtDeptShortName.Text = dv[0]["DeptShortName"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "Department", "DeptCode", id); } }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } string strSql = @"Select SD.*, S.StudyYear, S.EvaluateType From Education21Side S, Education21Standard SD Where SD.Education21StandardID = '{0}' And S.Education21SideID = SD.Education21SideID "; DataView dv = Conn.Select(string.Format(strSql, id)); if (dv.Count != 0) { ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); ddlEvaluateType.SelectedValue = dv[0]["EvaluateType"].ToString(); getddlEducation21Side(1, ddlYearB.SelectedValue); ddlEducation21Side.SelectedValue = dv[0]["Education21SideID"].ToString(); txtEducation21Standard.Text = dv[0]["Education21StandardName"].ToString(); txtDetail.Text = dv[0]["Detail"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); cbCkEvaluate.Checked = Convert.ToBoolean(dv[0]["ckEvaluate"]); } btc.getCreateUpdateUser(lblCreate, lblUpdate, "Education21Standard", "Education21StandardID", id); }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } string strSql = @" Select AD.*, IsNull(A.ActivityStatus, 0) ActivityStatus From ActivityDetail AD, Activity A Where AD.ActivityCode = A.ActivityCode And AD.ActivityDetailCode = '{0}' "; DataView dv = Conn.Select(string.Format(strSql, id)); if (dv.Count != 0) { txtActivityDetail.Text = dv[0]["ActivityDetail"].ToString(); txtSDay.Text = Convert.ToDateTime(dv[0]["TDay"]).ToShortDateString(); ddlSDay.SelectedValue = Convert.ToDateTime(dv[0]["TDay"]).Day.ToString("00"); ddlSMonth.SelectedValue = Convert.ToDateTime(dv[0]["TDay"]).Month.ToString("00"); ddlSYear.SelectedValue = (Convert.ToDateTime(dv[0]["TDay"]).Year + 543).ToString(); txtWithdrow.Text = dv[0]["Sort"].ToString(); txtResponsibleName.Text = dv[0]["ResponsibleName"].ToString(); txtPositionResponsible.Text = dv[0]["PositionResponsible"].ToString(); txtHeadGroupName.Text = dv[0]["HeadGroupName"].ToString(); txtPositionHeadGroup.Text = dv[0]["PositionHeadGroup"].ToString(); txtHeadGroupSaraName.Text = dv[0]["HeadGroupSaraName"].ToString(); txtPositionHeadGroupSara.Text = dv[0]["PositionHeadGroupSara"].ToString(); txtUnderManagerName.Text = dv[0]["UnderManagerName"].ToString(); txtPositionUnderManagerName.Text = dv[0]["PositionUnderManagerName"].ToString(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "ActivityDetail", "ActivityDetailCode", id); getBudgetEdit(dv[0]["ActivityDetailCode"].ToString()); if (Convert.ToBoolean(Cookie.GetValue2("ckActivityStatus"))) { DivActivityStatus.Visible = true; ddlActivityStatus.SelectedValue = dv[0]["ActivityStatus"].ToString(); } } }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } DataView dv = Conn.Select(string.Format("Select * From LogSchoolSar Where LogID = '" + id + "'")); if (dv.Count != 0) { txtVersion.Text = dv[0]["Version"].ToString(); txtVirtualName.Text = dv[0]["VirtualName"].ToString(); txtSchoolName.Text = dv[0]["SchoolName"].ToString(); ddlProvince.SelectedValue = dv[0]["ProvinceID"].ToString(); txtIPaddress.Text = dv[0]["IPaddress"].ToString(); txtConnectName.Text = dv[0]["ConnectName"].ToString(); txtTel.Text = dv[0]["Tel"].ToString(); txtSaleName.Text = dv[0]["SaleName"].ToString(); rdoStatus.SelectedValue = dv[0]["LogStatus"].ToString(); txtRent.Text = dv[0]["rent"].ToString(); txtSDay.Text = (string.IsNullOrEmpty(dv[0]["SDate"].ToString()) ? DateTime.Now.ToShortDateString() : Convert.ToDateTime(dv[0]["SDate"]).ToShortDateString()); ddlSDay.SelectedValue = (string.IsNullOrEmpty(dv[0]["SDate"].ToString()) ? DateTime.Now.Day.ToString("00") : Convert.ToDateTime(dv[0]["SDate"]).Day.ToString("00")); ddlSMonth.SelectedValue = (string.IsNullOrEmpty(dv[0]["SDate"].ToString()) ? DateTime.Now.Month.ToString("00") : Convert.ToDateTime(dv[0]["SDate"]).Month.ToString("00")); ddlSYear.SelectedValue = (string.IsNullOrEmpty(dv[0]["SDate"].ToString()) ? (DateTime.Now.Year + 543).ToString() : (Convert.ToDateTime(dv[0]["SDate"]).Year + 543).ToString()); txtEDay.Text = (string.IsNullOrEmpty(dv[0]["EDate"].ToString()) ? DateTime.Now.ToShortDateString() : Convert.ToDateTime(dv[0]["EDate"]).ToShortDateString()); ddlEDay.SelectedValue = (string.IsNullOrEmpty(dv[0]["EDate"].ToString()) ? DateTime.Now.Day.ToString("00") : Convert.ToDateTime(dv[0]["EDate"]).Day.ToString("00")); ddlEMonth.SelectedValue = (string.IsNullOrEmpty(dv[0]["EDate"].ToString()) ? DateTime.Now.Month.ToString("00") : Convert.ToDateTime(dv[0]["EDate"]).Month.ToString("00")); ddlEYear.SelectedValue = (string.IsNullOrEmpty(dv[0]["EDate"].ToString()) ? (DateTime.Now.Year + 543).ToString() : (Convert.ToDateTime(dv[0]["EDate"]).Year + 543).ToString()); rbtlRenew.SelectedValue = Convert.ToInt32(dv[0]["ckExpDate"]).ToString(); btc.getCreateUpdateUser(lblCreate, lblUpdate, "LogSchoolSar", "LogID", id); } }