public List <Todr1_Rcbp1> LoginCheck(Tms_Login request)
{
List <Todr1_Rcbp1> Result = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("TMS"))
{
string strSql = "";
if (request.DriverCode != null && request.DriverCode.Length > 0)
{
strSql = "Select isnull(DriverCode,'') as DriverCode From Todr1 Where DriverCode='" + request.DriverCode + "' ";
Result = db.Select <Todr1_Rcbp1>(strSql);
}
else if (request.BusinessPartyCode != null && request.BusinessPartyCode.Length > 0 && request.PassWord != null && request.PassWord.Length > 0)
{
strSql = "Select isnull(BusinessPartyCode,'') as BusinessPartyCode ,isnull(PassWord,'') as PassWord From Rcbp1 Where BusinessPartyCode='" + request.BusinessPartyCode + "' And PassWord ='******' ";
Result = db.Select <Todr1_Rcbp1>(strSql);
}
}
}
catch { throw; }
return(Result);
}
public List <Todr1> LoginCheck(Tms_Login request)
{
//int Result = -1; //20160511 注释
//try
//{
// using (var db = DbConnectionFactory.OpenDbConnection("TMS"))
// {
// string strSql = "Select count(*) From Saus1 Where UserId='" + request.UserId + "' And Password="******"'" + request.Password + "'";
// }
// else
// {
// strSql = strSql + "'" + request.Md5Stamp + "'";
// }
// Result = db.Scalar<int>(strSql);
// }
//}
//catch { throw; }
//return Result;
List <Todr1> Result = null; //20160511
try
{
using (var db = DbConnectionFactory.OpenDbConnection("TMS"))
{
//if (request.ContactNo != null && request.ContactNo.Length > 0) ///20160627 update login logic DriverCode
//{
// string strSql = "Select count(*) From Todr1 Where ContactNo1='" + request.ContactNo + "' ";
// Result = db.Scalar<int>(strSql);
// if (Result < 1)
// {
// strSql = "Select count(*) From Todr1 Where ContactNo2='" + request.ContactNo + "' ";
// Result = db.Scalar<int>(strSql);
// BlnContactNo = false;
// }
// else
// {
// BlnContactNo = true;
// }
//}
if (request.DriverCode != null && request.DriverCode.Length > 0)
{
string strSql = "Select isnull(DriverName,'') as DriverName From Todr1 Where DriverCode='" + request.DriverCode + "' ";
Result = db.Select <Todr1>(strSql);
}
}
}
catch { throw; }
return(Result);
}
public int LoginCheck(Tms_Login request)
{
//int Result = -1; //20160511 注释
//try
//{
// using (var db = DbConnectionFactory.OpenDbConnection("TMS"))
// {
// string strSql = "Select count(*) From Saus1 Where UserId='" + request.UserId + "' And Password="******"'" + request.Password + "'";
// }
// else
// {
// strSql = strSql + "'" + request.Md5Stamp + "'";
// }
// Result = db.Scalar<int>(strSql);
// }
//}
//catch { throw; }
//return Result;
int Result = -1; //20160511
try
{
using (var db = DbConnectionFactory.OpenDbConnection("TMS"))
{
if (request.ContactNo != null && request.ContactNo.Length > 0)
{
string strSql = "Select count(*) From Todr1 Where ContactNo1='" + request.ContactNo + "' ";
Result = db.Scalar <int>(strSql);
if (Result < 1)
{
strSql = "Select count(*) From Todr1 Where ContactNo2='" + request.ContactNo + "' ";
Result = db.Scalar <int>(strSql);
BlnContactNo = false;
}
else
{
BlnContactNo = true;
}
}
}
}
catch { throw; }
return(Result);
}
public int LoginCheck(Tms_Login request)
{
int Result = -1;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
{
Result = db.Scalar <int>(
"Select count(*) From Saus1 Where UserId={0} And Password={1}",
request.UserId, request.Password
);
}
}
catch { throw; }
return(Result);
}
public List <Todr1> LoginCheck(Tms_Login request)
{
List <Todr1> Result = null;; //20160511
try
{
using (var db = DbConnectionFactory.OpenDbConnection("TMS"))
{
if (request.DriverCode != null && request.DriverCode.Length > 0)
{
string strSql = "Select isnull(DriverName,'') as DriverName ,isnull(VehicleNo,'') as VehicleNo From Todr1 Where DriverCode='" + request.DriverCode + "' ";
Result = db.Select <Todr1>(strSql);
}
}
}
catch { throw; }
return(Result);
}
public List <Todr1> GetTodr1(Tms_Login request) //20160511
{
List <Todr1> Result = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("TMS"))
{
var strSQL = "";
if (BlnContactNo == false)
{
strSQL = "select isnull(DriverCode,'') as DriverCode,isnull(DriverName,'') as DriverName from todr1 where ContactNo2=" + Modfunction.SQLSafeValue(request.ContactNo);
Result = db.Select <Todr1>(strSQL);
}
else
{
strSQL = "select isnull(DriverCode,'') as DriverCode,isnull(DriverName,'') as DriverName from todr1 where ContactNo1=" + Modfunction.SQLSafeValue(request.ContactNo);
Result = db.Select <Todr1>(strSQL);
}
}
}
catch { throw; }
return(Result);
}