public void BindKeys(string WebCode) { DataTable dt = KPI_WebKeyDal.GetKeyList(WebCode); gvData.DataSource = dt; gvData.DataBind(); }
public void KPI_SubWeb_Edit(HttpContext context) { string KeyID = context.Request["KeyID"]; if (KeyID == "") { context.Response.Write("{\"status\":\"没有对象!\"}"); return; } //string WebCode = context.Request["WebCode"]; //string ECCode = context.Request["ECCode"]; //string ECName = context.Request["ECName"]; //string KeyEngunit = context.Request["KeyEngunit"]; //string KeyCalcType = context.Request["KeyCalcType"]; string KeyIndex = context.Request["KeyIndex"]; int iKeyIndex = 0; if (!int.TryParse(KeyIndex, out iKeyIndex)) { context.Response.Write("{\"status\":\"序号数字不合法!\"}"); return; } //if (KPI_WebKeyDal.KeyExists(ECCode, WebCode)) //{ // context.Response.Write("{\"status\":\"该指标已存在!\"}"); // return; //} KPI_WebKeyEntity kwk = new KPI_WebKeyEntity(); // kwk.KeyID = KeyID; //kwk.ECID = KPI_ECTagDal.GetECIDByCode(ECCode); //kwk.ECCode = ECCode; //kwk.ECName = ECName; //kwk.WebCode = WebCode; //kwk.KeyEngunit = KeyEngunit; //kwk.KeyCalcType = int.Parse(KeyCalcType); kwk.KeyIndex = iKeyIndex; kwk.KeyIsValid = 1; //kwk.KeyNote = ""; //kwk.KeyCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); kwk.KeyModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); if (KPI_WebKeyDal.Update(kwk)) { context.Response.Write("{\"status\":\"ok\"}"); } else { context.Response.Write("{\"status\":\"修改失败!\"}"); return; } }
void BindGrid() { lblInfor2.Text = "" + WebCode; gvTable = KPI_WebKeyDal.GetDisplayForSort(WebCode); gvData.DataSource = gvTable; gvData.DataBind(); }
public void KPI_SubWeb_Del(HttpContext context) { string KeyID = context.Request["KeyID"]; if (KPI_WebKeyDal.DeleteKey(KeyID)) { context.Response.Write("{\"status\":\"ok\"}"); } else { context.Response.Write("{\"status\":\"删除失败!\"}"); } }
public void KPI_SubWeb_Add(HttpContext context) { //KeyID,WebCode,ECCode,ECName,KeyEngunit,KeyCalcType,KeyIndex string KeyID = Guid.NewGuid().ToString(); string WebCode = context.Request["WebCode"]; string ECCode = context.Request["ECCode"]; string ECName = context.Request["ECName"]; string KeyEngunit = context.Request["KeyEngunit"]; string KeyCalcType = context.Request["KeyCalcType"]; string KeyIndex = context.Request["KeyIndex"]; int iKeyIndex = 0; if (!int.TryParse(KeyIndex, out iKeyIndex)) { context.Response.Write("{\"status\":\"序号数字不合法!\"}"); return; } if (KPI_WebKeyDal.KeyExists(ECCode, WebCode)) { context.Response.Write("{\"status\":\"该指标已存在!\"}"); return; } KPI_WebKeyEntity kwk = new KPI_WebKeyEntity(); // kwk.KeyID = KeyID; kwk.ECID = ECTagDal.GetECIDByCode(ECCode); kwk.ECCode = ECCode; kwk.ECName = ECName; kwk.WebCode = WebCode; kwk.KeyEngunit = KeyEngunit; kwk.KeyCalcType = int.Parse(KeyCalcType); kwk.KeyIndex = iKeyIndex; kwk.KeyIsValid = 1; kwk.KeyNote = ""; kwk.KeyCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); kwk.KeyModifyTime = kwk.KeyCreateTime; if (KPI_WebKeyDal.Insert(kwk)) { context.Response.Write("{\"status\":\"ok\"}"); } else { context.Response.Write("{\"status\":\"添加失败!\"}"); return; } }
/// <summary> /// 机组信息 /// </summary> void BindValue() { if (WebCode == "") { return; } DateTime StartTime = DateTime.Now; DateTime EndTime = DateTime.Now; //都是 日期的形式 if (!DateTime.TryParse(txt_ST.Value, out StartTime) || !DateTime.TryParse(txt_ET.Value, out EndTime) || StartTime >= EndTime) { MessageBox.popupClientMessage(this.Page, "时间格式不正确 或 时间范围不正确!"); return; } //加 1小时 StartTime = StartTime.AddHours(1); EndTime = EndTime.AddHours(1); string UnitID = ddlUnit.SelectedValue; //WebCode //得分、得分率、合格率、最大值、最小值、算数平均值、加权平均值、累计值、累计除法 string calctype = KPI_WebKeyDal.GetCalcType(WebCode); DataTable dtValue = ECSSArchiveDal.GetForShiftValue(UnitID, WebCode, calctype, StartTime, EndTime); DataTable dtGD = ConvertToTable(dtValue, calctype); //第1列为名称,必须为0; totalvalue = new double[dtGD.Columns.Count]; //初始化 for (int x = 0; x < totalvalue.Length; x++) { totalvalue[x] = 0; } gvData.DataSource = dtGD; gvData.DataBind(); }
protected void btnApply_Click(object sender, EventArgs e) { if (gvTable.Rows.Count <= 0) { return; } for (int i = 0; i < gvTable.Rows.Count; i++) { KPI_WebKeyEntity csE = new KPI_WebKeyEntity(); csE.KeyID = gvTable.Rows[i]["KeyID"].ToString(); csE.KeyIndex = (10 + i); KPI_WebKeyDal.Update(csE); } MessageBox.popupClientMessage(this.Page, "排序成功!", "call();"); }
/// <summary> /// 机组信息 /// </summary> void BindValue() { if (WebCode == "") { return; } DateTime StartTime = DateTime.Now; DateTime EndTime = DateTime.Now; //都是 日期的形式 if (!DateTime.TryParse(txt_ST.Value, out StartTime) || !DateTime.TryParse(txt_ET.Value, out EndTime) || StartTime >= EndTime) { MessageBox.popupClientMessage(this.Page, "时间格式不正确 或 时间范围不正确!"); return; } //加 1小时 StartTime = StartTime.AddHours(1); EndTime = EndTime.AddHours(1); string shiftname = ddlShift.SelectedItem.Text; if (shiftname == "全部") { shiftname = ""; } //WebCode //得分、得分率、合格率、最大值、最小值、算数平均值、加权平均值、累计值、累计除法 string calctype = KPI_WebKeyDal.GetCalcType(WebCode); DataTable dtValue = ECSSArchiveDal.GetForUnitValue(shiftname, WebCode, calctype, StartTime, EndTime); DataTable dtGD = ConvertToTable(dtValue, calctype); gvData.DataSource = dtGD; gvData.DataBind(); }