private void getUser()
{
BTC btc = new BTC();
DataView dv = btc.getMasterSchool();
if (dv.Count != 0)
{
lblConUser.Text = btc.getEmpName(dv[0]["ConUser"].ToString()) + " : ผู้รับผิดชอบ";
}
}
private void GetData(string id)
{
if (string.IsNullOrEmpty(id))
{
return;
}
string strSql = @"Select P.*, IsNull(P.SetBudget, 0) Set_Budget, D.MainSubDeptCode
From Projects P Inner Join Department D On P.DeptCode = D.DeptCode
Where ProjectsCode = '{0}' ";
DataView dv = Conn.Select(string.Format(strSql, id));
DataView dv1 = Conn.Select(string.Format("Select StandardNationCode From dtStandardNation Where ProjectsCode = '" + id + "' "));
DataView dv2 = Conn.Select(string.Format("Select StandardMinistryCode From dtStandardMinistry Where ProjectsCode = '" + id + "' "));
DataView dv333 = Conn.Select(string.Format("Select StrategicObjectivesCode From dtStrategicObjectives Where ProjectsCode = '" + id + "' "));
DataView dv9 = Conn.Select(string.Format("Select StrategicCode From dtStrategic Where ProjectsCode = '" + id + "' "));
DataView dv18 = Conn.Select(string.Format("Select StrategicPlanID From dtStrategicPlan Where ProjectsCode = '" + id + "' "));
DataView dv19 = Conn.Select(string.Format("Select CorporateStrategyID From dtCorporateStrategy Where ProjectsCode = '" + id + "' "));
if (dv.Count != 0)
{
ddlYearS.SelectedValue = dv[0]["StudyYear"].ToString();
lblYearS.Text = ddlYearS.SelectedItem.Text;
SetItem();
if (btc.CkUseData(id, "ProjectsCode", "Activity", " And DelFlag = 0 "))
{
ddlYearS.Enabled = false;
}
ddlStrategicPlan.SelectedValue = dv[0]["StrategicPlanID"].ToString();
txtStrategicPlan.Text = dv[0]["StrategicPlan"].ToString();
txtProjects.Text = dv[0]["ProjectsName"].ToString();
hdfMainSubDeptCode.Value = dv[0]["MainSubDeptCode"].ToString();
txtIdentityName.Text = dv[0]["IdentityName"].ToString();
txtIdentityName2.Text = dv[0]["IdentityName2"].ToString();
txtPurpose.Text = dv[0]["Purpose"].ToString();
txtPurpose2.Text = dv[0]["Purpose2"].ToString();
txtTarget.Text = dv[0]["Target"].ToString();
txtTarget2.Text = dv[0]["Target2"].ToString();
txtPeriod1.Text = dv[0]["Period1"].ToString();
hdfCreateUser.Value = dv[0]["CreateUser"].ToString();
txtProjectsDetail.Text = dv[0]["ProjectsDetail"].ToString();
txtResponsibleName.Text = dv[0]["ResponsibleName"].ToString();
txtResponsiblePosition.Text = dv[0]["ResponsiblePosition"].ToString();
txtSort.Text = dv[0]["Sort"].ToString();
txtProjectRegistration.Text = dv[0]["ProjectRegistration"].ToString();
txtIOCode.Text = dv[0]["IOCode"].ToString();
rbtlProjectType.SelectedValue = dv[0]["ProjectTypeID"].ToString();
rbtlProjectType.Enabled = false;
getrbtlSubProjectType();
rbtlSubProjectType.SelectedValue = dv[0]["SubProjectTypeID"].ToString();
rbtlSubProjectType.Enabled = false;
txtPlace.Text = dv[0]["Place1"].ToString();
txtEvaTool.Text = dv[0]["EvaTool"].ToString();
btc.getddlDepartment(1, ddlDept, "", CurrentUser.DeptID, null);
ddlDept.SelectedValue = dv[0]["DeptCode"].ToString();
lblDept.Text = ddlDept.SelectedItem.Text;
btc.getddlDepartmentJoin(1, ddlDeptJoin, "", ddlDept.SelectedValue);
ddlDeptJoin.SelectedValue = dv[0]["DeptJoinCode"].ToString();
if (!string.IsNullOrEmpty(dv[0]["DeptJoinCode"].ToString()))
{
lblDeptJoin.Text = ddlDeptJoin.SelectedItem.Text;
}
else
{
lblDeptJoin.Text = "-";
}
ddlDeptJoin.Visible = false;
ddlDept.Visible = false;
txtConclusion.Text = dv[0]["Conclusion"].ToString();
txtPerformance.Text = dv[0]["Performance"].ToString();
txtProblem.Text = dv[0]["Problem"].ToString();
txtSolutions.Text = dv[0]["Solutions"].ToString();
if (!string.IsNullOrEmpty(dv[0]["SDate"].ToString()))
{
txtSDay.Text = Convert.ToDateTime(dv[0]["SDate"]).ToShortDateString();
}
if (!string.IsNullOrEmpty(dv[0]["EDate"].ToString()))
{
txtEDay.Text = Convert.ToDateTime(dv[0]["EDate"]).ToShortDateString();
}
}
btc.getCreateUpdateUser(lblCreate, lblUpdate, "Projects", "ProjectsCode", id);
if (!string.IsNullOrEmpty(dv[0]["IsApprove"].ToString()))
{
if (Convert.ToInt32(dv[0]["IsApprove"]) == 1)
{
lblApprove.Text = "<span style=\"font-weight:bold;\"> ͹ØÁѵÔâ¤Ã§¡ÒÃâ´Â : </span>" + btc.getEmpName(dv[0]["UserApprove"].ToString()) + "<br /><span style=\"font-weight:bold;\"> Çѹ·Õè : </span>" + Convert.ToDateTime(dv[0]["DateApprove"]).ToString("dd/MM/yyyy");
lblComment.Text = "<span style=\"font-weight:bold;\">¤ÇÒÁ¤Ô´àËç¹ : </span>" + dv[0]["Comment"].ToString();
lblApprove.ForeColor = System.Drawing.Color.Green;
lblComment.ForeColor = System.Drawing.Color.Green;
}
else
{
lblApprove.Text = "<span style=\"font-weight:bold;\">äÁè͹ØÁѵÔâ¤Ã§¡ÒÃâ´Â : </span>" + btc.getEmpName(dv[0]["UserApprove"].ToString()) + "<br /><span style=\"font-weight:bold;\"> Çѹ·Õè : </span>" + Convert.ToDateTime(dv[0]["DateApprove"]).ToString("dd/MM/yyyy");
lblComment.Text = "<span style=\"font-weight:bold;\">¤ÇÒÁ¤Ô´àËç¹ : </span>" + dv[0]["Comment"].ToString();
lblApprove.ForeColor = System.Drawing.Color.Red;
lblComment.ForeColor = System.Drawing.Color.Red;
}
}
if (hdfCreateUser.Value != CurrentUser.ID)
{
if (CurrentUser.RoleLevel < 98)
{
btSave.Visible = false;
}
}
else
{
//if (btc.ckApproveFlow(id)) //àªç¤ÇèÒÁÕ¡Òà Approve ä»áÅéÇËÃ×ÍÂѧ
//{
// btSave.Visible = false;
//}
}
//if (dv18.Count != 0)
//{
// for (int i = 0; i <= cblStrategicPlan.Items.Count - 1; i++)
// {
// for (int j = 0; j <= dv18.Count - 1; j++)
// {
// if (cblStrategicPlan.Items[i].Value == dv18[j]["StrategicPlanID"].ToString())
// {
// cblStrategicPlan.Items[i].Selected = true;
// break;
// }
// }
// }
//}
if (btc.ckIdentityName("ckStrategies"))
{
DataView dv100 = Conn.Select(string.Format("Select StrategiesCode From dtStrategies Where ProjectsCode = '" + id + "'"));
if (dv100.Count != 0)
{
for (int i = 0; i <= cblStrategies.Items.Count - 1; i++)
{
for (int j = 0; j <= dv100.Count - 1; j++)
{
if (cblStrategies.Items[i].Value == dv100[j]["StrategiesCode"].ToString())
{
cblStrategies.Items[i].Selected = true;
break;
}
}
}
}
}
cblStrategies.Enabled = false;
btc.getcblCorporateStrategy(divCorporateStrategy, cblCorporateStrategy, ddlYearS.SelectedValue, cblStrategies); //KPI
if (dv19.Count != 0)
{
for (int i = 0; i <= cblCorporateStrategy.Items.Count - 1; i++)
{
for (int j = 0; j <= dv19.Count - 1; j++)
{
if (cblCorporateStrategy.Items[i].Value == dv19[j]["CorporateStrategyID"].ToString())
{
cblCorporateStrategy.Items[i].Selected = true;
break;
}
}
}
}
cblCorporateStrategy.Enabled = false;
if (dv1.Count != 0)
{
for (int i = 0; i <= cblStandardNation.Items.Count - 1; i++)
{
for (int j = 0; j <= dv1.Count - 1; j++)
{
if (cblStandardNation.Items[i].Value == dv1[j]["StandardNationCode"].ToString())
{
cblStandardNation.Items[i].Selected = true;
break;
}
}
}
}
if (dv2.Count != 0)
{
for (int i = 0; i <= cblStandardMinistry.Items.Count - 1; i++)
{
for (int j = 0; j <= dv2.Count - 1; j++)
{
if (cblStandardMinistry.Items[i].Value == dv2[j]["StandardMinistryCode"].ToString())
{
cblStandardMinistry.Items[i].Selected = true;
break;
}
}
}
}
if (dv333.Count != 0)
{
for (int i = 0; i <= cblStrategicObjectives.Items.Count - 1; i++)
{
for (int j = 0; j <= dv333.Count - 1; j++)
{
if (cblStrategicObjectives.Items[i].Value == dv333[j]["StrategicObjectivesCode"].ToString())
{
cblStrategicObjectives.Items[i].Selected = true;
break;
}
}
}
}
if (dv9.Count != 0)
{
for (int i = 0; i <= cblStrategic.Items.Count - 1; i++)
{
for (int j = 0; j <= dv9.Count - 1; j++)
{
if (cblStrategic.Items[i].Value == dv9[j]["StrategicCode"].ToString())
{
cblStrategic.Items[i].Selected = true;
break;
}
}
}
}
if (btc.ckIdentityName("iNameShow2"))
{
DataView dv101 = Conn.Select(string.Format("Select IdentityNameCode From dtIdentityName Where ProjectsCode = '" + id + "'"));
if (dv101.Count != 0)
{
for (int i = 0; i <= cblIdentityName2.Items.Count - 1; i++)
{
for (int j = 0; j <= dv101.Count - 1; j++)
{
if (cblIdentityName2.Items[i].Value == dv101[j]["IdentityNameCode"].ToString())
{
cblIdentityName2.Items[i].Selected = true;
break;
}
}
}
}
}
cblIdentityName2.Enabled = false;
}
