public int HandlePacket(GameClient client, GSPacketIn packet) { if (client.Player.PlayerCharacter.ConsortiaID == 0) return 0; //int id = packet.ReadInt(); string name = packet.ReadString(); bool result = false; string msg = "ConsortiaInviteAddHandler.Failed"; if(string.IsNullOrEmpty(name)) return 0; using (ConsortiaBussiness db = new ConsortiaBussiness()) { ConsortiaInviteUserInfo info = new ConsortiaInviteUserInfo(); info.ConsortiaID = client.Player.PlayerCharacter.ConsortiaID; info.ConsortiaName = client.Player.PlayerCharacter.ConsortiaName; info.InviteDate = DateTime.Now; info.InviteID = client.Player.PlayerCharacter.ID; info.InviteName = client.Player.PlayerCharacter.NickName; info.IsExist = true; info.Remark = ""; info.UserID = 0; info.UserName = name; if (db.AddConsortiaInviteUsers(info, ref msg)) { msg = "ConsortiaInviteAddHandler.Success"; result = true; GameServer.Instance.LoginServer.SendConsortiaInvite(info.ID, info.UserID, info.UserName, info.InviteID, info.InviteName, info.ConsortiaName,info.ConsortiaID); } } packet.WriteBoolean(result); packet.WriteString(LanguageMgr.GetTranslation(msg)); client.Out.SendTCP(packet); return 0; }
public bool AddConsortiaInviteUsers(ConsortiaInviteUserInfo info, ref string msg) { bool result = false; try { SqlParameter[] para = new SqlParameter[11]; para[0] = new SqlParameter("@ID", info.ID); para[0].Direction = ParameterDirection.InputOutput; para[1] = new SqlParameter("@ConsortiaID", info.ConsortiaID); para[2] = new SqlParameter("@ConsortiaName", info.ConsortiaName == null ? "" : info.ConsortiaName); para[3] = new SqlParameter("@InviteDate", info.InviteDate); para[4] = new SqlParameter("@InviteID", info.InviteID); para[5] = new SqlParameter("@InviteName", info.InviteName == null ? "" : info.InviteName); para[6] = new SqlParameter("@IsExist", info.IsExist); para[7] = new SqlParameter("@Remark", info.Remark == null ? "" : info.Remark); para[8] = new SqlParameter("@UserID", info.UserID); para[8].Direction = ParameterDirection.InputOutput; para[9] = new SqlParameter("@UserName", info.UserName == null ? "" : info.UserName); para[10] = new SqlParameter("@Result", System.Data.SqlDbType.Int); para[10].Direction = ParameterDirection.ReturnValue; result = db.RunProcedure("SP_ConsortiaInviteUser_Add", para); info.ID = (int)para[0].Value; info.UserID = (int)para[8].Value; int returnValue = (int)para[10].Value; result = returnValue == 0; switch (returnValue) { case 2: msg = "ConsortiaBussiness.AddConsortiaInviteUsers.Msg2"; break; case 4: msg = "ConsortiaBussiness.AddConsortiaInviteUsers.Msg4"; break; case 5: msg = "ConsortiaBussiness.AddConsortiaInviteUsers.Msg5"; break; case 6: msg = "ConsortiaBussiness.AddConsortiaInviteUsers.Msg6"; break; } } catch (Exception e) { if (log.IsErrorEnabled) log.Error("Init", e); } finally { } return result; }
public ConsortiaInviteUserInfo[] GetConsortiaInviteUserPage(int page, int size, ref int total, int order, int userID, int inviteID) { List<ConsortiaInviteUserInfo> infos = new List<ConsortiaInviteUserInfo>(); try { string sWhere = " IsExist=1 "; if (userID != -1) { sWhere += " and UserID =" + userID + " "; } if (inviteID != -1) { sWhere += " and UserID =" + inviteID + " "; } string sOrder = "ConsortiaName"; switch (order) { case 1: sOrder = "Repute"; break; case 2: sOrder = "ChairmanName"; break; case 3: sOrder = "Count"; break; case 4: sOrder = "CelebCount"; break; case 5: sOrder = "Honor"; break; } sOrder += ",ID "; DataTable dt = GetPage("V_Consortia_Invite", sWhere, page, size, "*", sOrder, "ID", ref total); foreach (DataRow dr in dt.Rows) { ConsortiaInviteUserInfo info = new ConsortiaInviteUserInfo(); info.ID = (int)dr["ID"]; info.CelebCount = (int)dr["CelebCount"]; info.ChairmanName = dr["ChairmanName"].ToString(); info.ConsortiaID = (int)dr["ConsortiaID"]; info.ConsortiaName = dr["ConsortiaName"].ToString(); info.Count = (int)dr["Count"]; info.Honor = (int)dr["Honor"]; info.InviteDate = (DateTime)dr["InviteDate"]; info.InviteID = (int)dr["InviteID"]; info.InviteName = dr["InviteName"].ToString(); info.IsExist = (bool)dr["IsExist"]; info.Remark = dr["Remark"].ToString(); info.Repute = (int)dr["Repute"]; info.UserID = (int)dr["UserID"]; info.UserName = dr["UserName"].ToString(); infos.Add(info); } } catch (Exception e) { if (log.IsErrorEnabled) log.Error("Init", e); } finally { } return infos.ToArray(); }
public static XElement CreateConsortiaInviteUserInfo(ConsortiaInviteUserInfo info) { return new XElement("Item", new XAttribute("ID", info.ID), new XAttribute("CelebCount", info.CelebCount), new XAttribute("ChairmanName", info.ChairmanName == null ? "" : info.ChairmanName), new XAttribute("ConsortiaID", info.ConsortiaID), new XAttribute("ConsortiaName", info.ConsortiaName == null ? "" : info.ConsortiaName), new XAttribute("Count", info.Count), new XAttribute("Honor", info.Honor), new XAttribute("InviteDate", info.InviteDate), new XAttribute("InviteID", info.InviteID), new XAttribute("InviteName", info.InviteName == null ? "" : info.InviteName), new XAttribute("Remark", info.Remark == null ? "" : info.Remark), new XAttribute("Repute", info.Repute), new XAttribute("UserID", info.UserID), new XAttribute("UserName", info.UserName == null ? "" : info.UserName)); }