private void ClientInitial() { List <KPI_UnitEntity> UnitList = KPI_UnitDal.GetAllEntity(); //drpUnits.Items.Add(new ListItem("全厂", "00")); drpSUnits.Items.Add(new ListItem("【所有机组】", "")); foreach (KPI_UnitEntity Unit in UnitList) { drpSUnits.Items.Add(new ListItem(Unit.UnitName, Unit.UnitID)); drpUnits.Items.Add(new ListItem(Unit.UnitName, Unit.UnitID)); } DataTable Shifts = KPI_ShiftDal.GetShifts(); drpSShifts.Items.Add(new ListItem("【所有值次】", "")); foreach (DataRow dr in Shifts.Rows) { drpShifts.Items.Add(new ListItem(dr["Name"] + "值", dr["Name"] + "")); drpSShifts.Items.Add(new ListItem(dr["Name"] + "值", dr["Name"] + "")); } Shifts.Dispose(); DataTable PositionTable = KPI_PositionDal.GetDataTable(); foreach (DataRow dr in PositionTable.Rows) { drpPositions.Items.Add(new ListItem(dr["PositionName"] + "", dr["PositionID"] + "")); } PositionTable.Dispose(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //指标信息 if (Request.QueryString["webcode"] != null) { WebCode = Request.QueryString["webcode"].ToString(); lblInfor.Text = "报表名称: " + KPI_WebDal.GetWebDesc(WebCode); } else { WebCode = ""; } ////机组信息 DataTable dt = KPI_ShiftDal.GetShifts(); ddlShift.Items.Add(new ListItem("全部", "ALL")); foreach (DataRow dr in dt.Rows) { ddlShift.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString())); } // txt_ST.Value = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd"); txt_ET.Value = DateTime.Now.ToString("yyyy-MM-dd"); BindValue(); } }
void BindShift() { //值信息 DataTable dtShift = KPI_ShiftDal.GetSearchList(""); gvShift.DataSource = dtShift; gvShift.DataBind(); }
protected bool ImportFromExcelToCreate(DataSet ds) { try { System.Data.DataTable dt = ds.Tables[0]; int nAll = dt.Rows.Count; int nCreate = 0; int nExist = 0; foreach (System.Data.DataRow dr in dt.Rows) { if (dr["SelectX"].ToString().ToLower() == "x") { //string PersonCode = dr["PersonCode"].ToString().Trim(); ////判断是否存在 //if (KPI_PersonDal.PersonCodeExists(PersonCode, "")) //{ // //MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在!", "call();"); // nExist += 1; // continue; //} //main tag string keyid = PageControl.GetGuid(); KPI_TeamEntity mEntity = new KPI_TeamEntity(); mEntity.TeamID = keyid; mEntity.PlantID = KPI_PlantDal.GetPlantID(dr["PlantName"].ToString().Trim()); mEntity.ShiftID = KPI_ShiftDal.GetShiftID(dr["ShiftName"].ToString().Trim()); mEntity.PersonID = KPI_PersonDal.GetPersonID(dr["PersonCode"].ToString().Trim()); mEntity.PositionID = KPI_PersonDal.GetPositionID(mEntity.PersonID); //PersonName,无多大意义 mEntity.PositionID = KPI_PositionDal.GetPositionID(dr["PositionName"].ToString().Trim()); mEntity.TeamNote = dr["TeamNote"].ToString().Trim(); KPI_TeamDal.Insert(mEntity); nCreate += 1; } } string strInfor = "标签点总数为:{0}个, 创建成功:{1}个,已存在标签点: {2}个。"; strInfor = string.Format(strInfor, nAll, nCreate, nExist); MessageBox.popupClientMessage(this.Page, strInfor, "call();"); return(true); } catch (Exception ee) { // MessageBox.popupClientMessage(this.Page, ee.Message, "call();"); return(false); } }
protected void gvShift_RowUpdating(object sender, GridViewUpdateEventArgs e) { string sID = ((HtmlInputHidden)(gvShift.Rows[e.RowIndex].Cells[0].FindControl("shiftid"))).Value.ToString().Trim(); string sName = ((TextBox)(gvShift.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim(); string sDesc = ((TextBox)(gvShift.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim(); string sValid = ((DropDownList)(gvShift.Rows[e.RowIndex].Cells[4].FindControl("ddlValid"))).SelectedValue; string sNote = ((TextBox)(gvShift.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim(); if (sName == "") { MessageBox.popupClientMessage(this.Page, "名称不能为空!", "call();"); return; } //名称是否重复 if (KPI_ShiftDal.ShiftNameExists(sName, sID)) { MessageBox.popupClientMessage(this.Page, "已存在相同的名称!"); return; } //更新 KPI_ShiftEntity ote = new KPI_ShiftEntity(); ote.ShiftID = sID; // ote.ShiftName = sName; ote.ShiftDesc = sDesc; ote.ShiftIsValid = sValid; ote.ShiftNote = sNote; ote.ShiftModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); if (KPI_ShiftDal.Update(ote)) { MessageBox.popupClientMessage(this.Page, "编辑成功!", "call();"); } else { MessageBox.popupClientMessage(this.Page, "编辑错误!", "call();"); } gvShift.EditIndex = -1; BindShift(); }
protected void gvShift_RowCommand(object sender, GridViewCommandEventArgs e) { string keyid = e.CommandArgument.ToString(); if (e.CommandName == "dataDelete") { if (KPI_ShiftDal.DeleteShift(keyid)) { MessageBox.popupClientMessage(this.Page, "删除成功!", "call();"); BindShift(); } else { MessageBox.popupClientMessage(this.Page, "删除错误!", "call();"); } } }
protected void btnAddShift_Click(object sender, EventArgs e) { ////添加新电厂信息 //string strjs = "<script language=javascript>window.open('KPI_SubRunShift.aspx','newwindow','width=500,height=400')</script>"; //ClientScript.RegisterStartupScript(this.GetType(), "", strjs); int index = KPI_ShiftDal.ShiftIDCounts(); string sID = PageControl.GetGuid(); KPI_ShiftEntity ote = new KPI_ShiftEntity(); ote.ShiftID = sID; ote.ShiftCode = KPI_ShiftDal.GetNextCode(); ote.ShiftName = "InputName"; ote.ShiftDesc = ""; ote.ShiftIsValid = "1"; ote.ShiftNote = ""; ote.ShiftCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); ote.ShiftModifyTime = ote.ShiftCreateTime; if (KPI_ShiftDal.Insert(ote)) { //MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); gvShift.EditIndex = index; BindShift(); } else { MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); } }