protected void Getdata()
{
Model.Feedback feedback = new Model.Feedback();
BLL.FeedbackManager feedbackManager = new BLL.FeedbackManager();
//今天数据
// string Day1 = DateTime.Now.AddDays(0).ToString("yyyy-MM-dd");
DateTime Stime1 = DateTime.Now.AddDays(0).Date;
DateTime Etime1 = DateTime.Now.AddDays(1).Date;
string strWhere1 = "feedbackTime>'" + Stime1 + "'and feedbackTime<'" + Etime1 + "'";
int rows1 = feedbackManager.GetRecordCount(strWhere1);
LabelDdayNum.Text = rows1.ToString();
// LabelDay1.Text = Day1;
LabelNum1.Text = rows1.ToString();
string Day1 = GetDay1();
//昨天数据
string Day2 = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
DateTime Stime2 = DateTime.Now.AddDays(-1).Date;
DateTime Etime2 = DateTime.Now.AddDays(0).Date;
string strWhere2 = "feedbackTime>'" + Stime2 + "'and feedbackTime<'" + Etime2 + "'";
int rows2 = feedbackManager.GetRecordCount(strWhere2);
LabelYdayNum.Text = rows2.ToString();
LabelDay2.Text = Day2;
LabelNum2.Text = rows2.ToString();
}
protected void Bind()
{
Model.Feedback feedback1 = new Model.Feedback();
BLL.FeedbackManager feedback2 = new BLL.FeedbackManager();
GridView1.DataSource = feedback2.GetAllList();
GridView1.DataBind();
}
protected void Gettxt()
{
Model.Feedback feedback = new Model.Feedback();
BLL.FeedbackManager feedbackManager = new BLL.FeedbackManager();
DataSet ds = feedbackManager.GetTXTList();
Response.Clear();
Response.Buffer = false;
Response.Charset = "utf - 8";
DateTime dt = System.DateTime.Now;
string str = dt.ToString("yyyyMMddhhmmss");
Response.AppendHeader("Content-Disposition", "attachment;filename=" + str + ".txt");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.ContentType = "application/ms-txt";
Response.Write("<meta http-equiv=Content-Type;content=/text/html;charset=utf-8/>");
System.IO.StringWriter sw = new System.IO.StringWriter();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
{
sw.WriteLine(ds.Tables[0].Rows[i][j].ToString().Trim() + "\t");
}
sw.WriteLine("\r \n");
}
HttpContext.Current.Response.Write(sw.ToString());
sw.Close();
HttpContext.Current.Response.End();
}
protected int GetGSexDataALL()
{
Model.Feedback feedback = new Model.Feedback();
BLL.FeedbackManager feedbackManager = new BLL.FeedbackManager();
string StrAll = "gender='" + "女" + "'";
int GnumAll = feedbackManager.GetRecordCountNum(StrAll);
return(GnumAll);
}
protected void btn_Dealwith_Click(object sender, EventArgs e)
{
BLL.FeedbackManager feedbackManager = new BLL.FeedbackManager();
Model.Feedback modelFeedback = new Model.Feedback();
modelFeedback.solutionState = "已解决";
if (feedbackManager.Update(modelFeedback))
{
Response.Write("~/Index.aspx");
}
}
protected void GetSolution()
{
Model.Feedback feedback = new Model.Feedback();
BLL.FeedbackManager feedbackManager = new BLL.FeedbackManager();
DateTime StimeW = DateTime.Now;
DateTime EtimeW = DateTime.Now.AddDays(0).Date;
string strWhere5 = "feedbackTime>'" + StimeW + "'and feedbackTime<'" + EtimeW + "'and solutionState='" + "1" + "'";
int rows5 = feedbackManager.GetRecordCount(strWhere5);
LabelWSolve.Text = rows5.ToString();
int Sum = feedbackManager.GetAllRecordCount();
int NSolve = Sum - rows5;
LabelNSolve.Text = Convert.ToString(NSolve);
}
protected void Page_Load(object sender, EventArgs e)
{
Model.Feedback feedback1 = new Model.Feedback();
BLL.FeedbackManager feedback2 = new BLL.FeedbackManager();
}
