/// <summary> /// 增加一条数据 /// </summary> public static bool Add(Model.H_Service model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into H_Service("); strSql.Append("username,name,telephone,TeamViewerID,zhifubao,bank,bankname,banknumber)"); strSql.Append(" values ("); strSql.Append("@username,@name,@telephone,@TeamViewerID,@zhifubao,@bank,@bankname,@banknumber)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@username", SqlDbType.NVarChar, 50), new SqlParameter("@name", SqlDbType.NVarChar, 50), new SqlParameter("@telephone", SqlDbType.NVarChar, 50), new SqlParameter("@TeamViewerID", SqlDbType.NVarChar, 50), new SqlParameter("@zhifubao", SqlDbType.NVarChar, 50), new SqlParameter("@bank", SqlDbType.NVarChar, 50), new SqlParameter("@bankname", SqlDbType.NVarChar, 50), new SqlParameter("@banknumber", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.username; parameters[1].Value = model.name; parameters[2].Value = model.telephone; parameters[3].Value = model.TeamViewerID; parameters[4].Value = model.zhifubao; parameters[5].Value = model.bank; parameters[6].Value = model.bankname; parameters[7].Value = model.banknumber; return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters) > 0); }
public void InitData() { if (Request.QueryString["pid"] != null) { string pid = Request.QueryString["pid"].ToString(); Model.H_Service service = H_ServiceClass.GetModel(pid); this.TextName.Value = service.name; this.TextTeamViewerID.Value = service.TeamViewerID; this.TextTel.Value = service.telephone; this.TextZhifubao.Value = service.zhifubao; this.TextBank.Value = service.bank; this.TextBank_name.Value = service.bankname; this.TextBank_number.Value = service.banknumber; } }
protected void Button1_Click(object sender, EventArgs e) { Model.H_Service service = new Model.H_Service(); service.name = this.TextName.Value.Trim(); service.TeamViewerID = this.TextTeamViewerID.Value.Trim(); service.telephone = this.TextTel.Value.Trim(); service.zhifubao = this.TextZhifubao.Value.Trim(); service.bank = this.TextBank.Value.Trim(); service.bankname = this.TextBank_name.Value.Trim(); service.banknumber = this.TextBank_number.Value.Trim(); service.id = int.Parse(Request.QueryString["pid"]); if (H_ServiceClass.Update(service)) { //JScript.Alert("操作成功", "a2", this); JScript.AlertAndRedirect("操作成功!", "ServiceList.aspx", this); } else { JScript.Alert("操作失败", "a2", this); } }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(Model.H_Service model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update H_Service set "); strSql.Append("username=@username,"); strSql.Append("name=@name,"); strSql.Append("telephone=@telephone,"); strSql.Append("TeamViewerID=@TeamViewerID,"); strSql.Append("zhifubao=@zhifubao,"); strSql.Append("bank=@bank,"); strSql.Append("bankname=@bankname,"); strSql.Append("banknumber=@banknumber"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@username", SqlDbType.NVarChar, 50), new SqlParameter("@name", SqlDbType.NVarChar, 50), new SqlParameter("@telephone", SqlDbType.NVarChar, 50), new SqlParameter("@TeamViewerID", SqlDbType.NVarChar, 50), new SqlParameter("@zhifubao", SqlDbType.NVarChar, 50), new SqlParameter("@bank", SqlDbType.NVarChar, 50), new SqlParameter("@bankname", SqlDbType.NVarChar, 50), new SqlParameter("@banknumber", SqlDbType.NVarChar, 50), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.username; parameters[1].Value = model.name; parameters[2].Value = model.telephone; parameters[3].Value = model.TeamViewerID; parameters[4].Value = model.zhifubao; parameters[5].Value = model.bank; parameters[6].Value = model.bankname; parameters[7].Value = model.banknumber; parameters[8].Value = model.id; return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters) > 0); }
protected void Button1_Click(object sender, EventArgs e) { Model.H_Service service = new Model.H_Service(); string strSql = "update H_User set isoccupy=1 where id=" + userid + ""; int count = DbHelperSQL.ExecuteSql(strSql); service.username = username; service.name = this.TextName.Value.Trim(); service.TeamViewerID = this.TextTeamViewerID.Value.Trim(); service.telephone = this.TextTel.Value.Trim(); service.zhifubao = this.TextZhifubao.Value.Trim(); service.bank = this.TextBank.Value.Trim(); service.bankname = this.TextBank_name.Value.Trim(); service.banknumber = this.TextBank_number.Value.Trim(); if (H_ServiceClass.Add(service) && count > 0) { JScript.Alert("操作成功!", "a2", this); } else { JScript.Alert("操作失败!", "a2", this); } }
/// <summary> /// 得到一个对象实体 /// </summary> public static Model.H_Service GetModel(string id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,username,name,telephone,TeamViewerID,zhifubao,bank,bankname,banknumber from H_Service "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.H_Service model = new Model.H_Service(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } model.username = ds.Tables[0].Rows[0]["username"].ToString(); model.name = ds.Tables[0].Rows[0]["name"].ToString(); model.telephone = ds.Tables[0].Rows[0]["telephone"].ToString(); model.TeamViewerID = ds.Tables[0].Rows[0]["TeamViewerID"].ToString(); model.zhifubao = ds.Tables[0].Rows[0]["zhifubao"].ToString(); model.bank = ds.Tables[0].Rows[0]["bank"].ToString(); model.bankname = ds.Tables[0].Rows[0]["bankname"].ToString(); model.banknumber = ds.Tables[0].Rows[0]["banknumber"].ToString(); return(model); } else { return(null); } }