/// <summary> /// 更新一条数据 /// </summary> public bool Update(Models.UserReservation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update UserReservation set "); strSql.Append("UserName=@UserName,"); strSql.Append("RestName=@RestName,"); strSql.Append("ReserveDate=@ReserveDate,"); strSql.Append("ReserveStatus=@ReserveStatus"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 100), new SqlParameter("@RestName", SqlDbType.NVarChar, 100), new SqlParameter("@ReserveDate", SqlDbType.Date, 3), new SqlParameter("@ReserveStatus", SqlDbType.NVarChar, 10), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.UserName; parameters[1].Value = model.RestName; parameters[2].Value = model.ReserveDate; parameters[3].Value = model.ReserveStatus; parameters[4].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Models.UserReservation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into UserReservation("); strSql.Append("UserName,RestName,ReserveDate,ReserveStatus)"); strSql.Append(" values ("); strSql.Append("@UserName,@RestName,@ReserveDate,@ReserveStatus)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 100), new SqlParameter("@RestName", SqlDbType.NVarChar, 100), new SqlParameter("@ReserveDate", SqlDbType.Date, 3), new SqlParameter("@ReserveStatus", SqlDbType.NVarChar, 10) }; parameters[0].Value = model.UserName; parameters[1].Value = model.RestName; parameters[2].Value = model.ReserveDate; parameters[3].Value = model.ReserveStatus; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Models.UserReservation DataRowToModel(DataRow row) { Models.UserReservation model = new Models.UserReservation(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["RestName"] != null) { model.RestName = row["RestName"].ToString(); } if (row["ReserveDate"] != null && row["ReserveDate"].ToString() != "") { model.ReserveDate = DateTime.Parse(row["ReserveDate"].ToString()); } if (row["ReserveStatus"] != null) { model.ReserveStatus = row["ReserveStatus"].ToString(); } } return(model); }
public List <Models.UserReservation> DataTableToList(DataTable dt) { List <Models.UserReservation> modelList = new List <Models.UserReservation>(); int rowCount = dt.Rows.Count; if (rowCount > 0) { Models.UserReservation model; for (int i = 0; i < rowCount; i++) { model = new Models.UserReservation(); if (dt.Rows[i]["Id"] != null && dt.Rows[i]["Id"].ToString() != "") { model.Id = int.Parse(dt.Rows[i]["Id"].ToString()); } if (dt.Rows[i]["UserName"] != null && dt.Rows[i]["UserName"].ToString() != "") { model.UserName = dt.Rows[i]["UserName"].ToString(); } if (dt.Rows[i]["RestName"] != null && dt.Rows[i]["RestName"].ToString() != "") { model.RestName = dt.Rows[i]["RestName"].ToString(); } if (dt.Rows[i]["ReserveDate"] != null && dt.Rows[i]["ReserveDate"].ToString() != "") { model.ReserveDate = (DateTime)dt.Rows[i]["ReserveDate"]; } if (dt.Rows[i]["ReserveStatus"] != null && dt.Rows[i]["ReserveStatus"].ToString() != "") { model.ReserveStatus = dt.Rows[i]["ReserveStatus"].ToString(); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 得到一个对象实体 /// </summary> public Models.UserReservation GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,UserName,RestName,ReserveDate,ReserveStatus from UserReservation "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; Models.UserReservation model = new Models.UserReservation(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }