protected void gvRM_RowCommand(object sender, GridViewCommandEventArgs e) { string keyid = e.CommandArgument.ToString(); if (e.CommandName == "dataDelete") { if (KPI_RemoveDal.DeleteRM(keyid)) { MessageBox.popupClientMessage(this.Page, "删除成功!", "call();"); BindRM(); } else { MessageBox.popupClientMessage(this.Page, "删除错误!", "call();"); } } else if (e.CommandName == "dataDone") { KPI_RemoveDal.RemoveOneRescord(keyid); KPI_RemoveEntity Entity = KPI_RemoveDal.GetEntity(keyid); DateTime StartDate = Convert.ToDateTime(Entity.RMStartTime); StartDate = new DateTime(StartDate.Year, StartDate.Month, 1); DateTime EndDate = Convert.ToDateTime(Entity.RMEndTime); EndDate = new DateTime(EndDate.Year, EndDate.Month, 1); EndDate = EndDate.AddMonths(1).AddSeconds(-1); KPI_RemoveDal.RecalcScoreAndBonus(StartDate, EndDate); BindRM(); MessageBox.popupClientMessage(this.Page, "事后剔除标记成功!", "call();"); } else if (e.CommandName == "dataRestore") { KPI_RemoveDal.RestoreOneRescord(keyid); KPI_RemoveEntity Entity = KPI_RemoveDal.GetEntity(keyid); DateTime StartDate = Convert.ToDateTime(Entity.RMStartTime); StartDate = new DateTime(StartDate.Year, StartDate.Month, 1); DateTime EndDate = Convert.ToDateTime(Entity.RMEndTime); EndDate = new DateTime(EndDate.Year, EndDate.Month, 1); EndDate = EndDate.AddMonths(1).AddSeconds(-1); KPI_RemoveDal.RecalcScoreAndBonus(StartDate, EndDate); BindRM(); MessageBox.popupClientMessage(this.Page, "事后剔除恢复成功!", "call();"); } }
protected void btnExcute_Click(object sender, EventArgs e) { if (gvRM.Rows.Count <= 0) { return; } // string[] rmids = new string[gvRM.Rows.Count]; for (int i = 0; i < gvRM.Rows.Count; i++) { rmids[i] = gvRM.Rows[i].Cells[1].ToString(); } KPI_RemoveDal.RemoveMultiRescord(rmids); BindRM(); MessageBox.popupClientMessage(this.Page, "事后剔除标记成功!", "call();"); }
/// <summary> /// //设备信息 /// </summary> void BindRM() { DateTime dt = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); string StartTime = ""; string EndTime = ""; if (rblRemove.SelectedValue == "0") { StartTime = dt.AddMonths(-1).ToString("yyyy-MM-dd HH:mm:00"); EndTime = dt.ToString("yyyy-MM-dd HH:mm:00"); } else if (rblRemove.SelectedValue == "1") { StartTime = dt.ToString("yyyy-MM-dd HH:mm:00"); //EndTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:00"); } //设备信息 DataTable dtTags = KPI_RemoveDal.GetRecords(StartTime, EndTime); gvRM.DataSource = dtTags; gvRM.DataBind(); }
protected void btnAdd_Click(object sender, EventArgs e) { DateTime dt = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); //判断时间 if (DateTime.Parse(txt_ST.Value) >= DateTime.Parse(txt_ET.Value) || DateTime.Parse(txt_ST.Value) < dt.AddMonths(-1) || DateTime.Parse(txt_ET.Value) > DateTime.Now) { MessageBox.popupClientMessage(this.Page, "开始时间大于结束时间 或 开始时间小于上月1号 或 结束时间大于当前时间!", "call();"); return; } if (rblRMType.SelectedValue == "0") { KPI_RemoveEntity rEntity = new KPI_RemoveEntity(); rEntity.RMID = Guid.NewGuid().ToString(); rEntity.RMType = 0; rEntity.RMKPIID = ddlRMKPIID.SelectedValue; rEntity.RMName = ddlRMKPIID.SelectedItem.Text; rEntity.RMStartTime = txt_ST.Value; rEntity.RMEndTime = txt_ET.Value; rEntity.RMIsValid = 0; rEntity.RMNote = tbxRMNote.Text.Trim(); KPI_RemoveDal.Insert(rEntity); } else if (rblRMType.SelectedValue == "1") { KPI_RemoveEntity rEntity = new KPI_RemoveEntity(); rEntity.RMID = Guid.NewGuid().ToString(); rEntity.RMType = 1; rEntity.RMKPIID = ddlRMKPIID.SelectedValue; rEntity.RMName = ddlRMKPIID.SelectedItem.Text; rEntity.RMStartTime = txt_ST.Value; rEntity.RMEndTime = txt_ET.Value; rEntity.RMIsValid = 0; rEntity.RMNote = tbxRMNote.Text.Trim(); KPI_RemoveDal.Insert(rEntity); } else if (rblRMType.SelectedValue == "2") { KPI_RemoveEntity rEntity = new KPI_RemoveEntity(); rEntity.RMID = Guid.NewGuid().ToString(); rEntity.RMType = 2; rEntity.RMKPIID = ddlRMKPIID.SelectedValue; rEntity.RMName = ddlRMKPIID.SelectedItem.Text; rEntity.RMStartTime = txt_ST.Value; rEntity.RMEndTime = txt_ET.Value; rEntity.RMIsValid = 0; rEntity.RMNote = tbxRMNote.Text.Trim(); KPI_RemoveDal.Insert(rEntity); } else if (rblRMType.SelectedValue == "3") { foreach (ListItem lt in cbxRMKPIID.Items) { if (lt.Selected) { KPI_RemoveEntity rEntity = new KPI_RemoveEntity(); rEntity.RMID = Guid.NewGuid().ToString(); rEntity.RMType = 3; rEntity.RMKPIID = lt.Value; rEntity.RMName = lt.Text; rEntity.RMStartTime = txt_ST.Value; rEntity.RMEndTime = txt_ET.Value; rEntity.RMIsValid = 0; rEntity.RMNote = tbxRMNote.Text.Trim(); KPI_RemoveDal.Insert(rEntity); } } } BindRM(); }