/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.dt_active_user model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_active_user set "); strSql.Append("activityId=@activityId,"); strSql.Append("UserId=@UserId,"); strSql.Append("joinDate=@joinDate"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@activityId", SqlDbType.Int, 4), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@joinDate", SqlDbType.Date, 3), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.activityId; parameters[1].Value = model.UserId; parameters[2].Value = model.joinDate; parameters[3].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.dt_active_user model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_active_user("); strSql.Append("activityId,UserId,joinDate)"); strSql.Append(" values ("); strSql.Append("@activityId,@UserId,@joinDate)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@activityId", SqlDbType.Int, 4), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@joinDate", SqlDbType.Date, 3) }; parameters[0].Value = model.activityId; parameters[1].Value = model.UserId; parameters[2].Value = model.joinDate; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.dt_active_user DataRowToModel(DataRow row) { Model.dt_active_user model = new Model.dt_active_user(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["activityId"] != null && row["activityId"].ToString() != "") { model.activityId = int.Parse(row["activityId"].ToString()); } if (row["UserId"] != null && row["UserId"].ToString() != "") { model.UserId = int.Parse(row["UserId"].ToString()); } if (row["joinDate"] != null && row["joinDate"].ToString() != "") { model.joinDate = DateTime.Parse(row["joinDate"].ToString()); } if (row["user_name"] != null && row["user_name"].ToString() != "") { model.userName = row["user_name"].ToString(); } if (row["address"] != null && row["address"].ToString() != "") { model.address = row["address"].ToString(); } } return(model); }
private void ReadCardEnd() { Model.dt_active_user ac_usr = listActive_user.Where(x => x.address == _Card).SingleOrDefault(); if (ac_usr != null) { ac_usr.joinDate = DateTime.Now; BLL.dt_active_user bll = new BLL.dt_active_user(); bll.Update(ac_usr); getData(); bind_dgv(); } _Card = string.Empty; }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.dt_active_user GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,activityId,UserId,joinDate from dt_active_user "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.dt_active_user model = new Model.dt_active_user(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }