Page 287 - ระบบบริหารจัดการงบประมาณด้านเทคโนโลยีสารสนเทศและการสื่อสาร กรมพัฒนาที่ดิน
P. 287
ห้องสมุดกรมพัฒนาที่ดิน
ง-32
if (sType != "Admin" && sType != "Exe")
sSql += " AND (formAlterHSWProcure.RecUser = N'" + sUsername + "')";
else
{ if (!cbAllBureau.Checked)
sSql += " AND (formAlterHSWProcure.Bureau = '" + ddlBureau.SelectedValue + "')";
}
if (txtFiscalYear.Text != "")
sSql += " AND (formAlterHSWProcure.FiscalYear = '" + txtFiscalYear.Text + "')";
if (txtProjectName.Text != "")
sSql += " AND (formAlterHSWProcure.ProjectName like '%" + txtProjectName.Text +
"%')"
if (txtResponsiblePerson.Text != "")
sSql += " AND (formAlterHSWProcure.ResponsiblePerson like '%" +
txtResponsiblePerson.Text + "%')";
if (txtCoordinator.Text != "")
sSql += " AND (formAlterHSWProcure.Coordinator like '%" + txtCoordinator.Text +
"%')";
if (ddlSendStatus.SelectedValue != "All")
sSql +=" AND (formAlterHSWProcure.SendStatus ='"+ ddlSendStatus.SelectedValue +
"')";
if (ddlApproveStatus.SelectedValue != "All")
sSql += " AND (formAlterHSWProcure.ApproveStatus = '" +
ddlApproveStatus.SelectedValue + "')";
if (ddlFinishJobStatus.SelectedValue != "All")
sSql += " AND (formAlterHSWProcure.FinishJobStatus = '" +
ddlFinishJobStatus.SelectedValue + "')";
sSql += " Order by Bureau.Ord";
dsShow.SelectCommand = sSql;
gvShow.DataBind();
//Response.Write(sSql);
}