public ReturnValue<USR_CustomerShow> AddComment(int AnswerSysNo, int CustomerSysNo, int QuestionSysNo, string Context)
{
QA_CommentMod m_comment = new QA_CommentMod();
m_comment.AnswerSysNo = AnswerSysNo;
m_comment.Context = AppCmn.CommonTools.SystemInputFilter(Context.DoTrim());
m_comment.DR = (int)AppEnum.State.normal;
m_comment.QuestionSysNo = QuestionSysNo;
m_comment.TS = DateTime.Now;
m_comment.CustomerSysNo = CustomerSysNo;
QA_CommentBll.GetInstance().AddComment(m_comment);
USR_CustomerShow ret = new USR_CustomerShow();
USR_CustomerBll.GetInstance().GetModel(CustomerSysNo).MemberwiseCopy(ret);
return ReturnValue<USR_CustomerShow>.Get200OK(ret);
}
public ReturnValue<USR_CustomerShow> AddAnswer(int CustomerSysNo, int QuestionSysNo, string Title, string Context)
{
QA_AnswerMod m_answer = new QA_AnswerMod();
m_answer.Award = 0;
m_answer.Title = Title;
m_answer.Context = AppCmn.CommonTools.SystemInputFilter(Context.DoTrim());
m_answer.CustomerSysNo = CustomerSysNo;
m_answer.DR = (int)AppEnum.State.normal;
m_answer.Hate = 0;
m_answer.Love = 0;
m_answer.QuestionSysNo = QuestionSysNo;
m_answer.Title = "";
m_answer.TS = DateTime.Now;
QA_AnswerBll.GetInstance().AddAnswer(m_answer);
USR_CustomerShow ret = new USR_CustomerShow();
USR_CustomerBll.GetInstance().GetModel(CustomerSysNo).MemberwiseCopy(ret);
return ReturnValue<USR_CustomerShow>.Get200OK(ret);
}
public ReturnValue<USR_CustomerShow> AddQuestionWithChart(Stream openPageData)
{
QA_QuestionInput<FATE_ChartMod> input;
//try
//{
int nReadCount = 0;
MemoryStream ms = new MemoryStream();
byte[] buffer = new byte[1024];
while ((nReadCount = openPageData.Read(buffer, 0, 1024)) > 0)
{
ms.Write(buffer, 0, nReadCount);
}
byte[] byteJson = ms.ToArray();
string textJson = System.Text.Encoding.UTF8.GetString(byteJson);
input = XMS.Core.Json.JsonSerializer.Deserialize<QA_QuestionInput<FATE_ChartMod>>(textJson);
if (input == null)
{
throw new BusinessException("参数有误");
}
//}
//catch (Exception ex)
//{
// throw ex;
//}
#region 判断输入项
if (input.CateSysNo == 0 || input.CateSysNo == AppConst.IntNull)
{
throw new BusinessException("请选择分类");
}
if (input.Title.DoTrim() == "")
{
throw new BusinessException("请输入标题");
}
if (input.Title.DoTrim().Length > 30)
{
throw new BusinessException("您输入的标题太长，请控制在30字以内");
}
int point = USR_CustomerBll.GetInstance().GetModel(input.CustomerSysNo).Point;
if (input.Award > point && point != AppConst.IntNull)
{
throw new BusinessException("您最多可用" + point + "积分");
}
#endregion
//try
//{
QA_QuestionMod m_quest = new QA_QuestionMod();
m_quest.Award = input.Award;
m_quest.CateSysNo = input.CateSysNo;
m_quest.Context = SQLData.SQLFilter(AppCmn.CommonTools.StringFilter(input.Context));
m_quest.CustomerSysNo = input.CustomerSysNo;
m_quest.LastReplyTime = DateTime.Now;
m_quest.ReplyCount = 0;
m_quest.ReadCount = 0;
m_quest.BuyCount = 0;
m_quest.OrderCount = 0;
m_quest.Title = AppCmn.CommonTools.SystemInputFilter(input.Title);
m_quest.TS = DateTime.Now;
m_quest.DR = (int)AppEnum.State.normal;
int sysno = 0;
QA_QuestionBll.GetInstance().AddQuest(ref m_quest, true);
sysno = m_quest.SysNo;
if (input.Chart.Count > 0)
{
FATE_ChartMod m_chart = new FATE_ChartMod();
m_chart.CharType = input.Chart[0].CharType; ;
if (m_chart.CharType != (int)AppEnum.ChartType.nochart)
{
m_chart.FirstBirth = input.Chart[0].FirstBirth;
m_chart.FirstPoi = input.Chart[0].FirstPoi;
m_chart.Transit = DateTime.Now;
m_chart.TransitPoi = input.Chart[0].FirstPoi;
m_chart.TheoryType = 0;
m_chart.FirstPoiName = input.Chart[0].FirstPoiName;
m_chart.FirstTimeZone = -8;
m_chart.FirstGender = input.Chart[0].FirstGender;
m_chart.FirstDayLight = input.Chart[0].FirstDayLight;
if (m_chart.CharType == (int)AppEnum.ChartType.relation)
{
m_chart.SecondBirth = input.Chart[0].SecondBirth;
m_chart.SecondPoi = input.Chart[0].SecondPoi;
m_chart.SecondPoiName = input.Chart[0].SecondPoiName;
m_chart.SecondTimeZone = -8;
m_chart.SecondGender = input.Chart[0].SecondGender;
m_chart.SecondDayLight = input.Chart[0].SecondDayLight;
}
m_chart.TS = DateTime.Now;
m_chart.DR = (int)AppEnum.State.normal;
int fatesysno = FATE_ChartBll.GetInstance().Add(m_chart);
REL_Question_ChartMod m_qchart = new REL_Question_ChartMod();
m_qchart.Chart_SysNo = fatesysno;
m_qchart.Question_SysNo = sysno;
REL_Question_ChartBll.GetInstance().Add(m_qchart);
}
}
//}
//catch (Exception ex)
//{
// throw ex;
//}
USR_CustomerShow ret = new USR_CustomerShow();
USR_CustomerBll.GetInstance().GetModel(input.CustomerSysNo).MemberwiseCopy(ret);
return ReturnValue<USR_CustomerShow>.Get200OK(ret);
}
public ReturnValue<PageInfo<QA_AnswerShow>> GetAnswerByQuest(int pagesize, int pageindex, int sysno)
{
int total = 0;
DataTable m_dt = QA_AnswerBll.GetInstance().GetListByQuest(pagesize, pageindex, sysno, ref total);
List<QA_AnswerShow> ret = new List<QA_AnswerShow>();
PageInfo<QA_AnswerShow> rett = new PageInfo<QA_AnswerShow>();
if (m_dt == null || m_dt.Rows.Count == 0)
{
rett.List = ret;
rett.Total = total;
rett.HasNextPage = false;
return ReturnValue<PageInfo<QA_AnswerShow>>.Get200OK(rett);
}
for (int i = 0; i < m_dt.Rows.Count; i++)
{
QA_AnswerShow tmp_answer = MapQA_AnswerShow(m_dt.Rows[i]);
USR_CustomerShow tmpu = new USR_CustomerShow();
USR_CustomerBll.GetInstance().GetModel(tmp_answer.CustomerSysNo).MemberwiseCopy(tmpu);
tmp_answer.Customer = tmpu;
DataTable tmp_dt = QA_CommentBll.GetInstance().GetListByAnswer(tmp_answer.SysNo);
if (tmp_dt != null && tmp_dt.Rows.Count > 0)
{
List<QA_CommentShow> commentlist = new List<QA_CommentShow>();
for (int j = 0; j < tmp_dt.Rows.Count && j <= 3; j++)
{
QA_CommentShow tmp_comment = MapQA_CommentShow(tmp_dt.Rows[j]);
USR_CustomerMaintain tmpuu = new USR_CustomerMaintain();
USR_CustomerBll.GetInstance().GetModel(tmp_comment.CustomerSysNo).MemberwiseCopy(tmpuu);
tmp_comment.Customer = tmpuu;
commentlist.Add(tmp_comment);
}
tmp_answer.TopComments = commentlist;
tmp_answer.ToalComment = tmp_dt.Rows.Count;
if (tmp_dt.Rows.Count > 3)
{
tmp_answer.HasMoreComment = true;
}
else
{
tmp_answer.HasMoreComment = false;
}
}
ret.Add(tmp_answer);
}
rett.List = ret;
rett.Total = total;
if (pagesize * pageindex >= total)
{
rett.HasNextPage = false;
}
else
{
rett.HasNextPage = true;
}
return ReturnValue<PageInfo<QA_AnswerShow>>.Get200OK(rett);
}
public ReturnValue<QA_QuestionShow<ZiWeiMod>> GetQuestionForZiWei(int sysno)
{
QA_QuestionMod tmp = QA_QuestionBll.GetInstance().GetModel(sysno);
QA_QuestionShow<ZiWeiMod> ret = new QA_QuestionShow<ZiWeiMod>();
tmp.MemberwiseCopy(ret);
USR_CustomerShow tmpu = new USR_CustomerShow();
USR_CustomerBll.GetInstance().GetModel(ret.CustomerSysNo).MemberwiseCopy(tmpu);
ret.Customer = tmpu;
#region 设置命盘
int[] _paras = { 1, 1, 0, 1 };
FATE_ChartMod m_chart = QA_QuestionBll.GetInstance().GetChartByQuest(ret.SysNo);
if (m_chart != null)
{
ZiWeiMod m_ziwei = new ZiWeiMod();
#region 设置实体各种参数
//默认做太阳时修正
string[] tmplatlng = m_chart.FirstPoi.ToString().Split(new char[] { '|' });
m_ziwei.BirthTime = new DateEntity(PublicDeal.GetInstance().RealTime(DateTime.Parse(m_chart.FirstBirth.ToString()),
new LatLng(tmplatlng[1], tmplatlng[0], m_chart.FirstPoiName)));
m_ziwei.Gender = (AppEnum.Gender)int.Parse(m_chart.FirstGender.ToString());
m_ziwei.RunYue = PublicValue.ZiWeiRunYue.dangxia;
m_ziwei.TransitTime = new DateEntity(DateTime.Now);
#endregion
m_ziwei = ZiWeiBiz.GetInstance().TimeToZiWei(m_ziwei.BirthTime, m_ziwei.Gender, _paras);
ret.Chart.Add(m_ziwei);
if (m_chart.CharType.ToString() == ((int)AppEnum.ChartType.relation).ToString())
{
ZiWeiMod m_ziwei1 = new ZiWeiMod();
#region 设置实体各种参数
tmplatlng = m_chart.SecondPoi.ToString().Split(new char[] { '|' });
m_ziwei1.BirthTime = new DateEntity(PublicDeal.GetInstance().RealTime(DateTime.Parse(m_chart.SecondBirth.ToString()),
new LatLng(tmplatlng[1], tmplatlng[0], m_chart.SecondPoiName)));
m_ziwei1.Gender = (AppEnum.Gender)int.Parse(m_chart.SecondGender.ToString());
m_ziwei1.RunYue = PublicValue.ZiWeiRunYue.dangxia;
m_ziwei1.TransitTime = new DateEntity(DateTime.Now);
#endregion
m_ziwei1 = ZiWeiBiz.GetInstance().TimeToZiWei(m_ziwei.BirthTime, m_ziwei.Gender, _paras);
ret.Chart.Add(m_ziwei1);
}
}
#endregion
return ReturnValue<QA_QuestionShow<ZiWeiMod>>.Get200OK(ret);
}
public ReturnValue<QA_QuestionShow<BaZiMod>> GetQuestionForBaZi(int sysno)
{
QA_QuestionMod tmp = QA_QuestionBll.GetInstance().GetModel(sysno);
QA_QuestionShow<BaZiMod> ret = new QA_QuestionShow<BaZiMod>();
tmp.MemberwiseCopy(ret);
USR_CustomerShow tmpu = new USR_CustomerShow();
USR_CustomerBll.GetInstance().GetModel(ret.CustomerSysNo).MemberwiseCopy(tmpu);
ret.Customer = tmpu;
#region 设置命盘
FATE_ChartMod m_chart = QA_QuestionBll.GetInstance().GetChartByQuest(ret.SysNo);
if (m_chart != null)
{
BaZiMod m_bazi = new BaZiMod();
string[] tmplatlng = m_chart.FirstPoi.ToString().Split(new char[] { '|' });
m_bazi.BirthTime = new DateEntity(PublicDeal.GetInstance().RealTime(DateTime.Parse(m_chart.FirstBirth.ToString()),
new LatLng(tmplatlng[1], tmplatlng[0], m_chart.FirstPoiName)));
m_bazi.AreaName = m_chart.FirstPoiName.ToString();
m_bazi.Longitude = tmplatlng[0];
m_bazi.Gender = (AppEnum.Gender)m_chart.FirstGender;
BaZiBiz.GetInstance().TimeToBaZi(ref m_bazi);
ret.Chart.Add(m_bazi);
if (m_chart.CharType.ToString() == ((int)AppEnum.ChartType.relation).ToString())
{
BaZiMod m_bazi1 = new BaZiMod();
tmplatlng = m_chart.SecondPoi.ToString().Split(new char[] { '|' });
m_bazi1.BirthTime = new DateEntity(PublicDeal.GetInstance().RealTime(DateTime.Parse(m_chart.SecondBirth.ToString()),
new LatLng(tmplatlng[1], tmplatlng[0], m_chart.SecondPoiName)));
m_bazi1.AreaName = m_chart.SecondPoiName.ToString();
m_bazi1.Longitude = tmplatlng[0];
m_bazi1.Gender = (AppEnum.Gender)m_chart.SecondGender;
BaZiBiz.GetInstance().TimeToBaZi(ref m_bazi1);
ret.Chart.Add(m_bazi1);
}
}
#endregion
return ReturnValue<QA_QuestionShow<BaZiMod>>.Get200OK(ret);
}
public ReturnValue<QA_QuestionShow<AstroMod>> GetQuestionForAstro(int sysno)
{
QA_QuestionMod tmp = QA_QuestionBll.GetInstance().GetModel(sysno);
QA_QuestionShow<AstroMod> ret = new QA_QuestionShow<AstroMod>();
tmp.MemberwiseCopy(ret);
USR_CustomerShow tmpu = new USR_CustomerShow();
USR_CustomerBll.GetInstance().GetModel(ret.CustomerSysNo).MemberwiseCopy(tmpu);
ret.Customer = tmpu;
#region 设置星盘
FATE_ChartMod m_chart = QA_QuestionBll.GetInstance().GetChartByQuest(ret.SysNo);
if (m_chart != null)
{
AstroMod tmpastro = new AstroMod();
if (m_chart.CharType.ToString() == ((int)AppEnum.ChartType.personal).ToString())
{
#region 设置实体各种参数
tmpastro.type = PublicValue.AstroType.benming;
tmpastro.birth = DateTime.Parse(m_chart.FirstBirth.ToString());
tmpastro.Gender = (AppEnum.Gender)m_chart.FirstGender;
string[] tmplatlng = m_chart.FirstPoi.ToString().Split(new char[] { '|' });
tmpastro.position = new LatLng(tmplatlng[1], tmplatlng[0], m_chart.FirstPoiName);
if (m_chart.FirstDayLight.ToString() == ((int)AppEnum.BOOL.True).ToString())
{
tmpastro.IsDayLight = AppEnum.BOOL.True;
}
else
{
tmpastro.IsDayLight = AppEnum.BOOL.False;
}
tmpastro.zone = int.Parse(m_chart.FirstTimeZone.ToString());
#endregion
}
else if (m_chart.CharType.ToString() == ((int)AppEnum.ChartType.relation).ToString())
{
#region 设置实体各种参数
tmpastro.type = PublicValue.AstroType.hepan;
tmpastro.compose = PublicValue.AstroZuhe.bijiao;
tmpastro.Gender = (AppEnum.Gender)m_chart.FirstGender;
tmpastro.Gender1 = (AppEnum.Gender)m_chart.SecondGender;
tmpastro.birth = DateTime.Parse(m_chart.FirstBirth.ToString());
string[] tmplatlng = m_chart.FirstPoi.ToString().Split(new char[] { '|' });
tmpastro.position = new LatLng(tmplatlng[1], tmplatlng[0], m_chart.FirstPoiName);
if (m_chart.FirstDayLight.ToString() == ((int)AppEnum.BOOL.True).ToString())
{
tmpastro.IsDayLight = AppEnum.BOOL.True;
}
else
{
tmpastro.IsDayLight = AppEnum.BOOL.False;
}
tmpastro.zone = int.Parse(m_chart.FirstTimeZone.ToString());
tmpastro.birth1 = DateTime.Parse(m_chart.SecondBirth.ToString());
tmplatlng = m_chart.SecondPoi.ToString().Split(new char[] { '|' });
tmpastro.position1 = new LatLng(tmplatlng[1], tmplatlng[0], m_chart.SecondPoiName);
if (m_chart.SecondDayLight.ToString() == ((int)AppEnum.BOOL.True).ToString())
{
tmpastro.IsDayLight1 = AppEnum.BOOL.True;
}
else
{
tmpastro.IsDayLight1 = AppEnum.BOOL.False;
}
tmpastro.zone1 = int.Parse(m_chart.SecondTimeZone.ToString());
#endregion
}
tmpastro.startsShow.Clear();
for (int i = 1; i <= 30; i++)
{
tmpastro.startsShow.Add(i, PublicValue.GetAstroStar((PublicValue.AstroStar)i));
}
tmpastro.aspectsShow.Clear();
tmpastro.aspectsShow.Add(1, 0);
tmpastro.aspectsShow.Add(2, 180);
tmpastro.aspectsShow.Add(4, 120);
tmpastro.aspectsShow.Add(3, 90);
tmpastro.aspectsShow.Add(5, 60);
tmpastro.graphicID = AstroBiz.GetInstance().SetGraphicID(tmpastro);
if ((tmpastro.type == PublicValue.AstroType.hepan && tmpastro.compose == PublicValue.AstroZuhe.bijiao) || (tmpastro.type == PublicValue.AstroType.tuiyun && tmpastro.transit == PublicValue.AstroTuiyun.xingyun))
{
AstroMod tmpinput = new AstroMod();
tmpinput.aspectsShow = tmpastro.aspectsShow;
tmpinput.startsShow = tmpastro.startsShow;
tmpinput.birth = tmpastro.birth;
tmpinput.position = tmpastro.position;
tmpinput.IsDayLight = tmpastro.IsDayLight;
tmpinput.zone = tmpastro.zone;
AstroBiz.GetInstance().GetParamters(ref tmpinput);
tmpastro.Stars = tmpinput.Stars;
tmpinput = new AstroMod();
tmpinput.aspectsShow = tmpastro.aspectsShow;
tmpinput.startsShow = tmpastro.startsShow;
tmpinput.birth = tmpastro.birth1;
tmpinput.position = tmpastro.position1;
tmpinput.IsDayLight = tmpastro.IsDayLight1;
tmpinput.zone = tmpastro.zone1;
AstroBiz.GetInstance().GetParamters(ref tmpinput);
tmpastro.Stars1 = tmpinput.Stars;
}
else
{
AstroBiz.GetInstance().GetParamters(ref tmpastro);
tmpastro.Stars1 = null;
}
ret.Chart.Add(tmpastro);
}
#endregion
return ReturnValue<QA_QuestionShow<AstroMod>>.Get200OK(ret);
}
public USR_CustomerShow MapUSR_CustomerShow(DataRow input)
{
USR_CustomerShow ret = new USR_CustomerShow();
if (input["BestAnswer"].ToString() != "")
{
ret.BestAnswer = int.Parse(input["BestAnswer"].ToString());
}
if (input["birth"].ToString() != "")
{
ret.Birth = DateTime.Parse(input["birth"].ToString());
}
else
{
ret.Birth = AppConst.DateTimeNull;
}
if (input["Credit"].ToString() != "")
{
ret.Credit = int.Parse(input["Credit"].ToString());
}
if (input["Exp"].ToString() != "")
{
ret.Exp = int.Parse(input["Exp"].ToString());
}
if (input["FateType"].ToString() != "")
{
ret.FateType = int.Parse(input["FateType"].ToString());
}
if (input["Gender"].ToString() != "")
{
ret.Gender = int.Parse(input["Gender"].ToString());
}
if (input["GradeSysNo"].ToString() != "")
{
ret.GradeSysNo = int.Parse(input["GradeSysNo"].ToString());
}
if (input["HasNewInfo"].ToString() != "")
{
ret.HasNewInfo = int.Parse(input["HasNewInfo"].ToString());
}
if (input["HomeTown"].ToString() != "")
{
ret.HomeTown = int.Parse(input["HomeTown"].ToString());
}
ret.Intro = input["Intro"].ToString();
if (input["IsShowBirth"].ToString() != "")
{
ret.IsShowBirth = int.Parse(input["IsShowBirth"].ToString());
}
if (input["IsStar"].ToString() != "")
{
ret.IsStar = int.Parse(input["IsStar"].ToString());
}
if (input["LastLoginTime"].ToString() != "")
{
ret.LastLoginTime = DateTime.Parse(input["LastLoginTime"].ToString());
}
else
{
ret.LastLoginTime = AppConst.DateTimeNull;
}
ret.NickName = input["NickName"].ToString();
ret.Photo = input["Photo"].ToString();
if (input["Point"].ToString() != "")
{
ret.Point = int.Parse(input["Point"].ToString());
}
if (input["RegTime"].ToString() != "")
{
ret.RegTime = DateTime.Parse(input["RegTime"].ToString());
}
else
{
ret.RegTime = AppConst.DateTimeNull;
}
ret.Signature = input["Signature"].ToString();
if (input["Status"].ToString() != "")
{
ret.Status = int.Parse(input["Status"].ToString());
}
if (input["SysNo"].ToString() != "")
{
ret.SysNo = int.Parse(input["SysNo"].ToString());
}
if (input["TotalAnswer"].ToString() != "")
{
ret.TotalAnswer = int.Parse(input["TotalAnswer"].ToString());
}
if (input["TotalQuest"].ToString() != "")
{
ret.TotalQuest = int.Parse(input["TotalQuest"].ToString());
}
if (input["TotalReply"].ToString() != "")
{
ret.TotalReply = int.Parse(input["TotalReply"].ToString());
}
if (input["TotalTalk"].ToString() != "")
{
ret.TotalTalk = int.Parse(input["TotalTalk"].ToString());
}
if (input["TotalTalkReply"].ToString() != "")
{
ret.TotalTalkReply = int.Parse(input["TotalTalkReply"].ToString());
}
ret.Phone = input["Phone"].ToString();
if (input["SetOrderCount"].ToString() != "")
{
ret.SetOrderCount = int.Parse(input["SetOrderCount"].ToString());
}
if (input["BuyOrderCount"].ToString() != "")
{
ret.BuyOrderCount = int.Parse(input["BuyOrderCount"].ToString());
}
if (input["SellOrderCount"].ToString() != "")
{
ret.SellOrderCount = int.Parse(input["SellOrderCount"].ToString());
}
if (input["TotalSellRMB"].ToString() != "")
{
ret.TotalSellRMB = int.Parse(input["TotalSellRMB"].ToString());
}
if (input["TotalBuyRMB"].ToString() != "")
{
ret.TotalBuyRMB = int.Parse(input["TotalBuyRMB"].ToString());
}
if (input["TotalBuyPoint"].ToString() != "")
{
ret.TotalBuyPoint = int.Parse(input["TotalBuyPoint"].ToString());
}
return ret;
}
public ReturnValue<USR_CustomerShow> GetUserInfo(int uid)
{
USR_CustomerMod m_user = USR_CustomerBll.GetInstance().GetModel(uid);
if (m_user.SysNo != -999999)
{
USR_CustomerShow ret = new USR_CustomerShow();
m_user.MemberwiseCopy(ret);
DataTable m_dt = REL_Customer_MedalBll.GetInstance().GetMedalByCustomer(uid, 0);
ret.TotalMedal = m_dt.Rows.Count;
int total = 0;
DataTable m_dt1 = USR_MessageBll.GetInstance().GetMessageByCustomer(uid, 1, 1, 0, 1, ref total);
ret.NewMessage = total;
return ReturnValue<USR_CustomerShow>.Get200OK(ret);
}
else
{
throw new BusinessException("用户ID错误，请重新输入！");
}
}