| | |
|---|
| | | System.Data.SqlClient.SqlParameter[] paramList = new System.Data.SqlClient.SqlParameter[2]; |
|---|
| | | paramList[0] = new System.Data.SqlClient.SqlParameter("@UserCode", UserNo); |
|---|
| | | paramList[1] = new System.Data.SqlClient.SqlParameter("@Password", psdTemp); |
|---|
| | | r = db.Database.SqlQuery<RSP>("EXEC dbo.p_SonyUserUpload @UserCode,@Password ", paramList).FirstOrDefault(); |
|---|
| | | paramList[1] = new System.Data.SqlClient.SqlParameter("@PasswordStr", password); |
|---|
| | | r = db.Database.SqlQuery<RSP>("EXEC dbo.p_SonyUserUpload @UserCode,@Password,@PasswordStr ", paramList).FirstOrDefault(); |
|---|
| | | } |
|---|
| | | return r; |
|---|
| | | } |
|---|
