protected void But_submit_Click(object sender, EventArgs e)
{
Model.Feedback feedback = new Model.Feedback();
feedback.categoryID = int.Parse(this.DropDownList_Category.SelectedValue);
feedback.Info = txbInfo.Text.Trim();
feedback.contact = txbContact.Text.Trim();
feedback.handler = "未处理";
feedback.UserID = Convert.ToInt32(Session["userID"]);
BLL.FeedbackManager feedbackManager = new FeedbackManager();
bool bo = feedbackManager.Add(feedback);
if (bo == true)
{
Response.Write("<script language=javascript>alert('提交成功')</script>");
txbContact.Text = "";
txbInfo.Text = "";
this.DropDownList_Category.SelectedIndex = 0;
}
else
{
Response.Write("<script language=javascript>alert('提交失败！请重试')");
}
}
public async Task <IActionResult> Post([FromBody] Model.Feedback feedback)
{
_feedbackContext.Feedback.Add(feedback);
await _feedbackContext.SaveChangesAsync();
return(StatusCode(StatusCodes.Status201Created));
}
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 void Bind()
{
Model.Feedback feedback1 = new Model.Feedback();
BLL.FeedbackManager feedback2 = new BLL.FeedbackManager();
GridView1.DataSource = feedback2.GetAllList();
GridView1.DataBind();
}
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();
}
public void Delete(Feedback model)
{
#region 取資料
Model.Feedback query = this.Get(model.ID_Feedback);
//var queryoverseastaff = this._overseaService.GetForOverType(query.ID_OverType);
#endregion
#region 邏輯驗證
if (query == null)//沒有資料
{
throw new Exception("MessageNoData".ToLocalized());
}
//驗證
//if (queryoverseastaff == null)//沒有資料
// throw new Exception("MessageDataHasLinking".ToLocalized());
#endregion
#region 變為Models需要之型別及邏輯資料
#endregion
#region Models資料庫
this._repository.Delete(query);
this._unitOfWork.SaveChange();
#endregion
}
protected void UpdateFeedback(object sender, EventArgs e)
{
Model.Distribution distribution = new Model.Distribution();
BLL.DistributionManager manager = new DistributionManager();
BLL.AdminManager adminManager1 = new BLL.AdminManager();
Model.Admin admin1 = adminManager1.GetModel1(Session["SadminID"].ToString());
string handlers = DropDownList_Distribution.SelectedItem.Text;
Model.Feedback feedback = new Model.Feedback();
BLL.FeedbackManager Fmanager = new FeedbackManager();
feedback.feedbackID = Convert.ToInt32(Labeltest.Text.Trim());
feedback.handler = handlers;
string Str1 = "handler='" + handlers + "'";
string Str2 = "feedbackID='" + Labeltest.Text.Trim() + "'";
bool bo2 = Fmanager.UpdateHandler(Str1, Str2);
if (bo2 == true)
{
Response.Write("<script language=javascript>alert('修改成功！')</script>");
BindY();
BindN();
}
}
protected void Btn_Solve_Click(object sender, EventArgs e)
{
string state = "1";
string idList = GetSelIDList();
if (idList.Trim().Length == 0)
{
return;
}
BLL.DistributionManager manager = new BLL.DistributionManager();
manager.UpdateList(state, idList);
Response.Write("<script language=javascript>alert('标记成功！')</script>");
NewBind();
HisBind();
Model.Feedback feedback = new Model.Feedback();
BLL.FeedbackManager Fmanager = new FeedbackManager();
BLL.AdminManager adminManager1 = new BLL.AdminManager();
Model.Admin admin1 = adminManager1.GetModel1(Session["GadminID"].ToString());
int ID = Convert.ToInt32(admin1.adminID);
string Str1 = "solutionState='" + state + "'";
string Str2 = "adminID='" + ID + "' and state = '" + state + "'";
Fmanager.UpdateSolution(Str1, Str2);
}
public static TModel FromFeedback <TModel>(Model.Feedback feedback) where
TModel : FeedbackApiModel, new()
{
var model = new TModel();
model.Id = feedback.Id;
return(model);
}
public async Task <string> UpdateFeedback(int Id, Model.Feedback _Feedback)
{
string Status = string.Empty;
var Feedback = Mapper.Map <Model.Feedback, Data.Feedback>(_Feedback);
var result = data.Put(Id, Feedback);
Status = result ? "Feedback updated successfully." : "Failed to update Feedback";
return(Status);
}
public async Task <string> InsertFeedback(Model.Feedback _Feedback)
{
string Status = string.Empty;
var Feedback = Mapper.Map <Model.Feedback, Data.Feedback>(_Feedback);
var result = data.Post(Feedback);
Status = result ? "Feedback submitted successfully." : "Failed to submit Feedback";
return(Status);
}
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 btn_KeyWSearch_Click(object sender, EventArgs e)
{
Model.Feedback feedbackC = new Model.Feedback();
BLL.FeedbackManager managerC = new FeedbackManager();
string Keyword = txbSearch.Text;
string strC = "F.Info like '%" + Keyword + "%'";
GridView1.DataSource = managerC.GetFeedbackByS(strC);
GridView1.DataBind();
Btn_All.Visible = true;
}
protected void Btn_Category_Click(object sender, EventArgs e)
{
Model.Feedback feedbackC = new Model.Feedback();
BLL.FeedbackManager managerC = new FeedbackManager();
int CID = Convert.ToInt32(DropDownList_Category.SelectedValue);
string strC = "F.categoryID='" + CID + "'";
GridView2.Visible = false;
GridView1.DataSource = managerC.GetFeedbackByS(strC);
GridView1.DataBind();
Btn_All.Visible = true;
}
public async Task <Response> Handle(Request request)
{
var entity = await _context.Feedbacks
.SingleOrDefaultAsync(x => x.Id == request.Feedback.Id && x.IsDeleted == false);
if (entity == null)
{
_context.Feedbacks.Add(entity = new Model.Feedback());
}
entity.Name = request.Feedback.Name;
await _context.SaveChangesAsync();
return(new Response()
{
});
}
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);
}
internal static Feedback ToBackendFeedback(this Model.Feedback feedback)
{
FeedbackMemento memento = feedback.GetMemento();
Feedback mapped = new Feedback()
{
Id = memento.Id,
Comment = memento.Comment,
SendingDate = memento.DateOfCreation,
IsAllowedToPublish = memento.IsAllowedToPublish,
IsPublished = memento.IsPublished
};
if (memento.Commentator != null)
{
mapped.CommentatorJmbg = memento.Commentator.Jmbg.Value;
}
return(mapped);
}
protected void Btn_Choos_Click(object sender, EventArgs e)
{
Button btn = sender as Button;
GridViewRow row = btn.Parent.Parent as GridViewRow;
string a = row.Cells[0].ToString();
string b = Convert.ToString(this.GridView1.DataKeys[row.DataItemIndex].Values[0]);//获得DataKeys的值
Labeltest.Text = b;
Model.Feedback feedback = new Model.Feedback();
BLL.FeedbackManager Fmanager = new FeedbackManager();
string Str1 = "feedbackID='" + Labeltest.Text + "'";
string s = Fmanager.GetListID(Str1);
LabelName.Text = s;
GridView2.Columns[9].Visible = true;
}
protected void btn_Dealwith_Click(object sender, EventArgs e)
{
string solution = "1";
string idList = GetSelIDList();
if (idList.Trim().Length == 0)
{
return;
}
BLL.AdminManager adminManager1 = new BLL.AdminManager();
Model.Admin admin1 = adminManager1.GetModel1(Session["SadminID"].ToString());
string name = Convert.ToString(admin1.adminName);
Model.Feedback feedback = new Model.Feedback();
BLL.FeedbackManager Fmanager = new FeedbackManager();
string Str1 = "solutionState='" + solution + "' , handler = '" + name + "'";
string Str2 = "feedbackID in(" + idList + ")";
Fmanager.UpdateSolution(Str1, Str2);
Response.Write("<script language=javascript>alert('已标记为已处理！')</script>");
BindY();
BindN();
}
public void Post(Model.Feedback feedbackModel)
{
Instance.Feedback.Add(feedbackModel);
Instance.SaveChanges();
}
public static FeedbackApiModel FromFeedback(Model.Feedback feedback) => FromFeedback <FeedbackApiModel>(feedback);
protected void Page_Load(object sender, EventArgs e)
{
Model.Feedback feedback1 = new Model.Feedback();
BLL.FeedbackManager feedback2 = new BLL.FeedbackManager();
}
