public void OnDestroy()
{
try
{
StageMgr.Dispose();
UIMgr.Dispose();
LevelMgr.Dispose();
AssetBundleMgr.Dispose(IsDisposeAssetBundleInQuit);
DataMgr.Dispose();
Commander.Dispose();
}
catch {}
}
public WO_Loot(int id, WorldObject at, MapPlayer onwer, ObjectsMgr manager)
: base(manager.GetNewGuid() | Constants.IDRObject, manager)
{
_onwer = onwer;
_position = at.Position;
_rotation = at.Rotation;
_loot = DataMgr.SelectLoot(id);
_resource = DataMgr.SelectResource(Constants.LootResource);
OnSpawn += WO_Loot_OnSpawn;
OnDespawn += WO_Loot_OnDespawn;
OnDestroy += WO_Loot_OnDestroy;
Spawn();
}
public int RestoreDataBase(string Path, int FileNo)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsObject DataManager = new ClsObject();
this.Connection = DataMgr.GetConnection_Master();
DataManager.Connection = this.Connection;
ClsUtility.AddParameters("@Path", SqlDbType.VarChar, Path);
ClsUtility.AddParameters("@Position", SqlDbType.Int, FileNo.ToString());
return((Int32)DataManager.ReturnObject(ClsUtility.theParams, "pr_SystemAdmin_RestoreDB_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery));
}
}
public int SaveUpdateClinicalSummaryData(ClinicalSummary obj, int userID)
{
CLogger.WriteLog(ELogLevel.INFO, "BPatientAdherence.SaveUpdateClinicalSummaryData() method called");
bool flag = true;
int visitId = 0;
ClsObject clsObjTP = new ClsObject();
try
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, obj.Ptn_pk.ToString());
ClsUtility.AddParameters("@Visit_Id", SqlDbType.Int, obj.Visit_Id.ToString());
ClsUtility.AddParameters("@location_id", SqlDbType.Int, obj.location_id.ToString());
ClsUtility.AddParameters("@Form_filling_date", SqlDbType.Int, obj.Form_filling_date);
ClsUtility.AddParameters("@CliniciansName", SqlDbType.VarChar, obj.CliniciansName.ToString());
ClsUtility.AddParameters("@Telephone", SqlDbType.VarChar, obj.Telephone.ToString());
ClsUtility.AddParameters("@Email", SqlDbType.VarChar, obj.Email.ToString());
ClsUtility.AddParameters("@PrimaryReason", SqlDbType.VarChar, obj.PrimaryReason.ToString());
ClsUtility.AddParameters("@ClinicalEvaluation", SqlDbType.VarChar, obj.ClinicalEvaluation.ToString());
ClsUtility.AddParameters("@NumberOfAdherence", SqlDbType.Int, obj.NumberOfAdherence.ToString());
ClsUtility.AddParameters("@NumberOfHomeVisit", SqlDbType.Int, obj.NumberOfHomeVisit.ToString());
ClsUtility.AddParameters("@SupportStructures", SqlDbType.VarChar, obj.SupportStructures.ToString());
ClsUtility.AddParameters("@EvidenceOfAdherence", SqlDbType.VarChar, obj.EvidenceOfAdherence.ToString());
ClsUtility.AddParameters("@NumberOfDOTS", SqlDbType.Int, obj.NumberOfDOTS.ToString());
ClsUtility.AddParameters("@PoorAdherence", SqlDbType.VarChar, obj.PoorAdherence.ToString());
ClsUtility.AddParameters("@EvaluationForOtherText", SqlDbType.VarChar, obj.EvaluationForOtherText.ToString());
ClsUtility.AddParameters("@EvaluationForOtherVal", SqlDbType.VarChar, obj.EvaluationForOtherVal.ToString());
ClsUtility.AddParameters("@CommentOnTreatment", SqlDbType.VarChar, obj.CommentOnTreatment.ToString());
ClsUtility.AddParameters("@HasDrugResistance", SqlDbType.VarChar, obj.HasDrugResistance.ToString());
ClsUtility.AddParameters("@HasFacilityMultidisciplinary", SqlDbType.VarChar, obj.HasFacilityMultidisciplinary.ToString());
ClsUtility.AddParameters("@MDTMembers", SqlDbType.VarChar, obj.MDTMembers.ToString());
ClsUtility.AddParameters("@UserId", SqlDbType.Int, userID.ToString());
visitId = (int)clsObjTP.ReturnObject(ClsUtility.theParams, "Pr_SaveUpdateClinicalSummaryData", ClsDBUtility.ObjectEnum.ExecuteNonQuery);
return(visitId);
}
catch (Exception ex)
{
flag = false;
CLogger.WriteLog(ELogLevel.ERROR, "BPatientAdherence.SaveUpdateClinicalSummaryData() Method:" + ex.ToString());
throw ex;
}
finally
{
clsObjTP = null;
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
void Create()
{
Log = new Log();
LayerManager.Init();
//不受状态机控制，仅打开和关闭的
PersistMgr = PersistDialogMgr.Ins;
//面板管理器.
DialogStateManager = new MainDialogMgr();
//顺序排队弹出框.
PopupStateManager = new MainPopupStateManager();
//各类游戏数据.
GameStateMgr = GameStateMgr.Ins;
AppInfo = AppInfo.Ins;
CombatData = CombatData.Ins;
GameNotice = new GameNotice();
MeteorManager = MeteorManager.Ins;
ScriptMng = ScriptMng.Ins;
ActionInterrupt = ActionInterrupt.Ins;
BuffMng = BuffMng.Ins;
EventBus = new EventBus();
NetWorkBattle = NetWorkBattle.Ins;
SceneMng = SceneMng.Ins;
//FrameSyncLocal = FrameSyncLocal.Ins;
FrameSyncServer = FrameSyncServer.Ins;
MeteorBehaviour = MeteorBehaviour.Ins;
DropMng = DropMng.Ins;
//原版相关资源的加载器.
MenuResLoader = MenuResLoader.Ins;
SkcLoader = SkcLoader.Ins;
BncLoader = BncLoader.Ins;
FMCLoader = FMCLoader.Ins;
GMBLoader = GMBLoader.Ins;
GMCLoader = GMCLoader.Ins;
DesLoader = DesLoader.Ins;
FMCPoseLoader = FMCPoseLoader.Ins;
SFXLoader = SFXLoader.Ins;
AmbLoader = AmbLoader.Ins;
DataMgr = DataMgr.Ins;
SfxMeshGenerator = SfxMeshGenerator.Ins;
RoomMng = RoomMng.Ins;
SoundManager = SoundManager.Ins;
DlcMng = DlcMng.Ins;
PathMng = PathMng.Ins;
DownloadManager = DownloadManager.Ins;
DontDestroyOnLoad(gameObject);
Log.WriteError(string.Format("GameStart AppVersion:{0}", Main.Ins.AppInfo.AppVersion()));
}
public int SaveUpdateSatellite(String ID, String SatelliteID, String SatelliteName, String status, int priority, int Flag, int UserID, String Createdate)
{
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject SatelliteMgr = new ClsObject();
SatelliteMgr.Connection = this.Connection;
SatelliteMgr.Transaction = this.Transaction;
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@SatelliteID", SqlDbType.VarChar, SatelliteID);
ClsUtility.AddParameters("@SatelliteName", SqlDbType.VarChar, SatelliteName);
ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, status.ToString());
ClsUtility.AddParameters("@SRNo", SqlDbType.Int, priority.ToString());
ClsUtility.AddParameters("@UserID", SqlDbType.Int, UserID.ToString());
int RowsAffected=0;
if (Flag == 0)
{
RowsAffected = (Int32)SatelliteMgr.ReturnObject(ClsUtility.theParams, "pr_Admin_SaveSatellite_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery);
}
else if (Flag == 1)
{
ClsUtility.AddParameters("@ID", SqlDbType.Int, ID.ToString());
RowsAffected = (Int32)SatelliteMgr.ReturnObject(ClsUtility.theParams, "pr_Admin_UpdateSatellite_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery);
}
/*********/
if (RowsAffected == 0)
{
MsgBuilder theBL = new MsgBuilder();
theBL.DataElements["MessageText"] = "Error in Saving Reason record. Try Again..";
AppException.Create("#C1", theBL);
}
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
return Convert.ToInt32(RowsAffected);
}
catch
{
throw;
}
finally
{
if (this.Connection != null)
DataMgr.ReleaseConnection(this.Connection);
}
}
// Use this for initialization
void Start()
{
//根据解锁关卡记录，设置关卡是否锁定
if (lvlMgr.unlock_levelID < id)
{
LockObj.SetActive(true);
isLock = true;
}
float scale = 2;
//初始化关卡数字显示
if (id < 10)
{
//完全用代码动态创建一个Image对象，并作为num的子节点
GameObject obj = new GameObject("num1", typeof(Image));
RectTransform rtf = obj.GetComponent <RectTransform>();
rtf.SetParent(numTrans);
//设置数字
Image img = obj.GetComponent <Image>();
img.sprite = lvlMgr.spr_nums[id];
img.SetNativeSize(); //图片原始尺寸
rtf.localScale = new Vector3(2, 2, 1);
rtf.localPosition = Vector3.zero;
}
else if (id < 100)
{
//十位数
GameObject obj = new GameObject("num1", typeof(Image));
RectTransform rtf = obj.GetComponent <RectTransform>();
rtf.SetParent(numTrans);
//设置数字
Image img = obj.GetComponent <Image>();
img.sprite = lvlMgr.spr_nums[id / 10];
img.SetNativeSize(); //图片原始尺寸
rtf.localScale = new Vector3(2, 2, 1);
rtf.localPosition = new Vector3(-scale * rtf.rect.width / 2 - 1, 0, 0);
//个位数
GameObject obj2 = new GameObject("num2", typeof(Image));
RectTransform rtf2 = obj2.GetComponent <RectTransform>();
rtf2.SetParent(numTrans);
//设置数字
Image img2 = obj2.GetComponent <Image>();
img2.sprite = lvlMgr.spr_nums[id % 10];
img2.SetNativeSize(); //图片原始尺寸
rtf2.localScale = new Vector3(2, 2, 1);
rtf2.localPosition = new Vector3(scale * rtf2.rect.width / 2 + 1, 0, 0);
}
levelInfo = DataMgr.Instance().levelData.levels[id - 1];
}
public WO_NPC(DB_WorldObject data, ObjectsMgr manager)
: base(manager.GetNewGuid() | Constants.ReleaseGuide, manager)
{
_data = data;
if (!DataMgr.Select(data.ObjectID, out _npc))
{
ServerLogger.LogError($"NPC id {data.ObjectID} doesn't exist");
}
if ((_npc.Flags & NPCFlags.Dialog) > 0)
{
_dialog = _server.Dialogs.GetDialog(_npc.Dialog);
}
if ((_npc.Flags & NPCFlags.Trader) > 0)
{
shop_ser = new SER_Shop(_npc.Items, $"{_npc.Pony.Name}'s shop");
}
if ((_npc.Flags & NPCFlags.Wears) > 0)
{
DB_Item entry; byte slot;
_wears = new Dictionary <int, InventoryItem>();
wears_ser = new SER_Wears(_wears);
foreach (var item in _npc.Wears)
{
if (item > 0 && DataMgr.Select(item, out entry))
{
slot = entry.Slot.ToWearableIndex();
if (_wears.ContainsKey(slot))
{
ServerLogger.LogWarn($"NPC id {data.ObjectID} duplicate wear slot {entry.Slot}");
}
else
{
_wears[slot] = new InventoryItem(item);
}
}
}
}
OnSpawn += WO_NPC_OnSpawn;
OnDespawn += WO_NPC_OnDespawn;
OnDestroy += WO_NPC_OnDestroy;
if ((_npc.Flags & NPCFlags.ScriptedMovement) > 0)
{
AddComponent(new ScriptedMovement(_npc.Movement, this));
}
else
{
AddComponent(new NullMovement(this));
}
m_char = new Character(_npc.ID, -1, _npc.Level, -1, _npc.Pony, null);
Spawn();
}
public int MigrateData(string cmd, int Location, string DBName, int CommandId)
{
//////SqlConnection theCon = (SqlConnection)Entity.GetConnection(ConStr);
//////SqlTransaction theTran = theCon.BeginTransaction();
try
{
//////this.Connection = theCon;
//////this.Transaction = theTran;
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject objMigration = new ClsObject();
objMigration.Connection = this.Connection;
objMigration.Transaction = this.Transaction;
//////Entity theObject = new Entity();
//////theObject.Connection = this.Connection;
//////theObject.Transaction = this.Transaction;
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@dbname", SqlDbType.VarChar, DBName);
if (Location > 0)
{
ClsUtility.AddParameters("@Loc", SqlDbType.Int, Location.ToString());
}
int RowsEffected = (int)objMigration.ReturnObject(ClsUtility.theParams, cmd, ClsUtility.ObjectEnum.ExecuteNonQuery);
string thecmd = "update migration set complete = 1 where id = " + CommandId;
ClsUtility.Init_Hashtable();
int rowseffected = (int)objMigration.ReturnObject(ClsUtility.theParams, thecmd, ClsUtility.ObjectEnum.ExecuteNonQuery);
//////theTran.Commit();
//////theCon.Close();
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
return(RowsEffected);
}
catch
{
//theTran.Rollback();
DataMgr.RollBackTransation(this.Transaction);
throw;
//////throw ex;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
public int SaveUpdatePatientARTCareSummary(int patientID, int VisitID, int LocationID, Hashtable ht, int userID, int DataQualityFlag)
{
int retval = 0;
DataSet theDS;
ClsObject ARTCareSummaryMgr = new ClsObject();
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ARTCareSummaryMgr.Connection = this.Connection;
ARTCareSummaryMgr.Transaction = this.Transaction;
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString());
ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString());
ClsUtility.AddParameters("@Visit_ID", SqlDbType.Int, VisitID.ToString());
ClsUtility.AddParameters("@visitdate", SqlDbType.DateTime, ht["visitdate"].ToString());
//ClsUtility.AddParameters("@CohortMonth", SqlDbType.VarChar, ht["CohortMonth"].ToString());
//ClsUtility.AddParameters("@CohortYear", SqlDbType.VarChar, ht["CohortYear"].ToString());
ClsUtility.AddParameters("@OtherfacilityRegimen", SqlDbType.VarChar, ht["OtherfacilityRegimen"].ToString());
ClsUtility.AddParameters("@OtherfacilityRegimenStartDate", SqlDbType.DateTime, ht["OtherfacilityRegimenStartDate"].ToString());
ClsUtility.AddParameters("@OtherfacilityWHOStage", SqlDbType.Int, ht["OtherfacilityWHOStage"].ToString());
ClsUtility.AddParameters("@OtherfacilityCD4", SqlDbType.Decimal, ht["OtherfacilityCD4"].ToString());
ClsUtility.AddParameters("@OtherfacilityCD4Percent", SqlDbType.Decimal, ht["OtherfacilityCD4Percent"].ToString());
ClsUtility.AddParameters("@OtherfacilityWeight", SqlDbType.Decimal, ht["OtherfacilityrWeight"].ToString());
ClsUtility.AddParameters("@OtherfacilityHeight", SqlDbType.Decimal, ht["OtherfacilityHeight"].ToString());
ClsUtility.AddParameters("@OtherfacilityClinicalStage", SqlDbType.Int, ht["OtherfacilityClinicalStage"].ToString());
ClsUtility.AddParameters("@dataquality", SqlDbType.Int, DataQualityFlag.ToString());
ClsUtility.AddParameters("@UserId", SqlDbType.Int, userID.ToString());
theDS = (DataSet)ARTCareSummaryMgr.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveUpdateARTCareSummaryNigeria", ClsDBUtility.ObjectEnum.DataSet);
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
return(retval);
}
//public int SaveNewLabType(string LabTypeName, int UserID)
//{
// try
// {
// this.Connection = DataMgr.GetConnection();
// this.Transaction = DataMgr.BeginTransaction(this.Connection);
// ClsObject LabManager = new ClsObject();
// LabManager.Connection = this.Connection;
// LabManager.Transaction = this.Transaction;
// oUtility.Init_Hashtable();
// oUtility.AddParameters("@LabTypeName", SqlDbType.VarChar, LabTypeName);
// oUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString());
// DataRow theDR;
// int RowsAffected = (Int32)LabManager.ReturnObject(oUtility.theParams, "pr_Admin_AddLabtype_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery);
// if (RowsAffected == 0)
// {
// MsgBuilder theBL = new MsgBuilder();
// theBL.DataElements["MessageText"] = "Error in Saving Lab type record. Try Again..";
// AppException.Create("#C1", theBL);
// }
// DataMgr.CommitTransaction(this.Transaction);
// DataMgr.ReleaseConnection(this.Connection);
// return Convert.ToInt32(RowsAffected);
// }
// catch
// {
// throw;
// }
// finally
// {
// if (this.Connection != null)
// DataMgr.ReleaseConnection(this.Connection);
// }
//}
//public int UpdateLabType(int LabTypeID, string LabTypeName, int UserID)
//{
// try
// {
// this.Connection = DataMgr.GetConnection();
// this.Transaction = DataMgr.BeginTransaction(this.Connection);
// ClsObject LabManager = new ClsObject();
// LabManager.Connection = this.Connection;
// LabManager.Transaction = this.Transaction;
// oUtility.Init_Hashtable();
// oUtility.AddParameters("@LabTypeName", SqlDbType.VarChar, LabTypeName);
// oUtility.AddParameters("@LabTypeID", SqlDbType.Int, LabTypeID.ToString());
// oUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString());
// DataRow theDR;
// int RowsAffected = (Int32)LabManager.ReturnObject(oUtility.theParams, "Pr_Admin_UpdateLabType_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery);
// if (RowsAffected == 0)
// {
// MsgBuilder theBL = new MsgBuilder();
// theBL.DataElements["MessageText"] = "Error in Saving Lab type record. Try Again..";
// AppException.Create("#C1", theBL);
// }
// DataMgr.CommitTransaction(this.Transaction);
// DataMgr.ReleaseConnection(this.Connection);
// return Convert.ToInt32(RowsAffected);
// }
// catch
// {
// throw;
// }
// finally
// {
// if (this.Connection != null)
// DataMgr.ReleaseConnection(this.Connection);
// }
//}
public DataTable UpdateLab(int LabID, string LabName, int LabDepartmentID, int LabTypeID, int UserID, int DeleteFlag, string DataType, decimal MaxBoundary, decimal MinBoundary, int LabValueId, int Sequence)
{
try
{
DataTable theAffectedDT;
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject LabManager = new ClsObject();
LabManager.Connection = this.Connection;
LabManager.Transaction = this.Transaction;
oUtility.Init_Hashtable();
oUtility.AddParameters("@LabName", SqlDbType.VarChar, LabName);
oUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString());
oUtility.AddParameters("@LabDepartmentId", SqlDbType.Int, LabDepartmentID.ToString());
oUtility.AddParameters("@LabTypeId", SqlDbType.Int, LabTypeID.ToString());
oUtility.AddParameters("@LabTestId", SqlDbType.Int, LabID.ToString());
oUtility.AddParameters("@DeleteFlag", SqlDbType.Int, DeleteFlag.ToString());
oUtility.AddParameters("@DataType", SqlDbType.NVarChar, DataType.ToString());
oUtility.AddParameters("@MaxBoundary", SqlDbType.Decimal, MaxBoundary.ToString());
oUtility.AddParameters("@MinBoundary", SqlDbType.Decimal, MinBoundary.ToString());
oUtility.AddParameters("@LabValueId", SqlDbType.Int, LabValueId.ToString());
oUtility.AddParameters("@Sequence", SqlDbType.Int, Sequence.ToString());
//DataRow theDR;
theAffectedDT = (DataTable)LabManager.ReturnObject(oUtility.theParams, "Pr_Admin_UpdateLabTest_Constella", ClsUtility.ObjectEnum.DataTable);
if (theAffectedDT.Rows[0][0].ToString() == "-1")
{
MsgBuilder theBL = new MsgBuilder();
theBL.DataElements["MessageText"] = "Error in Saving Lab test record. Try Again..";
AppException.Create("#C1", theBL);
}
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
return(theAffectedDT);
}
catch
{
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
private void RPC_06_11(NetMessage arg1, NetMessageInfo arg2)
{
int itemID = arg1.ReadInt32();
int amount = arg1.ReadInt32();
byte islot = arg1.ReadByte();
MapPlayer player = _server[arg2.Sender.Id];
if (player.Shop == this && DataMgr.Select(itemID, out DB_Item item) && (item.Flags & ItemFlags.Salable) > 0 && player.Items.HasInSlot(islot, itemID, amount))
{
player.Items.RemoveFromSlot(islot, amount);
player.Char.Data.Bits += (item.Price * amount);
player.View.SetBits(player.Char.Data.Bits);
}
}
// Update is called once per frame
void Update()
{
timer += Time.deltaTime;
if (timer >= timegap)
{
DataMgr.Instance().CalcPrice();
CalcPoint();
lineRenderer.SetPositions(PointArray);
/* MoveCamera();*/
timer = 0;
UIMgr uiMgr = FindObjectOfType <UIMgr>();
uiMgr.m_price.text = DataMgr.Instance().curprice.ToString("f2");
}
}
/// <summary>
/// Gets the report queries.
/// </summary>
/// <param name="reportId">The report identifier.</param>
/// <returns></returns>
/// <exception cref="System.NotImplementedException"></exception>
QueryCollection IReportIQTools.GetReportQueries(int reportId)
{
try
{
QueryCollection qCollection = new QueryCollection();
ClsObject ReportManager = new ClsObject();
ClsUtility.Init_Hashtable();
string queryStatement;
DataMgr dataManager = new DataMgr();
ClsUtility.AddParameters("@ReportID", SqlDbType.Int, reportId.ToString());
queryStatement = @"Select Distinct Q.QryID QueryID,
SB.sbCatID SubCategoryID,
SB.sbCategory SubCategory,
Q.qryName QueryName,
Q.qryDefinition Defination,
Q.qryDescription Description
From dbo.aa_sbCategory SB
Inner Join aa_Category C
On SB.CatID = C.CatID
Inner Join dbo.aa_Queries Q On Q.qryID = SB.QryID
Where (SB.DeleteFlag Is Null Or SB.DeleteFlag = 0)
And SB.QryID Is Not Null
And C.CatID=@ReportID;";
DataTable dt = (DataTable)ReportManager.ReturnIQToolsObject(ClsUtility.theParams, queryStatement, ClsDBUtility.ObjectEnum.DataTable, ConnectionMode.REPORT);
if (dt == null)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
//Query q = new
qCollection.Add(new Query()
{
QueryID = Convert.ToInt16(row["QueryID"]),
Name = row["QueryName"].ToString(),
SubCategoryID = Convert.ToInt16(row["SubCategoryID"]),
SubCategory = row["SubCategory"].ToString(),
Defination = row["Defination"].ToString(),
Description = row["Description"].ToString()
});
}
;
return(qCollection);
}
catch (Exception ex)
{
throw ex;
}
}
public WO_NPC(WO_NPC original, MapPlayer owner)
: base(original._manager.GetNewGuid() | Constants.CRObject, original._manager)
{
_owner = owner;
_original = original;
_npc = original._npc;
_data = original._data;
if ((_npc.Flags & NPCFlags.Dialog) > 0)
{
_dialog = _server.Dialogs.GetClone(_npc.Dialog, owner);
}
if ((_npc.Flags & NPCFlags.Trader) > 0)
{
shop_ser = new SER_Shop(_npc.Items, $"{_npc.Pony.Name}'s shop");
}
if ((_npc.Flags & NPCFlags.Wears) > 0)
{
DB_Item entry; byte slot;
_wears = new Dictionary <int, InventoryItem>();
wears_ser = new SER_Wears(_wears);
foreach (var item in _npc.Wears)
{
if (item > 0 && DataMgr.Select(item, out entry))
{
slot = entry.Slot.ToWearableIndex();
if (_wears.ContainsKey(slot))
{
ServerLogger.LogWarn($"NPC id {_data.ObjectID} duplicate wear slot {entry.Slot}");
}
else
{
_wears[slot] = new InventoryItem(item);
}
}
}
}
OnSpawn += WO_NPC_OnSpawn;
OnDespawn += WO_NPC_OnDespawn;
OnDestroy += WO_NPC_OnDestroy;
if ((_npc.Flags & NPCFlags.ScriptedMovement) > 0)
{
AddComponent(new ScriptedMovement(original._movement as ScriptedMovement, this));
}
else
{
AddComponent(new NullMovement(this));
}
m_char = new Character(_npc.ID, -1, _npc.Level, -1, _npc.Pony, null);
Spawn();
}
/// <summary>
/// Imports the reports from iq tools.
/// </summary>
/// <param name="overwrite">if set to <c>true</c> [overwrite].</param>
/// <exception cref="System.NotImplementedException"></exception>
public void ImportReportsFromIQTools(bool overwrite = false)
{
lock (this)
{
ClsObject ReportManager = new ClsObject();
ClsUtility.Init_Hashtable();
string queryStatement;
DataMgr dataManager = new DataMgr();
// string sourceDB = dataManager.Reports_DatabaseName;
// string destinationDB = dataManager.EMR_DatabaseName;
//if (overwrite)
//{
// queryStatement = "Truncate table dbo.IQToolsExcelReports";
// ReportManager.ReturnObject(ClsUtility.theParams, queryStatement, ClsUtility.ObjectEnum.ExecuteNonQuery);
// ReportManager.Connection = null;
//}
queryStatement = @"SELECT catID,Category FROM aa_Category WHERE excel=1;";
DataTable dt = (DataTable)ReportManager.ReturnIQToolsObject(ClsUtility.theParams, queryStatement, ClsDBUtility.ObjectEnum.DataTable, ConnectionMode.REPORT);
if (dt != null)
{
ReportManager.Connection = null;
dt.TableName = "reports";
//dt.Namespace = "fromiqtools";
System.IO.StringWriter writer = new System.IO.StringWriter();
dt.WriteXml(writer, true);
queryStatement = "pr_IQTools_ImportReports";
// @"Insert Into dbo.IQToolsExcelReports(IQToolsCaTID,ReportName,ReportStylesheet)
// Select
// a.c.value('catID[1]','int'),
// a.c.Category('Category[1]','varchar(200)')
// From @x.nodes(//reports) a(c);";
ClsUtility.Init_Hashtable();
if (overwrite)
{
ClsUtility.AddParameters("@overwrite", SqlDbType.Bit, (overwrite) ? "1" : "0");
}
ClsUtility.AddParameters("@data", SqlDbType.Xml, writer.ToString());
ReportManager.ReturnObject(ClsUtility.theParams, queryStatement, ClsDBUtility.ObjectEnum.ExecuteNonQuery);
}
// return (DataSet)ReportManager.ReturnObject(ClsUtility.theParams, "pr_Reports_Patient_Constella", ClsUtility.ObjectEnum.DataSet);
}
}
private void UnwearItem(WornSlot wslot, byte islot)
{
DB_Item item; InventoryItem witem;
var index = wslot.Index;
if (m_wears.TryGetValue(index, out witem))
{
if (DataMgr.Select(witem.Id, out item))
{
int itemSlot = islot;
if (!GetInventorySlot(islot).IsEmpty)
{
itemSlot = GetFreeSlot();
}
if (itemSlot != -1)
{
if (SetSlot(itemSlot, item, witem, 1) == 0)
{
m_wears.Remove(index);
m_wearSlotsUsed &= ~wslot.Position;
m_view.UnwearItem(wslot.Value, m_wearSlotsUsed);
if ((item.Flags & ItemFlags.Stats) > 0)
{
_mPlayer.Stats.UpdateStats();
}
}
else
{
_player.SystemMsg($"Couldn't unwear item {item.Name}");
m_view.WearItem(witem, wslot.Value, m_wearSlotsUsed);
}
}
else
{
_player.SystemMsg($"You inventory is full");
m_view.WearItem(witem, wslot.Value, m_wearSlotsUsed);
}
}
else
{
_player.SystemMsg($"Item {witem.Id} not found");
m_view.WearItem(witem, wslot.Value, m_wearSlotsUsed);
}
}
else
{
_player.SystemMsg($"Wear slot {wslot.Position} is empty");
}
}
/// <summary>
/// Updates the patientppointment details.
/// </summary>
/// <param name="AppointmentId">The appointment identifier.</param>
/// <param name="AppDate">The application date.</param>
/// <param name="AppReasonId">The application reason identifier.</param>
/// <param name="UserId">The user identifier.</param>
/// <param name="AppProviderId">The application provider identifier.</param>
/// <param name="Updationdate">The updationdate.</param>
/// <param name="ModuleId">The module identifier.</param>
/// <param name="AppNote">The application note.</param>
/// <returns></returns>
public int UpdatePatientppointmentDetails(int AppointmentId, DateTime AppDate, int AppReasonId, int UserId, int AppProviderId, DateTime Updationdate, int?ModuleId = null, string AppNote = "")
{
lock (this)
{
try
{
int theAffectedRows = 0;
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject obj = new ClsObject();
obj.Connection = this.Connection;
obj.Transaction = this.Transaction;
ClsUtility.Init_Hashtable();
ClsUtility.AddExtendedParameters("@AppointmentId", SqlDbType.Int, AppointmentId);
ClsUtility.AddExtendedParameters("@AppDate", SqlDbType.DateTime, AppDate);
ClsUtility.AddExtendedParameters("@AppReasonId", SqlDbType.Int, AppReasonId);
ClsUtility.AddExtendedParameters("@UserId", SqlDbType.Int, UserId);
ClsUtility.AddExtendedParameters("@AppProviderId", SqlDbType.Int, AppProviderId);
ClsUtility.AddExtendedParameters("@Updationdate", SqlDbType.DateTime, Updationdate);
if (ModuleId.HasValue)
{
ClsUtility.AddExtendedParameters("@ModuleId", SqlDbType.Int, ModuleId.Value);
}
if (AppNote != "")
{
ClsUtility.AddParameters("@AppNote", SqlDbType.VarChar, AppNote);
}
theAffectedRows = (int)obj.ReturnObject(ClsUtility.theParams, "pr_Scheduler_UpdatePatientAppointmentDetails_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery);
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
return(theAffectedRows);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
}
public int SaveCustomFieldValues(string sqlstr)
{
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject CustomFields = new ClsObject();
CustomFields.Connection = this.Connection;
CustomFields.Transaction = this.Transaction;
oUtility.Init_Hashtable();
oUtility.AddParameters("@QryString", SqlDbType.VarChar, sqlstr);
int RowsAffected = (Int32)CustomFields.ReturnObject(oUtility.theParams, "pr_General_Dynamic_Insert", ClsUtility.ObjectEnum.ExecuteNonQuery);
/*
* if (RowsAffected == 0)
* {
* MsgBuilder theBL = new MsgBuilder();
* theBL.DataElements["MessageText"] = "Error in Saving Custom Fields record. Try Again..";
* AppException.Create("#C1", theBL);
* }
* else
* {
* MsgBuilder theBL = new MsgBuilder();
* theBL.DataElements["MessageText"] = "Saved Custom Fields record...";
* AppException.Create("#C1", theBL);
* }
*/
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
return(RowsAffected);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
public int SaveKNHMEILabResult(DataTable theDT, int userId, int PatientId, int VisitId)
{
ClsObject KNHMEIManager = new ClsObject();
int retlab = 0;
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
KNHMEIManager.Connection = this.Connection;
KNHMEIManager.Transaction = this.Transaction;
oUtility.Init_Hashtable();
oUtility.AddParameters("@patientid", SqlDbType.Int, PatientId.ToString());
oUtility.AddParameters("@Visit_ID", SqlDbType.Int, VisitId.ToString());
retlab = (int)KNHMEIManager.ReturnObject(oUtility.theParams, "pr_Clinical_DeleteKNHMEILabResult_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery);
foreach (DataRow theDR in theDT.Rows)
{
oUtility.Init_Hashtable();
oUtility.AddParameters("@patientid", SqlDbType.Int, PatientId.ToString());
oUtility.AddParameters("@LabVisitID", SqlDbType.Int, theDR["LabVisitId"].ToString());
oUtility.AddParameters("@Visit_ID", SqlDbType.Int, VisitId.ToString());
oUtility.AddParameters("@ParameterId", SqlDbType.Int, theDR["ParameterID"].ToString());
oUtility.AddParameters("@PrevResult", SqlDbType.VarChar, theDR["PrevResult"].ToString());
oUtility.AddParameters("@PrevResultDate", SqlDbType.VarChar, theDR["PrevResultDate"].ToString());
oUtility.AddParameters("@UserId", SqlDbType.Int, userId.ToString());
retlab = (int)KNHMEIManager.ReturnObject(oUtility.theParams, "pr_Clinical_SaveKNHMEILabResult_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery);
}
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
KNHMEIManager = null;
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
return(retlab);
}
public void SavePharmacyRefill_Web(DataTable dt, int iserId, int dispensedBy, string DispensedByDate, string deleteScript)
{
DataTable thePharmacyDT = new DataTable();
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject theManager = new ClsObject();
foreach (DataRow theDR in dt.Rows)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@ptn_pharmacy_pk", SqlDbType.Int, theDR["orderId"].ToString());
ClsUtility.AddParameters("@drug_pk", SqlDbType.Int, theDR["DrugId"].ToString());
ClsUtility.AddParameters("@batchid", SqlDbType.Int, theDR["BatchId"].ToString());
//ClsUtility.AddParameters("@DispensedQuantity", SqlDbType.Decimal, theDR["RefillQty"].ToString() == "" ? "0" : theDR["RefillQty"].ToString());
ClsUtility.AddParameters("@DispensedQuantity", SqlDbType.Decimal, theDR["QtyDispensed"].ToString() == "" ? "0" : theDR["QtyDispensed"].ToString());
ClsUtility.AddParameters("@DispensedBy", SqlDbType.Int, dispensedBy.ToString());
if (DispensedByDate.ToString() != "")
{
ClsUtility.AddParameters("@DispensedByDate", SqlDbType.VarChar, DispensedByDate.ToString());
}
ClsUtility.AddParameters("@PrintPrescriptionStatus", SqlDbType.Int, theDR["PrintPrescriptionStatus"].ToString() == "True" ? "1" : "0");
ClsUtility.AddParameters("@comments", SqlDbType.Int, theDR["comments"].ToString());
if (deleteScript != "")
{
ClsUtility.AddParameters("@deleteScript", SqlDbType.VarChar, deleteScript);
}
theManager.ReturnObject(ClsUtility.theParams, "pr_SCM_SavePharmacyPartialDispense_Web", ClsDBUtility.ObjectEnum.DataTable);
}
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
public ScriptedMovement(ushort id, CreatureObject parent)
: base(parent)
{
_state = 0;
_entry = new SyncEntry();
_direction = Vector3.UnitZ;
_position = _creature.SpawnPosition;
_rotation = _creature.SpawnRotation.ToRadians();
if (DataMgr.Select(id, out _entries))
{
Execute();
}
parent.OnSpawn += ScriptedMovement_OnSpawn;
parent.OnDestroy += ScriptedMovement_OnDestroy;
}
// Use this for initialization
void Start()
{
//这里控制是否使用数据库
useDb = false;
// 初始化计时时间
statusTime = Time.time;
operationTime = Time.time;
AllTanks = topController.AllPlayers;
manager = new DataMgr();
manager.Initial();
if (useDb && PhotonNetwork.isMasterClient)
{
manager.GetGameId();
}
}
public WO_Switch(DB_WorldObject data, ObjectsMgr manager)
: base(data, manager)
{
if (!DataMgr.Select(data.Data01, out m_map))
{
ServerLogger.LogError($"Map Switch {data.Guid} map {data.Data01} doesn't exist");
}
else
{
m_view = _server.Room.SceneViewManager.CreateNetworkedSceneObjectView(_data.Guid);
m_view.SubscribeToRpc(1, RPC_001);
OnDestroy += WO_Switch_OnDestroy;
}
Spawn();
}
public void SetPar(Transform trans, EquipModel item)
{
GameObject go = GameObject.Instantiate(itemPrefab);
go.transform.SetParent(trans);
go.GetComponent <RectTransform>().sizeDelta = new Vector2(50, 50);
go.transform.localPosition = Vector3.zero;
go.transform.localScale = Vector3.one;
Sprite tempSprite = Resources.Load <Sprite>("Image/" + item.Id);
go.GetComponent <Image>().sprite = tempSprite;
Item gm = DataMgr.GetInstance().GetItemByID(item.Id);
go.GetComponent <BagItem>().Init(gm, tempSprite);
}
// Update is called once per frame
IEnumerator TimeCountDown()
{
while (TotalTime >= 0)
{
m_time.text = TotalTime.ToString();
yield return(new WaitForSeconds(1));
TotalTime--;
}
if (TotalTime <= 0)
{
DataMgr.Instance().Init();
SceneManager.LoadScene(1);
}
}
private void AddChars()
{
List <Character> allChar = Fight.Inst.GetAllCharacter(attacker.camp);
for (int num = 0; num < MaxNum && slots.Count > 0;)
{
int id = Buff;
HeroData jsd_hero = DataMgr.GetHero(id);
if (jsd_hero != null)
{
Monster monster = new Monster();
monster.LV = attacker.lv;
monster.STRENGTHENID = attacker.strengthenid;
monster.Data = jsd_hero;
int idx = Fight.Rand(0, slots.Count);
int slot = slots[idx];
Character c = Character.Create(monster);
c.isFenLie = true;
c.SetCamp(attacker.camp);
c.InitUI();
c.slot = slot;
c.SrcPos = Fight.Inst.GetSlotPos(c.camp, slot);
if (c.camp == CampType.Friend)
{
c.SrcRotation = Quaternion.Euler(new Vector3(0, 90f, 0));
c.direction = new Vector3(1f, 0f, 0f);
}
else
{
c.SrcRotation = Quaternion.Euler(new Vector3(0, -90f, 0));
c.direction = new Vector3(-1f, 0f, 0f);
}
c.position = attacker.position;
c.ReqPassiveSkill();
c.visible = false;
addChars.Add(c);
allChar.Add(c);
slots.RemoveAt(idx);
++num;
}
}
Fight.Inst.SortAllChar(attacker.camp);
}
public int DeleteCustomFields(int CustomFieldID, int DFlag)
{
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject CustomFields = new ClsObject();
CustomFields.Connection = this.Connection;
CustomFields.Transaction = this.Transaction;
oUtility.Init_Hashtable();
oUtility.AddParameters("@CustomFieldID", SqlDbType.Int, CustomFieldID.ToString());
oUtility.AddParameters("@ActivateFlag", SqlDbType.Int, DFlag.ToString());
int RowsAffected = (Int32)CustomFields.ReturnObject(oUtility.theParams, "pr_Admin_DeleteCustomField_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery);
/*
* if (RowsAffected == 0)
* {
* MsgBuilder theBL = new MsgBuilder();
* theBL.DataElements["MessageText"] = "Error in Deleting Custom Fields record. Try Again..";
* AppException.Create("#C1", theBL);
* }
* else
* {
*
* }
*/
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
return(RowsAffected);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
public void SavePharmacyRefill_Web(DataTable dt, int iserId, DateTime DispensedByDate, int patientID, int locationID, string appointmentDate, int userID, int empID)
{
DataTable thePharmacyDT = new DataTable();
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject theManager = new ClsObject();
foreach (DataRow theDR in dt.Rows)
{
oUtility.Init_Hashtable();
oUtility.AddParameters("@ptn_pharmacy_pk", SqlDbType.Int, theDR["orderId"].ToString());
oUtility.AddParameters("@drug_pk", SqlDbType.Int, theDR["DrugId"].ToString());
oUtility.AddParameters("@batchid", SqlDbType.VarChar, theDR["BatchId"].ToString());
oUtility.AddParameters("@DispensedQuantity", SqlDbType.VarChar, theDR["RefillQty"].ToString());
oUtility.AddParameters("@DispensedBy", SqlDbType.Int, iserId.ToString());
oUtility.AddParameters("@DispensedByDate", SqlDbType.DateTime, DispensedByDate.ToString());
oUtility.AddParameters("@comments", SqlDbType.VarChar, theDR["comments"].ToString());
oUtility.AddParameters("@Ptn_Pk", SqlDbType.Int, patientID.ToString());
oUtility.AddParameters("@LocationId", SqlDbType.Int, locationID.ToString());
oUtility.AddParameters("@AppointmentDate", SqlDbType.VarChar, appointmentDate.ToString());
oUtility.AddParameters("@UserId", SqlDbType.Int, userID.ToString());
oUtility.AddParameters("@EmpID", SqlDbType.Int, empID.ToString());
oUtility.AddParameters("@PillCount", SqlDbType.VarChar, theDR["PillCount"].ToString());
theManager.ReturnObject(oUtility.theParams, "pr_SCM_SavePharmacyPartialDispense_Web", ClsUtility.ObjectEnum.DataTable);
}
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
public int SaveAllergyInfo(int Id, int Ptn_Pk, string AllergyType, string Allergen, string otherAllergen, string severity, string typeReaction, int UserId, int DeleteFlag, string dataAllergy)
{
ClsObject FamilyInfo = new ClsObject();
int retval = 0;
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
FamilyInfo.Connection = this.Connection;
FamilyInfo.Transaction = this.Transaction;
oUtility.Init_Hashtable();
oUtility.AddParameters("@Id", SqlDbType.Int, Id.ToString());
oUtility.AddParameters("@Ptn_pk", SqlDbType.Int, Ptn_Pk.ToString());
oUtility.AddParameters("@vAllergyType", SqlDbType.VarChar, AllergyType.ToString());
oUtility.AddParameters("@vAllergen", SqlDbType.VarChar, Allergen.ToString());
oUtility.AddParameters("@votherAllergen", SqlDbType.VarChar, otherAllergen.ToString());
oUtility.AddParameters("@vTypeReaction", SqlDbType.VarChar, typeReaction.ToString());
oUtility.AddParameters("@vSeverity", SqlDbType.VarChar, severity.ToString());
oUtility.AddParameters("@UserId", SqlDbType.Int, UserId.ToString());
oUtility.AddParameters("@DeleteFlag", SqlDbType.Int, DeleteFlag.ToString());
oUtility.AddParameters("@DBKey", SqlDbType.VarChar, ApplicationAccess.DBSecurity);
//if (dataAllergy.DayOfYear != 1)
//{
oUtility.AddParameters("@vDataAllergy", SqlDbType.VarChar, dataAllergy.ToString());
//}
retval = (int)FamilyInfo.ReturnObject(oUtility.theParams, "Pr_Clinical_SaveAllergyInfo", ClsUtility.ObjectEnum.ExecuteNonQuery);
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
FamilyInfo = null;
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
return(retval);
}
/// <summary>
/// 获取单利对象
/// </summary>
/// <returns></returns>
public static DataMgr getInstance()
{
if (g_instance == null)
{
g_instance = new DataMgr();
}
return g_instance;
}
void Awake()
{
// 싱글턴 인스턴스 할당
instance = this;
}
void Awake ()
{
instance = this;
}
