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));
}
