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