protected int ExcuteUpdate(int rightid)
{
int val = -10;
string UpdateCommand = "UPDATE [right] SET [rshid] = @rshid, [drugid] = @drugid, [rttype] = @rttype, [rtname] = @rtname, [rtcontent] = @rtcontent WHERE [rtid] = @rtid";
SqlParameter[] par = new SqlParameter[6];
if (Session["drugid"] == null)
{
Response.Redirect("../Admin/AdWeb/APassport.aspx");
return(0);
}
par[0] = new SqlParameter("@rtid", SqlDbType.Int); par[0].Value = rightid;
par[1] = new SqlParameter("@rshid", SqlDbType.Int); par[1].Value = Convert.ToInt32(hid_rsid.Value);
par[2] = new SqlParameter("@drugid", SqlDbType.Int); par[2].Value = Convert.ToInt32(hid_drugid.Value);
par[3] = new SqlParameter("@rttype", SqlDbType.Int); par[3].Value = UcDDRright1.SelectedValue;
par[4] = new SqlParameter("@rtname", SqlDbType.NVarChar, 800); par[4].Value = CharTextRequired1.TextValue;
par[5] = new SqlParameter("@rtcontent", SqlDbType.NText); par[5].Value = RichText1.TextValue;
cRightss crght = new cRightss();
try
{
val = crght.ModiRightss(UpdateCommand, par);
}
catch
{ }
return(val);
}
public void DataBindText(string drugid)
{
cRightss ccrt = new cRightss();
try
{
DataTable dt = ccrt.GetCrtDtByDrugid(drugid);
gv.Visible = (dt.Rows.Count > 0) ? true : false;
if (dt.Rows.Count > 0)
{
//绑定到GV
gv.DataSource = dt;
gv.DataBind();
}
}
catch
{ }
}
protected int ExcuteInsert()
{
int val = -10;
string InsertCommand = "INSERT INTO [right] ([rshid], [drugid], [rttype], [rtname], [rtcontent]) VALUES (@rshid, @drugid, @rttype, @rtname, @rtcontent)";
SqlParameter[] par = new SqlParameter[5];
int idrugid = 0;
if (Session["drugid"] != null && Session["rsid"] != null)
{
hid_drugid.Value = Session["drugid"].ToString();
idrugid = Convert.ToInt32(Session["drugid"].ToString());
hid_rsid.Value = Session["rsid"].ToString().Trim();
}
else
{
//这个地方还需要再次考虑一下，是否要弹出一个窗口
Response.Redirect("../Admin/AdWeb/APassport.aspx");
}
par[0] = new SqlParameter("@rshid", SqlDbType.Int); par[0].Value = Convert.ToInt32(hid_rsid.Value);
par[1] = new SqlParameter("@drugid", SqlDbType.Int); par[1].Value = Convert.ToInt32(hid_drugid.Value);
par[2] = new SqlParameter("@rttype", SqlDbType.Int); par[2].Value = UcDDRright1.SelectedValue;
par[3] = new SqlParameter("@rtname", SqlDbType.NVarChar, 800); par[3].Value = CharTextRequired1.TextValue;
par[4] = new SqlParameter("@rtcontent", SqlDbType.NText); par[4].Value = RichText1.TextValue;
cRightss crght = new cRightss();
int grtid = -10;
try
{
val = crght.ModiRightss(InsertCommand, par);
//插入成功之后要取出刚刚插入的rtid
grtid = crght.GetrtidByRsid(hid_rsid.Value);
hid_rightid.Value = grtid.ToString();
// Session["rtid"] = grtid;
}
catch
{ }
return(val);
}
