protected int ExcuteUpdate(int keyid)
{
string UpdateCommand = "UPDATE [preparation] SET [pName] = @pName, [about] = @about WHERE [ppid] = @ppid";
int val = -10;
SqlParameter[] par = new SqlParameter[3];
if (Session["drugid"] == null)
{
//这个地方还需要再次考虑一下，是否要弹出一个窗口
Response.Redirect("../Admin/AdWeb/APassport.aspx");
return(0);
}
par[0] = new SqlParameter("@pName", SqlDbType.NText); par[0].Value = CharTextRequired1.TextValue;
par[1] = new SqlParameter("@about", SqlDbType.NText); par[1].Value = RichText1.TextValue;
par[2] = new SqlParameter("@ppid", SqlDbType.Int); par[2].Value = keyid;
cpreparation _cpr = new cpreparation();
try
{
val = _cpr.ModiPrepatation(UpdateCommand, par);
}
catch
{ }
return(val);
}
public void DataBindText(string drugid)
{
cpreparation cport = new cpreparation();
try
{
DataTable dt = cport.GetPrepatationDT(drugid);
if (dt.Rows.Count > 0)
{
//绑定到repeater上
Rpter_person.DataSource = dt;
Rpter_person.DataBind();
}
Rpter_person.Visible = (dt.Rows.Count > 0) ? true : false;
}
catch
{ }
}
//Excute在插入操作之后能在 Session["keyppid"] = keyid;和隐藏的值 hid_keyid.Value = keyid.ToString().Trim();保留主键id
protected int ExcuteInsert()
{
int val = -10;
//插入命令
string InsertCommand = "INSERT INTO [preparation] ( [drugid], [pName], [about]) VALUES (@drugid, @pName, @about)";
SqlParameter[] par = new SqlParameter[3];
int idrugid = 0;
if (Session["drugid"] != null)
{
idrugid = Convert.ToInt32(Session["drugid"].ToString());
}
else
{
//这个地方还需要再次考虑一下，是否要弹出一个窗口
Response.Redirect("../Admin/AdWeb/APassport.aspx");
}
par[0] = new SqlParameter("@drugid", SqlDbType.Int); par[0].Value = idrugid;
par[1] = new SqlParameter("@pName", SqlDbType.NText); par[1].Value = CharTextRequired1.TextValue;
par[2] = new SqlParameter("@about", SqlDbType.NText); par[2].Value = RichText1.TextValue;
cpreparation _cpr = new cpreparation();
DataTable dtcpre;
int keyid = 0;
try
{
val = _cpr.ModiPrepatation(InsertCommand, par);
dtcpre = _cpr.GetPrepatationDT(idrugid.ToString());
if (dtcpre.Rows.Count > 0)
{
//ppid为自增的主键id，所以要在保存之后立马把它的主键id获取到，以利于更新
keyid = Convert.ToInt32(dtcpre.Rows[dtcpre.Rows.Count - 1]["ppid"].ToString().Trim());
Session["keyppid"] = keyid;
hid_keyid.Value = keyid.ToString().Trim();
}
}
catch
{ }
return(val);
}
