/// <summary> /// 增加一条数据 /// </summary> public bool Add(WebDemo.Model.WebDemo.Hosts model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Hosts("); strSql.Append("CollectorID,HostID,HostName,HostAddr,Remark,flag,LimitNum,HostComType,HostType,HostRDate,DownloadFlag,PowerType,HostNo,HostLimitNum,IsRelay,IsDownMeterType)"); strSql.Append(" values ("); strSql.Append("@CollectorID,@HostID,@HostName,@HostAddr,@Remark,@flag,@LimitNum,@HostComType,@HostType,@HostRDate,@DownloadFlag,@PowerType,@HostNo,@HostLimitNum,@IsRelay,@IsDownMeterType)"); SqlParameter[] parameters = { new SqlParameter("@CollectorID", SqlDbType.Int, 4), new SqlParameter("@HostID", SqlDbType.Int, 4), new SqlParameter("@HostName", SqlDbType.VarChar, 50), new SqlParameter("@HostAddr", SqlDbType.VarChar, 50), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@flag", SqlDbType.Int, 4), new SqlParameter("@LimitNum", SqlDbType.Int, 4), new SqlParameter("@HostComType", SqlDbType.Int, 4), new SqlParameter("@HostType", SqlDbType.Int, 4), new SqlParameter("@HostRDate", SqlDbType.VarChar, 10), new SqlParameter("@DownloadFlag", SqlDbType.Int, 4), new SqlParameter("@PowerType", SqlDbType.Int, 4), new SqlParameter("@HostNo", SqlDbType.Int, 4), new SqlParameter("@HostLimitNum", SqlDbType.Int, 4), new SqlParameter("@IsRelay", SqlDbType.Int, 4), new SqlParameter("@IsDownMeterType", SqlDbType.Int, 4) }; parameters[0].Value = model.CollectorID; parameters[1].Value = model.HostID; parameters[2].Value = model.HostName; parameters[3].Value = model.HostAddr; parameters[4].Value = model.Remark; parameters[5].Value = model.flag; parameters[6].Value = model.LimitNum; parameters[7].Value = model.HostComType; parameters[8].Value = model.HostType; parameters[9].Value = model.HostRDate; parameters[10].Value = model.DownloadFlag; parameters[11].Value = model.PowerType; parameters[12].Value = model.HostNo; parameters[13].Value = model.HostLimitNum; parameters[14].Value = model.IsRelay; parameters[15].Value = model.IsDownMeterType; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(int HostID) { WebDemo.BLL.WebDemo.Hosts bll = new WebDemo.BLL.WebDemo.Hosts(); WebDemo.Model.WebDemo.Hosts model = bll.GetModel(HostID); this.lblCollectorID.Text = model.CollectorID.ToString(); this.lblHostID.Text = model.HostID.ToString(); this.lblHostName.Text = model.HostName; this.lblHostAddr.Text = model.HostAddr; this.lblRemark.Text = model.Remark; this.lblflag.Text = model.flag.ToString(); this.lblLimitNum.Text = model.LimitNum.ToString(); this.lblHostComType.Text = model.HostComType.ToString(); this.lblHostType.Text = model.HostType.ToString(); this.lblHostRDate.Text = model.HostRDate; this.lblDownloadFlag.Text = model.DownloadFlag.ToString(); this.lblPowerType.Text = model.PowerType.ToString(); this.lblHostNo.Text = model.HostNo.ToString(); this.lblHostLimitNum.Text = model.HostLimitNum.ToString(); this.lblIsRelay.Text = model.IsRelay.ToString(); this.lblIsDownMeterType.Text = model.IsDownMeterType.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.Hosts GetModel(int HostID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 CollectorID,HostID,HostName,HostAddr,Remark,flag,LimitNum,HostComType,HostType,HostRDate,DownloadFlag,PowerType,HostNo,HostLimitNum,IsRelay,IsDownMeterType from Hosts "); strSql.Append(" where HostID=@HostID "); SqlParameter[] parameters = { new SqlParameter("@HostID", SqlDbType.Int, 4) }; parameters[0].Value = HostID; WebDemo.Model.WebDemo.Hosts model = new WebDemo.Model.WebDemo.Hosts(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtCollectorID.Text)) { strErr += "集中器编号格式错误!\\n"; } if (!PageValidate.IsNumber(txtHostID.Text)) { strErr += "楼宇主机编号格式错误!\\n"; } if (this.txtHostName.Text.Trim().Length == 0) { strErr += "楼宇主机名称不能为空!\\n"; } if (this.txtHostAddr.Text.Trim().Length == 0) { strErr += "地址不能为空!\\n"; } if (this.txtRemark.Text.Trim().Length == 0) { strErr += "备注信息不能为空!\\n"; } if (!PageValidate.IsNumber(txtflag.Text)) { strErr += "flag格式错误!\\n"; } if (!PageValidate.IsNumber(txtLimitNum.Text)) { strErr += "LimitNum格式错误!\\n"; } if (!PageValidate.IsNumber(txtHostComType.Text)) { strErr += "HostComType格式错误!\\n"; } if (!PageValidate.IsNumber(txtHostType.Text)) { strErr += "HostType格式错误!\\n"; } if (this.txtHostRDate.Text.Trim().Length == 0) { strErr += "HostRDate不能为空!\\n"; } if (!PageValidate.IsNumber(txtDownloadFlag.Text)) { strErr += "DownloadFlag格式错误!\\n"; } if (!PageValidate.IsNumber(txtPowerType.Text)) { strErr += "PowerType格式错误!\\n"; } if (!PageValidate.IsNumber(txtHostNo.Text)) { strErr += "HostNo格式错误!\\n"; } if (!PageValidate.IsNumber(txtHostLimitNum.Text)) { strErr += "HostLimitNum格式错误!\\n"; } if (!PageValidate.IsNumber(txtIsRelay.Text)) { strErr += "IsRelay格式错误!\\n"; } if (!PageValidate.IsNumber(txtIsDownMeterType.Text)) { strErr += "IsDownMeterType格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int CollectorID = int.Parse(this.txtCollectorID.Text); int HostID = int.Parse(this.txtHostID.Text); string HostName = this.txtHostName.Text; string HostAddr = this.txtHostAddr.Text; string Remark = this.txtRemark.Text; int flag = int.Parse(this.txtflag.Text); int LimitNum = int.Parse(this.txtLimitNum.Text); int HostComType = int.Parse(this.txtHostComType.Text); int HostType = int.Parse(this.txtHostType.Text); string HostRDate = this.txtHostRDate.Text; int DownloadFlag = int.Parse(this.txtDownloadFlag.Text); int PowerType = int.Parse(this.txtPowerType.Text); int HostNo = int.Parse(this.txtHostNo.Text); int HostLimitNum = int.Parse(this.txtHostLimitNum.Text); int IsRelay = int.Parse(this.txtIsRelay.Text); int IsDownMeterType = int.Parse(this.txtIsDownMeterType.Text); WebDemo.Model.WebDemo.Hosts model = new WebDemo.Model.WebDemo.Hosts(); model.CollectorID = CollectorID; model.HostID = HostID; model.HostName = HostName; model.HostAddr = HostAddr; model.Remark = Remark; model.flag = flag; model.LimitNum = LimitNum; model.HostComType = HostComType; model.HostType = HostType; model.HostRDate = HostRDate; model.DownloadFlag = DownloadFlag; model.PowerType = PowerType; model.HostNo = HostNo; model.HostLimitNum = HostLimitNum; model.IsRelay = IsRelay; model.IsDownMeterType = IsDownMeterType; WebDemo.BLL.WebDemo.Hosts bll = new WebDemo.BLL.WebDemo.Hosts(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.Hosts DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.Hosts model = new WebDemo.Model.WebDemo.Hosts(); if (row != null) { if (row["CollectorID"] != null && row["CollectorID"].ToString() != "") { model.CollectorID = int.Parse(row["CollectorID"].ToString()); } if (row["HostID"] != null && row["HostID"].ToString() != "") { model.HostID = int.Parse(row["HostID"].ToString()); } if (row["HostName"] != null) { model.HostName = row["HostName"].ToString(); } if (row["HostAddr"] != null) { model.HostAddr = row["HostAddr"].ToString(); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } if (row["flag"] != null && row["flag"].ToString() != "") { model.flag = int.Parse(row["flag"].ToString()); } if (row["LimitNum"] != null && row["LimitNum"].ToString() != "") { model.LimitNum = int.Parse(row["LimitNum"].ToString()); } if (row["HostComType"] != null && row["HostComType"].ToString() != "") { model.HostComType = int.Parse(row["HostComType"].ToString()); } if (row["HostType"] != null && row["HostType"].ToString() != "") { model.HostType = int.Parse(row["HostType"].ToString()); } if (row["HostRDate"] != null) { model.HostRDate = row["HostRDate"].ToString(); } if (row["DownloadFlag"] != null && row["DownloadFlag"].ToString() != "") { model.DownloadFlag = int.Parse(row["DownloadFlag"].ToString()); } if (row["PowerType"] != null && row["PowerType"].ToString() != "") { model.PowerType = int.Parse(row["PowerType"].ToString()); } if (row["HostNo"] != null && row["HostNo"].ToString() != "") { model.HostNo = int.Parse(row["HostNo"].ToString()); } if (row["HostLimitNum"] != null && row["HostLimitNum"].ToString() != "") { model.HostLimitNum = int.Parse(row["HostLimitNum"].ToString()); } if (row["IsRelay"] != null && row["IsRelay"].ToString() != "") { model.IsRelay = int.Parse(row["IsRelay"].ToString()); } if (row["IsDownMeterType"] != null && row["IsDownMeterType"].ToString() != "") { model.IsDownMeterType = int.Parse(row["IsDownMeterType"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.Hosts model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Hosts set "); strSql.Append("CollectorID=@CollectorID,"); strSql.Append("HostName=@HostName,"); strSql.Append("HostAddr=@HostAddr,"); strSql.Append("Remark=@Remark,"); strSql.Append("flag=@flag,"); strSql.Append("LimitNum=@LimitNum,"); strSql.Append("HostComType=@HostComType,"); strSql.Append("HostType=@HostType,"); strSql.Append("HostRDate=@HostRDate,"); strSql.Append("DownloadFlag=@DownloadFlag,"); strSql.Append("PowerType=@PowerType,"); strSql.Append("HostNo=@HostNo,"); strSql.Append("HostLimitNum=@HostLimitNum,"); strSql.Append("IsRelay=@IsRelay,"); strSql.Append("IsDownMeterType=@IsDownMeterType"); strSql.Append(" where HostID=@HostID "); SqlParameter[] parameters = { new SqlParameter("@CollectorID", SqlDbType.Int, 4), new SqlParameter("@HostName", SqlDbType.VarChar, 50), new SqlParameter("@HostAddr", SqlDbType.VarChar, 50), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@flag", SqlDbType.Int, 4), new SqlParameter("@LimitNum", SqlDbType.Int, 4), new SqlParameter("@HostComType", SqlDbType.Int, 4), new SqlParameter("@HostType", SqlDbType.Int, 4), new SqlParameter("@HostRDate", SqlDbType.VarChar, 10), new SqlParameter("@DownloadFlag", SqlDbType.Int, 4), new SqlParameter("@PowerType", SqlDbType.Int, 4), new SqlParameter("@HostNo", SqlDbType.Int, 4), new SqlParameter("@HostLimitNum", SqlDbType.Int, 4), new SqlParameter("@IsRelay", SqlDbType.Int, 4), new SqlParameter("@IsDownMeterType", SqlDbType.Int, 4), new SqlParameter("@HostID", SqlDbType.Int, 4) }; parameters[0].Value = model.CollectorID; parameters[1].Value = model.HostName; parameters[2].Value = model.HostAddr; parameters[3].Value = model.Remark; parameters[4].Value = model.flag; parameters[5].Value = model.LimitNum; parameters[6].Value = model.HostComType; parameters[7].Value = model.HostType; parameters[8].Value = model.HostRDate; parameters[9].Value = model.DownloadFlag; parameters[10].Value = model.PowerType; parameters[11].Value = model.HostNo; parameters[12].Value = model.HostLimitNum; parameters[13].Value = model.IsRelay; parameters[14].Value = model.IsDownMeterType; parameters[15].Value = model.HostID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }