/// <summary> /// 更新一条数据 /// </summary> public bool Update(KryptonAccessController.AccessDataBase.Model.TimeAccess model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TimeAccess set "); strSql.Append("UserGroupID=@UserGroupID,"); strSql.Append("Mon=@Mon,"); strSql.Append("Tue=@Tue,"); strSql.Append("Wed=@Wed,"); strSql.Append("Thu=@Thu,"); strSql.Append("Fri=@Fri,"); strSql.Append("Sat=@Sat,"); strSql.Append("Sun=@Sun"); strSql.Append(" where TimeAccessID=@TimeAccessID "); SqlParameter[] parameters = { new SqlParameter("@UserGroupID", SqlDbType.Int, 4), new SqlParameter("@Mon", SqlDbType.Int, 4), new SqlParameter("@Tue", SqlDbType.Int, 4), new SqlParameter("@Wed", SqlDbType.Int, 4), new SqlParameter("@Thu", SqlDbType.Int, 4), new SqlParameter("@Fri", SqlDbType.Int, 4), new SqlParameter("@Sat", SqlDbType.Int, 4), new SqlParameter("@Sun", SqlDbType.Int, 4), new SqlParameter("@TimeAccessID", SqlDbType.Int, 4) }; parameters[0].Value = model.UserGroupID; parameters[1].Value = model.Mon; parameters[2].Value = model.Tue; parameters[3].Value = model.Wed; parameters[4].Value = model.Thu; parameters[5].Value = model.Fri; parameters[6].Value = model.Sat; parameters[7].Value = model.Sun; parameters[8].Value = model.TimeAccessID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.AccessDataBase.Model.TimeAccess DataRowToModel(DataRow row) { KryptonAccessController.AccessDataBase.Model.TimeAccess model = new KryptonAccessController.AccessDataBase.Model.TimeAccess(); if (row != null) { if (row["TimeAccessID"] != null && row["TimeAccessID"].ToString() != "") { model.TimeAccessID = int.Parse(row["TimeAccessID"].ToString()); } if (row["UserGroupID"] != null && row["UserGroupID"].ToString() != "") { model.UserGroupID = int.Parse(row["UserGroupID"].ToString()); } if (row["Mon"] != null && row["Mon"].ToString() != "") { model.Mon = int.Parse(row["Mon"].ToString()); } if (row["Tue"] != null && row["Tue"].ToString() != "") { model.Tue = int.Parse(row["Tue"].ToString()); } if (row["Wed"] != null && row["Wed"].ToString() != "") { model.Wed = int.Parse(row["Wed"].ToString()); } if (row["Thu"] != null && row["Thu"].ToString() != "") { model.Thu = int.Parse(row["Thu"].ToString()); } if (row["Fri"] != null && row["Fri"].ToString() != "") { model.Fri = int.Parse(row["Fri"].ToString()); } if (row["Sat"] != null && row["Sat"].ToString() != "") { model.Sat = int.Parse(row["Sat"].ToString()); } if (row["Sun"] != null && row["Sun"].ToString() != "") { model.Sun = int.Parse(row["Sun"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KryptonAccessController.AccessDataBase.Model.TimeAccess model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TimeAccess("); strSql.Append("TimeAccessID,UserGroupID,Mon,Tue,Wed,Thu,Fri,Sat,Sun)"); strSql.Append(" values ("); strSql.Append("@TimeAccessID,@UserGroupID,@Mon,@Tue,@Wed,@Thu,@Fri,@Sat,@Sun)"); SqlParameter[] parameters = { new SqlParameter("@TimeAccessID", SqlDbType.Int, 4), new SqlParameter("@UserGroupID", SqlDbType.Int, 4), new SqlParameter("@Mon", SqlDbType.Int, 4), new SqlParameter("@Tue", SqlDbType.Int, 4), new SqlParameter("@Wed", SqlDbType.Int, 4), new SqlParameter("@Thu", SqlDbType.Int, 4), new SqlParameter("@Fri", SqlDbType.Int, 4), new SqlParameter("@Sat", SqlDbType.Int, 4), new SqlParameter("@Sun", SqlDbType.Int, 4) }; parameters[0].Value = model.TimeAccessID; parameters[1].Value = model.UserGroupID; parameters[2].Value = model.Mon; parameters[3].Value = model.Tue; parameters[4].Value = model.Wed; parameters[5].Value = model.Thu; parameters[6].Value = model.Fri; parameters[7].Value = model.Sat; parameters[8].Value = model.Sun; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.AccessDataBase.Model.TimeAccess GetModel(int TimeAccessID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 TimeAccessID,UserGroupID,Mon,Tue,Wed,Thu,Fri,Sat,Sun from TimeAccess "); strSql.Append(" where TimeAccessID=@TimeAccessID "); SqlParameter[] parameters = { new SqlParameter("@TimeAccessID", SqlDbType.Int, 4) }; parameters[0].Value = TimeAccessID; KryptonAccessController.AccessDataBase.Model.TimeAccess model = new KryptonAccessController.AccessDataBase.Model.TimeAccess(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }