/// <summary> /// 更新一条数据 /// </summary> public bool Update(ESMonitor.Model.Devs model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@DevCode", SqlDbType.VarChar, 20), new SqlParameter("@StatId", SqlDbType.VarChar, 20), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@PreEndTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@DevStatus", SqlDbType.TinyInt, 1), new SqlParameter("@VideoURL", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Id; parameters[1].Value = model.DevCode; parameters[2].Value = model.StatId; parameters[3].Value = model.StartTime; parameters[4].Value = model.PreEndTime; parameters[5].Value = model.EndTime; parameters[6].Value = model.DevStatus; parameters[7].Value = model.VideoURL; DbHelperSQL.RunProcedure("T_Devs_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ESMonitor.Model.Devs model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@DevCode", SqlDbType.VarChar, 20), new SqlParameter("@StatId", SqlDbType.VarChar, 20), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@PreEndTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@DevStatus", SqlDbType.TinyInt, 1), new SqlParameter("@VideoURL", SqlDbType.VarChar, 50) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.DevCode; parameters[2].Value = model.StatId; parameters[3].Value = model.StartTime; parameters[4].Value = model.PreEndTime; parameters[5].Value = model.EndTime; parameters[6].Value = model.DevStatus; parameters[7].Value = model.VideoURL; DbHelperSQL.RunProcedure("T_Devs_ADD", parameters, out rowsAffected); return((int)parameters[0].Value); }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtDevCode.Text.Trim().Length == 0) { strErr += "DevCode不能为空!\\n"; } if (this.txtStatCode.Text.Trim().Length == 0) { strErr += "StatCode不能为空!\\n"; } if (!PageValidate.IsDateTime(txtStartTime.Text)) { strErr += "StartTime格式错误!\\n"; } if (!PageValidate.IsDateTime(txtPreEndTime.Text)) { strErr += "PreEndTime格式错误!\\n"; } if (!PageValidate.IsDateTime(txtEndTime.Text)) { strErr += "EndTime格式错误!\\n"; } if (!PageValidate.IsNumber(txtDevStatus.Text)) { strErr += "DevStatus格式错误!\\n"; } if (this.txtVideoURL.Text.Trim().Length == 0) { strErr += "VideoURL不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string DevCode = this.txtDevCode.Text; string StatCode = this.txtStatCode.Text; DateTime StartTime = DateTime.Parse(this.txtStartTime.Text); DateTime PreEndTime = DateTime.Parse(this.txtPreEndTime.Text); DateTime EndTime = DateTime.Parse(this.txtEndTime.Text); int DevStatus = int.Parse(this.txtDevStatus.Text); string VideoURL = this.txtVideoURL.Text; ESMonitor.Model.Devs model = new ESMonitor.Model.Devs(); model.DevCode = DevCode; model.StatCode = StatCode; model.StartTime = StartTime; model.PreEndTime = PreEndTime; model.EndTime = EndTime; model.DevStatus = DevStatus; model.VideoURL = VideoURL; ESMonitor.BLL.Devs bll = new ESMonitor.BLL.Devs(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
private void ShowInfo(int Id) { ESMonitor.BLL.Devs bll = new ESMonitor.BLL.Devs(); ESMonitor.Model.Devs model = bll.GetModel(Id); this.lblId.Text = model.Id.ToString(); this.lblDevCode.Text = model.DevCode; this.lblStatCode.Text = model.StatCode; this.lblStartTime.Text = model.StartTime.ToString(); this.lblPreEndTime.Text = model.PreEndTime.ToString(); this.lblEndTime.Text = model.EndTime.ToString(); this.lblDevStatus.Text = model.DevStatus.ToString(); this.lblVideoURL.Text = model.VideoURL; }
protected void OnSubmit() { ESMonitor.Model.Devs model = new ESMonitor.Model.Devs(); string devCode = txtNo.Text.Trim(); if (!_bll.Exists(devCode)) { model.DevCode = devCode; model.StatId = int.Parse(ddlState.SelectedValue); model.StartTime = Convert.ToDateTime(txtStartTime.Text); model.PreEndTime = Convert.ToDateTime(txtPreEndTime.Text); model.EndTime = Convert.ToDateTime(txtRealEndTime.Text); model.VideoURL = txtVideoURL.Text.Trim(); if (rbtn1.Checked) { model.DevStatus = 1; } else { model.DevStatus = 0; } int devId = _bll.Add(model); if (devId > 0) { string addr = txtAddr.Text.Trim(); if ((addr.IndexOf("0x") != -1) || (addr.IndexOf("0X") != -1)) { byte[] nodeId = Utility.StringToHexByte(addr.Substring(2, addr.Length - 2)); _bll.AddAddr(devId, nodeId); } Response.Redirect("Devs.aspx"); } } else { string tip = "已录入该记录"; ClientScript.RegisterStartupScript(GetType(), "", "<script>alert(\"" + tip + "\");</script>"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ESMonitor.Model.Devs GetModel(int Id) { SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; ESMonitor.Model.Devs model = new ESMonitor.Model.Devs(); DataSet ds = DbHelperSQL.RunProcedure("T_Devs_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ESMonitor.Model.Devs DataRowToModel(DataRow row) { ESMonitor.Model.Devs model = new ESMonitor.Model.Devs(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["DevCode"] != null) { model.DevCode = row["DevCode"].ToString(); } if (row["StatId"] != null && row["StatId"].ToString() != "") { model.StatId = int.Parse(row["StatId"].ToString()); } if (row["StartTime"] != null && row["StartTime"].ToString() != "") { model.StartTime = DateTime.Parse(row["StartTime"].ToString()); } if (row["PreEndTime"] != null && row["PreEndTime"].ToString() != "") { model.PreEndTime = DateTime.Parse(row["PreEndTime"].ToString()); } if (row["EndTime"] != null && row["EndTime"].ToString() != "") { model.EndTime = DateTime.Parse(row["EndTime"].ToString()); } if (row["DevStatus"] != null && row["DevStatus"].ToString() != "") { model.DevStatus = int.Parse(row["DevStatus"].ToString()); } if (row["VideoURL"] != null) { model.VideoURL = row["VideoURL"].ToString(); } } return(model); }