protected void btnSave_Click(object sender, EventArgs e) { List <String> sqls = new List <string>(); sqls.Add("delete from Mark where Entity='" + QueryString["entity"] + "' and EntityID='" + QueryString["id"] + "' and MarkType=" + CategoryID.SelectedValue); foreach (ListItem li in Marks.Items) { if (li.Selected) { sqls.Add(@"INSERT INTO Mark(Entity ,Marker ,MarkTime ,MarkDes ,MarkColor ,EntityID ,MarkType) VALUES('" + QueryString["entity"] + @"' ,'" + CurrentUser.Id + @"' ,getdate() ,'" + li.Value + @"' ," + MarkColor.SelectedValue + @" ,'" + QueryString["id"] + @"' ," + CategoryID.SelectedValue + ")"); } } DataDeal deal = new DataDeal(); deal.SqlExecute(sqls); Literal1.Text = deal.GetScalar("select dbo.f_GetMark('" + QueryString["entity"] + "'," + QueryString["id"] + ")"); Alert("标签提交成功,你可以继续选择其他体系和分类,继续打标签", MarkColor.ClientID); }
protected void Button1_Click(object sender, EventArgs e) { int Rq_Satae = 0; switch (TechLevel.SelectedIndex) { case 0: Rq_Satae = 0; break; case 1: Rq_Satae = 1; break; case 2: Rq_Satae = 2; break; } String sql = String.Format("update TechRequire set Rq_status={0} where Rq_ID={1}", Rq_Satae, QueryString["id"]); DataDeal deal = new DataDeal(); deal.SqlExecute(sql); 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); Alert("需求等级标签修改成功"); }
protected void btnSave_Clickc(object sender, EventArgs e) { String sql = String.Format("delete from Mark where Entity='tech' and EntityID={0}", QueryString["id"]); DataDeal deal = new DataDeal(); deal.SqlExecute(sql); Alert("标签清空"); Literal1.Text = deal.GetScalar("select dbo.f_GetMark('" + QueryString["entity"] + "'," + QueryString["id"] + ")"); }