public Message Get(string password, string mode)
{
try
{
if (!password.Equals("fbs123321"))
{
return(new Message
{
Content = "MUA"
});
}
if (mode.Equals("init"))
{
initKeyCodeDb();
return(new Message
{
Content = "VIVA"
});
}
else if (mode.Equals("next"))
{
string keycode = "";
var sql = String.Format("select * from keycode where state = 0 limit 1");
using (DatabaseKeeper.GetInstance().KeycodeDbLocker.ReadLock())
{
using (SQLiteDataReader dr = DatabaseKeeper.GetInstance().KeycodeDBHelper.ExecuteReader(sql))
{
if (dr.Read())
{
keycode = dr["keycode"].ToString();
}
}
}
sql = String.Format("update keycode set state = 1 where keycode = \"{0}\"", keycode);
using (DatabaseKeeper.GetInstance().KeycodeDbLocker.WriteLock())
{
DatabaseKeeper.GetInstance().KeycodeDBHelper.ExecuteNonQuery(sql);
}
return(new Message
{
Content = keycode
});
}
return(new Message
{
Content = "OOO"
});
}
catch (Exception ex)
{
Logger.Logger.GetLogger(this).ErrorFormat("GetKeyCode: {0}", ex);
return(new Message
{
Content = "500"
});
}
}
public Models.AppResult Get(int pageSize, int offSet, string searchName)
{
try
{
var appList = new List <Models.AppResultItem>();
var sql = "select * from app";
int dataSize = 0;
using (DatabaseKeeper.GetInstance().AppDbLocker.ReadLock())
{
using (SQLiteDataReader dr = DatabaseKeeper.GetInstance().AppDBHelper.ExecuteReader(sql))
{
while (dr.Read())
{
dataSize++;
var app = new Models.AppResultItem
{
id = dr["id"].ToString(),
name = dr["appname"].ToString(),
appIdMark = dr["packagename"].ToString(),
dlUrl = String.Format("download/{0}.dacrx", dr["appname"].ToString()),
url = dr["iconpath"].ToString()
};
appList.Add(app);
}
}
}
var result = new Models.AppResult
{
list = appList,
pageSize = 35,
pageNum = (int)Math.Ceiling(dataSize / 35.0),
dataSize = dataSize,
offSet = 0,
position = 0
};
return(result);
}
catch (Exception ex)
{
Logger.Logger.GetLogger(this).ErrorFormat("Exception: {0}", ex);
return(null);
}
}
void initKeyCodeDb()
{
using (var connection = DatabaseKeeper.GetInstance().KeycodeDBHelper.CreateSQLiteConnection())
{
connection.Open();
using (var trans = connection.BeginTransaction())
{
using (SQLiteCommand commnd = new SQLiteCommand(connection))
{
string keycode;
string sql;
for (int i = 0; i < 100000; i++)
{
keycode = getKeyCode();
sql = String.Format("insert into keycode(keycode, state) values(\"{0}\", \"{1}\")", keycode, 0);
commnd.CommandText = sql;
commnd.ExecuteNonQuery();
}
}
trans.Commit();
}
}
}
public DataResult Get()
{
var dataResult = new DataResult();
dataResult.AdvancedUsers = new List <string>();
dataResult.TiralUsers = new List <DataResultItem>();
string machineId;
int occupyTimes;
using (DatabaseKeeper.GetInstance().RegisterDbLocker.ReadLock())
{
var sql = String.Format("select * from register where keycode != \"\"");
using (SQLiteDataReader dr = DatabaseKeeper.GetInstance().RegisterDBHelper.ExecuteReader(sql))
{
while (dr.Read())
{
machineId = dr["machineid"].ToString();
dataResult.AdvancedUsers.Add(machineId);
}
}
sql = String.Format("select * from register where keycode = \"\"");
using (SQLiteDataReader dr = DatabaseKeeper.GetInstance().RegisterDBHelper.ExecuteReader(sql))
{
while (dr.Read())
{
machineId = dr["machineid"].ToString();
occupyTimes = Int16.Parse(dr["occupytimes"].ToString());
dataResult.TiralUsers.Add(new DataResultItem {
MachineId = machineId, OccupyTimes = occupyTimes
});
}
}
}
dataResult.AdvancedUsersCount = dataResult.AdvancedUsers.Count;
dataResult.TrialUsersCount = dataResult.TiralUsers.Count;
return(dataResult);
}
private void try2Register(RegisterInfo registerInfo, RegisterValue registerValue)
{
int keycodeState = -1;
var keycodeSql = String.Format("select * from keycode where keycode = \"{0}\"", registerInfo.KeyCode);
using (DatabaseKeeper.GetInstance().KeycodeDbLocker.ReadLock())
{
using (SQLiteDataReader dr = DatabaseKeeper.GetInstance().KeycodeDBHelper.ExecuteReader(keycodeSql))
{
if (dr.Read())
{
keycodeState = Int16.Parse(dr["state"].ToString());
}
}
}
//经过申请的keycode，可以用于注册
if (keycodeState == 1)
{
registerValue.KeyCode = registerInfo.KeyCode;
//更新keycode为已经使用
registerValue.Message = "注册成功";
var updateKeyCodeSql = String.Format("update keycode set state = 2 where keycode = \"{0}\"", registerInfo.KeyCode);
using (DatabaseKeeper.GetInstance().KeycodeDbLocker.WriteLock())
{
DatabaseKeeper.GetInstance().KeycodeDBHelper.ExecuteNonQuery(updateKeyCodeSql);
}
}
else if (keycodeState == 2)
{
registerValue.Message = "重复的注册码";
}
else
{
registerValue.Message = "无效的注册码";
}
}
private Message doPost(Message value)
{
var content = value.Content;
content = this.enciphermentUtil.decStringPlusBase64(content);
var registerInfo = JsonConvert.DeserializeObject <RegisterInfo>(content);
var sql = String.Format("select * from register where machineid = \"{0}\"", registerInfo.MachineId);
RegisterValue registerValue = null;
using (DatabaseKeeper.GetInstance().RegisterDbLocker.ReadLock())
{
using (SQLiteDataReader dr = DatabaseKeeper.GetInstance().RegisterDBHelper.ExecuteReader(sql))
{
if (dr.Read())
{
registerValue = new RegisterValue
{
MachineId = registerInfo.MachineId,
KeyCode = dr["keycode"].ToString(),
OccupyTimes = Int16.Parse(dr["occupytimes"].ToString())
};
}
}
}
if (registerValue == null)
{
registerValue = new RegisterValue
{
KeyCode = "",
OccupyTimes = 1,
MachineId = registerInfo.MachineId
};
registerValue.Message = "欢迎使用DesktopAndroid";
//升级到正式版
if (!String.IsNullOrEmpty(registerInfo.KeyCode))
{
try2Register(registerInfo, registerValue);
}
using (DatabaseKeeper.GetInstance().RegisterDbLocker.WriteLock())
{
var insertSql = String.Format("insert into register(machineid,keycode,occupytimes) values(\"{0}\",\"{1}\",\"{2}\")",
registerValue.MachineId, registerValue.KeyCode, registerValue.OccupyTimes);
DatabaseKeeper.GetInstance().RegisterDBHelper.ExecuteNonQuery(insertSql);
}
}
else
{
if (String.IsNullOrEmpty(registerValue.KeyCode))
{
//升级到正式版
if (!String.IsNullOrEmpty(registerInfo.KeyCode))
{
try2Register(registerInfo, registerValue);
//升级成功
if (!String.IsNullOrEmpty(registerValue.KeyCode))
{
using (DatabaseKeeper.GetInstance().RegisterDbLocker.WriteLock())
{
var updateSql = String.Format("update register set keycode = \"{0}\" where machineid = \"{1}\"", registerValue.KeyCode, registerValue.MachineId);
DatabaseKeeper.GetInstance().RegisterDBHelper.ExecuteNonQuery(updateSql);
}
}
}
else
{
if (registerValue.OccupyTimes >= LIMIT)
{
//不限制试用
//registerValue.IsLimited = true;
//registerValue.Message = "试用已结束，请升级到正式版";
registerValue.Message = "欢迎使用DesktopAndroid";
}
else
{
registerValue.Message = "欢迎使用DesktopAndroid";
//registerValue.Message = String.Format("你的试用次数还有{0}次", LIMIT - registerValue.OccupyTimes);
registerValue.OccupyTimes++;
using (DatabaseKeeper.GetInstance().RegisterDbLocker.WriteLock())
{
var updateSql = String.Format("update register set occupytimes = {0} where machineid = \"{1}\"", registerValue.OccupyTimes, registerValue.MachineId);
DatabaseKeeper.GetInstance().RegisterDBHelper.ExecuteNonQuery(updateSql);
}
}
}
}
}
registerValue.Random = registerInfo.Random;
var rspContent = JsonConvert.SerializeObject(registerValue);
rspContent = this.enciphermentUtil.encStringPlusBase64(rspContent);
return(new Message
{
Content = rspContent
});
}