public bool GetProfitLossListByPage(ref List <ProfitLossInfo> modelList, ProfitLossInfo model, ref DividPage page, UserInfo user, ref string strError)
{
List <ProfitLossInfo> lstModel = new List <ProfitLossInfo>();
try
{
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_ProfitLoss", GetFilterSql(model, user), "*", "Order By CheckID Desc, AreaNo, MaterialNo, AccountQty Desc, ScanQty Desc"))
{
while (dr.Read())
{
lstModel.Add(GetModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
finally
{
}
}
public bool QueryFastInList(Task_Model taskModel, string BeginTime, string EndTime, ref DividPage dividpage, ref List <Task_Model> lsttask, ref string strErrMsg)
{
if (dividpage == null)
{
dividpage = new DividPage();
}
lsttask = new List <Task_Model>();
try
{
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref dividpage, "v_queryfastinlist", GetFilterSql(taskModel, BeginTime, EndTime), "*", "Order by CREATEDATETIME desc"))
{
while (dr.Read())
{
lsttask.Add(GetModelFromDataReader(dr));
}
dividpage.CurrentPageRecordCounts = lsttask.Count;
}
if (lsttask == null || lsttask.Count == 0)
{
strErrMsg = "没有快速入库单信息！";
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
strErrMsg = ex.Message;
return(false);
}
}
/// <summary>
/// 获取检验通知书导出数据
/// </summary>
/// <param name="strErrMsg"></param>
/// <returns></returns>
public bool GetQualityExportListByPage(ref List <QuanlityExportInfo> modelList, QuanlityExportInfo model, ref DividPage page, UserInfo user, ref string strError)
{
if (page == null)
{
page = new DividPage();
}
List <QuanlityExportInfo> lstModel = new List <QuanlityExportInfo>();
try
{
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_GetQualityExportInfo", GetFilterSql(model, user), "*", "Order By CreateDate Desc"))
{
while (dr.Read())
{
lstModel.Add(GetQualityExport_ModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
finally
{
}
}
public bool GetQualityDetailListByPage(ref List <DeliveryReceiveDetail_Model> modelList, DeliveryReceiveDetail_Model model, ref DividPage page, UserInfo user, ref string strError)
{
if (page == null)
{
page = new DividPage();
}
List <DeliveryReceiveDetail_Model> lstModel = new List <DeliveryReceiveDetail_Model>();
try
{
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_GETQUALITYDETAILINFO", GetFilterSql(model, user), "*", "Order By rowno Asc"))
{
while (dr.Read())
{
lstModel.Add(GetDeliveryReceiveDetail_ModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
finally
{
}
}
public bool GetOverViewDetailByPage(ref List <OverViewDetailInfo> modelList, OverViewDetailInfo model, ref DividPage page, UserInfo user, ref string strError)
{
if (page == null)
{
page = new DividPage();
}
List <OverViewDetailInfo> lstModel = new List <OverViewDetailInfo>();
try
{
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_OverViewDetail", GetFilterSql(model, user)))
{
while (dr.Read())
{
lstModel.Add(GetModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
finally
{
}
}
//查询无PO快速入库数据
public bool GetFastInNotHavePOInfo(Task_Model taskmo, ref DividPage dividpage, ref List <Task_Model> lsttask, ref string strErrMsg)
{
if (dividpage == null)
{
dividpage = new DividPage();
}
lsttask = new List <Task_Model>();
try
{
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref dividpage, GetSql(taskmo), GetFilterSql(taskmo)))
{
Console.Write(GetSql(taskmo) + "\n" + GetFilterSql(taskmo));
while (dr.Read())
{
lsttask.Add(GetModelFromDataReader(dr));
}
dividpage.CurrentPageRecordCounts = lsttask.Count;
}
if (lsttask == null || lsttask.Count == 0)
{
strErrMsg = "没有快速入库单信息！";
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
strErrMsg = ex.Message;
return(false);
}
}
public bool GetCheckDetailsListByPage(ref List <CheckDetailsInfo> modelList, CheckDetailsInfo model, ref DividPage page, UserInfo user, ref string strError)
{
if (page == null)
{
page = new DividPage();
}
List <CheckDetailsInfo> lstModel = new List <CheckDetailsInfo>();
try
{
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_CheckDetails", GetFilterSql(model, user), GetFieldsSql(model, user), "Order By CheckID Desc,ID Desc"))
{
while (dr.Read())
{
lstModel.Add(GetModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
finally
{
}
}
public bool GetCheckAnalyseListByPage(ref List <CheckDetailsInfo> modelList, CheckDetailsInfo model, ref DividPage page, UserInfo user, ref string strError)
{
if (!_db.UpdateCheckAnalyse(model, ref strError))
{
return(false);
}
List <CheckDetailsInfo> lstModel = new List <CheckDetailsInfo>();
try
{
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_CheckAnalyse", GetFilterSql(model, user), "*", "Order by OperationTime desc"))
{
while (dr.Read())
{
lstModel.Add(GetModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
finally
{
}
}
public bool GetWarehouseListByPage(ref List <WarehouseInfo> modelList, WarehouseInfo model, ref DividPage page, UserInfo user, ref string strError)
{
if (page == null)
{
page = new DividPage();
}
List <WarehouseInfo> lstModel = new List <WarehouseInfo>();
try
{
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_Warehouse", GetFilterSql(model, user), "*", "Order By WarehouseNo,ID Desc"))
{
while (dr.Read())
{
lstModel.Add(GetModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
}
public bool GetStockDetailListByPage(ref List <Stock_Model> modelList, Stock_Model model, ref DividPage page, UserInfo user, ref string strError)
{
if (page == null)
{
page = new DividPage();
}
List <Stock_Model> lstModel = new List <Stock_Model>();
try
{
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_StockDetail", GetFilterSql(model, user), "*", "Order By CreateTime desc,WarehouseNo,HouseNo,AreaNo,MaterialNo,Qty"))
{
while (dr.Read())
{
lstModel.Add(GetModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
finally
{
}
}
public bool GetSpecialReturnMaterialListByPage(ref List <SpecialReturnMaterial> modelList, SpecialReturnMaterial model, ref DividPage page, UserInfo user, ref string strError)
{
if (page == null)
{
page = new DividPage();
}
List <SpecialReturnMaterial> lstModel = new List <SpecialReturnMaterial>();
try
{
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_SpecialReturnMaterial", GetFilterSql(model, user), "*", "Order By InvtID,ID Desc"))
{
while (dr.Read())
{
lstModel.Add(GetModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
finally
{
}
}
public bool GetCheckDetailsSelectListByPage(ref List <CheckDetailsInfo> modelList, CheckDetailsInfo model, ref DividPage page, UserInfo user, ref string strError)
{
List <CheckDetailsInfo> lstModel = new List <CheckDetailsInfo>();
try
{
string ViewName = string.Empty;
string FiltSql = string.Empty;
string SortSql = string.Empty;
if (!GetSelectListFilterSql(model, user, ref ViewName, ref FiltSql, ref SortSql))
{
strError = "获取盘点选择视图错误";
return(false);
}
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, ViewName, FiltSql, "V.*", SortSql))
{
while (dr.Read())
{
lstModel.Add(GetModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
finally
{
}
}
public bool GetPrintRecordListByPage(ref List <Barcode_Model> modelList, Barcode_Model model, ref DividPage page, UserInfo user, ref string strError)
{
if (page == null)
{
page = new DividPage();
}
List <Barcode_Model> lstModel = new List <Barcode_Model>();
try
{
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "v_printrecord", GetFilterSql(model, user), "barcodetype, strbarcodetype, supcode, supname, vouchertype, strvouchertype, sum(printqty) printqty", "Order by SupCode, BarcodeType, VoucherType, sum(PrintQty) desc"))
{
while (dr.Read())
{
lstModel.Add(GetModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
finally
{
}
}
public bool GetTaskTransListByPage(ref List <TaskTransInfo> modelList, TaskTransInfo model, ref DividPage page, UserInfo user, ref string strError)
{
if (page == null)
{
page = new DividPage();
}
List <TaskTransInfo> lstModel = new List <TaskTransInfo>();
try
{
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_TaskTrans", GetFilterSql(model, user), "*", "Order By CreateDate desc,TaskNo,FromAreaNo,ToAreaNo,SerialNo"))
{
while (dr.Read())
{
lstModel.Add(GetModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
finally
{
}
}
/// <summary>
/// Limpa os dados e encerra.
/// </summary>
public static void Close()
{
Common_DB.Close();
WorldNetwork.Shutdown();
GameNetwork.Shutdown();
Classe.Clear();
Configuration.Clear();
Authentication.Clear();
ProhibitedNames.Clear();
FileLog.Close();
}
/// <summary>
/// Fecha todas as conexões.
/// </summary>
public static void Close()
{
//Não permite nenhuma conexão (evitar possíveis erros)
Settings.CantConnectNow = true;
Settings.Server = null;
//Limpa as configurações
Configuration.Clear();
Authentication.Clear();
LoginNetwork.Shutdown();
WorldNetwork.Shutdown();
CheckSum.Clear();
//Fecha o arquivo de logs
FileLog.CloseFileLog();
Common_DB.Close();
}
public bool GetPreparationList(ref List <Preparation> modelList, Preparation model, UserInfo user, ref string strError)
{
List <Preparation> lstModel = new List <Preparation>();
try
{
using (SqlDataReader dr = Common_DB.QueryAll("V_Preparation", GetFilterSql(model, user), "*", "Order By pCode,ID Desc"))
{
while (dr.Read())
{
lstModel.Add(GetModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
}
public bool GetAreaList(ref List <AreaInfo> modelList, AreaInfo model, UserInfo user, ref string strError)
{
List <AreaInfo> lstModel = new List <AreaInfo>();
try
{
using (SqlDataReader dr = Common_DB.QueryAll("V_Area", GetFilterSql(model, user), "*", "Order By WarehouseNo,HouseNo,AreaNo,ID Desc"))
{
while (dr.Read())
{
lstModel.Add(GetModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
}
public void InitializeServer()
{
trayIcon = new NotifyIcon();
trayMenu = new ContextMenu();
Configuration.ParseConfigFile(Settings.FILE_CONFIG);
// CARREGA TODAS AS INFORMAÇÕES DE CONFIURAÇÃO
Settings.WorldServerName = Configuration.GetString("WorldServerName");
WriteLog($"World Server Name: {Settings.WorldServerName}", Color.CornflowerBlue);
Text = $"World Server @ {Settings.WorldServerName}";
Settings.Discovery = Configuration.GetString("Discovery");
WriteLog($"Discovery: {Settings.Discovery}", Color.Black);
Settings.Port = Configuration.GetInt32("Port");
WriteLog($"Port: {Settings.Port}", Color.Black);
Settings.MaxConnection = Configuration.GetInt32("MaximumConnections");
WriteLog($"MaxConnection: {Settings.MaxConnection}", Color.Black);
Settings.ConnectionTimeOut = Configuration.GetInt32("ConnectionTimeOut");
WriteLog($"ConnectionTimeOut: {Settings.ConnectionTimeOut}", Color.Black);
Settings.LogSystem = Configuration.GetBoolean("LogSystem");
WriteLog($"LogSystem: {Settings.LogSystem}", Color.Black);
Settings.Sleep = Configuration.GetInt32("Sleep");
WriteLog($"Sleep: {Settings.Sleep}", Color.Black);
LuaConfig.InitializeConfig();
WriteLog($"Create Character: {GameSettings.CharacterCreation}", Color.MediumVioletRed);
WriteLog($"Delete Character: {GameSettings.CharacterDelete}", Color.MediumVioletRed);
InitializeServerConfig();
if (Settings.LogSystem == true)
{
WriteLog("LogSystem - Ativado.", Color.Green);
FileLog.Open();
}
else
{
WriteLog("LogSystem - Desativado.", Color.Black);
}
WriteLog("Carregando config do mysql", Color.Black);
string tempError = string.Empty;
Common_DB.Server = Configuration.GetString("MySQL_IP");
Common_DB.Port = Configuration.GetInt32("MySQL_Port");
Common_DB.Username = Configuration.GetString("MySQL_User");
Common_DB.Password = Configuration.GetString("MySQL_Pass");
Common_DB.Database = Configuration.GetString("MySQL_DB");
// Tenta fazer a conexão com o banco de dados
if (!Common_DB.Open(out tempError))
{
WriteLog(tempError, Color.Red);
}
else
{
WriteLog("Connectado ao banco de dados", Color.Green);
}
Authentication.HexID = new HashSet <HexaID>();
Authentication.Player = new HashSet <PlayerData>();
InitializeGuild();
InitializeClasse();
WorldNetwork.InitializeServer();
GameNetwork.InitializeGameServer();
WriteLog("World Server Start.", Color.Green);
//################# sysTray ########################
trayMenu.MenuItems.Add("Mostrar", ShowForm);
trayMenu.MenuItems.Add("Sair", quit_MenuItem_Click);
trayIcon.Text = "World Server @";
trayIcon.Icon = this.Icon;
trayIcon.ContextMenu = trayMenu;
}
public void InitializeServer()
{
var error = string.Empty;
FileLog.OpenFileLog();
Configuration.ParseConfigFile(Constant.FILE_CONFIG);
Settings.Name = Configuration.GetString("Name");
FileLog.WriteLog($"Game Server Name: {Settings.Name}", Color.CornflowerBlue);
this.Text = $"Game Server @ {Settings.Name}";
Settings.Discovery = Configuration.GetString("Discovery");
FileLog.WriteLog($"Discovery: {Settings.Discovery}", Color.Black);
Settings.Port = Configuration.GetInt32("Port");
FileLog.WriteLog($"Port: {Settings.Port}", Color.Black);
Settings.MaxConnection = Configuration.GetInt32("MaximumConnections");
FileLog.WriteLog($"MaximumConnections: {Settings.MaxConnection}", Color.Black);
Settings.ConnectionTimeOut = Configuration.GetInt32("ConnectionTimeOut");
FileLog.WriteLog($"ConnectionTimeOut: {Settings.ConnectionTimeOut}", Color.Black);
Settings.Logs = Convert.ToBoolean(Configuration.GetInt32("LogSystem"));
FileLog.WriteLog($"Logs: {Settings.Logs}", Color.Black);
Settings.Sleep = Configuration.GetInt32("Sleep");
FileLog.WriteLog($"Sleep: {Settings.Sleep}", Color.Black);
Settings.ID = Configuration.GetString("ID");
FileLog.WriteLog($"Game Server ID: {Settings.ID}", Color.Black);
Settings.WorldServerID = new string[Constant.MAX_SERVER];
FileLog.WriteLog("Carregando config mysql", Color.Black);
Common_DB.Server = Configuration.GetString("MySQL_IP");
Common_DB.Port = Configuration.GetInt32("MySQL_Port");
Common_DB.Username = Configuration.GetString("MySQL_User");
Common_DB.Password = Configuration.GetString("MySQL_Pass");
Common_DB.Database = Configuration.GetString("MySQL_DB");
// Tenta se conectar ao banco de dados
if (!Common_DB.Connect(out error))
{
FileLog.WriteLog(error, Color.Red);
}
else
{
FileLog.WriteLog("Connectado ao banco de dados", Color.Green);
}
if (!string.IsNullOrEmpty(error))
{
FileLog.WriteLog(error, Color.Red);
}
for (int n = 0; n < Constant.MAX_SERVER; n++)
{
Settings.WorldServerID[n] = Configuration.GetString($"{n + 1}_WorldID");
FileLog.WriteLog($"WorldServer {n + 1} ID: {Settings.WorldServerID[n]}", Color.Coral);
}
FileLog.WriteLog("Carregando experiência", Color.Black);
ServerData_DB.LoadExperience();
FileLog.WriteLog($"Level Max: {Experience.Level.LevelMax}", Color.BlueViolet);
FileLog.WriteLog($"Exp Max: {Experience.Level.GetMaxExp()}", Color.BlueViolet);
Guild.Guilds = null;
// Prepara as classes para receber dados
Guild.Guilds = new HashSet <Guild>();
// Carrega todos os dados de guild
FileLog.WriteLog("Carregando guilds", Color.Black);
Guild_DB.GuildInfo();
Guild_DB.MemberInfo();
FileLog.WriteLog("Carregando membros", Color.Black);
// Classes
InitializeClasse();
///npc
FileLog.WriteLog("Carregando NPC", Color.Black);
NpcManager.Npc = new HashSet <NpcData>();
Npc_DB.InitializeNpc();
//Inicia mapas de teste
//Maps.MapGeneral.Map.InitializeMap();
Maps.MapManager.Add(1);
Maps.MapManager.Add(2);
Maps.MapManager.Add(3);
Authentication.HexID = new HashSet <HexaID>();
Authentication.Player = new HashSet <PlayerData>();
GameNetwork.InitializeServer();
FileLog.WriteLog("Game Server Start", Color.Green);
}
/// <summary>
/// Inicializa o servidor
/// </summary>
public void InitializeServer()
{
trayIcon = new NotifyIcon();
trayMenu = new ContextMenu();
LuaScript.LuaConfig.InitializeConfig();
Configuration.ParseConfigFile($"{Environment.CurrentDirectory}\\{Settings.FILE_CONFIG}");
Settings.Discovery = Configuration.GetString("Discovery");
WriteLog($"Discovery: {Settings.Discovery}", Color.Black);
Settings.Port = Configuration.GetInt32("Port");
WriteLog($"Port: {Settings.Port}", Color.Black);
Settings.MaxConnection = Configuration.GetInt32("MaximumConnections");
WriteLog($"MaxConnection: {Settings.MaxConnection}", Color.Black);
Settings.ConnectionTimeOut = Configuration.GetInt32("ConnectionTimeOut");
WriteLog($"ConnectionTimeOut: {Settings.ConnectionTimeOut}", Color.Black);
Settings.LogSystem = Configuration.GetByte("LogSystem");
WriteLog($"LogSystem: {Settings.LogSystem}", Color.Black);
Settings.Sleep = Configuration.GetInt32("Sleep");
WriteLog($"Sleep: {Settings.Sleep}", Color.Black);
Settings.Version = Configuration.GetString("CheckVersion");
WriteLog($"Version: {Settings.Version}", Color.BlueViolet);
GeoIp.Enabled = Configuration.GetBoolean("GeoIp");
var result = (GeoIp.Enabled == true) ? "Ativado" : "Desativado";
WriteLog($"GeoIp: {result}", Color.BlueViolet);
CheckSum.Enabled = Configuration.GetBoolean("CheckSum");
result = (CheckSum.Enabled == true) ? "Ativado" : "Desativado";
WriteLog($"CheckSum: {result}", Color.BlueViolet);
//1 - enabled
result = (Settings.LogSystem == 1) ? "LogSystem: Ativado" : "LogSystem: Desativado";
WriteLog("LogSystem: Desativado.", Color.Black);
if (Settings.LogSystem == 1)
{
FileLog.OpenFileLog();
}
Authentication.Player = new HashSet <PlayerData>();
InitializeServerConfig();
InitializeDatabaseConfig();
var tempError = string.Empty;
if (!Common_DB.Open(out tempError))
{
WriteLog(tempError, Color.Red);
}
else
{
WriteLog("Connectado ao banco de dados", Color.Green);
}
WriteLog("Conectando World Server.", Color.Green);
WorldNetwork.InitializeWorldServer();
WriteLog("Login Server Start.", Color.Green);
LoginNetwork.InitializeServer();
GeoIp.ReadFile();
#region Tray System
trayMenu.MenuItems.Add("Mostrar", ShowForm);
trayMenu.MenuItems.Add("Sair", quit_MenuItem_Click);
trayIcon.Text = "Connect Server @";
trayIcon.Icon = this.Icon;
trayIcon.ContextMenu = trayMenu;
#endregion
}
