protected int ExcuteUpdate(int hdid) { int val = -10; string UpdateCommand = "UPDATE [Heredity] SET [drugid] = @drugid, [hdt41] = @hdt41, [hdt42] = @hdt42, [hdt43] = @hdt43, [hdt44] = @hdt44, [hdt45] = @hdt45, [hdt46] = @hdt46, [hdt47] = @hdt47, [hdt48] = @hdt48, [hdt49] = @hdt49, [hdt50] = @hdt50, [hdt51] = @hdt51, [hdt52] = @hdt52, [hdt53] = @hdt53, [hdt54] = @hdt54, [hdt55] = @hdt55, [hdt56] = @hdt56, [hdt57] = @hdt57, [hdt58] = @hdt58, [hdt59] = @hdt59, [hdt60] = @hdt60, [hdt61] = @hdt61, [htd62] = @htd62, [htd63] = @htd63, [htd64] = @htd64, [htd65] = @htd65, [htd66] = @htd66, [htd67] = @htd67 WHERE [hdid] = @hdid"; SqlParameter[] par = new SqlParameter[29]; if (Session["drugid"] == null) { Response.Redirect("../Admin/AdWeb/APassport.aspx"); return(0); } if (rbtn_41.SelectedIndex == 0) { #region 插入数据 par[0] = new SqlParameter("@drugid", SqlDbType.Int); par[0].Value = Convert.ToInt32(hid_drugid.Value); par[1] = new SqlParameter("@hdt41", SqlDbType.NVarChar, 10); par[1].Value = rbtn_41.SelectedItem.Value; par[2] = new SqlParameter("@hdt42", SqlDbType.NVarChar, 40); par[2].Value = CharText1.TextValue; par[3] = new SqlParameter("@hdt43", SqlDbType.NVarChar, 50); par[3].Value = rbtn_43.SelectedItem.Value; par[4] = new SqlParameter("@hdt44", SqlDbType.NVarChar, 50); par[4].Value = rbtn_44.SelectedIndex == 4 ? rbtn_44.SelectedItem.Value + ":" + txt_44.Text.ToString().Trim() : rbtn_44.SelectedItem.Value; par[5] = new SqlParameter("@hdt45", SqlDbType.NVarChar, 50); par[5].Value = CharText2.TextValue; par[6] = new SqlParameter("@hdt46", SqlDbType.NVarChar, 50); par[6].Value = CharText3.TextValue; par[7] = new SqlParameter("@hdt47", SqlDbType.Date); par[7].Value = IsDate(txt_date1.Text.ToString().Trim()); par[8] = new SqlParameter("@hdt48", SqlDbType.NVarChar, 50); par[8].Value = CharText5.TextValue; par[9] = new SqlParameter("@hdt49", SqlDbType.Int); par[9].Value = isInt(CharText6.TextValue); par[10] = new SqlParameter("@hdt50", SqlDbType.NVarChar, 100); par[10].Value = CharText7.TextValue; par[11] = new SqlParameter("@hdt51", SqlDbType.NVarChar, 50); par[11].Value = CharText8.TextValue; par[12] = new SqlParameter("@hdt52", SqlDbType.NVarChar, 50); par[12].Value = CharText9.TextValue; par[13] = new SqlParameter("@hdt53", SqlDbType.NVarChar, 50); par[13].Value = CharText10.TextValue; par[14] = new SqlParameter("@hdt54", SqlDbType.Float); par[14].Value = IsFloat(CharText11.TextValue.ToString().Trim()); par[15] = new SqlParameter("@hdt55", SqlDbType.NVarChar, 50); par[15].Value = CharText12.TextValue; par[16] = new SqlParameter("@hdt56", SqlDbType.Date); par[16].Value = IsDate(txt_date2.Text.ToString().Trim()); par[17] = new SqlParameter("@hdt57", SqlDbType.NVarChar, 50); par[17].Value = rbtn_57.SelectedItem.Value; par[18] = new SqlParameter("@hdt58", SqlDbType.NVarChar, 50); par[18].Value = rbtn_58.SelectedItem.Value; par[19] = new SqlParameter("@hdt59", SqlDbType.NVarChar, 50); par[19].Value = CharText14.TextValue; par[20] = new SqlParameter("@hdt60", SqlDbType.NVarChar, 50); par[20].Value = rbtn_60.SelectedItem.Value; par[21] = new SqlParameter("@hdt61", SqlDbType.NVarChar, 50); par[21].Value = rbtn_61.SelectedIndex == 5 ? rbtn_61.SelectedItem.Value + ":" + txt_61.Text.ToString().Trim() : rbtn_61.SelectedItem.Value; par[22] = new SqlParameter("@htd62", SqlDbType.NVarChar, 50); par[22].Value = rbtn_62.SelectedIndex == 6 ? rbtn_62.SelectedItem.Value + ":" + txt_62.Text.ToString().Trim() : rbtn_62.SelectedItem.Value; par[23] = new SqlParameter("@htd63", SqlDbType.NVarChar, 50); par[23].Value = rbtn_63.SelectedIndex == 4 ? rbtn_63.SelectedItem.Value + ":" + txt_63.Text.ToString().Trim() : rbtn_63.SelectedItem.Value; par[24] = new SqlParameter("@htd64", SqlDbType.NVarChar, 50); par[24].Value = rbtn_64.SelectedIndex == 5 ? rbtn_64.SelectedItem.Value + ":" + txt_64.Text.ToString().Trim() : rbtn_64.SelectedItem.Value; par[25] = new SqlParameter("@htd65", SqlDbType.NVarChar, 50); par[25].Value = rbtn_65.SelectedItem.Value; par[26] = new SqlParameter("@htd66", SqlDbType.NVarChar, 80); par[26].Value = CharText15.TextValue; par[27] = new SqlParameter("@htd67", SqlDbType.NVarChar, 50); par[27].Value = rbtn_67.SelectedItem.Value; par[28] = new SqlParameter("@hdid", SqlDbType.Int); par[28].Value = hdid; #endregion } else { //把参数全都设置为空 #region 给参数提供数字 par[0] = new SqlParameter("@drugid", SqlDbType.Int); par[0].Value = Convert.ToInt32(hid_drugid.Value); par[1] = new SqlParameter("@hdt41", SqlDbType.NVarChar, 10); par[1].Value = rbtn_41.SelectedItem.Value; par[2] = new SqlParameter("@hdt42", SqlDbType.NVarChar, 40); par[2].Value = ""; par[3] = new SqlParameter("@hdt43", SqlDbType.NVarChar, 50); par[3].Value = ""; par[4] = new SqlParameter("@hdt44", SqlDbType.NVarChar, 50); par[4].Value = ""; par[5] = new SqlParameter("@hdt45", SqlDbType.NVarChar, 50); par[5].Value = ""; par[6] = new SqlParameter("@hdt46", SqlDbType.NVarChar, 50); par[6].Value = ""; par[7] = new SqlParameter("@hdt47", SqlDbType.Date); par[7].Value = DateTime.Now.ToShortDateString(); par[8] = new SqlParameter("@hdt48", SqlDbType.NVarChar, 50); par[8].Value = ""; par[9] = new SqlParameter("@hdt49", SqlDbType.Int); par[9].Value = 0; par[10] = new SqlParameter("@hdt50", SqlDbType.NVarChar, 100); par[10].Value = ""; par[11] = new SqlParameter("@hdt51", SqlDbType.NVarChar, 50); par[11].Value = ""; par[12] = new SqlParameter("@hdt52", SqlDbType.NVarChar, 50); par[12].Value = ""; par[13] = new SqlParameter("@hdt53", SqlDbType.NVarChar, 50); par[13].Value = ""; par[14] = new SqlParameter("@hdt54", SqlDbType.Float); par[14].Value = 0; par[15] = new SqlParameter("@hdt55", SqlDbType.NVarChar, 50); par[15].Value = ""; par[16] = new SqlParameter("@hdt56", SqlDbType.Date); par[16].Value = DateTime.Now.ToShortDateString(); par[17] = new SqlParameter("@hdt57", SqlDbType.NVarChar, 50); par[17].Value = ""; par[18] = new SqlParameter("@hdt58", SqlDbType.NVarChar, 50); par[18].Value = ""; par[19] = new SqlParameter("@hdt59", SqlDbType.NVarChar, 50); par[19].Value = ""; par[20] = new SqlParameter("@hdt60", SqlDbType.NVarChar, 50); par[20].Value = ""; par[21] = new SqlParameter("@hdt61", SqlDbType.NVarChar, 50); par[21].Value = ""; par[22] = new SqlParameter("@htd62", SqlDbType.NVarChar, 50); par[22].Value = ""; par[23] = new SqlParameter("@htd63", SqlDbType.NVarChar, 50); par[23].Value = ""; par[24] = new SqlParameter("@htd64", SqlDbType.NVarChar, 50); par[24].Value = ""; par[25] = new SqlParameter("@htd65", SqlDbType.NVarChar, 50); par[25].Value = ""; par[26] = new SqlParameter("@htd66", SqlDbType.NVarChar, 80); par[26].Value = ""; par[27] = new SqlParameter("@htd67", SqlDbType.NVarChar, 50); par[27].Value = ""; par[28] = new SqlParameter("@hdid", SqlDbType.Int); par[28].Value = hdid; #endregion } cHeredity chd = new cHeredity(); try { val = chd.ModiHeredity(UpdateCommand, par); } catch { } return(val); }
protected void DataBindText(string drugid) { cHeredity chd = new cHeredity(); try { DataTable dt = chd.GetHdTable(drugid); if (dt.Rows.Count > 0) { Session[insertCountN] = 1; hid_drugid.Value = drugid; hid_hdid.Value = dt.Rows[0]["hdid"].ToString().Trim(); // 41 string shdt41 = dt.Rows[0]["hdt41"].ToString().Trim(); rbtn_41.SelectedIndex = charTodi(shdt41); //42 CharText1.TextValue = dt.Rows[0]["hdt42"].ToString().Trim(); //43 string shdt43 = dt.Rows[0]["hdt43"].ToString().Trim(); rbtn_43.SelectedIndex = charTodi(shdt43); //44 string shdt44 = dt.Rows[0]["hdt44"].ToString().Trim(); rbtn_44.SelectedIndex = charTodiStr(shdt44, ref txt_44); //45 CharText2.TextValue = dt.Rows[0]["hdt45"].ToString().Trim(); //46 CharText3.TextValue = dt.Rows[0]["hdt46"].ToString().Trim(); //47采集时间toShortDate txt_date1.Text = toShortDate(dt.Rows[0]["hdt47"].ToString().Trim()); //48 CharText5.TextValue = dt.Rows[0]["hdt48"].ToString().Trim(); //49 CharText6.TextValue = dt.Rows[0]["hdt49"].ToString().Trim(); //50 CharText7.TextValue = dt.Rows[0]["hdt50"].ToString().Trim(); //51 CharText8.TextValue = dt.Rows[0]["hdt51"].ToString().Trim(); //52 CharText9.TextValue = dt.Rows[0]["hdt52"].ToString().Trim(); //53 CharText10.TextValue = dt.Rows[0]["hdt53"].ToString().Trim(); //54 CharText11.TextValue = dt.Rows[0]["hdt54"].ToString().Trim(); //55 CharText12.TextValue = dt.Rows[0]["hdt55"].ToString().Trim(); //56 鉴定时间 txt_date2.Text = toShortDate(dt.Rows[0]["hdt56"].ToString().Trim()); //57 string shdt57 = dt.Rows[0]["hdt57"].ToString().Trim(); rbtn_57.SelectedIndex = charTodi(shdt57); //58 string shdt58 = dt.Rows[0]["hdt58"].ToString().Trim(); rbtn_58.SelectedIndex = charTodi(shdt58); //59 CharText14.TextValue = dt.Rows[0]["hdt59"].ToString().Trim(); //60 string shdt60 = dt.Rows[0]["hdt60"].ToString().Trim(); rbtn_60.SelectedIndex = charTodi(shdt60); //61 string shdt61 = dt.Rows[0]["hdt61"].ToString().Trim(); rbtn_61.SelectedIndex = charTodiStr(shdt61, ref txt_61); //62 string shdt62 = dt.Rows[0]["htd62"].ToString().Trim(); rbtn_62.SelectedIndex = charTodiStr(shdt62, ref txt_62); //63 string shdt63 = dt.Rows[0]["htd63"].ToString().Trim(); rbtn_63.SelectedIndex = charTodiStr(shdt63, ref txt_63); //64 string shdt64 = dt.Rows[0]["htd64"].ToString().Trim(); rbtn_64.SelectedIndex = charTodiStr(shdt64, ref txt_64); //65 string shdt65 = dt.Rows[0]["htd65"].ToString().Trim(); rbtn_65.SelectedIndex = charTodi(shdt65); //66 CharText15.TextValue = dt.Rows[0]["htd66"].ToString().Trim(); //67 string shdt67 = dt.Rows[0]["htd67"].ToString().Trim(); rbtn_67.SelectedIndex = charTodi(shdt67); } } catch { } }
protected int ExcuteInsert() { int val = -10; string InsertCommand = "INSERT INTO [Heredity] ([drugid], [hdt41], [hdt42], [hdt43], [hdt44], [hdt45], [hdt46], [hdt47], [hdt48], [hdt49], [hdt50], [hdt51], [hdt52], [hdt53], [hdt54], [hdt55], [hdt56], [hdt57], [hdt58], [hdt59], [hdt60], [hdt61], [htd62], [htd63], [htd64], [htd65], [htd66], [htd67]) VALUES (@drugid, @hdt41, @hdt42, @hdt43, @hdt44, @hdt45, @hdt46, @hdt47, @hdt48, @hdt49, @hdt50, @hdt51, @hdt52, @hdt53, @hdt54, @hdt55, @hdt56, @hdt57, @hdt58, @hdt59, @hdt60, @hdt61, @htd62, @htd63, @htd64, @htd65, @htd66, @htd67)"; SqlParameter[] par = new SqlParameter[28]; 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"); } if (rbtn_41.SelectedIndex == 0) { #region 给参数提供数字 par[0] = new SqlParameter("@drugid", SqlDbType.Int); par[0].Value = idrugid; par[1] = new SqlParameter("@hdt41", SqlDbType.NVarChar, 10); par[1].Value = rbtn_41.SelectedItem.Value; par[2] = new SqlParameter("@hdt42", SqlDbType.NVarChar, 40); par[2].Value = CharText1.TextValue; par[3] = new SqlParameter("@hdt43", SqlDbType.NVarChar, 50); par[3].Value = rbtn_43.SelectedItem.Value; par[4] = new SqlParameter("@hdt44", SqlDbType.NVarChar, 50); par[4].Value = rbtn_44.SelectedIndex == 4 ? rbtn_44.SelectedItem.Value + ":" + txt_44.Text.ToString().Trim() : rbtn_44.SelectedItem.Value; par[5] = new SqlParameter("@hdt45", SqlDbType.NVarChar, 50); par[5].Value = CharText2.TextValue; par[6] = new SqlParameter("@hdt46", SqlDbType.NVarChar, 50); par[6].Value = CharText3.TextValue; par[7] = new SqlParameter("@hdt47", SqlDbType.Date); par[7].Value = IsDate(txt_date1.Text.ToString().Trim()); par[8] = new SqlParameter("@hdt48", SqlDbType.NVarChar, 50); par[8].Value = CharText5.TextValue; par[9] = new SqlParameter("@hdt49", SqlDbType.Int); par[9].Value = isInt(CharText6.TextValue); par[10] = new SqlParameter("@hdt50", SqlDbType.NVarChar, 100); par[10].Value = CharText7.TextValue; par[11] = new SqlParameter("@hdt51", SqlDbType.NVarChar, 50); par[11].Value = CharText8.TextValue; par[12] = new SqlParameter("@hdt52", SqlDbType.NVarChar, 50); par[12].Value = CharText9.TextValue; par[13] = new SqlParameter("@hdt53", SqlDbType.NVarChar, 50); par[13].Value = CharText10.TextValue; par[14] = new SqlParameter("@hdt54", SqlDbType.Float); par[14].Value = IsFloat(CharText11.TextValue.ToString().Trim()); par[15] = new SqlParameter("@hdt55", SqlDbType.NVarChar, 50); par[15].Value = CharText12.TextValue; par[16] = new SqlParameter("@hdt56", SqlDbType.Date); par[16].Value = IsDate(txt_date2.Text.ToString().Trim()); par[17] = new SqlParameter("@hdt57", SqlDbType.NVarChar, 50); par[17].Value = rbtn_57.SelectedItem.Value; par[18] = new SqlParameter("@hdt58", SqlDbType.NVarChar, 50); par[18].Value = rbtn_58.SelectedItem.Value; par[19] = new SqlParameter("@hdt59", SqlDbType.NVarChar, 50); par[19].Value = CharText14.TextValue; par[20] = new SqlParameter("@hdt60", SqlDbType.NVarChar, 50); par[20].Value = rbtn_60.SelectedItem.Value; par[21] = new SqlParameter("@hdt61", SqlDbType.NVarChar, 50); par[21].Value = rbtn_61.SelectedIndex == 5 ? rbtn_61.SelectedItem.Value + ":" + txt_61.Text.ToString().Trim() : rbtn_61.SelectedItem.Value; par[22] = new SqlParameter("@htd62", SqlDbType.NVarChar, 50); par[22].Value = rbtn_62.SelectedIndex == 6 ? rbtn_62.SelectedItem.Value + ":" + txt_62.Text.ToString().Trim() : rbtn_62.SelectedItem.Value; par[23] = new SqlParameter("@htd63", SqlDbType.NVarChar, 50); par[23].Value = rbtn_63.SelectedIndex == 4 ? rbtn_63.SelectedItem.Value + ":" + txt_63.Text.ToString().Trim() : rbtn_63.SelectedItem.Value; par[24] = new SqlParameter("@htd64", SqlDbType.NVarChar, 50); par[24].Value = rbtn_64.SelectedIndex == 5 ? rbtn_64.SelectedItem.Value + ":" + txt_64.Text.ToString().Trim() : rbtn_64.SelectedItem.Value; par[25] = new SqlParameter("@htd65", SqlDbType.NVarChar, 50); par[25].Value = rbtn_65.SelectedItem.Value; par[26] = new SqlParameter("@htd66", SqlDbType.NVarChar, 80); par[26].Value = CharText15.TextValue; par[27] = new SqlParameter("@htd67", SqlDbType.NVarChar, 50); par[27].Value = rbtn_67.SelectedItem.Value; #endregion } else { //把参数全都设置为空 #region 给参数提供数字 par[0] = new SqlParameter("@drugid", SqlDbType.Int); par[0].Value = idrugid; par[1] = new SqlParameter("@hdt41", SqlDbType.NVarChar, 10); par[1].Value = rbtn_41.SelectedItem.Value; par[2] = new SqlParameter("@hdt42", SqlDbType.NVarChar, 40); par[2].Value = ""; par[3] = new SqlParameter("@hdt43", SqlDbType.NVarChar, 50); par[3].Value = ""; par[4] = new SqlParameter("@hdt44", SqlDbType.NVarChar, 50); par[4].Value = ""; par[5] = new SqlParameter("@hdt45", SqlDbType.NVarChar, 50); par[5].Value = ""; par[6] = new SqlParameter("@hdt46", SqlDbType.NVarChar, 50); par[6].Value = ""; par[7] = new SqlParameter("@hdt47", SqlDbType.Date); par[7].Value = DateTime.Now.ToShortDateString(); par[8] = new SqlParameter("@hdt48", SqlDbType.NVarChar, 50); par[8].Value = ""; par[9] = new SqlParameter("@hdt49", SqlDbType.Int); par[9].Value = 0; par[10] = new SqlParameter("@hdt50", SqlDbType.NVarChar, 100); par[10].Value = ""; par[11] = new SqlParameter("@hdt51", SqlDbType.NVarChar, 50); par[11].Value = ""; par[12] = new SqlParameter("@hdt52", SqlDbType.NVarChar, 50); par[12].Value = ""; par[13] = new SqlParameter("@hdt53", SqlDbType.NVarChar, 50); par[13].Value = ""; par[14] = new SqlParameter("@hdt54", SqlDbType.Float); par[14].Value = 0; par[15] = new SqlParameter("@hdt55", SqlDbType.NVarChar, 50); par[15].Value = ""; par[16] = new SqlParameter("@hdt56", SqlDbType.Date); par[16].Value = DateTime.Now.ToShortDateString(); par[17] = new SqlParameter("@hdt57", SqlDbType.NVarChar, 50); par[17].Value = ""; par[18] = new SqlParameter("@hdt58", SqlDbType.NVarChar, 50); par[18].Value = ""; par[19] = new SqlParameter("@hdt59", SqlDbType.NVarChar, 50); par[19].Value = ""; par[20] = new SqlParameter("@hdt60", SqlDbType.NVarChar, 50); par[20].Value = ""; par[21] = new SqlParameter("@hdt61", SqlDbType.NVarChar, 50); par[21].Value = ""; par[22] = new SqlParameter("@htd62", SqlDbType.NVarChar, 50); par[22].Value = ""; par[23] = new SqlParameter("@htd63", SqlDbType.NVarChar, 50); par[23].Value = ""; par[24] = new SqlParameter("@htd64", SqlDbType.NVarChar, 50); par[24].Value = ""; par[25] = new SqlParameter("@htd65", SqlDbType.NVarChar, 50); par[25].Value = ""; par[26] = new SqlParameter("@htd66", SqlDbType.NVarChar, 80); par[26].Value = ""; par[27] = new SqlParameter("@htd67", SqlDbType.NVarChar, 50); par[27].Value = ""; #endregion } cHeredity chd = new cHeredity(); int ghdid = -10; try { val = chd.ModiHeredity(InsertCommand, par); ghdid = chd.GetHdid(idrugid.ToString()); hid_hdid.Value = ghdid.ToString(); } catch { } return(val); }