/// <summary> /// 得到一个对象实体 /// </summary> public CdHotelManage.Model.real_state DataRowToModel(DataRow row) { CdHotelManage.Model.real_state model = new CdHotelManage.Model.real_state(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["tr_number"] != null) { model.tr_number = row["tr_number"].ToString(); } if (row["tr_name"] != null) { model.tr_name = row["tr_name"].ToString(); } if (row["tr_remaker"] != null) { model.tr_remaker = row["tr_remaker"].ToString(); } if (row["back1"] != null) { model.back1 = row["back1"].ToString(); } if (row["back2"] != null) { model.back2 = row["back2"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(CdHotelManage.Model.real_state model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into real_state("); strSql.Append("tr_number,tr_name,tr_remaker,back1,back2)"); strSql.Append(" values ("); strSql.Append("@tr_number,@tr_name,@tr_remaker,@back1,@back2)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@tr_number", SqlDbType.NVarChar, 20), new SqlParameter("@tr_name", SqlDbType.NVarChar, 50), new SqlParameter("@tr_remaker", SqlDbType.NVarChar, -1), new SqlParameter("@back1", SqlDbType.NVarChar, 50), new SqlParameter("@back2", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.tr_number; parameters[1].Value = model.tr_name; parameters[2].Value = model.tr_remaker; parameters[3].Value = model.back1; parameters[4].Value = model.back2; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(CdHotelManage.Model.real_state model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update real_state set "); strSql.Append("tr_number=@tr_number,"); strSql.Append("tr_name=@tr_name,"); strSql.Append("tr_remaker=@tr_remaker,"); strSql.Append("back1=@back1,"); strSql.Append("back2=@back2"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@tr_number", SqlDbType.NVarChar, 20), new SqlParameter("@tr_name", SqlDbType.NVarChar, 50), new SqlParameter("@tr_remaker", SqlDbType.NVarChar, -1), new SqlParameter("@back1", SqlDbType.NVarChar, 50), new SqlParameter("@back2", SqlDbType.NVarChar, 50), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.tr_number; parameters[1].Value = model.tr_name; parameters[2].Value = model.tr_remaker; parameters[3].Value = model.back1; parameters[4].Value = model.back2; parameters[5].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public CdHotelManage.Model.real_state GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,tr_number,tr_name,tr_remaker,back1,back2 from real_state "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; CdHotelManage.Model.real_state model = new CdHotelManage.Model.real_state(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }