using DIXWeb.Business.Common;
|
using DIXWeb.Entity.GlobalM;
|
using DIXWeb.Util;
|
using System.Linq;
|
using System;
|
using DIXWeb.Entity.Power;
|
using DIXWeb.DataRepository;
|
using DIXWeb.DAL;
|
using DIXWeb.Entity.EasyUI;
|
|
namespace DIXWeb.Business.GlobalM
|
{
|
public class HomeBusiness:BaseBusiness<UserInfo>
|
{
|
/// <summary>
|
///
|
/// </summary>
|
/// <param name="UserNo"></param>
|
/// <param name="password"></param>
|
/// <returns></returns>
|
public ResultMessage SubmitLogin(string UserNo, string password)
|
{
|
try {
|
if (UserNo.IsNullOrEmpty() || password.IsNullOrEmpty())
|
return Error("账号或密码不能为空!");
|
password = password.ToMD5String();
|
var theUser = GetIQueryable().Where(x => x.UserNo == UserNo && x.Password == password).FirstOrDefault();
|
if (theUser != null)
|
{
|
Operator.Login(theUser.UserNo);
|
return Success();
|
}
|
else
|
return Error("账号或密码不正确!");
|
}
|
catch (Exception er) {
|
return Error("错误,"+er.Message);
|
}
|
|
}
|
|
|
public RSP SonyUserUpload(string UserNo, string password)
|
{
|
RSP r = null;
|
using (DBContext db = new DBContext())
|
{
|
string psdTemp = MD5Security.MD5Encrypt32(password);
|
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);
|
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;
|
}
|
|
|
|
}
|
}
|
|
/*
|
|
ALTER procedure[dbo].[p_SonyUserUpload]
|
(
|
@UserCode varchar(32),
|
@Password varchar(64)
|
)as begin
|
declare
|
|
@rCode int = 200,
|
@rMessage varchar(512)
|
|
|
declare @Id int=-4
|
select @Id = Id from UserInfo with(nolock) where UserNo = @UserCode
|
|
|
begin try
|
if @Id = -4 begin
|
insert into UserInfo(UserNo, UserName, Tel, Email, [Address], IdCard, MobilePhone, BirthDay, Sex, IsEnable, CreateTime, [Password])
|
|
values(@UserCode,'游客','','','中国','','','1900-01-01',1,1, GETDATE(), @Password)
|
|
end else begin
|
update UserInfo set[Password] = @Password where Id = @Id
|
|
end
|
end try
|
begin catch
|
set @rCode = 500
|
|
set @rMessage = ERROR_MESSAGE()
|
|
end catch
|
select
|
|
@rCode as 'Code',
|
@rMessage as 'Message'
|
end
|
|
/*
|
use Organize
|
go
|
|
declare
|
@UserCode varchar(32)='5105244240',
|
@Password varchar(64)='d277df6403346075b550f4b37742917a'
|
exec p_SonyUserUpload @UserCode,@Password
|
|
|
|
*/
|