protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataDeal deal = new DataDeal();
deal.BindCodeList("ColorType", MarkColor, false);
deal.BindCodeList("MarkCategory", CategoryID, false);
deal.BindCodeList("Rq_Status", TechLevel, false);
if ("tech".Equals(QueryString["entity"]))
{
txtKeywords.Text = deal.GetScalar("select Rq_Keywords from Rq_words_alg where Rq_ID=" + QueryString["id"]);
txtNotes.Text = deal.GetScalar("select Rq_EnpDes from TechRequire where Rq_ID=" + QueryString["id"]);
Literal1.Text = deal.GetScalar("select dbo.f_GetMark('" + QueryString["entity"] + "'," + QueryString["id"] + ")");
string temp = deal.GetScalar("select Rq_Status from TechRequire where Rq_ID=" + QueryString["id"]);
Literal2.Text = deal.GetScalar("select name from f_code where ID='Rq_status' and f_code.Code like " + temp);
}
else if ("researcher".Equals(QueryString["entity"]))
{
DataTable dt = deal.GetTable("select Extract from Researcher where id=" + QueryString["id"]);
if (!DataHelper.IsNullOrEmpty(dt))
{
txtKeywords.Text = "";
txtNotes.Text = dt.Rows[0]["Extract"].ToString();
}
}
CategoryID_SelectedIndexChanged(null, null);
}
}
