/// <summary> /// 更新一条数据 /// </summary> public void Update(RoadSolution.Model.Usertype model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Usertype set "); strSql.Append("TypeName='" + model.TypeName + "'"); strSql.Append(" where TypeID='" + model.TypeID + "'"); DbHelperSQL.ExecuteSql(strSql.ToString()); }
/// <summary> /// 增加一条数据 /// </summary> public string Add(RoadSolution.Model.Usertype model) { model.TypeID = GetMaxId().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Usertype("); strSql.Append("TypeID,TypeName"); strSql.Append(")"); strSql.Append(" values ("); strSql.Append("'" + model.TypeID + "',"); strSql.Append("'" + model.TypeName + "'"); strSql.Append(")"); DbHelperSQL.ExecuteSql(strSql.ToString()); return(model.TypeID); }
/// <summary> /// 得到一个对象实体 /// </summary> public RoadSolution.Model.Usertype GetModel(string TypeID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from Usertype "); strSql.Append(" where TypeID='" + TypeID + "'"); RoadSolution.Model.Usertype model = new RoadSolution.Model.Usertype(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); model.TypeID = TypeID; if (ds.Tables[0].Rows.Count > 0) { model.TypeName = ds.Tables[0].Rows[0]["TypeName"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(RoadSolution.Model.Usertype model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public string Add(RoadSolution.Model.Usertype model) { return(dal.Add(model)); }