public static ClsDES Instance()
{
if (clsDES == null)
{
lock (lockHelper)
{
if (clsDES == null)
{
clsDES = new ClsDES();
}
}
}
return(clsDES);
}
public string dtUserInfo(string vchrUid, string vchrPwd)
{
string s = "";
try
{
bool b注册 = false;
string sSQL = @"
SELECT TOP (200) iID, sType, cCode, cText
FROM _Code
WHERE (sType = 'aaa')
";
DataTable dt = clsSQLCommond.ExecQuery(sSQL);
if (dt == null || dt.Rows.Count != 1)
{
b注册 = false;
}
else
{
b注册 = true;
}
ClsDES clsDes = ClsDES.Instance();
DateTime d注册 = Convert.ToDateTime(clsDes.Decrypt(clsDes.Decrypt(dt.Rows[0]["cText"].ToString().Trim())));
sSQL = "select getdate()";
DateTime dNow = Convert.ToDateTime(clsSQLCommond.ExecGetScalar(sSQL));
if (d注册 > dNow)
{
if (b注册)
{
sSQL = "select vchrUid, vchrPwd, vchrRemark, tstamp, dtmCreate, dtmClose from _UserInfo " +
"where vchrUid = '" + vchrUid.Trim() + "' and vchrPwd = '" + vchrPwd.Trim() + "'";
dt = clsSQLCommond.ExecQuery(sSQL);
s = Cls序列化.SerializeDataTableXml(dt);
}
}
}
catch (Exception ee)
{
s = ee.Message;
}
return(s);
}
