/// <summary>
/// 权限验证
/// </summary>
/// <returns></returns>
public bool IsValid(out string msg)
{
Password = Des.DecryStrHex(Password, "0125" + UserCode);//解密
if (SQLBaseDAL.State == ConnectionState.Broken || SQLBaseDAL.State == ConnectionState.Closed)
{
//连接Broken、Closed
if (!SQLBaseDAL.Open(out msg))//开启连接
{
return(false);
}
}
return(UserDAL.Check(UserCode, Password, out msg));
}
internal static void AnalyzeLisense(string license, string serialNo, out string expDate, out string reportNumber)
{
char[] chars = license.ToCharArray();
char[] date = new char[16];
char[] keys = new char[16];
char[] number = new char[16];
for (int i = 0; i < 16; i++)
{
date[i] = chars[i * 3];
number[i] = chars[i * 3 + 1];
keys[i] = chars[i * 3 + 2];
}
string key = Des.DecryStrHex(new string(keys), serialNo);
expDate = Des.DecryStrHex(new string(date), key);
reportNumber = Des.DecryStrHex(new string(number), key);
}
/// <summary>
/// 获取数据库连接
/// </summary>
/// <returns></returns>
public static int GetConnectionString(decimal ID, out string connectionString, out short dbType, out string msg)
{
try
{
using (IDAL dal = DALBuilder.CreateDAL(ConfigurationManager.ConnectionStrings["SYSDB"].ConnectionString, 0))
{
string DataSource, DbName, UserID, Password;
dal.OpenReader("SELECT DbType, DataSource,DbName,UserID,Password FROM dbo.tDatabase WHERE ID=@ID",
dal.CreateParameter("@ID", ID));
if (dal.DataReader.Read())
{
dbType = Convert.ToInt16(dal.DataReader["DbType"]);
DataSource = Convert.ToString(dal.DataReader["DataSource"]).TrimEnd();
DbName = Convert.ToString(dal.DataReader["DbName"]).TrimEnd();
UserID = Convert.ToString(dal.DataReader["UserID"]).TrimEnd();
Password = Convert.ToString(dal.DataReader["Password"]).TrimEnd();
Password = Des.DecryStrHex(Password, UserID);
connectionString = dbType == 0 ?MSSQL_CONNECTIONSTRING :ORACLE_CONNECTIONSTRING;
connectionString = connectionString.Replace("@DataSource", DataSource).Replace("@DbName", DbName).Replace("@UserID", UserID).Replace("@Password", Password);
msg = "success";
return(1);
}
else
{
connectionString = null;
msg = "error";
dbType = -1;
return(0);
}
}
}
catch (System.Exception ex)
{
msg = ex.Message;
connectionString = null;
dbType = -1;
return(-1);
}
}
/// <summary>
/// 读取参数
/// </summary>
/// <param name="msg"></param>
/// <returns></returns>
public static bool GetConfig(out string msg)
{
try
{
string json = TransClass.GetConfig();
MMessage <MConfig[]> mmsg = Converter.Deserialize <MMessage <MConfig[]> >(
json);
if (mmsg.Flag)
{
foreach (MConfig config in mmsg.Content)
{
switch (config.ItemName)
{
case "RECEIPT HEAD1":
PubGlobal.SysConfig.PrnHeader1 = config.ItemValue;
break;
case "RECEIPT HEAD2":
PubGlobal.SysConfig.PrnHeader2 = config.ItemValue;
break;
case "RECEIPT HEAD3":
PubGlobal.SysConfig.PrnHeader3 = config.ItemValue;
break;
case "RECEIPT TAIL1":
PubGlobal.SysConfig.PrnFooter1 = config.ItemValue;
break;
case "RECEIPT TAIL2":
PubGlobal.SysConfig.PrnFooter2 = config.ItemValue;
break;
case "RECEIPT TAIL3":
PubGlobal.SysConfig.PrnFooter3 = config.ItemValue;
break;
case "ICNEWMM":
PubGlobal.SysConfig.CzkPassword = Des.DecryStrHex(config.ItemValue, "0125");
break;
case "IcLen":
PubGlobal.SysConfig.CzkLen = int.Parse(config.ItemValue);
break;
default:
break;
}
}
msg = "读取参数完毕";
return(true);
}
else
{
msg = mmsg.Text;
return(false);
}
}
catch (Exception ex)
{
msg = "系统异常：" + ex.Message;
return(false);
}
}
