2 Star 33 Fork 4

Rambo / online-music

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
singerInfoChange_edit.aspx.cs 4.63 KB
一键复制 编辑 Web IDE 原始数据 按行查看 历史
Rambo 提交于 2017-01-27 16:28 . 项目初始化
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class singerInfoChange_edit : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dataBind();
}
}
protected void btn_Click(object sender, EventArgs e)
{
update_singer();
Response.Redirect("~/singerInfoChange.aspx");
}
public void update_singer()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ToString());
conn.Open();
SqlTransaction myTrans = conn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand();
cmd.Transaction = myTrans;
cmd.Connection = conn;
cmd.CommandText = "select * from [singer] where singerId=@singerId";
cmd.Parameters.Add("@singerId", SqlDbType.NChar).Value = getId().Trim().ToString();
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
string oldsinger = dr.GetString(1).Trim();
dr.Close();
cmd.CommandText = "update [singer] set singer=@singer,sex=@sex,birthday=@birthday,hobby =@hobby where singerId=@singerId";
cmd.Parameters.Add("@singer", SqlDbType.NChar).Value = singer.Text.Trim().ToString();
cmd.Parameters.Add("@sex", SqlDbType.NChar).Value = sex.SelectedValue.Trim().ToString();
cmd.Parameters.Add("@birthday", SqlDbType.NChar).Value = birthday.Text.Trim().ToString();
cmd.Parameters.Add("@hobby", SqlDbType.NChar).Value = hobby.Text.Trim().ToString();
cmd.Parameters.Add("@oldsinger", SqlDbType.NChar).Value = oldsinger;
if (!singer.Text.Trim().ToString().Equals(oldsinger))
{
if (!isExisted(cmd))
{
msg.Text = oldsinger;
cmd.CommandText = "update [singer] set singer=@singer,sex=@sex,birthday=@birthday,hobby =@hobby where singerId=@singerId";
cmd.ExecuteNonQuery();
cmd.CommandText = "update [music] set singer='"+singer.Text.Trim().ToString()+"' where singer=@oldsinger";
cmd.ExecuteNonQuery();
cmd.CommandText = "update [album] set singer='" + singer.Text.Trim().ToString() + "' where singer=@oldsinger";
cmd.ExecuteNonQuery();
}
else
Response.Write("<script>alert('文件名已经存在!')</script>");
}
else
{
cmd.ExecuteNonQuery();
}
myTrans.Commit();
}
catch (Exception ex)
{
msg.Text = ex.ToString();
myTrans.Rollback();
}
finally
{
conn.Close();
}
}
protected Boolean isExisted(SqlCommand cmd)
{
cmd.CommandText = "select * from [singer] where singer=@singer";
SqlDataReader dr = cmd.ExecuteReader();
Boolean check = dr.Read();
dr.Close();
return check;
}
public string getId()
{
string id = HttpContext.Current.Request.Url.PathAndQuery.ToString();
int n = id.LastIndexOf('=');
id = id.Substring(n + 1);
return id;
}
public void dataBind()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ToString());
try
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from [singer] where singerId=@singerId";
cmd.Parameters.Add("@singerId", SqlDbType.NChar).Value = getId();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
singer.Text = dr.GetString(1).Trim();
if (dr.GetString(2).Trim().ToString().Equals("男"))
{
sex.SelectedIndex = 0;
}
else
sex.SelectedIndex = 1;
birthday.Text = dr.GetString(3).Trim().ToString();
hobby.Text = dr.GetString(4).Trim().ToString();
}
dr.Close();
}
catch (Exception ex)
{
msg.Text = ex.ToString();
}
finally
{
conn.Close();
}
}
}
ASP
1
https://gitee.com/LanboEx/online-music.git
git@gitee.com:LanboEx/online-music.git
LanboEx
online-music
online-music
master

搜索帮助

14c37bed 8189591 565d56ea 8189591