set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[UpdateMember]
@code nchar(10),
@name nchar(10),
@password varchar(50),
@pwd2 varchar(50),
@sex nchar(10),
@culture nchar(35),
@mail nchar(20),
@QQ nchar(15),
@skype nchar(20),
@MSN nchar(20),
@handset nchar(20),
@telephone nchar(15),
@remark varchar(200),
@birthday datetime ,
@on_duty datetime,
@photo image,
@imagecontenttype varchar(50),
@incumbency nchar(10),
@ID_Card nchar(25),
@ID_Card_belong varchar(50),
@BankAdr varchar(50),
@BankNam varchar(50),
@homeAddress varchar(50),
@trymoney money,
@try1 datetime,
@try2 datetime,
@money money,
@EnglishName nchar(10),
@EnglishID_Card_belong varchar(50),
@Address varchar(50),
@EnglishBankAdr varchar(50),
@EnglishRemark varchar(50),
@branch varchar(50),
@position varchar(50)
as
begin
if (@imagecontenttype<>'no' or @password<>'no' or @pwd2<>'no')
begin
update Member set code= @code ,
culture=@culture,
[name] =@name ,
password= @password,
pwd2=@pwd2,
sex =@sex ,
mail= @mail,
QQ =@QQ ,
skype =@skype,
MSN= @MSN,
handset= @handset,
telephone=@telephone ,
remark =@remark ,
birthday=@birthday ,
on_duty= @on_duty,
photo= @photo,
imagecontenttype=@imagecontenttype ,
incumbency =@incumbency,
ID_Card =@ID_Card,
ID_Card_belong =@ID_Card_belong,
BankAdr =@BankAdr,
BankNam=@BankNam,
homeAddress=@homeAddress,
trymoney=@trymoney,
try1=@try1 ,
try2=@try2,
[money]=@money,
EnglishName=@EnglishName,
EnglishID_Card_belong=@EnglishID_Card_belong ,
Address=@Address,
EnglishBankAdr=@EnglishBankAdr,
EnglishRemark=@EnglishRemark ,
branch=@branch,
position=@position
where code=@code
end
if( @imagecontenttype='no' or @password='no' or @pwd2='no')
begin
update Member set code= @code ,
culture=@culture,
[name] =@name ,
sex =@sex ,
mail= @mail,
QQ =@QQ ,
skype =@skype,
MSN= @MSN,
handset= @handset,
telephone=@telephone ,
remark =@remark ,
birthday=@birthday ,
on_duty= @on_duty,
incumbency =@incumbency,
ID_Card =@ID_Card,
ID_Card_belong =@ID_Card_belong,
BankAdr =@BankAdr,
BankNam=@BankNam,
homeAddress=@homeAddress,
trymoney=@trymoney,
try1=@try1 ,
try2=@try2,
[money]=@money,
EnglishName=@EnglishName,
EnglishID_Card_belong=@EnglishID_Card_belong ,
Address=@Address,
EnglishBankAdr=@EnglishBankAdr,
EnglishRemark=@EnglishRemark ,
branch=@branch,
position=@position
where code=@code
end
end
连接数据库odblink.cs
using System;
using System.Data;
using System.Configuration;
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;
/// <summary>
/// OdbLink 的摘要说明
/// </summary>
namespace ODB
{
public class OdbLink
{
public string aa()
{
// return "Data Source=TALENT-JYVD7PI7;Initial Catalog=slopwork;Integrated Security=True";
//return "server=211.75.173.53;uid=sa;pwd=lanhei2005;database=slopwork;min pool size=1;max pool size=100";
return System.Configuration.ConfigurationManager.ConnectionStrings["slopworkConnectionString"].ConnectionString;
}
}
}
方法Login.cs
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
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 ODB;
namespace ODB
{
/// <summary>
/// Login 的摘要说明
/// </summary>
public class Login
{
#region 加密
/// <summary>
/// MD5加密
/// </summary>
/// <param name="InputString">要加密的字串</param>
/// <returns>密文</returns>
public string Md5hash_String(string InputString)
{
InputString = Md5hash_String(InputString, "MD5");
return InputString;
}
/// <summary>
/// SHA1,MD5加密
/// </summary>
/// <param name="s">要加密的字符串</param>
/// <param name="format">加密格式 MD5 或 SHA1</param>
/// <returns>返回加密后的字串</returns>
public static string Md5hash_String(string InputString, string format)
{
if (format == "SHA1")
{
InputString = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(InputString, "SHA1");
}
else if (format == "MD5")
{
InputString = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(InputString, "MD5");
}
return InputString;
}
#endregion
}
}
后台代码
更新图片
void UpdateTisserOrder()
{
OdbLink str = new OdbLink();
SqlConnection Conn = new SqlConnection(str.aa().ToString());
Conn.Open();
SqlCommand com = new SqlCommand("UpdateMember", Conn);
更新图片
HttpPostedFile UpFile = File1.PostedFile; //HttpPostedFile对象,用于读取图象文件属性
FileLength = UpFile.ContentLength; //记录文件长度
Byte[] FileByteArray = new Byte[FileLength]; //图象文件临时储存Byte数组
Stream StreamObject = UpFile.InputStream; //建立数据流对像
//读取图象文件数据,FileByteArray为数据储存体,0为数据指针位置、FileLnegth为数据长度
StreamObject.Read(FileByteArray, 0, FileLength);
com.Parameters.Add(new SqlParameter("@photo", SqlDbType.Image));//图片
com.Parameters["@photo"].Value = FileByteArray;
com.Parameters.Add(new SqlParameter("@imagecontenttype", SqlDbType.VarChar));//图片格式
if(UpFile.ContentType!="application/octet-stream")
com.Parameters["@imagecontenttype"].Value = UpFile.ContentType;
else
com.Parameters["@imagecontenttype"].Value = "no";
更新密码
com.Parameters.Add(new SqlParameter("@password", SqlDbType.VarChar));//密码
ODB.Login pass = new ODB.Login();// 链接数据库语句
string pwdsss = pass.Md5hash_String(pwd1.Text.Trim());
if (pwd1.Text != "")
{
com.Parameters["@password"].Value = pwdsss;
}
else
{
com.Parameters["@password"].Value = "no";
}
com.Parameters.Add(new SqlParameter("@pwd2", SqlDbType.VarChar));//确认密码
if (pwd2.Text != "")
{
com.Parameters["@pwd2"].Value =pwdsss;
}
else
{
com.Parameters["@pwd2"].Value = "no";
}
com.CommandType = CommandType.StoredProcedure;//执行存储过程
if (Conn.State.ToString()=="Closed")
{
Conn.Open();
}
com.ExecuteNonQuery();
Conn.Close();
return ;
}
#endregion
#region 查看
void reading()
{
OdbLink str = new OdbLink();
Conn = new SqlConnection(str.aa().ToString());
//if (Conn.State.ToString() == "Closed")
//{
Conn.Open();
//}
com = new SqlCommand("select * from Member where code='" + code1 + "'", Conn);
SqlDataReader sdr = com.ExecuteReader();
while (sdr.Read())
{ //Member员工信息表
code.Text = sdr["code"].ToString().Trim();
pwd1.Text = sdr["password"].ToString().Trim();
born.Text = Convert.ToDateTime(sdr["birthday"].ToString().Trim()).ToShortDateString();
photoimage.ImageUrl = "../manufacturer/showImage.aspx?ImgID=" + sdr["id"].ToString().Trim() + "&type=man";
RadioButtonList1.Text = sdr["incumbency"].ToString().Trim();
}
Conn.Close();
}
#endregion