更新存储过程

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