/// <summary>
/// 得到一个对象实体
/// </summary>
public Models.mobile_model GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,model_name");
strSql.Append(" from tb_mobile_model");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Models.mobile_model model = new Models.mobile_model();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
///<summary>
/// 将对象转换为实体
/// </summary>
private Models.mobile_model DataRowToModel(DataRow row)
{
Models.mobile_model model = new Models.mobile_model();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["model_name"] != null && row["model_name"].ToString() != "")
{
model.model_name = row["model_name"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Models.mobile_model model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_mobile_model(model_name)");
strSql.Append(" values (@model_name)");
SqlParameter[] parameters = {
new SqlParameter("@model_name", SqlDbType.VarChar,50)};
parameters[0].Value = model.model_name;
object obj = DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); //带事务
model.id = Convert.ToInt32(obj);
return model.id;
}
public HttpResponseMessage Post([FromBody] Models.mobile_model value)
{
int addId = db.Add(value);
var response = Request.CreateResponse();
if (addId > 0)
{
response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent("添加成功！", Encoding.Unicode);
return(response);
}
else
{
response = Request.CreateResponse(HttpStatusCode.InternalServerError);
response.Content = new StringContent("未知错误", Encoding.Unicode);
return(response);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Models.mobile_model model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
trans.Commit();
}
catch
{
trans.Rollback();
return false;
}
}
}
return true;
}
public Models.mobile_model GetById(int id)
{
Models.mobile_model model = db.GetModel(id);
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Models.mobile_model model)
{
return(true);
}
