protected void ImageButtonSend_Click(object sender, ImageClickEventArgs e)
{
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString);
SqlCommand sqlCmd = new SqlCommand("sp_messagesSendAdd", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@SenderId", SqlDbType.Int).Value = Convert.ToInt32(Session["UserId"]);
sqlCmd.Parameters.Add("@SenderType", SqlDbType.Int).Value = 1;
sqlCmd.Parameters.Add("@ReceiverId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["Id"].ToString());
sqlCmd.Parameters.Add("@ReceiverType", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["Type"].ToString());
sqlCmd.Parameters.Add("@Message", SqlDbType.NVarChar).Value = TextBoxMessage.Text;
if (TextBoxMessage.Text.Length < 100)
{
sqlCmd.Parameters.Add("@Brief", SqlDbType.NVarChar).Value = TextBoxMessage.Text;
}
else
{
sqlCmd.Parameters.Add("@Brief", SqlDbType.NVarChar).Value = TextBoxMessage.Text.Substring(0, 100);
}
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
sqlCmd.Dispose();
sqlConn.Dispose();
TextBoxMessage.Text = "";
GridViewMessages.DataBind();
}
private void BindData()
{
using (var context = new ApplicationDbContext())
{
GridViewMessages.DataSource = context.Messages.ToList();
GridViewMessages.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserID"] != null)
{
userID = Int32.Parse(Session["UserID"].ToString());
eRegisterData.DAL DAL = new eRegisterData.DAL();
SqlConnection conn = DAL.getSubject();
SqlCommand comm = new SqlCommand();
try
{
conn.Open();
comm.Connection = conn;
comm.CommandText = @" SELECT ActorID
FROM Actors
WHERE UserID='" + userID + "'";
studentID = Int32.Parse(comm.ExecuteScalar().ToString());
conn.Close();
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
System.Data.DataTable message = new System.Data.DataTable();
eRegisterData.DAL oDAL1 = new eRegisterData.DAL();
message = oDAL1.GetUsersMessages(studentID, 0);
GridViewMessages.DataSource = message.DefaultView;
GridViewMessages.DataBind();
if (!IsPostBack)
{
System.Data.DataTable messageTypeInfo = new System.Data.DataTable();
eRegisterData.DAL oDal = new eRegisterData.DAL();
messageTypeInfo = oDal.getMessageType();
DropDownListMessageType.DataSource = messageTypeInfo.DefaultView;
DropDownListMessageType.DataTextField = messageTypeInfo.Columns["Type"].ColumnName.ToString();
DropDownListMessageType.DataValueField = messageTypeInfo.Columns["MessageTypeID"].ColumnName.ToString();
DropDownListMessageType.DataBind();
DropDownListMessageType.Items.Add(new ListItem("Моля изберете", "-1"));
DropDownListMessageType.SelectedIndex = DropDownListMessageType.Items.Count - 1;
}
}
else
{
Response.Redirect("~/eRegister.aspx");
}
}
protected void DropDownListMessageType_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownListMessageType.SelectedIndex == DropDownListMessageType.Items.Count - 1)
{
System.Data.DataTable message = new System.Data.DataTable();
eRegisterData.DAL oDAL1 = new eRegisterData.DAL();
message = oDAL1.GetUsersMessages(studentID, 0);
GridViewMessages.DataSource = message.DefaultView;
GridViewMessages.DataBind();
}
else
{
System.Data.DataTable messageType = new System.Data.DataTable();
eRegisterData.DAL oDAL = new eRegisterData.DAL();
messageType = oDAL.GetUsersMessages(studentID, Int32.Parse(DropDownListMessageType.SelectedValue));
GridViewMessages.DataSource = messageType.DefaultView;
GridViewMessages.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserID"] != null)
{
userID = Int32.Parse(Session["UserID"].ToString());
eRegisterData.DAL DAL = new eRegisterData.DAL();
SqlConnection conn = DAL.getSubject();
SqlCommand comm = new SqlCommand();
try
{
conn.Open();
comm.Connection = conn;
comm.CommandText = @" SELECT ActorID
FROM Actors
WHERE UserID='" + userID + "'";
studentID = Int32.Parse(comm.ExecuteScalar().ToString());
conn.Close();
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
System.Data.DataTable message = new System.Data.DataTable();
eRegisterData.DAL oDAL1 = new eRegisterData.DAL();
message = oDAL1.GetUsersMessages(studentID, 0);
GridViewMessages.DataSource = message.DefaultView;
GridViewMessages.DataBind();
}
else
{
Response.Redirect("~/eRegister.aspx");
}
}
private void buildPositionReport(DateTime reportStart, DateTime reportEnd, string fundCode)
{
try
{
//基金类型数据
DataTable dtFund = DataService.GetInstance().GetPortfolioList();
DataRow oFundRow = null;
if (dtFund != null)
{
for (int i = 0; i < dtFund.Rows.Count; i++)
{
string fcode = dtFund.Rows[i]["Code"].ToString();
if (fcode == fundCode)
{
oFundRow = dtFund.Rows[i];
break;
}
}
}
if (oFundRow == null)
{
LabelStatus.Text = "未知的代码！";
return;
}
string fundName = oFundRow["Name"].ToString();
string benchmarkname = oFundRow["Benchmark"].ToString();
string benchmarkcode = oFundRow["BenchmarkCode"].ToString();
DataTable dtGZB = DataService.GetInstance().GetGZB(reportStart, reportEnd, fundCode, null);
Performance p = new Performance();
p.LoadData(dtGZB, Security.Portfolio.PortfolioDataAdapterType.YSS, reportStart, reportEnd, benchmarkcode);
p.Attribute();
//基本信息
string html = this.getFundInfo(p, fundCode, fundName, benchmarkname);
spFundInfo.InnerHtml = html;
//归因分析
GridViewIndustry.DataSource = p.GetAttributionTable();
GridViewIndustry.DataBind();
//持仓分析
GridViewEquityPositionDetail.DataSource = p.GetPositionTable(SecurityType.Equity);
GridViewEquityPositionDetail.DataBind();
GridViewEquityPositionDetail.Caption = "股票持仓（" + p.PortfGroup.GetLatestPortfolio().EquityHoldings.Position.MarketValuePct.ToString("P2") + "）";
GridViewBondPositionDetail.DataSource = p.GetPositionTable(SecurityType.Bond);
GridViewBondPositionDetail.DataBind();
GridViewBondPositionDetail.Caption = "债券持仓（" + p.PortfGroup.GetLatestPortfolio().BondHoldings.Position.MarketValuePct.ToString("P2") + "）";
GridViewFundPositionDetail.DataSource = p.GetPositionTable(SecurityType.Fund);
GridViewFundPositionDetail.DataBind();
GridViewFundPositionDetail.Caption = "基金持仓（" + p.PortfGroup.GetLatestPortfolio().FundHoldings.Position.MarketValuePct.ToString("P2") + "）";
GridViewRevRepoPositionDetail.DataSource = p.GetPositionTable(SecurityType.RevRepo);
GridViewRevRepoPositionDetail.DataBind();
GridViewRevRepoPositionDetail.Caption = "逆回购持仓（" + p.PortfGroup.GetLatestPortfolio().RevRepoHoldings.Position.MarketValuePct.ToString("P2") + "）";
GridViewTheRepoPositionDetail.DataSource = p.GetPositionTable(SecurityType.TheRepo);
GridViewTheRepoPositionDetail.DataBind();
GridViewTheRepoPositionDetail.Caption = "正回购持仓（" + p.PortfGroup.GetLatestPortfolio().TheRepoHoldings.Position.MarketValuePct.ToString("P2") + "）";
GridViewCashPositionDetail.DataSource = p.GetPositionTable(SecurityType.Deposit);
GridViewCashPositionDetail.DataBind();
GridViewCashPositionDetail.Caption = "现金持仓（" + p.PortfGroup.GetLatestPortfolio().CashHoldings.Position.MarketValuePct.ToString("P2") + "）";
//交易记录
GridViewTransactionDetail.DataSource = p.GetTransactionTable();
GridViewTransactionDetail.DataBind();
//消息
GridViewMessages.DataSource = MessageManager.GetInstance().GetMessageTable();
GridViewMessages.DataBind();
}
catch (Exception ex)
{
LabelStatus.Visible = true;
LabelStatus.Text = ex.Message;
}
}
protected void GridViewMessages_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridViewMessages.PageIndex = e.NewPageIndex;
GridViewMessages.DataBind();
}
