// Methods
protected void BindChart()
{
if ((this.m_famous.SysNo != -999999) && (this.m_famous.BirthYear > 0))
{
FATE_ChartMod m_chart = new FATE_ChartMod
{
CharType = 1,
FirstBirth = new DateTime(this.m_famous.BirthYear, this.m_famous.BirthTime.Month, this.m_famous.BirthTime.Day, this.m_famous.BirthTime.Hour, this.m_famous.BirthTime.Minute, this.m_famous.BirthTime.Second),
FirstDayLight = 0,
FirstGender = this.m_famous.Gender,
FirstPoi = this.GetHomeTown(this.m_famous.HomeTown) == "未知" ? "120E00|30N00" : this.GetHomeTown(this.m_famous.HomeTown).Replace(" ", "|").Split(new char[] { '>' })[1],
FirstPoiName = ""
};
if (m_chart.FirstPoi.Contains("W"))
{
m_chart.FirstTimeZone = this.GetTimeZone(decimal.Parse("-" + m_chart.FirstPoi.Trim().Split(new char[] { '|' })[0].Replace("W", ".")));
}
else
{
m_chart.FirstTimeZone = this.GetTimeZone(decimal.Parse(m_chart.FirstPoi.Trim().Split(new char[] { '|' })[0].Replace("E", ".")));
}
if ((base.GetSession().CustomerEntity == null) || (base.GetSession().CustomerEntity.SysNo == -999999))
{
this.Astro1.input = m_chart;
this.Astro1.Visible = true;
}
else
{
switch (base.GetSession().CustomerEntity.FateType)
{
case 1:
this.Astro1.input = m_chart;
this.Astro1.Visible = true;
return;
case 2:
this.Ziwei1.IfRealTime = false;
this.Ziwei1.input = m_chart;
this.Ziwei1.Visible = true;
return;
case 3:
this.Bazi1.IfRealTime = false;
this.Bazi1.input = m_chart;
this.Bazi1.Visible = true;
return;
}
}
}
}
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));
}
// Methods
protected void BindChart()
{
if ((this.m_famous.SysNo != -999999) && (this.m_famous.BirthYear > 0))
{
FATE_ChartMod m_chart = new FATE_ChartMod
{
CharType = 1,
FirstBirth = new DateTime(this.m_famous.BirthYear, this.m_famous.BirthTime.Month, this.m_famous.BirthTime.Day, this.m_famous.BirthTime.Hour, this.m_famous.BirthTime.Minute, this.m_famous.BirthTime.Second),
FirstDayLight = 0,
FirstGender = this.m_famous.Gender,
FirstPoi = this.GetHomeTown(this.m_famous.HomeTown) == "未知" ? "120E00|30N00" : this.GetHomeTown(this.m_famous.HomeTown).Replace(" ", "|").Split(new char[] { '>' })[1],
FirstPoiName = ""
};
if (m_chart.FirstPoi.Contains("W"))
{
m_chart.FirstTimeZone = this.GetTimeZone(decimal.Parse("-" + m_chart.FirstPoi.Trim().Split(new char[] { '|' })[0].Replace("W", ".")));
}
else
{
m_chart.FirstTimeZone = this.GetTimeZone(decimal.Parse(m_chart.FirstPoi.Trim().Split(new char[] { '|' })[0].Replace("E", ".")));
}
if ((base.GetSession().CustomerEntity == null) || (base.GetSession().CustomerEntity.SysNo == -999999))
{
this.Astro1.input = m_chart;
this.Astro1.Visible = true;
}
else
{
switch (base.GetSession().CustomerEntity.FateType)
{
case 1:
this.Astro1.input = m_chart;
this.Astro1.Visible = true;
return;
case 2:
this.Ziwei1.IfRealTime = false;
this.Ziwei1.input = m_chart;
this.Ziwei1.Visible = true;
return;
case 3:
this.Bazi1.IfRealTime = false;
this.Bazi1.input = m_chart;
this.Bazi1.Visible = true;
return;
}
}
}
}
protected void BindData()
{
try
{
if (m_qustion.DR != (int)AppEnum.State.normal)
{
ShowError("");
}
m_qustion.ReadCount++;
QA_QuestionBll.GetInstance().Update(m_qustion);
ltrTitle.Text = m_qustion.Title;
ltrContext.Text = m_qustion.Context;
ltrAward.Text = m_qustion.Award.ToString();
ltrReply.Text = m_qustion.ReplyCount.ToString();
ltrViewNum.Text = m_qustion.ReadCount.ToString();
USR_CustomerMod m_user = USR_CustomerBll.GetInstance().GetModel(m_qustion.CustomerSysNo);
USR_GradeMod m_grade = USR_GradeBll.GetInstance().GetModel(m_user.GradeSysNo);
ltrNickName.Text = m_user.NickName;
ltrQALevel.Text = m_grade.Name;
ltrTotalReply.Text = m_user.TotalReply.ToString();
ltrTotalAsk.Text = m_user.TotalQuest.ToString();
Image1.ImageUrl = AppConfig.HomeUrl() + "ControlLibrary/ShowPhoto.aspx?type=t&id=" + m_user.Photo;
#region 显示命盘
FATE_ChartMod m_chart = QA_QuestionBll.GetInstance().GetChartByQuest(SysNo);
if (m_chart != null && m_chart.SysNo != AppConst.IntNull)
{
if (GetSession().CustomerEntity == null || GetSession().CustomerEntity.SysNo == AppConst.IntNull)
{
Astro1.input = m_chart;
Astro1.Visible = true;
}
else if (GetSession().CustomerEntity.FateType == (int)AppEnum.FateType.ziwei)
{
Ziwei1.input = m_chart;
Ziwei1.Visible = true;
}
else if (GetSession().CustomerEntity.FateType == (int)AppEnum.FateType.bazi)
{
Bazi1.input = m_chart;
Bazi1.Visible = true;
}
else
{
Astro1.input = m_chart;
Astro1.Visible = true;
}
}
#endregion
#region 绑定原报价单信息
if (order != 0)
{
TextBox2.Text = old_order.Words.ToString();
TextBox2.ReadOnly = true;
TextBox3.Text = old_order.Price.ToString();
TextBox3.ReadOnly = true;
txtDescription.Text = old_order.Description;
txtDescription.ReadOnly = true;
txtTrial.Text = old_order.Trial;
txtTrial.ReadOnly = true;
}
else
{
//发布报价单时隐藏结果输入框
resulttitle.Visible = false;
resultcontent.Visible = false;
}
#endregion
}
catch
{
ShowError("");
}
}
protected void AddCollection(object sender, EventArgs e)
{
int addsysno = 0;
BLG_CollectionMod m_collection = new BLG_CollectionMod();
try
{
switch (type)
{
case (int)AppCmn.AppEnum.CollectionType.quest:
if (Request.QueryString["sysno"] == null)
{
Response.Redirect("../Error.aspx?msg=");
}
try
{
addsysno = int.Parse(Request.QueryString["sysno"]);
}
catch
{
Response.Redirect("../Error.aspx?msg=");
}
m_collection.CustomerSysNo = GetSession().CustomerEntity.SysNo;
m_collection.DR = (int)AppEnum.State.normal;
m_collection.Name = "";
m_collection.TS = DateTime.Now;
m_collection.Type = (int)AppEnum.CollectionType.quest;
m_collection.RefSysNo = addsysno;
BLG_CollectionBll.GetInstance().Add(m_collection);
Page.ClientScript.RegisterStartupScript(this.GetType(), "addquestok", "alert('问题收藏成功');", true);
break;
case (int)AppCmn.AppEnum.CollectionType.article:
if (Request.QueryString["sysno"] == null)
{
Response.Redirect("../Error.aspx?msg=");
}
try
{
addsysno = int.Parse(Request.QueryString["sysno"]);
}
catch
{
Response.Redirect("../Error.aspx?msg=");
}
m_collection.CustomerSysNo = GetSession().CustomerEntity.SysNo;
m_collection.DR = (int)AppEnum.State.normal;
m_collection.Name = "";
m_collection.TS = DateTime.Now;
m_collection.Type = (int)AppEnum.CollectionType.article;
m_collection.RefSysNo = addsysno;
BLG_CollectionBll.GetInstance().Add(m_collection);
Page.ClientScript.RegisterStartupScript(this.GetType(), "addquestok", "alert('文章收藏成功');", true);
break;
case (int)AppCmn.AppEnum.CollectionType.famous:
if (Request.QueryString["sysno"] == null)
{
Response.Redirect("../Error.aspx?msg=");
}
try
{
addsysno = int.Parse(Request.QueryString["sysno"]);
}
catch
{
Response.Redirect("../Error.aspx?msg=");
}
m_collection.CustomerSysNo = GetSession().CustomerEntity.SysNo;
m_collection.DR = (int)AppEnum.State.normal;
m_collection.Name = "";
m_collection.TS = DateTime.Now;
m_collection.Type = (int)AppEnum.CollectionType.famous;
m_collection.RefSysNo = addsysno;
BLG_CollectionBll.GetInstance().Add(m_collection);
Page.ClientScript.RegisterStartupScript(this.GetType(), "addquestok", "alert('名人收藏成功');", true);
break;
case (int)AppCmn.AppEnum.CollectionType.chart:
FATE_ChartMod m_fate = new FATE_ChartMod();
try
{
string[] tmps = Request.QueryString["p"].Split(new char[] { '_' });
switch (Request.QueryString["minitype"].ToUpper())
{
case "ASTRO":
m_fate.CharType = (int)AppEnum.ChartType.personal;
m_fate.FirstBirth = new DateTime(int.Parse(tmps[0]), int.Parse(tmps[1]), int.Parse(tmps[2]), int.Parse(tmps[3]), int.Parse(tmps[4]), 0);
m_fate.FirstPoi = tmps[7] + "|" + tmps[6];
m_fate.Transit = DateTime.Now;
m_fate.TransitPoi = m_fate.FirstPoi;
m_fate.TheoryType = 0;
DataTable m_dist = SYS_DistrictBll.GetInstance().GetInfoByPoi(tmps[6], tmps[7]);
if (m_dist.Rows.Count > 0)
{
m_fate.FirstPoiName = m_dist.Rows[0]["Name1"] + "-" + m_dist.Rows[0]["Name2"] + "-" + m_dist.Rows[0]["Name3"];
}
else
{
m_fate.FirstPoiName = "未知";
}
m_fate.FirstTimeZone = int.Parse(tmps[8]);
m_fate.FirstGender = int.Parse(drpGender.SelectedValue);
if (tmps[5] == "1")
{
m_fate.FirstDayLight = (int)AppEnum.BOOL.True;
}
else
{
m_fate.FirstDayLight = (int)AppEnum.BOOL.False;
}
break;
case "ZIWEI":
m_fate.CharType = (int)AppEnum.ChartType.personal;
m_fate.FirstBirth = new DateTime(int.Parse(tmps[0]), int.Parse(tmps[1]), int.Parse(tmps[2]), int.Parse(tmps[3]), int.Parse(tmps[4]), 0);
m_fate.FirstPoi = "120.129798|30.259497";
m_fate.Transit = DateTime.Now;
m_fate.TransitPoi = m_fate.FirstPoi;
m_fate.TheoryType = 0;
m_fate.FirstPoiName = "浙江省-杭州市-西湖区";
m_fate.FirstTimeZone = -8;
m_fate.FirstGender = int.Parse(tmps[5]);
m_fate.FirstDayLight = (int)AppEnum.BOOL.False;
break;
case "BAZI":
m_fate.CharType = (int)AppEnum.ChartType.personal;
m_fate.FirstBirth = new DateTime(int.Parse(tmps[0]), int.Parse(tmps[1]), int.Parse(tmps[2]), int.Parse(tmps[3]), int.Parse(tmps[4]), 0);
m_fate.FirstPoi = "120.129798|30.259497";
m_fate.Transit = DateTime.Now;
m_fate.TransitPoi = m_fate.FirstPoi;
m_fate.TheoryType = 0;
m_fate.FirstPoiName = "浙江省-杭州市-西湖区";
m_fate.FirstTimeZone = -8;
m_fate.FirstGender = int.Parse(tmps[5]);
m_fate.FirstDayLight = (int)AppEnum.BOOL.False;
break;
default:
Response.Redirect("../Error.aspx?msg=");
break;
}
}
catch (Exception ex)
{
LogManagement.getInstance().WriteException(ex, "Collection-AddFate", Request.UserHostAddress, "收藏命盘失败");
Page.ClientScript.RegisterStartupScript(this.GetType(), "addwrong", "alert('系统错误，请联系管理员');", true);
}
m_collection.CustomerSysNo = GetSession().CustomerEntity.SysNo;
m_collection.DR = (int)AppEnum.State.normal;
m_collection.Name = Server.HtmlEncode(txtName.Text.Trim());
m_collection.TS = DateTime.Now;
m_collection.Type = (int)AppEnum.CollectionType.chart;
m_collection.Detail = Server.HtmlEncode(txtDetail.Text.Trim());
m_collection.RefSysNo = FATE_ChartBll.GetInstance().Add(m_fate);
BLG_CollectionBll.GetInstance().Add(m_collection);
Page.ClientScript.RegisterStartupScript(this.GetType(), "addfateok", "alert('命盘收藏成功');", true);
ModalPopupExtender1.Hide();
break;
case (int)AppCmn.AppEnum.CollectionType.url:
m_collection.CustomerSysNo = GetSession().CustomerEntity.SysNo;
m_collection.DR = (int)AppEnum.State.normal;
m_collection.Name = Server.HtmlEncode(txtName.Text.Trim());
m_collection.TS = DateTime.Now;
m_collection.Type = (int)AppEnum.CollectionType.url;
m_collection.RefUrl = Server.HtmlEncode(txtUrl.Text.Trim());
m_collection.Detail = Server.HtmlEncode(txtDetail.Text.Trim());
BLG_CollectionBll.GetInstance().Add(m_collection);
Page.ClientScript.RegisterStartupScript(this.GetType(), "addquestok", "alert('站外资源收藏成功');", true);
break;
default:
Response.Redirect("../Error.aspx?msg="); //type无效
break;
}
}
catch (Exception ex)
{
LogManagement.getInstance().WriteException(ex, "Collection-Add", Request.UserHostAddress, "添加收藏失败");
Page.ClientScript.RegisterStartupScript(this.GetType(), "addwrong", "alert('系统错误，请联系管理员');", true);
}
Response.Redirect("MyCollection.aspx?type=" + type);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FATE_ChartMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FATE_Chart(");
strSql.Append("FirstBirth,FirstPoi,Transit,TransitPoi,SecondBirth,SecondPoi,CharType,TheoryType,Bitvalue,DR,TS,FirstDayLight,SecondDayLight,FirstPoiName,SecondPoiName,FirstTimeZone,SecondTimeZone,FirstGender,SecondGender)");
strSql.Append(" values (");
strSql.Append("@FirstBirth,@FirstPoi,@Transit,@TransitPoi,@SecondBirth,@SecondPoi,@CharType,@TheoryType,@Bitvalue,@DR,@TS,@FirstDayLight,@SecondDayLight,@FirstPoiName,@SecondPoiName,@FirstTimeZone,@SecondTimeZone,@FirstGender,@SecondGender)");
strSql.Append(";select @@IDENTITY");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters =
{
new SqlParameter("@FirstBirth", SqlDbType.DateTime),
new SqlParameter("@FirstPoi", SqlDbType.VarChar, 100),
new SqlParameter("@Transit", SqlDbType.DateTime),
new SqlParameter("@TransitPoi", SqlDbType.VarChar, 100),
new SqlParameter("@SecondBirth", SqlDbType.DateTime),
new SqlParameter("@SecondPoi", SqlDbType.VarChar, 100),
new SqlParameter("@CharType", SqlDbType.Int, 4),
new SqlParameter("@TheoryType", SqlDbType.TinyInt, 1),
new SqlParameter("@Bitvalue", SqlDbType.VarChar, 100),
new SqlParameter("@DR", SqlDbType.TinyInt, 1),
new SqlParameter("@TS", SqlDbType.DateTime),
new SqlParameter("@FirstDayLight", SqlDbType.Int, 4),
new SqlParameter("@SecondDayLight", SqlDbType.Int, 4),
new SqlParameter("@FirstPoiName", SqlDbType.VarChar, 100),
new SqlParameter("@SecondPoiName", SqlDbType.VarChar, 100),
new SqlParameter("@FirstTimeZone", SqlDbType.Int, 4),
new SqlParameter("@SecondTimeZone", SqlDbType.Int, 4),
new SqlParameter("@FirstGender", SqlDbType.Int, 4),
new SqlParameter("@SecondGender", SqlDbType.Int, 4),
};
if (model.FirstBirth != AppConst.DateTimeNull)
{
parameters[0].Value = model.FirstBirth;
}
else
{
parameters[0].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[0]);
if (model.FirstPoi != AppConst.StringNull)
{
parameters[1].Value = model.FirstPoi;
}
else
{
parameters[1].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[1]);
if (model.Transit != AppConst.DateTimeNull)
{
parameters[2].Value = model.Transit;
}
else
{
parameters[2].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[2]);
if (model.TransitPoi != AppConst.StringNull)
{
parameters[3].Value = model.TransitPoi;
}
else
{
parameters[3].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[3]);
if (model.SecondBirth != AppConst.DateTimeNull)
{
parameters[4].Value = model.SecondBirth;
}
else
{
parameters[4].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[4]);
if (model.SecondPoi != AppConst.StringNull)
{
parameters[5].Value = model.SecondPoi;
}
else
{
parameters[5].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[5]);
if (model.CharType != AppConst.IntNull)
{
parameters[6].Value = model.CharType;
}
else
{
parameters[6].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[6]);
if (model.TheoryType != AppConst.IntNull)
{
parameters[7].Value = model.TheoryType;
}
else
{
parameters[7].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[7]);
if (model.Bitvalue != AppConst.StringNull)
{
parameters[8].Value = model.Bitvalue;
}
else
{
parameters[8].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[8]);
if (model.DR != AppConst.IntNull)
{
parameters[9].Value = model.DR;
}
else
{
parameters[9].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[9]);
if (model.TS != AppConst.DateTimeNull)
{
parameters[10].Value = model.TS;
}
else
{
parameters[10].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[10]);
if (model.FirstDayLight != AppConst.IntNull)
{
parameters[11].Value = model.FirstDayLight;
}
else
{
parameters[11].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[11]);
if (model.SecondDayLight != AppConst.IntNull)
{
parameters[12].Value = model.SecondDayLight;
}
else
{
parameters[12].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[12]);
if (model.FirstPoiName != AppConst.StringNull)
{
parameters[13].Value = model.FirstPoiName;
}
else
{
parameters[13].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[13]);
if (model.SecondPoiName != AppConst.StringNull)
{
parameters[14].Value = model.SecondPoiName;
}
else
{
parameters[14].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[14]);
if (model.FirstTimeZone != AppConst.IntNull)
{
parameters[15].Value = model.FirstTimeZone;
}
else
{
parameters[15].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[15]);
if (model.SecondTimeZone != AppConst.IntNull)
{
parameters[16].Value = model.SecondTimeZone;
}
else
{
parameters[16].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[16]);
if (model.FirstGender != AppConst.IntNull)
{
parameters[17].Value = model.FirstGender;
}
else
{
parameters[17].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[17]);
if (model.SecondGender != AppConst.IntNull)
{
parameters[18].Value = model.SecondGender;
}
else
{
parameters[18].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[18]);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(cmd, parameters)));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FATE_ChartMod model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into FATE_Chart(");
strSql.Append("FirstBirth,FirstPoi,Transit,TransitPoi,SecondBirth,SecondPoi,CharType,TheoryType,Bitvalue,DR,TS,FirstDayLight,SecondDayLight,FirstPoiName,SecondPoiName,FirstTimeZone,SecondTimeZone,FirstGender,SecondGender)");
strSql.Append(" values (");
strSql.Append("@FirstBirth,@FirstPoi,@Transit,@TransitPoi,@SecondBirth,@SecondPoi,@CharType,@TheoryType,@Bitvalue,@DR,@TS,@FirstDayLight,@SecondDayLight,@FirstPoiName,@SecondPoiName,@FirstTimeZone,@SecondTimeZone,@FirstGender,@SecondGender)");
strSql.Append(";select @@IDENTITY");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters = {
new SqlParameter("@FirstBirth",SqlDbType.DateTime),
new SqlParameter("@FirstPoi",SqlDbType.VarChar,100),
new SqlParameter("@Transit",SqlDbType.DateTime),
new SqlParameter("@TransitPoi",SqlDbType.VarChar,100),
new SqlParameter("@SecondBirth",SqlDbType.DateTime),
new SqlParameter("@SecondPoi",SqlDbType.VarChar,100),
new SqlParameter("@CharType",SqlDbType.Int,4),
new SqlParameter("@TheoryType",SqlDbType.TinyInt,1),
new SqlParameter("@Bitvalue",SqlDbType.VarChar,100),
new SqlParameter("@DR",SqlDbType.TinyInt,1),
new SqlParameter("@TS",SqlDbType.DateTime),
new SqlParameter("@FirstDayLight",SqlDbType.Int,4),
new SqlParameter("@SecondDayLight",SqlDbType.Int,4),
new SqlParameter("@FirstPoiName",SqlDbType.VarChar,100),
new SqlParameter("@SecondPoiName",SqlDbType.VarChar,100),
new SqlParameter("@FirstTimeZone",SqlDbType.Int,4),
new SqlParameter("@SecondTimeZone",SqlDbType.Int,4),
new SqlParameter("@FirstGender",SqlDbType.Int,4),
new SqlParameter("@SecondGender",SqlDbType.Int,4),
};
if (model.FirstBirth != AppConst.DateTimeNull)
parameters[0].Value = model.FirstBirth;
else
parameters[0].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[0]);
if (model.FirstPoi != AppConst.StringNull)
parameters[1].Value = model.FirstPoi;
else
parameters[1].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[1]);
if (model.Transit != AppConst.DateTimeNull)
parameters[2].Value = model.Transit;
else
parameters[2].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[2]);
if (model.TransitPoi != AppConst.StringNull)
parameters[3].Value = model.TransitPoi;
else
parameters[3].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[3]);
if (model.SecondBirth != AppConst.DateTimeNull)
parameters[4].Value = model.SecondBirth;
else
parameters[4].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[4]);
if (model.SecondPoi != AppConst.StringNull)
parameters[5].Value = model.SecondPoi;
else
parameters[5].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[5]);
if (model.CharType != AppConst.IntNull)
parameters[6].Value = model.CharType;
else
parameters[6].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[6]);
if (model.TheoryType != AppConst.IntNull)
parameters[7].Value = model.TheoryType;
else
parameters[7].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[7]);
if (model.Bitvalue != AppConst.StringNull)
parameters[8].Value = model.Bitvalue;
else
parameters[8].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[8]);
if (model.DR != AppConst.IntNull)
parameters[9].Value = model.DR;
else
parameters[9].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[9]);
if (model.TS != AppConst.DateTimeNull)
parameters[10].Value = model.TS;
else
parameters[10].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[10]);
if (model.FirstDayLight != AppConst.IntNull)
parameters[11].Value = model.FirstDayLight;
else
parameters[11].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[11]);
if (model.SecondDayLight != AppConst.IntNull)
parameters[12].Value = model.SecondDayLight;
else
parameters[12].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[12]);
if (model.FirstPoiName != AppConst.StringNull)
parameters[13].Value = model.FirstPoiName;
else
parameters[13].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[13]);
if (model.SecondPoiName != AppConst.StringNull)
parameters[14].Value = model.SecondPoiName;
else
parameters[14].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[14]);
if (model.FirstTimeZone != AppConst.IntNull)
parameters[15].Value = model.FirstTimeZone;
else
parameters[15].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[15]);
if (model.SecondTimeZone != AppConst.IntNull)
parameters[16].Value = model.SecondTimeZone;
else
parameters[16].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[16]);
if (model.FirstGender != AppConst.IntNull)
parameters[17].Value = model.FirstGender;
else
parameters[17].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[17]);
if (model.SecondGender != AppConst.IntNull)
parameters[18].Value = model.SecondGender;
else
parameters[18].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[18]);
return Convert.ToInt32(SqlHelper.ExecuteScalar(cmd, parameters));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FATE_ChartMod GetModel(int SysNo)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select SysNo, FirstBirth, FirstPoi, Transit, TransitPoi, SecondBirth, SecondPoi, CharType, TheoryType, Bitvalue, DR, TS, FirstDayLight, SecondDayLight, FirstPoiName, SecondPoiName, FirstTimeZone, SecondTimeZone, FirstGender, SecondGender from FATE_Chart");
strSql.Append(" where SysNo=@SysNo ");
SqlParameter[] parameters = {
new SqlParameter("@SysNo", SqlDbType.Int,4 )
};
parameters[0].Value = SysNo;
FATE_ChartMod model = new FATE_ChartMod();
DataSet ds=SqlHelper.ExecuteDataSet(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["SysNo"].ToString()!="")
{
model.SysNo=int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString());
}
if(ds.Tables[0].Rows[0]["FirstBirth"].ToString()!="")
{
model.FirstBirth=DateTime.Parse(ds.Tables[0].Rows[0]["FirstBirth"].ToString());
}
model.FirstPoi=ds.Tables[0].Rows[0]["FirstPoi"].ToString();
if(ds.Tables[0].Rows[0]["Transit"].ToString()!="")
{
model.Transit=DateTime.Parse(ds.Tables[0].Rows[0]["Transit"].ToString());
}
model.TransitPoi=ds.Tables[0].Rows[0]["TransitPoi"].ToString();
if(ds.Tables[0].Rows[0]["SecondBirth"].ToString()!="")
{
model.SecondBirth=DateTime.Parse(ds.Tables[0].Rows[0]["SecondBirth"].ToString());
}
model.SecondPoi=ds.Tables[0].Rows[0]["SecondPoi"].ToString();
if(ds.Tables[0].Rows[0]["CharType"].ToString()!="")
{
model.CharType=int.Parse(ds.Tables[0].Rows[0]["CharType"].ToString());
}
if(ds.Tables[0].Rows[0]["TheoryType"].ToString()!="")
{
model.TheoryType=int.Parse(ds.Tables[0].Rows[0]["TheoryType"].ToString());
}
model.Bitvalue=ds.Tables[0].Rows[0]["Bitvalue"].ToString();
if(ds.Tables[0].Rows[0]["DR"].ToString()!="")
{
model.DR=int.Parse(ds.Tables[0].Rows[0]["DR"].ToString());
}
if(ds.Tables[0].Rows[0]["TS"].ToString()!="")
{
model.TS=DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString());
}
if(ds.Tables[0].Rows[0]["FirstDayLight"].ToString()!="")
{
model.FirstDayLight=int.Parse(ds.Tables[0].Rows[0]["FirstDayLight"].ToString());
}
if(ds.Tables[0].Rows[0]["SecondDayLight"].ToString()!="")
{
model.SecondDayLight=int.Parse(ds.Tables[0].Rows[0]["SecondDayLight"].ToString());
}
model.FirstPoiName=ds.Tables[0].Rows[0]["FirstPoiName"].ToString();
model.SecondPoiName=ds.Tables[0].Rows[0]["SecondPoiName"].ToString();
if(ds.Tables[0].Rows[0]["FirstTimeZone"].ToString()!="")
{
model.FirstTimeZone=int.Parse(ds.Tables[0].Rows[0]["FirstTimeZone"].ToString());
}
if(ds.Tables[0].Rows[0]["SecondTimeZone"].ToString()!="")
{
model.SecondTimeZone=int.Parse(ds.Tables[0].Rows[0]["SecondTimeZone"].ToString());
}
if(ds.Tables[0].Rows[0]["FirstGender"].ToString()!="")
{
model.FirstGender=int.Parse(ds.Tables[0].Rows[0]["FirstGender"].ToString());
}
if(ds.Tables[0].Rows[0]["SecondGender"].ToString()!="")
{
model.SecondGender=int.Parse(ds.Tables[0].Rows[0]["SecondGender"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FATE_ChartMod model)
{
return dal.Add(model);
}
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));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(FATE_ChartMod model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FATE_ChartMod model)
{
return(dal.Add(model));
}
protected void Unnamed3_Click(object sender, EventArgs e)
{
Login(Request.Url.ToString());
#region 判断输入项
if (drpCate.SelectedIndex == 0)
{
CateTip.InnerHtml = "请选择分类";
CateTip.Attributes["class"] = "err";
Page.ClientScript.RegisterStartupScript(this.GetType(), "typemodify", "qaTypeChanged(document.getElementById('" + drpType.ClientID + "'));", true);
return;
}
if (txtTitle.Text.Trim() == "")
{
TitleTip.InnerHtml = "请输入标题";
TitleTip.Attributes["class"] = "err";
Page.ClientScript.RegisterStartupScript(this.GetType(), "typemodify", "qaTypeChanged(document.getElementById('" + drpType.ClientID + "'));", true);
return;
}
if (txtTitle.Text.Trim().Length > 200)
{
TitleTip.InnerHtml = "您输入的标题太长，请控制在200字以内";
TitleTip.Attributes["class"] = "err";
Page.ClientScript.RegisterStartupScript(this.GetType(), "typemodify", "qaTypeChanged(document.getElementById('" + drpType.ClientID + "'));", true);
return;
}
#endregion
try
{
QA_QuestionMod m_quest = new QA_QuestionMod();
m_quest.Award = 0;
m_quest.CateSysNo = int.Parse(drpCate.SelectedValue);
m_quest.Context = SQLData.SQLFilter(AppCmn.CommonTools.StringFilter(txtContext.Text.Trim()));
m_quest.CustomerSysNo = GetSession().CustomerEntity.SysNo;
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(txtTitle.Text.Trim());
m_quest.TS = DateTime.Now;
m_quest.DR = (int)AppEnum.State.normal;
int sysno = 0;
QA_QuestionBll.GetInstance().AddQuest(ref m_quest,false);
sysno = m_quest.SysNo;
RefreshSession();
FATE_ChartMod m_chart = new FATE_ChartMod();
m_chart.CharType = int.Parse(drpType.SelectedValue);
if (m_chart.CharType != (int)AppEnum.ChartType.nochart)
{
m_chart.FirstBirth = DatePicker1.SelectedTime;
m_chart.FirstPoi = District1.lng + "|" + District1.lat;
m_chart.Transit = DateTime.Now;
m_chart.TransitPoi = m_chart.FirstPoi;
m_chart.TheoryType = 0;
m_chart.FirstPoiName = District1.Area1Name + "-" + District1.Area2Name + "-" + District1.Area3Name;
m_chart.FirstTimeZone = -8;
m_chart.FirstGender = int.Parse(drpGender1.SelectedValue);
if (chkDaylight1.Checked)
{
m_chart.FirstDayLight = (int)AppEnum.BOOL.True;
}
else
{
m_chart.FirstDayLight = (int)AppEnum.BOOL.False;
}
if (m_chart.CharType == (int)AppEnum.ChartType.relation)
{
m_chart.SecondBirth = DatePicker2.SelectedTime;
m_chart.SecondPoi = District2.lng + "|" + District2.lat;
m_chart.SecondPoiName = District2.Area1Name + "-" + District2.Area2Name + "-" + District2.Area3Name;
m_chart.SecondTimeZone = -8;
m_chart.SecondGender = int.Parse(drpGender2.SelectedValue);
if (chkDaylight2.Checked)
{
m_chart.SecondDayLight = (int)AppEnum.BOOL.True;
}
else
{
m_chart.SecondDayLight = (int)AppEnum.BOOL.False;
}
}
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);
}
LogManagement.getInstance().WriteTrace("前台话题", "Ask", "IP:" + Request.UserHostAddress + "|UID:" + GetSession().CustomerEntity.Email);
Page.ClientScript.RegisterStartupScript(this.GetType(), "askok", "alert('话题发布成功！');", true);
Response.Redirect(AppConfig.HomeUrl()+"Quest/Topic/" + sysno,false);
}
catch (Exception ex)
{
LogManagement.getInstance().WriteException(ex, "QA-Add", Request.UserHostAddress, "发布话题失败");
Page.ClientScript.RegisterStartupScript(this.GetType(), "askok", "alert('系统故障，请联系管理员！');", true);
}
}
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 QA_QuestionShowMini <AstroMod> MapQA_QuestionShowMiniForAstro(DataRow input)
{
QA_QuestionShowMini <AstroMod> ret = new QA_QuestionShowMini <AstroMod>();
if (input["Award"].ToString() != "")
{
ret.Award = int.Parse(input["Award"].ToString());
}
if (input["CateSysNo"].ToString() != "")
{
ret.CateSysNo = int.Parse(input["CateSysNo"].ToString());
}
#region 设置星盘
FATE_ChartMod m_chart = QA_QuestionBll.GetInstance().GetChartByQuest(int.Parse(input["SysNo"].ToString()));
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
ret.Context = input["Context"].ToString();
if (input["NickName"] == null)
{
USR_CustomerMod m_customer = USR_CustomerBll.GetInstance().GetModel(int.Parse(input["CustomerSysNo"].ToString()));
ret.CustomerNickName = m_customer.NickName;
ret.CustomerPhoto = m_customer.Photo;
}
else
{
ret.CustomerNickName = input["NickName"].ToString();
ret.CustomerPhoto = input["Photo"].ToString();
}
if (input["CustomerSysNo"].ToString() != "")
{
ret.CustomerSysNo = int.Parse(input["CustomerSysNo"].ToString());
}
ret.DR = int.Parse(input["DR"].ToString());
if (input["EndTime"].ToString() != "")
{
ret.EndTime = DateTime.Parse(input["EndTime"].ToString());
}
else
{
ret.EndTime = AppConst.DateTimeNull;
}
if (input["IsSecret"].ToString() != "")
{
ret.IsSecret = int.Parse(input["IsSecret"].ToString());
}
if (input["LastReplyTime"].ToString() != "")
{
ret.LastReplyTime = DateTime.Parse(input["LastReplyTime"].ToString());
}
else
{
ret.LastReplyTime = AppConst.DateTimeNull;
}
if (input["LastReplyUser"].ToString() != "")
{
ret.LastReplyUser = int.Parse(input["LastReplyUser"].ToString());
}
if (input["ReadCount"].ToString() != "")
{
ret.ReadCount = int.Parse(input["ReadCount"].ToString());
}
if (input["ReplyCount"].ToString() != "")
{
ret.ReplyCount = int.Parse(input["ReplyCount"].ToString());
}
if (input["SysNo"].ToString() != "")
{
ret.SysNo = int.Parse(input["SysNo"].ToString());
}
ret.Title = input["Title"].ToString();
if (input["TS"].ToString() != "")
{
ret.TS = DateTime.Parse(input["TS"].ToString());
}
else
{
ret.TS = AppConst.DateTimeNull;
}
return(ret);
}
protected void AddCollection(object sender, EventArgs e)
{
int addsysno = 0;
BLG_CollectionMod m_collection = new BLG_CollectionMod();
try
{
switch (type)
{
case (int)AppCmn.AppEnum.CollectionType.quest:
if (Request.QueryString["sysno"] == null)
{
Response.Redirect("../Error.aspx?msg=");
}
try
{
addsysno = int.Parse(Request.QueryString["sysno"]);
}
catch
{
Response.Redirect("../Error.aspx?msg=");
}
m_collection.CustomerSysNo = GetSession().CustomerEntity.SysNo;
m_collection.DR = (int)AppEnum.State.normal;
m_collection.Name = "";
m_collection.TS = DateTime.Now;
m_collection.Type = (int)AppEnum.CollectionType.quest;
m_collection.RefSysNo = addsysno;
BLG_CollectionBll.GetInstance().Add(m_collection);
Page.ClientScript.RegisterStartupScript(this.GetType(), "addquestok", "alert('问题收藏成功');", true);
break;
case (int)AppCmn.AppEnum.CollectionType.article:
if (Request.QueryString["sysno"] == null)
{
Response.Redirect("../Error.aspx?msg=");
}
try
{
addsysno = int.Parse(Request.QueryString["sysno"]);
}
catch
{
Response.Redirect("../Error.aspx?msg=");
}
m_collection.CustomerSysNo = GetSession().CustomerEntity.SysNo;
m_collection.DR = (int)AppEnum.State.normal;
m_collection.Name = "";
m_collection.TS = DateTime.Now;
m_collection.Type = (int)AppEnum.CollectionType.article;
m_collection.RefSysNo = addsysno;
BLG_CollectionBll.GetInstance().Add(m_collection);
Page.ClientScript.RegisterStartupScript(this.GetType(), "addquestok", "alert('文章收藏成功');", true);
break;
case (int)AppCmn.AppEnum.CollectionType.famous:
if (Request.QueryString["sysno"] == null)
{
Response.Redirect("../Error.aspx?msg=");
}
try
{
addsysno = int.Parse(Request.QueryString["sysno"]);
}
catch
{
Response.Redirect("../Error.aspx?msg=");
}
m_collection.CustomerSysNo = GetSession().CustomerEntity.SysNo;
m_collection.DR = (int)AppEnum.State.normal;
m_collection.Name = "";
m_collection.TS = DateTime.Now;
m_collection.Type = (int)AppEnum.CollectionType.famous;
m_collection.RefSysNo = addsysno;
BLG_CollectionBll.GetInstance().Add(m_collection);
Page.ClientScript.RegisterStartupScript(this.GetType(), "addquestok", "alert('名人收藏成功');", true);
break;
case (int)AppCmn.AppEnum.CollectionType.chart:
FATE_ChartMod m_fate = new FATE_ChartMod();
try
{
string[] tmps = Request.QueryString["p"].Split(new char[] { '_' });
switch (Request.QueryString["minitype"].ToUpper())
{
case "ASTRO":
m_fate.CharType = (int)AppEnum.ChartType.personal;
m_fate.FirstBirth = new DateTime(int.Parse(tmps[0]), int.Parse(tmps[1]), int.Parse(tmps[2]), int.Parse(tmps[3]), int.Parse(tmps[4]), 0);
m_fate.FirstPoi = tmps[7] + "|" + tmps[6];
m_fate.Transit = DateTime.Now;
m_fate.TransitPoi = m_fate.FirstPoi;
m_fate.TheoryType = 0;
DataTable m_dist = SYS_DistrictBll.GetInstance().GetInfoByPoi(tmps[6], tmps[7]);
if (m_dist.Rows.Count > 0)
{
m_fate.FirstPoiName = m_dist.Rows[0]["Name1"] + "-" + m_dist.Rows[0]["Name2"] + "-" + m_dist.Rows[0]["Name3"];
}
else
{
m_fate.FirstPoiName = "未知";
}
m_fate.FirstTimeZone = int.Parse(tmps[8]);
m_fate.FirstGender = int.Parse(drpGender.SelectedValue);
if (tmps[5] == "1")
{
m_fate.FirstDayLight = (int)AppEnum.BOOL.True;
}
else
{
m_fate.FirstDayLight = (int)AppEnum.BOOL.False;
}
break;
case "ZIWEI":
m_fate.CharType = (int)AppEnum.ChartType.personal;
m_fate.FirstBirth = new DateTime(int.Parse(tmps[0]), int.Parse(tmps[1]), int.Parse(tmps[2]), int.Parse(tmps[3]), int.Parse(tmps[4]), 0);
m_fate.FirstPoi = "120.129798|30.259497";
m_fate.Transit = DateTime.Now;
m_fate.TransitPoi = m_fate.FirstPoi;
m_fate.TheoryType = 0;
m_fate.FirstPoiName = "浙江省-杭州市-西湖区";
m_fate.FirstTimeZone = -8;
m_fate.FirstGender = int.Parse(tmps[5]);
m_fate.FirstDayLight = (int)AppEnum.BOOL.False;
break;
case "BAZI":
m_fate.CharType = (int)AppEnum.ChartType.personal;
m_fate.FirstBirth = new DateTime(int.Parse(tmps[0]), int.Parse(tmps[1]), int.Parse(tmps[2]), int.Parse(tmps[3]), int.Parse(tmps[4]), 0);
m_fate.FirstPoi = "120.129798|30.259497";
m_fate.Transit = DateTime.Now;
m_fate.TransitPoi = m_fate.FirstPoi;
m_fate.TheoryType = 0;
m_fate.FirstPoiName = "浙江省-杭州市-西湖区";
m_fate.FirstTimeZone = -8;
m_fate.FirstGender = int.Parse(tmps[5]);
m_fate.FirstDayLight = (int)AppEnum.BOOL.False;
break;
default:
Response.Redirect("../Error.aspx?msg=");
break;
}
}
catch (Exception ex)
{
LogManagement.getInstance().WriteException(ex, "Collection-AddFate", Request.UserHostAddress, "收藏命盘失败");
Page.ClientScript.RegisterStartupScript(this.GetType(), "addwrong", "alert('系统错误，请联系管理员');", true);
}
m_collection.CustomerSysNo = GetSession().CustomerEntity.SysNo;
m_collection.DR = (int)AppEnum.State.normal;
m_collection.Name = Server.HtmlEncode(txtName.Text.Trim());
m_collection.TS = DateTime.Now;
m_collection.Type = (int)AppEnum.CollectionType.chart;
m_collection.Detail = Server.HtmlEncode(txtDetail.Text.Trim());
m_collection.RefSysNo = FATE_ChartBll.GetInstance().Add(m_fate);
BLG_CollectionBll.GetInstance().Add(m_collection);
Page.ClientScript.RegisterStartupScript(this.GetType(), "addfateok", "alert('命盘收藏成功');", true);
ModalPopupExtender1.Hide();
break;
case (int)AppCmn.AppEnum.CollectionType.url:
m_collection.CustomerSysNo = GetSession().CustomerEntity.SysNo;
m_collection.DR = (int)AppEnum.State.normal;
m_collection.Name = Server.HtmlEncode(txtName.Text.Trim());
m_collection.TS = DateTime.Now;
m_collection.Type = (int)AppEnum.CollectionType.url;
m_collection.RefUrl = Server.HtmlEncode(txtUrl.Text.Trim());
m_collection.Detail = Server.HtmlEncode(txtDetail.Text.Trim());
BLG_CollectionBll.GetInstance().Add(m_collection);
Page.ClientScript.RegisterStartupScript(this.GetType(), "addquestok", "alert('站外资源收藏成功');", true);
break;
default:
Response.Redirect("../Error.aspx?msg=");//type无效
break;
}
}
catch(Exception ex)
{
LogManagement.getInstance().WriteException(ex, "Collection-Add", Request.UserHostAddress, "添加收藏失败");
Page.ClientScript.RegisterStartupScript(this.GetType(), "addwrong", "alert('系统错误，请联系管理员');", true);
}
Response.Redirect("MyCollection.aspx?type="+type);
}
public QA_QuestionShowMini <BaZiMod> MapQA_QuestionShowMiniForBaZi(DataRow input)
{
QA_QuestionShowMini <BaZiMod> ret = new QA_QuestionShowMini <BaZiMod>();
if (input["Award"].ToString() != "")
{
ret.Award = int.Parse(input["Award"].ToString());
}
if (input["CateSysNo"].ToString() != "")
{
ret.CateSysNo = int.Parse(input["CateSysNo"].ToString());
}
#region 设置命盘
FATE_ChartMod m_chart = QA_QuestionBll.GetInstance().GetChartByQuest(int.Parse(input["SysNo"].ToString()));
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
ret.Context = input["Context"].ToString();
if (input["NickName"] == null)
{
USR_CustomerMod m_customer = USR_CustomerBll.GetInstance().GetModel(int.Parse(input["CustomerSysNo"].ToString()));
ret.CustomerNickName = m_customer.NickName;
ret.CustomerPhoto = m_customer.Photo;
}
else
{
ret.CustomerNickName = input["NickName"].ToString();
ret.CustomerPhoto = input["Photo"].ToString();
}
if (input["CustomerSysNo"].ToString() != "")
{
ret.CustomerSysNo = int.Parse(input["CustomerSysNo"].ToString());
}
ret.DR = int.Parse(input["DR"].ToString());
if (input["EndTime"].ToString() != "")
{
ret.EndTime = DateTime.Parse(input["EndTime"].ToString());
}
if (input["IsSecret"].ToString() != "")
{
ret.IsSecret = int.Parse(input["IsSecret"].ToString());
}
if (input["LastReplyTime"].ToString() != "")
{
ret.LastReplyTime = DateTime.Parse(input["LastReplyTime"].ToString());
}
if (input["LastReplyUser"].ToString() != "")
{
ret.LastReplyUser = int.Parse(input["LastReplyUser"].ToString());
}
if (input["ReadCount"].ToString() != "")
{
ret.ReadCount = int.Parse(input["ReadCount"].ToString());
}
if (input["ReplyCount"].ToString() != "")
{
ret.ReplyCount = int.Parse(input["ReplyCount"].ToString());
}
if (input["SysNo"].ToString() != "")
{
ret.SysNo = int.Parse(input["SysNo"].ToString());
}
ret.Title = input["Title"].ToString();
if (input["TS"].ToString() != "")
{
ret.TS = DateTime.Parse(input["TS"].ToString());
}
return(ret);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(FATE_ChartMod model)
{
dal.Update(model);
}
public QA_QuestionShowMini <ZiWeiMod> MapQA_QuestionShowMiniForZiWei(DataRow input)
{
QA_QuestionShowMini <ZiWeiMod> ret = new QA_QuestionShowMini <ZiWeiMod>();
if (input["Award"].ToString() != "")
{
ret.Award = int.Parse(input["Award"].ToString());
}
if (input["CateSysNo"].ToString() != "")
{
ret.CateSysNo = int.Parse(input["CateSysNo"].ToString());
}
#region 设置命盘
int[] _paras = { 1, 1, 0, 1 };
FATE_ChartMod m_chart = QA_QuestionBll.GetInstance().GetChartByQuest(int.Parse(input["SysNo"].ToString()));
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
ret.Context = input["Context"].ToString();
if (input["NickName"] == null)
{
USR_CustomerMod m_customer = USR_CustomerBll.GetInstance().GetModel(int.Parse(input["CustomerSysNo"].ToString()));
ret.CustomerNickName = m_customer.NickName;
ret.CustomerPhoto = m_customer.Photo;
}
else
{
ret.CustomerNickName = input["NickName"].ToString();
ret.CustomerPhoto = input["Photo"].ToString();
}
if (input["CustomerSysNo"].ToString() != "")
{
ret.CustomerSysNo = int.Parse(input["CustomerSysNo"].ToString());
}
ret.DR = int.Parse(input["DR"].ToString());
if (input["EndTime"].ToString() != "")
{
ret.EndTime = DateTime.Parse(input["EndTime"].ToString());
}
if (input["IsSecret"].ToString() != "")
{
ret.IsSecret = int.Parse(input["IsSecret"].ToString());
}
if (input["LastReplyTime"].ToString() != "")
{
ret.LastReplyTime = DateTime.Parse(input["LastReplyTime"].ToString());
}
if (input["LastReplyUser"].ToString() != "")
{
ret.LastReplyUser = int.Parse(input["LastReplyUser"].ToString());
}
if (input["ReadCount"].ToString() != "")
{
ret.ReadCount = int.Parse(input["ReadCount"].ToString());
}
if (input["ReplyCount"].ToString() != "")
{
ret.ReplyCount = int.Parse(input["ReplyCount"].ToString());
}
if (input["SysNo"].ToString() != "")
{
ret.SysNo = int.Parse(input["SysNo"].ToString());
}
ret.Title = input["Title"].ToString();
if (input["TS"].ToString() != "")
{
ret.TS = DateTime.Parse(input["TS"].ToString());
}
return(ret);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(FATE_ChartMod model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update FATE_Chart set ");
strSql.Append("FirstBirth=@FirstBirth,");
strSql.Append("FirstPoi=@FirstPoi,");
strSql.Append("Transit=@Transit,");
strSql.Append("TransitPoi=@TransitPoi,");
strSql.Append("SecondBirth=@SecondBirth,");
strSql.Append("SecondPoi=@SecondPoi,");
strSql.Append("CharType=@CharType,");
strSql.Append("TheoryType=@TheoryType,");
strSql.Append("Bitvalue=@Bitvalue,");
strSql.Append("DR=@DR,");
strSql.Append("TS=@TS,");
strSql.Append("FirstDayLight=@FirstDayLight,");
strSql.Append("SecondDayLight=@SecondDayLight,");
strSql.Append("FirstPoiName=@FirstPoiName,");
strSql.Append("SecondPoiName=@SecondPoiName,");
strSql.Append("FirstTimeZone=@FirstTimeZone,");
strSql.Append("SecondTimeZone=@SecondTimeZone,");
strSql.Append("FirstGender=@FirstGender,");
strSql.Append("SecondGender=@SecondGender");
strSql.Append(" where SysNo=@SysNo ");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters = {
new SqlParameter("@SysNo",SqlDbType.Int,4),
new SqlParameter("@FirstBirth",SqlDbType.DateTime),
new SqlParameter("@FirstPoi",SqlDbType.VarChar,100),
new SqlParameter("@Transit",SqlDbType.DateTime),
new SqlParameter("@TransitPoi",SqlDbType.VarChar,100),
new SqlParameter("@SecondBirth",SqlDbType.DateTime),
new SqlParameter("@SecondPoi",SqlDbType.VarChar,100),
new SqlParameter("@CharType",SqlDbType.Int,4),
new SqlParameter("@TheoryType",SqlDbType.TinyInt,1),
new SqlParameter("@Bitvalue",SqlDbType.VarChar,100),
new SqlParameter("@DR",SqlDbType.TinyInt,1),
new SqlParameter("@TS",SqlDbType.DateTime),
new SqlParameter("@FirstDayLight",SqlDbType.Int,4),
new SqlParameter("@SecondDayLight",SqlDbType.Int,4),
new SqlParameter("@FirstPoiName",SqlDbType.VarChar,100),
new SqlParameter("@SecondPoiName",SqlDbType.VarChar,100),
new SqlParameter("@FirstTimeZone",SqlDbType.Int,4),
new SqlParameter("@SecondTimeZone",SqlDbType.Int,4),
new SqlParameter("@FirstGender",SqlDbType.Int,4),
new SqlParameter("@SecondGender",SqlDbType.Int,4)
};
if (model.SysNo != AppConst.IntNull)
parameters[0].Value = model.SysNo;
else
parameters[0].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[0]);
if (model.FirstBirth != AppConst.DateTimeNull)
parameters[1].Value = model.FirstBirth;
else
parameters[1].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[1]);
if (model.FirstPoi != AppConst.StringNull)
parameters[2].Value = model.FirstPoi;
else
parameters[2].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[2]);
if (model.Transit != AppConst.DateTimeNull)
parameters[3].Value = model.Transit;
else
parameters[3].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[3]);
if (model.TransitPoi != AppConst.StringNull)
parameters[4].Value = model.TransitPoi;
else
parameters[4].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[4]);
if (model.SecondBirth != AppConst.DateTimeNull)
parameters[5].Value = model.SecondBirth;
else
parameters[5].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[5]);
if (model.SecondPoi != AppConst.StringNull)
parameters[6].Value = model.SecondPoi;
else
parameters[6].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[6]);
if (model.CharType != AppConst.IntNull)
parameters[7].Value = model.CharType;
else
parameters[7].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[7]);
if (model.TheoryType != AppConst.IntNull)
parameters[8].Value = model.TheoryType;
else
parameters[8].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[8]);
if (model.Bitvalue != AppConst.StringNull)
parameters[9].Value = model.Bitvalue;
else
parameters[9].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[9]);
if (model.DR != AppConst.IntNull)
parameters[10].Value = model.DR;
else
parameters[10].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[10]);
if (model.TS != AppConst.DateTimeNull)
parameters[11].Value = model.TS;
else
parameters[11].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[11]);
if (model.FirstDayLight != AppConst.IntNull)
parameters[12].Value = model.FirstDayLight;
else
parameters[12].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[12]);
if (model.SecondDayLight != AppConst.IntNull)
parameters[13].Value = model.SecondDayLight;
else
parameters[13].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[13]);
if (model.FirstPoiName != AppConst.StringNull)
parameters[14].Value = model.FirstPoiName;
else
parameters[14].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[14]);
if (model.SecondPoiName != AppConst.StringNull)
parameters[15].Value = model.SecondPoiName;
else
parameters[15].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[15]);
if (model.FirstTimeZone != AppConst.IntNull)
parameters[16].Value = model.FirstTimeZone;
else
parameters[16].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[16]);
if (model.SecondTimeZone != AppConst.IntNull)
parameters[17].Value = model.SecondTimeZone;
else
parameters[17].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[17]);
if (model.FirstGender != AppConst.IntNull)
parameters[18].Value = model.FirstGender;
else
parameters[18].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[18]);
if (model.SecondGender != AppConst.IntNull)
parameters[19].Value = model.SecondGender;
else
parameters[19].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[19]);
return SqlHelper.ExecuteNonQuery(cmd, parameters);
}
protected void BindData()
{
try
{
if (m_qustion.DR != (int)AppEnum.State.normal)
{
ShowError("");
}
m_qustion.ReadCount++;
QA_QuestionBll.GetInstance().Update(m_qustion);
ltrTitle.Text = m_qustion.Title;
ltrContext.Text = m_qustion.Context;
ltrAward.Text = m_qustion.Award.ToString();
ltrReply.Text = m_qustion.ReplyCount.ToString();
ltrTime.Text = m_qustion.TS.ToString("yyyy-MM-dd HH:mm:ss");
ltrViewNum.Text = m_qustion.ReadCount.ToString();
if (GetSession().CustomerEntity.SysNo == m_qustion.CustomerSysNo)
{
LinkButton5.Style["display"] = "";
ltrTime.Text += " | ";
}
USR_CustomerMod m_user = USR_CustomerBll.GetInstance().GetModel(m_qustion.CustomerSysNo);
USR_GradeMod m_grade = USR_GradeBll.GetInstance().GetModel(m_user.GradeSysNo);
ltrNickName.Text = m_user.NickName;
ltrQALevel.Text = m_grade.Name;
ltrTotalReply.Text = m_user.TotalReply.ToString();
ltrTotalAsk.Text = m_user.TotalQuest.ToString();
Image1.ImageUrl = AppConfig.HomeUrl() + "ControlLibrary/ShowPhoto.aspx?type=t&id=" + m_user.Photo;
#region 显示命盘
FATE_ChartMod m_chart = QA_QuestionBll.GetInstance().GetChartByQuest(SysNo);
if (m_chart != null && m_chart.SysNo != AppConst.IntNull)
{
if (GetSession().CustomerEntity == null || GetSession().CustomerEntity.SysNo == AppConst.IntNull)
{
Astro1.input = m_chart;
Astro1.Visible = true;
}
else if (GetSession().CustomerEntity.FateType == (int)AppEnum.FateType.ziwei)
{
Ziwei1.input = m_chart;
Ziwei1.Visible = true;
}
else if (GetSession().CustomerEntity.FateType == (int)AppEnum.FateType.bazi)
{
Bazi1.input = m_chart;
Bazi1.Visible = true;
}
else
{
Astro1.input = m_chart;
Astro1.Visible = true;
}
}
#endregion
BindList();
}
catch
{
ShowError("");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(FATE_ChartMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FATE_Chart set ");
strSql.Append("FirstBirth=@FirstBirth,");
strSql.Append("FirstPoi=@FirstPoi,");
strSql.Append("Transit=@Transit,");
strSql.Append("TransitPoi=@TransitPoi,");
strSql.Append("SecondBirth=@SecondBirth,");
strSql.Append("SecondPoi=@SecondPoi,");
strSql.Append("CharType=@CharType,");
strSql.Append("TheoryType=@TheoryType,");
strSql.Append("Bitvalue=@Bitvalue,");
strSql.Append("DR=@DR,");
strSql.Append("TS=@TS,");
strSql.Append("FirstDayLight=@FirstDayLight,");
strSql.Append("SecondDayLight=@SecondDayLight,");
strSql.Append("FirstPoiName=@FirstPoiName,");
strSql.Append("SecondPoiName=@SecondPoiName,");
strSql.Append("FirstTimeZone=@FirstTimeZone,");
strSql.Append("SecondTimeZone=@SecondTimeZone,");
strSql.Append("FirstGender=@FirstGender,");
strSql.Append("SecondGender=@SecondGender");
strSql.Append(" where SysNo=@SysNo ");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters =
{
new SqlParameter("@SysNo", SqlDbType.Int, 4),
new SqlParameter("@FirstBirth", SqlDbType.DateTime),
new SqlParameter("@FirstPoi", SqlDbType.VarChar, 100),
new SqlParameter("@Transit", SqlDbType.DateTime),
new SqlParameter("@TransitPoi", SqlDbType.VarChar, 100),
new SqlParameter("@SecondBirth", SqlDbType.DateTime),
new SqlParameter("@SecondPoi", SqlDbType.VarChar, 100),
new SqlParameter("@CharType", SqlDbType.Int, 4),
new SqlParameter("@TheoryType", SqlDbType.TinyInt, 1),
new SqlParameter("@Bitvalue", SqlDbType.VarChar, 100),
new SqlParameter("@DR", SqlDbType.TinyInt, 1),
new SqlParameter("@TS", SqlDbType.DateTime),
new SqlParameter("@FirstDayLight", SqlDbType.Int, 4),
new SqlParameter("@SecondDayLight", SqlDbType.Int, 4),
new SqlParameter("@FirstPoiName", SqlDbType.VarChar, 100),
new SqlParameter("@SecondPoiName", SqlDbType.VarChar, 100),
new SqlParameter("@FirstTimeZone", SqlDbType.Int, 4),
new SqlParameter("@SecondTimeZone", SqlDbType.Int, 4),
new SqlParameter("@FirstGender", SqlDbType.Int, 4),
new SqlParameter("@SecondGender", SqlDbType.Int, 4)
};
if (model.SysNo != AppConst.IntNull)
{
parameters[0].Value = model.SysNo;
}
else
{
parameters[0].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[0]);
if (model.FirstBirth != AppConst.DateTimeNull)
{
parameters[1].Value = model.FirstBirth;
}
else
{
parameters[1].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[1]);
if (model.FirstPoi != AppConst.StringNull)
{
parameters[2].Value = model.FirstPoi;
}
else
{
parameters[2].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[2]);
if (model.Transit != AppConst.DateTimeNull)
{
parameters[3].Value = model.Transit;
}
else
{
parameters[3].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[3]);
if (model.TransitPoi != AppConst.StringNull)
{
parameters[4].Value = model.TransitPoi;
}
else
{
parameters[4].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[4]);
if (model.SecondBirth != AppConst.DateTimeNull)
{
parameters[5].Value = model.SecondBirth;
}
else
{
parameters[5].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[5]);
if (model.SecondPoi != AppConst.StringNull)
{
parameters[6].Value = model.SecondPoi;
}
else
{
parameters[6].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[6]);
if (model.CharType != AppConst.IntNull)
{
parameters[7].Value = model.CharType;
}
else
{
parameters[7].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[7]);
if (model.TheoryType != AppConst.IntNull)
{
parameters[8].Value = model.TheoryType;
}
else
{
parameters[8].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[8]);
if (model.Bitvalue != AppConst.StringNull)
{
parameters[9].Value = model.Bitvalue;
}
else
{
parameters[9].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[9]);
if (model.DR != AppConst.IntNull)
{
parameters[10].Value = model.DR;
}
else
{
parameters[10].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[10]);
if (model.TS != AppConst.DateTimeNull)
{
parameters[11].Value = model.TS;
}
else
{
parameters[11].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[11]);
if (model.FirstDayLight != AppConst.IntNull)
{
parameters[12].Value = model.FirstDayLight;
}
else
{
parameters[12].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[12]);
if (model.SecondDayLight != AppConst.IntNull)
{
parameters[13].Value = model.SecondDayLight;
}
else
{
parameters[13].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[13]);
if (model.FirstPoiName != AppConst.StringNull)
{
parameters[14].Value = model.FirstPoiName;
}
else
{
parameters[14].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[14]);
if (model.SecondPoiName != AppConst.StringNull)
{
parameters[15].Value = model.SecondPoiName;
}
else
{
parameters[15].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[15]);
if (model.FirstTimeZone != AppConst.IntNull)
{
parameters[16].Value = model.FirstTimeZone;
}
else
{
parameters[16].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[16]);
if (model.SecondTimeZone != AppConst.IntNull)
{
parameters[17].Value = model.SecondTimeZone;
}
else
{
parameters[17].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[17]);
if (model.FirstGender != AppConst.IntNull)
{
parameters[18].Value = model.FirstGender;
}
else
{
parameters[18].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[18]);
if (model.SecondGender != AppConst.IntNull)
{
parameters[19].Value = model.SecondGender;
}
else
{
parameters[19].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[19]);
return(SqlHelper.ExecuteNonQuery(cmd, parameters));
}
protected void Unnamed3_Click(object sender, EventArgs e)
{
Login(Request.Url.ToString());
#region 判断输入项
if (drpCate.SelectedIndex == 0)
{
CateTip.InnerHtml = "请选择分类";
CateTip.Attributes["class"] = "err";
Page.ClientScript.RegisterStartupScript(this.GetType(), "typemodify", "qaTypeChanged(document.getElementById('" + drpType.ClientID + "'));", true);
return;
}
if (txtTitle.Text.Trim() == "")
{
TitleTip.InnerHtml = "请输入标题";
TitleTip.Attributes["class"] = "err";
Page.ClientScript.RegisterStartupScript(this.GetType(), "typemodify", "qaTypeChanged(document.getElementById('" + drpType.ClientID + "'));", true);
return;
}
if (txtTitle.Text.Trim().Length > 200)
{
TitleTip.InnerHtml = "您输入的标题太长，请控制在200字以内";
TitleTip.Attributes["class"] = "err";
Page.ClientScript.RegisterStartupScript(this.GetType(), "typemodify", "qaTypeChanged(document.getElementById('" + drpType.ClientID + "'));", true);
return;
}
#endregion
try
{
QA_QuestionMod m_quest = new QA_QuestionMod();
m_quest.Award = 0;
m_quest.CateSysNo = int.Parse(drpCate.SelectedValue);
m_quest.Context = SQLData.SQLFilter(AppCmn.CommonTools.StringFilter(txtContext.Text.Trim()));
m_quest.CustomerSysNo = GetSession().CustomerEntity.SysNo;
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(txtTitle.Text.Trim());
m_quest.TS = DateTime.Now;
m_quest.DR = (int)AppEnum.State.normal;
int sysno = 0;
QA_QuestionBll.GetInstance().AddQuest(ref m_quest, false);
sysno = m_quest.SysNo;
RefreshSession();
FATE_ChartMod m_chart = new FATE_ChartMod();
m_chart.CharType = int.Parse(drpType.SelectedValue);
if (m_chart.CharType != (int)AppEnum.ChartType.nochart)
{
m_chart.FirstBirth = DatePicker1.SelectedTime;
m_chart.FirstPoi = District1.lng + "|" + District1.lat;
m_chart.Transit = DateTime.Now;
m_chart.TransitPoi = m_chart.FirstPoi;
m_chart.TheoryType = 0;
m_chart.FirstPoiName = District1.Area1Name + "-" + District1.Area2Name + "-" + District1.Area3Name;
m_chart.FirstTimeZone = -8;
m_chart.FirstGender = int.Parse(drpGender1.SelectedValue);
if (chkDaylight1.Checked)
{
m_chart.FirstDayLight = (int)AppEnum.BOOL.True;
}
else
{
m_chart.FirstDayLight = (int)AppEnum.BOOL.False;
}
if (m_chart.CharType == (int)AppEnum.ChartType.relation)
{
m_chart.SecondBirth = DatePicker2.SelectedTime;
m_chart.SecondPoi = District2.lng + "|" + District2.lat;
m_chart.SecondPoiName = District2.Area1Name + "-" + District2.Area2Name + "-" + District2.Area3Name;
m_chart.SecondTimeZone = -8;
m_chart.SecondGender = int.Parse(drpGender2.SelectedValue);
if (chkDaylight2.Checked)
{
m_chart.SecondDayLight = (int)AppEnum.BOOL.True;
}
else
{
m_chart.SecondDayLight = (int)AppEnum.BOOL.False;
}
}
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);
}
LogManagement.getInstance().WriteTrace("前台话题", "Ask", "IP:" + Request.UserHostAddress + "|UID:" + GetSession().CustomerEntity.Email);
Page.ClientScript.RegisterStartupScript(this.GetType(), "askok", "alert('话题发布成功！');", true);
Response.Redirect(AppConfig.HomeUrl() + "Quest/Topic/" + sysno, false);
}
catch (Exception ex)
{
LogManagement.getInstance().WriteException(ex, "QA-Add", Request.UserHostAddress, "发布话题失败");
Page.ClientScript.RegisterStartupScript(this.GetType(), "askok", "alert('系统故障，请联系管理员！');", true);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FATE_ChartMod GetModel(int SysNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SysNo, FirstBirth, FirstPoi, Transit, TransitPoi, SecondBirth, SecondPoi, CharType, TheoryType, Bitvalue, DR, TS, FirstDayLight, SecondDayLight, FirstPoiName, SecondPoiName, FirstTimeZone, SecondTimeZone, FirstGender, SecondGender from FATE_Chart");
strSql.Append(" where SysNo=@SysNo ");
SqlParameter[] parameters =
{
new SqlParameter("@SysNo", SqlDbType.Int, 4)
};
parameters[0].Value = SysNo;
FATE_ChartMod model = new FATE_ChartMod();
DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "")
{
model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString());
}
if (ds.Tables[0].Rows[0]["FirstBirth"].ToString() != "")
{
model.FirstBirth = DateTime.Parse(ds.Tables[0].Rows[0]["FirstBirth"].ToString());
}
model.FirstPoi = ds.Tables[0].Rows[0]["FirstPoi"].ToString();
if (ds.Tables[0].Rows[0]["Transit"].ToString() != "")
{
model.Transit = DateTime.Parse(ds.Tables[0].Rows[0]["Transit"].ToString());
}
model.TransitPoi = ds.Tables[0].Rows[0]["TransitPoi"].ToString();
if (ds.Tables[0].Rows[0]["SecondBirth"].ToString() != "")
{
model.SecondBirth = DateTime.Parse(ds.Tables[0].Rows[0]["SecondBirth"].ToString());
}
model.SecondPoi = ds.Tables[0].Rows[0]["SecondPoi"].ToString();
if (ds.Tables[0].Rows[0]["CharType"].ToString() != "")
{
model.CharType = int.Parse(ds.Tables[0].Rows[0]["CharType"].ToString());
}
if (ds.Tables[0].Rows[0]["TheoryType"].ToString() != "")
{
model.TheoryType = int.Parse(ds.Tables[0].Rows[0]["TheoryType"].ToString());
}
model.Bitvalue = ds.Tables[0].Rows[0]["Bitvalue"].ToString();
if (ds.Tables[0].Rows[0]["DR"].ToString() != "")
{
model.DR = int.Parse(ds.Tables[0].Rows[0]["DR"].ToString());
}
if (ds.Tables[0].Rows[0]["TS"].ToString() != "")
{
model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString());
}
if (ds.Tables[0].Rows[0]["FirstDayLight"].ToString() != "")
{
model.FirstDayLight = int.Parse(ds.Tables[0].Rows[0]["FirstDayLight"].ToString());
}
if (ds.Tables[0].Rows[0]["SecondDayLight"].ToString() != "")
{
model.SecondDayLight = int.Parse(ds.Tables[0].Rows[0]["SecondDayLight"].ToString());
}
model.FirstPoiName = ds.Tables[0].Rows[0]["FirstPoiName"].ToString();
model.SecondPoiName = ds.Tables[0].Rows[0]["SecondPoiName"].ToString();
if (ds.Tables[0].Rows[0]["FirstTimeZone"].ToString() != "")
{
model.FirstTimeZone = int.Parse(ds.Tables[0].Rows[0]["FirstTimeZone"].ToString());
}
if (ds.Tables[0].Rows[0]["SecondTimeZone"].ToString() != "")
{
model.SecondTimeZone = int.Parse(ds.Tables[0].Rows[0]["SecondTimeZone"].ToString());
}
if (ds.Tables[0].Rows[0]["FirstGender"].ToString() != "")
{
model.FirstGender = int.Parse(ds.Tables[0].Rows[0]["FirstGender"].ToString());
}
if (ds.Tables[0].Rows[0]["SecondGender"].ToString() != "")
{
model.SecondGender = int.Parse(ds.Tables[0].Rows[0]["SecondGender"].ToString());
}
return(model);
}
else
{
return(null);
}
}
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));
}
