protected int ExcuteUpdate(int keyid)
{
int val = -10;
string UpdateCommand = "UPDATE [chemistry] SET [rshid] = @rshid, [drugid] = @drugid, [cmname] = @cmname, [cmformula] = @cmformula, [cmpic] = @cmpic WHERE [cmid] = @cmid";
SqlParameter[] par = new SqlParameter[6];
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("@cmid", SqlDbType.Int); par[0].Value = keyid;
par[1] = new SqlParameter("@rshid", SqlDbType.Int); par[1].Value = irsid;
par[2] = new SqlParameter("@drugid", SqlDbType.Int); par[2].Value = idrugid;
par[3] = new SqlParameter("@cmname", SqlDbType.NVarChar, 80); par[3].Value = CharText1.TextValue;
par[4] = new SqlParameter("@cmformula", SqlDbType.NVarChar, 100); par[4].Value = CharText2.TextValue;
par[5] = new SqlParameter("@cmpic", SqlDbType.NVarChar, 100); par[5].Value = lbl_cmpicURL.Text.ToString().Trim();
cResearch crh = new cResearch();
try
{
//在这里要拿到更新之前图片的名字
string GetsavePath = cChemistry.GetImgID(keyid); //这里是你的相对路径
string savePath = Server.MapPath(GetsavePath); //必须经过这一步操作才能变成有效路径
// 更新之后会改变原有的图片
val = crh.ModiResearch(UpdateCommand, par);
//更新结束后应该把原来的哪个图片给删除掉，但是图片的名字在更新之前要先拿到
if (GetsavePath != lbl_cmpicURL.Text.ToString().Trim())
{
if (System.IO.File.Exists(savePath))//先判断文件是否存在，再执行操作
{
System.IO.File.Delete(savePath);
}
}
}
catch
{ }
return(val);
}
protected int ExcuteInsert()
{
int val = -10;
string InsertCommand = "INSERT INTO [Research] ([drugid], [rsh21], [rsh22], [rsh23], [rsh24], [rsh25], [rsh26], [rsh27], [rsh28], [rsh29], [rsh30], [rsh31]) VALUES (@drugid, @rsh21, @rsh22, @rsh23, @rsh24, @rsh25, @rsh26, @rsh27, @rsh28, @rsh29, @rsh30, @rsh31)";
SqlParameter[] par = new SqlParameter[12];
int idrugid = 0;
if (Session["drugid"] != null)
{
hid_drugid.Value = Session["drugid"].ToString();
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("@rsh21", SqlDbType.NText); par[1].Value = RichText21.TextValue;
par[2] = new SqlParameter("@rsh22", SqlDbType.NText); par[2].Value = RichText22.TextValue;
par[3] = new SqlParameter("@rsh23", SqlDbType.NVarChar, 50); par[3].Value = "";
par[4] = new SqlParameter("@rsh24", SqlDbType.NText); par[4].Value = RichText24.TextValue;
par[5] = new SqlParameter("@rsh25", SqlDbType.NText); par[5].Value = RichText25.TextValue;
par[6] = new SqlParameter("@rsh26", SqlDbType.NText); par[6].Value = RichText26.TextValue;
par[7] = new SqlParameter("@rsh27", SqlDbType.NText); par[7].Value = RichText27.TextValue;
par[8] = new SqlParameter("@rsh28", SqlDbType.NText); par[8].Value = RichText28.TextValue;
par[9] = new SqlParameter("@rsh29", SqlDbType.NText); par[9].Value = RichText29.TextValue;
par[10] = new SqlParameter("@rsh30", SqlDbType.NText); par[10].Value = RichText30.TextValue;
par[11] = new SqlParameter("@rsh31", SqlDbType.NVarChar, 50); par[11].Value = "";
cResearch crh = new cResearch();
int grshid = -10;
try
{
val = crh.ModiResearch(InsertCommand, par);
//插入成功之后要取出刚刚插入的ccid
grshid = crh.Getrshid(idrugid.ToString().Trim());
hid_rsid.Value = grshid.ToString().Trim();
}
catch
{ }
return(val);
}
protected void DataBindText(string drugid)
{
cResearch crh = new cResearch();
try
{
DataTable dt = crh.GetResearchDatatable(drugid);
if (dt.Rows.Count > 0)
{
Session[insertCountN] = "1";
hid_rsid.Value = crh.Getrshid(drugid).ToString().Trim();
RichText21.TextValue = dt.Rows[0]["rsh21"].ToString().Trim();
RichText22.TextValue = dt.Rows[0]["rsh22"].ToString().Trim();
RichText24.TextValue = dt.Rows[0]["rsh24"].ToString().Trim();
RichText25.TextValue = dt.Rows[0]["rsh25"].ToString().Trim();
RichText26.TextValue = dt.Rows[0]["rsh26"].ToString().Trim();
RichText27.TextValue = dt.Rows[0]["rsh27"].ToString().Trim();
RichText28.TextValue = dt.Rows[0]["rsh28"].ToString().Trim();
RichText29.TextValue = dt.Rows[0]["rsh29"].ToString().Trim();
RichText30.TextValue = dt.Rows[0]["rsh30"].ToString().Trim();
}
else
{
Session[insertCountN] = "0";
RichText21.TextValue = "";
RichText22.TextValue = "";
RichText24.TextValue = "";
RichText25.TextValue = "";
RichText26.TextValue = "";
RichText27.TextValue = "";
RichText28.TextValue = "";
RichText29.TextValue = "";
RichText30.TextValue = "";
}
}
catch
{ }
}
protected int ExcuteUpdate(int keyid)
{
int val = -10;
string UpdateCommand = "UPDATE [Research] SET [rsh21] = @rsh21, [rsh22] = @rsh22, [rsh23] = @rsh23, [rsh24] = @rsh24, [rsh25] = @rsh25, [rsh26] = @rsh26, [rsh27] = @rsh27, [rsh28] = @rsh28, [rsh29] = @rsh29, [rsh30] = @rsh30, [rsh31] = @rsh31 WHERE [rshid] = @rshid";
SqlParameter[] par = new SqlParameter[12];
if (Session["drugid"] == null)
{
Response.Redirect("../Admin/AdWeb/APassport.aspx");
return(0);
}
par[0] = new SqlParameter("@rshid", SqlDbType.Int); par[0].Value = keyid;
par[1] = new SqlParameter("@rsh21", SqlDbType.NText); par[1].Value = RichText21.TextValue;
par[2] = new SqlParameter("@rsh22", SqlDbType.NText); par[2].Value = RichText22.TextValue;
par[3] = new SqlParameter("@rsh23", SqlDbType.NVarChar, 50); par[3].Value = "";
par[4] = new SqlParameter("@rsh24", SqlDbType.NText); par[4].Value = RichText24.TextValue;
par[5] = new SqlParameter("@rsh25", SqlDbType.NText); par[5].Value = RichText25.TextValue;
par[6] = new SqlParameter("@rsh26", SqlDbType.NText); par[6].Value = RichText26.TextValue;
par[7] = new SqlParameter("@rsh27", SqlDbType.NText); par[7].Value = RichText27.TextValue;
par[8] = new SqlParameter("@rsh28", SqlDbType.NText); par[8].Value = RichText28.TextValue;
par[9] = new SqlParameter("@rsh29", SqlDbType.NText); par[9].Value = RichText29.TextValue;
par[10] = new SqlParameter("@rsh30", SqlDbType.NText); par[10].Value = RichText30.TextValue;
par[11] = new SqlParameter("@rsh31", SqlDbType.NVarChar, 50); par[11].Value = "";
cResearch crh = new cResearch();
try
{
val = crh.ModiResearch(UpdateCommand, par);
}
catch
{ }
return(val);
}
