protected int ExcuteInsert()
{
int val = -10;
string InsertCommand = "INSERT INTO [Share] ([drugid], [ishareway], [iobtainway], [man], [depart], [mcode], [tel], [email], [Sharebak1], [Sharebak2]) VALUES (@drugid, @ishareway, @iobtainway, @man, @depart, @mcode, @tel, @email, @Sharebak1, @Sharebak2)";
SqlParameter[] par = new SqlParameter[10];
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;
string shareWay = "";
foreach (ListItem li in CheckBoxList1.Items)
{
if (li.Selected)
{
shareWay += li.Value + ",";
}
}
if (shareWay.Length > 0)
{
shareWay = shareWay.Substring(0, shareWay.Length - 1);
}
par[1] = new SqlParameter("@ishareway", SqlDbType.NVarChar, 40); par[1].Value = shareWay;
par[2] = new SqlParameter("@iobtainway", SqlDbType.NVarChar, 40); par[2].Value = RadioButtonList1.SelectedIndex == 3 ? RadioButtonList1.SelectedItem.Value + ":" + txt_73.Text.ToString() : RadioButtonList1.SelectedItem.Value;
par[3] = new SqlParameter("@man", SqlDbType.NVarChar, 40); par[3].Value = TextBox1.Text.ToString().Trim();
par[4] = new SqlParameter("@depart", SqlDbType.NVarChar, 40); par[4].Value = TextBox2.Text.ToString().Trim();
par[5] = new SqlParameter("@mcode", SqlDbType.NVarChar, 40); par[5].Value = TextBox3.Text.ToString().Trim();
par[6] = new SqlParameter("@tel", SqlDbType.NVarChar, 40); par[6].Value = TextBox4.Text.ToString().Trim();
par[7] = new SqlParameter("@email", SqlDbType.NVarChar, 40); par[7].Value = TextBox5.Text.ToString().Trim();
par[8] = new SqlParameter("@Sharebak1", SqlDbType.NVarChar, 100); par[8].Value = "";
par[9] = new SqlParameter("@Sharebak2", SqlDbType.NVarChar, 40); par[9].Value = "";
cShared cshar = new cShared();
int gshareid = -10;
try
{
val = cshar.ModiShared(InsertCommand, par);
gshareid = cshar.GetShareid(idrugid.ToString());
hid_shareid.Value = gshareid.ToString();
}
catch
{ }
return(val);
}
protected void DataBindText(string drugid)
{
cShared cshare = new cShared();
try
{
DataTable dt = cshare.GetShareTable(drugid);
if (dt.Rows.Count > 0)
{
Session[insertCountN] = 1;
hid_drugid.Value = drugid;
hid_shareid.Value = dt.Rows[0]["shid"].ToString().Trim();
string shareway = dt.Rows[0]["ishareway"].ToString().Trim();
string[] sway = shareway.Split(new Char[] { ',' });
for (int i = 0; i < sway.Length; i++)
{
try
{
int iselect = Convert.ToInt32(sway[i]);
CheckBoxList1.Items[iselect - 1].Selected = true;
}
catch
{ }
}
string rbtlist = dt.Rows[0]["iobtainway"].ToString().Trim();
RadioButtonList1.SelectedIndex = charTodiStr(rbtlist, ref txt_73);
TextBox1.Text = dt.Rows[0]["man"].ToString().Trim();
TextBox2.Text = dt.Rows[0]["depart"].ToString().Trim();
TextBox3.Text = dt.Rows[0]["mcode"].ToString().Trim();
TextBox4.Text = dt.Rows[0]["tel"].ToString().Trim();
TextBox5.Text = dt.Rows[0]["email"].ToString().Trim();
}
}
catch
{ }
}
