public int HandlePacket(GameClient client, GSPacketIn packet) { if (client.Player.PlayerCharacter.ConsortiaID == 0) return 0; int id = packet.ReadInt(); bool isAlly = packet.ReadBoolean(); bool result = false; string msg = "ConsortiaApplyAllyAddHandler.Add_Failed"; using (ConsortiaBussiness db = new ConsortiaBussiness()) { ConsortiaApplyAllyInfo info = new ConsortiaApplyAllyInfo(); info.Consortia1ID = client.Player.PlayerCharacter.ConsortiaID; info.Consortia2ID = id; info.Date = DateTime.Now; info.State = 0;// isAlly ? 1 : 0; info.Remark = ""; info.IsExist = true; if (db.AddConsortiaApplyAlly(info, client.Player.PlayerCharacter.ID, ref msg)) { msg = "ConsortiaApplyAllyAddHandler.Add_Success"; result = true; } } packet.WriteBoolean(result); packet.WriteString(LanguageMgr.GetTranslation(msg)); client.Out.SendTCP(packet); return 0; }
public ConsortiaApplyAllyInfo[] GetConsortiaApplyAllyPage(int page, int size, ref int total, int order, int consortiaID, int applyID, int state) { List<ConsortiaApplyAllyInfo> infos = new List<ConsortiaApplyAllyInfo>(); try { string sWhere = " IsExist=1 "; if (consortiaID != -1) { sWhere += " and Consortia2ID =" + consortiaID + " "; } if (applyID != -1) { sWhere += " and ID =" + applyID + " "; } if (state != -1) { sWhere += " and State =" + state + " "; } string sOrder = "ConsortiaName"; switch (order) { case 1: sOrder = "Repute"; break; case 2: sOrder = "ChairmanName"; break; case 3: sOrder = "Count"; break; case 4: sOrder = "Level"; break; case 5: sOrder = "Honor"; break; } sOrder += ",ID "; DataTable dt = GetPage("V_Consortia_Apply_Ally", sWhere, page, size, "*", sOrder, "ID", ref total); foreach (DataRow dr in dt.Rows) { ConsortiaApplyAllyInfo info = new ConsortiaApplyAllyInfo(); info.ID = (int)dr["ID"]; info.CelebCount = (int)dr["CelebCount"]; info.ChairmanName = dr["ChairmanName"].ToString(); info.Consortia1ID = (int)dr["Consortia1ID"]; info.Consortia2ID = (int)dr["Consortia2ID"]; info.ConsortiaName = dr["ConsortiaName"].ToString(); info.Count = (int)dr["Count"]; info.Date = (DateTime)dr["Date"]; info.Honor = (int)dr["Honor"]; info.IsExist = (bool)dr["IsExist"]; info.Remark = dr["Remark"].ToString(); info.Repute = (int)dr["Repute"]; info.State = (int)dr["State"]; info.Level = (int)dr["Level"]; info.Description = dr["Description"] == null ? "" : dr["Description"].ToString(); infos.Add(info); } } catch (Exception e) { if (log.IsErrorEnabled) log.Error("Init", e); } finally { } return infos.ToArray(); }
public bool AddConsortiaApplyAlly(ConsortiaApplyAllyInfo info, int userID, ref string msg) { bool result = false; try { SqlParameter[] para = new SqlParameter[9]; para[0] = new SqlParameter("@ID", info.ID); para[0].Direction = ParameterDirection.InputOutput; para[1] = new SqlParameter("@Consortia1ID", info.Consortia1ID); para[2] = new SqlParameter("@Consortia2ID", info.Consortia2ID); para[3] = new SqlParameter("@Date", info.Date); para[4] = new SqlParameter("@Remark", info.Remark); para[5] = new SqlParameter("@IsExist", info.IsExist); para[6] = new SqlParameter("@UserID", userID); para[7] = new SqlParameter("@State", info.State); para[8] = new SqlParameter("@Result", System.Data.SqlDbType.Int); para[8].Direction = ParameterDirection.ReturnValue; result = db.RunProcedure("SP_ConsortiaApplyAlly_Add", para); info.ID = (int)para[0].Value; int returnValue = (int)para[8].Value; result = returnValue == 0; switch (returnValue) { case 2: msg = "ConsortiaBussiness.AddConsortiaApplyAlly.Msg2"; break; case 3: msg = "ConsortiaBussiness.AddConsortiaApplyAlly.Msg3"; break; case 4: msg = "ConsortiaBussiness.AddConsortiaApplyAlly.Msg4"; break; } } catch (Exception e) { if (log.IsErrorEnabled) log.Error("Init", e); } finally { } return result; }
public static XElement CreateConsortiaApplyAllyInfo(ConsortiaApplyAllyInfo 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.Consortia1ID), //new XAttribute("Consortia2ID", info.Consortia2ID), new XAttribute("ConsortiaName", info.ConsortiaName == null ? "" : info.ConsortiaName), new XAttribute("Count", info.Count), new XAttribute("Date", info.Date.ToString("yyyy-MM-dd HH:mm:ss")), new XAttribute("Honor", info.Honor), new XAttribute("Remark", info.Remark == null ? "" : info.Remark), new XAttribute("Level", info.Level), new XAttribute("Description", info.Description == null ? "" : info.Description), new XAttribute("Repute", info.Repute)); }