public static void InitialiseClient()
{
L.I("Started Initialise Database Server Connection....");
bool conn = DatabaseSocketsClient.Initialise(IPAddress.Parse(XConfig.Current.Database.DBServerIP), XConfig.Current.Database.DBServerPort);
while (!conn)
{
L.E("DBServer Initial Connection Failed!");
conn = DatabaseSocketsClient.Initialise(IPAddress.Parse(XConfig.Current.Database.DBServerIP), XConfig.Current.Database.DBServerPort);
}
}
public static int Main(string[] args)
{
LW.SetLogLevel(LogLevel.D);
LW.InitLog();
LW.I("========= = Start WoodenBench for Schoolbus Windows Client = =========");
if (!XConfig.LoadConfig("XConfig.conf"))
{
LW.E("Config Loading Failed! Check file...");
return(0);
}
DataBaseOperation.InitialiseClient();
Application.EnableVisualStyles();
Application.Run(LoginWindow.Default);
DatabaseSocketsClient.KillConnection();
return(0);
}
public static void Main(string[] args)
{
StartUpTime = DateTime.Now;
L.InitLog();
L.I("WoodenBench WebServer Starting....");
L.I($"Startup Time {StartUpTime.ToString()}.");
Version = new FileInfo(new string(Assembly.GetExecutingAssembly().CodeBase.Skip(8).ToArray())).LastWriteTime.ToString();
L.I($"Version: {Version}");
var v = XConfig.LoadAll();
if (!(v.Item1 && v.Item2))
{
L.E("XConfig Load error... Quiting");
return;
}
L.I("Starting Job Watcher");
TimedJob.StartJobWatcher();
TimedJob.AddToJobList("Get Config", XConfig.ServerConfig.GetConfig, 10, 0);
TimedJob.AddToJobList("Session Checker", BaseController.CheckSessions, 10, 0);
TimedJob.AddToJobList("Status Monitor", StatusMonitor.SendStatus, 10);
DataBaseOperation.InitialiseClient();
XConfig.ServerConfig.GetConfig();
WeChatHelper.PrepareCodes();
WeChatHelper.InitialiseEncryptor();
L.I("Initialising Core Messaging Systems.....");
WeChatMessageSystem.StartProcessThreads();
WeChatMessageBackupService.StartBackupThread();
MessagingSystem.StartProcessThread();
var webHost = BuildWebHost(args, XConfig.Current.ApplicationInsightInstrumentationKey);
L.I("Starting WebHost....");
WebServerTask = webHost.RunAsync(ServerStopToken.Token);
WebServerTask.Wait();
L.E("WebServer Stoped! Cancellation Token = " + ServerStopToken.IsCancellationRequested);
DatabaseSocketsClient.KillConnection();
}
static void Main(string[] args)
{
L.InitLog();
XConfig.LoadConfig("XConfig.conf");
DataBaseOperation.InitialiseClient();
UserObject me = new UserObject()
{
HeadImagePath = "liuhaoyu.gif",
Password = "",
PhoneNumber = "18632738306",
Sex = "M",
UserGroup = new UserGroup(true, true, true, true),
UserName = "******",
Precision = 3,
RealName = "刘浩宇",
CurrentPoint = new System.Drawing.PointF(0, 0)
};
L.D(DataBaseOperation.CreateData(ref me).Stringify());
//L.D(DataBaseOperation.QuerySingle(new DBQuery().WhereEqualTo("UserName", "liuhaoyu"), out UserObject me).ToString());
L.D(me.Stringify());
string[] dePartMent = { "小学", "初中", "普高", "中加", "剑桥" };
string[] namelist = { "钟天泽", "刑从珊", "牟绮南", "陈绮琴", "柯良俊", "伦腾骏", "闪安梦", "浑诗霜", "晁振华", "李易绿", "咎鸿宝", "士芳茵", "隗依晨", "宿德庸", "夏侯清嘉", "乜白亦", "出依波", "邬天青", "惠秋月", "次兴言", "支嘉珍", "枝承嗣", "濮阳亦绿", "革湛英", "韶琼思", "是觅晴", "抄念之", "泉觅翠", "道德元", "貊依丝", "邶芳春", "贺问梅", "蒉晨濡", "鞠德曜", "蔺暄文", "业英悟", "应芳泽", "苦飞双", "欧锦欣", "第五语梦", "悉晓燕", "保鸿畴", "乌孙思懿", "许天蓝", "亥乐水", "邱雅寒", "阿新蕾", "植叶欣", "图门昊伟", "万娅欣", "夕运凯", "高香芹", "夙成周", "狄访风", "无君昊", "温阳焱", "宋合乐", "苑梦蕊", "徭烨磊", "令狐晴岚", "佟佳湛芳", "赫连安珊", "郁阳曦", "迮姝美", "伏觅双", "苍正雅", "冼和硕", "平子珍", "子车晨潍", "危清婉", "九思松", "太叔冬灵", "宏宛亦", "错淑君", "奈明明", "冉盼夏", "嘉水冬", "建永福", "党瑾瑶", "信孤晴", "訾萧曼", "零向真", "风英韶", "后开畅", "凭桃雨", "苏高峯", "让绿蝶", "盛文林", "范绿兰", "施胤雅", "卓安萱", "辜元正", "肖自强", "舒畅然", "公良幻梅", "丹星纬", "堵博易", "虎坚秉", "甲玉泽", "孟竹月", "詹彩萱" };
List <ClassObject> classList = new List <ClassObject>();
List <SchoolBusObject> busList = new List <SchoolBusObject>();
for (int i = 1; i < 16; i++)
{
ClassObject @class = new ClassObject()
{
CDepartment = dePartMent[RandomInt(0, 3)],
CGrade = RandomInt(1, 14) + "年级",
CNumber = RandomInt(1, 8) + "班",
TeacherID = me.ObjectId
};
L.D(DataBaseOperation.CreateData(ref @class).ToString());
L.D(@class.Stringify());
classList.Add(@class);
}
string[] places = { "城镇", /*"莆陂", "城阜", "泉州", "上庄", "辰洞" */ };
foreach (var item in places)
{
SchoolBusObject bo = new SchoolBusObject()
{
BusName = item,
TeacherID = me.ObjectId,
BigWeekOnly = RandomBool,
AHChecked = false,
CSChecked = false,
LSChecked = false
};
L.D(DataBaseOperation.CreateData(ref bo).ToString());
L.D(bo.Stringify());
busList.Add(bo);
}
foreach (var item in namelist)
{
StudentObject stu = new StudentObject()
{
BusID = busList[RandomInt(0, busList.Count)].ObjectId,
ClassID = classList[RandomInt(0, classList.Count)].ObjectId,
Sex = RandomBool ? "M" : "F",
StudentName = item,
AHChecked = false,
CSChecked = false,
LSChecked = false,
TakingBus = true,
WeekType = (StudentBigWeekMode)RandomInt(0, 3),
DirectGoHome = (DirectGoHomeMode)RandomInt(0, 3)
};
L.D(DataBaseOperation.CreateData(ref stu).ToString());
L.D(stu.Stringify());
bool sexParent = RandomBool;
UserObject user = new UserObject()
{
Sex = sexParent ? "M" : "F",
ChildList = new List <string>()
{
stu.ObjectId
},
PhoneNumber = "00000000000",
RealName = stu.StudentName + "的" + (sexParent ? "爸爸" : "妈妈"),
UserGroup = new UserGroup(false, false, false, true),
UserName = "******" + stu.ObjectId,
HeadImagePath = ""
};
L.D(DataBaseOperation.CreateData(ref user).ToString());
L.D(user.Stringify());
if (RandomBool)
{
if (stu != null)
{
me.ChildList.Add(stu.ObjectId);
}
}
}
me.HeadImagePath = "liuhaoyu.gif";
me.ClassList.Add(classList[RandomInt(0, classList.Count)].ObjectId);
L.D(DataBaseOperation.UpdateData(ref me).ToString());
L.D(me.Stringify());
DatabaseSocketsClient.KillConnection();
return;
}
private static DBQueryStatus _DBRequestInternal(string Table, DBVerbs operation, DBQuery query, DataBaseIO output, out DataBaseIO[] results)
{
try
{
//We gonna throw some exceptions!
if ((operation == DBVerbs.QueryMulti || operation == DBVerbs.QuerySingle || operation == DBVerbs.Update || operation == DBVerbs.Delete) && query == null)
{
throw new ArgumentNullException("When using Query Single/Multi and Change, Delete. Arg: query cannot be null");
}
if ((operation == DBVerbs.Create || operation == DBVerbs.Update) && output == null)
{
throw new ArgumentNullException("When using Query Create and Change. Arg: output cannot be null");
}
DataBaseSocketIO internalQuery = new DataBaseSocketIO {
Verb = operation, TableName = Table
};
switch (operation)
{
case DBVerbs.Create:
internalQuery.DBObjects = output.MoveToArray();
break;
case DBVerbs.QuerySingle:
case DBVerbs.QueryMulti:
internalQuery.Query = query;
break;
case DBVerbs.Update:
internalQuery.DBObjects = output.MoveToArray();
internalQuery.Query = query;
break;
case DBVerbs.Delete:
internalQuery.Query = query;
break;
}
string internalQueryString = internalQuery.Stringify();
string _MessageId = MessageId;
if (!DatabaseSocketsClient.SendCommand(internalQueryString, _MessageId, out string rcvdData))
{
results = null;
throw new DataBaseException("Database is not connected currently...");
}
if (!rcvdData.ToParsedObject(out DataBaseSocketIO reply))
{
throw new DataBaseException("DBInternalReply is null");
}
//time to throw exceptions! (again)
switch (reply.ResultCode)
{
case DBQueryStatus.INJECTION_DETECTED: throw new DataBaseException("INJECTION DETECTED.", reply.Exception);
case DBQueryStatus.INTERNAL_ERROR: throw new DataBaseException("Database Server Internal Error", reply.Exception);
}
switch (operation)
{
case DBVerbs.QueryMulti:
results = reply.DBObjects ?? throw new DataBaseException("Query DBObjects should have non-null result.");
break;
case DBVerbs.Create:
case DBVerbs.Update:
case DBVerbs.QuerySingle:
if (reply.DBObjects.Length != 1)
{
throw new DataBaseException("Create & Update & QuerySingle expect 1 result.");
}
results = reply.DBObjects;
break;
case DBVerbs.Delete:
results = null;
break;
//Who knows what the hell it is...
default: throw new DataBaseException("Database Operation is not Supported!");
}
return(reply.ResultCode);
}
catch (Exception ex)
{
results = null;
ex.LogException();
return(DBQueryStatus.INTERNAL_ERROR);
}
}
private static DBQueryStatus _DBRequestInternal(string Table, DBVerbs operation, DBQuery query, DataBaseIO output, out DataBaseIO[] results)
{
try
{
if ((operation == DBVerbs.QueryMulti || operation == DBVerbs.QuerySingle || operation == DBVerbs.Update || operation == DBVerbs.Delete) && query == null)
{
throw new ArgumentNullException("When using Query Single/Multi and Change, Delete. Arg: query cannot be null");
}
if ((operation == DBVerbs.Create || operation == DBVerbs.Update) && output == null)
{
throw new ArgumentNullException("When using Query Create and Change. Arg: output cannot be null");
}
DBInternal internalQuery = new DBInternal {
Verb = operation, TableName = Table
};
switch (operation)
{
case DBVerbs.Create:
internalQuery.DBObjects = output.MoveToArray();
break;
case DBVerbs.QuerySingle:
case DBVerbs.QueryMulti:
internalQuery.Query = query;
break;
case DBVerbs.Update:
internalQuery.DBObjects = output.MoveToArray();
internalQuery.Query = query;
break;
case DBVerbs.Delete:
internalQuery.Query = query;
break;
}
string internalQueryString = internalQuery.ToParsedString();
string _MessageId = MessageId;
if (!DatabaseSocketsClient.SendData(internalQueryString, _MessageId, out string rcvdData))
{
results = null;
throw new DataBaseException("Database is not connected currently...");
}
if (!rcvdData.ToParsedObject(out DBInternal reply))
{
throw new DataBaseException("DBInternalReply is null");
}
// THERE ARE SOME SPECIAL REPLY CODE....
switch (reply.ResultCode)
{
case DBQueryStatus.INJECTION_DETECTED:
throw new DataBaseException("INJECTION DETECTED.", reply.Exception);
case DBQueryStatus.INTERNAL_ERROR:
throw new DataBaseException("Database Server Internal Error", reply.Exception);
}
switch (operation)
{
case DBVerbs.QueryMulti:
results = reply.DBObjects;
break;
case DBVerbs.QuerySingle:
case DBVerbs.Create:
case DBVerbs.Update:
var singleResult = reply.DBObjects;
if (singleResult.Length > 1)
{
throw new DataBaseException("QuerySingle, Create, Change require only one Return result...");
}
if (operation == DBVerbs.QuerySingle)
{
//Allow No results....
results =
singleResult.Length == 0
? new DataBaseIO[0]
: singleResult;
}
else
{
//DisAllow Empty Results....
results =
singleResult.Length == 0
? throw new DataBaseException("Create Update functions expect one result...")
: singleResult;
}
break;
case DBVerbs.Delete:
results = null;
break;
default: throw new DataBaseException("Database Operation " + operation + " is not Supported!");
}
return(reply.ResultCode);
}
catch (DataBaseException ex)
{
results = null;
LW.E(ex);
return(DBQueryStatus.INTERNAL_ERROR);
}
}
