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