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); }