protected void btnXpathUpdae_Click(object sender, EventArgs e) { try { CnDataAcess.Entity.CnInterfaceVideoXpath cnXpath = new CnDataAcess.Entity.CnInterfaceVideoXpath(); cnXpath.CnWebName = Request["web"].ToString().Trim(); cnXpath.CnWebUrl = txtWebAddress.Text.Trim(); cnXpath.CnWebEncode = txtWebEncode.Text.Trim(); cnXpath.CnVideoTitle001 = txtTitle001.Text.Trim(); cnXpath.CnVideoHref001 = txtHref001.Text.Trim(); cnXpath.CnVideoSrc001 = txtSrc001.Text.Trim(); cnXpath.CnVideoTitle002 = txtTitle002.Text.Trim(); cnXpath.CnVideoHref002 = txtHref002.Text.Trim(); cnXpath.CnVideoSrc002 = txtSrc002.Text.Trim(); cnXpath.CnVideoTitle003 = txtTitle003.Text.Trim(); cnXpath.CnVideoHref003 = txtHref003.Text.Trim(); cnXpath.CnVideoSrc003 = txtSrc003.Text.Trim(); cnXpath.CnVideoTitle004 = txtTitle004.Text.Trim(); cnXpath.CnVideoHref004 = txtHref004.Text.Trim(); cnXpath.CnVideoSrc004 = txtSrc004.Text.Trim(); cnXpath.CnVideoTitle005 = txtTitle005.Text.Trim(); cnXpath.CnVideoHref005 = txtHref005.Text.Trim(); cnXpath.CnVideoSrc005 = txtSrc005.Text.Trim(); cnXpath.CnVideoTitle006 = txtTitle006.Text.Trim(); cnXpath.CnVideoHref006 = txtHref006.Text.Trim(); cnXpath.CnVideoSrc006 = txtSrc006.Text.Trim(); int resultCount = 0; resultCount = CnBusinessLogic.CnInterfaceVideoXpath.UpdateCnInterfaceVideo(cnXpath); if (resultCount > 0) { Response.Redirect("ParseXPathManage.aspx?update=ok&web="+Request["web"].ToString().Trim()); } else { labUpdateResult.Text = "<font color='red'><b>数据库更新失败!</b></font>"; } } catch (Exception ex) { labUpdateResult.Text = "<font color='red'><b>数据库更新失败!</b></font><font color='#666699'>" + ex.Message + "</font>"; } }
public CnDataAcess.Entity.CnInterfaceVideoXpath GetVideoXpathByWebName(string webname) { string sql = @"SELECT * FROM [Cn_InterfaceVideoXpath] WHERE [CnWebName] = @CnWebName"; CnDataAcess.Entity.CnInterfaceVideoXpath cnXpath = null; string conStr = System.Configuration.ConfigurationSettings.AppSettings["ConnectionStr"].ToString(); using (SqlConnection conn = new SqlConnection(conStr)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = sql; cmd.Parameters.AddWithValue("@CnWebName", webname); SqlDataReader sdr = cmd.ExecuteReader(); if (sdr.Read()) { cnXpath = new CnDataAcess.Entity.CnInterfaceVideoXpath(); cnXpath.CnWebName = sdr["CnWebName"] as string; cnXpath.CnWebUrl = sdr["CnWebUrl"] as string; cnXpath.CnWebEncode = sdr["CnWebEncode"] as string; cnXpath.CnVideoTitle001 = sdr["CnVideoTitle001"] as string; cnXpath.CnVideoHref001 = sdr["CnVideoHref001"] as string; cnXpath.CnVideoSrc001 = sdr["CnVideoSrc001"] as string; cnXpath.CnVideoTitle002 = sdr["CnVideoTitle002"] as string; cnXpath.CnVideoHref002 = sdr["CnVideoHref002"] as string; cnXpath.CnVideoSrc002 = sdr["CnVideoSrc002"] as string; cnXpath.CnVideoTitle003 = sdr["CnVideoTitle003"] as string; cnXpath.CnVideoHref003 = sdr["CnVideoHref003"] as string; cnXpath.CnVideoSrc003 = sdr["CnVideoSrc003"] as string; cnXpath.CnVideoTitle004 = sdr["CnVideoTitle004"] as string; cnXpath.CnVideoHref004 = sdr["CnVideoHref004"] as string; cnXpath.CnVideoSrc004 = sdr["CnVideoSrc004"] as string; cnXpath.CnVideoTitle005 = sdr["CnVideoTitle005"] as string; cnXpath.CnVideoHref005 = sdr["CnVideoHref005"] as string; cnXpath.CnVideoSrc005 = sdr["CnVideoSrc005"] as string; cnXpath.CnVideoTitle006 = sdr["CnVideoTitle006"] as string; cnXpath.CnVideoHref006 = sdr["CnVideoHref006"] as string; cnXpath.CnVideoSrc006 = sdr["CnVideoSrc006"] as string; } } return cnXpath; }