public void ReadConfig()
{
if (isLoadFinish == false)
{
return;
}
isLoadFinish = false;
lock (LockObject) { GameSystem.Instance.readConfigCnt += 1; }
Debug.Log("Config reading " + name);
string text = ResourceLoadManager.Instance.GetConfigText(name);
if (text == null)
{
Debug.LogError("LoadConfig failed: " + name);
return;
}
AnnouncementItems.Clear();
//读取以及处理XML文本的类
XmlDocument xmlDoc = CommonFunction.LoadXmlConfig(name, text);
//解析XML的过程
XmlNodeList nodelist = xmlDoc.SelectSingleNode("Data").ChildNodes;
foreach (XmlElement xe in nodelist)
{
XmlNode comment = xe.SelectSingleNode(GlobalConst.CONFIG_SWITCH_COLUMN);
if (comment != null && comment.InnerText == GlobalConst.CONFIG_SWITCH)
{
continue;
}
AnnouncementItem item = new AnnouncementItem();
foreach (XmlElement xel in xe)
{
if (xel.Name == "name")
{
item.title = xel.InnerText;
}
else if (xel.Name == "label")
{
item.label = xel.InnerText;
}
else if (xel.Name == "info")
{
item.info = xel.InnerText;
}
else if (xel.Name == "is_open")
{
uint.TryParse(xel.InnerText, out item.is_open);
}
else if (xel.Name == "version")
{
float.TryParse(xel.InnerText, out item.version);
}
}
AnnouncementItems.Add(item);
}
}
public AnnouncementItem GetOne(int ID)
{
var item = new AnnouncementItem();
string sql = "SELECT * FROM [newDB].[dbo].[event] WHERE id = @id";
SqlConnection conn = new SqlConnection(Constants.DBConnection);
SqlCommand MyCommand = new SqlCommand(sql, conn);
MyCommand.Parameters.AddWithValue("id", ID);
SqlDataReader MyReader;
conn.Open();
MyReader = MyCommand.ExecuteReader();
while (MyReader.Read())
{
item.ID = MyReader.GetInt32(MyReader.GetOrdinal("id"));
item.begin_time = MyReader.GetDateTime(MyReader.GetOrdinal("DateStart"));
item.end_time = MyReader.GetDateTime(MyReader.GetOrdinal("DateEnd"));
item.Subject = MyReader.GetString(MyReader.GetOrdinal("name"));
item.UrlImage = MyReader.GetString(MyReader.GetOrdinal("UrlImage"));
item.Content = MyReader.GetString(MyReader.GetOrdinal("content"));
item.DoiTuong = MyReader.GetString(MyReader.GetOrdinal("DoiTuong"));
item.ThoiGian = MyReader.GetString(MyReader.GetOrdinal("ThoiGian"));
item.GameID = MyReader.GetInt32(MyReader.GetOrdinal("GameID"));
item.DisplayOrder = MyReader.GetInt32(MyReader.GetOrdinal("DisplayOrder"));
item.begin_timestring = item.begin_time.ToString(Constants.DateFormat);
item.end_timestring = item.end_time.ToString(Constants.DateFormat);
}
MyReader.Close();
conn.Close();
return(item);
}
public List <AnnouncementItem> GetAll(int currentRecord = 0, int numberRecord = 10)
{
var lst = new List <AnnouncementItem>();
string sql = "SELECT * FROM [newDB].[dbo].[event] where [IsDelete] = 0 order by id desc OFFSET " + currentRecord + " ROWS FETCH NEXT " + numberRecord + "ROWS ONLY ";
SqlConnection conn = new SqlConnection(Constants.DBConnection);
SqlCommand MyCommand = new SqlCommand(sql, conn);
SqlDataReader MyReader;
conn.Open();
MyReader = MyCommand.ExecuteReader();
while (MyReader.Read())
{
var item = new AnnouncementItem
{
ID = MyReader.GetInt32(MyReader.GetOrdinal("id")),
DisplayOrder = MyReader.GetInt32(MyReader.GetOrdinal("DisplayOrder")),
begin_time = MyReader.GetDateTime(MyReader.GetOrdinal("DateStart")),
end_time = MyReader.GetDateTime(MyReader.GetOrdinal("DateEnd")),
Subject = MyReader.GetString(MyReader.GetOrdinal("name")),
Content = MyReader.GetString(MyReader.GetOrdinal("content")),
};
lst.Add(item);
}
MyReader.Close();
conn.Close();
return(lst);
}
static int GetOpenItem(IntPtr L)
{
LuaScriptMgr.CheckArgsCount(L, 1);
AnnouncementConfig obj = (AnnouncementConfig)LuaScriptMgr.GetNetObjectSelf(L, 1, "AnnouncementConfig");
AnnouncementItem o = obj.GetOpenItem();
LuaScriptMgr.PushObject(L, o);
return(1);
}
public ActionResult EditForm(int?id)
{
var obj = new AnnouncementItem();
if (id.HasValue)
{
obj = gamePlayerRepository.GetOneEventItem(id.Value);
}
return(Json(new
{
listGame = gamePlayerRepository.GetAllGame(),
data = obj
}, JsonRequestBehavior.AllowGet));
}
public ActionResult Action(AnnouncementItem objSubmit)
{
if (objSubmit.ID == 0)
{
gamePlayerRepository.InsertEvent(objSubmit.Subject, objSubmit.Content, objSubmit.begin_time, objSubmit.end_time, objSubmit.UrlImage, objSubmit.GameID, objSubmit.DoiTuong, objSubmit.ThoiGian, objSubmit.DisplayOrder);
}
else
{
gamePlayerRepository.UpdateEvent(objSubmit.ID, objSubmit.Subject, objSubmit.Content, objSubmit.begin_time, objSubmit.end_time, objSubmit.UrlImage, objSubmit.GameID, objSubmit.DoiTuong, objSubmit.ThoiGian, objSubmit.DisplayOrder);
}
return(Json(new
{
Error = false
}, JsonRequestBehavior.AllowGet));
}
static int _CreateAnnouncementItem(IntPtr L)
{
int count = LuaDLL.lua_gettop(L);
if (count == 0)
{
AnnouncementItem obj = new AnnouncementItem();
LuaScriptMgr.PushObject(L, obj);
return(1);
}
else
{
LuaDLL.luaL_error(L, "invalid arguments to method: AnnouncementItem.New");
}
return(0);
}
private bool OnCreateItem()
{
int maxnum = DataManager.AnnouncementTable.Count;
for (int id = 1; id < maxnum + 1; id++)
{
AnnouncementItem items = DataManager.AnnouncementTable[id] as AnnouncementItem;
if (items == null)
{
return(false);
}
ulong starTime = (ulong)ToSec(items.starttime);
ulong endTime = (ulong)ToSec(items.endtime);
ulong intervalTime = (ulong)items.interval;
ulong now = TimeUtilities.GetNow();
double nowsec = now / 1000;
ulong nowTime = (ulong)nowsec % (24 * 60 * 60);
double breakTime = (nowsec - starTime) % intervalTime;
if ((0 < endTime && nowTime > starTime && nowTime < endTime) || (0 >= endTime && nowTime > starTime))
{
if (breakTime < 1)
{
if (AnnounceItemManager.Instance.SetHide == false && (AnnounceItemManager.Instance.nextflag == true || AnnounceItemManager.Instance.ishide == true))
{
if (mContent.gameObject.activeSelf == false)
{
NGUITools.SetActive(mContent.gameObject, true);
}
mAnnounceItemNode = AnnounceItemManager.Instance.CreateAnnounceItem(items.describe);
mAnnounceItemNode.nextFlag = false;
AnnounceItemManager.Instance.nextflag = false;
AnnounceItemManager.Instance.ishide = false;
mAnnounceItemNode.Show();
return(true);
}
}
}
}
return(false);
}
/// <summary>
/// 每帧更新
/// </summary>
public void Update()
{
if (GameSystem.Instance.canLoadConfig)
{
GameSystem.Instance.canLoadConfig = false;
GameSystem.Instance.LoadConfig();
GameSystem.Instance.mClient.mUIManager.LoginCtrl.thread1.Start();
GameSystem.Instance.mClient.mUIManager.LoginCtrl.thread2.Start();
}
_time -= Time.deltaTime;
if (_time < 0)
{
Scheduler.Instance.RemoveUpdator(Update);
#if IOS_SDK || ANDROID_SDK
LoginNetwork.Instance.DoConnectToLS();
#endif
//_ui.ButtonOK.GetComponent<UIButton>().enabled = true;
//NGUITools.SetActive(_ui.ButtonOK.gameObject, true);
}
if (oncelogined == 1 &&
GameSystem.Instance.AnnouncementConfigData != null &&
GameSystem.Instance.AnnouncementConfigData.GetOpenItem() != null &&
!string.IsNullOrEmpty(DynamicStringManager.Instance.NoticePopupString)
)
{
//如果本地version和公告version不一致，弹出公告界面
AnnouncementItem anc = GameSystem.Instance.AnnouncementConfigData.GetOpenItem();
if (anc != null && LoginIDManager.GetAnnounceVersion() != anc.version)
{
showAnnounce();
LoginIDManager.SetAnnouceVersion(anc.version);
}
oncelogined = 2;
}
}
static int get_label(IntPtr L)
{
object o = LuaScriptMgr.GetLuaObject(L, 1);
AnnouncementItem obj = (AnnouncementItem)o;
if (obj == null)
{
LuaTypes types = LuaDLL.lua_type(L, 1);
if (types == LuaTypes.LUA_TTABLE)
{
LuaDLL.luaL_error(L, "unknown member name label");
}
else
{
LuaDLL.luaL_error(L, "attempt to index label on a nil value");
}
}
LuaScriptMgr.Push(L, obj.label);
return(1);
}
static int set_version(IntPtr L)
{
object o = LuaScriptMgr.GetLuaObject(L, 1);
AnnouncementItem obj = (AnnouncementItem)o;
if (obj == null)
{
LuaTypes types = LuaDLL.lua_type(L, 1);
if (types == LuaTypes.LUA_TTABLE)
{
LuaDLL.luaL_error(L, "unknown member name version");
}
else
{
LuaDLL.luaL_error(L, "attempt to index version on a nil value");
}
}
obj.version = (float)LuaScriptMgr.GetNumber(L, 3);
return(0);
}
static int set_info(IntPtr L)
{
object o = LuaScriptMgr.GetLuaObject(L, 1);
AnnouncementItem obj = (AnnouncementItem)o;
if (obj == null)
{
LuaTypes types = LuaDLL.lua_type(L, 1);
if (types == LuaTypes.LUA_TTABLE)
{
LuaDLL.luaL_error(L, "unknown member name info");
}
else
{
LuaDLL.luaL_error(L, "attempt to index info on a nil value");
}
}
obj.info = LuaScriptMgr.GetString(L, 3);
return(0);
}
public List <AnnouncementItem> GetAll()
{
var lst = new List <AnnouncementItem>();
string sql = "SELECT * FROM portal.announcement ORDER BY id DESC";
MySqlConnection conn = new MySqlConnection(Constants.DBConnection);
MySqlCommand MyCommand = new MySqlCommand(sql, conn);
MySqlDataReader MyReader;
conn.Open();
MyReader = MyCommand.ExecuteReader();
while (MyReader.Read())
{
var item = new AnnouncementItem();
item.ID = MyReader.GetInt32("id");
byte[] datasubject = Convert.FromBase64String(MyReader.GetString("subject"));
item.Subject = Encoding.UTF8.GetString(datasubject);
byte[] dataContent = Convert.FromBase64String(MyReader.GetString("content"));
item.Content = Encoding.UTF8.GetString(dataContent);
lst.Add(item);
}
MyReader.Close();
conn.Close();
return(lst);
}
protected void Page_Load(object sender, EventArgs e)
{
using (SqlConnection dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString))
{
if (dbconn.State == ConnectionState.Open)
{
dbconn.Close();
}
dbconn.Open();
var favoriteService = new FavoritesService();
if (Auth.Check())
//if (favoriteService.IsChurchAlreadyInFavorites(Auth.user().Id, churchh.SimbahanID))
{
//AddFav.Attributes.Add("style", "display: none;");
//RemoveFav.Attributes.Add("style", "display: block;");
}
if (Auth.Check())
{
Name.InnerHtml = Auth.user().FullName;
firstName.InnerHtml = Auth.user().FirstName;
lastName.InnerHtml = Auth.user().LastName;
email.InnerHtml = Auth.user().Email;
gender.InnerHtml = Auth.user().Gender;
birthday.InnerHtml = Auth.user().DateOfBirth;
if (Auth.user().RoleID == 3)
{
manage.Attributes["href"] = "#" + tab5.ClientID;
SqlCommand cmd = new SqlCommand("SELECT Simbahan.SimbahanID, Simbahan.Parish FROM Simbahan INNER JOIN ChurchRoles ON ChurchRoles.SimbahanID = Simbahan.SimbahanID WHERE ChurchRoles.RegID = '" + Auth.user().Id + "'", dbconn);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var li = new HtmlGenericControl("li");
li.InnerHtml = string.Format("<a href=\"{0}\">{1}</a>", "http://www.mycatholicportal.org/Churches?id=" + reader["SimbahanID"], reader["Parish"]);
ManageableChurch.Controls.Add(li);
}
tab5.Visible = true;
manage.Visible = true;
}
else
{
tab5.Visible = false;
manage.Visible = false;
}
var churches = favoriteService.GetFavoriteChurches(Auth.user().Id);
favoriteChurches.InnerHtml = "";
foreach (var church in churches)
{
var churchItem = new ChurchItem(church.SimbahanID, church.Parish, church.CompleteAddress,
church.ChurchPhotos[0].ChurchPhotos);
favoriteChurches.InnerHtml += churchItem.ToHtml();
}
var favoriteServices = new FavoritesService();
var announcements = favoriteServices.GetFavoriteAnnouncements(Auth.user().Id);
favoriteAnnouncements.InnerHtml = "";
foreach (var announcement in announcements)
{
var announcementItem = new AnnouncementItem(announcement.SimbahanId, announcement.Title, announcement.Venue,
announcement.ImagePath);
favoriteAnnouncements.InnerHtml += announcementItem.ToHtml();
}
var favoriteServicess = new FavoritesService();
var organnouncements = favoriteServices.GetFavoriteOrgAnnouncements(Auth.user().Id);
favoriteAnnouncementss.InnerHtml = "";
foreach (var organnouncement in organnouncements)
{
var announcementItem = new OrganizationAnnouncementItem(organnouncement.Id, organnouncement.OrganizationId, organnouncement.Title, organnouncement.Venue,
organnouncement.ImagePath);
favoriteAnnouncementss.InnerHtml += announcementItem.ToHtml();
}
var organizations = favoriteService.GetFavoriteOrganizations(Auth.user().Id);
favoriteOrganizations.InnerHtml = "";
foreach (var organization in organizations)
{
var organizationItem =
new OrganizationItem(organization.Id, organization.Name, organization.Address, "");
favoriteOrganizations.InnerHtml += organizationItem.ToHtml();
}
var verses = favoriteService.GetFavoriteBibleVerses(Auth.user().Id);
favoriteBibleVerses.InnerHtml = "";
foreach (var verse in verses)
{
var verseItem = new BibleVerseItem(verse);
favoriteBibleVerses.InnerHtml += verseItem.ToHtml();
}
var quotes = favoriteService.GetFavoriteReligiousQuotes(Auth.user().Id);
favoriteReligiousQuotes.InnerHtml = "";
foreach (var quote in quotes)
{
var quoteItem = new ReligiousQuoteItem(quote);
favoriteReligiousQuotes.InnerHtml += quoteItem.ToHtml();
}
var prayers = favoriteService.GetFavoriteBasicCatholicPrayer(Auth.user().Id);
favoriteBasicCatholicPrayers.InnerHtml = "";
foreach (var prayer in prayers)
{
var prayerItem = new BasicCatholicPrayerItem(prayer);
favoriteBasicCatholicPrayers.InnerHtml += prayerItem.ToHtml();
}
var devotes = favoriteService.GetFavoriteDevotion(Auth.user().Id);
favoriteDevotions.InnerHtml = "";
foreach (var devote in devotes)
{
var devoteItem = new DevotionItem(devote);
favoriteDevotions.InnerHtml += devoteItem.ToHtml();
}
var otps = favoriteService.GetFavoriteOtherCatholicPrayer(Auth.user().Id);
favoriteOtherCatholicPrayers.InnerHtml = "";
foreach (var otp in otps)
{
var otpItem = new OtherCatholicPrayerItem(otp);
favoriteOtherCatholicPrayers.InnerHtml += otpItem.ToHtml();
}
var saints = favoriteService.GetFavoriteSaint(Auth.user().Id);
favoriteSaints.InnerHtml = "";
//var favoriteService = new FavoritesService();
foreach (var saint in saints)
{
var saintItem = new SaintItem(saint);
favoriteSaints.InnerHtml += saintItem.ToHtml();
}
}
else
{
Response.Redirect("Login.aspx");
}
getUnreadDocuments();
countii();
}
}
public AnnouncementItem GetOpenItem()
{
AnnouncementItem ans = AnnouncementItems.Find(x => x.is_open == 1);
return(AnnouncementItems.Find(x => x.is_open == 1));
}
