/// <summary> /// 更新一条数据 /// </summary> public void Update(Mxm.Model.download model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update download set "); strSql.Append("name=@name,"); strSql.Append("remark=@remark,"); strSql.Append("picture=@picture,"); strSql.Append("path=@path,"); strSql.Append("sort=@sort,"); strSql.Append("create_time=@create_time"); strSql.Append(" where down_id=@down_id "); SqlParameter[] parameters = { new SqlParameter("@down_id", SqlDbType.Int, 4), new SqlParameter("@name", SqlDbType.NVarChar, 100), new SqlParameter("@remark", SqlDbType.NVarChar, 500), new SqlParameter("@picture", SqlDbType.NVarChar, 250), new SqlParameter("@path", SqlDbType.NVarChar, 250), new SqlParameter("@sort", SqlDbType.Int, 4), new SqlParameter("@create_time", SqlDbType.DateTime) }; parameters[0].Value = model.down_id; parameters[1].Value = model.name; parameters[2].Value = model.remark; parameters[3].Value = model.picture; parameters[4].Value = model.path; parameters[5].Value = model.sort; parameters[6].Value = model.create_time; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public Mxm.Model.download GetModel(int down_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select down_id,name,remark,picture,path,sort,create_time from download "); strSql.Append(" where down_id=@down_id "); SqlParameter[] parameters = { new SqlParameter("@down_id", SqlDbType.Int, 4) }; parameters[0].Value = down_id; Mxm.Model.download model = new Mxm.Model.download(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["down_id"].ToString() != "") { model.down_id = int.Parse(ds.Tables[0].Rows[0]["down_id"].ToString()); } model.name = ds.Tables[0].Rows[0]["name"].ToString(); model.remark = ds.Tables[0].Rows[0]["remark"].ToString(); model.picture = ds.Tables[0].Rows[0]["picture"].ToString(); model.path = ds.Tables[0].Rows[0]["path"].ToString(); if (ds.Tables[0].Rows[0]["sort"].ToString() != "") { model.sort = int.Parse(ds.Tables[0].Rows[0]["sort"].ToString()); } if (ds.Tables[0].Rows[0]["create_time"].ToString() != "") { model.create_time = DateTime.Parse(ds.Tables[0].Rows[0]["create_time"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Mxm.Model.download model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into download("); strSql.Append("name,remark,picture,path,sort,create_time)"); strSql.Append(" values ("); strSql.Append("@name,@remark,@picture,@path,@sort,@create_time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NVarChar, 100), new SqlParameter("@remark", SqlDbType.NVarChar, 500), new SqlParameter("@picture", SqlDbType.NVarChar, 250), new SqlParameter("@path", SqlDbType.NVarChar, 250), new SqlParameter("@sort", SqlDbType.Int, 4), new SqlParameter("@create_time", SqlDbType.DateTime) }; parameters[0].Value = model.name; parameters[1].Value = model.remark; parameters[2].Value = model.picture; parameters[3].Value = model.path; parameters[4].Value = model.sort; parameters[5].Value = model.create_time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(-1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mxm.Model.download GetModel(int down_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select down_id,name,remark,picture,path,sort,create_time from download "); strSql.Append(" where down_id=@down_id "); SqlParameter[] parameters = { new SqlParameter("@down_id", SqlDbType.Int,4)}; parameters[0].Value = down_id; Mxm.Model.download model = new Mxm.Model.download(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["down_id"].ToString() != "") { model.down_id = int.Parse(ds.Tables[0].Rows[0]["down_id"].ToString()); } model.name = ds.Tables[0].Rows[0]["name"].ToString(); model.remark = ds.Tables[0].Rows[0]["remark"].ToString(); model.picture = ds.Tables[0].Rows[0]["picture"].ToString(); model.path = ds.Tables[0].Rows[0]["path"].ToString(); if (ds.Tables[0].Rows[0]["sort"].ToString() != "") { model.sort = int.Parse(ds.Tables[0].Rows[0]["sort"].ToString()); } if (ds.Tables[0].Rows[0]["create_time"].ToString() != "") { model.create_time = DateTime.Parse(ds.Tables[0].Rows[0]["create_time"].ToString()); } return model; } else { return null; } }