protected int ExcuteInsert()
{
int val = -10;
string InsertCommand = "INSERT INTO [chemistry] ([rshid], [drugid], [cmname], [cmformula], [cmpic]) VALUES (@rshid, @drugid, @cmname, @cmformula, @cmpic)";
SqlParameter[] par = new SqlParameter[5];
int idrugid = 0;
int irsid = 0;
if (Session["drugid"] != null && Session["rsid"] != null)
{
idrugid = Convert.ToInt32(hid_drugid.Value.ToString().Trim());
irsid = Convert.ToInt32(hid_rsid.Value.ToString().Trim());
}
else
{
//这个地方还需要再次考虑一下，是否要弹出一个窗口
Response.Redirect("../Admin/AdWeb/APassport.aspx");
}
par[0] = new SqlParameter("@rshid", SqlDbType.Int); par[0].Value = irsid;
par[1] = new SqlParameter("@drugid", SqlDbType.Int); par[1].Value = idrugid;
par[2] = new SqlParameter("@cmname", SqlDbType.NVarChar, 80); par[2].Value = CharText1.TextValue;
par[3] = new SqlParameter("@cmformula", SqlDbType.NVarChar, 100); par[3].Value = CharText2.TextValue;
par[4] = new SqlParameter("@cmpic", SqlDbType.NVarChar, 100); par[4].Value = lbl_cmpicURL.Text.ToString().Trim();
cChemistry ccm = new cChemistry();
DataTable ccmdt;
int gcmid = -10;
try
{
val = ccm.ModiChemistry(InsertCommand, par);
//根据文化属性编号去查询，可能和根据药物编号查询效果一致的，但是效果更好些。
//此处可能有zhuyc漏洞，因为可能有并发的问题
ccmdt = ccm.GetCmDtByRshid(irsid.ToString());
if (ccmdt.Rows.Count > 0)
{
//插入新的数据后马上获取它的自增主关键字,方便更新。
gcmid = Convert.ToInt32(ccmdt.Rows[ccmdt.Rows.Count - 1]["cmid"].ToString().Trim());
Session["cmid"] = gcmid;
hid_cmid.Value = gcmid.ToString().Trim();
}
}
catch
{ }
return(val);
}
public void DataBindText(string drugid)
{
cChemistry ccm = new cChemistry();
try
{
DataTable dt = ccm.GetCmDtByDrugid(drugid);
gv.Visible = (dt.Rows.Count > 0) ? true : false;
if (dt.Rows.Count > 0)
{
//绑定到GV
gv.DataSource = dt;
gv.DataBind();
}
}
catch
{ }
}
