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