/// <summary> /// 更新一条数据 /// </summary> public bool Update(DNSABC.Model.DNSABC_UserApi model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DNSABC_UserApi set "); strSql.Append("UserId=@UserId,"); strSql.Append("Ip=@Ip,"); strSql.Append("KEY=@KEY"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@Ip", SqlDbType.VarChar, 4000), new SqlParameter("@KEY", SqlDbType.VarChar, 4000), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.UserId; parameters[1].Value = model.Ip; parameters[2].Value = model.KEY; parameters[3].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DNSABC.Model.DNSABC_UserApi model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DNSABC_UserApi("); strSql.Append("Id,UserId,Ip,KEY)"); strSql.Append(" values ("); strSql.Append("@Id,@UserId,@Ip,@KEY)"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@Ip", SqlDbType.VarChar, 4000), new SqlParameter("@KEY", SqlDbType.VarChar, 4000) }; parameters[0].Value = model.Id; parameters[1].Value = model.UserId; parameters[2].Value = model.Ip; parameters[3].Value = model.KEY; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(int Id) { DNSABC.BLL.DNSABC_UserApi bll = new DNSABC.BLL.DNSABC_UserApi(); DNSABC.Model.DNSABC_UserApi model = bll.GetModel(Id); this.lblId.Text = model.Id.ToString(); this.lblUserId.Text = model.UserId.ToString(); this.lblIp.Text = model.Ip; this.lblKEY.Text = model.KEY; }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtId.Text)) { strErr += "编号格式错误!\\n"; } if (!PageValidate.IsNumber(txtUserId.Text)) { strErr += "关联编号格式错误!\\n"; } if (this.txtIp.Text.Trim().Length == 0) { strErr += "授权IP不能为空!\\n"; } if (this.txtKEY.Text.Trim().Length == 0) { strErr += "Key密钥不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int Id = int.Parse(this.txtId.Text); int UserId = int.Parse(this.txtUserId.Text); string Ip = this.txtIp.Text; string KEY = this.txtKEY.Text; DNSABC.Model.DNSABC_UserApi model = new DNSABC.Model.DNSABC_UserApi(); model.Id = Id; model.UserId = UserId; model.Ip = Ip; model.KEY = KEY; DNSABC.BLL.DNSABC_UserApi bll = new DNSABC.BLL.DNSABC_UserApi(); bll.Add(model); ROYcms.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public DNSABC.Model.DNSABC_UserApi GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,UserId,Ip,KEY from DNSABC_UserApi "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; DNSABC.Model.DNSABC_UserApi model = new DNSABC.Model.DNSABC_UserApi(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } if (ds.Tables[0].Rows[0]["UserId"] != null && ds.Tables[0].Rows[0]["UserId"].ToString() != "") { model.UserId = int.Parse(ds.Tables[0].Rows[0]["UserId"].ToString()); } if (ds.Tables[0].Rows[0]["Ip"] != null && ds.Tables[0].Rows[0]["Ip"].ToString() != "") { model.Ip = ds.Tables[0].Rows[0]["Ip"].ToString(); } if (ds.Tables[0].Rows[0]["KEY"] != null && ds.Tables[0].Rows[0]["KEY"].ToString() != "") { model.KEY = ds.Tables[0].Rows[0]["KEY"].ToString(); } return(model); } else { return(null); } }